Toplist Hack

[Slynderdale]

This isnt the same as Dj'Sap's toplist scripted, i scripted my own, i do give him credit for the original and giving me the idea to make my own, my toplist has alot of cool features and easy to use.
It let members add one site only to the toplist where only other members can vote for it, the site with the most votes get higher on the list.

Members can only vote once a day though.
Members can also add a banner and image button if they want
People can click on the banner or button and will be taking to a page with the code to add the banner or button to there site to link them to the toplist to vote.
Theres 2 ways to vote:
1. go to the toplist and click vote on the site
2. Theres two kinds of links, one brings you to the toplist and automaticly vote for you and the other automaticly vote for you but brings you to the site you voted for

You have to sign up on the forums to vote

It keeps track on how many total an d daily ins (votes) and outs

Admins can see a specail edit and delete link next to the vote link, admins can delete any site and edit almost every thing about it, including url, description, title, button and banner url, total and daily ins and outs.

Admins are allowed to add more then one site

People can choose from a drop down menu on how many toplists get showed on there screen, the default is 50, you can choose from 10,25,50,75,100 and all, you can esily add more if you want.

Some screens shots are in the zip file.


Heres a live demo: http://www.gods-network.com/forums/toplist.php

Also screen shots are posted in posts below

[Slynderdale]

Heres what the main toplist page looks like.

[John]

Looks good :)

[Slynderdale]

Originally posted by JohnWarwick
Looks good :)

thanks :)

[ExcErr]

can i have a working demo?

[Slynderdale]

i just fixed a small bug, its nothing major, i updated the zip

if you already downloaded it, in toplist.php find in the show button code section:

$button="<a href=\"toplist.php?action=in&topid=$topid\" target=\"_blank\"><img src=\"$buttonurl\" border=0 height=33 width=88 alt=\"$siteurl\"></a>";


and replace it with:

$button="<a href=\"$bburl/toplist.php?action=in&topid=$topid\" target=\"_blank\"><img src=\"$buttonurl\" border=0 height=33 width=88 alt=\"$siteurl\"></a>";


find in the show banner code section:

$banner="<a href=\"toplist.php?action=in&topid=$topid\" target=\"_blank\"><img src=\"$bannerurl\" border=0 height=60 width=468 alt=\"$siteurl\"></a>";


and replace it with:

$banner="<a href=\"$bburl/toplist.php?action=in&topid=$topid\" target=\"_blank\"><img src=\"$bannerurl\" border=0 height=60 width=468 alt=\"$siteurl\"></a>";


i forgot to add the $bburl

[Slynderdale]

If any one wanna use it or edit it, heres a blue toplist button i made

[Neo]

Nice... but I think I will stick with my In-Link :)

[ZiRu$]

Thats great! I'll install it this weekend

[Slynderdale]

heres the admin edit screen

[Slynderdale]

the edit and delete option only shows up for the admins, as shown in the pic

[Slynderdale]

heres the menu where people can select how many to show

[Slynderdale]

I also have it so when you move your mouse over a site box area, the name of the site apears in your message bar and the background color changes to your secondaltcolor and when you move your mouse so its not on it any more, the color goes back to normal, also it also shows a test banner and button

[Slynderdale]

I have one request, if you install it on your forums, post or pm me the link and ill add it as a live demo for people, thank you and enjoyn the hack :)

[Harryli]

There is a wrong SQL statement I believe:

DROP TABLE IF EXISTS toplist_hitsin;
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
}

The } should be a ) I believe

[Slynderdale]

Originally posted by Harryli
There is a wrong SQL statement I believe:

DROP TABLE IF EXISTS toplist_hitsin;
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
}

The } should be a ) I believe

yea, your right, its a typo, i updated the zip above, ive been up for a couple days so im a little tired

[Harryli]

A couple of days are some days to much :D :D

Two questions: The "Button" for what is it used? As a small Banner? (Forgive me my bad english...)

And if I click "Show 25 sites" directly it gives a "site not found error".

[Harryli]

>for what is it used

Stupid me, found it out :D

[Slynderdale]

one last request, if you like the hack and gonna use it on your forums, please press the install button here to show your aprication, also you can receive updates on ant new relases for it, thanks :)

[Harryli]

