Register for your free account! | Forgot your password?

You last visited: Today at 01:29

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


[Release] Job Reward system

Reply
 
Old 05/08/2015, 16:12   #16
 
elite*gold: 0
Join Date: Mar 2012
Posts: 589
Received Thanks: 18
How do we determine the NPC?
When they sell will give awards of example only specified NPCs



ILowe is offline  
Old 05/08/2015, 16:39   #17

 
elite*gold: 0
Join Date: Dec 2014
Posts: 358
Received Thanks: 524
Quote:
Originally Posted by Count Dracula View Post
Apollo ? whay don'tu fix it first and then release it full fixed.
bc this system working, no have any prob OQAY?!


Apollo* is offline  
Thanks
2 Users
Old 05/08/2015, 16:45   #18
 
elite*gold: 85
Join Date: Feb 2014
Posts: 1,033
Received Thanks: 1,583
Dafuq did I just read.

Don't copy paste garbage code from me that I've deleted since 3 years.
Royalblade* is offline  
Old 05/08/2015, 16:53   #19

 
elite*gold: 0
Join Date: Dec 2014
Posts: 358
Received Thanks: 524
Quote:
Originally Posted by Royalblade* View Post
Dafuq did I just read.

Don't copy paste garbage code from me that I've deleted since 3 years.
True, your code's garbage..


Apollo* is offline  
Thanks
2 Users
Old 05/08/2015, 22:03   #20
 
elite*gold: 0
Join Date: Mar 2012
Posts: 589
Received Thanks: 18
error:

Each entry gives out awards.
ILowe is offline  
Old 05/08/2015, 22:32   #21


 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,095
Received Thanks: 2,630
^yes ofc, this thing doesn't reset the contribution, check the one I wrote above, I added the update statement which is missing. However, this code is pretty old.
​Exo is offline  
Old 05/08/2015, 22:44   #22
 
elite*gold: 0
Join Date: Mar 2012
Posts: 589
Received Thanks: 18
Try this

_AddLogChar

Code:
	declare @contribution int;
	declare @coinWinfortra int;
	declare @coinWinforthi int;
	declare @coinWinforhun int;
	declare @dividerfortra int;
	declare @dividerforthi int;
	declare @dividerforhun int;
	declare @charname16 varchar(16);
	declare @JobType int;

	set @dividerfortra = 270000;
	set @dividerforthi = 900000;
	set @dividerforhun = 300000;

	if(@EventID = 6)
	begin
	set @charname16 = (SELECT CharName16 FROM [SRO_VT_SHARD].[dbo].[_Char] where CharID = @CharID);
	set @contribution = (SELECT Contribution FROM [SRO_VT_SHARD].[dbo].[_CharTriJob] WHERE CharID = @CharID);
	set @coinWinfortra = ROUND( @contribution / @dividerfortra,0);
	set @coinWinforthi = ROUND (@contribution / @dividerforthi,0);
	set @coinWinforhun = ROUND (@contribution / @dividerforhun,0);
	set @JobType = (SELECT JobType FROM [SRO_VT_SHARD].[dbo].[_CharTrijob] Where CharID = @CharID);
	if(@coinWinfortra != 0 and @JobType = 1)
	begin
	exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @charname16, 'ITEM_ETC_SD_TOKEN_04', @coinWinfortra, 0;
	UPDATE [SRO_VT_SHARD].[dbo].[_CharTriJob] set Contribution = 0 WHERE CharID = @CharID;
	END
	if(@coinWinforthi != 0 and @JobType=2)
	begin
	exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @charname16, 'ITEM_ETC_SD_TOKEN_04', @coinWinforthi, 0;
	UPDATE [SRO_VT_SHARD].[dbo].[_CharTriJob] set Contribution = 0 WHERE CharID = @CharID;
	END
	if(@coinWinforhun != 0 and @JobType=3)
	begin
	exec [SRO_VT_SHARD].[dbo].[_ADD_ITEM_EXTERN] @charname16, 'ITEM_ETC_SD_TOKEN_04', @coinWinforhun, 0;
	UPDATE [SRO_VT_SHARD].[dbo].[_CharTriJob] set Contribution = 0 WHERE CharID = @CharID;
	END
	END
ILowe is offline  
Old 05/09/2015, 00:16   #23


 
elite*gold: 907
Join Date: Jan 2015
Posts: 791
Received Thanks: 237
thanks very usful
TheRunner is offline  
Old 05/09/2015, 09:18   #24
 
elite*gold: 0
Join Date: Feb 2014
Posts: 45
Received Thanks: 1
Nice Job
yaabnel5wl is offline  
Old 05/28/2015, 09:25   #25
 
