[X3 Release] Keazain`s Latest Compiles and Converted NCDB & Logon DB ready for use!

[leonardo14]

Thank you for this really nice pack now i will be able to make a server!
+REP

[badot]

OHH sh..! i was releasing new cores once again ARRGHH i cant stop this sh.. LOOL

all updated once again guys

please read treat in yellow text

:wave:I am so honored that the MASTER Keazain had answer my message i haven't tested yet the X40 i hope there will be a lot of revision after so many days of not updating. and i'm in the process again of downloading 2223 then here comes 2227.

good work!

[badot]

Where should i change the spawning of the house?

-- Start

-- Guild House

DROP TABLE IF EXISTS `houses`;
CREATE TABLE IF NOT EXISTS `houses` (
`ownerguid` int(6) unsigned NOT NULL DEFAULT '0',
`posX` float NOT NULL DEFAULT '0',
`posY` float NOT NULL DEFAULT '0',
`posZ` float NOT NULL DEFAULT '0',
`mapId` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`ownerguid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='House System structure' AUTO_INCREMENT=944 ;


INSERT INTO creature_spawns
(`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`)
VALUES
(6152980, 7733, 598, 263.153, 0.0362612, 1.23726, 3.10861, 0, 7346, 474, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

INSERT INTO creature_spawns
(`id`, `entry`, `map`, `position_x`, `position_y`, `position_z`, `orientation`, `movetype`, `displayid`, `faction`, `flags`, `bytes0`, `bytes1`, `bytes2`, `emote_state`, `npc_respawn_link`, `channel_spell`, `channel_target_sqlid`, `channel_target_sqlid_creature`, `standstate`)
VALUES
(6152981, 2456, 598, 274.185, -2.88463, 1.91083, 2.83921, 0, 1436, 814, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);

-- End


this is where it all started and after you put this in your SQLyog look for the creature_spawns id 6152980 and 6152981 under the creature_spawns table and change the x,y,z and orientation of the house also you have to copy the map id

you can also change the number in red, and instead of INSERT INTO replace it with REPLACE INTO and execute it in your SQLyog i hope it will work

[badot]

keazain can you help or somebody
I used my own custom vendor that i incorporated from the old Mangos Database i used the spawn location. I put it on the bridge before entering stormwind and the gate of orgrimmar and for the neutral i placed it at the upper location of gurubashi arena. my question is how can i change the faction or what of the vendor so that if other players try to fight during someone who is buying at the vendor will attack the attacker just like the old mangos server in neutral location like bootybay when someone hit you the guard will attack the attacker. the lower portion of the gurubashi arena specially the ring is PVP but the upper ring is neutral.

[snake eyes]

keazain can you help or somebody
I used my own custom vendor that i incorporated from the old Mangos Database i used the spawn location. I put it on the bridge before entering stormwind and the gate of orgrimmar and for the neutral i placed it at the upper location of gurubashi arena. my question is how can i change the faction or what of the vendor so that if other players try to fight during someone who is buying at the vendor will attack the attacker just like the old mangos server in neutral location like bootybay when someone hit you the guard will attack the attacker. the lower portion of the gurubashi arena specially the ring is PVP but the upper ring is neutral.

u have to change faction for ally mall 2 then if horde come they will attack
and change faction for horde mall to 1 then if an ally will try to come they will attck

[tabo89]

mangos include new ad.exe?

[kaelwow]

OHH sh..! i was releasing new cores once again ARRGHH i cant stop this sh.. LOOL

all updated once again guys

please read treat in yellow text

My man Keazain how can i donate your work its a very Nice and beautiful thing that you are doing here ill bet it cost's you some time to do all this! I want to do a Server With your Rev and DB. The server's position will be in Hungary if you don't mind This will be the most unic server here and with your help ill bet it will ROCK!!!:wave:

+Rep+Rep

If we setup the server then i will give you a full access to it just to show you how grateful we are with your work -if you care that is

Thank you Keazain Greetings from Hungary!!

[tabo89]

I need new DBC files for mangos rev 7300... there are wrong files

[marm09]

Please Keazain, when we will be able to unload X40 ARCEMU REPACK Rev.2227?
Thanks for your work.

[keeevin92]

Will the x40 pack included Bg working or still only wsg. Also the arena will the session and arena creater team work? So It doesnt mess up the server. And is there anyway to just update your new events and bugg fix? Because on my server I dont wanna screw up everything I made or can I save the things I have on my server and just update with your new stuffs?.

[Mango Jerry]

Please Keazain, when we will be able to unload X40 ARCEMU REPACK Rev.2227?
Thanks for your work.

Fix that Message.
Don't try to speed up Keazain and his Developers.

[marm09]

Fix that Message.
Don't try to speed up Keazain and his Developers.

Sorry, it was not that my intention.

[tabo89]

Keazain your mangos cores are bad. because i can't talk Guards. there is nothing and also mobs don't have spells. can you complie mangos with these?

[MARIGUANNO]

a program for but fast connection of upload speed optimize
software ?

That Emulator You recommend stable ??? arcemu aspire mangos ???

sorry not mores ingles

[MARIGUANNO]

recomiend emulator stable plss:wave: