Offline |
|
|
Csatlakozott:2019.06.30. 09:50 Hozzászólások:29 Megköszönt másnak: 7 alkalommal Megköszönték neki: 3 alkalommal
|
Sziasztok írok egy onlyd2 módot/skinrendszert Sql mentést csinálom meg minden ezt az erort kapom mikor fordítom amxx re: Welcome to the AMX Mod X 1.8.1-300 Compiler. Copyright (c) 1997-2006 ITB CompuPhase, AMX Mod X Team Modified for www.freakz.ronewskin_reg_v2_sqk.txt(1133) : error 037: invalid string (possibly non-terminated string) newskin_reg_v2_sqk.txt(1133 -- 1135) : error 001: expected token: ",", but found "-identifier-" 2 Errors. Compile failed! Forráskód: } public Create_Table_Others() { static Query[148]; new Len;
Teljes sql: } } public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQLDAT[0], SQLDAT[1], SQLDAT[2], SQLDAT[3]); Create_Table_Register(); Create_Table_Others(); } public Create_Table_Register(){ static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `register_sv1`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Player_IP` varchar(35) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Player_SteamID` varchar(35) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public Create_Table_Others() { static Query[148]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `save_sv2`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Csomag` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`skinp` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Rang` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Vip` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`euro` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public Load(id) { static Query[256]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `save_sv2` WHERE Nev = ^"%s^";", name[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]; if(SQL_NumRows(Query) > 0) { Csomag[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Csomag")); Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles")); skinp[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "skinp")); Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Rang")); Vip[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vip")); euro[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "euro")); } else { Save(id); } } } public Load_Register(id){ static Query[10048]; new Data[1], Name[32]; get_user_name(id, Name, 31); Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `register_sv1` WHERE Nev = ^"%s^";", name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataRegister", Query, Data, 1); } public QuerySelectDataRegister(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) { } else { Save_Register(id); } } } public Save(id){ static Query[256]; formatex(Query, charsmax(Query), "INSERT INTO `save_sv2` (`Nev`) VALUES (^"%s^");", name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Save_Register(id){ static Query[256]; new sPlayer_IP[35], sPlayer_SteamID[35]; get_user_ip(id, sPlayer_IP, charsmax(sPlayer_IP), 1); get_user_authid(id, sPlayer_SteamID, charsmax(sPlayer_SteamID)); formatex(Query, charsmax(Query), "INSERT INTO `register_sv1` (`Nev`, `Player_IP`, `Player_SteamID` ) VALUES (^"%s^", ^"%s^", ^"%s^");", name[id], sPlayer_IP, sPlayer_SteamID); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public SQL_Update_Reg(id){ static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `register_sv1` ", "); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Update(id) { static Query[10048]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `save_sv2` SET euro = ^"%i^", ",euro[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Csomag = ^"%i^", ", Csomag[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "skinp = ^"%i^", ", skinp[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Rang = ^"%i^", ", Rang[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Vip = ^"%i^" WHERE Nev = ^"%s^";", Vip[id], name[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 plugin_end() { SQL_FreeHandle(g_SqlTuple); }
Segítségeteket előre is köszönöm! _________________ Knife mód Hamarosan! by Speedy
|
|