Of course, the subject is from his title ..
If you want to work, Reward me the new people in the server, but do not tire yourself with the work of the computer (you have the personal need to wear it +16 100% FB) You can work 80% / 0% You can start and adjust the + in the procedure. And your convenience ..
We are concerned about the matter, unfortunately,
USE [SRO_VT_SHARDLOG] -- Codded By Gamer1337
GO
/****** Object: StoredProcedure [dbo].[FB] Script Date: 14/03/2017 12:00:00 ص ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
[COLOR="Blue"][B]CREATE PROCEDURE[/B][/COLOR] [dbo].[FB]
@CHARID INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @ItemID int
,@Charname VarChar(50)
,@PLUS int
, @Head int
,@CHEST int
,@LEGS int
,@SHOULDER int
,@HAND int
, @FOOT int
,@RING1 int
,@RING2 int
,@NECK int
,@ERRING int
,@WEP int
,@SHIELD int
SELECT @Charname=CHARNAME16 FROM SRO_VT_SHARD__JOoOo.._CHAR WHERE CHARID=@Charid
SET @PLUS = '16'
SET @Charid = (select CharID from SRO_VT_SHARD__JOoOo.._Char where CharName16=@Charname)
SET @Head = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=0 and CharID=@Charid)
SET @CHEST = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=1 and CharID=@Charid)
SET @LEGS = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=4 and CharID=@Charid)
SET @SHOULDER = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=2 and CharID=@Charid)
SET @HAND = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=3 and CharID=@Charid)
SET @FOOT = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=5 and CharID=@Charid)
SET @RING1 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=11 and CharID=@Charid)
SET @RING2 = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=12 and CharID=@Charid)
SET @NECK = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=10 and CharID=@Charid)
SET @ERRING = (Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=9 and CharID=@Charid)
SET @WEP =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=6 and CharID=@Charid)
SET @SHIELD =(Select ItemID from SRO_VT_SHARD__JOoOo.dbo._Inventory where Slot=7 and CharID=@Charid)
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@Head
---------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@CHEST
----------------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@SHOULDER
----------------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@HAND
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=6,
optlevel=@PLUS,
MagParam1 =5583457484950,
MagParam2 =5583457484962,
MagParam3 =30064771144,
MagParam4=858993459290,
MagParam5=30064771150,
MagParam6=257698037898,
Variance=1073741823
where ID64 =@LEGS
-----------------------
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4=257698037898,
Variance=1073741823
where ID64 =@FOOT
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=4,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
MagParam4 =257698037862,
Variance=34359738367
where ID64 =@WEP
update SRO_VT_SHARD__JOoOo.._Items
set MagParamNum=3,
optlevel=@PLUS,
MagParam1 =30064771150,
MagParam2 =30064771144,
MagParam3 =858993459290,
Variance=1073741823
where ID64 =@SHIELD
set nocount off;
END
Stat Scroll Dosent work help! 03/08/2017 - SRO Private Server - 6 Replies Hi Guys ! i have a problem i add the Stat Scroll, in DB+media
the problem is when i use i dosent get the Statpoints my Hp and mp are the same, who can help me ?
here is my
_addtimedJOB
USE
GO
/****** Object: StoredProcedure . Script Date: 02/25/2017 08:34:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
Random Stat Scroll Question 04/20/2016 - Flyff Private Server - 2 Replies Hello Epvp, anyone who can tell me how can I change the Stats of Random Scroll (Scroll of STR, Scroll of DEX, Scroll of INT, Scroll of STA) I want to change it to random stats by 150 randomized by 10, 20, 30, 40 up to 150
and Here's the Code
void CDPSrvr::OnRandomScroll( CAr & ar, DPID dpidCache, DPID dpidUser, LPBYTE lpbuf, u_long uBufSize )
{
Any way to reset STAT points? (not using a stat reset scroll) 02/12/2016 - SRO Coding Corner - 5 Replies Hey folks i tryed with item scroll reset stat, it works allmost perfect but those dc is rly sux...
I saw at some private server that they have some like coded procedure starting to be active when you write something in your for example private chat(and it give nice reset stat without DC)
chat:
$Reset Reset_stats
thats only example.
CRASH After Using Reset STAT scroll. 01/13/2016 - SRO Private Server - 2 Replies Hey Folks!
I made restat scroll, i found some threads here abt that and i tryed to make my own. But there is on weird thing, each time i use this restat scroll it makes my client crash but stats are return to previous/basic stat(so that works correct)
Okai how i did that:
1* Database:
1.1 I putted that in RefObjectCommon table:
1 70001 ITEM_MALL_STATS_POINT_RECALL_A_KARA ???? ???? ???...
Stat Reset Scroll 02/28/2015 - SRO Private Server - 2 Replies Hello epvp, i downloaded this stat reset scroll but when i use it, it doesn't do anything and i added successfully to DB+media.
_AddTimedJob -
USE
GO
/****** Object: StoredProcedure . Script Date: 2/28/2015 8:45:17 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
