vBTopSite

vBTopSite - Used from 2.2.9 - 2.3.3, should work on all 2.x

Description: Topsites script for people who's sites revolve around vbulletin.

This script I actually wrote several months ago, and now I finally decided to release them on vb.org.
There are some things which I have not included in this version, but they will be released here as I am satisfied with them:
All functions appearing in 'Useful Admin Functions' in the ACP
Everything else works. ^_^ now anyway, features...


Topsites Features: [in no order, partial list]

• Works with all vb things, like it shuts off with your forums, and Banned people have no access.
• Secure Member Panel
• Seperate Member Base, user need not be joined to forums to join/view topsites
• Secure Retrieval System
• Stats rendered in real-time
• 'Today' Reset system
• Customizable stat display in the sitecell template. [instructions for that if you ask me]
• Tracks 12 stats, rankable by 9
• Not a 'clicking required' topsites, displaying buttons earns hits
• E-mail verification system
• Allow certain HTML in description
• Display filters for accounts which arent displaying the button
• Comprehensive who's online locations

Admin Features: [in no order, partial list]

• Topsites active y/n
• Hit accruing active y/n
• E-mail verification required (activation) y/n
• Urls to buttons, arrows (for placing buttons remotely even)
• Length of 'day' for reset purposes, 1 for daily, 0 to disable
• Allowed HTML in description (blank for full stripping)
• Option to resolve bad button urls -> replacing them with the rank button
• Display filter (explained in the acp, or ask me for more details)
• Set which stat to rank by
• Edit/delete sites
• SEARCH site database
• Editing page features links to view submitted button, auto-checks validity of urls
• Automatic emailing script: send to specific site/all sites/inactivated sites/activated sites
• Displays stats [but not allowing editing]
• View topsites from acp
• **Force 'day' reset of unreset sites
• **Force 'day' reset particular site
• **Force 'day' reset of ALL sites
• **Prune sites which joined from DATE, from all sites/inactivated/activated
• **Clean up IP table of old hits/hits from pruned sites
• **Flush hits from particular site
• **Flush hits from site older than DATE

** = Will be appearing on vb.org shortly.

It is advised anyone who uses this hack, to click install, because of the nice updating thing i can do,
and like i said, there will be updates in a little while.

LIVE VERSION: http://forums.ffgon.com/topsites.php
Feel free to join if you are a Final Fantasy site ^_^ [ignore the popups, they dont appear if you are logged into the forums]
MORE:
http://www.animationation.net/community/topsites.php
http://www.bluelaguna.net/forum/topsites.php
http://www.orbsydia.com/forum/topsites.php

anyway, i might post screenshots, but the admin stuff isnt much to see, i basically just explained it up there ^ :-p
If you have any questions, etc, post them

FYI: a more advanced script is in the works by me, which will be free from vbulletin and including many more features,
like a user rating/comment system. This will be 10$ or so, and more details are available if you pm me (dont discuss it here)

Thank you for using this hack! i know i dont usually post my stuff, well here you go ^_^

[Darkwaltz4]

heh, yeah i know i know, i cant code that mess called vb3 [yet]...at least until i figure out the whole template thing, all over again (theres like 3 types now >.<)

anyway, there is definately a different-version issue at work here, with the 'require' column i told you about. to fix it, open up the topsites_ammin.php, and put quote around the query that updates topsites_options

_everywhere_ you see:
-----------
require='
-----------
replace with
-----------
`require`='
-----------

and also, when you get it working, mind posting a link to it? that would be cool ^_^

wow, so now i know what to include in the next version (which ill work on when everyone is good with this one)

[AN-net]

ok this time when i submitted the options it did "update" the options table from admin cp perspective by saying "options updated" but when i went to http://www.animationation.net/community/topsites.php
i get this:

Database error in vBulletin 2.3.2:

Invalid SQL: SELECT * FROM topsites_sites WHERE active>0 ORDER BY DESC LIMIT 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 'DESC LIMIT 0,' at line 1

mysql error number: 1064

Date: Wednesday 31st of December 2003 08:14:14 PM
Script: http://www.animationation.net/commun...es.php?page=1&
Referer:

[Darkwaltz4]

you did not fully fill out your settings, your 'Sites per page' option is not filled out

[AN-net]

ok just checked phpmyadmin and it doesnt seem it updated anything, from looking at it seems instead of updating you need to insert some stuff so you can browse it. just my 2 cents

[Darkwaltz4]

okay, in this case, you never executed the INSERT query

if you need it, its:

PHP Code:

INSERT INTO `topsites_options` ( `active` , `hitson` , `perpage` , `daytime` , `require` , `buttons` , `totalbuttons` , `resolve` , `display` , `htmlallowed` , `bheight` , `bwidth` , `bborder` , `arrows` , `rankby` ) 
VALUES (
'0', '0', '10', '1', '1', '', '50', '0', '1', '<b><u><i>', '0', '0', '0', '', 'todayunique'
); 


when this is done, thats probably what caused the problem when you tried to update your options

[AN-net]

omg i forgot to do that, silly me lol( got all caught up in actually creating the options table lol

[AN-net]

To look at anothe working example see:
http://www.animationation.net/commun...es.php?page=1&

[Darkwaltz4]

lol, hopefully the next working example wont take as long to get working ^_^

this hack isnt beta, the install instructions were, lol

ill be updating the zip file above soon, there are the movement arrows i forgot to include, and i also revised the instructions a bit, to avoid many of the issues discovered with them :-p

also, newer queries which should work for all mysql versions. hopefully i can add in some of the starred items soon :-p

[AN-net]

one more problem, ok i signed my own site up to test it and also to see how it works but now, when i get sent the email with the password the password was totally random and weird and also when i copy and pasted it in the site login with my id i got invalid password. is the password susposed to contain subscripts,slashes, and colons?

[Darkwaltz4]

yeah, i put up a change in the random password generator. *in the new zip* if you would like to change it yourself, find:

chr(rand(1,100));

and change it to chr(rand(1,75));
(this code only appears once, so just use Find)

you can edit the password to your site using the ACP 'manage sites' option