![](https://metin2.dev/uploads/theme-resources/set_resources_31/84c1e40ea0e759e3f1505eb1788ddf3c_pattern.png)
![](https://metin2.dev/uploads/theme-resources/set_resources_31/84c1e40ea0e759e3f1505eb1788ddf3c_default_photo.png)
siemka256
-
Posts
35 -
Joined
-
Last visited
-
Feedback
0%
Content Type
Forums
Store
Third Party - Providers Directory
Feature Plan
Release Notes
Docs
Events
Posts posted by siemka256
-
-
Napisz dokladnie co chcesz po polsku i angielsku, przetlumacze Ci, nie przeklinaj
Heart hurts when reading it so I translate it for him
-
Other client is fine so that's not the case. It's just this particular one.
@Edit
Tried MW2 and it's fine
syserr:
0324 23:46:16654 :: CMapOutdoor::Load - LoadMonsterAreaInfo ERROR 0324 23:46:57216 :: Traceback (most recent call last): 0324 23:46:57216 :: File "game.py", line 1202, in OnKeyDown 0324 23:46:57216 :: File "game.py", line 1386, in RequestDropItem 0324 23:46:57216 :: AttributeError 0324 23:46:57216 :: : 0324 23:46:57216 :: 'GameWindow' object has no attribute 'itemDropQuestionDialog' 0324 23:46:57216 :: 0324 23:46:57216 :: Traceback (most recent call last): 0324 23:46:57216 :: File "game.py", line 1202, in OnKeyDown 0324 23:46:57216 :: File "game.py", line 1386, in RequestDropItem 0324 23:46:57216 :: AttributeError 0324 23:46:57216 :: : 0324 23:46:57216 :: 'GameWindow' object has no attribute 'itemDropQuestionDialog' 0324 23:46:57216 :: 0324 23:46:57433 :: Traceback (most recent call last): 0324 23:46:57433 :: File "game.py", line 1202, in OnKeyDown 0324 23:46:57433 :: File "game.py", line 1386, in RequestDropItem 0324 23:46:57433 :: AttributeError 0324 23:46:57433 :: : 0324 23:46:57433 :: 'GameWindow' object has no attribute 'itemDropQuestionDialog' 0324 23:46:57433 :: 0324 23:46:57433 :: Traceback (most recent call last): 0324 23:46:57433 :: File "game.py", line 1202, in OnKeyDown 0324 23:46:57433 :: File "game.py", line 1386, in RequestDropItem 0324 23:46:57433 :: AttributeError 0324 23:46:57433 :: : 0324 23:46:57433 :: 'GameWindow' object has no attribute 'itemDropQuestionDialog' 0324 23:46:57433 :: 0324 23:46:57649 :: Traceback (most recent call last): 0324 23:46:57649 :: File "game.py", line 1202, in OnKeyDown 0324 23:46:57649 :: File "game.py", line 1386, in RequestDropItem 0324 23:46:57649 :: AttributeError 0324 23:46:57649 :: : 0324 23:46:57649 :: 'GameWindow' object has no attribute 'itemDropQuestionDialog' 0324 23:46:57649 :: 0324 23:46:57649 :: Traceback (most recent call last): 0324 23:46:57649 :: File "game.py", line 1202, in OnKeyDown 0324 23:46:57649 :: File "game.py", line 1386, in RequestDropItem 0324 23:46:57650 :: AttributeError 0324 23:46:57650 :: : 0324 23:46:57650 :: 'GameWindow' object has no attribute 'itemDropQuestionDialog' 0324 23:46:57650 ::
@Edit
Fixed, Dunno how and why what caused this but its fine now.
i changed lv and gold from int to bigint and changed game from stripped to unstripped.
-
syserr clean
I make a video on how's this occuring in real life
@Edit
As I cannot start NVidia Geforce, I cannot make a demo video.
I am adding more screenshots.
-
Does anyone know why's this happening?
GAME vanilla 60k
client bin: 28249
-
load: ANI directory = (null)
? What about that?
Cba to create new one so I dig
-
-
-
For other people who look for libs in the future:
pkg install compat7x
or
cd /usr/ports/misc/compat7x && make install clean
-
I changed port from 22, this could help.
If still having brutes then I hop to Key Auth
regards,
-
@bump
don't want to create another topic
-
reupload? anyone?
-
-
Here are the event flags available up to Ymir's game 34083.
Usage: /e eventflag value
mob_dam [value]
Set mobs damage (default 100)
mob_gold, mob_gold_buyer [value]
Set gold drop rate for free and premium* user (default 100)
mob_gold_pct, mob_gold_pct_buyer [value]
Set yang bomb drop rate for free and premium* user (default 100)
mob_exp, mob_exp_buyer [value]
Set experience rate for free and premium* user (default 100)
mob_item, mob_item_buyer [value]
Set item drop rate for free and premium* user
arena_potion_limit [bool]
Enable limit of potions that you can use in Musician's Yu-Hwan duel arena (thanks to TÜRK)
arena_potion_limit_count [value]
Number of potions that can be used if arena_potion_limit is true (thanks to TÜRK)
eclipse [bool]
Enable and disable night mode.
gold_drop_limit_time [sec]
Time in seconds before Yang can be dropped again (anti drop bot measure)
guild_disband_delay [bool]
Set a 24 hours waiting time after a guild is disbanded, for the members to join another guild. (Default: 1) (thanks to pedr0caz)
guild_withdraw_delay [bool]
Set a 24 hours waiting time after being kicked from a guild, for the player to join another guild. (Default: 1) (thanks to pedr0caz)
hivalue_item_sell [bool]
Value 1 enables sale of Blessing Marble and Perpetual Iron in shops.
MonarchHealGold [yang]
Amount of kingdom Yang required to cast Monarch Heal buff.
personal_shop [tax %]
Place a tax on private shop sales. The Yang goes to the Kingdom vault.
2006_drop [drop rate 1/x]
Enable drop of Chinese New Year 2006 - Hexagonal Box (vnum 50037)
2007_drop [drop rate 1/x]
Enable drop of Chinese New Year 2007 - Hexagonal Box (vnum 50043)
dragon_boat_festival_drop [?]
Enable drop of 50085
drop_moon [bool]
Enable drop of moonlight boxes. Drop rate can NOT be changed!
easter_drop [?]
Enable/set drop of item 50160 to 50179 - Easter Egg (Thanks to miguelmig)
football_drop [?]
Enable/set drop of 50096 - Football Ball (World Cup GF event) (thanks to miguelmig)
halloween_drop [?]
Enable/set drop of 50095 - Pumpkin (thanks to miguelmig)
hc_drop [drop rate 1/x]
Drop rate of item 30178 - Gameforge event for the opening of Grotto of Exile (thanks to miguelmig)
horse_skill_book_drop [drop rate 1/x]
Set drop rate of Horse Skill books.
kids_day_drop [drop rate 1/x]
Drop rate of Puzzle box (50034) for low level players.
kids_day_drop_high [drop rate 1/x]
Drop rate of Puzzle Box (50034) for high level players.
lotto_drop [drop rate 1/x]
Enables drop of Lottery Tickets with unique numbers. The dropped ticket numbers can be found in player.lotto_list table for further processing.
lotto_round [value]
Choose a number to mark the lottery tickets with. This is useful if you want to run different Lottery events and make sure a ticket is not used twice.
mars_drop [drop rate 1/x]
Enable global drop of Perpetual Iron.
newyear_fire [?]
Enable drop of Chinese Fire Crackers (Chinese New Year event)
newyear_mob [bool]
Randomly spawns Hae-Tae in City 2 (Chinese New Year event)
newyear_moon [?]
Moon Paste event, enables drop of vnums 50016~50017~50018~50019 (Chinese New Year event)
new_xmas_event [bool]
Spawns the new christmas tree design in town.
ramadan_drop [drop rate 1/x]
Enable drop of bread (30315) for Gameforge Ramadan event.
three_skill_item [drop rate 1/x]
Set drop rate of Soulstones (from metins and bosses only)
threeway_war_boss_count [value]
Number of Elite Nine Tails that will be summoned for the winning Kingdom in Nation War.
threeway_war_pass_idx [mapidx]
Map index of Nation War pass map. This is filled automatically with a random map from the list in share/locale/whatever/forkedmapindex.txt; do not edit this event flag but change the txt file instead.
threeway_war_sungzi_idx [mapidx]
Map index of Nation War Sungzi map. This is filled automatically with a random map from the list in share/locale/whatever/forkedmapindex.txt; do not edit this event flag but change the txt file instead.
valentine_drop [bool?]
Enable drop of Chocolate and Roses
whiteday_drop [?]
Enable drop of items 50031 - 50032
xmas_boom [bool]
Enable night mode, firework sound, and Event Helper (NPC selling fireworks)
xmas_snow [bool]
Enable snow.
xmas_sock [drop rate 1/x]
Enable drop of Christmas socks.
xmas_song [bool]
Play Christmas song everywhere.
xmas_tree [0-3]
Enable the original Christmas Tree NPC. 3 models available (1,2,3)
* a premium user has an active exp/yang/drop bonus set through the account table (for noobs: the blue squares in the top left corner of the client)
Note: "bool" means that it only accepts "false" (0) or "true" (any other number) as parameters.
Yet unknown:
fish_miss_pct
gold_trade_cycle
gold_trade_enable
indepence_day
japan_regen
medal_part_drop
user_dam
user_dam_buyer
crcdisconnect
pre_event_hc
refine_box
guild_invite_limit
refine_box_drop
refine_box_low
refine_box_mid
refine_box_high
drop_char_stone
drop_char_stone.level_range
dropevent.drop_char_stone
drop_char_stone.percent_lv01_10
drop_char_stone.percent_lv11_30
drop_char_stone.percent_lv31_MX
independence_day
spawn_block_log
threeway_war_choice
threeway_war_kill_count
threeway_war_dead_count
xmas_santa
guild_invite_limit
manwoo
fishevent
poly
update_refine_time
If anybody knows their effect, or other event flags not listed here, please post and I will add it here
Woul've liked but don't want to ruid your 1337 likes
-
navicat password?
mt2:yolo
localhost.
To prevent from the error all you have to do is to edit config files
There's a hashtag upfront locale name and column name (if I am right, i cannot connect to my pc atm.)
----------------------------------------------------------------------------------------------------------------------------
I have a problem with
I beg you help me someone, it's starting to piss me off. I am using a database (tested with metin for FreeBSD). I am connected over the network (externally) to the database.
WELCOME_MSG = "DB Server has been started" SQL_ACCOUNT = "91.121.143.223 account mt2 yolo 0" SQL_PLAYER = "91.121.143.223 player mt2 yolo 0" SQL_COMMON = "91.121.143.223 common mt2 yolo 0" SQL_HOTBACKUP = "91.121.143.223 hotbackup mt2 yolo 0" TABLE_POSTFIX = "" BIND_PORT = 15000 DB_SLEEP_MSEC = 10 CLIENT_HEART_FPS = 10 HASH_PLAYER_LIFE_SEC = 600 BACKUP_LIMIT_SEC = 3600 PLAYER_ID_START = 100 PLAYER_DELETE_LEVEL_LIMIT = 70 PLAYER_DELETE_CHECK_SIMPLE = 1 ITEM_ID_RANGE = 2000000000 2100000000 MIN_LENGTH_OF_SOCIAL_ID = 6 NAME_COLUMN = "locale_name" LOCALE = "international" SIMPLE_SOCIALID = 1 Block "Y/QSB7omi36awq4ctpUxuiwRARM="
Please don't hack me.
-
I am on 34k
my functions:
__fish_real_refine_rod __get_empire_priv_string __get_guild_priv_string __get_guildid_byname __give_char_priv __give_empire_priv __give_guild_priv __refine_pick addimage addmapsignal affect.add affect.add_collect affect.add_collect_point affect.add_hair affect.get_apply_on affect.get_apply_value affect.remove affect.remove_all_collect affect.remove_bad affect.remove_collect affect.remove_good affect.remove_hair arena.add_observer arena.get_duel_list arena.is_in_arena arena.start_duel ba.start bool_to_str building.get_land_id building.get_land_info building.has_land building.reconstruct building.set_land_owner BuildSkillList char_log chat clear_letter clear_server_timer clearmapsignal cleartimer cmdchat color color256 command complete_quest complete_quest_state confirm count_item_range d.all_near_to d.check_eliminated d.clear_regen d.count_monster d.delete_item_in_item_group_from_all d.exit d.exit_all d.exit_all_by_item_group d.exit_all_to_start_position d.get_kill_mob_count d.get_kill_stone_count d.get_map_index d.getf d.is_unique_dead d.is_use_potion d.join d.jump_all d.kill_all d.kill_unique d.new_jump d.new_jump_all d.new_jump_party d.notice d.purge d.purge_unique d.regen_file d.revived d.say_diff_by_item_group d.select d.set_dest d.set_exit_all_at_eliminate d.set_item_group d.set_regen_file d.set_unique d.set_warp_at_eliminate d.set_warp_location d.setf d.setqf d.setqf2 d.spawn d.spawn_goto_mob d.spawn_group d.spawn_mob d.spawn_mob_dir d.spawn_move_group d.spawn_move_unique d.spawn_name_mob d.spawn_stone_door d.spawn_unique d.spawn_wooden_door d.unique_get_hp_perc d.unique_set_def_grade d.unique_set_hp d.unique_set_maxhp delay DragonLair.startRaid find_npc_by_vnum find_pc_by_name find_pc_cond forked.get_pass_start_pos forked.get_sungzi_start_pos forked.getdeadcount forked.getpassmapindexbyempire forked.getpasspathbyempire forked.getsungzimapindex forked.initforked forked.initkillcount forked.is_registered_user forked.isforkedmapindex forked.issungzimapindex forked.purge_all_monsters forked.register_user forked.setdeadcount forked.warp_all_in_map game.drop_item game.drop_item_with_ownership game.get_event_flag game.get_guild_name game.get_safebox_level game.get_warp_guild_war_list game.open_mall game.open_safebox game.request_make_guild game.set_event_flag game.set_safebox_level get_channel_id get_global_time get_locale get_mob_level get_quest_state get_random_vnum_from_table get_server_timer_arg get_time gm_resetstate goldbar.quest guild.around_ranking_string guild.change_master guild.change_master_with_limit guild.get_any_war guild.get_ladder_point guild.get_member_count guild.get_name guild.get_rank guild.get_reserve_war_table guild.get_warp_war_list guild.high_ranking_string guild.is_bet guild.is_war guild.level guild.name guild.war_bet guild.war_enter herb_q_init_a herb_q_init_v highscore.register highscore.show horse.advance horse.feed horse.get_grade horse.get_health horse.get_health_pct horse.get_hp horse.get_level horse.get_name horse.get_stamina horse.get_stamina_pct horse.is_dead horse.is_mine horse.is_riding horse.is_summon horse.revive horse.ride horse.set_level horse.set_name horse.summon horse.unride horse.unsummon input input_number ipairs is_speed_server is_test_server item.can_over9refine item.change_to_over9 item.get_cell item.get_count item.get_id item.get_level item.get_level_limit item.get_name item.get_over9_material_vnum item.get_refine_vnum item.get_size item.get_socket item.get_sub_type item.get_type item.get_value item.get_vnum item.has_flag item.next_refine_vnum item.over9refine item.remove item.select item.select_cell item.set_socket item.set_value item.start_realtime_expire item_log item_name kill_all_in_map loop_timer makequestbutton marriage.divorce_time_check marriage.end_wedding marriage.engage_to marriage.find_married_vid marriage.get_married_time marriage.get_wedding_list marriage.in_my_wedding marriage.join_wedding marriage.marry_to marriage.remove marriage.set_to_marriage marriage.warp_to_my_marriage_map marriage.wedding_client_command marriage.wedding_dark marriage.wedding_is_playing_music marriage.wedding_music marriage.wedding_snow math.ceil math.floor math.max math.min math.mod math.abs math.random member.chat member.clear_ready member.set_ready mgmt.monarch_change_lord mgmt.monarch_state mob.spawn mob.spawn_group mob_name mob_vnum mob_table next_time_is_now next_time_set notice notice_all notice_in_map notice_multiline npc.dec_remain_hairdye_count npc.dec_remain_skill_book_count npc.get_empire npc.get_guild npc.get_leader_vid npc.get_race npc.get_remain_hairdye_count npc.get_remain_skill_book_count npc.get_vid_attack_mul npc.get_vid_damage_mul npc.getrace npc.is_near npc.is_near_vid npc.is_pc npc.is_quest npc.kill npc.lock npc.open_shop npc.purge npc.set_vid_attack_mul npc.set_vid_damage_mul npc.unlock npc_get_job npc_is_same_empire npc_is_same_job number oh.candidacy oh.candidacy_list oh.candidacy_name oh.candidacycount oh.election oh.frog_to_empire_money oh.info oh.isguildmaster oh.ismonarch oh.monarch_mob oh.monarchbless oh.monarchdefenseup oh.monarchpowerup oh.notice oh.spawnguard oh.spawnmob oh.takemonarchmoney oh.transfer oh.warp os.date oxevent.close oxevent.end_event oxevent.end_event_force oxevent.get_attender oxevent.get_status oxevent.give_item oxevent.open oxevent.quiz party.chat party.clear_ready party.get_leader_pid party.get_max_level party.get_near_count party.getf party.give_buff party.is_in_dungeon party.is_leader party.is_party party.run_cinematic party.setf party.setqf party.show_cinematic party.syschat pc.aggregate_monster pc.can_warp pc.change_alignment pc.change_empire pc.change_gold pc.change_money pc.change_name pc.change_sex pc.change_sp pc.changealignment pc.changegold pc.changemoney pc.clear_one_skill pc.clear_skill pc.clear_sub_skill pc.count_item pc.countitem pc.dec_skill_point pc.delqf pc.destroy_guild pc.diamond_refine pc.enough_inventory pc.forget_my_attacker pc.get_alignment pc.get_armor pc.get_change_empire_count pc.get_channel_id pc.get_empire pc.get_empty_inventory_count pc.get_equip_refine_level pc.get_exp pc.get_gm_level pc.get_gold pc.get_guild pc.get_horse_level pc.get_hp pc.get_job pc.get_leadership pc.get_level pc.get_local_x pc.get_local_y pc.get_map_index pc.get_max_hp pc.get_max_sp pc.get_money pc.get_name pc.get_next_exp pc.get_part pc.get_player_id pc.get_playtime pc.get_premium_remain_sec pc.get_race pc.get_real_alignment pc.get_sex pc.get_sig_items pc.get_skill_group pc.get_skill_level pc.get_skill_point pc.get_socket_items pc.get_sp pc.get_special_ride_vnum pc.get_start_location pc.get_vid pc.get_war_map pc.get_weapon pc.get_wear pc.get_x pc.get_y pc.getarmor pc.getcurrentmapindex pc.getempire pc.getf pc.getgold pc.getguild pc.gethp pc.getleadership pc.getmaxhp pc.getmaxsp pc.getmoney pc.getname pc.getplaytime pc.getqf pc.getsp pc.getweapon pc.getx pc.gety pc.give_exp pc.give_exp2 pc.give_exp_perc pc.give_gold pc.give_item pc.give_item2 pc.give_item2_select pc.give_item_from_special_item_group pc.give_lotto pc.give_polymorph_book pc.has_guild pc.has_master_skill pc.hasguild pc.have_map_scroll pc.have_pos_scroll pc.in_dungeon pc.is_clear_skill_group pc.is_dead pc.is_engaged pc.is_gm pc.is_guild_master pc.is_horse_alive pc.is_married pc.is_mount pc.is_near_vid pc.is_polymorphed pc.is_riding pc.is_skill_book_no_delay pc.isguildmaster pc.learn_grand_master_skill pc.mining pc.mount pc.mount_bonus pc.ore_refine pc.pc_attract_ranger pc.polymorph pc.refine_equip pc.remove_from_guild pc.remove_item pc.remove_polymorph pc.remove_skill_book_no_delay pc.removeitem pc.reset_point pc.reset_status pc.revive_horse pc.select pc.send_block_mode pc.set_change_empire_count pc.set_part pc.set_skill_group pc.set_skill_level pc.set_warp_location pc.set_warp_location_local pc.setf pc.setqf pc.teleport pc.unmount pc.warp pc.warp_exit pc.warp_local pc.warp_to_guild_war_observer_position pc_find_skill_teacher_vid pc_find_square_guard_vid pc_get_exp_bonus pc_get_village_map_index pc_is_novice pet.count_summoned pet.is_summon pet.spawn_effect pet.summon pet.unsummon purge_area q.done q.getcurrentquestindex q.no_send q.set_clock q.set_clock_name q.set_clock_value q.set_counter q.set_counter_name q.set_counter_value q.set_icon q.set_quest_state q.set_state q.set_title q.set_title2 q.setstate q.start q.yield raw_script regen_in_map remove_item_range resetdelay restart_quest say say_black say_blue say_blue2 say_gold say_green say_in_map say_item say_item_vnum say_npc_name say_pc_name say_red say_reward say_show_item say_title say_white say_yellow select select_item select_table send_letter send_letter_ex server_loop_timer server_timer set_quest_state set_state setbgimage setcolor setdelay setleftimage setmapcenterposition setskin setstate show_horse_menu skill_group_dialog speedserver.get_current_exp_priv speedserver.get_holiday speedserver.get_wday speedserver.init_holiday speedserver.init_wday speedserver.set_holiday speedserver.set_wday string.format string.gfind string.gsub string.len string.lower sys_log syschat table.foreach table.foreachi table.getn table.insert table.remove table_get_random_item target.clear target.delete target.id target.npc target.pc target.pos target.vid test_chat time_hour_to_sec time_min_to_sec time_to_str timer tonumber tostring type under_han wait warp_all_in_area_to_area warp_all_to_village warp_to_village gm_resetstate get_locale_base_path close io.open lines string.split write get_next_char_num say_size pc.charge_cash
I already got an issue with pc.give_poly_marble and pc.time_remaining
-
That's what my one looks like:
I would like to use your dragon system so if you could fix it I would appreciate.
-
Same issue as @above
-
@_@ BUMP for 40k client
-
Sorry, It doesn't work, still having the same issue.
Would I be able to have your mob_proto.txt, mob_proto.sql with database structure and entries please? Thank you in addition, @Amok,
Regards,
siemka256
-
I am using 34k clean sg files.
I use default .txt files
db:
SYSERR: Nov 5 00:57:15 :: 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 (30130, "¶}¶۱", "Gravestone", 1, 5, 0, 1, SYSERR: Nov 5 00:57:15 :: 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 (30301, "÷dѤن", "Vein of Soul Crystal Ore", SYSERR: Nov 5 00:57:15 :: 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 (33001, "ٰȨСG Șѱ", "Adventurer's Skull", SYSERR: Nov 5 00:57:15 :: 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 (33002, "Ali Baba", "Ali Baba", 1, 5, 0, 1, 0, SYSERR: Nov 5 00:57:15 :: 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 (33003, "Homeless Beggar", "Homeless Beggar", 1 SYSERR: Nov 5 00:57:15 :: 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 (33004, "Homeless Beggar", "Homeless Beggar", 1 SYSERR: Nov 5 00:57:15 :: 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 (33005, "Homeless Beggar", "Homeless Beggar", 1 SYSERR: Nov 5 00:57:15 :: 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 (33006, "Homeless Beggar", "Homeless Beggar", 1 SYSERR: Nov 5 00:57:15 :: 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 (33007, "Homeless Beggar", "Homeless Beggar", 1 SYSERR: Nov 5 00:57:15 :: 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 (33008, "ȣښٓخ e", "Jack Pumpkin", 1, 5, SYSERR: Nov 5 00:57:15 :: 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 (34001, "ےܧv", "Fire Phoenix", 1, 5, 0, 1, 0 SYSERR: Nov 5 00:57:15 :: 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 (34002, "߆Ң ݸ؏", "Baby Reindeer", 1, 5, 0, SYSERR: Nov 5 00:57:15 :: 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 (34003, "۹߰ےܧv", "Ice Phoenix", 1, 5, 0, 1 SYSERR: Nov 5 00:57:15 :: 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 (34004, "DŽȲ", "Baby Gahnasel", 1, 5, 0, 1, 0, SYSERR: Nov 5 00:57:15 :: 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 (34005, "߆Ң |Щ࠸", "Porky", 1, 5, 0, 1, 0, SYSERR: Nov 5 00:57:15 :: 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 (34006, "߆Ң |Щ", "Rufus", 1, 5, 0, 1, 0, SYSERR: Nov 5 00:57:15 :: 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 (34007, "߆Ң |Щȣ", "Khan", 1, 5, 0, 1, 0, 0 SYSERR: Nov 5 00:57:15 :: 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 (34008, "߆Ң |ЩܧZ", "Leonidas", 1, 5, 0, 1 SYSERR: Nov 5 00:57:15 :: 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 (34009, "DŽȲ", "Baby Gahnasel", 1, 5, 0, 1, 0, SYSERR: Nov 5 00:57:15 :: 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 (34010, "ũخݺضݺ߆Ң ݸ؏", "Bambi", 1, 5, 0 SYSERR: Nov 5 00:57:16 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Table 'account.block_exception' doesn't exist
My mob_proto structure:
-- ---------------------------- -- Table structure for `mob_proto` -- ---------------------------- DROP TABLE IF EXISTS `mob_proto`; CREATE TABLE `mob_proto` ( `vnum` int(11) NOT NULL DEFAULT 0 , `name` varchar(24) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT 'Noname' , `locale_name` varbinary(24) NOT NULL DEFAULT 'Noname ' , `rank` tinyint(2) NOT NULL DEFAULT 0 , `type` tinyint(2) NOT NULL DEFAULT 0 , `battle_type` tinyint(1) NOT NULL DEFAULT 0 , `level` smallint(3) NOT NULL DEFAULT 1 , `size` enum('SMALL','MEDIUM','BIG') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'SMALL' , `ai_flag` set('AGGR','NOMOVE','COWARD','NOATTSHINSU','NOATTCHUNJO','NOATTJINNO','ATTMOB','BERSERK','STONESKIN','GODSPEED','DEATHBLOW','REVIVE') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL , `mount_capacity` tinyint(2) NOT NULL DEFAULT 0 , `setRaceFlag` set('ANIMAL','UNDEAD','DEVIL','HUMAN','ORC','MILGYO','INSECT','FIRE','ICE','DESERT') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' , `setImmuneFlag` set('STUN','SLOW','FALL','CURSE','POISON','TERROR') CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' , `empire` tinyint(4) NOT NULL DEFAULT 0 , `folder` varchar(100) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '' , `on_click` tinyint(4) NOT NULL DEFAULT 0 , `st` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `dx` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `ht` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `iq` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `damage_min` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `damage_max` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `max_hp` int(10) UNSIGNED NOT NULL DEFAULT 0 , `regen_cycle` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 , `regen_percent` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 , `gold_min` int(11) NOT NULL DEFAULT 0 , `gold_max` int(11) NOT NULL DEFAULT 0 , `exp` int(10) UNSIGNED NOT NULL DEFAULT 0 , `def` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `attack_speed` smallint(6) UNSIGNED NOT NULL DEFAULT 100 , `move_speed` smallint(6) UNSIGNED NOT NULL DEFAULT 100 , `aggressive_hp_pct` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 , `aggressive_sight` smallint(10) UNSIGNED NOT NULL DEFAULT 0 , `attack_range` smallint(5) UNSIGNED NOT NULL DEFAULT 0 , `drop_item` int(10) UNSIGNED NOT NULL DEFAULT 0 , `resurrection_vnum` int(10) UNSIGNED NOT NULL DEFAULT 0 , `enchant_curse` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 , `enchant_slow` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 , `enchant_poison` tinyint(4) UNSIGNED NOT NULL DEFAULT 0 , `enchant_stun` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 , `enchant_critical` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 , `enchant_penetrate` tinyint(3) UNSIGNED NOT NULL DEFAULT 0 , `resist_sword` tinyint(4) NOT NULL DEFAULT 0 , `resist_twohand` tinyint(4) NOT NULL DEFAULT 0 , `resist_dagger` tinyint(4) NOT NULL DEFAULT 0 , `resist_bell` tinyint(4) NOT NULL DEFAULT 0 , `resist_fan` tinyint(4) NOT NULL DEFAULT 0 , `resist_bow` tinyint(4) NOT NULL DEFAULT 0 , `resist_fire` tinyint(4) NOT NULL DEFAULT 0 , `resist_elect` tinyint(4) NOT NULL DEFAULT 0 , `resist_magic` tinyint(4) NOT NULL DEFAULT 0 , `resist_wind` tinyint(4) NOT NULL DEFAULT 0 , `resist_poison` tinyint(4) NOT NULL DEFAULT 0 , `dam_multiply` float NULL DEFAULT NULL , `summon` int(11) NULL DEFAULT NULL , `drain_sp` int(11) NULL DEFAULT NULL , `mob_color` int(10) UNSIGNED NULL DEFAULT NULL , `polymorph_item` int(10) UNSIGNED NOT NULL DEFAULT 0 , `skill_level0` tinyint(3) UNSIGNED NULL DEFAULT NULL , `skill_vnum0` int(10) UNSIGNED NULL DEFAULT NULL , `skill_level1` tinyint(3) UNSIGNED NULL DEFAULT NULL , `skill_vnum1` int(10) UNSIGNED NULL DEFAULT NULL , `skill_level2` tinyint(3) UNSIGNED NULL DEFAULT NULL , `skill_vnum2` int(10) UNSIGNED NULL DEFAULT NULL , `skill_level3` tinyint(3) UNSIGNED NULL DEFAULT NULL , `skill_vnum3` int(10) UNSIGNED NULL DEFAULT NULL , `skill_level4` tinyint(3) UNSIGNED NULL DEFAULT NULL , `skill_vnum4` int(10) UNSIGNED NULL DEFAULT NULL , `sp_berserk` tinyint(4) NOT NULL DEFAULT 0 , `sp_stoneskin` tinyint(4) NOT NULL DEFAULT 0 , `sp_godspeed` tinyint(4) NOT NULL DEFAULT 0 , `sp_deathblow` tinyint(4) NOT NULL DEFAULT 0 , `sp_revive` tinyint(4) NOT NULL DEFAULT 0 , PRIMARY KEY (`vnum`) ) ENGINE=MyISAM DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci ;
My mob proto txt file:
http://www.speedyshare.com/mMFRn/mob-proto.txt
Please, I need help I've been trying to sort this out for the whole day ;D
-
@requested
-
Do you even english?
-
Welcome,
I need to extract item_proto and mob_proto into .xml or .sql but I'm not one of the best people to do this. I am always having an error or 0 byte files because it doesn't work...
Would I be able to receive some help from the community to help me convert the client item_proto and mob_proto into item_proto.sql and mob_proto.sql so I can import or INSERT the data into my database?
Thank you in addition.
http://speedy.sh/szwyR/item-proto
item_proto virustotal
https://www.virustotal.com/en/file/19c65b7f93ad37f409c82fdfa3a55f01f5e40d5678a29e40788d8ed293b69d48/analysis/1415128322/
mob_proto virustotal
https://www.virustotal.com/en/file/af25a2a32d9fed4f728eb29df6382b154f43eee04573c25b9982c5a42999c00f/analysis/1415128356/
Any help appreciated.
ps
There's an xml of item_proto if needed.
http://www77.zippyshare.com/v/21089979/file.html
Also .txt files from serverside.
http://speedy.sh/hgZCt/item-34k.txt.rar
VirusTotal
Scan
https://www.virustotal.com/en/file/57e075b6da2da9688c6f8b6c93bbf4fc272813f973e8bfda8882fcaa61ff0a28/analysis/1415128683/
ps.
All I need is item_proto and mob_proto from 34k sg clean.
Regards,
siemka256
-
1
-
1
-
-
Thank you very much. I think I also need a mysql dump of mob_proto and item_proto but im not sure, does sg 34k generate it itself? I assume that's why there are files in share. *.txt files.
I also think my config files are odd.
CHANNEL: 1 HOSTNAME: Auth01 PORT: 11000 P2P_PORT: 12000 DB_ADDR: 127.0.0.1 DB_PORT: 15000 PLAYER_SQL: 127.0.0.1 metin2 password account COMMON_SQL: 127.0.0.1 metin2 password common LOG_SQL: 127.0.0.1 metin2 password log SERVER_KEY: fIFjs5S47kdhsMUxsgjSrisTfGRB79PN4qi/D4U6yCX1LYUqBDQOxleqtAxp+cFteti2gp6fnnQ9Td2QFUWjpSuwLX/XDfCTgkCwoxYzb0P20YgIraXKDrN5FHbKYUvOl0Y69NcHUpGo+xU+Tbs2O6AEJYLrqW0BW3ggL6JeVUM* TABLE_POSTFIX: PASSES_PER_SEC: 25 PING_EVENT_SECOND_CYCLE: 180 ADMINPAGE_PASSWORD: uniquehardtoguesspasswordhere ADMINPAGE_IP: my.server.i.p AUTH_SERVER: master TRAFFIC_PROFILE: TEST_SERVER: 0 BIND_IP: *.*.*.*
And I think my client handshaker is not right. Using source sg 34k, compiled. with fixed (intrologin.py) logininfo.txt > logininfo.py
Nov 4 03:03:09 :: SYSTEM: new connection from [82.17.74.176] fd: 16 handshake 1754987163 output input_len 0, ptr 0x28d6cc00Nov 4 03:03:09 :: Handshake: client_time 0 server_time 73918Nov 4 03:03:10 :: AUTH_PHASE 0x28d6cc00
Source Client Clean & Fixed
in Binaries
Posted
ReUpload?