Offline |
|
|
Csatlakozott: 2015.07.21. 00:49 Hozzászólások: 178
Megköszönt másnak: 23 alkalommal Megköszönték neki: 20 alkalommal
|
Most meg mikor lefordítanám ezt adja be: Csatolmány:
névtelen.JPG [ 177.32 KiB | Megtekintve 208 alkalommal ]
public client_disconnect(id) { if(!is_user_bot(id)) { Update(id); } Gold[id] = 0; LvL[id] = 0; ExP[id] = 0; Skin[id] = 0; for(new i; i < MAX; i++) { Knifes[i][id] = 0; } copy(Name[id], charsmax(Name[]), ""); } public plugin_end() { SQL_FreeHandle(g_SqlTuple) } public plugin_cfg() { g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0],SQLINFO[1],SQLINFO[2],SQLINFO[3]); new Query[1024]; new Len; Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `oneshot_pb` "); Len += formatex(Query[Len], charsmax(Query)-Len, "(`%s` varchar(32) NOT NULL, `%s` INT(11), `%s` INT(11), "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s` INT(11), `%s` INT(11), `%s` INT(11), `%s` INT(11), "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s` INT(11) )", TABLE[0], TABLE[1], TABLE[2], TABLE[3], TABLE[4], TABLE[5], TABLE[6], TABLE[7], TABLE[8], TABLE[9], TABLE[10], TABLE[11], TABLE[12], TABLE[13], TABLE[14], TABLE[15], TABLE[16], TABLE[17], TABLE[18], TABLE[19], TABLE[20], TABLE[21], TABLE[22], TABLE[23]); 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 Load(id) { new Query[1024], Data[1]; Data[0] = id; formatex(Query, charsmax(Query), "SELECT * FROM `oneshot_pb` WHERE %s = ^"%s^";", TABLE[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) { Gold[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "arany")); LvL[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "szint")); ExP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "tapasztalat")); Knifes[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes1")); Knifes[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes2")); Knifes[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes3")); Knifes[4][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes4")); Knifes[5][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes5")); Knifes[6][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes6")); Knifes[7][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes7")); Knifes[8][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes8")); Knifes[9][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes9")); Knifes[10][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes10")); Knifes[11][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes11")); Knifes[12][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes12")); Knifes[13][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes13")); Knifes[14][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes14")); Knifes[15][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes15")); Knifes[16][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes16")); Knifes[17][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes17")); Knifes[18][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes18")); Knifes[19][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes19")); Knifes[20][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "kes20")); } else { Save(id); } } } public Save(id) { new Query[1024]; new Len; Len += formatex(Query[Len], charsmax(Query), "INSERT INTO `oneshot_pb` "); Len += formatex(Query[Len], charsmax(Query)-Len, "(`%s`, `%s`, `%s`, `%s`, `%s`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`, `%s`, `%s`, `%s`, `%s`, `%s`, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`%s`) VALUES (^"%s^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^", ^"0^");", TABLE[0], TABLE[1], TABLE[2], TABLE[3], TABLE[4], TABLE[5], TABLE[6], TABLE[7], TABLE[8], TABLE[9], TABLE[10], TABLE[11], TABLE[12], TABLE[13], TABLE[14],, TABLE[15], TABLE[16], TABLE[17], TABLE[18], TABLE[19], TABLE[20], TABLE[21], TABLE[22], TABLE[23], 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, charsmax(Query), "UPDATE `oneshot_pb` SET %s = ^"%i^", %s = ^"%i^", "); Len += formatex(Query, charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", "); Len += formatex(Query, charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", "); Len += formatex(Query, charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", "); Len += formatex(Query, charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", "); Len += formatex(Query, charsmax(Query)-Len, "%s = ^"%i^", %s = ^"%i^", %s = ^"%i^", %s = ^"%i^", "); Len += formatex(Query, charsmax(Query)-Len, "%s = ^"%i^" WHERE %s = ^"%s^";", TABLE[1], Gold[id], TABLE[2], LvL[id], TABLE[3], ExP[id], TABLE[4], Knifes[1][id], TABLE[5], Knifes[2][id], TABLE[6], Knifes[3][id], TABLE[7], Knifes[4][id], TABLE[8], Knifes[5][id], TABLE[9], Knifes[6][id], TABLE[10], Knifes[7][id], TABLE[11], Knifes[8][id], TABLE[12], Knifes[9][id], TABLE[13], Knifes[10][id], TABLE[14], Knifes[11][id], TABLE[15], Knifes[12][id], TABLE[16], Knifes[13][id], TABLE[17], Knifes[14][id], TABLE[18], Knifes[15][id], TABLE[19], Knifes[16][id], TABLE[20], Knifes[17][id], TABLE[21], Knifes[18][id], TABLE[22], Knifes[19][id], TABLE[23], Knifes[20][id], TABLE[0], Name[id]); SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); }
|
|