Errno.: 1054 ทุกครั้งที่เเก้ไขข้อมูลกลุ่มสมาิชิกอะครับ

Ryusuke

Errno.: 1054 ทุกครั้งที่เเก้ไขข้อมูลกลุ่มสมาิชิกอะครับ
คือผมไปโหลด เเละ run query ตามกระทู้นี้มา เพื่อจะเเก้ภาษาจีนอะครับ
http://www.discuzthai.com/thread-6728-1-1.html
หลังจากนั้นก็ขึ้นเเบบนี้ตลอด พอจะมีวิธีเเก้หรือเปล่าครับ
ขอบคุณเพื่อนๆทุกๆคนล่วงหน้าครับ

Discuz! info: MySQL Query Error

User: Ryusuke
Time: 2010-3-16 1:37pm
Script: /board/bbs/admincp.php

SQL: SELECT groupid, type, grouptitle, creditshigher, creditslower, stars, color, groupavatar, readaccess, allowcusbbcode, allowgetattach, edittimelimit FROM [Table]usergroups ORDER BY creditslower
Error: Unknown column 'edittimelimit' in 'field list'
Errno.: 1054

Similar error report has been dispatched to administrator before.
http://faq.comsenz.com/?action-viewnews-itemid-99

MinT

ตอบกลับ 1# Ryusuke


    ถ้าทำในลักษณะนี้  ครับ  ก็พังหมดแหละครับ

ต้องแก้ตอนลงใหม่  ๆๆ  เลย  ถึงจะไม่พัง

acaz

ไปที่ admincp > เครื่องมือ > ฐานข้อมูล > run query
หรือทำใน phpmyadmin ได้เหมือนกัน
แล้วใช้ฐานข้อมูลนี้แทนครับ

1. DROP TABLE IF EXISTS cdb_usergroups;
   
