Version: 1.00, by Darkwaltz4
Developer Last Online: Feb 2013
Version: 2.3.x
Rating:
Released: 12-29-2003
Last Update: Never
Installs: 3
No support by the author.
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.
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 ^_^
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
the current problem for right now: seems to just be AN-net with the second query
all the problems from previous posts, were trouble with: vb3's attachment process >.> and also vbhacker not liking the vbhackmacker file i used (so i rewrote the instructions without use of vbhacker) and then it became less annoying ^_^
yeah, so anyone returning, ignore most of the above posts >.>
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 'require tinyint( 1 ) NOT NULL default '1',
buttons varchar(
i still get that
i having no experience with sql syntax would assume the word require is messing it up, i dont know just a hunch
AHA, i know whats going on, and i might update the query in the install file if this keeps up a problem >.>
PHP Code:
CREATE TABLE `topsites_options` (
`active` tinyint( 1 ) NOT NULL default '0',
`hitson` tinyint( 1 ) NOT NULL default '0',
`perpage` tinyint( 3 ) NOT NULL default '10',
`daytime` tinyint( 2 ) NOT NULL default '1',
`require` tinyint( 1 ) NOT NULL default '1',
`buttons` varchar( 75 ) NOT NULL default '',
`totalbuttons` int( 3 ) NOT NULL default '50',
`resolve` tinyint( 1 ) NOT NULL default '0',
`display` tinyint( 1 ) NOT NULL default '1',
`htmlallowed` varchar( 75 ) NOT NULL default '<b><u><i>',
`bheight` tinyint( 3 ) NOT NULL default '0',
`bwidth` tinyint( 3 ) NOT NULL default '0',
`bborder` tinyint( 3 ) NOT NULL default '0',
`arrows` varchar( 75 ) NOT NULL default '',
`rankby` varchar( 75 ) NOT NULL default 'todayunique',
KEY `active` ( `active` )
) TYPE = MyISAM ;
there, the problem (thanks for putting the entire error message) was that the word 'require' is a reserved word, and to use it in a table requires that you quote it to work *edit: just verified this*
im getting this now when i fill in the options in admin cp and hit save changes:
Quote:
Database error in vBulletin Control Panel 2.3.2:
Invalid SQL: UPDATE topsites_options SET display='1',active='1',require='1',hitson='1',butt ons='http://www.animationation.net/community/images/topsite/',arrows='ttp://www.animationation.net/community/images/topsite/',perpage='10',totalbuttons='50',daytime='0',htmla llowed='',bheight='31',bwidth='88',bborder='1',res olve='0',rankby='totalunique'
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 'require='1',hitson='1',buttons='http://www.animationation.net/c
vBTopSite Details »»
About Developer
Visit Web Site
No support by the author.
12-31-2003, 03:40 PM
