Code:
// Creds: HRP for most of thingys :P
#include <dbi>
#include <engine>
new Sql:dbc
public plugin_init()
{
register_plugin("Sql","1.0","Rixorster")
register_cvar("mysql_host","localhost",FCVAR_PROTECTED)
register_cvar("mysql_db","database",FCVAR_PROTECTED)
register_cvar("mysql_user","root",FCVAR_PROTECTED)
register_cvar("mysql_pass","",FCVAR_PROTECTED)
public sql_init()
{
new host[64]
new username[33]
new password[32]
new dbname[32]
new error[32]
get_cvar_string("mysql_host",host,64)
get_cvar_string("mysql_user",username,32)
get_cvar_string("mysql_pass",password,32)
get_cvar_string("mysql_db",dbname,32)
database = dbi_connect(host,username,password,dbname,error,32)
if (dbc == SQL_FAILED)
{
server_print("You fail at life^n")
}
else
{
server_print("Gg!^n")
}
}