R> Npc for Counting Total item in Inventory and Cart item or whole database?

[Ryoma27]

let say the server has a total 2,000,000 apples and the players Farm of total 500,000 apples, npc will set the price of that item depends on the total price 2M/500k=4z for selling Price, and 1-3% buying price, like in stock exchange? the price will automatically change based on supply and demand every minute or every hour, any one? 

[Emistry]

something like this ?

prontera,155,181,5	shop	apple_shop	757,909:-1

-	script	apple_shop_main	-1,{
	
	OnInit:
		.item_id = 512;
		.max_amount = 2000000;
		
		.shop_npc$ = "apple_shop";
		
	OnMinute00: // update every hour
		hideonnpc .shop_npc$;
		npcshopdelitem .shop_npc$, .item_id;
		.@sql$ = .@sql$ + "SELECT `amount` FROM `inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `cart_inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `storage` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `guild_storage` WHERE `nameid` = "+.item_id;
		.@size = query_sql(.@sql$, .@amount);
		for (.@i = 0; .@i < .@size; .@i++)
			.@total_amount += .@amount[.@i];
		
		setiteminfo .item_id, ITEMINFO_SELL, (.max_amount / .@total_amount);
		setiteminfo .item_id, ITEMINFO_BUY, (((.max_amount / .@total_amount) * 100) / rand(1, 3)));
		
		npcshopadditem .shop_npc$, .item_id, (.max_amount / .@total_amount);
		hideoffnpc .shop_npc$;
		end;
}

 

Edited March 5, 2022 by Emistry

[Ryoma27]

23 hours ago, Emistry said:

something like this ?

prontera,155,181,5	shop	apple_shop	757,909:-1

-	script	apple_shop_main	-1,{
	
	OnInit:
		.item_id = 512;
		.max_amount = 2000000;
		
		.shop_npc$ = "apple_shop";
		
	OnMinute00: // update every hour
		hideonnpc .shop_npc$;
		npcshopdelitem .shop_npc$, .item_id;
		.@sql$ = .@sql$ + "SELECT `amount` FROM `inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `cart_inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `storage` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `guild_storage` WHERE `nameid` = "+.item_id;
		.@size = query_sql(.@sql$, .@amount);
		for (.@i = 0; .@i < .@size; .@i++)
			.@total_amount += .@amount[.@i];
		
		setiteminfo .item_id, ITEMINFO_SELL, (.max_amount / .@total_amount);
		setiteminfo .item_id, ITEMINFO_BUY, (((.max_amount / .@total_amount) * 100) / rand(1, 3)));
		
		npcshopadditem .shop_npc$, .item_id, (.max_amount / .@total_amount);
		hideoffnpc .shop_npc$;
		end;
}

 

let me try this Sir Emistry, 

[Ryoma27]

On 3/5/2022 at 5:55 PM, Emistry said:

something like this ?

prontera,155,181,5	shop	apple_shop	757,909:-1

-	script	apple_shop_main	-1,{
	
	OnInit:
		.item_id = 512;
		.max_amount = 2000000;
		
		.shop_npc$ = "apple_shop";
		
	OnMinute00: // update every hour
		hideonnpc .shop_npc$;
		npcshopdelitem .shop_npc$, .item_id;
		.@sql$ = .@sql$ + "SELECT `amount` FROM `inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `cart_inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `storage` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `guild_storage` WHERE `nameid` = "+.item_id;
		.@size = query_sql(.@sql$, .@amount);
		for (.@i = 0; .@i < .@size; .@i++)
			.@total_amount += .@amount[.@i];
		
		setiteminfo .item_id, ITEMINFO_SELL, (.max_amount / .@total_amount);
		setiteminfo .item_id, ITEMINFO_BUY, (((.max_amount / .@total_amount) * 100) / rand(1, 3)));
		
		npcshopadditem .shop_npc$, .item_id, (.max_amount / .@total_amount);
		hideoffnpc .shop_npc$;
		end;
}

 

new_zone04,93,108,5	shop	Wisteria_Shop	757,30006:-1

-	script	Wisteria_Shop_main	-1,{
	
	OnInit:
		.item_id = 30006;
		.max_amount = 20000000;
		
		.shop_npc$ = "Wisteria_Shop";
		
	OnMinute00: // update every hour
		hideonnpc .shop_npc$;
		npcshopdelitem .shop_npc$, .item_id;
		.@sql$ = .@sql$ + "SELECT `amount` FROM `inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `cart_inventory` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `storage` WHERE `nameid` = "+.item_id;
		.@sql$ = .@sql$ + " UNION ";
		.@sql$ = .@sql$ + "SELECT `amount` FROM `guild_storage` WHERE `nameid` = "+.item_id;
		.@size = query_sql(.@sql$, .@amount);
		for (.@i = 0; .@i < .@size; .@i++)
			.@total_amount += .@amount[.@i];
		
		setiteminfo .item_id, ITEMINFO_SELL, (.max_amount / .@total_amount);
		setiteminfo .item_id, ITEMINFO_BUY, (((.max_amount / .@total_amount) * 100) / rand(1, 3)));
		
		npcshopadditem .shop_npc$, .item_id, (.max_amount / .@total_amount);
		hideoffnpc .shop_npc$;
		end;
}