Burgershot
2019-12-13, 07:34 PM
Hello everyone,
i created a similar mysql login/register system now like this example here: https://github.com/pBlueG/SA-MP-MySQL/bl...-cache.pwn
The only thing i changed is: i dont assign default values after registering server side. I want to get them from db, since i added it there as defaults if a new player registers an account.
How i did this is: if we assume the functions are all the same as the example above, i called in .
Login works fine, but if trying to "AssignPlayerData" after registration i get this error for every data i want to to get.
If im thinking right, this is because the entire query to get data is in OnPlayerConnect, and if account does not exists we have no row for that player. So do i need to do the same query again after registering the player and before "AssignPlayerData" ? Is this the right way, or is there a cleaner way?
i created a similar mysql login/register system now like this example here: https://github.com/pBlueG/SA-MP-MySQL/bl...-cache.pwn
The only thing i changed is: i dont assign default values after registering server side. I want to get them from db, since i added it there as defaults if a new player registers an account.
How i did this is: if we assume the functions are all the same as the example above, i called
Code:
AssignPlayerData(playerid)Code:
public OnPlayerRegister(playerid)Login works fine, but if trying to "AssignPlayerData" after registration i get this error for every data i want to to get.
Code:
[plugins/mysql] cache_get_value_name_int: invalid row index '0' (number of rows: '0')If im thinking right, this is because the entire query to get data is in OnPlayerConnect, and if account does not exists we have no row for that player. So do i need to do the same query again after registering the player and before "AssignPlayerData" ? Is this the right way, or is there a cleaner way?