[Release]Scroll to make plus for limited time

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 [Only registered and activated users can see links. Click Here To Register...], it's about
scroll to make plus for a limited time

Create Plus scroll log Table

Quote:

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

Quote:

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

Quote:

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

#Approved

Quote:

Originally Posted by PortalDark #Approved

Thx ;)

good job , thanks

Quote:

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

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

Quote:

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

Quote:

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

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

Quote:

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? :D)


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)

Quote:

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? :D) 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. -_-

Quote:

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

Quote:

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.

Nice ^^

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

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

Quote:

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

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.

Quote:

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)

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

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.