For our server, #zone is disabled and we use an NPC to translocate people from the Nexus. So to get to the Nexus, everyone starts with a Kobold Skull Charm with the effect of "The Nexus" on it.
Code:
### This creates an item with Nexus Gate ###
UPDATE items SET casttime = 10000 WHERE id = 59943;
UPDATE items SET casttime_ = 10000 WHERE id = 59943;
UPDATE items SET clicktype = 4 WHERE id = 59943;
UPDATE items SET clicklevel = 1 WHERE id = 59943;
UPDATE items SET clickeffect = 2734 WHERE id = 59943;
UPDATE items SET recastdelay = 60 WHERE id = 59943;
UPDATE items SET maxcharges = -1 WHERE id = 59943;
INSERT INTO starting_items VALUES (179,0,0,0,0,59943,1,0,0);
I'm not sure exactly which one of those does it, but I believe that it's either clicktype or clickeffect. This will display the refresh timer on the item. Not a countdown, but a list of the total cooldown time. Best I can do. The item was originally modeled on
Al`Kabor's Propylon of the Nexus, if you'd like something different to analyze.