Peršokti į turinį

,

Nori pirkti ar parduoti SA:MP turtą? SPAUSK ČIA!

Kažkas blogai su mySQL krovimu / saugojimu.

Parašė etc.
Liepos 25, 2014 forume SA:MP Klausimai, pagalba ir prašymai

https://www.supergames.lt/topic/187904-ka%C5%BEkas-blogai-su-mysql-krovimu-saugojimu/

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 4378 dienas (-ų). Patariame sukurti naują temą, o ne rašyti naują pranešimą.

Už neaktyvių temų prikėlimą galite sulaukti įspėjimo ir pranešimo pašalinimo!

Recommended Posts

Naujokas (-ė)

etc.

Liepos 25, 2014

Liepos 25, 2014

[11:03:24] ---------------------------

[11:03:24] MySQL Debugging activated (07/25/14)

[11:03:24] ---------------------------

[11:03:24]  

[11:03:24] >> mysql_connect( )

[11:03:24] CMySQLHandler::CMySQLHandler() - constructor called.

[11:03:24] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "sfierro" | Username: "root" ...

[11:03:24] CMySQLHandler::Connect() - Connection was successful.

[11:03:24] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[11:03:24] >> mysql_ping( Connection handle: 1 )

[11:03:24] CMySQLHandler::Ping() - Connection is still alive.

[11:03:46] >> mysql_query( Connection handle: 1 )

[11:03:46] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas='Daniel_King') - Successfully executed.

[11:03:46] >> mysql_store_result( Connection handle: 1 )

[11:03:46] CMySQLHandler::StoreResult() - Result was stored.

[11:03:46] >> mysql_num_rows( Connection handle: 1 )

[11:03:46] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:03:48] >> mysql_query( Connection handle: 1 )

[11:03:48] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas='Daniel_King' AND Slaptazodis='') - Successfully executed.

[11:03:48] >> mysql_store_result( Connection handle: 1 )

[11:03:48] CMySQLHandler::StoreResult() - Result was stored.

[11:03:48] >> mysql_num_rows( Connection handle: 1 )

[11:03:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:03:48] >> mysql_query( Connection handle: 1 )

[11:03:48] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:03:48] >> mysql_store_result( Connection handle: 1 )

[11:03:48] CMySQLHandler::StoreResult() - Result was stored.

[11:03:48] >> mysql_num_rows( Connection handle: 1 )

[11:03:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:03:48] >> mysql_fetch_row_format( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchRow() - Return: 1|Daniel_King||-2070.79|-3.60508|35.4656|48|14999|0|1|255.255.255.255|2014-7-25 10:50:29|0|0|15|1|10|1414048667

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("lastCDate") - 2014-7-25 10:50:29

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("lastIP") - 255.255.255.255

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("Patirtis") - 48

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("Pinigai") - 14999

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("X") - -2070.79

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("Y") - -3.60508

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("Z") - 35.4656

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("admin") - 0

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("vip") - 1

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("world") - 0

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("inter") - 0

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("skin") - 15

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("lytis") - 1

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("Kreditai") - 10

[11:03:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:03:48] CMySQLHandler::FetchField("VipLaikas") - 1414048667

[11:03:48] >> mysql_free_result( Connection handle: 1 )

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

[11:06:09] >> mysql_query( Connection handle: 1 )

[11:06:09] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas='Supistai_Kietas') - Successfully executed.

[11:06:09] >> mysql_store_result( Connection handle: 1 )

[11:06:09] CMySQLHandler::StoreResult() - Result was stored.

[11:06:09] >> mysql_num_rows( Connection handle: 1 )

[11:06:09] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:06:14] >> mysql_query( Connection handle: 1 )

[11:06:14] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas='Supistai_Kietas' AND Slaptazodis='aaa') - Successfully executed.

[11:06:14] >> mysql_store_result( Connection handle: 1 )

[11:06:14] CMySQLHandler::StoreResult() - Result was stored.

[11:06:14] >> mysql_num_rows( Connection handle: 1 )

[11:06:14] CMySQLHandler::NumRows() - Returned 0 row(s)

[11:06:18] >> mysql_query( Connection handle: 1 )

