Need Help : check the card items already installed in the equipment

[Akbare-2nd]

before, I say thank you for those who want to help make a script,
I want to check the card that has been installed on an equipment.
because this is an npc check so maybe it's better if he searches in the sql database like :

inventory

cart_inventory

guild_storage

Can someone make me a script for this?

STEP 1

Input: char name
input: item card id

STEP 2

result :

character name or account id
weapon name
card name
attached to :
card0:
card1:
card2:
card3:

example result :

character name: shinju [2000010]
weapon name: jur[3]
card name: andre card

card list :
card0 : andre card <---my target
card1 : mummy card
card2 : Santa Poring Card
card3 :

I use this script as a base

or maybe someone knows a query for this? because I don't really understand

thanks in advance

[Poring King]

I have this . Try this one i dont know if this will still work to latest rAthena . But the script is easy to understand so you can play with it

prontera,150,150,4	script	Item Inspector	123,{

        mes "Welcome to the Item Inspector!";
        mes "Enter the name of the player you want to inspect:";
        input .@playerName$;  // Get the player name input from the user
        
        // Check if the input is empty
        if (.@playerName$ == "") {
            dispbottom "You must enter a player name.";
            close;
        }

        // Get the target player's ID
        set .@target_charid, getcharid(0); // Get target player's ID
        
        // Check if player exists
        if (getcharid(0) != getcharid(0)) {
            dispbottom "Player not found or is offline.";
            close;
        }

        // Display player's inventory
        dispbottom "Inventory of " + .@playerName$ + ":";
        query_sql "SELECT `id`, `item_id`, `amount` FROM `inventory` WHERE `char_id` = " + .@target_charid, .@inv_id, .@inv_item_id, .@inv_amount;

        if (getarraysize(.@inv_id) > 0) {
            for (set .@i, 0; .@i < getarraysize(.@inv_id); set .@i, .@i + 1) {
                dispbottom "Item ID: " + .@inv_item_id[.@i] + ", Amount: " + .@inv_amount[.@i];
            }
        } else {
            dispbottom "No items found in inventory.";
        }

        // Display equipped items
        dispbottom "Equipped Items of " + .@playerName$ + ":";
        query_sql "SELECT `id`, `item_id`, `card1`, `card2`, `card3`, `card4` FROM `equipment` WHERE `char_id` = " + .@target_charid, .@equip_id, .@equip_item_id, .@equip_card1, .@equip_card2, .@equip_card3, .@equip_card4;

        if (getarraysize(.@equip_id) > 0) {
            for (set .@i, 0; .@i < getarraysize(.@equip_id); set .@i, .@i + 1) {
                dispbottom "Item ID: " + .@equip_item_id[.@i] + ", Card 1: " + .@equip_card1[.@i] + ", Card 2: " + .@equip_card2[.@i] + ", Card 3: " + .@equip_card3[.@i] + ", Card 4: " + .@equip_card4[.@i];
            }
        } else {
            dispbottom "No equipped items found.";
        }

        close;
}

 

[Akbare-2nd]

4 hours ago, Poring King said:

I have this . Try this one i dont know if this will still work to latest rAthena . But the script is easy to understand so you can play with it

