1) backup your current char/logon database
2) grab a new core http://forum.ragezone.com/f114/lates...-daily-305070/
3) download a ready to use database for current cores. eg. NCDB:
hxxp://projects.emupedia.com/svn/ncdb with TortoiseSVN or RapidSVN. Username is "anonymous" (without ""). no password (leave it blank).
hxxp://tortoisesvn.net/downloads
hxxp://www.rapidsvn.org/download/release/
use hxxp://projects.emupedia.com/svn/ncdb from within TortoiseSVN or RapidSVN, not within a webbrowser. both programs will download the most current version of the ncdb project.
use "Tool.bat" to install ncdb-world-database.
4) compare your char/logon database/tables with changes made to the db-structure:
Code:
Revision: 1844
----
ALTER TABLE playerpets DROP COLUMN autocastspell;
UPDATE playerpets SET actionbar="";
Revision: 1837
----
trainer_defs.sql
trainer_spells.sql
Revision: 1786
----
alter table characters add column custom_faction int(30) default 0 not null after gender;
Revision: 1743
----
spell_proc_data.sql (world db)
Revision: 1730
----
alter table creature_spawns add column channel_spell int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid int(30) not null default 0;
alter table creature_spawns add column channel_target_sqlid_creature int(30) not null default 0;
Revision: 1649
----
banned_phrases.sql
Revision: 1641
----
arenateams.sql
Revision: 1603
----
alter table creature_names change displayid male_displayid int(30) not null;
alter table creature_names add column female_displayid int(30) not null after male_displayid;
alter table creature_names add column unknown_int1 int(30) not null default 0 after female_displayid;
alter table creature_names add column unknown_int2 int(30) not null default 0 after unknown_int1;
alter table creature_names change unk2 unknown_float1 float(0) not null;
alter table creature_names change unk3 unknown_float2 float(0) not null;
alter table creature_proto add column fly_speed float(0) default "14.0" not null;
alter table creature_proto add column extra_a9_flags int(30) default 0 not null;
Revision: 1602
----
alter table characters change lastDailyReset honorPointsToAdd INT(10) NOT NULL;
update characters set honorPointsToAdd = 0;
alter table characters change charterId arenaPoints INT(10) NOT NULL;
update characters set arenaPoints = 0;
Revision: 1598
----
server_settings.sql (CHARACTER DATABASE)
Revision: 1566
----
Added : arenateams.sql
Added : charters.sql
Revision: 1561
----
Added : weather.sql
Revision: 1542
----
ALTER TABLE creature_proto ADD walk_speed FLOAT DEFAULT "2.5" NOT NULL AFTER death_state;
ALTER TABLE creature_proto ADD run_speed FLOAT DEFAULT "8" NOT NULL AFTER walk_speed;
Revision: 1425
----
if you wish to use this formula then execute this query
update ai_agents set spellCooldown=-1 where spellCooldown=0
Revision: 1393
----
CREATE TABLE `banned_names` (
`name` varchar(30) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Revision: 1387
----
alter table playeritems drop column guid;
alter table playeritems add column guid bigint(10) NOT NULL auto_increment primary key after ownerguid;
Revision: 1361
----
Added : pets.sql
Revision: 1312
----
Added : groups.sql
Revision: 1305
----
Added : new_trainer_sruct.sql
Revision: 1143
----
CREATE TABLE `zoneguards` (
`zoneId` int(10) unsigned NOT NULL,
`hordeEntry` int(10) unsigned default NULL,
`allianceEntry` int(10) unsigned default NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Revision: 1132
----
alter table creature_proto change health minhealth int(30) unsigned not null;
alter table creature_proto add column maxhealth int(30) unsigned not null after minhealth;
update creature_proto set maxhealth=minhealth;
alter table creature_proto change level minlevel int(30) unsigned not null;
alter table creature_proto add column maxlevel int(30) unsigned not null after minlevel;
update creature_proto set maxlevel=minlevel;
alter table creature_proto add column invisibility_type int(30) unsigned not null;
alter table creature_proto add column death_state int(30) unsigned not null;
Revision: 1071
----
alter table creatureloot add column heroicpercentchance float(0) default 0;
alter table creatureloot add column mincount int(30) default 1;
alter table creatureloot add column maxcount int(30) default 1;
alter table fishingloot add column heroicpercentchance float(0) default 0;
alter table fishingloot add column mincount int(30) default 1;
alter table fishingloot add column maxcount int(30) default 1;
alter table itemloot add column heroicpercentchance float(0) default 0;
alter table itemloot add column mincount int(30) default 1;
alter table itemloot add column maxcount int(30) default 1;
alter table objectloot add column heroicpercentchance float(0) default 0;
alter table objectloot add column mincount int(30) default 1;
alter table objectloot add column maxcount int(30) default 1;
alter table skinningloot add column heroicpercentchance float(0) default 0;
alter table skinningloot add column mincount int(30) default 1;
alter table skinningloot add column maxcount int(30) default 1;
Revision: 974
----
prospecting.sql
Revision: 896
----
alter table worldmap_info add column required_quest int(30) not null default 0 after lvl_mod_a;
alter table worldmap_info add column required_itemid int(30) not null default 0 after lvl_mod_a;
Revision 262:
----
UPDATE totemspells SET spellToCast1= 8349 WHERE spellId=1535
UPDATE totemspells SET spellToCast1= 8502 WHERE spellId=8498
UPDATE totemspells SET spellToCast1= 8503 WHERE spellId=8499
UPDATE totemspells SET spellToCast1= 11306 WHERE spellId=11314
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=11315
UPDATE totemspells SET spellToCast1= 11307 WHERE spellId=27623
UPDATE totemspells SET spellToCast1= 8187 WHERE spellId=8190
UPDATE totemspells SET spellToCast1= 10579 WHERE spellId=10585
UPDATE totemspells SET spellToCast1= 10580 WHERE spellId=10586
UPDATE totemspells SET spellToCast1= 10581 WHERE spellId=10587
Revision 231:
----
UPDATE totemspells SET spellToCast1= 5729 WHERE spellId=5730
t4k
Reply With Quote