Jump to content
  • 0

Problema server ( CMySQLResult::GetRowDataByName() )

Razerz

Asked by Razerz,

 Share

Question

Razerz Apprentice

Razerz

Posted
Posted (edited)

Salut SA-MP.RO !

Problema intalnita : De ceva timp a aparut o problema, mai exact uneori se pierd banii/ scor-ul si vip-ul.

Eroarea/Warning-ul : in mysql log primesc eroarea CMySQLResult::GetRowDataByName()",1,"invalid row index('0)",('0');"de la CallBack-ul CheckAccountPassword(nu stiu daca asta este problema) aici aveti mysql log http://pastebin.com/7tiaKbtJ si aici callback-ul checkaccountpassword http://pastebin.com/DvzpyiZh

Imagini/video : imagine cu eroarea

error.png

Ai incercat sa o rezolvi singur: ? Da, dar nu am reusit.

 

 

 

 

 

 

Multumesc mult.

Edited by Razerz

9 answers to this question

Recommended Posts

  • 0
  • Administrator
WopsS Grand Master

WopsS

Posted
  • Administrator
Posted

Asta trebuia postata la ajutor scripting, pe aici nu prea se activeaza asa mult.

Poti sa pui codul de la CheckAccountPassword daca mai ai nevoie de ajutor?

  • 0
Razerz Apprentice

Razerz

Posted
  • Author
Posted (edited)

Asta trebuia postata la ajutor scripting, pe aici nu prea se activeaza asa mult.

Poti sa pui codul de la CheckAccountPassword daca mai ai nevoie de ajutor?

SQL_Function CheckAccountPassword( playerid, password[ ] )
{
	if ( !IsPlayerConnected( playerid ) )
	    return ( 1 );

	new Login_Field[ 256 ], xxstring[512];

	cache_get_field_content( 0, "Password", Login_Field, g_Handle );

	if ( strmatch( password, Login_Field ) )
	{
	    new LastOnline[ 256 ], RegisterDate[ 256 ];

	    PlayerPlaySound(playerid,1057,0.0,0.0,0.0);

	    format( gsQuery, 128, "UPDATE `Accounts` SET `LoggedIn` = 1,`IP` = '%s',`Lang` = %d WHERE `Name` = '%s'", GetPlayerIPEx( playerid ), Lang[ playerid ], PlayerName( playerid ) );
	    mysql_function_query( g_Handle, gsQuery, false, "", "" );
	    //----------------------------- Loggin' Into Account -----------------//
        PlayerInfo[ playerid ][ LoggedIn ] 			= 1;
        PlayerInfo[ playerid ][ AccID ] 			= cache_get_field_content_int( 0, "Key", g_Handle );
        PlayerInfo[ playerid ][ pVip ] 				= cache_get_field_content_int( 0, "Vip", g_Handle );
        PlayerInfo[ playerid ][ Level ]             = cache_get_field_content_int( 0, "Level", g_Handle );
        PlayerInfo[ playerid ][ rVip ] 				= cache_get_field_content_int( 0, "rVip", g_Handle );
	    PlayerInfo[ playerid ][ bKillingSpree ] 	= cache_get_field_content_int( 0, "BestKillings", g_Handle );
        PlayerInfo[ playerid ][ KillingSpree ] 		= cache_get_field_content_int( 0, "KillingSpree", g_Handle );
        PlayerInfo[ playerid ][ Drugs ] 			= cache_get_field_content_int( 0, "Drugs", g_Handle );
	    PlayerInfo[ playerid ][ Coins ] 			= cache_get_field_content_int( 0, "Coins", g_Handle );
        PlayerInfo[ playerid ][ PosRespect ] 		= cache_get_field_content_int( 0, "Positive", g_Handle );
     	PlayerInfo[ playerid ][ NegRespect ] 		= cache_get_field_content_int( 0, "Negative", g_Handle );
	    PlayerInfo[ playerid ][ SAdmin ] 			= cache_get_field_content_int( 0, "SAdmin", g_Handle );
	    PlayerInfo[ playerid ][ FavSkin ] 			= cache_get_field_content_int( 0, "FavSkin", g_Handle );
		PlayerInfo[ playerid ][ rank ] 				= cache_get_field_content_int( 0, "ClanRank", g_Handle );
		PlayerInfo[ playerid ][ c_points ] 			= cache_get_field_content_int( 0, "ClanPoints", g_Handle );
		PlayerInfo[ playerid ][ c_deaths ] 			= cache_get_field_content_int( 0, "ClanDeaths", g_Handle );
		PlayerInfo[ playerid ][ PKicks ] 			= cache_get_field_content_int( 0, "Kicks", g_Handle );
		PlayerInfo[ playerid ][ PBans ] 			= cache_get_field_content_int( 0, "Bans", g_Handle );
		PlayerInfo[ playerid ][ PJails ] 			= cache_get_field_content_int( 0, "Jails", g_Handle );
		PlayerInfo[ playerid ][ PWarns ] 			= cache_get_field_content_int( 0, "Warns", g_Handle );
		PlayerInfo[ playerid ][ PClearCH ] 			= cache_get_field_content_int( 0, "ClearChats", g_Handle );
		PlayerInfo[ playerid ][ PReactions ] 		= cache_get_field_content_int( 0, "ReactionTest", g_Handle );
		PlayerInfo[ playerid ][ PMaths ] 			= cache_get_field_content_int( 0, "MathTest", g_Handle );
		PlayerInfo[ playerid ][ PMutes ] 			= cache_get_field_content_int( 0, "Mutes", g_Handle );
		PlayerInfo[ playerid ][ Property ] 			= cache_get_field_content_int( 0, "Property", g_Handle );
		PlayerInfo[ playerid ][ Jailed ] 			= cache_get_field_content_int( 0, "Jailed", g_Handle );
		PlayerInfo[ playerid ][ Frozen ] 			= cache_get_field_content_int( 0, "Frozen", g_Handle );
	    PlayerInfo[ playerid ][ Kills ] 			= cache_get_field_content_int( 0, "Kills", g_Handle );
		PlayerInfo[ playerid ][ Deaths ] 			= cache_get_field_content_int( 0, "Deaths", g_Handle );
		PlayerInfo[ playerid ][ rAdmin ] 			= cache_get_field_content_int( 0, "RAdmin", g_Handle );
        PlayerInfo[ playerid ][ p_TextColor ] 		= cache_get_field_content_int( 0, "ChatColor", g_Handle );
		PlayerInfo[ playerid ][ D_Score ] 			= cache_get_field_content_int( 0, "DuelScore", g_Handle );
		PlayerInfo[ playerid ][ Race_Score ] 		= cache_get_field_content_int( 0, "RaceScore", g_Handle );
		PlayerInfo[ playerid ][ Stunt_Score ]	 	= cache_get_field_content_int( 0, "StuntScore", g_Handle );
		PlayerInfo[ playerid ][ Drift_Score ]	 	= cache_get_field_content_int( 0, "DriftScore", g_Handle );
		PlayerInfo[ playerid ][ CarID ] 			= cache_get_field_content_int( 0, "OwnedCarID", g_Handle );
		PlayerInfo[ playerid ][ szOwnedHouseID ] 	= cache_get_field_content_int( 0, "HouseID", g_Handle );
		PlayerInfo[ playerid ][ P_BANK_MONEY ] 		= cache_get_field_content_int( 0, "BankMoney", g_Handle );
		Lang[ playerid ]                            = cache_get_field_content_int( 0, "Lang", g_Handle );
		Users[ playerid ][ gang ] 					= cache_get_field_content_int( 0, "GangID", g_Handle );
		Users[ playerid ][ g_Kills ] 				= cache_get_field_content_int( 0, "GangKills", g_Handle );
		Users[ playerid ][ g_Deaths ] 				= cache_get_field_content_int( 0, "GangDeaths", g_Handle );
		Users[ playerid ][ isLeader ] 				= cache_get_field_content_int( 0, "GangRank", g_Handle );
		Users[ playerid ][ g_Warns ] 				= cache_get_field_content_int( 0, "GangWarns", g_Handle );
		Users[ playerid ][ g_Captures ] 			= cache_get_field_content_int( 0, "GangCaptures", g_Handle );
		Users[ playerid ][ g_Points ] 				= cache_get_field_content_int( 0, "GangPoints", g_Handle );
		PlayerInfo[ playerid ][ NoPM ] 				= cache_get_field_content_int( 0, "NoPM", g_Handle );
		PlayerInfo[ playerid ][ GotoIgnored ] 		= cache_get_field_content_int( 0, "NoGoto", g_Handle );
		PlayerInfo[ playerid ][ Ignore_Spec ] 		= cache_get_field_content_int( 0, "NoSpec", g_Handle );

		cache_get_field_content( 0, "E-Mail", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ EMail ], 128, "%s", Login_Field );

		SetPVarFloat( playerid, "vSpawn_X", cache_get_field_content_float( 0, "vSpawn_X", g_Handle ) );
		SetPVarFloat( playerid, "vSpawn_Y", cache_get_field_content_float( 0, "vSpawn_Y", g_Handle ) );
		SetPVarFloat( playerid, "vSpawn_Z", cache_get_field_content_float( 0, "vSpawn_Z", g_Handle ) );
		SetPVarFloat( playerid, "vSpawn_A", cache_get_field_content_float( 0, "vSpawn_A", g_Handle ) );

        ResetPlayerMoney( playerid );
        GivePlayerMoney( playerid, cache_get_field_content_int( 0, "Cash", g_Handle ) );
        SetPVarInt( playerid, "sMoney", cache_get_field_content_int( 0, "Cash", g_Handle ) );

		SetPlayerScore( playerid, cache_get_field_content_int( 0, "Score", g_Handle ) );

	    cache_get_field_content( 0, "Online", Login_Field, g_Handle );
		sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ hours ],
										PlayerInfo[ playerid ][ mins ],
										PlayerInfo[ playerid ][ secs ] );

		cache_get_field_content( 0, "LastOn", LastOnline, g_Handle );
		cache_get_field_content( 0, "RegisterDate", RegisterDate, g_Handle );
		cache_get_field_content( 0, "Rank", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ RankName ], 25, Login_Field );

		cache_get_field_content( 0, "Description1", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ Description1 ], 128, "%s", Login_Field );

		cache_get_field_content( 0, "Description2", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ Description2 ], 128, "%s", Login_Field );

		cache_get_field_content( 0, "Description3", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ Description3 ], 128, "%s", Login_Field );

		cache_get_field_content( 0, "ClanJoined", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ JoinedInClan ], 50, Login_Field );

		cache_get_field_content( 0, "Clan", Login_Field, g_Handle );
		format( PlayerInfo[ playerid ][ Clan ], 25, "%s", Login_Field );

		cache_get_field_content( 0, "ClanOnline", Login_Field );
		sscanf( Login_Field, "p<:>iii", PlayerInfo[ playerid ][ clan_H ], PlayerInfo[ playerid ][ clan_M ], PlayerInfo[ playerid ][ clan_S ] );

		cache_get_field_content( 0, "SavingSts", Login_Field, g_Handle );
		sscanf( Login_Field, "p<,>ii", PlayerInfo[ playerid ][ p_HoldSaving ], PlayerInfo[ playerid ][ p_VehicleHoldSaving ] );

		if ( PlayerInfo[ playerid ][ Jailed ] >= 1 )
		{
			cache_get_field_content( 0, "JailTime", Login_Field, g_Handle );
			sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] );
		}

		if ( PlayerInfo[ playerid ][ Frozen ] == 1 )
		{
			cache_get_field_content( 0, "FreezeTime", Login_Field, g_Handle );
			sscanf( Login_Field, "p<:>ii", gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] );
		}
		if ( PlayerInfo[ playerid ][ CarID ] != 0 )
		{
			format( gsQuery, 128, "SELECT * FROM `PersonalVehicles` WHERE `Owner` = '%s'", PlayerName( playerid ) );
			mysql_function_query( g_Handle, gsQuery, true, "LoadPersonalVehicleInfo", "i", playerid );
		}

		if ( !strmatch( PlayerInfo[ playerid ][ Clan ], "None" ) )
		{
		    format( gsQuery, 256, "SELECT * FROM `Clans` WHERE `name` = '%s'", PlayerInfo[ playerid ][ Clan ] );
		    mysql_function_query( g_Handle, gsQuery, true, "LoadClanDetails", "i", playerid );
		}
	    {
			switch( Lang[ playerid ] )
			{
			    case 0:
				{
				format(xxstring, 512, "{1DEE01}Hi {FF0000}%s\n\
	   								   {1DEE01}You have been LoggedIn:\n\n\
 				                       {FF0000}• {1DEE01}Admin Level: {00BBF6}%d\n\
            						   {FF0000}• {1DEE01}VIP Level: {00BBF6}%d\n\
                					   {FF0000}• {1DEE01}Stats Note: {00BBF6}%d/10\n\n\
                                       {1DEE01}Use {FF0000}/Stats{1DEE01} for more details!",
									   PlayerName(playerid), PlayerInfo[playerid][Level],
								       PlayerInfo[playerid][pVip], GiveNote(playerid));
		  		return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}X{FF0000}X{AFAFAF} - Account Info", xxstring, "Ok","");
				}
				case 1:
				{
				format(xxstring, 512, "{1DEE01}Salut {FF0000}%s\n\
	   								   {1DEE01}Ai fost logat cu succes:\n\n\
 				                       {FF0000}• {1DEE01}Admin Level: {00BBF6}%d\n\
            						   {FF0000}• {1DEE01}VIP Level: {00BBF6}%d\n\
                					   {FF0000}• {1DEE01}Stats Note: {00BBF6}%d/10\n\n\
                                       {1DEE01}Foloseste {FF0000}/Stats{1DEE01} pentru mai multe detalii!",
									   PlayerName(playerid), PlayerInfo[playerid][Level],
								       PlayerInfo[playerid][pVip], GiveNote(playerid));
		  		return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}X{FF0000}X{AFAFAF} - Account Info", xxstring, "Ok","");
				}
			}
		}
	}
	else
	{
        PlayerInfo[ playerid ][ FailLogin ]++;

		if ( PlayerInfo[ playerid ][ FailLogin ] == MAX_FAIL_LOGINS )
		{
            format( gsString, 144, "*** {00FF00}%s(%d) {FFF1AF}has been kicked. Reason: {FF0000}Failed Logins{FFF1AF}!", PlayerName( playerid ), playerid );
			SendClientMessageToAll( COLOR_GREY, gsString );

            Kick( playerid );
		}
		switch( Lang[ playerid ] )
		{
		    case 0: format( gsString, 256, "\t\t\t{FF0000}ACCOUNT:\n\n{ACACAC}Login failed! Incorrect Password.\nATTEMPTS: {FF0000}%d/%d\n\n{00FF00}PONT: {ACACAC}Change your '{FF0000}Name{ACACAC}' if this isn't your account name.", PlayerInfo[ playerid ][ FailLogin ], MAX_FAIL_LOGINS );
		    case 1: format( gsString, 256, "\t\t\t\t{FF0000}CONT:\n\n{ACACAC}Logarea nu a reusit! Parola Incorecta.\nINCERCARI: {FF0000}%d/%d\n\n{00FF00}PONT: {ACACAC}Schimbati '{FF0000}Numele{ACACAC}' daca acesta nu este numele accountului tau.", PlayerInfo[ playerid ][ FailLogin ], MAX_FAIL_LOGINS );
		}
		ShowPlayerDialog( playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{FFFFFF}Login your account", gsString, "Login", "New Name" );
	}
	return ( 1 );
}

