View Full Version : Toplist
DjSap
04-02-2002, 10:00 PM
The toplist hack allows people to add their sites to your toplist and send traffic to your site, in return you will send traffic to them.
This toplist script is pretty simple but it does the work, it has a cheat protection where it doesn't allow one ip to vote more then once a day on a certain site. It is completly template driven and will blend in with your vb design.
The installation is simple and the zip file contains install.txt where you will find instructions.
please post bugs/comments/suggestions here.
Floris
04-03-2002, 10:41 AM
Dynamic IP can be a problem,
why not let a 'username/id' only vote once? Instead of an IP, since you say that the user has to be registered?
DjSap
04-03-2002, 10:54 AM
the user has to be registered to sign up on the toplist, if the people vote from the persons site then you cannot be sure that they are signed up on your site.
rawnet
04-03-2002, 11:24 AM
EXAMPLE
Have you got an example URL and some screen shots please?
Ross
DjSap
04-03-2002, 11:59 AM
here is a screen of the toplist itself, this uses the default vd style.
It says to run the queries in topsite.sql.
Do I run that into the vBulletin database, or do I need to put that in another database?
DjSap
04-03-2002, 01:22 PM
use the same db as vbulletin
Lesane
04-03-2002, 01:43 PM
Pretty cool hack, i'm gonna install this one later. Thanks.
Very nice hack man. But I have to agree with xiphoid. I might install with... but I have In-Link :p
ZiRu$
04-03-2002, 04:10 PM
I'll install it later too....GREAT HACK
DjSap
04-03-2002, 04:18 PM
im working on adding a rate site thingy right now, does anybody have any more suggestions?
Bald Bouncer
04-03-2002, 04:57 PM
anyone got any idea why I cant run the query, using phpadmin and its saying no SQL to run??
DjSap
04-03-2002, 07:07 PM
i only tested the file with phpMyAdmin, phpadmin might use a diffrent system, try copying all content from toplist.sql and paste it into the query box and run it.
Shroomboy
04-04-2002, 01:27 AM
I suggest letting them have buttons (didn't see any on the preview)
ZiRu$
04-04-2002, 02:01 AM
Originally posted by Shroomboy
I suggest letting them have buttons (didn't see any on the preview)
i think the top 3 should be able to have buttons
Lionel
04-04-2002, 04:37 AM
works nice on 2.21. Installed took 30 seconds. Just a query and created a link.
Okiewan
04-04-2002, 04:22 PM
after install... get a blank page with only this in the source:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252"></HEAD>
<BODY></BODY></HTML>
Thoughts?
Shroomboy
04-04-2002, 07:17 PM
well what page did u go to? toplists.php or toplists.sql and you hvae to run the toplists.sql to make the tables... if u have PHPMyAdmin use that... oh and suggestions on the hack
1. Your site had a button with numbers on it...
2. You show that sitesbutton
3. The limit for description is longer then is (can't see where to change)
4. make more like a topsite that other sites have...
5. Make it have a choice of wheather only members of the forums can join or if anyone can...
Okiewan
04-04-2002, 09:50 PM
yup..made the tables. Been a while since i tried to call a .sql from a browser :)
TheCaver
04-06-2002, 01:35 AM
Works great, nice addition..........
JC
Okiewan
04-07-2002, 02:32 PM
Bug? Seems that if there are mutiple template sets, the templates are not created ... if anyone cares about this hack anymore.... :)
lifesourcerec
04-07-2002, 03:50 PM
Suggestion...
Modify it so that "Your Bulletin Board > Top List" links are at the top? That way users can click that instead of keep clicking "Back" to get back to the forum.
In Template toplist_menu
Before this:
<normalfont><a href=toplist.php?s=$session[sessionhash]>Toplist</a> | <a href=toplist.php?s=$session[sessionhash]&action=add>Add Site</a> | <a href=toplist.php?s=$session[sessionhash]&action=edit>Edit Site</a></normalfont>
Add this:
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td width="100%" valign="top">
<img src="{ imagesfolder}/vb_bullet.gif" border="0" align="absmiddle"><normalfont><b><a href="index.php?s=$session[sessionhash]">$bbtitle</a> > Top Sites</normalfont></b>
</td>
</tr>
</table>
Remove the space between { and imagesfolder.
Okiewan
04-07-2002, 04:10 PM
Made all the templates by hand... works fine. Can't actually say that the possible bug I reported is correct, I removed all of the "experimental" templates, leaving only one, then reinstalled, it still didn't make the templates (yes, ran the queries again).
Go figure..
NSeXcellent
04-07-2002, 08:54 PM
Could someone explain "Run the queries in toplist.sql" a little better, for a not-so-sql-literate person? Thank you :D
mewgood
04-07-2002, 11:57 PM
go to phpmyadmin and run toplist.sql
mewgood
04-10-2002, 06:17 AM
why I get a blank page?
http://www.mewgood.com/~vbb/toplist.php
mewgood
04-11-2002, 04:21 AM
anyone please?
Okiewan
04-12-2002, 12:00 PM
Check to see if the install program made the templates as it's supposed to. It didn't on my site, I had to make them manually. You can do that by opening the install file, you'll see the templates there.
DjSap
04-12-2002, 12:11 PM
well i found that there is a problem if you got many diffrent template sets, cuz the install file only adds the toplist templates to the default template set, the rest you have to do by hand or change the mysql query.
mewgood
04-13-2002, 04:10 AM
can you please list in here, or please pm me about it? I don't get it..
mewgood
04-16-2002, 05:05 AM
can anyone please post the templets out?
DjSap
04-16-2002, 05:54 AM
Well this sql query should work on boards with many style sets.
To make this little thingie work you have to open template.php and around line 332 you will find this:
$only['calendar'] = 'Calendar';
Above it place
$only['toplist'] = 'Toplist';
mewgood
04-17-2002, 04:17 AM
ar...
look please.
http://www.mewgood.com/~vbb/toplist.php
same it is a blank page..
Slynderdale
04-17-2002, 07:14 PM
nice hack, im gonna use it but editing it a little so it uses your vbulletin account and pass to check if your an admin, if your an admin youll have access to the admin options instead of using the password varible so every admin on the forum, and other usergroups you give permission can access the admin section and instead og logging ip im changing it so it logs the users id so they must sign up on your forums first to rate.
mewgood
04-18-2002, 10:43 PM
Originally posted by mewgood
ar...
look please.
http://www.mewgood.com/~vbb/toplist.php
same it is a blank page..
anyoe can help me out?
Slynderdale
04-19-2002, 04:29 AM
Ill be releasing a toplist edit shortly, i made some improvments and modifications to it, it will be as a toplist.hack file and a text file for those who dont have vbhacker.
Modifications:
The toplist will looks like this:
Site Name Added by username
description
[vote for this site]
and after a in and out will be vote so people can vote for the site
and if your a admin at the left will be a link [edit] [delete]
Admins will be able to edit the in and out count, the url, site name,sit name and description and be able to delete it, and a list all ability to see all the sites listed.
Im also gonna add a toplist section in the forum options so you can set the max sites to list, if users can post more then one site, if if you want the members to be registered to be able to vote, if not it uses ip detection, same for the in count.
DjSap
04-19-2002, 05:46 AM
i got a rating thing done but im too lazy to rls an updated version, its better if you include it in your rls, hit me up on icq and ill give you the file additions.
Slynderdale
04-19-2002, 06:26 AM
Heres what i have so far for the top list, i removed and edited some of the scripted, only admins can see the edit and remove links at the bottom of the site info, its a new template so if you want you could make them images
Slynderdale
04-19-2002, 06:26 AM
Heres what the admin edit looks like
Slynderdale
04-19-2002, 06:28 AM
Im gonna add voting next, members will be able to vote for a site once, im also adding some other modifications too, ill keep you inform
eXtreme Tim
04-21-2002, 07:45 PM
i have whipped up my own version of it. I plan to make a cp thing latter on.
Slynderdale
04-21-2002, 09:01 PM
Heres my current one, i added better checking and only admins can see the edit and delete links, and you can only vote for the site if your a member on the forums and i fixed up the code quite a bit
Slynderdale
04-21-2002, 09:02 PM
heres the admin edit
Slynderdale
04-21-2002, 09:04 PM
heres the drop down menu i added to show a number of sites
Slynderdale
04-21-2002, 09:07 PM
heres how the color changes when you move the mouse over it and the url that the link goes to apears in your broswer message bar at the buttom
Slynderdale
04-21-2002, 09:10 PM
i have it so a site can also have an option to add a small button image if they want to show on the toplist
eXtreme Tim
04-22-2002, 12:46 AM
Mine has daily hits in and out and total hits in and out. I plan to add in that image column on mine with it set to size the images to 100 x 50 or so. Can i get the code your using for it to do the links like that for edit and delete so i don't have to make them myself.
mewgood
04-22-2002, 01:39 AM
can anyone help me?
I need templets.......
Slynderdale
04-23-2002, 11:14 AM
heres my toplist file, DO NOT PLACE IT OVER YOUR OLD ONE, youll get an error because you dont have the templates and query's, im just posting to for those who wannna see the code, when im finished ill post every thing up.
Corbu
04-23-2002, 05:35 PM
Very good hack !
But he doesn't work on my board !
Does he don't work because my version of phpmyadmin is on this number : 2.2.0pre5 ???
Because I have being the install a lot of time and it continues to desn't work... :( :( :( :( :(
Sorry for my english, i'm french.
Slynderdale
04-24-2002, 01:04 AM
Originally posted by Corbu
Very good hack !
But he doesn't work on my board !
Does he don't work because my version of phpmyadmin is on this number : 2.2.0pre5 ???
Because I have being the install a lot of time and it continues to desn't work... :( :( :( :( :(
Sorry for my english, i'm french.
wait till my finished version is out, it should work then
Slynderdale, can you add 'unique hits' & 'total hits' please?
Slynderdale
04-24-2002, 04:53 AM
Originally posted by MHR
Slynderdale, can you add 'unique hits' & 'total hits' please?
good idea, ill add it
and maybe a 'Trend' that tells a site have move up / down or unchanged. :D
ZiRu$
04-24-2002, 02:58 PM
Originally posted by Slynderdale
wait till my finished version is out, it should work then
I cant wait man!...I'mma hold off installing till your done
Slynderdale
04-24-2002, 10:59 PM
Originally posted by Hot Dogg
I cant wait man!...I'mma hold off installing till your done
Ill finish it today for every one
BigJohnson
04-25-2002, 08:40 PM
thanx
Airwaves
04-26-2002, 08:09 AM
Is this hack still in Beta mode?
ZiRu$
04-26-2002, 06:43 PM
Originally posted by Slynderdale
Ill finish it today for every one
ok man that was yesterday! hows it coming along! I hope you have it up today I wanna add a few hacks tonight
Slynderdale
04-26-2002, 11:10 PM
sorry, been a little busy past couple days, its completed, i added banner support to and when you click on the banner or button on the page it brings a small window that gives you a code on how to add the benner or button to your site, ill write up the instructions now
Airwaves
04-27-2002, 04:08 PM
thanks mate :D cant wait
BigJohnson
04-28-2002, 10:58 AM
yes i cant wait neither where is it mani am waiting all day for this one.
ZiRu$
04-29-2002, 11:02 PM
whats goin on man! Are you still gonna post it?
Slynderdale
04-30-2002, 03:49 AM
Sorry i just moved a couple days ago and my cable modem dont work here so i have to use aol dial up till the cable company comes and i can only be on aol for around 5 minutes a day, sorry, thats whats taking so long
NitroSimSev
05-01-2002, 01:05 PM
For those that have VBPortal Installed I did a similar hack awhile back at PHPPortals.com http://www.phpportals.com/forums/showthread.php?s=&threadid=3680
Go here to check out a working version.
http://www.nitrosim.com/modules.php?op=modload&name=Top_Sites&file=index
Slynderdale
05-01-2002, 01:23 PM
I finished my toplist hack, thank you djsap for the original toplist and giving me the idea to make my own, it has alot of stuff, banner and button support, today and total ins and out, members must be signed up to vote and alot more, go here to see it:
http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=342
FleaBag
05-16-2002, 09:37 PM
Can someone please tell me the SQL query to run to remove this entirely from my database?
FleaBag
05-18-2002, 02:05 PM
Anyone, pleeeeease? LOL
FleaBag
05-21-2002, 10:16 AM
OK many thanks to TWTCommish and FireFly for supplying me with the info I needed to remove the Toplist hack from my database. For everyone else who might want to do the same, here is the query you need to run on your database.
DROP TABLE toplist_hitsin;
DROP TABLE toplist_settings;
DROP TABLE toplist_sites;
DELETE FROM template WHERE title IN ('toplist_menu','toplist_addsite','toplist_redirec t_add','toplist_error_allfields','toplist_editsite _nosites','toplist_editsite','toplist_redirect_del ete','toplist_redirect_edit','toplist_editsitebit' ,'toplist','toplistbit','toplistbit_admin_nosites' ,'toplist_adminbit')
Hope this helps some of you like it helped me. :)
insanctus
02-26-2003, 02:00 AM
Very cool hack.... Thanks for you work on it.
mikeB
03-05-2003, 02:05 PM
ok, question.
I just installed this and I wonder why when I click on the banner it send me to a page with my banner code?
how do I make it so that the banner sends people to the site?
http://www.highradiation.com/learn/toplist.php
thanks>!
coldpride
06-24-2003, 12:35 AM
Hmm... I am having a little problem with this hack. Though I though It was really easy to install. I did everythign in the instructions still it doesn't show the topsitelist it shows a blank page? http://www.ani-community.net/toplist.php can anyone help ?
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.