Mostafa Megahed
2008/6/16, 1:12 PM
عرض التواقيع - Show Signatures
On: UPDATE user SET options=options + 1 WHERE NOT(options & 1);
Off: UPDATE user SET options=options - 1 WHERE options & 1;
عرض الصور الشخصية - Show Avatars
On: UPDATE user SET options=options + 2 WHERE NOT(options & 2);
Off: UPDATE user SET options=options - 2 WHERE options & 2;
عرض الصور - Show Images
On: UPDATE user SET options=options + 4 WHERE NOT(options & 4);
Off: UPDATE user SET options=options - 4 WHERE options & 4;
مستعمل سي أو بي بي أي الاعضاء القاصرين - COPPA User
Yes: UPDATE user SET options=options + 8 WHERE NOT(options & 8);
No: UPDATE user SET options=options - 8 WHERE options & 8;
إستلمْ رسائل الإدارةِ البريدية إلكترونية - Receive Admin Emails
On: UPDATE user SET options=options + 16 WHERE NOT(options & 16);
Off: UPDATE user SET options=options - 16 WHERE options & 16;
تحميل vCard
On: UPDATE user SET options=options + 32 WHERE NOT(options & 32);
Off: UPDATE user SET options=options - 32 WHERE options & 32;
دي إس تي ذاتي صحيح - DST Auto-Correct
On: UPDATE user SET options=options + 64 WHERE NOT(options & 64);
Off: UPDATE user SET options=options - 64 WHERE options & 64;
DST On/Off تشغيل او اغلاق
On: UPDATE user SET options=options + 128 WHERE NOT(options & 128);
Off: UPDATE user SET options=options - 128 WHERE options & 128;
عرض عنوان البريد الالكترونتي - Show Email Address
On: UPDATE user SET options=options + 256 WHERE NOT(options & 256);
Off: UPDATE user SET options=options - 256 WHERE options & 256;
مخفي - Invisible
On: UPDATE user SET options=options + 512 WHERE NOT(options & 512);
Off: UPDATE user SET options=options - 512 WHERE options & 512;
السمعة - Show Reputation
On: UPDATE user SET options=options + 1024 WHERE NOT(options & 1024);
Off: UPDATE user SET options=options - 1024 WHERE options & 1024;
استلام الرسائل - Receive PMs
On: UPDATE user SET options=options + 2048 WHERE NOT(options & 2048);
Off: UPDATE user SET options=options - 2048 WHERE options & 2048;
استلام البريد الالكتروني للرسائل - Get email for new PMs
On: UPDATE user SET options=options + 4096 WHERE NOT(options & 4096);
Off: UPDATE user SET options=options - 4096 WHERE options & 4096;
اعلام بوصول رسائلة خاصة للعضو - Show New Private Message Notification Pop-up
On: UPDATE user SET pmpopup = 1;
Off: UPDATE user SET pmpopup = 0;
طلب البريد - Post Order
Newest first: UPDATE user SET options=options + 32768 WHERE NOT(options & 32768);
Oldest first: UPDATE user SET options=options - 32768 WHERE options & 32768;
إستلمْ رسائلَ خاصّةَ فقط مِنْ الرفاقِ - Receive Private Messages only from Buddies
On: UPDATE user SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE user SET options=options - 131072 WHERE options & 131072;
Additional queries that aren't covered by the options bitfield
Thread Display Mode- نمط عرض المواضيع
Linear: UPDATE user SET threadedmode=0;
Threaded: UPDATE user SET threadedmode=1;
Hybrid: UPDATE user SET threadedmode=2;
Popup on new PM - فتح قائمة للابلاغ بوجودة رسالة خاصة
On: UPDATE user SET pmpopup=1;
Off: UPDATE user SET pmpopup=0;
Default daysprune setting - ضبط daysprune الافتراضي
UPDATE user SET daysprune=X;
where X is the number of days.
Language - الغة الافتراضية
UPDATE user SET languageid=X;
where X is the ID of the language (you can get this from the admin CP).
Style - الاستايل الافتراضي
UPDATE user SET styleid=X;
where X is the ID of the style (you can get this from the admin CP).
First day of the week - اول ايام الاسبوع
UPDATE user SET startofweek=X;
where X is a number 1 through 7 indicating the first day of the week (with 1 being Sunday, 2 being Monday, etc.).
Message Editor Interface - محرر الكتابة
Do Not Show Editor Toolbar: UPDATE user SET showvbcode=0;
Show Standard Editor Toolbar: UPDATE user SET showvbcode=1;
Show Enhanced (WYSIWYG) Editor Toolbar: UPDATE user SET showvbcode=2;
Thread sub******ion/email notification defaults - اخطار بالاشتراك بالموضوع
Do not subscribe: UPDATE user SET autosubscribe = -1;
Subscribe without notification: UPDATE user SET autosubscribe = 0;
Instant email: UPDATE user SET autosubscribe = 1;
Daily email: UPDATE user SET autosubscribe = 2;
Weekly email: UPDATE user SET autosubscribe = 3;
Show Birthday - عرض يوم الميلاد
Hide Age & Date of Birth: UPDATE user SET showbirthday = 0
Display Age: UPDATE user SET showbirthday = 1
Display Age & Date of Birth: UPDATE user SET showbirthday = 2
Timezoneoffset
UPDATE user SET timezoneoffset = X
where X is the GMT value (0, 2, -5, ...)
Make all forums active/inactive - اجعل كافة المنتديات النشيطة / خاملة
Active: UPDATE forum SET options=options + 1 WHERE NOT(options & 1);
Inactive: UPDATE forum SET options=options - 1 WHERE (options & 1);
Open/Close all forums for new posts - فتح / اغلاق كل المنتديات عن المواضيع الجديدة
Open: UPDATE forum SET options=options + 2 WHERE NOT(options & 2);
Close: UPDATE forum SET options=options - 2 WHERE (options & 2);
Set all forums to act as categories/forums
Act as forums: UPDATE forum SET options=options + 4 WHERE NOT(options & 4);
Act as categories:UPDATE forum SET options=options - 4 WHERE (options & 4);
Turn on/off Post Moderation for all forums - تشغيل او ايقاب Post Moderation من كافة المنتدي
On: UPDATE forum SET options=options + 8 WHERE NOT(options & 8);
Off: UPDATE forum SET options=options - 8 WHERE (options & 8);
Turn on/off Thread Moderation for all forums- تشغيل او ايقاب Thread Moderation من كافة المنتدي
On: UPDATE forum SET options=options + 16 WHERE NOT(options & 16);
Off: UPDATE forum SET options=options - 16 WHERE (options & 16);
Turn on/off Attachment Moderation for all forums- تشغيل او ايقاب Attachment Moderation من كافة المنتدي
On: UPDATE forum SET options=options + 32 WHERE NOT(options & 32);
Off: UPDATE forum SET options=options - 32 WHERE (options & 32);
Turn on/off BBCode for all forums - تشغيل او ايقاب BBCode من كافة المنتدى
On: UPDATE forum SET options=options + 64 WHERE NOT(options & 64);
Off: UPDATE forum SET options=options - 64 WHERE (options & 64);
Turn on/off Images for all forums - تشغيل او ايقاب الصور من كافة المنتدى
On: UPDATE forum SET options=options + 128 WHERE NOT(options & 128);
Off: UPDATE forum SET options=options - 128 WHERE (options & 128);
Turn on/off HTML for all forums - تشغيل او ايقاب HTML من كافة المنتدى
On: UPDATE forum SET options=options + 256 WHERE NOT(options & 256);
Off: UPDATE forum SET options=options - 256 WHERE (options & 256);
Turn on/off Smilies for all forums- تشغيل او ايقاف الابتسامات من كافة المنتدى
On: UPDATE forum SET options=options + 512 WHERE NOT(options & 512);
Off: UPDATE forum SET options=options - 512 WHERE (options & 512);
Turn on/off Post Icons for all forums- تشغيل او ايقاب ايقونات المواضيع لكافة المنتدى
On: UPDATE forum SET options=options + 1024 WHERE NOT(options & 1024);
Off: UPDATE forum SET options=options - 1024 WHERE (options & 1024);
Turn on/off Thread Rating for all forums- تشغيل او ايقاف التقيم من كافة المنتدى
On: UPDATE forum SET options=options + 2048 WHERE NOT(options & 2048);
Off: UPDATE forum SET options=options - 2048 WHERE (options & 2048);
Turn on/off Post Counting for all forums
On: UPDATE forum SET options=options + 4096 WHERE NOT(options & 4096);
Off: UPDATE forum SET options=options - 4096 WHERE (options & 4096);
Set 'Can have Password' on/off for all forums- وضع باسورد لكافة المنتدى
On: UPDATE forum SET options=options + 8192 WHERE NOT(options & 8192);
Off: UPDATE forum SET options=options - 8192 WHERE (options & 8192);
Turn on/off Search Indexing for all forums- تفعيل محرك البحث لكافة المنتدى
On: UPDATE forum SET options=options + 16384 WHERE NOT(options & 16384);
Off: UPDATE forum SET options=options - 16384 WHERE (options & 16384);
Turn on/off Style Overriding for all forums - تشغيل او تفعيل خيار اختيار
الاستايل لكافة المنتدى
On: UPDATE forum SET options=options + 32768 WHERE NOT(options & 32768);
Off: UPDATE forum SET options=options - 32768 WHERE (options & 32768);
Turn on/off 'Show on ForumJump Menu' for all forums
On: UPDATE forum SET options=options + 65536 WHERE NOT(options & 65536);
Off: UPDATE forum SET options=options - 65536 WHERE (options & 65536);
Turn on/off 'Warn Administrators' for all forums- تشغيل او ايقاف تحذير المدير لكافة المنتدى
On: UPDATE forum SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE forum SET options=options - 131072 WHERE (options & 131072);
Verified for 3.6.2 - هذا الامر فقط للنسخه 3.6.2 فما فوق
Turn registration on - تفعيل التسجيل
UPDATE setting SET value = 1 WHERE varname = 'allowregistration';
UPDATE datastore SET data = REPLACE(data, '"allowregistration";i:0', '"allowregistration";i:1') WHERE title = 'options';
Turn registration off- ايقاف التسجيل
UPDATE setting SET value = 0 WHERE varname = 'allowregistration';
UPDATE datastore SET data = REPLACE(data, '"allowregistration";i:1', '"allowregistration";i:0') WHERE title = 'options';
هذا الامر لازالت البيانات الشخصية من الملف الشخصي :
UPDATE `user` SET `homepage` = '', `icq` = '', `aim` = '', `yahoo` = '', `msn` = '', `skype` = '' WHERE `user`.`userid` >= 1
منقول
On: UPDATE user SET options=options + 1 WHERE NOT(options & 1);
Off: UPDATE user SET options=options - 1 WHERE options & 1;
عرض الصور الشخصية - Show Avatars
On: UPDATE user SET options=options + 2 WHERE NOT(options & 2);
Off: UPDATE user SET options=options - 2 WHERE options & 2;
عرض الصور - Show Images
On: UPDATE user SET options=options + 4 WHERE NOT(options & 4);
Off: UPDATE user SET options=options - 4 WHERE options & 4;
مستعمل سي أو بي بي أي الاعضاء القاصرين - COPPA User
Yes: UPDATE user SET options=options + 8 WHERE NOT(options & 8);
No: UPDATE user SET options=options - 8 WHERE options & 8;
إستلمْ رسائل الإدارةِ البريدية إلكترونية - Receive Admin Emails
On: UPDATE user SET options=options + 16 WHERE NOT(options & 16);
Off: UPDATE user SET options=options - 16 WHERE options & 16;
تحميل vCard
On: UPDATE user SET options=options + 32 WHERE NOT(options & 32);
Off: UPDATE user SET options=options - 32 WHERE options & 32;
دي إس تي ذاتي صحيح - DST Auto-Correct
On: UPDATE user SET options=options + 64 WHERE NOT(options & 64);
Off: UPDATE user SET options=options - 64 WHERE options & 64;
DST On/Off تشغيل او اغلاق
On: UPDATE user SET options=options + 128 WHERE NOT(options & 128);
Off: UPDATE user SET options=options - 128 WHERE options & 128;
عرض عنوان البريد الالكترونتي - Show Email Address
On: UPDATE user SET options=options + 256 WHERE NOT(options & 256);
Off: UPDATE user SET options=options - 256 WHERE options & 256;
مخفي - Invisible
On: UPDATE user SET options=options + 512 WHERE NOT(options & 512);
Off: UPDATE user SET options=options - 512 WHERE options & 512;
السمعة - Show Reputation
On: UPDATE user SET options=options + 1024 WHERE NOT(options & 1024);
Off: UPDATE user SET options=options - 1024 WHERE options & 1024;
استلام الرسائل - Receive PMs
On: UPDATE user SET options=options + 2048 WHERE NOT(options & 2048);
Off: UPDATE user SET options=options - 2048 WHERE options & 2048;
استلام البريد الالكتروني للرسائل - Get email for new PMs
On: UPDATE user SET options=options + 4096 WHERE NOT(options & 4096);
Off: UPDATE user SET options=options - 4096 WHERE options & 4096;
اعلام بوصول رسائلة خاصة للعضو - Show New Private Message Notification Pop-up
On: UPDATE user SET pmpopup = 1;
Off: UPDATE user SET pmpopup = 0;
طلب البريد - Post Order
Newest first: UPDATE user SET options=options + 32768 WHERE NOT(options & 32768);
Oldest first: UPDATE user SET options=options - 32768 WHERE options & 32768;
إستلمْ رسائلَ خاصّةَ فقط مِنْ الرفاقِ - Receive Private Messages only from Buddies
On: UPDATE user SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE user SET options=options - 131072 WHERE options & 131072;
Additional queries that aren't covered by the options bitfield
Thread Display Mode- نمط عرض المواضيع
Linear: UPDATE user SET threadedmode=0;
Threaded: UPDATE user SET threadedmode=1;
Hybrid: UPDATE user SET threadedmode=2;
Popup on new PM - فتح قائمة للابلاغ بوجودة رسالة خاصة
On: UPDATE user SET pmpopup=1;
Off: UPDATE user SET pmpopup=0;
Default daysprune setting - ضبط daysprune الافتراضي
UPDATE user SET daysprune=X;
where X is the number of days.
Language - الغة الافتراضية
UPDATE user SET languageid=X;
where X is the ID of the language (you can get this from the admin CP).
Style - الاستايل الافتراضي
UPDATE user SET styleid=X;
where X is the ID of the style (you can get this from the admin CP).
First day of the week - اول ايام الاسبوع
UPDATE user SET startofweek=X;
where X is a number 1 through 7 indicating the first day of the week (with 1 being Sunday, 2 being Monday, etc.).
Message Editor Interface - محرر الكتابة
Do Not Show Editor Toolbar: UPDATE user SET showvbcode=0;
Show Standard Editor Toolbar: UPDATE user SET showvbcode=1;
Show Enhanced (WYSIWYG) Editor Toolbar: UPDATE user SET showvbcode=2;
Thread sub******ion/email notification defaults - اخطار بالاشتراك بالموضوع
Do not subscribe: UPDATE user SET autosubscribe = -1;
Subscribe without notification: UPDATE user SET autosubscribe = 0;
Instant email: UPDATE user SET autosubscribe = 1;
Daily email: UPDATE user SET autosubscribe = 2;
Weekly email: UPDATE user SET autosubscribe = 3;
Show Birthday - عرض يوم الميلاد
Hide Age & Date of Birth: UPDATE user SET showbirthday = 0
Display Age: UPDATE user SET showbirthday = 1
Display Age & Date of Birth: UPDATE user SET showbirthday = 2
Timezoneoffset
UPDATE user SET timezoneoffset = X
where X is the GMT value (0, 2, -5, ...)
Make all forums active/inactive - اجعل كافة المنتديات النشيطة / خاملة
Active: UPDATE forum SET options=options + 1 WHERE NOT(options & 1);
Inactive: UPDATE forum SET options=options - 1 WHERE (options & 1);
Open/Close all forums for new posts - فتح / اغلاق كل المنتديات عن المواضيع الجديدة
Open: UPDATE forum SET options=options + 2 WHERE NOT(options & 2);
Close: UPDATE forum SET options=options - 2 WHERE (options & 2);
Set all forums to act as categories/forums
Act as forums: UPDATE forum SET options=options + 4 WHERE NOT(options & 4);
Act as categories:UPDATE forum SET options=options - 4 WHERE (options & 4);
Turn on/off Post Moderation for all forums - تشغيل او ايقاب Post Moderation من كافة المنتدي
On: UPDATE forum SET options=options + 8 WHERE NOT(options & 8);
Off: UPDATE forum SET options=options - 8 WHERE (options & 8);
Turn on/off Thread Moderation for all forums- تشغيل او ايقاب Thread Moderation من كافة المنتدي
On: UPDATE forum SET options=options + 16 WHERE NOT(options & 16);
Off: UPDATE forum SET options=options - 16 WHERE (options & 16);
Turn on/off Attachment Moderation for all forums- تشغيل او ايقاب Attachment Moderation من كافة المنتدي
On: UPDATE forum SET options=options + 32 WHERE NOT(options & 32);
Off: UPDATE forum SET options=options - 32 WHERE (options & 32);
Turn on/off BBCode for all forums - تشغيل او ايقاب BBCode من كافة المنتدى
On: UPDATE forum SET options=options + 64 WHERE NOT(options & 64);
Off: UPDATE forum SET options=options - 64 WHERE (options & 64);
Turn on/off Images for all forums - تشغيل او ايقاب الصور من كافة المنتدى
On: UPDATE forum SET options=options + 128 WHERE NOT(options & 128);
Off: UPDATE forum SET options=options - 128 WHERE (options & 128);
Turn on/off HTML for all forums - تشغيل او ايقاب HTML من كافة المنتدى
On: UPDATE forum SET options=options + 256 WHERE NOT(options & 256);
Off: UPDATE forum SET options=options - 256 WHERE (options & 256);
Turn on/off Smilies for all forums- تشغيل او ايقاف الابتسامات من كافة المنتدى
On: UPDATE forum SET options=options + 512 WHERE NOT(options & 512);
Off: UPDATE forum SET options=options - 512 WHERE (options & 512);
Turn on/off Post Icons for all forums- تشغيل او ايقاب ايقونات المواضيع لكافة المنتدى
On: UPDATE forum SET options=options + 1024 WHERE NOT(options & 1024);
Off: UPDATE forum SET options=options - 1024 WHERE (options & 1024);
Turn on/off Thread Rating for all forums- تشغيل او ايقاف التقيم من كافة المنتدى
On: UPDATE forum SET options=options + 2048 WHERE NOT(options & 2048);
Off: UPDATE forum SET options=options - 2048 WHERE (options & 2048);
Turn on/off Post Counting for all forums
On: UPDATE forum SET options=options + 4096 WHERE NOT(options & 4096);
Off: UPDATE forum SET options=options - 4096 WHERE (options & 4096);
Set 'Can have Password' on/off for all forums- وضع باسورد لكافة المنتدى
On: UPDATE forum SET options=options + 8192 WHERE NOT(options & 8192);
Off: UPDATE forum SET options=options - 8192 WHERE (options & 8192);
Turn on/off Search Indexing for all forums- تفعيل محرك البحث لكافة المنتدى
On: UPDATE forum SET options=options + 16384 WHERE NOT(options & 16384);
Off: UPDATE forum SET options=options - 16384 WHERE (options & 16384);
Turn on/off Style Overriding for all forums - تشغيل او تفعيل خيار اختيار
الاستايل لكافة المنتدى
On: UPDATE forum SET options=options + 32768 WHERE NOT(options & 32768);
Off: UPDATE forum SET options=options - 32768 WHERE (options & 32768);
Turn on/off 'Show on ForumJump Menu' for all forums
On: UPDATE forum SET options=options + 65536 WHERE NOT(options & 65536);
Off: UPDATE forum SET options=options - 65536 WHERE (options & 65536);
Turn on/off 'Warn Administrators' for all forums- تشغيل او ايقاف تحذير المدير لكافة المنتدى
On: UPDATE forum SET options=options + 131072 WHERE NOT(options & 131072);
Off: UPDATE forum SET options=options - 131072 WHERE (options & 131072);
Verified for 3.6.2 - هذا الامر فقط للنسخه 3.6.2 فما فوق
Turn registration on - تفعيل التسجيل
UPDATE setting SET value = 1 WHERE varname = 'allowregistration';
UPDATE datastore SET data = REPLACE(data, '"allowregistration";i:0', '"allowregistration";i:1') WHERE title = 'options';
Turn registration off- ايقاف التسجيل
UPDATE setting SET value = 0 WHERE varname = 'allowregistration';
UPDATE datastore SET data = REPLACE(data, '"allowregistration";i:1', '"allowregistration";i:0') WHERE title = 'options';
هذا الامر لازالت البيانات الشخصية من الملف الشخصي :
UPDATE `user` SET `homepage` = '', `icq` = '', `aim` = '', `yahoo` = '', `msn` = '', `skype` = '' WHERE `user`.`userid` >= 1
منقول