// https://rathena.org/board/topic/107660-r-sql-mall/
- script all_in_one_shop_main -1,{
// Shop NPC Name
function func_ShopTypeName {
switch (getarg(0, -1)) {
case IT_HEALING: return "Healing";
case IT_USABLE: return "";
case IT_ETC: return "Etc";
case IT_WEAPON: return "";
case IT_ARMOR: return "Armor";
case IT_CARD: return "Card";
case IT_PETEGG: return "Petegg";
case IT_PETARMOR: return "Petarmor";
case IT_AMMO: return "Ammo";
case IT_DELAYCONSUME: return "Delayconsume";
case IT_SHADOWGEAR: return "Shadowgear";
case IT_CASH: return "Cash";
default: return "Misc";
}
}
// Shop NPC Sprite ID
function func_ShopClassID {
switch (getarg(0, -1)) {
case IT_HEALING: return -1;
case IT_USABLE: return 4_F_KAFRA2;
case IT_ETC: return 4_F_KAFRA3;
case IT_WEAPON: return 4_F_KAFRA4;
case IT_ARMOR: return 4_F_KAFRA5;
case IT_CARD: return 4_F_KAFRA6;
case IT_PETEGG: return 4_F_KAFRA7;
case IT_PETARMOR: return 4_F_KAFRA8;
case IT_AMMO: return 4_F_KAFRA9;
case IT_DELAYCONSUME: return 4_F_KAFRA2;
case IT_SHADOWGEAR: return 4_F_KAFRA5;
case IT_CASH: return -1;
default: return rand(-1, 4_F_KAFRA9);
}
}
OnInit:
.is_renewal_db = 1;
.max_shop_item = 100;
.blacklist_item$ = "5001,5002,5003";
sleep 1000; // delays
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_SHADOWGEAR);
callsub(OnLoad, IT_CASH);
end;
OnLoad:
.@type = getarg(0, -1);
.@type_name$ = func_ShopTypeName(.@type);
.@npc = 1;
.@sql$ = "SELECT `id`, `weight`, `attack`, " + (.is_renewal_db ? "`magic_attack`" : "`attack`") + ", `slots`, `weapon_level`, `defense`, `equip_level_min`, `script`, `equip_script`, `unequip_script` "
+ "FROM `" + (.is_renewal_db ? "item_db_re" : "item_db") + "` "
+ "WHERE `type` = '"+escape_sql(.@type_name$)+"'";
if (.blacklist_item$ != "")
.@sql$ = .@sql$ + " AND `id` NOT IN ("+escape_sql(.blacklist_item$)+")";
.@sql$ = .@sql$ + " ORDER BY `name_english`";
.@size = query_sql(.@sql$, .@id, .@weight, .@atk, .@matk, .@slot, .@weapon_level, .@defense, .@equip_level_min, .@script$, .@equip_script$, .@unequip_script$);
if (.@size > 0) {
.@npc_count = (.@size / .max_shop_item);
freeloop(1);
do {
.@x = 0;
.@npc_shop_name$ = "Shop#t_"+.@type+"_"+.@npc;
if (getmapxy(.@map$, .@map_x, .@map_y, BL_NPC, .@npc_shop_name$)) {
errormes "SQL Mall - NPC not found - " + .@npc_shop_name$;
}
else {
npcshopdelitem .@npc_shop_name$, 909;
do {
.@index = (.@npc * .max_shop_item + .@x);
.@total_cost = 0;
// cost calculations
.@total_cost += ((.@weight[.@index] / 10) * 1000);
.@total_cost += ((.@atk[.@index] / 100) * 5000);
if (.is_renewal_db)
.@total_cost += ((.@matk[.@index] / 100) * 5000);
.@total_cost += (.@slots[.@index] * 3000);
.@total_cost += (.@weapon_level[.@index] * 2000);
.@total_cost += ((.@defense[.@index] / 10) * 1000);
.@total_cost += ((.@equip_level_min[.@index] / 10) * 10000);
// effect count.
.@total_cost += (countstr(.@script$[.@index], "bonus") * 1000);
.@total_cost += (countstr(.@equip_script$[.@index], "bonus") * 1000);
.@total_cost += (countstr(.@unequip_script$[.@index], "bonus") * 1000);
.@total_cost += (countstr(.@unequip_script$[.@index], "heal") * 100);
.@total_cost += (countstr(.@unequip_script$[.@index], "warp") * 1000);
if (.@total_cost > 0)
npcshopadditem .@npc_shop_name$, .@id[.@index], .@total_cost;
.@x++;
.@total_item_count++;
} while (.@x < .max_shop_item && .@index < .@size);
setnpcdisplay(.@npc_shop_name$, .@type_name$+" "+.@npc+"#t_"+.@type+"_"+.@npc, func_ShopClassID(.@type));
}
.@npc++;
} while (.@npc <= .@npc_count);
freeloop(0);
}
// Remove excessive NPC
while (!getmapxy(.@map$, .@map_x, .@map_y, BL_NPC, "Shop#t_"+.@type+"_"+.@npc) || .@npc <= .@npc_count) {
disablenpc "Shop#t_"+.@type+"_"+.@npc;
.@npc++;
}
// debugmes "SQL Mall - " + func_ShopTypeName(.@type) + " - Loaded " + F_InsertComma(.@total_item_count) + " Item(s)";
return;
}
// Add more if needed (follow the name and numbering)
prt_fild08,201,40,5 shop Shop#t_0_1 -1,909:-1
prt_fild08,202,40,5 shop Shop#t_0_2 -1,909:-1
prt_fild08,203,40,5 shop Shop#t_0_3 -1,909:-1
prt_fild08,204,40,5 shop Shop#t_0_4 -1,909:-1
prt_fild08,201,42,5 shop Shop#t_2_1 -1,909:-1
prt_fild08,202,42,5 shop Shop#t_2_2 -1,909:-1
prt_fild08,203,42,5 shop Shop#t_2_3 -1,909:-1
prt_fild08,204,42,5 shop Shop#t_2_4 -1,909:-1
prt_fild08,205,42,5 shop Shop#t_2_5 -1,909:-1
prt_fild08,206,42,5 shop Shop#t_2_6 -1,909:-1
prt_fild08,207,42,5 shop Shop#t_2_7 -1,909:-1
prt_fild08,208,42,5 shop Shop#t_2_8 -1,909:-1
prt_fild08,209,42,5 shop Shop#t_2_9 -1,909:-1
prt_fild08,210,42,5 shop Shop#t_2_10 -1,909:-1
prt_fild08,201,44,5 shop Shop#t_3_1 -1,909:-1
prt_fild08,202,44,5 shop Shop#t_3_2 -1,909:-1
prt_fild08,203,44,5 shop Shop#t_3_3 -1,909:-1
prt_fild08,204,44,5 shop Shop#t_3_4 -1,909:-1
prt_fild08,205,44,5 shop Shop#t_3_5 -1,909:-1
prt_fild08,206,44,5 shop Shop#t_3_6 -1,909:-1
prt_fild08,207,44,5 shop Shop#t_3_7 -1,909:-1
prt_fild08,208,44,5 shop Shop#t_3_8 -1,909:-1
prt_fild08,209,44,5 shop Shop#t_3_9 -1,909:-1
prt_fild08,210,44,5 shop Shop#t_3_10 -1,909:-1
prt_fild08,211,44,5 shop Shop#t_3_11 -1,909:-1
prt_fild08,212,44,5 shop Shop#t_3_12 -1,909:-1
prt_fild08,213,44,5 shop Shop#t_3_13 -1,909:-1
prt_fild08,214,44,5 shop Shop#t_3_14 -1,909:-1
prt_fild08,215,44,5 shop Shop#t_3_15 -1,909:-1
prt_fild08,216,44,5 shop Shop#t_3_16 -1,909:-1
prt_fild08,217,44,5 shop Shop#t_3_17 -1,909:-1
prt_fild08,218,44,5 shop Shop#t_3_18 -1,909:-1
prt_fild08,219,44,5 shop Shop#t_3_19 -1,909:-1
prt_fild08,220,44,5 shop Shop#t_3_20 -1,909:-1
prt_fild08,221,44,5 shop Shop#t_3_21 -1,909:-1
prt_fild08,222,44,5 shop Shop#t_3_22 -1,909:-1
prt_fild08,223,44,5 shop Shop#t_3_23 -1,909:-1
prt_fild08,224,44,5 shop Shop#t_3_24 -1,909:-1
prt_fild08,225,44,5 shop Shop#t_3_25 -1,909:-1
prt_fild08,226,44,5 shop Shop#t_3_26 -1,909:-1
prt_fild08,227,44,5 shop Shop#t_3_27 -1,909:-1
prt_fild08,228,44,5 shop Shop#t_3_28 -1,909:-1
prt_fild08,229,44,5 shop Shop#t_3_29 -1,909:-1
prt_fild08,201,46,5 shop Shop#t_4_1 -1,909:-1
prt_fild08,202,46,5 shop Shop#t_4_2 -1,909:-1
prt_fild08,203,46,5 shop Shop#t_4_3 -1,909:-1
prt_fild08,204,46,5 shop Shop#t_4_4 -1,909:-1
prt_fild08,205,46,5 shop Shop#t_4_5 -1,909:-1
prt_fild08,206,46,5 shop Shop#t_4_6 -1,909:-1
prt_fild08,207,46,5 shop Shop#t_4_7 -1,909:-1
prt_fild08,208,46,5 shop Shop#t_4_8 -1,909:-1
prt_fild08,209,46,5 shop Shop#t_4_9 -1,909:-1
prt_fild08,210,46,5 shop Shop#t_4_10 -1,909:-1
prt_fild08,211,46,5 shop Shop#t_4_11 -1,909:-1
prt_fild08,212,46,5 shop Shop#t_4_12 -1,909:-1
prt_fild08,213,46,5 shop Shop#t_4_13 -1,909:-1
prt_fild08,214,46,5 shop Shop#t_4_14 -1,909:-1
prt_fild08,215,46,5 shop Shop#t_4_15 -1,909:-1
prt_fild08,216,46,5 shop Shop#t_4_16 -1,909:-1
prt_fild08,217,46,5 shop Shop#t_4_17 -1,909:-1
prt_fild08,218,46,5 shop Shop#t_4_18 -1,909:-1
prt_fild08,219,46,5 shop Shop#t_4_19 -1,909:-1
prt_fild08,220,46,5 shop Shop#t_4_20 -1,909:-1
prt_fild08,221,46,5 shop Shop#t_4_21 -1,909:-1
prt_fild08,222,46,5 shop Shop#t_4_22 -1,909:-1
prt_fild08,223,46,5 shop Shop#t_4_23 -1,909:-1
prt_fild08,224,46,5 shop Shop#t_4_24 -1,909:-1
prt_fild08,225,46,5 shop Shop#t_4_25 -1,909:-1
prt_fild08,226,46,5 shop Shop#t_4_26 -1,909:-1
prt_fild08,227,46,5 shop Shop#t_4_27 -1,909:-1
prt_fild08,228,46,5 shop Shop#t_4_28 -1,909:-1
prt_fild08,229,46,5 shop Shop#t_4_29 -1,909:-1
prt_fild08,230,46,5 shop Shop#t_4_30 -1,909:-1
prt_fild08,231,46,5 shop Shop#t_4_31 -1,909:-1
prt_fild08,232,46,5 shop Shop#t_4_32 -1,909:-1
prt_fild08,233,46,5 shop Shop#t_4_33 -1,909:-1
prt_fild08,234,46,5 shop Shop#t_4_34 -1,909:-1
prt_fild08,235,46,5 shop Shop#t_4_35 -1,909:-1
prt_fild08,236,46,5 shop Shop#t_4_36 -1,909:-1
prt_fild08,237,46,5 shop Shop#t_4_37 -1,909:-1
prt_fild08,238,46,5 shop Shop#t_4_38 -1,909:-1
prt_fild08,239,46,5 shop Shop#t_4_39 -1,909:-1
prt_fild08,240,46,5 shop Shop#t_4_40 -1,909:-1
prt_fild08,241,46,5 shop Shop#t_4_41 -1,909:-1
prt_fild08,242,46,5 shop Shop#t_4_42 -1,909:-1
prt_fild08,243,46,5 shop Shop#t_4_43 -1,909:-1
prt_fild08,244,46,5 shop Shop#t_4_44 -1,909:-1
prt_fild08,245,46,5 shop Shop#t_4_45 -1,909:-1
prt_fild08,246,46,5 shop Shop#t_4_46 -1,909:-1
prt_fild08,247,46,5 shop Shop#t_4_47 -1,909:-1
prt_fild08,248,46,5 shop Shop#t_4_48 -1,909:-1
prt_fild08,249,46,5 shop Shop#t_4_49 -1,909:-1
prt_fild08,240,46,5 shop Shop#t_4_50 -1,909:-1
prt_fild08,241,46,5 shop Shop#t_4_51 -1,909:-1
prt_fild08,242,46,5 shop Shop#t_4_52 -1,909:-1
prt_fild08,243,46,5 shop Shop#t_4_53 -1,909:-1
prt_fild08,244,46,5 shop Shop#t_4_54 -1,909:-1
prt_fild08,245,46,5 shop Shop#t_4_55 -1,909:-1
prt_fild08,246,46,5 shop Shop#t_4_56 -1,909:-1
prt_fild08,247,46,5 shop Shop#t_4_57 -1,909:-1
prt_fild08,248,46,5 shop Shop#t_4_58 -1,909:-1
prt_fild08,249,46,5 shop Shop#t_4_59 -1,909:-1
prt_fild08,201,48,5 shop Shop#t_5_1 -1,909:-1
prt_fild08,202,48,5 shop Shop#t_5_2 -1,909:-1
prt_fild08,203,48,5 shop Shop#t_5_3 -1,909:-1
prt_fild08,204,48,5 shop Shop#t_5_4 -1,909:-1
prt_fild08,205,48,5 shop Shop#t_5_5 -1,909:-1
prt_fild08,206,48,5 shop Shop#t_5_6 -1,909:-1
prt_fild08,207,48,5 shop Shop#t_5_7 -1,909:-1
prt_fild08,208,48,5 shop Shop#t_5_8 -1,909:-1
prt_fild08,209,48,5 shop Shop#t_5_9 -1,909:-1
prt_fild08,210,48,5 shop Shop#t_5_10 -1,909:-1
prt_fild08,211,48,5 shop Shop#t_5_11 -1,909:-1
prt_fild08,212,48,5 shop Shop#t_5_12 -1,909:-1
prt_fild08,213,48,5 shop Shop#t_5_13 -1,909:-1
prt_fild08,214,48,5 shop Shop#t_5_14 -1,909:-1
prt_fild08,215,48,5 shop Shop#t_5_15 -1,909:-1
prt_fild08,216,48,5 shop Shop#t_5_16 -1,909:-1
prt_fild08,217,48,5 shop Shop#t_5_17 -1,909:-1
prt_fild08,218,48,5 shop Shop#t_5_18 -1,909:-1
prt_fild08,219,48,5 shop Shop#t_5_19 -1,909:-1
prt_fild08,220,48,5 shop Shop#t_5_20 -1,909:-1
prt_fild08,221,48,5 shop Shop#t_5_21 -1,909:-1
prt_fild08,222,48,5 shop Shop#t_5_22 -1,909:-1
prt_fild08,223,48,5 shop Shop#t_5_23 -1,909:-1
prt_fild08,224,48,5 shop Shop#t_5_24 -1,909:-1
prt_fild08,225,48,5 shop Shop#t_5_25 -1,909:-1
prt_fild08,226,48,5 shop Shop#t_5_26 -1,909:-1
prt_fild08,227,48,5 shop Shop#t_5_27 -1,909:-1
prt_fild08,228,48,5 shop Shop#t_5_28 -1,909:-1
prt_fild08,229,48,5 shop Shop#t_5_29 -1,909:-1
prt_fild08,230,48,5 shop Shop#t_5_30 -1,909:-1
prt_fild08,231,48,5 shop Shop#t_5_31 -1,909:-1
prt_fild08,232,48,5 shop Shop#t_5_32 -1,909:-1
prt_fild08,233,48,5 shop Shop#t_5_33 -1,909:-1
prt_fild08,234,48,5 shop Shop#t_5_34 -1,909:-1
prt_fild08,235,48,5 shop Shop#t_5_35 -1,909:-1
prt_fild08,236,48,5 shop Shop#t_5_36 -1,909:-1
prt_fild08,237,48,5 shop Shop#t_5_37 -1,909:-1
prt_fild08,238,48,5 shop Shop#t_5_38 -1,909:-1
prt_fild08,239,48,5 shop Shop#t_5_39 -1,909:-1
prt_fild08,201,50,5 shop Shop#t_6_1 -1,909:-1
prt_fild08,202,50,5 shop Shop#t_6_2 -1,909:-1
prt_fild08,203,50,5 shop Shop#t_6_3 -1,909:-1
prt_fild08,204,50,5 shop Shop#t_6_4 -1,909:-1
prt_fild08,205,50,5 shop Shop#t_6_5 -1,909:-1
prt_fild08,206,50,5 shop Shop#t_6_6 -1,909:-1
prt_fild08,207,50,5 shop Shop#t_6_7 -1,909:-1
prt_fild08,208,50,5 shop Shop#t_6_8 -1,909:-1
prt_fild08,209,50,5 shop Shop#t_6_9 -1,909:-1
prt_fild08,210,50,5 shop Shop#t_6_10 -1,909:-1
prt_fild08,211,50,5 shop Shop#t_6_11 -1,909:-1
prt_fild08,212,50,5 shop Shop#t_6_12 -1,909:-1
prt_fild08,213,50,5 shop Shop#t_6_13 -1,909:-1
prt_fild08,214,50,5 shop Shop#t_6_14 -1,909:-1
prt_fild08,215,50,5 shop Shop#t_6_15 -1,909:-1
prt_fild08,216,50,5 shop Shop#t_6_16 -1,909:-1
prt_fild08,217,50,5 shop Shop#t_6_17 -1,909:-1
prt_fild08,218,50,5 shop Shop#t_6_18 -1,909:-1
prt_fild08,219,50,5 shop Shop#t_6_19 -1,909:-1
prt_fild08,220,50,5 shop Shop#t_6_20 -1,909:-1
prt_fild08,221,50,5 shop Shop#t_6_21 -1,909:-1
prt_fild08,222,50,5 shop Shop#t_6_22 -1,909:-1
prt_fild08,223,50,5 shop Shop#t_6_23 -1,909:-1
prt_fild08,224,50,5 shop Shop#t_6_24 -1,909:-1
prt_fild08,225,50,5 shop Shop#t_6_25 -1,909:-1
prt_fild08,226,50,5 shop Shop#t_6_26 -1,909:-1
prt_fild08,227,50,5 shop Shop#t_6_27 -1,909:-1
prt_fild08,228,50,5 shop Shop#t_6_28 -1,909:-1
prt_fild08,229,50,5 shop Shop#t_6_29 -1,909:-1
prt_fild08,201,52,5 shop Shop#t_7_1 -1,909:-1
prt_fild08,201,54,5 shop Shop#t_8_1 -1,909:-1
prt_fild08,201,56,5 shop Shop#t_10_1 -1,909:-1
prt_fild08,202,56,5 shop Shop#t_10_2 -1,909:-1
prt_fild08,201,58,5 shop Shop#t_11_1 -1,909:-1
prt_fild08,202,58,5 shop Shop#t_11_2 -1,909:-1
prt_fild08,203,58,5 shop Shop#t_11_3 -1,909:-1
prt_fild08,204,58,5 shop Shop#t_11_4 -1,909:-1
prt_fild08,201,60,5 shop Shop#t_12_1 -1,909:-1
prt_fild08,202,60,5 shop Shop#t_12_2 -1,909:-1
prt_fild08,203,60,5 shop Shop#t_12_3 -1,909:-1
prt_fild08,204,60,5 shop Shop#t_12_4 -1,909:-1
prt_fild08,205,60,5 shop Shop#t_12_5 -1,909:-1
prt_fild08,206,60,5 shop Shop#t_12_6 -1,909:-1
prt_fild08,207,60,5 shop Shop#t_12_7 -1,909:-1
prt_fild08,208,60,5 shop Shop#t_12_8 -1,909:-1
prt_fild08,209,60,5 shop Shop#t_12_9 -1,909:-1
prt_fild08,201,62,5 shop Shop#t_18_1 -1,909:-1
prt_fild08,202,62,5 shop Shop#t_18_2 -1,909:-1
prt_fild08,203,62,5 shop Shop#t_18_3 -1,909:-1
prt_fild08,204,62,5 shop Shop#t_18_4 -1,909:-1
prt_fild08,205,62,5 shop Shop#t_18_5 -1,909:-1
prt_fild08,206,62,5 shop Shop#t_18_6 -1,909:-1
prt_fild08,207,62,5 shop Shop#t_18_7 -1,909:-1
prt_fild08,208,62,5 shop Shop#t_18_8 -1,909:-1
prt_fild08,209,62,5 shop Shop#t_18_9 -1,909:-1
prt_fild08,210,62,5 shop Shop#t_18_10 -1,909:-1
prt_fild08,211,62,5 shop Shop#t_18_11 -1,909:-1
prt_fild08,212,62,5 shop Shop#t_18_12 -1,909:-1
prt_fild08,213,62,5 shop Shop#t_18_13 -1,909:-1
prt_fild08,214,62,5 shop Shop#t_18_14 -1,909:-1
prt_fild08,215,62,5 shop Shop#t_18_15 -1,909:-1
prt_fild08,216,62,5 shop Shop#t_18_16 -1,909:-1
prt_fild08,217,62,5 shop Shop#t_18_17 -1,909:-1
prt_fild08,218,62,5 shop Shop#t_18_18 -1,909:-1
prt_fild08,219,62,5 shop Shop#t_18_19 -1,909:-1
Comments
0 B
|👍
/👎