Help and discussion for custom spawn points based on UID begins here...
After pasting the trigger code ( the second peice of code ) did you make sure you added $$ to the delimiter text box before pressing ok?
just gave it a try. didnt work unfortunatly. I created the table with the
Code:CREATE TABLE `cust_spawn` ( `unique_id` INT(10) NULL DEFAULT NULL, `worldspace` VARCHAR(50) NULL DEFAULT NULL ) COLLATE='utf8_general_ci' ENGINE=InnoDB;
inserter my uid # (not the GUID)
then inserted rog as my worldspace.
then ran the sql query in phpmyadmin cuz navicat didnt like some permissions or somthing.
it ran without a hitch but when i logged in i was still where i was at before, then i killed myself to test and i was at the shore again.
dont know if i went wrong somewhere.
thanks for the help.
How easily could we tie this to a specific object from base building would you say?
Something along the lines of a custom building I'd add with very difficult to get materials (Find and craft) - At which point the person can deploy it and have it attached to their UID permanently.
When trying to create the trigger nothing seems to happen, "loading" for a split second, then no error/complete message. Using phpMyadmin
After pasting the trigger code ( the second peice of code ) did you make sure you added $$ to the delimiter text box before pressing ok?