Ethos

Players don't save to Account Table

12 posts in this topic

I have an issue where players don't save to the account table in my exile database, they show up in players and recent players but if they disconnect and reconnect they have the whole "spawning as a rabbit" business where they are at feet level on the map and cant move around etc. if they commit suicide and try to re-spawn the game kicks them saying error character request timed out.

MySQL is not in strict mode either lol, any suggestions? if you need more info I'd be happy to provide, just let me know what you need.

currently the server is running Exile and CBA with DMS missions

Share this post


Link to post
Share on other sites
Advertisement

Only players or admin's too? So finally all players?

Be sure ur extdb is running and exile is connected to the db...all tables are implemented?

Which exile version are running?

Share this post


Link to post
Share on other sites

We are having the exact same problem.
Also running CBA. Seen this comming back a few times before in other topics that CBA might be the culperate.
Gonna have to test this tomorrow.

Running Tanoa with latest Exile version.
Mods: CBA, CUP w/v/u, Ryan zombies, DMS, Zupa Capture Points with infistar.
 

[22:03:28:282877 +00:-1] [Thread 109200] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Input String setAccountMoneyAndRespect:70:320:76561198057206805
[22:03:28:282919 +00:-1] [Thread 109200] extDB2: SQL_CUSTOM_V2: Error No Custom Call Not Found: Callname setAccountMoneyAndRespect

These errors are the only ones showing up in the DB log.

Edited by Ambu5h

Share this post


Link to post
Share on other sites

Additionaly, the problem lies within the DB where the account table is not filled in but the players table includes the player and its statistics.
This will make them spawn underground with a blanco character.

Made this Query to give you insight over who cant connect.
 

SELECT * FROM `player` WHERE `account_uid` IS NOT NULL AND NOT EXISTS( SELECT `uid` FROM `account` WHERE `uid` = `account_uid`)

This gives you all the players that are pressent in the Players table but NOT in the accounts table.

Share this post


Link to post
Share on other sites
42 minutes ago, Ambu5h said:

Additionaly, the problem lies within the DB where the account table is not filled in but the players table includes the player and its statistics.
This will make them spawn underground with a blanco character.

Made this Query to give you insight over who cant connect.
 


SELECT * FROM `player` WHERE `account_uid` IS NOT NULL AND NOT EXISTS( SELECT `uid` FROM `account` WHERE `uid` = `account_uid`)

This gives you all the players that are pressent in the Players table but NOT in the accounts table.

a simpler way of doing that is:

SELECT * FROM player WHERE account_uid NOT IN (SELECT uid FROM account)

 

Share this post


Link to post
Share on other sites
17 minutes ago, second_coming said:

a simpler way of doing that is:


SELECT * FROM player WHERE account_uid NOT IN (SELECT uid FROM account)

 

Haha alright... well back to getting some SQL lession i guess :p.
Ill try and add that to the mission init.sqf see if that changes some things.

THX ALOT of the reply! Very limited stuff seems to be available on this problem.

Edited by Ambu5h

Share this post


Link to post
Share on other sites

You could create a trigger on the player table to just handle it

delimiter //
CREATE TRIGGER `player_before_insert` BEFORE INSERT ON `player` FOR EACH ROW BEGIN
  if new.`account_uid` not in (select distinct `uid` from account) then
  insert into account (`uid`, `name`) values (new.`account_uid`, new.`name`);
  END IF;
END
//
delimiter ;

This will make an entry in account if the uid doesn't exist already. You may need to change this up though, just an example of how to do it.

Share this post


Link to post
Share on other sites
Advertisement

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Recently Browsing   0 members

    No registered users viewing this page.