Login

RioYX

Good east error it has me crazy, the problem is:

Quote:

[18:15:00] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')

There is nothing to do with this already makes me crazy D:!
Appears every time the server and sale again.

Edit: Revivo

Mencent · 23.02.2017, 14:44

Hello!

Can you show us the code of this? Maybe cache_get_field_content or something like that.

RioYX · 23.02.2017, 14:55

The OnQueryFinish ?, here you have it for mediafire since there is no other part to upload it, but help me T_T Click here I'm sorry if this is in Spanish, is that it is a Spanish server that I do, to put into practice Spanish and English hehehe

Mencent · 23.02.2017, 15:00

Try this, please.

PHP код:



forward OnQueryFinish(resultid, extraid, ConnectionHandle);

public OnQueryFinish(resultid, extraid, ConnectionHandle)

{

    new Rows, Field, string[256];

    if(resultid != 0)

    {

        cache_get_data(Rows, Field);

    }

    switch(resultid)

    {

        case 1:

        {

            if(Rows == 1)

            {

                new content[29];

                // Emisora

                cache_get_field_content(0, "TieneEmisora", content);        Emisoras[extraid][TieneEmisora] = strval(content);

                cache_get_field_content(0, "NombreEmisora", content);        strmid(Emisoras[extraid][NombreEmisora],  content, 0, strlen(content), 90);

                //

                cache_get_field_content(0, "ID", content);                    PlayerInfo[extraid][pID] = strval(content);

                cache_get_field_content(0, "Online", content);                PlayerInfo[extraid][pOnline] = strval(content);

                cache_get_field_content(0, "Patines", content);                PlayerInfo[extraid][pPatines] = strval(content);

                cache_get_field_content(0, "Baneado", content);                PlayerInfo[extraid][pBan] = strval(content);

                cache_get_field_content(0, "Sed", content);                    PlayerInfo[extraid][pSed] = strval(content);

                cache_get_field_content(0, "Licencia", content);            PlayerInfo[extraid][pLicencia] = strval(content);

                cache_get_field_content(0, "Hambre", content);                PlayerInfo[extraid][pHambre] = strval(content);

                cache_get_field_content(0, "SocioHP", content);                PlayerInfo[extraid][pSocioHP] = strval(content);

                cache_get_field_content(0, "TipoCarcel", content);            PlayerInfo[extraid][pTipoCarcel] = strval(content);

                cache_get_field_content(0, "TiempoCarcelM", content);        PlayerInfo[extraid][pTiempoCarcelM] = strval(content);

                cache_get_field_content(0, "TiempoCarcelS", content);        PlayerInfo[extraid][pTiempoCarcelS] = strval(content);

                cache_get_field_content(0, "Numero", content);                PlayerInfo[extraid][pNumero] = strval(content);

                cache_get_field_content(0, "TiempoJail", content);            PlayerInfo[extraid][pTiempoJail] = strval(content);

                cache_get_field_content(0, "Cargos", content);                PlayerInfo[extraid][pCargos] = strval(content);

                cache_get_field_content(0, "Duty", content);                PlayerInfo[extraid][pDuty] = strval(content);

                cache_get_field_content(0, "SkinTrabajo", content);            PlayerInfo[extraid][pModelo] = strval(content);

                cache_get_field_content(0, "Agenda", content);                PlayerInfo[extraid][pAgenda] = strval(content);

                cache_get_field_content(0, "Stats", content);                PlayerInfo[extraid][pStats] = strval(content);

                cache_get_field_content(0, "EMS", content);                    PlayerInfo[extraid][pEMS] = strval(content);

                cache_get_field_content(0, "Radio", content);                PlayerInfo[extraid][pRadio] = strval(content);

                cache_get_field_content(0, "GPS", content);                    PlayerInfo[extraid][pGPS] = strval(content);

                cache_get_field_content(0, "Origen", content);                PlayerInfo[extraid][pOrigen] = strval(content);

                cache_get_field_content(0, "DNI", content);                    PlayerInfo[extraid][pDNI] = strval(content);

                cache_get_field_content(0, "Rango", content);                PlayerInfo[extraid][pRango] = strval(content);

                cache_get_field_content(0, "Edad", content);                PlayerInfo[extraid][jEdad] = strval(content);

                cache_get_field_content(0, "Experiencia", content);            PlayerInfo[extraid][jExperiencia] = strval(content);

                cache_get_field_content(0, "Skin", content);                PlayerInfo[extraid][jRopa] = strval(content);

                cache_get_field_content(0, "Dia", content);                    PlayerInfo[extraid][jDia] = strval(content);

                cache_get_field_content(0, "Mes", content);                    PlayerInfo[extraid][jMes] = strval(content);

                cache_get_field_content(0, "Ano", content);                    PlayerInfo[extraid][jAno] = strval(content);

                cache_get_field_content(0, "Segundo", content);                PlayerInfo[extraid][jSegundo] = strval(content);

                cache_get_field_content(0, "Minuto", content);                PlayerInfo[extraid][jMinuto] = strval(content);

                cache_get_field_content(0, "Hora", content);                PlayerInfo[extraid][jHora] = strval(content);

                cache_get_field_content(0, "Nivel", content);                PlayerInfo[extraid][jNivel] = strval(content);

                cache_get_field_content(0, "Sexo", content);                PlayerInfo[extraid][jSexo] = strval(content);

                cache_get_field_content(0, "Martillo", content);            PlayerInfo[extraid][jMartillo] = strval(content);

                cache_get_field_content(0, "Destornillador", content);        PlayerInfo[extraid][jDestornillador] = strval(content);

                cache_get_field_content(0, "Barreta", content);                PlayerInfo[extraid][jBarreta] = strval(content);

                cache_get_field_content(0, "Balde", content);                PlayerInfo[extraid][jBalde] = strval(content);

                cache_get_field_content(0, "Faccion", content);                PlayerInfo[extraid][jMiembro] = strval(content);

                cache_get_field_content(0, "hprecio", content);                PlayerInfo[extraid][hprecio] = strval(content);

                cache_get_field_content(0, "hmoneda", content);                PlayerInfo[extraid][hmoneda] = strval(content);

                cache_get_field_content(0, "h2precio", content);            PlayerInfo[extraid][h2precio] = strval(content);

                cache_get_field_content(0, "h2moneda", content);            PlayerInfo[extraid][h2moneda] = strval(content);

                cache_get_field_content(0, "Repuestos", content);            PlayerInfo[extraid][Repuestos] = strval(content);

                cache_get_field_content(0, "FinMes", content);                PlayerInfo[extraid][finmes] = strval(content);

                cache_get_field_content(0, "FinDia", content);                PlayerInfo[extraid][findia] = strval(content);

                cache_get_field_content(0, "FinAno", content);                PlayerInfo[extraid][finano] = strval(content);

                cache_get_field_content(0, "EnCasa", content);                PlayerInfo[extraid][EnCasa] = strval(content);

                cache_get_field_content(0, "EnRopero", content);            PlayerInfo[extraid][EnRopero] = strval(content);

                cache_get_field_content(0, "EnGarage", content);            PlayerInfo[extraid][EnGarage] = strval(content);

                cache_get_field_content(0, "CasaID", content);                PlayerInfo[extraid][CasaID] = strval(content);

                cache_get_field_content(0, "CasaID2", content);                PlayerInfo[extraid][CasaID2] = strval(content);

                cache_get_field_content(0, "Agonizando", content);            PlayerInfo[extraid][Agonizando] = strval(content);

                cache_get_field_content(0, "razon", content);                strmid(PlayerInfo[extraid][pRazon],  content, 0, strlen(content), 32);

                cache_get_field_content(0, "totem", content);                strmid(PlayerInfo[extraid][Totem],  content, 0, strlen(content), 32);

                cache_get_field_content(0, "totems", content);                PlayerInfo[extraid][Totems] = strval(content);

                cache_get_field_content(0, "ent_totem", content);            PlayerInfo[extraid][Ent_Totem] = strval(content);


                PlayerInfo[extraid][pInterior]         = cache_get_field_content_int(0, "Interior");

                PlayerInfo[extraid][pMundoVirtual]     = cache_get_field_content_int(0, "MundoVirtual");

                PlayerInfo[extraid][arrestado]         = cache_get_field_content_int(0, "arrestado");

                PlayerInfo[extraid][horasjugadas]     = cache_get_field_content_int(0, "horasjugadas");


                cache_get_field_content(0, "VIP", content);                    PlayerInfo[extraid][vip] = strval(content);

                cache_get_field_content(0, "Banco", content);                PlayerInfo[extraid][pBanco] = strval(content);

                cache_get_field_content(0, "Moneda", content);                PlayerInfo[extraid][Moneda] = strval(content);

                cache_get_field_content(0, "Money", content);                PlayerInfo[extraid][jDinero] = strval(content);

                cache_get_field_content(0, "Medicamentos", content);        PlayerInfo[extraid][pMedicamentos] = strval(content);

                cache_get_field_content(0, "Crack", content);                PlayerInfo[extraid][pCrack] = strval(content);

                cache_get_field_content(0, "Marihuana", content);           PlayerInfo[extraid][pMarihuana] = strval(content);

                cache_get_field_content(0, "Semillas", content);            PlayerInfo[extraid][pSemillas] = strval(content);

                cache_get_field_content(0, "Materiales", content);            PlayerInfo[extraid][pMateriales] = strval(content);

                cache_get_field_content(0, "Trabajo", content);                PlayerInfo[extraid][jJob] = strval(content);

                cache_get_field_content(0, "Trabajo2", content);            PlayerInfo[extraid][vipjob] = strval(content);

                cache_get_field_content(0, "Admin", content);                PlayerInfo[extraid][jAdminNvl] = strval(content);


                cache_get_field_content(0, "NMute", content);                TiempoDuda[extraid] = strval(content);

                cache_get_field_content(0, "TiempoAD", content);            TiempoAD[extraid] = strval(content);

                cache_get_field_content(0, "TiempoPD", content);            TiempoPD[extraid] = strval(content);


                cache_get_field_content(0, "RopaBasu", content);            RopaBasu[extraid] = strval(content);

                cache_get_field_content(0, "RopaMedi", content);            RopaMedi[extraid] = strval(content);

                cache_get_field_content(0, "RopaMeca", content);            RopaMeca[extraid] = strval(content);

                cache_get_field_content(0, "RopaMine", content);            RopaMine[extraid] = strval(content);


                cache_get_field_content(0, "Vida", content);                PlayerInfo[extraid][jVida] =         floatstr(content);

                cache_get_field_content(0, "Chaleco", content);                PlayerInfo[extraid][jArmadura] =     floatstr(content);

                cache_get_field_content(0, "posX", content);                PlayerInfo[extraid][jPos_x] =         floatstr(content);

                cache_get_field_content(0, "posY", content);                PlayerInfo[extraid][jPos_y] =         floatstr(content);

                cache_get_field_content(0, "posZ", content);                PlayerInfo[extraid][jPos_z] =         floatstr(content);

                // Armas

                cache_get_field_content(0, "WP0", content);                    PlayerInfo[extraid][pWP0] = strval(content);

                cache_get_field_content(0, "WP1", content);                    PlayerInfo[extraid][pWP1] = strval(content);

                cache_get_field_content(0, "WP2", content);                    PlayerInfo[extraid][pWP2] = strval(content);

                cache_get_field_content(0, "WP3", content);                    PlayerInfo[extraid][pWP3] = strval(content);

                cache_get_field_content(0, "WP4", content);                    PlayerInfo[extraid][pWP4] = strval(content);

                cache_get_field_content(0, "WP5", content);                    PlayerInfo[extraid][pWP5] = strval(content);

                cache_get_field_content(0, "WP6", content);                    PlayerInfo[extraid][pWP6] = strval(content);

                cache_get_field_content(0, "WP7", content);                    PlayerInfo[extraid][pWP7] = strval(content);

                cache_get_field_content(0, "WP8", content);                    PlayerInfo[extraid][pWP8] = strval(content);

                cache_get_field_content(0, "WP9", content);                    PlayerInfo[extraid][pWP9] = strval(content);

                cache_get_field_content(0, "WP10", content);                PlayerInfo[extraid][pWP10] = strval(content);

                cache_get_field_content(0, "WP11", content);                PlayerInfo[extraid][pWP11] = strval(content);

                cache_get_field_content(0, "WP12", content);                PlayerInfo[extraid][pWP12] = strval(content);

                // Habilidades y Niveles

                cache_get_field_content(0, "NivelMecanico", content);        PlayerInfo[extraid][pNivelMecanico] = strval(content);

                cache_get_field_content(0, "ExpMecanico", content);            PlayerInfo[extraid][pExpMecanico] = strval(content);

                cache_get_field_content(0, "NivelArmero", content);            PlayerInfo[extraid][pNivelArmero] = strval(content);

                cache_get_field_content(0, "ExpArmero", content);            PlayerInfo[extraid][pExpArmero] = strval(content);

                cache_get_field_content(0, "NivelCamionero", content);        PlayerInfo[extraid][pNivelCamionero] = strval(content);

                cache_get_field_content(0, "ExpCamionero", content);        PlayerInfo[extraid][pExpCamionero] = strval(content);

                cache_get_field_content(0, "NivelBasurero", content);        PlayerInfo[extraid][pNivelBasurero] = strval(content);

                cache_get_field_content(0, "ExpBasurero", content);            PlayerInfo[extraid][pExpBasurero] = strval(content);

                cache_get_field_content(0, "NivelLadron", content);            PlayerInfo[extraid][pNivelLadron] = strval(content);

                cache_get_field_content(0, "ExpLadron", content);            PlayerInfo[extraid][pExpLadron] = strval(content);

                cache_get_field_content(0, "NivelPescador", content);        PlayerInfo[extraid][pNivelPescador] = strval(content);

                cache_get_field_content(0, "ExpPescador", content);            PlayerInfo[extraid][pExpPescador] = strval(content);

                cache_get_field_content(0, "NivelMinero", content);            PlayerInfo[extraid][pNivelMinero] = strval(content);

                cache_get_field_content(0, "ExpMinero", content);            PlayerInfo[extraid][pExpMinero] = strval(content);

                cache_get_field_content(0, "NivelPiloto", content);         PlayerInfo[extraid][pNivelPiloto] = strval(content);

                cache_get_field_content(0, "ExpPiloto", content);           PlayerInfo[extraid][pExpPiloto] = strval(content);

                cache_get_field_content(0, "NivelTransportista", content);    PlayerInfo[extraid][pNivelTransportista] = strval(content);

                cache_get_field_content(0, "ExpTransportista", content);    PlayerInfo[extraid][pExpTransportista] = strval(content);

                // Auto 1

                cache_get_field_content(0, "OX", content);                    PlayerInfo[extraid][pOX] = floatstr(content);

                cache_get_field_content(0, "OY", content);                    PlayerInfo[extraid][pOY] = floatstr(content);

                cache_get_field_content(0, "OZ", content);                    PlayerInfo[extraid][pOZ] = floatstr(content);

                cache_get_field_content(0, "OA", content);                    PlayerInfo[extraid][pOA] = floatstr(content);

                cache_get_field_content(0, "VE1", content);                    PlayerInfo[extraid][VE1] = strval(content);

                cache_get_field_content(0, "VE2", content);                    PlayerInfo[extraid][VE2] = strval(content);

                cache_get_field_content(0, "VE3", content);                    PlayerInfo[extraid][VE3] = strval(content);

                cache_get_field_content(0, "VE4", content);                    PlayerInfo[extraid][VE4] = strval(content);

                cache_get_field_content(0, "vMoneda", content);                PlayerInfo[extraid][vMonedaa] = strval(content);

                cache_get_field_content(0, "Modelo", content);                PlayerInfo[extraid][vModelo] = strval(content);

                cache_get_field_content(0, "vGas", content);                PlayerInfo[extraid][vGas] = strval(content);

                cache_get_field_content(0, "vinterior", content);            PlayerInfo[extraid][vinterior] = strval(content);

                cache_get_field_content(0, "vvw", content);                    PlayerInfo[extraid][vvw] = strval(content);

                cache_get_field_content(0, "Color1", content);                PlayerInfo[extraid][vColor1] = strval(content);

                cache_get_field_content(0, "Color2", content);                PlayerInfo[extraid][vColor2] = strval(content);

                cache_get_field_content(0, "VidaV", content);                PlayerInfo[extraid][pVidaV] = floatstr(content);

                cache_get_field_content(0, "vBaul", content);                PlayerInfo[extraid][vBaul] = strval(content);

                cache_get_field_content(0, "vBaul2", content);                PlayerInfo[extraid][vBaul2] = strval(content);

                cache_get_field_content(0, "vBaul3", content);                PlayerInfo[extraid][vBaul3] = strval(content);

                cache_get_field_content(0, "vBaul4", content);                PlayerInfo[extraid][vBaul4] = strval(content);

                cache_get_field_content(0, "vBaul5", content);                PlayerInfo[extraid][vBaul5] = strval(content);

                cache_get_field_content(0, "vBaul6", content);                PlayerInfo[extraid][vBaul6] = strval(content);

                cache_get_field_content(0, "vBaul7", content);                PlayerInfo[extraid][vBaul7] = strval(content);

                cache_get_field_content(0, "vBaul8", content);                PlayerInfo[extraid][vBaul8] = strval(content);

                cache_get_field_content(0, "PaintJob", content);            PlayerInfo[extraid][vPJ] = strval(content);

                cache_get_field_content(0, "1Componentes0", content);        PlayerInfo[extraid][vComponentes0] = strval(content);

                cache_get_field_content(0, "1Componentes1", content);        PlayerInfo[extraid][vComponentes1] = strval(content);

                cache_get_field_content(0, "1Componentes2", content);        PlayerInfo[extraid][vComponentes2] = strval(content);

                cache_get_field_content(0, "1Componentes3", content);        PlayerInfo[extraid][vComponentes3] = strval(content);

                cache_get_field_content(0, "1Componentes4", content);        PlayerInfo[extraid][vComponentes4] = strval(content);

                cache_get_field_content(0, "1Componentes5", content);        PlayerInfo[extraid][vComponentes5] = strval(content);

                cache_get_field_content(0, "1Componentes6", content);        PlayerInfo[extraid][vComponentes6] = strval(content);

                cache_get_field_content(0, "1Componentes7", content);        PlayerInfo[extraid][vComponentes7] = strval(content);

                cache_get_field_content(0, "1Componentes8", content);        PlayerInfo[extraid][vComponentes8] = strval(content);

                cache_get_field_content(0, "1Componentes9", content);        PlayerInfo[extraid][vComponentes9] = strval(content);

                cache_get_field_content(0, "1Componentes10", content);        PlayerInfo[extraid][vComponentes10] = strval(content);

                cache_get_field_content(0, "1Componentes11", content);        PlayerInfo[extraid][vComponentes11] = strval(content);

                cache_get_field_content(0, "1Componentes12", content);        PlayerInfo[extraid][vComponentes12] = strval(content);

                cache_get_field_content(0, "1Componentes13", content);        PlayerInfo[extraid][vComponentes13] = strval(content);

                cache_get_field_content(0, "Precio", content);                PlayerInfo[extraid][vPrecio] = strval(content);

                cache_get_field_content(0, "X", content);                    PlayerInfo[extraid][vX] = floatstr(content);

                cache_get_field_content(0, "Y", content);                    PlayerInfo[extraid][vY] = floatstr(content);

                cache_get_field_content(0, "Z", content);                    PlayerInfo[extraid][vZ] = floatstr(content);

                cache_get_field_content(0, "A", content);                    PlayerInfo[extraid][vA] = floatstr(content);

                cache_get_field_content(0, "Ovw", content);                    PlayerInfo[extraid][vOvw] = strval(content);

                cache_get_field_content(0, "Ointerior", content);            PlayerInfo[extraid][vOinterior] = strval(content);

                cache_get_field_content(0, "1Patente", content);            strmid(PlayerInfo[extraid][vpatente],  content, 0, strlen(content), 32);

                cache_get_field_content(0, "Segurov", content);                PlayerInfo[extraid][vSeguro] = strval(content);

                cache_get_field_content(0, "vTraba", content);                PlayerInfo[extraid][vTraba] = strval(content);

                // Auto 2

                cache_get_field_content(0, "OX2", content);                    PlayerInfo[extraid][pOX2] = floatstr(content);

                cache_get_field_content(0, "OY2", content);                    PlayerInfo[extraid][pOY2] = floatstr(content);

                cache_get_field_content(0, "OZ2", content);                    PlayerInfo[extraid][pOZ2] = floatstr(content);

                cache_get_field_content(0, "OA2", content);                    PlayerInfo[extraid][pOA2] = floatstr(content);

                cache_get_field_content(0, "V2E1", content);                PlayerInfo[extraid][V2E1] = strval(content);

                cache_get_field_content(0, "V2E2", content);                PlayerInfo[extraid][V2E2] = strval(content);

                cache_get_field_content(0, "V2E3", content);                PlayerInfo[extraid][V2E3] = strval(content);

                cache_get_field_content(0, "V2E4", content);                PlayerInfo[extraid][V2E4] = strval(content);

                cache_get_field_content(0, "v2Moneda", content);            PlayerInfo[extraid][v2Monedaa] = strval(content);

                cache_get_field_content(0, "Modelo2", content);                PlayerInfo[extraid][vModelo2] = strval(content);

                cache_get_field_content(0, "v2Gas", content);                PlayerInfo[extraid][v2Gas] = strval(content);

                cache_get_field_content(0, "v2interior", content);            PlayerInfo[extraid][v2interior] = strval(content);

                cache_get_field_content(0, "v2vw", content);                PlayerInfo[extraid][v2vw] = strval(content);

                cache_get_field_content(0, "2Color1", content);                PlayerInfo[extraid][v2Color1] = strval(content);

                cache_get_field_content(0, "2Color2", content);                PlayerInfo[extraid][v2Color2] = strval(content);

                cache_get_field_content(0, "v2Baul", content);                PlayerInfo[extraid][v2Baul] = strval(content);

                cache_get_field_content(0, "v2Baul2", content);                PlayerInfo[extraid][v2Baul2] = strval(content);

                cache_get_field_content(0, "v2Baul3", content);                PlayerInfo[extraid][v2Baul3] = strval(content);

                cache_get_field_content(0, "v2Baul4", content);                PlayerInfo[extraid][v2Baul4] = strval(content);

                cache_get_field_content(0, "v2Baul5", content);                PlayerInfo[extraid][v2Baul5] = strval(content);

                cache_get_field_content(0, "v2Baul6", content);                PlayerInfo[extraid][v2Baul6] = strval(content);

                cache_get_field_content(0, "v2Baul7", content);                PlayerInfo[extraid][v2Baul7] = strval(content);

                cache_get_field_content(0, "v2Baul8", content);                PlayerInfo[extraid][v2Baul8] = strval(content);

                cache_get_field_content(0, "PaintJob2", content);            PlayerInfo[extraid][vPJ2] = strval(content);

                cache_get_field_content(0, "2Componentes0", content);        PlayerInfo[extraid][v2Componentes0] = strval(content);

                cache_get_field_content(0, "2Componentes1", content);        PlayerInfo[extraid][v2Componentes1] = strval(content);

                cache_get_field_content(0, "2Componentes2", content);        PlayerInfo[extraid][v2Componentes2] = strval(content);

                cache_get_field_content(0, "2Componentes3", content);        PlayerInfo[extraid][v2Componentes3] = strval(content);

                cache_get_field_content(0, "2Componentes4", content);        PlayerInfo[extraid][v2Componentes4] = strval(content);

                cache_get_field_content(0, "2Componentes5", content);        PlayerInfo[extraid][v2Componentes5] = strval(content);

                cache_get_field_content(0, "2Componentes6", content);        PlayerInfo[extraid][v2Componentes6] = strval(content);

                cache_get_field_content(0, "2Componentes7", content);        PlayerInfo[extraid][v2Componentes7] = strval(content);

                cache_get_field_content(0, "2Componentes8", content);        PlayerInfo[extraid][v2Componentes8] = strval(content);

                cache_get_field_content(0, "2Componentes9", content);        PlayerInfo[extraid][v2Componentes9] = strval(content);

                cache_get_field_content(0, "2Componentes10", content);        PlayerInfo[extraid][v2Componentes10] = strval(content);

                cache_get_field_content(0, "2Componentes11", content);        PlayerInfo[extraid][v2Componentes11] = strval(content);

                cache_get_field_content(0, "2Componentes12", content);        PlayerInfo[extraid][v2Componentes12] = strval(content);

                cache_get_field_content(0, "2Componentes13", content);        PlayerInfo[extraid][v2Componentes13] = strval(content);

                cache_get_field_content(0, "Precio2", content);                PlayerInfo[extraid][v2Precio] = strval(content);

                cache_get_field_content(0, "Ovw2", content);                PlayerInfo[extraid][v2Ovw] = strval(content);

                cache_get_field_content(0, "Ointerior2", content);            PlayerInfo[extraid][v2Ointerior] = strval(content);

                cache_get_field_content(0, "VidaV2", content);                PlayerInfo[extraid][pVidaV2] = floatstr(content);

                cache_get_field_content(0, "X2", content);                    PlayerInfo[extraid][v2X] = floatstr(content);

                cache_get_field_content(0, "Y2", content);                    PlayerInfo[extraid][v2Y] = floatstr(content);

                cache_get_field_content(0, "Z2", content);                    PlayerInfo[extraid][v2Z] = floatstr(content);

                cache_get_field_content(0, "A2", content);                    PlayerInfo[extraid][v2A] = floatstr(content);

                cache_get_field_content(0, "2Patente", content);            strmid(PlayerInfo[extraid][v2patente], content, 0, strlen(content), 32);

                cache_get_field_content(0, "Segurov2", content);            PlayerInfo[extraid][vSeguro2] = strval(content);

                cache_get_field_content(0, "v2Traba", content);                PlayerInfo[extraid][v2Traba] = strval(content);

                // Auto 3

                cache_get_field_content(0, "OX3", content);                    PlayerInfo[extraid][pOX3] = floatstr(content);

                cache_get_field_content(0, "OY3", content);                    PlayerInfo[extraid][pOY3] = floatstr(content);

                cache_get_field_content(0, "OZ3", content);                    PlayerInfo[extraid][pOZ3] = floatstr(content);

                cache_get_field_content(0, "OA3", content);                    PlayerInfo[extraid][pOA3] = floatstr(content);

                cache_get_field_content(0, "V3E1", content);                PlayerInfo[extraid][V3E1] = strval(content);

                cache_get_field_content(0, "V3E2", content);                PlayerInfo[extraid][V3E2] = strval(content);

                cache_get_field_content(0, "V3E3", content);                PlayerInfo[extraid][V3E3] = strval(content);

                cache_get_field_content(0, "V3E4", content);                PlayerInfo[extraid][V3E4] = strval(content);

                cache_get_field_content(0, "v3Moneda", content);            PlayerInfo[extraid][v3Monedaa] = strval(content);

                cache_get_field_content(0, "Modelo3", content);                PlayerInfo[extraid][vModelo3] = strval(content);

                cache_get_field_content(0, "v3Gas", content);                PlayerInfo[extraid][v3Gas] = strval(content);

                cache_get_field_content(0, "v3interior", content);            PlayerInfo[extraid][v3interior] = strval(content);

                cache_get_field_content(0, "v3vw", content);                PlayerInfo[extraid][v3vw] = strval(content);

                cache_get_field_content(0, "3Color1", content);                PlayerInfo[extraid][v3Color1] = strval(content);

                cache_get_field_content(0, "3Color2", content);                PlayerInfo[extraid][v3Color2] = strval(content);

                cache_get_field_content(0, "v3Baul", content);                PlayerInfo[extraid][v3Baul] = strval(content);

                cache_get_field_content(0, "v3Baul2", content);                PlayerInfo[extraid][v3Baul2] = strval(content);

                cache_get_field_content(0, "v3Baul3", content);                PlayerInfo[extraid][v3Baul3] = strval(content);

                cache_get_field_content(0, "v3Baul4", content);                PlayerInfo[extraid][v3Baul4] = strval(content);

                cache_get_field_content(0, "v3Baul5", content);                PlayerInfo[extraid][v3Baul5] = strval(content);

                cache_get_field_content(0, "v3Baul6", content);                PlayerInfo[extraid][v3Baul6] = strval(content);

                cache_get_field_content(0, "v3Baul7", content);                PlayerInfo[extraid][v3Baul7] = strval(content);

                cache_get_field_content(0, "v3Baul8", content);                PlayerInfo[extraid][v3Baul8] = strval(content);

                cache_get_field_content(0, "PaintJob3", content);            PlayerInfo[extraid][vPJ3] = strval(content);

                cache_get_field_content(0, "3Componentes0", content);        PlayerInfo[extraid][v3Componentes0] = strval(content);

                cache_get_field_content(0, "3Componentes1", content);        PlayerInfo[extraid][v3Componentes1] = strval(content);

                cache_get_field_content(0, "3Componentes2", content);        PlayerInfo[extraid][v3Componentes2] = strval(content);

                cache_get_field_content(0, "3Componentes3", content);        PlayerInfo[extraid][v3Componentes3] = strval(content);

                cache_get_field_content(0, "3Componentes4", content);        PlayerInfo[extraid][v3Componentes4] = strval(content);

                cache_get_field_content(0, "3Componentes5", content);        PlayerInfo[extraid][v3Componentes5] = strval(content);

                cache_get_field_content(0, "3Componentes6", content);        PlayerInfo[extraid][v3Componentes6] = strval(content);

                cache_get_field_content(0, "3Componentes7", content);        PlayerInfo[extraid][v3Componentes7] = strval(content);

                cache_get_field_content(0, "3Componentes8", content);        PlayerInfo[extraid][v3Componentes8] = strval(content);

                cache_get_field_content(0, "3Componentes9", content);        PlayerInfo[extraid][v3Componentes9] = strval(content);

                cache_get_field_content(0, "3Componentes10", content);        PlayerInfo[extraid][v3Componentes10] = strval(content);

                cache_get_field_content(0, "3Componentes11", content);        PlayerInfo[extraid][v3Componentes11] = strval(content);

                cache_get_field_content(0, "3Componentes12", content);        PlayerInfo[extraid][v3Componentes12] = strval(content);

                cache_get_field_content(0, "3Componentes13", content);        PlayerInfo[extraid][v3Componentes13] = strval(content);

                cache_get_field_content(0, "Precio3", content);                PlayerInfo[extraid][v3Precio] = strval(content);

                cache_get_field_content(0, "Ovw3", content);                PlayerInfo[extraid][v3Ovw] = strval(content);

                cache_get_field_content(0, "Ointerior3", content);            PlayerInfo[extraid][v3Ointerior] = strval(content);

                cache_get_field_content(0, "VidaV3", content);                PlayerInfo[extraid][pVidaV3] = floatstr(content);

                cache_get_field_content(0, "X3", content);                    PlayerInfo[extraid][v3X] = floatstr(content);

                cache_get_field_content(0, "Y3", content);                    PlayerInfo[extraid][v3Y] = floatstr(content);

                cache_get_field_content(0, "Z3", content);                    PlayerInfo[extraid][v3Z] = floatstr(content);

                cache_get_field_content(0, "A3", content);                    PlayerInfo[extraid][v3A] = floatstr(content);

                cache_get_field_content(0, "3Patente", content);            strmid(PlayerInfo[extraid][v3patente], content, 0, strlen(content), 32);

                cache_get_field_content(0, "Segurov3", content);            PlayerInfo[extraid][vSeguro3] = strval(content);

                cache_get_field_content(0, "v3Traba", content);                PlayerInfo[extraid][v3Traba] = strval(content);

                // Auto 4

                cache_get_field_content(0, "V4E1", content);                PlayerInfo[extraid][V4E1] = strval(content);

                cache_get_field_content(0, "V4E2", content);                PlayerInfo[extraid][V4E2] = strval(content);

                cache_get_field_content(0, "V4E3", content);                PlayerInfo[extraid][V4E3] = strval(content);

                cache_get_field_content(0, "V4E4", content);                PlayerInfo[extraid][V4E4] = strval(content);

                cache_get_field_content(0, "v4Moneda", content);            PlayerInfo[extraid][v4Monedaa] = strval(content);

                cache_get_field_content(0, "Modelo4", content);                PlayerInfo[extraid][vModelo4] = strval(content);

                cache_get_field_content(0, "v4Gas", content);                PlayerInfo[extraid][v4Gas] = strval(content);

                cache_get_field_content(0, "v4interior", content);            PlayerInfo[extraid][v4interior] = strval(content);

                cache_get_field_content(0, "v4vw", content);                PlayerInfo[extraid][v4vw] = strval(content);

                cache_get_field_content(0, "4Color1", content);                PlayerInfo[extraid][v4Color1] = strval(content);

                cache_get_field_content(0, "4Color2", content);                PlayerInfo[extraid][v4Color2] = strval(content);

                cache_get_field_content(0, "v4Baul", content);                PlayerInfo[extraid][v4Baul] = strval(content);

                cache_get_field_content(0, "v4Baul2", content);                PlayerInfo[extraid][v4Baul2] = strval(content);

                cache_get_field_content(0, "v4Baul3", content);                PlayerInfo[extraid][v4Baul3] = strval(content);

                cache_get_field_content(0, "v4Baul4", content);                PlayerInfo[extraid][v4Baul4] = strval(content);

                cache_get_field_content(0, "v4Baul5", content);                PlayerInfo[extraid][v4Baul5] = strval(content);

                cache_get_field_content(0, "v4Baul6", content);                PlayerInfo[extraid][v4Baul6] = strval(content);

                cache_get_field_content(0, "v4Baul7", content);                PlayerInfo[extraid][v4Baul7] = strval(content);

                cache_get_field_content(0, "v4Baul8", content);                PlayerInfo[extraid][v4Baul8] = strval(content);

                cache_get_field_content(0, "PaintJob4", content);            PlayerInfo[extraid][vPJ4] = strval(content);

                cache_get_field_content(0, "4Componentes0", content);        PlayerInfo[extraid][v4Componentes0] = strval(content);

                cache_get_field_content(0, "4Componentes1", content);        PlayerInfo[extraid][v4Componentes1] = strval(content);

                cache_get_field_content(0, "4Componentes2", content);        PlayerInfo[extraid][v4Componentes2] = strval(content);

                cache_get_field_content(0, "4Componentes3", content);        PlayerInfo[extraid][v4Componentes3] = strval(content);

                cache_get_field_content(0, "4Componentes4", content);        PlayerInfo[extraid][v4Componentes4] = strval(content);

                cache_get_field_content(0, "4Componentes5", content);        PlayerInfo[extraid][v4Componentes5] = strval(content);

                cache_get_field_content(0, "4Componentes6", content);        PlayerInfo[extraid][v4Componentes6] = strval(content);

                cache_get_field_content(0, "4Componentes7", content);        PlayerInfo[extraid][v4Componentes7] = strval(content);

                cache_get_field_content(0, "4Componentes8", content);        PlayerInfo[extraid][v4Componentes8] = strval(content);

                cache_get_field_content(0, "4Componentes9", content);        PlayerInfo[extraid][v4Componentes9] = strval(content);

                cache_get_field_content(0, "4Componentes10", content);        PlayerInfo[extraid][v4Componentes10] = strval(content);

                cache_get_field_content(0, "4Componentes11", content);        PlayerInfo[extraid][v4Componentes11] = strval(content);

                cache_get_field_content(0, "4Componentes12", content);        PlayerInfo[extraid][v4Componentes12] = strval(content);

                cache_get_field_content(0, "4Componentes13", content);        PlayerInfo[extraid][v4Componentes13] = strval(content);

                cache_get_field_content(0, "Precio4", content);                PlayerInfo[extraid][v4Precio] = strval(content);

                cache_get_field_content(0, "Ovw4", content);                PlayerInfo[extraid][v4Ovw] = strval(content);

                cache_get_field_content(0, "Ointerior4", content);            PlayerInfo[extraid][v4Ointerior] = strval(content);

                cache_get_field_content(0, "OX4", content);                    PlayerInfo[extraid][pOX4] = floatstr(content);

                cache_get_field_content(0, "OY4", content);                    PlayerInfo[extraid][pOY4] = floatstr(content);

                cache_get_field_content(0, "OZ4", content);                    PlayerInfo[extraid][pOZ4] = floatstr(content);

                cache_get_field_content(0, "OA4", content);                    PlayerInfo[extraid][pOA4] = floatstr(content);

                cache_get_field_content(0, "VidaV4", content);                PlayerInfo[extraid][pVidaV4] = floatstr(content);

                cache_get_field_content(0, "X4", content);                    PlayerInfo[extraid][v4X] = floatstr(content);

                cache_get_field_content(0, "Y4", content);                    PlayerInfo[extraid][v4Y] = floatstr(content);

                cache_get_field_content(0, "Z4", content);                    PlayerInfo[extraid][v4Z] = floatstr(content);

                cache_get_field_content(0, "A4", content);                    PlayerInfo[extraid][v4A] = floatstr(content);

                cache_get_field_content(0, "4Patente", content);            strmid(PlayerInfo[extraid][v4patente], content, 0, strlen(content), 32);

                cache_get_field_content(0, "Segurov4", content);            PlayerInfo[extraid][vSeguro4] = strval(content);

                cache_get_field_content(0, "v4Traba", content);                PlayerInfo[extraid][v4Traba] = strval(content);

                cache_get_field_content(0, "Regalo", content);              PlayerInfo[extraid][jRegalo] = strval(content);

                SetSpawnInfo(extraid,0,PlayerInfo[extraid][jRopa],PlayerInfo[extraid][jPos_x], PlayerInfo[extraid][jPos_y], PlayerInfo[extraid][jPos_z],5,0,0,0,0,0,0);

                SetPlayerScore(extraid,  PlayerInfo[extraid][jNivel]);

                SetPlayerArmour(extraid, PlayerInfo[extraid][jArmadura]);

                SetPlayerHealth(extraid, PlayerInfo[extraid][jVida]);


                if(PlayerInfo[extraid][pBan] == 1)

                {

                       new str[220];

                    format(str, sizeof(str), "Su cuenta se encuentra baneada, razуn: %s.", PlayerInfo[extraid][pRazon]);

                    SCM(extraid, COLOR_MUTE, str);

                    Kick(extraid);

                    return 1;

                }

                if(PlayerInfo[extraid][pTiempoJail] > 0)

                {

                    PlayerInfo[extraid][pTiempoJailS] = PlayerInfo[extraid][pTiempoJail]/1000;

                }

                if(PlayerInfo[extraid][pCargos] > 0)

                {

                    SetTimerEx("Encerrando2",2000,false,"d",extraid);

                }

                if(PlayerInfo[extraid][pEMS] == 0)

                {

                    format(string,sizeof(string),"Ingresa un e-mail vбlido para recuperar tu contraseсa en caso de perderla.\n\nTu e-mail:");

                    ShowPlayerDialog(extraid, DEMAIL,DIALOG_STYLE_INPUT,"Ingresa tu direcciуn de e-mail",string,"Siguiente","");

                }

                else

                {

                    SpawnPlayer(extraid);

                }

            }

            else if(!Rows)

            //if(Rows == 0)

            {

                new pName[50],content[20]; GetPlayerName(extraid, pName, 50);

                cache_get_field_content(0, "Password", content);

                PlayerInfo[extraid][pPassword] = strval(content);

                format(string, sizeof(string), "Contraseсa Incorrecta, Intentalo de nuevo", pName);

                ShowPlayerDialog(extraid, LOGIN, DIALOG_STYLE_INPUT,"Estб cuenta estб registrada",string,"Enviar","Salir");

            }

        }

        case 2:

        {

            if(Rows == 1)

            {

                LimpiarChat(extraid, 100, 1);

                new pName[50]; GetPlayerName(extraid, pName, 50);

                format(string, sizeof(string), "Ingresa tu contraseсa:", pName);

                ShowPlayerDialog(extraid, LOGIN, DIALOG_STYLE_PASSWORD,"Estб cuenta estб registrada",string,"Enviar","Salir");

            }

            else if(!Rows)

            {

                LimpiarChat(extraid, 100, 1);

                new pName[50]; GetPlayerName(extraid, pName, 50);

                format(string, sizeof(string), "Ingresa tu contraseсa:", pName);

                ShowPlayerDialog(extraid, REGISTRO, DIALOG_STYLE_PASSWORD,"Registra una nueva cuenta",string,"Enviar","Salir");

            }

        }

        case 5:

        {

            if(Rows == 1)

            {

                new stringo[128],pName[32],query[200];

                GetPlayerName(extraid, pName, 32);

                format(stringo, 128, "Banda: {009BE4}%s{FFFFFF} fuй expulsado de la banda por {009BE4}%s{FFFFFF}.",PlayerInfo[extraid][pExpulsando], pName);

                SendRadioMessage(PlayerInfo[extraid][jMiembro], -1, stringo,INVALID_PLAYER_ID);

                SCM(extraid, COLOR_AMARILLO, stringo);

                BandasInfo[PlayerInfo[extraid][jMiembro]-1][BIntegrantes]--;

                format(query, 200, "UPDATE `facciones` SET `Integrantes`='%d' WHERE `id`='%d'",BandasInfo[PlayerInfo[extraid][jMiembro]-1][BIntegrantes],PlayerInfo[extraid][jMiembro]);

                mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, extraid);

                format(query, 200, "UPDATE `usuarios` SET `Faccion`='0',`Rango`='0',`Duty`='0' WHERE `Username`='%s'",PlayerInfo[extraid][pExpulsando]);

                mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, extraid);

            }

            else if(!Rows)

            {

                SCM(extraid, -1, "Este jugador es invalido o no esta en tu banda.");

            }

        }

        case 6:

        {

            if(Rows >= 1)

            {

                if(Rows > 50) Rows = 50;

                new type, queryString[180];

                for(new i = 0; i < Rows ; i++)

                {

                    ActionQueue[i][qID] = cache_get_field_content_int(i, "ID");

                    ActionQueue[i][qfaccj] = cache_get_field_content_int(i, "faccj");

                    cache_get_field_content(i, "user_ses", ActionQueue[i][quser_ses], Conecction, 23);

                    cache_get_field_content(i, "jugname", ActionQueue[i][qjugname], Conecction, 23);

                    cache_get_field_content(i, "queue_params", ActionQueue[i][qparams], Conecction, 23);

                    ActionQueue[i][qstatus] = cache_get_field_content_int(i, "status");

                    type = cache_get_field_content_int(i, "type");

                    if(ActionQueue[i][qstatus] == 0)

                    {

                        new qString[128];

                        switch(type) // 1 aceptar invitacion, 2 cambiar rango, 3 expulsar, 4 abandonar banda

                        {

                            case 1:

                            {

                                 ActionQueue[i][qstatus] = 1;

                                format(qString, 128, "jugadorinvitacion %d %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses]);

                                CustomProc(qString);

                            }

                            case 2:

                            {

                                if(!strcmp(ActionQueue[i][qparams], "nada", true))

                                {

                                    ActionQueue[i][qstatus] = 2;

                                }

                                new gRank;

                                sscanf(ActionQueue[i][qparams], "p<|>d", gRank);

                                format(qString, 128, "gMemberRank %d %d %s %s", ActionQueue[i][qfaccj], gRank, ActionQueue[i][quser_ses], ActionQueue[i][qjugname]);

                                CustomProc(qString);

                            }

                            case 3:

                            {

                                ActionQueue[i][qstatus] = 1;

                                format(qString, 128, "expulsarmiembro %d %s %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses], ActionQueue[i][qjugname]);

                                CustomProc(qString);

                            }

                            case 4:

                            {

                                ActionQueue[i][qstatus] = 1;

                                format(qString, 128, "abandonarbanda %d %s", ActionQueue[i][qfaccj], ActionQueue[i][quser_ses]);

                                CustomProc(qString);

                            }

                            case 5:

                            {

                                ActionQueue[i][qstatus] = 1;

                                format(qString, 128, "recargarbandas");

                                CustomProc(qString);

                            }

                        }

                        mysql_format(Conecction, queryString, 128, "UPDATE `action_queue` SET `status` = '%d' WHERE `ID` = '%d'", ActionQueue[i][qstatus], ActionQueue[i][qID]);

                        mysql_format(Conecction, queryString, 128, "DELETE FROM `action_queue` WHERE `ID` = '%d'", ActionQueue[i][qID]);

                        mysql_tquery(Conecction, queryString, "");

                    }

                }

            }

        }

    }

    return 1;

}

RioYX · 23.02.2017, 15:05

Still the error follows, GOD! T-T

Vince · 23.02.2017, 16:37

This script is making me cringe so hard. If you need a fifth vehicle are you going to add another 50 columns? What if you need twenty extra vehicles? A thousand extra columns? What if you want to store more items in the trunk? Even more extra columns. This is not how you use SQL. Think ahead! This setup requires at least five different tables, and probably more too.

Properly normalized the "car section" should look somewhat like this:

Yes, you would need a few more queries but your codebase would be smaller and much more expandable.

RioYX · 23.02.2017, 16:51

I do not understand anything you say, I just need help because it comes "0" and not a brief explanation of how to design a car lol.

RioYX · 24.02.2017, 14:39

revive, help please T_T

RioYX · 25.02.2017, 19:00

Revive up, please.!

Login
Username:
Password:	Lost Password?
	Remember me