R> Ranked Blacksmith shop

[Rizz]

Hi, I have a concept about a shop that can only be accessed by the top 10 Ranked Blacksmith. I would be grateful if someone would provide me the script or instruct me on how to make it. Thanks in advance.

[cook1e]

Try this one.
 

-	shop	fame_shop	-1,501:-1,502:-1,503:-1,504
prontera,156,168,5	script	fame shop	123,{
query_sql "SELECT `fame` FROM `char` WHERE `fame`>0", .@fame;
if (.@fame) {
callshop "fame_shop";
}else{
dispbottom "you don't have fame points.";
}
end;
}

 

Edited June 26, 2021 by cook1e

[Rizz]

On 6/25/2021 at 1:54 PM, cook1e said:

Try this one.
 

-	shop	fame_shop	-1,501:-1,502:-1,503:-1,504
prontera,156,168,5	script	fame shop	123,{
query_sql "SELECT `fame` FROM `char` WHERE `fame`>0 AND (`class`='10') ORDER BY `fame` DESC LIMIT 10", .@fame;
if (.@fame) {
callshop "fame_shop";
}else{
dispbottom "you don't have fame points.";
}
end;
}

Thanks for the response. I have tested it but the other class can access the shop 

 

 

[cook1e]

I have edited the post above, try
 

[Rizz]

Other class still can access the shop 

[cook1e]

18 hours ago, Rizz said:

Other class still can access the shop 

Only Blacksmith/Whitesmith can open this shop, working for me.

-	shop	fame_shop	-1,501:-1,502:-1,503:-1,504:-1
prontera,156,168,5	script	fame shop	123,{
query_sql "SELECT `fame` FROM `char` WHERE `fame`>0 AND (`class`='10' OR `class`='4011') ORDER BY `fame` DESC LIMIT 10", .@fame;
if (.@fame) {
callshop "fame_shop";
}else{
dispbottom "you don't have fame points.";
}
end;
}

 

Edited June 27, 2021 by cook1e

[Rizz]

On 6/28/2021 at 2:33 AM, cook1e said:

Only Blacksmith/Whitesmith can open this shop, working for me.

-	shop	fame_shop	-1,501:-1,502:-1,503:-1,504:-1
prontera,156,168,5	script	fame shop	123,{
query_sql "SELECT `fame` FROM `char` WHERE `fame`>0 AND (`class`='10' OR `class`='4011') ORDER BY `fame` DESC LIMIT 10", .@fame;
if (.@fame) {
callshop "fame_shop";
}else{
dispbottom "you don't have fame points.";
}
end;
}

 

I have tested it, but it does not work on me, other class can access the shop.
Thanks for helping.