[fysiks]

Optimization:

PHP Code:

    if( szText[0] != '/' ) // To avoid the native call equali() since this will most case most often.
    {
        return PLUGIN_CONTINUE
    }
    
    if( equali( szText, "/calladmin", 10 ) )
    {
        if( szText[ 10 ] )
        {
            while( replace( szText[ 10 ], charsmax( szText ), "  ", " ") || equal( szText[ 10 ] ," " ) )
            {
                ColorChat( iPlayer, RED, "[%s]^x01 No reason defined!", Prefix )
                return PLUGIN_HANDLED
            }

            new Query[ 1001 ] 
            new s_date = get_systime( )
            format( Query, 1000, DB_CALL, szMid, s_date, server, name, szText[ 10 ], steamid )  
            SQL_ThreadQuery( SqlConnection, "QueryCreateTable", Query ) 
            return PLUGIN_HANDLED
        }
        else
        {
            ShowPlayers( iPlayer )
            return PLUGIN_HANDLED
        }
    } 


For some reason that while loop just doesn't look right. Does it actually work correctly?

[cFG]

Originally Posted by Vechta Maybe you can make for more Shoutbox system's?

And more community forums systems

[outsiderlv]

Updated the code.

[fysiks]

You need to remove color chat to make it able to work on all mods.

[outsiderlv]

Thanks for advice fysiks!
Updated.

[meTaLiCroSS]

I can't see that arabian-hosted image ._.

[TzK]

L 02/17/2011 - 176:50: [MySQL] Function not found: QueryCreateTable L 02/17/2011 - 176:50: [AMXX] Displaying debug trace (plugin "calladmin.amxx") L 02/17/2011 - 176:50: [AMXX] Run time error 10: native error (native "SQL_ThreadQuery") L 02/17/2011 - 176:50: [AMXX] [0] 82265.attach::CmdSay (line 115)

Trying to make this with my shoutbox, where table name is shoutbox_shouts, but it`s not working : /

[outsiderlv]

Accidently removed that thing while updating with cvars.
Btw, fixed. Try now.

[TzK]

Now there is no Error, but it not shown in shoutbox. I see my msg in database, but it`s not shown in shoutbox >_<.

mysql_mid = register_cvar( "ca_mysql_mid", "1" )

if this set to 1, shoudn`t s_mid in database be 1 not 0?
And in s_ip i got my steamid not ip :/
EDIT: Just saw, that after 20min it shown up that messages. It seems, like it show up, after some other write here in shoutbox.

[t3hNox]

In order to get this plugin to work with IPB3 shoutbox you will need to create a php file that will cache shouts when SQL query is executed from the plugin.
And to "run" it you will need to make a socket connection from the plugin to this specific php file.