Guest User

Untitled

a guest
Jul 18th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. public GetSkinInventory(Handle:db, client)
  2. {
  3. if (db == INVALID_HANDLE) {
  4. PrintToServer("[GetCredits] Database not valid!");
  5. return -1;
  6. }
  7.  
  8. new String:steamid[64];
  9. if (!GetClientAuthString(client, steamid, sizeof(steamid))) {
  10. PrintToServer("[GetCredits] GetClientAuthString failed!");
  11. }
  12.  
  13. new String:qstr[128];
  14. Format(qstr, sizeof(qstr), "SELECT skinsyo FROM creditswirl WHERE steamid='%s'", steamid);
  15. SQL_LockDatabase(db); new Handle:query = SQL_Query(db, qstr); SQL_UnlockDatabase(db);
  16. if (query == INVALID_HANDLE)
  17. {
  18. PrintToServer("[GetCredits] SQL_Query failed!");
  19. return -1;
  20. }
  21.  
  22. if (SQL_GetRowCount(query) > 1) {
  23. PrintToServer("[GetCredits] SteamID has multiple entires!");
  24. CloseHandle(query);
  25. return -1;
  26. } else {
  27. if (!SQL_FetchRow(query)) {
  28. CloseHandle(query);
  29. return -1;
  30. }
  31. else {
  32. new val = SQL_FetchInt(query, 0);
  33. CloseHandle(query);
  34. return val;
  35. }
  36. }
  37. }
Add Comment
Please, Sign In to add comment