A bug or a problem?

RevolutionEO · 12/03/2009, 14:21

Hi, i have got a problem, on my server in the Gameserver\syslog folder there is no text document called DbAnalyst This text document contains the records of the eudemon ranks and so on, actually all the ranks. what could be the problem? on my test server i am using excactly the same BD(my serverver DB) the same mysql 4.0.21 and the same server files...only that on the test server im on 127.0.0.1/localhost ip and on my host it's using a different ip. please help me out.

RevolutionEO · 12/03/2009, 15:15

*bumb*

Sorry to spam but i've fixed it...

sandolkakos · 12/03/2009, 15:27

When you fix a problem that you asked for help, do not go back just to say that set.

but also tell how you have fixed, because your doubt probably will be the doubt of another people in the future. ^^

RevolutionEO · 12/03/2009, 22:39

this is just my mistake this post

RevolutionEO · 12/03/2009, 22:39

Ok, so i got this problem here... some of the DB tables couldnn't be created in this file called DbAnalysis the only tables that are being created are here:

this is my one that isn't working properly

Code:

================================================================================
=== JehadNpcServer beta V1.3388 - (Feb  1 2008 16:44:31)
=== Start server time is 2009-12-03 21:25:30
================================================================================
=== Current time is 2009-12-03 21:28:16
=== Server takes 0 days  00:02:46
================================================================================



start ==========================
[cq_user] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_rule] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:1 update:0 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0
[cq_fact] select:1 update:0 delete:0 insert:0

start ==========================
[cq_user] select:8 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

and this is the one that works.

Code:

================================================================================
=== Jehad Server Stable V2.3721 C2.193  - EPVP (Jul  6 2008 16:09:53)
=== Start server time is 2009-12-01 19:13:43
================================================================================
=== Current time is 2009-12-01 19:20:10
=== Server takes 0 days  00:06:27
================================================================================



start ==========================
[cq_user] select:1 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

start ==========================
[cq_goods] select:413 update:0 delete:0 insert:0
[cq_dynanpc] select:3 update:0 delete:0 insert:0
[cq_levexp] select:1 update:0 delete:0 insert:0
[cq_advert_queue] select:1 update:0 delete:0 insert:0
[cq_card2] select:1 update:0 delete:0 insert:0
[cq_shortcut_key] select:1 update:1 delete:0 insert:0
[cq_traptype] select:1 update:0 delete:0 insert:0
[cq_itemaddition] select:1 update:0 delete:0 insert:0
[cq_grade] select:1 update:0 delete:0 insert:0
[cq_eudemon_prize_list] select:1 update:0 delete:0 insert:0
[cq_user] select:5 update:15 delete:0 insert:0
[cq_deluser] select:3 update:0 delete:0 insert:0
[cq_npc] select:3 update:0 delete:0 insert:0
[cq_eudemon_pk_type] select:1 update:0 delete:0 insert:0
[cq_business] select:1 update:0 delete:0 insert:0
[cq_suspicion_event] select:1 update:1 delete:0 insert:0
[cq_controlcenter] select:1 update:0 delete:0 insert:0
[cq_ip_address] select:1 update:0 delete:0 insert:0
[cq_totem_pole_type] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_type] select:1 update:0 delete:0 insert:0
[cq_pet] select:1 update:0 delete:0 insert:0
[cq_trade] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_sys_shop_price] select:1 update:0 delete:0 insert:0
[cq_trap] select:1 update:0 delete:0 insert:0
[cq_npc_income] select:238 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_gm_checkpunish] select:1 update:0 delete:0 insert:0
[cq_tutor_type] select:1 update:0 delete:0 insert:0
[cq_disdain] select:1 update:0 delete:0 insert:0
[cq_punish_status] select:1 update:0 delete:0 insert:0
[cq_eudemon_trainskill_dmg_type] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_talenttype] select:1 update:0 delete:0 insert:0
[cq_eudemon] select:66 update:66 delete:0 insert:10
[cq_castleitem] select:1 update:0 delete:0 insert:0
[cq_family_attr] select:76 update:0 delete:0 insert:0
[cq_family] select:2 update:0 delete:0 insert:0
[cq_synattr] select:113 update:0 delete:0 insert:0
[cq_card] select:1 update:0 delete:0 insert:0
[cq_donation_dynasort_rec] select:1 update:0 delete:0 insert:0
[cq_lifeskilltype] select:1 update:0 delete:0 insert:0
[cq_wanted] select:2 update:0 delete:0 insert:0
[cq_magic] select:55 update:0 delete:0 insert:40
[cq_item] select:5 update:24 delete:0 insert:0
[cq_action] select:1 update:0 delete:0 insert:0
[cq_castle_lev_req] select:1 update:0 delete:0 insert:0
[cq_task] select:1 update:0 delete:0 insert:0
[cq_auction] select:1 update:0 delete:0 insert:0
[cq_totem_add] select:56 update:0 delete:0 insert:0
[cq_eudemon_rbn_rqr] select:1 update:0 delete:0 insert:0
[cq_official_type] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_lottery] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:2 update:17 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:2 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_rebirth] select:1 update:0 delete:0 insert:0
[drop_rule] select:1 update:0 delete:0 insert:0
[cq_soul_value_lev] select:1 update:0 delete:0 insert:0
[cq_dropitemrule] select:321 update:0 delete:0 insert:0
[cq_sys_bank] select:1 update:0 delete:0 insert:0
[cq_collect_rule] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_rec] select:2270 update:0 delete:0 insert:166
[cq_eudemon_auxrbn_rqr] select:1 update:0 delete:0 insert:0
[cq_ad_queue] select:1 update:0 delete:0 insert:0
[cq_battle_limit_type] select:1 update:0 delete:0 insert:0
[cq_bonus_points_type] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_student_type] select:1 update:0 delete:0 insert:0
[cq_talentgain] select:1 update:0 delete:0 insert:0
[cq_map] select:4 update:2 delete:0 insert:0
[cq_passway] select:1 update:0 delete:0 insert:0
[cq_sys_leaveword] select:1 update:0 delete:0 insert:0
[cq_leaveword] select:8 update:0 delete:0 insert:0
[cq_tutor_contributions] select:1 update:0 delete:0 insert:0
[cq_skill] select:0 update:10 delete:0 insert:0
[cq_suspicion_punish] select:1 update:0 delete:0 insert:0
[cq_tutorexp] select:1 update:0 delete:0 insert:0
[cq_eudemon_exchg_egg] select:1 update:0 delete:0 insert:0
[cq_item_value_type] select:1 update:0 delete:0 insert:0
[cq_region] select:404 update:0 delete:0 insert:0
[cq_building] select:1 update:0 delete:0 insert:0
[cq_counter] select:1 update:0 delete:0 insert:0
[cq_ip_log] select:1 update:1 delete:0 insert:0
[cq_calendar] select:1 update:0 delete:0 insert:0
[cq_punish_type] select:1 update:0 delete:0 insert:0
[cq_trade_auto_finish_type] select:1 update:0 delete:0 insert:0
[cq_buildingtype] select:1 update:0 delete:0 insert:0
[cq_quiz] select:1 update:0 delete:0 insert:0
[cq_portal] select:1 update:0 delete:0 insert:0
[cq_mercenary_task] select:1 update:0 delete:0 insert:0
[cq_partner] select:1 update:0 delete:0 insert:0
[cq_vardata] select:1 update:0 delete:0 insert:0
[cq_castle] select:2 update:0 delete:0 insert:0
[cq_point_allot] select:1 update:0 delete:0 insert:0
[cq_pk_item] select:1 update:0 delete:0 insert:0
[cq_pk_bonus] select:1 update:0 delete:0 insert:0
[cq_control] select:1 update:0 delete:0 insert:0
[cq_dup_name] select:1 update:0 delete:0 insert:0
[cq_eudemon_rbn_type] select:1 update:0 delete:0 insert:0
[cq_weapon_skill] select:1 update:0 delete:0 insert:0

