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
|
public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]) new query[2048]; new Len; Len += formatex(query[Len], charsmax(query), "CREATE TABLE IF NOT EXISTS `global_mode`") 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), ",tabla[0],tabla[1],tabla[2],tabla[3],tabla[4],tabla[5],tabla[6],tabla[7],tabla[8],tabla[9]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[10],tabla[11],tabla[12],tabla[13],tabla[14],tabla[15],tabla[16],tabla[17],tabla[18],tabla[19]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[20],tabla[21],tabla[22],tabla[23],tabla[24],tabla[25],tabla[26],tabla[27],tabla[28],tabla[29]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[30],tabla[31],tabla[32],tabla[33],tabla[34],tabla[35],tabla[36],tabla[37],tabla[38],tabla[39]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[40],tabla[41],tabla[42],tabla[43],tabla[44],tabla[45],tabla[46],tabla[47],tabla[48],tabla[49]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[50],tabla[51],tabla[52],tabla[53],tabla[54],tabla[55],tabla[56],tabla[57],tabla[58],tabla[59]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[60],tabla[61],tabla[62],tabla[63],tabla[64],tabla[65],tabla[66],tabla[67],tabla[68],tabla[69]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[70],tabla[71],tabla[72],tabla[73],tabla[74],tabla[75],tabla[76],tabla[77],tabla[78],tabla[79]) Len += formatex(query[Len], charsmax(query)-Len, " `%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[80],tabla[81],tabla[82],tabla[83],tabla[84],tabla[85],tabla[86],tabla[87],tabla[88],tabla[89]) Len += formatex(query[Len], charsmax(query)-Len, " `%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), `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY ) ",tabla[90],tabla[91],tabla[92],tabla[93],tabla[94],tabla[95],tabla[96],tabla[97],tabla[98],tabla[99]) 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) skinkapcs[id] = true belepve[id] = false arany[id] = 0 olesek[id] = 0 szint[id] = 0 kulcs[id] = 0 ak47skin[0][id] = 0 ak47skin[1][id] = 0 ak47skin[2][id] = 0 ak47skin[3][id] = 0 ak47skin[4][id] = 0 ak47skin[5][id] = 0 ak47skin[6][id] = 0 ak47skin[7][id] = 0 ak47skin[8][id] = 0 ak47skin[9][id] = 0 ak47skin[10][id] = 0 ak47skin[11][id] = 0 ak47skin[12][id] = 0 ak47skin[13][id] = 0 awpskin[0][id] = 0 awpskin[1][id] = 0 awpskin[2][id] = 0 awpskin[3][id] = 0 awpskin[4][id] = 0 awpskin[5][id] = 0 awpskin[6][id] = 0 awpskin[7][id] = 0 awpskin[8][id] = 0 awpskin[9][id] = 0 awpskin[10][id] = 0 awpskin[11][id] = 0 awpskin[12][id] = 0 awpskin[13][id] = 0 m4a1skin[0][id] = 0 m4a1skin[1][id] = 0 m4a1skin[2][id] = 0 m4a1skin[3][id] = 0 m4a1skin[4][id] = 0 m4a1skin[5][id] = 0 m4a1skin[6][id] = 0 m4a1skin[7][id] = 0 m4a1skin[8][id] = 0 m4a1skin[9][id] = 0 m4a1skin[10][id] = 0 m4a1skin[11][id] = 0 m4a1skin[12][id] = 0 m4a1skin[13][id] = 0 kesskin[0][id] = 0 kesskin[1][id] = 0 kesskin[2][id] = 0 kesskin[3][id] = 0 kesskin[4][id] = 0 kesskin[5][id] = 0 kesskin[6][id] = 0 kesskin[7][id] = 0 kesskin[8][id] = 0 kesskin[9][id] = 0 kesskin[10][id] = 0 kesskin[11][id] = 0 kesskin[12][id] = 0 kesskin[13][id] = 0 kesskin[14][id] = 0 kesskin[15][id] = 0 kesskin[16][id] = 0 kesskin[17][id] = 0 deagleskin[0][id] = 0 deagleskin[1][id] = 0 deagleskin[2][id] = 0 deagleskin[3][id] = 0 deagleskin[4][id] = 0 deagleskin[5][id] = 0 deagleskin[6][id] = 0 deagleskin[7][id] = 0 deagleskin[8][id] = 0 deagleskin[9][id] = 0 uspskin[0][id] = 0 uspskin[1][id] = 0 uspskin[2][id] = 0 uspskin[3][id] = 0 uspskin[4][id] = 0 uspskin[5][id] = 0 uspskin[6][id] = 0 uspskin[7][id] = 0 uspskin[8][id] = 0 famasskin[0][id] = 0 famasskin[1][id] = 0 famasskin[2][id] = 0 famasskin[3][id] = 0 famasskin[4][id] = 0 famasskin[5][id] = 0 famasskin[6][id] = 0 } } public load(id) { new Query[2048], Data[1] Data[0] = id formatex(Query, charsmax(Query), "SELECT * FROM `global_mode` 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_e")) olesek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "oles_e")) szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "szint_e")) kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kulcs_e")) lada[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la0_e")) lada[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la1_e")) lada[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la2_e")) lada[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la3_e")) lada[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la4_e")) lada[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la5_e")) lada[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la6_e")) lada[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la7_e")) lada[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la8_e")) lada[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la9_e")) lada[10][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la10_e")) lada[11][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la11_e")) lada[12][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la12_e")) lada[13][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la13_e")) lada[14][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la14_e")) lada[15][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "la15_e")) ak47skin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak1_e")) ak47skin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak2_e")) ak47skin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak3_e")) ak47skin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak4_e")) ak47skin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak5_e")) ak47skin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak6_e")) ak47skin[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak7_e")) ak47skin[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak8_e")) ak47skin[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak9_e")) ak47skin[10][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak10_e")) ak47skin[11][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak11_e")) ak47skin[12][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak12_e")) ak47skin[13][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak13_e")) awpskin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp1_e")) awpskin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp2_e")) awpskin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp3_e")) awpskin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp4_e")) awpskin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp5_e")) awpskin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp6_e")) awpskin[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp7_e")) awpskin[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp8_e")) awpskin[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp9_e")) awpskin[10][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp10_e")) awpskin[11][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp11_e")) awpskin[12][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp12_e")) awpskin[13][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "wp13_e")) m4a1skin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m41_e")) m4a1skin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m42_e")) m4a1skin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m43_e")) m4a1skin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m44_e")) m4a1skin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m45_e")) m4a1skin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m46_e")) m4a1skin[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m47_e")) m4a1skin[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m48_e")) m4a1skin[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m49_e")) m4a1skin[10][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m410_e")) m4a1skin[11][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m411_e")) m4a1skin[12][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m412_e")) m4a1skin[13][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m413_e")) deagleskin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg1_e")) deagleskin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg2_e")) deagleskin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg3_e")) deagleskin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg4_e")) deagleskin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg5_e")) deagleskin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg6_e")) deagleskin[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg7_e")) deagleskin[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg8_e")) deagleskin[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "dg9_e")) kesskin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k1_e")) kesskin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k2_e")) kesskin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k3_e")) kesskin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k4_e")) kesskin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k5_e")) kesskin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k6_e")) kesskin[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k7_e")) kesskin[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k8_e")) kesskin[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k9_e")) kesskin[10][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k10_e")) kesskin[11][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k11_e")) kesskin[12][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k12_e")) kesskin[13][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k13_e")) kesskin[14][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k14_e")) kesskin[15][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k15_e")) kesskin[16][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k16_e")) kesskin[17][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "k17_e")) uspskin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u1_e")) uspskin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u2_e")) uspskin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u3_e")) uspskin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u4_e")) uspskin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u5_e")) uspskin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u6_e")) uspskin[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u7_e")) uspskin[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "u8_e")) famasskin[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "f1_e")) famasskin[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "f2_e")) famasskin[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "f3_e")) famasskin[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "f4_e")) famasskin[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "f5_e")) famasskin[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "f6_e")) } else { save(id) } } } public save(id) { new Query[2048]; new Len; Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `global_mode` ") Len += formatex(Query[Len], charsmax(Query)-Len, "(`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[0],tabla[1],tabla[2],tabla[3],tabla[4],tabla[5],tabla[6],tabla[7],tabla[8],tabla[9]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[10],tabla[11],tabla[12],tabla[13],tabla[14],tabla[15],tabla[16],tabla[17],tabla[18],tabla[19]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[20],tabla[21],tabla[22],tabla[23],tabla[24],tabla[25],tabla[26],tabla[27],tabla[28],tabla[29]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[30],tabla[31],tabla[32],tabla[33],tabla[34],tabla[35],tabla[36],tabla[37],tabla[38],tabla[39]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[40],tabla[41],tabla[42],tabla[43],tabla[44],tabla[45],tabla[46],tabla[47],tabla[48],tabla[49]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[50],tabla[51],tabla[52],tabla[53],tabla[54],tabla[55],tabla[56],tabla[57],tabla[58],tabla[59]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[60],tabla[61],tabla[62],tabla[63],tabla[64],tabla[65],tabla[66],tabla[67],tabla[68],tabla[69]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[70],tabla[71],tabla[72],tabla[73],tabla[74],tabla[75],tabla[76],tabla[77],tabla[78],tabla[79]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, ",tabla[80],tabla[81],tabla[82],tabla[83],tabla[84],tabla[85],tabla[86],tabla[87],tabla[88],tabla[89]) Len += formatex(Query[Len], charsmax(Query)-Len, " `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s`, `%s` ) VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ",tabla[90],tabla[91],tabla[92],tabla[93],tabla[94],tabla[95],tabla[96],tabla[97],tabla[98],tabla[99],name[id]) Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ") Len += formatex(Query[Len], charsmax(Query)-Len, " ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"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[2048]; new Len; Len += formatex(Query[Len], charsmax(Query), "UPDATE `global_mode` ") 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^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[13],lada[8][id], tabla[14],lada[9][id], tabla[15],lada[10][id], tabla[16],lada[11][id], tabla[17],lada[12][id], tabla[18],lada[13][id], tabla[19],lada[14][id], tabla[20],ak47skin[1][id], tabla[21],ak47skin[2][id], tabla[22],ak47skin[3][id], tabla[23],ak47skin[4][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[24],ak47skin[5][id], tabla[25],ak47skin[6][id], tabla[26],ak47skin[7][id], tabla[27],ak47skin[8][id], tabla[28],ak47skin[9][id], tabla[29],ak47skin[10][id], tabla[30],ak47skin[11][id], tabla[31],ak47skin[12][id], tabla[32],ak47skin[13][id], tabla[33],awpskin[1][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[34],awpskin[2][id], tabla[35],awpskin[3][id], tabla[36],awpskin[4][id], tabla[37],awpskin[5][id], tabla[38],awpskin[6][id], tabla[39],awpskin[7][id], tabla[40],awpskin[8][id], tabla[41],awpskin[9][id], tabla[42],awpskin[10][id], tabla[43],awpskin[11][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[44],awpskin[12][id], tabla[45],awpskin[13][id], tabla[46],m4a1skin[1][id], tabla[47],m4a1skin[2][id], tabla[48],m4a1skin[3][id], tabla[49],m4a1skin[4][id], tabla[50],m4a1skin[5][id], tabla[51],m4a1skin[6][id], tabla[52],m4a1skin[7][id], tabla[53],m4a1skin[8][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[54],m4a1skin[9][id], tabla[55],m4a1skin[10][id], tabla[56],m4a1skin[11][id], tabla[57],m4a1skin[12][id], tabla[58],m4a1skin[13][id], tabla[59],deagleskin[1][id], tabla[60],deagleskin[2][id], tabla[61],deagleskin[3][id], tabla[62],deagleskin[4][id], tabla[63],deagleskin[5][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[64],deagleskin[6][id], tabla[65],deagleskin[7][id], tabla[66],deagleskin[8][id], tabla[67],deagleskin[9][id], tabla[68],kesskin[1][id], tabla[69],kesskin[2][id], tabla[70],kesskin[3][id], tabla[71],kesskin[4][id], tabla[72],kesskin[5][id], tabla[73],kesskin[6][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[74],kesskin[7][id], tabla[75],kesskin[8][id], tabla[76],kesskin[9][id], tabla[77],kesskin[10][id], tabla[78],kesskin[11][id], tabla[79],kesskin[12][id], tabla[80],kesskin[13][id], tabla[81],kesskin[14][id], tabla[82],kesskin[15][id], tabla[83],kesskin[16][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", ", tabla[84],kesskin[17][id], tabla[85],uspskin[1][id], tabla[86],uspskin[2][id], tabla[87],uspskin[3][id], tabla[88],uspskin[4][id], tabla[89],uspskin[5][id], tabla[90],uspskin[6][id], tabla[91],uspskin[7][id], tabla[92],uspskin[8][id], tabla[93],famasskin[1][id]) Len += formatex(Query[Len], charsmax(Query)-Len, " %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^" WHERE username = ^"%s^"; ", tabla[94],famasskin[2][id], tabla[95],famasskin[3][id], tabla[96],famasskin[4][id], tabla[97],famasskin[5][id], tabla[98],famasskin[6][id], tabla[99],lada[15][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 ak47skin[0][id] = 0 ak47skin[1][id] = 0 ak47skin[2][id] = 0 ak47skin[3][id] = 0 ak47skin[4][id] = 0 ak47skin[5][id] = 0 ak47skin[6][id] = 0 ak47skin[7][id] = 0 ak47skin[8][id] = 0 ak47skin[9][id] = 0 ak47skin[10][id] = 0 ak47skin[11][id] = 0 ak47skin[12][id] = 0 ak47skin[13][id] = 0 awpskin[0][id] = 0 awpskin[1][id] = 0 awpskin[2][id] = 0 awpskin[3][id] = 0 awpskin[4][id] = 0 awpskin[5][id] = 0 awpskin[6][id] = 0 awpskin[7][id] = 0 awpskin[8][id] = 0 awpskin[9][id] = 0 awpskin[10][id] = 0 awpskin[11][id] = 0 awpskin[12][id] = 0 awpskin[13][id] = 0 m4a1skin[0][id] = 0 m4a1skin[1][id] = 0 m4a1skin[2][id] = 0 m4a1skin[3][id] = 0 m4a1skin[4][id] = 0 m4a1skin[5][id] = 0 m4a1skin[6][id] = 0 m4a1skin[7][id] = 0 m4a1skin[8][id] = 0 m4a1skin[9][id] = 0 m4a1skin[10][id] = 0 m4a1skin[11][id] = 0 m4a1skin[12][id] = 0 m4a1skin[13][id] = 0 kesskin[0][id] = 0 kesskin[1][id] = 0 kesskin[2][id] = 0 kesskin[3][id] = 0 kesskin[4][id] = 0 kesskin[5][id] = 0 kesskin[6][id] = 0 kesskin[7][id] = 0 kesskin[8][id] = 0 kesskin[9][id] = 0 kesskin[10][id] = 0 kesskin[11][id] = 0 kesskin[12][id] = 0 kesskin[13][id] = 0 kesskin[14][id] = 0 kesskin[15][id] = 0 kesskin[16][id] = 0 kesskin[17][id] = 0 deagleskin[0][id] = 0 deagleskin[1][id] = 0 deagleskin[2][id] = 0 deagleskin[3][id] = 0 deagleskin[4][id] = 0 deagleskin[5][id] = 0 deagleskin[6][id] = 0 deagleskin[7][id] = 0 deagleskin[8][id] = 0 deagleskin[9][id] = 0 uspskin[0][id] = 0 uspskin[1][id] = 0 uspskin[2][id] = 0 uspskin[3][id] = 0 uspskin[4][id] = 0 uspskin[5][id] = 0 uspskin[6][id] = 0 uspskin[7][id] = 0 uspskin[8][id] = 0 famasskin[0][id] = 0 famasskin[1][id] = 0 famasskin[2][id] = 0 famasskin[3][id] = 0 famasskin[4][id] = 0 famasskin[5][id] = 0 famasskin[6][id] = 0 copy(name[id], charsmax(name[]), "") } public plugin_end() { SQL_FreeHandle(g_SqlTuple) }
|
|