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
|
Hali! Van ez a MySQL, és el szeretném menteni a Skin-t de azt már nem tudom hogyan, valaki segítene? Előre is köszönom public plugin_cfg() { new Query[2048], 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 `tabla_neve`") Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ") Len += formatex(Query[Len], charsmax(Query)-Len, "`oles` int(11) NOT NULL, ") Len += formatex(Query[Len], charsmax(Query)-Len, "`skinek` int(11) NOT NULL, ") Len += formatex(Query[Len], charsmax(Query)-Len, "`szint` int(11), `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) { new Query[1024], Data[1], Len; Data[0] = id Len += formatex(Query[Len], charsmax(Query), "SELECT * FROM `tabla_neve` ") Len += formatex(Query[Len], charsmax(Query)-Len, "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) { Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles")) Szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "szint")) Skin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "skinek")) } else { save(id) } } } public save(id) { new Query[1024] new Len; Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `tabla_neve` ") Len += formatex(Query[Len], charsmax(Query)-Len,"(`Nev`, `oles`, "); Len += formatex(Query[Len], charsmax(Query)-Len,"`szint`, `%s`, `%s`, `%s`, `%s` ) VALUES (^"%s^", ", Oles[id], Szint[id], SkinNevek[0], SkinNevek[1], SkinNevek[2], SkinNevek[3], name[id]) Len += formatex(Query[Len], charsmax(Query)-Len, "^"0^", ^"0^", ^"0^", ^"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(id) { new Query[1024] new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `tabla_neve` ") Len += formatex(Query[Len], charsmax(Query)-Len, " SET oles = ^"%i^", ", Oles[id]) Len += formatex(Query[Len], charsmax(Query)-Len, " szint = ^"%i^" WHERE Nev = ^"%s^"; ", Szint[id], name[id]) for(new i;i < sizeof(SkinNevek); i++) { Len += formatex(Query[Len], charsmax(Query)-Len, "Fegyver%d = ^"%i^",",i , Skin[i][id]) } SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query) } public plugin_end() { SQL_FreeHandle(g_SqlTuple) } public client_putinserver(id) { if(!is_user_bot(id)) { get_user_name(id, name[id], charsmax(name)) load(id) } } public client_disconnect(id) { if(!is_user_bot(id)) { get_user_name(id, name[id], charsmax(name)) update(id) } copy(name[id], charsmax(name[]), "") }
_________________ Global Offensive: (50%)
|
|