LCKB
Pls Help me Fixed DB Ploblem - Printable Version

+- LCKB (https://lckb.dev/forum)
+-- Forum: ** OLD LCKB DATABASE ** (https://lckb.dev/forum/forumdisplay.php?fid=109)
+--- Forum: Off-Topic (The Outer World) (https://lckb.dev/forum/forumdisplay.php?fid=198)
+---- Forum: General Discussion (https://lckb.dev/forum/forumdisplay.php?fid=147)
+---- Thread: Pls Help me Fixed DB Ploblem (/showthread.php?tid=1303)



- kimpobin02 - 11-27-2012


I have Ploblem to Insert to Database

Table not Execute SQL

-t_item

-t_item_081126

-t_npc

-t_npc_regen

-t_quest

-t_skill

-t_string

 

*Pls help me or upload link for me new database fixed




- lordzik112 - 11-27-2012

give my SS error




- kimpobin02 - 11-28-2012


My Err

[Err] 2006 - MySQL server has gone away[Err] /*Data for the table `t_item` */

 

insert into `t_item`(`a_index`,`a_type_idx`,`a_subtype_idx`,`a_enable`,`a_name`,`a_name_twn`,`a_name_chn`,`a_descr`,`a_descr_twn`,`a_descr_chn`,`a_job_flag`,`a_flag`,`a_wearing`,`a_num_0`,`a_num_1`,`a_num_2`,`a_num_3`,`a_num_4`,`a_level`,`a_level2`,`a_weight`,`a_price`,`a_max_use`,`a_drop_prob_10`,`a_need_item0`,`a_need_item1`,`a_need_item2`,`a_need_item3`,`a_need_item4`,`a_need_item5`,`a_need_item6`,`a_need_item7`,`a_need_item8`,`a_need_item9`,`a_need_item_count0`,`a_need_item_count1`,`a_need_item_count2`,`a_need_item_count3`,`a_need_item_count4`,`a_need_item_count5`,`a_need_item_count6`,`a_need_item_count7`,`a_need_item_count8`,`a_need_item_count9`,`a_need_sskill`,`a_need_sskill_level`,`a_need_sskill2`,`a_need_sskill_level2`,`a_zone_flag`,`a_file_smc`,`a_texture_id`,`a_texture_row`,`a_texture_col`,`b_todo_delete`,`a_set_0`,`a_set_1`,`a_set_2`,`a_set_3`,`a_set_4`,`a_set`,`a_grade`,`a_fame`,`a_name_thai`,`a_descr_thai`,`a_name_thai_eng`,`a_descr_thai_eng`,`a_name_twn2`,`a_descr_twn2`,`a_price_twn2`,`a_name_jpn`,`a_descr_jpn`,`a_name_mal`,`a_descr_mal`,`a_name_mal_eng`,`a_descr_mal_eng`,`a_name_usa`,`a_descr_usa`,`a_name_brz`,`a_descr_brz`,`a_rare_index_0`,`a_rare_index_1`,`a_rare_index_2`,`a_rare_index_3`,`a_rare_index_4`,`a_rare_index_5`,`a_rare_index_6`,`a_rare_index_7`,`a_rare_index_8`,`a_rare_index_9`,`a_rare_prob_0`,`a_rare_prob_1`,`a_rare_prob_2`,`a_rare_prob_3`,`a_rare_prob_4`,`a_rare_prob_5`,`a_rare_prob_6`,`a_rare_prob_7`,`a_rare_prob_8`,`a_rare_prob_9`,`a_name_hk`,`a_descr_hk`,`a_descr_hk_eng`,`a_name_hk_eng`,`a_name_ger`,`a_descr_ger`,`a_effect_name`,`a_attack_effect_name`,`a_damage_effect_name`,`a_name_spn`,`a_descr_spn`,`a_name_frc`,`a_descr_frc`,`a_name_pld`,`a_descr_pld`,`a_name_rus`,`a_descr_rus`,`a_name_tur`,`a_descr_tur`,`a_name_spn2`,`a_descr_spn2`,`a_name_frc2`,`a_descr_frc2`,`a_name_ita`,`a_descr_ita`,`a_name_mex`,`a_descr_mex`,`a_name_nld`,`a_descr_nld`,`a_quest_trigger_count`,`a_quest_trigger_ids`,`a_name_dev`,`a_descr_dev`) values (18,1,2,1,'?????????','????','????','','','',8,134217790,3,12,0,0,0,0,1,999,30,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\shield\\mage\\ma_bd_001.smc',0,8,11,0,0,0,0,0,0,-1,0,-1,'???????????','','','','????','',0,'?T?u???R???Z?b?gÂÂi??ÂÂj','','????','?????s?????l','Leather Skirt','','Leather Skirt','Mage Armor','Espartilho Simples','',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,'????','','','Leather Skirt','Rock von Sabra','Magier R?stung',NULL,NULL,NULL,'Falda de Aprendiz','Armadura de Maga','Jupe de Sabra','Armure d?ensorceleur','Sp?dniczka Sabrii','Ekwipunek czarodziejki','??????? ????','????','Sabra Ete?i','B?y?c? Z?rh?','Falda de Cuero','Armadura de Mago','Jupe de Cuir','Armure de Mage','Gonna di Sabra','Armatura Mago','Fald?n de Seda','Armadura de Mago','','',0,'','',''),(2,1,1,1,'????????????','????','??????','','','',1,134217790,1,15,0,0,0,0,1,999,150,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\Shield\\Titan\\ti_bu_001.smc',0,0,15,0,0,0,0,0,0,-1,0,-1,'????????????','Knight','','','????','',0,'?z?ÂÂ?ÂÂ?X?x???gÂÂiÂÂ?ÂÂj','','????','?????s???@??','Leather Armor','','Leather Armor','Titan Armor','Prote??o Simples','',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,'????','','','Leather Armor','Harnisch des Titans','Titan R?stung','',NULL,NULL,'Armadura de *****?n','Armadura de *****?n','Cuirasse du titan','Armure du titan','Pancerz Tytana','Ekwipunek Tytana','??????? ?????','????','Titan Z?rh?','Titan Z?rh?','Armadura de Cuero','Armadura de *****?n','Armure de Cuir','Armure de Titan','Corazza del Titano','Armatura Titano','Peto de Piel','Armadura de *****?n','','',0,'','',''),(3,1,2,1,'????????????','????','??????','','','',1,134217790,3,12,0,0,0,0,1,999,100,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\Shield\\Titan\\ti_bd_001.smc',0,1,0,0,0,0,0,0,0,-1,0,-1,'???????????','Knight','','','????','',0,'?z?ÂÂ?ÂÂ?X?x???gÂÂi??ÂÂj','','????','?????s???u??','Leather Pants','','Leather Pants','Titan Armor','Cal??o Simple

[Err] 2006 - MySQL server has gone away

[Err] /*Data for the table `t_item_081126` */

 

insert into `t_item_081126`(`a_index`,`a_type_idx`,`a_subtype_idx`,`a_enable`,`a_name`,`a_name_twn`,`a_name_chn`,`a_descr`,`a_descr_twn`,`a_descr_chn`,`a_job_flag`,`a_flag`,`a_wearing`,`a_num_0`,`a_num_1`,`a_num_2`,`a_num_3`,`a_num_4`,`a_level`,`a_weight`,`a_price`,`a_max_use`,`a_drop_prob_10`,`a_need_item0`,`a_need_item1`,`a_need_item2`,`a_need_item3`,`a_need_item4`,`a_need_item5`,`a_need_item6`,`a_need_item7`,`a_need_item8`,`a_need_item9`,`a_need_item_count0`,`a_need_item_count1`,`a_need_item_count2`,`a_need_item_count3`,`a_need_item_count4`,`a_need_item_count5`,`a_need_item_count6`,`a_need_item_count7`,`a_need_item_count8`,`a_need_item_count9`,`a_need_sskill`,`a_need_sskill_level`,`a_need_sskill2`,`a_need_sskill_level2`,`a_zone_flag`,`a_file_smc`,`a_texture_id`,`a_texture_row`,`a_texture_col`,`b_todo_delete`,`a_set_0`,`a_set_1`,`a_set_2`,`a_set_3`,`a_set_4`,`a_set`,`a_grade`,`a_fame`,`a_name_thai`,`a_descr_thai`,`a_name_thai_eng`,`a_descr_thai_eng`,`a_name_twn2`,`a_descr_twn2`,`a_price_twn2`,`a_name_jpn`,`a_descr_jpn`,`a_name_mal`,`a_descr_mal`,`a_name_mal_eng`,`a_descr_mal_eng`,`a_name_usa`,`a_descr_usa`,`a_name_brz`,`a_descr_brz`,`a_rare_index_0`,`a_rare_index_1`,`a_rare_index_2`,`a_rare_index_3`,`a_rare_index_4`,`a_rare_index_5`,`a_rare_index_6`,`a_rare_index_7`,`a_rare_index_8`,`a_rare_index_9`,`a_rare_prob_0`,`a_rare_prob_1`,`a_rare_prob_2`,`a_rare_prob_3`,`a_rare_prob_4`,`a_rare_prob_5`,`a_rare_prob_6`,`a_rare_prob_7`,`a_rare_prob_8`,`a_rare_prob_9`,`a_name_hk`,`a_descr_hk`,`a_descr_hk_eng`,`a_name_hk_eng`,`a_name_ger`,`a_descr_ger`,`a_effect_name`,`a_name_spn`,`a_descr_spn`,`a_name_frc`,`a_descr_frc`,`a_name_pld`,`a_descr_pld`) values (18,1,2,1,'?????????','????','????','','','',8,62,3,12,0,0,0,0,1,30,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\shield\\mage\\ma_bd_001.smc',0,8,11,0,0,0,0,0,0,-1,0,-1,'???????????','','','','????','',0,'?T?u???R???Z?b?gÂÂi??ÂÂj','','????','?????s?????l','Leather Skirt','','Leather Skirt','Mage Armor','Espartilho Simples','',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,'????','','','Leather Skirt','Rock von Sabra','Magier R?stung',NULL,'Falda de Sabra','Armadura de Mago','','','',''),(2,1,1,1,'????????????','????','??????','','','',1,62,1,15,0,0,0,0,1,150,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\Shield\\Titan\\ti_bu_001.smc',0,0,15,0,0,0,0,0,0,-1,0,-1,'????????????','Knight','','','????','',0,'?z?ÂÂ?ÂÂ?X?x???gÂÂiÂÂ?ÂÂj','','????','?????s???@??','Leather Armor','','Leather Armor','Titan Armor','Prote??o Simples','',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,'????','','','Leather Armor','Harnisch des Titans','Titan R?stung',NULL,'Armadura de *****?n','Armadura de *****?n','','','',''),(3,1,2,1,'????????????','????','??????','','','',1,62,3,12,0,0,0,0,1,100,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\Shield\\Titan\\ti_bd_001.smc',0,1,0,0,0,0,0,0,0,-1,0,-1,'???????????','Knight','','','????','',0,'?z?ÂÂ?ÂÂ?X?x???gÂÂi??ÂÂj','','????','?????s???u??','Leather Pants','','Leather Pants','Titan Armor','Cal??o Simples','',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,'????','','','Leather Pants','Hose des Titans','Titan R?stung',NULL,'Pantal?n de *****?n','Armadura de *****?n','','','',''),(4,1,3,1,'??????????????','?????M','??????','','','',1,62,5,8,0,0,0,0,1,30,0,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\Shield\\Titan\\ti_hn_001.smc',0,0,13,0,0,0,0,0,0,-1,0,-1,'???????????????','','','','?????M','',0,'?N??ÂÂ[?`??ÂÂ[?n?“?g?O?ÂÂÂÂ[?u','','?????M','?????s?????M','Leather Gloves','','Leather Gloves','Titan Armor','Luvas Simples','',-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,'?????M','','','Leather Gloves','Handschuhe des Titans','Titan R?stung',NULL,'Guantes de *****?n','Armadura de *****?n','','','',''),(5,1,1,1,'????????','?L????','??????????','','','',1,62,1,35,0,0,0,0,11,210,1467,-1,0,-1,-1,-1,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,1023,'Data\\Item\\Shield\\*****

[Err] 2006 - MySQL server has gone away

[Err] /*Data for the table `t_npc` */

 

insert into `t_npc`(`a_index`,`a_enable`,`a_name`,`a_name_twn`,`a_name_chn`,`a_family`,`a_skillmaster`,`a_flag`,`a_flag1`,`a_level`,`a_exp`,`a_prize`,`a_sight`,`a_size`,`a_move_area`,`a_attack_area`,`a_skill_point`,`a_descr`,`a_descr_twn`,`a_descr_chn`,`a_descr_long`,`a_sskill_master`,`a_str`,`a_dex`,`a_int`,`a_con`,`a_attack`,`a_magic`,`a_defense`,`a_resist`,`a_attacklevel`,`a_defenselevel`,`a_hp`,`a_mp`,`a_attackType`,`a_attackSpeed`,`a_recover_hp`,`a_recover_mp`,`a_walk_speed`,`a_run_speed`,`a_skill0`,`a_skill1`,`a_skill2`,`a_skill3`,`a_item_0`,`a_item_1`,`a_item_2`,`a_item_3`,`a_item_4`,`a_item_5`,`a_item_6`,`a_item_7`,`a_item_8`,`a_item_9`,`a_item_10`,`a_item_11`,`a_item_12`,`a_item_13`,`a_item_14`,`a_item_15`,`a_item_16`,`a_item_17`,`a_item_18`,`a_item_19`,`a_item_percent_0`,`a_item_percent_1`,`a_item_percent_2`,`a_item_percent_3`,`a_item_percent_4`,`a_item_percent_5`,`a_item_percent_6`,`a_item_percent_7`,`a_item_percent_8`,`a_item_percent_9`,`a_item_percent_10`,`a_item_percent_11`,`a_item_percent_12`,`a_item_percent_13`,`a_item_percent_14`,`a_item_percent_15`,`a_item_percent_16`,`a_item_percent_17`,`a_item_percent_18`,`a_item_percent_19`,`a_minplus`,`a_maxplus`,`a_probplus`,`a_product0`,`a_product1`,`a_product2`,`a_product3`,`a_product4`,`a_file_smc`,`a_motion_walk`,`a_motion_idle`,`a_motion_dam`,`a_motion_attack`,`a_motion_die`,`a_motion_run`,`a_motion_idle2`,`a_motion_attack2`,`a_scale`,`a_attribute`,`a_fireDelayCount`,`a_fireDelay0`,`a_fireDelay1`,`a_fireDelay2`,`a_fireDelay3`,`a_fireEffect0`,`a_fireEffect1`,`a_fireEffect2`,`a_fireObject`,`a_fireSpeed`,`a_name_thai`,`a_descr_thai`,`a_name_thai_eng`,`a_descr_thai_eng`,`a_aitype`,`a_aiflag`,`a_aileader_flag`,`a_ai_summonHp`,`a_aileader_idx`,`a_aileader_count`,`a_name_jpn`,`a_descr_jpn`,`a_name_mal`,`a_descr_mal`,`a_name_mal_eng`,`a_descr_mal_eng`,`a_name_usa`,`a_descr_usa`,`a_name_brz`,`a_descr_brz`,`a_name_hk`,`a_descr_hk`,`a_descr_hk_eng`,`a_name_hk_eng`,`a_name_ger`,`a_descr_ger`,`a_hit`,`a_dodge`,`a_magicavoid`,`a_job_attribute`,`a_name_spn`,`a_descr_spn`,`a_name_frc`,`a_descr_frc`,`a_name_pld`,`a_descr_pld`,`a_name_rus`,`a_descr_rus`,`a_name_tur`,`a_descr_tur`,`a_name_spn2`,`a_descr_spn2`,`a_name_frc2`,`a_descr_frc2`,`a_name_ita`,`a_descr_ita`,`a_name_mex`,`a_descr_mex`,`a_name_nld`,`a_descr_nld`,`a_npc_choice_trigger_count`,`a_npc_choice_trigger_ids`,`a_npc_kill_trigger_count`,`a_npc_kill_trigger_ids`,`a_createprob`,`a_socketprob_0`,`a_socketprob_1`,`a_socketprob_2`,`a_socketprob_3`,`a_jewel_0`,`a_jewel_1`,`a_jewel_2`,`a_jewel_3`,`a_jewel_4`,`a_jewel_5`,`a_jewel_6`,`a_jewel_7`,`a_jewel_8`,`a_jewel_9`,`a_jewel_10`,`a_jewel_11`,`a_jewel_12`,`a_jewel_13`,`a_jewel_14`,`a_jewel_15`,`a_jewel_16`,`a_jewel_17`,`a_jewel_18`,`a_jewel_19`,`a_jewel_percent_0`,`a_jewel_percent_1`,`a_jewel_percent_2`,`a_jewel_percent_3`,`a_jewel_percent_4`,`a_jewel_percent_5`,`a_jewel_percent_6`,`a_jewel_percent_7`,`a_jewel_percent_8`,`a_jewel_percent_9`,`a_jewel_percent_10`,`a_jewel_percent_11`,`a_jewel_percent_12`,`a_jewel_percent_13`,`a_jewel_percent_14`,`a_jewel_percent_15`,`a_jewel_percent_16`,`a_jewel_percent_17`,`a_jewel_percent_18`,`a_jewel_percent_19`,`a_name_dev`,`a_descr_dev`) values (148,1,'????? ??','???`?k??','????????',8,-1,14,0,35,5511,235,7,1.3,12,0.8,1000,'','','','',-1,106,96,96,106,112,0,614,34,35,35,3407,2142,0,17,40,40,1.5,4.5,'','','-1','-1',44,85,173,793,794,800,801,815,816,822,823,808,809,987,999,807,-1,-1,-1,-1,800,7,100,300,300,300,300,300,300,300,300,300,300,300,300,300,0,0,0,0,0,0,0,-1,-1,-1,-1,-1,'Data\\monster\\m_ramian\\ramianqueen.smc','ramianqueen_walk','ramianqueen_idle01','ramianqueen_dam_01','ramianqueen_att_01','ramianqueen_die','ramianqueen_run','ramianqueenidle_02','ramianqueen_att_02',1,0,0,0,0,0,0,'','','',0,0,'?????? ???????','','','',0,0,0,0,0,0,'???~?A?“?N?BÂÂ[?“','','???`?k??','','Death Goddess','','Death Goddess','','Rainha Nina','','???`?k??','','','Death Goddess','G?ttin der Dunkelheit','',196,37,37,0,'Naga de la Oscuridad','','D?esse des t?n?bres','','Bogini Ciemno?ci','','?????? ??????',' ','Kara

[Err] 2006 - MySQL server has gone away

[Err] /*Data for the table `t_npc_regen` */

 

insert into `t_npc_regen`(`a_index`,`a_zone_num`,`a_npc_idx`,`a_pos_x`,`a_pos_z`,`a_pos_h`,`a_pos_r`,`a_y_layer`,`a_regen_sec`,`a_total_num`) values (120078,6,144,27.938,189,37,180,0,0,1),(120079,6,143,30.438,186.25,37,180,0,0,1),(120080,6,144,29.5,172.5,26.01,-180,0,0,1),(1770489,4,519,1820.44,278.438,100.604,180,0,6000,-1),(1825036,23,502,750.75,616.5,43.25,0,0,300,-1),(1825035,23,502,771.25,607.75,46.25,0,0,300,-1),(1865268,32,192,307.375,343.125,76.1194,-90,0,300,-1),(1825034,23,858,1208,108,100.797,-60,0,300,-1),(1825033,23,850,754,566.75,45.7117,-210,0,300,-1),(1825032,23,841,373.313,913.031,34.9784,0,0,300,-1),(1825031,23,509,1050.63,644.813,92.9631,45,4,300,-1),(1825030,23,505,1328.31,1111.06,159.536,0,0,72000,-1),(1825029,23,504,362.156,784.875,35.3254,0,0,72000,-1),(1825028,23,503,1262.5,164.75,87.7465,0,0,300,-1),(3141952,32,455,1030.72,615.188,50.4732,0,0,300,-1),(1825027,23,503,1296.69,1095.81,160.582,0,0,300,-1),(1825026,23,503,1305.22,1096.13,159.866,0,0,300,-1),(1825025,23,503,1276.5,1150.75,154.562,0,0,300,-1),(1825024,23,503,1266.56,1145.59,153.681,0,0,300,-1),(1825023,23,503,1282.13,1143.06,155.072,0,0,300,-1),(1825022,23,503,1286.81,1112.69,159.205,0,0,300,-1),(1825021,23,503,1295.56,1126.25,157.086,0,0,300,-1),(1353054,9,189,284,324,75.51,90,0,300,-1),(1353053,9,189,224,324,75.51,90,0,300,-1),(1353052,9,189,240,344,74.51,90,0,300,-1),(1353051,9,189,263,345,74.51,90,0,300,-1),(1353050,9,189,238,399,70.635,90,0,300,-1),(1353049,9,189,263,393,70.635,90,0,300,-1),(1353048,9,189,260,436,70.635,90,0,300,-1),(1353047,9,189,240,428,70.635,90,0,300,-1),(1353046,9,189,396,344,57.51,-90,0,300,-1),(1353045,9,189,408,340,57.51,-90,0,300,-1),(1353044,9,189,408,380,52.51,-90,0,300,-1),(1353043,9,189,396,380,52.51,-90,0,300,-1),(1353042,9,189,408,368,52.51,-90,0,300,-1),(1353041,9,189,396,368,52.51,-90,0,300,-1),(1353040,9,188,256,340,74.51,90,0,300,-1),(1353039,9,188,240,384,70.635,90,0,300,-1),(1353038,9,188,269.5,372,70.51,90,0,300,-1),(1353037,9,188,276,416,70.51,90,0,300,-1),(1353036,9,188,228,412,70.51,90,0,300,-1),(1353035,9,188,388,384,52.51,-90,0,300,-1),(1353034,9,188,412,384,52.51,-90,0,300,-1),(1353033,9,188,376,384,52.51,-90,0,300,-1),(1353032,9,218,182.5,234.5,49.51,60,0,300,-1),(1353031,9,190,404,328,57.51,180,0,432000,-1),(1353030,9,188,424,384,52.51,-90,0,300,-1),(1353029,9,188,416,352,56.9331,-90,0,300,-1),(1353028,9,188,404,356,56.6638,-90,0,300,-1),(1353027,9,188,392,352,57.51,-90,0,300,-1),(1353026,9,187,104,420,48.51,90,0,300,-1),(1353025,9,187,36,416,48.51,90,0,300,-1),(1353024,9,187,48,408,48.51,90,0,300,-1),(1353023,9,187,48,428,48.51,90,0,300,-1),(1353022,9,187,127.75,424.5,48.51,90,0,300,-1),(1353021,9,187,56,352,48.51,90,0,300,-1),(1353020,9,187,28,348,48.51,90,0,300,-1),(1353019,9,187,64,380,50.51,90,0,300,-1),(1353018,9,187,28,424,48.51,90,0,300,-1),(1353017,9,187,100,356,48.51,90,0,300,-1),(1825020,23,503,1195.41,1365.31,152.638,0,0,300,-1),(1825019,23,503,1119.72,1302.88,105.895,0,0,300,-1),(1825018,23,503,1102.53,1318.88,107.017,0,0,300,-1),(1825017,23,503,1101.41,1441.38,134.53,0,0,300,-1),(1825016,23,503,1054.69,1325.56,104.699,0,0,300,-1),(1825015,23,503,988.188,1370.13,107.059,0,0,300,-1),(1825014,23,503,1037.5,1350.09,105.946,0,0,300,-1),(1825013,23,503,1020.97,1362.19,107.009,0,0,300,-1),(1825012,23,503,990,1421.88,110.959,0,0,300,-1),(1825011,23,503,980.5,1387.94,106.201,0,0,300,-1),(1825010,23,503,991.563,1393.13,106.148,0,0,300,-1),(1825009,23,503,1011.97,1424.84,115.043,0,0,300,-1),(1825008,23,503,1041.72,1449.09,122.031,0,0,300,-1),(1825007,23,503,1081.16,1451.53,133.57,0,0,300,-1),(1825006,23,503,1129.44,1436.44,140.059,0,0,300,-1),(1825005,23,503,1169.97,1420.31,143.565,0,0,300,-1),(1825004,23,503,1152.69,1413.09,144.054,0,0,300,-1),(1825003,23,503,1187.84,1406.47,145.884,0,0,300,-1),(1825002,23,503,1182.38,1420.75,144.187,0,0,300,-1),(1825001,23,503,1080.34,1334.13,104.924,0,0,300,-1),(1825000,23,503,1025.59,1338.06,105.655,0,0,300,-1),(1824999,23,503,1165.72,1227.09,103.995,0,0,300,-1),(1824998,23,503,1154.13,1228.44,102.

[Err] 2006 - MySQL server has gone away

[Err] /*Data for the table `t_quest` */

 

insert into `t_quest`(`a_index`,`a_name`,`a_name_twn`,`a_name_chn`,`a_type1`,`a_type2`,`a_enable`,`a_prequest_num`,`a_start_type`,`a_start_data`,`a_start_npc_zone_num`,`a_prize_npc`,`a_prize_npc_zone_num`,`a_need_exp`,`a_need_min_level`,`a_need_max_level`,`a_need_job`,`a_need_item0`,`a_need_item1`,`a_need_item2`,`a_need_item3`,`a_need_item4`,`a_need_item_count0`,`a_need_item_count1`,`a_need_item_count2`,`a_need_item_count3`,`a_need_item_count4`,`a_condition0_type`,`a_condition1_type`,`a_condition2_type`,`a_condition0_index`,`a_condition1_index`,`a_condition2_index`,`a_condition0_num`,`a_condition1_num`,`a_condition2_num`,`a_condition0_data0`,`a_condition0_data1`,`a_condition0_data2`,`a_condition0_data3`,`a_condition1_data0`,`a_condition1_data1`,`a_condition1_data2`,`a_condition1_data3`,`a_condition2_data0`,`a_condition2_data1`,`a_condition2_data2`,`a_condition2_data3`,`a_prize_type0`,`a_prize_type1`,`a_prize_type2`,`a_prize_type3`,`a_prize_type4`,`a_prize_index0`,`a_prize_index1`,`a_prize_index2`,`a_prize_index3`,`a_prize_index4`,`a_prize_data0`,`a_prize_data1`,`a_prize_data2`,`a_prize_data3`,`a_prize_data4`,`a_option_prize`,`a_opt_prize_type0`,`a_opt_prize_type1`,`a_opt_prize_type2`,`a_opt_prize_type3`,`a_opt_prize_type4`,`a_opt_prize_type5`,`a_opt_prize_type6`,`a_opt_prize_index0`,`a_opt_prize_index1`,`a_opt_prize_index2`,`a_opt_prize_index3`,`a_opt_prize_index4`,`a_opt_prize_index5`,`a_opt_prize_index6`,`a_opt_prize_data0`,`a_opt_prize_data1`,`a_opt_prize_data2`,`a_opt_prize_data3`,`a_opt_prize_data4`,`a_opt_prize_data5`,`a_opt_prize_data6`,`a_opt_prize_plus0`,`a_opt_prize_plus1`,`a_opt_prize_plus2`,`a_opt_prize_plus3`,`a_opt_prize_plus4`,`a_opt_prize_plus5`,`a_opt_prize_plus6`,`a_only_opt_prize`,`a_desc`,`a_desc_twn`,`a_desc_chn`,`a_desc2`,`a_desc2_twn`,`a_desc2_chn`,`a_desc3`,`a_desc3_twn`,`a_desc3_chn`,`a_name_thai`,`a_desc_thai`,`a_desc2_thai`,`a_desc3_thai`,`a_name_thai_eng`,`a_desc_thai_eng`,`a_desc2_thai_eng`,`a_desc3_thai_eng`,`a_name_jpn`,`a_desc_jpn`,`a_desc2_jpn`,`a_desc3_jpn`,`a_name_mal`,`a_desc_mal`,`a_desc2_mal`,`a_desc3_mal`,`a_name_mal_eng`,`a_desc_mal_eng`,`a_desc2_mal_eng`,`a_desc3_mal_eng`,`a_name_usa`,`a_desc_usa`,`a_desc2_usa`,`a_desc3_usa`,`a_name_brz`,`a_desc_brz`,`a_desc2_brz`,`a_desc3_brz`,`a_name_hk`,`a_desc_hk`,`a_desc2_hk`,`a_desc3_hk`,`a_desc2_hk_eng`,`a_desc3_hk_eng`,`a_desc_hk_eng`,`a_name_hk_eng`,`a_name_ger`,`a_desc_ger`,`a_desc2_ger`,`a_desc3_ger`,`a_name_spn`,`a_desc_spn`,`a_desc2_spn`,`a_desc3_spn`,`a_name_frc`,`a_desc_frc`,`a_desc2_frc`,`a_desc3_frc`,`a_name_pld`,`a_desc_pld`,`a_desc2_pld`,`a_desc3_pld`,`a_name_rus`,`a_desc_rus`,`a_desc2_rus`,`a_desc3_rus`,`a_failvalue`,`a_partyscale`,`a_name_tur`,`a_desc_tur`,`a_desc2_tur`,`a_desc3_tur`,`a_name_spn2`,`a_desc_spn2`,`a_desc2_spn2`,`a_desc3_spn2`,`a_name_frc2`,`a_desc_frc2`,`a_desc2_frc2`,`a_desc3_frc2`,`a_name_ita`,`a_desc_ita`,`a_desc2_ita`,`a_desc3_ita`,`a_name_mex`,`a_desc_mex`,`a_desc2_mex`,`a_desc3_mex`,`a_name_nld`,`a_desc_nld`,`a_desc2_nld`,`a_desc3_nld`,`a_start_give_item`,`a_start_give_kindcount`,`a_start_give_numcount`,`a_start_trigger_id`,`a_quest_flag`,`a_name_dev`,`a_desc_dev`,`a_desc2_dev`,`a_desc3_dev`) values (28,'???????? ????(????)','????????G???????','???????????',2,0,1,0,0,136,0,139,0,0,10,38,-1,-1,-1,-1,-1,-1,0,0,0,0,0,1,-1,-1,290,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,5,2,0,-1,391,5,0,786,0,5,1,3249,1,0,0,-1,-1,-1,-1,-1,-1,-1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'??? ???? ?????? ?????? ???????\r\n???? ???? ?????? ??????? ???? ?? \"??????\"???? ????????? ????!\r\n?? ?????? ???????? ???????? ???? ??????','?Q?n??????]?????????H?????o???u?]????????v????i?A?o?|i?????z???F?C','????? ??????????????\r\n??????????????? ????????????!\r\n?????????????????????','???? ?????? ?????? ????????. ???? ???????? ?? ?????? ???? ???????? ??????????.\r\n???? ?????? ???? ???? \"???? ????\"?? ???? ???????? ??????\r\n???? ?????????? ???? ?????? ?????? ????????????','?z?O????????????a?H?{?b?NiD?z????????k?C\r\n\r\n?????A?J?M?z?O???????A???N?N?????z?u???????????va?C?U??

[Err] 2006 - MySQL server has gone away

[Err] /*Data for the table `t_skill` */

 

insert into `t_skill`(`a_index`,`a_job`,`a_job2`,`a_name`,`a_name_twn`,`a_name_chn`,`a_type`,`a_flag`,`a_maxLevel`,`a_appRange`,`a_fireRange`,`a_fireRange2`,`a_minRange`,`a_targetType`,`a_targetNum`,`a_useState`,`a_useWeaponType0`,`a_useWeaponType1`,`a_use_needWearingType`,`a_useMagicIndex1`,`a_useMagicLevel1`,`a_useMagicIndex2`,`a_useMagicLevel2`,`a_useMagicIndex3`,`a_useMagicLevel3`,`a_appState`,`a_appWeaponType0`,`a_appWeaponType1`,`a_app_needWearingType`,`a_readyTime`,`a_stillTime`,`a_fireTime`,`a_reuseTime`,`a_cd_ra`,`a_cd_re`,`a_cd_sa`,`a_cd_fa`,`a_cd_fe0`,`a_cd_fe1`,`a_cd_fe2`,`a_cd_fot`,`a_cd_fos`,`a_cd_ox`,`a_cd_oz`,`a_cd_oh`,`a_cd_oc`,`a_cd_fdc`,`a_cd_fd0`,`a_cd_fd1`,`a_cd_fd2`,`a_cd_fd3`,`a_cd_dd`,`a_cd_fe_after`,`a_cd_fe_after2`,`a_client_description`,`a_client_description_twn`,`a_client_description_chn`,`a_client_tooltip`,`a_client_tooltip_twn`,`a_client_tooltip_chn`,`a_client_icon_texid`,`a_client_icon_row`,`a_client_icon_col`,`a_cd_ra2`,`a_cd_re2`,`a_cd_sa2`,`a_cd_fa2`,`a_cd_fe3`,`a_cd_fe4`,`a_cd_fe5`,`a_cd_fot2`,`a_cd_fos2`,`a_cd_ox2`,`a_cd_oz2`,`a_cd_oh2`,`a_cd_oc2`,`a_cd_fdc2`,`a_cd_fd4`,`a_cd_fd5`,`a_cd_fd6`,`a_cd_fd7`,`a_cd_dd2`,`a_selfparam`,`a_targetparam`,`a_soul_consum`,`a_summon_idx`,`a_name_thai`,`a_client_description_thai`,`a_client_tooltip_thai`,`a_name_thai_eng`,`a_client_description_thai_eng`,`a_client_tooltip_thai_eng`,`a_name_jpn`,`a_client_description_jpn`,`a_client_tooltip_jpn`,`a_sorcerer_flag`,`a_name_mal`,`a_client_description_mal`,`a_client_tooltip_mal`,`a_name_mal_eng`,`a_client_description_mal_eng`,`a_client_tooltip_mal_eng`,`a_name_usa`,`a_client_description_usa`,`a_client_tooltip_usa`,`a_name_brz`,`a_client_description_brz`,`a_client_tooltip_brz`,`a_name_hk`,`a_client_description_hk`,`a_client_tooltip_hk`,`a_client_description_hk_eng`,`a_client_tooltip_hk_eng`,`a_name_hk_eng`,`a_name_ger`,`a_client_description_ger`,`a_client_tooltip_ger`,`a_apet_index`,`a_name_spn`,`a_client_description_spn`,`a_client_tooltip_spn`,`a_name_frc`,`a_client_description_frc`,`a_client_tooltip_frc`,`a_name_pld`,`a_client_description_pld`,`a_client_tooltip_pld`,`a_name_rus`,`a_client_description_rus`,`a_client_tooltip_rus`,`a_name_tur`,`a_client_description_tur`,`a_client_tooltip_tur`,`a_name_spn2`,`a_client_description_spn2`,`a_client_tooltip_spn2`,`a_name_frc2`,`a_client_description_frc2`,`a_client_tooltip_frc2`,`a_name_ita`,`a_client_description_ita`,`a_client_tooltip_ita`,`a_name_mex`,`a_client_description_mex`,`a_client_tooltip_mex`,`a_name_nld`,`a_client_description_nld`,`a_client_tooltip_nld`,`a_allowzone`,`a_name_dev`,`a_client_description_dev`,`a_client_tooltip_dev`) values (1,0,0,'???? ??????','????','????????',0,4,5,0,2,2,0,2,1,2,3,4,-1,-1,0,-1,0,-1,0,0,-1,-1,-1,0,0,22,30,'','','','ti_skill_01','TI Power Magnum 1','','TI Power Magnum 2',0,0,0,0,0,0,1,1.14,0,0,0,0,'','','?????????? ???? ???? ???? ???? ??????????.','?`?J?j?l?Oq???M?b?W?A??????H?C','???????????????????????????.','','','',0,0,0,'','','','ti_a_skill_01','TI Power Magnum 1_a','','TI Power Magnum 2',0,0,0,0,0,0,1,1.14,0,0,0,0,0,0,0,-1,'???????????????','???????????????????? ??????????????????????','','','','','?p?ÂÂÂÂ[?}?O?i?€','?u??ÂÂ[?h??????â€â€???ÂÂ???ÂÂA“G??ÂÂU??????ÂÂB','',0,'????','Q?????????Oq???','','Power Magnum','Strong blade attack\r\n','Increase damage on next attack.','Power Magnum','Increase damage on next attack.\r\n','Strong blade attack.','Grande Impacto','Ataca o inimigo com maior for?a','','????','?`?J?j?l?Oq???M?b?W?A??????H?C','','Strong blade attack','','Power Magnum','Kraftfokus','Steigert die Angriffskraft.','Der Titan konzentriert seine Kraft auf einen einzelnen m?chtigen Schlag gegen einen Gegner. Steigt die Angriffskraft.',0,'Poder m?ximo','Poderoso ataque contra un enemigo.','El *****?n concentra su fuerza en un ?nico golpe potente contra un enemigo.','Foyer de force','Augmente la force d\'attaque.','Le titan concentre sa force sur un coup contre un ennemi. Augmente la force d\'attaque.','Fokus Si?y','Podnosi atak. Tytan koncentruje swoj? si?e na jednym przeciw

[Err] 2006 - MySQL server has gone away

[Err] /*Data for the table `t_string` */

 

insert into `t_string`(`a_index`,`a_string`,`a_string_twn`,`a_string_chn`,`a_string_thai`,`a_string_thai_eng`,`a_string_twn2`,`a_string_jpn`,`a_string_mal`,`a_string_mal_eng`,`a_string_usa`,`a_string_brz`,`a_string_hk`,`a_string_hk_eng`,`a_string_ger`,`a_string_spn`,`a_string_frc`,`a_string_pld`,`a_string_rus`,`a_string_tur`,`a_string_spn2`,`a_string_frc2`,`a_string_ita`,`a_string_mex`,`a_string_nld`,`a_string_dev`) values (1,'???? ?????? ???? ????????.','???A???H???w??','???????????','??????????????????????1','','???A???H???w??.','ÂÂ?‘???ÂÂâ€Â??ÂÂ?????z??????????ÂÂB','???A???H???w??.','Server is busy. Please try again.','Server is busy. Please try again.','Muitos pedidos para conex?o.','???A???H???w??','Server is busy. Please try again.','Der Server ist ?berlastet. Bitte versuch es sp?ter noch einmal','El servidor est? sobrecargado. Por favor, int?ntelo de nuevo m?s tarde.','Le serveur est surcharg?. STP essaie encore une fois plus tard.','Serwer jest przeci??ony. Prosz? spr?buj p??niej jeszcze raz','?????? ?????. ????????? ??????? ?????.','Serverde trafik yo?un. L?tfen daha sonra tekrar deneyin','Server ocupado. Por favor intenta de nuevo.','','Il server ? sovraccarico. Riprova pi? tardi.','El servidor est? ocupado. Por favor, int?ntelo de nuevo m?s tarde.','','Server is busy. Please try again.'),(2,'?????? ???? ????????. ??????????? ???? ????????????.','?C?????????~','??????????.??????????????','????????????????? ???????????? Client ???????','','?C?????????~','?oÂÂ[?W???“??????????ÂÂBÂÂ?“x?N???C?A?“?g????ÂÂs????????????ÂÂB','?C?????????~','Invalid game version.','Invalid version.','N?o ? a vers?o correta. Tente o cliente novamente.','?C?????????~','Invalid game version.','Falsche Client Version','Versi?n de cliente incorrecta.','Mauvaise version du client.','Niew?a?ciwa wersja clienta','?????? ??????.','Yanl?? client versionu','Versi?n inv?lida.','','Versione del client errata','Version Invalida','','Invalid version.'),(3,'?????? ?????? ???????? ????????.','???J???r???T?????r?A?????s?T?{','????????????','??????????????????????????????','','???J???r???T???r???A?????s?T?{','??????•??????????????????ÂÂB','???J???r???T???r???A?????s?T?{','Invalid command.','Invalid command.','H? letras erradas.','???J???r???T?????r?A?????s?T?{','Invalid command.','Ung?ltiger Befehl','Caracteres no v?lidos.','Commande invalide','Niew?a?ciwe polecenie\r\n','???????? ???????.','Ge?ersiz Komut','Orden inv?lida.','','Comando non valido','Comando Invalido.','','Invalid command.'),(4,'?????? ????????.','?K?X???J???~','????????','????????????????','','?K?X???J???~','?p?X?ÂÂÂÂ[?h??????????ÂÂB','?K?X???J???~','Invalid password.','Invalid password.','Senha inv?lida','?K?X???J???~','Invalid password.','Benutzername oder Passwort ung?ltig','Nombre de usuario o contrase?a incorrectos.','Nom d\'utilisateur ou mot de passe invalide','Login lub has?o nieprawid?owe\r\n','???????? ??????.','Kullan?c? ad? veya ?ifre yanl??','ID o Contrase?a inv?lida.','','Nome utente o password errati','Contrase?a incorrecta.','','Invalid password.'),(5,'?????? ?????? ?????? ????????. 11?? 4?? ??????????.','???A???|??}??','LastChaos - MDO','??????????????????????????????','','???A???|??}??','??ÂÂ????TÂÂ[?r?X?????O????ÂÂB','???A???|??}??','Server unavailable.','Server unavailable.','Est? fora de servi?o agora. Ser? aberto dia 4 de novembro.','???A???|??}??','Server unavailable.','Der Server ist im Moment nicht verf?gbar','Este servicio no est? disponible en estos momentos.','Le serveur n\'est momentan?ment pas disponible','Serwer jest w tej chwili niedost?pny','?????? ??????????.','Sunucu ?u an ?evirim d???','Server no disponible.','','Attualmente il server non ? disponibile','El servidor no est? disponible','','Server unavailable.'),(6,'???? ?????? ????????????.','?b?????b??????','????????????','ID ????????????????????','','?b?????b??????','????ID??????ÂÂ?‘???????????ÂÂB','?b?????b??????','Account ID already logged on.','Account ID already logged on.','Este ID j? conectado.','?b?????b??????','Account ID already logged on.','Dieser Be

[Err] 1231 - Variable 'sql_mode' can't be set to the value of 'NULL'

[Err] /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;

[Err] 1231 - Variable 'foreign_key_checks' can't be set to the value of 'NULL'

[Err] /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;

[Err] 1231 - Variable 'unique_checks' can't be set to the value of 'NULL'

[Err] /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;

[Err] 1231 - Variable 'sql_notes' can't be set to the value of 'NULL'

[Err] /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

[Msg] Finished - Unsuccessfully

--------------------------------------------------

 




- kimpobin02 - 11-29-2012

Thank I can Fixed It