[TuT+Release] Perfect Timed Job [Guild+Job]

[Ahmed Abdelhady]

This is the perfect wait time remover!

How it works:
*) When you click leave/disband guild or timed job, it will kick you from the game, because AQ player updater will return a warning.


Why its better than others out there?
*) Alot of methods were to either delete the timed job AFTER it gets added, which is a horrible idea because it will return "Brutal Query (100)" ERROR, and you want to minimize the amount of errors you get to bare minimum!

/******By Jangan ******/
-- Run the query!
PHP Code:

USE [SRO_VT_SHARD]
GO
/******By Jangan ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER procedure [dbo].[_AddTimedJob]
@CharID int,
@Category tinyint,
@JobID int,
@TimeToKeep int,
@Data1 int,
@Data2 int,
--##begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
@Serial64 bigint,
@JID int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
return -1
if (@TimeToKeep <= 0)
return -2
declare @NewJobID int
set @NewJobID = 0

--##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
--##If you want to only have one not both, then just modify the line below!
if (@JobID = 1 or @JobID = 2)
BEGIN
return -1
END
ELSE
BEGIN
--##begin due to develop composite item
insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,D ata2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64, JID)
values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
END
--##end due to develop composite item
set @NewJobID = @@identity
if (@@error <> 0 or @@rowcount = 0)

return -3
return @NewJobID

This Tut+ Release Is taken From Another Site.

[PortalDark]

this was asked to not being posted on epvpers

[Haznev]

And you,who wants to help this site,asks someone to not post things here? Nice hypocrisy & greed,right?

[Ahmed Abdelhady]

Originally Posted by PortalDark

this was asked to not being posted on epvpers

nope dude, i taked it from rz and he didn't asked to not being psoted on epvpers or other site, i just want to help the ppls

[Dragonz2105]

Originally Posted by Ahmed Abdelhady

nope dude, i taked it from rz and he didn't asked to not being psoted on epvpers or other site, i just want to help the ppls

huh..

its really sux..
since all ppl there share and getting help ..
but when they release some thing they say dont post it here
is it hard for them to release it here and get that thanks u already got and double of it ?

[LastThief]

atleast give credits

[Ahmed Abdelhady]

read my last few words in my thread
This Tut+ Release Is taken From Another Site.

[raz2121abx]

So what ? you need my tanks?

[PortalDark]

Originally Posted by Haznev

And you,who wants to help this site,asks someone to not post things here? Nice hypocrisy & greed,right?

no, not greedy at all
I could have shared this but RZ post stated to not publish here XD
but we gonna act like that, ill keep leeching every release on RZ

[Disco Teka]

Portal, it was obvious that tutorials get leeched. Nothing new. Credits would help a bit if you mention the name of the creator.

[PortalDark]

Originally Posted by Disco Teka

Portal, it was obvious that tutorials get leeched. Nothing new. Credits would help a bit if you mention the name of the creator.

im not saying that i wont be leeched, but whatever, nvm then,
do as i haven't said anything

[Zoxon]

Originally Posted by Ahmed Abdelhady

read my last few words in my thread
This Tut+ Release Is taken From Another Site.

Thats not credits at all.

And doesnt matter,how i hate him,but the credits goes to Jangan,and if you copy the work of somebody,you should write the credits cuz thats not your work,thats all.

[Ahmed Abdelhady]

any way its my fault because i want to share the ideas betwen the sites and the ppls
request 4 close #

[PortalDark]

Originally Posted by Zoxon

Actually yes,better if you dont share anything,if you dont give the credits.
Anyway just lold on your sig,i would prefer my *** above your face. >_>

thnx for the rude comment

[Ahmed Abdelhady]

Originally Posted by Zoxon

Actually yes,better if you dont share anything,if you dont give the credits.
Anyway just lold on your sig,i would prefer my *** above your face. >_>

i said i taked it from another site
i forgot 2 write his name
so no problem in that
Thanks 4 The Rude Comment, i with portal