[Share] ^^ Ammend Magic

[SeiferXIII]

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

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 = 51,
    [ChaInfo].ChaSavePosX = -1,
    [ChaInfo].ChaSavePosY = -1,
    [ChaInfo].ChaSavePosZ = -1
    FROM INSERTED
    WHERE Inserted.ChaGuName = 'SaintB51F'
    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

Credits: Eifelzoecker, Jolin88, Crypticword(denverporia), marck

[MentaL]

[icedbox2002]

Nice share!
Thanks!
Important Link!

[volter]

this is nice ^^ thnx

can you make a trigger for adding stats like this?

[lourence8]

ahahahah

nice one sir seifer


i saw it in RanPDF

[SeiferXIII]

@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

[Jolin88]

and I don't get any credits huh? Eifel got that idea by me in first place

[lourence8]

and I don't get any credits huh? Eifel got that idea by me in first place

originally, i see this idea on phoenixran, (jolin's server lately)

did u read sir jolin?

i think its redundant if u will also include in credits

peace bro ^_^

[Jolin88]

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'

[Abry]

Nice share!
Thanks!
Important Link!

That's my line..

Anyway, added to important links.. ;)

[lourence8]

not working in ep3?


when i use my character alwys rollback T_T

[AutoKill]

hmmmm you can do more... by using amend... like money cheat, warp, and many more... all this is runing on my weak server

[volter]

we can also use this for adding stats like MU they use this amend..^^

[icedbox2002]

That's my line..

Anyway, added to important links.. ;)

Ooppss.... Sorry!

[AutoKill]

You can use the amend also for reset stat

[SeiferXIII]

haha i forgot, put it in your 1st trigger (example REBORN trigger)

remove this part of my trigger

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

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..