[NeXoR]

Quote:

Originally Posted by Gammix Yes if you have default values such as 0, there is no need to set it while registering a new row. Default values can be set when you are creating a column in a MySQL table, either by code or manually. For example: You have default values of `Admin`, `VIP` etc. as 0. So your query can be: pawn Код: mysql_format(mysql, query, sizeof(query), "INSERT INTO `players` (`Username`, `Password`, `IP`) VALUES ('%e', '%s', '%s')", Name[playerid], pInfo[playerid][Password], IP[playerid]);

Makes sense indeed, thank you
Regarding player load
How can I load everything without a mass code ?
Example for mass code

PHP код:

pInfo[playerid][Admin] = cache_get_field_content_int(0, "Admin"); //we're getting a field 4 from row 0. And since it's an integer, we use cache_get_row_int
     pInfo[playerid][VIP] = cache_get_field_content_int(0, "VIP"); //Above
     pInfo[playerid][Money] = cache_get_field_content_int(0, "Money");//Above
     pInfo[playerid][posX] = cache_get_field_content_float(0, "PosX");//Above. Since player's position is a float, we use cache_get_field_content_float
     pInfo[playerid][posY] = cache_get_field_content_float(0, "PosY");//Above
     pInfo[playerid][posZ] = cache_get_field_content_float(0, "PosZ");//Above 


Edit - in default values on column edition
Shall I put it NULL or otherwise?