Jump to content
  • 0

Ajutor MySQL Save player


AsSsASIN

Question

Recommended Posts

[19:16:27] MySQL Debugging activated (02/21/11)

[19:16:27] ---------------------------

[19:16:27] 

[19:47:32] >> mysql_real_escape_string( Connection handle: 1 )

[19:47:32] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[19:47:32] >> mysql_query( Connection handle: 1 )

[19:47:32] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed.

[19:47:32] >> mysql_store_result( Connection handle: 1 )

[19:47:32] CMySQLHandler::StoreResult() - Result was stored.

[19:47:32] >> mysql_num_rows( Connection handle: 1 )

[19:47:32] CMySQLHandler::NumRows() - Returned 0 row(s)

[19:47:37] >> mysql_real_escape_string( Connection handle: 1 )

[19:47:37] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[19:47:37] >> mysql_real_escape_string( Connection handle: 1 )

[19:47:37] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******.

[19:47:37] >> mysql_query( Connection handle: 1 )

[19:47:37] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed.

[19:47:38] >> mysql_query( Connection handle: 1 )

[19:47:38] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed.

[19:47:38] >> mysql_store_result( Connection handle: 1 )

[19:47:38] CMySQLHandler::StoreResult() - Result was stored.

[19:47:38] >> mysql_fetch_row_format( Connection handle: 1 )

[19:47:39] >> mysql_query( Connection handle: 1 )

[19:47:39] CMySQLHandler::Query(SELECT Password FROM players WHERE id = 0 LIMIT 1) - Successfully executed.

[19:47:39] >> mysql_store_result( Connection handle: 1 )

[19:47:39] CMySQLHandler::StoreResult() - Result was stored.

[19:47:39] >> mysql_fetch_row_format( Connection handle: 1 )

[19:47:39] >> mysql_query( Connection handle: 1 )

[19:47:39] CMySQLHandler::Query(SELECT * FROM players WHERE id = 0 LIMIT 1) - Successfully executed.

[19:47:39] >> mysql_store_result( Connection handle: 1 )

[19:47:39] CMySQLHandler::StoreResult() - Result was stored.

[19:47:39] >> mysql_fetch_row_format( Connection handle: 1 )

[19:47:39] >> mysql_free_result( Connection handle: 1 )

[19:47:39] CMySQLHandler::FreeResult() - Result was successfully free'd.

[19:49:28] >> mysql_query( Connection handle: 1 )

[19:49:28] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.

[19:50:07] >> mysql_query( Connection handle: 1 )

[19:50:07] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.

[19:55:20] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[19:55:20] CMySQLHandler::FreeResult() - The result is already empty.

[19:55:20] CMySQLHandler::Disconnect() - Connection was closed.

Link to comment
Share on other sites

[19:49:28] CMySQLHandler::Query(UPDATE `players` SET `Level` = '1', `AdminLevel` = '0', `DonateRank` = '0', `PointsUpgrade` = '0', `ConnectTime` = '101', `Reg` = '77', `Sex` = '77' WHERE `username` = 'Multiple users found, please narrow earch';) - Successfully executed.

La `username` ar trebui sa fie nickul tau.

Link to comment
Share on other sites

Noua syntaxa

public SavePlayerData(playerid)
{
	new query[700];
	format(query, 700, "UPDATE players SET password=%s, Admin=%d WHERE username=%s", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid));
    mysql_query(query);
	return 1;
}

.. si zice eroare din mysql ca syntaxa e gresita, problema?

Link to comment
Share on other sites

Esti stresant.

valorile se pun sub ' ' iar alea dinantea' lui egal(am uitat cum se numesc,raceala) cu ` ` .Deci prin urmare

format(query, 700, "UPDATE players SET `password`='%s', `Admin`='%d' WHERE `username`='%s'", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid));

pPassword trebuie sa fie string( pPassword[30])

pAdmin trebuie sa fie integer( pAdmin)

Astea in gm.

Link to comment
Share on other sites

Tot incerc, si iar incerc, defapt am rezolvat cu salvarea, dar parola nu se salveaza cum trebuie ...


public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    new tmppass[64],loginstring[256],loginname[64],regstring[256];
    GetPlayerName(playerid,loginname,sizeof(loginname));
	if(response) {
        if(dialogid == 1) {
            if(strlen(inputtext)) {
                //Encrypt(tmppass);
				strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
                OnPlayerLogin(playerid,tmppass);
            } else {
                format(loginstring,sizeof(loginstring),"{FF0000}WRONG PASSWORD!! {FFFFFF}please write the correct password.",loginname);
                ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",loginstring,"Login", "");
            }
        }
        if(dialogid == 2) {
            if(strlen(inputtext)) {
                //Encrypt(tmppass);
				strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
				OnPlayerRegister(playerid,tmppass);
            } else {
                format(regstring,sizeof(regstring),"{FFFFFF}Welcome on {0000FF}eXtrike Federation{FFFFFF}.\n{FFFFFF}What's up {0000FF}%s{FFFFFF}? Please enter your password.",loginname);
                ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"{FFFFFF}Login to the server.",regstring,"Register", "");
            }
        }
	    return 1;
    }
    return 1;
}

public SavePlayerData(playerid)
{
	new query[700];
	format(query, 700, "UPDATE `players` SET `password` ='%s', `Admin` ='%d' WHERE `username` ='%s' ", PlayerInfo[playerid][pPassword], PlayerInfo[playerid][pAdmin], ReturnName(playerid));
    mysql_query(query);
	return 1;
}

[14:12:09] MySQL Debugging activated (02/24/11)

[14:12:09] ---------------------------

[14:12:09]  

[14:12:44] >> mysql_real_escape_string( Connection handle: 1 )

[14:12:44] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[14:12:44] >> mysql_query( Connection handle: 1 )

[14:12:44] CMySQLHandler::Query(SELECT id FROM players WHERE LOWER(username) = LOWER('exDDD') LIMIT 1) - Successfully executed.

[14:12:44] >> mysql_store_result( Connection handle: 1 )

[14:12:44] CMySQLHandler::StoreResult() - Result was stored.

[14:12:44] >> mysql_num_rows( Connection handle: 1 )

[14:12:44] CMySQLHandler::NumRows() - Returned 0 row(s)

[14:12:50] >> mysql_real_escape_string( Connection handle: 1 )

[14:12:50] CMySQLHandler::EscapeString(exDDD); - Escaped 5 characters to exDDD.

[14:12:50] >> mysql_real_escape_string( Connection handle: 1 )

[14:12:50] CMySQLHandler::EscapeString(******); - Escaped 6 characters to ******.

[14:12:50] >> mysql_query( Connection handle: 1 )

[14:12:50] CMySQLHandler::Query(INSERT INTO players (username, password) VALUES ('exDDD', '******')) - Successfully executed.

[14:12:54] >> mysql_query( Connection handle: 1 )

[14:12:54] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:12:54] >> mysql_store_result( Connection handle: 1 )

[14:12:54] CMySQLHandler::StoreResult() - Result was stored.

[14:12:54] >> mysql_fetch_row_format( Connection handle: 1 )

[14:12:55] >> mysql_query( Connection handle: 1 )

[14:12:55] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:12:55] >> mysql_store_result( Connection handle: 1 )

[14:12:55] CMySQLHandler::StoreResult() - Result was stored.

[14:12:55] >> mysql_fetch_row_format( Connection handle: 1 )

[14:13:04] >> mysql_query( Connection handle: 1 )

[14:13:04] CMySQLHandler::Query(SELECT password FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:13:04] >> mysql_store_result( Connection handle: 1 )

[14:13:04] CMySQLHandler::StoreResult() - Result was stored.

[14:13:04] >> mysql_fetch_row_format( Connection handle: 1 )

[14:13:04] >> mysql_query( Connection handle: 1 )

[14:13:04] CMySQLHandler::Query(SELECT * FROM players WHERE id = 104 LIMIT 1) - Successfully executed.

[14:13:04] >> mysql_store_result( Connection handle: 1 )

[14:13:04] CMySQLHandler::StoreResult() - Result was stored.

[14:13:04] >> mysql_fetch_row_format( Connection handle: 1 )

[14:13:04] >> mysql_free_result( Connection handle: 1 )

[14:13:04] CMySQLHandler::FreeResult() - Result was successfully free'd.

[14:13:34] >> mysql_query( Connection handle: 1 )

[14:13:34] CMySQLHandler::Query(UPDATE `players` SET `password` ='**:***', `Admin` ='1338' WHERE `username` ='exDDD' ) - Successfully executed.

[14:14:13] >> mysql_close( Connection handle: 1 )

[14:14:13] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[14:14:13] CMySQLHandler::FreeResult() - The result is already empty.

[14:14:13] CMySQLHandler::Disconnect() - Connection was closed.

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.