Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 11:25

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



_AddTimedJob Procedure - Help me to fix it

Discussion on _AddTimedJob Procedure - Help me to fix it within the SRO Private Server forum part of the Silkroad Online category.

Closed Thread
 
Old   #1
 
elite*gold: 0
Join Date: Oct 2011
Posts: 109
Received Thanks: 12
_AddTimedJob Procedure - Help me to fix it

Hello,

I'm using vsro database, and wanna to create a lottery item by following speps of this

I've successfully done every step, only have a prob with making the AddTimedJob Procedure well. I've made a simple copy + paste with a bit editing of @ JobID,but it doesn't work.

Guys, could any of you help me how I should fix it?

CODE:
PHP Code:
if @ JobID '35129') ------- JobID RefSkill ID
   begin
declare @ charname6 varchar(64
Select charname6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @ CharID 
declare @ lottery Avatar varchar(129)
set lottery Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
    
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN charname 6 lottery Avatar,1,0
   end 
Thnks,
NS

p.s.: there isn't any space nex to '@' in the PHP code



NagySandor96 is offline  
Old 03/12/2016, 00:20   #2
 
elite*gold: 500
Join Date: Jul 2009
Posts: 260
Received Thanks: 539
You are missing a '(' for your if function.

if (@JobID = '35129') ------- JobID = RefSkill ID
begin
declare @6 varchar(64)
Select @6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @D
declare @Avatar varchar(129)
set @Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @6, @Avatar,1,0
end

The error message would be helpfull


Bizzyyyyy is offline  
Old 03/12/2016, 02:25   #3
 
elite*gold: 0
Join Date: Oct 2011
Posts: 109
Received Thanks: 12
Here's a picture. Is it enough ?
http://i.epvpimg.com/Ku7Pg.png
NagySandor96 is offline  
Old 03/12/2016, 06:46   #4


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,634
Quote:
Originally Posted by NagySandor96 View Post
Here's a picture. Is it enough ?
http://i.epvpimg.com/Ku7Pg.png
ayy check your commas


​Exo is offline  
Old 03/12/2016, 19:04   #5
 
elite*gold: 0
Join Date: Oct 2011
Posts: 109
Received Thanks: 12
still the same error
NagySandor96 is offline  
Old 03/13/2016, 14:43   #6
 
elite*gold: 500
Join Date: Jul 2009
Posts: 260
Received Thanks: 539
remove the "end" after return @JobID and add a "," between your values...
Bizzyyyyy is offline  
Old 08/17/2016, 21:28   #7
 
elite*gold: 0
Join Date: Oct 2011
Posts: 109
Received Thanks: 12
@ !
Everything works fine,but when I'm using the scroll in-game I dont get anything.
I guess the procedure isn't perfect. Could you help me? :/

#Problem has been solved
The correct Procedure which has to be added to SRO_VT_LOG>_AddLogItem Procedure

//attached the correct procedure//
Attached Images
File Type: jpg procedure (2).jpg (12.9 KB, 11 views)
NagySandor96 is offline  
Old 08/17/2016, 23:26   #8
CheeseBurger !!


 
elite*gold: 1
Join Date: Oct 2012
Posts: 8,409
Received Thanks: 3,219
^
Closed


Spidy. is offline  
Closed Thread



« Help i want open Server with Ip Static | mbot problem :( »

Similar Threads
[ASK] Join BM procedure
02/28/2016 - Seafight - 1 Replies
Hi. I am trying to develop a No CC RaidBot. I modified NPCBot 3.02 -by trolleras and fixed by goldenpower- to shoot leviathans, but I still need to add a join BM procedure. I was thinking about extracting the procedures from trolleras BM bot just like the BonusMapCheck. Anyone willing to help? I could also add sunburst, but the bitmaps I have are not very precise.
Procedure For +3 Scroll [_AddTimedJob]
01/14/2015 - SRO PServer Guides & Releases - 0 Replies
Hey every one ! 2day i'll Release new scroRZePvpers this procedure created for give extra +3 to the item in slot '1' at char inventory, but this scroll not work if your item +8 or more. i mean it will give the extra +3 to any D11 EGY A or B +1 ~ +7 in Slot 1 in your inventory. you can change the values as u want ! Slot, Extra plus, Items ID's and which item plus to work
Procedure
12/08/2014 - SRO Private Server - 2 Replies
resert skills > status > remove premium ? any one got right Procedure? ?
Please giv me the right procedure of 10x dmg launcher..
05/19/2008 - RF Online - 5 Replies
Please:Help me to have a 10xdmg launcher pls i dont know or give me the exact procedure to do it.. Thanks to all Help me:D



All times are GMT +2. The time now is 11:25.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

BTC: 33E6kMtxYa7dApCFzrS3Jb7U3NrVvo8nsK
ETH: 0xc6ec801B7563A4376751F33b0573308aDa611E05

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2020 elitepvpers All Rights Reserved.