prontera,150,150,4	script	Item Inspector	123,{

        mes "Welcome to the Item Inspector!";
        mes "Enter the name of the player you want to inspect:";
        input .@playerName$;  // Get the player name input from the user
        
        // Check if the input is empty
        if (.@playerName$ == "") {
            dispbottom "You must enter a player name.";
            close;
        }

        // Get the target player's ID
        set .@target_charid, getcharid(0); // Get target player's ID
        
        // Check if player exists
        if (getcharid(0) != getcharid(0)) {
            dispbottom "Player not found or is offline.";
            close;
        }

        // Display player's inventory
        dispbottom "Inventory of " + .@playerName$ + ":";
        query_sql "SELECT `id`, `item_id`, `amount` FROM `inventory` WHERE `char_id` = " + .@target_charid, .@inv_id, .@inv_item_id, .@inv_amount;

        if (getarraysize(.@inv_id) > 0) {
            for (set .@i, 0; .@i < getarraysize(.@inv_id); set .@i, .@i + 1) {
                dispbottom "Item ID: " + .@inv_item_id[.@i] + ", Amount: " + .@inv_amount[.@i];
            }
        } else {
            dispbottom "No items found in inventory.";
        }

        // Display equipped items
        dispbottom "Equipped Items of " + .@playerName$ + ":";
        query_sql "SELECT `id`, `item_id`, `card1`, `card2`, `card3`, `card4` FROM `equipment` WHERE `char_id` = " + .@target_charid, .@equip_id, .@equip_item_id, .@equip_card1, .@equip_card2, .@equip_card3, .@equip_card4;

        if (getarraysize(.@equip_id) > 0) {
            for (set .@i, 0; .@i < getarraysize(.@equip_id); set .@i, .@i + 1) {
                dispbottom "Item ID: " + .@equip_item_id[.@i] + ", Card 1: " + .@equip_card1[.@i] + ", Card 2: " + .@equip_card2[.@i] + ", Card 3: " + .@equip_card3[.@i] + ", Card 4: " + .@equip_card4[.@i];
            }
        } else {
            dispbottom "No equipped items found.";
        }

        close;
}

 

Thanks, it's a little open for me to make modifications and fit what I want

[Poring King]

Try this i improve it a little bit send a screen shot again . Because i dont have server to test it

 

