[SAMMELTHREAD] Kleine Scripting Fragen

Herolot · 26. Mai 2020

hey, ich habe das problem das die kicks in mysql nicht abgespeichert werden. mein code sieht wie gefolgt aus:

Code

        new ip[32];
        GetPlayerIp(pID,ip,sizeof(ip));

        new query[512];
        mysql_format(mysql, query, sizeof(query), "INSERT INTO `log_kicks` (`name`, `kickedby`, `reason`, `timestamp`, `ip`) 
VALUES ('%i', '%i', '%e', '%i', '%e')", GetPVarInt(pID, "accountid"), GetPVarInt(playerid, "accountid"),  reason, gettime(), ip);
        mysql_tquery(mysql, query);

Code

CREATE TABLE `log_kicks` (
  `id` int(11) NOT NULL,
  `name` int(11) NOT NULL,
  `kickedby` int(11) NOT NULL,
  `reason` text NOT NULL,
  `timestamp` int(11) NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ich bekomme keine errors/warnings.

Maho · 26. Mai 2020

Zitat von Herolot

hey, ich habe das problem das die kicks in mysql nicht abgespeichert werden. mein code sieht wie gefolgt aus:

Code

        new ip[32];
        GetPlayerIp(pID,ip,sizeof(ip));

        new query[512];
        mysql_format(mysql, query, sizeof(query), "INSERT INTO `log_kicks` (`name`, `kickedby`, `reason`, `timestamp`, `ip`) 
VALUES ('%i', '%i', '%e', '%i', '%e')", GetPVarInt(pID, "accountid"), GetPVarInt(playerid, "accountid"),  reason, gettime(), ip);
        mysql_tquery(mysql, query);

Code

CREATE TABLE `log_kicks` (
  `id` int(11) NOT NULL,
  `name` int(11) NOT NULL,
  `kickedby` int(11) NOT NULL,
  `reason` text NOT NULL,
  `timestamp` int(11) NOT NULL,
  `ip` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

ich bekomme keine errors/warnings.

Was sagt die MySQL log?

Herolot · 26. Mai 2020

Zitat von iTsMaho

Was sagt die MySQL log?

[16:21:48] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'datenbank.log_kicks' doesn't exist

existieren tut sie

Canna · 26. Mai 2020

Nein, eben nicht. Achte auf Rechtschreibfehler. Wenn diese existieren würde, würde die Fehlermeldung anders aussehen.

Herolot · 26. Mai 2020

Zitat von Canna

Nein, eben nicht. Achte auf Rechtschreibfehler. Wenn diese existieren würde, würde die Fehlermeldung anders aussehen.

pasted-from-clipboard.png

"INSERT INTO `log_kicks` (`name`, `kickedby`, `reason`, `timestamp`, `ip`)

Whice · 26. Mai 2020

Heißt denn die Datenbank in der sich 'log_kicks' befindet auch 'datenbank' wie in der MySQL Log angegeben oder hast du vielleicht eine andere Datenbank im Script ausgewählt?

Maho · 26. Mai 2020

Zitat von Herolot

pasted-from-clipboard.png

"INSERT INTO `log_kicks` (`name`, `kickedby`, `reason`, `timestamp`, `ip`)

Existiert sie auch in der Datenbank: Datenbank

Herolot · 26. Mai 2020

Zitat von Whice.

Heißt denn die Datenbank in der sich 'log_kicks' befindet auch 'datenbank' wie in der MySQL Log angegeben oder hast du vielleicht eine andere Datenbank im Script ausgewählt?

Zitat von iTsMaho

Existiert sie auch in der Datenbank: Datenbank

Danke euch allen, das war der Fehler. Werde nächstes mal genauer hinschauen.

Loui V · 27. Mai 2020

Kann mir mal jemand helfen ich habe ein Script zum laufen gebracht jedoch geht die SAMP Server.exe nicht auf und bei denn Serverlogs steht auch kein fehler drin?

Kaliber · 27. Mai 2020

Zitat von Loui V

steht auch kein fehler drin?

Und du bist sicher, dass du crashdetect geladen hast?

Wie sieht denn der log aus?

quitX · 27. Mai 2020

Guten Abend,

hab gerade mal den Compiler "geupdatet" und dazu die Includes, jetzt bekomme ich bei der kleinsten Sache schon Warnings die ich nicht behoben bekomme ...

» Compiler: https://github.com/pawn-lang/compiler/releases

» Includes: https://github.com/pawn-lang/samp-stdlib

Code

new strQuery[80];
mysql_format(DBHandle, strQuery, sizeof(strQuery), "SELECT * FROM `srv_accounts` WHERE `Name` = '%e' LIMIT 1", PlayerInfo[playerid][pName]); // <- 76
mysql_pquery(DBHandle, strQuery, "OnAccountCheck", "d", playerid); // <- 77

(76) : warning 239: literal array/string passed to a non-const parameter
(77) : warning 239: literal array/string passed to a non-const parameter
(77) : warning 239: literal array/string passed to a non-const parameter

Kaliber · 27. Mai 2020

Kannst du uns deine a_mysql.inc zeigen?

quitX · 27. Mai 2020

Klar, ist zwar die Originale R39-6, aber hier, gerne.

Code

/**
 * MySQL plugin R39-6
 */


#if defined mysql_included
    #endinput
#endif
#define mysql_included


/**
 * Common error codes
 *
 * Client: http://dev.mysql.com/doc/refman/5.1/en/error-messages-client.html
 * Server: http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html
 */

#define ER_DBACCESS_DENIED_ERROR         1044
#define ER_ACCESS_DENIED_ERROR             1045
#define ER_UNKNOWN_TABLE                 1109
#define ER_SYNTAX_ERROR                 1149
#define CR_SERVER_GONE_ERROR             2006
#define CR_SERVER_LOST                     2013
#define CR_COMMAND_OUT_OF_SYNC             2014
#define CR_SERVER_LOST_EXTENDED         2055


enum E_MYSQL_LOGLEVEL
{
    LOG_NONE = 0,
    LOG_ERROR = 1,
    LOG_WARNING = 2,
    LOG_DEBUG = 4,
    
    LOG_ALL = LOG_ERROR | LOG_WARNING | LOG_DEBUG
};

enum E_MYSQL_LOGTYPE
{
    LOG_TYPE_TEXT = 1,
    LOG_TYPE_HTML = 2
};

enum ORM_Error
{
    ERROR_OK,
    ERROR_NO_DATA
};

enum E_MYSQL_OPTION
{
    DUPLICATE_CONNECTIONS,
    LOG_TRUNCATE_DATA
};

enum E_EXECTIME_UNIT
{
    UNIT_MILLISECONDS,
    UNIT_MICROSECONDS
};


#define mysql_real_escape_string                     mysql_escape_string
#define cache_num_fields                             cache_get_field_count
#define cache_num_rows                                 cache_get_row_count
#define mysql_function_query(%0,%1,%2,%3,"%4"%5)     mysql_tquery(%0,%1,%3,#%4%5)
#define mysql_reload(%0)                             mysql_tquery(%0,"FLUSH PRIVILEGES")
#define mysql_debug(%0)                                (%0?mysql_log(LOG_ALL):mysql_log())
#define ismysqlnull(%0)                             (strcmp(%0,"NULL",false)==0)


// ORM functions
native ORM:orm_create(const table[], connectionHandle = 1);
native orm_destroy(ORM:id);

native ORM_Error:orm_errno(ORM:id);

native orm_apply_cache(ORM:id, row);
native orm_select(ORM:id, callback[] = "", format[] = "", {Float, _}:...);
/*
native orm_select_inline(ORM:id, callback:Callback, format[], {Float,_}:...); //y_inline
*/
native orm_update(ORM:id);
native orm_insert(ORM:id, callback[] = "", format[] = "", {Float, _}:...);
/*
native orm_insert_inline(ORM:id, callback:Callback, format[], {Float,_}:...); //y_inline
*/
native orm_delete(ORM:id, bool:clearvars=true);

native orm_load(ORM:id, callback[] = "", format[] = "", {Float, _}:...) = orm_select;
native orm_save(ORM:id, callback[] = "", format[] = "", {Float, _}:...);

native orm_addvar_int(ORM:id, &var, varname[]);
native orm_addvar_float(ORM:id, &Float:var, varname[]);
native orm_addvar_string(ORM:id, var[], var_maxlen, varname[]);

native orm_delvar(ORM:id, varname[]);
native orm_setkey(ORM:id, varname[]);


// MySQL functions
native mysql_log(E_MYSQL_LOGLEVEL:loglevel = LOG_ERROR | LOG_WARNING, E_MYSQL_LOGTYPE:logtype = LOG_TYPE_TEXT);
native mysql_connect(const host[], const user[], const database[], const password[], port = 3306, bool:autoreconnect = true, pool_size = 2);
native mysql_close(connectionHandle = 1);
native mysql_reconnect(connectionHandle = 1);

native mysql_unprocessed_queries(connectionHandle = 1);
native mysql_current_handle();
native mysql_option(E_MYSQL_OPTION:type, value);

native mysql_errno(connectionHandle = 1);
native mysql_escape_string(const source[], destination[], connectionHandle = 1, max_len = sizeof(destination));
native mysql_format(connectionHandle, output[], len, format[], {Float,_}:...);
native mysql_pquery(connectionHandle, query[], callback[] = "", format[] = "", {Float,_}:...);
/*
native mysql_pquery_inline(connHandle, query[], callback:Callback, format[], {Float,_}:...); //y_inline
*/
native mysql_tquery(connectionHandle, query[], callback[] = "", format[] = "", {Float,_}:...);
/*
native mysql_tquery_inline(connHandle, query[], callback:Callback, format[], {Float,_}:...); //y_inline
*/
native Cache:mysql_query(conhandle, query[], bool:use_cache = true);

native mysql_stat(destination[], connectionHandle = 1, max_len = sizeof(destination));
native mysql_get_charset(destination[], connectionHandle = 1, max_len = sizeof(destination));
native mysql_set_charset(charset[], connectionHandle = 1);


// Cache functions
native cache_get_data(&num_rows, &num_fields, connectionHandle = 1);
native cache_get_row_count(connectionHandle = 1);
native cache_get_field_count(connectionHandle = 1);
native cache_get_field_name(field_index, destination[], connectionHandle = 1, max_len = sizeof(destination));

native cache_get_row(row, field_idx, destination[], connectionHandle = 1, max_len = sizeof(destination));
native cache_get_row_int(row, field_idx, connectionHandle = 1);
native Float:cache_get_row_float(row, field_idx, connectionHandle = 1);

native cache_get_field_content(row, const field_name[], destination[], connectionHandle = 1, max_len = sizeof(destination));
native cache_get_field_content_int(row, const field_name[], connectionHandle = 1);
native Float:cache_get_field_content_float(row, const field_name[], connectionHandle = 1);

native Cache:cache_save(connectionHandle = 1);
native cache_delete(Cache:cache_id, connectionHandle = 1);
native cache_set_active(Cache:cache_id, connectionHandle = 1);
native cache_is_valid(Cache:cache_id, connectionHandle = 1);

native cache_affected_rows(connectionHandle = 1);
native cache_insert_id(connectionHandle = 1);
native cache_warning_count(connectionHandle = 1);

native cache_get_query_exec_time(E_EXECTIME_UNIT:unit = UNIT_MICROSECONDS);
native cache_get_query_string(destination[], max_len = sizeof(destination));


// Forward declarations
forward OnQueryError(errorid, error[], callback[], query[], connectionHandle);


#if defined MYSQL_USE_YINLINE || defined E_CALLBACK_DATA
    #if !defined E_CALLBACK_DATA
        #include <YSI\y_inline>
    #endif
    
    static g_MySQL_InlineData[1000][E_CALLBACK_DATA];
    static g_MySQL_VarArray[32][YSI_MAX_STRING];
    static g_MySQL_AddressArray[32];

    stock MySQL_Internal_SaveInline(callback:CB) 
    {
        static bool:g_MySQL_LazyInit = true;
        if(g_MySQL_LazyInit == true) 
        {
            //set g_MySQL_InlineData empty
            for(new i=0; i < sizeof(g_MySQL_InlineData); ++i)
                for(new E_CALLBACK_DATA:e = E_CALLBACK_DATA:0; e < E_CALLBACK_DATA; ++e)
                    g_MySQL_InlineData[i][e] = 0;
            g_MySQL_LazyInit = false;
        }
        
        for(new i=0; i < sizeof(g_MySQL_InlineData); ++i)
            if(_:g_MySQL_InlineData[i][E_CALLBACK_DATA_POINTER] == 0)
                if (Callback_Get(CB, g_MySQL_InlineData[i]))
                    return i;
                    
        return -1;
    }
    
    #define mysql_pquery_inline(%0,%1,%2,"%3"%4) \
        mysql_pquery(%0,%1,"FJ37DH3JG_MYSQL_INTERNAL","d"#%3,MySQL_Internal_SaveInline(%2)%4)
        
    #define mysql_tquery_inline(%0,%1,%2,"%3"%4) \
        mysql_tquery(%0,%1,"FJ37DH3JG_MYSQL_INTERNAL","d"#%3,MySQL_Internal_SaveInline(%2)%4)
    
    #define orm_select_inline(%0,%1,"%2"%3) \
        orm_select(%0,"FJ37DH3JG_MYSQL_INTERNAL","d"#%2,MySQL_Internal_SaveInline(%1)%3)
    
    #define orm_insert_inline(%0,%1,"%2"%3) \
        orm_insert(%0,"FJ37DH3JG_MYSQL_INTERNAL","d"#%2,MySQL_Internal_SaveInline(%1)%3)


    forward FJ37DH3JG_MYSQL_INTERNAL(...);
    public FJ37DH3JG_MYSQL_INTERNAL(...) 
    {
        new InlineDataIndex = getarg(0);
        if(InlineDataIndex < 0)
            return 0;
        
        for(new i=0; i < numargs()-1; ++i) 
        {
            for(new l=0; l < YSI_MAX_STRING; ++l) 
            {
                new TmpVal = getarg(i+1, l);
                if(l == 0 || g_MySQL_VarArray[i][l-1] < 256)
                    g_MySQL_VarArray[i][l] = TmpVal;
                else 
                    break;
            }
            
            g_MySQL_AddressArray[i] = AMX_GetRelativeAddress(g_MySQL_VarArray[i][0]);
        }
        
        Callback_Array(g_MySQL_InlineData[InlineDataIndex], g_MySQL_AddressArray);
        
        Callback_Release(g_MySQL_InlineData[InlineDataIndex]);
        for(new E_CALLBACK_DATA:e = E_CALLBACK_DATA:0; e < E_CALLBACK_DATA; ++e)
            g_MySQL_InlineData[InlineDataIndex][e] = 0;
        
        for(new i=0; i < numargs()-1; ++i) 
        {
            g_MySQL_AddressArray[i] = 0;
            for(new l=0, lmax=strlen(g_MySQL_VarArray[i]); l < lmax; ++l)
                g_MySQL_VarArray[i][l] = 0;
        }
        return 1;
    }
#endif

Alles anzeigen

Kaliber · 27. Mai 2020

Versuch es mal so:

C

/**
 * MySQL plugin R39-6
 */


#if defined mysql_included
    #endinput
#endif
#define mysql_included


/**
 * Common error codes
 *
 * Client: http://dev.mysql.com/doc/refman/5.1/en/error-messages-client.html
 * Server: http://dev.mysql.com/doc/refman/5.1/en/error-messages-server.html
 */

#define ER_DBACCESS_DENIED_ERROR         1044
#define ER_ACCESS_DENIED_ERROR             1045
#define ER_UNKNOWN_TABLE                 1109
#define ER_SYNTAX_ERROR                 1149
#define CR_SERVER_GONE_ERROR             2006
#define CR_SERVER_LOST                     2013
#define CR_COMMAND_OUT_OF_SYNC             2014
#define CR_SERVER_LOST_EXTENDED         2055


enum E_MYSQL_LOGLEVEL
{
    LOG_NONE = 0,
    LOG_ERROR = 1,
    LOG_WARNING = 2,
    LOG_DEBUG = 4,

    LOG_ALL = LOG_ERROR | LOG_WARNING | LOG_DEBUG
};

enum E_MYSQL_LOGTYPE
{
    LOG_TYPE_TEXT = 1,
    LOG_TYPE_HTML = 2
};

enum ORM_Error
{
    ERROR_OK,
    ERROR_NO_DATA
};

enum E_MYSQL_OPTION
{
    DUPLICATE_CONNECTIONS,
    LOG_TRUNCATE_DATA
};

enum E_EXECTIME_UNIT
{
    UNIT_MILLISECONDS,
    UNIT_MICROSECONDS
};


#define mysql_real_escape_string                     mysql_escape_string
#define cache_num_fields                             cache_get_field_count
#define cache_num_rows                                 cache_get_row_count
#define mysql_function_query(%0,%1,%2,%3,"%4"%5)     mysql_tquery(%0,%1,%3,#%4%5)
#define mysql_reload(%0)                             mysql_tquery(%0,"FLUSH PRIVILEGES")
#define mysql_debug(%0)                                (%0?mysql_log(LOG_ALL):mysql_log())
#define ismysqlnull(%0)                             (strcmp(%0,"NULL",false)==0)


// ORM functions
native ORM:orm_create(const table[], connectionHandle = 1);
native orm_destroy(ORM:id);

native ORM_Error:orm_errno(ORM:id);

native orm_apply_cache(ORM:id, row);
native orm_select(ORM:id, const callback[] = "", const format[] = "", {Float, _}:...);
/*
native orm_select_inline(ORM:id, callback:Callback, format[], {Float,_}:...); //y_inline
*/
native orm_update(ORM:id);
native orm_insert(ORM:id, const callback[] = "", const format[] = "", {Float, _}:...);
/*
native orm_insert_inline(ORM:id, callback:Callback, format[], {Float,_}:...); //y_inline
*/
native orm_delete(ORM:id, bool:clearvars=true);

native orm_load(ORM:id, const callback[] = "", const format[] = "", {Float, _}:...) = orm_select;
native orm_save(ORM:id, const callback[] = "", const format[] = "", {Float, _}:...);

native orm_addvar_int(ORM:id, &var, varname[]);
native orm_addvar_float(ORM:id, &Float:var, varname[]);
native orm_addvar_string(ORM:id, var[], var_maxlen, varname[]);

native orm_delvar(ORM:id, const varname[]);
native orm_setkey(ORM:id, const varname[]);


// MySQL functions
native mysql_log(E_MYSQL_LOGLEVEL:loglevel = LOG_ERROR | LOG_WARNING, E_MYSQL_LOGTYPE:logtype = LOG_TYPE_TEXT);
native mysql_connect(const host[], const user[], const database[], const password[], port = 3306, bool:autoreconnect = true, pool_size = 2);
native mysql_close(connectionHandle = 1);
native mysql_reconnect(connectionHandle = 1);

native mysql_unprocessed_queries(connectionHandle = 1);
native mysql_current_handle();
native mysql_option(E_MYSQL_OPTION:type, value);

native mysql_errno(connectionHandle = 1);
native mysql_escape_string(const source[], const destination[], connectionHandle = 1, max_len = sizeof(destination));
native mysql_format(connectionHandle, const output[], len, const format[], {Float,_}:...);
native mysql_pquery(connectionHandle, const query[], const callback[] = "", const format[] = "", {Float,_}:...);
/*
native mysql_pquery_inline(connHandle, query[], callback:Callback, format[], {Float,_}:...); //y_inline
*/
native mysql_tquery(connectionHandle, const query[], const callback[] = "", const format[] = "", {Float,_}:...);
/*
native mysql_tquery_inline(connHandle, query[], callback:Callback, format[], {Float,_}:...); //y_inline
*/
native Cache:mysql_query(conhandle, const query[], bool:use_cache = true);

native mysql_stat(const destination[], connectionHandle = 1, max_len = sizeof(destination));
native mysql_get_charset(const destination[], connectionHandle = 1, max_len = sizeof(destination));
native mysql_set_charset(const charset[], connectionHandle = 1);


// Cache functions
native cache_get_data(&num_rows, &num_fields, connectionHandle = 1);
native cache_get_row_count(connectionHandle = 1);
native cache_get_field_count(connectionHandle = 1);
native cache_get_field_name(field_index, const destination[], connectionHandle = 1, max_len = sizeof(destination));

native cache_get_row(row, field_idx, const destination[], connectionHandle = 1, max_len = sizeof(destination));
native cache_get_row_int(row, field_idx, connectionHandle = 1);
native Float:cache_get_row_float(row, field_idx, connectionHandle = 1);

native cache_get_field_content(row, const field_name[], const destination[], connectionHandle = 1, max_len = sizeof(destination));
native cache_get_field_content_int(row, const field_name[], connectionHandle = 1);
native Float:cache_get_field_content_float(row, const field_name[], connectionHandle = 1);

native Cache:cache_save(connectionHandle = 1);
native cache_delete(Cache:cache_id, connectionHandle = 1);
native cache_set_active(Cache:cache_id, connectionHandle = 1);
native cache_is_valid(Cache:cache_id, connectionHandle = 1);

native cache_affected_rows(connectionHandle = 1);
native cache_insert_id(connectionHandle = 1);
native cache_warning_count(connectionHandle = 1);

native cache_get_query_exec_time(E_EXECTIME_UNIT:unit = UNIT_MICROSECONDS);
native cache_get_query_string(const destination[], max_len = sizeof(destination));


// Forward declarations
forward OnQueryError(errorid, error[], callback[], query[], connectionHandle);


#if defined MYSQL_USE_YINLINE || defined E_CALLBACK_DATA
    #if !defined E_CALLBACK_DATA
        #include <YSI\y_inline>
    #endif

    static g_MySQL_InlineData[1000][E_CALLBACK_DATA];
    static g_MySQL_VarArray[32][YSI_MAX_STRING];
    static g_MySQL_AddressArray[32];

    stock MySQL_Internal_SaveInline(callback:CB)
    {
        static bool:g_MySQL_LazyInit = true;
        if(g_MySQL_LazyInit == true)
        {
            //set g_MySQL_InlineData empty
            for(new i=0; i < sizeof(g_MySQL_InlineData); ++i)
                for(new E_CALLBACK_DATA:e = E_CALLBACK_DATA:0; e < E_CALLBACK_DATA; ++e)
                    g_MySQL_InlineData[i][e] = 0;
            g_MySQL_LazyInit = false;
        }

        for(new i=0; i < sizeof(g_MySQL_InlineData); ++i)
            if(_:g_MySQL_InlineData[i][E_CALLBACK_DATA_POINTER] == 0)
                if (Callback_Get(CB, g_MySQL_InlineData[i]))
                    return i;

        return -1;
    }

    #define mysql_pquery_inline(%0,%1,%2,"%3"%4) \
        mysql_pquery(%0,%1,"FJ37DH3JG_MYSQL_INTERNAL","d"#%3,MySQL_Internal_SaveInline(%2)%4)

    #define mysql_tquery_inline(%0,%1,%2,"%3"%4) \
        mysql_tquery(%0,%1,"FJ37DH3JG_MYSQL_INTERNAL","d"#%3,MySQL_Internal_SaveInline(%2)%4)

    #define orm_select_inline(%0,%1,"%2"%3) \
        orm_select(%0,"FJ37DH3JG_MYSQL_INTERNAL","d"#%2,MySQL_Internal_SaveInline(%1)%3)

    #define orm_insert_inline(%0,%1,"%2"%3) \
        orm_insert(%0,"FJ37DH3JG_MYSQL_INTERNAL","d"#%2,MySQL_Internal_SaveInline(%1)%3)


    forward FJ37DH3JG_MYSQL_INTERNAL(...);
    public FJ37DH3JG_MYSQL_INTERNAL(...)
    {
        new InlineDataIndex = getarg(0);
        if(InlineDataIndex < 0)
            return 0;

        for(new i=0; i < numargs()-1; ++i)
        {
            for(new l=0; l < YSI_MAX_STRING; ++l)
            {
                new TmpVal = getarg(i+1, l);
                if(l == 0 || g_MySQL_VarArray[i][l-1] < 256)
                    g_MySQL_VarArray[i][l] = TmpVal;
                else
                    break;
            }

            g_MySQL_AddressArray[i] = AMX_GetRelativeAddress(g_MySQL_VarArray[i][0]);
        }

        Callback_Array(g_MySQL_InlineData[InlineDataIndex], g_MySQL_AddressArray);

        Callback_Release(g_MySQL_InlineData[InlineDataIndex]);
        for(new E_CALLBACK_DATA:e = E_CALLBACK_DATA:0; e < E_CALLBACK_DATA; ++e)
            g_MySQL_InlineData[InlineDataIndex][e] = 0;

        for(new i=0; i < numargs()-1; ++i)
        {
            g_MySQL_AddressArray[i] = 0;
            for(new l=0, lmax=strlen(g_MySQL_VarArray[i]); l < lmax; ++l)
                g_MySQL_VarArray[i][l] = 0;
        }
        return 1;
    }
#endif

Alles anzeigen

quitX · 27. Mai 2020

Öhm, das hat geklappt, woran lag das Problem.

Kaliber · 27. Mai 2020

Zitat von Dr.Tastisch

Öhm, das hat geklappt, woran lag das Problem.

Bei dem "neuen" Compiler ist es notwendig, dass alle Strings als const angegeben werden.

Zum Beispiel:

C

stock test(str[])

Das müsste zu:

C

stock test(const str[])

Theoretisch ist es nicht notwendig, aber der Compiler, kann solche Funktionen dann besser optimieren.

Allrounder18 · 2. Juni 2020

Guten Abend,

ich wollte eine Mitgliederliste für die Fraktionsleader machen das Problem ist nur das ich aus einer anderen Tabelle den Charakternamen brauche und meine Funktion um den Charakternamen zu bekommen beendet immer die aktuelle Query wodurch mir immer nur ein Fraktionsmitglied angezeigt wird.

Die Query womit man alle Fraktionsmitglieder bekommt

Code

 mysql_format(connection, query, sizeof(query), "SELECT * FROM `character_job` WHERE `faction` = '%i'", CharacterInfo[playerid][CHARACTER_FACTION]);
                    mysql_tquery(connection, query, "GetFactionMember", "i", playerid);

GetFactionMember

Code

callback GetFactionMember(playerid)
{
    new rows, string[256], tempString[256], cid, rang;
    cache_get_row_count(rows);
    if(rows)
    {
        for(new i = 0; i < rows; i++)
        {
            cache_get_value_name_int(i, "characterid", cid);
            cache_get_value_name_int(i, "rang", rang);
            format(string, sizeof(string), "{FFFFFF}%s\t%s\n", getCharacterNameById(cid), FactionRangInfo[CharacterInfo[playerid][CHARACTER_FACTION]][rang][FACTION_RANG_NAME]);
            strcat(tempString, string, sizeof(tempString));
        }
        format(string, sizeof(string), "{FFFFFF}Name\t{FFFFFF}Rang\n%s", tempString);
        ShowPlayerDialog(playerid, DIALOG_FACTION_MEMBER, DIALOG_STYLE_TABLIST_HEADERS, "{FFFFFF}Verwaltung : Fraktion", string, "{FFFFFF}Zurück", "", 5);
    }
    return 1;
}

Alles anzeigen

Funktion um den Charakternamen zu bekommen

Code

getCharacterNameById(id)
{
    new query[128];
    mysql_format(connection, query, sizeof(query), "SELECT `firstname`, `lastname` FROM `character` WHERE `id` = '%i'", id);
    new Cache:result = mysql_query(connection, query);
    new name[256], firstname[128], lastname[128];
    cache_get_value_name(0, "firstname", firstname, 128);
    cache_get_value_name(0, "lastname", lastname, 128);
    format(name, sizeof(name), "%s_%s", firstname, lastname);
    cache_delete(result);
    return name;
}

Alles anzeigen

Mit freundlichen Grüßen

Allrounder18

Whice · 2. Juni 2020

Zitat von Allrounder18

ich wollte eine Mitgliederliste für die Fraktionsleader machen das Problem ist nur das ich aus einer anderen Tabelle den Charakternamen brauche

Das kannst du einfach in SQL mit einer Subquery lösen, als Beispiel so (Vorausgesetzt die ID in character & character_job sind für alle Spieler identisch):

SQL

SELECT `firstname`, `lastname` FROM `character` WHERE EXISTS (SELECT `id`, `faction` FROM `character_job` WHERE `faction` = 'HIER_DIE_FRAKTIONS_ID_PER_FORMAT_EINFÜGEN' AND `character`.`id` = `character_job`.`id`);

[SAMMELTHREAD] Kleine Scripting Fragen

Beitrag von Klex (30. Mai 2020)

Beitrag von Klex (1. Juni 2020)