[C++] Read from Database

[Cian 0]

Hello Guys,

I want read a Vnum from Database... 

However it does not work.

My Source code :

Spoiler

long CItem::GetPetVnum()
{
    char Query[1024 + 1];
    snprintf(Query, sizeof(Query), "SELECT Petvnum FROM pet_summon WHERE PetSummonItemVnum='%d'", GetVnum());
    std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery(Query));
    MYSQL_ROW row = mysql_fetch_row(msg->Get()->pSQLResult);
    long alrow = atoi(row[0]);
    sys_log(0, "TEST_VNUM : %d\n", alrow);
    return alrow;
}

What is wrong?

Thanks for your help!

Sorry for my bad English ..

Edited August 20, 2022 by Metin2 Dev
Core X - External 2 Internal

[Fazer 699]

	 long CItem::GetPetVnum()
{
    char szQuery[1024];
    snprintf(szQuery, sizeof(szQuery), "SELECT Petvnum FROM pet_summon WHERE PetSummonItemVnum='%d'", GetVnum());
    std::auto_ptr<SQLMsg> msg(CDBManager::instance().DirectQuery(szQuery));
  MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult);
    long alrow = atoi(row[0]);
    sys_log(0, "TEST_VNUM : %d\n", alrow);
    return alrow;
}

try this

[hachiwari 136]

9 minutes ago, Fazer said:

try this

	 long CItem::GetPetVnum()
{
    char szQuery[1024 + 1];
    snprintf(szQuery, sizeof(szQuery), "SELECT Petvnum FROM pet_summon WHERE PetSummonItemVnum='%d'", GetVnum());
    std::auto_ptr<SQLMsg> msg(CDBManager::instance().DirectQuery(szQuery));
  MYSQL_ROW row = mysql_fetch_row(pMsg->Get()->pSQLResult);
    long alrow = atoi(row[0]);
    sys_log(0, "TEST_VNUM : %d\n", alrow);
    return alrow;
}

change name?XDDD

 

#topic

try this

long CItem::GetPetVnum()
{
    char szQuery[1024];
    snprintf(szQuery, sizeof(szQuery), "SELECT Petvnum FROM pet_summon WHERE PetSummonItemVnum = %u LIMIT 1", GetVnum());
    std::auto_ptr<SQLMsg> msg(DBManager::instance().DirectQuery(szQuery));

    if (msg->Get()->uiNumRows > 0)
    {
        MYSQL_ROW row = mysql_fetch_row(msg->Get()->pSQLResult);
        long alrow = atoi(row[0]);
        sys_log(0, "TEST_VNUM : %l\n", alrow);
        return alrow;
    }
    else
        return -1;
}

 

 

 

 

 

 

 

[Cian 0]

Thanks all for help !