Page 1 of 2

i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 1:56 pm
by razorshark
when me and my staff are on my server we put in npcs and stuff then when i rest the server they disapeear but the objects stay? can someone help?

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 2:20 pm
by Roozzz
Which command are you using?

There is at least one that doesn't save intentionally, You can check this by looking at the code and checking for Save in db or something. If you wish you can easily alter this, basically adding 2 lines, look at the other commands how its done.

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 2:33 pm
by razorshark
i use /mob create and doesnt save any of them!!

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 2:36 pm
by Roozzz
/mob create used to work fine.

How do you shutdown your server? /exit or pressing the X? Just hitting X won't save a thing iirc.

-edit-

To be exact:
nfastcreate and nrandcreate do not save in the db.
AND
/mob fastcreate <ModelID> <level> [save(default = 0; use 1 to save)] <name>' to create mob with specified info"

look at mob.cs

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 3:00 pm
by razorshark
i normally just exit it out up top

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 3:09 pm
by Roozzz
Just hitting X won't save a thing iirc.
There is your problem.

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 3:15 pm
by razorshark
well when i type exit i dont think it saved anyhting ill go check now

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 3:44 pm
by Tolakram
This doesn't make any sense.

Using a SQL database adding mobs saves instantly to the DB. Are you sure the user to your MySQL db has write privileges? Are there any errors about adding objects on the console?

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 3:47 pm
by razorshark
hold on im testing

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 3:55 pm
by razorshark
everything saved but the mobs im using navicat lite and i emptyed the mob table to reduce my server lag

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 4:34 pm
by geshi
Yep, I had this problem too, you must delete the BoatID column from your mob table.. I think it's called BoatID anyway :confused: something to do with Boats.

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 5:07 pm
by viper1805
it's the 'old' BoatOwnerID change it into OwnerID or delete it so that the server recreates the OwnerID-column (:

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 8:18 pm
by Tolakram
Why does anyone use navicat when HeidiSQL is available. Free and does everything needed.

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 8:56 pm
by baradien
Downloading and Importing your MySQL Databases:
1) Too download the official keep(Includes: Keep, KeepComponent, KeepHookpoint, KeepPosition, Relic) releases, click here.
2) Too download the official content package(Includes: Ability, ClassXRealmAbility, SpecXAbility, Specialisation, Style, Style Substitute, StyleXSpell, Spell, SpellLine, LineXSpell) releases, click here.
3) Too download the official World package(Includes: World Object, Zone Point, Area, Bind Point, Door) releases, click here.
4) Once you have downloaded all theese databases, extract them all into a folder you can easily remember.
5) Open up your Navicat MySQL GUI.
6) Open up your localhost connection, and right click on the database "dol" that you created.
7) Click execute batch file, and locate the folder you extracted all the databases into.
8) Click each database one by one, and they will be added to your MySQL database.
9) You now have an MySQL Database :)
10) You will now be able to run your fully compiled, fully functional DOL server, with a successful MySQL Database.
here your answer tola :) sinds supgee guide say it then will do the same way ^^

Re: i cant save my mobs? help!!

PostPosted: Sat Oct 23, 2010 10:07 pm
by Graveen
Why does anyone use navicat when HeidiSQL is available. Free and does everything needed.
And more ! bulk engine changes, bulk table copies, ssl connection...