How to execute a simple query in source

[fusqueta]

I'v beem working on pc.cpp and I want to store death log into db

when I try

            if (SQL_ERROR == Sql_Query(sql_handle, "Insert into death_log(char_id,killer_type,killer_id,map,time,lasthit) values(%d,'%s',%d,%d,'%s',%d)",150000,"BL_PC",150004,1,"20031020",1))
                Sql_ShowDebug(sql_handle);

Error    C2065    'sql_handle': identifier not defined    map-server    D:\rathena\src\map\pc.cpp    8498    
 

how setup db connection from pc.cpp ,skills.cpp ,stats.cpp etc and execute simple querys?   "Insert into 'test'(testint) values (1)"

Edited November 14, 2020 by fusqueta

[fusqueta]

I created a function on log.cpp that already have all mysql pre-configs needed

 

 

void log_death(int charid, int16 m, int16 killertype, int killerid, int lasthit)

{

StringBuf_Init(&buf);
    StringBuf_Printf(&buf, "%s INTO `%s` ( `map`, `time`)", LOG_QUERY, "death_log");

    StringBuf_Printf(&buf, "values ('%s',NOW() )", map_getmapdata(m)->name[0] ? map_getmapdata(m)->name : "");

    if (SQL_SUCCESS != SqlStmt_PrepareStr(stmt, StringBuf_Value(&buf)) || SQL_SUCCESS != SqlStmt_Execute(stmt))
        SqlStmt_ShowDebug(stmt);

}

 

Edited November 22, 2020 by fusqueta

[BeWan]

just use script

OnPCDieEvent:

sql query

end;

[fusqueta]

ty for the answer, unfortunately I need to query from source

Edited November 16, 2020 by fusqueta

[fusqueta]

UP