[Release] Job Reward system

[ILowe]

How do we determine the NPC?
When they sell will give awards of example only specified NPCs

[Apollo*]

Originally Posted by Count Dracula

Apollo ? whay don'tu fix it first and then release it full fixed.

bc this system working, no have any prob OQAY?!

[Royalblade*]

Dafuq did I just read.

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

[Apollo*]

Originally Posted by Royalblade*

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..

[ILowe]

error:

Each entry gives out awards.

[​Exo]

^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.

[ILowe]

Try this

_AddLogChar

	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

[TheRunner]

thanks very usful

[yaabnel5wl]

Nice Job

[ILowe]

We NPC? determining how
Examples of awards they will sell only when the specified NPC

[spinal2]

Originally Posted by thebate1

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

[ILowe]

HAVE BUG CONS HELP ME

[tx2013]

Originally Posted by Apollo*

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?

[Tommy.]

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

[rogerio14]

how i can limit only 100 coins for day ? any know ?