aboutsummaryrefslogtreecommitdiff
path: root/sql/realmd.sql
AgeCommit message (Collapse)Author
2010-04-11Missing changes for prev. commit. thx to Aokromes.n0n4m3
--HG-- branch : trunk
2010-04-11Update realmlist gamebuild.n0n4m3
--HG-- branch : trunk
2010-03-23Fixed long forgotten gamebuild default value (thx Aokromes).teacher
Also fixed typo in script full file (thx ogeraisi). --HG-- branch : trunk
2010-02-14* Core switch to client 3.3.2 (11403)Brian
* Credits (in no particular order) to: * n0n4m3, raczman, manuel, Spp, Malcrom, Teacher, QAston, Tartalo, * thenecromancer, Xanadu, Trazom, Zor, kiper * Additional credits to: * TOM_RUS and NoFantasy from MaNGOS * Thanks for testing Aokromes and XTElite1 * SoTA still needs some work, but is very playable (huge thanks to raczman and * kiper) * To upgrade, you need to apply all SQL from sql/updates/3.2.2a_old from the * last rev you are on * and then apply all SQL from sql/updates/3.3.2_old to char / realmd / world * DBs * Known problem with guild banks. --HG-- branch : trunk
2010-02-01Updated world.sql and characters.sql.teacher
Removed commented code form realm.sql and set account.expansion field default value to 2 (wotlk) (thx Aokromes). Properly set default values for some world DB fields. Properly set some world DB fields to allow Database import in strict mode (by Brian). Updated world_script_full with recent committed npc script. Renamed a couple of files with proper revision number. Note: no DB data will changed nor harmed by this commit. --HG-- branch : trunk
2009-12-22* Add missed change from last rev. Allow realmd.sql to run multiple timesp0wer
* without error. --HG-- branch : trunk
2009-12-22* Comment out adding accounts 1 2 and 3 to `account_access` since it is ↵p0wer
commented * out in `account` as well. Thanks Sundark. --HG-- branch : trunk
2009-12-22Fixed realmd.sql, remove assigning the gmlevel when gmlevel isn't in account ↵maanuel
anymore by Sundark and zero389. --HG-- branch : trunk
2009-12-21Fix some whitespace errors. Corrected account_access 'id' type.p0wer
--HG-- branch : trunk
2009-12-21* Add support for different gmlevel's for different realms.p0wer
* * Using the value -1 will add the same value for all realms. * Make sure to apply the updates. * Information regarding this patch will be posted on the database forums soon. * * Thanks to Sundark and the Ilixiuemu team(for original patch) --HG-- branch : trunk
2009-12-18sql updates for 3.2.2awin32
--HG-- branch : trunk
2009-12-09* Removed unused table from the realm DBBrian
--HG-- branch : trunk
2009-09-15Add Server revision to realmd.uptime tableChaz Brown
--HG-- branch : trunk
2009-09-14*Fix a typo.Anubisss
--HG-- branch : trunk
2009-09-13Add support for multirealm. Patch by streetrat.Kudlaty
--HG-- branch : trunk
2009-08-09 [8332] Add non-unique key `accid` for `realmcharacters` table for ↵megamage
speedup queries by this field. Author: rilex Just note about related _not_ mangos bug: this table _expected_ to have primary key by pair (`realmid`,`acctid`). If used DB not have it for table, then this wrongly setup of DB. --HG-- branch : trunk
2009-07-31*Remove data from world.sql - it exists now only for structure documentation.QAston
*Remove debug spell_check command - such things shouldn't belong to core. --HG-- branch : trunk
2009-06-18*Second part of previous commit.hunteee
--HG-- branch : trunk
2009-06-02[7938] Use same type for account ids in different tables related to used in ↵megamage
code uint32 type for it. Author: charlie2025 --HG-- branch : trunk
2009-03-26[7545] Fixed exploration achievements for certian areas Author: DonTomikamegamage
[7546] move uptime table to Realm database, use realmid column. Author: Triply --HG-- branch : trunk
2009-03-19* Implementing database logging:XTZGZoReX
** LogTime and LogColors config options removed due to incompatibility. ** Old file logging still available. ** Totally redone the Log class. ** Config options added: EnableLogDB, DBLogLevel, LogDB.Char, LogDB.RA, LogDB.GM -- remember to update config file. ** SQL updates attached. --HG-- branch : trunk
2009-02-18*Merge.megamage
--HG-- branch : trunk
2009-02-17Newline added to bottom of all files.KingPin
--HG-- branch : trunk
2008-12-26*Some fix. Finally usable.megamage
--HG-- branch : trunk
2008-12-24*SQL clean up.megamage
--HG-- branch : trunk
2008-10-23[svn] Prevent Bestial Wrath from being applied 5 times when cast by a hunter ↵w12x
with The Beast Within talent. Hopefully this will also fix the crashes caused by this spell. Change 'tbc' to 'expansion' in realmd.sql. --HG-- branch : trunk
2008-10-14[svn] * SQL cleanuprunningnak3d
* Removed unneeded revision SQL, since everyone will be starting off at a single revision. * Left the characters SQL in case someone needs to convert a MaNGOS characters DB * Final dumps of realmd / world / and characters DB schemas --HG-- branch : trunk
2008-10-02[svn] * Proper SVN structureinitNeo2003
--HG-- branch : trunk