hide_errors();
$db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist, regex, form, html, perline, profilefieldcategoryid) VALUES ('610','3','0','100','25','610','1','radio','a:2:{i:0;s:3:\"نعم\";i:1;s:2:\"لا\";}','0','1','0','0','0','','1','0','0','0')");
$db->query_write("ALTER TABLE userfield ADD field610 MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist, regex, form, html, perline, profilefieldcategoryid) VALUES ('620','3','0','100','25','620','1','select','a:248:{i:0;s:12:\"saudi arabia\";i:1;s:11:\"afghanistan\";i:2;s:7:\"albania\";i:3;s:7:\"alderny\";i:4;s:7:\"algeria\";i:5;s:14:\"american samoa\";i:6;s:7:\"andorra\";i:7;s:6:\"angola\";i:8;s:8:\"anguilla\";i:9;s:10:\"antarctica\";i:10;s:15:\"antigua barbuda\";i:11;s:11:\"arab league\";i:12;s:9:\"argentina\";i:13;s:7:\"armenia\";i:14;s:5:\"aruba\";i:15;s:5:\"asean\";i:16;s:9:\"australia\";i:17;s:7:\"austria\";i:18;s:10:\"azerbaijan\";i:19;s:7:\"bahamas\";i:20;s:7:\"bahrain\";i:21;s:10:\"bangladesh\";i:22;s:8:\"barbados\";i:23;s:7:\"belarus\";i:24;s:7:\"belgium\";i:25;s:6:\"belize\";i:26;s:5:\"benin\";i:27;s:7:\"bermuda\";i:28;s:6:\"bhutan\";i:29;s:7:\"bolivia\";i:30;s:18:\"bosnia herzegovina\";i:31;s:8:\"botswana\";i:32;s:6:\"brazil\";i:33;s:7:\"britain\";i:34;s:27:\"british antarctic territory\";i:35;s:30:\"british indian ocean territory\";i:36;s:22:\"british virgin islands\";i:37;s:6:\"brunei\";i:38;s:8:\"bulgaria\";i:39;s:12:\"burkina faso\";i:40;s:13:\"burma myanmar\";i:41;s:7:\"burundi\";i:42;s:8:\"cambodia\";i:43;s:8:\"cameroon\";i:44;s:6:\"canada\";i:45;s:10:\"cape verde\";i:46;s:14:\"cayman islands\";i:47;s:24:\"central african republic\";i:48;s:4:\"chad\";i:49;s:5:\"chile\";i:50;s:5:\"china\";i:51;s:16:\"christmas island\";i:52;s:8:\"colombia\";i:53;s:7:\"comoros\";i:54;s:17:\"congo brazzaville\";i:55;s:12:\"cook islands\";i:56;s:10:\"costa rica\";i:57;s:13:\"cote d ivoire\";i:58;s:7:\"croatia\";i:59;s:4:\"cuba\";i:60;s:6:\"cyprus\";i:61;s:13:\"czec republic\";i:62;s:7:\"denmark\";i:63;s:9:\"dijibouti\";i:64;s:8:\"dominica\";i:65;s:18:\"dominican republic\";i:66;s:10:\"east timor\";i:67;s:7:\"ecuador\";i:68;s:5:\"egypt\";i:69;s:11:\"el salvador\";i:70;s:17:\"equatorial guinea\";i:71;s:7:\"eritrea\";i:72;s:7:\"estonia\";i:73;s:8:\"ethiopia\";i:74;s:16:\"falkland islands\";i:75;s:6:\"faroes\";i:76;s:4:\"fiji\";i:77;s:7:\"finland\";i:78;s:6:\"france\";i:79;s:16:\"french polynesia\";i:80;s:31:\"french southern antarctic lands\";i:81;s:5:\"gabon\";i:82;s:6:\"gambia\";i:83;s:7:\"georgia\";i:84;s:7:\"germany\";i:85;s:5:\"ghana\";i:86;s:9:\"gibraltar\";i:87;s:6:\"greece\";i:88;s:9:\"greenland\";i:89;s:7:\"grenada\";i:90;s:4:\"guam\";i:91;s:9:\"guatemala\";i:92;s:8:\"guernsey\";i:93;s:13:\"guinea bissau\";i:94;s:6:\"guinea\";i:95;s:6:\"guyana\";i:96;s:5:\"haiti\";i:97;s:8:\"holy see\";i:98;s:8:\"honduras\";i:99;s:9:\"hong kong\";i:100;s:7:\"hungary\";i:101;s:7:\"iceland\";i:102;s:5:\"india\";i:103;s:9:\"indonesia\";i:104;s:4:\"iran\";i:105;s:4:\"iraq\";i:106;s:7:\"ireland\";i:107;s:11:\"isle of man\";i:108;s:5:\"italy\";i:109;s:7:\"jamaica\";i:110;s:5:\"japan\";i:111;s:6:\"jersey\";i:112;s:6:\"jordan\";i:113;s:10:\"kazakhstan\";i:114;s:5:\"kenya\";i:115;s:8:\"kiribati\";i:116;s:6:\"kuwait\";i:117;s:10:\"kyrgyzstan\";i:118;s:4:\"laos\";i:119;s:6:\"latvia\";i:120;s:7:\"lebanon\";i:121;s:7:\"lesotho\";i:122;s:7:\"liberia\";i:123;s:5:\"libya\";i:124;s:13:\"liechtenstein\";i:125;s:9:\"lithuania\";i:126;s:10:\"luxembourg\";i:127;s:5:\"macao\";i:128;s:9:\"macedonia\";i:129;s:10:\"madagascar\";i:130;s:6:\"malawi\";i:131;s:8:\"malaysia\";i:132;s:8:\"maldives\";i:133;s:4:\"mali\";i:134;s:5:\"malta\";i:135;s:16:\"marshall islands\";i:136;s:10:\"mauritania\";i:137;s:9:\"mauritius\";i:138;s:6:\"mexico\";i:139;s:10:\"micronesia\";i:140;s:7:\"moldova\";i:141;s:6:\"monaco\";i:142;s:8:\"mongolia\";i:143;s:10:\"montserrat\";i:144;s:7:\"morocco\";i:145;s:10:\"mozambique\";i:146;s:7:\"myanmar\";i:147;s:7:\"namibia\";i:148;s:5:\"nauru\";i:149;s:5:\"nepal\";i:150;s:20:\"netherlands antilles\";i:151;s:11:\"netherlands\";i:152;s:13:\"new caledonia\";i:153;s:11:\"new zealand\";i:154;s:9:\"nicaragua\";i:155;s:5:\"niger\";i:156;s:7:\"nigeria\";i:157;s:4:\"niue\";i:158;s:14:\"norfolk island\";i:159;s:11:\"north korea\";i:160;s:15:\"northern cyprus\";i:161;s:16:\"northern ireland\";i:162;s:17:\"northern marianas\";i:163;s:6:\"norway\";i:164;s:4:\"oman\";i:165;s:8:\"pakistan\";i:166;s:5:\"palau\";i:167;s:9:\"palestine\";i:168;s:6:\"panama\";i:169;s:16:\"papua new guinea\";i:170;s:8:\"paraguay\";i:171;s:4:\"peru\";i:172;s:11:\"phillipines\";i:173;s:16:\"pitcairn islands\";i:174;s:6:\"poland\";i:175;s:8:\"portugal\";i:176;s:11:\"puerto rico\";i:177;s:5:\"qatar\";i:178;s:7:\"reunion\";i:179;s:7:\"romania\";i:180;s:18:\"russian federation\";i:181;s:6:\"rwanda\";i:182;s:4:\"sami\";i:183;s:5:\"samoa\";i:184;s:10:\"san marino\";i:185;s:17:\"sao tome principe\";i:186;s:4:\"sark\";i:187;s:12:\"saudi arabia\";i:188;s:8:\"scotland\";i:189;s:7:\"seborga\";i:190;s:7:\"senegal\";i:191;s:17:\"serbia montenegro\";i:192;s:10:\"seychelles\";i:193;s:12:\"sierra leone\";i:194;s:9:\"singapore\";i:195;s:8:\"slovakia\";i:196;s:8:\"slovenia\";i:197;s:15:\"solomon islands\";i:198;s:7:\"somalia\";i:199;s:10:\"somaliland\";i:200;s:12:\"south africa\";i:201;s:36:\"south georgia south sandwich islands\";i:202;s:11:\"south korea\";i:203;s:5:\"spain\";i:204;s:9:\"sri lanka\";i:205;s:9:\"st helena\";i:206;s:14:\"st kitts nevis\";i:207;s:8:\"st lucia\";i:208;s:21:\"st vincent grenadines\";i:209;s:5:\"sudan\";i:210;s:8:\"suriname\";i:211;s:9:\"swaziland\";i:212;s:6:\"sweden\";i:213;s:11:\"switzerland\";i:214;s:5:\"syria\";i:215;s:6:\"taiwan\";i:216;s:9:\"tajikstan\";i:217;s:8:\"tanzania\";i:218;s:8:\"thailand\";i:219;s:5:\"tibet\";i:220;s:11:\"timor leste\";i:221;s:4:\"togo\";i:222;s:7:\"tokelau\";i:223;s:5:\"tonga\";i:224;s:15:\"trinidad tobago\";i:225;s:16:\"tristan de cunha\";i:226;s:7:\"tunisia\";i:227;s:6:\"turkey\";i:228;s:12:\"turkmenistan\";i:229;s:20:\"turks caicos islands\";i:230;s:6:\"uganda\";i:231;s:7:\"ukraine\";i:232;s:20:\"united arab emirates\";i:233;s:13:\"united states\";i:234;s:7:\"uruguay\";i:235;s:10:\"uzbekistan\";i:236;s:7:\"vanuatu\";i:237;s:9:\"venezuela\";i:238;s:7:\"vietnam\";i:239;s:14:\"virgin islands\";i:240;s:5:\"wales\";i:241;s:14:\"western sahara\";i:242;s:13:\"western samoa\";i:243;s:5:\"yemen\";i:244;s:10:\"yugoslavia\";i:245;s:5:\"zaire\";i:246;s:6:\"zambia\";i:247;s:8:\"zimbabwe\";}','0','2','0','1','1','','0','0','0','0'
)");
$db->query_write("ALTER TABLE userfield ADD field620 MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist, regex, form, html, perline, profilefieldcategoryid) VALUES ('630','3','0','100','25','630','1','radio','a:2:{i:0;s:3:\"ذكر\";i:1;s:4:\"أنثى\";}','0','1','0','1','1','','0','0','0','0')");
$db->query_write("ALTER TABLE userfield ADD field630 MEDIUMTEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "`usergroup` ADD `maxnewthread` INT(11) DEFAULT '0' NOT NULL ;");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "`usergroup` ADD `maxnewtime` INT(11) DEFAULT '0' NOT NULL ;");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "`usergroup` ADD `maxnewpost` INT(11) DEFAULT '0' NOT NULL ;");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "`usergroup` ADD `maxnewposttime` INT(11) DEFAULT '0' NOT NULL ;");
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
$db->query_write("
CREATE TABLE `" . TABLE_PREFIX . "mwaextraadmin3_nlp_notifications_thread` (
`id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`threadid` INT( 10 ) NOT NULL ,
`threadtitle` VARCHAR( 250 ) NOT NULL ,
`postuserid` INT( 10 ) NOT NULL ,
`postusername` VARCHAR( 100 ) NOT NULL ,
`dateline` INT( 10 ) NOT NULL,
`forumid` INT( 10 ) NOT NULL,
PRIMARY KEY ( `id`, `threadid` )
)ENGINE = MYISAM ;
");
$db->query_write("
CREATE TABLE `" . TABLE_PREFIX . "mwaextraadmin3_nlp_notifications_read` (
`userid` INT( 10 ) NOT NULL ,
`threadid` INT( 10 ) NOT NULL ,
`dateline` INT( 10 ) NOT NULL
)ENGINE = MYISAM ;
");
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "mwaextraadmin3_nlp_vmail
(
`code` text NOT NULL,
`email` text NOT NULL,
`prefix` text NOT NULL,
`dateline` int(10) unsigned NOT NULL default '0'
)
");
$db->query_write("ALTER TABLE " . TABLE_PREFIX . "mwaextraadmin3_nlp_vmail
ADD `day` text NOT NULL,
ADD `month` text NOT NULL,
ADD `year` text NOT NULL");
$vmailtime = TIMENOW;
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "mwaextraadmin3_nlp_vmail`
ADD `location` ENUM( 'register', 'profile' ) NOT NULL,
ADD `userid` INT( 10 ) NOT NULL FIRST
");
$db->query_write("
UPDATE `" . TABLE_PREFIX . "mwaextraadmin3_nlp_vmail`
SET `location` = 'register'
WHERE dateline < $vmailtime");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "mwaextraadmin3_nlp_vmail`
CHANGE `code` `code` VARCHAR( 32 ) NOT NULL ,
CHANGE `email` `email` CHAR( 100 ) NOT NULL ,
CHANGE `prefix` `prefix` VARCHAR( 100 ) NOT NULL ,
CHANGE `day` `day` INT( 2 ) NOT NULL ,
CHANGE `month` `month` INT( 2 ) NOT NULL ,
CHANGE `year` `year` INT( 4 ) NOT NULL");
$db->show_errors();
function mwaextraadmin3_imageresizer_checkdb() {
global $vbulletin;
$fielddefs = array (
'mwaextraadmin3_imageresizer_mode' => array (
'Type' => 'enum(\'none\',\'enlarge\',\'samewindow\',\'newwindow\')',
'Null' => 'YES',
'Default' => NULL,
),
'mwaextraadmin3_imageresizer_maxwidth' => array (
'Type' => 'smallint(5) unsigned',
'Null' => 'YES',
'Default' => NULL,
),
'mwaextraadmin3_imageresizer_maxheight' => array (
'Type' => 'smallint(5) unsigned',
'Null' => 'YES',
'Default' => NULL,
),
);
$fields = array();
$result = $vbulletin->db->query('SHOW FULL COLUMNS FROM `'.TABLE_PREFIX.'user` LIKE "mwaextraadmin3\_imageresizer\_%"');
while($r = $vbulletin->db->fetch_array($result)) {
if(isset($fielddefs[$r['Field']])) {
$fields[$r['Field']] = true;
foreach($fielddefs[$r['Field']] AS $k=>$v) {
if((!is_array($v) && $r[$k] != $v) || (is_array($v) && !in_array($r[$k], $v))) {
$fields[$r['Field']] = false;
break;
}
}
}
}
$sqls = array();
foreach($fielddefs AS $field=>$def)
if(!isset($fields[$field]) || $fields[$field] === false)
$sqls[] = (!isset($fields[$field]) ? 'ADD' : 'CHANGE `'.$field.'`').' `'.$field.'` '.$def['Type'].' DEFAULT '.($def['Default'] == NULL ? 'NULL' : '"'.$def['Default'].'"').' '.($def['Null'] == 'YES' ? 'NULL' : 'NOT NULL');
return $sqls;
}
$sqls = mwaextraadmin3_imageresizer_checkdb();
if(count($sqls) > 0) {
$sql = 'ALTER TABLE `'.TABLE_PREFIX.'user` '.implode(', ', $sqls);
$vbulletin->db->query_write($sql);
$sqls = mwaextraadmin3_imageresizer_checkdb();
if(count($sqls) > 0) {
if(!defined('DISABLE_PRODUCT_REDIRECT')) define('DISABLE_PRODUCT_REDIRECT', 1);
print_form_header('', '', 0, 1, 'messageform', '65%');
print_table_header('حدث خطأ');
print_description_row('
حدث خطأ اثناء محاولة تنفيذ استعلام لقاعدة البيانات ويرجى تنفيذ الإستعلام التالي من قبلك ليعمل الهاك بشكل صحيح
');
print_table_footer();
}
}
$db->query_write("CREATE TABLE ".TABLE_PREFIX."whoread (
userid int(10) unsigned NOT NULL default 0,
threadid int(10) unsigned NOT NULL default 0,
dateline int(10) unsigned NOT NULL default 0,
ipaddress varchar(20) NOT NULL default '',
PRIMARY KEY (userid,threadid),
KEY dateline (threadid,dateline),
KEY ipaddress (ipaddress))
");
$count = 1;
$db->hide_errors();
$db->query_write("TRUNCATE ".TABLE_PREFIX."whoread");
$data = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."threadread");
while ($list = $vbulletin->db->fetch_array($data))
{
$count += 1;
$time = $list['readtime'];
$userid = $list['userid'];
$threadid = $list[threadid];
$db->query_write("INSERT INTO ".TABLE_PREFIX."whoread
(userid, threadid, dateline, ipaddress)
VALUES ($userid, $threadid, $time, '')
");
if (!($count%1000)) echo 'Processed '.$count.' Records'; vbflush();
}
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin3_msgpopup");
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin3_msgpopupuser");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "adminhelp (script, action, optionname, displayorder, volatile, product) VALUES ('mwaextraadmin3_msgpopup', 'edit', 'user', 1, 1, 'mwaextraadmin3_msgpopup')");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "adminhelp (script, action, optionname, displayorder, volatile, product) VALUES ('mwaextraadmin3_msgpopup', '', 'user', 1, 1, 'mwaextraadmin3_msgpopup')");
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "mwaextraadmin3_msgpopup
(
`id` int(10) NOT NULL auto_increment,
`msg` text NOT NULL,
`usergroup` varchar(50) NOT NULL default '',
`user` varchar(50) NOT NULL default '',
`refarelink` varchar(250) NOT NULL default '',
`active` smallint(1) NOT NULL default '1',
`dateline` int(10) NOT NULL default '0',
`timeout` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
)
");
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "mwaextraadmin3_msgpopupuser
(
`id` int(50) NOT NULL auto_increment,
`userid` int(10) NOT NULL default '0',
`msgid` int(10) NOT NULL default '0',
`done` smallint(1) NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
)
");
$vbulletin->db->query_write("CREATE TABLE IF NOT EXISTS`". TABLE_PREFIX ."mwaextraadmin3_CybLTOUA` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`mwaextraadmin3_CybLTOUAadmins` VARCHAR(50) DEFAULT '1' NOT NULL,
`mwaextraadmin3_CybLTOUAadminsb` VARCHAR(50) DEFAULT '1' NOT NULL)
");
$vbulletin->db->query_write("
INSERT INTO ". TABLE_PREFIX ."mwaextraadmin3_CybLTOUA
(id, mwaextraadmin3_CybLTOUAadmins, mwaextraadmin3_CybLTOUAadminsb)
VALUES ('1', '1', '1')
");
$column_add_q = "ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `que` INT UNSIGNED DEFAULT '0' NOT NULL";
$vbulletin->db->query_write($column_add_q);
// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
$SQL = 'CREATE TABLE ' . TABLE_PREFIX . 'y2ksw_imgcache ('
. 'ID INT NOT NULL AUTO_INCREMENT, '
. 'PRIMARY KEY (ID)'
. ') '
. 'TYPE = myisam';
$db->query_write($SQL);
$db->show_errors();
$vbulletin->db->hide_errors();
require_once(DIR . '/includes/class_dbalter.php');
$alter_mood =& new vB_Database_Alter_MySQL($vbulletin->db);
$alter_mood->fetch_table_info('user');
$alter_mood->add_field( array(array('name' => 'vmood', 'type' => 'varchar', 'length'=> 100,'null' => false, 'default' => 'none')));
$vbulletin->db->show_errors();
]]>
hide_errors();
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid = '610'");
$db->query_write("ALTER TABLE userfield DROP field610");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid = '620'");
$db->query_write("ALTER TABLE userfield DROP field620");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "profilefield WHERE profilefieldid = '630'");
$db->query_write("ALTER TABLE userfield DROP field630");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup`
DROP `maxnewthread`,
DROP `maxnewpost`,
DROP `maxnewtime`,
DROP `maxnewposttime`;");
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
$db->query_write("
DROP TABLE `" . TABLE_PREFIX . "mwaextraadmin3_nlp_notifications_read` ,`" . TABLE_PREFIX . "mwaextraadmin3_nlp_notifications_thread`
");
$db->query_write("DROP TABLE " . TABLE_PREFIX . "mwaextraadmin3_nlp_vmail");
$db->show_errors();
function mwaextraadmin3_imageresizer_checkdb() {
global $vbulletin;
$allfields = array('mwaextraadmin3_imageresizer_mode', 'mwaextraadmin3_imageresizer_maxwidth', 'mwaextraadmin3_imageresizer_maxheight');
$fields = array();
$result = $vbulletin->db->query('SHOW FULL COLUMNS FROM `'.TABLE_PREFIX.'user` LIKE "mwaextraadmin3\_imageresizer\_%"');
while($r = $vbulletin->db->fetch_array($result)) {
if(in_array($r['Field'], $allfields)) {
$fields[] = $r['Field'];
}
}
}
$fields = mwaextraadmin3_imageresizer_checkdb();
if(count($fields) > 0) {
$sql = 'ALTER TABLE `'.TABLE_PREFIX.'user` DROP `'.implode('`, DROP `', $fields).'`';
$vbulletin->db->query_write($sql);
$fields = mwaextraadmin3_imageresizer_checkdb();
if(count($fields) > 0) {
if(!defined('DISABLE_PRODUCT_REDIRECT')) define('DISABLE_PRODUCT_REDIRECT', 1);
print_form_header('', '', 0, 1, 'messageform', '65%');
print_table_header('حدث خطأ');
print_description_row('
محاولة تنفيذ استعلام لقاعدة البيانات فاشلة ويتوجب تنفيذ الإستعلام التالي من قبلك
');
print_table_footer();
}
}
$db->query_write("DROP TABLE ".TABLE_PREFIX."whoread");
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin3_msgpopup");
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin3_msgpopupuser");
$db->query_write("DELETE FROM " . TABLE_PREFIX . "adminhelp WHERE product = 'mwaextraadmin3_msgpopup'");
$vbulletin->db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin3_CybLTOUA");
$column_add_q = "ALTER TABLE `" . TABLE_PREFIX . "usergroup` DROP `que`";
$vbulletin->db->query_write($column_add_q);
// Rebuild Bitfields
require_once(DIR . '/includes/class_bitfield_builder.php');
vB_Bitfield_Builder::save($db);
build_forum_permissions();
/*
$SQL = "DROP TABLE IF EXISTS " . TABLE_PREFIX . "y2ksw_imgcache";
$db->query_write($SQL);
*/
$vbulletin->db->hide_errors();
require_once(DIR . '/includes/class_dbalter.php');
$alter_mood =& new vB_Database_Alter_MySQL($vbulletin->db);
$alter_mood->fetch_table_info('user');
$alter_mood->drop_field('vmood');
$vbulletin->db->show_errors();
]]>
| {$vboptions['mwaextraadmin3_athkar_title']} |
| {$vboptions['mwaextraadmin3_athkar_title']} | $mwasepgif $mwaextraadmin3_athkar_thread_texta $mwasepgif |
$vbphrase[mwaextraadmin3_copypmdel_delhead1]
|
|
|