منتديات مدينة الاحلام

فيس بوك مدينة الاحلام twitter RSS 

 
 

 

 

معجبو مدينة الاحلام علي الفيس بوك

  #1  
قديم 23 - 02 - 2008, 23:04
الصورة الرمزية قلب جرئ
قلب جرئ غير متصل
..:: من سكان المدينة ::..
 


قلب جرئ is on a distinguished road
Exclamation تنبيه مهم لأصحاب الترميز cp1256 وقاموا بالترقية لـ 3.7.0










بسم الله الرحمن الرحيم

السلام عليكم ورحمة الله وبركاته

أحبتي من قام بتحويل ترميز منتداه للترميز العربي cp1256 وقام بالترقية للنسخة 3.7.0

لابد وأن يواجه بعض المشاكل في الترميز في الجداول الجديدة وقمت بترقية منتداي وحولت الجداول الجديدة والتي تمت زراعتها تلقائياً مع الترقية .

وهذه أوامر لتحويل الجداول الجديدة للترميز العربي

أولاً الأوامر الأولية هي للجداول او الحقول الداخلية :

[PHP]ALTER TABLE `album` CHANGE `title` `title` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `description` `description` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `state` `state` ENUM( 'public', 'private', 'profile' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'public
[/PHP]

[PHP]ALTER TABLE `bookmarksite` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `iconpath` `iconpath` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `url` `url` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL[/PHP]

[PHP]ALTER TABLE `forumprefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `groupmessage` CHANGE `postusername` `postusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `state` `state` ENUM( 'visible', 'moderation', 'deleted' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'visible',
CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
[/PHP]

[PHP]ALTER TABLE `groupmessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `notice` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `noticecriteria` CHANGE `criteriaid` `criteriaid` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `condition1` `condition1` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `condition2` `condition2` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `condition3` `condition3` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `picture` CHANGE `caption` `caption` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `extension` `extension` VARCHAR( 20 ) CHARACTER SET cp1256 COLLATE cp1256_bin NOT NULL ,
CHANGE `idhash` `idhash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `picturecomment` CHANGE `postusername` `postusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `state` `state` ENUM( 'visible', 'moderation', 'deleted' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'visible',
CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `picturecomment_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

[/PHP]

[PHP]ALTER TABLE `postedithistory` CHANGE `username` `username` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `reason` `reason` VARCHAR( 200 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL[/PHP]

[PHP]ALTER TABLE `postlog` CHANGE `useragent` `useragent` CHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `socialgroup` CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `description` `description` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `lastposter` `lastposter` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `type` `type` ENUM( 'public', 'moderated', 'inviteonly' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'public'
[/PHP]

[PHP]ALTER TABLE `socialgroupmember` CHANGE `type` `type` ENUM( 'member', 'moderated', 'invited' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'member'[/PHP]

[PHP]ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL

[/PHP]

[PHP]ALTER TABLE `uploadcategorys` CHANGE `title` `title` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL ,
CHANGE `username` `username` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `uploadfiles` CHANGE `username` `username` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `file` `file` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `path` `path` VARCHAR( 50 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `userchangelog` CHANGE `fieldname` `fieldname` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `newvalue` `newvalue` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `oldvalue` `oldvalue` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `change_uniq` `change_uniq` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `usercss` CHANGE `selector` `selector` VARCHAR( 30 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `property` `property` VARCHAR( 30 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `value` `value` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL[/PHP]

[PHP]ALTER TABLE `usercsscache` CHANGE `cachedcss` `cachedcss` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
[/PHP]

[PHP]ALTER TABLE `visitormessage` CHANGE `postusername` `postusername` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `state` `state` ENUM( 'visible', 'moderation', 'deleted' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'visible',
CHANGE `title` `title` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `pagetext` `pagetext` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
[/PHP]

[PHP]ALTER TABLE `visitormessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
[/PHP]

[PHP]ALTER TABLE `prefix` CHANGE `prefixid` `prefixid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL[/PHP]


ثانياً: الأوامر التالية لتحويل ترميز بنية الجداول الرئيسية لجعلها تتوافق مع الترميز العربي

[PHP]ALTER TABLE `postlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci[/PHP]

[PHP]ALTER TABLE `postedithistory` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `profilevisitor` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `albumpicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci

[/PHP]

[PHP]ALTER TABLE `bookmarksite` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `forumprefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `groupmessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `groupmessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `humanverify` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `hvanswer` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `hvquestion` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `notice` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `noticecriteria` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `picture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `picturecomment` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `picturecomment_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `prefix` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `prefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `socialgroup` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `socialgroupmember` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `socialgrouppicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
][/PHP]

[PHP]ALTER TABLE `spamlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `tachyforumcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `tachythreadcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `tag` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `tagsearch` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `tagthread` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `uploadfiles` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `userchangelog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `usercss` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `usercsscache` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `visitormessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `visitormessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
[/PHP]

[PHP]ALTER TABLE `uploadcategorys` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci[/PHP]

هذه الطريقة مجربة


منقوووووووووووووووول



jkfdi lil gHwphf hgjvld. cp1256 ,rhl,h fhgjvrdm gJ 3>7>0

 
 
 
 
 





رد مع اقتباس
قديم 24 - 02 - 2008, 23:57   رقم المشاركة : [2]
..:: من سكان المدينة ::..
 

Spider Man is on a distinguished road
افتراضي

مشكور علي النقل المميز

والاختيار المفيد


الله يعطيك القوة

ننتظر جديدك


Spider Man غير متصل   رد مع اقتباس
قديم 27 - 02 - 2008, 20:48   رقم المشاركة : [3]
..:: من سكان المدينة ::..
الصورة الرمزية قلب جرئ
 

قلب جرئ is on a distinguished road
افتراضي

مشكور اخوي على المرور


قلب جرئ غير متصل   رد مع اقتباس
إضافة رد

مواقع النشر (المفضلة)

أدوات الموضوع

تعليمات المشاركة
لا تستطيع إضافة مواضيع جديدة
لا تستطيع الرد على المواضيع
لا تستطيع إرفاق ملفات
لا تستطيع تعديل مشاركاتك

BB code is متاحة
كود [IMG] متاحة
كود HTML معطلة
Trackbacks are متاحة
Pingbacks are متاحة
Refbacks are متاحة



الساعة الآن 06:57.

    Powered by vBulletin Version 3.8.7
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd
ترقية وتطوير: مجموعة الدعم العربى
  

SEO by vBSEO