creativv Posted March 20, 2016 Report Share Posted March 20, 2016 On 3/20/2016 at 12:23 PM, 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 Expand 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 Link to comment Share on other sites More sharing options...
Shawn Posted March 20, 2016 Report Share Posted March 20, 2016 Why is this getting spammed on the forums for? It has been sorted. Spamming forums gets nothing done. Hoplox 1 Link to comment Share on other sites More sharing options...
DangerRuss Posted March 22, 2016 Report Share Posted March 22, 2016 I tried that trigger as well and it produces another error. I'm not by my pc right now to paste the error. Link to comment Share on other sites More sharing options...
DangerRuss Posted March 22, 2016 Report Share Posted March 22, 2016 On 3/19/2016 at 8: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()) Expand 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 --------------------------- Link to comment Share on other sites More sharing options...
Hoplox Posted March 22, 2016 Author Report Share Posted March 22, 2016 On 3/22/2016 at 6:57 PM, 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 --------------------------- Expand 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. Link to comment Share on other sites More sharing options...
DangerRuss Posted March 22, 2016 Report Share Posted March 22, 2016 oh yes I looked around and it was in a fix I had set up for something else.. nice! good catch. ty Hoplox 1 Link to comment Share on other sites More sharing options...
Hoplox Posted March 22, 2016 Author Report Share Posted March 22, 2016 On 3/22/2016 at 8:18 PM, DangerRuss said: oh yes I looked around and it was in a fix I had set up for something else.. nice! good catch. ty Expand No problem. :) Goodluck with this on your server and have a nice day. :) Link to comment Share on other sites More sharing options...
ckto Posted March 23, 2016 Report Share Posted March 23, 2016 anyway to make it work for SC 3.0? Thanks. Link to comment Share on other sites More sharing options...
Buck0 Posted March 23, 2016 Report Share Posted March 23, 2016 3.0 doesnt use banks, so no Link to comment Share on other sites More sharing options...
ckto Posted March 23, 2016 Report Share Posted March 23, 2016 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 Link to comment Share on other sites More sharing options...
Hoplox Posted March 23, 2016 Author Report Share Posted March 23, 2016 On 3/23/2016 at 9:51 PM, 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 Expand Change the 100000 to 300000. Link to comment Share on other sites More sharing options...
ckto Posted March 24, 2016 Report Share Posted March 24, 2016 On 3/23/2016 at 11:55 PM, Hoplox said: Change the 100000 to 300000. Expand Managed to change it on HeidiSQL. BUT ins't working for me.Am I doing something wrong maybe... Link to comment Share on other sites More sharing options...
Hoplox Posted March 24, 2016 Author Report Share Posted March 24, 2016 On 3/24/2016 at 12:32 AM, ckto said: Managed to change it on HeidiSQL. BUT ins't working for me.Am I doing something wrong maybe... Expand 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. Link to comment Share on other sites More sharing options...
ckto Posted March 24, 2016 Report Share Posted March 24, 2016 On 3/24/2016 at 12:42 AM, 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. Expand I understand now, thanks! Gonna wait to see a new player arround ^^ ----- Edit : It really worked with new players, thank you very much! Link to comment Share on other sites More sharing options...
Hoplox Posted March 24, 2016 Author Report Share Posted March 24, 2016 On 3/24/2016 at 12:43 AM, ckto said: I understand now, thanks! Gonna wait to see a new player arround ^^ Expand Alright, hope it works well on your server. Feel free to ask anymore questions if you require support. :) Link to comment Share on other sites More sharing options...
JohnnyBravo666 Posted March 25, 2016 Report Share Posted March 25, 2016 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. Link to comment Share on other sites More sharing options...
Hoplox Posted March 25, 2016 Author Report Share Posted March 25, 2016 On 3/25/2016 at 9:05 PM, 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. Expand Have you fixed it now? Link to comment Share on other sites More sharing options...
JohnnyBravo666 Posted March 25, 2016 Report Share Posted March 25, 2016 On 3/25/2016 at 9:15 PM, Hoplox said: Have you fixed it now? Expand 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()) Hoplox 1 Link to comment Share on other sites More sharing options...
creativv Posted March 27, 2016 Report Share Posted March 27, 2016 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 Link to comment Share on other sites More sharing options...
Seelanpro Posted August 23, 2016 Report Share Posted August 23, 2016 Thanks :DDDD This is amazing! Link to comment Share on other sites More sharing options...
Thug Posted November 18, 2016 Report Share Posted November 18, 2016 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? Link to comment Share on other sites More sharing options...
Tech_Support Posted November 18, 2016 Report Share Posted November 18, 2016 On 11/18/2016 at 3:05 AM, 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? Expand The version that adds "banking_data" Table in the SQL database. (edited) Link to comment Share on other sites More sharing options...
Thug Posted November 18, 2016 Report Share Posted November 18, 2016 On 11/18/2016 at 5:09 AM, Tech_Support said: "player_data" table in the SQL database. Expand 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 Link to comment Share on other sites More sharing options...
theduke Posted November 20, 2016 Report Share Posted November 20, 2016 On 11/18/2016 at 4: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 Expand 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now