| 				
					| Offline |  
					|  |  Csatlakozott:2022.10.18. 12:36
 Hozzászólások:12
 | 
				
					| Sziasztok, valaki tudna segíteni? a gond az lenne hogy a Skineket meg a Tárgyakat mármint a Dollár nem menti az sql, viszont a regisztrációt pedig menti. előre is köszönöm! public client_disconnected(id){    if(!is_user_bot(id))    {        Update(id);    }    Belepve[id] = false;    Beirtjelszot[id] = false;    Beirtjelszot1[id] = false;    Beirtfelhasznalot[id] = false;    Beirtfelhasznalot1[id] = false;        regFh[id][0] = EOS;    regJelszo[id][0] = EOS;    Felhasznalonev[id][0] = EOS;    Jelszo[id][0] = EOS;        Dollar[id] = 0;Rang[id] = 0;Oles[id] = 0;HS[id] = 0;Regisztralt[id] = 0;SMS[id] = 0;EXP[id] = 0;Masodpercek[id] = 0;Elerve[id] = 0;Elerve1[id] = 0;Elerve2[id] = 0;Elerve3[id] = 0;Elerve4[id] = 0;Elerve5[id] = 0;Battlepass[id] = 0;g_Chat_Prefix[id] = "";g_Vip[id] = 0;g_VipTime[id] = 0;g_Quest[id] = 0;g_QuestWeapon[id] = 0;g_QuestMVP[id] = 0;g_QuestHead[id] = 0;        for(new i;i < MAX; i++)        OsszesSkin[i][id] = 0;        for(new i;i < LADA; i++)        Lada[i][id] = 0;        for(new i;i < LADA; i++)        LadaK[i][id] = 0;        copy(name[id], charsmax(name[]), "");} public client_putinserver(id){    if(!is_user_bot(id))    {        get_user_authid(id, name[id], charsmax(name));        Load(id);        Load_Register(id);    }    Gun[id] = true;    Hud[id] = true;    Belepve[id] = false;    Felhasznalonev[id] = "";    Jelszo[id] = "";} public plugin_cfg(){    g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);    Create_Table_Register();    Create_Table_Others();} public Create_Table_Register(){    static Query[10048];    new Len;        Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `hwd_regtabla`");    Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Player_IP` varchar(35) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Player_SteamID` varchar(35) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` 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 Create_Table_Others(){    static Query[10048];    new Len;        Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `hwd_cucmentes`");    Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL, ");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Felhasznalonev` varchar(32) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Jelszo` varchar(32) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Regisztralt` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollars` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`SMS` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`EXP` int(11) 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, "`HS` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Masodpercek` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestH` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestMVP` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestNeed` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestHave` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestWeap` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`QuestHead` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`JutLada` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`JutKulcs` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`JutPont` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`JutDoll` int(11) NOT NULL,");     Len += formatex(Query[Len], charsmax(Query)-Len, "`Battlepass` int(11) NOT NULL,");     Len += formatex(Query[Len], charsmax(Query)-Len, "`Vip` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`VipIdo` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Elerve` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Elerve1` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Elerve2` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Elerve3` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Elerve4` int(11) NOT NULL,");    Len += formatex(Query[Len], charsmax(Query)-Len, "`Elerve5` int(11) NOT NULL,");        for(new i;i < MAX; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "`F%d` int(11) NOT NULL,", i);    for(new i;i < LADA; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "`L%d` int(11) NOT NULL,", i);    for(new i;i < 11; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "`S%d` int(11) NOT NULL,", i);        for(new i;i < LADA; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "`K_%d` int(11) NOT NULL,", i);        Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs` int(11) NOT NULL, `id` INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)");        SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);} public Load(id) {    static Query[10048];    new Data[1], Name[32];    get_user_authid(id, Name, 31);    Data[0] = id;        formatex(Query, charsmax(Query), "SELECT * FROM `hwd_cucmentes` WHERE Nev = ^"%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) {            SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Felhasznalonev"), regFh[id], charsmax(regFh[]));            SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[]));            Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt"));            Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"));            Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollars"));            Oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"));            SMS[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "SMS"));            EXP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "EXP"));            HS[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "HS"));            Masodpercek[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Masodpercek"));            g_Quest[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestH"));            g_QuestMVP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestMVP"));            g_QuestKills[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestNeed"));            g_QuestKills[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHave"));            g_QuestWeapon[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestWeap"));            g_QuestHead[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHead"));            g_Jutalom[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutLada"));            g_Jutalom[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutKulcs"));            g_Jutalom[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutPont"));            g_Jutalom[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutDoll"));            Battlepass[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Battlepass"));            g_Vip[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vip"));            g_VipTime[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipIdo"));            Elerve[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elerve"));            Elerve1[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elerve1"));            Elerve2[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elerve2"));            Elerve3[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elerve3"));            Elerve4[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elerve4"));            Elerve5[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Elerve5"));                        for(new i;i < MAX; i++)            {                new String[64];                formatex(String, charsmax(String), "F%d", i);                OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));            }            for(new i;i < LADA; i++)            {                new String[64];                formatex(String, charsmax(String), "L%d", i);                Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));            }            for(new i;i < LADA; i++)            {                new String[64];                formatex(String, charsmax(String), "K_%d", i);                LadaK[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));            }            for(new i;i < 11; i++)            {                new String[64];                formatex(String, charsmax(String), "S%d", i);                Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));            }            Kulcs[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs"));        }        else        {            Save(id);        }    }} public Load_Register(id){    static Query[10048];    new Data[1], Name[32];    get_user_authid(id, Name, 31);    Data[0] = id;        formatex(Query, charsmax(Query), "SELECT * FROM `hwd_regtabla` WHERE Nev = ^"%s^";", name[id]);    SQL_ThreadQuery(g_SqlTuple, "QuerySelectDataRegister", Query, Data, 1);} public QuerySelectDataRegister(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, "Felhasznalonev"), regFh[id], charsmax(regFh[]));            SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Jelszo"), regJelszo[id], charsmax(regJelszo[]));            Regisztralt[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Regisztralt"));        }        else        {            Save_Register(id);        }    }} public Save(id){    static Query[256];        formatex(Query, charsmax(Query), "INSERT INTO `hwd_cucmentes` (`Nev`) VALUES (^"%s^");", name[id]);    SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);} public Save_Register(id){    static Query[256];        new sPlayer_IP[35], sPlayer_SteamID[35];    get_user_ip(id, sPlayer_IP, charsmax(sPlayer_IP), 1);    get_user_authid(id, sPlayer_SteamID, charsmax(sPlayer_SteamID));        formatex(Query, charsmax(Query), "INSERT INTO `hwd_regtabla` (`Nev`, `Player_IP`, `Player_SteamID` ) VALUES (^"%s^", ^"%s^", ^"%s^");", name[id], sPlayer_IP, sPlayer_SteamID);    SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);} public SQL_Update_Reg(id){    static Query[10048];    new Len;        Len += formatex(Query[Len], charsmax(Query), "UPDATE `hwd_regtabla` SET Felhasznalonev = ^"%s^", ", regFh[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Jelszo = ^"%s^", ", regJelszo[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Regisztralt = ^"%i^" WHERE Nev = ^"%s^";", Regisztralt[id], name[id]);        SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);} public Update(id){    static Query[10048];    new Len;        Len += formatex(Query[Len], charsmax(Query), "UPDATE `hwd_cucmentes` SET Dollars = ^"%i^", ",Dollar[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^", ", Rang[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^", ", Oles[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "SMS = ^"%i^", ", SMS[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "EXP = ^"%i^", ", EXP[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "HS = ^"%i^", ", HS[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Masodpercek = ^"%i^", ", Masodpercek[id]+get_user_time(id));    Len += formatex(Query[Len], charsmax(Query)-Len, "QuestH = '%i', ", g_Quest[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "QuestMVP = '%i', ", g_QuestMVP[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "QuestNeed = '%i', ", g_QuestKills[0][id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "QuestHave = '%i', ", g_QuestKills[1][id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "QuestWeap = '%i', ", g_QuestWeapon[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "QuestHead = '%i', ", g_QuestHead[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "JutLada = '%i', ", g_Jutalom[0][id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "JutKulcs = '%i', ", g_Jutalom[1][id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "JutPont = '%i', ", g_Jutalom[2][id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "JutDoll = '%i', ", g_Jutalom[3][id]);     Len += formatex(Query[Len], charsmax(Query)-Len, "Battlepass = '%i', ", Battlepass[id]);     Len += formatex(Query[Len], charsmax(Query)-Len, "Vip = ^"%i^", ", g_Vip[id]-get_user_time(id));    Len += formatex(Query[Len], charsmax(Query)-Len, "VipTime = ^"%i^", ", g_VipTime[id]-get_user_time(id));    Len += formatex(Query[Len], charsmax(Query)-Len, "Elerve = ^"%i^", ", Elerve[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Elerve1 = ^"%i^", ", Elerve1[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Elerve2 = ^"%i^", ", Elerve2[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Elerve3 = ^"%i^", ", Elerve3[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Elerve4 = ^"%i^", ", Elerve4[id]);    Len += formatex(Query[Len], charsmax(Query)-Len, "Elerve5 = ^"%i^", ", Elerve5[id]);        for(new i=0;i < MAX; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "F%d = ^"%i^", ", i, OsszesSkin[i][id]);        for(new i;i < LADA; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "L%d = ^"%i^", ", i, Lada[i][id]);        for(new i;i < LADA; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "K_%d = ^"%i^", ", i, LadaK[i][id]);           for(new i;i < 11; i++)        Len += formatex(Query[Len], charsmax(Query)-Len, "S%d = ^"%i^", ", i, Skin[i][id]);        Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs = ^"%i^" WHERE Nev = ^"%s^";", Kulcs[id], name[id]);        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;    }} public plugin_end() {    SQL_FreeHandle(g_SqlTuple);}
 
 |  |