[11:06:18] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas='Supistai_Kietas' AND Slaptazodis='aaaaaa') - Successfully executed.

[11:06:18] >> mysql_store_result( Connection handle: 1 )

[11:06:18] CMySQLHandler::StoreResult() - Result was stored.

[11:06:18] >> mysql_num_rows( Connection handle: 1 )

[11:06:18] CMySQLHandler::NumRows() - Returned 0 row(s)

[11:06:20] >> mysql_query( Connection handle: 1 )

[11:06:20] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas='Supistai_Kietas' AND Slaptazodis='aaaaa') - Successfully executed.

[11:06:20] >> mysql_store_result( Connection handle: 1 )

[11:06:20] CMySQLHandler::StoreResult() - Result was stored.

[11:06:20] >> mysql_num_rows( Connection handle: 1 )

[11:06:20] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:06:20] >> mysql_query( Connection handle: 1 )

[11:06:20] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Supistai_Kietas') - Successfully executed.

[11:06:20] >> mysql_store_result( Connection handle: 1 )

[11:06:20] CMySQLHandler::StoreResult() - Result was stored.

[11:06:20] >> mysql_num_rows( Connection handle: 1 )

[11:06:20] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:06:20] >> mysql_fetch_row_format( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchRow() - Return: 2|Supistai_Kietas|aaaaa|-1460.67|555.673|12.2502|10|15000|0|0|255.255.255.255|2014-7-24 21:16:44|0|0|15|1|0|0

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("lastCDate") - 2014-7-24 21:16:44

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("lastIP") - 255.255.255.255

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("Patirtis") - 10

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("Pinigai") - 15000

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("X") - -1460.67

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("Y") - 555.673

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("Z") - 12.2502

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("admin") - 0

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("vip") - 0

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("world") - 0

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("inter") - 0

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("skin") - 15

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("lytis") - 1

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("Kreditai") - 0

[11:06:20] >> mysql_fetch_field_row( Connection handle: 1 )

[11:06:20] CMySQLHandler::FetchField("VipLaikas") - 0

[11:06:20] >> mysql_free_result( Connection handle: 1 )

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

[11:09:40] >> mysql_query( Connection handle: 1 )

[11:09:40] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:40] >> mysql_store_result( Connection handle: 1 )

[11:09:40] CMySQLHandler::StoreResult() - Result was stored.

[11:09:40] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:40] >> mysql_num_rows( Connection handle: 1 )

[11:09:40] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:40] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:40] CMySQLHandler::FetchField("Kreditai") - 10

[11:09:40] >> mysql_free_result( Connection handle: 1 )

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

[11:09:40] >> mysql_query( Connection handle: 1 )

[11:09:40] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:40] >> mysql_store_result( Connection handle: 1 )

[11:09:40] CMySQLHandler::StoreResult() - Result was stored.

[11:09:40] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:40] >> mysql_num_rows( Connection handle: 1 )

[11:09:40] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:40] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:40] CMySQLHandler::FetchField("Kreditai") - 10

[11:09:40] >> mysql_free_result( Connection handle: 1 )

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

[11:09:40] >> mysql_query( Connection handle: 1 )

[11:09:40] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Supistai_Kietas') - Successfully executed.

[11:09:40] >> mysql_store_result( Connection handle: 1 )

[11:09:40] CMySQLHandler::StoreResult() - Result was stored.

[11:09:40] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:40] >> mysql_num_rows( Connection handle: 1 )

[11:09:40] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:40] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:40] CMySQLHandler::FetchField("Kreditai") - 0

[11:09:40] >> mysql_free_result( Connection handle: 1 )

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

[11:09:43] >> mysql_query( Connection handle: 1 )

[11:09:43] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:43] >> mysql_store_result( Connection handle: 1 )

[11:09:43] CMySQLHandler::StoreResult() - Result was stored.

[11:09:43] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:43] >> mysql_num_rows( Connection handle: 1 )

[11:09:43] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:43] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:43] CMySQLHandler::FetchField("Kreditai") - 10

[11:09:43] >> mysql_free_result( Connection handle: 1 )

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

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

[11:09:45] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Supistai_Kietas') - Successfully executed.

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

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

