Nesaugo mySQL domenų.

[evanas1]

Sveiki, šendien susirišau savo modą, su mySQL, pas mane visko turi daug ko sugoti, bet aš padariau, kad saugotu ten pinigus, xp ir pnš, paprastus dalykus. Viską padariau, bet kai prisijungiu xp, lt būną 0, ir pozicijos nesaugo, tiesiog krentu iš dangaus.

Mano kodas : saugojimas/krovimas

 

Saugojimas:

SaugomZaideja(playerid)
{
	if(zInfo[ playerid ][zaidzia] == 3)
	{
	new query[512],name[MAX_PLAYER_NAME];
	new Float:coo[3],weps[2][12];
	GetPlayerName( playerid,name,sizeof(name));
	GetPlayerPos( playerid,coo[0],coo[1],coo[2]);
	format(query, sizeof(query), "UPDATE zaidejai SET pos_X = %f, pos_Y = %f, pos_Z = %f, world = %i, star = %i, pinigai = %i, patirtis %i, interior = %i, pos_X = %f, pos_Y = %f, pos_Z = %f WHERE vardas = '%s'",
	coo[0],
	coo[1],
	coo[2],
	GetPlayerVirtualWorld(playerid),
	GetPlayerWantedLevel(playerid),
	GetPlayerMoneyA(playerid),
	GetPlayerScore(playerid),
	GetPlayerInterior(playerid),
	name
	);
	mysql_query(query);
	}
}

Krovimas:

KraunamZaideja(playerid)
{
	new name[MAX_PLAYER_NAME],query[256], Float:pos[3], fetch[20];
	GetPlayerName( playerid,name,sizeof(name));
	format(query, sizeof(query), "SELECT * FROM zaidejai WHERE Vardas = '%s'", name);
	mysql_query(query);
	mysql_store_result();
	while(mysql_retrieve_row())
	{
 	mysql_fetch_field_row(fetch,"pinigai");
	GivePlayerMoneyA( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"patirtis");
	SetPlayerScore( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"world");
	SetPlayerVirtualWorld( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"star");
	SetPlayerWantedLevel( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"pos_X");
	pos[0] = floatstr(fetch);
	mysql_fetch_field_row(fetch,"pos_Y");
	pos[1] = floatstr(fetch);
	mysql_fetch_field_row(fetch,"pos_Z");
	pos[2] = floatstr(fetch);
	SetPlayerPos( playerid, pos[0], pos[1], pos[2]);
	}
	mysql_free_result(); 
	return 1;
	}

[Virsenas]

mysql_log parodyk.

[evanas1]

[14:26:12]  

[14:26:12] ---------------------------

[14:26:12] MySQL Debugging activated (06/20/14)

[14:26:12] ---------------------------

[14:26:12]  

[14:26:12] >> mysql_connect( )

[14:26:12] CMySQLHandler::CMySQLHandler() - constructor called.

[14:26:12] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sqlz" | Username: "root" ...

[14:26:12] CMySQLHandler::Connect() - Connection was successful.

[14:26:12] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[14:26:12] >> mysql_ping( Connection handle: 1 )

[14:26:12] CMySQLHandler::Ping() - Connection is still alive.

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

[14:27:04] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_White') - Successfully executed.

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

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

[14:27:04] >> mysql_num_rows( Connection handle: 1 )

[14:27:04] CMySQLHandler::NumRows() - Returned 0 row(s)

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

[14:27:04] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

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

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

[14:27:04] >> mysql_num_rows( Connection handle: 1 )

[14:27:04] CMySQLHandler::NumRows() - Returned 0 row(s)

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

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

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

[14:27:12] CMySQLHandler::Query(INSERT INTO zaidejai (vardas, pass) VALUES ('Evans_White', 'logitech')) - An error has occured. (Error ID: 1054, Unknown column 'pass' in 'field list')

[14:27:25] >> mysql_query( Connection handle: 1 )

[14:27:25] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_White') - Successfully executed.

[14:27:25] >> mysql_query( Connection handle: 1 )

[14:27:25] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_White') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[14:27:25] >> mysql_query( Connection handle: 1 )

[14:27:25] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2250.778320, pos_Y = -54.412296, pos_Z = 26.405620, world = 0, star = 0, pinigai = 30000, patirtis 250, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = '') - An error has occured. (Error ID: 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 '250, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = ''' at line 1)

[15:20:07]  

[15:20:07] ---------------------------

[15:20:07] MySQL Debugging activated (06/20/14)

[15:20:07] ---------------------------

[15:20:07]  

[15:20:07] >> mysql_connect( )

[15:20:07] CMySQLHandler::CMySQLHandler() - constructor called.

[15:20:07] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sqlz" | Username: "root" ...

[15:20:07] CMySQLHandler::Connect() - Connection was successful.

[15:20:07] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[15:20:07] >> mysql_ping( Connection handle: 1 )

[15:20:07] CMySQLHandler::Ping() - Connection is still alive.

[15:20:35] >> mysql_query( Connection handle: 1 )

[15:20:35] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_White') - Successfully executed.

[15:20:35] >> mysql_store_result( Connection handle: 1 )

[15:20:35] CMySQLHandler::StoreResult() - Result was stored.

[15:20:35] >> mysql_num_rows( Connection handle: 1 )

[15:20:35] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:20:35] >> mysql_query( Connection handle: 1 )

[15:20:35] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[15:20:35] >> mysql_store_result( Connection handle: 1 )

[15:20:35] CMySQLHandler::StoreResult() - Result was stored.

[15:20:35] >> mysql_num_rows( Connection handle: 1 )

[15:20:35] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:20:35] >> mysql_free_result( Connection handle: 1 )

[15:20:35] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:22:31] >> mysql_query( Connection handle: 1 )

[15:22:31] CMySQLHandler::Query(INSERT INTO zaidejai (Vardas, Slaptazodis) VALUES ('Evans_White', 'logitech')) - Successfully executed.

[15:24:41] >> mysql_query( Connection handle: 1 )

[15:24:41] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_White') - Successfully executed.

[15:24:41] >> mysql_query( Connection handle: 1 )

[15:24:41] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_White') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[15:24:41] >> mysql_query( Connection handle: 1 )

[15:24:41] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2204.214355, pos_Y = 21.585168, pos_Z = 26.548072, world = 0, star = 0, pinigai = 30200, patirtis 254, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = '') - An error has occured. (Error ID: 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 '254, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = ''' at line 1)

[15:25:09] >> mysql_query( Connection handle: 1 )

[15:25:09] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_White') - Successfully executed.

[15:25:09] >> mysql_store_result( Connection handle: 1 )

[15:25:09] CMySQLHandler::StoreResult() - Result was stored.

[15:25:09] >> mysql_num_rows( Connection handle: 1 )

[15:25:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:25:09] >> mysql_query( Connection handle: 1 )

[15:25:09] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[15:25:09] >> mysql_store_result( Connection handle: 1 )

[15:25:09] CMySQLHandler::StoreResult() - Result was stored.

[15:25:09] >> mysql_num_rows( Connection handle: 1 )

[15:25:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:25:09] >> mysql_free_result( Connection handle: 1 )

[15:25:09] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:25:13] >> mysql_query( Connection handle: 1 )

[15:25:13] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_White' AND Slaptazodis = 'logitech') - Successfully executed.

[15:25:13] >> mysql_store_result( Connection handle: 1 )

[15:25:13] CMySQLHandler::StoreResult() - Result was stored.

[15:25:13] >> mysql_retrieve_row( Connection handle: 1 )

[15:25:13] >> mysql_free_result( Connection handle: 1 )

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

[15:26:31] >> mysql_query( Connection handle: 1 )

[15:26:31] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_White') - Successfully executed.

[15:26:31] >> mysql_query( Connection handle: 1 )

[15:26:31] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_White') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[15:34:11]  

[15:34:11] ---------------------------

[15:34:11] MySQL Debugging activated (06/20/14)

[15:34:11] ---------------------------

[15:34:11]  

[15:34:11] >> mysql_connect( )

[15:34:11] CMySQLHandler::CMySQLHandler() - constructor called.

[15:34:11] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sqlz" | Username: "root" ...

[15:34:11] CMySQLHandler::Connect() - Connection was successful.

[15:34:11] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[15:34:11] >> mysql_ping( Connection handle: 1 )

[15:34:11] CMySQLHandler::Ping() - Connection is still alive.

[15:34:35] >> mysql_query( Connection handle: 1 )

[15:34:35] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_White') - Successfully executed.

[15:34:35] >> mysql_store_result( Connection handle: 1 )

[15:34:35] CMySQLHandler::StoreResult() - Result was stored.

[15:34:35] >> mysql_num_rows( Connection handle: 1 )

[15:34:35] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:34:35] >> mysql_query( Connection handle: 1 )

[15:34:35] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[15:34:35] >> mysql_store_result( Connection handle: 1 )

[15:34:35] CMySQLHandler::StoreResult() - Result was stored.

[15:34:35] >> mysql_num_rows( Connection handle: 1 )

[15:34:35] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:34:35] >> mysql_free_result( Connection handle: 1 )

[15:34:35] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:34:39] >> mysql_query( Connection handle: 1 )

[15:34:39] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_White' AND Slaptazodis = 'logitech') - Successfully executed.

[15:34:39] >> mysql_store_result( Connection handle: 1 )

[15:34:39] CMySQLHandler::StoreResult() - Result was stored.

[15:34:39] >> mysql_retrieve_row( Connection handle: 1 )

[15:34:39] >> mysql_free_result( Connection handle: 1 )

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

[15:34:39] >> mysql_query( Connection handle: 1 )

[15:34:39] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_White') - Successfully executed.

[15:34:39] >> mysql_store_result( Connection handle: 1 )

[15:34:39] CMySQLHandler::StoreResult() - Result was stored.

[15:34:39] >> mysql_retrieve_row( Connection handle: 1 )

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("pinigai") - NULL

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("patirtis") - 0

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("world") - 0

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("star") - 0

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("pos_X") - 0

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("pos_Y") - 0

[15:34:39] >> mysql_fetch_field_row( Connection handle: 1 )

[15:34:39] CMySQLHandler::FetchField("pos_Z") - 0

[15:34:39] >> mysql_retrieve_row( Connection handle: 1 )

[15:34:39] >> mysql_free_result( Connection handle: 1 )

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

[15:36:55] >> mysql_query( Connection handle: 1 )

[15:36:55] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_White') - Successfully executed.

[15:36:55] >> mysql_query( Connection handle: 1 )

[15:36:55] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_White') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[15:37:27] >> mysql_query( Connection handle: 1 )

[15:37:27] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[15:37:27] >> mysql_store_result( Connection handle: 1 )

[15:37:27] CMySQLHandler::StoreResult() - Result was stored.

[15:37:27] >> mysql_num_rows( Connection handle: 1 )

[15:37:27] CMySQLHandler::NumRows() - Returned 0 row(s)

[15:37:27] >> mysql_query( Connection handle: 1 )

[15:37:27] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[15:37:27] >> mysql_store_result( Connection handle: 1 )

[15:37:27] CMySQLHandler::StoreResult() - Result was stored.

[15:37:27] >> mysql_num_rows( Connection handle: 1 )

[15:37:27] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:37:27] >> mysql_free_result( Connection handle: 1 )

[15:37:27] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:37:33] >> mysql_query( Connection handle: 1 )

[15:37:33] CMySQLHandler::Query(INSERT INTO zaidejai (Vardas, Slaptazodis) VALUES ('Evans_Whiteas', 'logitech')) - Successfully executed.

[15:40:24] >> mysql_query( Connection handle: 1 )

[15:40:24] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_Whiteas') - Successfully executed.

[15:40:24] >> mysql_query( Connection handle: 1 )

[15:40:24] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_Whiteas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[15:40:24] >> mysql_query( Connection handle: 1 )

[15:40:24] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2341.991455, pos_Y = 106.926597, pos_Z = 25.844612, world = 0, star = 0, pinigai = 30000, patirtis 258, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = '') - An error has occured. (Error ID: 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 '258, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = ''' at line 1)

[15:41:10] >> mysql_query( Connection handle: 1 )

[15:41:10] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[15:41:10] >> mysql_store_result( Connection handle: 1 )

[15:41:10] CMySQLHandler::StoreResult() - Result was stored.

[15:41:10] >> mysql_num_rows( Connection handle: 1 )

[15:41:10] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:41:10] >> mysql_query( Connection handle: 1 )

[15:41:10] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[15:41:10] >> mysql_store_result( Connection handle: 1 )

[15:41:10] CMySQLHandler::StoreResult() - Result was stored.

[15:41:10] >> mysql_num_rows( Connection handle: 1 )

[15:41:10] CMySQLHandler::NumRows() - Returned 2 row(s)

[15:41:10] >> mysql_free_result( Connection handle: 1 )

[15:41:10] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:41:14] >> mysql_query( Connection handle: 1 )

[15:41:14] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_Whiteas' AND Slaptazodis = 'logitech') - Successfully executed.

[15:41:14] >> mysql_store_result( Connection handle: 1 )

[15:41:14] CMySQLHandler::StoreResult() - Result was stored.

[15:41:14] >> mysql_retrieve_row( Connection handle: 1 )

[15:41:14] >> mysql_free_result( Connection handle: 1 )

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

[15:41:14] >> mysql_query( Connection handle: 1 )

[15:41:14] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[15:41:14] >> mysql_store_result( Connection handle: 1 )

[15:41:14] CMySQLHandler::StoreResult() - Result was stored.

[15:41:14] >> mysql_retrieve_row( Connection handle: 1 )

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("pinigai") - NULL

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("patirtis") - 0

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("world") - 0

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("star") - 0

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("pos_X") - 0

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("pos_Y") - 0

[15:41:14] >> mysql_fetch_field_row( Connection handle: 1 )

[15:41:14] CMySQLHandler::FetchField("pos_Z") - 0

[15:41:14] >> mysql_retrieve_row( Connection handle: 1 )

[15:41:14] >> mysql_free_result( Connection handle: 1 )

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

[15:41:22] >> mysql_query( Connection handle: 1 )