2. CREATE TABLE cdb_usergroups (
   
3.   groupid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
   
4.   radminid tinyint(3) NOT NULL DEFAULT '0',
   
5.   `type` enum('system','special','member') NOT NULL DEFAULT 'member',
   
6.   system char(8) NOT NULL DEFAULT 'private',
   
7.   grouptitle char(30) NOT NULL DEFAULT '',
   
8.   creditshigher int(10) NOT NULL DEFAULT '0',
   
9.   creditslower int(10) NOT NULL DEFAULT '0',
   
10.   stars tinyint(3) NOT NULL DEFAULT '0',
    
11.   color char(7) NOT NULL DEFAULT '',
    
12.   groupavatar char(60) NOT NULL DEFAULT '',
    
13.   readaccess tinyint(3) unsigned NOT NULL DEFAULT '0',
    
14.   allowvisit tinyint(1) NOT NULL DEFAULT '0',
    
15.   allowpost tinyint(1) NOT NULL DEFAULT '0',
    
16.   allowreply tinyint(1) NOT NULL DEFAULT '0',
    
17.   allowpostpoll tinyint(1) NOT NULL DEFAULT '0',
    
18.   allowpostreward tinyint(1) NOT NULL DEFAULT '0',
    
19.   allowposttrade tinyint(1) NOT NULL DEFAULT '0',
    
20.   allowpostactivity tinyint(1) NOT NULL DEFAULT '0',
    
21.   allowdirectpost tinyint(1) NOT NULL DEFAULT '0',
    
22.   allowgetattach tinyint(1) NOT NULL DEFAULT '0',
    
23.   allowpostattach tinyint(1) NOT NULL DEFAULT '0',
    
24.   allowvote tinyint(1) NOT NULL DEFAULT '0',
    
25.   allowmultigroups tinyint(1) NOT NULL DEFAULT '0',
    
26.   allowsearch tinyint(1) NOT NULL DEFAULT '0',
    
27.   allowcstatus tinyint(1) NOT NULL DEFAULT '0',
    
28.   allowuseblog tinyint(1) NOT NULL DEFAULT '0',
    
29.   allowinvisible tinyint(1) NOT NULL DEFAULT '0',
    
30.   allowtransfer tinyint(1) NOT NULL DEFAULT '0',
    
31.   allowsetreadperm tinyint(1) NOT NULL DEFAULT '0',
    
32.   allowsetattachperm tinyint(1) NOT NULL DEFAULT '0',
    
33.   allowhidecode tinyint(1) NOT NULL DEFAULT '0',
    
34.   allowhtml tinyint(1) NOT NULL DEFAULT '0',
    
35.   allowcusbbcode tinyint(1) NOT NULL DEFAULT '0',
    
36.   allowanonymous tinyint(1) NOT NULL DEFAULT '0',
    
37.   allownickname tinyint(1) NOT NULL DEFAULT '0',
    
38.   allowsigbbcode tinyint(1) NOT NULL DEFAULT '0',
    
39.   allowsigimgcode tinyint(1) NOT NULL DEFAULT '0',
    
40.   allowviewpro tinyint(1) NOT NULL DEFAULT '0',
    
41.   allowviewstats tinyint(1) NOT NULL DEFAULT '0',
    
42.   disableperiodctrl tinyint(1) NOT NULL DEFAULT '0',
    
43.   reasonpm tinyint(1) NOT NULL DEFAULT '0',
    
44.   maxprice smallint(6) unsigned NOT NULL DEFAULT '0',
    
45.   maxsigsize smallint(6) unsigned NOT NULL DEFAULT '0',
    
46.   maxattachsize mediumint(8) unsigned NOT NULL DEFAULT '0',
    
47.   maxsizeperday int(10) unsigned NOT NULL DEFAULT '0',
    
48.   maxpostsperhour tinyint(3) unsigned NOT NULL DEFAULT '0',
    
49.   attachextensions char(100) NOT NULL DEFAULT '',
    
50.   raterange char(150) NOT NULL DEFAULT '',
    
51.   mintradeprice smallint(6) unsigned NOT NULL DEFAULT '1',
    
52.   maxtradeprice smallint(6) unsigned NOT NULL DEFAULT '0',
    
53.   minrewardprice smallint(6) NOT NULL DEFAULT '1',
    
54.   maxrewardprice smallint(6) NOT NULL DEFAULT '0',
    
55.   magicsdiscount tinyint(1) NOT NULL,
    
56.   allowmagics tinyint(1) unsigned NOT NULL,
    
57.   maxmagicsweight smallint(6) unsigned NOT NULL,
    
58.   allowbiobbcode tinyint(1) unsigned NOT NULL DEFAULT '0',
    
59.   allowbioimgcode tinyint(1) unsigned NOT NULL DEFAULT '0',
    
60.   maxbiosize smallint(6) unsigned NOT NULL DEFAULT '0',
    
61.   allowinvite tinyint(1) NOT NULL DEFAULT '0',
    
62.   allowmailinvite tinyint(1) NOT NULL DEFAULT '0',
    
63.   maxinvitenum tinyint(3) unsigned NOT NULL DEFAULT '0',
    
64.   inviteprice smallint(6) unsigned NOT NULL DEFAULT '0',
    
65.   maxinviteday smallint(6) unsigned NOT NULL DEFAULT '0',
    
66.   allowpostdebate tinyint(1) NOT NULL DEFAULT '0',
    
67.   tradestick tinyint(1) unsigned NOT NULL,
    
68.   exempt tinyint(1) unsigned NOT NULL,
    
69.   allowsendpm tinyint(1) NOT NULL DEFAULT '1',
    
70.   maxattachnum smallint(6) NOT NULL DEFAULT '0',
    
71.   allowposturl tinyint(1) NOT NULL DEFAULT '3',
    
72.   allowrecommend tinyint(1) unsigned NOT NULL DEFAULT '1',
    
73.   edittimelimit SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
    
74.   allowpostrushreply TINYINT(1) NOT NULL DEFAULT '0',
    
75.   PRIMARY KEY (groupid),
    
76.   KEY creditsrange (creditshigher,creditslower)
    
77. ) TYPE=MyISAM;
    
