Advertisement
Guest User

Untitled

a guest
Jun 3rd, 2012
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.54 KB | None | 0 0
  1. forward MySQLUpdateFinish(query[], playerid);
  2. public MySQLUpdateFinish(query[], playerid)
  3. {
  4. if (strcmp(query, "WHERE Pseudo=", false) == 0) mysql_query(query);
  5. else
  6. {
  7. new playername2[1024];
  8. GetPlayerName(playerid, playername2, sizeof(playername2));
  9. new whereclause[32];
  10. format(whereclause, sizeof(whereclause), " WHERE Pseudo=%s", playername2);
  11. strcat(query, whereclause, MAX_STRING);
  12. mysql_query(query);
  13. format(query, MAX_STRING, "UPDATE Comptes SET ");
  14. }
  15. return 1;
  16. }
  17.  
  18. forward MySQLUpdatePlayerStr(query[], playerid, sqlvalname[], sqlupdatestr[]);
  19. public MySQLUpdatePlayerStr(query[], playerid, sqlvalname[], sqlupdatestr[])
  20. {
  21. MySQLUpdateBuild(query, playerid);
  22. new escstr[128];
  23. new updval[128];
  24. mysql_real_escape_string(sqlupdatestr, escstr);
  25. format(updval, sizeof(updval), "%s='%s'", sqlvalname, escstr);
  26. strcat(query, updval, MAX_STRING);
  27. return 1;
  28. }
  29.  
  30. forward MySQLUpdateBuild(query[], playerid);
  31. public MySQLUpdateBuild(query[], playerid)
  32. {
  33. new querylen = strlen(query);
  34.  
  35. new playername2[1024];
  36. GetPlayerName(playerid, playername2, sizeof(playername2));
  37.  
  38. new querymax = MAX_STRING;
  39. if (querylen < 1) format(query, querymax, "UPDATE Comptes SET ");
  40. else if (querymax-querylen < 50)
  41. {
  42. new whereclause[32];
  43. format(whereclause, sizeof(whereclause), " WHERE Pseudo=%s", playername2);
  44. strcat(query, whereclause, querymax);
  45. mysql_query(query);
  46. format(query, querymax, "UPDATE Comptes SET ");
  47. }
  48. else if (strfind(query, "=", true) != -1) strcat(query, ",", MAX_STRING);
  49. return 1;
  50. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement