Offline |
![Jómunkásember Jómunkásember](./images/ranks/hl16.png) |
Csatlakozott: 2014.01.04. 18:31 Hozzászólások: 326
Megköszönt másnak: 79 alkalommal Megköszönték neki: 7 alkalommal
|
Hello.Ezt a mentést alfaanero topicjából hoztam létre.Az lenne a kérdésem ,hogyan tudnék még több értéket menteni,mert ha írok még hozzá nem fordul le ,mert túl hosszú lesz. #include <amxmodx> #include <sqlx> new arany[33] new kulcs[33] new olesek[33] new szint[33] new lada[15][33] new const SQL_INFO[][] = { "sds", // HOST "dsds", // USERNAME "ds", // PASSWORD "adss" // DATABASE } new Handle:g_SqlTuple; new name[33][32] public plugin_cfg() { new Query[512]; g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) formatex(Query, charsmax(Query), "CREATE TABLE IF NOT EXISTS `tabla_neve2` (`username` varchar(32) NOT NULL, `arany_ertek` int(11) NOT NULL,`oles_ertek` INT(11) NOT NULL, `szint_ertek` INT(11) NOT NULL, `kulcs_ertek` INT(11) NOT NULL, `lada1_ertek` INT(11) NOT NULL, `lada2_ertek` INT(11) NOT NULL, `lada3_ertek` INT(11) NOT NULL, `lada4_ertek` INT(11) NOT NULL, `lada5_ertek` INT(11) NOT NULL,`lada6_ertek` INT(11) NOT NULL,`lada7_ertek` INT(11) NOT NULL)") 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)) load(id) } } public load(id) { new Query[512], Data[1] Data[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `tabla_neve2` WHERE username = ^"%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) { arany[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "arany_ertek")) olesek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles_ertek")) szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "szint_ertek")) kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kulcs_ertek")) lada[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada1_ertek")) lada[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada2_ertek")) lada[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada3_ertek")) lada[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada4_ertek")) lada[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada5_ertek")) lada[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada6_ertek")) lada[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "lada7_ertek")) } else { save(id) } } } public save(id) { new text[512]; formatex(text, charsmax(text), "INSERT INTO `tabla_neve2` (`username`, `arany_ertek`, `oles_ertek`, `szint_ertek`, `kulcs_ertek`, `lada1_ertek`, `lada2_ertek`, `lada3_ertek`, `lada4_ertek`, `lada5_ertek`, `lada6_ertek`, `lada7_ertek`) VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^");", 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 text[512]; formatex(text, charsmax(text), "UPDATE `tabla_neve2` SET arany_ertek = ^"%i^", oles_ertek = ^"%i^", szint_ertek = ^"%i^", kulcs_ertek = ^"%i^", lada1_ertek = ^"%i^", lada2_ertek = ^"%i^", lada3_ertek = ^"%i^", lada4_ertek = ^"%i^", lada5_ertek = ^"%i^", lada6_ertek = ^"%i^", lada7_ertek = ^"%i^" WHERE username = ^"%s^";", arany[id],olesek[id],szint[id],kulcs[id],lada[0][id],lada[1][id],lada[2][id],lada[3][id],lada[4][id],lada[5][id],lada[6][id], name[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", text) } public client_disconnect(id) { if(!is_user_bot(id)) { update(id) } arany[id] = 0 olesek[id] = 0 szint[id] = 0 kulcs[id] = 0 arrayset( lada[ id ], 0, sizeof ( lada[] ) ) copy(name[id], charsmax(name[]), "") } public plugin_end() { SQL_FreeHandle(g_SqlTuple) }
|
|