[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...)

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...

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

..>.>

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

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

why is it that when i update the creature_proto table that it always sticks on connected?

use Milestone 0.2 - 0.2,1

hmm guess u got some stragne prob...