78. 
    
79. INSERT INTO cdb_usergroups SET `groupid`=1,`radminid`=1,`type`='system',`system`='private',`grouptitle`='ผู้ดูแลระบบ',`creditshigher`=0,`creditslower`=0,`stars`=9,`color`='',`groupavatar`='',`readaccess`=200,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=3,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=1,`allowsearch`=2,`allowcstatus`=1,`allowuseblog`=1,`allowinvisible`=1,`allowtransfer`=1,`allowsetreadperm`=1,`allowsetattachperm`=1,`allowhidecode`=1,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=1,`allownickname`=1,`allowsigbbcode`=1,`allowsigimgcode`=1,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=1,`reasonpm`=0,`maxprice`=30,`maxsigsize`=500,`maxattachsize`=2048000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='',`raterange`='1        -30        30        500',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=2,`maxmagicsweight`=200,`allowbiobbcode`=2,`allowbioimgcode`=2,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=255,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1,`allowpostrushreply`=1;
    
80. INSERT INTO cdb_usergroups SET `groupid`=2,`radminid`=2,`type`='system',`system`='private',`grouptitle`='ผู้ดูแลพิเศษ',`creditshigher`=0,`creditslower`=0,`stars`=8,`color`='',`groupavatar`='',`readaccess`=150,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=1,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=1,`allowsearch`=1,`allowcstatus`=1,`allowuseblog`=1,`allowinvisible`=1,`allowtransfer`=1,`allowsetreadperm`=1,`allowsetattachperm`=1,`allowhidecode`=1,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=0,`allownickname`=1,`allowsigbbcode`=1,`allowsigimgcode`=1,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=1,`reasonpm`=0,`maxprice`=20,`maxsigsize`=300,`maxattachsize`=2048000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='1        -15        15        50',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=2,`maxmagicsweight`=180,`allowbiobbcode`=2,`allowbioimgcode`=2,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=255,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
81. INSERT INTO cdb_usergroups SET `groupid`=3,`radminid`=3,`type`='system',`system`='private',`grouptitle`='ผู้ดูแลกระดานข่าว',`creditshigher`=0,`creditslower`=0,`stars`=7,`color`='',`groupavatar`='',`readaccess`=100,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=1,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=1,`allowsearch`=1,`allowcstatus`=1,`allowuseblog`=1,`allowinvisible`=0,`allowtransfer`=1,`allowsetreadperm`=1,`allowsetattachperm`=1,`allowhidecode`=1,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=0,`allownickname`=1,`allowsigbbcode`=1,`allowsigimgcode`=1,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=1,`reasonpm`=0,`maxprice`=10,`maxsigsize`=200,`maxattachsize`=2048000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='1        -10        10        30',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=2,`maxmagicsweight`=160,`allowbiobbcode`=2,`allowbioimgcode`=2,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=224,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
82. INSERT INTO cdb_usergroups SET `groupid`=4,`radminid`=0,`type`='system',`system`='private',`grouptitle`='ห้ามโพสต์',`creditshigher`=0,`creditslower`=0,`stars`=0,`color`='',`groupavatar`='',`readaccess`=0,`allowvisit`=1,`allowpost`=0,`allowreply`=0,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=0,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=0,`allowpostattach`=0,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=0,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=0,`allowsigimgcode`=0,`allowviewpro`=0,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=0,`maxattachsize`=0,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=1,`allowmagics`=0,`maxmagicsweight`=0,`allowbiobbcode`=0,`allowbioimgcode`=0,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=0,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
83. INSERT INTO cdb_usergroups SET `groupid`=5,`radminid`=0,`type`='system',`system`='private',`grouptitle`='ห้ามเข้า',`creditshigher`=0,`creditslower`=0,`stars`=0,`color`='',`groupavatar`='',`readaccess`=0,`allowvisit`=0,`allowpost`=0,`allowreply`=0,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=0,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=0,`allowpostattach`=0,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=0,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=0,`allowsigimgcode`=0,`allowviewpro`=0,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=0,`maxattachsize`=0,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=1,`allowmagics`=0,`maxmagicsweight`=0,`allowbiobbcode`=0,`allowbioimgcode`=0,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=0,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
84. INSERT INTO cdb_usergroups SET `groupid`=6,`radminid`=0,`type`='system',`system`='private',`grouptitle`='ห้าม IP',`creditshigher`=0,`creditslower`=0,`stars`=0,`color`='',`groupavatar`='',`readaccess`=0,`allowvisit`=0,`allowpost`=0,`allowreply`=0,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=0,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=0,`allowpostattach`=0,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=0,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=0,`allowsigimgcode`=0,`allowviewpro`=0,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=0,`maxattachsize`=0,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=1,`allowmagics`=0,`maxmagicsweight`=0,`allowbiobbcode`=0,`allowbioimgcode`=0,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=0,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
85. INSERT INTO cdb_usergroups SET `groupid`=7,`radminid`=0,`type`='system',`system`='private',`grouptitle`='ผู้เข้าชม',`creditshigher`=0,`creditslower`=0,`stars`=0,`color`='',`groupavatar`='',`readaccess`=1,`allowvisit`=1,`allowpost`=0,`allowreply`=0,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=0,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=0,`allowpostattach`=0,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=0,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=0,`allowsigimgcode`=0,`allowviewpro`=0,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=0,`maxattachsize`=0,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='gif,jpg,jpeg,png',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=1,`allowmagics`=0,`maxmagicsweight`=0,`allowbiobbcode`=0,`allowbioimgcode`=0,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=0,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
86. INSERT INTO cdb_usergroups SET `groupid`=8,`radminid`=0,`type`='system',`system`='private',`grouptitle`='รอการยืนยัน',`creditshigher`=0,`creditslower`=0,`stars`=0,`color`='',`groupavatar`='',`readaccess`=0,`allowvisit`=1,`allowpost`=0,`allowreply`=0,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=0,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=0,`allowpostattach`=0,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=0,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=1,`allowsigimgcode`=0,`allowviewpro`=0,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=50,`maxattachsize`=0,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=1,`allowmagics`=0,`maxmagicsweight`=0,`allowbiobbcode`=0,`allowbioimgcode`=0,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=0,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
87. INSERT INTO cdb_usergroups SET `groupid`=9,`radminid`=0,`type`='member',`system`='private',`grouptitle`='ขอส่วนบุญ',`creditshigher`=-9999999,`creditslower`=0,`stars`=0,`color`='',`groupavatar`='',`readaccess`=0,`allowvisit`=1,`allowpost`=0,`allowreply`=0,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=0,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=0,`allowpostattach`=0,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=0,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=0,`allowsigimgcode`=0,`allowviewpro`=1,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=0,`maxattachsize`=0,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm,pdf,zip,rar,tar,gz,bzip2,gif,jpg,jpeg,png',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=1,`allowmagics`=0,`maxmagicsweight`=0,`allowbiobbcode`=0,`allowbioimgcode`=0,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=0,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
88. INSERT INTO cdb_usergroups SET `groupid`=10,`radminid`=0,`type`='member',`system`='private',`grouptitle`='สมาชิกระดับ 1',`creditshigher`=0,`creditslower`=50,`stars`=1,`color`='',`groupavatar`='',`readaccess`=10,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=0,`allowpostreward`=0,`allowposttrade`=1,`allowpostactivity`=0,`allowdirectpost`=0,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=0,`allowmultigroups`=0,`allowsearch`=1,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=1,`allowsigimgcode`=0,`allowviewpro`=1,`allowviewstats`=0,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=80,`maxattachsize`=1024000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=1,`maxmagicsweight`=40,`allowbiobbcode`=1,`allowbioimgcode`=1,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
89. INSERT INTO cdb_usergroups SET `groupid`=11,`radminid`=0,`type`='member',`system`='private',`grouptitle`='สมาชิกระดับ 2',`creditshigher`=50,`creditslower`=200,`stars`=2,`color`='',`groupavatar`='',`readaccess`=20,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=0,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=0,`allowsearch`=1,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=0,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=1,`allowsigimgcode`=0,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=100,`maxattachsize`=1024000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=1,`maxmagicsweight`=60,`allowbiobbcode`=1,`allowbioimgcode`=1,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
90. INSERT INTO cdb_usergroups SET `groupid`=12,`radminid`=0,`type`='member',`system`='private',`grouptitle`='สมาชิกระดับ 3',`creditshigher`=200,`creditslower`=500,`stars`=3,`color`='',`groupavatar`='',`readaccess`=30,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=0,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=0,`allowsearch`=1,`allowcstatus`=0,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=0,`allownickname`=0,`allowsigbbcode`=1,`allowsigimgcode`=0,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=150,`maxattachsize`=1024000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=1,`maxmagicsweight`=80,`allowbiobbcode`=1,`allowbioimgcode`=1,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
91. INSERT INTO cdb_usergroups SET `groupid`=13,`radminid`=0,`type`='member',`system`='private',`grouptitle`='สมาชิกระดับ 4',`creditshigher`=500,`creditslower`=1000,`stars`=4,`color`='',`groupavatar`='',`readaccess`=50,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=0,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=1,`allowsearch`=1,`allowcstatus`=1,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=0,`allowsetattachperm`=0,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=0,`allownickname`=1,`allowsigbbcode`=1,`allowsigimgcode`=0,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=200,`maxattachsize`=2048000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='1        -10        10        30',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=2,`maxmagicsweight`=100,`allowbiobbcode`=2,`allowbioimgcode`=2,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
92. INSERT INTO cdb_usergroups SET `groupid`=14,`radminid`=0,`type`='member',`system`='private',`grouptitle`='สมาชิกระดับ 5',`creditshigher`=1000,`creditslower`=3000,`stars`=6,`color`='',`groupavatar`='',`readaccess`=70,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=0,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=1,`allowsearch`=1,`allowcstatus`=1,`allowuseblog`=0,`allowinvisible`=0,`allowtransfer`=0,`allowsetreadperm`=1,`allowsetattachperm`=1,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=0,`allownickname`=1,`allowsigbbcode`=1,`allowsigimgcode`=1,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=300,`maxattachsize`=2048000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='1        -15        15        40',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=2,`maxmagicsweight`=120,`allowbiobbcode`=2,`allowbioimgcode`=2,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
93. INSERT INTO cdb_usergroups SET `groupid`=15,`radminid`=0,`type`='member',`system`='private',`grouptitle`='สมาชิกระดับ 6',`creditshigher`=3000,`creditslower`=9999999,`stars`=8,`color`='',`groupavatar`='',`readaccess`=90,`allowvisit`=1,`allowpost`=1,`allowreply`=1,`allowpostpoll`=1,`allowpostreward`=1,`allowposttrade`=1,`allowpostactivity`=1,`allowdirectpost`=0,`allowgetattach`=1,`allowpostattach`=1,`allowvote`=1,`allowmultigroups`=1,`allowsearch`=1,`allowcstatus`=1,`allowuseblog`=0,`allowinvisible`=1,`allowtransfer`=0,`allowsetreadperm`=1,`allowsetattachperm`=1,`allowhidecode`=0,`allowhtml`=0,`allowcusbbcode`=1,`allowanonymous`=1,`allownickname`=1,`allowsigbbcode`=1,`allowsigimgcode`=1,`allowviewpro`=1,`allowviewstats`=1,`disableperiodctrl`=0,`reasonpm`=0,`maxprice`=0,`maxsigsize`=500,`maxattachsize`=2048000,`maxsizeperday`=0,`maxpostsperhour`=0,`attachextensions`='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',`raterange`='1        -20        20        50',`mintradeprice`=1,`maxtradeprice`=0,`minrewardprice`=1,`maxrewardprice`=0,`magicsdiscount`=0,`allowmagics`=2,`maxmagicsweight`=140,`allowbiobbcode`=2,`allowbioimgcode`=2,`maxbiosize`=0,`allowinvite`=0,`allowmailinvite`=0,`maxinvitenum`=0,`inviteprice`=0,`maxinviteday`=0,`allowpostdebate`=1,`tradestick`=5,`exempt`=0,`allowsendpm`=1,`maxattachnum`=0,`allowposturl`=3,`allowrecommend`=1;
    
