1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
|
<?php
chdir("..");
require("./global.php");
$db->query("CREATE TABLE bb".$n."_ads (adid int(11) NOT NULL auto_increment, userid int(11) NOT NULL default '0', bannerurl varchar(255) NOT NULL default '', alt varchar(255) NOT NULL default '', hyperlink varchar(255) NOT NULL default '', views_available int(11) NOT NULL default '0', views_used int(11) NOT NULL default '0', klicks int(11) NOT NULL default '0', PRIMARY KEY (adid)) TYPE=MyISAM AUTO_INCREMENT=0");
$db->query("INSERT INTO bb".$n."_groupvariables (variableid,variablename,type,defaultvalue,variablegroupid,showorder,acpmode) VALUES ('','a_can_otherstuff_ads','truefalse','0','22','7','2')");
$variableid=$db->insert_id();
$db->query("INSERT INTO bb".$n."_groupvalues(groupid) SELECT groupid FROM bb".$n."_groups");
$db->query("UPDATE bb".$n."_groupvalues SET variableid='".$variableid."', value='0' WHERE variableid='0'");
$db->query("INSERT INTO bb".$n."_acpmenuitems (itemid,itemgroupid,link,languageitem,linkformat,condition,conditiontype,showorder,acpmode) VALUES ('','17','ads.php','ADS','<b>%s</b>','a_can_otherstuff_ads','OR','4','2')");
echo "Done. Please delete the file acp/ads_setup.php now!";
?> |