Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
114
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. Hey Jeffry ich habe das jetze so aber es funktioniert irgendwie nicht ?
  2. Geprintet wird mir der Richtige code.
  3.  
  4. public OnPlayerEnterCode(playerid)
  5. {
  6. new rows = cache_get_row_count();
  7. if(rows > 0)
  8. {
  9. new typ = cache_get_field_content_int(0,"typ",dbhandle),betrag = cache_get_field_content_int(0,"betrag",dbhandle),Code[15],query[128];
  10. GetPVarString(playerid, "Gutscheincode",Code,sizeof(Code));
  11. printf("%s",Code);
  12. new string[128];
  13. if(typ == 1)
  14. {
  15. GivePlayerMoney(playerid,betrag);
  16. sInfo[playerid][Money] += betrag;
  17. format(string,sizeof(string),"Du hast den Gutschein eingelöst und %d$ Bekommen.",betrag);
  18. SendClientMessage(playerid,GRÜN,string);
  19. format(query,sizeof(query),"DELETE FROM gutschein WHERE Code = %s",Code);
  20. mysql_function_query(dbhandle,query,false,"","");
  21. return 1;
  22. }
  23.  
  24.  
  25. [13:36:30] [DEBUG] mysql_tquery - connection: 1, query: "DELETE FROM gutschein WHERE Code = ABC", callback: "(null)", format: "(null)"
  26. [13:36:30] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
  27. [13:36:30] [DEBUG] CMySQLQuery::Execute[] - starting query execution
  28. [13:36:30] [ERROR] CMySQLQuery::Execute[] - (error #1054) Unknown column 'ABC' in 'where clause'
  29. [13:36:30] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement