تنبيه مهم لأصحاب الترميز 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]

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


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

المصدر: منتديات مدينة الاحلام