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 '<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;
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