[Release]Scroll to make plus for limited time

[bestprem]

Hello P-Server community
Here we are offering our service by Hilbiled team
HilbiledTeam
---------------------
--Who is HilbiledTeam
Actually am not going to say its a big team its just a founder who got hands on most awesome PHP Development and SQL Developer and some other stuff to offer you best service

---------------------
-Where we do came from ?
- actually founder got some hands on friends from / ******** / epvp and came up with this team
---------------------
--Why we are here
well we do like to offer you some service which is awesome now days after many things did show
Like What! ?
- Exploits
- PHP Scripts Etc
- Website design
- 3D design
- Logo design
- Launcher and loading design
- Databases
- Encryption
- Security for much of kinds
- Rooted Servers
- Protected Servers

Coming soon!
- Selling vps and dedicated server OS Linux and server files working on it.
---------------------
- How you can trust us
actually its hard part of you but we are really not that kiddos stuff when you come to make up any deal we will show you
who we did deals with other guys and how our work is it and there much popular servers are powered by our developers
---------------------
-After deals
well if you had a deal with us we just add our copyright to get popular
------------------------
For Contact
will be private msg
till we make our Skype chat and also to get your hands on must of our team in chat room
------------------------


This is the fourth release from , it's about
scroll to make plus for a limited time

Create Plus scroll log Table

DECLARE @dbname nvarchar(128) = N'HILBILED'
IF not (EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = @dbname OR name = @dbname)))
begin
create database [HILBILED]
end
GO