[15:41:22] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_Whiteas') - Successfully executed.

[15:41:22] >> mysql_query( Connection handle: 1 )

[15:41:22] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_Whiteas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[15:41:50] >> mysql_query( Connection handle: 1 )

[15:41:50] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[15:41:50] >> mysql_store_result( Connection handle: 1 )

[15:41:50] CMySQLHandler::StoreResult() - Result was stored.

[15:41:50] >> mysql_num_rows( Connection handle: 1 )

[15:41:50] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:41:50] >> mysql_query( Connection handle: 1 )

[15:41:50] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[15:41:50] >> mysql_store_result( Connection handle: 1 )

[15:41:50] CMySQLHandler::StoreResult() - Result was stored.

[15:41:50] >> mysql_num_rows( Connection handle: 1 )

[15:41:50] CMySQLHandler::NumRows() - Returned 2 row(s)

[15:41:50] >> mysql_free_result( Connection handle: 1 )

[15:41:50] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:42:00] >> mysql_query( Connection handle: 1 )

[15:42:00] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_Whiteas' AND Slaptazodis = 'logitech') - Successfully executed.

[15:42:00] >> mysql_store_result( Connection handle: 1 )

[15:42:00] CMySQLHandler::StoreResult() - Result was stored.

[15:42:00] >> mysql_retrieve_row( Connection handle: 1 )

[15:42:00] >> mysql_free_result( Connection handle: 1 )

[15:42:00] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:42:00] >> mysql_query( Connection handle: 1 )

[15:42:00] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[15:42:00] >> mysql_store_result( Connection handle: 1 )

[15:42:00] CMySQLHandler::StoreResult() - Result was stored.

[15:42:00] >> mysql_retrieve_row( Connection handle: 1 )

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("pinigai") - NULL

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("patirtis") - 0

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("world") - 0

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("star") - 0

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("pos_X") - 0

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("pos_Y") - 0

[15:42:00] >> mysql_fetch_field_row( Connection handle: 1 )

[15:42:00] CMySQLHandler::FetchField("pos_Z") - 0

[15:42:00] >> mysql_retrieve_row( Connection handle: 1 )

[15:42:00] >> mysql_free_result( Connection handle: 1 )

[15:42:00] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:42:08] >> mysql_query( Connection handle: 1 )

[15:42:08] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_Whiteas') - Successfully executed.

[15:42:08] >> mysql_query( Connection handle: 1 )

[15:42:08] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_Whiteas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[16:33:05]  

[16:33:05] ---------------------------

[16:33:05] MySQL Debugging activated (06/20/14)

[16:33:05] ---------------------------

[16:33:05]  

[16:33:05] >> mysql_connect( )

[16:33:05] CMySQLHandler::CMySQLHandler() - constructor called.

[16:33:05] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sqlz" | Username: "root" ...

[16:33:05] CMySQLHandler::Connect() - Connection was successful.

[16:33:05] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[16:33:05] >> mysql_ping( Connection handle: 1 )

[16:33:05] CMySQLHandler::Ping() - Connection is still alive.

[16:33:32] >> mysql_query( Connection handle: 1 )

[16:33:32] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[16:33:32] >> mysql_store_result( Connection handle: 1 )

[16:33:32] CMySQLHandler::StoreResult() - Result was stored.

[16:33:32] >> mysql_num_rows( Connection handle: 1 )

[16:33:32] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:33:32] >> mysql_query( Connection handle: 1 )

[16:33:32] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[16:33:32] >> mysql_store_result( Connection handle: 1 )

[16:33:32] CMySQLHandler::StoreResult() - Result was stored.

[16:33:32] >> mysql_num_rows( Connection handle: 1 )

[16:33:32] CMySQLHandler::NumRows() - Returned 2 row(s)

[16:33:32] >> mysql_free_result( Connection handle: 1 )

[16:33:32] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:33:37] >> mysql_query( Connection handle: 1 )

[16:33:37] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_Whiteas' AND Slaptazodis = 'logitech') - Successfully executed.

[16:33:37] >> mysql_store_result( Connection handle: 1 )

[16:33:37] CMySQLHandler::StoreResult() - Result was stored.

[16:33:37] >> mysql_retrieve_row( Connection handle: 1 )

[16:33:37] >> mysql_free_result( Connection handle: 1 )

[16:33:37] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:33:37] >> mysql_query( Connection handle: 1 )

[16:33:37] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evans_Whiteas') - Successfully executed.

[16:33:37] >> mysql_store_result( Connection handle: 1 )

[16:33:37] CMySQLHandler::StoreResult() - Result was stored.

[16:33:37] >> mysql_retrieve_row( Connection handle: 1 )

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("pinigai") - NULL

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("patirtis") - 0

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("world") - 0

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("star") - 0

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("pos_X") - 0

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("pos_Y") - 0

