[Danny]

Hey,

I'm using this query in my accountsystem and somehow it's crashing the server. I suspect this can be due a bug in the new R7 version.

Код:

	printf("First query. (ID: %d)",playerid);
	new savequery[1500];
	mysql_format(sqlConnection, savequery, "UPDATE `" #USERTABLE "` SET `username`='%s',`ipaddress`='%s',`status`='%d',`language`='%d',`autologin`='%d',`age`='%d',`carlicense`='%d'", AccountInfo[playerid][username], AccountInfo[playerid][ipaddress], AccountInfo[playerid][status], AccountInfo[playerid][language], AccountInfo[playerid][autologin], AccountInfo[playerid][age], AccountInfo[playerid][carlicense]);
	mysql_format(sqlConnection, savequery, "%s,`flylicense`='%d',`boatlicense`='%d',`viprank`='%d',`property1`='%d',`property2`='%d',`warnreason1`='%s',`warnreason2`='%s'", savequery, AccountInfo[playerid][flylicense], AccountInfo[playerid][boatlicense], AccountInfo[playerid][viprank], AccountInfo[playerid][property1], AccountInfo[playerid][property2], AccountInfo[playerid][warnreason1], AccountInfo[playerid][warnreason2]);
	mysql_format(sqlConnection, savequery, "%s,`warnreason3`='%s',`serversounds`='%d',`daysplayed`='%d',`hoursplayed`='%d',`minutesplayed`='%d',`money`='%d',`bankmoney`='%d'", savequery, AccountInfo[playerid][warnreason3], AccountInfo[playerid][serversounds], AccountInfo[playerid][daysplayed], AccountInfo[playerid][hoursplayed], AccountInfo[playerid][minutesplayed], AccountInfo[playerid][money], AccountInfo[playerid][bankmoney]);
	mysql_format(sqlConnection, savequery, "%s,`positionx`='%f',`positiony`='%f',`positionz`='%f',`angle`='%f',`faction`='%d',`rank`='%d',`factioncode`='%d',`joindate`='%s'", savequery, AccountInfo[playerid][positionx], AccountInfo[playerid][positiony], AccountInfo[playerid][positionz], AccountInfo[playerid][angle], AccountInfo[playerid][faction], AccountInfo[playerid][frank], AccountInfo[playerid][factioncode], AccountInfo[playerid][fjoindate]);
	mysql_format(sqlConnection, savequery, "%s,`fishingexp`='%d',`fish`='%d',`jailtimeleft`='%d',`weap0`='%d',`ammo0`='%d',`weap1`='%d',`ammo1`='%d',`weap2`='%d',`ammo2`='%d' WHERE `identification`='%d'", savequery, AccountInfo[playerid][fishingexp], AccountInfo[playerid][fish], floatround((JailInfo[playerid][3]/1000)), pWeapons[playerid][0][0], pWeapons[playerid][0][1], pWeapons[playerid][1][0], pWeapons[playerid][1][1], pWeapons[playerid][2][0], pWeapons[playerid][2][1],
	AccountInfo[playerid][identification]);
	return mysql_function_query(sqlConnection, savequery, false, "OnAccountSaved", "d", playerid);
}

Does someone see the cause of the crash or does someone have any experience with the new R7 version of BlueG's plugin that's crashing under normal circumstances?

Greetz,
Danny

[WooTFTW]

You could try crashdetect plugin, to find out why it's crashing.

[Danny]

Quote:

Originally Posted by WooTFTW You could try crashdetect plugin, to find out why it's crashing.

I tried, but it don't detect the crash or something, it'll give me no result.