start ==========================

start ==========================
[cq_user] select:1 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

start ==========================
[cq_goods] select:413 update:0 delete:0 insert:0
[cq_dynanpc] select:3 update:1 delete:0 insert:0
[cq_levexp] select:1 update:0 delete:0 insert:0
[cq_advert_queue] select:1 update:0 delete:0 insert:0
[cq_card2] select:1 update:0 delete:0 insert:0
[cq_shortcut_key] select:1 update:1 delete:0 insert:0
[cq_traptype] select:1 update:0 delete:0 insert:0
[cq_itemaddition] select:1 update:0 delete:0 insert:0
[cq_grade] select:1 update:0 delete:0 insert:0
[cq_eudemon_prize_list] select:1 update:0 delete:0 insert:0
[cq_user] select:5 update:28 delete:0 insert:0
[cq_deluser] select:3 update:0 delete:0 insert:0
[cq_npc] select:3 update:1 delete:0 insert:0
[cq_eudemon_pk_type] select:1 update:0 delete:0 insert:0
[cq_business] select:1 update:0 delete:0 insert:0
[cq_suspicion_event] select:1 update:1 delete:0 insert:0
[cq_controlcenter] select:1 update:0 delete:0 insert:0
[cq_ip_address] select:1 update:0 delete:0 insert:0
[cq_totem_pole_type] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_type] select:1 update:0 delete:0 insert:0
[cq_pet] select:1 update:0 delete:0 insert:0
[cq_trade] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_sys_shop_price] select:1 update:0 delete:0 insert:0
[cq_trap] select:1 update:0 delete:0 insert:0
[cq_npc_income] select:238 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_gm_checkpunish] select:1 update:0 delete:0 insert:0
[cq_tutor_type] select:1 update:0 delete:0 insert:0
[cq_disdain] select:1 update:0 delete:0 insert:0
[cq_punish_status] select:1 update:0 delete:0 insert:0
[cq_eudemon_trainskill_dmg_type] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_talenttype] select:1 update:0 delete:0 insert:0
[cq_eudemon] select:67 update:561 delete:108 insert:119
[cq_castleitem] select:1 update:0 delete:0 insert:0
[cq_family_attr] select:76 update:0 delete:0 insert:0
[cq_family] select:2 update:0 delete:0 insert:0
[cq_synattr] select:113 update:0 delete:0 insert:0
[cq_card] select:1 update:0 delete:0 insert:0
[cq_donation_dynasort_rec] select:1 update:0 delete:0 insert:0
[cq_lifeskilltype] select:1 update:0 delete:0 insert:0
[cq_wanted] select:2 update:0 delete:0 insert:0
[cq_magic] select:158 update:0 delete:0 insert:72
[cq_item] select:5 update:48 delete:0 insert:0
[cq_action] select:1 update:0 delete:0 insert:0
[cq_castle_lev_req] select:1 update:0 delete:0 insert:0
[cq_task] select:1 update:0 delete:0 insert:0
[cq_auction] select:1 update:0 delete:0 insert:0
[cq_totem_add] select:56 update:0 delete:0 insert:0
[cq_eudemon_rbn_rqr] select:1 update:0 delete:0 insert:0
[cq_official_type] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_lottery] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:2 update:0 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:2 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_rebirth] select:1 update:0 delete:0 insert:0
[drop_rule] select:1 update:0 delete:0 insert:0
[cq_soul_value_lev] select:1 update:0 delete:0 insert:0
[cq_dropitemrule] select:321 update:0 delete:0 insert:0
[cq_sys_bank] select:1 update:0 delete:0 insert:0
[cq_collect_rule] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_rec] select:2270 update:151 delete:0 insert:270
[cq_eudemon_auxrbn_rqr] select:1 update:0 delete:0 insert:0
[cq_ad_queue] select:1 update:0 delete:0 insert:0
[cq_battle_limit_type] select:1 update:0 delete:0 insert:0
[cq_bonus_points_type] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_student_type] select:1 update:0 delete:0 insert:0
[cq_talentgain] select:1 update:0 delete:0 insert:0
[cq_map] select:4 update:2 delete:0 insert:0
[cq_passway] select:1 update:0 delete:0 insert:0
[cq_sys_leaveword] select:1 update:0 delete:0 insert:0
[cq_leaveword] select:54 update:0 delete:0 insert:0
[cq_tutor_contributions] select:1 update:0 delete:0 insert:0
[cq_skill] select:0 update:17 delete:0 insert:0
[cq_suspicion_punish] select:1 update:0 delete:0 insert:0
[cq_tutorexp] select:1 update:0 delete:0 insert:0
[cq_eudemon_exchg_egg] select:1 update:0 delete:0 insert:0
[cq_item_value_type] select:1 update:0 delete:0 insert:0
[cq_region] select:404 update:0 delete:0 insert:0
[cq_building] select:1 update:0 delete:0 insert:0
[cq_counter] select:1 update:0 delete:0 insert:0
[cq_ip_log] select:1 update:1 delete:0 insert:0
[cq_calendar] select:1 update:0 delete:0 insert:0
[cq_punish_type] select:1 update:0 delete:0 insert:0
[cq_trade_auto_finish_type] select:1 update:0 delete:0 insert:0
[cq_buildingtype] select:1 update:0 delete:0 insert:0
[cq_quiz] select:1 update:0 delete:0 insert:0
[cq_portal] select:1 update:0 delete:0 insert:0
[cq_mercenary_task] select:1 update:0 delete:0 insert:0
[cq_partner] select:1 update:0 delete:0 insert:0
[cq_vardata] select:1 update:0 delete:0 insert:0
[cq_castle] select:2 update:0 delete:0 insert:0
[cq_point_allot] select:1 update:0 delete:0 insert:0
[cq_pk_item] select:1 update:0 delete:0 insert:0
[cq_pk_bonus] select:1 update:0 delete:0 insert:0
[cq_control] select:1 update:0 delete:0 insert:0
[cq_dup_name] select:1 update:0 delete:0 insert:0
[cq_eudemon_rbn_type] select:1 update:0 delete:0 insert:0
[cq_weapon_skill] select:1 update:0 delete:0 insert:0

start ==========================

start ==========================
[cq_user] select:2 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

start ==========================
[cq_goods] select:413 update:0 delete:0 insert:0
[cq_dynanpc] select:3 update:0 delete:0 insert:0
[cq_levexp] select:1 update:0 delete:0 insert:0
[cq_advert_queue] select:1 update:0 delete:0 insert:0
[cq_card2] select:2 update:0 delete:0 insert:0
[cq_shortcut_key] select:2 update:2 delete:0 insert:0
[cq_traptype] select:1 update:0 delete:0 insert:0
[cq_itemaddition] select:1 update:0 delete:0 insert:0
[cq_grade] select:1 update:0 delete:0 insert:0
[cq_eudemon_prize_list] select:1 update:0 delete:0 insert:0
[cq_user] select:5 update:31 delete:0 insert:0
[cq_deluser] select:4 update:0 delete:0 insert:0
[cq_npc] select:3 update:0 delete:0 insert:0
[cq_eudemon_pk_type] select:1 update:0 delete:0 insert:0
[cq_business] select:1 update:0 delete:0 insert:0
[cq_suspicion_event] select:2 update:2 delete:0 insert:0
[cq_controlcenter] select:2 update:0 delete:0 insert:0
[cq_ip_address] select:1 update:0 delete:0 insert:0
[cq_totem_pole_type] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_type] select:1 update:0 delete:0 insert:0
[cq_pet] select:1 update:0 delete:0 insert:0
[cq_trade] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_sys_shop_price] select:1 update:0 delete:0 insert:0
[cq_trap] select:1 update:0 delete:0 insert:0
[cq_npc_income] select:238 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_gm_checkpunish] select:1 update:0 delete:0 insert:0
[cq_tutor_type] select:1 update:0 delete:0 insert:0
[cq_disdain] select:1 update:0 delete:0 insert:0
[cq_punish_status] select:2 update:0 delete:0 insert:0
[cq_eudemon_trainskill_dmg_type] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_talenttype] select:1 update:0 delete:0 insert:0
[cq_eudemon] select:82 update:104 delete:0 insert:12
[cq_castleitem] select:2 update:0 delete:0 insert:0
[cq_family_attr] select:77 update:0 delete:0 insert:0
[cq_family] select:2 update:0 delete:0 insert:0
[cq_synattr] select:113 update:2 delete:0 insert:0
[cq_card] select:2 update:0 delete:0 insert:0
[cq_donation_dynasort_rec] select:1 update:0 delete:0 insert:0
[cq_tutor_contributions2] select:18 update:0 delete:0 insert:0
[cq_lifeskilltype] select:1 update:0 delete:0 insert:0
[cq_wanted] select:2 update:0 delete:0 insert:0
[cq_magic] select:96 update:0 delete:0 insert:76
[cq_item] select:6 update:0 delete:0 insert:0
[cq_action] select:1 update:0 delete:0 insert:0
[cq_castle_lev_req] select:1 update:0 delete:0 insert:0
[cq_task] select:1 update:0 delete:0 insert:0
[cq_auction] select:1 update:0 delete:0 insert:0
[cq_totem_add] select:56 update:0 delete:0 insert:0
[cq_eudemon_rbn_rqr] select:1 update:0 delete:0 insert:0
[cq_official_type] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_lottery] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:2 update:1 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:2 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_rebirth] select:1 update:0 delete:0 insert:0
[drop_rule] select:1 update:0 delete:0 insert:0
[cq_soul_value_lev] select:1 update:0 delete:0 insert:0
[cq_dropitemrule] select:321 update:0 delete:0 insert:0
[cq_sys_bank] select:1 update:0 delete:0 insert:0
[cq_collect_rule] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_rec] select:2270 update:0 delete:0 insert:449
[cq_eudemon_auxrbn_rqr] select:1 update:0 delete:0 insert:0
[cq_ad_queue] select:1 update:0 delete:0 insert:0
[cq_battle_limit_type] select:1 update:0 delete:0 insert:0
[cq_bonus_points_type] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_student_type] select:1 update:0 delete:0 insert:0
[cq_talentgain] select:1 update:0 delete:0 insert:0
[cq_map] select:4 update:2 delete:0 insert:0
[cq_passway] select:1 update:0 delete:0 insert:0
[cq_sys_leaveword] select:2 update:0 delete:0 insert:0
[cq_leaveword] select:19 update:0 delete:0 insert:0
[cq_tutor_contributions] select:4 update:0 delete:0 insert:0
[cq_skill] select:1 update:18 delete:0 insert:1
[cq_suspicion_punish] select:1 update:0 delete:0 insert:0
[cq_tutorexp] select:4 update:0 delete:0 insert:0
[cq_eudemon_exchg_egg] select:1 update:0 delete:0 insert:0
[cq_item_value_type] select:1 update:0 delete:0 insert:0
[cq_region] select:404 update:0 delete:0 insert:0
[cq_building] select:2 update:0 delete:0 insert:0
[cq_counter] select:1 update:0 delete:0 insert:0
[cq_ip_log] select:2 update:2 delete:0 insert:0
[cq_calendar] select:1 update:0 delete:0 insert:0
[cq_punish_type] select:1 update:0 delete:0 insert:0
[cq_trade_auto_finish_type] select:1 update:0 delete:0 insert:0
[cq_buildingtype] select:1 update:0 delete:0 insert:0
[cq_quiz] select:1 update:0 delete:0 insert:0
[cq_portal] select:1 update:0 delete:0 insert:0
[cq_tutor] select:4 update:0 delete:0 insert:0
[cq_mercenary_task] select:1 update:0 delete:0 insert:0
[cq_partner] select:2 update:0 delete:0 insert:0
[cq_vardata] select:1 update:0 delete:0 insert:0
[cq_castle] select:3 update:0 delete:0 insert:0
[cq_point_allot] select:1 update:0 delete:0 insert:0
[cq_pk_item] select:1 update:0 delete:0 insert:0
[cq_pk_bonus] select:1 update:0 delete:0 insert:0
[cq_control] select:1 update:0 delete:0 insert:0
[cq_dup_name] select:1 update:0 delete:0 insert:0
[cq_eudemon_rbn_type] select:1 update:0 delete:0 insert:0
[cq_weapon_skill] select:1 update:0 delete:0 insert:0

