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

Click to expand...

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

Click to expand...

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

Click to expand...

Edit what you want, use ur brain

This release by Kiro