Advertisement
Guest User

Untitled

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