| 文章来源：魔域私服｜新开魔域私服｜最新魔域私服下载 发布时间：2008-5-31 8:15:40 |
#
#Tablestructurefortablecq_bonus
#
CREATETABLEcq_bonus(
serianumberchar(15)binaryNOTNULLdefault未知,
passwordchar(15)binaryNOTNULLdefault未知,
actionint(4)unsignedzerofillNOTNULLdefault0000,
idint(4)unsignedzerofillNOTNULLauto_increment,
PRIMARYKEY(id),
UNIQUEKEYserianumber(serianumber)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_traptype
#
DROPTABLEIFEXISTScq_traptype;
CREATETABLEcq_traptype(
idint(4)unsignedzerofillNOTNULL,
sorttinyint(3)unsignedzerofillNOTNULLdefault0,
lookint(4)unsignedzerofillNOTNULLdefault0000,
action_idint(4)unsignedzerofillNOTNULLdefault0000,
levelint(4)unsignedzerofillNOTNULLdefault0000,
attack_maxint(4)unsignedzerofillNOTNULLdefault0000,
attack_minint(4)unsignedzerofillNOTNULLdefault0000,
dexterityint(4)unsignedzerofillNOTNULLdefault0000,
attack_speedint(4)unsignedzerofillNOTNULLdefault1000,
active_timesint(4)unsignedzerofillNOTNULLdefault0000,
magic_typeint(4)unsignedzerofillNOTNULLdefault0000,
magic_hitrateint(4)unsignedzerofillNOTNULLdefault0100,
sizeint(4)unsignedzerofillNOTNULLdefault0000,
atk_modeint(3)unsignedzerofillNOTNULLdefault0001,
PRIMARYKEY(id)
)TYPE=MyISAM;
insertcq_traptypevalues(1,1,1091010,0,20,250,250,80,1000,0,1000,50,1,1);
insertcq_traptypevalues(2,10,1091010,0,20,25,25,80,1000,0,1000,50,7,1);
#sort:
TRAPSORT_SYSTRAP=1,//系统的陷阱，多次有效
TRAPSORT_FIREWALL=10,//火墙,可由系统放置
#look-0:invisibletrap
#action_id-runactionwhenactivetrap,onlyeffectforTRAPSORT_SYSTRAP
#active_times-0:forevereffect
#magic_type-0:hitbyweaponmode
#atk_mode:可叠加
ATKMODE_USER=1,
ATKMODE_MONSTER=2,
ATKMODE_NOATTACK=4,//不攻击对象，只触发ACTION
CREATETABLEcq_trap(
idint(4)unsignedzerofillNOTNULL,
typeint(4)unsignedzerofillNOTNULLdefault0000,
lookint(4)unsignedzerofillNOTNULLdefault0000,
owner_idint(4)unsignedzerofillNOTNULLdefault0000,
map_idint(4)unsignedzerofillNOTNULLdefault0000,
pos_xint(4)unsignedzerofillNOTNULLdefault0000,
pos_yint(4)unsignedzerofillNOTNULLdefault0000,
dataint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id)
)TYPE=MyISAM;
insertcq_trapvalues(990001,1,1091010,0,1002,404,400,0);
insertcq_trapvalues(990002,2,1091012,0,1002,439,400,0);
#id-990001~999999
#look-0:invisibletrap
#
#Tablestructurefortablecq_point_allot
#
DROPTABLEIFEXISTScq_point_allot;
CREATETABLEcq_point_allot(
idint(4)unsignedzerofillNOTNULLauto_increment,
prof_sortint(4)unsignedzerofillNOTNULLdefault0000,
levelint(4)unsignedzerofillNOTNULLdefault0000,
forceint(4)unsignedzerofillNOTNULLdefault0000,
Speedint(4)unsignedzerofillNOTNULLdefault0000,
healthint(4)unsignedzerofillNOTNULLdefault0000,
soulint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
UNIQUEKEYidx(prof_sort,level)
)TYPE=MyISAM;
INSERTcq_point_allotVALUES(0,0,0,0,0,0,0);
#
#Tablestructurefortablecq_superman
#
CREATETABLEcq_superman(
idint(4)unsignedzerofillNOTNULL,
numberint(4)unsignedzerofillNOTNULLdefault0000,
namevarchar(15)binaryNOTNULLdefault--,
PRIMARYKEY(id),
KEYnumber(number)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_config
#
CREATETABLEcq_config(
idint(4)unsignedzerofillNOTNULL,
namevarchar(15)binaryNOTNULLdefault,
dataint(4)unsignedzerofillNOTNULLdefault0000,
stringvarchar(255)binaryNOTNULLdefault,
PRIMARYKEY(id),
KEYname(name)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_rebirth
#
DROPTABLEIFEXISTScq_rebirth;
CREATETABLEcq_rebirth(
idint(4)unsignedzerofillNOTNULL,
need_profint(4)unsignedzerofillNOTNULLdefault0000,
new_profint(4)unsignedzerofillNOTNULLdefault0000,
need_levelint(4)unsignedzerofillNOTNULLdefault0000,
new_levelint(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_dropitemrule
#
DROPTABLEIFEXISTScq_dropitemrule;
CREATETABLEcq_dropitemrule(
idintunsignedNOTNULL,
RuleIdintunsignedNOTNULLdefault0,
ChanceintunsignedNOTNULLdefault0,
Item0intunsignedNOTNULLdefault0,
Item1intunsignedNOTNULLdefault0,
Item2intunsignedNOTNULLdefault0,
Item3intunsignedNOTNULLdefault0,
Item4intunsignedNOTNULLdefault0,
Item5intunsignedNOTNULLdefault0,
Item6intunsignedNOTNULLdefault0,
Item7intunsignedNOTNULLdefault0,
Item8intunsignedNOTNULLdefault0,
Item9intunsignedNOTNULLdefault0,
Item10intunsignedNOTNULLdefault0,
Item11intunsignedNOTNULLdefault0,
Item12intunsignedNOTNULLdefault0,
Item13intunsignedNOTNULLdefault0,
Item14intunsignedNOTNULLdefault0,
PRIMARYKEY(id,RuleId)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_table
#
DROPTABLEIFEXISTScq_table;
CREATETABLEcq_table(
idint(4)unsignedzerofillNOTNULLauto_increment,
npc_idint(4)unsignedzerofillNOTNULLdefault0000,
typeint(4)unsignedzerofillNOTNULLdefault0000,
key_idint(4)unsignedzerofillNOTNULLdefault0000,
datastrvarchar(255)binaryNOTNULLdefault,
data0int(4)unsignedzerofillNOTNULLdefault0000,
data1int(4)unsignedzerofillNOTNULLdefault0000,
data2int(4)unsignedzerofillNOTNULLdefault0000,
data3int(4)unsignedzerofillNOTNULLdefault0000,
PRIMARYKEY(id),
)TYPE=MyISAM;
#
#Tablestructurefortablecq_npc
#
DROPTABLEIFEXISTScq_npc;
CREATETABLEcq_npc(
idint(4)unsignedzerofillNOTNULLdefault0000,
owneridint(4)unsignedNOTNULLdefault0,
ownertypeint(4)unsignedNOTNULLdefault0,
namechar(15)binaryNOTNULLdefault未命名,
typeint(4)unsignedzerofillNOTNULLdefault0,
lookfaceint(4)unsignedzerofillNOTNULLdefault0,
idxserverint(4)NOTNULLdefault-1,
mapidint(4)unsignedzerofillNOTNULLdefault0,
cellxint(4)unsignedzerofillNOTNULLdefault0,
cellyint(4)unsignedzerofillNOTNULLdefault0,
task0int(4)unsignedzerofillNOTNULLdefault0,
task1int(4)unsignedzerofillNOTNULLdefault0,
task2int(4)unsignedzerofillNOTNULLdefault0,
task3int(4)unsignedzerofillNOTNULLdefault0,
task4int(4)unsignedzerofillNOTNULLdefault0,
task5int(4)unsignedzerofillNOTNULLdefault0,
task6int(4)unsignedzerofillNOTNULLdefault0,
task7int(4)unsignedzerofillNOTNULLdefault0,
data0int(4)NOTNULLdefault0,
data1int(4)NOTNULLdefault0,
data2int(4)NOTNULLdefault0,
data3int(4)NOTNULLdefault0,
datastrchar(15)binaryNOTNULLdefault无,
linkidint(4)unsignedzerofillNOTNULLdefault0,
lifeint(4)unsignedzerofillNOTNULLdefault0,
maxlifeint(4)unsignedzerofillNOTNULLdefault0,
baseint(4)unsignedzerofillNOTNULLdefault0,
sortsmallint(2)unsignedzerofillNOTNULLdefault0,
itemidint(4)unsignedzerofillNOTNULLdefault0,
defencesmallint(2)unsignedzerofillNOTNULLdefault0,
magic_defsmallint(2)unsignedzerofillNOTNULLdefault0,
PRIMARYKEY(id)
)TYPE=MyISAM;
INSERTcq_npcVALUES(9999,0,0,赌场,19,26,-1,1002,404,398,0,0,0,0,0,0,0,0,0,0,0,0,,0,0,0,0,0,0);
CREATETABLEcq_dynanpc(
idint(4)unsignedzerofillNOTNULLdefault0000auto_increment,
owneridint(4)unsignedNOTNULLdefault0,
ownertypetinyint(3)unsignedNOTNULLdefault0,
namevarchar(15)binaryNOTNULLdefault未命名,
typesmallint(2)unsignedzerofillNOTNULLdefault0,
lookfaceint(4)unsignedzerofillNOTNULLdefault0,
idxservertinyint(3)NOTNULLdefault-1,
mapidint(4)unsignedzerofillNOTNULLdefault0,
cellxsmallint(2)unsignedzerofillNOTNULLdefault0,
cellysmallint(2)unsignedzerofillNOTNULLdefault0,
task0int(4)unsignedzerofillNOTNULLdefault0,
task1int(4)unsignedzerofillNOTNULLdefault0,
task2int(4)unsignedzerofillNOTNULLdefault0,
task3int(4)unsignedzerofillNOTNULLdefault0,
task4int(4)unsignedzerofillNOTNULLdefault0,
task5int(4)unsignedzerofillNOTNULLdefault0,
task6int(4)unsignedzerofillNOTNULLdefault0,
task7int(4)unsignedzerofillNOTNULLdefault0,
data0int(4)NOTNULLdefault0,
data1int(4)NOTNULLdefault0,
data2int(4)NOTNULLdefault0,
data3int(4)NOTNULLdefault0,
datastrvarchar(255)binaryNOTNULLdefault无,
linkidint(4)unsignedzerofillNOTNULLdefault0,
lifeint(4)unsignedzerofillNOTNULLdefault0,
maxlifeint(4)unsignedzerofillNOTNULLdefault0,
baseint(4)unsignedzerofillNOTNULLdefault0,
sortsmallint(2)unsignedzerofillNOTNULLdefault0,
itemidint(4)unsignedzerofillNOTNULLdefault0,
defencesmallint(2)unsignedzerofillNOTNULLdefault0,
magic_defsmallint(2)unsignedzerofillNOTNULLdefault0,
PRIMARYKEY(id)
)TYPE=MyISAM;
####################
##INSERTVALUES##
####################
#ownertype:0:system,1:user,2:syndicate,3:npc
#type-
enumNPCTYPE{
_NPC_NONE=0,//通用NPC
_SHOPKEEPER_NPC=1,//商店NPC
_TASK_NPC=2,//任务NPC
_STORAGE_NPC=3,//寄存处NPC
_TRUNCK_NPC=4,//箱子NPC
_FACE_NPC=5,//变头像NPC
_FORGE_NPC=6,//锻造NPC
_STATUARY_NPC=7,//雕像NPC
_WEAPONGOAL_NPC=8,//武器靶子NPC
_MAGICGOAL_NPC=9,//武器靶子NPC
_BOWGOAL_NPC=10,//武器靶子NPC
_SYNFLAG_NPC=11,//帮派标记NPC
};
#sort-
enumNPCSORT{
NPCSORT_TASK=1,//任务类
NPCSORT_RECYCLE=2,//可回收类
NPCSORT_SCENE=4,//场景类(带地图物件，LookFace为地图物件的TYPE)
NPCSORT_LINKMAP=8,//挂地图类(使用LINKID，与其它使用LINKID的互斥)
NPCSORT_DIEACTION=16,//带死亡任务(使用LINKID，与其它使用LINKID的互斥)
NPCSORT_DELENABLE=32,//可以手动删除(不是指通过任务)
};
#maxlife-0:cannotbeattack
#base-npctypein"TerrainNpc.ini".
DROPTABLEIFEXISTScq_goods;
CREATETABLEcq_goods(
idint(4)unsignedzerofillNOTNULLdefault0000,
owneridint(4)unsignedNOTNULLdefault0,
itemtypeint(4)unsignedNOTNULLdefault0,
PRIMARYKEY(id),
KEYownerid(ownerid)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_task
#
DROPTABLEIFEXISTScq_task;
CREATETABLEcq_task(
idint(4)unsignedzerofillNOTNULLdefault0000,
id_nextint(4)unsignedzerofillNOTNULLdefault0000,
id_nextfailint(4)unsignedzerofillNOTNULLdefault0000,
itemname1char(15)binaryNOTNULLdefault,
itemname2char(15)binaryNOTNULLdefault,
moneyint(4)unsignedNOTNULLdefault0,
professionint(4)unsignedNOTNULLdefault0,
sexint(4)unsignedNOTNULLdefault0,
min_pkint(4)NOTNULLdefault0,
max_pkint(4)NOTNULLdefault0,
teamint(4)unsignedzerofillNOTNULLdefault0,
metempsychosisint(4)unsignedzerofillNOTNULLdefault0,
querytinyint(1)unsignedzerofillNOTNULLdefault0,
marriagetinyint(1)NOTNULLdefault0,
client_activetinyint(1)unsignedzerofillNOTNULLdefault0,
PRIMARYKEY(id)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_action
#
DROPTABLEIFEXISTScq_action;
CREATETABLEcq_action(
idint(4)unsignedzerofillNOTNULLdefault0000,
id_nextint(4)unsignedzerofillNOTNULLdefault0000,
id_nextfailint(4)unsignedzerofillNOTNULLdefault0000,
typeint(4)unsignedzerofillNOTNULLdefault0000,
dataint(4)NOTNULLdefault0,
paramchar(127)binaryNOTNULLdefault,
PRIMARYKEY(id)
)TYPE=MyISAM;
DROPTABLEIFEXISTScq_user;
CREATETABLEcq_user(
namevarchar(15)binaryNOTNULLdefault,
matevarchar(15)binaryNOTNULLdefault,
lookfaceint(4)unsignedNOTNULLdefault0,
hairsmallint(2)unsignedNOTNULLdefault0,
moneyint(4)unsignedNOTNULLdefault0,
money_savedint(4)unsignedNOTNULLdefault0,
task_dataint(4)unsignedNOTNULLdefault0,
leveltinyint(1)unsignedNOTNULLdefault0,
expint(4)NOTNULLdefault0,
forcesmallint(2)unsignedNOTNULLdefault0,
physiquesmallint(2)unsignedNOTNULLdefault0,
Speedsmallint(2)unsignedNOTNULLdefault0,
healthsmallint(2)unsignedNOTNULLdefault0,
soulsmallint(2)unsignedNOTNULLdefault0,
additional_pointsmallint(2)unsignedNOTNULLdefault0,
auto_allottinyint(1)unsignedNOTNULLdefault0,
lifesmallint(2)unsignedNOTNULLdefault0,
manasmallint(2)unsignedNOTNULLdefault0,
professiontinyint(2)unsignedNOTNULLdefault0,
deedint(4)NOTNULLdefault0,
pksmallint(2)NOTNULLdefault0,
nobilitytinyint(1)unsignedNOTNULLdefault0000,
medalvarchar(64)binaryNOTNULLdefault,
medal_selecttinyint(4)unsignedNOTNULLdefault0000,
metempsychosistinyint(1)unsignedNOTNULLdefault0000,
syndicate_idint(4)unsignedNOTNULLdefault0000,
recordmap_idint(4)unsignedNOTNULLdefault0000,
recordxsmallint(2)unsignedNOTNULLdefault0000,
recordysmallint(2)unsignedNOTNULLdefault0000,
account_idint(4)unsignedNOTNULLdefault0000,
idint(4)unsignedNOTNULLauto_increment,
last_loginint(8)unsignedNOTNULLdefault0,
task_maskint(4)unsignedNOTNULLdefault0000,
time_of_lifeint(4)unsignedNOTNULLdefault0000,
virtueint(4)unsignedNOTNULLdefault0000,
home_idint(4)unsignedNOTNULLdefault0000,
titlevarchar(64)binaryNOTNULLdefault,
title_selecttinyint(4)unsignedNOTNULLdefault0000,
lock_keyint(4)unsignedNOTNULLdefault0000,
PRIMARYKEY(id),
KEYindex_account_id(account_id),
KEYindex_name(name),
KEYindex_level(level)
)TYPE=MyISAM;
INSERTcq_userSETid=1000000,name=RESERVE_ID_SPACE,account_id=4111222333;
DROPTABLEIFEXISTScq_weapon_skill;
CREATETABLEcq_weapon_skill(
typeint(4)unsignedzerofillNOTNULLdefault0000,
leveltinyint(2)unsignedzerofillNOTNULLdefault0000,
expint(4)unsignedzerofillNOTNULLdefault0000,
old_leveltinyint(2)unsignedzerofillNOTNULLdefault0000,
owner_idint(4)unsignedzerofillNOTNULLdefault0000,
idint(4)unsignedzerofillNOTNULLauto_increment,
unlearntinyint(1)unsignedzerofillNOTNULLdefault0,
PRIMARYKEY(id),
KEYowner_id(owner_id)
)TYPE=MyISAM;
#
#Tablestructurefortablecq_levexp
#
DROPTABLEIFEXISTScq_levexp;
CREATETABLEcq_levexp(
levelint(4)unsignedzerofillNOTNULLdefault0000,
expint(4)unsignedNOTNULLdefault0,
PRIMARYKEY(level)
)TYPE=MyISAM;
#
#Dumpingdatafortablecq_levexp
#
INSERTINTOcq_levexpVALUES(0001,36);
INSERTINTOcq_levexpVALUES(0002,51);
INSERTINTOcq_levexpVALUES(0003,71);
INSERTINTOcq_levexpVALUES(0004,100);
INSERTINTOcq_levexpVALUES(0005,164);
INSERTINTOcq_levexpVALUES(0006,357);
INSERTINTOcq_levexpVALUES(0007,523);
INSERTINTOcq_levexpVALUES(0008,765);
INSERTINTOcq_levexpVALUES(0009,1115);
INSERTINTOcq_levexpVALUES(0010,2705);
INSERTINTOcq_levexpVALUES(0011,2841);
INSERTINTOcq_levexpVALUES(0012,3052);
INSERTINTOcq_levexpVALUES(0013,3275);
INSERTINTOcq_levexpVALUES(0014,3511);
INSERTINTOcq_levexpVALUES(0015,2461);
INSERTINTOcq_levexpVALUES(0016,3156);
INSERTINTOcq_levexpVALUES(0017,4213);
INSERTINTOcq_levexpVALUES(0018,5397);
INSERTINTOcq_levexpVALUES(0019,6396);
INSERTINTOcq_levexpVALUES(0020,4712);
INSERTINTOcq_levexpVALUES(0021,6036);
INSERTINTOcq_levexpVALUES(0022,8049);
INSERTINTOcq_levexpVALUES(0023,10300);
INSERTINTOcq_levexpVALUES(0024,12200);
INSERTINTOcq_levexpVALUES(0025,7828);
INSERTINTOcq_levexpVALUES(0026,9996);
INSERTINTOcq_levexpVALUES(0027,13291);
INSERTINTOcq_levexpVALUES(0028,16961);
INSERTINTOcq_levexpVALUES(0029,20034);
INSERTINTOcq_levexpVALUES(0030,12703);
INSERTINTOcq_levexpVALUES(0031,16183);
INSERTINTOcq_levexpVALUES(0032,21470);
INSERTINTOcq_levexpVALUES(0033,27338);
INSERTINTOcq_levexpVALUES(0034,32225);
INSERTINTOcq_levexpVALUES(0035,20031);
INSERTINTOcq_levexpVALUES(0036,25475);
INSERTINTOcq_levexpVALUES(0037,33740);
INSERTINTOcq_levexpVALUES(0038,42892);
INSERTINTOcq_levexpVALUES(0039,50478);
INSERTINTOcq_levexpVALUES(0040,37296);
INSERTINTOcq_levexpVALUES(0041,47367);
INSERTINTOcq_levexpVALUES(0042,62654);
INSERTINTOcq_levexpVALUES(0043,79550);
INSERTINTOcq_levexpVALUES(0044,93507);
INSERTINTOcq_levexpVALUES(0045,58310);
INSERTINTOcq_levexpVALUES(0046,73960);
INSERTINTOcq_levexpVALUES(0047,97707);
INSERTINTOcq_levexpVALUES(0048,123902);
INSERTINTOcq_levexpVALUES(0049,145465);
INSERTINTOcq_levexpVALUES(0050,90536);
INSERTINTOcq_levexpVALUES(0051,114712);
INSERTINTOcq_levexpVALUES(0052,151385);
INSERTINTOcq_levexpVALUES(0053,191773);
INSERTINTOcq_levexpVALUES(0054,224919);
INSERTINTOcq_levexpVALUES(0055,139669);
INSERTINTOcq_levexpVALUES(0056,176805);
INSERTINTOcq_levexpVALUES(0057,233123);
INSERTINTOcq_levexpVALUES(0058,295061);
INSERTINTOcq_levexpVALUES(0059,345764);
INSERTINTOcq_levexpVALUES(0060,223040);
INSERTINTOcq_levexpVALUES(0061,282232);
INSERTINTOcq_levexpVALUES(0062,371987);
INSERTINTOcq_levexpVALUES(0063,470642);
INSERTINTOcq_levexpVALUES(0064,551316);
INSERTINTOcq_levexpVALUES(0065,336936);
INSERTINTOcq_levexpVALUES(0066,426076);
INSERTINTOcq_levexpVALUES(0067,561214);
INSERTINTOcq_levexpVALUES(0068,709603);
INSERTINTOcq_levexpVALUES(0069,830715);
INSERTINTOcq_levexpVALUES(0070,502587);
INSERTINTOcq_levexpVALUES(0071,635204);
INSERTINTOcq_levexpVALUES(0072,836218);
INSERTINTOcq_levexpVALUES(0073,1056753);
INSERTINTOcq_levexpVALUES(0074,1236460);
INSERTINTOcq_levexpVALUES(0075,735967);
INSERTINTOcq_levexpVALUES(0076,929744);
INSERTINTOcq_levexpVALUES(0077,1223418);
INSERTINTOcq_levexpVALUES(0078,1545383);
INSERTINTOcq_levexpVALUES(0079,1807392);
INSERTINTOcq_levexpVALUES(0080,1175412);
INSERTINTOcq_levexpVALUES(0081,1484085);
INSERTINTOcq_levexpVALUES(0082,1951814);
INSERTINTOcq_levexpVALUES(0083,2464176);
INSERTINTOcq_levexpVALUES(0084,2880473);
INSERTINTOcq_levexpVALUES(0085,1655624);
INSERTINTOcq_levexpVALUES(0086,2089765);
INSERTINTOcq_levexpVALUES(0087,2747551);
INSERTINTOcq_levexpVALUES(0088,3467760);
INSERTINTOcq_levexpVALUES(0089,4052400);
INSERTINTOcq_levexpVALUES(0090,2304544);
INSERTINTOcq_levexpVALUES(0091,2908073);
INSERTINTOcq_levexpVALUES(0092,3822426);
INSERTINTOcq_levexpVALUES(0093,4823128);
INSERTINTOcq_levexpVALUES(0094,5634816);
INSERTINTOcq_levexpVALUES(0095,3234913);
INSERTINTOcq_levexpVALUES(0096,4081025);
INSERTINTOcq_levexpVALUES(0097,5362786);
INSERTINTOcq_levexpVALUES(0098,6765013);
INSERTINTOcq_levexpVALUES(0099,7901491);
INSERTINTOcq_levexpVALUES(0100,4518997);
INSERTINTOcq_levexpVALUES(0101,5699613);
INSERTINTOcq_levexpVALUES(0102,7487970);
INSERTINTOcq_levexpVALUES(0103,9443671);
INSERTINTOcq_levexpVALUES(0104,11027591);
INSERTINTOcq_levexpVALUES(0105,6136098);
INSERTINTOcq_levexpVALUES(0106,7737731);
INSERTINTOcq_levexpVALUES(0107,10163682);
INSERTINTOcq_levexpVALUES(0108,12815845);
INSERTINTOcq_levexpVALUES(0109,14962606);
INSERTINTOcq_levexpVALUES(0110,17410153);
INSERTINTOcq_levexpVALUES(0111,19151169);
INSERTINTOcq_levexpVALUES(0112,21066285);
INSERTINTOcq_levexpVALUES(0113,23172914);
INSERTINTOcq_levexpVALUES(0114,25490205);
INSERTINTOcq_levexpVALUES(0115,28039226);
INSERTINTOcq_levexpVALUES(0116,30843149);
INSERTINTOcq_levexpVALUES(0117,33927463);
INSERTINTOcq_levexpVALUES(0118,37320210);
INSERTINTOcq_levexpVALUES(0119,41052231);
INSERTINTOcq_levexpVALUES(0120,45157454);
DROPTABLEIFEXISTScq_dropitemrule;
CREATETABLEcq_dropitemrule(
idintunsignedNOTNULL, #规则组ID
RuleIdintunsignedNOTNULLdefault0, #规则ID
ChanceintunsignedNOTNULLdefault0, #掉物品概率
Item0intunsignedNOTNULLdefault0, #以下为此概率可能掉的物品类别ID
Item1intunsignedNOTNULLdefault0,
Item2intunsignedNOTNULLdefault0,
Item3intunsignedNOTNULLdefault0,
Item4intunsignedNOTNULLdefault0,
Item5intunsignedNOTNULLdefault0,
Item6intunsignedNOTNULLdefault0,
Item7intunsignedNOTNULLdefault0,
Item8intunsignedNOTNULLdefault0,
Item9intunsignedNOTNULLdefault0,
Item10intunsignedNOTNULLdefault0,
Item11intunsignedNOTNULLdefault0,
Item12intunsignedNOTNULLdefault0,
Item13intunsignedNOTNULLdefault0,
Item14intunsignedNOTNULLdefault0,
PRIMARYKEY(id,RuleId)
)TYPE=MyISAM;
#
#id=0为默认规则：不掉任何物品的规则——此规则不生效，正常的规则不允许id=0
#
INSERTcq_dropitemrulesetid=0,ruleid=0,chance=0;
如果喜欢www.885mu.com请告诉你身边的朋友，谢谢对本站支持！ |
|