SA-MP Forums Archive
MYSQL not updating? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MYSQL not updating? (/showthread.php?tid=335069)



MYSQL not updating? - Nuke547 - 17.04.2012

Why doesn't this make the group update?

pawn Код:
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);
}



Re: MYSQL not updating? - MP2 - 17.04.2012

Check the mysql_log (in your server directory).


Re: MYSQL not updating? - Nuke547 - 17.04.2012

Nothing comes up


Re: MYSQL not updating? - MP2 - 17.04.2012

mysq_debug(1) under OnGameModeInit then run the code again.