[11:09:45] >> mysql_retrieve_row( Connection handle: 1 )

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

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

[11:09:45] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:45] CMySQLHandler::FetchField("Kreditai") - 0

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

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

[11:09:46] >> mysql_query( Connection handle: 1 )

[11:09:46] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:46] >> mysql_store_result( Connection handle: 1 )

[11:09:46] CMySQLHandler::StoreResult() - Result was stored.

[11:09:46] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:46] >> mysql_num_rows( Connection handle: 1 )

[11:09:46] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:46] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:46] CMySQLHandler::FetchField("Kreditai") - 10

[11:09:46] >> mysql_free_result( Connection handle: 1 )

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

[11:09:48] >> mysql_query( Connection handle: 1 )

[11:09:48] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:48] >> mysql_store_result( Connection handle: 1 )

[11:09:48] CMySQLHandler::StoreResult() - Result was stored.

[11:09:48] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:48] >> mysql_num_rows( Connection handle: 1 )

[11:09:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:48] CMySQLHandler::FetchField("Kreditai") - 10

[11:09:48] >> mysql_free_result( Connection handle: 1 )

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

[11:09:48] >> mysql_query( Connection handle: 1 )

[11:09:48] CMySQLHandler::Query(UPDATE `zaidejai` SET `vip` = '1', `Kreditai` = '5', `VipLaikas` = '1416640667' WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:48] >> mysql_query( Connection handle: 1 )

[11:09:48] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Supistai_Kietas') - Successfully executed.

[11:09:48] >> mysql_store_result( Connection handle: 1 )

[11:09:48] CMySQLHandler::StoreResult() - Result was stored.

[11:09:48] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:48] >> mysql_num_rows( Connection handle: 1 )

[11:09:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:48] CMySQLHandler::FetchField("Kreditai") - 0

[11:09:48] >> mysql_free_result( Connection handle: 1 )

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

[11:09:48] >> mysql_query( Connection handle: 1 )

[11:09:48] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:48] >> mysql_store_result( Connection handle: 1 )

[11:09:48] CMySQLHandler::StoreResult() - Result was stored.

[11:09:48] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:48] >> mysql_num_rows( Connection handle: 1 )

[11:09:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:48] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:48] CMySQLHandler::FetchField("Kreditai") - 5

[11:09:48] >> mysql_free_result( Connection handle: 1 )

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

[11:09:50] >> mysql_query( Connection handle: 1 )

[11:09:50] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:09:50] >> mysql_store_result( Connection handle: 1 )

[11:09:50] CMySQLHandler::StoreResult() - Result was stored.

[11:09:50] >> mysql_retrieve_row( Connection handle: 1 )

[11:09:50] >> mysql_num_rows( Connection handle: 1 )

[11:09:50] CMySQLHandler::NumRows() - Returned 1 row(s)

[11:09:50] >> mysql_fetch_field_row( Connection handle: 1 )

[11:09:50] CMySQLHandler::FetchField("Kreditai") - 5

[11:09:50] >> mysql_free_result( Connection handle: 1 )

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

[11:09:50] >> mysql_query( Connection handle: 1 )

[11:09:50] CMySQLHandler::Query(UPDATE `zaidejai` SET `vip` = '1', `Kreditai` = '0', `VipLaikas` = '1419232667' WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:14:48] >> mysql_query( Connection handle: 1 )

[11:14:48] CMySQLHandler::Query(UPDATE zaidejai SET lastIP = '255.255.255.255', lastCDate = '2014-7-25 11:14:48' WHERE Vardas = 'Daniel_King') - Successfully executed.

[11:14:48] >> mysql_query( Connection handle: 1 )

[11:14:48] CMySQLHandler::Query(UPDATE `zaidejai` SET `X` = '-2071.682373', `Y` = '-46.256175', Z = '38.950748', `Patirtis` = '111', `Pinigai` = '14999' WHERE `Vardas` = 'Daniel_King') - Successfully executed.

[11:14:48] >> mysql_query( Connection handle: 1 )

[11:14:48] CMySQLHandler::Query(UPDATE zaidejai SET admin = '0', vip = '1', Vip = '68 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 ''68 WHERE Vardas = ''' at line 1)

