upgrade your db and will work SQL folder is not for nothing it help with something.
Printable View
upgrade your db and will work SQL folder is not for nothing it help with something.
1694_quests.sql
spellfixes.sql
1658_playercreateinfo_intros.sql
1587_quests.sql
1576_wotlk_worldstring_table.sql these files are in but can you tell for me what to do next ???and thx for all your stuff
I get no spawns in northrend wha so ever, anyone tell me what im doing wrong ? I used the latest whydb svn check out, applied all patches I could find and yet no spawns.
you make all good but whydb don't make npcs ids to northrend. It only make trainer_spells.sql
worldmap_info.sql
playercreateinfo_spells.sql
recalls.sql
playercreateinfo_items.sql
playercreateinfo_skills.sql
playercreateinfo.sql
playercreateinfo_bars.sql
areatriggers.sql
graveyards.sql
Like you can see in link Wotlk WhyDB 246 need to wait more time maybe in 2009 is full wotlk maded
well i dont understand when i creatin charackter he is nude and there is no npcs nothing...
that's cool! thanks man!
ArcEmu1717-1753
- Fixing few Memory leaks.
- Removing few asserts from non-critical sections.
- Few crash fixes.
- Channel joining on zone change.
- Auras created by triggered spells are no longer saved.
- Arena team flag is also no longer saved.
- Paladins Consecration range corrected.
- Fixing infinite range of Prayer of Mending.
*Warrior stances seems to be ok now :)
--Alice--
*Corrections for Death Knight runic power system....(doesn't work yet)
*Corrections on SendPowerUpdate and SetPower
*Removed TakeRunicPower
*Mechano-Hog
*Death Coil (DK)
*Final fix on PvP stuff
*Fixed DeathGate
- GameObject::Despawn now also has a delay argument.
- Arathi Basin: Instant recap of a contested Flag.
- WSG: Flags now will respawn with a delay of 20secs.
- small other changes to BG related things.
* Removed deprecated creature equipment fields (3x2) from creature_proto.
- Few Paladin changes coming from KFL:
-- Judgement of Light - no healing bonus.
-- Added &Spell::SpellEffectRestoreManaPct (it wasn't in SpellEffectsHandler).
-- Paladin Judgement spells adds specific debuffs.
-- Seal of Wisdom proc.
-- Seal of Command trigger.
-- Seal of Corruption and Seal of Vengeance trigger.
-- Seal of Martyr trigger and school dmg.
-- Divine Storm range (same like consecration).
-- Sacred Shield - trigger, bonus to flash is not working.
-- Switching off Blessing of Light, Judgement of Wisdom and Light trigger(need to change it to new one).
PlaySound function for Player (PlaySoundToSet plays thing to everyone in InRangeSet and PlaySound to single player) - It may be useful f/e in http://www.wowhead.com/?quest=12593 reading
Added Gaeriyan to IsSpiritHealer to fix http://www.wowhead.com/?quest=3912 (You can speak to him when You are dead now)
Removed doubled OnAreaTrigger hook (Its already in ScriptMgr ) I will commit SSC Doors script tomorrow, so if You dont want to have SSC doors bugged, dont use it yet.
Lies, commited SSC Doors script now...
You can now Add quests to finished to player after he completes x quest (usable for reputation rings quests f/e) put it in style same to Quest x or y (divided by space: 1512 123 161)
- Lowered Chain Aggro range to 8 yard.
- Crash fixes in Item related code.
- 2 small memory leaks fixed.
- dailys are now reset on 4 am.
- casting wont get interrupted if your target is dying but you are casting on another unit
- vanish now wont stack up your invisiblity Level.
- simplified vanish code.
- immune message for targets immune due diminishing returns
- SpellEffectCreateItem is now cast able from units to player
- Alchemy discovery via creating Potions/Elixirs.
- default duration of SpellEffectEnchantItemTemporary is now 1hr.
- silence effects now will interrupt spell casting properly
- LOS checks for Aoe Spells
- small change to vanish code we dont want to cancel all spells in the area
* core will now actually start up.. guys test before you make major commits =\
--Alice--
*Barbershops now works
*Some corrections on player_bytes
--Alice--
*Some Corrections on my previous rev
*Barbershops now works perfectly :)
*Hair and Facial now can be altered (Barbershop)
--Alice--
*Fixed GameObject spawn problems.... now can be saved (.go spawn idobject 1) :)
static_casts, just in these 2 files atm, as im off soon so i will finish later :P
Fix for locked Mutex threads in Linux!
Moved the following columns to creature_spawns from creature_proto:
Mountdisplayid
slot1item
slot2item
slot3item
Please don't forget to apply the structure update!
Fixed DB editor. user and pass were declared 3 times when they only needed to declared once. Also fixed some typos and added the news spawns sql
And yes...this has been tested work.
*DEV'S PLEASE UPDATE THIS WHENEVER YOU ADD A NEW SQL UPDATE* Thanks
* Should fix the visible invisible npc problem (spell and/or script trigger/target npcs). They are no longer visible.
Things to consider:
- The current system of generating gender from the creature_names displayids is stupid. It can be directly read from bytes0. Faster and more sophisticated.
- The invisible npcs should be visible to GMs.
*RuneCostID corrected
*CMSG_GROUP_INVITE updated
*Pet bar corrected
*Pet spells now works... (but server still crashes when use spells)
*Professions max skill now is 450
- Data written to a deleted object, patch by alexisdm
- Item Quality: Heirloom, patch by MesoX
Corrected these, thanks to Redhound for testing.
WHERE statement so it wont overwrite Your changes.
* Fixed creature spawn saving.
* Spawned creatures' gender will be saved to db from now on.
Added
SQL1753
WHY my characters are always NUDE ??? and theres no npcs HELLP
umm no idea if its fixed but a few days ego tested this server
when casting spells i get allot of disconnections because something went wrong
it say something about access violation
is it fixed? or.. :P?
Running ArcEmu 1753 with updates applied and WhyDB244 with WoTLK updates. Starts up fast and error free.
Stupid question: Since upgrading to WoTLK I have lost my realmslist.wtf file. How do I connect the client to my server? lol
so will this wrk with the latest
With WotLK the realmlist.wtf is now located in World of Warcraft\Data\enUS folder.Quote:
Originally Posted by gavinstcloud
so any one can hellp wiht npcs ??
does the latest revision work with 2.4.3 ? i mean does the emulator accept 2.4.3 game versions ?
thank you .
Modem i'm not sure but it sounds like u need to redump your playercreateinfo>>>>> sqls. They should be in the whydb folder.
ArcEmu1753-1786
* Fixed creature spawn saving.
* Spawned creatures' gender will be saved to db from now on.
Other:
- Fix hash_map deprecation warnings with gcc 4.3, patch by alexisdm
Fix crash with pet when leaving combat
thanks to alexisdm
Fix (I hope) server crash with Vanish spell
Fix crashes when summoning things (Elemental totems, Army of the Dead)
* Removed a pointless check from Creature:Load
* Added some null reference checks to scripts
Added an import all feature. This feature is a quicker way to import all the updates and then get on with your life. :-)
Fixes a client crash when clicking on a flight path
Seem to only affect some servers
-- COOLACID --
Fix from Redhound for some Buffer overflows causing Core on exit, and fixes some talent inspects.
Andy says to revert this, it isn't fixing anything.
Next commit will fix the real issue.
Taxi fix.
Now you will not crash when you talk to a flight master !
Thanks to c1nco, you're the man, man.
Fixed proc for item Band of the Eternal Champion
Thanks to Riko87
Fix null spell name on locale (frFR and esES at least), This bug disallow multiple buffs at the same time by alexisdm.
Fix: Intellect stat not giving mana
Thanks StoneCutter
CrashHandler fix:
BUILD_REVISION is an int, not a string.
tm.tm_mon is 0-based (so add 1 for calendar month)
* Implemented opcode SMSG_MOUNTRESULT AND SMSG_DISMOUNT_RESULT, errors show correctly. (couldn't verify structure since my retail account is not active).
Only thing left is to add the errors. :P
DB updater for Linux. Works for me ;)
A few fixes for Linux compile (Scripts)
Ok:
Spaces in names == BAD
' in names == BAD
I've fixed most of the compile issues for linux - but there is still some .h issues with the WOTLK scripts
Ok - Fixed the includes - but some define errors still exist?
Ok - \\ is bad too on comments - DON'T DO IT!
vmaps for 3.0.3 link broken?
i don't upload vmap
Hi, first of all i want to thank you for your releases.
If you have time I have a question maybe you can help me with.
I am using whyDB 248 with the respective sql updates, and I have created a blank char+accounts DB using the data found on whyDB 236
When I login everything is shown Ok, but setting the ascent-world to debug, I can see that when I create a characters, it returns the error:
sql query failed due to column count doesnt match value count at row1, Replace into characters VALUES (1,1 ......)
I am using ArcEmu 1786 but I am also getting the same error on somehow previous versions.
There are no recent updates in the characters db, so I don't get why is doesn't match.
I am using client 3.0.3 with burning crusade, so I left the account flags to 8, in fact I would prefer people not to be able to create death nights until they have less bugs.
thanks for reading and the help too.
Regards
some tables are updated from whydb in last version that show you errors on restore sql files
thanks for answering so fast.
I have checked the sql updates you uploaded, and there are no updates in the characters table in the last revisions.
The last 2 ones I have applied on the character database are the 1564 Character glyphs, and the 1653 archivements, and I have already applied both.
Do you know where can I find a clean character structure, or if there some sql missing in the last release?
Regards
i post all updates. Character you can find in SQL Full
There is no fully dbs ? i have downloaded your dbs but they only create all databases without ex items is empty and all other.
i had that problem too because when i dumped i executed one after another without clicking on done after each one. Dont know why I never had to do it before, but when i executed them one at a time clicking done before moving on to the next it worked fine. Hope this helped