13.05.2017, 05:07
Hey.
I need to save in database 8 ranks. Like, rank_1, rank_2 ... rank_8.
What is the best way to do this?
Actually ;
Edit: Also, loading ranks is painfull :
I need to save in database 8 ranks. Like, rank_1, rank_2 ... rank_8.
What is the best way to do this?
Actually ;
PHP код:
CREATE TABLE `---`.`---` ( `---` INT NOT NULL AUTO_INCREMENT , `rank_1` VARCHAR(35) NOT NULL , `rank_2` VARCHAR(35) NOT NULL , `rank_3` VARCHAR(35) NOT NULL , `rank_4` VARCHAR(35) NOT NULL , `rank_5` VARCHAR(35) NOT NULL , `rank_6` VARCHAR(35) NOT NULL , `rank_7` VARCHAR(35) NOT NULL , `rank_8` VARCHAR(35) NOT NULL , PRIMARY KEY (`faction_id`)) ENGINE = InnoDB;
PHP код:
PUBLIC:OnRanksLoading()
{
new temporaire,
nbRank = cache_num_rows();
for(new i; i != nbRank; i++)
{
cache_get_value_int(i, "SQLID", temporaire); // SQLID
cache_get_value(i, "rank_0", f_RankName[temporaire][0], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_1", f_RankName[temporaire][1], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_2", f_RankName[temporaire][2], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_3", f_RankName[temporaire][3], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_4", f_RankName[temporaire][4], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_5", f_RankName[temporaire][5], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_6", f_RankName[temporaire][6], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_7", f_RankName[temporaire][7], MAX_FAC_RANK_NAME);
cache_get_value(i, "rank_8", f_RankName[temporaire][8], MAX_FAC_RANK_NAME);
}
}