How to Check the Inventory and Storage of the Player

[nikki1200]

Hi All,

 

Seeking for your assistance on how to check the inventory and storage of the player.

 

Please advise,

 

Thanks,

 

[Capuche]

how to check the inventory

getinventorylist or countitem

 

storage of the player.

by sql

 

You want to search a specific item or to see all the item of the player?

[nikki1200]

how in sql??

[Patskie]

Try :

prontera,150,150,0    script    Sample    100,{
    mes "Input player";
    input .@player$;
    next;
    mes .@player$+ " have the following items on his storage :";
    .account_id = getcharid(3, .@player$);
    query_sql "SELECT COUNT(`nameid`) FROM `storage` WHERE `account_id` = '" +.account_id+ "'",.@total;
    while ( .@count < .@total ) {
        query_sql "SELECT `nameid` FROM `storage` WHERE `account_id` = '" +.account_id+ "' LIMIT 128 OFFSET "+.@offset,.@list;
        .@i = 0;
        .@size = getarraysize( .@list );
        while ( .@i < .@size ) {
            mes "- " +getitemname(.@list[.@i]);
            .@count++;
            .@i++;
        }
        .@offset += .@size;
        deletearray .@list, .@size;
    }
    close;
}