Can't start game >.<

09/06/2011 14:45 [Admin]Forever#1
So , my dragons weren't working after trying to delete the DB skill . Then i followed oLago's post from [Only registered and activated users can see links. Click Here To Register...]
. But i did a big mistake . At DELETE FROM [PS_GameDefs].[dbo].[Skills] WHERE SkillLevel<100;
GO , idk why shStudio made files on desktop ( altho it was set somewhere else ) and so i hadn't see them . Then i executed that code in sql manager since i am nub , it said 594 lines affected , and now game won't start ... it says the 0 error after selecting char and pressing Start . Any solutions or we have to do server again from the beginning ? >.<
09/06/2011 21:48 viper4513#2
Quote:
DELETE FROM [PS_GameDefs].[dbo].[Skills]
WHERE SkillLevel<100;
GO
That query only deletes your skill with levels under 100 (IE you're player skills) But as you've edited your mob skills, and used the ShStudio generated script to update your database, it has made all your mob skills level 3 (i think thats the level) which therefor makes ALL you're skills, including mob skills under level 100.

Now, when you ran that DELETE FROM query, you deleted your entire Skill Table, all player, and mob skills (including the buff items aswell).

I think the reason you're getting this error is because of 2 things..
1st your database has missing data (non-existant data)
2nd your database, due to having the missing data, doesnt match with your data files (the ones the game uses to "see" what data it should show)

Either, use an older version (backup) of your database and/or data files to fix this problem, or unfortunatly start again, unless you can address the problem and fix it accordingly.

Maybe one of the proper Devs will have more info on it for you with a more simple fix.