Most Viewed Ads

[Jesse]

Hi Freeadz: Looks great! I wasn't really sure how people would want to visually display the popular ads, so I just used the same format as "latest items". But I really like the simplicity of your list. Good job!


Everyone is certainly encouraged to do the layout however they'd like. My examples are crude and only meant to provide some ideas.  The plugin is simply a utility to provide easy-access to the data. The rest is up to the user. 

[freeeadz]

Thanks Jesse for your appreciation for my first ever code (Updation) on the OSClass Forum

Pls I need help on this also.

http://forums.osclass.org/themes/some-changes-in-bcute-theme/

[przemo]

Welcome!
The Annex gives main.php my code from the template of "modern". Please insert this plugin to me: (. I installed it already in the admin panel. My site: www.jasielskie.org.pl (please insert where it is written in Polish, "the most popular ads."

[welshboy84]

Where do I add the code to add this into my side bar please? I'm also using the Bcute template

[Jesse]

welshboy84,

Where you add the code completely depends on where you want this feature to appear. Do you want it to be displayed like the current "Latest Ads" are displayed? Or do you just want a list of "most viewed ads" in the sidebar? The answer to those questions will tell you exactly where to place the code. And exactly what code you'll need to use will again depend on how you want this to be displayed.

EDIT: I just re-read and noticed you said you wanted to place the code in your sidebar.... so not sure what else you're wanting to know? Obviously, if you want the code in the sidebar, then for goodness sake, place the code in the sidebar (somewhere under the code:  <div id="sidebar"> ).

[chofi]

Hey Jesse

The plugin work well , and is very useful

thanks
Regards

Chofi

[przemo]

PLZ help me UP

[Jesse]

przemo,

For starters, copy and paste my "Basic" example from my post here, http://forums.osclass.org/development/most-viewed-ads/msg21500/#msg21500, and place it somewhere in your file Main.php. From there, you can work on customizing the display.

[przemo]

Welcome! Unfortunately, I am very weak in programming, etc. My developer went to another country, so I can not do this alone.

In the posts above, I have given my code main.php please someone good for the insertion of this. I'll be really grateful.

I wait and thank you very sincerely,
Przemek

[navjottomer]

Is it possible to show popular ads for today only.

[Jesse]

Yes, that could be done. Just change this line of code in the plugin's index.php file to reflect that you only want results WHERE dt_date = "todays date" (I don't know exactly what the correct code for "todays date" should be for comparison).

Code: [Select]

$results=$conn->osc_dbFetchResults("SELECT fk_i_item_id, i_num_views FROM %st_item_stats ORDER BY fk_i_item_id ASC", DB_TABLE_PREFIX);

[navjottomer]

I changed it something like this and it is working perfect.

Code: [Select]

$results=$conn->osc_dbFetchResults("SELECT fk_i_item_id, i_num_views FROM %st_item_stats WHERE DATE(dt_date) = DATE(NOW()) ORDER BY fk_i_item_id ASC ", DB_TABLE_PREFIX);

[przemo]

Welcome!
The Annex gives main.php my code from the template of "modern". Please insert this plugin to me: (. I installed it already in the admin panel. My site: www.jasielskie.org.pl (please insert where it is written in Polish, "the most popular ads."

[Alexandr]

Hello!
how to display ads on the page similar ads
Similar ads under the heading «Animals»
Similar ads under the heading «Cars»
.......

[Jesse]

Alexandr,

The feature you're asking for is completely different from the one discussed in this topic. Please start a new topic to post your question. Basically, you'd need a new plugin to display "similar ads". It would certainly be a very useful plugin, and one others have also asked for. Perhaps you could post this under "Suggestions"?