[request] lottery procedure

[sigel123456789]

it has to be when user use a scroll it inserts his name into a table
and then selects random 10 from the table without repeating names

[JoleChow*]

Originally Posted by sigel123456789

it has to be when user use a scroll it inserts his name into a table
and then selects random 10 from the table without repeating names

Found this in my laptop
You can edit it to work as return scroll (AddLogItem)

 Spoiler

-----------------------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 [MENTION=3898309]charname[/MENTION]6 varchar(64) 
Select [MENTION=3898309]charname[/MENTION]6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = [MENTION=395373]Chari[/MENTION]D 
declare [MENTION=1994693]lottery[/MENTION]Avatar varchar(129)
set [MENTION=1994693]lottery[/MENTION]Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
    exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION]6 [MENTION=1994693]lottery[/MENTION]Avatar,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

[sigel123456789]

Originally Posted by JoleChow*

Found this in my laptop
You can edit it to work as return scroll (AddLogItem)

 Spoiler

-----------------------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 [MENTION=3898309]charname[/MENTION]6 varchar(64) 
Select [MENTION=3898309]charname[/MENTION]6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = [MENTION=395373]Chari[/MENTION]D 
declare [MENTION=1994693]lottery[/MENTION]Avatar varchar(129)
set [MENTION=1994693]lottery[/MENTION]Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
    exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION]6 [MENTION=1994693]lottery[/MENTION]Avatar,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

thanks but iam looking for the procedure which will select the winners

[Devsome]

Originally Posted by sigel123456789

thanks but iam looking for the procedure which will select the winners

Did you read that Code from @ ?
This looks like that Procedure

...exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN...

[sigel123456789]

Originally Posted by Devsome

Did you read that Code from @ ?
This looks like that Procedure

...exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN...

ya that what not looking for
iam looking for silk lottery which selects random 10 winners
it could be in 2 ways
1- scroll when the player uses . it inserts his name into a table then selects 10 randomly
2- buying tickets and keep in inventory and before announcing winners a procedure checks items in inventory and inserts into a table then selects 10 randomly