|
You last visited: Today at 18:44
Advertisement
Simple Release " Avatar Lottery "
Discussion on Simple Release " Avatar Lottery " within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
12/14/2014, 05:12
|
#1
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
Simple Release " Avatar Lottery "
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.
Code:
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
Code:
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
Code:
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
Code:
ITEM_MALL_AVATAR1 NULL NULL
ITEM_MALL_AVATAR2 NULL NULL
ITEM_MALL_AVATAR3 NULL NULL
ITEM_MALL_AVATAR4 NULL NULL
Quote:
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.
|
|
|
01/21/2015, 15:10
|
#2
|
elite*gold: 27
Join Date: Jan 2015
Posts: 1,339
Received Thanks: 885
|
although you are my real life friend and my partner, but you made my day  work
|
|
|
01/21/2015, 15:30
|
#3
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
Quote:
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.
|
|
|
01/21/2015, 15:30
|
#4
|
elite*gold: 0
Join Date: Jan 2015
Posts: 17
Received Thanks: 0
|
nice, ty
|
|
|
01/21/2015, 16:40
|
#5
|
elite*gold: 27
Join Date: Jan 2015
Posts: 1,339
Received Thanks: 885
|
Quote:
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)
|
|
|
01/21/2015, 16:40
|
#6
|
elite*gold: 0
Join Date: Oct 2013
Posts: 81
Received Thanks: 27
|
TLDR : Kontaktkopf Raketen
|
|
|
01/21/2015, 16:42
|
#7
|
elite*gold: 85
Join Date: Aug 2010
Posts: 1,278
Received Thanks: 524
|
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
Quote:
for sure its always select a random reward ?
|
|
|
01/21/2015, 22:19
|
#8
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
Quote:
Originally Posted by Jayden.
nice, ty 
|
urw (;
Quote:
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.
Quote:
Originally Posted by VeSpacco
TLDR : Kontaktkopf Raketen
|
huh?
|
|
|
01/21/2015, 22:35
|
#9
|
elite*gold: 0
Join Date: May 2013
Posts: 227
Received Thanks: 13
|
FIX UR OLD THEARDS LINKG FIRST THEN U CAN MAKE NEW THEARDS LOL !?
|
|
|
01/21/2015, 22:37
|
#10
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
Quote:
Originally Posted by Maddona
FIX UR OLD THEARDS LINKG FIRST THEN U CAN MAKE NEW THEARDS LOL !?
|
sure, good advice
|
|
|
01/22/2015, 00:48
|
#11
|
elite*gold: 0
Join Date: Jan 2015
Posts: 2
Received Thanks: 0
|
so im tested this not work !
look
 
thanks you for this release but not working for me ^^
|
|
|
01/22/2015, 01:04
|
#12
|
elite*gold: 50
Join Date: Mar 2013
Posts: 1,153
Received Thanks: 412
|
Quote:
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?
|
|
|
01/22/2015, 01:06
|
#13
|
elite*gold: 0
Join Date: Jan 2015
Posts: 2
Received Thanks: 0
|
Quote:
Originally Posted by asanoftw
where you put this producer?
|
i'm add in AddTimedJob
|
|
|
04/16/2015, 13:31
|
#14
|
elite*gold: 0
Join Date: Feb 2015
Posts: 166
Received Thanks: 42
|
Quote:
Originally Posted by asanoftw
where you put this producer?
|
yea me to i have all add use the scroll not get reward -.-
|
|
|
04/16/2015, 17:19
|
#15
|
elite*gold: 0
Join Date: Mar 2015
Posts: 95
Received Thanks: 59
|
note : Producer is not Procedure
you're welcum
|
|
|
All times are GMT +1. The time now is 18:49.
|
|