Hi, I want to make a plugin that will store data in a database I made using phpMyAdmin. I'm also using wamp.
I've been using this guide
https://wiki.alliedmods.net/Advanced...ng_(AMX_Mod_X).
PHP Code:
#include <amxmodx>
#include <dbi>
#include <amxx\amxmod_compat\mysql>
#include <esf>
#include <ipci\ascend>
#include <esf_util>
#include <fun>
#include <fakemeta>
#include <fakemeta_const>
#include <hamsandwich>
new Sql:databaseconnection
new err[255]
new errNum
public plugin_init()
{
register_plugin("Database Data","1.0","")
register_clcmd("say steamid","plugintriggertest");
RegisterHam(Ham_Killed, "player", "fwdPlayerDeath", 0);
databaseconnection= dbi_connect("127.0.0.1", "root", "", "esf_data")
if (databaseconnection < SQL_OK)
{
errNum = dbi_error(databaseconnection, err, 254)
server_print("error1: %s|%d", err, errNum)
}
}
new steamid[32]
new username[40]
new powerlevel
new charactername[32]
new characterid
public plugintriggertest(id)
{
client_print(id,print_chat,"error1: %s|%d", err, errNum)
get_user_name(id,username,40)
get_user_authid( id, steamid, 32)
powerlevel=getClientPL(id);
characterid=getClientCLASS(id);
getClassDATAv( characterid, cxName, charactername, 32 );
new Result:ret = dbi_query(databaseconnection,"INSERT INTO general_information (SteamID,Username,Character_1,Powerlevel_1) VALUES ('%s','%s','%s',%i);",steamid,username,charactername,powerlevel)
//new Result:ret = dbi_query(databaseconnection,"INSERT INTO general_information (SteamID,Username,Character_1,Powerlevel_1) VALUES ('%s','%s','%s',%i);",steamid,username,charactername,powerlevel)
//client_print(id,print_chat,"INSERT INTO general_information (SteamID,Username,Character_1,Powerlevel_1) VALUES ('%s','%s','%s',%i);",steamid,username,charactername,powerlevel)
if (ret < RESULT_NONE)
{
new err[255]
new errNum = dbi_error(databaseconnection, err, 254)
server_print("error2: %s|%d", err, errNum)
}
dbi_close(databaseconnection)
}
If I run the query through the mysql console it works, but when I try running it ingame I get this error:
PHP Code:
L 08/26/2019 - 21:06:26: [SQLITE] Invalid DBI handle 0
L 08/26/2019 - 21:06:26: [AMXX] Displaying debug trace (plugin "DBContent.amxx")
L 08/26/2019 - 21:06:26: [AMXX] Run time error 10: native error (native "dbi_query")
L 08/26/2019 - 21:06:26: [AMXX] [0] DBContentSQLX.sma::plugintriggertest (line 48)
I'm kinda new to amxx scripting so any help would be appreciated.