================================================================================
=== Jehad Server Stable V2.3721 C2.193  - EPVP (Jul  6 2008 16:09:53)
=== Start server time is 2009-12-01 19:13:43
================================================================================
=== Current time is 2009-12-01 19:20:10
=== Server takes 0 days  00:06:27
================================================================================



start ==========================
[cq_user] select:1 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

start ==========================
[cq_goods] select:413 update:0 delete:0 insert:0
[cq_dynanpc] select:3 update:0 delete:0 insert:0
[cq_levexp] select:1 update:0 delete:0 insert:0
[cq_advert_queue] select:1 update:0 delete:0 insert:0
[cq_card2] select:1 update:0 delete:0 insert:0
[cq_shortcut_key] select:1 update:1 delete:0 insert:0
[cq_traptype] select:1 update:0 delete:0 insert:0
[cq_itemaddition] select:1 update:0 delete:0 insert:0
[cq_grade] select:1 update:0 delete:0 insert:0
[cq_eudemon_prize_list] select:1 update:0 delete:0 insert:0
[cq_user] select:5 update:15 delete:0 insert:0
[cq_deluser] select:3 update:0 delete:0 insert:0
[cq_npc] select:3 update:0 delete:0 insert:0
[cq_eudemon_pk_type] select:1 update:0 delete:0 insert:0
[cq_business] select:1 update:0 delete:0 insert:0
[cq_suspicion_event] select:1 update:1 delete:0 insert:0
[cq_controlcenter] select:1 update:0 delete:0 insert:0
[cq_ip_address] select:1 update:0 delete:0 insert:0
[cq_totem_pole_type] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_type] select:1 update:0 delete:0 insert:0
[cq_pet] select:1 update:0 delete:0 insert:0
[cq_trade] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_sys_shop_price] select:1 update:0 delete:0 insert:0
[cq_trap] select:1 update:0 delete:0 insert:0
[cq_npc_income] select:238 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_gm_checkpunish] select:1 update:0 delete:0 insert:0
[cq_tutor_type] select:1 update:0 delete:0 insert:0
[cq_disdain] select:1 update:0 delete:0 insert:0
[cq_punish_status] select:1 update:0 delete:0 insert:0
[cq_eudemon_trainskill_dmg_type] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_talenttype] select:1 update:0 delete:0 insert:0
[cq_eudemon] select:66 update:66 delete:0 insert:10
[cq_castleitem] select:1 update:0 delete:0 insert:0
[cq_family_attr] select:76 update:0 delete:0 insert:0
[cq_family] select:2 update:0 delete:0 insert:0
[cq_synattr] select:113 update:0 delete:0 insert:0
[cq_card] select:1 update:0 delete:0 insert:0
[cq_donation_dynasort_rec] select:1 update:0 delete:0 insert:0
[cq_lifeskilltype] select:1 update:0 delete:0 insert:0
[cq_wanted] select:2 update:0 delete:0 insert:0
[cq_magic] select:55 update:0 delete:0 insert:40
[cq_item] select:5 update:24 delete:0 insert:0
[cq_action] select:1 update:0 delete:0 insert:0
[cq_castle_lev_req] select:1 update:0 delete:0 insert:0
[cq_task] select:1 update:0 delete:0 insert:0
[cq_auction] select:1 update:0 delete:0 insert:0
[cq_totem_add] select:56 update:0 delete:0 insert:0
[cq_eudemon_rbn_rqr] select:1 update:0 delete:0 insert:0
[cq_official_type] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_lottery] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:2 update:17 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:2 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_rebirth] select:1 update:0 delete:0 insert:0
[drop_rule] select:1 update:0 delete:0 insert:0
[cq_soul_value_lev] select:1 update:0 delete:0 insert:0
[cq_dropitemrule] select:321 update:0 delete:0 insert:0
[cq_sys_bank] select:1 update:0 delete:0 insert:0
[cq_collect_rule] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_rec] select:2270 update:0 delete:0 insert:166
[cq_eudemon_auxrbn_rqr] select:1 update:0 delete:0 insert:0
[cq_ad_queue] select:1 update:0 delete:0 insert:0
[cq_battle_limit_type] select:1 update:0 delete:0 insert:0
[cq_bonus_points_type] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_student_type] select:1 update:0 delete:0 insert:0
[cq_talentgain] select:1 update:0 delete:0 insert:0
[cq_map] select:4 update:2 delete:0 insert:0
[cq_passway] select:1 update:0 delete:0 insert:0
[cq_sys_leaveword] select:1 update:0 delete:0 insert:0
[cq_leaveword] select:8 update:0 delete:0 insert:0
[cq_tutor_contributions] select:1 update:0 delete:0 insert:0
[cq_skill] select:0 update:10 delete:0 insert:0
[cq_suspicion_punish] select:1 update:0 delete:0 insert:0
[cq_tutorexp] select:1 update:0 delete:0 insert:0
[cq_eudemon_exchg_egg] select:1 update:0 delete:0 insert:0
[cq_item_value_type] select:1 update:0 delete:0 insert:0
[cq_region] select:404 update:0 delete:0 insert:0
[cq_building] select:1 update:0 delete:0 insert:0
[cq_counter] select:1 update:0 delete:0 insert:0
[cq_ip_log] select:1 update:1 delete:0 insert:0
[cq_calendar] select:1 update:0 delete:0 insert:0
[cq_punish_type] select:1 update:0 delete:0 insert:0
[cq_trade_auto_finish_type] select:1 update:0 delete:0 insert:0
[cq_buildingtype] select:1 update:0 delete:0 insert:0
[cq_quiz] select:1 update:0 delete:0 insert:0
[cq_portal] select:1 update:0 delete:0 insert:0
[cq_mercenary_task] select:1 update:0 delete:0 insert:0
[cq_partner] select:1 update:0 delete:0 insert:0
[cq_vardata] select:1 update:0 delete:0 insert:0
[cq_castle] select:2 update:0 delete:0 insert:0
[cq_point_allot] select:1 update:0 delete:0 insert:0
[cq_pk_item] select:1 update:0 delete:0 insert:0
[cq_pk_bonus] select:1 update:0 delete:0 insert:0
[cq_control] select:1 update:0 delete:0 insert:0
[cq_dup_name] select:1 update:0 delete:0 insert:0
[cq_eudemon_rbn_type] select:1 update:0 delete:0 insert:0
[cq_weapon_skill] select:1 update:0 delete:0 insert:0

