How do I give new players a Starting Bank?

[Bricktop]

Hey guys I just added coins and Banking to my server and was wondering how I would go about adding 300k coins to a new players bank so they would have it when they log in. But Of course I don't want them to be able to just change their name and get it again so I figure it would need to be tied to their steam UID? Any help would be appreciated. 

Thanks

[BigEgg]

You need to create a trigger:

 

CREATE TRIGGER `bankingIssueFix` AFTER INSERT ON `player_data`
 FOR EACH ROW INSERT INTO banking_data
( PlayerUID, PlayerName, BankSaldo,  LastUpdated)
VALUES
(NEW.PlayerUID, NEW.PlayerName, 0, NOW())

 

Just run the above code and change the 0 to 300000

 

Credit: @Rocu :

 

[Bricktop]

Perfect Man ~

Exactly what I needed - Thank you very much!