[PriceLess]

The error I get it underneath. The error line is the line SQL_TQuery on Mysql_Insert
Been strugling for an hour, so kinda rather ask.
Here is my script :

Spoiler

PHP Code:

#include <sourcemod>

new Handle:hDatabase = INVALID_HANDLE;

new String:info[3][50];

public OnPluginStart()
{
    SQL_TConnect(Mysql_Connect, "serverinfo")
    if(!SQL_CheckConfig("serverinfo"))
    {
        PrintToServer("Failed t connect");
    }
    GetConVarString(FindConVar("ip"), info[0], sizeof(info[]));
    GetConVarString(FindConVar("hostport"), info[1], sizeof(info[]));
    GetConVarString(FindConVar("hostname"), info[2], sizeof(info[]));
}

public Mysql_Connect(Handle:owner, Handle:hndl, const String:error[], any:data)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("Failed to query (%s)", error);
    }
    else
    {
        PrintToServer("Conneted");
        hDatabase = hndl;
        SQL_TQuery(hndl, Mysql_CreateTable, "CREATE TABLE IF NOT EXISTS servers (id INTEGER PRIMARY KEY AUTO_INCREMENT, ip VARCHAR(24), port VARCHAR(9), name VARCHAR(32)");
    }
}

public Mysql_CreateTable(Handle:owner, Handle:hndl, const String:error[], any:data)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("Failed to create database %s", error);
        return;
    }
}

public OnConfigsExecuted()
{
    decl String:Query[200];
    Format(Query, sizeof(Query), "INSERT INTO servers (ip, port, name) VALUES ('%s', '%s', '%s')", info[1], info[2], info[0]);
    SQL_TQuery(hDatabase, Mysql_Insert, Query);
}

public Mysql_Insert(Handle:owner, Handle:hndl, const String:error[], any:data)
{
    if(hndl == INVALID_HANDLE)
    {
        LogError("Failed to query (%s)", error);
        return;
    }
} 


The error :

Spoiler

L 03/03/2013 - 060:59: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 03/03/2013 - 060:59: [SM] Displaying call stack trace for plugin "servername.smx":
L 03/03/2013 - 060:59: [SM] [0] Line 46, C:\Users\Pepsi\Desktop\servername.sp::OnConfi gsExecuted()
L 03/03/2013 - 060:59: [servername.smx] Failed to create database You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[Dr. McKay]

You missed a closing parenthesis:

PHP Code:

SQL_TQuery(hndl, Mysql_CreateTable, "CREATE TABLE IF NOT EXISTS servers (id INTEGER PRIMARY KEY AUTO_INCREMENT, ip VARCHAR(24), port VARCHAR(9), name VARCHAR(32))"); 


[PriceLess]

now im getting this error.. dunno whats wrong now.

PHP Code:

L 03/03/2013 - 09:12:54: Info (map "de_dust2") (file "errors_20130303.log")
L 03/03/2013 - 09:12:54: [SM] Native "SQL_TQuery" reported: Invalid database Handle 0 (error: 4)
L 03/03/2013 - 09:12:54: [SM] Displaying call stack trace for plugin "servere.smx":
L 03/03/2013 - 09:12:54: [SM]   [0]  Line 46, C:\Users\Pepsi\Desktop\servere.sp::OnConfigsExecuted() 


[Dr. McKay]

You're going to need to delay your query until the database is actually connected.

[PriceLess]

Ok, like a timer or something?


*edit* fixed. thanks alot!