How to Change Order of Affiliate Links and Banners?

[markluchauer]

Is there any way to organize the ad banners/links so that they appear in a specific order for the user?

As of now, when I create a new ad banner/link it shows up at the top of the list when the user looks at the Ads page.

Even though I am creating new ad banners, I would like my most popular ad banners to remain at the top of the list when the user views the ad banners rather than the most recent ad banners that were created.

Thank you for your help with this.

[markluchauer]

I just realized that it sorts the banners alphabetically. I am still wondering if there is a way to sort these by “most used” or “most popular” or sort by ID #.

I guess I could just put the number 1, 2, 3 etc. in the title of the banner.

[amin007]

Numbering the banners is an easy way to control the sort order. You can also change the code to sort it by ID.

[btm]

I am trying to do the same thing with creatives. Can someone tell me how to either renumber the creatives or change the code to sort by ID number? Right now they are showing with the highest number first. I would like to reverse this.

Thank you.

[amin007]

Open the “banners_menu.php” file from the affiliate plugin and search for the following line of code:

$wp_banners_db = $wpdb->get_results("SELECT * FROM $banners_table_name ORDER BY number DESC", OBJECT);

Once you find it change it with the following and that should do it:

$wp_banners_db = $wpdb->get_results("SELECT * FROM $banners_table_name ORDER BY number ASC", OBJECT);

There will be two occurrences of that.

[btm]

Thank you. Since I posted that I ended up adding some creatives which are now out of order.

Is there a way to dictate the specific order that they appear or to change the number assigned to a creative?

Thanks

[Author]

Posts