I have my sample npc script below with SQL query. In database, it has multiple rows of result.
can you please show me how can i make the dispbottom to reflect the first 3 rows of result?
izlude,117,110,6 script sample 952,{
input .@item_id;
query_sql("SELECT char_id, nameid, amount FROM `inventory` HAVING nameid = "+.@item_id+" ORDER BY amount DESC",.@charid,.@nameid,.@amnt);
dispbottom .@charid+" : "+getitemname(.@nameid)+" "+.@amnt+"pcs";
end;}
Question
gleynn
Hi,
I have my sample npc script below with SQL query. In database, it has multiple rows of result.
can you please show me how can i make the dispbottom to reflect the first 3 rows of result?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.