[Beginners]Functions

[juliendu38]

Hello People !

i want to create this thread for share some functions,
this is not big functions, this is just for help beginners.

i know you like to flame on all topic but be cool here please

the functions was here to win time Nothing more.
if you are beginner, it can be good to learn how work functions and how to create your own.

if you want share your own function you can

ps : the functions here i made like some years ago and i don't have try it now, say me if there was errors or problems


FUNCTION MonItem (add item to monster, normal item)

 Spoiler

ALTER PROCEDURE [dbo].[MonItem]
@ INT,
@ INT
AS


BEGIN
Insert into TMONITEMCHART
(bchartType, WMonID, wItemID, wItemIDMin, wItemIDMax, BlevelMin, blevelmax, bitemprob_N1, bitemprob_N2, bitemprob_N3, bitemprob_N4, bitemprob_M, bitemprob_S, bitemprob_R, bitemmagicopt, bitemrareopt, wWeight)
Values
(12, @, @, 0, 0, 1, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1)

END

FUNCTION MonItemx5 (add x5 items to monster)

 Spoiler

ALTER PROCEDURE [dbo].[MonItemx5]
@ INT,
@ INT,
@3 INT,
@4 INT,
@5 INT,
@ INT
AS
BEGIN
Insert into TMONITEMCHART
(bchartType, WMonID, wItemID, wItemIDMin, wItemIDMax, BlevelMin, blevelmax, bitemprob_N1, bitemprob_N2, bitemprob_N3, bitemprob_N4, bitemprob_M, bitemprob_S, bitemprob_R, bitemmagicopt, bitemrareopt, wWeight)
Values
(12, @, @, 0, 0, 1, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1)

Insert into TMONITEMCHART
(bchartType, WMonID, wItemID, wItemIDMin, wItemIDMax, BlevelMin, blevelmax, bitemprob_N1, bitemprob_N2, bitemprob_N3, bitemprob_N4, bitemprob_M, bitemprob_S, bitemprob_R, bitemmagicopt, bitemrareopt, wWeight)
Values
(12, @, @, 0, 0, 1, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1)

Insert into TMONITEMCHART
(bchartType, WMonID, wItemID, wItemIDMin, wItemIDMax, BlevelMin, blevelmax, bitemprob_N1, bitemprob_N2, bitemprob_N3, bitemprob_N4, bitemprob_M, bitemprob_S, bitemprob_R, bitemmagicopt, bitemrareopt, wWeight)
Values
(12, @, @3, 0, 0, 1, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1)

Insert into TMONITEMCHART
(bchartType, WMonID, wItemID, wItemIDMin, wItemIDMax, BlevelMin, blevelmax, bitemprob_N1, bitemprob_N2, bitemprob_N3, bitemprob_N4, bitemprob_M, bitemprob_S, bitemprob_R, bitemmagicopt, bitemrareopt, wWeight)
Values
(12, @, @4, 0, 0, 1, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1)

Insert into TMONITEMCHART
(bchartType, WMonID, wItemID, wItemIDMin, wItemIDMax, BlevelMin, blevelmax, bitemprob_N1, bitemprob_N2, bitemprob_N3, bitemprob_N4, bitemprob_M, bitemprob_S, bitemprob_R, bitemmagicopt, bitemrareopt, wWeight)
Values
(12, @, @5, 0, 0, 1, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 1)
END

FUNCTION MonMoney (edit money to monster by level, warning it include all monster to the level, edit min and max money)

 Spoiler

ALTER PROCEDURE [dbo].[MonMoney]
@wlevel INT
AS
BEGIN
update TMONSTERCHART SET dwMinMoney=700, dwMaxmoney=2000 WHERE bLevel=@wLevel
END

FUNCTION NPCITEM (Add 5 items on Npc, perfect for equipement set)

 Spoiler

ALTER PROCEDURE [dbo].[TNPCITEM]
@ INT,
@ INT,
@1 INT,
@ INT,
@3 INT,
@4 INT
AS
BEGIN
INSERT INTO TNPCITEMCHART
(wNpcID, dwitemID)
VALUES
@, @)
INSERT INTO TNPCITEMCHART
(wNpcID, dwitemID)
VALUES
@, @1)
INSERT INTO TNPCITEMCHART
(wNpcID, dwitemID)
VALUES
@, @)
INSERT INTO TNPCITEMCHART
(wNpcID, dwitemID)
VALUES
@, @3)
INSERT INTO TNPCITEMCHART
(wNpcID, dwitemID)
VALUES
@, @4)

END

i've stopped 4Story project and lot of Tools & files is sleeping,
i waiting the agree of the real owner to share it.

[lFutuR]

Gg good job

[.Konst]

Originally Posted by juliendu38

i've stopped 4Story project and lot of Tools & files is sleeping,
i waiting the agree of the real owner to share it.

These scripts are as basic as SQL can get. Also why do you want to share the tools of others if you stop?

[NavigatorCreed]

Function #1 & #2 Both functions are usuless because you can do it much more faster with copy/paste in table.

Function #3 Why you put there level if better way to do it is Monster ID?

[juliendu38]

Function #3 = yes you can do it Navigator, but for my old server (pve) i used this for change money rate by levels,because in my old level 40 = 5 Silver and level 90 = 10 silver Something like this, but yes you have an function for the monster ID i don't have precise, but yes navi i will added an "PS"


Konst : keep calm i don't share your work, and, because the files i have is old, i don't think one of the owner have it again, but it can be used by beginners (if owner want how i said) i've stopped since 1 year well its sure i don't have the last biggest files and Tools ever

how i said this is for beginners, this is easy, and... why you are here xD

[pipitt05000]

Originally Posted by juliendu38

Function #3 = yes you can do it Navigator, but for my old server (pve) i used this for change money rate by levels,because in my old level 40 = 5 Silver and level 90 = 10 silver Something like this, but yes you have an function for the monster ID i don't have precise, but yes navi i will added an "PS"


Konst : keep calm i don't share your work, and, because the files i have is old, i don't think one of the owner have it again, but it can be used by beginners (if owner want how i said) i've stopped since 1 year well its sure i don't have the last biggest files and Tools ever

how i said this is for beginners, this is easy, and... why you are here xD

Thanks for share !

PS: tkt gros, ils sont juste affreux ces trouduk