[request] lottery procedure

Quote:

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

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

Quote:

Originally Posted by JoleChow* Found this in my laptop You can edit it to work as return scroll (AddLogItem)  Spoiler Code: -----------------------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

Quote:

Originally Posted by sigel123456789 thanks but iam looking for the procedure which will select the winners

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

Quote:

Originally Posted by Devsome Did you read that Code from @[Only registered and activated users can see links. Click Here To Register...] ? This looks like that Procedure Code: ...exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN...