Offline |
|
|
Csatlakozott: 2016.01.30. 12:31 Hozzászólások: 112
Megköszönt másnak: 18 alkalommal Megköszönték neki: 5 alkalommal
|
Sok esély van rá hogy elrontottam mert még nem mentettem soha sql ben. Ha gépnél leszek felrakom. EDIT!: public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]); static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `uwill_deathmatch`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`M4Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`AKOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`AWPOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FAMASOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`MP5Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`M3Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`DEAGLEOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`USPOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`KESOles` int(11) NOT NULL,"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public Load(id) { static Query[10048]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `uwill_deathmatch` WHERE Nev = ^"%s^";", Name); 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]; if(SQL_NumRows(Query) > 0) { m4oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "M4Oles")); akoles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AKOles")); awpoles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "AWPOles")); famasoles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FAMASOles")); mp5oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "MP5Oles")) m3oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "M3Oles")) deagleoles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "DEAGLEOles")) uspoles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "USPOles")) kesoles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "KESOles")) } else { Save(id); } } } public Save(id) { static Query[256]; new Name[32]; get_user_name(id, Name, 31); formatex(Query, charsmax(Query), "INSERT INTO `uwill_deathmatch` (`Nev`) VALUES (^"%s^");", Name); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Update(id) { static Query[10048]; new Len; new Name[32]; get_user_name(id, Name, 31); Len += formatex(Query[Len], charsmax(Query), "UPDATE `uwill_deathmatch` SET M4Oles = ^"%i^", ",m4oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "AKOles = ^"%i^", ", akoles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "AWPOles = ^"%i^", ", awpoles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FAMASOles = ^"%i^", ", famasoles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "MP5Oles = ^"%i^", ", mp5oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "M3Oles = ^"%i^", ", m3oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "DEAGLEOles = ^"%i^", ", deagleoles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "USPOles = ^"%i^", ", uspoles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "KESOles = ^"%i^", ", kesoles[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) { if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!"); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("[HIBA*] HIBAT DOBTAM: %s",Error); } 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 client_putinserver(id) { if(!is_user_bot(id)) Load(id); } public client_disconnect(id) { if(!is_user_bot(id)) Update(id); return PLUGIN_HANDLED } public plugin_end() { SQL_FreeHandle(g_SqlTuple); }
Lehet nagy baromság, de elnézést, most próbáltam először
|
|