1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MYSQL PROBLEM
Danyal
Huge Clucker
****
Posts: 332
Threads: 28
Joined: Sep 2011
Reputation: 0
#1

11.02.2012, 15:58
pawn Код:
//============================================================================//
//                                  Includes                                  //
//============================================================================//
#include <a_samp>
#include <zcmd>
#include <sscanf2>
#include <a_mysql>
//============================================================================//
//                                  Defines                                   //
//============================================================================//
#define SERVER_NAME     "Server Name"
#define SERVER_TIME     "12"
#define SERVER_GRAVITY  "0.00800"
#define SERVER_MAP      "Map name"
#define SERVER_WEBSITE  "www.yoursite.com"

#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB   "database"

#define Blue    "{003DF5}"
#define Red     "{FF0000}"
#define Green   "{66FF00}"
#define White   "{FFFFFF}"

#define DIALOG_REGISTER         100
#define DIALOG_LOGIN            101
#define DIALOG_POS              102
//============================================================================//
//                                  Forwards                                  //
//============================================================================//
forward HideMessage1(playerid);
//============================================================================//
//                                  New's                                     //
//============================================================================//
new Text:Textdraw1;
enum PlayerData
{
    pDriftingPoints,
    pCash,
    pVipLevel,
    pAdminLevel,
    pKills,
    pDeaths,
    pLocked,
    pNumber,
    pWanted,
    pGun1,
    pGun2,
    pGun3,
    pGun4,
    pGun5,
    pGun6,
    pGun7,
    pGun8,
    pGun9,
    pGun10,
    pGun11,
    pGun12,
    pAmmo1,
    pAmmo2,
    pAmmo3,
    pAmmo4,
    pAmmo5,
    pAmmo6,
    pAmmo7,
    pAmmo8,
    pAmmo9,
    pAmmo10,
    pAmmo11,
    pAmmo12,
//  pFleader,
//  pFmember,
//  pBank,
//  pProds,
//  pSkin,
//  pRepairOffer,
//  pCredit,
//  pJob,
//  pCarSkill,
//  pDetSkill,
//  pFightingSkills,
//  pPlayTime,
//  pRespect,
//  pScore,
//  pCar,
//  pFailedLogins,
//  pMins,
//  pHours,
};
new PlayerInfo[MAX_PLAYERS][PlayerData];
new MoneyGiven[MAX_PLAYERS];
new IsRegistered[MAX_PLAYERS];
new Logged[MAX_PLAYERS];
new JustLogged[MAX_PLAYERS];


public OnGameModeInit()
{
    mysql_start();
    Textdraw1 = TextDrawCreate(13.000000, 150.000000, "First Message");
    TextDrawBackgroundColor(Textdraw1, 255);
    TextDrawFont(Textdraw1, 1);
    TextDrawLetterSize(Textdraw1, 0.370000, 1.100000);
    TextDrawColor(Textdraw1, -1);
    TextDrawSetOutline(Textdraw1, 0);
    TextDrawSetProportional(Textdraw1, 1);
    TextDrawSetShadow(Textdraw1, 1);
    TextDrawUseBox(Textdraw1, 1);
    TextDrawBoxColor(Textdraw1, 255);
    TextDrawTextSize(Textdraw1, 278.000000, 36.000000);
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    new
    Query[1024];
    mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS);
    format(Query, 512, "CREATE TABLE IF NOT EXISTS playerdata(User VARCHAR(24), Password VARCHAR(40), DriftingPoints INT(20),");
    format(Query, 512, "%s Cash INT(20), VipLevel INT(20), AdminLevel INT(20), Kills INT(20), Deaths INT(20), Locked INT(20),", Query);
    format(Query, 512, "%s Number INT(20), Wanted INT(20), Gun1 INT(20), Gun2 INT(20), Gun3 INT(20), Gun4 INT(20), Gun5 INT(20), Gun6 INT(20),", Query);
    format(Query, 512, "%s Gun7 INT(20), Gun8 INT(20), Gun9 INT(20), Gun10 INT(20), Gun11 INT(20), Gun12 INT(20), Ammo1 INT(20), Ammo2 INT(20),", Query);
    format(Query, 512, "%s Ammo3 INT(20), Ammo4 INT(20), Ammo5 INT(20), Ammo6 INT(20), Ammo7 INT(20), Ammo8 INT(20), Ammo9 INT(20), Ammo10 INT(20),", Query);
    format(Query, 512, "%s Ammo11 INT(20), Ammo12 INT(20), IP VARCHAR(15) )", Query);
    mysql_query(Query);
    mysql_debug(1);
    return 1;
}

forward mysql_start();
public mysql_start()
{
    mysql_debug(1);
    if (mysql_connect(SQL_HOST, SQL_USER, SQL_DB, SQL_PASS))
    {
        print("[MYSQL] Connection successful!");
    }
    else
    {
        print("[MYSQL] There was an error connecting to the MYSQL server");
        //IRC_GroupSay(gGroupID, "IRC_Channel", "[MYSQL] There was an error connecting to the MYSQL server");
    }
    return 1;
}

public OnGameModeExit()
{
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
    SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
    SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
    return 1;
}

public OnPlayerConnect(playerid)
{
    RemoveUnderScore(playerid);
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    MoneyGiven[playerid] = -1;
    JustLogged[playerid] = 0;
    new query[1024], pname[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);
    mysql_store_result();
//    new rows = mysql_num_rows();
//    if(!rows)
//    {
    if(mysql_num_rows() == 0)
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
    }
//    if(rows == 1)
    else
    {
        new IP[2][15];
        mysql_fetch_field_row(IP[0],"IP");
        GetPlayerIp(playerid, IP[1], 15);
        if(strlen(IP[0]) != 0 && !strcmp(IP[0], IP[1], true))
        {
            MySQL_Login(playerid);
        }
        else if(!strlen(IP[0]) || strcmp(IP[0], IP[1], true))
        {
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
            IsRegistered[playerid] = 1;
        }
    }
    mysql_free_result();
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    if(Logged[playerid] == 1)
    {
        new Cash = GetPlayerMoney(playerid);
        new query[1024], pname[24];
        GetPlayerName(playerid, pname, 24);
        PlayerInfo[playerid][pWanted] = GetPlayerWantedLevel(playerid);
        PlayerInfo[playerid][pDriftingPoints] = GetPlayerScore(playerid);
        GetPlayerWeaponData(playerid, 1, PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pAmmo1]);
        GetPlayerWeaponData(playerid, 2, PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pAmmo2]);
        GetPlayerWeaponData(playerid, 3, PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pAmmo3]);
        GetPlayerWeaponData(playerid, 4, PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo4]);
        GetPlayerWeaponData(playerid, 5, PlayerInfo[playerid][pGun5], PlayerInfo[playerid][pAmmo5]);
        GetPlayerWeaponData(playerid, 6, PlayerInfo[playerid][pGun6], PlayerInfo[playerid][pAmmo6]);
        GetPlayerWeaponData(playerid, 7, PlayerInfo[playerid][pGun7], PlayerInfo[playerid][pAmmo7]);
        GetPlayerWeaponData(playerid, 8, PlayerInfo[playerid][pGun8], PlayerInfo[playerid][pAmmo8]);
        GetPlayerWeaponData(playerid, 9, PlayerInfo[playerid][pGun9], PlayerInfo[playerid][pAmmo9]);
        GetPlayerWeaponData(playerid, 10, PlayerInfo[playerid][pGun10], PlayerInfo[playerid][pAmmo10]);
        GetPlayerWeaponData(playerid, 11, PlayerInfo[playerid][pGun11], PlayerInfo[playerid][pAmmo11]);
        GetPlayerWeaponData(playerid, 12, PlayerInfo[playerid][pGun12], PlayerInfo[playerid][pAmmo12]);
        format(query, sizeof(query), "UPDATE playerdata SET DriftingPoints=%d, Cash=%d, VipLevel=%d, AdminLevel=%d, Kills=%d, Deaths=%d, Locked=%d, Number=%d, Wanted=%d, Gun1=%d, Gun2=%d, Gun3=%d, Gun4=%d, Gun5=%d, Gun6=%d, Gun7=%d, Gun8=%d, Gun9=%d, Gun10=%d, Gun11=%d, Gun12=%d, Ammo1=%d, Ammo2=%d, Ammo3=%d, Ammo4=%d, Ammo5=%d, Ammo6=%d, Ammo7=%d, Ammo8=%d, Ammo9=%d, Ammo10=%d, Ammo11=%d, Ammo12=%d/*posx=%f, posy=%f, posz=%f, posa=%f*/  WHERE user='%s'",
        PlayerInfo[playerid][pDriftingPoints],
        Cash,
        PlayerInfo[playerid][pVipLevel],
        PlayerInfo[playerid][pAdminLevel],
        PlayerInfo[playerid][pKills],
        PlayerInfo[playerid][pDeaths],
        PlayerInfo[playerid][pKills],
        PlayerInfo[playerid][pDeaths],
        PlayerInfo[playerid][pLocked],
        PlayerInfo[playerid][pNumber],
        PlayerInfo[playerid][pWanted],
        PlayerInfo[playerid][pGun1],
        PlayerInfo[playerid][pGun2],
        PlayerInfo[playerid][pGun3],
        PlayerInfo[playerid][pGun4],
        PlayerInfo[playerid][pGun5],
        PlayerInfo[playerid][pGun6],
        PlayerInfo[playerid][pGun7],
        PlayerInfo[playerid][pGun8],
        PlayerInfo[playerid][pGun9],
        PlayerInfo[playerid][pGun10],
        PlayerInfo[playerid][pGun11],
        PlayerInfo[playerid][pGun12],
        PlayerInfo[playerid][pAmmo1],
        PlayerInfo[playerid][pAmmo2],
        PlayerInfo[playerid][pAmmo3],
        PlayerInfo[playerid][pAmmo4],
        PlayerInfo[playerid][pAmmo5],
        PlayerInfo[playerid][pAmmo6],
        PlayerInfo[playerid][pAmmo7],
        PlayerInfo[playerid][pAmmo8],
        PlayerInfo[playerid][pAmmo9],
        PlayerInfo[playerid][pAmmo10],
        PlayerInfo[playerid][pAmmo11],
        PlayerInfo[playerid][pAmmo12],
        pname);
        mysql_query(query);
    }
    return 1;
}

public OnPlayerSpawn(playerid)
{
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    if(MoneyGiven[playerid] != -1)
    {
        GivePlayerMoney(playerid, MoneyGiven[playerid]);
        MoneyGiven[playerid] = -1;
    }
    if(JustLogged[playerid] == 1)
    {
        ShowPlayerDialog(playerid, DIALOG_POS, DIALOG_STYLE_MSGBOX, ""Blue"Sucessfully logged-in!", ""White"You have sucessfully logged-in to your account!\n\n"White"Would you like to load you previous possition?", "Yes", "No");
        JustLogged[playerid] = 0;
    }
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{
    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
    if (strcmp("/mycommand", cmdtext, true, 10) == 0)
    {
        // Do something here
        return 1;
    }
    return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
    return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
    return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
    return 1;
}

public OnRconCommand(cmd[])
{
    return 1;
}

public OnPlayerRequestSpawn(playerid)
{
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    if(!Logged[playerid])
    {
        if(!IsRegistered[playerid])
        {
            ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
            return 0;
        }
        if(IsRegistered[playerid] == 1)
        {
            ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
            return 0;
        }
    }
    return 1;
}

public OnObjectMoved(objectid)
{
    return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
    return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
    return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
    return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
    return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
    return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
    return 1;
}

public OnPlayerExitedMenu(playerid)
{
    return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
    return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
    return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
    return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
    return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    if(dialogid == DIALOG_POS)
    {
        if(response)
        {
            SendMessage(playerid, "~g~Info: ~w~Sucessfully loaded your last possition!");
        }
        else if(!response)
        {
            return 1;
        }
    }
    //================================================================//
    //                              MySQL part                        //
    //================================================================//
    if(dialogid == DIALOG_REGISTER)
    {
        if(response)
        {
            if(!strlen(inputtext) || strlen(inputtext) > 100)
            {
                SendMessage(playerid, "~r~Error: ~w~You must insert a password between 1-100 characters!");
                ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
            }
            else if(strlen(inputtext) > 0 && strlen(inputtext) < 100)
            {
                new escpass[100];
                mysql_real_escape_string(inputtext, escpass);
                MySQL_Register(playerid, escpass);
            }
        }
        if(!response)
        {
                SendMessage(playerid, "~r~Error: ~w~You must register before logging in!");
                ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""Blue"Please register",""White"Welcome to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to register!\n\n"White"Please insert a password below:", "Register", "Cancel");
        }
    }
    if(dialogid == DIALOG_LOGIN)
    {
        if(!response)
        {
                SendMessage(playerid, "~r~Error: ~w~You must login before you spawn!");
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
        }
        if(response)
        {
            new query[1024], pname[24], escapepass[100];
            GetPlayerName(playerid, pname, 24);
            mysql_real_escape_string(inputtext, escapepass);
            format(query, sizeof(query), "SELECT `user` FROM playerdata WHERE user = '%s' AND password = SHA1('%s')", pname, escapepass);
            mysql_query(query);
            mysql_store_result();
            new numrows = mysql_num_rows();
            if(numrows == 1) MySQL_Login(playerid);
            if(!numrows)
            {
                ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, ""Blue"Please log-in", ""White"Welcome back to "Red""SERVER_NAME""White"!\n"White"In order to start playing, you have to log-in!\n\n"White"Please insert "Red"your"White" password below:", "Login", "Cancel");
                SendMessage(playerid, "~r~Error: ~w~Incorrect password!");
            }
            mysql_free_result();
        }
    }
    return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
    return 1;
}

