Heya
This appears to work, but does any1 know any way to make it better?
its a bit sloppy atm and i wanna clean it up
PHP Code:
bool:SQL_TableExists(szTable[])
{
new Handle:SqlConnection = SQL_Connect(gSqlTuple, ErrorCode, gError, 511);
if(SqlConnection == Empty_Handle)
{
set_fail_state(gError);
}
new Handle:Query;
new iOutput;
Query = SQL_PrepareQuery(SqlConnection, "SELECT * from `%s`", szTable);
if(!SQL_Execute(Query))
{
SQL_QueryError(Query, gError, 511);
if(containi(gError, "#1146") != -1)
{
iOutput = 0;
}
else if(containi(gError, "No result set in this query!") != -1)
{
iOutput = 0;
}
}
else
{
iOutput = 1;
}
SQL_FreeHandle(Query);
SQL_FreeHandle(SqlConnection);
return iOutput == 1 ? true:false;
}
__________________