[16:33:37] >> mysql_fetch_field_row( Connection handle: 1 )

[16:33:37] CMySQLHandler::FetchField("pos_Z") - 0

[16:33:37] >> mysql_retrieve_row( Connection handle: 1 )

[16:33:37] >> mysql_free_result( Connection handle: 1 )

[16:33:37] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:33:43] >> mysql_query( Connection handle: 1 )

[16:33:43] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evans_Whiteas') - Successfully executed.

[16:33:43] >> mysql_query( Connection handle: 1 )

[16:33:43] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evans_Whiteas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[16:34:05]  

[16:34:05] ---------------------------

[16:34:05] MySQL Debugging activated (06/20/14)

[16:34:05] ---------------------------

[16:34:05]  

[16:34:05] >> mysql_connect( )

[16:34:05] CMySQLHandler::CMySQLHandler() - constructor called.

[16:34:05] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sqlz" | Username: "root" ...

[16:34:05] CMySQLHandler::Connect() - Connection was successful.

[16:34:05] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[16:34:05] >> mysql_ping( Connection handle: 1 )

[16:34:05] CMySQLHandler::Ping() - Connection is still alive.

[16:34:51] >> mysql_query( Connection handle: 1 )

[16:34:51] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evanas_Sddfs') - Successfully executed.

[16:34:51] >> mysql_store_result( Connection handle: 1 )

[16:34:51] CMySQLHandler::StoreResult() - Result was stored.

[16:34:51] >> mysql_num_rows( Connection handle: 1 )

[16:34:51] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:34:51] >> mysql_query( Connection handle: 1 )

[16:34:51] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[16:34:51] >> mysql_store_result( Connection handle: 1 )

[16:34:51] CMySQLHandler::StoreResult() - Result was stored.

[16:34:51] >> mysql_num_rows( Connection handle: 1 )

[16:34:51] CMySQLHandler::NumRows() - Returned 2 row(s)

[16:34:51] >> mysql_free_result( Connection handle: 1 )

[16:34:51] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:34:55] >> mysql_query( Connection handle: 1 )

[16:34:55] CMySQLHandler::Query(INSERT INTO zaidejai (Vardas, Slaptazodis) VALUES ('Evanas_Sddfs', 'logitech')) - Successfully executed.

[16:35:10] >> mysql_query( Connection handle: 1 )

[16:35:10] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evanas_Sddfs') - Successfully executed.

[16:35:10] >> mysql_query( Connection handle: 1 )

[16:35:10] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evanas_Sddfs') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[16:35:10] >> mysql_query( Connection handle: 1 )

[16:35:10] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2279.061767, pos_Y = -56.099040, pos_Z = 26.405620, world = 0, star = 0, pinigai = 30000, patirtis 250, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = '') - An error has occured. (Error ID: 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 '250, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = ''' at line 1)

[16:35:41] >> mysql_query( Connection handle: 1 )

[16:35:41] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Evanas_Sddfs') - Successfully executed.

[16:35:41] >> mysql_store_result( Connection handle: 1 )

[16:35:41] CMySQLHandler::StoreResult() - Result was stored.

[16:35:41] >> mysql_num_rows( Connection handle: 1 )

[16:35:41] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:35:41] >> mysql_query( Connection handle: 1 )

[16:35:41] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[16:35:41] >> mysql_store_result( Connection handle: 1 )

[16:35:41] CMySQLHandler::StoreResult() - Result was stored.

[16:35:41] >> mysql_num_rows( Connection handle: 1 )

[16:35:41] CMySQLHandler::NumRows() - Returned 3 row(s)

[16:35:41] >> mysql_free_result( Connection handle: 1 )

[16:35:41] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:35:51] >> mysql_query( Connection handle: 1 )

[16:35:51] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evanas_Sddfs' AND Slaptazodis = 'logitech') - Successfully executed.

[16:35:51] >> mysql_store_result( Connection handle: 1 )

[16:35:51] CMySQLHandler::StoreResult() - Result was stored.

[16:35:51] >> mysql_retrieve_row( Connection handle: 1 )

[16:35:51] >> mysql_free_result( Connection handle: 1 )

[16:35:51] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:35:51] >> mysql_query( Connection handle: 1 )

[16:35:51] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Evanas_Sddfs') - Successfully executed.

[16:35:51] >> mysql_store_result( Connection handle: 1 )

[16:35:51] CMySQLHandler::StoreResult() - Result was stored.

[16:35:51] >> mysql_retrieve_row( Connection handle: 1 )

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("pinigai") - NULL

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("patirtis") - 0

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("world") - 0

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("star") - 0

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("pos_X") - 0

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("pos_Y") - 0

[16:35:51] >> mysql_fetch_field_row( Connection handle: 1 )

