Offline |
|
Csatlakozott: 2016.08.13. 03:37 Hozzászólások: 10
Megköszönték neki: 1 alkalommal
|
Toretto írta: Hello ez igy miért nem ment? public plugin_cfg() { static Query[10048], Len; g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0],SQLINFO[1],SQLINFO[2],SQLINFO[3]); Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `g_offen` (`authid` varchar(32) NOT NULL, `username` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Jel` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`DLL` int(11) NOT NULL, `Regizve` int(11) NOT NULL, "); for(new i;i < 110; i++) { Len += formatex(Query[Len], charsmax(Query)-Len, "`W%d` int(11) NOT NULL, ", i); } for(new i;i < 6; i++){ Len += formatex(Query[Len], charsmax(Query)-Len, "`L%d` int(11) NOT NULL, ", i); } Len += formatex(Query[Len], charsmax(Query)-Len, "`OL` int(11) NOT NULL, `RG` int(11) NOT NULL, `KL` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple,"createTableThread", Query) } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("Nem lehet csatlakozni az adatbazishoz.") else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error") if(Errcode) log_amx("Hiba: %s",Error) } public client_putinserver(id) { if(!is_user_bot(id) && !is_user_hltv(id)) { get_user_name(id, name[id], charsmax(name)) get_user_authid(id, authid[id], charsmax(authid)) if(contain(authid[id], "_ID_LAN") != -1) get_user_ip(id, authid[id], charsmax(authid), 1) Load_SQL(id) } } public client_disconnect(id) { if(!is_user_bot(id) && !is_user_hltv(id)) Update_SQL(id) for(new i;i < 13; i++) Skin[i][id] = 0; authid[id][0] = EOS; name[id][0] = EOS; Gun[id] = 1; Registered[id] = 0; UserPassword[id] = ""; RegPassword[id] = ""; Loggedin[id] = false; Write[id] = false; Write2[id] = false; } public client_infochanged(id) { if(!is_user_connected(id)) return PLUGIN_HANDLED get_user_info(id, "name", name[id], charsmax(name[])) return PLUGIN_CONTINUE } public Load_SQL(id) { static Query[10048], Data[1]; Data[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `g_offen` WHERE authid = ^"%s^";", authid[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1) } public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error) return } else { new id = Data[0]; new kname[32]; if(SQL_NumRows(Query) > 0) { SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jel"), RegPassword[id], charsmax(RegPassword[])); Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DLL")); Registered[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regizve")); for(new i;i < 110; i++) { formatex(kname, charsmax(kname), "W%d", i); OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, kname)); } for(new i;i < 6; i++) { formatex(kname, charsmax(kname), "L%d", i); Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, kname)); } Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "OL")); Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "RG")); Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "KL")); } else Save_SQL(id); } } public Save_SQL(id) { static Query[10048], Len; Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `g_offen` (`authid`, `username`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Jel` ,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`DLL` , `Regizve` ,"); for(new i;i < 110; i++) { Len += formatex(Query[Len], charsmax(Query)-Len, "`W%d` ,", i); } for(new i;i < 6; i++) { Len += formatex(Query[Len], charsmax(Query)-Len, "`L%d` ,", i); } Len += formatex(Query[Len], charsmax(Query)-Len, "`OL` , `RG`, `KL`) VALUES (^"%s^", ^"%s^"", authid[id], name[id]); Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^""); Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^", ^"0^""); for(new i;i < 110;i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^""); } for(new i;i < 6; i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^""); } Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^",^"0^",^"0^");"); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query) } public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) { log_amx("%s", Error) return } } public Update_SQL(id) { static Query[10048], Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `g_offen` SET `username` = ^"%s^"", name[id]); Len += formatex(Query[Len], charsmax(Query)-Len, ", `Jel` = ^"%s^"", RegPassword[id]); Len += formatex(Query[Len], charsmax(Query)-Len, ", `DLL` = %d, `Regizve` = ^"%d^"", Dollar[id], Registered[id]); for(new i;i < 110; i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `W%d` = %d", i, OsszesSkin[i][id]); } for(new i;i < 6; i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `L%d` = %d", i, Lada[i][id]); } Len += formatex(Query[Len], charsmax(Query)-Len, ", `OL` = %d, `RG` = %d, `KL` = %d WHERE `authid` = ^"%s^";", Oles[id], Rang[id], Kulcs[id], authid[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query) }
Jo ez caak 1 - 2 hiba van benne ha gepen leszek javitom ! | Moderátori megjegyzés (mforce): | semmi értelmeset nem szóltál a témához. Hsz vadászat és off |
_________________ Global Offensive [15%][StatTrak*/130 Skin/ 9 Láda] DeathRun[5%][Kopás Rendszer/5 Láda / 40 Skin]
|
|