Toplist

[derekivey]

Thats weird, can you PM me admin details and FTP details to just that folder (images/toplist/) so I can take a look at it?

Thanks

[derekivey]

Since vB 3.6 Beta 1 is out now, I will release 1.0.8 soon and begin porting this hack to 3.6. School is almost over for the summer so I will have a lot more time to work on adding more features to this hack :).

Derek

[derekivey]

Hey Everyone,

I have released version 1.0.8. Please see the first post for the changes. Many new features have been added, such as a feature that checks to see if the user added their In url to their site and if so it activates them either via a cronjob or they can do it by going to a url. This is an optional feature, it can be disabled in the settings. Please see the readme for instructions on how to install or upgrade this hack. Also, please let me know if you have any problems with this hack, I will try and fix them ASAP.

Thanks,

Derek

[C_P]

Upgrade was smooth as silk and new options are fantastic! Scrolling option on forum home is GREAT also. Hope not too server intensive though... I am sure my awesome host will let me know.
Great job Derek. Wish I could click Thank you or Install again.

[mholtum]

I am trying to open the image.png with photshopCS and I get this error

Could not complete your request because the file format module could not parse the file.

WTF?

[mholtum]

Ok, heres the fix:

OPEN: FORUMHOME

FIND:

<marquee direction="$vboptions[toplist_forumhome_marquee_direction]" width="100%" scrollamount="$vboptions[toplist_forumhome_marquee_scrollamount]">$toplist_images</marquee>


REPLACE WITH:

<marquee direction="$vboptions[toplist_forumhome_marquee_direction]" width="100%" onMouseover="this.scrollAmount=0" onMouseout="this.scrollAmount=$vboptions[toplist_forumhome_marquee_scrollamount]">$toplist_images</marquee>


Let me know if you have any problems.

I am not seeing the marquee on my forum home and the code is not there either.

[Mr.D]

I have a few questions.

When i submit a site or someone else does why is site shown on the toplist on forumhome and the site is inactive. I think that is a bug.

Other thing how does that Check if code has been added to user's site work. Is there any button or something that will check that or??

And buttons dont work in admincp.

[Mr.D]

When i try to validate i get this error Could not find phrase 'error_toplist_site_pending_moderation'.

In admincp when i click Toplist sites and i want to edit it this message appears Sorry, you must select a Site ID to edit a site. Please go back and try again.

[b6gm6n]

<hope you get thos bugs sorted :) anyways...here's a question for ya... what about an exisiting TL installed into a vB...im moveing/merging a vB... and hopefully the toplist with it.....are there any database entries i should look out for...? cheers

[derekivey]

Upgrade was smooth as silk and new options are fantastic! Scrolling option on forum home is GREAT also. Hope not too server intensive though... I am sure my awesome host will let me know.
Great job Derek. Wish I could click Thank you or Install again.
Nope, the scrolling option is not server intensive :).

I am trying to open the image.png with photshopCS and I get this error

Could not complete your request because the file format module could not parse the file.

WTF?
You don't open that in CS, you have to open it in a program such as notepad or wordpad. It is a PHP file and not an image. If you want to change the background you can edit background.png I think the filename is.

I am not seeing the marquee on my forum home and the code is not there either.
I'll look into this.

I have a few questions.

When i submit a site or someone else does why is site shown on the toplist on forumhome and the site is inactive. I think that is a bug.

Other thing how does that Check if code has been added to user's site work. Is there any button or something that will check that or??

And buttons dont work in admincp.
It shouldn't be a bug, it was working fine for me. I'll take a look again and see.

When i try to validate i get this error Could not find phrase 'error_toplist_site_pending_moderation'.

In admincp when i click Toplist sites and i want to edit it this message appears Sorry, you must select a Site ID to edit a site. Please go back and try again.
Hmm, I thought I added that phrase. I might have accidentally selected a different product for it, I'll take a look. For your 2nd problem, make sure when you hover over the link it says something like &id=somenumber

Derek

[chriszep]

I have no chance
I deleted everything in my sql base
but when I upload the product

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT INTO setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'toplist_enabled',
'toplist_options',
'1',
'1',
'free',
'yesno',
10,
0,
1,
'toplist'
),
(
'disabled_message',
'toplist_options',
'The Toplist is Currently Disabled. Please Come Back Later.',
'The Toplist is Currently Disabled. Please Come Back Later.',
'free',
'textarea',
20,
0,
1,
'toplist'
),
(
'toplist_ranking_method',
'toplist_options',
'0',
'0',
'number',
'<select name=\\\"setting[$setting[varname]]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0,\'selected=\"selected\"\') . \">In Hits</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1,\'selected=\"selected\"\') . \">Out Hits</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2,\'selected=\"selected\"\') . \">Rating</option>\r\n<option value=\\\"3\\\" \" . iif($setting[\'value\']==3,\'selected=\"selected\"\') . \">Views</option>\r\n</select>',
30,
0,
1,
'toplist'
),
(
'toplist_count_out_from_guests',
'toplist_options',
'0',
'0',
'free',
'yesno',
40,
0,
1,
'toplist'
),
(
'toplist_limit_out_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
50,
0,
1,
'toplist'
),
(
'toplist_out_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
60,
0,
1,
'toplist'
),
(
'toplist_limit_in_clicks',
'toplist_options',
'1',
'1',
'free',
'yesno',
70,
0,
1,
'toplist'
),
(
'toplist_in_click_limit',
'toplist_options',
'1',
'1',
'free',
'',
80,
0,
1,
'toplist'
),
(
'toplist_open_in_new_window',
'toplist_options',
'1',
'1',
'free',
'yesno',
90,
0,
1,
'toplist'
),
(
'toplist_disable_html',
'toplist_options',
'1',
'1',
'free',
'yesno',
100,
0,
1,
'toplist'
),
(
'toplist_moderate_sites',
'toplist_options',
'0',
'0',
'free',
'yesno',
110,
0,
1,
'toplist'
),
(
'',
'toplist_options',
'1',
'1',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_email_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
120,
0,
1,
'toplist'
),
(
'toplist_email_users',
'toplist_options',
'1',
'1',
'free',
'',
130,
0,
1,
'toplist'
),
(
'toplist_pm_new_validation',
'toplist_options',
'0',
'0',
'free',
'yesno',
140,
0,
1,
'toplist'
),
(
'toplist_pm_from_user',
'toplist_options',
'1',
'1',
'free',
'',
150,
0,
1,
'toplist'
),
(
'toplist_pm_users',
'toplist_options',
'1',
'1',
'free',
'',
160,
0,
1,
'toplist'
),
(
'sites_per_page',
'toplist_options',
'15',
'15',
'free',
'',
170,
0,
1,
'toplist'
),
(
'toplist_in_redirect_url',
'toplist_options',
'',
'',
'free',
'',
180,
0,
1,
'toplist'
),
(
'toplist_number_of_sites',
'toplist_options',
'1',
'1',
'free',
'',
190,
0,
1,
'toplist'
),
(
'toplist_max_height',
'toplist_options',
'31',
'31',
'free',
'',
200,
0,
1,
'toplist'
),
(
'toplist_max_width',
'toplist_options',
'88',
'88',
'free',
'',
210,
0,
1,
'toplist'
),
(
'toplist_popup_height',
'toplist_options',
'220',
'220',
'free',
'',
220,
0,
1,
'toplist'
),
(
'toplist_popup_width',
'toplist_options',
'250',
'250',
'free',
'',
230,
0,
1,
'toplist'
),
(
'toplist_show_forumhome_images',
'toplist_options',
'0',
'0',
'free',
'yesno',
240,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_direction',
'toplist_options',
'left',
'left',
'free',
'',
250,
0,
1,
'toplist'
),
(
'toplist_forumhome_marquee_scrollamount',
'toplist_options',
'5',
'5',
'free',
'',
260,
0,
1,
'toplist'
),
(
'toplist_forumhome_number_of_images',
'toplist_options',
'0',
'0',
'free',
'',
270,
0,
1,
'toplist'
),
(
'toplist_max_image_size',
'toplist_options',
'5000',
'5000',
'free',
'',
280,
0,
1,
'toplist'
),
(
'toplist_number_of_in_hits_until_banner_shows',
'toplist_options',
'0',
'0',
'free',
'',
290,
0,
1,
'toplist'
),
(
'toplist_show_user_banners',
'toplist_options',
'1',
'1',
'free',
'yesno',
300,
0,
1,
'toplist'
),
(
'toplist_check_if_code_exists',
'toplist_options',
'0',
'0',
'free',
'yesno',
310,
0,
1,
'toplist'
),
(
'toplist_use_custom_in_rank_image',
'toplist_options',
'0',
'0',
'free',
'yesno',
320,
0,
1,
'toplist'
),
(
'toplist_custom_in_rank_image_extension',
'toplist_options',
'gif',
'gif',
'free',
'',
330,
0,
1,
'toplist'
),
(
'toplist_count_site_page_views',
'toplist_options',
'0',
'0',
'free',
'yesno',
340,
0,
1,
'toplist'
);

MySQL Error : Duplicate entry '' for key 1
Error Number : 1062
Date : Thursday, June 8th 2006 @ 10:59:38 PM
Script : http://www.xxxxxxxxxxxxxxx/forums/admincp/plugin.php
Referrer : http://www.xxxxxxxxxxxxxx.com/forums/admincp/plugin.php?do=productadd
IP Address : 8xxxxxxxxxxxxx2
Username : xxxxxxxxxxxxxx
Classname : vb_database

[Equinox6]

Hi realy quick question, is there enyway i can change the name so it shows on the navbar as something else apart from 'toplist' i want to use this as more of a affiliates thing?

Is it possable?

Regards,

-Equinox

[derekivey]

Sorry, looks like vBulletin messed up my XML file. Please try the attached one, and let me know if it works. Zip file has been updated too.

Thanks,
Derek

[derekivey]

Hi realy quick question, is there enyway i can change the name so it shows on the navbar as something else apart from 'toplist' i want to use this as more of a affiliates thing?

Is it possable?

Regards,

-Equinox

Sure is, just edit the text in the phrase called 'toplist' (w/o the quotes), don't change the var name, but for the English Translation just type Affiliates or what ever you want.

Let me know if you have any problems.

Thanks,
Derek

[Mr.D]

Hmm, I thought I added that phrase. I might have accidentally selected a different product for it, I'll take a look. For your 2nd problem, make sure when you hover over the link it says something like &id=somenumber

Derek

yes it hase id something like this and i think the id is wrong

?do=viewvotes&id%20=%201

and the banner doesent show on admincp on all pages. And when will you add that phrase in there

