Offline |
|
Csatlakozott: 2016.01.17. 07:11 Hozzászólások: 296
Megköszönt másnak: 60 alkalommal Megköszönték neki: 11 alkalommal
|
Üdv! Lylechriss cs:go modjába találtam ezt az sql mentést, és az a baj vele hogy nem menti el a többit, Csak a Flames M4A1-t, meg a Chroma Case 2, csak ezeket menti le, de a többit nem. Valaki tudna segíteni? előre is köszönöm! new const SQL_INFO[][] = { "", "", "", "" } enum _:DATA { InSQL[32] } enum _: CASE_DATA { LadaInSQL[32] } new const LADANEVEK[][CASE_DATA] = { { "Chroma Case" }, { "Chroma Case 2" }, { "Falchion Case" }, { "Huntsman Weapon Case" }, { "Operation Breakout Weapon Case" }, { "Shadow Case" } } new const SkinNevek[][DATA] = { { "Gifft Madár M4A1" }, { "Flames M4A1" }, { "BulletRain M4A1" }, { "Guardian M4A1" }, { "Asiimov M4A1" }, { "Poseidon M4A1" }, { "Dragon King M4A1" }, { "Zombie Hunter M4A1" }, { "Hyper Beast M4A1" }, { "Howl M4A1" }, { "Magma M4A1" } } public plugin_cfg() { static Query[5120], Len g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `g_offen` (`authid` varchar(32) NOT NULL, `username` varchar(32) NOT NULL") for(new i; i<sizeof(SkinNevek);i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `%s` int(11) NOT NULL", SkinNevek[i][InSQL]) } for(new i; i<sizeof(LADANEVEK);i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `%s` int(11) NOT NULL", LADANEVEK[i][LadaInSQL]) } Len += formatex(Query[Len], charsmax(Query)-Len, ", `pontok` 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 tudtam csatlakozni az adatbazishoz."); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("Hibat dobtam: %s",Error); } public load(id) { static Query[5120], 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]; if(SQL_NumRows(Query) > 0) { for(new i; i<sizeof(SkinNevek);i++) { Skin[id][i] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, SkinNevek[i][InSQL])) } for(new i; i<sizeof(LADANEVEK);i++) { Lada[id][i] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, LADANEVEK[i][LadaInSQL])) } Pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "pontok")) } else { save(id) } } } public save(id) { static Query[5120], Len Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `g_offen` (`authid`, `username`") for(new i; i<sizeof(SkinNevek);i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `%s`", SkinNevek[i][InSQL]) } for(new i; i<sizeof(LADANEVEK); i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `%s`", LADANEVEK[i][LadaInSQL]) } Len += formatex(Query[Len], charsmax(Query)-Len, ", `pontok`) VALUES (^"%s^", ^"%s^"", authid[id], name[id]) for(new i;i<sizeof(SkinNevek);i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^"") } for(new i; i<sizeof(LADANEVEK); i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"0^"") } Len += formatex(Query[Len], charsmax(Query)-Len, ", ^"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(id) { static Query[5120], Len Len += formatex(Query[Len], charsmax(Query), "UPDATE `g_offen` SET `username` = ^"%s^"", name[id]) for(new i;i<sizeof(SkinNevek);i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `%s` = %d", SkinNevek[i][InSQL], Skin[i][id]) } for(new i;i<sizeof(LADANEVEK);i++) { Len += formatex(Query[Len], charsmax(Query)-Len, ", `%s` = %d", LADANEVEK[i][LadaInSQL], Lada[i][id]) } Len += formatex(Query[Len], charsmax(Query)-Len, ", `pontok` = %d WHERE `authid` = ^"%s^"; ", Pont[id], authid[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query) } public plugin_end() { SQL_FreeHandle(g_SqlTuple) } public client_putinserver(id) { Skins[id] = true if(!is_user_bot(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(id) } } public client_disconnect(id) { if(!is_user_bot(id)) { update(id) } authid[id][0] = EOS; name[id][0] = EOS; } public client_infochanged(id) { if(!is_user_connected(id)) return PLUGIN_HANDLED get_user_info(id, "name", name[id], charsmax(name[])) return PLUGIN_CONTINUE }
_________________ Global Offensive: (50%)
|
|