Simple Release " Avatar Lottery "

[asanoftw]

heya epvp, since i left sro section bc school , work etc now i think dat i am free a bit to release smth useful to me here we go.

 Example Scroll lines

RefObjCommon
1	48896	ITEM_LOTTERY_SPECIAL_STONE	?????	xxx	SN_ITEM_LOTTERY_SPECIAL_STONE	SN_ITEM_LOTTERY_SPECIAL_STONE_TT_DESC	1	0	3	3	13	14	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	pet2\item\item_pet2_enc_equip_set.ddj	xxx	xxx	26166

RefObjItem
26166	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????	1	[USU1:SKILL_LOTTERY_SPECIAL_STONE]	-1	RESURRECT	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

RefSkill
1	35129	1013	SKILL_LOTTERY_SPECIAL_STONE	???? ????	SKILL_LOTTERY_SPECIAL_STONE	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_dungeon_free_ticket_forgotten_world.ddj	SN_SKILL_LOTTERY_SPECIAL_STONE	xxx	SN_SKILL_LOTTERY_SPECIAL_STONE_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	3600	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

 AddTimedJob Procedure ( SRO_VT_SHARD )

if(@JobID = '35129') ------- JobID = RefSkill ID
   begin
declare @CharName6 varchar(64) 
Select @CharName6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID 
declare @LotteryAvatar varchar(129)
set @LotteryAvatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
    exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName6,@LotteryAvatar,1,0
   end

 Lottery Table

USE [SRO_VT_SHARD]
GO

/****** Object:  Table [dbo].[_LotteryNEWSTONE]    Script Date: 09/15/2013 19:54:32 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[_LotteryNEWSTONE](
	[GiftItems] [varchar](129) NULL,
	[SpecialItems] [varchar](129) NULL,
	[PremItems] [varchar](129) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

 Lottery Items

• Add Item Code On Table

ITEM_MALL_AVATAR1	NULL	NULL
ITEM_MALL_AVATAR2	NULL	NULL
ITEM_MALL_AVATAR3	NULL	NULL
ITEM_MALL_AVATAR4	NULL	NULL

You must change the Codes above to your avatar codes that you want make lottery on it
after use the scroll you need to teleport and the lottery will random choose and execute the reward on inventory

Could be enough.

[Aaron*]

although you are my real life friend and my partner, but you made my day work

[asanoftw]

Originally Posted by Jocs

although you are my real life friend and my partner, but you made my day work

XD, u've to thankful me then.

[Jayden.]

nice, ty

[Aaron*]

Originally Posted by asanoftw

XD, u've to thankful me then.

yea, but what do you do? xD
washing bars? (got it? ) note : bars = dicks (rofl)

[VeSpacco]

TLDR : Kontaktkopf Raketen

[Eslam Galull]

you made my day to .. thanks

btw
we can fix scroll lines to do a teleport automatic like the return scroll
we can also use it more than avatar lottery ( scrolls & items & whatever )

Edit1 :

about

SELECT TOP 1 GiftItems

for sure its always select a random reward ?

[asanoftw]

Originally Posted by Jayden.

nice, ty

urw (;

Originally Posted by its.soul

you made my day to .. thanks

btw
we can fix scroll lines to do a teleport automatic like the return scroll
we can also use it more than avatar lottery ( scrolls & items & whatever )

Edit1 :

about

for sure its always select a random reward ?

yup it is.

Originally Posted by VeSpacco

TLDR : Kontaktkopf Raketen

huh?

[Maddona]

FIX UR OLD THEARDS LINKG FIRST THEN U CAN MAKE NEW THEARDS LOL !?

[asanoftw]

Originally Posted by Maddona

FIX UR OLD THEARDS LINKG FIRST THEN U CAN MAKE NEW THEARDS LOL !?

sure, good advice

[Dorota]

so im tested this not work !
look


thanks you for this release but not working for me ^^

[asanoftw]

Originally Posted by Dorota

so im tested this not work !
look


thanks you for this release but not working for me ^^

where you put this producer?

[Dorota]

Originally Posted by asanoftw

where you put this producer?

i'm add in AddTimedJob

[Andi_xBrainwash]

Originally Posted by asanoftw

where you put this producer?

yea me to i have all add use the scroll not get reward -.-

[DeaDeployment]

note : Producer is not Procedure

you're welcum