nikas455 Posted June 8, 2015 Report Share Posted June 8, 2015 how to tie 30 plot and player. without "life plot" and "group manager"? Link to comment Share on other sites More sharing options...
0 SchwEde Posted June 8, 2015 Report Share Posted June 8, 2015 Inventing your own system. Link to comment Share on other sites More sharing options...
0 Guest Posted June 8, 2015 Report Share Posted June 8, 2015 Plot for Life is not actually a system or something like that. It's a name for the process of saving entries to the database. Without saving entries to the database you won't be able to have persistent plots, that simple. Link to comment Share on other sites More sharing options...
0 Angrygargamel Posted June 8, 2015 Report Share Posted June 8, 2015 there was some function to implement in the mysql database which sets you as owner when you die -> when a new player id is added (when you die and respawn) EDIT: alright girls and gals ^^ here is what i had running on my servers fine for many months... its a trigger which resets you as the owner after you got respawned CREATE TRIGGER `update_owner` AFTER INSERT ON `character_data` FOR EACH ROW BEGIN UPDATE object_data SET CharacterID = NEW.CharacterID WHERE CharacterID IN (SELECT CharacterID FROM character_data WHERE PlayerUID = NEW.PlayerUID) AND NOT (Classname LIKE '%door%' OR Classname LIKE '%vault%' OR Classname LIKE '%box%'); END try it out... it works... Link to comment Share on other sites More sharing options...
0 Buck0 Posted June 9, 2015 Report Share Posted June 9, 2015 Would just learn how to install the mods you "dont want" Updating database via a trigger constantly is not something i would do Link to comment Share on other sites More sharing options...
0 nikas455 Posted June 9, 2015 Author Report Share Posted June 9, 2015 there was some function to implement in the mysql database which sets you as owner when you die -> when a new player id is added (when you die and respawn) EDIT: alright girls and gals ^^ here is what i had running on my servers fine for many months... its a trigger which resets you as the owner after you got respawned CREATE TRIGGER `update_owner` AFTER INSERT ON `character_data` FOR EACH ROW BEGIN UPDATE object_data SET CharacterID = NEW.CharacterID WHERE CharacterID IN (SELECT CharacterID FROM character_data WHERE PlayerUID = NEW.PlayerUID) AND NOT (Classname LIKE '%door%' OR Classname LIKE '%vault%' OR Classname LIKE '%box%'); END try it out... it works... how to add xampp? Link to comment Share on other sites More sharing options...
0 Angrygargamel Posted June 9, 2015 Report Share Posted June 9, 2015 Updating database via a trigger constantly is not something i would do i dont see any reason why not... or any problems if you do... mysql is capable of much more than simple triggers like that without any problems... also this method is approved by many other users which use this for a long time now... but hey.... do whatever you want man ^^ i am just showing up another working alternative method here... how to add xampp? what exactly do you mean? how to add xampp on your server? or how to add this with xampp? i for my part wouldnt use xampp at all...but thats your decision to make... SchwEde 1 Link to comment Share on other sites More sharing options...
0 nikas455 Posted June 10, 2015 Author Report Share Posted June 10, 2015 i dont see any reason why not... or any problems if you do... mysql is capable of much more than simple triggers like that without any problems... also this method is approved by many other users which use this for a long time now... but hey.... do whatever you want man ^^ i am just showing up another working alternative method here... what exactly do you mean? how to add xampp on your server? or how to add this with xampp? i for my part wouldnt use xampp at all...but thats your decision to make... or how to add this with xampp? Sorry, not speak english Link to comment Share on other sites More sharing options...
0 Angrygargamel Posted June 10, 2015 Report Share Posted June 10, 2015 with xampp you should have phpmyadmin or something similar to administrate the database... login to this tool select the database and then import these lines nikas455 1 Link to comment Share on other sites More sharing options...
Question
nikas455
how to tie 30 plot and player. without "life plot" and "group manager"?
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now