Now it shows no errors! some time when map is loaded it shows no message,
or when new map is and i type /showsms it shows and 5 minutes is passed it dosent show message!
when server starts it gives error that cant connect to db! map changed no db connect error.
Tables
Code:
CREATE TABLE `sms_chat`(
`Sender` varchar(12) NOT NULL,
`Message` varchar(255) NOT NULL,
`Time` varchar(255) NOT NULL
)
.sma
Code:
#include <amxmodx>
#include <amxmisc>
#include <sqlx>
#include <fun>
////////////////////////////////////////////////////////////////////////////////////////////////////
#define PLUGIN "SMS Show"
#define VERSION "0.1"
#define AUTHOR "author"
////////////////////////////////////////////////////////////////////////////////////////////////////
new Host[64],User[64],Pass[64],Db[64]
new error[256], errorcode
new Handle:sql_makedbtuple
new Handle:sql_connect
////////////////////////////////////////////////////////////////////////////////////////////////////
public plugin_init() {
register_plugin(PLUGIN, VERSION, AUTHOR)
register_clcmd("say /sms", "Show_Sms_Motd");
register_clcmd("say /showsms", "func_get_sms");
register_clcmd("say_team /sms", "Show_Sms_Motd");
register_cvar("amx_sql_host", "host")
register_cvar("amx_sql_user", "user")
register_cvar("amx_sql_pass", "pass")
register_cvar("amx_sql_db", "db")
get_cvar_string("amx_sql_host",Host,63)
get_cvar_string("amx_sql_user",User,63)
get_cvar_string("amx_sql_pass",Pass,63)
get_cvar_string("amx_sql_db",Db,63)
sql_makedbtuple = SQL_MakeDbTuple(Host,User,Pass,Db)
sql_connect = SQL_Connect(sql_makedbtuple, errorcode, error, 255)
if (!sql_connect)
{
log_amx("Error (%d): %s", errorcode, error)
console_print(0,"Error (%d): %s", errorcode, error)
set_fail_state("Can't connect to DB!")
return PLUGIN_HANDLED
}
set_task(300.0, "func_get_sms", 0, "", 0, "b")
return PLUGIN_HANDLED
}
////////////////////////////////////////////////////////////////////////////////////////////////////
public Show_Sms_Motd(id)
{
show_motd(id, "sms.txt")
}
////////////////////////////////////////////////////////////////////////////////////////////////////
public func_get_sms()
{
new Handle:query = SQL_PrepareQuery(sql_connect, "SELECT `Time`, `Message` FROM `sms_chat` ORDER BY `Time` DESC")
if( SQL_Execute(query) )
{
if( SQL_MoreResults(query) )
{
new resultado[2][192]
SQL_ReadResult(query, 0, resultado[0], 191)
SQL_ReadResult(query, 1, resultado[1], 191)
client_print(0, print_chat, "LAST SMS: on %s, with text %s", resultado[0], resultado[1])
}
SQL_FreeHandle(query)
}
}
////////////////////////////////////////////////////////////////////////////////////////////////////