start ==========================

start ==========================
[cq_user] select:1 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

start ==========================
[cq_goods] select:413 update:0 delete:0 insert:0
[cq_dynanpc] select:3 update:1 delete:0 insert:0
[cq_levexp] select:1 update:0 delete:0 insert:0
[cq_advert_queue] select:1 update:0 delete:0 insert:0
[cq_card2] select:1 update:0 delete:0 insert:0
[cq_shortcut_key] select:1 update:1 delete:0 insert:0
[cq_traptype] select:1 update:0 delete:0 insert:0
[cq_itemaddition] select:1 update:0 delete:0 insert:0
[cq_grade] select:1 update:0 delete:0 insert:0
[cq_eudemon_prize_list] select:1 update:0 delete:0 insert:0
[cq_user] select:5 update:28 delete:0 insert:0
[cq_deluser] select:3 update:0 delete:0 insert:0
[cq_npc] select:3 update:1 delete:0 insert:0
[cq_eudemon_pk_type] select:1 update:0 delete:0 insert:0
[cq_business] select:1 update:0 delete:0 insert:0
[cq_suspicion_event] select:1 update:1 delete:0 insert:0
[cq_controlcenter] select:1 update:0 delete:0 insert:0
[cq_ip_address] select:1 update:0 delete:0 insert:0
[cq_totem_pole_type] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_type] select:1 update:0 delete:0 insert:0
[cq_pet] select:1 update:0 delete:0 insert:0
[cq_trade] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_sys_shop_price] select:1 update:0 delete:0 insert:0
[cq_trap] select:1 update:0 delete:0 insert:0
[cq_npc_income] select:238 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_gm_checkpunish] select:1 update:0 delete:0 insert:0
[cq_tutor_type] select:1 update:0 delete:0 insert:0
[cq_disdain] select:1 update:0 delete:0 insert:0
[cq_punish_status] select:1 update:0 delete:0 insert:0
[cq_eudemon_trainskill_dmg_type] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_talenttype] select:1 update:0 delete:0 insert:0
[cq_eudemon] select:67 update:561 delete:108 insert:119
[cq_castleitem] select:1 update:0 delete:0 insert:0
[cq_family_attr] select:76 update:0 delete:0 insert:0
[cq_family] select:2 update:0 delete:0 insert:0
[cq_synattr] select:113 update:0 delete:0 insert:0
[cq_card] select:1 update:0 delete:0 insert:0
[cq_donation_dynasort_rec] select:1 update:0 delete:0 insert:0
[cq_lifeskilltype] select:1 update:0 delete:0 insert:0
[cq_wanted] select:2 update:0 delete:0 insert:0
[cq_magic] select:158 update:0 delete:0 insert:72
[cq_item] select:5 update:48 delete:0 insert:0
[cq_action] select:1 update:0 delete:0 insert:0
[cq_castle_lev_req] select:1 update:0 delete:0 insert:0
[cq_task] select:1 update:0 delete:0 insert:0
[cq_auction] select:1 update:0 delete:0 insert:0
[cq_totem_add] select:56 update:0 delete:0 insert:0
[cq_eudemon_rbn_rqr] select:1 update:0 delete:0 insert:0
[cq_official_type] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_lottery] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:2 update:0 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:2 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_rebirth] select:1 update:0 delete:0 insert:0
[drop_rule] select:1 update:0 delete:0 insert:0
[cq_soul_value_lev] select:1 update:0 delete:0 insert:0
[cq_dropitemrule] select:321 update:0 delete:0 insert:0
[cq_sys_bank] select:1 update:0 delete:0 insert:0
[cq_collect_rule] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_rec] select:2270 update:151 delete:0 insert:270
[cq_eudemon_auxrbn_rqr] select:1 update:0 delete:0 insert:0
[cq_ad_queue] select:1 update:0 delete:0 insert:0
[cq_battle_limit_type] select:1 update:0 delete:0 insert:0
[cq_bonus_points_type] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_student_type] select:1 update:0 delete:0 insert:0
[cq_talentgain] select:1 update:0 delete:0 insert:0
[cq_map] select:4 update:2 delete:0 insert:0
[cq_passway] select:1 update:0 delete:0 insert:0
[cq_sys_leaveword] select:1 update:0 delete:0 insert:0
[cq_leaveword] select:54 update:0 delete:0 insert:0
[cq_tutor_contributions] select:1 update:0 delete:0 insert:0
[cq_skill] select:0 update:17 delete:0 insert:0
[cq_suspicion_punish] select:1 update:0 delete:0 insert:0
[cq_tutorexp] select:1 update:0 delete:0 insert:0
[cq_eudemon_exchg_egg] select:1 update:0 delete:0 insert:0
[cq_item_value_type] select:1 update:0 delete:0 insert:0
[cq_region] select:404 update:0 delete:0 insert:0
[cq_building] select:1 update:0 delete:0 insert:0
[cq_counter] select:1 update:0 delete:0 insert:0
[cq_ip_log] select:1 update:1 delete:0 insert:0
[cq_calendar] select:1 update:0 delete:0 insert:0
[cq_punish_type] select:1 update:0 delete:0 insert:0
[cq_trade_auto_finish_type] select:1 update:0 delete:0 insert:0
[cq_buildingtype] select:1 update:0 delete:0 insert:0
[cq_quiz] select:1 update:0 delete:0 insert:0
[cq_portal] select:1 update:0 delete:0 insert:0
[cq_mercenary_task] select:1 update:0 delete:0 insert:0
[cq_partner] select:1 update:0 delete:0 insert:0
[cq_vardata] select:1 update:0 delete:0 insert:0
[cq_castle] select:2 update:0 delete:0 insert:0
[cq_point_allot] select:1 update:0 delete:0 insert:0
[cq_pk_item] select:1 update:0 delete:0 insert:0
[cq_pk_bonus] select:1 update:0 delete:0 insert:0
[cq_control] select:1 update:0 delete:0 insert:0
[cq_dup_name] select:1 update:0 delete:0 insert:0
[cq_eudemon_rbn_type] select:1 update:0 delete:0 insert:0
[cq_weapon_skill] select:1 update:0 delete:0 insert:0

