[Potato Uno]

Use SQL_TQuery to execute a query and pass in a function that will get called once the query completes.

[derptestt]

I just copied what I thought looked useful from the kztimer sql.sp, and modified it. I apologize in advance if this is just a complete failed code. But would this at least create a table called Chat and insert the chat string into it?

PHP Code:

new String:sql_createChat[]
new String:sql_insertChat[]

public db_setupDatabase()
{
    decl String:szError[255];
    g_hDb = SQL_Connect("serverchat", false, szError, 255);
        
    if(g_hDb == INVALID_HANDLE)
    {
        SetFailState("[Server Chat] Unable to connect to database (%s)",szError);
        return;
    }
        
    decl String:szIdent[8];
    SQL_ReadDriver(g_hDb, szIdent, 8);
        
    if(strcmp(szIdent, "mysql", false) == 0)
    {
        g_DbType = MYSQL;
    }
    else 
        if(strcmp(szIdent, "sqlite", false) == 0)
            g_DbType = SQLITE;
        else
        {
            LogError("[Server Chat] Invalid Database-Type");
            return;
        }
        
    SQL_FastQuery(g_hDb,"SET NAMES  'utf8'");
    db_createTables();
}

public db_createTables()
{
    SQL_LockDatabase(g_hDb);     
    SQL_FastQuery(g_hDb, sql_createChat);
    SQL_UnlockDatabase(g_hDb);
}

public db_InsertChat(String:szChatText[4096])
{
    decl String:szQuery[512];       
    Format(szQuery, 512, sql_insertChat, szChatText); 
    SQL_TQuery(g_hDb, SQL_CheckCallback, szQuery,DBPrio_Low);
} 


[m_bNightstalker]

Init:

CREATE TABLE IF NOT EXISTS `xchat` (`id` int(11) NOT NULL AUTO_INCREMENT, `server` int(11) NOT NULL, `msg` varchar(2048) NOT NULL, PRIMARY KEY (`id`));

FormatEx(query, sizeof(query), "SELECT `id` FROM `xchat` WHERE `server` != %d;", g_iServerID);

while (SQL_FetchRow(hndl))
{
    new id  = SQL_FetchInt(hndl, 0);

    if(id > g_iLastID)
        g_iLastID = id;
}

Push chat message:

FormatEx(query, sizeof(query), "INSERT INTO `xchat` (msg, server) VALUES ('%s','%d');", sText, g_iServerID);

Read new chat messages:

FormatEx(query, sizeof(query), "SELECT `id`, `msg` FROM `xchat` WHERE `server` != %d AND `id` > '%d';", g_iServerID, g_iLastID);

while (SQL_FetchRow(hndl))
{
    id = SQL_FetchInt(hndl, 0);
    SQL_FetchString(hndl, 1, text, sizeof(text));

    if(id > g_iLastID)
    {
        g_iLastID = id;
        CPrintToChatAll(text);
    }
}

[derptestt]

m_bNightstalker: Can I add you on Steam to discuss this?

[m_bNightstalker]

Originally Posted by derptestt m_bNightstalker: Can I add you on Steam to discuss this?

I'm not your personal sourcepawn teacher, sry. Everyone who can code a bit can write this plugin with the given help.

[derptestt]

Originally Posted by m_bNightstalker I'm not your personal sourcepawn teacher, sry. Everyone who can code a bit can write this plugin with the given help.

It's cool, I'll just study the API and some basic programming logic for a few months and then come back to this. Thank you for the code though, my friend says it makes sense.

Btw I was going to offer you BitCoins.

[ecca]

Why not either write a php code that pushes message to all servers at once or use a middleman such as nodejs to read and push messages. You could also do with MySQL, but it all depend on preferences.

[derptestt]

I'm going to spew out some intense logic here. I wouldn't have posted in the REQUEST section of the forum, if I already knew how to do it. It goes on my understanding as I don't mess with PHP or SourcePawn on that level. I understand if people don't want to do it for me or share their code. If you know how though, and you just want a few bucks to do it, I'm willing. Thank you.

[shavit]

Originally Posted by derptestt I know this is a lot to ask, but do y'all know a plugin that utilizes SQL, so I can take a peek at how it works within SourcePawn? Right now I'm looking at the sql.sp included in the KZTimer mod, but it's a bit overwhelming. Thank you in advance.

I'm doing some SQL stuff here; https://github.com/Shavitush/bhoptim...ster/scripting

[friagram]

socket is way better. Your mysql server is going to get raped doing that many queries, moreso if you have lots of servers.