Quote:
Originally Posted by Natsheh
That guide is outdated use sqlx include file, for more info about sqlx natives you can search for it...
|
Thanks for the reply, I've tried rewriting it and still get the same error.
Code:
PHP Code:
#include <amxmodx>
#include <sqlx>
#include <amxx\amxmod_compat\mysql>
#include <esf>
#include <ipci\ascend>
#include <esf_util>
#include <fun>
#include <fakemeta>
#include <fakemeta_const>
#include <hamsandwich>
new Handle:g_SqlTuple
new g_Error[512]
new ErrorCode,Handle:SqlConnection
public plugin_init()
{
register_plugin("Database Data","1.0","")
register_clcmd("say steamid","plugintriggertest");
RegisterHam(Ham_Killed, "player", "fwdPlayerDeath", 0);
g_SqlTuple=SQL_MakeDbTuple("127.0.0.1","root","","esf_data")
SqlConnection= SQL_Connect(g_SqlTuple,ErrorCode,g_Error,511)
if(SqlConnection == Empty_Handle)
set_fail_state(g_Error)
}
new steamid[32]
new username[40]
new powerlevel
new charactername[32]
new characterid
public plugintriggertest(id)
{
get_user_name(id,username,40)
get_user_authid( id, steamid, 32)
powerlevel=getClientPL(id);
characterid=getClientCLASS(id);
getClassDATAv( characterid, cxName, charactername, 32 );
new Handle:Query=SQL_PrepareQuery(SqlConnection,"INSERT INTO general_information (SteamID,Username,Character_1,Powerlevel_1) VALUES ('%s','%s','%s',%i);",steamid,username,charactername,powerlevel)
if(!SQL_Execute(Query))
{
SQL_QueryError(Query,g_Error,511)
set_fail_state(g_Error)
}
SQL_FreeHandle(Query)
}
Error:
PHP Code:
L 08/26/2019 - 21:45:54: [SQLITE] Invalid database handle: 0
L 08/26/2019 - 21:45:54: [AMXX] Displaying debug trace (plugin "DBContent.amxx")
L 08/26/2019 - 21:45:54: [AMXX] Run time error 10: native error (native "SQL_PrepareQuery")
L 08/26/2019 - 21:45:54: [AMXX] [0] DBContentSQLX.sma::plugintriggertest (line 42)