[kramesa]

Hi all, I trying to make this plugin:

#include <amxmodx>
#include <amxmisc>
#include <sqlx>

enum _:ServerTypes
{
    _Server_IP,
    _Server_Players,
    _Server_Data
};

new ServerData[ServerTypes];
new Handle:SQLTuple;

public plugin_init() {
    register_clcmd("say /need", "Need");
    
    PrepareDatabase();
}

PrepareDatabase()
{
    SQLTuple = SQL_MakeStdTuple();
    
    new Query[512];
    formatex(Query, 
    charsmax(Query), 
    "CREATE TABLE IF NOT EXISTS need (serverip VARCHAR(32), players INT(10), data VARCHAR(32)");
    
    SQL_ThreadQuery(SQLTuple, "QueryDefaultHandle", Query);
}

SaveData()
{
    new Query[512];
    
    formatex(Query, charsmax(Query), 
    "REPLACE INTO need (serverip, players, data) VALUES ('%s', %i, '%s')",
    ServerData[_Server_IP],
    ServerData[_Server_Players],
    ServerData[_Server_Data]
    );
    
    SQL_ThreadQuery(SQLTuple, "QueryDefaultHandle", Query);
}

public QueryDefaultHandle(FailState, Handle:Query, Error[], ErrorCode, Data[], DataSize, Float:QueueTime)
{
    switch(FailState)
    {
        case TQUERY_CONNECT_FAILED:
        {
            set_fail_state("SQL: Connection failed.");
        }
        case TQUERY_QUERY_FAILED:
        {
            log_amx("SQL: Query failed. Error: %s (%i)", Error, ErrorCode);
        }
    }
}

public Need(id)
{
    new PlayersNum, MinPlayers;
    PlayersNum = get_playersnum();
    MinPlayers = 12;
    
    if(PlayersNum < MinPlayers) {
        new ServerIP[60], Date[9], PlayersNeed;
        get_user_ip(0, ServerIP, sizeof(ServerIP) - 1)
        PlayersNeed = (MinPlayers - PlayersNum);
        get_time("%d/%m/%Y - %H:%M:%S", Date, 8);
        
        ServerData[_Server_IP] = ServerIP;
        ServerData[_Server_Players] = PlayersNeed;
        ServerData[_Server_Data] = Date;
        SaveData();
    }
}

But, I have error on this lines:

ServerData[_Server_IP] = ServerIP;

And:

ServerData[_Server_Data] = Date;

[code]error 006: must be assigned to an array[/quote]

Anyone help-me to fix this plugin?

Thanks

[YamiKaitou]

You are trying to copy an variable that is an array into a variable that is not an array.

[kramesa]

Originally Posted by YamiKaitou You are trying to copy an variable that is an array into a variable that is not an array.

Ok and how I fix this?

[YamiKaitou]

Use copy to copy it to another array.

Example

PHP Code:

new ServerData[ServerTypes][23];
....
        new ServerIP[23], Date[23], PlayersNeed;
        get_user_ip(0, ServerIP, sizeof(ServerIP) - 1)
        PlayersNeed = (MinPlayers - PlayersNum);
        get_time("%d/%m/%Y - %H:%M:%S", Date, charsmax(Date));
        
        copy(ServerData[_Server_IP], charsmax(ServerData[_Server_IP]), ServerIP);
        ServerData[_Server_Players][0] = PlayersNeed;
        copy(ServerData[_Server_Data], charsmax(ServerData[_Server_Data]), Date); 


[kramesa]

Ok, i will try, ty.

[kramesa]

Well, the plugin don't works

[YamiKaitou]

Did you update the rest of the plugin? I'm not going to correct your entire plugin for you, this is "Scripting Help" after all.

[kramesa]

Originally Posted by YamiKaitou Did you update the rest of the plugin? I'm not going to correct your entire plugin for you, this is "Scripting Help" after all.

Well, can anyone fix the part of MySQL?

[YamiKaitou]

Show us your current code after the changes. Also describe the "don't works" part.

[kramesa]

The code is the same, only with your part modified.