Jump to content
FREAKHOSTING - Servere Jocuri incepand de la €2.99 pe luna
  • 0

Problema CMySQLResult::GetRowDataByName()

SkyLeAs

Asked by SkyLeAs,

 Share

Question

SkyLeAs Proficient

SkyLeAs

Posted
Posted

Salut am o problema si nu stiu dece 0.o in server log nu am nici o eroare nmk nmk.

Azi cand am intrat in mysq log mam trezit cu asta 

In callback "CheckAccountPassword"
12:34:52	CMySQLResult::GetRowDataByName()	ERROR	invalid row index ('0')
In callback "LoginPlayerAccount"
In callback "CheckAccountPassword"
12:35:07	CMySQLResult::GetRowDataByName()	ERROR	invalid row index ('0')
In callback "CheckAccountPassword"
12:35:12	CMySQLResult::GetRowDataByName()	ERROR	invalid row index ('0')

Si nu stiu dela ce este 0.o :(( Ma poate ajuta cineva.

Link to comment
Share on other sites

9 answers to this question

Recommended Posts

  • 0
SkyLeAs Proficient

SkyLeAs

Posted
  • Author
Posted

posteaza callback-ul CheckAccountPassword

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 ][ 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, "{fcfcfc}Hi [ {c2fc00}%s{fcfcfc} ]n
                                       {fcfcfc}You have been LoggedIn:nn
			                       	   {FF0000}• {fcfcfc}Admin Level: [ {c2fc00}%d{fcfcfc} ]n
        						       {FF0000}• {fcfcfc}VIP Level: [ {c2fc00}%d{fcfcfc} ]n
            					       {FF0000}• {fcfcfc}Stats Note: [ {c2fc00}%d{fcfcfc}/{c2fc00}10{fcfcfc} ]nn
                                       {FF0000}• {fcfcfc}Use {c2fc00}/Stats{fcfcfc} for more details!",
								       PlayerName(playerid), PlayerInfo[playerid][Level],
							           PlayerInfo[playerid][pVip], GiveNote(playerid));
	  			return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}S{FF0000}G{AFAFAF} - {fcfcfc}Account {c2fc00}Info", xxstring, "Ok","");
				}
				case 1:
				{
				format(xxstring, 512, "{fcfcfc}Salut [ {c2fc00}%s{fcfcfc} ]n
                                       {fcfcfc}Ai fost logat cu succes:nn
			                       	   {FF0000}• {fcfcfc}Admin Level: [ {c2fc00}%d{fcfcfc} ]n
        						       {FF0000}• {fcfcfc}VIP Level: [ {c2fc00}%d{fcfcfc} ]n
            					       {FF0000}• {fcfcfc}Stats Note: [ {c2fc00}%d{fcfcfc}/{c2fc00}10{fcfcfc} ]nn
                                       {FF0000}• {fcfcfc}Foloseste {c2fc00}/Stats{fcfcfc} pentru mai multe detalii!",
								       PlayerName(playerid), PlayerInfo[playerid][Level],
	  							       PlayerInfo[playerid][pVip], GiveNote(playerid));
	  			return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}S{FF0000}G{AFAFAF} - {fcfcfc}Account {c2fc00}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, "ttt{FF0000}ACCOUNT:nn{ACACAC}Login failed! Incorrect Password.nATTEMPTS: {FF0000}%d/%dnn{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, "tttt{FF0000}CONT:nn{ACACAC}Logarea nu a reusit! Parola Incorecta.nINCERCARI: {FF0000}%d/%dnn{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 );
}
Link to comment
Share on other sites
  • 0
#Teddy Contributor

#Teddy

Posted
Posted

Incearca asa:

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 ][ 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, "{fcfcfc}Hi [ {c2fc00}%s{fcfcfc} ]n
                                       {fcfcfc}You have been LoggedIn:nn
                          {FF0000}• {fcfcfc}Admin Level: [ {c2fc00}%d{fcfcfc} ]n
                {FF0000}• {fcfcfc}VIP Level: [ {c2fc00}%d{fcfcfc} ]n
                    {FF0000}• {fcfcfc}Stats Note: [ {c2fc00}%d{fcfcfc}/{c2fc00}10{fcfcfc} ]nn
                                       {FF0000}• {fcfcfc}Use {c2fc00}/Stats{fcfcfc} for more details!",
      PlayerName(playerid), PlayerInfo[playerid][Level],
          PlayerInfo[playerid][pVip], GiveNote(playerid));
  return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}S{FF0000}G{AFAFAF} - {fcfcfc}Account {c2fc00}Info", xxstring, "Ok","");
}
case 1:
{
format(xxstring, 512, "{fcfcfc}Salut [ {c2fc00}%s{fcfcfc} ]n
                                       {fcfcfc}Ai fost logat cu succes:nn
                          {FF0000}• {fcfcfc}Admin Level: [ {c2fc00}%d{fcfcfc} ]n
                {FF0000}• {fcfcfc}VIP Level: [ {c2fc00}%d{fcfcfc} ]n
                    {FF0000}• {fcfcfc}Stats Note: [ {c2fc00}%d{fcfcfc}/{c2fc00}10{fcfcfc} ]nn
                                       {FF0000}• {fcfcfc}Foloseste {c2fc00}/Stats{fcfcfc} pentru mai multe detalii!",
      PlayerName(playerid), PlayerInfo[playerid][Level],
         PlayerInfo[playerid][pVip], GiveNote(playerid));
  return ShowPlayerDialog(playerid, 0, DIALOG_STYLE_MSGBOX, "{0066CC}X{FFFF00}S{FF0000}G{AFAFAF} - {fcfcfc}Account {c2fc00}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, "ttt{FF0000}ACCOUNT:nn{ACACAC}Login failed! Incorrect Password.nATTEMPTS: {FF0000}%d/%dnn{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, "tttt{FF0000}CONT:nn{ACACAC}Logarea nu a reusit! Parola Incorecta.nINCERCARI: {FF0000}%d/%dnn{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 );
}

Ocupation: Youtube, Mined Bitcoin's, Scripting & Mapping SA:MP

Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 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.

  I accept