Pasted

// https://rathena.org/board/topic/118854-npc-item-with-control-request/
 
prontera,155,181,5  script  Sample  4_F_KAFRA1,{
    .@item_id = 512;
    
    if (callsub(L_HasItem, .@item_id)) {
        npctalk "you already obtained "+getitemname(.@item_id);
    }
    else {
        getitem .@item_id,1;
        npctalk "you obtained "+getitemname(.@item_id);
    }
    end;
 
 
    L_HasItem:
        .@item_id = getarg(0, 0);
        .@cid = getcharid(0);
        .@aid = getcharid(3);
        .@gid = getcharid(2);
        
        if (.@item_id) {
            query_sql("SELECT COUNT(1) FROM `inventory` WHERE `nameid` = "+.@item_id+" AND `char_id` IN (SELECT `char_id` FROM `char` WHERE `account_id` = "+.@aid+")", .@inventory);
            query_sql("SELECT COUNT(1) FROM `cart_inventory` WHERE `nameid` = "+.@item_id+" AND `char_id` IN (SELECT `char_id` FROM `char` WHERE `account_id` = "+.@aid+")", .@cart_inventory);
            
            if (.@gid)
                query_sql("SELECT COUNT(1) FROM `guild_storage` WHERE `nameid` = "+.@item_id+" AND `guild_id` = "+.@gid+")", .@guild_storage);
 
        
            .@count += .@inventory;
            .@count += .@cart_inventory;
            .@count += .@guild_storage;
            
            .@count += countitem(.@item_id);
            .@count += cartcountitem(.@item_id);
            .@count += storagecountitem(.@item_id);
            if (.@gid)
                .@count += guildstoragecountitem(.@item_id);
        }
        return (.@count > 0);
}