//============================================================================//
//                                  Stocks /  Publics                         //
//============================================================================//

public HideMessage1(playerid)
{
    TextDrawHideForPlayer(playerid, Textdraw1);
    return 1;
}

stock MySQL_Register(playerid, passwordstring[])
{
    new query[1024], pname[24], IP[15];
    new Bannedby[20];
    format(Bannedby, 20, "Not Banned");
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, IP, 15);
    format(query, sizeof(query), "INSERT INTO playerdata (user, password, DriftingPoints, Cash, VipLevel, AdminLevel, Kills, Deaths, Locked, Number, Wanted, Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Gun7, Gun8, Gun9, Gun10, Gun11, Gun12, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, Ammo7, Ammo8, Ammo9, Ammo10, Ammo11, Ammo12, IP) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s')", pname, passwordstring, Bannedby, IP);
    mysql_query(query);
    SendMessage(playerid, "~g~Info: ~w~You have been registered on this server!");
    Logged[playerid] = 1;
    return 1;
}

stock RemoveUnderScore(playerid)
{
    new name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,sizeof(name));
    for(new i = 0; i < MAX_PLAYER_NAME; i++)
    {
        if(name[i] == '_') name[i] = ' ';
    }
    return name;
}

stock MySQL_Login(playerid)
{
    new query[1024], pname[24], savingstring[256];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT DriftingPoints, Cash, VipLevel, AdminLevel, Kills, Deaths, Locked, Number, Wanted, Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Gun7, Gun8, Gun9, Gun10, Gun11, Gun12, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, Ammo7, Ammo8, Ammo9, Ammo10, Ammo11, Ammo12 FROM playerdata WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "DriftingPoints"); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "Cash"); MoneyGiven[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "VipLevel"); PlayerInfo[playerid][pVipLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "AdminLevel"); PlayerInfo[playerid][pAdminLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Locked"); PlayerInfo[playerid][pLocked] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Number"); PlayerInfo[playerid][pNumber] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Wanted"); PlayerInfo[playerid][pWanted] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun1"); PlayerInfo[playerid][pGun1] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun2"); PlayerInfo[playerid][pGun2] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun3"); PlayerInfo[playerid][pGun3] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun4"); PlayerInfo[playerid][pGun4] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun5"); PlayerInfo[playerid][pGun5] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun6"); PlayerInfo[playerid][pGun6] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun7"); PlayerInfo[playerid][pGun7] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun8"); PlayerInfo[playerid][pGun8] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun9"); PlayerInfo[playerid][pGun9] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun10"); PlayerInfo[playerid][pGun10] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun11"); PlayerInfo[playerid][pGun11] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Gun12"); PlayerInfo[playerid][pGun12] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo1"); PlayerInfo[playerid][pAmmo1] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo2"); PlayerInfo[playerid][pAmmo2] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo3"); PlayerInfo[playerid][pAmmo3] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo4"); PlayerInfo[playerid][pAmmo4] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo5"); PlayerInfo[playerid][pAmmo5] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo6"); PlayerInfo[playerid][pAmmo6] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo7"); PlayerInfo[playerid][pAmmo7] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo8"); PlayerInfo[playerid][pAmmo8] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo9"); PlayerInfo[playerid][pAmmo9] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo10"); PlayerInfo[playerid][pAmmo10] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo11"); PlayerInfo[playerid][pAmmo11] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "Ammo12"); PlayerInfo[playerid][pAmmo12] = strval(savingstring);
    }
    mysql_free_result();
    JustLogged[playerid] = 1;
    Logged[playerid] = 1;
    SendMessage(playerid, "~g~Info: ~w~You have been logged-in!");
    return 1;
}