prontera,150,150,4	script	Item Inspector	123,{

    // NPC Initialization
    OnInit:
        // No special initialization needed for this script
        end;

    // Main menu
    Menu:
        mes "Welcome to the Item Inspector!";
        mes "Enter the name of the player you want to inspect:";
        input .@playerName$;  // Get the player name input from the user
        
        // Check if the input is empty
        if (.@playerName$ == "") {
            dispbottom "You must enter a player name.";
            close;
        }

        // Get the target player's ID
        query_sql "SELECT `char_id` FROM `char` WHERE `name` = '"+.@playerName$+"'", .@target_charid;

        if (getarraysize(.@target_charid) == 0) {
            dispbottom "Player not found or is offline.";
            close;
        }

        // Display equipped items
        dispbottom "Equipped Items of " + .@playerName$ + ":";

        // Query to fetch equipped items by slot
        query_sql "SELECT `item_id`, `card1`, `card2`, `card3`, `card4`, `slot` FROM `equipment` WHERE `char_id` = " + .@target_charid[0], .@equip_item_id, .@equip_card1, .@equip_card2, .@equip_card3, .@equip_card4, .@equip_slot$;

        if (getarraysize(.@equip_item_id) > 0) {
            for (set .@i, 0; .@i < getarraysize(.@equip_item_id); set .@i, .@i + 1) {
                // Fetch item name from item_db
                query_sql "SELECT `name` FROM `item_db` WHERE `id` = " + .@equip_item_id[.@i], .@item_name$;
                set .@item_name$, .@item_name$[0];
                
                // Fetch card names for the equipped item
                setarray .@card_ids[0], .@equip_card1[.@i], .@equip_card2[.@i], .@equip_card3[.@i], .@equip_card4[.@i];
                set .@card_names$, "";

                for (set .@j, 0; .@j < getarraysize(.@card_ids); set .@j, .@j + 1) {
                    if (.@card_ids[.@j] > 0) {
                        query_sql "SELECT `name` FROM `card_db` WHERE `id` = " + .@card_ids[.@j], .@card_name$;
                        .@card_names$ += (getarraysize(.@card_name$) > 0 ? .@card_name$[0] : "Unknown") + " ";
                    } else {
                        .@card_names$ += "None ";
                    }
                }

                // Display item information based on slot type
                switch (.@equip_slot$[.@i]) {
                    case "head_top":
                        dispbottom "Top Headgear: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "head_mid":
                        dispbottom "Middle Headgear: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "head_low":
                        dispbottom "Lower Headgear: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "armor":
                        dispbottom "Armor: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "shield":
                        dispbottom "Shield: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "weapon":
                        dispbottom "Weapon: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "garment":
                        dispbottom "Garment: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "shoes":
                        dispbottom "Shoes: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "acc1":
                        dispbottom "Accessory 1: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "acc2":
                        dispbottom "Accessory 2: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                }
            }
        } else {
            dispbottom "No equipped items found.";
        }

        close;
}

 

[Akbare-2nd]

1 hour ago, Poring King said:

Try this i improve it a little bit send a screen shot again . Because i dont have server to test it

 

prontera,150,150,4	script	Item Inspector	123,{

    // NPC Initialization
    OnInit:
        // No special initialization needed for this script
        end;

    // Main menu
    Menu:
        mes "Welcome to the Item Inspector!";
        mes "Enter the name of the player you want to inspect:";
        input .@playerName$;  // Get the player name input from the user
        
        // Check if the input is empty
        if (.@playerName$ == "") {
            dispbottom "You must enter a player name.";
            close;
        }

        // Get the target player's ID
        query_sql "SELECT `char_id` FROM `char` WHERE `name` = '"+.@playerName$+"'", .@target_charid;

        if (getarraysize(.@target_charid) == 0) {
            dispbottom "Player not found or is offline.";
            close;
        }

        // Display equipped items
        dispbottom "Equipped Items of " + .@playerName$ + ":";

        // Query to fetch equipped items by slot
        query_sql "SELECT `item_id`, `card1`, `card2`, `card3`, `card4`, `slot` FROM `equipment` WHERE `char_id` = " + .@target_charid[0], .@equip_item_id, .@equip_card1, .@equip_card2, .@equip_card3, .@equip_card4, .@equip_slot$;

        if (getarraysize(.@equip_item_id) > 0) {
            for (set .@i, 0; .@i < getarraysize(.@equip_item_id); set .@i, .@i + 1) {
                // Fetch item name from item_db
                query_sql "SELECT `name` FROM `item_db` WHERE `id` = " + .@equip_item_id[.@i], .@item_name$;
                set .@item_name$, .@item_name$[0];
                
                // Fetch card names for the equipped item
                setarray .@card_ids[0], .@equip_card1[.@i], .@equip_card2[.@i], .@equip_card3[.@i], .@equip_card4[.@i];
                set .@card_names$, "";

                for (set .@j, 0; .@j < getarraysize(.@card_ids); set .@j, .@j + 1) {
                    if (.@card_ids[.@j] > 0) {
                        query_sql "SELECT `name` FROM `card_db` WHERE `id` = " + .@card_ids[.@j], .@card_name$;
                        .@card_names$ += (getarraysize(.@card_name$) > 0 ? .@card_name$[0] : "Unknown") + " ";
                    } else {
                        .@card_names$ += "None ";
                    }
                }

                // Display item information based on slot type
                switch (.@equip_slot$[.@i]) {
                    case "head_top":
                        dispbottom "Top Headgear: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "head_mid":
                        dispbottom "Middle Headgear: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "head_low":
                        dispbottom "Lower Headgear: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "armor":
                        dispbottom "Armor: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "shield":
                        dispbottom "Shield: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "weapon":
                        dispbottom "Weapon: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "garment":
                        dispbottom "Garment: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "shoes":
                        dispbottom "Shoes: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "acc1":
                        dispbottom "Accessory 1: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                    case "acc2":
                        dispbottom "Accessory 2: " + .@item_name$ + ", Cards: " + .@card_names$;
                        break;
                }
            }
        } else {
            dispbottom "No equipped items found.";
        }

        close;
}

 

i'm found this error and don't know how to fix it >_<

[Poring King]

prontera,150,150,4    script    Item Search    1234,{
    mes "[Item Search]";
    mes "Enter the name of the player you want to search:";
    input .@player_name$;
    
    if (!check_player_exists(.@player_name$)) {
        mes "Player not found.";
        close;
    }
    
    mes "Enter the name or ID of the item you are looking for:";
    input .@search_input$;
    
    // Initialize variables
    set .@item_id, 0;
    set .@item_amount, 0;
    set .@found_where$, "";
    set .@total_amount, 0;
    
    if (isnumber(.@search_input$)) {
        .@item_id = atoi(.@search_input$);
    } else {
        .@item_id = getitemid(.@search_input$);
    }
    
    // Search for the item and display results
    callfunc "search_item", .@player_name$, .@item_id;
    close;
}

// Function to check if a player exists
function check_player_exists {
    .@player_name$ = getcharid(0);
    .@player_id = query_sql("SELECT account_id FROM `char` WHERE `name` = '"+.@player_name$+"' LIMIT 1");
    if (.@player_id) {
        return true;
    }
    return false;
}

// Function to search for the item
function search_item {
    .@player_name$ = getcharid(0);
    .@item_id = getcharid(0);
    
    // Initialize variables
    set .@item_amount, 0;
    set .@found_where$, "";
    set .@total_amount, 0;
    
    // Check Inventory
    for (.@i = 0; .@i < MAX_INVENTORY; .@i++) {
        if (getinventoryitemid(.@i) == .@item_id) {
            .@item_amount = getinventoryitemamount(.@i);
            .@total_amount += .@item_amount;
            .@found_where$ = "Inventory";
        }
    }

    // Check Equipped Items
    for (.@i = 0; .@i < EQI_MAX; .@i++) {
        if (getequipid(.@i) == .@item_id) {
            .@item_amount = 1; // Equipped items are always one
            .@total_amount += .@item_amount;
            .@found_where$ = "Equipped";
        }
    }

    // Check Guild Storage
    if (getcharid(1)) { // Check if player is in a guild
        for (.@i = 0; .@i < MAX_GUILD_STORAGE; .@i++) {
            if (getguildstorageitemid(.@i) == .@item_id) {
                .@item_amount = getguildstorageitemamount(.@i);
                .@total_amount += .@item_amount;
                .@found_where$ = "Guild Storage";
            }
        }
    }

    // Check Personal Storage
    for (.@i = 0; .@i < MAX_STORAGE; .@i++) {
        if (getstorageitemid(.@i) == .@item_id) {
            .@item_amount = getstorageitemamount(.@i);
            .@total_amount += .@item_amount;
            .@found_where$ = "Personal Storage";
        }
    }

    if (.@total_amount > 0) {
        mes "Item found!";
        mes "Item Name: " + getitemname(.@item_id);
        mes "Total Amount: " + .@total_amount;
        mes "Location: " + .@found_where$;
        
        // Check if the item is a card
        if (getitemtype(.@item_id) == IT_CARD) { // Adjust this condition based on how you identify cards
            // Provide details on card compounding
            .@card_compound_info$ = get_card_compound_info(.@item_id);
            mes "This item is a card.";
            mes "Card Compounded: " + .@card_compound_info$;
            mes "Location where found: " + .@found_where$;
        }
    } else {
        mes "No items matched your search.";
    }
}

// Function to get card compounding information
function get_card_compound_info {
    .@item_id = getcharid(0);
    
    // Initialize variables
    set .@info$, "";
    
    // Query to get compounding information from database
    query_sql("SELECT compounded_item, compounding_location FROM card_compounding_info WHERE card_id = "+.@item_id+" LIMIT 1", .@info$, .@compounding_location$);
    
    // Check if we got any result
    if (.@info$ == "") {
        .@info$ = "No specific compounding info available.";
    } else {
        .@info$ = "Compounded into [" + .@info$ + "] at " + .@compounding_location$;
    }
    
    return .@info$;
}

Try this and i read your request seems like i send you a different one . This time i do what you need . Let me know if it is work . Not sure if i do right logical to getting info if the search item is card

Edited August 12, 2024 by Poring King

[Akbare-2nd]

On 8/12/2024 at 11:54 AM, Poring King said:

prontera,150,150,4    script    Item Search    1234,{
    mes "[Item Search]";
    mes "Enter the name of the player you want to search:";
    input .@player_name$;
    
    if (!check_player_exists(.@player_name$)) {
        mes "Player not found.";
        close;
    }
    
    mes "Enter the name or ID of the item you are looking for:";
    input .@search_input$;
    
    // Initialize variables
    set .@item_id, 0;
    set .@item_amount, 0;
    set .@found_where$, "";
    set .@total_amount, 0;
    
    if (isnumber(.@search_input$)) {
        .@item_id = atoi(.@search_input$);
    } else {
        .@item_id = getitemid(.@search_input$);
    }
    
    // Search for the item and display results
    callfunc "search_item", .@player_name$, .@item_id;
    close;
}

// Function to check if a player exists
function check_player_exists {
    .@player_name$ = getcharid(0);
    .@player_id = query_sql("SELECT account_id FROM `char` WHERE `name` = '"+.@player_name$+"' LIMIT 1");
    if (.@player_id) {
        return true;
    }
    return false;
}

// Function to search for the item
function search_item {
    .@player_name$ = getcharid(0);
    .@item_id = getcharid(0);
    
    // Initialize variables
    set .@item_amount, 0;
    set .@found_where$, "";
    set .@total_amount, 0;
    
    // Check Inventory
    for (.@i = 0; .@i < MAX_INVENTORY; .@i++) {
        if (getinventoryitemid(.@i) == .@item_id) {
            .@item_amount = getinventoryitemamount(.@i);
            .@total_amount += .@item_amount;
            .@found_where$ = "Inventory";
        }
    }

    // Check Equipped Items
    for (.@i = 0; .@i < EQI_MAX; .@i++) {
        if (getequipid(.@i) == .@item_id) {
            .@item_amount = 1; // Equipped items are always one
            .@total_amount += .@item_amount;
            .@found_where$ = "Equipped";
        }
    }

    // Check Guild Storage
    if (getcharid(1)) { // Check if player is in a guild
        for (.@i = 0; .@i < MAX_GUILD_STORAGE; .@i++) {
            if (getguildstorageitemid(.@i) == .@item_id) {
                .@item_amount = getguildstorageitemamount(.@i);
                .@total_amount += .@item_amount;
                .@found_where$ = "Guild Storage";
            }
        }
    }

    // Check Personal Storage
    for (.@i = 0; .@i < MAX_STORAGE; .@i++) {
        if (getstorageitemid(.@i) == .@item_id) {
            .@item_amount = getstorageitemamount(.@i);
            .@total_amount += .@item_amount;
            .@found_where$ = "Personal Storage";
        }
    }

    if (.@total_amount > 0) {
        mes "Item found!";
        mes "Item Name: " + getitemname(.@item_id);
        mes "Total Amount: " + .@total_amount;
        mes "Location: " + .@found_where$;
        
        // Check if the item is a card
        if (getitemtype(.@item_id) == IT_CARD) { // Adjust this condition based on how you identify cards
            // Provide details on card compounding
            .@card_compound_info$ = get_card_compound_info(.@item_id);
            mes "This item is a card.";
            mes "Card Compounded: " + .@card_compound_info$;
            mes "Location where found: " + .@found_where$;
        }
    } else {
        mes "No items matched your search.";
    }
}

// Function to get card compounding information
function get_card_compound_info {
    .@item_id = getcharid(0);
    
    // Initialize variables
    set .@info$, "";
    
    // Query to get compounding information from database
    query_sql("SELECT compounded_item, compounding_location FROM card_compounding_info WHERE card_id = "+.@item_id+" LIMIT 1", .@info$, .@compounding_location$);
    
    // Check if we got any result
    if (.@info$ == "") {
        .@info$ = "No specific compounding info available.";
    } else {
        .@info$ = "Compounded into [" + .@info$ + "] at " + .@compounding_location$;
    }
    
    return .@info$;
}

Try this and i read your request seems like i send you a different one . This time i do what you need . Let me know if it is work . Not sure if i do right logical to getting info if the search item is card

I found an error and don't understand how to fix it, maybe you can help thanks

script error on npc/npc/system/item_equip_check.c line 6
    parse_simpleexpr: unmatched ')'
     1 : {
     2 :     mes "[Item Search]";
     3 :     mes "Enter the name of the player you want to search:";
     4 :     input .@player_name$;
     5 :
*    6 :     if (!check_player_exists'('.@player_name$)) {
     7 :         mes "Player not found.";
     8 :         close;
     9 :     }

 

[EAJ_BASEMASK]

Some commands not related to rA i assumed it's custom_command.
isnumber();

some functions(); needs to be declared too

Edited August 16, 2024 by EAJ_BASEMASK