start ==========================

start ==========================
[cq_user] select:2 update:0 delete:0 insert:0
[cq_superman] select:1 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_map] select:1 update:0 delete:0 insert:0

start ==========================
[cq_goods] select:413 update:0 delete:0 insert:0
[cq_dynanpc] select:3 update:0 delete:0 insert:0
[cq_levexp] select:1 update:0 delete:0 insert:0
[cq_advert_queue] select:1 update:0 delete:0 insert:0
[cq_card2] select:2 update:0 delete:0 insert:0
[cq_shortcut_key] select:2 update:2 delete:0 insert:0
[cq_traptype] select:1 update:0 delete:0 insert:0
[cq_itemaddition] select:1 update:0 delete:0 insert:0
[cq_grade] select:1 update:0 delete:0 insert:0
[cq_eudemon_prize_list] select:1 update:0 delete:0 insert:0
[cq_user] select:5 update:31 delete:0 insert:0
[cq_deluser] select:4 update:0 delete:0 insert:0
[cq_npc] select:3 update:0 delete:0 insert:0
[cq_eudemon_pk_type] select:1 update:0 delete:0 insert:0
[cq_business] select:1 update:0 delete:0 insert:0
[cq_suspicion_event] select:2 update:2 delete:0 insert:0
[cq_controlcenter] select:2 update:0 delete:0 insert:0
[cq_ip_address] select:1 update:0 delete:0 insert:0
[cq_totem_pole_type] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_type] select:1 update:0 delete:0 insert:0
[cq_pet] select:1 update:0 delete:0 insert:0
[cq_trade] select:1 update:0 delete:0 insert:0
[cq_track] select:1 update:0 delete:0 insert:0
[cq_sys_shop_price] select:1 update:0 delete:0 insert:0
[cq_trap] select:1 update:0 delete:0 insert:0
[cq_npc_income] select:238 update:0 delete:0 insert:0
[cq_config] select:1 update:0 delete:0 insert:0
[cq_gm_checkpunish] select:1 update:0 delete:0 insert:0
[cq_tutor_type] select:1 update:0 delete:0 insert:0
[cq_disdain] select:1 update:0 delete:0 insert:0
[cq_punish_status] select:2 update:0 delete:0 insert:0
[cq_eudemon_trainskill_dmg_type] select:1 update:0 delete:0 insert:0
[cq_itemtype] select:1 update:0 delete:0 insert:0
[cq_talenttype] select:1 update:0 delete:0 insert:0
[cq_eudemon] select:82 update:104 delete:0 insert:12
[cq_castleitem] select:2 update:0 delete:0 insert:0
[cq_family_attr] select:77 update:0 delete:0 insert:0
[cq_family] select:2 update:0 delete:0 insert:0
[cq_synattr] select:113 update:2 delete:0 insert:0
[cq_card] select:2 update:0 delete:0 insert:0
[cq_donation_dynasort_rec] select:1 update:0 delete:0 insert:0
[cq_tutor_contributions2] select:18 update:0 delete:0 insert:0
[cq_lifeskilltype] select:1 update:0 delete:0 insert:0
[cq_wanted] select:2 update:0 delete:0 insert:0
[cq_magic] select:96 update:0 delete:0 insert:76
[cq_item] select:6 update:0 delete:0 insert:0
[cq_action] select:1 update:0 delete:0 insert:0
[cq_castle_lev_req] select:1 update:0 delete:0 insert:0
[cq_task] select:1 update:0 delete:0 insert:0
[cq_auction] select:1 update:0 delete:0 insert:0
[cq_totem_add] select:56 update:0 delete:0 insert:0
[cq_eudemon_rbn_rqr] select:1 update:0 delete:0 insert:0
[cq_official_type] select:1 update:0 delete:0 insert:0
[cq_monstertype] select:1 update:0 delete:0 insert:0
[cq_lottery] select:1 update:0 delete:0 insert:0
[cq_syndicate] select:2 update:1 delete:0 insert:0
[cq_generator] select:1 update:0 delete:0 insert:0
[cq_magictype] select:2 update:0 delete:0 insert:0
[cq_dynamap] select:1 update:0 delete:0 insert:0
[cq_rebirth] select:1 update:0 delete:0 insert:0
[drop_rule] select:1 update:0 delete:0 insert:0
[cq_soul_value_lev] select:1 update:0 delete:0 insert:0
[cq_dropitemrule] select:321 update:0 delete:0 insert:0
[cq_sys_bank] select:1 update:0 delete:0 insert:0
[cq_collect_rule] select:1 update:0 delete:0 insert:0
[cq_dyna_rank_rec] select:2270 update:0 delete:0 insert:449
[cq_eudemon_auxrbn_rqr] select:1 update:0 delete:0 insert:0
[cq_ad_queue] select:1 update:0 delete:0 insert:0
[cq_battle_limit_type] select:1 update:0 delete:0 insert:0
[cq_bonus_points_type] select:1 update:0 delete:0 insert:0
[cq_unlawful_name] select:1 update:0 delete:0 insert:0
[cq_student_type] select:1 update:0 delete:0 insert:0
[cq_talentgain] select:1 update:0 delete:0 insert:0
[cq_map] select:4 update:2 delete:0 insert:0
[cq_passway] select:1 update:0 delete:0 insert:0
[cq_sys_leaveword] select:2 update:0 delete:0 insert:0
[cq_leaveword] select:19 update:0 delete:0 insert:0
[cq_tutor_contributions] select:4 update:0 delete:0 insert:0
[cq_skill] select:1 update:18 delete:0 insert:1
[cq_suspicion_punish] select:1 update:0 delete:0 insert:0
[cq_tutorexp] select:4 update:0 delete:0 insert:0
[cq_eudemon_exchg_egg] select:1 update:0 delete:0 insert:0
[cq_item_value_type] select:1 update:0 delete:0 insert:0
[cq_region] select:404 update:0 delete:0 insert:0
[cq_building] select:2 update:0 delete:0 insert:0
[cq_counter] select:1 update:0 delete:0 insert:0
[cq_ip_log] select:2 update:2 delete:0 insert:0
[cq_calendar] select:1 update:0 delete:0 insert:0
[cq_punish_type] select:1 update:0 delete:0 insert:0
[cq_trade_auto_finish_type] select:1 update:0 delete:0 insert:0
[cq_buildingtype] select:1 update:0 delete:0 insert:0
[cq_quiz] select:1 update:0 delete:0 insert:0
[cq_portal] select:1 update:0 delete:0 insert:0
[cq_tutor] select:4 update:0 delete:0 insert:0
[cq_mercenary_task] select:1 update:0 delete:0 insert:0
[cq_partner] select:2 update:0 delete:0 insert:0
[cq_vardata] select:1 update:0 delete:0 insert:0
[cq_castle] select:3 update:0 delete:0 insert:0
[cq_point_allot] select:1 update:0 delete:0 insert:0
[cq_pk_item] select:1 update:0 delete:0 insert:0
[cq_pk_bonus] select:1 update:0 delete:0 insert:0
[cq_control] select:1 update:0 delete:0 insert:0
[cq_dup_name] select:1 update:0 delete:0 insert:0
[cq_eudemon_rbn_type] select:1 update:0 delete:0 insert:0
[cq_weapon_skill] select:1 update:0 delete:0 insert:0

