Offline |
|
Csatlakozott: 2020.06.14. 17:59 Hozzászólások: 374
Megköszönt másnak: 64 alkalommal Megköszönték neki: 10 alkalommal
|
Üdv, Következő olyan gondom lenne hogy, a kiválasztott skin kiválasztom,de következő pályán már nem marad aktivált a skin, ebbe szeretnék egy kis segítséget kérni, aki tud nekem segíteni benne az kérem tegye meg. Köszönöm! _) SQL Mentés Rész public client_disconnected(id){ if(!is_user_bot(id)) Update(id); Oles[id] = 0; m4a1Oles[id] = 0; ak47Oles[id] = 0; awpOles[id] = 0; scoutOles[id] = 0; famasOles[id] = 0; augOles[id] = 0; galilOles[id] = 0; m3Oles[id] = 0; xm1014Oles[id] = 0; knifeOles[id] = 0; deagleOles[id] = 0; uspOles[id] = 0; glockOles[id] = 0 Beirtprefix[id] = false; prefiszem[id][0] = EOS; copy(name[id], charsmax(name[]), ""); } public client_putinserver(id){ if(!is_user_bot(id)){ get_user_name(id, name, charsmax(name)); Load(id); szerverbelepes(id); } } public szerverbelepes(id){ get_user_name(id, name, charsmax(name)); client_print_color(id,print_team_default, "^3[.arK~DemonS:.]^4 ^1%s^1 csatlakozott a szerverre. ^4Játékos:^3 %d/%d", name, get_playersnum(), get_maxplayers()); } /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public makeTuple(){ new Szolgaltato[100], Felhasznalonev[20], Jelszo[20], Dbnev[100] get_pcvar_string(cvSzolgaltato, Szolgaltato, 99) get_pcvar_string(cvFelhasznalonev, Felhasznalonev, 19) get_pcvar_string(cvJelszo, Jelszo, 19) get_pcvar_string(cvDbnev, Dbnev, 99) g_SqlTuple = SQL_MakeDbTuple(Szolgaltato, Felhasznalonev, Jelszo, Dbnev) } public plugin_cfg(){ static Query[10048] new Len Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `skinrangmenu`"); Len += formatex(Query[Len], charsmax(Query)-Len, "(`Steamid` varchar(32) NOT NULL, "); Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`m4a1Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`ak47Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`awpOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`scoutOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`famasOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`galilOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`augOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`m3Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`xm1014Oles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`knifeOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`deagleOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`uspOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`glockOles` int(11) NOT NULL,"); Len += formatex(Query[Len], charsmax(Query)-Len, "`id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)"); SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query); } public Load(id){ static Query[10048]; new Data[1], Steam[40]; Data[0] = id; get_user_authid(id, Steam, charsmax(Steam)) formatex(Query, charsmax(Query), "SELECT * FROM `skinrangmenu` WHERE Steamid = ^"%s^";", Steam) 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){ SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Prefix"), prefiszem[id], charsmax(prefiszem[])); Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles")); m4a1Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "m4a1Oles")); ak47Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ak47Oles")); awpOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "awpOles")); scoutOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "scoutOles")); famasOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "famasOles")); galilOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "galilOles")); augOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "augOles")); xm1014Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "xm1014Oles")); knifeOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "knifeOles")); deagleOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "deagleOles")); uspOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "uspOles")); glockOles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "glockOles")); } else Save(id); } } public SQL_Update_Reg(id){ static Query[10048]; new Len; new Steam[40] get_user_authid(id, Steam, charsmax(Steam)) Len += formatex(Query[Len], charsmax(Query), "UPDATE `skinrangmenu` SET Oles = ^"%i^", ", Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Prefix = ^"%s^", ", prefiszem[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE Steamid = ^"%s^";", Steam) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Save(id){ static Query[256] new Steam[40] get_user_authid(id, Steam, charsmax(Steam)) formatex(Query, charsmax(Query), "INSERT INTO `skinrangmenu` (`Steamid`) VALUES (^"%s^");", Steam) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query); } public Update(id){ static Query[10048] new Len new Steam[32]; get_user_authid(id, Steam, 31) Len += formatex(Query[Len], charsmax(Query), "UPDATE `skinrangmenu` SET Oles = ^"%i^", ", Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "Prefix = ^"%s^", ", prefiszem[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "m4a1Oles = ^"%i^", ", m4a1Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "ak47Oles = ^"%i^", ", ak47Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "awpOles = ^"%i^", ", awpOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "scoutOles = ^"%i^", ", scoutOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "famasOles = ^"%i^", ", famasOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "galilOles = ^"%i^", ", galilOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "augOles = ^"%i^", ", augOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "m3Oles = ^"%i^", ", m3Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "xm1014Oles = ^"%i^", ", xm1014Oles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "knifeOles = ^"%i^", ", knifeOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "deagleOles = ^"%i^", ", deagleOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "uspOles = ^"%i^", ", uspOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "glockOles = ^"%i^", ", glockOles[id]); Len += formatex(Query[Len], charsmax(Query)-Len, "m4a1Oles = ^"%i^" WHERE Steamid = ^"%s^";", m4a1Oles[id], Steam) SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query) } public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime){ if(FailState == TQUERY_CONNECT_FAILED) set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ!"); else if(FailState == TQUERY_QUERY_FAILED) set_fail_state("Query Error"); if(Errcode) log_amx("[HIBA*] HIBAT DOBTAM: %s",Error); } 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; } }
|
|