vbacoder

Mob Spawnt nicht an einer der Stellen.. when 11505.kill begin if pc.get_map_index() == 219 then local r=number(1, 3) if r==1 then pc.give_item2(50076, 1) pc.give_item2(50133, 1) pc.give_item2(53049, 1) say_item("Mit OK Info schliessen", 777701, "") local aaa = select ("OK") if aaa == 1 then return end elseif r==2 then pc.give_item2(50076, 1) pc.give_item2(50133, 1) pc.give_item2(53049, 1) say_item("Mit OK Info schliessen", 777701, "") local aaa = select ("OK") if aaa == 1 then return end elseif r==3 then pc.give_item2(50076, 1) pc.give_item2(50133, 1) pc.give_item2(53049, 1) say_item("Mit OK Info schliessen", 777701, "") local aaa = select ("OK") if aaa == 1 then return end end local s=number(1, 30) if 1 == s then mob.spawn( 11505 , 88 , 84 , 1, 1, 1) end if 2 == s then mob.spawn( 11505 , 590 , 140 , 1, 1, 1) end if 3 == s then mob.spawn( 11505 , 191 , 145 , 1, 1, 1) end end end Kompilen und alles geht. Man erhällt auch die Items oben und das Item wird angezeigt. Jedoch spawnt kein neuer Mob an einer der 3 Stellen Weis vll jemand weiter?

Any solving idea for this ?

@Sonitex THX, working but Server dont start anymore. ps says: core1 - ch1 crashed Syserr of Database (4 lines because everything would be to much ): SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34038, "¾Æ±â Àü°©¹é»çÀÚ", "Kugel", 1, 5, 0, 1, SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34039, "¾Æ±â Àü°©¹é»çÀÚ", "Yeti", 1, 5, 0, 1, SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34040, "¾Æ±â Àü°©¹é»çÀÚ", "Fox", 1, 5, 0, 1, 0 SYSERR: Mar 13 15:55:18 :: ChildLoop: AsyncSQL: query failed: Data truncated for column 'size' at row 1 (query: replace into mob_proto (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (34041, "¾Æ±â Àü°©¹é»çÀÚ", "Turtle", 1, 5, 0, 1

I cant find such an config option in Kori Files 1.3. I tried using old DB Core and item_proto TXT and started the Servers Database Core.. There are no changes at item_proto@player in the MySQL Database :S

i already have the TXT file. I want to convert it ti SQL :S

Hi comm, Ich nutzte etwas veraltete Files (Rev41K) mit item_proto / mob_proto als TXT und nicht als SQL in itemproto@player Nun habe ich die Kori Files ausprobiert, und stellte fest, dass diese die Datenbanktabellen nicht als TXT sondern wieder SQL-Format verwenden. Nun zu meiner Frage ... Wie kann ich die alten item_proto.TXT nun zu SQL (Query) konvertieren? oder Umstellen, dass wieder TXT angesprochen wird, Oder zur Not auch die XML vom Client zu SQL kobvertieren. Ich freue mich auf eure Hilfe LG,

UP Problem already there. Core 1 crash after log in with correct credentials.. i reinstalled mySQL.. but problem also there..

I tried with crap files before (Rev 41k), it worked.. so i think my mysql server is not damaged :S

Hey There! I installed the Kori Serverfiles + Client a few houres ago. I have the problem: When I try to login with not existing login credentials, the game says: "Accountname or Password wrong" (GER: Accountname oder Passwort falsch). By trying to login with existing credentials, it always says all the time "Connecting to server..." (GER: Verbindung zum Server wird hergestellt...). I looked in PuTTy and did "ps", so i found out that every time when I try to login with existing credentials, core 1 crashes. Core1 CH1 always crashs... The syserr of core1 doesnt tell me anything: Here is the Syserr of auth: and syserr of Database: User: kori, Pass: passwort are existing in database. I thank everyone who can help me TY <3