[AndMetal]

Originally Posted by So_1337

### 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 know it's a little off topic, but I just wanted to point out a much simpler (read faster) query:

### This creates an item with Nexus Gate ###
UPDATE items SET 
	casttime = 10000, 
	casttime_ = 10000, 
	clicktype = 4, 
	clicklevel = 1, 
	clickeffect = 2734, 
	recastdelay = 60, 
	maxcharges = -1 
WHERE id = 59943;
INSERT INTO starting_items VALUES (179,0,0,0,0,59943,1,0,0);

On topic, I wonder if it's the clicktype? What we know from the Wiki:

clicktype

* Enter the number for the clicktype
o 1 = Item can be casted from anyslot (Main Inventory).
o 2 = Isn't used (As far as I can tell)
o 3 = Item can be casted from anyslot (Main Inventory).
o 4 = Item must be equipted to cast effect. (In my experience, type 4 means the effect works on self only)
o 5 = Seems to involve poisening a weapon. (In my experience, type 5 means the effect works on target)

Just a thought...