Problems getting comma separated values

Problems getting comma separated values - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Problems getting comma separated values (/showthread.php?tid=660724)

Problems getting comma separated values - JaskaranSingh - 11.11.2018

I want to store multiple values in one field in the MySQL database.

This is the way I am currently using to store data (convert to string and concatenate a comma)

PHP код:



for(new i = 0; i < 10; i++) {

        Player[playerid][playerPmBlocks][i] = 0;

        valstr(temp, Player[playerid][playerPmBlocks][i]);

        strcat(blockstring, temp, sizeof(blockstring));

        strcat(blockstring, ",", sizeof(blockstring));

    }

This is my enum:

PHP код:



enum PlayerInfo {

    playerPmBlocks[255]

};

new Player[MAX_PLAYERS][PlayerInfo];

When I get the data, I am using

PHP код:



cache_get_value(0, "ppmblocks", tempblocks, 255);

Please tell me a way to remove these commas and store back into the array I am using in the enum.

Also, I am highly unsatisfied by this code. If you guys have any better way to do this, please let me know. This is an urgency.

Re: Problems getting comma separated values - Calisthenics - 11.11.2018

Quote:

Originally Posted by JaskaranSingh

Also, I am highly unsatisfied by this code. If you guys have any better way to do this, please let me know.

Glad you are because storing multiple values into a single column is the wrong way to go. What you need is another table.

Re: Problems getting comma separated values - khRamin78 - 11.11.2018

Quote:

Originally Posted by JaskaranSingh

I want to store multiple values in one field in the MySQL database.

This is the way I am currently using to store data (convert to string and concatenate a comma)

PHP код:



for(new i = 0; i < 10; i++) {

        Player[playerid][playerPmBlocks][i] = 0;

        valstr(temp, Player[playerid][playerPmBlocks][i]);

        strcat(blockstring, temp, sizeof(blockstring));

        strcat(blockstring, ",", sizeof(blockstring));

    }

This is my enum:

PHP код:



enum PlayerInfo {

    playerPmBlocks[255]

};

new Player[MAX_PLAYERS][PlayerInfo];

When I get the data, I am using

PHP код:



cache_get_value(0, "ppmblocks", tempblocks, 255);

just use loop trough string until it finds the the comma and until that [i mean like string[128] > string[4] = ","]

then get the string[0-3] characters and store them then remove them from string and repeat that again until the string size ends

or you can use strfind > https://sampwiki.blast.hk/wiki/Strfind

Edit : Using mixed script of functions of >>
StrFind
Strmid

Re: Problems getting comma separated values - khRamin78 - 11.11.2018

Quote:

Originally Posted by Calisthenics

Glad you are because storing multiple values into a single column is the wrong way to go. What you need is another table.

Quote:

Originally Posted by JaskaranSingh

I want to store multiple values in one field in the MySQL database.

This is the way I am currently using to store data (convert to string and concatenate a comma)

PHP код:



for(new i = 0; i < 10; i++) {

        Player[playerid][playerPmBlocks][i] = 0;

        valstr(temp, Player[playerid][playerPmBlocks][i]);

        strcat(blockstring, temp, sizeof(blockstring));

        strcat(blockstring, ",", sizeof(blockstring));

    }

This is my enum:

PHP код:



enum PlayerInfo {

    playerPmBlocks[255]

};

new Player[MAX_PLAYERS][PlayerInfo];

When I get the data, I am using

PHP код:



cache_get_value(0, "ppmblocks", tempblocks, 255);

Here i was free i just made you a simple of method

PHP код:



/* > tempblocks is your string tight ? with 255 Char size*/


new tempblocks[255]; // Defined Like This Means can store 255 chars

new tempchar = 0;

new tempstring[128];

new temparrycount = 0;

cache_get_value(0,"ppmblocks",tempblocks,255);



for(new i=0;i<sizeof(tempblocks),i++)

{


    tempchar = strfind(tempblocks,",",true); // tempchar now will have position of that , char in string


    strmid(tempstring,tempblocks,0,(tempchar-1); // now we have first string before , in tempstring

    playerPmBlocks[playerid][temparrycount] = strval(tempstring); // use strval if its a number which storing in 

    temparrycount++;

    //Now we have to Delete the part we extracted 

    strdel(tempblocks,0,tempchar);  


    if(strfind(tempblocks,",",true) == -1) { // lets check if all comos removed so get the last string which is left 

        playerPmBlocks[playerid][temparrycount] = strval(tempblocks);

        break; 

    } 

}

Re: Problems getting comma separated values - JaskaranSingh - 12.11.2018

Quote:

Originally Posted by Calisthenics

Glad you are because storing multiple values into a single column is the wrong way to go. What you need is another table.

Thank you. This saved my another 10 hours.