Done :D

[Ornithopter]

I installed this bad boy...Great job man... This is a wonderful addition and fits very nicely into vB. Thanks for writing it.

Anywho, I can't give you a working demo because its on my test layout for now, but in a few days ^_~...

[Slynderdale]

Originally posted by Ornithopter
I installed this bad boy...Great job man... This is a wonderful addition and fits very nicely into vB. Thanks for writing it.

Anywho, I can't give you a working demo because its on my test layout for now, but in a few days ^_~...

thanks, im glad you like it :)

[Dark_Wizard]

Hmmm...I really like this. Do you have any issues with me making some changes? I would like to pull from the vblinks db/hack from Sisko.

[Slynderdale]

What changes? im open to ideas and suggestions, if you need any changes just ask and ill see what i can do :) also if you only want the changed just for your website, no problem, ill do sutom changes just for you :)

[Dark_Wizard]

I wanted to incorporate this with vblinks so the data doesn't have to be added again unless you want to write a script to pull the info from the vblinks db and import it to the toplist hack. Let me know.....

[GOD-Dblade]

http://www.gods-network.com/forums/toplist.php

:) looks hot as hell good job man

[Slynderdale]

Originally posted by GOD-Dblade
http://www.gods-network.com/forums/toplist.php

:) looks hot as hell good job man

thank you and thank you for the live demo :)

[GOD-Dblade]

no prob man :) keep up the good work

[rishel]

We got one error when trying to do a MySQL insert of the SQL databases: Any idea of what this means?

Error
SQL-query :

CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
)

DROP TABLE IF EXISTS toplist_settings

MySQL said:

You have an error in your SQL syntax near 'DROP TABLE IF EXISTS toplist_settings' at line 9

Back

[Slynderdale]

Originally posted by rishel
We got one error when trying to do a MySQL insert of the SQL databases: Any idea of what this means?

Error
SQL-query :

CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
)

DROP TABLE IF EXISTS toplist_settings

MySQL said:


You have an error in your SQL syntax near 'DROP TABLE IF EXISTS toplist_settings' at line 9

Back

run them one by one unless the what your using supports mutiple queries

[JagenSWPC]

Originally posted by Slynderdale


thanks :)
Sk, its me Gastly from AIM (Gastly4Ever)
Where do you get that FireFlyies run a query in admin control panel or how to you use phpmyadmin?

[Seby]

Hi there,

I have a suggestion for this addon, or maybe it is more of a request. Would it be possible to modify it so it also counts the visitors and pageviews of the sites? I mean they have to put a button on their site, and relying on how often it has been called from the webserver the script counts the hits. I like that kind of ranking more than ranking after clicks on the button since that only shows the "clicking mentality" of the users, not how frequently a site is visited.
I had a script that counted the pageviews and visitors (it was in perl) and it almost crashed my server cause of to many visitors, but maybe php/mysql could handle more hits that perl?

What do you say?
Thanks,
Sebastian

[Slynderdale]

good idea, ill add it

[Lesane]

It would be cool if the script automaticilly reset the toplist once in a while like once a week or XX amount of days.

[Seby]

Originally posted by Slynderdale
good idea, ill add it

Thanks a lot Slynderdale, I only have found non-free toplists that feature it and I dont have the money to pay for them. I am really looking forward to the release of the script ;)

Thanks,
Sebastian

[Twig Deez]

good work, slynderdale!

installed on my forums without a hitch.
once i get some sites submitted, i'll give you the link to use as a live demo, if you'd like.

one error: there's a td missing from toplistbit_nosites.
and a cosmetic change, i prefer to use {tablebordercolor} instead of {categorybackcolor},
in the main toplist template. but that's a personal preference.

but yeah, two thumbs up from me, man. :cool:

[Twig Deez]

sweet as.

http://www.shootemup.net/board/toplist.php?s=

[Slynderdale]

in toplist 2.0 which im gonna release in a day or two, theres a bug fix i found and im adding it so some one can add a banner to there page that records page views

[ceo_tfw]

can you let us know where the nav.gif is? when you click on the small button link to a members site to get code, the two buttons seem to be broken :)

[irn-bru]

Nice hack.

Make's a nice addon to any board...

[Slynderdale]