[11:14:48] >> mysql_query( Connection handle: 1 )

[11:14:48] CMySQLHandler::Query(UPDATE zaidejai SET lytis = '1', skin = '15', world = '0', inter = '0' WHERE Vardas = 'Daniel_King') - Successfully executed.

[11:14:48] >> mysql_query( Connection handle: 1 )

[11:14:48] CMySQLHandler::Query(UPDATE zaidejai SET Kreditai = '10' WHERE Vardas = 'Daniel_King') - Successfully executed.

[11:14:48] >> mysql_query( Connection handle: 1 )

[11:14:48] CMySQLHandler::Query(UPDATE zaidejai SET VipLaikas = '0' WWHERE Vardas = 'Daniel_King') - 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 'WWHERE Vardas = 'Daniel_King'' at line 1)

Labas. Šiandien pasirašiau paslaugų sistemą ir pradėjo bugintis Kreditai. Įsirašiau vieną kartą į lentelę sau Kreditų 10, tada nuėjau išleidau, atsijungiau, o pkpMyAdmin'e irgi 0 liko. Prisijungiu vėl - 10 kreditų. Wata?

stock loadPlayerData(playerid)
{
    if(!IsPlayerConnected(playerid)) return 1;
	new Float:gpPos[3], lQuery[100],aaaaa[500];
 	format(lQuery, sizeof(lQuery), "SELECT * FROM `zaidejai` 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 , "lastCDate" ) ; format ( playerDB [ playerid ] [ lastCDate ] , 50 , "%s" , lQuery ) ;
		mysql_fetch_field_row ( lQuery , "lastIP" ) ; format ( playerDB [ playerid ] [ lastIP ] , 17 , "%s" , lQuery ) ;
		mysql_fetch_field_row(lQuery, "Patirtis"); SetPlayerScore(playerid, strval(lQuery));
		mysql_fetch_field_row(lQuery, "Pinigai"); GivePlayerMoney(playerid, strval(lQuery));
		mysql_fetch_field_row(lQuery, "X"); gpPos[0] = floatstr(lQuery);
		mysql_fetch_field_row(lQuery, "Y"); gpPos[1] = floatstr(lQuery);
		mysql_fetch_field_row(lQuery, "Z"); gpPos[2] = floatstr(lQuery);
		SetPlayerPos(playerid, gpPos[0], gpPos[1], gpPos[2]);
		mysql_fetch_field_row(lQuery, "admin"); playerDB[playerid][admin] = strval(lQuery);
		mysql_fetch_field_row(lQuery, "vip"); playerDB[playerid][vip] = strval(lQuery);
		mysql_fetch_field_row(lQuery, "world"); SetPlayerVirtualWorld(playerid, strval(lQuery));
		mysql_fetch_field_row(lQuery, "inter"); SetPlayerInterior(playerid, strval(lQuery));
		mysql_fetch_field_row(lQuery, "skin"); SetPlayerSkin(playerid, strval(lQuery));
		mysql_fetch_field_row(lQuery, "lytis"); playerDB[playerid][lytis] = strval(lQuery);
		mysql_fetch_field_row(lQuery, "Kreditai"); playerDB[playerid][Kreditai] = strval(lQuery);
		mysql_fetch_field_row(lQuery, "VipLaikas"); playerDB[playerid][VipLaikas] = strval(lQuery);
	}
	mysql_free_result();
	if(playerDB[playerid][vip] == 1 )
	{
		if(playerDB[playerid][VipLaikas] < gettime())
		{
			SendClientMessage(playerid, GREEN, "• Praradai VIP narystę nes tavo VIP galiojimo laikas pasibaigęs!");
			playerDB[playerid][vip] = 0;
			playerDB[playerid][VipLaikas] = 0;
		}
		SetPlayerColor(playerid,0xFFFF0000);
	}

	printf("Užkraunamas %s žaidėjas",PlayerName(playerid));
	return 1;
}

