Register for your free account! | Forgot your password?

You last visited: Today at 13:19

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

Advertisement



Contribution problem

Discussion on Contribution problem within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
Cript_1337's Avatar
 
elite*gold: 0
Join Date: Jan 2015
Posts: 216
Received Thanks: 68
Post Contribution problem

Hello guys , i added job system to my server but i have a little problem
in this it require my server Contribution so i make a trade and get the Contribution from CharTrojb table
Code:
if exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = [MENTION=395373]Chari[/MENTION]D
and Contribution >= '2928581' and JobType = '1' and [MENTION=444787]Char[/MENTION]_ReqLevel >= '95')
begin
well , the problem is . the first trade i get the reward, but when i try again to do another trade with the same character i dont get any reward "coins" any more because the Contribution of the character changes , and its not the same as the Contribution at the procedure

so how can i solve this?
Cript_1337 is offline  
Old 07/09/2018, 08:44   #2
 
elite*gold: 0
Join Date: May 2008
Posts: 167
Received Thanks: 2
i wish someone helps you because i already had this issue
multiuses is offline  
Old 07/09/2018, 15:57   #3


 
ZαKuRα's Avatar
 
elite*gold: 23
Join Date: Feb 2011
Posts: 641
Received Thanks: 477
Quote:
USE [Name Your Log]GO
/****** Object: StoredProcedure [dbo].[_JobCoins] Script Date: 25.02.2015 13:24:59 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




CREATE procedure [dbo].[_JobCoins] @charID int, @eventID tinyint
as
DECLARE @charnameJob varchar(268) = (Select CharName16 From SRO_VT_SHARD.dbo._Char where CharID = @charID)
Declare @JID Int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = @charID)
DECLARE @char_ReqLevel int = (Select CurLevel from SRO_VT_SHARD.dbo._char where CharID = @charID)
-- Begin Hunter Reward
If @eventID = 6
begin
Declare @cosID int = (select ID from SRO_VT_SHARD.dbo._CharCOS where OwnerCharID = @charID)
----------------------------------------------------------Begin Delete pet if he loggout.
Delete from SRO_VT_SHARD.dbo._InvCOS where COSID = @cosID
Delete from SRO_VT_SHARD.dbo._CharCOS where
OwnerCharID = @charID and RefCharID between '2187' and '2189'
or OwnerCharID = @charID and RefCharID between '3915' and '3917'
or OwnerCharID = @charID and RefCharID between '3912' and '3914'
or OwnerCharID = @charID and RefCharID between '2184' and '2186'
or OwnerCharID = @charID and RefCharID between '23250' and '23257'
or OwnerCharID = @charID and RefCharID between '23258' and '23265'
or OwnerCharID = @charID and RefCharID between '23905' and '23912'
end
if exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @charID
and Contribution >= '3484407' and JobType = '3' and @char_ReqLevel >= '80' )
begin
exec SRO_VT_SHARD.._Add_ITEM_EXTERN @charnamejob,'ITEM_ETC_ARENA_COIN',10,10
Update SRO_VT_SHARD.dbo._CharTrijob set Contribution = '1' where CharID = @charID
end -- orig 3484407
if exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @charID
and Contribution >= '3484407' and JobType = '1' and @char_ReqLevel >= '80')
begin
exec SRO_Vt_SHARD.._Add_ITEM_EXTERN @charnamejob,'ITEM_ETC_ARENA_COIN',10,10
Update SRO_VT_SHARD.dbo._CharTrijob set Contribution = '1' where CharID = @charID
end
if exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @charID
and Contribution >= '3484407' and JobType = '2' and @char_ReqLevel >= '80') begin
exec SRO_Vt_SHARD.._Add_ITEM_EXTERN @charnamejob,'ITEM_ETC_ARENA_COIN',10,10
Update SRO_VT_SHARD.dbo._CharTrijob set Contribution = '1' where CharID = @charID

end
.
ZαKuRα is offline  
Thanks
1 User
Old 07/09/2018, 19:18   #4

 
Bocc1337's Avatar
 
elite*gold: 737
Join Date: Oct 2007
Posts: 730
Received Thanks: 133
You need to make the contributions to reset after each trade. Likr a relog and make a range example. Contribution 1000000. To. 2000000
Sory on mobile cant tpye out full code.
Keep in mind. Also the shorter routs give less then the longer routs.
This is also why a range is best
Bocc1337 is offline  
Old 07/10/2018, 06:08   #5

 
HECKT0R's Avatar
 
elite*gold: 96
Join Date: Nov 2012
Posts: 548
Received Thanks: 349
use this code inside your LOG DB> _Addlogchar procedure

PHP Code:
IF (@EventID '9') OR (@EventID '11'
BEGIN
UPDATE SRO_VT_SHARD
.._CharTrijob
            SET Contribution 
0
        WHERE CharID 
= [MENTION=395373]Chari[/MENTION]D
end 
but make sure to use it after your job procedure
or you can use the code above inside job procedure itself but after granting job reward .
HECKT0R is online now  
Thanks
1 User
Reply


Similar Threads Similar Threads
Banneth's Contribution to the community (Nc 2.2 Auto'r)
04/03/2009 - General Gaming Discussion - 16 Replies
Hackers, I have tried to get some help here, tried to help my knolage grow, but it seems no one will share info with me. SO i decided i will contribute, to the community so that i may prove myself. and hopefully you will PM me or whatever with some help to my inquires (IE the difrent hacks) Please enjoy this NC 2.2 auto'r It includes, Lom pill macro. Weapon parts macro,
My first contribution
07/25/2007 - CO2 Exploits, Hacks & Tools - 2 Replies
I was just thinking that on my server Meteor tears sell for around 750 k, So i was just thinking that you could keep on trading someone and then Propose to them and it might take a while but it might be a good way to make millions a day since you get a meteor tear when somone divorces from you.
My contribution...
04/01/2007 - Conquer Online 2 - 16 Replies
Ok, all you have to do is always click on the same box and you have a greater chance at socs. This isnt luck, it's statistics. Think about real life lottories (not scratch off). People pick certain numbers and always play them, why? Because it's a hell of a bigger chance to keep trying the same number and hoping it wins then trying to pick random numbers each week and hoping it hits. If you have basic C++ knowledge then make a program that simulates a 6 number lottory system with...
Contribution
01/24/2007 - Conquer Online 2 - 4 Replies
Alright as u can see im a "non contributor" and ill admit i mostly dl shit BUT reason being is I R NOOB:P like im still in highschool grade 11 and im just STARTING to get into like C++ coding next semester and like im just curious as to how ppls learned to code:) for example college, took shops on it, even just highschool. I DONT need how old u r:P im just curious cus i obviously CANT contribute if im not skilled enough yet but once i am watch outXD. ANYWAYS feedback would be nice^^ liek i said...
Contribution Points, Made Easy
07/29/2005 - WoW Guides & Templates - 0 Replies
This one is being used a lot lately to gain ton's of cont points for one individual. One "ungrouped" person taps a racial leader, and a raid group kills him. The person with the tap, of course, gets all of the points. It's being done a lot on Cairne in Thunder Bluff.



All times are GMT +1. The time now is 13:19.


Powered by vBulletin®
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

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