Toplist 2.0 should be done today or tomarrow, if you have any ideas or requests post them, if there good ill add them in 2.0

New Features of 2.0:

Members can add a image on there site that records daily and total page hits.

Admins can reset sites and set there stats all back to 0.

A random banner and button code that shows a random buttom or banner when the page refreshes and if you click on it, it counts as an out for that site and it takes you to that site.

A bug fix in the old version that if a site has over 10 votes some times its gets placed at the bottom or middle and ones wirh 5,6,7 and so on gets placed higher.

also an idea, an admin reset and delete all, if you wish these to be added, please post and tell me and tell me if you have any other ideas.

[Slynderdale]

Originally posted by ceo_tfw
can you let us know where the nav.gif is? when you click on the small button link to a members site to get code, the two buttons seem to be broken :)
i replaced all my > with a image instead of >, makes it look a little better and it matches my custom style i made, just change it to > and ill also attach the image if you want it.

[countryboy713]

What i was really looking forward to, if you can, is the page views count for votes. When they put my button on their page and it gets viewed, it counts as a vote.

Is this still possible?

[Slynderdale]

Originally posted by countryboy713
What i was really looking forward to, if you can, is the page views count for votes. When they put my button on their page and it gets viewed, it counts as a vote.

Is this still possible?

ill make it the way i have planned then when thats done ill edit it to how you want it and ill post it for you :)

[Seby]

thanks that you will implement the page views thing ;) Will be a great hack when done I think. Would be cool if you could make an option in the admin interface to choose wether you want a "voting" list of a "pageviews" list. So if people sign up they either get a vote image or an image that counts the pageviews.
Just an idea though.

Thanks,
Sebastian

[Princeton]

Some things just didn't make sense to me so I ....
Changed a few things:
permissions, I'm using only buttons I removed all references to banners, BUTTON CODE displays when in EDIT section only, added refferid to vote url {reciprocal link}, made the front page valid HTML, added a help section (actually this was already part of my site ... you never know), added a dialog box to confirm deletion.

Besides doing all these (personal) changes, I think you did a great job.:up: What would make this even better is the ability to count incoming hits site-wide. eg. no need to click on a vote url or a banner to count as a hit

You can check it out at total-impact.com (http://www.total-impact.com/forums/affiliate.php?action=in&topid=8&referrerid=1). Add your site if you like ... read the guidelines before you do.

[Seby]

so you gonna release the hack soon? I am waiting :D

[ULTIMATESSJ]

i got a proble while trying to run the query for this

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: DROP TABLE IF EXISTS toplist_hitsin;
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
)
mysql error: You have an error in your SQL syntax near ';
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_incremen' at line 1

mysql error number: 1064

Date: Friday 31st of May 2002 04:52:43 PM
Script: http://www.animexplosion.com/forums/forums/admin/query.php
Referer: http://www.animexplosion.com/forums/admin/query.php

[Slynderdale]

Originally posted by ULTIMATESSJ
i got a proble while trying to run the query for this

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: DROP TABLE IF EXISTS toplist_hitsin;
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
)
mysql error: You have an error in your SQL syntax near ';
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_incremen' at line 1

mysql error number: 1064

Date: Friday 31st of May 2002 04:52:43 PM
Script: http://www.animexplosion.com/forums/forums/admin/query.php
Referer: http://www.animexplosion.com/forums/admin/query.php
run the queries one by one with phpmyadmin, fire flies query in admin cp or another query tool

[Slynderdale]

Originally posted by Seby
so you gonna release the hack soon? I am waiting :D

soon, power went out all day today and yesterday and my mom just came out of the hospital, ive been a little busy, ive been working on the scripted though and adding alot of new stuff

[ULTIMATESSJ]

Originally posted by Slynderdale

run the queries one by one with phpmyadmin, fire flies query in admin cp or another query tool

isn't this just one query

DROP TABLE IF EXISTS toplist_hitsin;
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
)

[Slynderdale]

Originally posted by ULTIMATESSJ


isn't this just one query

DROP TABLE IF EXISTS toplist_hitsin;
CREATE TABLE toplist_hitsin (
inid int(11) unsigned NOT NULL auto_increment,
topid int(11) NOT NULL default '0',
accountid varchar(20) NOT NULL default '',
date varchar(20) NOT NULL default '',
PRIMARY KEY (inid)
)

no, 2

the drop table is one and the create table is one

[Seby]

Originally posted by Slynderdale


soon, power went out all day today and yesterday and my mom just came out of the hospital, ive been a little busy, ive been working on the scripted though and adding alot of new stuff

Thanks a lot Slynderdale ;) Keep up the great work!

Sebastian

[xug]

Thanks Slynderdale for this cool hack.

I do have one cosmetic bug and can't figure it out where the problem could be.

Maybe you can tell me what's wrong with my script.

The bottom links from vbulletin are messed up, take a look here :

http://www.xboxusersgroup.com/forums/toplist.php?s=

[techno]

Having a problem...

Seems like after a site gets a few votes, they are placed at the bottom of the list...hmmm :(

[Slynderdale]

Originally posted by techno
Having a problem...

Seems like after a site gets a few votes, they are placed at the bottom of the list...hmmm :(

im working on a fix for 2.0

[techno]

ok, thanks

[ManagerJosh]

Great Hack Slynderdale

Looking forward to version 2.0! How soon can we expect it?

[psychoxmonkee]

yah
how soon?

[X-Fan]

Cool hack! Will prove very popular with my site's members, I'm sure.

http://x-mencomics.com/xfan/forums/toplist.php?s=

[ManagerJosh]

Here is a patch to correct the sorting issue on the toplist. This corrects the sorting issue though I'm not sure what Slynderdale had in mind.

This addresses the problem earlier stated by Slynderdale:
A bug fix in the old version that if a site has over 10 votes some times its gets placed at the bottom or middle and ones wirh 5,6,7 and so on gets placed higher.

This patch adjusts settings in the MySQL so that it handles the sorting properly.

Be Sure to Back Up Your Database in case something happens.

Run the following MySQL query in PhpMyAdmin:
ALTER TABLE `toplist_sites` CHANGE `topid` `topid` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

After running the MySQL Query, log out of your Database, and view your TopList. It now sorts properly. In Version 2.0, I'm not sure what changes will be made to sort it properly, but hopefully what I did is what Slynderdale had in mind.

Enjoy!

[Andy R]

A couple of questions...

1. Can I run this script from a different domain on the same server? Instead of having it run on www.airstreamforums.com I would like to run it from www.airstreamsites.com. Kind of like how I have PhotoPost integrated @ www.airstreamphotos.com...

2. I have clicked on many of the demo links but they all seem to not be live anymore? Can you post a live demo link?

THANKS A TON FOR YOUR HARD WORK!!!

I look forward to installing this hack!

[psychoxmonkee]

yeah, if you have safemode off, you can include the directories USING THE FULL SYSTEM PATH: e.g. /usr/home/domain/www/toplist.php

[Robert Basil]

Added and running great. (With a few little code hacks)

http://www.sportbikeworld.com/toplist.php

[psychoxmonkee]

new version out yet???

[FleaBag]

Sweet hack, running well on 2.2.6 - thanks! :D

[Ninth Dimension]

/me clicks install

very good hack, any news on v2.0?

[Slynderdale]

Sorry about the hold up. my webhost been down for the past month so all my projects are on hold, sorry every one, as soon as it goes back up ill finish the toplist hack

[Tim Wheatley]

Excellent. Works great. :)

Gonna have to alter the templates a little (for example tell people what size buttons/banners have to be) and explain what in out means even. ;)

But superb stuff! :D

[Vivi Ornitier]

umm . . u guys think u can write a script to add the templates automatically? i don' twanna add 30 new ones b y hand

[xug]

Any news on V2??

[FleaBag]

Works with 2.2.7, thanking you. ;)

[NexDog]

Looking forward to v2.0. Slynderdale, if you want some help with hosting, give me a shout. :)

[FleaBag]

Eagerly awaiting version 2. ;)

[NexDog]

I hope Slynderdale gets back to this fine place soon. I have 3 issues that I need to resolve before hitting that prestigous "Install" button. :D

1) No top nav links at all.
2) Bottom links crushed and hiding behind the main topsites area.
3) No way to enter any width and height parameters to buttons and banners.

It's there, nice and messy:

