[INDENT][INDENT][INDENT][INDENT][INDENT][INDENT][SIZE=6][COLOR=Indigo][U][B]
Printable View
[INDENT][INDENT][INDENT][INDENT][INDENT][INDENT][SIZE=6][COLOR=Indigo][U][B]
Very Nice! But can you write also, how to update to this version from 1595?
are you blind you didnt read where it says wrks on 1605+
No, I read it, I just wanted to know, If i have to delete my databases to renew or what ??
Thx for this ;)
Vinillo
Dude, how do I update my databases keeping old accounts ? tell me.
Sorry to say, but your NCDB R461.sql doesnt import good. It gives an error at around 42683k/81984k when importing Basically, theres a 20 pages long error, an finish with Error Code: 1054 - Unknown column 'name' in 'field list' Thanks
depents how you update it :P ps illidan script is not working for me after the nice chat with akama and illidan it stops illidan just sit there looking ad his skull and akama stand in the middle doing .... nothing :P
im not updating, im importing from scratch.
To get this database to work with the newest Ascent Rev use the following query's....
Code: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;
Code: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;
Code: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;
Code:ALTER TABLE creatureloot DROP heroicpercentchance;
ALTER TABLE creatureloot DROP mincount;
ALTER TABLE creatureloot DROP maxcount;
ALTER TABLE fishingloot DROP heroicpercentchance;
ALTER TABLE fishingloot DROP mincount;
ALTER TABLE fishingloot DROP maxcount;
ALTER TABLE itemloot DROP heroicpercentchance;
ALTER TABLE itemloot DROP mincount;
ALTER TABLE itemloot DROP maxcount;
ALTER TABLE objectloot DROP heroicpercentchance;
ALTER TABLE objectloot DROP mincount;
ALTER TABLE objectloot DROP maxcount;
ALTER TABLE pickpocketingloot DROP heroicpercentchance;
ALTER TABLE pickpocketingloot DROP mincount;
ALTER TABLE pickpocketingloot DROP maxcount;
ALTER TABLE prospectingloot DROP heroicpercentchance;
ALTER TABLE prospectingloot DROP mincount;
ALTER TABLE prospectingloot DROP maxcount;
ALTER TABLE skinningloot DROP heroicpercentchance;
ALTER TABLE skinningloot DROP mincount;
ALTER TABLE skinningloot DROP maxcount;
ALTER TABLE creatureloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE fishingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE itemloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE objectloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE pickpocketingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE prospectingloot MODIFY column percentchance float(0) NOT NULL default 0;
ALTER TABLE skinningloot MODIFY column percentchance float(0) NOT NULL default 0;
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 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 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 prospectingloot add column heroicpercentchance float(0) default 0;
alter table prospectingloot add column mincount int(30) default 1;
alter table prospectingloot add column maxcount int(30) default 1;
alter table pickpocketingloot add column heroicpercentchance float(0) default 0;
alter table pickpocketingloot add column mincount int(30) default 1;
alter table pickpocketingloot 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;
Code:CREATE TABLE `server_settings` (
`setting_id` varchar(200) NOT NULL,
`setting_value` int(50) NOT NULL,
PRIMARY KEY (`setting_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `groups` (
`group_id` int(30) NOT NULL,
`group_type` tinyint(2) NOT NULL,
`subgroup_count` tinyint(2) NOT NULL,
`loot_method` tinyint(2) NOT NULL,
`loot_threshold` tinyint(2) NOT NULL,
`group1member1` int(50) NOT NULL,
`group1member2` int(50) NOT NULL,
`group1member3` int(50) NOT NULL,
`group1member4` int(50) NOT NULL,
`group1member5` int(50) NOT NULL,
`group2member1` int(50) NOT NULL,
`group2member2` int(50) NOT NULL,
`group2member3` int(50) NOT NULL,
`group2member4` int(50) NOT NULL,
`group2member5` int(50) NOT NULL,
`group3member1` int(50) NOT NULL,
`group3member2` int(50) NOT NULL,
`group3member3` int(50) NOT NULL,
`group3member4` int(50) NOT NULL,
`group3member5` int(50) NOT NULL,
`group4member1` int(50) NOT NULL,
`group4member2` int(50) NOT NULL,
`group4member3` int(50) NOT NULL,
`group4member4` int(50) NOT NULL,
`group4member5` int(50) NOT NULL,
`group5member1` int(50) NOT NULL,
`group5member2` int(50) NOT NULL,
`group5member3` int(50) NOT NULL,
`group5member4` int(50) NOT NULL,
`group5member5` int(50) NOT NULL,
`group6member1` int(50) NOT NULL,
`group6member2` int(50) NOT NULL,
`group6member3` int(50) NOT NULL,
`group6member4` int(50) NOT NULL,
`group6member5` int(50) NOT NULL,
`group7member1` int(50) NOT NULL,
`group7member2` int(50) NOT NULL,
`group7member3` int(50) NOT NULL,
`group7member4` int(50) NOT NULL,
`group7member5` int(50) NOT NULL,
`group8member1` int(50) NOT NULL,
`group8member2` int(50) NOT NULL,
`group8member3` int(50) NOT NULL,
`group8member4` int(50) NOT NULL,
`group8member5` int(50) NOT NULL,
`timestamp` int(30) NOT NULL,
PRIMARY KEY (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Btw, wheres the shopping center?
Blood elf and Draenei don work :S
Change the 0 in the flag field of the account table to 8, durrr.Quote:
Originally Posted by Tempt
heh... good to know you're still working on repacks julian ;)
i'll try to try this later
Doesn't let me get past Selecting the realm :(