Mysql uiInsertID problem

[Dash 105]

Hi dev's i have some problems with mysql

 

    sprintf(szQuery,"insert into player.gift set item_count=%d, owner=%d",
    bItemCount,owner->GetPlayerID());
    std::auto_ptr<SQLMsg> pkMsg(DBManager::instance().DirectQuery(szQuery));
    SQLResult * pRes = pkMsg->Get(); 
    DWORD gift_id= pRes->uiInsertID;

 

gift_id is alaways 0 why?

[JachuPL 411]

that's some strange query. Tell us where did you get it 

Edited June 19, 2015 by JachuPL

[Dash 105]

Resolved , added id column with auto increment

Edited June 20, 2015 by Dash