الموضوع: أدوات المودة المطورة للإدارة الإصدار الرابع ... نسخه نهائية .

تــسلم يالغــآلي ..

فديت التـميز يالغلآ

جاري التركيب .

مـودتي .. }

اخي الفاضل
بعد تركيب الهاك
صفحة المنتدى الرئيسية لا تعمل
وعندما دخلت الى صفحة الهاك في لوحة التحكم وجدت هذا الخطأ
علما بأن النسخة 3.8.4
$db->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:24 8:{i:0;s:12:\"saudi arabia\";i:1;s:11:\"afgha nistan\";i:2;s:7:\"albani a\";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:1 0:\"antarctica\";i:10;s:1 5:\"antigua barbuda\";i:11;s:11:\"ara b league\";i:12;s:9:\"argen tina\";i:13;s:7:\"armenia \";i:14;s:5:\"aruba\";i:1 5;s:5:\"asean\";i:16;s:9: \"australia\";i:17;s:7:\" austria\";i:18;s:10:\"aze rbaijan\";i:19;s:7:\"baha mas\";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:\"ben in\";i:27;s:7:\"bermuda\" ;i:28;s:6:\"bhutan\";i:29 ;s:7:\"bolivia\";i:30;s:1 8:\"bosnia herzegovina\";i:31;s:8:\" botswana\";i:32;s:6:\"bra zil\";i:33;s:7:\"britain\ ";i:34;s:27:\"british antarctic territory\";i:35;s:30:\"b ritish indian ocean territory\";i:36;s:22:\"b ritish virgin islands\";i:37;s:6:\"brun ei\";i:38;s:8:\"bulgaria\ ";i:39;s:12:\"burkina faso\";i:40;s:13:\"burma myanmar\";i:41;s:7:\"buru ndi\";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:\"cayma n islands\";i:47;s:24:\"cen tral african republic\";i:48;s:4:\"cha d\";i:49;s:5:\"chile\";i: 50;s:5:\"china\";i:51;s:1 6:\"christmas island\";i:52;s:8:\"colom bia\";i:53;s:7:\"comoros\ ";i:54;s:17:\"congo brazzaville\";i:55;s:12:\ "9999 islands\";i:56;s:10:\"cos ta rica\";i:57;s:13:\"cote d ivoire\";i:58;s:7:\"croat ia\";i:59;s:4:\"cuba\";i: 60;s:6:\"cyprus\";i:61;s: 13:\"czec republic\";i:62;s:7:\"den mark\";i:63;s:9:\"dijibou ti\";i:64;s:8:\"dominica\ ";i:65;s:18:\"dominic an republic\";i:66;s:10:\"ea st timor\";i:67;s:7:\"ecuado r\";i:68;s:5:\"egypt\";i: 69;s:11:\"el salvador\";i:70;s:17:\"eq uatorial guinea\";i:71;s:7:\"eritr ea\";i:72;s:7:\"estonia\" ;i:73;s:8:\"ethiopia\";i: 74;s:16:\"falkland islands\";i:75;s:6:\"faro es\";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:\"f rench southern antarctic lands\";i:81;s:5:\"gabon\ ";i:82;s:6:\"gambia\";i:8 3;s:7:\"georgia\";i:84;s: 7:\"germany\";i:85;s:5:\" ghana\";i:86;s:9:\"gibral tar\";i:87;s:6:\"greece\" ;i:88;s:9:\"greenland\";i :89;s:7:\"grenada\";i:90; s:4:\"guam\";i:91;s:9:\"g uatemala\";i:92;s:8:\"gue rnsey\";i:93;s:13:\"guine a bissau\";i:94;s:6:\"guine a\";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:\"hungar y\";i:101;s:7:\"iceland\" ;i:102;s:5:\"india\";i:10 3;s:9:\"indonesia\";i:104 ;s:4:\"iran\";i:105;s:4:\ "iraq\";i:106;s:7:\"irela nd\";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:\"ka zakhstan\";i:114;s:5:\"ke nya\";i:115;s:8:\"kiribat i\";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:\"lib eria\";i:123;s:5:\"libya\ ";i:124;s:13:\"liechtenst ein\";i:125;s:9:\"lithuan ia\";i:126;s:10:\"luxembo urg\";i:127;s:5:\"macao\" ;i:128;s:9:\"macedonia\"; i:129;s:10:\"madagascar\" ;i:130;s:6:\"malawi\";i:1 31;s:8:\"malaysia\";i:132 ;s:8:\"maldives\";i:133;s :4:\"mali\";i:134;s:5:\"m alta\";i:135;s:16:\"marsh all islands\";i:136;s:10:\"ma uritania\";i:137;s:9:\"ma uritius\";i:138;s:6:\"mex ico\";i:139;s:10:\"micron esia\";i:140;s:7:\"moldov a\";i:141;s:6:\"monaco\"; i:142;s:8:\"mongolia\";i: 143;s:10:\"montserrat\";i :144;s:7:\"morocco\";i:14 5;s:10:\"mozambique\";i:1 46;s:7:\"myanmar\";i:147; s:7:\"namibia\";i:148;s:5 :\"nauru\";i:149;s:5:\"ne pal\";i:150;s:20:\"nether lands antilles\";i:151;s:11:\"n etherlands\";i:152;s:13:\ "new caledonia\";i:153;s:11:\" new zealand\";i:154;s:9:\"nic aragua\";i:155;s:5:\"nige r\";i:156;s:7:\"nigeria\" ;i:157;s:4:\"niue\";i:158 ;s:14:\"norfolk island\";i:159;s:11:\"nor th korea\";i:160;s:15:\"nort hern cyprus\";i:161;s:16:\"nor thern ireland\";i:162;s:17:\"no rthern marianas\";i:163;s:6:\"no rway\";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:\"para guay\";i:171;s:4:\"peru\" ;i:172;s:11:\"phillipines \";i:173;s:16:\"pitcai rn islands\";i:174;s:6:\"pol and\";i:175;s:8:\"portuga l\";i:176;s:11:\"puerto rico\";i:177;s:5:\"qatar\ ";i:178;s:7:\"reunion\";i :179;s:7:\"romania\";i:18 0;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:\"sa rk\";i:187;s:12:\"saudi arabia\";i:188;s:8:\"scot land\";i:189;s:7:\"seborg a\";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:\"singa pore\";i:195;s:8:\"slovak ia\";i:196;s:8:\"slovenia \";i:197;s:15:\"solomo n islands\";i:198;s:7:\"som alia\";i:199;s:10:\"somal iland\";i:200;s:12:\"sout h africa\";i:201;s:36:\"sou th georgia south sandwich islands\";i:202;s:11:\"so uth 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:\"surin ame\";i:211;s:9:\"swazila nd\";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:\"tim or 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:\"tri stan de cunha\";i:226;s:7:\"tunis ia\";i:227;s:6:\"turkey\" ;i:228;s:12:\"turkmenista n\";i:229;s:20:\"turks caicos islands\";i:230;s:6:\"uga nda\";i:231;s:7:\"ukraine \";i:232;s:20:\"united arab emirates\";i:233;s:13:\"u nited states\";i:234;s:7:\"urug uay\";i:235;s:10:\"uzbeki stan\";i:236;s:7:\"vanuat u\";i:237;s:9:\"venezuela \";i:238;s:7:\"vietnam\"; i:239;s:14:\"virgin islands\";i:240;s:5:\"wal es\";i:241;s:14:\"wester n sahara\";i:242;s:13:\"wes tern samoa\";i:243;s:5:\"yemen \";i:244;s:10:\"yugoslavi a\";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.ph p');
vB_Bitfield_Builder::save ($db);
build_forum_permissions() ;
$db->query_write("
CREATE TABLE `" . TABLE_PREFIX . "mwaextraadmin4_nlp_notif ications_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 . "mwaextraadmin4_nlp_notif ications_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 . "mwaextraadmin4_nlp_v mail
(
`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 . "mwaextraadmin4_nlp_v mail
ADD `day` text NOT NULL,
ADD `month` text NOT NULL,
ADD `year` text NOT NULL");
$vmailtime = TIMENOW;
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "mwaextraadmin4_nlp_vmail `
ADD `location` ENUM( 'register', 'profile' ) NOT NULL,
ADD `userid` INT( 10 ) NOT NULL FIRST
");
$db->query_write("
UPDATE `" . TABLE_PREFIX . "mwaextraadmin4_nlp_vmail `
SET `location` = 'register'
WHERE dateline < $vmailtime");
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "mwaextraadmin4_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 mwaextraadmin4_imageresiz er_checkdb() {
global $vbulletin;

$fielddefs = array (
'mwaextraadmin4_imageresi zer_mode' => array (
'Type' => 'enum(\'none\',\'enlarge\ ',\'samewindow\',\'newwin dow\')',
'Null' => 'YES',
'Default' => NULL,
),
'mwaextraadmin4_imageresi zer_maxwidth' => array (
'Type' => 'smallint(5) unsigned',
'Null' => 'YES',
'Default' => NULL,
),
'mwaextraadmin4_imageresi zer_maxheight' => array (
'Type' => 'smallint(5) unsigned',
'Null' => 'YES',
'Default' => NULL,
),
);

$fields = array();
$result = $vbulletin->db->query('SHOW FULL COLUMNS FROM `'.TABLE_PREFIX.'user` LIKE "mwaextraadmin4\_imageres izer\_%"');
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 = mwaextraadmin4_imageresiz er_checkdb();
if(count($sqls) > 0) {
$sql = 'ALTER TABLE `'.TABLE_PREFIX.'user` '.implode(', ', $sqls);
$vbulletin->db->query_write($sql);

$sqls = mwaextraadmin4_imageresiz er_checkdb();
if(count($sqls) > 0) {
if(!defined('DISABLE_PROD UCT_REDIRECT')) define('DISABLE_PRODUCT_R EDIRECT', 1);
print_form_header('', '', 0, 1, 'messageform', '65%');
print_table_header('حدث خطأ');
print_description_row('<b lockquote><br />حدث خطأ اثناء محاولة تنفيذ استعلام لقاعدة البيانات ويرجى تنفيذ الإستعلام التالي من قبلك ليعمل الهاك بشكل صحيح<br /><br /><textarea cols="100" rows="4" wrap="soft">'.htmlspecial chars($sql).'</textarea><br /><br /></blockquote>');
print_table_footer();
}
}
$db->query_write("CREATE TABLE ".TABLE_PREFIX."whore ad (
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."threadrea d");
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."whore ad
(userid, threadid, dateline, ipaddress)
VALUES ($userid, $threadid, $time, '')
");
if (!($count%1000)) echo '<div align="center">Processed '.$count.' Records</div>'; vbflush();
}
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin4_msgpopup" );
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "mwaextraadmin4_msgpopupu ser");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "adminhelp (script, action, optionname, displayorder, volatile, product) VALUES ('mwaextraadmin4_msgpopup ', 'edit', 'user', 1, 1, 'mwaextraadmin4_msgpopup' )");
$db->query_write("INSERT INTO " . TABLE_PREFIX . "adminhelp (script, action, optionname, displayorder, volatile, product) VALUES ('mwaextraadmin4_msgpopup ', '', 'user', 1, 1, 'mwaextraadmin4_msgpopup' )");
$db->query_write("CREATE TABLE " . TABLE_PREFIX . "mwaextraadmin4_msgpo pup
(
`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 . "mwaextraadmin4_msgpopupu ser
(
`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 ."mwaextraadmin4_CybLTOUA ` (
`id` INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
`mwaextraadmin4_CybLTOUAa dmins` VARCHAR(50) DEFAULT '1' NOT NULL,
`mwaextraadmin4_CybLTOUAa dminsb` VARCHAR(50) DEFAULT '1' NOT NULL)
");
$vbulletin->db->query_write("
INSERT INTO ". TABLE_PREFIX ."mwaextraadmin4_CybLT OUA
(id, mwaextraadmin4_CybLTOUAad mins, mwaextraadmin4_CybLTOUAad minsb)
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.ph p');
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();
$db->hide_errors();
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `phpkd_pmpruneperiod` INT(10) DEFAULT '0' NOT NULL ;");
$db->show_errors();
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "pages_default");
$db->query_write("DROP TABLE IF EXISTS " . TABLE_PREFIX . "pages_visitor");
$db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "pages_default (
pageid int(10) NOT NULL auto_increment,
title varchar(250) NOT NULL default '',
varname varchar(250) NOT NULL default '',
text mediumtext,
bbcode int(1) NOT NULL default '0',
groupids char(250) NOT NULL default '',
countvisit int(10) NOT NULL default '0',
dateline int(10) NOT NULL default '0',
PRIMARY KEY (pageid)
) AUTO_INCREMENT=1");
$db->query_write("CREATE TABLE IF NOT EXISTS " . TABLE_PREFIX . "pages_visitor (
id int(10) NOT NULL auto_increment,
pagesid int(10) NOT NULL,
visitors int(10) NOT NULL default '0',
ip varchar(15) NOT NULL,
dateline int(10) NOT NULL default '0',
PRIMARY KEY (id)
) AUTO_INCREMENT=1");
$db->hide_errors();
// DROP OLD TABLES
$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "psistats_browser`");
$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "psistats_country`");
$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "psistats_os`");
$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "psistats_referrer`") ;
$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "psistats_screendepth `");
$db->query_write("DROP TABLE IF EXISTS `" . TABLE_PREFIX . "psistats_screenresolutio n`");
// CREATE TABLES
$db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "psistats_cache` (
`cdata` varchar(255) NOT NULL default '',
`ctype` varchar(40) NOT NULL default '',
`csid` varchar(255) NOT NULL default '',
UNIQUE KEY `csid` (`csid`)) TYPE=MyISAM
");
$db->query_write("CREATE TABLE IF NOT EXISTS `" . TABLE_PREFIX . "psistats_data` (
`cdata` varchar(100) NOT NULL default '',
`count` int(10) unsigned NOT NULL default '0',
`ctype` varchar(40) NOT NULL default '',
`cmisc` varchar(40) NOT NULL default '',
KEY `ctype` (`ctype`)) TYPE=MyISAM
");
// CREATE CRON ON PRE-3.6.0 VBULLETIN
if (is_newer_version('3.6.0' , $vbulletin->options['templateversion']))
{
$db->query_write("DELETE FROM `" . TABLE_PREFIX ."cron` WHERE `filename` LIKE '%psistats_update.php%' LIMIT 1");
$db->query_write("INSERT INTO `" . TABLE_PREFIX . "cron` VALUES (NULL, 1136665500, -1, -1, -1, 'a:1:{i:0;i:25;}', './includes/cron/psistats_update.php', 1, 'psiStats 2006 Update (15-Minute Interval)')");
}
$db->show_errors();
$db->hide_errors();
$vbulletin->db->query_write("ALTER TABLE `" . TABLE_PREFIX . "user` ADD showcybstats TINYINT( 1 ) DEFAULT '1' NOT NULL");
$cyb_ind_b = false;
$cyb_check_indexes = $vbulletin->db->query_read("SHOW INDEX FROM " . TABLE_PREFIX . "user");
while ($cyb_found_indexes = $vbulletin->db->fetch_array($cyb_check_i ndexes))
{
if ($cyb_found_indexes['Key_name'] == 'post_thanks_thanked_time s')
{
$cyb_ind_b = true;
}
}
if (mysql_query("SELECT post_thanks_thanked_times FROM " . TABLE_PREFIX . "user LIMIT 0") AND !$cyb_ind_b)
{
$vbulletin->db->query_write("ALTER TABLE " . TABLE_PREFIX . "user ADD INDEX (post_thanks_thanked_time s)");
}
$db->show_errors();
$db->query_write("DROP TABLE IF EXISTS `pm_preventor`");
$Query = "ALTER TABLE `".TABLE_PREFIX."usergrou p` CHANGE `opentag` `opentag` TEXT NULL ,CHANGE `closetag` `closetag` TEXT NULL ";
$vbulletin->db->query($Query);

اخي الفاضل
بعد التركيب والتفعيل صفحة المنتدى الرئيسية لا تفتح
وعندما ذهبت الى صفحة الهاك في لوحة التحكم وجدت هذا الخطأ
علما بأن النسخة لدي 3.8.4
$db->hide_errors();
$db->query_write("INSERT INTO " . TABLE_PREFIX . "profilefield (profilefieldid, required, hidden, maxlength, size, displayorder, editable, type, data, height, def, optional, searchable, memberlist,

وباقي الكود في املف المرفق

مشكوور اخوي بس يصير اركبه ع المنتدى >>وهو اصلا فيه مشكله بحيث اني كل ما ادخل الملف الشخصي يقول خطأ بالخادم وما يسمح لي بتعديل اي شئ علما بأن هالمشكله من يوم سويت المنتدى!!!!!!
يعني هالموضوع طبيعي انه ما يظهر الملف الشخصي الين ما اركب هاك ادوات الموده...
علما بأن نسخه المنتدى من البدايه *يعني من الإنشاء* النسخه 384
بلييييييييييييييييييييييز الحل......!؟