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.

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.

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

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

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. Add your site if you like ... read the guidelines before you do.

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

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

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

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

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

Sebastian

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=

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

ok, thanks

Great Hack Slynderdale

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

yah
how soon?

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

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

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

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!

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

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

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

new version out yet???

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

/me clicks install

very good hack, any news on v2.0?

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

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

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

Any news on V2??

Works with 2.2.7, thanking you. ;)

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

Eagerly awaiting version 2. ;)

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

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

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

Please Gamer:mad: - https://vborg.vbsupport.ru/showthrea...&postid=316171

Satan

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

[cries].. but.. but this hack is so cool... need it[/cries]

I like...:)

'Clicks install'