بسم الله الرحمن الرحيم
السلام عليكم ورحمة الله وبركاته
أحبتي من قام بتحويل ترميز منتداه للترميز العربي cp1256 وقام بالترقية للنسخة 3.7.0
لابد وأن يواجه بعض المشاكل في الترميز في الجداول الجديدة وقمت بترقية منتداي وحولت الجداول الجديدة والتي تمت زراعتها تلقائياً مع الترقية .
وهذه أوامر لتحويل الجداول الجديدة للترميز العربي
أولاً الأوامر الأولية هي للجداول او الحقول الداخلية :
كود:
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
كود:
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
كود:
ALTER TABLE `forumprefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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
كود:
ALTER TABLE `groupmessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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
كود:
ALTER TABLE `hvanswer` CHANGE `answer` `answer` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
ALTER TABLE `hvquestion` CHANGE `regex` `regex` VARCHAR( 255 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
ALTER TABLE `notice` CHANGE `title` `title` VARCHAR( 250 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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
كود:
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
كود:
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
كود:
ALTER TABLE `picturecomment_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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
كود:
ALTER TABLE `postlog` CHANGE `useragent` `useragent` CHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
ALTER TABLE `prefixset` CHANGE `prefixsetid` `prefixsetid` VARCHAR( 25 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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'
كود:
ALTER TABLE `socialgroupmember` CHANGE `type` `type` ENUM( 'member', 'moderated', 'invited' ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL DEFAULT 'member'
كود:
ALTER TABLE `tag` CHANGE `tagtext` `tagtext` VARCHAR( 100 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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
كود:
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
كود:
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
كود:
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
كود:
ALTER TABLE `usercsscache` CHANGE `cachedcss` `cachedcss` TEXT CHARACTER SET cp1256 COLLATE cp1256_general_ci NULL DEFAULT NULL
كود:
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
كود:
ALTER TABLE `visitormessage_hash` CHANGE `dupehash` `dupehash` VARCHAR( 32 ) CHARACTER SET cp1256 COLLATE cp1256_general_ci NOT NULL
كود:
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
ثانياً: الأوامر التالية لتحويل ترميز بنية الجداول الرئيسية لجعلها تتوافق مع الترميز العربي
كود:
ALTER TABLE `postlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `postedithistory` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `profilevisitor` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `albumpicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `bookmarksite` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `forumprefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `groupmessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `groupmessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `humanverify` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `hvanswer` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `hvquestion` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `notice` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `noticecriteria` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `picture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `picturecomment` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `picturecomment_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `prefix` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `prefixset` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `socialgroup` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `socialgroupmember` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `socialgrouppicture` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `spamlog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `tachyforumcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `tachythreadcounter` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `tag` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `tagsearch` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `tagthread` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `uploadfiles` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `userchangelog` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `usercss` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `usercsscache` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `visitormessage` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `visitormessage_hash` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
كود:
ALTER TABLE `uploadcategorys` DEFAULT CHARACTER SET cp1256 COLLATE cp1256_general_ci
هذه الطريقة مجربة عملياً على موقعي :
http://www.support-vb.com/forum/index.php
والحمد لله كل شئ تمام فأحببت أن أقدم ولو معلومة بسيطة للأخوة الذين قاموا بتحويل الترميز حتى يستفيدون.
تحية طيبة للجميع