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

Threaded Mode
Help MySql Problem
ElectricBox
Little Clucker
**
Posts: 16
Threads: 6
Joined: Oct 2012
Reputation: 0
#1

12.01.2013, 10:43
im using g stylez mysql r6 version but every time i login my server shutdown any idea here is the login function

pawn Код:
if(dialogid == log)
    {

        if(!response){
        Quited[playerid] = 1;
        Kick(playerid);
        return 1;
        }

        if (strlen(inputtext)==0){
        ShowPlayerDialog(playerid,log,DIALOG_STYLE_INPUT,"{008000}Login","{FFFFFF}You did not enter password!\nPlease enter password below to login","Login","Cancel");
        return 1;
        }
        new escpass[100];
        mysql_real_escape_string(inputtext,escpass);
        format(MySql_Query,sizeof(MySql_Query),"SELECT * FROM `playerdata` WHERE `name`='%s' AND `password`='%s'",PlayerName(playerid),escpass);
        mysql_query(MySql_Query);
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
        MySql_Login(playerid);
        Load_ACH(playerid);
        }
        else
        if(!mysql_num_rows())
        {
        ShowPlayerDialog(playerid,log,DIALOG_STYLE_INPUT,"{008000}Login","{FF0000}Wrong Password!\n{FFFFFF}Please enter right password below to login","Login","Cancel");
        }
        mysql_free_result();
    }

pawn Код:
stock MySql_Login(playerid)
{
    new pname[24], savingstring[20];
    GetPlayerName(playerid, pname, 24);
    format(MySql_Query, sizeof(MySql_Query), "SELECT * FROM `playerdata` WHERE `name` = '%s'", PlayerName(playerid));
    mysql_query(MySql_Query);
    mysql_store_result();
    while(mysql_fetch_row_format(MySql_Query,"|"))
    {
    mysql_fetch_field_row(savingstring, "money"); SafeGivePlayerMoney(playerid,strval(savingstring));
    mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid,strval(savingstring));
    mysql_fetch_field_row(savingstring, "robrank"); robberrank[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "jailed"); Jailed[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "jailtime"); JailTime[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "raperank"); raperrank[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "arrestrank"); arrestranks[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "swatranks"); swatranks[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "copranks"); copranks[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "pvtlaw"); pvtlaw[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "armyranks"); armyranks[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "tazeranks"); tazerank[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "hitmanrank"); hitmanranks[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "takeddownrank"); takesdownranks[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "weapsdealer"); weapondealer[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "salesdealer"); itemsdealer[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "medicrank"); medic[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "mechanicrank"); mechanic[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "canusearmy"); CanUseArmy[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "canuseswat"); CanUseSwat[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "swatcommander"); SwatCommander[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "armycommander"); ArmyCommander[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "adminlevel"); PlayerAdminLevel[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "accountlocked"); AccountLocked[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "bankcash"); BankCash[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "AirPortOwner");  AirPortOwner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "BoatOwner"); BoatOwner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "SFBoatOwner"); SFBoatOwner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "DrugHouseOwner"); DrugHouseOwner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "grottiowner"); grottiowner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "autobahnowner"); autobahnowner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "uttoautoowner"); uttoautoowner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "coutowner"); couttowner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "wangsowner"); wangsowner[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "cashinsured"); BankRobInsurance[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "warnings"); Warned[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "ircwarnings"); IRCWarned[playerid]=strval(savingstring);
    mysql_fetch_field_row(savingstring, "RegAsAdmin"); RegAsAdmin[playerid] =strval(savingstring);
    mysql_fetch_field_row(savingstring, "KickWarn"); KickWarn[playerid] =strval(savingstring);
    SystemMsg(playerid,"You are now logged in. Your stats will be auto-saved when you disconnect");
    PLAYERLIST_authed[playerid]=true;
 }
    mysql_free_result();

    new IP[30];
    GetPlayerIp(playerid, IP, 30);
    format(MySql_Query, sizeof(MySql_Query), "UPDATE playerdata SET playerIP='%s' WHERE name='%s'", IP, PlayerName(playerid));
    mysql_query(MySql_Query);
    return 1;
}
Find
Reply
ElectricBox
Little Clucker
**
Posts: 16
Threads: 6
Joined: Oct 2012
Reputation: 0
#2

12.01.2013, 11:49
Please guyes little help here is mysql debug


pawn Код:
[16:08:10]  
[16:08:10] ---------------------------
[16:08:10] MySQL Debugging activated (01/12/13)
[16:08:10] ---------------------------
[16:08:10]  
[16:08:10] >> mysql_connect( )
[16:08:10] CMySQLHandler::CMySQLHandler() - constructor called.
[16:08:10] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "db68" | Username: "db68" ...
[16:08:10] CMySQLHandler::Connect() - Connection was successful.
[16:08:10] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[16:08:10] >> mysql_ping( Connection handle: 1 )
[16:08:10] CMySQLHandler::Ping() - Connection is still alive.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS logs(Event VARCHAR(30), Details VARCHAR(128))) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS vehicles(DatabaseID INT(20),Owner VARCHAR(20), Model INT(20), PosX INT(20), PosY INT(20), PosZ INT(20), PosA INT(20), Damage INT(20), Color1 INT(20), Color2 INT(20)) ) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS adminsdata(AdminName VARCHAR(30),LoginPassword INT(20),AdminRanks INT(20))) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS playerdata(name VARCHAR(30), password VARCHAR(30), playerIP INT(20), money INT(20), bankcash INT(20),cashinsured INT(20),grottiowner INT(20),autobahnowner INT(20),uttoautoowner INT(20),coutowner INT(20),wangsowner INT(20),score INT(20),jailed INT(20),wallet INT(20),crock INT(20),drugs INT(20),drugbagy INT(20), onlinehours INT(20) , onlineminutes INT(20) , onlineseconds INT(20), arrestrank INT(20) ,adminlevel INT(20),copranks INT(20),robrank INT(20),warnings INT(20),KickWarn INT(20),ircwarnings INT(20),jailtime INT(20),nameban INT(20),accountlocked INT(20),canusearmy INT(20),canuseswat INT(20),swatcommander INT(20),armycommander INT(20),AirPortOwner INT(20),BoatOwner INT(20),SFBoatOwner INT(20),DrugHouseOwner INT(20),RegAsAdmin INT(20), raperank INT(20), weapsdealer INT(20), salesdealer INT(20)  ,swatranks INT(20),medicrank INT(20), mechanicrank INT(20), pvtlaw INT(20), armyranks INT(20),hitmanrank INT(20), tazeranks INT(20), takeddownrank INT(20))) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS achdata(name VARCHAR(30),ach1 INT(20),ach2 INT(20),ach3 INT(20),ach4 INT(20),ach5 INT(20),ach6 INT(20),ach7 INT(20),ach8 INT(20),ach9 INT(20),ach10 INT(20),ach11 INT(20),ach12 INT(20),ach13 INT(20)) ) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS bansdata(BannedName VARCHAR(30),AdminName VARCHAR(30),Reason VARCHAR(128),BannedIP INT(20)) ) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS housesdata(`id` INT(20)) ) - Successfully executed.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(SELECT * FROM `vehicles`) - Successfully executed.
[16:08:10] >> mysql_store_result( Connection handle: 1 )
[16:08:10] CMySQLHandler::StoreResult() - Result was stored.
[16:08:10] >> mysql_num_rows( Connection handle: 1 )
[16:08:10] CMySQLHandler::NumRows() - Returned 0 row(s)
[16:08:10] >> mysql_free_result( Connection handle: 1 )
[16:08:10] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:10] >> mysql_query( Connection handle: 1 )
[16:08:10] CMySQLHandler::Query(SELECT * FROM `housesdata` WHERE `id` < 500) - Successfully executed.
[16:08:10] >> mysql_store_result( Connection handle: 1 )
[16:08:10] CMySQLHandler::StoreResult() - Result was stored.
[16:08:10] >> mysql_retrieve_row( Connection handle: 1 )
[16:08:10] >> mysql_free_result( Connection handle: 1 )
[16:08:10] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:12] >> mysql_free_result( Connection handle: 1 )
[16:08:12] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:12] >> mysql_free_result( Connection handle: 1 )
[16:08:12] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:12] >> mysql_free_result( Connection handle: 1 )
[16:08:12] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:12] >> mysql_free_result( Connection handle: 1 )
[16:08:12] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:13] >> mysql_free_result( Connection handle: 1 )
[16:08:13] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:13] >> mysql_free_result( Connection handle: 1 )
[16:08:13] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:14] >> mysql_free_result( Connection handle: 1 )
[16:08:15] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:15] >> mysql_free_result( Connection handle: 1 )
[16:08:15] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:15] >> mysql_free_result( Connection handle: 1 )
[16:08:15] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:16] >> mysql_free_result( Connection handle: 1 )
[16:08:16] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:16] >> mysql_free_result( Connection handle: 1 )
[16:08:16] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:17] >> mysql_free_result( Connection handle: 1 )
[16:08:17] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:17] >> mysql_free_result( Connection handle: 1 )
[16:08:17] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:17] >> mysql_free_result( Connection handle: 1 )
[16:08:17] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:18] >> mysql_free_result( Connection handle: 1 )
[16:08:18] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:18] >> mysql_free_result( Connection handle: 1 )
[16:08:18] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:19] >> mysql_free_result( Connection handle: 1 )
[16:08:19] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:19] >> mysql_free_result( Connection handle: 1 )
[16:08:19] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:20] >> mysql_free_result( Connection handle: 1 )
[16:08:20] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:20] >> mysql_free_result( Connection handle: 1 )
[16:08:20] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:21] >> mysql_free_result( Connection handle: 1 )
[16:08:21] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:21] >> mysql_free_result( Connection handle: 1 )
[16:08:22] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:22] >> mysql_free_result( Connection handle: 1 )
[16:08:22] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:22] >> mysql_free_result( Connection handle: 1 )
[16:08:22] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:23] >> mysql_free_result( Connection handle: 1 )
[16:08:23] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:23] >> mysql_free_result( Connection handle: 1 )
[16:08:23] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:23] >> mysql_free_result( Connection handle: 1 )
[16:08:23] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:24] >> mysql_free_result( Connection handle: 1 )
[16:08:24] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:25] >> mysql_free_result( Connection handle: 1 )
[16:08:25] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:25] >> mysql_free_result( Connection handle: 1 )
[16:08:25] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:25] >> mysql_free_result( Connection handle: 1 )
[16:08:25] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:26] >> mysql_free_result( Connection handle: 1 )
[16:08:26] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:26] >> mysql_free_result( Connection handle: 1 )
[16:08:26] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:27] >> mysql_free_result( Connection handle: 1 )
[16:08:27] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:27] >> mysql_free_result( Connection handle: 1 )
[16:08:27] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:28] >> mysql_free_result( Connection handle: 1 )
[16:08:28] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:28] >> mysql_free_result( Connection handle: 1 )
[16:08:28] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:28] >> mysql_free_result( Connection handle: 1 )
[16:08:29] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:29] >> mysql_free_result( Connection handle: 1 )
[16:08:29] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:30] >> mysql_free_result( Connection handle: 1 )
[16:08:30] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:30] >> mysql_free_result( Connection handle: 1 )
[16:08:30] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:30] >> mysql_free_result( Connection handle: 1 )
[16:08:30] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:31] >> mysql_free_result( Connection handle: 1 )
[16:08:31] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:31] >> mysql_free_result( Connection handle: 1 )
[16:08:31] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:31] >> mysql_ping( Connection handle: 1 )
[16:08:31] CMySQLHandler::Ping() - Connection is still alive.
[16:08:31] >> mysql_query( Connection handle: 1 )
[16:08:31] CMySQLHandler::Query(SELECT * FROM `playerdata` WHERE `name`='MrChips') - Successfully executed.
[16:08:31] >> mysql_store_result( Connection handle: 1 )
[16:08:31] CMySQLHandler::StoreResult() - Result was stored.
[16:08:31] >> mysql_num_rows( Connection handle: 1 )
[16:08:31] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:08:31] >> mysql_free_result( Connection handle: 1 )
[16:08:31] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:32] >> mysql_free_result( Connection handle: 1 )
[16:08:32] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:32] >> mysql_query( Connection handle: 1 )
[16:08:32] CMySQLHandler::Query(SELECT onlinehours, onlineminutes, onlineseconds FROM playerdata WHERE name = 'MrChips') - Successfully executed.
[16:08:32] >> mysql_store_result( Connection handle: 1 )
[16:08:32] CMySQLHandler::StoreResult() - Result was stored.
[16:08:32] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:32] CMySQLHandler::FetchRow() - Return: 0|0|11
[16:08:32] >> mysql_query( Connection handle: 1 )
[16:08:32] CMySQLHandler::Query(UPDATE playerdata SET on‌linehours = '0' , on‌lineminutes = '0' , on‌lineseconds = '12' WHERE name = 'MrChips') - Successfully executed.
[16:08:32] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:32] >> mysql_free_result( Connection handle: 1 )
[16:08:32] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:32] >> mysql_free_result( Connection handle: 1 )
[16:08:32] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:33] >> mysql_free_result( Connection handle: 1 )
[16:08:33] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:33] >> mysql_free_result( Connection handle: 1 )
[16:08:33] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:33] >> mysql_query( Connection handle: 1 )
[16:08:33] CMySQLHandler::Query(SELECT onlinehours, onlineminutes, onlineseconds FROM playerdata WHERE name = 'MrChips') - Successfully executed.
[16:08:33] >> mysql_store_result( Connection handle: 1 )
[16:08:33] CMySQLHandler::StoreResult() - Result was stored.
[16:08:33] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:33] CMySQLHandler::FetchRow() - Return: 0|0|12
[16:08:33] >> mysql_query( Connection handle: 1 )
[16:08:33] CMySQLHandler::Query(UPDATE playerdata SET onlinehours = '0' , onlineminutes = '0' , onlineseconds = '13' WHERE name = 'MrChips') - Successfully executed.
[16:08:33] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:33] >> mysql_free_result( Connection handle: 1 )
[16:08:33] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:34] >> mysql_free_result( Connection handle: 1 )
[16:08:34] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:34] >> mysql_query( Connection handle: 1 )
[16:08:34] CMySQLHandler::Query(SELECT onlinehours, onlineminutes, onlineseconds FROM playerdata WHERE name = 'MrChips') - Successfully executed.
[16:08:34] >> mysql_store_result( Connection handle: 1 )
[16:08:34] CMySQLHandler::StoreResult() - Result was stored.
[16:08:34] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:34] CMySQLHandler::FetchRow() - Return: 0|0|13
[16:08:34] >> mysql_query( Connection handle: 1 )
[16:08:34] CMySQLHandler::Query(UPDATE playerdata SET on‌linehours = '0' , on‌lineminutes = '0' , on‌lineseconds = '14' WHERE name = 'MrChips') - Successfully executed.
[16:08:34] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:34] >> mysql_free_result( Connection handle: 1 )
[16:08:34] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:34] >> mysql_free_result( Connection handle: 1 )
[16:08:34] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:34] >> mysql_free_result( Connection handle: 1 )
[16:08:34] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:35] >> mysql_free_result( Connection handle: 1 )
[16:08:35] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:35] >> mysql_query( Connection handle: 1 )
[16:08:35] CMySQLHandler::Query(SELECT onlinehours, onlineminutes, onlineseconds FROM playerdata WHERE name = 'MrChips') - Successfully executed.
[16:08:35] >> mysql_store_result( Connection handle: 1 )
[16:08:35] CMySQLHandler::StoreResult() - Result was stored.
[16:08:35] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:35] CMySQLHandler::FetchRow() - Return: 0|0|14
[16:08:35] >> mysql_query( Connection handle: 1 )
[16:08:35] CMySQLHandler::Query(UPDATE playerdata SET onlinehours = '0' , onlineminutes = '0' , onlineseconds = '15' WHERE name = 'MrChips') - Successfully executed.
[16:08:35] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:35] >> mysql_free_result( Connection handle: 1 )
[16:08:35] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:36] >> mysql_free_result( Connection handle: 1 )
[16:08:36] CMySQLHandler::FreeResult() - The result is already empty.
[16:08:36] >> mysql_real_escape_string( Connection handle: 1 )
[16:08:36] CMySQLHandler::EscapeString(amir1123411211); - Escaped 14 characters to amir1123411211.
[16:08:36] >> mysql_query( Connection handle: 1 )
[16:08:36] CMySQLHandler::Query(SELECT * FROM `playerdata` WHERE `name`='MrChips' AND `password`='amir1123411211') - Successfully executed.
[16:08:36] >> mysql_store_result( Connection handle: 1 )
[16:08:36] CMySQLHandler::StoreResult() - Result was stored.
[16:08:36] >> mysql_num_rows( Connection handle: 1 )
[16:08:36] CMySQLHandler::NumRows() - Returned 1 row(s)
[16:08:36] >> mysql_query( Connection handle: 1 )
[16:08:36] CMySQLHandler::Query(SELECT * FROM `playerdata` WHERE `name` = 'MrChips') - Successfully executed.
[16:08:36] >> mysql_store_result( Connection handle: 1 )
[16:08:36] CMySQLHandler::StoreResult() - Result was stored.
[16:08:36] >> mysql_free_result( Connection handle: 1 )
[16:08:36] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:08:36] >> mysql_query( Connection handle: 1 )
[16:08:36] CMySQLHandler::Query(UPDATE playerdata SET playerIP='77.127.17.151' WHERE name='MrChips') - Successfully executed.
[16:08:36] >> mysql_query( Connection handle: 1 )
[16:08:36] CMySQLHandler::Query(SELECT * FROM `achdata` WHERE `name` = 'MrChips') - Successfully executed.
[16:08:36] >> mysql_store_result( Connection handle: 1 )
[16:08:36] CMySQLHandler::StoreResult() - Result was stored.
[16:08:36] >> mysql_fetch_row_format( Connection handle: 1 )
[16:08:36] CMySQLHandler::FetchRow() - Return: MrChips|0|0|0|0|0|0|0|0|0|0|0|0|0
[16:08:36] >> mysql_fetch_field_row( Connection handle: 1 )
Find
Reply
ElectricBox
Little Clucker
**
Posts: 16
Threads: 6
Joined: Oct 2012
Reputation: 0
#3

12.01.2013, 15:16
helllo people ?
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