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]