Add new function for Quests

[Dumik 7]

I want add new function for quests. But when i apply this function to quest nothing happens. Please can you help me?

int game_mysql_query(lua_State* L) 
{ 
  LPCHARACTER ch = CQuestManager::instance().GetCurrentCharacterPtr(); 
  SQLMsg *msg; 

  msg = DBManager::instance().DirectQuery(lua_tostring(L, 1)); 

  if (msg->uiSQLErrno != 0) 
  { 
    sys_err("game_mysql_query failed"); return 0; 
  } 
} 

{ "mysql_query", game_mysql_query }, 

Quest part: pc.give_item2(game.mysql_query("SELECT login FROM account.account WHERE id="..player_id.." ")) Thank you a lot

[Denis 1454]

You created a new .cpp file and add it there? or you add it to the existing ones?

[Dumik 7]

I used existing file questlua_game.cpp

[Denis 1454]

You are using a SELECT clause but the function is made to use INSERT,UPDATE clauses only

[Dumik 7]

It is there any possible how to add possible use SELECT clause?

[Domco 3]

Santhia comming soon kappa

[Denis 1454]

    int game_mysql_query(lua_State* L) {
        int i=0;
        //MYSQL_FIELD *field;
        //MYSQL_ROW row;
        char szQuery[1024];
        const char * query = lua_tostring(L, 1);
        unsigned long long int num = 0;
        snprintf(szQuery, sizeof(szQuery), "%s",query);
        
        SQLMsg * msg = DBManager::instance().DirectQuery(szQuery);
        if(msg) {
            std::auto_ptr<SQLMsg> pmsg(msg);
            lua_newtable(L);
            while(MYSQL_ROW row = mysql_fetch_row(pmsg->Get()->pSQLResult)) {
                while(MYSQL_FIELD * field = (MYSQL_FIELD*)mysql_fetch_field(pmsg->Get()->pSQLResult) ) {
                    lua_pushstring(L,field->name);
                    if (sscanf(row[i],"%llu", &num)) 
                        lua_pushnumber(L, num * 1.0);
                    else 
                        lua_pushstring(L,row[i]);
                    lua_rawset(L, -3);
                    i++;            
                }
            }
            return 1;
        } else {
            sys_err("MySQL Query failed!");
            lua_pushnumber(L,0);
        }
        return 0;
    } 

try this one

[Dumik 7]

I will try and Thank you a lot

[eTony 103]

I want add new function for quests. But when i apply this function to quest nothing happens. Please can you help me?

int game_mysql_query(lua_State* L) 
{ 
  LPCHARACTER ch = CQuestManager::instance().GetCurrentCharacterPtr(); 
  SQLMsg *msg; 

  msg = DBManager::instance().DirectQuery(lua_tostring(L, 1)); 

  if (msg->uiSQLErrno != 0) 
  { 
    sys_err("game_mysql_query failed"); return 0; 
  } 
} 

{ "mysql_query", game_mysql_query }, 

Quest part: pc.give_item2(game.mysql_query("SELECT login FROM account.account WHERE id="..player_id.." ")) Thank you a lot

Pan frajer už najednou tak moc nemachruje jo? Nezapomeň zase psát že s staráš jen o web a autopatcher Tak hlavně že neumíš ani použít funkci pc.give_item2 a píšeš weby :D 

//Sorry, i don't speak english :-) 

[TAUMP 796]

Neasi kokotík Dumik opět zabodoval :D