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  

  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.

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