[16:35:51] CMySQLHandler::FetchField("pos_Z") - 0

[16:35:51] >> mysql_retrieve_row( Connection handle: 1 )

[16:35:51] >> mysql_free_result( Connection handle: 1 )

[16:35:51] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:36:08] >> mysql_query( Connection handle: 1 )

[16:36:08] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Evanas_Sddfs') - Successfully executed.

[16:36:08] >> mysql_query( Connection handle: 1 )

[16:36:08] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Evanas_Sddfs') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

Redaguota Birželio 20, 2014, nario Harris V.

[Virsenas]

mysql_debug(1);

Įsikelk į gamemod'ą. Sukompiliuok, paleisk serverį ir įeik. Tada atsijunk ir parodyk mysql_log

[evanas1]

Vistiek nėra. Palauk pabandysiu kitaip.

 

EDIT:

 

NE VISTIEK NĖRA.

Redaguota Birželio 20, 2014, nario Harris V.

[Virsenas]

[16:35:10] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2279.061767, pos_Y = -56.099040, pos_Z = 26.405620, world = 0, star = 0, pinigai = 30000, patirtis 250, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = '') - An error has occured. (Error ID: 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 '250, interior = 0, pos_X = 0.000000, pos_Y = , pos_Z =  WHERE vardas = ''' at line 1)

Kam išsaugomos koordinatės du kartus ?

pos_X = 2279.061767, pos_Y = -56.099040, pos_Z = 26.405620

pos_X = 0.000000, pos_Y = , pos_Z = 

Saugojime ir krovime padidink query kintamojo dydį iki ~600. Nes kaip matai po pos_X saugojimo baigiasi reikiama atmintis ir toliau net neberodo reikšmių

pos_Y = , pos_Z =  WHERE vardas = ''

Redaguota Birželio 20, 2014, nario Virsenas

[evanas1]

Vistiek, tas pats. Nesuprantu, kas čia galibūt.

[Virsenas]

Parodyk dabartinį saugojimo ir krovimo kodą.

[evanas1]

SaugomZaideja(playerid)

{

if(zInfo[ playerid ][zaidzia] == 3)

{

new query[600],name[MAX_PLAYER_NAME];

new Float:coo[3],weps[2][12];

GetPlayerName( playerid,name,sizeof(name));

GetPlayerPos( playerid,coo[0],coo[1],coo[2]);

format(query, sizeof(query), "UPDATE zaidejai SET pos_X = %f, pos_Y = %f, pos_Z = %f, world = %i, star = %i, pinigai = %i, patirtis %i, interior = %i WHERE vardas = '%s'",

coo[0],

coo[1],

coo[2],

GetPlayerVirtualWorld(playerid),

GetPlayerWantedLevel(playerid),

GetPlayerMoneyA(playerid),

GetPlayerScore(playerid),

GetPlayerInterior(playerid),

name

);

mysql_query(query);

}

}

KraunamZaideja(playerid)

{

new name[MAX_PLAYER_NAME],query[600], Float:pos[3], fetch[20];

GetPlayerName( playerid,name,sizeof(name));

format(query, sizeof(query), "SELECT * FROM zaidejai WHERE Vardas = '%s'", name);

mysql_query(query);

mysql_store_result();

while(mysql_retrieve_row())

{

mysql_fetch_field_row(fetch,"pinigai");

GivePlayerMoneyA( playerid, strval(fetch));

mysql_fetch_field_row(fetch,"patirtis");

SetPlayerScore( playerid, strval(fetch));

mysql_fetch_field_row(fetch,"world");

SetPlayerVirtualWorld( playerid, strval(fetch));

mysql_fetch_field_row(fetch,"star");

SetPlayerWantedLevel( playerid, strval(fetch));

mysql_fetch_field_row(fetch,"pos_X");

pos[0] = floatstr(fetch);

mysql_fetch_field_row(fetch,"pos_Y");

pos[1] = floatstr(fetch);

mysql_fetch_field_row(fetch,"pos_Z");

pos[2] = floatstr(fetch);

SetPlayerPos( playerid, pos[0], pos[1], pos[2]);

}

mysql_free_result();

return 1;

}

[Virsenas]

format(query, sizeof(query), "SELECT pos_X,pos_Y,pos_Z,world,star,pinigai,patirtis,interior FROM zaidejai WHERE Vardas = '%s'", name);

Čia tarp krovimo.

SELECT * FROM zaidejai

Pasirinks visus stulpelius, t.y. id, Vardas, Slaptazodis ir t.t., todėl man atrodo tame ir problema. Dar būtų gerai, kad po šito testo vėl įkeltum log'ą.

[evanas1]

Dabar tas pats bet į kitą vietą numeta

 

Logas

17:26:25] ---------------------------

[17:26:25] MySQL Debugging activated (06/20/14)

