R> Custom WoE Salary from database

[CyanZoldyck]

Hello! I need help. I am using Euphy's WOE Controller script. I have this customization on where I am counting total of Silver Coins farmed from my fishing system to be uploaded in database. Count total of silver coins got in fishing per week and upload it in database

 

Now, I want this silver coins to be added in WoE salary in this computation: Total of Silver Coins farmed in the whole server*5/100

 

woe_controller.txt

[CyanZoldyck]

Hi, Can someone help me with this?

Here's the WOE rewards:

	// Rewards per castle.
	//   setarray .reward_id[0],     <itemID>{,<itemID>,...}
	//   setarray .reward_amount[0], <amount>{,<amount>,...}
	setarray .reward_id[0],30202,12103;
	setarray .reward_amount[0],50,5;

Here's my database table. I want to SUM the points column and then put that points added into WOE salary rewards into the ItemID 30202 in this computation. Total SUM of points * 5 / 100

Hi rAthena community, any luck with this? 

[CyanZoldyck]

Anyone can help me with this? Thanks!

[ryzenthird]

Total Silver Coin Farmed in the whole server?

query_sql("SELECT SUM(points) FROM table_name",.@sumpoints); // This would add all the points in the server or you could modify this to sum/add all silver coined farmed in the server like if its in inventory it should be 

query_sql("SELECT COUNT(*) FROM inventory WHERE item_id = silver_coin_item_id",.@total_silver_coined_farmed);

so it should be

set .@total,(.@total_silver_coined_farmed * 5) / 100; 

[CyanZoldyck]

The query worked thank you! Can you teach me how can I add it as WoE reward?

set .@total,(.@total_silver_coined_farmed * 5) / 100; 

[CyanZoldyck]

bump. Anyone? Thank you!