Offline |
|
|
Csatlakozott: 2018.02.01. 16:27 Hozzászólások: 225
Megköszönt másnak: 14 alkalommal Megköszönték neki: 18 alkalommal
|
Üdv! Olyan problémám volna hogy nem igazán akar működni a mentés, ez alatt azt értem hogy: Nem minden játékosnak menti el a dolgát, pl: 5 játékosnak elmenti, 3-nak meg nem... Előre is köszönöm a segítséget... public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) static Query[10048]; NEW Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `beta_awp` "); Len += formatex(Query[Len], charsmax(Query)-Len, "(`JATEKOSNEV` varchar(32) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`XP` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`SZINT` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`OLES` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`PONT` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`HALAL` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FEJLOVES` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`CSAVAR` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`RUGO` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FEGYVERTUS` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FEGYVEREGY` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FEGYVERKETTO` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FEGYVERHAROM` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`FEGYVERNEGY` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`ELOLVAS` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`REGISZTRALT` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`PERCEK` int(11) 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 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 client_putinserver(id) { IF(!is_user_bot(id)) get_user_name(id, name[id], charsmax(name)) regisztralas_betoltese(id) LOAD(id) } public client_disconnect(id) { IF(!is_user_bot(id)) regisztralas_mentese(id) UPDATE(id) } public client_connect(id) { NEW nm[32] get_user_name(id, nm, 31) regisztralas_betoltese(id) kapcsolo[id] = TRUE } public LOAD(id) { NEW Query[512], DATA[1] DATA[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `beta_awp` WHERE JATEKOSNEV = ^"%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) { Xp[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "XP")) Szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SZINT")) Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "OLES")) Pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "PONT")) Halal[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "HALAL")) Fejloves[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FEJLOVES")) Csavar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "CSAVAR")) Rugo[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "RUGO")) FegyverTus[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FEGYVERTUS")) awp[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FEGYVEREGY")) kes[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FEGYVERKETTO")) awp[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FEGYVERHAROM")) kes[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "FEGYVERNEGY")) Elolvas[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ELOLVAS")) reg_pont[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "REGISZTRALT")) Perc[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "PERCEK")) } ELSE { save(id) } } } public save(id) { NEW text[512]; formatex(text, charsmax(text), "INSERT INTO `beta_awp` (`JATEKOSNEV`) VALUES (^"%s^");", name[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text) } 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[512], Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE beta_awp SET "); Len += formatex(Query[Len], charsmax(Query)-Len, "XP = %i, ", Xp[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "SZINT = %i, ", Szint[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "OLES = %i, ", Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "HALAL = %i, ", Halal[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FEJLOVES = %i, ", Fejloves[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "CSAVAR = %i, ", Csavar[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "RUGO = %i, ", Rugo[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FEGYVERTUS = %i, ", FegyverTus[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FEGYVEREGY = %i, ", awp[1][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FEGYVERKETTO = %i, ", kes[1][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FEGYVERHAROM = %i, ", awp[2][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "FEGYVERNEGY = %i, ", kes[2][id]); Len += formatex(Query[Len], charsmax(Query)-Len, "ELOLVAS = %i, ", Elolvas[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "REGISZTRALT = %i, ", reg_pont[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "PERCEK = %i, ", Perc[id]+get_user_time(id)); Len += formatex(Query[Len], charsmax(Query)-Len, "PONT = %i WHERE JATEKOSNEV = ^"%s^";", Pont[id], name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public plugin_end() { SQL_FreeHandle(g_SqlTuple) }
|
|