94. 
    
95. INSERT INTO cdb_usergroups SET groupid='16',radminid='3',type='special',system='private',grouptitle='Practice moderators',creditshigher='0',creditslower='0',stars='7',color='',groupavatar='',readaccess='100',allowvisit='1',allowpost='1',allowreply='1',allowpostpoll='1',allowpostreward='1',allowposttrade='1',allowpostactivity='1',allowdirectpost='1',allowgetattach='1',allowpostattach='1',allowvote='1',allowmultigroups='1',allowsearch='1',allowcstatus='1',allowuseblog='1',allowinvisible='0',allowtransfer='1',allowsetreadperm='1',allowsetattachperm='1',allowhidecode='1',allowhtml='0',allowcusbbcode='1',allowanonymous='0',allownickname='1',allowsigbbcode='1',allowsigimgcode='1',allowviewpro='1',allowviewstats='1',disableperiodctrl='1',reasonpm='0',maxprice='10',maxsigsize='200',maxattachsize='2048000',maxsizeperday='0',maxpostsperhour='0',attachextensions='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',raterange='1 -10 10 30',mintradeprice='1',maxtradeprice='0',minrewardprice='1',maxrewardprice='0',magicsdiscount='0',allowmagics='2',maxmagicsweight='160',allowbiobbcode='1',allowbioimgcode='1',maxbiosize='0',allowinvite='0',allowmailinvite='0',maxinvitenum='0',inviteprice='0',maxinviteday='10',allowpostdebate='1',tradestick='5',exempt='188',allowsendpm='1',maxattachnum='0',allowrecommend='0',allowposturl='3',edittimelimit='0',allowpostrushreply='0';
    