http://www.hostnexus.com/forum/toplist.php

I might remove the banner altogether as another member did....

[NexDog]

No worries, worked it out. Will launch it everyone soon

[FleaBag]

Working with 2.2.8. The queries needed to be rearranged though.

[Chris M]

Please Gamer:mad: - https://vborg.vbsupport.ru/showthread.php?s=&action=showpost&postid=316171

Satan

[Iori Yagami]

*sniff* I wanted to install it on my board (2.2.8.) but I only get a lot of SQL errors. *sniff*

.. but.. but this hack is so cool... need it

[Warlord]

I like...:)

'Clicks install'

[Warlord]

Ok, I've made a few changes...

The members banner now leads to their site, as does the link with their site name, I got rid of the button code stuff.

I do have a question...

What code would I use to create my own (hosted on my server) button for people to put on their site which they can click and have their votes recorded?

I want to add this code to the add site and edit site features.

[Warlord]

Anybody home? :D I'm kind of dead in the water about promoting this thing until I get the code they need to put on their web page.


I need the code to put in the textarea on the add site page:

http://www.superherochat.com/forums/toplist.php?action=add

And I also want to put it on the edit site page (in case they lose the code):

http://www.superherochat.com/forums/toplist.php?action=edit

Ok, I think I may have figured out the code, but how do I get it to appear on the page without becoming active? I can't put it in the textarea box, because I need the php to stay active, AND keep the html inactive....


This is the code I came up with...


<a href="http://www.superherochat.com/forums/toplist.php?action=in&topid=$topid"><img src="http://www.superherochat.com/images/vote.jpg" border=0 height=142 width=113 alt="Vote for this site on the Superhero Chat Top Fansites!"></a>


Any suggestions?

[Warlord]

P.S. That's only the code for the edit site feature, for after they register a site to the list.. I have no clue on how to come up with code to do it before they actually register.. it'd have to be some sort of counter (i.e. the last site to register was topid=4 so the next person to click register would get topid5, but I'm clueless as to how I would set that up on the register page)

[Warlord]

ok, I figured it out for the edit site feature.. seems php is still active in textarea tags and html isn't, so I just put it in there...

But I still don't know how to do it with the "add site feature" :(

[Warlord]

Is anyone else having problems with the Edit SIte feature? It says my info has been updated, but it doesn't actually update it. Anyone have the fix for this?

[Warlord]

Originally posted by ManagerJosh
Here is a patch to correct the sorting issue on the toplist. This corrects the sorting issue though I'm not sure what Slynderdale had in mind.

This addresses the problem earlier stated by Slynderdale:


This patch adjusts settings in the MySQL so that it handles the sorting properly.

Be Sure to Back Up Your Database in case something happens.

Run the following MySQL query in PhpMyAdmin:
ALTER TABLE `toplist_sites` CHANGE `topid` `topid` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;

After running the MySQL Query, log out of your Database, and view your TopList. It now sorts properly. In Version 2.0, I'm not sure what changes will be made to sort it properly, but hopefully what I did is what Slynderdale had in mind.

Enjoy!


GAHHH! Now I'm having the problem with the sites being in the wrong order... I tried that sql query above and it had no effect. :(

Anyone offering any support on this thread or am I just talking to myself?

[Warlord]

bump

[Warlord]

Ok, well since nobody wanted to help me, I figured it out by myself...

To fix the sorting issue run this sql query...


ALTER TABLE `toplist_sites` CHANGE `topin` `topin` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT;


ManagerJosh had it close, but had the topid instead of topin.

[Warlord]

Still need help with that edit site feature though.. if anyone wants to help me out.


Pretty Please with a cherry on top? :D

[Warlord]

Can someone at least answer this thread? I'm starting to think I've been 'secretly banned' or something.. lol..

*Climbs to tallest thread and bellows out....*

HELLO!

*echo resonates throughout the canyon*

[Warlord]

Ummm ok.. who did I piss off?

[hagan]

I have installed it now but not made it public untill yet.
First i will thank you for this great hack.It will be very usefull for any boardcommunity.

Now a few things i realize after installing it.

The editfunction does not work properly.
You click on edit and will be redirect to the editscreen.

Also, i really dont understand what this custom buttonstuff is good for.
For me a toplist on my board should have only one button.Mine, that the members can add on their sites.
Visitors on the member sites clicks on the button or banner from me and automaticly votes for the site and will be redirect to my boards toplist.

Regards Hagan

[ULTIMATESSJ]

one thing that would really improve it would be the ability for the rank number to appear on the buttons, a site commenting system for the members to comment on the sites on the toplist, and to be able to split it into different rank categories, say most unique visitors, or most button clicks on the toplist

[Warlord]

Originally posted by hagan
I have installed it now but not made it public untill yet.
First i will thank you for this great hack.It will be very usefull for any boardcommunity.

Now a few things i realize after installing it.

The editfunction does not work properly.
You click on edit and will be redirect to the editscreen.

Also, i really dont understand what this custom buttonstuff is good for.
For me a toplist on my board should have only one button.Mine, that the members can add on their sites.
Visitors on the member sites clicks on the button or banner from me and automaticly votes for the site and will be redirect to my boards toplist.



Regards Hagan

Sounds like you want yours how I have mine set up.

Here's a demo..

http://www.superherochat.com/forums/toplist.php

If you'd like I can send you the template changes I made.
As for the edit site feature, I get the screen where you're supposed to make your changes, but the changes I make just won't take effect. Are you sure you added all the templates?

[hagan]

I get on the editscreen, make my changes and click on submit.
Then i get back to where i was, the editscreen.The Changes have like you said no effect.

I was on your toplist.Looks very good.You got rid of this custom buttonstuff.
But one thing is still missing.If you get to a membersite and click on your toplistbutton to vote you must be registered to vote.
I think everybody should be able to vote.This would create much more traffic and hits.

Warlord, that would be very nice.I would love to have your template modifications.
Or make it here public.I think there are others that want it.

Best regards,
Hagan

[Warlord]

ManagerJosh has his list set up so non-members can vote, perhaps he would be so kind as to enlighten the rest of us as to how we might make the same changes? :D

Also, has anyone figured out how to fix the Edit option? ManagerJosh thinks it's a php problem and not a mysql problem.. anyone got a fix for this yet?



Here's the template modifications I made for anyone that wants them....

[Warlord]

bumpity doo daa

[Warlord]

Ok people.. once again... here's the fix.. this time for the updating problem we were having for the edit site feature.

Just overwrite your current toplist.php with this one.

As always, make a backup of the file you are about to overwrite.. "Just in case".

[Automated]

How do you access the admin bit of the script?

Thanks
Matthew

[Warlord]

If you're referring to the administrative features, you can edit/delete sites by clicking "Edit" beneath their site listing.

[!!!]

Interesting, the names "Cheetos," "Loriel," and "Godspeed" reminded me of Graal ;)

https://vborg.vbsupport.ru/attachment.php?s=&postid=246096

Shadow Kni...I mean, Slynderdale (if that's your real name!), do you have a website?

[Slynderdale]

Good News, one, i have no need of a web host any more, i installed php, apache and mysql on my laptop so now i can work on my scripts esily, and i also have access to my vbulletin account again, for some reason it was telling me i had the wrong password and wouldnt let me log in for a couple weeks then i went to the password recovery form, i got the confirmation email and i confirmed and it never sent the new email with the new pass, i got it now, i also will be working on more hacks and upgrades to these, i also will be releasing all my hacks that i have made such as the profile add ons and picture hack and so forth.

[Slynderdale]

Originally posted by !!!
Interesting, the names "Cheetos," "Loriel," and "Godspeed" reminded me of Graal ;)

https://vborg.vbsupport.ru/attachment.php?s=&postid=246096