Could not find phrase 'error_toplist_site_pending_moderation'.

[derekivey]

Can you PM me admin details so I can check this out please?

Thanks,
Derek

[derekivey]

Sorry, I have added the missing phrase. Please reimport the attached xml file and select yes to overwrite. Zip file has been updated as well.

Derek

[michaelsilvia]

I am getting this error when uploading a .jpg file.

Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG

The format of the file you uploaded is .

Please go back and select a new image or leave the image field blank.

How can I change the type of images that can be uploaded?

[derekivey]

Hi, can you please send me the image so I can try and fix the bug? This has never happened to me so I need to take a look at it and see whats wrong.

Thanks,
Derek

[derfelix]

Hi Derek
Big thumbs up.. havent updated yet cause im just upgrading vbulletin..
but looks great with all the new features!!!

may i add a couple of wishes for next release???
(i'm comparing the features to my existing external toplist)

functionality:
- add a cron to reset the counts..
why? because if any new sites are added.. they will never be able to move up if some sites have been there for years with thousands of ins and outs. (usually i have a cron on a weekly base ... but a reset once a month would be fine also)

- add a cache to the generated banners
if the site that uses the stats banner has 1.000.000 hits a day.. it will be generated 1.000.000 times ON YOUR SERVER. (cache update once an hour or day.. or only if things change)

- change the layout to standard banners 468x60
When using the standard banners.. the layout gets to wide specially if you are using a left navigation block.. it would be, for those banners much nicer if the banner was between site title and description, not needing an extra column.

- only show banners for the first 10 or 20 or 30 sites
the banners for the others should not appear. (sort of reward for good sites)

Last .. but this is just the frosting on the pie

- have a plus [+] minus [-] or equal [=] sign near the ranking
so users would know if this site is coming up or loosing rank.. example i a site is ranked 4 it would have a symbol besides the rank (or somewhere else) if the former rank was 3 it would be a [-] .. if the former rank was 10 it would be a [+].. and if nothing has changed.. ie. the former rank was 4 in the last 24 hours so.. it would be [=]... hmm i'll check with my toplist pro what criteria they use for [=]

sorry if one of these features is allready implemented.. as i said i will only be upgrading during the week. (I only looked at the changelog)
But I think its great and looks very professional now!!!!!

And last... just had an idea.. and i dunno if its easy to implement..
- if a user has a homepage in his profile, add a little checkbox in his settings so he can have it added automatically to the toplist (it should tell him to add a banner as soon as possible)

thats all for now.. no more ideas

Felix

[derekivey]

Hi Derek
Big thumbs up.. havent updated yet cause im just upgrading vbulletin..
but looks great with all the new features!!!

may i add a couple of wishes for next release???
(i'm comparing the features to my existing external toplist)

functionality:
- add a cron to reset the counts..
why? because if any new sites are added.. they will never be able to move up if some sites have been there for years with thousands of ins and outs. (usually i have a cron on a weekly base ... but a reset once a month would be fine also)

- add a cache to the generated banners
if the site that uses the stats banner has 1.000.000 hits a day.. it will be generated 1.000.000 times ON YOUR SERVER. (cache update once an hour or day.. or only if things change)

- change the layout to standard banners 468x60
When using the standard banners.. the layout gets to wide specially if you are using a left navigation block.. it would be, for those banners much nicer if the banner was between site title and description, not needing an extra column.

- only show banners for the first 10 or 20 or 30 sites
the banners for the others should not appear. (sort of reward for good sites)

Last .. but this is just the frosting on the pie

- have a plus [+] minus [-] or equal [=] sign near the ranking
so users would know if this site is coming up or loosing rank.. example i a site is ranked 4 it would have a symbol besides the rank (or somewhere else) if the former rank was 3 it would be a [-] .. if the former rank was 10 it would be a [+].. and if nothing has changed.. ie. the former rank was 4 in the last 24 hours so.. it would be [=]... hmm i'll check with my toplist pro what criteria they use for [=]

sorry if one of these features is allready implemented.. as i said i will only be upgrading during the week. (I only looked at the changelog)
But I think its great and looks very professional now!!!!!

And last... just had an idea.. and i dunno if its easy to implement..
- if a user has a homepage in his profile, add a little checkbox in his settings so he can have it added automatically to the toplist (it should tell him to add a banner as soon as possible)

thats all for now.. no more ideas

Felix

Hey,

Nice ideas! I think I will add most of them, but I don't know how I would go about creating a cache for the generated banners. Do you know how I could do this?

Also, I'm not sure how I can add a plus, or negative sign right now because it would probably require me to rewrite a lot of the script. Right now, the ranks are not stored in the database, so there is no record of their old ones at all. I could probably make another table in the database to store them but not sure yet, I'll have to see about that one.

Derek

[derfelix]

Hey,

Nice ideas! I think I will add most of them, but I don't know how I would go about creating a cache for the generated banners. Do you know how I could do this?

well the way i would do it, (but i often have clumsy solutions :confused: ) ist that i would create a cache folder.. and generate the jpg or png in there.. as filename i would use a name underscore banner id (ex: statsbanner_000001.jpg)
the cache folder schould be 777
and each time a banner is created dont forget the chmode 0777 so it can be overwritten by a newly generated one.
(I forgot that one.. because it worked fine without it.. -the script being the creator- but when i upgraded to another version of my script.. i couldnt access the files anymore) heres the code snippet for the file creation:
$stats_banner = "statsbanner_" . $banner_id . ".png";
@imagepng($sourcebanner, $cache_path . $stats_banner);
@chmod($cache_path . $stats_banner, 0777);
//send banner to browser
@imagepng($sourcebanner); // yes source banner.. as we just created it.. no need to fetch from disk
@imagedestroy($sourcebanner); // free memory as some systems dont do it automatically

You probably know it.. but as i just spent 3 hours finding out why my other script didnt work after upgrade.. i thought a reminder to add the chmod wouldn't harm.. and maybe even save time ;)
Ah yes and i think i read that php 5 doesnt like the @ in front of the commands.. but im not sure..


in the script that calls the banner...

if -> no cache banner exists for this banner id.. ->
create new one (like now) ->
but save it to cache ->
and then display it (on the fly like done now) (SEE THE CODE SNIPPET ABOVE !!)

else

if -> cache banner exists for this id.. ->
check creation time ->


if it is older than (now) minus offset ->
create new one ->
overwrite the old one ->
display it on the fly (like it is done now) (SEE THE CODE SNIPPET ABOVE !!)
else (it was created between now and (now-time offset))
do nothing and only display the cached one
with:
$stats_banner = "statsbanner_" . $banner_id . ".png";
readfile($cache_path . $stats_banner);

time offset should be changeble by admin (xx minutes) (xx hours) (maybe days) but no complicated milliseconds settings..
if no time offset is set.. then all banners are created on the fly and caching is disabled.



this would not require database for cached banner.. difference to offset is calculated by file creation time.
it would be better than to create it on change of stats.. because that would require database.

thats the way i would do it.. but there is maybe a better way..



Also, I'm not sure how I can add a plus, or negative sign right now because it would probably require me to rewrite a lot of the script. Right now, the ranks are not stored in the database, so there is no record of their old ones at all. I could probably make another table in the database to store them but not sure yet, I'll have to see about that one.
Derek

hey that is absolutely not a must.. its just a nice feature.. but i wouldn't place it top on the todo list..

felix

[michaelsilvia]

I am attaching the image.

Also, I am having a new problem with categories. How do you delete or edit categories? I get this error.

Sorry, you cannot edit a category without first selecting one. Please try again, and make sure a id is included in the url.

There is no way to select the category in the ACP.

Mike

[DementedMindz]

ok fixed my other problem but whats up with Main Category you cant delete or edit that or something? i try to delete it or edit and its telling me Sorry, in order to delete a category you must select an ID to delete. Please try again.

[loonytune15]

Nice ideas in there :)
Still got 2 bugs currently.
1. none of the images are working in the admincp.
2. I hvae slected the optin to open in new window yet it still opens in the same window.

Any ideas?

[derekivey]

well the way i would do it, (but i often have clumsy solutions :confused: ) ist that i would create a cache folder.. and generate the jpg or png in there.. as filename i would use a name underscore banner id (ex: statsbanner_000001.jpg)
the cache folder schould be 777
and each time a banner is created dont forget the chmode 0777 so it can be overwritten by a newly generated one.
(I forgot that one.. because it worked fine without it.. -the script being the creator- but when i upgraded to another version of my script.. i couldnt access the files anymore) heres the code snippet for the file creation:
$stats_banner = "statsbanner_" . $banner_id . ".png";
@imagepng($sourcebanner, $cache_path . $stats_banner);
@chmod($cache_path . $stats_banner, 0777);
//send banner to browser
@imagepng($sourcebanner); // yes source banner.. as we just created it.. no need to fetch from disk
@imagedestroy($sourcebanner); // free memory as some systems dont do it automatically

You probably know it.. but as i just spent 3 hours finding out why my other script didnt work after upgrade.. i thought a reminder to add the chmod wouldn't harm.. and maybe even save time ;)
Ah yes and i think i read that php 5 doesnt like the @ in front of the commands.. but im not sure..


in the script that calls the banner...

if -> no cache banner exists for this banner id.. ->
create new one (like now) ->
but save it to cache ->
and then display it (on the fly like done now) (SEE THE CODE SNIPPET ABOVE !!)

else

if -> cache banner exists for this id.. ->
check creation time ->


if it is older than (now) minus offset ->
create new one ->
overwrite the old one ->
display it on the fly (like it is done now) (SEE THE CODE SNIPPET ABOVE !!)
else (it was created between now and (now-time offset))
do nothing and only display the cached one
with:
$stats_banner = "statsbanner_" . $banner_id . ".png";
readfile($cache_path . $stats_banner);

time offset should be changeble by admin (xx minutes) (xx hours) (maybe days) but no complicated milliseconds settings..
if no time offset is set.. then all banners are created on the fly and caching is disabled.



this would not require database for cached banner.. difference to offset is calculated by file creation time.
it would be better than to create it on change of stats.. because that would require database.

thats the way i would do it.. but there is maybe a better way..




hey that is absolutely not a must.. its just a nice feature.. but i wouldn't place it top on the todo list..

felix

I'll look into adding the cache but can't make any guarentees, I was also thinking about maybe moving the buttons to the database instead of using file storage but I'm not sure yet.

[derekivey]

Guys,

Please try uploading the attached file to the admincp directory to see if it fix any of those bugs. It seems to be working for me but I want to make sure.

Thanks,
Derek

[derfelix]

i personnally think that putting graphs in the dbase takes more ressources than filesystem.. anyway noone can find the cachefolder if you get it with readfile
--------------
Just looked at my standalone toplist and found what I was missing here:

Anti cheat..
we have now the ability to control if the code is on the users site.. great.
but the user could click hundreds of times on his banner on his site.. giving it lots of ins! there are 2 ways of preventing this.. by logging ips.. and with cookies..

second:
a user links out to his site.. this is a good and clean site.. its ok..
after a week.. he changes the outlink and sends people clicking his banner to a viagra site.. or a ringtone site or a porn site.. his outlink the admin should be notified. (ok... as few of these sites will have the code - which is checked here - it is only of minor importance)

Felix
@derek
if you wish i can pm you admin info for that toplist so you can take a look at the admin interface.

[loonytune15]

that file you atached works Derek. I am now showing the images in the admincp.

but the open in new window still doesn't work.

[derekivey]

Ok I'll take a look at that loonytune15. Do you still have the categories problem though?

[derekivey]

Anti cheat..
we have now the ability to control if the code is on the users site.. great.
but the user could click hundreds of times on his banner on his site.. giving it lots of ins! there are 2 ways of preventing this.. by logging ips.. and with cookies..

I believe I added the feature to limit the number of ins per IP address. But I think adding a cookies thing would be good also. I'll prolly add that...


second:
a user links out to his site.. this is a good and clean site.. its ok..
after a week.. he changes the outlink and sends people clicking his banner to a viagra site.. or a ringtone site or a porn site.. his outlink the admin should be notified. (ok... as few of these sites will have the code - which is checked here - it is only of minor importance)

So your saying have it PM the admin when they change their URL? That would be easy for me to add. Let me know if this is what you mean.

Thanks,
Derek

[Mr.D]

Ok the button problem is fixed in admin cp that file works

Can you make an addon so buttons can be shown in header

[DementedMindz]

ok that fixed my problem with the Categories... now i just have one other question... a few of the new topsites out its hard to link to them cause the basiclly use a button... here is a example code...

<a href="http://www.example.com/">
<img src="http://www.example.com/button.php?u=DementedMindz" alt="Example Topsites" border="0" />
</a>
how code we link to that?

also make it a little easier to validate the sites... ex. i added like 20 sites yesterday as admin from admin panel... now when i added them i figured it would of added them but it didnt... i had to go to the toplist.php page once on there i had to hit edit not validate cause if i hit validate it said waiting admin approval when i was the admin so i hit edit then save and it validated them... Aardvark Topsites PHP (http://www.aardvarktopsitesphp.com/) you maybe able to get some nice ideas of features from that script... such as a Stats page and the site Movement say it goes up or down in rank... here is a few features that it has that would be nice on here also...

- Members ranks can be shown on their button.
- Advanced stats and graphs
- Stat Buttons, allowing you to customize your buttons and display all kinds of stats on them
- Counts unique pageviews, total pageviews, unique hits in, total hits in, unique hits out, and total hits out
- Rank daily, weekly, or monthly

[derekivey]

Ok the button problem is fixed in admin cp that file works

Can you make an addon so buttons can be shown in header
Sure, I'll try when I get some time. Where in the header should it be?

Derek

[derekivey]

ok that fixed my problem with the Categories... now i just have one other question... a few of the new topsites out its hard to link to them cause the basiclly use a button... here is a example code...

<a href="http://www.example.com/">
<img src="http://www.example.com/button.php?u=DementedMindz" alt="Example Topsites" border="0" />
</a>
how code we link to that?

also make it a little easier to validate the sites... ex. i added like 20 sites yesterday as admin from admin panel... now when i added them i figured it would of added them but it didnt... i had to go to the toplist.php page once on there i had to hit edit not validate cause if i hit validate it said waiting admin approval when i was the admin so i hit edit then save and it validated them... Aardvark Topsites PHP (http://www.aardvarktopsitesphp.com/) you maybe able to get some nice ideas of features from that script... such as a Stats page and the site Movement say it goes up or down in rank... here is a few features that it has that would be nice on here also...

- Members ranks can be shown on their button.
- Advanced stats and graphs
- Stat Buttons, allowing you to customize your buttons and display all kinds of stats on them
- Counts unique pageviews, total pageviews, unique hits in, total hits in, unique hits out, and total hits out
- Rank daily, weekly, or monthly

I don't quite understand what you mean about trying to link to them. Can you please give me a better example?

Also I'll take a look into adding your suggestions.

Derek

[DementedMindz]

I don't quite understand what you mean about trying to link to them. Can you please give me a better example?

Also I'll take a look into adding your suggestions.

Derek

ok for example there html code is this

<a href="http://www.example.com/">
<img src="http://www.example.com/button.php?u=DementedMindz" alt="Example Topsites" border="0" />
</a>

now if you try to link to this http://www.example.com/button.php?u=DementedMindz it will only bring you to there topsite button and not give you a hit and rate to there topsite... you need the full html code to get hits to there topsite... basiclly you need to enter that code if not you dont get hits... ill send you a pm with a direct link and it should explain it more

[Mr.D]

Sure, I'll try when I get some time. Where in the header should it be?

Derek

At the bottom of the Header

[Mr.D]

Error No. 1
I cant upload this .gif file 49340

Error No. 2
I cant validate site from siteurl.com/toplist.php

49342

i get this message when i click on the validate.

49341

Error No.3

The buttons that are on the forums home page they are shown and they are not validated i think that needs fixing. And they are not opening in the new window and that is selected in admin cp.

Error No.4

The link to username of the user that submited the site is wrong in admin cp toplist see screenshot

49344

This are the errors that i found so far i hope this helps. ;)

[jaks]

I was just coming to ask about the categories edit link being broken and I see you have a fix for it already. I uploaded the new file and it's now working just fine. :D

I would love it if you could add category descriptions to this hack and figure out the issue with the VBadvanced pages breaking the voting popup. Category descriptions are a more important thing I would think though.

[jaks]

I modified the VBA module template so it could be used as a side module.
If you would like it I posted it in the VBA module addon thread for the topsite here https://vborg.vbsupport.ru/showthread.php?t=101302 and I also added a screenshot of what it looks like finished.

[dendrob]

The really cool thing in this topsite would be detailed stats for each site listed. Sure you could list the last periods stats by which you're ranking right on the main topsite listing, but if you click on STATS for each page ranked, if something like the attached would pop up it would be awesome!

[loonytune15]

I dont know of any catagories prob but i barely use them.

But the open in the new window is a prob :)

[derekivey]

At the bottom of the Header
Ok, I'll try and make it when I get some time.

Error No. 1
I cant upload this .gif file 49340
Ok, I will take a look and see why it won't upload. Other people have been having this problem also and for some reason the image's file type isn't being passed to the Toplist, so I'll have to take a look and try to fix it.

Error No. 2
I cant validate site from siteurl.com/toplist.php

49342

i get this message when i click on the validate.

49341
You have to login to the AdminCP and go to Inactive sites and validate it first.

Error No.3

The buttons that are on the forums home page they are shown and they are not validated i think that needs fixing. And they are not opening in the new window and that is selected in admin cp.
Yeah, sorry I think I forgot to update that module. I will get it fixed ASAP.

Error No.4

The link to username of the user that submited the site is wrong in admin cp toplist see screenshot

49344
Fixed. Please try the attached file. :)

I was just coming to ask about the categories edit link being broken and I see you have a fix for it already. I uploaded the new file and it's now working just fine. :D

I would love it if you could add category descriptions to this hack and figure out the issue with the VBadvanced pages breaking the voting popup. Category descriptions are a more important thing I would think though.
Where should I put category descriptions at? How about on the add site and edit site pages I add a spot where the selected category's description is shown and when they change categories in the drop down it would show the newly selected category's descriptions (this would use javascript btw). Also I will take a look at the vBadvanced problem when I get it installed on my test board.

The really cool thing in this topsite would be detailed stats for each site listed. Sure you could list the last periods stats by which you're ranking right on the main topsite listing, but if you click on STATS for each page ranked, if something like the attached would pop up it would be awesome!
That looks like it would be worth adding. I will try adding it as well when I get some time.

I dont know of any catagories prob but i barely use them.

But the open in the new window is a prob :)
I'll look into the open new window problem. Did it just start happening during this version?

Thanks,
Derek

[jaks]

Originally Posted by jaks
I was just coming to ask about the categories edit link being broken and I see you have a fix for it already. I uploaded the new file and it's now working just fine.

I would love it if you could add category descriptions to this hack and figure out the issue with the VBadvanced pages breaking the voting popup. Category descriptions are a more important thing I would think though.

Where should I put category descriptions at? How about on the add site and edit site pages I add a spot where the selected category's description is shown and when they change categories in the drop down it would show the newly selected category's descriptions (this would use javascript btw). Also I will take a look at the vBadvanced problem when I get it installed on my test board.

I was thinking at the top of each category there could be a spot for it. There really is no need for it in addsite and editsite as far as I can tell. Javascript would really be defeating the purpose.

Main description for the topsite on the toplist.php and category descriptions at the top for each of the category pages. I'm thinking for solely for SEO purposes. It could go above or below the random site part.

A simple
<table class="thead" width="100%">
<tr><td colspan="2">Category title</td></tr>
<tr><td width="30%">Image here</td><td width="70">description here</td></tr>
<tr><td colspan="2">footer</td></tr>
</table>
Don't even really need the footer there. Just enough space for some text to re-enforce the keywords for the search engines. This would also give people some flexibility up top. Wrap it in an if statement for category description is null no block will show. If it parses html that would be a plus too.

I was also thinking it would be nice to have a featured site as an alternative to random if that's possible. Hehe... more work lol...

[derekivey]

I was thinking at the top of each category there could be a spot for it. There really is no need for it in addsite and editsite as far as I can tell. Javascript would really be defeating the purpose.

Main description for the topsite on the toplist.php and category descriptions at the top for each of the category pages. I'm thinking for solely for SEO purposes. It could go above or below the random site part.

A simple
<table class="thead" width="100%">
<tr><td colspan="2">Category title</td></tr>
<tr><td width="30%">Image here</td><td width="70">description here</td></tr>
<tr><td colspan="2">footer</td></tr>
</table>
Don't even really need the footer there. Just enough space for some text to re-enforce the keywords for the search engines. This would also give people some flexibility up top. Wrap it in an if statement for category description is null no block will show. If it parses html that would be a plus too.

I was also thinking it would be nice to have a featured site as an alternative to random if that's possible. Hehe... more work lol...

Ahh ok, I get it now. Also how would the featured site be selected? Would it be admin selectable or what?

[jaks]

Ya.. definitely selectable in admin.

:D
Jaks

[derfelix]

So your saying have it PM the admin when they change their URL? That would be easy for me to add. Let me know if this is what you mean.


Well yes.. that would be great.. and sufficiant.. or email.. what ever is easier!
Felix

[jeffj]

can this be installed so that only the administrator can add links?

I want to use this page for advertisers on my site only.

thanks

[derekivey]

can this be installed so that only the administrator can add links?

I want to use this page for advertisers on my site only.

thanks
Yes, just edit the usergroup permissions and set Can Add Sites to no for all usergroups, except the admin group.

[nets]

i have a problem .. on click the button link this message apper :

Datenbankfehler in vBulletin 3.5.4:

Invalid SQL:
UPDATE toplist_sites SET
out=out+1,
views=views+1
WHERE id = '1';

MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out=out+1,
views=views+1
WHERE id = '1'' at line 2
Fehler-Nr. : 1064
Datum : Thursday, June 15th 2006 @ 01:07:23 PM
Skript : http://www.xxxxxxx.xx/forum/out.php?id=1
Referrer : http://www.xxxxxxx.xx/forum/toplist.php
IP-Adresse : 111.111.111.11
Benutzername : arthus
Klassenname : vB_Database


installd . php 5.0.18, ap 2.2

can you help me ?? zhank`s

arthus

[derekivey]

Hmm thats weird, it looks fine to me, I'll have to take a look more closely and I'll let you know if I find anything out.

Derek

EDIT: What MySQL version do you have?

[b6gm6n]

Hi... i love this mod... really coool... anyways i suppose you know of the 'cannot edit categories' bug from ACP... :) (too many spaces_ "id = 2") :D maybe...

-b6

[derekivey]

Please try this file, it should fix it. I attached it to a post and forgot to update the zip file in the first post.

Link: https://vborg.vbsupport.ru/attachment.php?attachmentid=49355&d=1150214870

Derek

[nets]

thank`s
iam install it :banana:

georg

Please try this file, it should fix it. I attached it to a post and forgot to update the zip file in the first post.

Link: https://vborg.vbsupport.ru/attachment.php?attachmentid=49355&d=1150214870

Derek

[derekivey]

Hi Georg,

Are you still getting that MySQL error?

Thanks,
Derek

[b6gm6n]

One last thing... a friend uploaded a banner which was outside my dims limits... added the site but showed no banner... sho he thought he'd try it again... and again...and again...not knowing he was uploading a banner that was too big... so a little notice would be great :D...as i say...top mod... great stuff!

-b6

[derekivey]

There should be a notice. That's weird it wasn't showing up though. What happened when he tried adding it? What did the Toplist script do?

[nets]

yes,
this file was already instal.
the same error ist still getting.
what now ??
greatings
georg



Hi Georg,

Are you still getting that MySQL error?

Thanks,
Derek

[derekivey]

Ok, what version of MySQL do you have?

[nets]

Ok, what version of MySQL do you have?

Server OS/PHP WINNT
Datenbankverbrauch 81,10 MB
Webserver Apache v2.2.0
Index belegt 2,57 MB
PHP 5.1.1
PHPs max. Post-Gr??e 16,00 MB
PHPs maximale Uploadgr??e 16,00 MB
PHPs Speicherlimit Nein
MySQL-Version 5.0.18-nt-max
MySQL Paketgr??e 1.023,0 KB

here my dates
georg

[Ramsesx]

Seems not to work with msql 5, maybe you remember my help request before 2 month derek.

[derekivey]

Georg,

Please try the attached file and let me know if it works.

Thanks,
Derek

[Snake]

I'll test it out for you...

[nets]

i`ll have overide it.
and it runs perfektly .. no errors !!
the sql database run?s.

thanks .. :banana:
georg


Georg,

Please try the attached file and let me know if it works.

Thanks,
Derek

[derekivey]

Thanks for getting back to me. I will update the zip file soon with the fix so that no one else has any problems with it.

Thanks,
Derek

[b6gm6n]

There should be a notice. That's weird it wasn't showing up though. What happened when he tried adding it? What did the Toplist script do?

it's ok... all working, my bad...

[Vitz]

I'm getting an odd Database error when trying to add a site through the Admin CP. Any idea how to fix this?


Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO toplist_sites SET
username = 'Vitz',
name = 'Name',
url = 'http://www.name.com',
description = 'Name',
`in` = '0',
out = '0',
views = '0',
status = 'active',
cid = '',
imagetype = 'image/jpeg',
imagesize = '4326',
imagecode = 'yIu026PzjHz7HrXTnGd6',
added_code = '0';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out = '0',
views = '0',
status = 'active',
cid = '',
' at line 7
Error Number : 1064
Date : Monday, June 19th 2006 @ 08:12:40 AM
Script : http://www.elusive-works.co.uk/forums/admincp/toplist_admin.php
Referrer : http://www.elusive-works.co.uk/forums/admincp/toplist_admin.php?do=add
IP Address : 82.169.28.64
Username : Vitz
Classname : vB_Database

Other than that, great hack. It'll definitely help me out.

[derekivey]

What MySQL version are you running?

[PitPunks]

Nominated for m.o.t.m and clicked install, ++++ing amazing dude, thanks!

[derekivey]

Thanks! Glad you like it :D.

Derek

[Dj. Gargamel]

hello - I just installed this great mod but I am having a problem - everything is working correctly till the moment I am choosing a category of sites to view - sites are displayed only when View All Sites option is turned on - when we are trying to sort sites by category none of pages is being shown (one random site is displaying always at top)

[puregraf]

hi im getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status = 'inactive';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 01:30:55 PM
Script : http://www.puregraffiti.com/graffiti-space/admincp/toplist_admin.php
Referrer :
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database


and when i access: http://www.puregraffiti.com/graffiti-space/toplist.php

i get:

puregraffiti, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


also,

i have no topsites category under my admincp for vbulletin like how it shows on your screenshots that im supposed to have... ??

someone please help

[Noxious]

i just installed this mod, i was wondering if anyone know how i change the banner allowed file extensions as the default mod only allows jpeg, gif and png image banner files and i prefere to use jpg, and when i try to upload a jpg banner i get an error message

Thanks for any help

[derekivey]

hello - I just installed this great mod but I am having a problem - everything is working correctly till the moment I am choosing a category of sites to view - sites are displayed only when View All Sites option is turned on - when we are trying to sort sites by category none of pages is being shown (one random site is displaying always at top)
Can you PM me a link to your site so I can take a look?

hi im getting this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status = 'inactive';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 01:30:55 PM
Script : http://www.puregraffiti.com/graffiti-space/admincp/toplist_admin.php
Referrer :
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database


and when i access: http://www.puregraffiti.com/graffiti-space/toplist.php

i get:

puregraffiti, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.


also,

i have no topsites category under my admincp for vbulletin like how it shows on your screenshots that im supposed to have... ??

someone please help
Make sure you imported the product XML file under vB's product manager, then set the usergroup permissions and everything should be working.

i just installed this mod, i was wondering if anyone know how i change the banner allowed file extensions as the default mod only allows jpeg, gif and png image banner files and i prefere to use jpg, and when i try to upload a jpg banner i get an error message

Thanks for any help
Currently you have to edit the add_site.php, edit_site.php, and /admincp/toplist_admin.php files to add image types. You will need to know the mime type for each file type you want to add (e.g. image/jpeg).

The line should look like this:
if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")

Derek

[puregraf]

Make sure you imported the product XML file under vB's product manager, then set the usergroup permissions and everything should be working.


hi, i went to redo that, and i went to import and got this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE image LIKE 'http://%';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Monday, June 19th 2006 @ 06:35:04 PM
Script : http://www.puregraffiti.com/graffiti-space/admincp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti-space/admincp/plugin.php?do=productadd
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

then i went to do it again cause it didnt add it, and i got this:



Database error in vBulletin 3.5.4:

Invalid SQL:
CREATE TABLE `toplist_ratings` (
`id` int(10) NOT NULL auto_increment,
`site_id` int(10) NOT NULL default '0',
`username` varchar(255) NOT NULL default '',
`rating` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM;;



MySQL Error : Table 'toplist_ratings' already exists
Error Number : 1050
Date : Monday, June 19th 2006 @ 06:37:29 PM
Script : http://www.puregraffiti.com/graffiti-space/admincp/plugin.php
Referrer : http://www.puregraffiti.com/graffiti-space/admincp/plugin.php?do=productadd
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

[derekivey]

Please login to PHPMyAdmin, and delete all of the toplist_ tables, as well as the toplistpermissions column in the usergroup table (Do not delete the table itself!), and try the import again.

Derek

[Dj. Gargamel]

Can you PM me a link to your site so I can take a look?

Derek
PM sent - thanks for support

[Vitz]

What MySQL version are you running?

I'm currently running MySQL 5.0.18.

[derekivey]

Ok, I'll release an update shortly to fix these db errors. It seems that MySQL has added some more keywords so I will need to add ` around everything.

Derek

[derekivey]

Ok I have released the update. Those of you having SQL errors should redownload the zip file and reupload the files only. You don't have to reimport the xml file.

Please let me know if you continue to have problems.

Thanks,
Derek

[derekivey]

There was another bug found with this hack, if you edit a site in the AdminCP, it resets the category back to no category, so its just shown when you first go to the Toplist. If you would like to fix this, please upload the attached file to the AdminCP and overwrite the old one. I am also updating the zip file to include this change.

Thanks,
Derek

[Domenico]

Another bug, when you give a usergroup permission to edit they can bypass the validation. Instead of clicking the validate link to check if the backlink exist they can simply click edit and save and the link is posted in the toplist. Can this be fixed?

Also when I turn on site moderation and then validate the user, the user still gets the message (when clicking validate) that the moderator needs to validate the link first. So the site is validated by me but the user still gets this message and can't validate his site (backlink).

[derekivey]

I'll take a look at these and get back to you. I'll see if I can reproduce them.

Derek

[Dj. Gargamel]

Thank for so fast answer and using Your precious time
unfortunately I found next error - when I am trying to edit category in Admin CP i get message "Sorry, you cannot edit a category without first selecting one. Please try again, and make sure a id is included in the url."

[Domenico]

Thank for so fast answer and using Your precious time
unfortunately I found next error - when I am trying to edit category in Admin CP i get message "Sorry, you cannot edit a category without first selecting one. Please try again, and make sure a id is included in the url."

I also had this error but with the latest update it is gone. You can go around this bug by opening the edit category in a new window. Then in the url you can see what is wrong. You must get rid of the two spaces at the end.