96. INSERT INTO cdb_admingroups SET admingid='16',alloweditpost='0',alloweditpoll='0',allowstickthread='1',allowmodpost='0',allowdelpost='0',allowmassprune='0',allowrefund='0',allowcensorword='0',allowviewip='0',allowbanip='0',allowedituser='0',allowmoduser='0',allowbanuser='0',allowpostannounce='0',allowviewlog='0',allowbanpost='1',disablepostctrl='0',supe_allowpushthread='0',allowhighlightthread='1',allowdigestthread='1',allowrecommendthread='1',allowbumpthread='1',allowclosethread='1',allowmovethread='0',allowedittypethread='0',allowstampthread='1',allowcopythread='0',allowmergethread='0',allowsplitthread='0',allowrepairthread='0',allowwarnpost='1',allowviewreport='1',alloweditforum='0',allowremovereward='0',allowedittrade='0',alloweditactivity='0';
    
97. 
    
98. INSERT INTO cdb_usergroups SET groupid='17',radminid='2',type='special',system='private',grouptitle='Edit a Web site',creditshigher='0',creditslower='0',stars='8',color='',groupavatar='',readaccess='150',allowvisit='1',allowpost='1',allowreply='1',allowpostpoll='1',allowpostreward='1',allowposttrade='1',allowpostactivity='1',allowdirectpost='3',allowgetattach='1',allowpostattach='1',allowvote='1',allowmultigroups='1',allowsearch='1',allowcstatus='1',allowuseblog='1',allowinvisible='1',allowtransfer='1',allowsetreadperm='1',allowsetattachperm='1',allowhidecode='1',allowhtml='0',allowcusbbcode='1',allowanonymous='0',allownickname='1',allowsigbbcode='1',allowsigimgcode='1',allowviewpro='1',allowviewstats='1',disableperiodctrl='1',reasonpm='0',maxprice='20',maxsigsize='300',maxattachsize='2048000',maxsizeperday='0',maxpostsperhour='0',attachextensions='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',raterange='1 -15 15 50',mintradeprice='1',maxtradeprice='0',minrewardprice='1',maxrewardprice='0',magicsdiscount='0',allowmagics='2',maxmagicsweight='180',allowbiobbcode='1',allowbioimgcode='1',maxbiosize='0',allowinvite='0',allowmailinvite='0',maxinvitenum='0',inviteprice='0',maxinviteday='10',allowpostdebate='1',tradestick='5',exempt='255',allowsendpm='1',maxattachnum='0',allowrecommend='0',allowposturl='3',edittimelimit='0',allowpostrushreply='0';
    