Shadow Kni...I mean, Slynderdale (if that's your real name!), do you have a website?

My real name is John, my handle is Slynderdale and yes im the same Shadow Knigt that useto play and code for graal, i havnt been on there in months and i dont even have it on my computer any more, i lost interest into it, coding for it was fun, but it held no future for me.

[Slynderdale]

Also also, im totaly recoding the toplist hack from scratch, im also fixing the html coding up, im adding alot of fixes and features to it, and also it will have settings like allowing non members to vote and alot of others like having a setting allowing only the top 10 sites to be able to show the banners. If you have any requests please feel free to post them.

[UnForums2k]

is there anyway to move the toplist hack to the main directory instead of under vbulletin? but still keep all the same options like user must be registed?? this would be really useful and i personaly like this hack more than Dj ..blahs... more simple and no images to slow forum down... nice work

[GoTTi]

On the top links added, I want it when a user clicks on the banner they get a new IE window pointing to that address, not a Add URL field for their site.

How do I edit this to do that? That is how a Top List hack should work? CLick that banner and goto site.

[GoTTi]

how can we integrate flash banners and buttons in this hack?

I tried to do it, and I get a image error.

[lifesourcerec]

I moved everything over to a new site, and now I get this error:

Invalid SQL: SELECT inid FROM toplist_hitsin WHERE topid='16' AND ipaddress='24.201.40.192' AND date='20030115'
mysql error: Unknown column 'ipaddress' in 'where clause'

How do I insert a new column in phpMyAdmin?

[GoTTi]

does ne1 know howto integrate flash banners into this hack?

i did it and got a error image.

[lifesourcerec]

Originally posted by lifesourcerec
I moved everything over to a new site, and now I get this error:

Invalid SQL: SELECT inid FROM toplist_hitsin WHERE topid='16' AND ipaddress='24.201.40.192' AND date='20030115'
mysql error: Unknown column 'ipaddress' in 'where clause'

How do I insert a new column in phpMyAdmin?

Nevermind. Figured it out :)

[GoTTi]

I would like to integrate Flash banners and buttons into this hack...how can I go about doing this?

[GoTTi]

Great hack here, but now adays sites have FLASH...AND THIS HACK isn't compatible with FLASH...

how can it be integrated with FLASH banners and buttons????????

[GoTTi]

integrate FLASH into this hack, how can i do it?

[insanctus]

I like this hack but there is one major thing I do not like.

The person has to be a memeber to vote.

To be a member to add a site makes sence. But how many are going to click vote then sign up for a page.

Lets face it most do not take the time. Sure that is where ones site content helps. But just getting going could prove hard.

Any ideas?

[insanctus]

N/M Hacked it to check ip instead of names.

Very cool script..

[mikeB]

Originally posted by insanctus
N/M Hacked it to check ip instead of names.

Very cool script..

how?

[insanctus]

I added a table in mysql called iplog

Then in toplist.php I changed the part under ######In#### to.

// ####### In #######
if ($action=="in") {
if ($topid=="") {
$goto="toplist.php?s=$session[sessionhash]";
eval("standardredirect(\"".gettemplate("toplist_error_blankid")."\",\"$goto\");");
exit;
}
$iplog = $REMOTE_ADDR;
$result=$DB_site->query("SELECT inid FROM toplist_hitsin WHERE topid='$topid' AND date='$today' AND iplog='$REMOTE_ADDR'");
list($voted) = mysql_fetch_row($result);
if ($voted == ''){
$DB_site->query("INSERT INTO toplist_hitsin (topid, accountid, date, iplog ) VALUES ('$topid','$accountid','$today' ,'$REMOTE_ADDR')");
$DB_site->query("UPDATE toplist_sites SET topin=topin+1, todaytopin=todaytopin+1 WHERE topid='$topid'");
}
doshutdown();
header("location: toplist.php?s=$session[sessionhash]");
}


Now if they are not a memeber they can vote in.... not out.... but if you wanted to do that I am sure it be easy to add.

Mine now only checks ip's per day. Hope that helps :)

[mikeB]

this is very helpful!> I'm not all that familiar w/ mysql.. can you tel me how you added the table iplog? did you have to run a specific query?

thanks a ton>!

[insanctus]

Ok .. In phpadmin in your forum data base find this "toplist_hitsin"

Now click it then click browse.

You will see things link inid , topid, date.

Now scroll down and find. Add new field 1 at end of table. Hit go.

In Field put iplog then hit save... and your done :)

[mikeB]

http://www.cloud10.org/gallery/data/500/1mysqlerror.jpg

ok when I try to add new field 1 at end of table, I go to whats displayed in the above image

then when I try and add iplog I get this error:
http://www.cloud10.org/gallery/data/500/1mysqlerror1.jpg

is there something else I need to add to make it happen?

[Slynderdale]

length = 20

