[Ascent][Help]Ok Ragezone ppl, help me!
...
I have been working on this damn server update for the past 8 hours...and everytime i get errors
the latest error isn't in the ascent.exe for once..
nor is it in the logonserver.exe
i have silvermoondatabase:life
i Want a blizz-like server not a fun server with a mall and blah blah blah
i also have rev 1621, its compatiable
but, only problem is......when i load into the game, i got and look around for any npcs..and NONE are there....................................................................................
Some One wanna help me out?!?!?!?!?!?!
ps. is it something wrong with my database or my rev? or my wow cache?!?! >.<
>.>:scratch:
>.<
(whits end..im going to bed till monday...)
Re: [Ascent][Help]Ok Ragezone ppl, help me!
try these queries
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;
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;
You should know though that your BD is too old and you will always have problems
with newer cores...
Re: [Ascent][Help]Ok Ragezone ppl, help me!
Quote:
Originally Posted by
kounelos
try these queries
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;
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;
You should know though that your BD is too old and you will always have problems
with newer cores...
well thanks for the creative criticism and the query lines.......
But did Not
work
..>.>
Re: [Ascent][Help]Ok Ragezone ppl, help me!
What do you mean it didnt work?
when you are running the queries you get errors?
My suggestion is to change your DB or wait for a new silvermoon release
Re: [Ascent][Help]Ok Ragezone ppl, help me!
Quote:
Originally Posted by
kounelos
What do you mean it didnt work?
when you are running the queries you get errors?
My suggestion is to change your DB or wait for a new silvermoon release
no i didnt get errors, and No, im not running another batch.............
(last one took me 8 hours)
btw, the npcs are still gone, thats what i mean
Re: [Ascent][Help]Ok Ragezone ppl, help me!
why is it that when i update the creature_proto table that it always sticks on connected?
Re: [Ascent][Help]Ok Ragezone ppl, help me!
use Milestone 0.2 - 0.2,1
Re: [Ascent][Help]Ok Ragezone ppl, help me!
hmm guess u got some stragne prob...