بسم الله الرحمن الرحيم
السلام عليكم ورحمة الله وبركاته
أحبتي من قام بتحويل ترميز منتداه للترميز العربي 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:
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:
ALTER TABLE `forumprefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود 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:
ALTER TABLE `groupmessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود PHP:
ALTER TABLE `humanverify` CHANGE `hash` `hash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL ,
CHANGE `answer` `answer` MEDIUMTEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
كود PHP:
ALTER TABLE `hvanswer` CHANGE `answer` `answer` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود PHP:
ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود PHP:
ALTER TABLE `notice` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود 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:
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:
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:
ALTER TABLE `picturecomment_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود 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:
ALTER TABLE `postlog` CHANGE `useragent` `useragent` CHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود PHP:
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود PHP:
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود 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:
ALTER TABLE `socialgroupmember` CHANGE `type` `type` ENUM( 'member', 'moderated', 'invited' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'member'
كود PHP:
ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود 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:
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:
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:
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:
ALTER TABLE `usercsscache` CHANGE `cachedcss` `cachedcss` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
كود 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:
ALTER TABLE `visitormessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود 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:
ALTER TABLE `postlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `postedithistory` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `profilevisitor` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `albumpicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `albumpicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `forumprefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `groupmessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `groupmessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `humanverify` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `hvanswer` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `hvquestion` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `notice` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `noticecriteria` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `picture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `picturecomment` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `picturecomment_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `prefix` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `prefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `socialgroup` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `socialgroupmember` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `socialgrouppicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `spamlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `tachyforumcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `tachythreadcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `tag` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `tagthread` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `uploadfiles` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `userchangelog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `usercss` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `usercsscache` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `visitormessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `visitormessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود PHP:
ALTER TABLE `uploadcategorys` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
اخيرااااااااا انتهى
تحياتى
06-02-2008, 12:21
تنبيه مهم لأصحاب الترميز cp1256 وقاموا بالترقية لـ 3.7.0 
