Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public GetSkinInventory(Handle:db, client)
- {
- if (db == INVALID_HANDLE) {
- PrintToServer("[GetCredits] Database not valid!");
- return -1;
- }
- new String:steamid[64];
- if (!GetClientAuthString(client, steamid, sizeof(steamid))) {
- PrintToServer("[GetCredits] GetClientAuthString failed!");
- }
- new String:qstr[128];
- Format(qstr, sizeof(qstr), "SELECT skinsyo FROM creditswirl WHERE steamid='%s'", steamid);
- SQL_LockDatabase(db); new Handle:query = SQL_Query(db, qstr); SQL_UnlockDatabase(db);
- if (query == INVALID_HANDLE)
- {
- PrintToServer("[GetCredits] SQL_Query failed!");
- return -1;
- }
- if (SQL_GetRowCount(query) > 1) {
- PrintToServer("[GetCredits] SteamID has multiple entires!");
- CloseHandle(query);
- return -1;
- } else {
- if (!SQL_FetchRow(query)) {
- CloseHandle(query);
- return -1;
- }
- else {
- new val = SQL_FetchInt(query, 0);
- CloseHandle(query);
- return val;
- }
- }
- }
Add Comment
Please, Sign In to add comment