Beiträge von Sho0ti

  • Nitrado Guthaben

    Guten Abend Com,


    Da ich noch genug Nitradoguthaben besitze und diese nicht mehr brauche, verkaufe ich Sie gegen PSC.
    Wie sind die Preise ?


    Für eine 10€ PSC kriegt Ihr 16€ Nitrado Guthaben,
    Für eine 25€ PSC kriegt Ihr 35€ Nitrado Guthaben.
    Und für eine 50€ PSC kriegt Ihr 70€ Nitrado Guthaben.


    Alles wird mit einen Mittelsmann gemacht. Wenn Ihr Screen's haben wollt schreibt mir eine Private Nachricht.


    Mfg


    [Folgendes muss im Thema enthalten sein und darf nicht entfernt werden:]
    ______
    Unverbindlicher Hinweis: Die Sicherheit einer Transaktion kann am besten durch die Einschaltung eines Mittelsmannes gewährleistet werden. Weitere Informationen dazu gibt es hier.

  • CS:GO Clan

    Guten Abend Com,


    Wir suchen ein anderen Clan als Gegner wir sind gerade 5 Spieler online.


    Meldet euch wenn Ihr lust habt.


    Unser höchster ist Gold Nova 3 der zweit höchster Gold Nova 2 und der dritte Silber Elite 2.


    Also wenn Ihr lust hat könnt Ihr gerne kommen :)


    Just 4 Fun.


    // Push

  • [SUCHE] Farbänderung

    Da ich kein Fan von Grafiken bin und dies auch nicht kann, suche ich jemanden der es vielleicht macht :)


    Dieses Bild -> einmal:


    In Rot mit einen weissen P drinne.
    In Orange mit einen weissen H drinne.
    In Blau mit einen weissen A drinne.


    Wäre lieb wenn das jemanden machen würde :)

  • MySQL Fehler

    Jeffry:


    Jetzt will er keine Spieler speichern mehr.



    MySQL Log.


    Spoiler anzeigen
    [16:26:14] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
    [16:26:14] [DEBUG] CMySQLHandle::Create - creating new connection..
    [16:26:14] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
    [16:26:14] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
    [16:26:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [16:26:14] [DEBUG] CMySQLConnection::Connect - connection was successful
    [16:26:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [16:26:14] [DEBUG] mysql_errno - connection: 1
    [16:26:14] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_accounts` ( `ID` int(11) NOT NU", callback: "(null)", format: "(null)"
    [16:26:14] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_banrange` ( `ID` int(11) NOT NU", callback: "(null)", format: "(null)"
    [16:26:14] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_scheine` ( `ID` int(11) NOT NUL", callback: "(null)", format: "(null)"
    [16:26:14] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_settings` ( `ID` int(11) NOT NU", callback: "(null)", format: "(null)"
    [16:26:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [16:26:14] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO BCL_settings VALUES ();", callback: "(null)", format: "(null)"
    [16:26:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [16:26:14] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
    [16:26:14] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BCL_settings`", callback: "LoadSettings", format: "(null)"
    [16:26:14] [DEBUG] CMySQLConnection::Connect - connection was successful
    [16:26:14] [DEBUG] CMySQLConnection::Connect - connection was successful
    [16:26:14] [DEBUG] CMySQLConnection::Connect - connection was successful
    [16:26:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [16:26:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [16:26:14] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:26:14] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 401.16 milliseconds
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 159.976 milliseconds
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 167.898 milliseconds
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 232.236 milliseconds
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 35.546 milliseconds
    [16:26:15] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:26:15] [DEBUG] CMySQLQuery::Execute[LoadSettings] - starting query execution
    [16:26:15] [DEBUG] CMySQLQuery::Execute[LoadSettings] - query was successfully executed within 0.363 milliseconds
    [16:26:15] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [16:26:15] [DEBUG] Calling callback "LoadSettings"..
    [16:26:15] [DEBUG] cache_get_data - connection: 1
    [16:26:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 1", connection: 1
    [16:26:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 1", data: "22"
    [16:26:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 2", connection: 1
    [16:26:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 2", data: "25"
    [16:26:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 3", connection: 1
    [16:26:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 3", data: "18"
    [16:26:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 4", connection: 1
    [16:26:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 4", data: "20"
    [16:26:15] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Staatskasse", connection: 1
    [16:26:15] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Staatskasse", data: "1250000"
    [16:26:15] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [16:26:51] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BCL_banrange` WHERE `Name` = 'Havoc.' AND `Gesper", callback: "MySQL_Banrange", format: "i"
    [16:26:51] [DEBUG] CMySQLQuery::Execute[MySQL_Banrange] - starting query execution
    [16:26:51] [DEBUG] CMySQLQuery::Execute[MySQL_Banrange] - query was successfully executed within 0.357 milliseconds
    [16:26:51] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [16:26:51] [DEBUG] Calling callback "MySQL_Banrange"..
    [16:26:51] [DEBUG] cache_get_data - connection: 1
    [16:26:51] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [16:26:57] [DEBUG] mysql_escape_string - source: "Havoc.", connection: 1, max_len: 24
    [16:26:57] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM BCL_accounts WHERE Name = 'Havoc.'", callback: "UserCheck", format: "i"
    [16:26:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
    [16:26:57] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.412 milliseconds
    [16:26:57] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
    [16:26:57] [DEBUG] Calling callback "UserCheck"..
    [16:26:57] [DEBUG] cache_get_data - connection: 1
    [16:26:57] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
    [16:27:00] [DEBUG] mysql_escape_string - source: "Havoc.", connection: 1, max_len: 24
    [16:27:00] [DEBUG] mysql_escape_string - source: "123456", connection: 1, max_len: 128
    [16:27:00] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO BCL_accounts (Name, Passwort, Eingeloggt) VALUES ('H", callback: "(null)", format: "(null)"
    [16:27:00] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO BCL_scheine (Name) VALUES ('Havoc.')", callback: "(null)", format: "(null)"
    [16:27:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:27:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 105.882 milliseconds
    [16:27:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:27:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:27:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 27.531 milliseconds
    [16:27:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [16:27:09] [DEBUG] mysql_format - connection: 1, len: 80, format: "UPDATE BCL_accounts SET `LastLogin` = NOW() WHERE Name = '%e'"
    [16:27:09] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE BCL_accounts SET `LastLogin` = NOW() WHERE Name = 'Havoc.", callback: "(null)", format: "(null)"
    [16:27:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [16:27:09] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 60.341 milliseconds
    [16:27:09] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving


    //e


    Jeffry:


    Was sagt der Error aus ?


    SQL
    [16:44:55] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE Name = 'Havoc.'' at line 1

  • MySQL Fehler

    stock SpielerSpeichern(playerid)
    {
    new mainQuery[2048], secondQuery[1024];
    if(SpielerInfo[playerid][pEingeloggt] == 0)return 1;
    SpielerInfo[playerid][pEingeloggt] = 0;

    format(secondQuery, sizeof(secondQuery), "UPDATE `"SERVER_TAG"_accounts` SET `InternetProtocol` = '%s', `Eingeloggt`='%d', `Admin`='%d', `Tutorial`='%d', `Level`='%d', `Payday`='%d', `Respekt`='%d', `MaxRespekt`='%d', `Geld`='%d',",
    SpielerIP(playerid), SpielerInfo[playerid][pEingeloggt], SpielerInfo[playerid][pAdmin], SpielerInfo[playerid][pTutorial],SpielerInfo[playerid][pLevel],SpielerInfo[playerid][pPayday],
    SpielerInfo[playerid][pRespekt],SpielerInfo[playerid][pMaxRespekt],SpielerInfo[playerid][pGeld]);
    strcat(mainQuery, secondQuery);
    mysql_function_query(Handle, mainQuery, false, "", "");
    strdel(mainQuery, 0, sizeof(mainQuery));
    strdel(secondQuery, 0, sizeof(secondQuery));


    format(secondQuery, sizeof(secondQuery), "`Bank`='%d', `Festgeld`='%d', `Lohn`='%d', `Skin`='%d', `Spawnchange`='%d', `Fraktion`='%d', `FrakRank`='%d', `FrakSkin`='%d', `Verheiratet`='%d',",
    SpielerInfo[playerid][pBank],SpielerInfo[playerid][pFestgeld],SpielerInfo[playerid][pLohn],SpielerInfo[playerid][pSkin],SpielerInfo[playerid][pSpawnchange],SpielerInfo[playerid][pFraktion],
    SpielerInfo[playerid][pFrakRank],SpielerInfo[playerid][pFrakSkin],SpielerInfo[playerid][pVerheiratet]);
    strcat(mainQuery, secondQuery);
    mysql_function_query(Handle, mainQuery, false, "", "");
    strdel(mainQuery, 0, sizeof(mainQuery));
    strdel(secondQuery, 0, sizeof(secondQuery));

    format(secondQuery, sizeof(secondQuery), "`Job`='%d', `Geschlecht`='%d', WHERE Name = '%s'",
    SpielerInfo[playerid][pJob],SpielerInfo[playerid][pGeschlecht],Spielername(playerid));
    strcat(mainQuery, secondQuery);
    mysql_function_query(Handle, mainQuery, false, "", "");
    strdel(mainQuery, 0, sizeof(mainQuery));
    strdel(secondQuery, 0, sizeof(secondQuery));


    format(secondQuery, sizeof(secondQuery), "UPDATE `"SERVER_TAG"_scheine` SET `Autoschein` = '%d', `AutoscheinPunkte` = '%d', `Flugschein` = '%d', `Waffenschein` = '%d', `Fischschein` = '%d', `Zollschein` = '%d', `Personalausweis` = '%d' WHERE `Name` = '%s'",
    SpielerInfo[playerid][pAutoschein],SpielerInfo[playerid][pAutoscheinPunkte],SpielerInfo[playerid][pFlugschein],SpielerInfo[playerid][pWaffenschein],SpielerInfo[playerid][pFischschein],SpielerInfo[playerid][pZollschein],SpielerInfo[playerid][pPersonalausweis],Spielername(playerid));
    strcat(mainQuery, secondQuery);
    mysql_function_query(Handle, mainQuery, false, "", "");
    strdel(mainQuery, 0, sizeof(mainQuery));
    strdel(secondQuery, 0, sizeof(secondQuery));

    return 1;
    }

  • MySQL Fehler

    Guten Tag,


    Und zwar bekomme ich diesen Fehler in der MySQL Log.


    Spoiler anzeigen

    SQL
    [15:04:09] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2[15:04:09] [DEBUG] CMySQLHandle::Create - creating new connection..[15:04:09] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called[15:04:09] [DEBUG] CMySQLHandle::Create - connection created (id: 1)[15:04:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:09] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:09] [DEBUG] mysql_errno - connection: 1[15:04:09] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_accounts` (  `ID` int(11) NOT NU", callback: "(null)", format: "(null)"[15:04:09] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_banrange` (  `ID` int(11) NOT NU", callback: "(null)", format: "(null)"[15:04:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:09] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_scheine` (  `ID` int(11) NOT NUL", callback: "(null)", format: "(null)"[15:04:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:09] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:09] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_settings` (  `ID` int(11) NOT NU", callback: "(null)", format: "(null)"[15:04:09] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:09] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:09] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:09] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:09] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO BCL_settings VALUES ();", callback: "(null)", format: "(null)"[15:04:09] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BCL_settings`", callback: "LoadSettings", format: "(null)"[15:04:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:09] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.629 milliseconds[15:04:09] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:09] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.572 milliseconds[15:04:09] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:09] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.395 milliseconds[15:04:09] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:09] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.432 milliseconds[15:04:09] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:09] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:09] [ERROR] CMySQLQuery::Execute[] - (error #1062) Duplicate entry '0' for key 'PRIMARY'[15:04:09] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:04:09] [DEBUG] CMySQLQuery::Execute[LoadSettings] - starting query execution[15:04:09] [DEBUG] CMySQLQuery::Execute[LoadSettings] - query was successfully executed within 0.311 milliseconds[15:04:09] [DEBUG] Calling callback "OnQueryError"..[15:04:09] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:04:09] [DEBUG] Calling callback "LoadSettings"..[15:04:09] [DEBUG] cache_get_data - connection: 1[15:04:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 1", connection: 1[15:04:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 1", data: "22"[15:04:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 2", connection: 1[15:04:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 2", data: "25"[15:04:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 3", connection: 1[15:04:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 3", data: "18"[15:04:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 4", connection: 1[15:04:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 4", data: "20"[15:04:09] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Staatskasse", connection: 1[15:04:09] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Staatskasse", data: "1250000"[15:04:09] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:04:13] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BCL_banrange` WHERE `Name` = 'Havoc.' AND `Gesper", callback: "MySQL_Banrange", format: "i"[15:04:13] [DEBUG] CMySQLQuery::Execute[MySQL_Banrange] - starting query execution[15:04:13] [DEBUG] CMySQLQuery::Execute[MySQL_Banrange] - query was successfully executed within 0.376 milliseconds[15:04:13] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:04:13] [DEBUG] Calling callback "MySQL_Banrange"..[15:04:13] [DEBUG] cache_get_data - connection: 1[15:04:13] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:04:20] [DEBUG] mysql_escape_string - source: "Havoc.", connection: 1, max_len: 24[15:04:20] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM BCL_accounts WHERE Name = 'Havoc.'", callback: "UserCheck", format: "i"[15:04:20] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution[15:04:20] [DEBUG] CMySQLQuery::Execute[UserCheck] - query was successfully executed within 0.368 milliseconds[15:04:20] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:04:20] [DEBUG] Calling callback "UserCheck"..[15:04:20] [DEBUG] cache_get_data - connection: 1[15:04:20] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:04:23] [DEBUG] mysql_escape_string - source: "Havoc.", connection: 1, max_len: 24[15:04:23] [DEBUG] mysql_escape_string - source: "123456", connection: 1, max_len: 128[15:04:23] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM BCL_accounts WHERE Name = 'Havoc.' AND Passwort = ", callback: "OnPasswordResponse", format: "i"[15:04:23] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - starting query execution[15:04:23] [DEBUG] CMySQLQuery::Execute[OnPasswordResponse] - query was successfully executed within 0.486 milliseconds[15:04:23] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:04:23] [DEBUG] Calling callback "OnPasswordResponse"..[15:04:23] [DEBUG] cache_get_data - connection: 1[15:04:23] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE BCL_accounts SET Eingeloggt = '1' WHERE Name = 'Havoc.'", callback: "(null)", format: "(null)"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1[15:04:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Admin", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Tutorial", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Tutorial", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Level", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Payday", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Payday", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Respekt", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Respekt", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "MaxRespekt", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "MaxRespekt", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geld", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Bank", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Bank", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Festgeld", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Festgeld", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Lohn", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Lohn", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Skin", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Skin", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Spawnchange", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Spawnchange", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Fraktion", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Fraktion", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "FrakRank", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "FrakRank", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "FrakSkin", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "FrakSkin", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Verheiratet", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Verheiratet", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Job", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Job", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geschlecht", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Geschlecht", data: "0"[15:04:23] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BCL_scheine` WHERE `Name` = 'Havoc.'", callback: "LoadPlayerScheine", format: "i"[15:04:23] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:04:23] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 92.522 milliseconds[15:04:23] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:23] [DEBUG] CMySQLQuery::Execute[LoadPlayerScheine] - starting query execution[15:04:23] [DEBUG] CMySQLQuery::Execute[LoadPlayerScheine] - query was successfully executed within 0.300 milliseconds[15:04:23] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:04:23] [DEBUG] Calling callback "LoadPlayerScheine"..[15:04:23] [DEBUG] cache_get_data - connection: 1[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Autoschein", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Autoschein", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "AutoscheinPunkte", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "AutoscheinPunkte", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Flugschein", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Flugschein", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Waffenschein", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Waffenschein", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Fischschein", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Fischschein", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Zollschein", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Zollschein", data: "0"[15:04:23] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Personalausweis", connection: 1[15:04:23] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Personalausweis", data: "0"[15:04:23] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called[15:04:35] [DEBUG] mysql_format - connection: 1, len: 80, format: "UPDATE BCL_accounts SET `LastLogin` = NOW() WHERE Name = '%e'"[15:04:35] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE BCL_accounts SET `LastLogin` = NOW() WHERE Name = 'Havoc.", callback: "(null)", format: "(null)"[15:04:35] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `BCL_accounts` SET `InternetProtocol` = '255.255.255.255'", callback: "(null)", format: "(null)"[15:04:35] [DEBUG] mysql_tquery - connection: 1, query: "`Bank`='0', `Festgeld`='0', `Lohn`='0', `Skin`='20', `Spawnchang", callback: "(null)", format: "(null)"[15:04:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:35] [DEBUG] mysql_tquery - connection: 1, query: "`Job`='0', `Geschlecht`='2', WHERE Name = 'Havoc.'", callback: "(null)", format: "(null)"[15:04:35] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `BCL_scheine` SET  `Autoschein` = '0', `AutoscheinPunkte`", callback: "(null)", format: "(null)"[15:04:35] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 92.441 milliseconds[15:04:35] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:35] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1[15:04:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:04:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:35] [DEBUG] Calling callback "OnQueryError"..[15:04:35] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Bank`='0', `Festgeld`='0', `Lohn`='0', `Skin`='20', `Spawnchange`='0', `Fraktio' at line 1[15:04:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:04:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:35] [DEBUG] Calling callback "OnQueryError"..[15:04:35] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Job`='0', `Geschlecht`='2', WHERE Name = 'Havoc.'' at line 1[15:04:35] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError[15:04:35] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:35] [DEBUG] Calling callback "OnQueryError"..[15:04:35] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 34.265 milliseconds[15:04:35] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:53] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "samp", password: "****", port: 3306, autoreconnect: true, pool_size: 2[15:04:53] [DEBUG] CMySQLHandle::Create - creating new connection..[15:04:53] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called[15:04:53] [DEBUG] CMySQLHandle::Create - connection created (id: 1)[15:04:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:53] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:53] [DEBUG] mysql_errno - connection: 1[15:04:53] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_accounts` (  `ID` int(11) NOT NU", callback: "(null)", format: "(null)"[15:04:53] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_banrange` (  `ID` int(11) NOT NU", callback: "(null)", format: "(null)"[15:04:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:53] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_scheine` (  `ID` int(11) NOT NUL", callback: "(null)", format: "(null)"[15:04:53] [DEBUG] CMySQLConnection::Connect - establishing connection to database...[15:04:53] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:53] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:53] [DEBUG] mysql_tquery - connection: 1, query: "CREATE TABLE IF NOT EXISTS `BCL_settings` (  `ID` int(11) NOT NU", callback: "(null)", format: "(null)"[15:04:53] [DEBUG] CMySQLConnection::Connect - connection was successful[15:04:53] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO BCL_settings VALUES ();", callback: "(null)", format: "(null)"[15:04:53] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled[15:04:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:53] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `BCL_settings`", callback: "LoadSettings", format: "(null)"[15:04:53] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 308.814 milliseconds[15:04:53] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:54] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 212.398 milliseconds[15:04:54] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:54] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:54] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 482.105 milliseconds[15:04:54] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:54] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:54] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 302.289 milliseconds[15:04:54] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:54] [DEBUG] CMySQLQuery::Execute[] - starting query execution[15:04:54] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 21.606 milliseconds[15:04:54] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving[15:04:54] [DEBUG] CMySQLQuery::Execute[LoadSettings] - starting query execution[15:04:54] [DEBUG] CMySQLQuery::Execute[LoadSettings] - query was successfully executed within 0.344 milliseconds[15:04:54] [DEBUG] CMySQLResult::CMySQLResult() - constructor called[15:04:54] [DEBUG] Calling callback "LoadSettings"..[15:04:54] [DEBUG] cache_get_data - connection: 1[15:04:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 1", connection: 1[15:04:54] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 1", data: "22"[15:04:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 2", connection: 1[15:04:54] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 2", data: "25"[15:04:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 3", connection: 1[15:04:54] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 3", data: "18"[15:04:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Steuerklasse 4", connection: 1[15:04:54] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Steuerklasse 4", data: "20"[15:04:54] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Staatskasse", connection: 1[15:04:54] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "Staatskasse", data: "1250000"[15:04:54] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

    Spoiler anzeigen


    Kann mir einer helfen ? Jeffry:

  • |DINI| Geld gegen Cheat schützen!

    Schützt 100% gegen Geld Hack, habe es selbst ausprobiert. Geld wird angezeigt aber direkt wieder abgezogen.


    stock SetMoney(playerid, value)
    {
    if(!IsPlayerConnected(playerid))return 0;
    SpielerInfo[playerid][pGeld] = value;
    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid, SpielerInfo[playerid][pGeld]);
    return 1;
    }


    stock GiveMoney(playerid, value)
    {
    if(!IsPlayerConnected(playerid))return 0;
    SpielerInfo[playerid][pGeld] += value;
    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid, SpielerInfo[playerid][pGeld]);
    return 1;
    }


    Mfg

  • [SAMMELTHREAD] Kleine Scripting Fragen

    Jeffry:


    Funktioniert leider immernoch :/


    format(query, sizeof(query), "CREATE TABLE IF NOT EXISTS `"SERVER_TAG"_settings` (");
    format(query, sizeof(query), "%s `ID` int(11) NOT NULL PRIMARY KEY,", query);
    format(query, sizeof(query), "%s `Steuerklasse 1` int(2) NOT NULL DEFAULT '22',", query);
    format(query, sizeof(query), "%s `Steuerklasse 2` int(2) NOT NULL DEFAULT '25',", query);
    format(query, sizeof(query), "%s `Steuerklasse 3` int(2) NOT NULL DEFAULT '18',", query);
    format(query, sizeof(query), "%s `Steuerklasse 4` int(2) NOT NULL DEFAULT '20',", query);
    format(query, sizeof(query), "%s `Staatskasse` int(11) NOT NULL DEFAULT '1250000'", query);
    format(query, sizeof(query), "%s) ENGINE=InnoDB DEFAULT CHARSET=latin1;", query);
    mysql_tquery(Handle, "INSERT INTO "SERVER_TAG"_settings VALUES ();");
    mysql_tquery(Handle, query);