Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- forward MySQLUpdateFinish(query[], playerid);
- public MySQLUpdateFinish(query[], playerid)
- {
- if (strcmp(query, "WHERE Pseudo=", false) == 0) mysql_query(query);
- else
- {
- new playername2[1024];
- GetPlayerName(playerid, playername2, sizeof(playername2));
- new whereclause[32];
- format(whereclause, sizeof(whereclause), " WHERE Pseudo=%s", playername2);
- strcat(query, whereclause, MAX_STRING);
- mysql_query(query);
- format(query, MAX_STRING, "UPDATE Comptes SET ");
- }
- return 1;
- }
- forward MySQLUpdatePlayerStr(query[], playerid, sqlvalname[], sqlupdatestr[]);
- public MySQLUpdatePlayerStr(query[], playerid, sqlvalname[], sqlupdatestr[])
- {
- MySQLUpdateBuild(query, playerid);
- new escstr[128];
- new updval[128];
- mysql_real_escape_string(sqlupdatestr, escstr);
- format(updval, sizeof(updval), "%s='%s'", sqlvalname, escstr);
- strcat(query, updval, MAX_STRING);
- return 1;
- }
- forward MySQLUpdateBuild(query[], playerid);
- public MySQLUpdateBuild(query[], playerid)
- {
- new querylen = strlen(query);
- new playername2[1024];
- GetPlayerName(playerid, playername2, sizeof(playername2));
- new querymax = MAX_STRING;
- if (querylen < 1) format(query, querymax, "UPDATE Comptes SET ");
- else if (querymax-querylen < 50)
- {
- new whereclause[32];
- format(whereclause, sizeof(whereclause), " WHERE Pseudo=%s", playername2);
- strcat(query, whereclause, querymax);
- mysql_query(query);
- format(query, querymax, "UPDATE Comptes SET ");
- }
- else if (strfind(query, "=", true) != -1) strcat(query, ",", MAX_STRING);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement