Life is Feudal Official Forum

[HolyCrusader]

I think if you want the players to RESPAWN at the specific location when they die, until they bind a new bind point, you can place an item such as a fountain in a neutral city (ObjectID = 96), look it up in the unmovable_objects table and note its unique item ID (example, 12345), then you can add "Set New.BindedObjectID = 12345;" to your trigger:

Code: Select all

delimiter $$
CREATE TRIGGER `t_set_first_spawn` before INSERT ON `character` FOR EACH ROW BEGIN
   set New.GeoID = 117052637;
   set New.GeoAlt = 5100;
        set New.BindedObjectID = 12345;
END;
$$


[MacDante]

I write some modification to trigger and this trigger set specific spawn point depending on the selected race.

Code: Select all

delimiter $$
CREATE DEFINER=`root`@`localhost` TRIGGER `t_set_first_spawn` BEFORE INSERT ON `character` FOR EACH ROW BEGIN
   CASE new.RaceID
      when 1 then
            set New.GeoID = 117517090;
            set New.GeoAlt = 5270;
      when 2 then
            set New.GeoID = 118017424;
            set New.GeoAlt = 6100;
      when 3 then
            set New.GeoID = 115944941;
            set New.GeoAlt = 5100;
      else
            set New.GeoID = 117052637;
            set New.GeoAlt = 5100;
   end CASE;
END;
$$

[Joeyzombie]

I apologize in advance but please bear with me, I am a complete noob to this game/SQL I tried th add trigger thing and the Query. This is the error I'm getting when I add it to my trigger http://prntscr.com/9a09gd and this is the error I get when I add it as a query http://prntscr.com/9a7ycd

[Sneauxx]

I seem to be having a unrealistically hard time figuring this out,

Can I possibly get someone to walk me through this?

Would be glad to paypal over a few bucks for their time.

Add me on steam sn0w.nyc

[Catherine]

its not working for me, i did exacly whats in the post

[Thril]

The trigger is working quite nice, but i noticed some weird behaviour:

If i set just one Spawn Location that way, it seems to work, but new Characters don't spawn at the exact location, but often in a few couple tiles around that spot. sometimes a couple more also... but always around the area.

Anyone has the same "issue" ?

[Shrewdcrow]

The trigger is working quite nice, but i noticed some weird behaviour:

If i set just one Spawn Location that way, it seems to work, but new Characters don't spawn at the exact location, but often in a few couple tiles around that spot. sometimes a couple more also... but always around the area.

Anyone has the same "issue" ?

Is the location in a claim? It will spawn at random just outside of claims if so.

[Galestaer]

The trigger is working quite nice, but i noticed some weird behaviour:

If i set just one Spawn Location that way, it seems to work, but new Characters don't spawn at the exact location, but often in a few couple tiles around that spot. sometimes a couple more also... but always around the area.

Anyone has the same "issue" ?

Is the location in a claim? It will spawn at random just outside of claims if so.

Is there any way to set the new char spawn inside a claim?