konstantin91

i done all i need, made gm account..... Now i am interested how to start fixing... For example on server 1.12.1 where i play (live) Snarler when tamed dont have +100 resistance on all, Lupos dont progress (dont leveling up) and do not do shadow dmg as physical dmg, and that is his special ability ??? I had idea to find them in DB (and i dont know where are they in DB) and to setup they stats, but maybe ill need some scripting to fix this buggs i wrote above ??? Btw i am familiar with SQL, i studied it on college, but i wasnt working on it for some time so i forgot some things but ill start learning again........

yep, its working i can confrim too... Btw i made accout and in SQLyog under zp_realm > account i assigned to my account gm level 3, and when i use that account to enter game and make new char is that gm char or just normal player ???

I think problem can be mysql_info, cause that file is used for access to database... Maybe its configured bad, ill just post pic of it, maybe someone else have some idea what can be problem that i cant enter game when i create my acc.......

i checked realmd and mangos.conf and evertyhing seems ok but i found some errors in servr log from step 8, but errors showed in tutorial and in my server log doesnt mach... Ill copy all errors... 2012-07-29 11:12:32 ERROR:Table `creature_template` have creature (Entry: 14764) with equipment_id 4192 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment. 2012-07-29 11:12:32 ERROR:Table `creature_template` have creature (Entry: 14765) with equipment_id 4192 not found in table `creature_equip_template` or `creature_equip_template_raw`, set to no equipment. 2012-07-29 11:12:32 ERROR:Creature (Entry: 15349) has nonexistent modelid_1 (17192), can crash client 2012-07-29 11:12:32 ERROR:Creature (Entry: 15349) are using modelid_1 (0), but creature_model_info are missing for this model. 2012-07-29 11:12:32 ERROR:Creature (Entry: 15349) has nonexistent modelid in modelid_1/modelid_2 2012-07-29 11:12:32 ERROR:Creature (Entry: 15711) has nonexistent modelid_1 (15676), can crash client 2012-07-29 11:12:32 ERROR:Creature (Entry: 15711) are using modelid_1 (0), but creature_model_info are missing for this model. 2012-07-29 11:12:32 ERROR:Creature (Entry: 15711) has nonexistent modelid in modelid_1/modelid_2 2012-07-29 11:12:32 ERROR:Creature (Entry: 16963) has nonexistent modelid_1 (17312), can crash client 2012-07-29 11:12:32 ERROR:Creature (Entry: 16963) are using modelid_1 (0), but creature_model_info are missing for this model. 2012-07-29 11:12:32 ERROR:Creature (Entry: 16963) has nonexistent modelid in modelid_1/modelid_2 2012-07-29 11:12:41 ERROR:Table 'gameobject_loot_template' entry 8387 isn't gameobject lootid and not referenced from loot, and then useless. 2012-07-29 11:12:47 Loading BattleGround event indexes... 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150874 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150908 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150875 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150909 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150720 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150877 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150722 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150878 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150739 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150884 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150741 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150892 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150861 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150896 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150866 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150898 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150869 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150900 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150870 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150901 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150871 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150903 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150872 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150904 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150873 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 ERROR:BattleGroundEvent: creature with nonexistent guid 150905 for event: map:0, event1:50, event2:2 ("(null)") 2012-07-29 11:12:47 >> Loaded 68 script definitions 2012-07-29 11:12:48 ERROR:Table `gameobject_scripts` has not existing gameobject (GUID: 28683) as script id 2012-07-29 11:12:48 event_scripts : 2012-07-29 11:12:48 ERROR:Table `event_scripts` has invalid gameobject (GUID: 600016) in SCRIPT_COMMAND_CLOSE_DOOR for script id 9425 2012-07-29 11:12:48 ERROR:Table `event_scripts` has invalid gameobject (GUID: 600017) in SCRIPT_COMMAND_CLOSE_DOOR for script id 9426 2012-07-29 11:12:48 ERROR:Table `event_scripts` has invalid gameobject (GUID: 600015) in SCRIPT_COMMAND_CLOSE_DOOR for script id 9427 2012-07-29 11:12:48 >> Loaded 16 CreatureEventAI summon definitions 2012-07-29 11:12:48 Loading CreatureEventAI Scripts... 2012-07-29 11:12:49 ERROR:CreatureEventAI: Creature 12143 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1214301. 2012-07-29 11:12:49 ERROR:CreatureEventAI: Creature 15215 has EFLAG_REPEATABLE set. Event can never be repeatable. Removing flag for event 1521501. 2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -1144 in table `creature_ai_texts` but not used in EventAI scripts. 2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -931 in table `creature_ai_texts` but not used in EventAI scripts. 2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -930 in table `creature_ai_texts` but not used in EventAI scripts. 2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -929 in table `creature_ai_texts` but not used in EventAI scripts. 2012-07-29 11:12:49 ERROR:CreatureEventAI: Entry -928 in table `creature_ai_texts` but not used in EventAI scripts. 2012-07-29 11:12:49 2012-07-29 11:12:49 >> Loaded 13438 CreatureEventAI scripts

I created two accounts with command account create #name #pass in mangosd.exe, than i opened SQLyog and under zp_realm > account found my two accounts created successfuly. I also in realmlist.wtf typed set realmlist 127.0.0.1 and when i enter WoW and type my accounts its not working, than i saw ur update and adde to realmlist.wtf set patchlist 127.0.0.1, but problem stayed. I cant enter , it displays like i used wrong pass or username, just cant access my acc i created.... what can be problem ?

Found it, i just added it on system variables in system properties, that looks like some global file where all path needed stored :DDDD

I just dont undertsand where to add path, i understand that path is " C:\\xampp\\mysql\\bin " but i dont understand where to add it, what requires this path ???

BTW i am able to get to server with SQLyog and this is pic how it looks like, can anyone help me with this problem, is there anyway i fix it so it works (step 6) or i do that with other tool, not xampp ???

I cant belive, ill need thousand years to install this fucking server... I done evrything and on step 6 i stucked. When i neter command mysql_import i got error "Importing ./zp_characters/auction.sql into zp_characters ...[creting zp_characters] DATABSE zp-characters DOES NOT EXIST AND I FAILED TO CREATE IT, ABORTING" I done part with user and password corectly, i made new user and pass on http://127.0.0.1/security/xamppsecurity.php and i checked in xampp/security folder and it mach, so i entered that in mysql info as u said and now i got this error, pls explain me what is problem here ???