Also this hack is overdue for a overhaul with the code..After i fix up my image verification hack, Ill start work on recoding the toplist hack.

[insanctus]

Try running this

ALTER TABLE `toplist_hitsin` ADD `iplog` VARCHAR(20) NOT NULL

[mikeB]

great, this worked... it's allowing unregistered user to see it... great.. and do the ungregistered user clicks in and out work?

just so if my members want to put this button on their sites (like a regular toplist) will it count correctly?

thanks a ton... the top list is here, just up last night:
http://highradiation.com/learn/toplist.php

[insanctus]

N/P ... Just glad I could help someone.
As for the out I never tested if you had to be a member to click out.... I will check that right now :).

[insanctus]

Just tested on yours as a guest and the out works fine.

[mikeB]

great thanks!

one more thing is, the countng and ranks seem to be off... for instance the top site doesnt have as many hits in today or over all as the one below it, anyone else have counting/rank issues? and know how to resolve?

[insanctus]

Hmm I only have my site on mine as a test site ( ~ crys alittle ) My page has only 4 users at the moment so issues like that I have not had a chance to deal with.

Sorry but on that I am at a lose.

[mikeB]

anyone else have any suggestions for making this rank correctly?

http://highradiation.com/learn/toplist.php

I'm having a hrad time figuring out exactly how this is ranked? heh looks like random ranking to me

[Slynderdale]

Originally posted by mikeB
anyone else have any suggestions for making this rank correctly?

http://highradiation.com/learn/toplist.php

I'm having a hrad time figuring out exactly how this is ranked? heh looks like random ranking to me

Give me till this week end when I have some free time to write version 2.0 of the toplist, the problem will be fixed then.

[mikeB]

great, I look forward to it!

[mikeB]

hey there, any word on getting the rank to work correctly?

hopefully soon!> thanks>!

[GoTTi]

slyn, how is the update coming with this hack?

I would really like to integrate flash with this.

[Alien]

Any word on the rewrite? :)

[GoTTi]

there gunna be a fix for this hack for the ranking problem? it isnt listing them properly.

[Ian Cunningham]

listing problem here too :(

[Ian Cunningham]

bump?

[coldpride]

I am having a little problem... I was woundering if you could make a .sql file that Will install the queries by it self. That would help me big time since I don't know how to do it manually.

[Alien]

Still looking for a nice update to this. :D

[coldpride]

Indeed. If any one can help me out it woul dbe great. convert the quires to .sql

[Alien]

Will you still be updating this, or leaving it as is?

03-07-03 at 03:37 PM Slynderdale said this in Post #129 (https://vborg.vbsupport.ru/showthread.php?postid=362450#post362450)
Give me till this week end when I have some free time to write version 2.0 of the toplist, the problem will be fixed then.

[rishel]

I wouldnt hold your breath :)

[MuSuL]

If any one wanna use it or edit it, heres a blue toplist button i made

Where would this go?....and how would you use it...

Thanks

[MuSuL]

I have figure it all out, did the corrections like some have said in this therad and I have to say

THIS IS THE BEST! LOVE IT !!!!!!

[Hoffi]

Any Updateinfo would be great.

[MuSuL]

OK, I thought it was working great!..Well I see now that no matter how many points you have, your banner will not move to the top...WHY?

[Slynderdale]

Sorry about the lack of updates, my license expired and I just recently upgraded it. Also I've been busy with work, college and a couple other projects.

After this semester is over, I plan to completly rewrite this hack and also start on a rewrite for vbulletin 3. If you have any ideas, suggestions or comments on the next version, please post about them.

[Hoffi]

Sorry about the lack of updates, my license expired and I just recently upgraded it. Also I've been busy with work, college and a couple other projects.

After this semester is over, I plan to completly rewrite this hack and also start on a rewrite for vbulletin 3. If you have any ideas, suggestions or comments on the next version, please post about them.
So I will rewrite it myself. I just need it very soon.

[Jae Dot]

Will this hack eat up alot of bandwidth?

[Areku]

Will this hack eat up alot of bandwidth?
Lack of updates...

has any1 ported this hack to vb3 already?!?!

Pleeeease! ;)

[Hoffi]

I use it on vB3, yes.

I ask the author if I can release it.