[17:26:25] ---------------------------

[17:26:25]  

[17:26:25] >> mysql_connect( )

[17:26:25] CMySQLHandler::CMySQLHandler() - constructor called.

[17:26:25] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sqlz" | Username: "root" ...

[17:26:25] CMySQLHandler::Connect() - Connection was successful.

[17:26:25] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[17:26:25] >> mysql_ping( Connection handle: 1 )

[17:26:25] CMySQLHandler::Ping() - Connection is still alive.

[17:26:52] >> mysql_query( Connection handle: 1 )

[17:26:52] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Harris_Amazingas') - Successfully executed.

[17:26:52] >> mysql_store_result( Connection handle: 1 )

[17:26:52] CMySQLHandler::StoreResult() - Result was stored.

[17:26:52] >> mysql_num_rows( Connection handle: 1 )

[17:26:52] CMySQLHandler::NumRows() - Returned 0 row(s)

[17:26:52] >> mysql_query( Connection handle: 1 )

[17:26:52] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[17:26:52] >> mysql_store_result( Connection handle: 1 )

[17:26:52] CMySQLHandler::StoreResult() - Result was stored.

[17:26:52] >> mysql_num_rows( Connection handle: 1 )

[17:26:52] CMySQLHandler::NumRows() - Returned 5 row(s)

[17:26:52] >> mysql_free_result( Connection handle: 1 )

[17:26:52] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:26:58] >> mysql_query( Connection handle: 1 )

[17:26:58] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[17:26:58] >> mysql_store_result( Connection handle: 1 )

[17:26:58] CMySQLHandler::StoreResult() - Result was stored.

[17:26:58] >> mysql_num_rows( Connection handle: 1 )

[17:26:58] CMySQLHandler::NumRows() - Returned 5 row(s)

[17:27:00] >> mysql_query( Connection handle: 1 )

[17:27:00] CMySQLHandler::Query(INSERT INTO zaidejai (Vardas, Slaptazodis) VALUES ('Harris_Amazingas', 'eveikas')) - Successfully executed.

[17:27:09] >> mysql_query( Connection handle: 1 )

[17:27:09] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Harris_Amazingas') - Successfully executed.

[17:27:09] >> mysql_query( Connection handle: 1 )

[17:27:09] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Harris_Amazingas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[17:27:09] >> mysql_query( Connection handle: 1 )

[17:27:09] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2280.915039, pos_Y = -64.424911, pos_Z = 26.405620, world = 0, star = 0, pinigai = 30000, patirtis 250, interior = 0  WHERE vardas = 'Harris_Amazingas') - An error has occured. (Error ID: 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 '250, interior = 0  WHERE vardas = 'Harris_Amazingas'' at line 1)

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

[17:28:49] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Harris_Amazingas') - Successfully executed.

[17:28:49] >> mysql_store_result( Connection handle: 1 )

[17:28:49] CMySQLHandler::StoreResult() - Result was stored.

[17:28:49] >> mysql_num_rows( Connection handle: 1 )

[17:28:49] CMySQLHandler::NumRows() - Returned 1 row(s)

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

[17:28:49] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[17:28:49] >> mysql_store_result( Connection handle: 1 )

[17:28:49] CMySQLHandler::StoreResult() - Result was stored.

[17:28:49] >> mysql_num_rows( Connection handle: 1 )

[17:28:49] CMySQLHandler::NumRows() - Returned 6 row(s)

[17:28:49] >> mysql_free_result( Connection handle: 1 )

[17:28:49] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:28:52] >> mysql_query( Connection handle: 1 )

[17:28:52] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Harris_Amazingas' AND Slaptazodis = 'logitech') - Successfully executed.

[17:28:52] >> mysql_store_result( Connection handle: 1 )

[17:28:52] CMySQLHandler::StoreResult() - Result was stored.

[17:28:52] >> mysql_retrieve_row( Connection handle: 1 )

[17:29:14] >> mysql_query( Connection handle: 1 )

[17:29:14] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Harris_Amazingas') - Successfully executed.

[17:29:15] >> mysql_query( Connection handle: 1 )

[17:29:15] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Harris_Amazingas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[17:32:09] >> mysql_query( Connection handle: 1 )

[17:32:09] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Harris_Amazingas') - Successfully executed.

[17:32:09] >> mysql_store_result( Connection handle: 1 )

[17:32:09] CMySQLHandler::StoreResult() - Result was stored.

[17:32:09] >> mysql_num_rows( Connection handle: 1 )

[17:32:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[17:32:09] >> mysql_query( Connection handle: 1 )

[17:32:09] CMySQLHandler::Query(SELECT * FROM `zaidejai`) - Successfully executed.

[17:32:09] >> mysql_store_result( Connection handle: 1 )

[17:32:09] CMySQLHandler::StoreResult() - Result was stored.

[17:32:09] >> mysql_num_rows( Connection handle: 1 )

[17:32:09] CMySQLHandler::NumRows() - Returned 6 row(s)

[17:32:09] >> mysql_free_result( Connection handle: 1 )

[17:32:09] CMySQLHandler::FreeResult() - Result was successfully free'd.

[17:32:12] >> mysql_query( Connection handle: 1 )

[17:32:12] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Harris_Amazingas' AND Slaptazodis = 'logitech') - Successfully executed.

[17:32:12] >> mysql_store_result( Connection handle: 1 )

[17:32:12] CMySQLHandler::StoreResult() - Result was stored.

[17:32:12] >> mysql_retrieve_row( Connection handle: 1 )

[17:32:26] >> mysql_query( Connection handle: 1 )

[17:32:26] CMySQLHandler::Query(UPDATE `zaidejai` SET `online` = '0' WHERE `Vardas` = 'Harris_Amazingas') - Successfully executed.

[17:32:26] >> mysql_query( Connection handle: 1 )

[17:32:26] CMySQLHandler::Query(UPDATE `zaidejai` SET `AtsijungeP` = '2014.06.20' WHERE `Vardas` = 'Harris_Amazingas') - An error has occured. (Error ID: 1054, Unknown column 'AtsijungeP' in 'field list')

[Virsenas]

Gi sakiau, tarp krovimo šitą naudok:

format(query, sizeof(query), "SELECT pos_X,pos_Y,pos_Z,world,star,pinigai,patirtis,interior FROM zaidejai WHERE Vardas = '%s'", name);

ne

SELECT * FROM zaidejai

Ir tada informacijos panaudojimas turėtų būti paeiliui taip pat kaip viršutinėje eilutėje. Negali vienam kode naudot tarkim taip:

pos_X,pos_Y,pos_Z,world,star,pinigai,patirtis,interior

o, kitur taip:

pinigai,patirtis,interior,world,star,pos_X,pos_Y,pos_Z

[evanas1]

Aš esu padaręs, bet dabar numeta tiesiog į kitą vietą

KraunamZaideja(playerid)
{
	new name[MAX_PLAYER_NAME],query[600], Float:pos[3], fetch[20];
	GetPlayerName( playerid,name,sizeof(name));
	format(query, sizeof(query), "SELECT pinigai,patirtis,world,star,interior,pos_X,pos_Y,pos_Z FROM zaidejai WHERE Vardas = '%s'", name);
	mysql_query(query);
	mysql_store_result();
	while(mysql_retrieve_row())
	{
 	mysql_fetch_field_row(fetch,"pinigai");
	GivePlayerMoneyA( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"patirtis");
	SetPlayerScore( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"world");
	SetPlayerVirtualWorld( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"star");
	SetPlayerWantedLevel( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"interior");   SetPlayerInterior( playerid, strval(fetch));
	mysql_fetch_field_row(fetch,"pos_X");
	pos[0] = floatstr(fetch);
	mysql_fetch_field_row(fetch,"pos_Y");
	pos[1] = floatstr(fetch);
	mysql_fetch_field_row(fetch,"pos_Z");
	pos[2] = floatstr(fetch);
	SetPlayerPos( playerid, pos[0], pos[1], pos[2]);
	}
	mysql_free_result(); 
	return 1;
	}

[Virsenas]

[17:27:09] CMySQLHandler::Query(UPDATE zaidejai SET pos_X = 2280.915039, pos_Y = -64.424911, pos_Z = 26.405620, world = 0, star = 0, pinigai = 30000, patirtis 250, interior = 0  WHERE vardas = 'Harris_Amazingas') - An error has occured. (Error ID: 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 '250, interior = 0  WHERE vardas = 'Harris_Amazingas'' at line 1)

prie patirtis trūksta lygybės ženklo. O šitas išsaugojimas, čia kažkas su registracija susiję ?

[evanas1]

Ne, su registracija tai nieko, registracijoj, tik tai kaip užsiregistruoji, įrašo tavo vardą į duom bazę.

[Virsenas]

Išsiblaškęs šiandien. Nepamačiau. O dabar užkrauna žaidėjo informaciją ? Pinigus, xp ir kitą ? O kai prisijungi į serverį numeta kažkur kitur, nei kai atsijungi ?

Redaguota Birželio 20, 2014, nario Virsenas

[evanas1]

Taip, bet xp nieko nesaugo, beje duomenų bazėj buvau, pamiršęs sukurti interioro lentelę, bet vistiek nepadėda, bet pozicija jau kitur būną, kai prisijungi.

[evanas1]

Pabandysiu perrašyt kitaip saugojimą/krovimą.

[Virsenas]

sscanf ?

[evanas1]

Susitvarkiau, bet vistiek ačiū už pagalbą!