Remove %20 twice at the end and enter. No it works. :)

[Domenico]

Ok another one, when users forget to copy the site code they can't get it again when hey edit their site. They have to delete the entry and start all over again. Can't you display the site code on the user edit page ?

Request: how can I remove the rating column? I want to disable the rating part from the toplist.

[Vitz]

Thank you for the update. The hack seems to work fine now. I just have one question. How would I go about moving the toplist box that scrolls the listed sides, to the bottom of my forums? Right now I have an affiliate box there, and would like to replace that with the Toplist box. I'm not very experienced when it comes to coding so if you could help me, that'd be great. Thanks.

[derekivey]

Thank for so fast answer and using Your precious time
unfortunately I found next error - when I am trying to edit category in Admin CP i get message "Sorry, you cannot edit a category without first selecting one. Please try again, and make sure a id is included in the url."
Make sure you uploaded the attached file above. I logged into your admincp and it doesn't look like you did because that bug still exists, and so does the broken images bug when you click on Toplist Sites.

Ok another one, when users forget to copy the site code they can't get it again when hey edit their site. They have to delete the entry and start all over again. Can't you display the site code on the user edit page ?

Request: how can I remove the rating column? I want to disable the rating part from the toplist.
It shows up when they edit their site and click submit. I think I will add a page in the next version where they can see it without having to edit their site.

Right now you manually have to remove the rating column, but in the next version I will have an option that when disabled it will not show it, requiring no file edits. For now, if you want to remove it now, you have to edit the Toplist, Toplist_1, and Toplist_2 templates to remove it.

Thank you for the update. The hack seems to work fine now. I just have one question. How would I go about moving the toplist box that scrolls the listed sides, to the bottom of my forums? Right now I have an affiliate box there, and would like to replace that with the Toplist box. I'm not very experienced when it comes to coding so if you could help me, that'd be great. Thanks.
You will have to mess with the plugin called Toplist Forum Home Addon, which is on the hook forumhome_complete. You will have to edit the line called:
$find = '<!-- end logged-in users -->';
and replace it with a line of code that is currently above where you want to put it.

Derek

[Domenico]

Thanks for your answer! :)

Ok some users think they are clever and put the site html on a page outside of their site. Can you make the url where they put the site html code visible on the admin page when I edit a site please?

[Noxious]

Currently you have to edit the add_site.php, edit_site.php, and /admincp/toplist_admin.php files to add image types. You will need to know the mime type for each file type you want to add (e.g. image/jpeg).

The line should look like this:
if ($image_type == "image/gif" OR $image_type == "image/pjpeg" OR $image_type == "image/jpeg" OR $image_type == "image/x-png")

Derek

done that but still getting the following when trying to upload a JPG banner, JPEG files work but no1 really uses them anymore

Sorry, your image could not be uploaded because the format of it is not allowed. Allowed formats are GIF, JPEG, and PNG

The format of the file you uploaded is .

Please go back and select a new image or leave the image field blank.

[Domenico]

Right now you manually have to remove the rating column, but in the next version I will have an option that when disabled it will not show it, requiring no file edits. For now, if you want to remove it now, you have to edit the Toplist, Toplist_1, and Toplist_2 templates to remove it.

Derek

Derek, can you please show us wich code has to be taken out because whatever I do it messes up everything. I just want to remove the rating column.

Thank you!

[DementedMindz]

ok question i went in to delete a site and after i deleted it from the toplist.php page i got this error... what would cause that?

Warning: unlink(images/toplist/buttons/sites/forumhome_todayusers): No such file or directory in /delete_site.php on line 105

also the site never had a button i never added one..

[derekivey]

Thanks for your answer! :)

Ok some users think they are clever and put the site html on a page outside of their site. Can you make the url where they put the site html code visible on the admin page when I edit a site please?
It doesn't check other pages for the code. It only checks the exact url they entered as their site URL.

done that but still getting the following when trying to upload a JPG banner, JPEG files work but no1 really uses them anymore
Yeah thats a weird bug in this hack. I'm not exactly sure why it doesn't detect the filetype of the image. If you feel comfortable with what file types people upload, you can remove the if statement to allow any filetype until I figure out how to fix the bug.

Derek, can you please show us wich code has to be taken out because whatever I do it messes up everything. I just want to remove the rating column.

Thank you!
Open the Toplist template.

FIND AND DELETE:
<td class="thead" width="90">$vbphrase[toplist_rating]</td>

FIND AND DELETE:

<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">2<else />1</if>" width="90">
<if condition="$rating == 0">
$vbphrase[toplist_not_rated]
<else />
<img src="$vboptions[bburl]/images/rating/toplist_rating_$rating.gif" alt="" />
<br />
$randsite[votes]
<if condition="$randsite[votes] == 1">
$vbphrase[toplist_vote]
<else />
$vbphrase[toplist_votes]
</if>
</if>
<if condition="!$show[guest]">
<br />
<a href="#" onclick="javascript:window.open('$vboptions[bburl]/toplist.php?do=rate&amp;id=$randsite[id]','rate_site','menubar=0,resizable=1,width=$vbopti ons[toplist_popup_width],height=$vboptions[toplist_popup_height]');return false;">$vbphrase[toplist_rate_site]</a>
</if>
</td>


Close & Save the Toplist template.

Open the Toplist_1 template.

FIND AND DELETE:

<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">2<else />1</if>" width="90">
<if condition="$sr[rating_average] == 0">
$vbphrase[toplist_not_rated]
<else />
<img src="$vboptions[bburl]/images/rating/toplist_rating_{$rating_image}.gif" alt="" />
<br />
$sr[votes]
<if condition="$sr[votes] == 1">
$vbphrase[toplist_vote]
<else />
$vbphrase[toplist_votes]
</if>
</if>
<if condition="!$show[guest]">
<br />
<a href="#" onclick="javascript:window.open('$vboptions[bburl]/toplist.php?do=rate&amp;id=$sr[id]','rate_site','menubar=0,resizable=1,width=$vbopti ons[toplist_popup_width],height=$vboptions[toplist_popup_height]');return false;">$vbphrase[toplist_rate_site]</a>
</if>
</td>


Close & Save the Toplist_1 template.

Open the Toplist_2 template.

FIND AND DELETE:

<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">2<else />1</if>" width="90">
<if condition="$sr[rating_average] == 0">
$vbphrase[toplist_not_rated]
<else />
<img src="$vboptions[bburl]/images/rating/toplist_rating_{$rating_image}.gif" alt="" />
<br />
$sr[votes]
<if condition="$sr[votes] == 1">
$vbphrase[toplist_vote]
<else />
$vbphrase[toplist_votes]
</if>
</if>
<if condition="!$show[guest]">
<br />
<a href="#" onclick="javascript:window.open('$vboptions[bburl]/toplist.php?do=rate&amp;id=$sr[id]','rate_site','menubar=0,resizable=1,width=$vbopti ons[toplist_popup_width],height=$vboptions[toplist_popup_height]');return false;">$vbphrase[toplist_rate_site]</a>
</if>
</td>


That should delete it.

ok question i went in to delete a site and after i deleted it from the toplist.php page i got this error... what would cause that?

Warning: unlink(images/toplist/buttons/sites/forumhome_todayusers): No such file or directory in /delete_site.php on line 105

also the site never had a button i never added one..
You can ignore that. But, I'm not sure why its trying to delete a file called forumhome_todayusers. Did you modify anything?

[DementedMindz]

Nope not at all... Im not sure why it was either i even tried it on my test board and it did the same thing... It does it mostly when you dont add a image(button) for the site...

[derekivey]

Just ignore it for now. It won't cause any problems. If you want to prevent it from being shown, open delete_site.php and go to line 105, and put a @ in front of unlink.

Derek

[Domenico]

Many thanks for your support Derek!

[puregraf]

Please login to PHPMyAdmin, and delete all of the toplist_ tables, as well as the toplistpermissions column in the usergroup table (Do not delete the table itself!), and try the import again.

Derek


I did what you said and i guess it worked, but not all the way. look on the left on the menu where the toplist is supposed to be, there is a new module there but its blank..

heres a screenshot of my admin after i imported the file from my comp manage products / import producthttps://vborg.vbsupport.ru/

[derekivey]

Many thanks for your support Derek!
No Problem.

I did what you said and i guess it worked, but not all the way. look on the left on the menu where the toplist is supposed to be, there is a new module there but its blank..

heres a screenshot of my admin after i imported the file from my comp manage products / import producthttp://puregraffiti.com/pg2/topsites_screenshot.jpg
Looks like it didn't import the phrases. Go to Languages & Phrases, and do a search for toplist, and see if any come up.

Derek

[puregraf]

No Problem.


Looks like it didn't import the phrases. Go to Languages & Phrases, and do a search for toplist, and see if any come up.

Derek

No Phrases Matched Your Query
:paranoid:


I clicked on one of the blank spaces on the module on that screenshot i posted above and it took me to a page were it had this error:

Database error in vBulletin 3.5.4:

Invalid SQL:
SELECT * FROM toplist_sites WHERE status = 'inactive';

MySQL Error : Table 'puregraf_peegee.toplist_sites' doesn't exist
Error Number : 1146
Date : Thursday, June 22nd 2006 @ 09:35:34 PM
Script : http://www.puregraffiti.com/graffiti-space/admincp/toplist_admin.php?do=massdelete
Referrer : http://www.puregraffiti.com/graffiti-space/admincp/
IP Address : 71.137.37.85
Username : puregraffiti
Classname : vb_database

Thanks for your help.

[derekivey]

Doesn't look like it is importing correctly for you, for some reason. If you would like, I will try importing it for you. If you want me to, please PM me admin info.

Thanks,
Derek

[Michael_Tree]

I can't change the usergroups permission, there is no box in usergroups :S

[derekivey]

Make sure you uploaded all of the files. It should be there if all of the files were uploaded.

Derek

[bigM]

hi,

when I add a new site, there is no banner / button shown to me. I think the script can't upload any pictures to my webspace / ftp...

Can anybody help me, please?

Thanks in advance!

bigM

[Michael_Tree]

thanks! I had something uploaded wrong :P

[puregraf]

Doesn't look like it is importing correctly for you, for some reason. If you would like, I will try importing it for you. If you want me to, please PM me admin info.

Thanks,
Derek

thanks, i sent a pm;)

[Michael_Tree]

Hey again...

