Toplist Hack
 

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.

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

Also screen shots are posted in posts below
[/edit]

Heres what the main toplist page looks like.

Looks good :)

thanks :)

can i have a working demo?

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:
and replace it with:
find in the show banner code section:
and replace it with:
i forgot to add the $bburl

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

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

Thats great! I'll install it this weekend

heres the admin edit screen

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

heres the menu where people can select how many to show

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

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 :)

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

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".

>for what is it used

Stupid me, found it out :D

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 :)

Done :D

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 :)

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.

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 :)

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.....

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

:) looks hot as hell good job man

thank you and thank you for the live demo :)

no prob man :) keep up the good work

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

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?

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

good idea, ill add it

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

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

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:

sweet as.

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

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

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 :)

Nice hack.

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