[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 = [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

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

 

[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

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

 

[Warrior15]

theres an error whn i execute it on my sql..on line 5

 

[lourence8]

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

problem solved already ehehe

tnx to sir Eifel

 

[albertmsanchez]

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?

 

[lourence8]

@albertmsanchez

how many trigger in ur chainfo sir?

 

[albertmsanchez]

i have only 1 trigger