elite*gold: 0
Join Date: Mar 2012
Posts: 589
Received Thanks: 18
We NPC? determining how
Examples of awards they will sell only when the specified NPC
ILowe is offline  
Old 06/06/2015, 21:00   #26
 
elite*gold: 0
Join Date: Dec 2007
Posts: 204
Received Thanks: 10
Quote:
Originally Posted by thebate1 View Post
The module '_RoyalAutoCoinGranting' depends on the missing object 'SRO_VT_SHARDLOG.dbo._RoyalContributionUnlimiter'. The module will still be created; however, it cannot run successfully until the object exists.
The module '_RoyalAutoCoinGranting' depends on the missing object 'SRO_VT_SHARDLOG.dbo._RoyalContributionUnlimiter'. The module will still be created; however, it cannot run successfully until the object exists.
Easy Cheap ..

Your BD Log Probably no is 'SRO_VT_SHARDLOG' .. look it.. in defaut case ur database log named [COLOR="red"]'Log_db'[/COLOR


change Log name db in query and try ...


But its a Lost Timer try this.. all query take sucess and no reward in game as take... Iam test with Trader LV1 to 7 ,.. nothing reward ....


#Bad
spinal2 is offline  
Old 06/28/2015, 03:03   #27
 
elite*gold: 0
Join Date: Mar 2012
Posts: 589
Received Thanks: 18
HAVE BUG CONS HELP ME
ILowe is offline  
Old 01/08/2017, 06:17   #28
 
elite*gold: 0
Join Date: Mar 2013
Posts: 16
Received Thanks: 0
How to change the table _CharTrijob

Quote:
Originally Posted by Apollo* View Post
bc this system working, no have any prob OQAY?!
How to change the table _CharTrijob of the Level is greater than 7, including the client?
tx2013 is offline  
Old 01/09/2017, 23:11   #29
 
elite*gold: 0
Join Date: Jan 2012
Posts: 264
Received Thanks: 115
For some reasons after using these procs im not receiving any contribution or exp nor gold anymore, Which is actually weird and i've never experienced this bug before lel


Flowushy is offline  
Reply



« [Re-Upload] DuelRoad DB ch dg 8 | [Release] How To Add Unique Scroll In DB »

Similar Threads
[Release] PHP Vote Reward System
07/13/2016 - Shaiya PServer Guides & Releases - 20 Replies
!important Alright guys I've fixed all the issues that i know of please let me know if you find any more. Well here is an epic release for elitepvpers I've spent a few hours coding this so I really hope you guys enjoy it. So what does this PHP Vote Reward System do well if you know Shaiya Invasions Shaiya Vote Reward system well this is almost a complete copy players don't get the points until they click the link back to the website from the vote site. Also FYI this script can't be...
[Release]Unique Slayer System ,, grant title + write notice + reward
12/10/2014 - SRO PServer Guides & Releases - 29 Replies
This system has never been released before .. and as i know , haters are going to hate , thats usual .. explaining of this system : When you kill a specific unique 10 times or however value you select ,, a notice will be written with your char name and which unique you killed and which title you have received .. It'll also reward u a title name .. And it'll reward you an item from your select .. as i know you should edit this and not reply with : 'error' or 'not working' .. and of course you...
[Release] Daily Reward System
11/24/2014 - SRO PServer Guides & Releases - 17 Replies
Since i saw no server using this systems and i got it, i decided to release it , reading the procedure will explain it more ! before reading the procedure, some ppl asked me why ADD_ITEM_EXTERN_CHEST? i said : because the reward will go to storage not inventory , and not to work on 4 chars per 1 acc. Add this to _AddLogChar at log db Create this procedure at LOG db Create this table at log db
[Release]Message System (create Your Own Automtic reply& reward )
12/04/2013 - SRO PServer Guides & Releases - 17 Replies
Well after Ludoworks showed their new krall server i saw gr8 stuff they made in the server. but i love to keep everything to public so by the time I'll post every thing they made on their server . starting with (Message system for getting titles or Even Giving gold or Silks for VIP members its based on your imagination) i will post krall query's and scripts for making my tool much more better :-p http://www4.0zz0.com/2013/01/16/09/154333083.png http://i.imgur.com/FcGlN.png
[Release] Vote Reward System
02/07/2013 - CO2 PServer Guides & Releases - 12 Replies
Hello, i've been requesting & asking too much questions, and thought that because Epvp(members) helped me, i've to help back. This vote system works on the 5672+ sources available these days, but it can work on any source if you know what you're doing. How does it work : NPC that opens a vote link & adds a CPs amount, works every 12h -----------Codes------------- Open Dialogs.cs(or NPCS.cs, depends on your source): Paste this with the other npcs



All times are GMT +1. The time now is 01:29.


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

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2018 elitepvpers All Rights Reserved.