Now it seems to work just fine,but when I click on my "in link", it loads a blank page :-(

Maybe you know whats up?

[derekivey]

hi,

when I add a new site, there is no banner / button shown to me. I think the script can't upload any pictures to my webspace / ftp...

Can anybody help me, please?

Thanks in advance!

bigM
What happens? Do you get a blank page or something?

[derekivey]

Hey again...

Now it seems to work just fine,but when I click on my "in link", it loads a blank page :-(

Maybe you know whats up?
Did you remember to set the In url under Toplist Settings?

[Michael_Tree]

Well, it asks for a "In Redirect URL", but that it's not even taking me there. What do you suggest I make it?

[derekivey]

Pm me the URL to the toplist, along with admin info, and I will take a look at it.

Thanks,
Derek

[Macktr]

Get Off in.php is renewing continuous???

[derekivey]

You need to set the In URL setting under Toplist settings.

Derek

[Ski-Whiz]

Another bug, when you give a usergroup permission to edit they can bypass the validation. Instead of clicking the validate link to check if the backlink exist they can simply click edit and save and the link is posted in the toplist. Can this be fixed?

Also when I turn on site moderation and then validate the user, the user still gets the message (when clicking validate) that the moderator needs to validate the link first. So the site is validated by me but the user still gets this message and can't validate his site (backlink).


I have this issues as well.... When a member submits a site, it get's approved in the "inactive sites" area. (It then moves to the Toplist Sites). The member should now to to the Topsite "homepage" and hit validate to let the admin that they have the banner up. Well, even though it's approved, he gets a message saying it isn't.

Also, if they edit their listing before it's validated, it will bypass the validation.

These (bugs) are both easily found..

[Ski-Whiz]

Ok, I found the validation issue.

In addsite.php

find:

if ($vbulletin->options['toplist_moderate_sites'] == 0)

Replace with:

if ($vbulletin->options['toplist_moderate_sites'] == 1)

Hope this helps.. It was a typo..

[derekivey]

Thanks. I am aware of those bugs and will update the files shortly.

Thanks,
Derek

[derekivey]

Ok here are the fixes. Just upload the attached files and overwrite the old ones. I have also updated the zip file to include these changes.

Derek

[Ski-Whiz]

Thanks!!!

I didn't know how much time ya had, so I posted a fix for the validate bug.. Hope you didn't mind?

[derekivey]

NP. I actually removed that code in the update because I realized that it wasn't really needed. I'm not sure why I added it in the first place lol.

Derek

[puregraf]

Hi. A webmaster added his site to my toplist, and i went to his site, and clicked on the image to test my toplists and the page keep reloading and would not load and take me to the toplists, is there something wrong with the code it generated? or i dont know can you help, thanks

[puregraf]

Hi. A webmaster added his site to my toplist, and i went to his site, and clicked on the image to test my toplists and the page keep reloading and would not load and take me to the toplists, is there something wrong with the code it generated? or i dont know can you help, thanks

[derekivey]

Make sure you set the In Redirect URL setting. That is probably why this is happening to you.

Thanks,
Derek

[Mr.D]

When will this hack be ported to 3.6.0

[derekivey]

Should work fine on 3.6.

[Mr.D]

It Works Very good

[Mr.D]

Any news when will new version be out?

[sab2000sab]

My scrolling images on Forum home disappeared.. and they are on in the ACP.. any ideas?.. They stopped working and I didn't even make any changes.. lol ???

Thanks..

[Sean James]

can this script use banners say 400x60?

[derekivey]

Any news when will new version be out?
I don't have an ETA at this time.

My scrolling images on Forum home disappeared.. and they are on in the ACP.. any ideas?.. They stopped working and I didn't even make any changes.. lol ???

Thanks..
Did you edit the forumhome template at all?

can this script use banners say 400x60?
Yes, just change the max size in the settings. You might have to edit the templates to rearrange stuff to make it look better too.

Derek

[sab2000sab]

Did you edit the forumhome template at all?

Nope.. I wasn't even logged into the ACP.. I had added 3 links with buttons.. and after I added the 4th.. they did not show up anymore. The number of buttons it shows on the forumhome was set to 10. I tried deleting the 4th link I put in, just in case... but that didn't help.

Thanks...

[derekivey]

Can you PM me admin info and the board url so I can take a look?

Thanks,
Derek

[kall]

Errors in the install.xml causing 'duplicate entry' errors in sql:

<setting varname="" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>1</defaultvalue>
</setting>
<setting varname="toplist_email_new_validation" displayorder="120">
<datatype>free</datatype>
<optioncode>yesno</optioncode>
<defaultvalue>0</defaultvalue>
</setting>

That empty named one shouldn't be there.. right?

[derekivey]

Thanks for reporting that kall. Yeah for some reason my vBulletin keeps exporting a blank setting, I'm not sure why. I will edit the zip file and remove it.

Thanks,
Derek

[kall]

No problem Derek.. my Style Manager keeps throwing up incompletely-loaded templates, so your vB's not the only one being odd. :)

(1am, I had no idea how to fix it.. 12PM, things were a bit more awake. :) )

[derekivey]

Ok, I fixed it. Here there was a blank setting in my setting table attached to my product. Hopefully it won't add it to the XML file now that I deleted it from the database.

Thanks again :).

Derek

[category]

How you Edit each usergroup's permissions

[category]

never mind got it =) just didnt understand the manual

[Sean James]

how do u remove the random sites? i tried doing it via templates but it didnt work

[derekivey]

how do u remove the random sites? i tried doing it via templates but it didnt work
Should be in the "Toplist" template. I will probably add a setting to disable them in the next version as well.

[Sean James]

Should be in the "Toplist" template. I will probably add a setting to disable them in the next version as well.
I have tried this and it still shows :( only removes the category header.

It is a good idea for the random section, but makes the site too wide for what i am trying to do.
http://www.eliteironbodybuilding.com/forum/toplist.php

[Mr.D]

i found a bug when you let unregistered people to add banners they cant it redirects them to a login page and i set in usergroup that they can can you fix that.

[derekivey]

@Griffin80: try removing the following code from the "Toplist" template...


<br /><br />
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr align="center">
<td class="tcat" colspan="7">{$vbphrase['toplist_random_site']}</td>
</tr>
<tr align="center">
<td class="thead" width="20">$vbphrase[toplist_rank]</td>
<td class="thead">$vbphrase[toplist_site_name_and_description]</td>
<if condition="$vboptions[toplist_show_user_banners] == 1">
<td class="thead" width="88">$vbphrase[toplist_button]</td>
</if>
<td class="thead" width="50">$vbphrase[toplist_in]</td>
<td class="thead" width="50">$vbphrase[toplist_out]</td>
<td class="thead" width="50">$vbphrase[toplist_views]</td>
<td class="thead" width="90">$vbphrase[toplist_rating]</td>
</tr>
<if condition="$randchk >= 1 || $num_rows >= 1">
<tr align="center">
<td class="alt2">$rand_rank</td>
<td class="alt1"><a href="$vboptions[bburl]/out.php?id=$randsite[id]" target="_BLANK">$randsite[name]</a><br />$randsite[description]<br /></td>
<if condition="$vboptions[toplist_show_user_banners] == 1">
<if condition="$randsite[imagecode] != ''">
<td class="alt2" width="88"><a href="$vboptions[bburl]/out.php?id=$randsite[id]" target="_BLANK"><img src="$vboptions[bburl]/toplist_image.php?do=view&amp;id=$randsite[id]" border="0" alt="" /></a></td>
<else />
<td class="alt2" width="88">$vbphrase[toplist_none]</td>
</if>
</if>
<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">1<else />2</if>" width="50">$randsite[in]</td>
<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">2<else />1</if>" width="50">$randsite[out]</td>
<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">1<else />2</if>" width="50">$randsite[views]</td>
<td class="alt<if condition="$vboptions[toplist_show_user_banners] == 1">2<else />1</if>" width="90">
<if condition="$rating == 0">
$vbphrase[toplist_not_rated]
<else />
<img src="$vboptions[bburl]/images/rating/toplist_rating_$rating.gif" alt="" />
<br />
$randsite[votes]
<if condition="$randsite[votes] == 1">
$vbphrase[toplist_vote]
<else />
$vbphrase[toplist_votes]
</if>
</if>
<if condition="!$show[guest]">
<br />
<a href="#" onclick="javascript:window.open('$vboptions[bburl]/toplist.php?do=rate&amp;id=$randsite[id]','rate_site','menubar=0,resizable=1,width=$vbopti ons[toplist_popup_width],height=$vboptions[toplist_popup_height]');return false;">$vbphrase[toplist_rate_site]</a>
</if>
</td>
</tr>
<else />
<tr align="center">
<td class="alt1" colspan="7">$vbphrase[toplist_none]</td>
</tr>
</if>

<tr align="center">
<td class="thead" colspan="7"><div class="smallfont">
&nbsp;
</div>
</td>
</tr>
</table>


@Mr.d: I think I manually added print_no_permission() calls in the files for usergroup 1. Try removing those.

[Mr.D]

oknow works i have removed it. Will you fix the files in next update

[Sean James]

thx derekivey work perfectly. Realised what i was overlooking now after seeing your code lol

[derekivey]

No Problem :)

[Mr.D]

Any news when will some updates be?

[derekivey]

Not sure yet. I just got home from vacation yesterday, and have been really busy catching up on everything, and I am also trying to finish my bug tracker which I'll be using to help keep track of bugs for all of my hacks (I am probably going to be starting a site for all my hacks soon). I hope to get the next version out by the end of the week, but I can't make any promises, it just depends how busy I am.

Thanks,
Derek

Derek

[Mr.D]

If you can make features for this script like this script have i tell you it would be script of the month. Take a look of this script for top list
http://www.cjultra.com/ basically the admin can create custom templates and then he can put a shell for toplist for say 1 to 20 and then show 20-40 on the footer.

here is a readme file that you can read if someone is agreeing with me please reply



50593

[derekivey]

Version 1.0.9 will be released either tomorrow or Friday hopefully. I am adding a reset feature where you can reset each sites out/in/views to 0 and basically start over. This has been requested by many of you so that you can give newer people a chance to get higher ranks. I am also in the process of cleaning up the code, and removing a few un-needed queries, so that should help speed things up, and help with performance. Also, it will have settings to disable the random site feature, ranks, descriptions, in hits, out hits, views, and ratings. Please reply back if you would like to see anything else in this version, I will try to add it if time permits, so that I can stick with releasing this tomorrow or Friday.

Thanks,
Derek

[Mr.D]

Can you add textlink to be displayed in forum home and not just banner?

[derekivey]

I'll try. Where do you want it to be at on the forum home?

Thanks,
Derek

[dendrob]

