Really serious problem!!!

[wizzo]

hi i got a really serious problem wif my server... and that is... no NPCs at all!! (only my shopping mall npcs which i downloaded) so if any1 can help me fix it i wud b
gr8ful... thanks

[*~Descending~*]

Did you download the Database like NCDB or whydb or did you use the EMPTY database in your core folder from arcemu/aspire/ascent etc.

[Vindicated]

Make sure you have a database installed period.

[wizzo]

i dunno...i just got the link from this site, cliked on it downloaded xtracted etc and then i lost em all

[c0ddingt0n]

Is it a repack? Or complie?

[Ickybad]

Make sure your creature spawn tables are reading in your world exe and everything is smooth make sure your tables aren't blank. Then if not run updates I've had this problem v4 updated now no more probs.

[wizzo]

ok its not blank but i got nothing in vendors section...is taht a prob? (the only vendors i got are in navicat and they r the mall vendors) and where can i get v4 update from...im using heidisql (and i got no monsters either to fight anywhere)

[Ickybad]

The vendor sql you ran open it in note pad and check if it has a delete query it runs.

[wizzo]

i think one of does...heres wat it sed:

ALTER TABLE vendors ADD extended_cost INT NOT NULL DEFAULT '0';
-- fill extended_cost collumn with basic data from items_extendedcost table
UPDATE vendors,items_extendedcost SET extended_cost = CostId where ItemId = item;
-- uncomment this to delete old table <--
-- DROP TABLE items_extendedcost; ^
|
----------------------------------------------> |

it was in the file execute this for vendors fix

does it mean anything?

[nofix]

That query doesnt change anything in your creature_spawn table.

Im guessing you are running Arcemu, since its a sql update from them.

Try running this update aswell. (Create a DB Backup First!)

ALTER TABLE creature_spawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0';
ALTER TABLE creature_spawns ADD bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;

ALTER TABLE creature_staticspawns CHANGE `bytes` `bytes0` INT( 30 ) NOT NULL DEFAULT '0';
ALTER TABLE creature_staticspawns ADD bytes1 INT( 30 ) NOT NULL DEFAULT '0' AFTER bytes0;