start ==========================

so you see the big difference here.

so if you have any idea what is wrong please let me know

RevolutionEO · 12/03/2009, 23:07

or maybe im closing my server in the wrong way for maintenance because always i do the /kickoutall then i close the npc server that takes about 5 minutes then i close the msg server and when ever it gets to the end of closing msg an error pops up saying don't send/close program.

sandolkakos · 12/03/2009, 23:20

i just send BroadCast Mensage speaking that the Server will enter in Maintenance, and:

Close NPC Server (in 3 seconds closed)
Close MSG Server (variable: 2 at 6 minutes)
Close ACC Server (close in real time)

@edit
Sorry, i correct the name of MSG Server ^^

RevolutionEO · 12/04/2009, 00:13

i'm not with you there...you see im doing that first i close my NPC server which takes about 5 minutes, because when i click the close button it starts creating thernal threads or something like that when it's done and NPc server closed i click to close the MSG server that should take about 5 min...but when i click close msg server it works fine but when it gets to the bit where it says msg server closing after 3 seconds an error pops us saying this program has a problem closing and asks to don't server/close program. then i close the acc server. so i guess the big problem that the cript is getting unfinished is because that error pops up but why would it pop up? anyone knows?

It's really annoying when you logg in after maintenance and your pets are rank 1 when they are not supposed to be rank 1...just because the euds don't get stored into cq_dyna_rank_rec... it works 100% on my test server tho.

