SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 09/08/2015, 03:43 AM   #1
andreistalker
Big Clucker
 
andreistalker's Avatar
 
Join Date: May 2015
Posts: 64
Reputation: 1
Default Server Crash + MySql

When my server crash, it set on MySql 0 money to all players that were on server. I think is from Money Timer...
andreistalker is offline   Reply With Quote
Old 09/08/2015, 04:21 AM   #2
zDivine
Huge Clucker
 
Join Date: Oct 2012
Location: zDivine.pwn
Posts: 298
Reputation: 49
Default Re: Server Crash + MySql

Did you just want to let everyone in on your thoughts or something?
zDivine is offline   Reply With Quote
Old 09/08/2015, 04:35 AM   #3
andreistalker
Big Clucker
 
andreistalker's Avatar
 
Join Date: May 2015
Posts: 64
Reputation: 1
Default Re: Server Crash + MySql

Code for update
HTML Code:
public updatemoney()
{
	foreach(Player, i)
	{
  		if(gLogged[i] == 1){
			new query[256];
			mysql_format(handle, query, sizeof(query), "UPDATE `conturi` SET `Cash`='%d' AND 'Level'='%d' WHERE `Nume`='%s'", P_Data[i][pLevel], P_Data[i][pLevel], GetName(i));// facem update-ul la baza de date
 			mysql_query(handle, query);
		}
	}
	return 1;
}
andreistalker is offline   Reply With Quote
Old 09/08/2015, 08:22 AM   #4
MarvinPWN
Big Clucker
 
Join Date: Jul 2015
Posts: 143
Reputation: 15
Default Re: Server Crash + MySql

You use two times pLevel, but where is pCash or something else?
Can you show us your OnPlayerDisconnect callback?
MarvinPWN 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
MySQL - Login causes server crash Barnwell Server Support 3 02/02/2015 06:10 PM
MySQL Problem - Server crash GTA:SA Server Support 2 03/01/2015 07:45 AM
MySQL Server Crash Pille_ Scripting Help 5 03/03/2013 09:37 PM
Server crash when I register (MYSQL) Gangs_Rocks Scripting Help 3 26/08/2012 10:22 AM
server crash (mysql problem??) Sascha Help Archive 10 17/02/2011 11:27 AM


All times are GMT. The time now is 02:39 AM.


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