/****** Object: Table [dbo].[_PlusScrollLog] Script Date: 12/2/2014 8:13:41 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[_PlusScrollLog](
[ID] [int] IDENTITY(1,1) NOT NULL,
[CharID] [int] NOT NULL,
[Serial64] [bigint] NOT NULL,
[StartTime] [datetime] NOT NULL,
[PlusTime] [int] NOT NULL
) ON [PRIMARY]

GO

Proc _AddLogItem

if (@Operation = 41)
begin
if (@ItemRefID = '1337')
begin
insert into [_PlusScrollLog] (CharID,Serial64,StartTime,PlusTime)values (@CharID,@ItemSerial,Getdate(),3) -- 3hours
end
end

Proc _AddLogChar

if (@EventID in (6,9,4,11))
begin
declare @OldItemSerial as bigint = (Select Serial64 from _PlusScrollLog where CharID = @CharID)
declare @OldTime as datetime = (select Top(1) StartTime from HILBILED.._PlusScrollLog where CharID = @CharID and Serial64 = @OldItemSerial order by StartTime desc)
if DATEDIFF(HOUR,3,GETDATE()) >= @OldTime
begin
Update SRO_VT_SHARD.._Items set Optlevel -= 2 where Serial64 = @OldItemSerial
Delete from HILBILED.._PlusScrollLog where Serial64 = @OldItemSerial
end
end

Edit what you want, use ur brain

This release by Kiro

[PortalDark]

#Approved

[bestprem]

Originally Posted by PortalDark

#Approved

Thx

[Crue*]

good job , thanks

[Syloxx]

if (@Operation = 41)
begin
if (@ItemRefID = '1337')

IF @Operation = 41 AND @RefItemID = 1337 ??

insert into [_PlusScrollLog] (CharID,Serial64,StartTime,PlusTime)values (@CharID,@ItemSerial,Getdate(),3)

INSERT INTO _PlusScrollLog
VALUES (@CharID, @ItemSerial, GETDATE(), 3)

since you insert the whole table specifies columns isn't required

if (@EventID in (6,9,4,11))

IF @EventID IN (4, 6, 9, 11, 21)
you forgot the death teleport

declare @OldItemSerial as bigint = (Select Serial64 from _PlusScrollLog where CharID = @CharID)
declare @OldTime as datetime = (select Top(1) StartTime from HILBILED.._PlusScrollLog where CharID = @CharID and Serial64 = @OldItemSerial order by StartTime desc)

DECLARE @ItemSerial BIGINT,
@Time DATETIME,
@Timer INT

SELECT TOP 1 @ItemSerial = Serial64,
@Time = StartTime,
@Timer = PlusTime
FROM _PlusScrollLog
WHERE CharID = @CharID
ORDER BY StartTime DESC

IF DATEDIFF (HOUR, @Timer, GETDATE()) >= @Time
UPDATE _Items bla bla is correct
UPDATE _PlusScrollLog SET expired = 1 WHERE Serial64 = @ItemSerial (delete a log just because its expired? so the scenes of logs is gone? )


the whole thing is written in the epvp text window so it could have some bugs


INFO:
I advise you not to use it!!!

reasons:
-its scamable (since you update the optlevel you can sell it as a higher plus)

-there are many ways to abuse the procedure (change the serial, use the weapon on another char etc)

[bestprem]

Originally Posted by Syloxx

IF @Operation = 41 AND @RefItemID = 1337 ??



INSERT INTO _PlusScrollLog
VALUES (@CharID, @ItemSerial, GETDATE(), 3)

since you insert the whole table specifies columns isn't required




IF @EventID IN (4, 6, 9, 11, 21)
you forgot the death teleport



DECLARE @ItemSerial BIGINT,
@Time DATETIME,
@Timer INT

SELECT TOP 1 @ItemSerial = Serial64,
@Time = StartTime,
@Timer = PlusTime
FROM _PlusScrollLog
WHERE CharID = @CharID
ORDER BY StartTime DESC

IF DATEDIFF (HOUR, @Timer, GETDATE()) >= @Time
UPDATE _Items bla bla is correct
UPDATE _PlusScrollLog SET expired = 1 WHERE Serial64 = @ItemSerial (delete a log just because its expired? so the scenes of logs is gone? )


the whole thing is written in the epvp text window so it could have some bugs


INFO:
I advise you not to use it!!!

reasons:
-its scamable (since you update the optlevel you can sell it as a higher plus)

-there are many ways to abuse the procedure (change the serial, use the weapon on another char etc)

don't try to prove your self if u wanna do something do it in silence. -_-

[Syloxx]

Originally Posted by bestprem

don't try to prove your self if u wanna do something do it in silence. -_-

are u kidding me? this is a forum now google the decryption of forum

Internet forum - Wikipedia, the free encyclopedia

Originally Posted by Wikipedia

An Internet forum, or message board, is an online discussion site where people can hold conversations in the form of posted messages.

[Airemacute]

Nice ^^

[SROConnect]

Do not use this.
People will abuse it and it will cause more scamming then you can imagine.

[Eslam Galull]

the main idea is not bad !! ,, but there is alot of ways to hack the way you it back to old plus .. and sro players using there minds in ( bugs ) so they will found a way from that ways to BUG it !! .. so

 Spoiler

USELESS

[bestprem]

Originally Posted by its.soul

the main idea is not bad !! ,, but there is alot of ways to hack the way you it back to old plus .. and sro players using there minds in ( bugs ) so they will found a way from that ways to BUG it !! .. so

 Spoiler

USELESS

little bit by ur self!!

,, something else do u wanna me to teach ppl how to pee too!!!

[​Exo]

Here's an idea, if you're not going to make a new copy of a CharBound item, then at least make a new BlueState that only shows when the scroll is used.

[Syloxx]

Originally Posted by xExorcist

Here's an idea, if you're not going to make a new copy of a CharBound item, then at least make a new BlueState that only shows when the scroll is used.

there is already a blue state for that (this also increase the optlevel)

[Dracula Untold]

nice ideea u shared ! but it have to be safe 100% so u can use it on your own server !

[​Exo]

There're many ways to avoid the abusing of such thing you just need to use your mind and think of every possible action that could happen to the item under the effect of the scroll and remove the possible exploits.