You are viewing an old version of this page. Return to the latest version.
Difference between revisions of "Database:Zones"
| Line 11: | Line 11: | ||
Signs allow spawns in the world to display messages and transport you to a target zone id/location | Signs allow spawns in the world to display messages and transport you to a target zone id/location | ||
| − | For example | + | '''You must have a Spawn to enable a sign''' |
| + | |||
| + | Get your spawn ID | ||
| + | |||
| + | <pre> | ||
| + | SELECT id,name FROM spawn WHERE name LIKE '%My door%'; | ||
| + | </pre> | ||
| + | |||
| + | For example the ID might be 94. | ||
<pre> | <pre> | ||
insert into spawn_signs (spawn_id, type, description, zone_id) values (94, 'Zone', 'enter this building', 414); | insert into spawn_signs (spawn_id, type, description, zone_id) values (94, 'Zone', 'enter this building', 414); | ||
</pre> | </pre> | ||
Revision as of 22:50, 2 October 2009
About
Table
Status
Motd
Teleporters / Signs
Signs allow spawns in the world to display messages and transport you to a target zone id/location
You must have a Spawn to enable a sign
Get your spawn ID
SELECT id,name FROM spawn WHERE name LIKE '%My door%';
For example the ID might be 94.
insert into spawn_signs (spawn_id, type, description, zone_id) values (94, 'Zone', 'enter this building', 414);