Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Share] ^^ Ammend Magic

Joined
Sep 16, 2007
Messages
1,206
Reaction score
540
i take some help with our co-devz with this kind of magic in-game hahaha
originally, i see this idea on phoenixran, (jolin's server lately)

Here it is,
Once you type the 'SaintB51F', you will be warped there after you relogin..

Execute this on your MSSQL
Code:
USE [RanGame1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Auto_Map] ON [dbo].[ChaInfo]
AFTER UPDATE
AS
BEGIN
    UPDATE [ChaInfo] SET [ChaInfo].ChaSaveMap = [COLOR=Red][B]51[/B][/COLOR],
    [ChaInfo].ChaSavePosX = -1,
    [ChaInfo].ChaSavePosY = -1,
    [ChaInfo].ChaSavePosZ = -1
    FROM INSERTED
    WHERE Inserted.ChaGuName = '[COLOR=RoyalBlue][B]SaintB51F[/B][/COLOR]'
    and [ChaInfo].ChaMoney > 1
    and [ChaInfo].ChaLevel > 1
    and [ChaInfo].ChaNum = Inserted.ChaNum
    and [ChaInfo].UserNum = Inserted.UserNum
END

If you want to add another map, juz copy paste that trigger on same query and then change the following below
51 = Map Code
SaintB51F = The Word that you will put on the Ammend


use your common sense :lol:

Credits: Eifelzoecker, Jolin88, Crypticword(denverporia), marck
 
Last edited:
Initiate Mage
Joined
Jan 9, 2008
Messages
80
Reaction score
1
this is nice ^^ thnx

can you make a trigger for adding stats like this?
 
Quit
Member
Joined
Oct 18, 2006
Messages
709
Reaction score
94
ahahahah

nice one sir seifer


i saw it in RanPDF
 
Joined
Sep 16, 2007
Messages
1,206
Reaction score
540
@lourence8
hahaha i ask eifel to make me a script and of course he will try it in his server ^^ is it great huh wahaha :D

@all
np
 
Custom Title Activated
Member
Joined
Aug 16, 2007
Messages
1,378
Reaction score
581
and I don't get any credits huh? Eifel got that idea by me in first place
 
Custom Title Activated
Member
Joined
Aug 16, 2007
Messages
1,378
Reaction score
581
ok nvm

but this should be changed :


and [ChaInfo].ChaMoney > 1


remove it, the code means you require 2 gold or higher to enter but its not consumed

my actual script goes as follow :

update chainfo set chasavemap = 35,chaguname = '' from inserted where inserted.chanum = chainfo.chanum and inserted.chaguname = 'B30'
update chainfo set chasavemap = 36,chaguname = '' from inserted where inserted.chanum = chainfo.chanum and inserted.chaguname = 'B50'
update chainfo set chasavemap = 37,chaguname = '' from inserted where inserted.chanum = chainfo.chanum and inserted.chaguname = 'B90'
 
Quit
Member
Joined
Oct 18, 2006
Messages
709
Reaction score
94
not working in ep3?


when i use my character alwys rollback T_T
 
Last edited:
Junior Spellweaver
Joined
Apr 2, 2008
Messages
119
Reaction score
0
hmmmm you can do more... by using amend... like money cheat, warp, and many more... all this is runing on my weak server
 
Initiate Mage
Joined
Jan 9, 2008
Messages
80
Reaction score
1
we can also use this for adding stats like MU they use this amend..^^
 
Joined
Sep 16, 2007
Messages
1,206
Reaction score
540
haha i forgot, put it in your 1st trigger (example REBORN trigger)

remove this part of my trigger
Code:
USE [RanGame1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Auto_Map] ON [dbo].[ChaInfo]
AFTER UPDATE
AS

and add on my RB Trigger on this part of your RB

Code:
AFTER UPDATE
AS

REMEMBER: if you will not combine your and my trigger, it will cause rollback ^_^
ty to all np, sorry sir lourence


@Jolin, i already credited u ^^ see above..
 
Skilled Illusionist
Joined
Dec 21, 2008
Messages
326
Reaction score
9
theres an error whn i execute it on my sql..on line 5
 
Quit
Member
Joined
Oct 18, 2006
Messages
709
Reaction score
94
haha i forgot, put it in your 1st trigger (example REBORN trigger)

remove this part of my trigger
Code:
USE [RanGame1]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[Auto_Map] ON [dbo].[ChaInfo]
AFTER UPDATE
AS

and add on my RB Trigger on this part of your RB

Code:
AFTER UPDATE
AS

REMEMBER: if you will not combine your and my trigger, it will cause rollback ^_^
ty to all np, sorry sir lourence


@Jolin, i already credited u ^^ see above..

problem solved already ehehe

tnx to sir Eifel
 
Junior Spellweaver
Joined
Aug 18, 2008
Messages
104
Reaction score
0
guys help me coz when i use this ammend magic after an hour my server crashes...

then after that ammend magic cannot be use anymore...

what do i need to do?
 
Quit
Member
Joined
Oct 18, 2006
Messages
709
Reaction score
94
@albertmsanchez

how many trigger in ur chainfo sir?
 
Back
Top