One thing I'd really, really like to see is an option to enable which HTML code you'd like the listed sites to use. I find myself editing the templates (which is a bit confusing) hiding 4 of 5 HTML codes, becaue I want all the users to list the same HTML code, without giving then an option to use 1 of 5.

I hope you know what I mean.

[Mr.D]

I'll try. Where do you want it to be at on the forum home?

Thanks,
Derek


in whosonline like the buttons

[derekivey]

One thing I'd really, really like to see is an option to enable which HTML code you'd like the listed sites to use. I find myself editing the templates (which is a bit confusing) hiding 4 of 5 HTML codes, becaue I want all the users to list the same HTML code, without giving then an option to use 1 of 5.

I hope you know what I mean.
That setting disables them from using html code in their descriptions. Thats basically all it does.

Derek

[derekivey]

in whosonline like the buttons
Scrolling or not scrolling?

[Mr.D]

Scrolling or not scrolling?
No scroling

[DS MrSinister]

No scrolling plz

[derekivey]

How many should it show? Should they be random ones or how should it determine which ones to show?

[derekivey]

I still have a little bit to finish on the reset system so I am pushing the release date for version 1.0.9 back to tomorrow. Sorry for the delay.

Derek

[Mr.D]

How many should it show? Should they be random ones or how should it determine which ones to show?
Well let them be in order or make a admin setting how should we want them to be orderd by?

[dwbro1]

Sorry if I missed this in the threads somewhere, but is it possible to add a random link to the thread list display in the forums? Basically, I'd like to add this to maybe the footer of each page or inbetween threads.

[sab2000sab]

Could someone please explain to me how the Dynamic link thing works.. I don't understand..

thanks!

[derekivey]

Version 1.0.9 has been released. The changes include:

Optimized/Cleaned Up Code
Added setting to disable random sites
Added Reset Toplist Feature
Fixed many bugs
Look in the readme file for instructions on how to install or upgrade.

Please let me know if you have any problems with this.

Derek

[derekivey]

Sorry if I missed this in the threads somewhere, but is it possible to add a random link to the thread list display in the forums? Basically, I'd like to add this to maybe the footer of each page or inbetween threads.
Not yet, but I am working on that for the next version.

Could someone please explain to me how the Dynamic link thing works.. I don't understand..

thanks!
You mean the dynamic image? If so you can find a how to on how to edit it here (https://vborg.vbsupport.ru/showpost.php?p=885450&postcount=450).

[loonytune15]

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/monster/public_html/forums/toplist.php(557) : eval()'d code on line 54


got that after upgrading..

also now there is no sites in the list..

[---MAD---]

hmm, ill wait to see why you got that before I upgrade ;)

[derekivey]

What page do you get that on?

[trackpads]

thanks!

[loonytune15]

the main toplist page

[chriszep]

hello just installed last version successfully
I can create category etc... but when I put a website
the categorie where it is show a blanck page
I delete the website , i can see the category
any idea ?
the folder to upload pics is 777

[derekivey]

loonytune15, and chriszep, can you guys send me a link to your sites so I can take a look at these and try to find out whats wrong?

Thanks,
Derek

[Mr.D]

Any news about text links on forum home or all vbulletin

[dendrob]

How about RSS feed as a new feature down the raod. Top 10 ??? I know you have enough features to work on, so leave it for later ;)

[derekivey]

@ Mr. D sorry, I haven't had time to work on it, I will get it done ASAP.

@ dendrob sounds like a good idea, I might add that.

[Snake]

derek, are you planning to release a newer version soon or shall I just install it now?

[Snake]

derek, are you planning to release a newer version soon or shall I just install it now?

[derekivey]

Just go ahead and install, the new version won't be out for atleast a week.

Derek

[loonytune15]

<a href="http://www.monster-designs.com/forums/toplist.php" target="_blank">http://www.monster-designs.com/forums/toplist.php</a>

[derekivey]

http://www.monster-designs.com/forums/toplist.php
I will take a look. It looks like it's a problem with the Toplist_1 template. I will look into it now and get back to you.

Derek

[Shazz]

I updated the toplist..
I read the fixes. You can't notice them can you?
________
Dodge 400 specifications (http://www.dodge-wiki.com/wiki/Dodge_400)

[derekivey]

Make sure you have reverted any customized Toplist templates. Much of the new stuff in this release is just bug fixes, but I added a feature to allow you to reset the Toplist, and just added a setting to disable the random site feature on the Toplist page.

[loonytune15]

thanks..

not sure if the above post is directed at me but all my templates are the reverted..

[derekivey]

http://www.monster-designs.com/forums/toplist.php
Can you PM me admin access info so I can take a look at the template and try to fix it?

Thanks,
Derek

[derekivey]

thanks..

not sure if the above post is directed at me but all my templates are the reverted..
That post was directed to Shazz. Sorry about the confusion.

Derek

[Snake]

Okay I have installed it now and it seems to work just fine. Thank you!

Oh also I would like to request one thing. Could you change the URL to the toplist and have it as a diretory like "domain.com/toplist/index.php" instead of "domain.com/toplist.php" in the next release? I think that would be much better. :)

[derekivey]

Okay I have installed it now and it seems to work just fine. Thank you!

Oh also I would like to request one thing. Could you change the URL to the toplist and have it as a diretory like "domain.com/toplist/index.php" instead of "domain.com/toplist.php" in the next release? I think that would be much better. :)
You can probably use mod_rewrite to do that, I will take a look when I get some time. Also I'm hoping on adding SEO to the next version so that will either change the directory or use mod_rewrite to make it look like it's in a directory.

Derek

[loonytune15]

So any idea on why my toplist is stuffed??

[Carsten77]

Hi Derek,

I just installed the new version and it works finde but 1 question.

i want to turn on the Toplist Cache in Forumhome, but when i activate it its in the middle an i want it after upcoming events what have i to do to realise it.

just found this in the plugins:



if ($vbulletin->options['toplist_show_forumhome_images'] == 1)
{
$globaltemplates = array_merge($globaltemplates, array('Toplist_Forum_Home', 'Toplist_Sites_Code'));
}


????

any idea??

[derekivey]

So any idea on why my toplist is stuffed??
Can you PM me admin access info so I can take a look at the template and try to fix it?

Thanks,
Derek
Still didn't get a PM from you with admin access.

Derek

[derekivey]

Hi Derek,

I just installed the new version and it works finde but 1 question.

i want to turn on the Toplist Cache in Forumhome, but when i activate it its in the middle an i want it after upcoming events what have i to do to realise it.

just found this in the plugins:



if ($vbulletin->options['toplist_show_forumhome_images'] == 1)
{
$globaltemplates = array_merge($globaltemplates, array('Toplist_Forum_Home', 'Toplist_Sites_Code'));
}


????

any idea??
Edit the FORUMHOME template, and put <!-- Toplist --> right after the </if> for the upcoming events code.

Then, edit the plugin called Toplist Forum Home Addon.

Find:
$find = '<!-- end logged-in users -->';

Replace With:
$find = '<!-- Toplist -->';

Save the plugin.

Derek

[DementedMindz]

wow what happen to this it use to be Valid XHTML 1.0 now it has like 60 errors i think it maybe a easy fix im lookin at it now i know you have a extra </if> somewhere

[DementedMindz]

ahh i see something is messed up cause this shows up... Delete Site ] to everyone

[DementedMindz]

Toplist_1 has a few errors in it... seems as you have </if> in a few wrong places that cut back 30 errors now for the other 30 lol

[derekivey]

I'll take a look...

Derek

[derekivey]

Ok sorry about that heres the fix...

Open Toplist_1.

