- Joined
- Apr 13, 2008
- Messages
- 1,244
- Reaction score
- 656
U can make this as a SQL Agent Job 
The idea is, when, for example u logout, when u r in Lorencia (MapNumber = 0) in coordinates (MapPosX = 230, MapPosY = 160) and login again u will be in, for example Illusion Temple 6 (MapNumber = 49) in coordinates (MapPosX = 104, MapPosY = 134)!
That way u can hide your GM Shop in a place, that doesn't exist (a black terrain in some map), and change the MapNumbers and Coordinates to where u want and to the GM Shop
Here is the query:
The Blue Chars can be changed to the desired
The idea is, when, for example u logout, when u r in Lorencia (MapNumber = 0) in coordinates (MapPosX = 230, MapPosY = 160) and login again u will be in, for example Illusion Temple 6 (MapNumber = 49) in coordinates (MapPosX = 104, MapPosY = 134)!
That way u can hide your GM Shop in a place, that doesn't exist (a black terrain in some map), and change the MapNumbers and Coordinates to where u want and to the GM Shop
Here is the query:
Code:
UPDATE Character
SET MapNumber= [COLOR="Blue"]49[/COLOR] , MapPosX = [COLOR="Blue"]104[/COLOR] , MapPosY = [COLOR="Blue"]134[/COLOR]
WHERE MapNumber = [COLOR="Blue"]0[/COLOR] , MapPosX = [COLOR="Blue"]230[/COLOR] , MapPosY = [COLOR="Blue"]160[/COLOR]The Blue Chars can be changed to the desired