99. INSERT INTO cdb_admingroups SET admingid='17',alloweditpost='1',alloweditpoll='0',allowstickthread='2',allowmodpost='1',allowdelpost='0',allowmassprune='0',allowrefund='1',allowcensorword='0',allowviewip='1',allowbanip='0',allowedituser='0',allowmoduser='0',allowbanuser='0',allowpostannounce='1',allowviewlog='1',allowbanpost='1',disablepostctrl='1',supe_allowpushthread='0',allowhighlightthread='1',allowdigestthread='3',allowrecommendthread='1',allowbumpthread='1',allowclosethread='1',allowmovethread='1',allowedittypethread='1',allowstampthread='1',allowcopythread='1',allowmergethread='1',allowsplitthread='1',allowrepairthread='1',allowwarnpost='1',allowviewreport='1',alloweditforum='1',allowremovereward='1',allowedittrade='0',alloweditactivity='0';
    
100. 
     
101. INSERT INTO cdb_usergroups SET groupid='18',radminid='1',type='special',system='private',grouptitle='Information Inspector',creditshigher='0',creditslower='0',stars='9',color='',groupavatar='',readaccess='200',allowvisit='1',allowpost='1',allowreply='1',allowpostpoll='1',allowpostreward='1',allowposttrade='1',allowpostactivity='1',allowdirectpost='3',allowgetattach='1',allowpostattach='1',allowvote='1',allowmultigroups='1',allowsearch='2',allowcstatus='0',allowuseblog='1',allowinvisible='1',allowtransfer='1',allowsetreadperm='1',allowsetattachperm='1',allowhidecode='1',allowhtml='1',allowcusbbcode='1',allowanonymous='1',allownickname='1',allowsigbbcode='1',allowsigimgcode='1',allowviewpro='1',allowviewstats='1',disableperiodctrl='0',reasonpm='0',maxprice='30',maxsigsize='500',maxattachsize='0',maxsizeperday='0',maxpostsperhour='1',attachextensions='',raterange='1 -30 30 400 2 -30 30 400 3 -30 30 4000',mintradeprice='1',maxtradeprice='0',minrewardprice='1',maxrewardprice='0',magicsdiscount='0',allowmagics='2',maxmagicsweight='200',allowbiobbcode='1',allowbioimgcode='1',maxbiosize='0',allowinvite='1',allowmailinvite='1',maxinvitenum='0',inviteprice='1',maxinviteday='10',allowpostdebate='1',tradestick='5',exempt='255',allowsendpm='1',maxattachnum='0',allowrecommend='3',allowposturl='3',edittimelimit='0',allowpostrushreply='0';
     
102. INSERT INTO cdb_admingroups SET admingid='18',alloweditpost='0',alloweditpoll='0',allowstickthread='0',allowmodpost='0',allowdelpost='0',allowmassprune='0',allowrefund='0',allowcensorword='0',allowviewip='1',allowbanip='0',allowedituser='0',allowmoduser='0',allowbanuser='0',allowpostannounce='0',allowviewlog='0',allowbanpost='0',disablepostctrl='1',supe_allowpushthread='1',allowhighlightthread='0',allowdigestthread='0',allowrecommendthread='0',allowbumpthread='0',allowclosethread='0',allowmovethread='0',allowedittypethread='0',allowstampthread='0',allowcopythread='0',allowmergethread='0',allowsplitthread='0',allowrepairthread='0',allowwarnpost='0',allowviewreport='0',alloweditforum='0',allowremovereward='0',allowedittrade='0',alloweditactivity='0';
     
103. INSERT INTO cdb_adminactions (`admingid`, `disabledactions`) VALUES ('18', 'a:1:{i:0;s:9:"_readonly";}');
     
104. 
     
105. INSERT INTO cdb_usergroups SET groupid='19',radminid='3',type='special',system='private',grouptitle='Auditor',creditshigher='0',creditslower='0',stars='7',color='',groupavatar='',readaccess='100',allowvisit='1',allowpost='1',allowreply='1',allowpostpoll='1',allowpostreward='1',allowposttrade='1',allowpostactivity='1',allowdirectpost='1',allowgetattach='1',allowpostattach='1',allowvote='1',allowmultigroups='1',allowsearch='1',allowcstatus='1',allowuseblog='1',allowinvisible='0',allowtransfer='1',allowsetreadperm='1',allowsetattachperm='1',allowhidecode='1',allowhtml='0',allowcusbbcode='1',allowanonymous='0',allownickname='1',allowsigbbcode='1',allowsigimgcode='1',allowviewpro='1',allowviewstats='1',disableperiodctrl='1',reasonpm='0',maxprice='10',maxsigsize='200',maxattachsize='2048000',maxsizeperday='0',maxpostsperhour='0',attachextensions='chm, pdf, zip, rar, tar, gz, bzip2, gif, jpg, jpeg, png',raterange='1 -10 10 30',mintradeprice='1',maxtradeprice='0',minrewardprice='1',maxrewardprice='0',magicsdiscount='0',allowmagics='2',maxmagicsweight='160',allowbiobbcode='1',allowbioimgcode='1',maxbiosize='0',allowinvite='0',allowmailinvite='0',maxinvitenum='0',inviteprice='0',maxinviteday='10',allowpostdebate='1',tradestick='5',exempt='188',allowsendpm='1',maxattachnum='0',allowrecommend='0',allowposturl='3',edittimelimit='0',allowpostrushreply='0';
     
106. INSERT INTO cdb_admingroups SET admingid='19',alloweditpost='0',alloweditpoll='0',allowstickthread='0',allowmodpost='1',allowdelpost='0',allowmassprune='0',allowrefund='0',allowcensorword='0',allowviewip='1',allowbanip='1',allowedituser='0',allowmoduser='1',allowbanuser='1',allowpostannounce='0',allowviewlog='0',allowbanpost='0',disablepostctrl='1',supe_allowpushthread='0',allowhighlightthread='0',allowdigestthread='0',allowrecommendthread='0',allowbumpthread='0',allowclosethread='0',allowmovethread='0',allowedittypethread='0',allowstampthread='0',allowcopythread='0',allowmergethread='0',allowsplitthread='0',allowrepairthread='0',allowwarnpost='0',allowviewreport='0',alloweditforum='0',allowremovereward='0',allowedittrade='0',alloweditactivity='0';

คัดลอกไปที่คลิปบอร์ด

Ryusuke

ขอบคุณมากครับพี่ Acaz