[None1337]

Quote:

Originally Posted by ****** Again, why are you storing multiple values in a single column? That's really not how you should be using a database. Make a new table for the object IDs and store one per row.

Sorry, my bad. I didn't understand the question.

I already have a table with all objects and x,y,z: https://imgur.com/a/jmB80p3

So, above is a pictures with all the objects and x,y,z. When a new player register, he got some random objectID from this table, and all the id that player get, i'm saving in a different table.

And i'm using something like that to save the id in database.

Код:

public saveQuest(playerid) {

  generateIdRandomFromDb(playerid);

new string[256];
string[0] = (EOS);


for(new x; x < 50; x++) {
          format(string, sizeof string, "%s %d", questInfo[playerid][databaseID_object][x]);
}

mysql_format(db, string, sizeof string, "UPDATE `special_table` SET `objectID` = '%e' WHERE `playerID` = %d LIMIT 1;", string, pID[playerid]);
mysql_tquery(db, string);

}

This is the most easier way to do for myself and for the system. Better ways aren't (I think).
And simply, when a player connect, i've loaded his id of an object from database:

Код:

// public LoadQuest (playerid) {
     mysql_format(db, Gstring, "SELECt blablabla.... WHERE id .. bla blabla
    mysql_tquery(db, Gstrin, bla bla bla..
}


//another public

public finishLoad(playerid) {
if(!cache_num_rows()) return 1;

new show_s[300], var_storage[50];
cache_get_field_content(0, "ObjectID", show_s);
sscanf(show_s, "a<i>[50]", var_storage);

for(new x; x < 50; x++) {
        questInfo[playerid][databaseID_object][x] = var_storage[x];

}

}

So every think work perfectly, but i don't know how to store in php the objectID in a array like $var_storage[x]
to make a loop and create red marker on the San Andreas map.