22.07.2016, 12:01
Quote:
Try...
Код:
CMD:changepass(playerid,params[]) { new query[313], name[24], WPhash[145], Cache: Result, GetOldPass[145], OldPass[60], NewPass[60]; if(sscanf(params, "s[60]s[60]", OldPass, NewPass)) return SendClientMessage(playerid, COLOR_WHITE, "USAGE: /changepass (Old Password) (New Password)"); GetPlayerName(playerid, name,24); mysql_format(koneksi, query, sizeof(query), "SELECT `password` FROM `player` WHERE `name` = '%s'", name); Result = mysql_query(koneksi, query); if(cache_num_rows()) cache_get_field_content(0, "password`", GetOldPass); cache_delete(Result); WP_Hash(WPhash, sizeof(WPhash), OldPass); if(strcmp(WPhash, GetOldPass, false) == 0) { WP_Hash(WPhash, sizeof(WPhash), NewPass); mysql_format(koneksi, query, sizeof(query), "UPDATE `player` SET `password` = '%s' WHERE `name` = '%s'", WPhash, name); mysql_query(koneksi, query, false); SendClientMessage(playerid, COLOR_GREEN, "Password Changed!"); } else SendClientMessage(playerid, COLOR_GREEN, "Old Password is Wrong!"); return 1; } |
And Get Error In Mysql
Код HTML:
16:28:09 CMySQLResult::GetRowDataByName WARNING field not found ("password`")