Neįrašo į lentelę duomenų [ mySQL ]

[example']

Labas, kažkodėl tai neįrašo į lentelę duomenų...

[11:45:25] ---------------------------

[11:45:25] MySQL Debugging activated (08/20/14)

[11:45:25] ---------------------------

[11:45:25]  

[11:45:25] >> mysql_connect( )

[11:45:25] CMySQLHandler::CMySQLHandler() - constructor called.

[11:45:25] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "boneFierro" | Username: "root" ...

[11:45:25] CMySQLHandler::Connect() - Connection was successful.

[11:45:25] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[11:45:25] >> mysql_ping( Connection handle: 1 )

[11:45:25] CMySQLHandler::Ping() - Connection is still alive.

[11:45:47] >> mysql_query( Connection handle: 1 )

[11:45:47] CMySQLHandler::Query(SELECT * FROM `players` WHERE Vardas = 'Ryan' ) - Successfully executed.

[11:45:47] >> mysql_store_result( Connection handle: 1 )

[11:45:47] CMySQLHandler::StoreResult() - Result was stored.

[11:45:47] >> mysql_num_rows( Connection handle: 1 )

[11:45:47] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:45:56] >> mysql_query( Connection handle: 1 )

[11:45:56] CMySQLHandler::Query(SELECT * FROM players WHERE Vardas='Ryan' AND Slaptazodis='7D90DD820EAEF8AD57C09F3E4164DE32') - Successfully executed.

[11:45:56] >> mysql_store_result( Connection handle: 1 )

[11:45:56] CMySQLHandler::StoreResult() - Result was stored.

[11:45:56] >> mysql_num_rows( Connection handle: 1 )

[11:45:56] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:45:56] >> mysql_free_result( Connection handle: 1 )

[11:45:56] CMySQLHandler::FreeResult() - Result was successfully free'd.

būtent tik trijų dalykų: po registracijos regDate - 0.0.0 0:0:0

lastIP - tuščia

lastOnline - tuščia

if( response )
			{
				new query [ 128 ];
				if( strlen( inputtext ) < 5 )
				{
					SendClientMessage( playerid, 0xFF0000FF, "• Slaptažodis turi būti sudarytas bent iš 5 simbolių!" ) ;
					ShowPlayerDialog( playerid, 1 , DIALOG_STYLE_PASSWORD, "{ffffff}» REGISTRACIJA", "{ffffff}Sveiki atvykę į serverį\nNorėdami pradėti žaisti, įrašykite slaptažodį, kurį naudosite žaidime:", "Registruotis", "Atšaukti" ) ;
				}
				else
				{
					new 
						regDatas [ 50 ] , 
						data [ 6 ],
						msg [ 246 ]
					;
					format ( regDatas , sizeof ( regDatas ) , "%d-%.02d-%.02d %.02d:%.02d:%.02d" , data [ 3 ] , data [ 4 ] , data [ 5 ] , data [ 0 ] , data [ 1 ] , data [ 2 ] ) ;
					format( query, sizeof(query), "INSERT INTO players (Vardas, Slaptazodis, regDate) VALUES ( '%s', '%s', '%s' )", playerName ( playerid ) , MD5_Hash(inputtext), regDatas ) ;
					mysql_query( query ) ;
					format( msg, sizeof ( msg ), "• Slaptažodis nustatytas: %s", inputtext );
					SendClientMessage(playerid, GREEN, msg ) ;
					ShowPlayerDialog( playerid, 2, DIALOG_STYLE_INPUT, "{FF9900}» El. pašto nustatymas", "{FF9900}Sveiki,\n \n{FFFFFF}Jums reikia įvesti savo elektroninio pašto adresą. Kodėl?\nTam, kad jeigu pamiršite slaptažodį, jis bus greitai jums sugrąžintas.\n \n{FF0000}Prašome įvesti el.pašto adresą( [email protected] ):\nLAUKELIS NEGALI BŪTI TUŠČIAS!", "Patvirtinti", "" );
					registerd [ playerid ] = true;
					online [ playerid ] = true;
				}
			}

function: savePlayerData( playerid )
{
	if( login[ playerid ] && registerd[ playerid ] )
	{
		new zQuery[350], Float:gpPos[3], data [ 6 ] , lastDat [ 50 ];
		GetPlayerPos(playerid, gpPos[0], gpPos[1], gpPos[2]);
		gettime ( data [ 0 ] , data [ 1 ] , data [ 2 ] ) ;
		getdate ( data [ 3 ] , data [ 4 ] , data [ 5 ] ) ;
		format ( lastDat , sizeof ( lastDat ) , "%0.2d-%0.2d-%0.2d %0.2d:%0.2d:%0.2d" , data [ 3 ] , data [ 4 ] , data [ 5 ] , data [ 0 ] , data [ 1 ] , data [ 2 ] );
		format ( zQuery , sizeof ( zQuery ) , "UPDATE `players` SET lastIP = '%s', lastOnline = '%s' WHERE Vardas = '%s'" , playerIp ( playerid ) , lastDat , playerName ( playerid ) ) ;
		mysql_query ( zQuery ) ;
		format(zQuery, sizeof(zQuery), "UPDATE `players` SET `pos_X` = '%f', `pos_Y` = '%f', pos_Z = '%f', `exp` = '%d', `litai` = '%d' WHERE `Vardas` = '%s'", gpPos[0], gpPos[1],gpPos[2],user.playerid[ exp ],user.playerid[ moneyPocket ], playerName(playerid));
		mysql_query(zQuery);
		format( zQuery, sizeof( zQuery ), "UPDATE `players` SET admin = '%d', vip = '%d' WHERE Vardas = '%s'", user.playerid[ admin ], user.playerid[ vip ], playerName( playerid ) ) ;
		mysql_query(zQuery);

		printf( "[ SAVE ] %s žaidėjas išsaugomas .", playerName( playerid ) ) ;
	}
	return 1 ;
}

function: loadPlayerData( playerid )
{
	if( login[ playerid ] && registerd[ playerid ] )
	{
		if(!IsPlayerConnected(playerid)) return 1;
		new Float:gpPos[3], lQuery[100],aaaaa[500];
	 	format(lQuery, sizeof(lQuery), "SELECT * FROM `players` WHERE `Vardas` = '%s'", playerName(playerid));
		mysql_query(lQuery);
		mysql_store_result();

		if(mysql_num_rows() != 0)
		{
		    mysql_fetch_row(aaaaa);
		    mysql_fetch_field_row ( lQuery , "lastOnline" ) ; format ( playerDB [ playerid ] [ lastOnline ] , 50 , "%s" , lQuery ) ;
			mysql_fetch_field_row ( lQuery , "lastIP" ) ; format ( playerDB [ playerid ] [ lastIP ] , 17 , "%s" , lQuery ) ;
			mysql_fetch_field_row(lQuery, "exp"); SetPlayerScore(playerid, strval(lQuery));
			mysql_fetch_field_row(lQuery, "moneyPocket"); SetPlayerVirtualWorld(playerid, strval(lQuery));
			mysql_fetch_field_row(lQuery, "vip"); playerDB[playerid][vip] = !!strval(lQuery);
			mysql_fetch_field_row(lQuery, "admin"); playerDB[playerid][admin] = strval(lQuery);
			mysql_fetch_field_row(lQuery, "pos_X"); gpPos[0] = floatstr(lQuery);
			mysql_fetch_field_row(lQuery, "pos_Y"); gpPos[1] = floatstr(lQuery);
			mysql_fetch_field_row(lQuery, "pos_Z"); gpPos[2] = floatstr(lQuery);
		    SetPlayerPos(playerid, gpPos[0], gpPos[1], gpPos[2]+1);
		}
		mysql_free_result();

		printf( "[ LOAD ] %s žaidėjas pakraunamas .", playerName( playerid ) ) ;
	}
	return 1 ;
}

[example']

Viską susitvarkiau, rakinam temą.

Redaguota Rugpjūčio 20, 2014, nario M. J.