| | | | الله يجزاكم خير اخواني على مساعدة الأعضاء وهذا العشم فيكم ..
اخواني انا منتداي فيه مشاكل كثيرة ولكها رقم " 1054 "
وصلني ما يقارب 400 إيميل انه في أخطاء وكلها هذا الرقم الي ذكرته لكم ..
تابعت بعض الحلول وزرعت بعض الجداول والآن فقط فتحت رئيسية المنتدى وئيسية الأقسام ولا أقدر أتحكم بالباقي ..
حتى الصفحات الي فتحت فيها أخطاء والكلام ممسوح وغيره ..
وهذا الامر حدث فجأة من نفسه ..
ووقفت جميع الهاكات من الكونفينق ونفس الحالة ..
وأعتقد إنه الإشكال من ملف اللغة الي انا مركبه لأنه كل الأخطاء الي وصلتني عالإيميل فيها اللغة ..
لكن للاسف ما أعرف شلون أغيرها لأنه لوحة التحكم للمنتدى ما تفتح ...!!
فياليت أحد يقدر يساعدني وهذي صفحة المنتدى alsohab.com
والله يجزاكم خير ..
__________________
=============
شدوا يداً فركابنا لا ترتضي دنيا العفن
رباه أصلح شأننا وشباب أمتنا معاً
============= |
19-07-2008, 11:52 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة مبرمج عربى الله يجزاكم خير اخواني على مساعدة الأعضاء وهذا العشم فيكم ..
اخواني انا منتداي فيه مشاكل كثيرة ولكها رقم " 1054 "
وصلني ما يقارب 400 إيميل انه في أخطاء وكلها هذا الرقم الي ذكرته لكم ..
تابعت بعض الحلول وزرعت بعض الجداول والآن فقط فتحت رئيسية المنتدى وئيسية الأقسام ولا أقدر أتحكم بالباقي ..
حتى الصفحات الي فتحت فيها أخطاء والكلام ممسوح وغيره ..
وهذا الامر حدث فجأة من نفسه ..
ووقفت جميع الهاكات من الكونفينق ونفس الحالة ..
وأعتقد إنه الإشكال من ملف اللغة الي انا مركبه لأنه كل الأخطاء الي وصلتني عالإيميل فيها اللغة ..
لكن للاسف ما أعرف شلون أغيرها لأنه لوحة التحكم للمنتدى ما تفتح ...!!
فياليت أحد يقدر يساعدني وهذي صفحة المنتدى alsohab.com
والله يجزاكم خير .. |
السلام عليكم
عزيزي الخطاً هذا غالباً من الهاكات بالتأكيد .
لكن جيبلي الرسالة للايرور براسة واشوفلك حلك الآن بأذن الله ..
|
27-07-2008, 12:50 PM
| | | | | | | | اخوي خالد اشوفك انت الوحيد اللي ترد
مشكلتي عرضتها في الصفحة 28 من كم شهر ولاحد حاول يساعدني اعرضها من جديد
والمشكلة تظهر في لوحة التحكم عند محاولة اجراء اي تعديل على خصائص المجموعات
توجهني هذه المشكلة في لوحة التحكم اذا حاولت اعدل اي مجموعة
Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'المشرفات',
`description` = '',
`usertitle` = 'مشرفة',
`opentag` = '<b><font color=\"#cc0099\"> ',
`closetag` = '</font><img border=\"0\" src=\"images/star2.gif\" width=\"16\" height=\"16\"> ',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`nbmsgshowchatbox` = '',
`mgccustomusergroupperms` = '0',
`forumpermissions` = '1048575',
`genericpermissions` = '535762639',
`attachlimit` = '0',
`pmquota` = '70',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=15;
MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Sunday, July 6th 2008 @ 08:04:13 PM
Script : http://************/usergroup.php?do=update
Referrer : http://***********/usergroup.php?do=edit&usergroupid=15
Username : ******
Classname : vb_database
كما تواجهني مشكلة اخرى هي كالتالي عند استعراض بعض المواضيع
Database error in vBulletin 3.6.4: Invalid SQL:SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=; MySQL Error : 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 '' at line 1Error Number : 1064Date : Sunday, July 6th 2008 @ 08:03:45 PMScript : http://********/external.php?type=RS...ids=21Referrer : IP Address : *****: ÛíÑ ãÓÌáClassname : vb_database
فهل نجد لديكم الحل
__________________
صلو على الحبيب |
31-07-2008, 03:50 PM
| | | | | | | | السلام عليكم
يعطيكم العافيه على مجهودكم .. والله يجزاكم رضاه والجنه
عندي مشكله عند فتح الملف الشخصي لأي عضو
وهذا نص الايرور
Fatal error: Call to a member function on a non-object in /home/el6erco/public_html/vb/includes/functions.php(1420) : eval()'d code on line 2
يعطيكم العافيه
وبانتظار حلولكم
|
08-08-2008, 02:57 PM
| | | | | | | | السلام عليكم مشكله
بعد الترقيه .. نريد لها حجل جزاكم الله خير مع العلم
اني قمت بترقيات كثيرة ولاول مرة تظهر لي المشكله !!!
3.6.8 الى 3.7.2
عند الدخول للوحه التحكم :
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Date : Thursday, August 14th 2008 @ 10:48:05 PM
Script : http://vb3.*****.com/t7km/index.php?do=home
Referrer : http://vb3.*****.com/t7km/index.php?do=nav
IP Address : **.**.**.**
Username : drami
Classname : vB_Database
آخر تعديل بواسطة ياحبايب في 15-08-2008 الساعة 06:00 AM.
|
15-08-2008, 05:57 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة jeddah اخوي خالد اشوفك انت الوحيد اللي ترد
مشكلتي عرضتها في الصفحة 28 من كم شهر ولاحد حاول يساعدني اعرضها من جديد
والمشكلة تظهر في لوحة التحكم عند محاولة اجراء اي تعديل على خصائص المجموعات
توجهني هذه المشكلة في لوحة التحكم اذا حاولت اعدل اي مجموعة
Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'المشرفات',
`description` = '',
`usertitle` = 'مشرفة',
`opentag` = '<b><font color=\"#cc0099\"> ',
`closetag` = '</font><img border=\"0\" src=\"images/star2.gif\" width=\"16\" height=\"16\"> ',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`nbmsgshowchatbox` = '',
`mgccustomusergroupperms` = '0',
`forumpermissions` = '1048575',
`genericpermissions` = '535762639',
`attachlimit` = '0',
`pmquota` = '70',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=15;
MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Sunday, July 6th 2008 @ 08:04:13 PM
Script : http://************/usergroup.php?do=update
Referrer : http://***********/usergroup.php?do=edit&usergroupid=15
Username : ******
Classname : vb_database
كما تواجهني مشكلة اخرى هي كالتالي عند استعراض بعض المواضيع
Database error in vBulletin 3.6.4: Invalid SQL:SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=; MySQL Error : 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 '' at line 1Error Number : 1064Date : Sunday, July 6th 2008 @ 08:03:45 PMScript : http://********/external.php?type=RS...ids=21Referrer : IP Address : *****: ÛíÑ ãÓÌáClassname : vb_database
فهل نجد لديكم الحل |
اخي الكريم اوقف الهاكات وهو هاك المحادثه احذفه واعد تركيبه من جديد
طريقه توقيف الهاكات الطريقه الصحيحه من ملف الــConfig.php
في اخر الملف قبل علامه ?> كود: define('DISABLE_HOOKS', 1); إقتباس:
المشاركة الأصلية بواسطة Dr.osamA |
اخي الكريم اعد عمل يوزر ftp جديد فأن شاء الله يعمل واذا لم يتم العمل قم بتبليغ السيرفر لحل المشكله .... إقتباس:
المشاركة الأصلية بواسطة rooor السلام عليكم
يعطيكم العافيه على مجهودكم .. والله يجزاكم رضاه والجنه
عندي مشكله عند فتح الملف الشخصي لأي عضو
وهذا نص الايرور
Fatal error: Call to a member function on a non-object in /home/el6erco/public_html/vb/includes/functions.php(1420) : eval()'d code on line 2
يعطيكم العافيه
وبانتظار حلولكم | اوقف الهاكات اخي الكريم وشوف هاك ايش التي مسوي الخطأ وقم بأيقاف الهاك .... إقتباس:
المشاركة الأصلية بواسطة ياحبايب السلام عليكم مشكله
بعد الترقيه .. نريد لها حجل جزاكم الله خير مع العلم
اني قمت بترقيات كثيرة ولاول مرة تظهر لي المشكله !!!
3.6.8 الى 3.7.2
عند الدخول للوحه التحكم :
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT COUNT(*) AS count
FROM moderation AS moderation
INNER JOIN post AS post USING (postid)
WHERE moderation.type='reply';
MySQL Error : Unknown column 'postid' in 'from clause'
Error Number : 1054
Date : Thursday, August 14th 2008 @ 10:48:05 PM
Script : http://vb3.*****.com/t7km/index.php?do=home
Referrer : http://vb3.*****.com/t7km/index.php?do=nav
IP Address : **.**.**.**
Username : drami
Classname : vB_Database | اوقف الهاكات وبالذات اوقف هاك اخفاء الموضوع لكتابه رد
|
18-08-2008, 05:37 AM
| | | | | | | | إقتباس: Database error in vBulletin 3.7.2:
Invalid SQL:
INSERT INTO post
(showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, dateline, ipaddress, attach, threadid)
VALUES
(1, 1, 'M!do', 10, 'تجربة كمان', 'الوووووووووووووووووووووو', 0, 1, 1220358785, '', 0, 25114);
MySQL Error : Duplicate entry '137101' for key 1
Error Number : 1062
Request Date : Tuesday, September 2nd 2008 @ 03:33:05 PM
Error Date : Tuesday, September 2nd 2008 @ 03:33:05 PM
Script : EgyMedicine.CoM
Referrer : EgyMedicine.CoM
IP Address : 41.233.6.191
Username : M!do
Classname : vB_Database
MySQL Version : 4.1.22-standard | رمضان كريم
|
02-09-2008, 03:36 PM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة d3d7 |
اخي يبدو اني لديك مشكله وهي :
ارجو اضافه هذا الكود عن طريق الــ phpmyadmin كود: ALTER TABLE `adminhelp` CHANGE `adminhelpid` `adminhelpid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `adminlog` CHANGE `adminlogid` `adminlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `announcement` CHANGE `announcementid` `announcementid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `attachment` CHANGE `attachmentid` `attachmentid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `avatar` CHANGE `avatarid` `avatarid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `bbcode` CHANGE `bbcodeid` `bbcodeid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendar` CHANGE `calendarid` `calendarid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendarcustomfield` CHANGE `calendarcustomfieldid` `calendarcustomfieldid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendarmoderator` CHANGE `calendarmoderatorid` `calendarmoderatorid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `calendarpermission` CHANGE `calendarpermissionid` `calendarpermissionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cron` CHANGE `cronid` `cronid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `cronlog` CHANGE `cronlogid` `cronlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `event` CHANGE `eventid` `eventid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `forum` CHANGE `forumid` `forumid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `forumpermission` CHANGE `forumpermissionid` `forumpermissionid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `holiday` CHANGE `holidayid` `holidayid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `icon` CHANGE `iconid` `iconid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `imagecategory` CHANGE `imagecategoryid` `imagecategoryid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `language` CHANGE `languageid` `languageid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `moderator` CHANGE `moderatorid` `moderatorid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `moderatorlog` CHANGE `moderatorlogid` `moderatorlogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `paymentapi` CHANGE `paymentapiid` `paymentapiid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `paymentinfo` CHANGE `paymentinfoid` `paymentinfoid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `paymenttransaction` CHANGE `paymenttransactionid` `paymenttransactionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `phrase` CHANGE `phraseid` `phraseid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `plugin` CHANGE `pluginid` `pluginid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pm` CHANGE `pmid` `pmid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pmtext` CHANGE `pmtextid` `pmtextid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `poll` CHANGE `pollid` `pollid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `pollvote` CHANGE `pollvoteid` `pollvoteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `post` CHANGE `postid` `postid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `productcode` CHANGE `productcodeid` `productcodeid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `profilefield` CHANGE `profilefieldid` `profilefieldid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `ranks` CHANGE `rankid` `rankid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `reminder` CHANGE `reminderid` `reminderid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `reputation` CHANGE `reputationid` `reputationid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `reputationlevel` CHANGE `reputationlevelid` `reputationlevelid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `search` CHANGE `searchid` `searchid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `smilie` CHANGE `smilieid` `smilieid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `style` CHANGE `styleid` `styleid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscribeevent` CHANGE `subscribeeventid` `subscribeeventid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscribeforum` CHANGE `subscribeforumid` `subscribeforumid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscribethread` CHANGE `subscribethreadid` `subscribethreadid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscription` CHANGE `subscriptionid` `subscriptionid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `subscriptionlog` CHANGE `subscriptionlogid` `subscriptionlogid` MEDIUMINT( 8 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `template` CHANGE `templateid` `templateid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `templatehistory` CHANGE `templatehistoryid` `templatehistoryid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `thread` CHANGE `threadid` `threadid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `threadrate` CHANGE `threadrateid` `threadrateid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `upgradelog` CHANGE `upgradelogid` `upgradelogid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `user` CHANGE `userid` `userid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `useractivation` CHANGE `useractivationid` `useractivationid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usergroup` CHANGE `usergroupid` `usergroupid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usergroupleader` CHANGE `usergroupleaderid` `usergroupleaderid` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usergrouprequest` CHANGE `usergrouprequestid` `usergrouprequestid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usernote` CHANGE `usernoteid` `usernoteid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `usertitle` CHANGE `usertitleid` `usertitleid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `userpromotion` CHANGE `userpromotionid` `userpromotionid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `word` CHANGE `wordid` `wordid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT;
|
04-09-2008, 10:50 AM
| | | | | | | | اخوي وين بالضبط اضيفها ؟؟؟؟
في اي جدول
|
10-09-2008, 06:28 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة d3d7 اخوي وين بالضبط اضيفها ؟؟؟؟
في اي جدول | هلا ا خوي ادخل على phpmyadmin
تم sql وحط الامر لي عطاك اخونا احمد تم
سوي تنفيد
|
11-09-2008, 03:26 PM
| | | | | | | | إقتباس: Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,
spamlog.postid AS spamlog_postid,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 22 AND postparsed.languageid = 1)
LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 22 AND sigparsed.languageid = 1)
LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
WHERE post.postid IN (0,23306,23310,23352,23368,23391,23771,23827,24066,24096,62123)
ORDER BY post.dateline;
MySQL Error : Table 'postparsed' is marked as crashed and should be repaired
Error Number : 1194
Request Date : Wednesday, September 17th 2008 @ 08:07:53 AM
Error Date : Wednesday, September 17th 2008 @ 08:07:53 AM
Script : http://www..com/forums/showthread.php?t=12208
Referrer : http://www..com/forums/forumdisplay.php?f=41
IP Address : 62.139.113.114
Username : M!do
Classname : vB_Database
MySQL Version : 4.1.22-standard | رمضااانكريم
|
17-09-2008, 08:13 AM
| | | | | | | | الله اكرم , عزيزي جدول postparsed محذوف من قاعده البيانات فأرجو التأكد منه او قم بأسترجاع الجدول اذا لم يوجد ...
|
22-09-2008, 10:13 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة jeddah اخوي خالد اشوفك انت الوحيد اللي ترد
مشكلتي عرضتها في الصفحة 28 من كم شهر ولاحد حاول يساعدني اعرضها من جديد
والمشكلة تظهر في لوحة التحكم عند محاولة اجراء اي تعديل على خصائص المجموعات
توجهني هذه المشكلة في لوحة التحكم اذا حاولت اعدل اي مجموعة
Database error in vBulletin 3.6.4:
Invalid SQL:
UPDATE usergroup SET
### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'المشرفات',
`description` = '',
`usertitle` = 'مشرفة',
`opentag` = '<b><font color=\"#cc0099\"> ',
`closetag` = '</font><img border=\"0\" src=\"images/star2.gif\" width=\"16\" height=\"16\"> ',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`nbmsgshowchatbox` = '',
`mgccustomusergroupperms` = '0',
`forumpermissions` = '1048575',
`genericpermissions` = '535762639',
`attachlimit` = '0',
`pmquota` = '70',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '13',
`adminpermissions` = '0',
`genericoptions` = '63',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '2000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '4'
WHERE usergroupid=15;
MySQL Error : Unknown column 'nbmsgshowchatbox' in 'field list'
Error Number : 1054
Date : Sunday, July 6th 2008 @ 08:04:13 PM
Script : http://************/usergroup.php?do=update
Referrer : http://***********/usergroup.php?do=edit&usergroupid=15
Username : ******
Classname : vb_database
كما تواجهني مشكلة اخرى هي كالتالي عند استعراض بعض المواضيع
Database error in vBulletin 3.6.4: Invalid SQL:SELECT COUNT(threadid) AS total FROM thread WHERE postuserid=; MySQL Error : 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 '' at line 1Error Number : 1064Date : Sunday, July 6th 2008 @ 08:03:45 PMScript : http://********/external.php?type=RS...ids=21Referrer : IP Address : *****: ÛíÑ ãÓÌáClassname : vb_database
فهل نجد لديكم الحل |
تفضل http://www.mwadah.com/t116461/
|
27-09-2008, 04:51 AM
| | | | | | | | السلام عليكم
تواجهني مشكله من اسبوع تقريبا
طبعا اقدر احل المشكله في عملية اصلاح قواعد البيانات repier
وتنحل المشكله وكل شي اوكي بعدها بيوم ترجع مره اخرى واسوي repier وترجع اليوم الى بعده كود PHP: nvalid SQL:
SELECT posthash.threadid
FROM posthash AS posthash
WHERE posthash.userid = 2 AND
posthash.dupehash = '60c1eb0d8b0da59f7de10f22783b6616' AND
posthash.dateline > 1222530834;
MySQL Error : Table './site_vb/posthash' is marked as crashed and should be repaired
Error Number : 145
__________________
شـــكرا ســوالف
ملاحظه: يستخدم العضويه اكثر من شخص |
27-09-2008, 07:10 PM
| | | | | | | | اخي الكريم تأكد من وجود جدول posthash
معي الرساله بأن الجدول محذوف أرجو التأكد ...........
|
28-09-2008, 11:47 PM
| | | | | | | | تم التأكد من الجدول في MYSQL وهو موجود
لكن يفصل بين فترة واخرى واحتاج عمل repier ومن ثم يعمل لكن العملية ترجع بعد يوم
__________________
شـــكرا ســوالف
ملاحظه: يستخدم العضويه اكثر من شخص |
29-09-2008, 01:59 AM
| | | | | | | | عندي مشكله في حاله الدخول الى اعدادات لوحه التحكم المنتدى .. ونفس الخطا يجيني في حاله الدخول الى الرسائل الخاصه فقط لمجموعه الادمن يطلع لي هالمسج ذا تيبل از فول .. مع العلم ان الهاكات معطله من الكونفيج..
حاولت بكل الطرق اللي مطروحه بالمنتدى من حذف جدول السيزون الى زياده جدول الهيب ماكس ولكن دون فائده ..
حاولت حذف الرسائل الخاصه كلها وضبطت المشكله الاولى حقت الرسائل الخاصه وصار يدخل بدون رسائل خطا .. لكن مشكله السيتنق مازالت موجوده ..
السيرفر توه مرقى ومن هنا طلعت المشكله فمادري كيف الحل .. مع اني فرغت جدول التيمب وحذفت السيزون واعدت بناءه وحذفت برضو ال بي سيزون واعدت بناءه ونفس المشكله ..
اعدت قوالب الاستايل الى الافتراضي .. حاولت بجميع الحلول ماش ماضبطش ..
حاولت نسخ قاعده البيانات وتركيبها مره اخرى عشان اسوي عليها بعض التجارب ياسوي لها ابديت للنسخه الجديده ..
لكن عند محاوله الاسترجاع يظهر لي خطاء جدول الادمن هيلب از فول ..
Database error in vBulletin 3.7.1:
Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;
MySQL Error : The table '' is full
Error Number : 1114
Request Date : Sunday, October 5th 2008 @ 03:47:09 AM
Error Date : Sunday, October 5th 2008 @ 03:48:13 AM
Script : http://www.al9da.net/vb/admincpal9da/options.php?null=0
Referrer : http://www.al9da.net/vb/admincpal9da/index.php?do=nav
Classname : vB_Database
MySQL Version : 4.1.22-standard
المشكله ان رساله الخطا لم تكتب اسم الجدول MySQL Error : The table '' is full
|
05-10-2008, 03:53 AM
| | | | | | | | السلام عليكم اخواني
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT COUNT(postid) AS total, dateline FROM post WHERE userid=19 AND dateline > '1223507038' GROUP BY userid;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, October 9th 2008 @ 11:03:31 PM
Error Date : Thursday, October 9th 2008 @ 11:03:58 PM
Script : http://alra7ba.net/vb/showthread.php?t=277
Referrer :
IP Address : 213.178.224.163
Username : غير مسجل
Classname : vB_Database
MySQL Version : هل من حل لهذه المشكلة ؟؟
شكرا سلفا
تحيااتي
|
10-10-2008, 04:12 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة Q8Start تم التأكد من الجدول في MYSQL وهو موجود
لكن يفصل بين فترة واخرى واحتاج عمل repier ومن ثم يعمل لكن العملية ترجع بعد يوم | اذآ قم بزرع هذا الامر عن طريق الـــPHPMYADMIN كود: CREATE TABLE `posthash` (
`userid` int(10) unsigned NOT NULL default '0',
`threadid` int(10) unsigned NOT NULL default '0',
`postid` int(10) unsigned NOT NULL default '0',
`dupehash` char(32) NOT NULL default '',
`dateline` int(10) unsigned NOT NULL default '0',
KEY `userid` (`userid`,`dupehash`),
KEY `dateline` (`dateline`)
) TYPE=MyISAM;
|
10-10-2008, 08:29 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة haman عندي مشكله في حاله الدخول الى اعدادات لوحه التحكم المنتدى .. ونفس الخطا يجيني في حاله الدخول الى الرسائل الخاصه فقط لمجموعه الادمن يطلع لي هالمسج ذا تيبل از فول .. مع العلم ان الهاكات معطله من الكونفيج..
حاولت بكل الطرق اللي مطروحه بالمنتدى من حذف جدول السيزون الى زياده جدول الهيب ماكس ولكن دون فائده ..
حاولت حذف الرسائل الخاصه كلها وضبطت المشكله الاولى حقت الرسائل الخاصه وصار يدخل بدون رسائل خطا .. لكن مشكله السيتنق مازالت موجوده ..
السيرفر توه مرقى ومن هنا طلعت المشكله فمادري كيف الحل .. مع اني فرغت جدول التيمب وحذفت السيزون واعدت بناءه وحذفت برضو ال بي سيزون واعدت بناءه ونفس المشكله ..
اعدت قوالب الاستايل الى الافتراضي .. حاولت بجميع الحلول ماش ماضبطش ..
حاولت نسخ قاعده البيانات وتركيبها مره اخرى عشان اسوي عليها بعض التجارب ياسوي لها ابديت للنسخه الجديده ..
لكن عند محاوله الاسترجاع يظهر لي خطاء جدول الادمن هيلب از فول ..
Database error in vBulletin 3.7.1:
Invalid SQL:
SELECT setting.*, settinggroup.grouptitle
FROM settinggroup AS settinggroup
LEFT JOIN setting AS setting USING(grouptitle)
WHERE settinggroup.displayorder <> 0
ORDER BY settinggroup.displayorder, setting.displayorder;
MySQL Error : The table '' is full
Error Number : 1114
Request Date : Sunday, October 5th 2008 @ 03:47:09 AM
Error Date : Sunday, October 5th 2008 @ 03:48:13 AM
Script : http://www.al9da.net/vb/admincpal9da/options.php?null=0
Referrer : http://www.al9da.net/vb/admincpal9da/index.php?do=nav
Classname : vB_Database
MySQL Version : 4.1.22-standard
المشكله ان رساله الخطا لم تكتب اسم الجدول MySQL Error : The table '' is full |
يبدو ان في مشكله في خيارات المنتدي .... جدول setting
قم بزرع هذا الامر عن طريق الـــPHPMYADMIN كود: CREATE TABLE `setting` (
`varname` varchar(100) NOT NULL default '',
`grouptitle` varchar(50) NOT NULL default '',
`value` mediumtext,
`defaultvalue` mediumtext,
`optioncode` mediumtext,
`displayorder` smallint(5) unsigned NOT NULL default '0',
`advanced` smallint(6) NOT NULL default '0',
`volatile` smallint(5) unsigned NOT NULL default '0',
`datatype` enum('free','number','boolean','bitfield','username') NOT NULL default 'free',
`product` varchar(25) NOT NULL default '',
`validationcode` text,
`blacklist` smallint(6) NOT NULL default '0',
PRIMARY KEY (`varname`)
) TYPE=MyISAM;
#
# إرجاع أو إستيراد بيانات الجدول `setting`
#
INSERT INTO `setting` VALUES ('multimatchscore', 'searchfunc', '15', '15', '', 100, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowwildcards', 'search_default', '1', '1', 'yesno', 70, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxsearchlength', 'search_default', '20', '20', '', 60, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('goodwords', 'search_default', 'vb vbb php sql', 'vb vbb php sql', 'textarea', 45, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('searchimagecheck', 'search', '1', '1', 'yesno', 130, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('badwords', 'search', '', '', 'textarea', 120, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('similarthreadthreshold', 'search', '3.5', '3.5', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('searchsharing', 'search', '1', '1', 'yesno', 105, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('similarthreadsearch', 'search', '0', '', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('minsearchlength', 'search', '4', '4', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxresults', 'search', '500', '500', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('searchperpage', 'search', '25', '25', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('searchfloodtime', 'search', '0', '0', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('votechange', 'poll', '0', '', 'yesno', 110, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablesearches', 'search', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showvotes', 'poll', '1', '1', '', 100, 0, 1, 'number', 'vbulletin', 'return (intval($data) > 0);', 0);
INSERT INTO `setting` VALUES ('updatelastpost', 'poll', '0', '', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxpolllength', 'poll', '100', '100', '', 15, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxpolloptions', 'poll', '10', '10', '', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('thumbcolor', 'attachment', '#000000', '#000000', '', 80, 0, 1, 'free', 'vbulletin', 'return (preg_match(\'~^#([0-9A-F]{6})$~i\', $data) > 0);', 0);
INSERT INTO `setting` VALUES ('thumbquality', 'attachment', '75', '75', '', 65, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachrow', 'attachment', '5', '5', '', 70, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachthumbssize', 'attachment', '100', '100', '', 60, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachthumbs', 'attachment', '1', '1', 'select:piped\r\n0|no\r\n1|yes\r\n2|yes_with_border\r\n3|yes_with_dimensions\r\n4|yes_with_border_and_dimensions', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('viewattachedimages', 'attachment', '1', '1', 'select:piped\r\n0|no\r\n1|yes\r\n2|only_one_per_post', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachresize', 'attachment', '1', '1', 'yesno', 35, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowduplicates', 'attachment', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowclosedattachdel', 'attachment', '0', '', 'yesno', 27, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowattachdel', 'attachment', '1', '1', 'yesno', 25, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachurlcount', 'attachment', '1', '1', 'select:piped\r\n0|0\r\n1|1\r\n2|2\r\n3|3\r\n4|4\r\n5|5\r\n6|6\r\n7|7\r\n8|8\r\n9|9\r\n10|10', 24, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachlimit', 'attachment', '5', '5', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachboxcount', 'attachment', '1', '1', 'select:piped\r\n0|0\r\n1|1\r\n2|2\r\n3|3\r\n4|4\r\n5|5\r\n6|6\r\n7|7\r\n8|8\r\n9|9\r\n10|10', 23, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('wysiwyg_smtotal', 'postiface', '15', '15', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachtotalspace', 'attachment', '0', '0', '', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smtotal', 'postiface', '15', '15', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smcolumns', 'postiface', '3', '3', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('editormodes', 'postiface', 'a:3:{s:2:"fe";i:2;s:2:"qr";i:2;s:2:"qe";i:2;}', 'a:3:{s:2:"fe";i:2;s:2:"qr";i:2;s:2:"qe";i:2;}', '<!--" . ($setting[\'value\'] = unserialize($setting[\'value\'])) . "-->\r\n<input type=\\"hidden\\" name=\\"setting[$settingid]\\" value=\\"1\\" />\r\n<fieldset>\r\n <legend>$vbphrase[options]</legend>\r\n <div class=\\"smallfont\\" style=\\"margin-top:6px\\">\r\n $vbphrase[full_editor]<br />\r\n <select name=\\"fe\\" tabindex=\\"1\\" class=\\"bginput\\">\r\n <option value=\\"0\\"" . ($setting[\'value\'][\'fe\'] == 0 ? \' selected="selected"\' : \'\') . ">$vbphrase[disable_controls]</option>\r\n <option value=\\"1\\"" . ($setting[\'value\'][\'fe\'] == 1 ? \' selected="selected"\' : \'\') . ">$vbphrase[enable_standard_controls]</option>\r\n <option value=\\"2\\"" . ($setting[\'value\'][\'fe\'] == 2 ? \' selected="selected"\' : \'\') . ">$vbphrase[enable_standard_and_wysiwyg_controls]</option>\r\n </select>\r\n </div>\r\n <div class=\\"smallfont\\" style=\\"margin-top:6px\\">\r\n $vbphrase[quick_reply]<br />\r\n <select name=\\"qr\\" tabindex=\\"1\\" class=\\"bginput\\">\r\n <option value=\\"0\\"" . ($setting[\'value\'][\'qr\'] == 0 ? \' selected="selected"\' : \'\') . ">$vbphrase[disable_controls]</option>\r\n <option value=\\"1\\"" . ($setting[\'value\'][\'qr\'] == 1 ? \' selected="selected"\' : \'\') . ">$vbphrase[enable_standard_controls]</option>\r\n <option value=\\"2\\"" . ($setting[\'value\'][\'qr\'] == 2 ? \' selected="selected"\' : \'\') . ">$vbphrase[enable_standard_and_wysiwyg_controls]</option>\r\n </select>\r\n </div>\r\n <div class=\\"smallfont\\" style=\\"margin-top:6px\\">\r\n $vbphrase[quick_edit]<br />\r\n <select name=\\"qe\\" tabindex=\\"1\\" class=\\"bginput\\">\r\n <option value=\\"0\\"" . ($setting[\'value\'][\'qe\'] == 0 ? \' selected="selected"\' : \'\') . ">$vbphrase[disable_controls]</option>\r\n <option value=\\"1\\"" . ($setting[\'value\'][\'qe\'] == 1 ? \' selected="selected"\' : \'\') . ">$vbphrase[enable_standard_controls]</option>\r\n <option value=\\"2\\"" . ($setting[\'value\'][\'qe\'] == 2 ? \' selected="selected"\' : \'\') . ">$vbphrase[enable_standard_and_wysiwyg_controls]</option>\r\n </select>\r\n </div>\r\n</fieldset>', 5, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('postimagecheck', 'posting', '1', '1', 'yesno', 250, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('logip', 'posting', '1', '1', 'select:piped\r\n0|do_not_log_ip\r\n1|display_but_require_admin_or_mod\r\n2|display_publicly', 240, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('noeditedbytime', 'posting', '2', '2', '', 230, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('addpolltimeout', 'posting', '0', '0', '', 215, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('edittimelimit', 'posting', '0', '0', '', 220, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('editthreadtitlelimit', 'posting', '5', '5', '', 210, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowdynimg', 'posting', '0', '', 'yesno', 70, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('floodchecktime', 'posting', '30', '30', '', 90, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('stopshouting', 'posting', '3', '3', '', 60, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maximages', 'posting', '4', '4', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('quotetitle', 'posting', '0', '', 'yesno', 37, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ignorequotechars', 'posting', '1', '1', 'yesno', 35, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('postmaxchars', 'posting', '10000', '10000', '', 31, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('titlemaxchars', 'posting', '85', '85', '', 32, 0, 1, 'number', 'vbulletin', 'return ($data > 0 AND $data < 251);', 0);
INSERT INTO `setting` VALUES ('postminchars', 'posting', '10', '10', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('mqlimit', 'posting', '0', '0', '', 26, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('multiquote', 'posting', '1', '1', 'yesno', 25, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('quickedit', 'posting', '1', '1', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('quickreply', 'posting', '2', '2', 'radio:piped\r\n0|no\r\n1|yes(,)qr_click_not_required\r\n2|yes(,)qr_click_required', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('codemaxlines', 'bbcode', '30', '30', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowedbbcodes', 'bbcode', '1023', '1023', 'bitfield:nocache|allowedbbcodes', 10, 0, 1, 'bitfield', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('globalignore', 'banning', '', '', '', 50, 0, 1, 'free', 'vbulletin', 'return (preg_match(\'#^(\\d+ *)*$#\', $data) > 0);', 0);
INSERT INTO `setting` VALUES ('allowkeepbannedemail', 'banning', '1', '1', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('aggressiveemailban', 'banning', '0', '0', 'yesno', 31, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('banemail', 'banning', '', '', ' <textarea name=\\"setting[banemail]\\" rows=\\"8\\" cols=\\"40\\" dir=\\"ltr\\" class=\\"bginput\\" tabindex=\\"1\\" title=\\"name="setting[banemail]"\\">" . $vbulletin->banemail . "</textarea>', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('banip', 'banning', '', '', 'textarea', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablebanning', 'banning', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('profilelastpost', 'memberlist', '0', '', 'yesno', 60, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usememberlistadvsearch', 'memberlist', '1', '1', 'yesno', 50, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('memberlistperpage', 'memberlist', '30', '30', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('memberlistfields', 'memberlist', '216', '216', 'bitfield:nocache|memberlistfields', 20, 0, 1, 'bitfield', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('memberlistposts', 'memberlist', '0', '0', '', 15, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablememberlist', 'memberlist', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('uiforumid', 'userinfraction', '0', '0', 'select:eval\r\n$options = construct_forum_chooser_options(1);', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('uimessage', 'userinfraction', '1', '1', 'yesno', 15, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('rpforumid', 'userinfraction', '0', '0', 'select:eval\r\n$options = construct_forum_chooser_options(1);', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('rpuserid', 'userinfraction', '', '', 'username', 30, 0, 1, 'username', 'vbulletin', 'return ($data !== false);', 0);
INSERT INTO `setting` VALUES ('rpemail', 'userinfraction', '1', '1', 'select:piped\r\n0|no_email\r\n1|email_moderators\r\n2|email_moderators_and_administrators', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('reqbirthday', 'user', '0', '0', 'yesno', 5, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ctMaxChars', 'user', '25', '25', '', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ctCensorWords', 'user', 'admin forum moderator vbulletin leader', 'admin forum moderator vbulletin leader', 'textarea', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ctCensorMod', 'user', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('softlinebreakchars', 'user', '90', '90', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowbbcode', 'user', '1', '1', 'yesno', 120, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowsmilies', 'user', '1', '1', 'yesno', 130, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowbbimagecode', 'user', '0', '', 'yesno', 140, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowhtml', 'user', '0', '', 'yesno', 150, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ignoremods', 'user', '0', '', 'yesno', 300, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('avatarenabled', 'userpix', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('numavatarswide', 'userpix', '5', '5', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('numavatarsperpage', 'userpix', '10', '10', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('profilepicenabled', 'userpix', '1', '1', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('reputationenable', 'reputation', '1', '', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('reputationdefault', 'reputation', '10', '10', '', 25, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('reputationundefined', 'reputation', 'is off the scale', 'is off the scale', '', 27, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showuserrates', 'reputation', '5', '5', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('adminpower', 'reputation', '10', '10', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('rdpower', 'reputation', '365', '365', '', 70, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pcpower', 'reputation', '1000', '1000', '', 80, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('kppower', 'reputation', '100', '100', '', 90, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('minreputationpost', 'reputation', '50', '50', '', 100, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('minreputationcount', 'reputation', '10', '10', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxreputationperday', 'reputation', '10', '10', '', 120, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('reputationrepeat', 'reputation', '20', '20', '', 130, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('unallowvbcode', 'usernote', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('unallowsmilies', 'usernote', '1', '1', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('unallowimg', 'usernote', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('unallowhtml', 'usernote', '0', '', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('defaultregoptions', 'register', '4686473', '4686473', '<fieldset>\r\n <legend>$vbphrase[yes] / $vbphrase[no]</legend>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_adminemail\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'adminemail\'] . "\\" id=\\"cb_adminemail\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'adminemail\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[receive_admin_emails]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_invisible\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'invisiblemode\'] . "\\" id=\\"cb_invisible\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'invisiblemode\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[invisible_mode]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_displayemail\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'receiveemail\'] . "\\" id=\\"cb_displayemail\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'receiveemail\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[display_email]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_receivepm\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'enablepm\'] . "\\" id=\\"cb_receivepm\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'enablepm\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[receive_private_messages]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_emailonpm\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'emailonpm\'] . "\\" id=\\"cb_emailonpm\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'emailonpm\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[send_notification_email_when_a_private_message_is_received]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_pmpopup\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'pmpopup\'] . "\\" id=\\"cb_pmpopup\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'pmpopup\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[pop_up_notification_box_when_a_private_message_is_received]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_vcard\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'vcard\'] . "\\" id=\\"cb_vcard\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'vcard\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[allow_vcard_download]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_sig\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'signature\'] . "\\" id=\\"cb_sig\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'signature\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[display_signatures]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_avatar\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'avatar\'] . "\\" id=\\"cb_avatar\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'avatar\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[display_avatars]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_images\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'image\'] . "\\" id=\\"cb_images\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'image\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[display_images]</label>\r\n </div>\r\n <div class=\\"smallfont\\">\r\n <label for=\\"cb_reputation\\"><input type=\\"checkbox\\" name=\\"setting[$setting[varname]][]\\" value=\\"" . $vbulletin->bf_misc_regoptions[\'showreputation\'] . "\\" id=\\"cb_reputation\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'showreputation\']) ? \'checked="checked"\' : \'\') . " />$vbphrase[display_reputation]</label>\r\n </div>\r\n</fieldset>\r\n<br />\r\n<fieldset>\r\n <legend>$vbphrase[options]</legend>\r\n <div class=\\"smallfont\\" style=\\"margin-top:6px\\">\r\n $vbphrase[auto_subscription_mode]<br />\r\n <select name=\\"setting[$setting[varname]][]\\" class=\\"bginput\\">\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'subscribe_none\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'subscribe_none\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[subscribe_choice_none]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'subscribe_nonotify\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'subscribe_nonotify\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[subscribe_choice_0]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'subscribe_instant\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'subscribe_instant\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[subscribe_choice_1]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'subscribe_daily\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'subscribe_daily\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[subscribe_choice_2]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'subscribe_weekly\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'subscribe_weekly\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[subscribe_choice_3]</option>\r\n </select>\r\n </div>\r\n <div class=\\"smallfont\\" style=\\"margin-top:6px\\">\r\n $vbphrase[message_editor_interface]<br />\r\n <select name=\\"setting[$setting[varname]][]\\" class=\\"bginput\\">\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'vbcode_none\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'vbcode_none\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[do_not_show_editor_toolbar]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'vbcode_standard\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'vbcode_standard\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[show_standard_editor_toolbar]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'vbcode_enhanced\']. "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'vbcode_enhanced\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[show_enhanced_editor_toolbar]</option>\r\n </select>\r\n </div>\r\n <div class=\\"smallfont\\" style=\\"margin-top:6px\\">\r\n $vbphrase[thread_display_mode]<br />\r\n <select name=\\"setting[$setting[varname]][]\\" class=\\"bginput\\">\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'thread_linear_oldest\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'thread_linear_oldest\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[linear] - $vbphrase[oldest_first]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'thread_linear_newest\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'thread_linear_newest\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[linear] - $vbphrase[newest_first]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'thread_threaded\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'thread_threaded\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[threaded]</option>\r\n <option value=\\"" . $vbulletin->bf_misc_regoptions[\'thread_hybrid\'] . "\\" " . (bitwise($setting[\'value\'], $vbulletin->bf_misc_regoptions[\'thread_hybrid\']) ? \'selected="selected"\' : \'\') . ">$vbphrase[hybrid]</option>\r\n </select>\r\n </div>\r\n</fieldset>', 130, 0, 1, 'bitfield', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usereferrer', 'register', '1', '1', 'yesno', 120, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('illegalusernames', 'register', '', '', '', 100, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usernameregex', 'register', '', '', '', 105, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxuserlength', 'register', '25', '25', '', 90, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('minuserlength', 'register', '3', '3', '', 80, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('requireuniqueemail', 'register', '1', '1', 'yesno', 70, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('verifyemail', 'register', '0', '', 'yesno', 60, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowmultiregs', 'register', '0', '', 'yesno', 50, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('newuseremail', 'register', '', '', '', 40, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('welcomepm', 'register', '', '', 'username', 35, 0, 1, 'username', 'vbulletin', 'return ($data !== false);', 0);
INSERT INTO `setting` VALUES ('welcomemail', 'register', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('regimagecheck', 'register', '1', '1', 'yesno', 25, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('moderatenewmembers', 'register', '0', '', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('checkcoppa', 'register', '1', '1', 'yesno', 17, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usecoppa', 'register', '0', '0', 'select:piped\r\n0|coppa_disabled\r\n1|coppa_enabled\r\n2|deny_under_13_registration', 15, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('styleid', 'stylelang', '1', '1', 'select:eval\r\n$options = fetch_style_title_options_array();', 50, 0, 1, 'number', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('allowchangestyles', 'stylelang', '1', '1', 'yesno', 60, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('cleargifurl', 'stylelang', 'clear.gif', 'clear.gif', '', 70, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('storecssasfile', 'stylelang', '0', '', 'yesno', 80, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usepopups', 'stylelang', '1', '1', 'yesno', 90, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('legacypostbit', 'stylelang', '1', '', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showimicons', 'stylelang', '1', '1', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('skypeweb_gfx', 'stylelang', '1', '1', 'radio:piped\r\n0|no\r\n1|yes\r\n2|language_specific_skypeweb_graphics', 110, 0, 1, 'number', 'vbulletin', 'return in_array($data, array(0, 1, 2));', 0);
INSERT INTO `setting` VALUES ('enableemail', 'email', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('displayemails', 'email', '1', '1', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('secureemail', 'email', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('emailfloodtime', 'email', '60', '60', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usemailqueue', 'email', '1', '1', 'radio:piped\r\n0|no\r\n1|yes\r\n2|yes_with_locking', 70, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('emailsendnum', 'email', '10', '10', '', 80, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('needfromemail', 'email', '0', '', 'yesno', 90, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('use_smtp', 'email', '0', '', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smtp_host', 'email', '', '', '', 110, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smtp_port', 'email', '25', '25', '', 120, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smtp_user', 'email', '', '', '', 130, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smtp_pass', 'email', '', '', '', 140, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('smtp_tls', 'email', '0', '0', 'yesno', 150, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablecensor', 'censor', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('censorchar', 'censor', '*', '*', '', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('censorwords', 'censor', '', '', 'textarea', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('blankasciistrip', 'censor', '160 173 u8205 u8204 u8237 u8238', '160 173 u8205 u8204 u8237 u8238', '', 40, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowregistration', 'register', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('languageid', 'stylelang', '3', '1', 'radio:eval\r\n$options = fetch_language_titles_array();', 10, 0, 1, 'number', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('ipcheck', 'server', '1', '1', 'select:piped\r\n0|255.255.255.255\r\n1|255.255.255.0\r\n2|255.255.0.0', 260, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('tmppath', 'server', '/tmp', '/tmp', '', 220, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('copypostindex', 'server', '1', '1', 'yesno', 250, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('loadlimit', 'server', '0', '0', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('safeupload', 'server', '0', '', 'yesno', 210, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('attachmentviewslive', 'server', '0', '', 'yesno', 41, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadviewslive', 'server', '0', '', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('cachemaxage', 'server', '7', '7', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('useheaderredirect', 'http', '1', '1', 'yesno', 230, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowphpinfo', 'server', '0', '', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('addheaders', 'http', '0', '', 'yesno', 200, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('nocacheheaders', 'http', '0', '', 'yesno', 220, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('gziplevel', 'http', '1', '1', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('gzipoutput', 'http', '1', '1', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('cookiepath', 'http', '/', '/', 'cookiepath', 20, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('cookiedomain', 'http', '', '', 'cookiedomain', 30, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('cookietimeout', 'http', '900', '900', '', 10, 0, 1, 'number', 'vbulletin', 'return ($data >= 60);', 0);
INSERT INTO `setting` VALUES ('logdateformat', 'datetime', 'H:i, jS M Y', 'H:i, jS M Y', '', 80, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('calformat2', 'datetime', 'F j', 'F j', '', 70, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('calformat1', 'datetime', 'F j, Y', 'F j, Y', '', 60, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('registereddateformat', 'datetime', 'M Y', 'M Y', '', 50, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('timeformat', 'datetime', 'h:i A', 'h:i A', '', 40, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('dateformat', 'datetime', 'm-d-Y', 'm-d-Y', '', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('dstonoff', 'datetime', '0', '', 'yesno', 25, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('timeoffset', 'datetime', '0', '', 'select:eval\r\n$options = fetch_timezones_array();', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('yestoday', 'datetime', '1', '1', 'radio:piped\r\n0|normal\r\n1|yesterday_today\r\n2|detailed', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('magickpath', 'imagesettings', '', '', '', 40, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('regimageoption', 'imagesettings', '15', '15', 'bitfield:nocache|regimageoptions', 30, 0, 1, 'bitfield', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('regimagetype', 'imagesettings', 'GDttf', 'GD', '<select name=\\"setting[$setting[varname]]\\" id=\\"select_setting[regimagetype]\\" tabindex=\\"1\\" class=\\"bginput\\">\r\n<option value=\\"\\" " . iif($setting[\'value\']==\'\',\'selected="selected"\') . ">$vbphrase[none]</option>\r\n<option value=\\"GD\\" " . iif($setting[\'value\']==\'GD\',\'selected="selected"\') . ">$vbphrase[gd_simple_font]</option>\r\n<option value=\\"GDttf\\" " . iif($setting[\'value\']==\'GDttf\',\'selected="selected"\') . ">$vbphrase[gd_ttf_font]</option>\r\n<option value=\\"Magick\\" " . iif($setting[\'value\']==\'Magick\',\'selected="selected"\') . ">ImageMagick 6</option>\r\n</select>\r\n<br />\r\n<br />\r\n<div class=\\"smallfont\\" style=\\"float: $stylevar[left]; padding: 2px\\">\r\nGD<br />\r\n<img src=\\"../image.php?type=regcheck&imagehash=$gdinfo[gdhash]&i=gd\\" alt=\\"GD\\" width=\\"201\\" height=\\"61\\" border=\\"0\\" style=\\"padding: 1px\\" />\r\n</div>\r\n" . (!empty($vbulletin->options[\'magickpath\']) ? "\r\n<div class=\\"smallfont\\" style=\\"float: $stylevar[left]; padding: 2px\\">\r\nImageMagick<br />\r\n<img src=\\"../image.php?type=regcheck&imagehash=$gdinfo[imhash]&i=im\\" alt=\\"ImageMagick\\" width=\\"201\\" height=\\"61\\" border=\\"0\\" style=\\"padding: 1px\\" />\r\n</div>" : \'\') . "', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('imagetype', 'imagesettings', 'GD', 'GD', 'radio:piped\r\n0|None\r\nGD|GD\r\nMagick|ImageMagick 6', 15, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('markinglimit', 'general', '10', '10', '', 350, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('disable_ajax', 'general', '0', '0', 'select:piped\r\n0|enable_all_ajax_features\r\n1|disable_problematic_ajax_features\r\n2|disable_all_ajax_features', 360, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadmarking', 'general', '0', '0', 'radio:piped\r\n0|inactivity_cookie_based\r\n1|database_no_automatic_forum_marking\r\n2|database_automatic_forum_marking', 340, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowedreferrers', 'general', '', '', 'textarea', 330, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('forumleaders', 'general', '1', '1', 'select:piped\r\n0|no\r\n1|yes\r\n2|yes_but_disable_moderators', 320, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usestrikesystem', 'general', '1', '1', 'yesno', 310, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('addtemplatename', 'general', '0', '', 'yesno', 300, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pagenavs', 'general', '10 50 100 500 1000', '10 50 100 500 1000', '', 55, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enableaccess', 'general', '1', '1', 'yesno', 60, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pagenavpages', 'general', '3', '3', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('description', 'general', '', '', '', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('useforumjump', 'general', '1', '1', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('keywords', 'general', '', '', '', 10, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('address', 'address', '', '', '', 110, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('faxnumber', 'address', '', '', '', 100, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('companyname', 'address', '', '', '', 90, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('copyrighttext', 'address', '', '', '', 80, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('privacyurl', 'address', '', '', '', 70, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('webmasteremail', 'address', 'webmaster@localhost', 'webmaster@example.com', '', 60, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('contactusoptions', 'address', 'استفسار\r\nمشكلة بالتسجيل', 'استفسار\r\nمشكلة بالتسجيل', 'textarea', 55, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('contactustype', 'address', '1', '1', 'radio:piped\r\n0|no\r\n1|yes\r\n2|yes_but_verify_image', 53, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('contactuslink', 'address', 'sendmessage.php', 'sendmessage.php', '', 50, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('homeurl', 'address', 'http://localhost', 'http://www.example.com/', '', 40, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('hometitle', 'address', '', 'Home Page', '', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('bburl', 'address', 'http://localhost/vb', 'http://www.example.com/forums', '', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('bbtitle', 'address', 'Forums', 'vBulletin Forums', '', 10, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('bbclosedreason', 'onoff', '<p>المعذر المنتدى متوقف للصيانة.</p>\r\n<p>عاود الزياره لاحقا...</p>', '<p>المعذر المنتدى متوقف للصيانة.</p>\r\n<p>عاود الزياره لاحقا...</p>', 'textarea', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('bbactive', 'onoff', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('fulltextsearch', 'version', '1', '0', 'yesno', 110, 0, 1, 'boolean', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('sigpicurl', 'version', 'signaturepics', 'signaturepics', '', 100, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('sigpicpath', 'version', './signaturepics', './signaturepics', '', 90, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('profilepicurl', 'version', 'customprofilepics', 'customprofilepics', '', 80, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('profilepicpath', 'version', './customprofilepics', './customprofilepics', '', 70, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('avatarurl', 'version', 'customavatars', 'customavatars', '', 60, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('avatarpath', 'version', './customavatars', './customavatars', '', 50, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('usefileavatar', 'version', '0', '', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('attachpath', 'version', '/path/to/your/attachment/directory', '/path/to/your/attachment/directory', '', 30, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('attachfile', 'version', '', '', 'radio:piped\r\n0|no\r\n1|yes(,)userid/userid.attach\r\n2|yes(,)u/s/e/r/i/d/userid.attach', 20, 0, 1, 'free', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('subscriptionmethods', 'version', '0', '0', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 1);
INSERT INTO `setting` VALUES ('templateversion', 'version', '3.6.8', '3.6.8', '', 10, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('datescore', 'searchfunc', '15', '15', '', 175, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadtitlescore', 'searchfunc', '5', '5', '', 200, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('posttitlescore', 'searchfunc', '5', '5', '', 210, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('replyscore', 'searchfunc', '0.1', '0.10', '', 220, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('replyfunc', 'searchfunc', 'none', 'none', '', 225, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('viewscore', 'searchfunc', '0.01', '0.01', '', 230, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('viewfunc', 'searchfunc', 'none', 'none', '', 235, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ratescore', 'searchfunc', '0.5', '0.5', '', 240, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('ratefunc', 'searchfunc', 'none', 'none', '', 245, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('forumhome', 'forumhome', 'index', 'index', '', 1, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('displayloggedin', 'forumhome', '1', '1', 'select:piped\r\n0|no\r\n1|yes_alphabetical_all\r\n3|yes_alphabetical_members\r\n2|yes_random_all\r\n4|yes_random_members', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showbirthdays', 'forumhome', '1', '1', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showevents', 'forumhome', '1', '1', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showholidays', 'forumhome', '1', '1', 'yesno', 43, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showeventtype', 'forumhome', '0', '', 'select:piped\r\n0|group_by_event\r\n1|group_by_date', 45, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('activememberdays', 'forumhome', '30', '30', '', 70, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('activememberoptions', 'forumhome', '3', '3', 'bitfield:nocache|activememberoptions', 80, 0, 1, 'bitfield', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('forumhomedepth', 'forumlist', '2', '2', '', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('forumdisplaydepth', 'forumlist', '2', '2', '', 15, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('subforumdepth', 'forumlist', '0', '0', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showforumdescription', 'forumlist', '1', '1', 'yesno', 25, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showprivateforums', 'forumlist', '0', '0', 'select:piped\r\n0|no\r\n1|yes_hide_post_counts\r\n2|yes_display_post_counts', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showlocks', 'forumlist', '0', '', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('lastthreadchars', 'forumlist', '30', '30', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showmoderatorcolumn', 'forumlist', '0', '', 'yesno', 70, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('nav_forumdesc', 'forumdisplay', '0', '0', 'yesno', 1, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showforumusers', 'forumdisplay', '0', '0', 'select:piped\r\n0|no\r\n1|yes_alphabetical_all\r\n3|yes_alphabetical_members\r\n2|yes_random_all\r\n4|yes_random_members', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxthreads', 'forumdisplay', '20', '20', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showstickies', 'forumdisplay', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showdots', 'forumdisplay', '1', '1', 'yesno', 70, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usehotthreads', 'forumdisplay', '1', '1', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('hotnumberviews', 'forumdisplay', '150', '150', '', 110, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('hotnumberposts', 'forumdisplay', '15', '15', '', 120, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('linktopages', 'forumdisplay', '1', '1', 'yesno', 200, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxmultipage', 'forumdisplay', '3', '3', '', 210, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadpreview', 'forumdisplay', '150', '150', '', 220, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('oneannounce', 'forumdisplay', '1', '1', 'yesno', 230, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showthreadusers', 'showthread', '0', '', 'select:piped\r\n0|no\r\n1|yes_alphabetical_all\r\n3|yes_alphabetical_members\r\n2|yes_random_all\r\n4|yes_random_members', 10, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('maxposts', 'showthread', '10', '10', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('usermaxposts', 'showthread', '5,10,20,30,40', '5,10,20,30,40', '', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showdeficon', 'showthread', 'images/icons/icon1.gif', 'images/icons/icon1.gif', '', 50, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('wordwrap', 'showthread', '50', '50', '', 60, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadvoted', 'showthread', '0', '', 'yesno', 230, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadsubscribed', 'showthread', '1', '1', 'yesno', 240, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('showsimilarthreads', 'showthread', '1', '1', 'yesno', 250, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('postelements', 'showthread', '0', '0', 'bitfield:nocache|postelements', 300, 0, 1, 'bitfield', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('allowthreadedmode', 'threadedmode', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threadedmode', 'threadedmode', '0', '', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threaded_listdepth', 'threadedmode', '5', '5', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threaded_maxcache', 'threadedmode', '40', '40', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('threaded_trimtitle', 'threadedmode', '30', '30', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablepms', 'pm', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('checknewpm', 'pm', '1', '1', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pmmaxchars', 'pm', '5000', '5000', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pmfloodtime', 'pm', '60', '60', '', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pmperpage', 'pm', '50', '50', '', 51, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('pmmaxperpage', 'pm', '100', '100', '', 52, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('privallowicons', 'pm', '1', '1', 'yesno', 100, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('privallowbbcode', 'pm', '1', '1', 'yesno', 110, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('privallowsmilies', 'pm', '1', '1', 'yesno', 120, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('privallowbbimagecode', 'pm', '1', '1', 'yesno', 130, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('privallowhtml', 'pm', '0', '', 'yesno', 140, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('WOLenable', 'online', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('WOLrefresh', 'online', '60', '60', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('WOLguests', 'online', '1', '1', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('WOLresolve', 'online', '0', '', 'yesno', 40, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablespiders', 'online', '0', '', 'yesno', 50, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('archiveenabled', 'archive', '1', '1', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('archive_threadtype', 'archive', '1', '1', 'yesno', 15, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('archive_threadsperpage', 'archive', '250', '250', '', 20, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('archive_postsperpage', 'archive', '250', '250', '', 30, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('cpstylefolder', 'admincp', 'vBulletin_3_Default', 'vBulletin_3_Default', 'cpstylefolder', 10, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('timeoutcontrolpanel', 'admincp', '0', '', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('adminquickstats', 'admincp', '0', '', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('cp_collapse_forums', 'admincp', '0', '', 'radio:piped\r\n0|default\r\n1|collapsible\r\n2|single', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('cp_usereditcolumns', 'admincp', '2', '2', 'radio:piped\r\n1|1\r\n2|2', 50, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('externaljs', 'external', '0', '', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('externalrss', 'external', '0', '', 'yesno', 20, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('rsspodcast', 'external', '1', '1', 'yesno', 27, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('externalxml', 'external', '0', '', 'yesno', 30, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('externalcutoff', 'external', '30', '30', 'input:5', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('externalcache', 'external', '60', '60', 'input:5', 50, 0, 1, 'number', 'vbulletin', 'return ($data > 0 AND $data <= 1440);', 0);
INSERT INTO `setting` VALUES ('externalcount', 'external', '15', '15', '', 60, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('errorlogdatabase', 'errorhandling', '', '', '', 10, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('errorlogsecurity', 'errorhandling', '', '', '', 20, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('errorlogphp', 'errorhandling', '', '', '', 30, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('errorlogemail', 'errorhandling', '', '', '', 35, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('errorlogmaxsize', 'errorhandling', '1048576', '1048576', '', 40, 0, 1, 'number', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('disableerroremail', 'errorhandling', '0', '', 'yesno', 50, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('enablehooks', 'plugin', '1', '0', 'yesno', 10, 0, 1, 'boolean', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('paymentemail', 'paidsubs', '', '', '', 10, 0, 1, 'free', 'vbulletin', '', 0);
INSERT INTO `setting` VALUES ('style_of_best_threads', 'stamps_options', '1', '1', '<select name=\'setting[$setting[varname]]\' tabindex=\'1\' class=\'bginput\'>\r\n<option value=\'0\' " . iif($setting[\'value\']==\'0\',\'selected="selected"\') . ">$vbphrase[move_left]</option>\r\n<option value=\'1\' " . iif($setting[\'value\']==\'1\',\'selected="selected"\') . ">$vbphrase[move_up]</option>\r\n<option value=\'2\' " . iif($setting[\'value\']==\'2\',\'selected="selected"\') . ">$vbphrase[table_simple]</option>\r\n</select>', 10, 0, 1, 'number', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('stamp_position', 'stamps_options', 'top left', 'top left', '<select name=\'setting[$setting[varname]]\' tabindex=\'1\' class=\'bginput\'>\r\n<option value=\'top right\' " . iif($setting[\'value\']==\'top right\',\'selected="selected"\') . ">$vbphrase[top_right]</option>\r\n<option value=\'top center\' " . iif($setting[\'value\']==\'top center\',\'selected="selected"\') . ">$vbphrase[top_center]</option>\r\n<option value=\'top left\' " . iif($setting[\'value\']==\'top left\',\'selected="selected"\') . ">$vbphrase[top_left]</option>\r\n<option value=\'center right\' " . iif($setting[\'value\']==\'center right\',\'selected="selected"\') . ">$vbphrase[center_right]</option>\r\n<option value=\'center left\' " . iif($setting[\'value\']==\'center left\',\'selected="selected"\') . ">$vbphrase[center_left]</option>\r\n<option value=\'bottom right\' " . iif($setting[\'value\']==\'bottom right\',\'selected="selected"\') . ">$vbphrase[bottom_right]</option>\r\n<option value=\'bottom center\' " . iif($setting[\'value\']==\'bottom center\',\'selected="selected"\') . ">$vbphrase[bottom_center]</option>\r\n<option value=\'bottom left\' " . iif($setting[\'value\']==\'bottom left\',\'selected="selected"\') . ">$vbphrase[bottom_left]</option>\r\n</select>', 20, 0, 1, 'free', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('repeat_stamp_pic', 'stamps_options', 'no-repeat', 'no-repeat', '<select name=\'setting[$setting[varname]]\' tabindex=\'1\' class=\'bginput\'>\r\n<option value=\'no-repeat\' " . iif($setting[\'value\']==\'no-repeat\',\'selected="selected"\') . ">$vbphrase[no_repeat]</option>\r\n<option value=\'repeat\' " . iif($setting[\'value\']==\'repeat\',\'selected="selected"\') . ">$vbphrase[repeat]</option>\r\n<option value=\'repeat-x\' " . iif($setting[\'value\']==\'repeat-x\',\'selected="selected"\') . ">$vbphrase[repeat_x]</option>\r\n<option value=\'repeat-y\' " . iif($setting[\'value\']==\'repeat-y\',\'selected="selected"\') . ">$vbphrase[repeat_y]</option>\r\n</select>', 30, 0, 1, 'free', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('stamps_threadchars', 'stamps_options', '35', '35', '', 40, 0, 1, 'number', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('stamps_speed', 'stamps_options', '1', '1', '', 50, 0, 1, 'number', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('stamps_maxthreads', 'stamps_options', '10', '10', '', 60, 0, 1, 'number', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('stamp_limt_days', 'stamps_options', '10', '10', '', 70, 0, 1, 'number', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('stamp_limt2_days', 'stamps_options', '30', '30', '', 80, 0, 1, 'number', 'stamps', '', 0);
INSERT INTO `setting` VALUES ('eed_s', 'eedmokark', '1', '1', 'yesno', 1, 0, 1, 'free', 'eedmobark', '', 0);
INSERT INTO `setting` VALUES ('eed_m', 'eedmokark', '1', '1', '<select name=\\"setting[$setting[varname]]\\" tabindex=\\"1\\" class=\\"bginput\\">\r\n<option value=\\"1\\" " . iif($setting[\'value\']==1,\'selected="selected"\') . ">اسفل الـ Header</option>\r\n<option value=\\"2\\" " . iif($setting[\'value\']==2,\'selected="selected"\') . ">اسفل الـ Navbar</option>\r\n<option value=\\"3\\" " . iif($setting[\'value\']==3,\'selected="selected"\') . ">فوق الـ Footer</option>\r\n</select>', 2, 0, 1, 'free', 'eedmobark', '', 0);
INSERT INTO `setting` VALUES ('b9amkk3', 'eedmokark', '', '', 'هاك تكبيرات العيد\r\n<br>برمجة : معهد التميز\r\n<BR>Linux@x77v.com', 10, 0, 1, 'free', 'eedmobark', '', 0);
|
10-10-2008, 08:29 AM
| | | | | | | | إقتباس:
المشاركة الأصلية بواسطة Dr.osamA السلام عليكم اخواني
Database error in vBulletin 3.7.2:
Invalid SQL:
SELECT COUNT(postid) AS total, dateline FROM post WHERE userid=19 AND dateline > '1223507038' GROUP BY userid;
MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, October 9th 2008 @ 11:03:31 PM
Error Date : Thursday, October 9th 2008 @ 11:03:58 PM
Script : http://alra7ba.net/vb/showthread.php?t=277
Referrer :
IP Address : 213.178.224.163
Username : غير مسجل
Classname : vB_Database
MySQL Version : هل من حل لهذه المشكلة ؟؟
شكرا سلفا
تحيااتي | وعليكم السلام
جرب ايقاف الهاكات , كود PHP: define('DISABLE_HOOKS', 1);
في أخر ملف الكونفج
قبل علامة ?>
واذا لم تكن يرجي الرجوع الى السيرفر والمستضيف وان شاء الله هو يفيدك بحل المشكله بس تأكد المشكله ليست من الهاكات اولآ
|
10-10-2008, 08:33 AM
| | | | | | | | السلام عليكم
عملت اصلاح للقاعده لكن من دون جدوى الاقسام و المواضيع لا تفتح فقط الصفحه الرئيسية
MySQL Error : Table './site_vb/post' is marked as crashed and last (automatic?) repair failed
Error Number : 144
__________________
شـــكرا ســوالف
ملاحظه: يستخدم العضويه اكثر من شخص |
12-10-2008, 06:20 PM
| | | | | | | | شـكرا لك
انحلت المشكله
__________________
شـــكرا ســوالف
ملاحظه: يستخدم العضويه اكثر من شخص |
12-10-2008, 11:17 PM
| | | | | | | |