Offline |
|
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
|
Köszönöm az eddigi segítséget. Létrehozza a táblát minden jó ,lemegyek frissítem az adatbázist látom,hogy amim volt megvan,de ha felmegyek nem kapom meg szóval 0-ról indulok #include <amxmodx> #include <sqlx> new Handle:g_SqlTuple; new name[33][32] new arany[33], kulcs[33], olesek[33], szint[33] new lada[10][33] new const tabla[][] = { "username",//0 "arany_ertek",//1 "oles_ertek",//2 "szint_ertek",//3 "kulcs_ertek",//4 "lada0_ertek",//5 "lada1_ertek",//6 "lada2_ertek",//7 "lada3_ertek",//8 "lada4_ertek",//9 "lada5_ertek",//10 "lada6_ertek",//11 "lada7_ertek",//12 "lada8_ertek",//13 "lada9_ertek"//14 } new const SQL_INFO[][] = { "ds", // HOST "sds", // USERNAME "sd", // PASSWORD "ds" // DATABASE } public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) new Query[1024]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `beta_4` ") Len += formatex(Query[Len], charsmax(Query)-Len, "(`%s` varchar(32) NOT NULL, `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11) )",tabla[0],tabla[1],tabla[2],tabla[3],tabla[4],tabla[5],tabla[6],tabla[7],tabla[8],tabla[9],tabla[10],tabla[11],tabla[12],tabla[13],tabla[14]) 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 `beta_4` 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, "%s"),tabla[1]) olesek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[2]) szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[3]) kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[4]) lada[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[5]) lada[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[6]) lada[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[7]) lada[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[8]) lada[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[9]) lada[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[10]) lada[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s"),tabla[11]) lada[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s") ,tabla[12]) lada[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s") ,tabla[13]) lada[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "%s") ,tabla[14]) } else { save(id) } } } public save(id) { new Query[1024]; new Len; Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `beta_4` ") Len += formatex(Query[Len], charsmax(Query)-Len, "(`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s` ) VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^");",tabla[0],tabla[1],tabla[2],tabla[3],tabla[4],tabla[5],tabla[6],tabla[7],tabla[8],tabla[9],tabla[10],tabla[11],tabla[12],tabla[13],tabla[14], 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 Query[1024]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `beta_4` ") Len += formatex(Query[Len], charsmax(Query)-Len, " SET %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ",tabla[1],arany[id], tabla[2],olesek[id], tabla[3],szint[id], tabla[4],kulcs[id], tabla[5],lada[0][id], tabla[6],lada[1][id], tabla[7],lada[2][id], tabla[8],lada[3][id], tabla[9],lada[4][id], tabla[10],lada[5][id], tabla[11],lada[6][id], tabla[12],lada[7][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^" WHERE username = ^"%s^";", tabla[13],lada[8][id], tabla[14],lada[9][id], name[id]) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query) } 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) }
|
|