The Arcive of Official vBulletin Modifications Site.

vBTopSite · **Released**: 12-29-2003

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 ^_^

sweet22 · #12 12-30-2003, 09:52 PM

there is no attachment or download for the topsite

Roxie · #13 12-30-2003, 10:00 PM

I am having to do the queries manually and I got this error with the first one:

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 108
STR: '
SQL: CREATE TABLE topsites_ips (
ipin int(10) NOT NULL auto_increment,
address varchar(14) NOT NULL default \'\',
siteid int(5) NOT NULL default \'0\',
dateadd int(20) NOT NULL default \'0\',
PRIMARY KEY (ipin)
) TYPE=MyISAM
SQL-query :

CREATE TABLE topsites_ips ( ipin int(10) NOT NULL auto_increment, address varchar(14) NOT NULL default \'\', siteid int(5) NOT NULL default \'0\', dateadd int(20) NOT NULL default \'0\', PRIMARY KEY (ipin) ) TYPE=MyISAM

MySQL said:

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 '\'\',
siteid int(5) NOT NULL default \'0\',
dateadd int(20)

Darkwaltz4 · #14 12-30-2003, 10:06 PM

UGH THIS IS GETTING ANNOYING NOW....blame vbhackmaker, here use this

PHP Code:


			
CREATE TABLE topsites_ips (

  ipin int(10) NOT NULL auto_increment,

  address varchar(14) NOT NULL default '',

  siteid int(5) NOT NULL default '0',

  dateadd int(20) NOT NULL default '0',

  PRIMARY KEY  (ipin)

) TYPE=MyISAM;



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 '&lt;b&gt;&lt;u&gt;&lt;i&gt;',

  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;



CREATE TABLE topsites_sites (

  siteid int(3) NOT NULL auto_increment,

  siteurl varchar(75) NOT NULL default '',

  sitetitle varchar(75) NOT NULL default '',

  webmaster varchar(30) NOT NULL default '',

  webemail varchar(50) NOT NULL default '',

  sitedescription text NOT NULL,

  sitepassword varchar(30) NOT NULL default '',

  buttonurl varchar(75) NOT NULL default '',

  totalhits int(10) unsigned NOT NULL default '0',

  totalout int(10) unsigned NOT NULL default '0',

  totalunique int(10) unsigned NOT NULL default '0',

  totalin int(10) unsigned NOT NULL default '0',

  todayin int(10) unsigned NOT NULL default '0',

  todayunique int(10) unsigned NOT NULL default '0',

  todayout int(10) unsigned NOT NULL default '0',

  todayhits int(10) unsigned NOT NULL default '0',

  lastreset int(20) NOT NULL default '0',

  lastrank int(20) NOT NULL default '0',

  joindate int(20) NOT NULL default '0',

  active tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (siteid),

  UNIQUE KEY siteurl (siteurl,webmaster,webemail,buttonurl)

) TYPE=MyISAM;



INSERT INTO topsites_options VALUES (0, 0, 10, 1, 1, 'http://YOURSITE/topsites/buttons', 10, 0, 2, '<b><u><i>', 31, 88, 0, 'http://YOURSITE/topsites', 'todayunique');



---------------------------------

find forum/global.php

----

if (!$servertoobusy) {

  require('./admin/sessions.php');

----

replace with

----

if (!$servertoobusy) {

if($PHP_SELF != "/topsites_hit.php") {

  require('./admin/sessions.php');

}



find in admin/index.php

----------

makenavoption("Add","announcement.php?action=add","|");

makenavoption("Modify","announcement.php?action=modify");

makenavselect("Announcements");



add below

// *************************************************

makenavoption("Options","topsites_admin.php?action=options"," | ");

makenavoption("Manage Sites","topsites_admin.php?action=site","<br/>");

makenavoption("Useful Admin Functions","topsites_admin.php?action=functs","<br/>");

makenavoption("Send Emails","topsites_admin.php?action=email"," | ");

makenavoption("View","../topsites.php?page=1","<br/>");

makenavselect("vBTopSite");

*sigh* i think i remember why i dont release hacks here, lol

and yeah...............................vb3 is in the process of 'updating the attachment' =_= which means it might not be available until tomarrow...stupid thing. if you click install, ill be able to update you when it returns

Roxie · #15 12-30-2003, 10:17 PM

I'm getting errors with all the queries now....I'm going to hold off on installing until you get the file updated. Then I'll try again.

Darkwaltz4 · #16 12-30-2003, 11:27 PM

Okay, the update is there, i took out the vbhacker stuff, and added all of the instructions which you will need, and that should be everything *heavy sigh* now, this is really ruining my credibility isnt it, lol. Just follow the instructions, vbhacker sucks i just found out, when you are trying to make your own with vbhackmaker.

ULTIMATESSJ · #17 12-30-2003, 11:35 PM

One small question

I have my forums installed on a subdomain (for example http://forum.mysite.com). Say i wanted this topsite page to appear on the normal site (example again http://www.mysite.com/topsite.php), what would i need to do?

Darkwaltz4 · #18 12-30-2003, 11:39 PM

hmmmm....im just guessing, but you might be able to do it if you put the full url into the include file to global.php of your fourms (which it needs to run) however i have a feeling this wont work, because then youll have to edit all the requires in the global.php file....you might try it, but i seriously dont think it will work without some annoyance experienced on your end.

this is one of the problems, which is solved by being free of vb in the version i mentioned above :-p because some people dont like the topsites to be dependant on the forums.

AN-net · #19 12-31-2003, 05:51 AM

i seem to be having problems with the second db query>_<

edit:
im having problems with the topsites_options:
specifically:
'require tinyint( 1 ) NOT NULL default '1',
buttons varchar(

Darkwaltz4 · #20 12-31-2003, 03:32 PM

which version of mysql are you running? the sql statements should all be run through phpmyadmin, after all i used phpmyadmin to render the statements in the first place, lol (using the view dump schema thing)

on a side note, if anyone actually gets this running on their site, mind posting a link?

i might even list it at the top or something

MindTrix · #21 12-31-2003, 03:38 PM

Sounds good, nice job

Hope you get the problems fixed soon

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.04478 seconds Memory Usage 2,349KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!