Pawn Help - Split MySQL - Printable Version

Code:
[color=#24292e][size=x-small][font=SFMono-Regular, Consolas, "Liberation Mono", Menlo, monospace]// MySQL:

 g_MysqlRaceCheck[playerid];



 // create orm instance and register all needed variables

 new ORM: ormid = PlayerInfo[playerid][ORM_ID] = orm_create("player", mySQL_Server);



 orm_addvar_int(ormid, PlayerInfo[playerid][pID], "id");

 orm_addvar_string(ormid, PlayerName[playerid], MAX_PLAYER_NAME, "nome");

 orm_addvar_string(ormid, PlayerInfo[playerid][pKey], 65, "senha");

 orm_addvar_int(ormid, PlayerInfo[playerid][pLevel], "level");

 orm_addvar_int(ormid, PlayerInfo[playerid][pExp], "respeitos");

 orm_addvar_int(ormid, PlayerInfo[playerid][pConnectTime], "horas_jogadas");

 orm_addvar_int(ormid, PlayerInfo[playerid][pCash], "dinheiro");

 orm_addvar_int(ormid, PlayerInfo[playerid][pConta], "dinheiro_banco");

 orm_addvar_int(ormid, PlayerInfo[playerid][pOuros], "ouros");

 orm_addvar_int(ormid, PlayerInfo[playerid][pCashVip], "cash");

 orm_addvar_int(ormid, PlayerInfo[playerid][pKills], "assassinatos");

 orm_addvar_int(ormid, PlayerInfo[playerid][pDeaths], "mortes");

 orm_addvar_int(ormid, PlayerInfo[playerid][pSkin], "skin");

 orm_addvar_int(ormid, PlayerInfo[playerid][pPayDay], "timer_payday");

 orm_addvar_int(ormid, PlayerInfo[playerid][pPegouVIP], "vip_pegou");



 new string_save[355];

 new string_read[18][60];

 new string[50];

 for(new carro; carro < MAX_PLAYER_CARROS; carro)

 {

 // Veiculo informa??es

 format(string, sizeof string, "veiculo_%d", carro);

 orm_addvar_string(ormid, string_save, sizeof (string_save), string);



 split(string_save, string_read, '|');



 PlayerConce[playerid][carro][conce_valid]? = strval(string_read[0]);

 PlayerConce[playerid][carro][conce_model]? = strval(string_read[1]);

 PlayerConce[playerid][carro][conce_pos][0] = floatstr(string_read[2]);

 PlayerConce[playerid][carro][conce_pos][1] = floatstr(string_read[3]);

 PlayerConce[playerid][carro][conce_pos][2] = floatstr(string_read[4]);

 PlayerConce[playerid][carro][conce_pos][3] = floatstr(string_read[5]);

 PlayerConce[playerid][carro][conce_health] = floatstr(string_read[6]);

 PlayerConce[playerid][carro][conce_color][0] = strval(string_read[7]);

 PlayerConce[playerid][carro][conce_color][1] = strval(string_read[8]);

 PlayerConce[playerid][carro][conce_preco] = strval(string_read[9]);

 PlayerConce[playerid][carro][conce_gasolina] = strval(string_read[10]);

 PlayerConce[playerid][carro][conce_estacionado] = strval(string_read[11]);

 PlayerConce[playerid][carro][conce_seguro] = strval(string_read[12]);

 PlayerConce[playerid][carro][conce_alarme]? = strval(string_read[13]);

 PlayerConce[playerid][carro][conce_date] = strval(string_read[14]);

 PlayerConce[playerid][carro][conce_despesas] = strval(string_read[15]);

 format(PlayerConce[playerid][carro][conce_placa], 25, string_read[16]);

 format(PlayerConce[playerid][carro][conce_textol], 75, string_read[17]);



 // Tunning

 format(string, sizeof string, "tune_%d", carro);

 orm_addvar_string(ormid, string_save, 258, string);



 split(string_save, string_read, '|');



 for(new component; component != 15; component) {

 PlayerConce[playerid][carro][conce_tune][component] = strval(string_read[component]);

 }

 }

 for(new index; index != MAX_PLAYER_ATTACHED_OBJECTS; index) 

 {

 // Acessorios Informa??es

 format(string, sizeof string, "itens_%d", index);

 orm_addvar_string(ormid, string_save, sizeof(string_save), string);

 

 split(string_save, string_read, '|');

 

 format(acessorioInfo[playerid][index][acessorioNome], 75, string_read[1]);

 acessorioInfo[playerid][index][acessorioValid]? = strval(string_read[0]);

 acessorioInfo[playerid][index][acessorioModelo] = strval(string_read[2]);

 acessorioInfo[playerid][index][acessorioBone] = strval(string_read[3]);

 // Coordenadas

 acessorioInfo[playerid][index][acessorioPos][0] = floatstr(string_read[4]);

 acessorioInfo[playerid][index][acessorioPos][1] = floatstr(string_read[5]);

 acessorioInfo[playerid][index][acessorioPos][2] = floatstr(string_read[6]);

 // Rota??o

 acessorioInfo[playerid][index][acessorioRot][0] = floatstr(string_read[7]);

 acessorioInfo[playerid][index][acessorioRot][1] = floatstr(string_read[8]);

 acessorioInfo[playerid][index][acessorioRot][2] = floatstr(string_read[9]);

 // Tamanho

 acessorioInfo[playerid][index][acessorioTam][0] = floatstr(string_read[10]);

 acessorioInfo[playerid][index][acessorioTam][1] = floatstr(string_read[11]);

 acessorioInfo[playerid][index][acessorioTam][2] = floatstr(string_read[12]);

 }



 orm_setkey(ormid, "nome");



 // tell the orm system to load all data, assign it to our variables and call our callback when ready

 orm_load(ormid, "OnPlayerLoginCheck", "dd", playerid, g_MysqlRaceCheck[playerid]);[/font][/size][/color]