funhacker · 12/04/2009, 01:40

Quote:

Originally Posted by RevolutionEO

i'm not with you there...you see im doing that first i close my NPC server which takes about 5 minutes, because when i click the close button it starts creating thernal threads or something like that when it's done and NPc server closed i click to close the MSG server that should take about 5 min...but when i click close msg server it works fine but when it gets to the bit where it says msg server closing after 3 seconds an error pops us saying this program has a problem closing and asks to don't server/close program. then i close the acc server. so i guess the big problem that the cript is getting unfinished is because that error pops up but why would it pop up? anyone knows?

It's really annoying when you logg in after maintenance and your pets are rank 1 when they are not supposed to be rank 1...just because the euds don't get stored into cq_dyna_rank_rec... it works 100% on my test server tho.

Feel free to forcebly close the NPC server. As it does not write any data to your MySQL database so it will not damage it.

RevolutionEO · 12/04/2009, 01:44

so what you're saying funhacker is that i can just click the no use button on the NPC server window? that will just close the NPC server immediatly. I've have changed my Mysql chnaged it with the one that the msg works with and tomorrow when i'll do a maintenance i will see if it works as it supposed to work. i hope it does, coz today i've copied the server files the data folder from mysql folder in and paste in into my localhost mysql and it worked fine it created the full file without giving out the msg error message at the end so im using this mysql now.

funhacker · 12/04/2009, 08:25

Yes you can use the No Use button.

Personaly closing order I would do is the following.

Soft Close (Account Server) -> (Wait until closed) -> Kickoutall msg.exe -> wait until writing is finished -> soft close msg.exe -> (Wait until closed) -> Hard/Forced close of NPC.exe

The reason for this is Account server being closed first will prevent others logging in (kickoutall does the same) whilst server is going down. Then kicking all people out stops the connection from people and stop them from doing new tasks. Then waiting until the writing thread has finished will ensure all database writing will be done (preventing database corruption). Then finally NPC can be forced closed as it's only function is to read cq_gen and cq_monster arrays (not tables) from msg.exe then run the monster's AI. Which it then does also send information back to msg about coords and attacking actions etc. Which is why it's best to close last as to prevent any missleading data being sent to the msg.exe in closing of NPC.exe

RevolutionEO · 12/04/2009, 13:06

well to be honest i was doing all that in the wrong order, first /kickoutall --->soft close NPC.exe -----> soft close MSG.exe ----> soft close ACC.exe so that makes it the other way arround... Between can i type im the MSG.exe kickoutall and will it work as i wrote in game?

funhacker · 12/04/2009, 14:25

Quote:

Originally Posted by RevolutionEO

well to be honest i was doing all that in the wrong order, first /kickoutall --->soft close NPC.exe -----> soft close MSG.exe ----> soft close ACC.exe so that makes it the other way arround... Between can i type im the MSG.exe kickoutall and will it work as i wrote in game?

Yes it works both ways, with just 1 difference.

Kickoutall in game will kick out ALL players (except the GM/PM that executed the command) and closing the server not allowing any more connections

Where as the server sided command will kick every single player also not allowing any more connections.

RevolutionEO · 12/04/2009, 15:48

yes i've tested the kickoutall and /kickoutall on my test server and i see what it does, it kicks out everyone out even me when i kickoutall on MSG.exe ...well thank you very much for the help, its appreciated.

RevolutionEO · 12/04/2009, 19:41

Ok so i closed the server in the order you told me...the ACC server takes about 1 second to close...then i try to type kickoutall in msg.exe but it wont let me as the msg keep saying conneting to account server...and then i tried to do the kickoutall first then close acc server and then close the msg server but i still get the error at the end asking to close the program...

Then i only turned on the acc and msg servers and let only like 5-10 people online nd the kickoutall and that sometimes work coz i done it 3 times and only twice the eudemons data been recorded out of 2259...any other way so everything goes smoothly without any errors?