SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Scripting Help > Discussion

Reply
 
Thread Tools Display Modes
Old 10/04/2017, 09:01 AM   #1
SMerajiyan
Little Clucker
 
SMerajiyan's Avatar
 
Join Date: Mar 2015
Posts: 5
Reputation: 0
Question Saving server data into Database Problem

Hi guys, I've just recieved a RolePlay GameMode from one of my friends.
I synced everything between GameMode and that .sql file ( server works in the best way )
I want to clear everything in that server so that i can test something such as moving main city, moving jobs factions and etc.
-----
And here the problem begins, When i erase the database ( not tables just their data ) I'm not able to modify server, I think you didn't understand ( don't offend ) let me explain again, For example i've cleaned all of datas in "houses" ( tables are still there )
When i launch server and i go in. i can edit house using /hedit ( all of houses from 1 till unlimited are accessable ), i can set exterior interior and everything but when it's done and i close the server (using Maintenance or using gmx doesn't matter) it won't save itself into database, like i didn't change anything, I know i can add every single thing in database manually but my question is, if adding data to database from server is impossible so how "accounts" are made by server then?
Any, Any help will be so so so appreciate.
Thanks for reading <3
And sorry for my bad English.
-----
P.s: I can attach files if it's necessary.
SMerajiyan is offline   Reply With Quote
Old 10/04/2017, 10:19 AM   #2
OneDay
Huge Clucker
 
Join Date: Sep 2015
Posts: 291
Reputation: 126
Default Re: Saving server data into Database Problem

is your gamemode user having database permissions like INSERT?
OneDay is offline   Reply With Quote
Old 10/04/2017, 12:16 PM   #3
SMerajiyan
Little Clucker
 
SMerajiyan's Avatar
 
Join Date: Mar 2015
Posts: 5
Reputation: 0
Default Re: Saving server data into Database Problem

Quote:
Originally Posted by OneDay View Post
is your gamemode user having database permissions like INSERT?
Ty for reading!
Yes, It has all of the permissions
SMerajiyan is offline   Reply With Quote
Old 11/04/2017, 12:51 PM   #4
SMerajiyan
Little Clucker
 
SMerajiyan's Avatar
 
Join Date: Mar 2015
Posts: 5
Reputation: 0
Default Re: Saving server data into Database Problem

Bump~
SMerajiyan is offline   Reply With Quote
Old 11/04/2017, 05:28 PM   #5
Marricio
Gangsta
 
Join Date: Dec 2010
Posts: 757
Reputation: 96
Default Re: Saving server data into Database Problem

It's just the houses or everything doesn't work? Like, does the accounts save? Try checking for errors caused by your queries.
Marricio is offline   Reply With Quote
Old 05/05/2017, 03:22 PM   #6
ShihabSoft
Banned
 
Join Date: Jun 2016
Posts: 165
Reputation: 8
Default Re: Saving server data into Database Problem

Post the snippet of your save code here.
ShihabSoft is offline   Reply With Quote
Old 05/05/2017, 03:49 PM   #7
DRIFT_HUNTER
High-roller
 
Join Date: Oct 2009
Posts: 2,143
Reputation: 172
Default Re: Saving server data into Database Problem

Just make a command that will force save stuff just like in OnGameModeExit
__________________
Путин here,
Путин there,
Путин просто everywhere.


Any PM's that include question about any kind of help will be ignored.
Use appropriate boards for that
DRIFT_HUNTER is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem saving data in database CMH Scripting Help 0 07/01/2017 11:01 AM
data saving problem CarRamper Scripting Help 5 23/06/2016 04:26 PM
MySQL database saving problem GloomY Scripting Help 4 05/06/2015 07:43 PM
Problem with saving data TonyII Scripting Help 11 30/12/2014 02:16 PM
Problem with getting data from database TheRox Scripting Help 2 08/09/2014 04:03 PM


All times are GMT. The time now is 08:37 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.