stock savePlayerData(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 ] ) ;

	playerDB[ playerid ][ skin ] = GetPlayerSkin( playerid ) ;
	playerDB[ playerid ][ Pinigai ] = GetPlayerMoney( playerid ) ;
	playerDB[ playerid ][ skin ] = GetPlayerSkin( playerid ) ;
	playerDB[ playerid ][ world ] = GetPlayerVirtualWorld( playerid ) ;
	playerDB[ playerid ][ inter ] = GetPlayerInterior( playerid ) ;

	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 zaidejai SET lastIP = '%s', lastCDate = '%s' WHERE Vardas = '%s'" , PlayerIP ( playerid ) , lastDat , PlayerName ( playerid ) ) ;
	mysql_query ( zQuery ) ;
	format(zQuery, sizeof(zQuery), "UPDATE `zaidejai` SET `X` = '%f', `Y` = '%f', Z = '%f', `Patirtis` = '%d', `Pinigai` = '%d' WHERE `Vardas` = '%s'", gpPos[0], gpPos[1],gpPos[2],GetPlayerScore(playerid),playerDB[playerid][Pinigai], PlayerName(playerid));
	mysql_query(zQuery);
	format(zQuery, sizeof(zQuery), "UPDATE zaidejai SET admin = '%d', vip = '%d', Vip = '%d WHERE Vardas = '%s'",playerDB[playerid][admin],playerDB[playerid][vip], PlayerName(playerid));
	mysql_query(zQuery);
	format( zQuery, sizeof( zQuery ), "UPDATE zaidejai SET lytis = '%i', skin = '%i', world = '%i', inter = '%i' WHERE Vardas = '%s'", playerDB[ playerid ][ lytis ], playerDB[ playerid ][ skin ], playerDB[ playerid ][ world ], playerDB[ playerid ][ inter ], PlayerName( playerid ) ) ;
	mysql_query( zQuery ) ;
	format( zQuery, sizeof( zQuery ), "UPDATE zaidejai SET Kreditai = '%i' WHERE Vardas = '%s'", playerDB[ playerid ][ Kreditai ], PlayerName( playerid ) ) ;
	mysql_query( zQuery ) ;
	format( zQuery, sizeof( zQuery ), "UPDATE zaidejai SET VipLaikas = '%d' WWHERE Vardas = '%s'", playerDB[ pid ], PlayerName( pid ) ) ;
	mysql_query( zQuery ) ;
	printf("Saugojimas %s žaidėjas",PlayerName(playerid));
	return 1;
}

log'as

Atsakyti į šį pranešimą

Naujokas (-ė)

etc.

Liepos 25, 2014

Autorius

Liepos 25, 2014

problem solved.

Atsakyti į šį pranešimą

Ši tema yra neaktyvi. Paskutinis pranešimas šioje temoje buvo prieš 4378 dienas (-ų). Patariame sukurti naują temą, o ne rašyti naują pranešimą.

Už neaktyvių temų prikėlimą galite sulaukti įspėjimo ir pranešimo pašalinimo!

Prisijungti prie diskusijos

Palikti atsakymą galite iš karto, o užsiregistruoti vėliau. Jeigu jau turite paskyrą mūsų forume, Prisijunkite.

Svečias

Atsakyti šioje temoje...

× Įklijuotas tekstas turi teksto formatavimą. Pašalinti teksto formatavimą

Galimi tik 75 veidukai.

× Nuoroda buvo automatiškai įterpta. Įterpti nuorodą paprastai

× Jūsų ankstesnis pranešimas buvo atkurtas. Išvalyti redaktorių

× Jūs negalite įkelti nuotraukas tiesiogiai.Įkelkite arba įdėkite nuotraukas iš URL.

Įterpti nuotrauką iš URL

×

https://www.supergames.lt/topic/187904-ka%C5%BEkas-blogai-su-mysql-krovimu-saugojimu/

Šiame puslapyje naršo: 0 nariai
- Nėra registruotų narių peržiūrinčių šį forumą.

Skelbimai

Paslaugų tiekėjai vienoje vietoje (tinklapių kūrėjai, programuotojai ir kiti)
Būsenos atnaujimuose galima tik viena būsena su jūsų reklama.

Naujausios temos
- 2
  
  Padėkit susitvarkyt LOL
  
  DROGZ · Šeštadienis, 15:48
