Offline |
|
|
Csatlakozott: 2014.04.10. 15:32 Hozzászólások: 776
Megköszönt másnak: 122 alkalommal Megköszönték neki: 60 alkalommal
|
Hello. Ez így miért nem csinál semmit? #include <amxmodx> #include <sqlx> #define PLUGIN "New Plug-In" #define VERSION "1.0" #define AUTHOR "author" new arany[33], kulcs[33], szint[33], olesek[33] new const tabla[][] = { "Nev", "Arany", "Kill", "Szint", "Kulcs", "ID" } new const SQL_INFO[][] = { "", // HOST "", // USERNAME "", // PASSWORD "" // DATABASE } new Handle:g_SqlTuple; new name[33][32] public plugin_init() { register_plugin(PLUGIN, VERSION, AUTHOR) // Add your code here... } 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 `teszt_mod1` (`%s` varchar(32) NOT NULL, `%s` INT(11) NOT NULL, `%s` INT(11) NOT NULL, `%s` INT(11) NOT NULL, `%s` INT(11) NOT NULL, `%s` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)",tabla[0],tabla[1],tabla[2],tabla[3],tabla[4],tabla[5]) 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 `teszt_mod1` WHERE %s = ^"%s^";", tabla[0],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")) olesek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kill")) szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint")) kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs")) } else { save(id) } } } public save(id) { new Query[1024]; new Len; Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `teszt_mod1` ") Len += formatex(Query[Len], charsmax(Query)-Len, "(`%s`, `%s`, `%s`, `%s`, `%s`) VALUES (^"%s^", ^"%s^", ^"%s^", ^"%s^", ^"%s^", ^"0^",^"0^",^"0^",^"0^",^"0^");", tabla[0], tabla[1], tabla[2], tabla[3], tabla[4], name[id]) 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 text[512]; formatex(text, charsmax(text), "UPDATE `teszt_mod1` SET %s = ^"%i^", SET %s = ^"%i^", SET %s = ^"%i^", SET %s = ^"%i^" WHERE username = ^"%s^";", tabla[1],arany[id], tabla[2],olesek[id],tabla[3], szint[id], tabla[4], kulcs[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 name[id][0] = EOS; } public plugin_end() { SQL_FreeHandle(g_SqlTuple) }
_________________
|
|