Poti pune o poza cu tabela din mysql ?

http://s30.postimg.org/uahnl0oo1/tab1.png

http://s9.postimg.org/4uxrho7z3/tab2.png

--
-- Table structure for table `Accounts`
--

CREATE TABLE IF NOT EXISTS `Accounts` (
  `Key` int(11) NOT NULL AUTO_INCREMENT,
  `Name` text,
  `IP` text,
  `Password` text,
  `RegisterDate` date DEFAULT NULL,
  `LoggedIn` int(11) DEFAULT NULL,
  `Level` int(11) DEFAULT NULL,
  `Vip` int(11) DEFAULT NULL,
  `rVip` int(11) DEFAULT NULL,
  `LastOn` date DEFAULT NULL,
  `Cash` int(11) DEFAULT NULL,
  `Score` int(11) DEFAULT NULL,
  `Kills` int(11) DEFAULT NULL,
  `Deaths` int(11) DEFAULT NULL,
  `Online` text,
  `Rank` text NOT NULL,
  `BestKillings` int(11) DEFAULT NULL,
  `KillingSpree` int(11) DEFAULT NULL,
  `Drugs` int(11) DEFAULT NULL,
  `TimesOnServer` int(11) DEFAULT NULL,
  `Coins` int(11) DEFAULT NULL,
  `SAdmin` int(11) DEFAULT NULL,
  `FavSkin` int(11) DEFAULT NULL,
  `UseSkin` int(11) DEFAULT NULL,
  `Description1` text NOT NULL,
  `Description2` text NOT NULL,
  `Description3` text NOT NULL,
  `Positive` int(11) DEFAULT NULL,
  `Negative` int(11) DEFAULT NULL,
  `Clan` text,
  `ClanRank` int(11) DEFAULT NULL,
  `E-Mail` text,
  `ClanPoints` int(11) DEFAULT NULL,
  `ClanDeaths` int(11) DEFAULT NULL,
  `ClanOnline` text,
  `ClanJoined` text,
  `Kicks` int(11) DEFAULT NULL,
  `Bans` int(11) DEFAULT NULL,
  `Jails` int(11) DEFAULT NULL,
  `Warns` int(11) DEFAULT NULL,
  `ClearChats` int(11) DEFAULT NULL,
  `ReactionTest` int(11) DEFAULT NULL,
  `MathTest` int(11) DEFAULT NULL,
  `Mutes` int(11) DEFAULT NULL,
  `ARatio` int(11) DEFAULT NULL,
  `Property` int(11) DEFAULT NULL,
  `Jailed` int(11) DEFAULT NULL,
  `JailTime` text,
  `Frozen` int(11) DEFAULT NULL,
  `FreezeTime` text,
  `RAdmin` int(11) DEFAULT NULL,
  `ChatColor` int(11) NOT NULL,
  `RaceScore` int(11) DEFAULT NULL,
  `StuntScore` int(11) DEFAULT NULL,
  `DriftScore` int(11) DEFAULT NULL,
  `DuelScore` int(11) DEFAULT NULL,
  `CNRScore` int(11) DEFAULT NULL,
  `vSpawn_X` float NOT NULL,
  `vSpawn_Y` float NOT NULL,
  `vSpawn_Z` float NOT NULL,
  `vSpawn_A` float NOT NULL,
  `TopOnline` int(11) NOT NULL,
  `AdminWarns` int(11) NOT NULL,
  `OwnedCarID` int(11) NOT NULL,
  `SavingSts` text NOT NULL,
  `HouseID` int(11) NOT NULL,
  `BankMoney` int(11) NOT NULL,
  `Lang` int(11) NOT NULL,
  `GangID` int(11) NOT NULL,
  `GangRank` int(11) NOT NULL,
  `GangKills` int(11) NOT NULL,
  `GangDeaths` int(11) NOT NULL,
  `GangWarns` int(11) NOT NULL,
  `GangCaptures` int(11) NOT NULL,
  `GangPoints` int(11) NOT NULL,
  `NoPM` int(11) DEFAULT NULL,
  `NoGoto` int(11) DEFAULT NULL,
  `NoSpec` int(11) DEFAULT NULL,
  PRIMARY KEY (`Key`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12959 ;
Edited by Razerz
  • 0
Rappy Enthusiast

Rappy

Posted
Posted (edited)

Imi trebuie un screen shot cu tabela cu valori in ea, nu designul ei.

Edited by Rappy
  • 0
Razerz Apprentice

Razerz

Posted
  • Author
Posted (edited)

Nu am inteles, mai exact trebuie sa iti dau tabelu unde sunt cont-urile creeate? sau astea

 

            //--------------------------- Account INSERT ---------------------//
            gsString[ 0 ] = EOS;
			format( gsString, 2048, "INSERT INTO `Accounts`(`Key`, `Name`, `IP`, `Password`, `RegisterDate`, `LoggedIn`, `Level`, `Vip`, `rVip`, `LastOn`, \
									 `Cash`, `Score`, `Kills`, `Deaths`, `Online`, `Rank`, `BestKillings`, `KillingSpree`, `Drugs`, `TimesOnServer`," );
			format( gsString, 2048, "%s`Coins`, `SAdmin`, `FavSkin`, `UseSkin`, `Description1`, `Description2`, `Description3`, `Positive`, `Negative`, \
									 `Clan`, `ClanRank`, `E-Mail`, `ClanPoints`, `ClanDeaths`, `ClanOnline`, `ClanJoined`, `Kicks`, `Bans`, `Jails`,", gsString );
			format( gsString, 2048, "%s`Warns`, `ClearChats`, `ReactionTest`, `MathTest`, `Mutes`, `ARatio`, `Property`, `Jailed`, `JailTime`, `Frozen`, \
									 `FreezeTime`, `RAdmin`, `ChatColor`, `RaceScore`, `StuntScore`, `DriftScore`, `DuelScore`, `CNRScore`, `vSpawn_X`, `vSpawn_Y`, `vSpawn_Z`, `vSpawn_A`, \
									 `TopOnline`, `AdminWarns`, `OwnedCarID`, `SavingSts`, `HouseID`, `BankMoney`,", gsString );
			format( gsString, 2048, "%s`Lang`, `GangID`,`GangKills`,`GangDeaths`,`GangRank`,`GangWarns`,`GangCaptures`,`GangPoints`, `NoPM`, `NoGoto`, `NoSpec`)", gsString );

			format( gsString, 2048, "%s VALUES (0, '%s', '%s', '%s', '%d-%d-%d', 1, 0, 0, 0, '%d-%d-%d', \
											 500000, 50, 0, 0, '00:00:00', 0, 0, 0, 0, 1, \
											 0, 0, 0, 0, ' ', ' ', ' ', 0, 0,", gsString, PlayerName( playerid ), GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay, liYear, liMonth, liDay );
			format( gsString, 2048, "%s'None', 0, ' ', 0, 0, '00:00:00', 'None', 0, 0, 0, \
											 0, 0, 0, 0, 0, 0, 0, 0, '00:00', 0, \
											 '00:00', 0, '0xFFFFFFFF', 0, 0, 0, 0, 0, 0.00, 0.00, 0.00, 0.00, \
											 0, 0, 0, '0,0', 0, 0, %d, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)", gsString, Lang[ playerid ] );
			mysql_function_query( g_Handle, gsString, false, "OnAccountCreated", "i", playerid );

SavePlayer( playerid )
{
	new Ratio[ 7 ], h, m, s, c_h, c_m, c_s, szYear, szMonth, szDay;

	Ratio[ 0 ] = PlayerInfo[ playerid ][ PKicks ] + PlayerInfo[ playerid ][ PBans ];
	Ratio[ 1 ] = Ratio[ 0 ] + PlayerInfo[ playerid ][ PWarns ];
	Ratio[ 2 ] = Ratio[ 1 ] + PlayerInfo[ playerid ][ PJails ];
	Ratio[ 3 ] = Ratio[ 2 ] + PlayerInfo[ playerid ][ PClearCH ];
	Ratio[ 4 ] = Ratio[ 3 ] + PlayerInfo[ playerid ][ PReactions ];
	Ratio[ 5 ] = Ratio[ 4 ] + PlayerInfo[ playerid ][ PMaths ];
	Ratio[ 6 ] = Ratio[ 5 ] + PlayerInfo[ playerid ][ PMutes ];

    TotalGameTime( playerid, h, m, s );
    TotalClanTime( playerid, c_h, c_m, c_s );
	getdate( szYear, szMonth, szDay );

	gsString[ 0 ] = EOS;
	format( gsString, 3048, "UPDATE `Accounts` SET `LoggedIn` = 0,`Level` = %d,`Vip` = %d,`rVip` = %d,`LastOn` = '%d-%d-%d',`Cash` = %d", PlayerInfo[ playerid ][ Level ], PlayerInfo[ playerid ][ pVip ], PlayerInfo[ playerid ][ rVip ], szYear, szMonth, szDay, GetPlayerMoney( playerid ) );
	format( gsString, 3048, "%s,`Score` = %d,`Kills` = %d,`Deaths` = %d,`Online` = '%02d:%02d:%02d',`Rank` = '%s',`BestKillings` = '%d'", gsString, GetPlayerScore( playerid ), PlayerInfo[ playerid ][ Kills ], PlayerInfo[ playerid ][ Deaths ], h, m, s, PlayerInfo[ playerid ][ RankName ], PlayerInfo[ playerid ][ bKillingSpree ] );
	format( gsString, 3048, "%s,`KillingSpree` = '%d',`Drugs` = '%d',`TimesOnServer` = `TimesOnServer`+1,`Coins` = '%d',`SAdmin` = '%d'", gsString, PlayerInfo[ playerid ][ KillingSpree ], PlayerInfo[ playerid ][ Drugs ], PlayerInfo[ playerid ][ Coins ], PlayerInfo[ playerid ][ SAdmin ] );
	format( gsString, 3048, "%s,`FavSkin` = '%d',`UseSkin` = '%d',`Description1` = '%s',`Description2` = '%s',`Description3` = '%s',`Positive` = '%d',`Negative` = '%d'", gsString, PlayerInfo[ playerid ][ FavSkin ], PlayerInfo[ playerid ][ UseSkin ], PlayerInfo[ playerid ][ Description1 ], PlayerInfo[ playerid ][ Description2 ], PlayerInfo[ playerid ][ Description3 ], PlayerInfo[ playerid ][ PosRespect ], PlayerInfo[ playerid ][ NegRespect ] );
	format( gsString, 3048, "%s,`Clan` = '%s',`ClanRank` = '%d',`ClanPoints` = %d,`ClanDeaths` = %d,`ClanOnline` = '%02d:%02d:%02d',`ClanJoined` = '%s'", gsString, PlayerInfo[ playerid ][ Clan ], PlayerInfo[ playerid ][ rank ], PlayerInfo[ playerid ][ c_points ], PlayerInfo[ playerid ][ c_deaths ], c_h, c_m, c_s, PlayerInfo[ playerid ][ JoinedInClan ] );
	format( gsString, 3048, "%s,`Kicks` = '%d',`Bans` = '%d',`Jails` = '%d',`Warns` = '%d',`ClearChats` = '%d',`ReactionTest` = '%d',`MathTest` = '%d'", gsString, PlayerInfo[ playerid ][ PKicks ], PlayerInfo[ playerid ][ PBans ], PlayerInfo[ playerid ][ PJails ], PlayerInfo[ playerid ][ PWarns ], PlayerInfo[ playerid ][ PClearCH ], PlayerInfo[ playerid ][ PReactions ], PlayerInfo[ playerid ][ PMaths ] );
	format( gsString, 3048, "%s,`Mutes` = '%d',`ARatio` = '%d',`Property` = '%d',`Jailed` = '%d',`JailTime` = '%d:%d',`Frozen` = %d,`FreezeTime` = '%d:%d'", gsString, PlayerInfo[ playerid ][ PMutes ], Ratio[ 6 ], PlayerInfo[ playerid ][ Property ], PlayerInfo[ playerid ][ Jailed ], gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ], PlayerInfo[ playerid ][ Frozen ], gTime[ playerid ][ 0 ], gTime[ playerid ][ 1 ] );
	format( gsString, 3048, "%s,`RAdmin` = '%d', `ChatColor` = %d, `RaceScore` = '%d', `StuntScore` = '%d', `CNRScore` = %d", gsString, PlayerInfo[ playerid ][ rAdmin ], PlayerInfo[ playerid ][ p_TextColor ], PlayerInfo[ playerid ][ Race_Score ], PlayerInfo[ playerid ][ Stunt_Score ], PlayerInfo[ playerid ][ CNR_Score ] );
	format( gsString, 3048, "%s,`DriftScore` = '%d',`DuelScore` = '%d',`vSpawn_X` = %.2f, `vSpawn_Y` = %.2f, `vSpawn_Z` = %.2f, `vSpawn_A` = %.2d", gsString, PlayerInfo[ playerid ][ Drift_Score ], PlayerInfo[ playerid ][ D_Score ], GetPVarFloat( playerid, "vSpawn_X" ), GetPVarFloat( playerid, "vSpawn_Y" ), GetPVarFloat( playerid, "vSpawn_Z" ), GetPVarFloat( playerid, "vSpawn_A" ) );
	format( gsString, 3048, "%s,`TopOnline` = %02d%02d%02d,`OwnedCarID` = %d,`AdminWarns` = %d,`SavingSts` = '%d,%d',`HouseID` = %d", gsString, PlayerInfo[ playerid ][ hours ], PlayerInfo[ playerid ][ mins ], PlayerInfo[ playerid ][ secs ], PlayerInfo[ playerid ][ CarID ], PlayerInfo[ playerid ][ AdminWarns ], PlayerInfo[ playerid ][ p_HoldSaving ], PlayerInfo[ playerid ][ p_VehicleHoldSaving ], PlayerInfo[ playerid ][ szOwnedHouseID ] );
	format( gsString, 3048, "%s,`BankMoney` = %d,`Lang` = %d,`NoPM` = %d,`NoGoto` = %d,`NoSpec` = %d", gsString, PlayerInfo[ playerid ][ P_BANK_MONEY ], Lang[ playerid ], PlayerInfo[ playerid ][ NoPM ], PlayerInfo[ playerid ][ GotoIgnored ], PlayerInfo[ playerid ][ Ignore_Spec ] );
	format( gsString, 3048, "%s,`GangID` = %d,`GangRank` = %d,`GangKills` = %d,`GangDeaths` = %d,`GangWarns` = %d,`GangCaptures` = %d,`GangPoints` = %d WHERE `Key` = %d", gsString, Users[ playerid ][ gang ], Users[ playerid ][ isLeader ], Users[ playerid ][ g_Kills ], Users[ playerid ][ g_Deaths ], Users[ playerid ][ g_Warns ], Users[ playerid ][ g_Captures ], Users[ playerid ][ g_Points ], PlayerInfo[ playerid ][ AccID ] );
	mysql_function_query( g_Handle, gsString, false, "", "" );
	
	
	...continuare....

 

Edited by Razerz
  • 0
  • Administrator
WopsS Grand Master

WopsS

Posted
  • Administrator
Posted

La CheckAccountPassword adauga prima data inainte de orice verificare

new Rows, Fields;

cache_get_data(Rows, Fields);

if (Rows == 0)
    return 0;

 

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to question listing
×
×
  • 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.