// https://rathena.org/board/topic/107660-r-sql-mall/

-	script	all_in_one_shop_main	-1,{
	
	OnInit:
		callsub(OnLoad,IT_HEALING);
		callsub(OnLoad,IT_USABLE);
		callsub(OnLoad,IT_ETC);
		callsub(OnLoad,IT_WEAPON);
		callsub(OnLoad,IT_ARMOR);
		callsub(OnLoad,IT_CARD);
		callsub(OnLoad,IT_PETEGG);
		callsub(OnLoad,IT_PETARMOR);
		callsub(OnLoad,IT_AMMO);
		callsub(OnLoad,IT_DELAYCONSUME);
		callsub(OnLoad,IT_CASH);
		end;

	OnLoad:
		.@type = getarg( 0,-1 );
		
		.@size = query_sql( "SELECT `id`,`weight`,`atk`,`matk`,`slots`,`weapon_level`,`defence`,`equip_level_min`,`script`,`equip_script`,`unequip_script` FROM `item_db` WHERE `type` = "+.@type, .@id,.@weight,.@atk,.@math,.@slot,.@weapon_level,.@defence,.@equip_level_min,.@script$,.@equip_script$,.@unequip_script$ );

		if ( .@size ) {
			.@npc_count = ( .@size / 100 );
		
			freeloop(1);
			do {
				.@x = 0;
				do {
					.@index = ( .@npc * 100 + .@x );
					
					.@total_cost = 0;
					
					// cost calculations
					.@total_cost += (( .@weight[.@index] / 10 ) * 1000 );
					.@total_cost += (( .@atk[.@index] / 100 ) * 5000 );
					.@total_cost += ( .@slots[.@index] * 3000 );
					.@total_cost += ( .@weapon_level[.@index] * 2000 );
					.@total_cost += (( .@defence[.@index] / 10 ) * 1000 );
					.@total_cost += (( .@equip_level_min[.@index] / 10 ) * 10000 );
			
					// effect count.
					.@total_cost += ( countstr( .@script$,"bonus" ) * 1000 );
					.@total_cost += ( countstr( .@equip_script$,"bonus" ) * 1000 );
					.@total_cost += ( countstr( .@unequip_script$,"bonus" ) * 1000 );
					
				
					.@npc_shop_name$ = "Shop#type_"+.@type+"_"+.@npc;
					npcshopdelitem .@npc_shop_name$,909;
					npcshopadditem .@npc_shop_name$,.@id[.@index],.@total_cost;
					.@x++;
				} while ( .@x < 100 && .@index < .@size );
				.@npc++;
			} while ( .@npc <= .@npc_count );
			debugmes "Loaded NPC Shop for Item Type "+.@type+" - "+( ( .@npc * 100 + .@x ) - 1 )+" Item(s)";
			freeloop(0);
		}
		return;

}

prt_fild08,203,72,5	shop	Shop#type_0_1	4_F_KAFRA1,909:-1
prt_fild08,205,72,5	shop	Shop#type_0_2	4_F_KAFRA1,909:-1
prt_fild08,207,72,5	shop	Shop#type_0_3	4_F_KAFRA1,909:-1
prt_fild08,209,72,5	shop	Shop#type_0_4	4_F_KAFRA1,909:-1

prt_fild08,203,72,5	shop	Shop#type_2_1	4_F_KAFRA1,909:-1
prt_fild08,205,72,5	shop	Shop#type_2_2	4_F_KAFRA1,909:-1
prt_fild08,207,72,5	shop	Shop#type_2_3	4_F_KAFRA1,909:-1
prt_fild08,209,72,5	shop	Shop#type_2_4	4_F_KAFRA1,909:-1
prt_fild08,211,72,5	shop	Shop#type_2_5	4_F_KAFRA1,909:-1
prt_fild08,213,72,5	shop	Shop#type_2_6	4_F_KAFRA1,909:-1
prt_fild08,215,72,5	shop	Shop#type_2_7	4_F_KAFRA1,909:-1
prt_fild08,217,72,5	shop	Shop#type_2_8	4_F_KAFRA1,909:-1
prt_fild08,219,72,5	shop	Shop#type_2_9	4_F_KAFRA1,909:-1
prt_fild08,221,72,5	shop	Shop#type_2_10	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_3_1	4_F_KAFRA1,909:-1
prt_fild08,205,59,5	shop	Shop#type_3_2	4_F_KAFRA1,909:-1
prt_fild08,207,59,5	shop	Shop#type_3_3	4_F_KAFRA1,909:-1
prt_fild08,209,59,5	shop	Shop#type_3_4	4_F_KAFRA1,909:-1
prt_fild08,211,59,5	shop	Shop#type_3_5	4_F_KAFRA1,909:-1
prt_fild08,213,59,5	shop	Shop#type_3_6	4_F_KAFRA1,909:-1
prt_fild08,215,59,5	shop	Shop#type_3_7	4_F_KAFRA1,909:-1
prt_fild08,217,59,5	shop	Shop#type_3_8	4_F_KAFRA1,909:-1
prt_fild08,219,59,5	shop	Shop#type_3_9	4_F_KAFRA1,909:-1
prt_fild08,203,57,5	shop	Shop#type_3_10	4_F_KAFRA1,909:-1
prt_fild08,205,57,5	shop	Shop#type_3_11	4_F_KAFRA1,909:-1
prt_fild08,207,57,5	shop	Shop#type_3_12	4_F_KAFRA1,909:-1
prt_fild08,209,57,5	shop	Shop#type_3_13	4_F_KAFRA1,909:-1
prt_fild08,211,57,5	shop	Shop#type_3_14	4_F_KAFRA1,909:-1
prt_fild08,213,57,5	shop	Shop#type_3_15	4_F_KAFRA1,909:-1
prt_fild08,215,57,5	shop	Shop#type_3_16	4_F_KAFRA1,909:-1
prt_fild08,217,57,5	shop	Shop#type_3_17	4_F_KAFRA1,909:-1
prt_fild08,219,57,5	shop	Shop#type_3_18	4_F_KAFRA1,909:-1
prt_fild08,221,57,5	shop	Shop#type_3_19	4_F_KAFRA1,909:-1

prt_fild08,203,72,5	shop	Shop#type_4_1	4_F_KAFRA1,909:-1
prt_fild08,205,72,5	shop	Shop#type_4_2	4_F_KAFRA1,909:-1
prt_fild08,207,72,5	shop	Shop#type_4_3	4_F_KAFRA1,909:-1
prt_fild08,209,72,5	shop	Shop#type_4_4	4_F_KAFRA1,909:-1
prt_fild08,211,72,5	shop	Shop#type_4_5	4_F_KAFRA1,909:-1
prt_fild08,213,72,5	shop	Shop#type_4_6	4_F_KAFRA1,909:-1
prt_fild08,215,72,5	shop	Shop#type_4_7	4_F_KAFRA1,909:-1
prt_fild08,217,72,5	shop	Shop#type_4_8	4_F_KAFRA1,909:-1
prt_fild08,219,72,5	shop	Shop#type_4_9	4_F_KAFRA1,909:-1
prt_fild08,221,72,5	shop	Shop#type_4_10	4_F_KAFRA1,909:-1
prt_fild08,223,72,5	shop	Shop#type_4_11	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_5_1	4_F_KAFRA1,909:-1
prt_fild08,205,59,5	shop	Shop#type_5_2	4_F_KAFRA1,909:-1
prt_fild08,207,59,5	shop	Shop#type_5_3	4_F_KAFRA1,909:-1
prt_fild08,209,59,5	shop	Shop#type_5_4	4_F_KAFRA1,909:-1
prt_fild08,211,59,5	shop	Shop#type_5_5	4_F_KAFRA1,909:-1
prt_fild08,213,59,5	shop	Shop#type_5_6	4_F_KAFRA1,909:-1
prt_fild08,215,59,5	shop	Shop#type_5_7	4_F_KAFRA1,909:-1
prt_fild08,217,59,5	shop	Shop#type_5_8	4_F_KAFRA1,909:-1
prt_fild08,219,59,5	shop	Shop#type_5_9	4_F_KAFRA1,909:-1
prt_fild08,203,57,5	shop	Shop#type_5_10	4_F_KAFRA1,909:-1
prt_fild08,205,57,5	shop	Shop#type_5_11	4_F_KAFRA1,909:-1
prt_fild08,207,57,5	shop	Shop#type_5_12	4_F_KAFRA1,909:-1
prt_fild08,209,57,5	shop	Shop#type_5_13	4_F_KAFRA1,909:-1
prt_fild08,211,57,5	shop	Shop#type_5_14	4_F_KAFRA1,909:-1
prt_fild08,213,57,5	shop	Shop#type_5_15	4_F_KAFRA1,909:-1
prt_fild08,215,57,5	shop	Shop#type_5_16	4_F_KAFRA1,909:-1
prt_fild08,217,57,5	shop	Shop#type_5_17	4_F_KAFRA1,909:-1
prt_fild08,219,57,5	shop	Shop#type_5_18	4_F_KAFRA1,909:-1
prt_fild08,221,57,5	shop	Shop#type_5_19	4_F_KAFRA1,909:-1
prt_fild08,203,55,5	shop	Shop#type_5_20	4_F_KAFRA1,909:-1
prt_fild08,205,55,5	shop	Shop#type_5_21	4_F_KAFRA1,909:-1
prt_fild08,207,55,5	shop	Shop#type_5_22	4_F_KAFRA1,909:-1
prt_fild08,209,55,5	shop	Shop#type_5_23	4_F_KAFRA1,909:-1
prt_fild08,211,55,5	shop	Shop#type_5_24	4_F_KAFRA1,909:-1
prt_fild08,213,55,5	shop	Shop#type_5_25	4_F_KAFRA1,909:-1
prt_fild08,215,55,5	shop	Shop#type_5_26	4_F_KAFRA1,909:-1
prt_fild08,217,55,5	shop	Shop#type_5_27	4_F_KAFRA1,909:-1
prt_fild08,219,55,5	shop	Shop#type_5_28	4_F_KAFRA1,909:-1
prt_fild08,221,55,5	shop	Shop#type_5_29	4_F_KAFRA1,909:-1
prt_fild08,203,53,5	shop	Shop#type_5_30	4_F_KAFRA1,909:-1
prt_fild08,205,53,5	shop	Shop#type_5_31	4_F_KAFRA1,909:-1
prt_fild08,207,53,5	shop	Shop#type_5_32	4_F_KAFRA1,909:-1
prt_fild08,209,53,5	shop	Shop#type_5_33	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_6_1	4_F_KAFRA1,909:-1
prt_fild08,205,59,5	shop	Shop#type_6_2	4_F_KAFRA1,909:-1
prt_fild08,207,59,5	shop	Shop#type_6_3	4_F_KAFRA1,909:-1
prt_fild08,209,59,5	shop	Shop#type_6_4	4_F_KAFRA1,909:-1
prt_fild08,211,59,5	shop	Shop#type_6_5	4_F_KAFRA1,909:-1
prt_fild08,213,59,5	shop	Shop#type_6_6	4_F_KAFRA1,909:-1
prt_fild08,215,59,5	shop	Shop#type_6_7	4_F_KAFRA1,909:-1
prt_fild08,217,59,5	shop	Shop#type_6_8	4_F_KAFRA1,909:-1
prt_fild08,219,59,5	shop	Shop#type_6_9	4_F_KAFRA1,909:-1
prt_fild08,203,57,5	shop	Shop#type_6_10	4_F_KAFRA1,909:-1
prt_fild08,205,57,5	shop	Shop#type_6_11	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_7_1	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_8_1	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_10_1	4_F_KAFRA1,909:-1
prt_fild08,203,59,5	shop	Shop#type_10_2	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_11_1	4_F_KAFRA1,909:-1
prt_fild08,203,59,5	shop	Shop#type_11_2	4_F_KAFRA1,909:-1

prt_fild08,203,59,5	shop	Shop#type_18_1	4_F_KAFRA1,909:-1
prt_fild08,205,59,5	shop	Shop#type_18_2	4_F_KAFRA1,909:-1
prt_fild08,207,59,5	shop	Shop#type_18_3	4_F_KAFRA1,909:-1
prt_fild08,209,59,5	shop	Shop#type_18_4	4_F_KAFRA1,909:-1
prt_fild08,211,59,5	shop	Shop#type_18_5	4_F_KAFRA1,909:-1
prt_fild08,213,59,5	shop	Shop#type_18_6	4_F_KAFRA1,909:-1
prt_fild08,215,59,5	shop	Shop#type_18_7	4_F_KAFRA1,909:-1
prt_fild08,217,59,5	shop	Shop#type_18_8	4_F_KAFRA1,909:-1
prt_fild08,219,59,5	shop	Shop#type_18_9	4_F_KAFRA1,909:-1
prt_fild08,203,57,5	shop	Shop#type_18_10	4_F_KAFRA1,909:-1
prt_fild08,205,57,5	shop	Shop#type_18_11	4_F_KAFRA1,909:-1