- 0
  
  Nupirkčiau jūsų cs2 paskyrą
  
  wapas · Penktadienis, 14:53
- 0
  
  Amberlands.gg - nauji CS 1.6 serveriai
  
  Amberlands · Trečiadienis, 19:06
- 12
  
  Noriu kurti FIVEM serveri :)
  
  paulius_chill · Antradienis, 18:05
- 1
  
  [Interlude C6 PvP] L2TOPAS – Grįžtam į auksinę L2 erą (Test Serveris JAU ONLINE!)
  
  L2TOPAS · Liepos 13
Naujausi būsenos atnaujinimai
- Nustatymai
  
  Teksto formatavimas
  
  Nario nuotrauka
  
  Member
- Antradienis, 18:02 paulius_chill
  
  Sveiki! Yra is cia esanciu nusimananciu apie fivem serverio kurima?
  
  Rodyti mažiau
  
  3 atsakymai
  
  Nustatymai
  
  Pranešti
- Liepos 13 Fav0
  
  Lineage 2 C6 Interlude! No Custom, PVP! L2TOPAS DISCORD:https://discord.gg/xeEwV2ZQy
  
  Rodyti mažiau
  
  1 atsakymas
  
  Nustatymai
  
  Pranešti
- Liepos 11 strawengg
  
  🎮 Formuojama nauja CS2 komanda FACEIT turnyrams!
  Ieškome ~3K FACEIT ELO žaidėjų, kurie nori sukurti rimtą komandą ilgalaikei perspektyvai.
  Ko ieškome:
  🎯 ~3K ELO
  🧠 Zero toxic
  🎙️ Gera komunikacija
  🤝 Komandinio žaidimo supratimas
  📈 Noro tobulėti ir reguliariai treniruotis
  Šiuo metu komandą formuojame nuo nulio, todėl ieškome motyvuotų žaidėjų, norinčių augti kartu. Registracijos Forma: https://forms.gle/bsyGU1UxwfGJQSWWA
  📩 PM arba [email protected]
  🌐 www.strawen.space
  Jei tinka mūsų vizija – susisiek! 💪
  
  Rodyti mažiau
  
  1 atsakymas
  
  Nustatymai
  
  Pranešti
- Liepos 10 MarcoD
  
  LibertyCity.LT - FIVEM GRP
  
  Rodyti mažiau
  
  1
  
  1
  
  0 atsakymai
  
  Nustatymai
  
  Pranešti
- Liepos 10 zygiukx
  
  DangeRP Serveris - Jau Veikiame - Fivem Role Play
  
  Rodyti mažiau
  
  0 atsakymai
  
  Nustatymai
  
  Pranešti
- Liepos 7 -Lukass
  
  https://discord.gg/MfEy6cfKn - Fivem GRP serveris kuriamas kam įdomu kviečiu užsukt.
  
  Rodyti mažiau
  
  0 atsakymai
  
  Nustatymai
  
  Pranešti
- Birželio 29 Profilio
  
  Jei kam reikalingos soc. paskyros užsukit i profilio.lt
  
  Rodyti mažiau
  
  0 atsakymai
  
  Nustatymai
  
  Pranešti
- Birželio 29 MarU
  
  kas nors pardavinejat Reddit paskyras?
  
  Rodyti mažiau
  
  1 atsakymas
  
  Nustatymai
  
  Pranešti
- Birželio 28 Nedas S.
  
  Nupirkčiau facebook grupę ar puslapį. Tema statybos, statybines medžiagos ar kažkas panašaus.
  
  Rodyti mažiau
  
  0 atsakymai
  
  Nustatymai
  
  Pranešti
- Birželio 28 Nedas S.
  
  www.WebHits.lt - Nemokamas puslapių lankytojų skaitliukas
  
  Rodyti mažiau
  
  0 atsakymai
  
  Nustatymai
  
  Pranešti
Populiariausi nariai
- Savaitės
- Mėnesio
- Metų
- Visų laikų
1. 1
  
  MarcoD
  1
2. 2
  
  CyberSoul
  1
3. 3
  
  lamaa
  1
4. 4
  
  strawengg
  0
5. 5
  
  lolipopas
  0
Rodyti daugiau

×

×

Sukurti naują...