Sad Panda - Database Currupted

[Drewww]

Few days ago I noticed when NPCs Died they never disapear, and NPCs no longer have Chat options, looking in the logs I see GIGs of LUA Errors.
Restarting isnt a problem but the time remaking all the gear and stat lists.
And since my SQL knowledge is very poor I wont bother trying to find what is wrong.
So leads me to a new question. What is some ways of making gear with stat lists on them. Can that be done via a GM commands. Although spawning items, ripping stats and making stat lists isnt hard, it just takes a long time.

[MentaL]

[Turmalin]

Simpliest(lol) way is bot usage) U can use micromacro, for ex.
As for scripts - did you had change path to your script folder or change something in those scripts or ini configs?

[Drewww]

Sort it out after a week. When I was doing file shares from one PC to another I've unknowingly removed the security properties from the c:\runewaker\data folder. So SQL could only read the database and not write back to it.

Found this out when I learned about Detaching and Attaching a database. So still learning new things, at least my database is intact. I did a fresh windows install, new sql, and attached the old database and it was back up an running.

Since the database wasn't detached before I had to make a folder share for c:\runewaker to allow everyone, then it attached, backed it up, cleared the share, and re imported. Anyhow all good now.

Also found out that some of the Fun NPCs I installed in Varanas were filling the logs with errors, for example a boss with a script with zone details for some instance was filling zone 2 logs with errors cause it wasn't in its correct zone. So fixed those up too.

[Turmalin]

Congratulations, gj)