Find:
[ <a href="$vboptions[bburl]/delete_site.php?id=$sr[id]"></if>

Replace With:
[ <a href="$vboptions[bburl]/delete_site.php?id=$sr[id]">

There are 2 instances of this so be sure to replace both of them.

Derek

[DementedMindz]

yeah i fixed that but im still showing 30 errors now im tryin now to figure out where the other ones are

[DementedMindz]

ok in Toplist_1 you have this

[ <a href="$vboptions[bburl]/delete_site.php?id=$sr[id]">$vbphrase[toplist_delete_site]</a> ]
</if>
</if>


it should be this

[ <a href="$vboptions[bburl]/delete_site.php?id=$sr[id]">$vbphrase[toplist_delete_site]</a> ]
</if>

[loonytune15]

Still didn't get a PM from you with admin access.

Derek

Sorry must of missed that post.

Pm sent.

[derekivey]

ok in Toplist_1 you have this

[ <a href="$vboptions[bburl]/delete_site.php?id=$sr[id]">$vbphrase[toplist_delete_site]</a> ]
</if>
</if>


it should be this

[ <a href="$vboptions[bburl]/delete_site.php?id=$sr[id]">$vbphrase[toplist_delete_site]</a> ]
</if>
My fix shold have done it because it was transitional as soon as I removed the extra if.

[DementedMindz]

question how do we move Report to a line under the description? cause right now its showin up right after the description...

[derekivey]

Shouldn't be on the same line as the description, but you can try adding a <br /> before the code in the Toplist_1 template.

[DementedMindz]

ok ill try that now thanks for the fast reply

[DementedMindz]

that made a huge space on top.. i have the random site shut off too if that helps..
what is happening is if there description is short it keeps it on the same line as the description

[derekivey]

Did this start happening after you deleted some of those </if>'s?

[DementedMindz]

i reverted my templates so i only delete the ones you said to

[egyptsons]

I wish if you do a Top list hack for threads
and also by Members voting

[derekivey]

I wish if you do a Top list hack for threads
and also by Members voting
What do you mean? I don't really understand... can you please clarify?

Thanks,
Derek

[King Kovifor]

What do you mean? I don't really understand... can you please clarify?

Thanks,
Derek

Derek,

I think him means Top Threads (using ratings)!

[egyptsons]

What do you mean? I don't really understand... can you please clarify?

Thanks,
Derek
Thanks Derek for your reply, sorry for my language.
I mean the same way for sites but for theards, Like every member writ a theard put the link in the toplist then one button appear in his theard automatically to let other members or visitor to vote;)

[derekivey]

Ok, I will see about adding it. Sounds like a good feature.

Derek

[Lena Starling]

I transferred my board from one domain to another and while trying to reinstall the Toplist hack I get this error:

MySQL Error : Table 'toplist_ratings' already exists


And yes, I do have the "Overwrite" option selected. : ( Any suggestions on how to fix this error? If you know, please try to give me clear instructions. Thanks!

[derekivey]

If you just transfered everything, you shouldn't have to reinstall the Toplist itself. If you want to do a fresh install, just delete the product, and delete any Toplist_ tables that vB's product manager left, and import the XML file again to install.

Derek

[Lena Starling]

The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?

[Izza]

After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column.

I have set the toplist up on our test site which works flawlessy .

Any ideas whats going wrong?


the database error I get is


Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '5000000',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '150',
`avatarmaxsize` = '200000',
`toplistpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'toplistpermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 08:48:09 PM
Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php
Referrer : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : ********
Username : ********
Classname : vb_database

[derekivey]

The hack was actually uninstalled during the move, it's just those tables stuck around...

How do I remove the tables?
Execute the following code in PHPMyAdmin...

DELETE TABLE IF EXISTS toplist_categories;
DELETE TABLE IF EXISTS toplist_clicks;
DELETE TABLE IF EXISTS toplist_ratings;
DELETE TABLE IF EXISTS toplist_reports;
DELETE TABLE IF EXISTS toplist_sites;

If you have a table prefix, don't forget to add that to each of the lines above.

After that has been done, reinstall the Toplist hack and let me know if you have anymore problems.

After installing the toplist hack. I am unable to set permissions . I get a database error.
Having looked in the database I have no toplist permissions column.

I have set the toplist up on our test site which works flawlessy .

Any ideas whats going wrong?


the database error I get is


Database error in vBulletin 3.5.4:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<span style=\"color: red;\">',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`forumpermissions` = '1048575',
`attachlimit` = '5000000',
`pmquota` = '500',
`pmpermissions` = '3',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions` = '205520831',
`genericoptions` = '31',
`profilepicmaxwidth` = '120',
`profilepicmaxheight` = '150',
`profilepicmaxsize` = '200000',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '150',
`avatarmaxsize` = '200000',
`toplistpermissions` = '1'
WHERE usergroupid=6;

MySQL Error : Unknown column 'toplistpermissions' in 'field list'
Error Number : 1054
Date : Sunday, July 23rd 2006 @ 08:48:09 PM
Script : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php
Referrer : http://www.iz-grafix.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : ********
Username : ********
Classname : vb_database
Looks like the product installer didn't add the column to the usergroup table.

Execute the following SQL in PHPMyAdmin.

ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL;

Be sure to add your table prefix to that if you have one.

Derek

[Izza]

Thanks for the quick reply though it didn't fix my problem.

After running the query I got this error

Error
SQL query:

ALTER TABLE usergroup ADD toplistpermissions INT( 10 ) UNSIGNED DEFAULT '0' NOT NULL ;

MySQL said:

#1060 - Duplicate column name 'arcadepermissions'

[derekivey]

Hmm, thats weird. Can you open PHPMyAdmin, and see if there are two columns called arcadepermissions, and see if the toplistpermissions column is there at all?

Thanks,
Derek

[Izza]

I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.

What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not.

https://vborg.vbsupport.ru/

[Dj. Gargamel]

Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record

we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ??

[derekivey]

I don't have more than one arcadepermissions table and still don't have a toplistpermissions table either.

What I did see was this below, should I have multiple index files?, the error at the bottom makes me think not.

http://www.iz-grafix.co.uk/mt/arcadepermissions.gif
Don't worry about indexes... Click structure at the top to see if they are there.

Hello Derek - today I noticed we are having another problem - few days ago I have installed the newest version of mod - our toplist is using ranking method by views - today I saw that one user was raising the counter views continously within 5 min - of course his site was raising up in the toplist also I looked closely to other sites and noticed that there is second site with very strange views record

we are having counts form guests disabled, there is a Limit The Number Of Clicks Out For Each User and it is set to 1, we also turn on Limit The Number Of Clicks In For Each IP Address - so why this not situation is going on - maybe this option are only for In Hits and Out Hits ??
Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

Derek

[Dj. Gargamel]

Yeah those options are only for clicks in and out. Maybe I should add a setting to either count uniques or count all page views. I can probably make it so when it's set to uniques, have it only count them once in a certain time period (say 1 day or what ever). What do you think?

DerekIt would be perfect -
I would like to ask how is views ranking method counted - is it summary of in out and views ??

thanks again for such fantastic support

[gamelandz]

How do I change the look of the list? I want to remove the in and the out column?

[gamelandz]

why are the words "Delete Site ]" showing up in my description? I am not logged in and unregistered users can't delete listings

[ProjectCamaro]

It works but I get this error at the top of the forum:


Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/u1/projectcamaro/html/forum/toplist.php(555) : eval()'d code on line 54

Parse error: syntax error, unexpected '"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/u1/projectcamaro/html/forum/toplist.php(555) : eval()'d code on line 54

[derekivey]

It would be perfect -
I would like to ask how is views ranking method counted - is it summary of in out and views ??

thanks again for such fantastic support
No, it's the page views, the number of views in the views column, that includes all out hits to that site, as well as page views that are counted if the site owner adds the tracking code to their site.

How do I change the look of the list? I want to remove the in and the out column?
You would have to edit the Toplist, Toplist_1, and Toplist_2 templates to remove those.

why are the words "Delete Site ]" showing up in my description? I am not logged in and unregistered users can't delete listings
Did you try the fix in this post (
https://vborg.vbsupport.ru/showpost.php?p=1033169&postcount=945)?

It works but I get this error at the top of the forum:
Try the fix I mentioned above...

[ProjectCamaro]

Try the fix I mentioned above...

Thank you, that fixed it. :cool:

[derekivey]

Thank you, that fixed it.

No Problem :)

[DementedMindz]

derek i just thought of something that might be nice... say you dont allow buttons or banners on your toplist via admincp maybe have it where when you shut that setting off and it will shut it off on addsite cause if you shut it off right now it still shows on addsite... also whats the biggest banner size you would recommend?

[derekivey]

I will add that to the next version. I recommend small banner sizes because if you did big ones, you would probably have to modify the templates so they would fit better, but the size is entirely up to you.

Derek

[ProjectCamaro]

Quick question. I have the marquee at the bottom of the forum right now and I have two questions. Is there a way to make it when someone clicks on one of the banner's at the bottom that it'll open the link in a new window instead of the same one and is there a way to change the text right above the marquee that says "Toplist Sites:" to something unique?
Thank you again, it's working great for me.

[derekivey]

1) Yes, edit the Toplist_Forum_Home template (I think it's called that).
2) Yes, search for that phrase in vB's phrase manager and put something in for the English translation field.

Derek

[hilfe-forum]

Hi can you help me?

i get this error:

Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/www1/rechner2/wwwneu/vbulletin/toplist.php(555) : eval()'d code on line 54



Line 54 is: <if condition="$sr['votes'] == 1">


it?s the original Temlate

vB Ver. = 3.5.3

[derekivey]

Hi can you help me?

i get this error:

Parse error: parse error, unexpected '\"', expecting T_STRING or T_VARIABLE or T_NUM_STRING in /var/www/www1/rechner2/wwwneu/vbulletin/toplist.php(555) : eval()'d code on line 54



Line 54 is: <if condition="$sr['votes'] == 1">


it?s the original Temlate

vB Ver. = 3.5.3
Try this... https://vborg.vbsupport.ru/showpost.php?p=1033169&postcount=945

[ProjectCamaro]

1) Yes, edit the Toplist_Forum_Home template (I think it's called that).
2) Yes, search for that phrase in vB's phrase manager and put something in for the English translation field.

Derek

Ok I was able to get the phrase changed with no problem. What do I edit in that template to make the links open in new window's? Sorry I'm really not the best at this as you can tell.

[derekivey]

Sorry wrong template... The template you need to edit is Toplist_Sites_Code.

Find:
<a href="$vboptions[bburl]/out.php?id=$timage[id]">

Replace With:
<a href="$vboptions[bburl]/out.php?id=$timage[id]" target="_blank">

Not sure why I didn't make it open in a new window but that will be included in the next version.

Derek

[derekivey]

BTW guys, When I release the next version, I will have it for 3.5 and 3.6.

Derek

[gamelandz]

Did you try the fix in this post"]https://vborg.vbsupport.ru/showpost.php?p=1033169&postcount=945]post[/url]?

that worked....thanks a million

[derekivey]

No Problem :).

[Shazz]

BTW guys, When I release the next version, I will have it for 3.5 and 3.6.

Derek
W00t!@

*adds it to the list
________
Toyota TF106 history (http://www.toyota-wiki.com/wiki/Toyota_TF106)

[derekivey]

You should be able to use the current version on 3.6, I haven't found any problems so far.

Derek

[ambrosious]

i have just updated this script to the latest version, but when i edit the usergroup pemissions i get this error:



Thanks

I get the same error, do not know where to look to solve it, anyone got any ideas?

[ambrosious]

Nevermind, fixed.

[ProjectCamaro]

Sorry wrong template... The template you need to edit is Toplist_Sites_Code.

Find:
<a href="$vboptions[bburl]/out.php?id=$timage[id]">

Replace With:
<a href="$vboptions[bburl]/out.php?id=$timage[id]" target="_blank">

Not sure why I didn't make it open in a new window but that will be included in the next version.

Derek

Awesome, works perfectly!! Thank you for the help, it's now setup just the way I personally like it for my website so I'll leave you alone now. :D

[derekivey]

Awesome, works perfectly!! Thank you for the help, it's now setup just the way I personally like it for my website so I'll leave you alone now. :D
No Problem :)

[Clyde1967]

I am having problems with images displaying for toplist.All the settings appear to be correct but they wont display,also my avatars are not displaying as well.Any help would be much appreciated.

[loonytune15]

I have a suggestion for the next release..

On the Forumhome where it says "Toplist:" , can we have after that how many sites are in the toplist, and have the word toplist, able to be linked to the toplist?

[ZeroX Prodigy]

Great modification Derek! Works perfectly, and can't wait for the next versions!

[derekivey]

I am having problems with images displaying for toplist.All the settings appear to be correct but they wont display,also my avatars are not displaying as well.Any help would be much appreciated.
Not sure about your avatars, because this doesn't mess with user's avatars, but can you PM me a link to your site so I can take a look at the toplist?

I have a suggestion for the next release..

On the Forumhome where it says "Toplist:" , can we have after that how many sites are in the toplist, and have the word toplist, able to be linked to the toplist?
Sounds good, I will include that in the next release.

Great modification Derek! Works perfectly, and can't wait for the next versions!
Thanks, I appreciate the feedback :).

[gamelandz]

ok here are my problems: I did a fresh install and this is what is happening:

1. View my toplist (http://www.gamelandz.com/toplist.php)
2. when a registered user ads a ad.....how do they edit it? (i hve permissions set that they can edit)

what do i do?

[derekivey]

What happens when they try to edit? Or is the link not showing?

[gamelandz]

the link is not showing