Experienced Elementalist
- Joined
- Dec 7, 2006
- Messages
- 250
- Reaction score
- 2
add this to LOAD_USER_DATA
:laugh:
Code:
-- you could ofcourse modify the zone numbers.
begin
UPDATE userdata set zone = 21 where struserid = @id AND zone = 201
UPDATE userdata set zone = 21 where struserid = @id AND zone = 31 -- bifrost -> moradon
UPDATE userdata set zone = 21 where struserid = @id AND zone = 61 -- Dark Land -> moradon
UPDATE userdata set zone = 21 where struserid = @id AND zone = 56 -- Felankors Lair -> moradon
UPDATE userdata set zone = 21 where struserid = @id AND zone = 62 -- Gem Land -> moradon
end
-- this just makes it so DUPERS will always be inserted into Gokhan no matter what they try:O
exec RunDupeCheckInn @AccountID
exec RunDupeCheck @AccountID
exec RunDupeCheck2 @AccountID
-- exec DupeDeleter @id -- ourko db needed or the proc.
exec RunDupeCheck @id
exec RunDupeCheck2 @id
:laugh: