[Release] New players get starting money

[creativv]

18 minutes ago, Buck0 said:

A quick email to a service provder would have that resolved in 15 mins if it was the case. Why are you even involved and dragging this to these forums. 

Holy shit lol

See how you feel when you give something to someone , he takes a strole around the corner and he get's mugged from the shit you gave him mate .......

People are Always high and mighty about when someone joins a server to steal stuff from somebody else's mission file and now your acting like this ......

Apperently it is allright to do it when you work together with someone and then because one is to greedy to keep all donations for himself that he locks the other out of the database , ftp and all for his own server .

Seen you post more stuff had certain amount of respect for you since you help out allot of people , you just lost it .

Thats all i got to say have fun guys

[Shawn]

Why is this getting spammed on the forums for? It has been sorted. Spamming forums gets nothing done.

[DangerRuss]

I tried that trigger as well and it produces another error. I'm not by my pc right now to paste the error.  

[DangerRuss]

On 3/19/2016 at 4:03 PM, Hoplox said:

Try this instead:

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

 

The new error
 

---------------------------
Error
---------------------------
SQL Error (1235): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
---------------------------
OK   
---------------------------

 

[Hoplox]

3 minutes ago, DangerRuss said:

The new error
 

---------------------------
Error
---------------------------
SQL Error (1235): This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
---------------------------
OK   
---------------------------

 

You may already have this trigger in your database. If so, look for this line:

(NEW.PlayerUID, NEW.PlayerName, 100000, NOW())

and change the 100000 to any value of your choice.

[DangerRuss]

oh yes I looked around and it was in a fix I had set up for something else.. nice! good catch. ty

[Hoplox]

1 minute ago, DangerRuss said:

oh yes I looked around and it was in a fix I had set up for something else.. nice! good catch. ty

No problem. :) Goodluck with this on your server and have a nice day. :)

[ckto]

anyway to make it work for SC 3.0? Thanks.

[Buck0]

3.0 doesnt use banks, so no

[ckto]

I managed to swap to SC 4.0 and apply this script to the database but i want to change to 300k insted of 100k,

how can i change it? Already applyed the trigger; thanks

[Hoplox]

2 hours ago, ckto said:

I managed to swap to SC 4.0 and apply this script to the database but i want to change to 300k insted of 100k,

how can i change it? Already applyed the trigger; thanks

Change the 100000 to 300000.

[ckto]

35 minutes ago, Hoplox said:

Change the 100000 to 300000.

Managed to change it on HeidiSQL.

BUT ins't working for me.Am I doing something wrong maybe...

[Hoplox]

9 minutes ago, ckto said:

Managed to change it on HeidiSQL.

BUT ins't working for me.Am I doing something wrong maybe...

Remember, it is only for fresh brand new players on your server. You can test it by wiping your player_data and login_data, then launching your server and joining again. The money will go into the bank of the player.

[ckto]

13 hours ago, Hoplox said:

Remember, it is only for fresh brand new players on your server. You can test it by wiping your player_data and login_data, then launching your server and joining again. The money will go into the bank of the player.

I understand now, thanks!

Gonna wait to see a new player arround ^^

 

-----

 

Edit : It really worked with new players, thank you very much!

[Hoplox]

2 minutes ago, ckto said:

I understand now, thanks!

Gonna wait to see a new player arround ^^

Alright, hope it works well on your server. Feel free to ask anymore questions if you require support.  :)

[JohnnyBravo666]

I was having this same issue where it wouldn't do that after I had wiped the database. I inserted a trigger to automatically force it to when a new player joins the server.

[Hoplox]

10 minutes ago, JohnnyBravo666 said:

I was having this same issue where it wouldn't do that after I had wiped the database. I inserted a trigger to automatically force it to when a new player joins the server.

Have you fixed it now?

 

[JohnnyBravo666]

Just now, Hoplox said:

Have you fixed it now?

 

Yes I have. The trigger worked perfectly. I'll post below so if anyone else wants to give the trigger a try if they continue having problems too.

*********************************************************************************************************************************************************************************

CREATE DEFINER=`<databaseusername>`@`%` TRIGGER `bankingissuefix` BEFORE INSERT ON `player_data` FOR EACH ROW INSERT INTO banking_data
( PlayerUID, PlayerName, BankSaldo,  LastUpdated)
VALUES
(NEW.PlayerUID, NEW.PlayerName, 50000, NOW())

[creativv]

It will only work if there is no banking_Data for the player and no Player_data ...

Otherwise you will get duplicate entry message on console

[Seelanpro]

Thanks :DDDD

This is amazing!

[Thug]

So now I'm confused, after all the going back and forth over who did what I have a question.

I have one server with 999 coin on it and another with zupa 3.0.  Which server will this work for?

 

[Tech_Support]

20 hours ago, Thug said:

So now I'm confused, after all the going back and forth over who did what I have a question.

I have one server with 999 coin on it and another with zupa 3.0.  Which server will this work for?

 

The version that adds "banking_data" Table in the SQL database. (edited)

[Thug]

12 hours ago, Tech_Support said:

"player_data" table in the SQL database.

In my data base under player_data is PlayerUID, PlayerName, PlayerMorality, PlayerSex

The money that the players earned is stored in PlayerMorality.

Do I replace banking_data with PlayMorality where it says it below? If not anyone know what to do?

FOR EACH ROW INSERT INTO banking_data

 

[theduke]

On 11/18/2016 at 0:19 PM, Thug said:

In my data base under player_data is PlayerUID, PlayerName, PlayerMorality, PlayerSex

The money that the players earned is stored in PlayerMorality.

Do I replace banking_data with PlayMorality where it says it below? If not anyone know what to do?

FOR EACH ROW INSERT INTO banking_data

 

No, the only version this will work for is the version that has global banking. If you look in your database, you will see a extra table. Its the banking_data table.