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

[markbatt]

The Gua engine is version 24 . Here is a list of all it commands

/*--------------------------------------------*\
| GUAENGINE
| Scripted by Gastricpenguin
| Copywrite 2009
| http://www.mmowned.com/
\*--------------------------------------------*/
GuaEngine Command List

Core Functions [Do not require prefix]
RegisterUnitEvent(entry, event, "function")
RegisterGameObjectEvent(entry, event, "function")
RegisterQuestEvent(entry, event, "function")
RegisterUnitGossipEvent(entry, event, "function")
RegisterItemGossipEvent(entry, event, "function")
RegisterGOGossipEvent(entry, event, "function")
WorldMessage("string")
WideScreenMessage("string")
Query(1 or 0, field#,"string") -- 0: World DB, 1: Char DB
Execute(1 or 0, "string") -- 0: World DB, 1: Char DB
ReloadTable("string")

Unit Functions
SpawnCreature(entry, x, y, z, o, faction, duration, equip1, equip2, equip3)
EquipWeapons(item, item, item)
GetPlayersInRange() -- DEPRECATED, DO NOT USE
BuffInRangePlayers(spell)

Player Functions
GetLowGUID()
GetMoney()
CanRemoveCoinage(gold, silver, copper)
CanRemoveGold(gold)
CanRemoveSilver(silver)
RemoveCoinage(gold, silver, copper)
RemoveGold(gold)
RemoveSilver(silver)
AddCoinage(gold, silver, copper)
SendVendorList(pUnit)
Mount(model)
Dismount()
GiveXp(xp)
AddHonor(honor)
IsHorde()
IsAlliance()
IsOnQuest(quest)
TogglePvPFlag()
ToggleFFAPvPFlag()
RecalculateHonor()
SoftDisconnect()
LevelUp(# of levels)

GameObject Functions
GetName()
GetMapId()
GetCreatureNearestCoords()
GetGameObjectNearestCoords()
GetClosestPlayer()
GetZoneId()
GetItemCount()
GetSpawnX()
GetSpawnY()
GetSpawnZ()
GetSpawnO()
GetInRangePlayersCount()
GetEntry()
GetX()
GetY()
GetZ()
GetO()
GetInRangePlayers()
GetInRangeGameObjects()
GetInstanceID()
GetUInt64Value()
GetUInt32Value()
GetFloatValue()
GetGUID()
Teleport(target, entry, x, y, z)
AddItem(target, id, count)
Despawn()
IsInWorld()
IsInBack()
IsInFront()
PlaySoundToSet()
SpawnCreature(entry, x, y, z, o, faction, duration, equip1, equip2, equip3)
SpawnGameObject(entry, x, y, z, o, duration, scale)
CalcDistance()
SetOrientation()
RemoveFromWorld()
CalcRadAngle()
SetUInt32Value()
SetUInt64Value()
SetFloatValue()
ModUInt32Value()
CastSpell()
FullCastSpell()
CastSpellOnTarget()
FullCastSpellOnTarget()

[badot]

glad to hear from you i thought i am the oldest here but just what you said "for your grand children" i felt relieve.
I used this server in my Computer Shop i have 10 computers connected only by LAN we dont have an internet in our area, but i am playing WOW retail in Gundrak Server.
I have 50 players in my server alternately playing WOW thats why I am updating my server regularly. I'm still using 2278 and updating database and somestuff manually. i just downloaded a DB form AC RDB and i'm using some stuff from that DB to upgrade my DB right now. i will DL 2605 i hope it work i will post if it work on my server. thanks again
BTW I'm from the Philippines

[W@WAdict]

glad to hear from you i thought i am the oldest here but just what you said "for your grand children" i felt relieve.
I used this server in my Computer Shop i have 10 computers connected only by LAN we dont have an internet in our area, but i am playing WOW retail in Gundrak Server.
I have 50 players in my server alternately playing WOW thats why I am updating my server regularly. I'm still using 2278 and updating database and somestuff manually. i just downloaded a DB form AC RDB and i'm using some stuff from that DB to upgrade my DB right now. i will DL 2605 i hope it work i will post if it work on my server. thanks again
BTW I'm from the Philippines

I may be older than a lot of people on the emu scene, but I'm still young at heart....lol

I affectionately recall the old days in the emu scene, back when there was only one or two emu's out there, around the WDDB days, that was a real community there, hardly ever was any flaming going on, and people were eager to share what they knew. If someone left a post that seemed like a flame, they generally came back with an apology and note that they were kidding, or they did not mean it like it sounded.

Ahhh the good old days.

I'm from the USA myself.

[forgottenspirit]

Could you reup to somewhere else? Getting super slow downloads from that host.

[B14d3r11]

um yea keazain your ArcEmu Blizz Repack's World.sql didnt import any items or anything when i executed it, dont know why everything that was there was put in successfuly.

[badot]

I cant DL from the site you given and 2537 the spirit healer aint working is there any remedy to that. can you give another site where can i DL

I start hosting WOW early 2005 when the account and the password was given by the GM i think there is only 8 account and my player is over 20 so player cant play when the account is actively playing. I think the server its from UK and other one I forgot then the KOBOLD server, The Mangos i think is the best before. then the Arcemu the user friendly server.

thank you for the reply and for the help

[W@WAdict]

I cant DL from the site you given and 2537 the spirit healer aint working is there any remedy to that. can you give another site where can i DL

I start hosting WOW early 2005 when the account and the password was given by the GM i think there is only 8 account and my player is over 20 so player cant play when the account is actively playing. I think the server its from UK and other one I forgot then the KOBOLD server, The Mangos i think is the best before. then the Arcemu the user friendly server.

thank you for the reply and for the help

I do believe that on my copy of the Blizz database, I quite using Keazain's and got a pre-converted NCDB database from ArcEmu.org in their forums, and they had the spirit healers fixed, it is most likely the npcflags are wrong in the database, so it could possibly be fixed in the db you are using, if you knew what was changed in the database from arcemu.org.

I remember updating the core, and the database at the same time.

[W@WAdict]

I tried the following sql on my funserver database, with the version of ArcEmu from Keazain, and the spirit healers worked, the only thing was I lost the reincarnation button the only choice was the normal choice to go to the graveyard. It really does not matter to me though, because you can rez at the graveyard, then teleport to whereever you wanna go. I copied the values from my Blizz Database that worked.

REPLACE INTO creature_proto (entry,minlevel,maxlevel,faction,minhealth,maxhealth,mana,scale,npcflags,attackt ime,attacktype,mindamage,maxdamage,can_ranged,rangedattacktime,rangedmindamage,r angedmaxdamage,respawntime,armor,resistance1,resistance2,resistance3,resistance4 ,resistance5,resistance6,combat_reach,bounding_radius,auras,boss,money,invisibil ity_type,death_state,walk_speed,run_speed,fly_speed,extra_a9_flags,spell1,spell2 ,spell3,spell4,spell_flags,modImmunities) VALUES (6491,60,60,35,4120,4120,0,1,16384,2000,0,0,0,0,0,0,0,360000,3814,0,0,0,0,0,0,1. 5,0.5,10848,0,0,0,0,2.5,8,14,0,0,0,0,0,0,0)

Maybe this will help in some way, the reincarnation probably has some thing to do with the extra_a9_flags, but I'm not sure.

[Psionicshard]

I apologize in advance if this was asked and answered already, I tried looking through the replies, but there are a lot of pages, so I wouldn't be surprised if it was and I missed it.

I'm using the ArcEmu blizz-like server rev.2537, and there are a few things that are really confusing me.

In the "tools" folder, under "latest arcemu sql files" there are a whole ton of updates.. a lot of which will not batch into my world/logon DBs without a LOT of errors... Do I need those? What are they all for? Is there a readme somewhere I missed?

Thanks in advance for any help!

[snake eyes]

would some one explain keazain addons and what its used for and past a sql for it if its needed

[advertiser103]

these DBs are so awesome I use em all the time

[Bunster]

Can you use these Repacks such as "ULTIMATE ARCEMU by Keazain: Last Update 2009.04.11" still or are they out of date? Will they run with the latest WoW patch :P ? thx

[Meiya Stormsinger]

Awesome

[mtdewrush]

Nice and clean I love it thanks!

[skit2i2det]

I have your repack and it seems to work great but there is a problem, i cant make accounts? ;(.
When i open accounts in heidisql or navicat (both the same result) it stands like this when i gona make an new acc:
accounts does not have a primary key.
Updates to this table will be done using the following pseudo statment:
Update accounts SET ModifiedFieldsAndValues WHERE AllFieldsAndOldValues LIMIT 1.

And if i ignore that and make an account i cant start the logon-server, it stops on the startup and stands like this:
19:19 N PatchMgr: loading Patches...
19:19 N AccountMgr: Precaching accounts...

and there it stops and a popup comes up and there it stands that "logon-server has stopped working"

I have had servers before and this problem had never came up, so what is the problem and what to do?