SA-MP Forums

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

Reply
 
Thread Tools Display Modes
Old 17/04/2012, 01:22 AM   #1
Nuke547
Big Clucker
 
Join Date: Dec 2011
Posts: 173
Reputation: 16
Default MYSQL not updating?

Why doesn't this make the group update?

pawn Code:
stock SaveGroup(groupid)
{
    new query[500];
    format(query, sizeof(query), "UPDATE groups SET name = '%s', motd = '%s', extx = %f, exty = %f, extz = %f, intx = %f, inty = %f, intz = %f, interior = %d, virtualworld = %d, safex = %f, safey = %f, safez = %f, title = '%s', title2 = '%s', title3 = '%s', title4 = '%s', title5 = '%s', title6 = '%s' WHERE id = %d", gStats[groupid][Name], gStats[groupid][MOTD], gStats[groupid][Ext][0], gStats[groupid][Ext][1], gStats[groupid][Ext][2], gStats[groupid][Int][0], gStats[groupid][Int][1],
    gStats[groupid][Int][2], gStats[groupid][Interior], gStats[groupid][VirtualWorld], gStats[groupid][Safe][0], gStats[groupid][Safe][1], gStats[groupid][Safe][2], gStats[groupid][Title][0], gStats[groupid][Title][1], gStats[groupid][Title][2], gStats[groupid][Title][3], gStats[groupid][Title][4], gStats[groupid][Title][5], groupid);
    mysql_query(query);
}
Nuke547 is offline   Reply With Quote
Old 17/04/2012, 01:36 AM   #2
MP2
Godfather
 
MP2's Avatar
 
Join Date: Jan 2011
Location: England
Posts: 6,316
Reputation: 909
Default Re: MYSQL not updating?

Check the mysql_log (in your server directory).
__________________
>> Click here to see my releases.

Please do not PM me requesting help. Here you have a forum with 11,000+ active users - why are you limiting your help to one person?
MP2 is offline   Reply With Quote
Old 17/04/2012, 01:39 AM   #3
Nuke547
Big Clucker
 
Join Date: Dec 2011
Posts: 173
Reputation: 16
Default Re: MYSQL not updating?

Nothing comes up
Nuke547 is offline   Reply With Quote
Old 17/04/2012, 01:43 AM   #4
MP2
Godfather
 
MP2's Avatar
 
Join Date: Jan 2011
Location: England
Posts: 6,316
Reputation: 909
Default Re: MYSQL not updating?

mysq_debug(1) under OnGameModeInit then run the code again.
__________________
>> Click here to see my releases.

Please do not PM me requesting help. Here you have a forum with 11,000+ active users - why are you limiting your help to one person?
MP2 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 Not Updating aqu Scripting Help 0 26/02/2012 03:46 PM
Updating a mysql row ihatetn931 Help Archive 0 24/11/2010 12:53 PM
Updating Car [Mysql] Cameltoe Help Archive 10 14/08/2010 09:56 PM


All times are GMT. The time now is 05:11 AM.


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