stock GetName(playerid)
{
    new pname[24];
    GetPlayerName(playerid, pname, 24);
    return pname;
}

stock SendMessage(playerid, message[])
{
    TextDrawHideForPlayer(playerid, Textdraw1);
    TextDrawSetString(Textdraw1, message);
    TextDrawShowForPlayer(playerid, Textdraw1);
    SetTimer("HideMessage1", 5000, false);
    return 1;
}
DEBUG REPORT
PHP код:
[21:57:01] ---------------------------
[21:57:01] MySQL Debugging activated (02/11/12)
[21:57:01] ---------------------------
[21:57:01]  
[21:57:04] >> mysql_query( Connection handle: 1 )
[21:57:04] CMySQLHandler::Query() - You cannot call this function now. (Reason: Connection is dead)
[21:57:04] >> mysql_store_result( Connection handle: 1 )
[21:57:04] CMySQLHandler::StoreResult() - There is nothing to store (Reason: Connection is dead)
[21:57:04] >> mysql_num_rows( Connection handle: 1 )
[21:57:04] CMySQLHandler::NumRows() - You cannot call this function now. (Reason: Dead Connection)
[21:57:04] >> mysql_fetch_field_row( Connection handle: 1 )
[21:57:04] CMySQLHandler::FetchField(IP) - You cannot call this function now. (Reason: Connection is dead)
[21:57:04] >> mysql_free_result( Connection handle: 1 )
[21:57:04] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead)
[21:57:09] >> mysql_real_escape_string( Connection handle: 1 ) 
Problem is that server goes offline when i register on spawn
Find
Reply
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#2

11.02.2012, 15:59
Your database information is incorrect then.
Find
Reply
KingHual
Banned
Posts: 2,286
Threads: 18
Joined: Jun 2010
#3

11.02.2012, 16:02
Is your server hosted at the same place as the database?
Find
Reply
[MG]Dimi
High-roller
*****
Posts: 1,239
Threads: 16
Joined: Mar 2011
Reputation: 0
#4

11.02.2012, 16:03
make sure your MySQL connection collation is utf8_unicode_ci . Some databases won't work on others. Also under OnPlayerConnect:
pawn Код:
format(query, sizeof(query), "SELECT IP FROM `playerdata` WHERE user = '%s' LIMIT 1", pname);
mysql_query(query);
Ip is Column inside table, not SQL Syntax so it has to be inside ``.
pawn Код:
format(query, sizeof(query), "SELECT `IP` FROM `playerdata` WHERE `user` = '%s' LIMIT 1", pname);
mysql_query(query);
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#5

11.02.2012, 16:09
You're also attempting to connect to the same server and database twice.
Find
Reply
Danyal
Huge Clucker
****
Posts: 332
Threads: 28
Joined: Sep 2011
Reputation: 0
#6

11.02.2012, 17:13
DEBUG REPORT

PHP код:
[23:11:36] >> mysql_query( Connection handle: 1 )
[23:11:36] CMySQLHandler::Query(SELECT `IP` FROM `playerdata` WHERE `user` = 'Danyal' LIMIT 1) - Successfully executed.
[23:11:36] >> mysql_store_result( Connection handle: 1 )
[23:11:36] CMySQLHandler::StoreResult() - Result was stored.
[23:11:36] >> mysql_num_rows( Connection handle: 1 )
[23:11:36] CMySQLHandler::NumRows() - Returned 0 row(s)
[23:11:36] >> mysql_free_result( Connection handle: 1 )
[23:11:36] CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:11:38] >> mysql_real_escape_string( Connection handle: 1 )
[23:11:38] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
[23:11:38] >> mysql_query( Connection handle: 1 )
[23:11:38] CMySQLHandler::Query(INSERT INTO playerdata (user, password, DriftingPoints, Cash, VipLevel, AdminLevel, Kills, Deaths, Locked, Number, Wanted, Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Gun7, Gun8, Gun9, Gun10, Gun11, Gun12, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, Ammo7, Ammo8, Ammo9, Ammo10, Ammo11, Ammo12, IP) VALUES('Danyal', SHA1('123456'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Not Banned')) - An error has occured. (Error ID: 1036, Table 'playerdata' is read only)
[23:12:00] >> mysql_query( Connection handle: 1 )
[23:12:00] CMySQLHandler::Query(UPDATE playerdata SET DriftingPoints=0, Cash=0, VipLevel=0, AdminLevel=0, Kills=0, Deaths=0, Locked=0, Number=0, Wanted=0, Gun1=0, Gun2=0, Gun3=0, Gun4=0, Gun5=0, Gun6=0, Gun7=0, Gun8=0, Gun9=0, Gun10=0, Gun11=0, Gun12=0, Ammo1=0, Ammo2=0, Ammo3=0, Ammo4=0, Ammo5=0, Ammo6=0, Ammo7=0, Ammo8=0, Ammo9=0, Ammo10=0, Ammo11=0, Ammo12=0/*posx=0.000000, posy=0.000000, posz=0.000000, posa=*/  WHERE user='') - Successfully executed.
[23:12:22] >> mysql_query( Connection handle: 1 )
[23:12:22] CMySQLHandler::Query(SELECT `IP` FROM `playerdata` WHERE `user` = 'Danyal' LIMIT 1) - Successfully executed.
[23:12:22] >> mysql_store_result( Connection handle: 1 )
[23:12:22] CMySQLHandler::StoreResult() - Result was stored.
[23:12:22] >> mysql_num_rows( Connection handle: 1 )
[23:12:22] CMySQLHandler::NumRows() - Returned 0 row(s)
[23:12:22] >> mysql_free_result( Connection handle: 1 )
[23:12:22] CMySQLHandler::FreeResult() - Result was successfully free'd.
[23:12:32] >> mysql_real_escape_string( Connection handle: 1 )
[23:12:32] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
[23:12:32] >> mysql_query( Connection handle: 1 )
[23:12:32] CMySQLHandler::Query(INSERT INTO playerdata (user, password, DriftingPoints, Cash, VipLevel, AdminLevel, Kills, Deaths, Locked, Number, Wanted, Gun1, Gun2, Gun3, Gun4, Gun5, Gun6, Gun7, Gun8, Gun9, Gun10, Gun11, Gun12, Ammo1, Ammo2, Ammo3, Ammo4, Ammo5, Ammo6, Ammo7, Ammo8, Ammo9, Ammo10, Ammo11, Ammo12, IP) VALUES('Danyal', SHA1('123456'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Not Banned')) - An error has occured. (Error ID: 1036, Table 'playerdata' is read only) 
I solved that problem but now player data isn't saved in DATABASE
Find
Reply
Scenario
Godfather
*****
Posts: 7,801
Threads: 187
Joined: Feb 2010
Reputation: 0
#7

11.02.2012, 17:43
Quote:

Table 'playerdata' is read only
You have set something up incorrectly in the database.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help