how to tie 30 plot and player. without "life plot" and "group manager"?

[nikas455]

how to tie 30 plot and player. without "life plot" and "group manager"?

[SchwEde]

Inventing your own system.

[Guest]

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.

[Angrygargamel]

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...

[Buck0]

Would just learn how to install the mods you "dont want"

Updating database via a trigger constantly is not something i would do

[nikas455]

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?

[Angrygargamel]

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...

[nikas455]

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

[Angrygargamel]

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