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: 15
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: 5,449
Reputation: 766
Default Re: MYSQL not updating?

Check the mysql_log (in your server directory).
__________________
>> Click here for ALL of my releases
mGates - Create AUTOMATIC gates with ONE FUNCTION (+ restrictions i.e. team members only)
IEE (Interior Enter/Exits) - Create enex markers with one function
Cuffs - Cuff offsets for ALL SKINS!
vfunc - Vehicle functions. GetVehicleColor and synced random colors.
gBug - Prevent the 'G' bug (players being able to enter moving vehicles by pressing G then running after them).
MP2 is online now   Reply With Quote
Old 17/04/2012, 01:39 AM   #3
Nuke547
Big Clucker
 
Join Date: Dec 2011
Posts: 173
Reputation: 15
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: 5,449
Reputation: 766
Default Re: MYSQL not updating?

mysq_debug(1) under OnGameModeInit then run the code again.
__________________
>> Click here for ALL of my releases
mGates - Create AUTOMATIC gates with ONE FUNCTION (+ restrictions i.e. team members only)
IEE (Interior Enter/Exits) - Create enex markers with one function
Cuffs - Cuff offsets for ALL SKINS!
vfunc - Vehicle functions. GetVehicleColor and synced random colors.
gBug - Prevent the 'G' bug (players being able to enter moving vehicles by pressing G then running after them).
MP2 is online now   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 02:46 PM
Updating a mysql row ihatetn931 Help Archive 0 24/11/2010 11:53 AM
Updating Car [Mysql] Cameltoe Help Archive 10 14/08/2010 09:56 PM


All times are GMT. The time now is 10:46 AM.


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