1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
GetRowDataByName() - invalid row index ('0')
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#1

14.08.2016, 21:14
Hello

In my file "MySQL_log" i have this problem

Код HTML:
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[22:56:51] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
This problem is when connecte and succesfise on server (passeword succed)

Код HTML:
case THREAD_LOAD_CHARACTER:
		{

		    cache_get_data(rows, fields, g_iHandle);
						pInfo[extraid][pID] = cache_get_field_int(0, "ID");
			pInfo[extraid][Registered] = cache_get_field_int(0, "Enregistrer");
			pInfo[extraid][Admin] = cache_get_field_int(0, "Admin");
					//cache_get_field_content(0, "Birthdate", pInfo[extraid][pBirthdate], g_iHandle, 24);
			        //cache_get_field_content(0, "Origin", pInfo[extraid][pOrigin], g_iHandle, 32);
			pInfo[extraid][Level] = cache_get_field_int(0, "Level");
			pInfo[extraid][Exp] = cache_get_field_int(0, "Exp");
			pInfo[extraid][MaxExp] = cache_get_field_int(0, "MaxExp");
			pInfo[extraid][Skin] = cache_get_field_int(0, "Skin");
			pInfo[extraid][Gender] = cache_get_field_int(0, "Sexe");
            pInfo[extraid][Health] = cache_get_field_float(0, "Vie");
            pInfo[extraid][Armour] = cache_get_field_float(0, "Gillet");
            pInfo[extraid][HandMoney] = cache_get_field_int(0, "Cash");
			pInfo[extraid][BankMoney] = cache_get_field_int(0, "BanqueCash");
			pInfo[extraid][Mask] = cache_get_field_int(0, "Masque");
			pInfo[extraid][MaskID] = cache_get_field_int(0, "MasqueID");
			pInfo[extraid][PhoneNumber] = cache_get_field_int(0, "NumeroTel");
			pInfo[extraid][HouseOwner] = cache_get_field_int(0, "Maison");
			pInfo[extraid][BizOwner] = cache_get_field_int(0, "Commerce");
			pInfo[extraid][FacOwner] = cache_get_field_int(0, "FactionProprio");
			pInfo[extraid][VehicleOwner] = cache_get_field_int(0, "Vehicule1");
			pInfo[extraid][VehicleOwner2] = cache_get_field_int(0, "Vehicule2");
			pInfo[extraid][VehicleOwner3] = cache_get_field_int(0, "Vehicule3");
			pInfo[extraid][SecteID] = cache_get_field_int(0, "Faction");
			pInfo[extraid][Grade] = cache_get_field_int(0, "Grade");
			pInfo[extraid][PayeCheck] = cache_get_field_int(0, "ChequeJob");
			pInfo[extraid][PayeTime] = cache_get_field_int(0, "TempsTravail");
			pInfo[extraid][Montre] = cache_get_field_int(0, "Montre");
			pInfo[extraid][Gps] = cache_get_field_int(0, "GPS");
			pInfo[extraid][Canne] = cache_get_field_int(0, "Canne");
			pInfo[extraid][Phone] = cache_get_field_int(0, "Telephone");
			pInfo[extraid][Credits] = cache_get_field_int(0, "Credits");
			pInfo[extraid][CarteIden] = cache_get_field_int(0, "Identite");
			pInfo[extraid][DrogueFab1] = cache_get_field_int(0, "GramDrogue1");
			pInfo[extraid][DrogueFab2] = cache_get_field_int(0, "GramDrogue2");
			pInfo[extraid][DrogueFab3] = cache_get_field_int(0, "GramDrogue3");
			pInfo[extraid][Cocaine] = cache_get_field_int(0, "Cocaine");
			pInfo[extraid][Heroine] = cache_get_field_int(0, "Heroine");
			pInfo[extraid][Ecstacy] = cache_get_field_int(0, "Ecstacy");
			pInfo[extraid][Mort] = cache_get_field_int(0, "Mort");
			pInfo[extraid][JailTime] = cache_get_field_int(0, "JailTemps");
			pInfo[extraid][Amende] = cache_get_field_int(0, "Amende");
			pInfo[extraid][Facture] = cache_get_field_int(0, "Facture");
			pInfo[extraid][Emprunt] = cache_get_field_int(0, "Emprunt");
			pInfo[extraid][Lotto] = cache_get_field_int(0, "Warn");
            pInfo[extraid][Baned] = cache_get_field_int(0, "Bannis");
			pInfo[extraid][Permis] = cache_get_field_int(0, "Permis");
		    pInfo[extraid][PermisPoint] = cache_get_field_int(0, "PointPermis");
			pInfo[extraid][PortArme] = cache_get_field_int(0, "PortArme");
		    pInfo[extraid][LastPos] = cache_get_field_int(0, "Situation");
	        pInfo[extraid][Weapon1] = cache_get_field_int(0, "Arme1");
	        pInfo[extraid][Wep1Ammo] = cache_get_field_int(0, "Wep1Ammo");
	        pInfo[extraid][Weapon2] = cache_get_field_int(0, "Arme2");
	        pInfo[extraid][Wep2Ammo] = cache_get_field_int(0, "Wep2Ammo");
	        pInfo[extraid][Weapon3] = cache_get_field_int(0, "Arme3");
	        pInfo[extraid][Wep3Ammo] = cache_get_field_int(0, "Wep3Ammo");
	        pInfo[extraid][Weapon4] = cache_get_field_int(0, "Arme4");
	        pInfo[extraid][Wep4Ammo] = cache_get_field_int(0, "Wep4Ammo");
	        pInfo[extraid][Weapon5] = cache_get_field_int(0, "Arme5");
	        pInfo[extraid][Wep5Ammo] = cache_get_field_int(0, "Wep5Ammo");
	        pInfo[extraid][Weapon6] = cache_get_field_int(0, "Arme6");
	        pInfo[extraid][Wep6Ammo] = cache_get_field_int(0, "Wep6Ammo");
	        pInfo[extraid][Weapon7] = cache_get_field_int(0, "Arme7");
	        pInfo[extraid][Wep7Ammo] = cache_get_field_int(0, "Wep7Ammo");
					//cache_get_field_content(0, "Warn1", pInfo[extraid][pWarn1], g_iHandle, 32);
					//cache_get_field_content(0, "Warn2", pInfo[extraid][pWarn2], g_iHandle, 32);

			if (pInfo[extraid][Admin] > 0)
			{
				SendClientMessage(extraid, -1, "Vous кtes connectй en tant qu'admuinistrateur.");
				       
			}
	        pInfo[extraid][pLogged] = 1;
		    SendClientMessage(extraid, -1, "Connexion rйussi veuillez informer le fondateur");
		    SetTimerEx("SpawnTimer", 1000, false, "d", extraid);
                  
									
		}
Find
Reply
Vince
Spam Machine
*****
Posts: 10,066
Threads: 38
Joined: Sep 2007
Reputation: 0
#2

14.08.2016, 22:10
cache_get_data is of little use if you don't check its output, i.e. whether there are actually any rows in the result.
Find
Reply
Shinja
Gangsta
*****
Posts: 969
Threads: 26
Joined: Jan 2016
Reputation: 0
#3

14.08.2016, 22:17
( Последний раз редактировалось Shinja; 15.08.2016 в 02:48. )
Show us where you are executing the query

You'd better use
PHP код:
cache_get_row_int(row, field_idx) 
PHP код:
cache_get_row_float(row, field_idx) 
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#4

15.08.2016, 12:06
Quote:
Originally Posted by Vince
Посмотреть сообщение
cache_get_data is of little use if you don't check its output, i.e. whether there are actually any rows in the result.
I have added this " { } " and this problem still there

Код HTML:
case THREAD_LOAD_CHARACTER:
		{

		  { cache_get_data(rows, fields, g_iHandle);

				        
			pInfo[extraid][pID] = cache_get_field_int(0, "ID");
			pInfo[extraid][Registered] = cache_get_field_int(0, "Enregistrer");
			pInfo[extraid][Admin] = cache_get_field_int(0, "Admin");
			pInfo[extraid][Level] = cache_get_field_int(0, "Level");
			pInfo[extraid][Exp] = cache_get_field_int(0, "Exp");
			pInfo[extraid][MaxExp] = cache_get_field_int(0, "MaxExp");
			pInfo[extraid][Skin] = cache_get_field_int(0, "Skin");
			pInfo[extraid][Gender] = cache_get_field_int(0, "Sexe");
            pInfo[extraid][Health] = cache_get_field_float(0, "Vie");
            pInfo[extraid][Armour] = cache_get_field_float(0, "Gillet");
            pInfo[extraid][HandMoney] = cache_get_field_int(0, "Cash");
			pInfo[extraid][BankMoney] = cache_get_field_int(0, "BanqueCash");
			pInfo[extraid][Mask] = cache_get_field_int(0, "Masque");
			pInfo[extraid][MaskID] = cache_get_field_int(0, "MasqueID");
			pInfo[extraid][PhoneNumber] = cache_get_field_int(0, "NumeroTel");
			pInfo[extraid][HouseOwner] = cache_get_field_int(0, "Maison");
			pInfo[extraid][BizOwner] = cache_get_field_int(0, "Commerce");
			pInfo[extraid][FacOwner] = cache_get_field_int(0, "FactionProprio");
			pInfo[extraid][VehicleOwner] = cache_get_field_int(0, "Vehicule1");
			pInfo[extraid][VehicleOwner2] = cache_get_field_int(0, "Vehicule2");
			pInfo[extraid][VehicleOwner3] = cache_get_field_int(0, "Vehicule3");
			pInfo[extraid][SecteID] = cache_get_field_int(0, "Faction");
			pInfo[extraid][Grade] = cache_get_field_int(0, "Grade");
			pInfo[extraid][PayeCheck] = cache_get_field_int(0, "ChequeJob");
			pInfo[extraid][PayeTime] = cache_get_field_int(0, "TempsTravail");
			pInfo[extraid][Montre] = cache_get_field_int(0, "Montre");
			pInfo[extraid][Gps] = cache_get_field_int(0, "GPS");
			pInfo[extraid][Canne] = cache_get_field_int(0, "Canne");
			pInfo[extraid][Phone] = cache_get_field_int(0, "Telephone");
			pInfo[extraid][Credits] = cache_get_field_int(0, "Credits");
			pInfo[extraid][CarteIden] = cache_get_field_int(0, "Identite");
			pInfo[extraid][DrogueFab1] = cache_get_field_int(0, "GramDrogue1");
			pInfo[extraid][DrogueFab2] = cache_get_field_int(0, "GramDrogue2");
			pInfo[extraid][DrogueFab3] = cache_get_field_int(0, "GramDrogue3");
			pInfo[extraid][Cocaine] = cache_get_field_int(0, "Cocaine");
			pInfo[extraid][Heroine] = cache_get_field_int(0, "Heroine");
			pInfo[extraid][Ecstacy] = cache_get_field_int(0, "Ecstacy");
			pInfo[extraid][Mort] = cache_get_field_int(0, "Mort");
			pInfo[extraid][JailTime] = cache_get_field_int(0, "JailTemps");
			pInfo[extraid][Amende] = cache_get_field_int(0, "Amende");
			pInfo[extraid][Facture] = cache_get_field_int(0, "Facture");
			pInfo[extraid][Emprunt] = cache_get_field_int(0, "Emprunt");
			pInfo[extraid][Lotto] = cache_get_field_int(0, "Warn");
            pInfo[extraid][Baned] = cache_get_field_int(0, "Bannis");
			pInfo[extraid][Permis] = cache_get_field_int(0, "Permis");
		    pInfo[extraid][PermisPoint] = cache_get_field_int(0, "PointPermis");
			pInfo[extraid][PortArme] = cache_get_field_int(0, "PortArme");
		    pInfo[extraid][LastPos] = cache_get_field_int(0, "Situation");
	        pInfo[extraid][Weapon1] = cache_get_field_int(0, "Arme1");
	        pInfo[extraid][Wep1Ammo] = cache_get_field_int(0, "Wep1Ammo");
	        pInfo[extraid][Weapon2] = cache_get_field_int(0, "Arme2");
	        pInfo[extraid][Wep2Ammo] = cache_get_field_int(0, "Wep2Ammo");
	        pInfo[extraid][Weapon3] = cache_get_field_int(0, "Arme3");
	        pInfo[extraid][Wep3Ammo] = cache_get_field_int(0, "Wep3Ammo");
	        pInfo[extraid][Weapon4] = cache_get_field_int(0, "Arme4");
	        pInfo[extraid][Wep4Ammo] = cache_get_field_int(0, "Wep4Ammo");
	        pInfo[extraid][Weapon5] = cache_get_field_int(0, "Arme5");
	        pInfo[extraid][Wep5Ammo] = cache_get_field_int(0, "Wep5Ammo");
	        pInfo[extraid][Weapon6] = cache_get_field_int(0, "Arme6");
	        pInfo[extraid][Wep6Ammo] = cache_get_field_int(0, "Wep6Ammo");
	        pInfo[extraid][Weapon7] = cache_get_field_int(0, "Arme7");
	        pInfo[extraid][Wep7Ammo] = cache_get_field_int(0, "Wep7Ammo");
					
			if (pInfo[extraid][Admin] > 0)
			{
				SendClientMessage(extraid, -1, "Vous кtes connectй en tant qu'admuinistrateur.");
				        //SendAdminAction(extraid, "You have logged in a level %d admin.", pInfo[extraid][pAdmin]);
			}
	        pInfo[extraid][pLogged] = 1;
		    SendClientMessage(extraid, -1, "Connexion rйussi veuillez informer le fondateur");
		    SetTimerEx("SpawnTimer", 1000, false, "d", extraid); }
		}
Find
Reply
Luis-
High-roller
*****
Posts: 3,934
Threads: 353
Joined: Jan 2010
Reputation: 0
#5

15.08.2016, 12:10
I don't understand why you've added extra brackets, surely you're Pawno has either 26 errors or has completely stopped responding..

pawn Код:
case THREAD_LOAD_CHARACTER:
{
    cache_get_data(rows, fields, g_iHandle);

                
    pInfo[extraid][pID] = cache_get_field_int(0, "ID");
    pInfo[extraid][Registered] = cache_get_field_int(0, "Enregistrer");
    pInfo[extraid][Admin] = cache_get_field_int(0, "Admin");
    pInfo[extraid][Level] = cache_get_field_int(0, "Level");
    pInfo[extraid][Exp] = cache_get_field_int(0, "Exp");
    pInfo[extraid][MaxExp] = cache_get_field_int(0, "MaxExp");
    pInfo[extraid][Skin] = cache_get_field_int(0, "Skin");
    pInfo[extraid][Gender] = cache_get_field_int(0, "Sexe");
    pInfo[extraid][Health] = cache_get_field_float(0, "Vie");
    pInfo[extraid][Armour] = cache_get_field_float(0, "Gillet");
    pInfo[extraid][HandMoney] = cache_get_field_int(0, "Cash");
    pInfo[extraid][BankMoney] = cache_get_field_int(0, "BanqueCash");
    pInfo[extraid][Mask] = cache_get_field_int(0, "Masque");
    pInfo[extraid][MaskID] = cache_get_field_int(0, "MasqueID");
    pInfo[extraid][PhoneNumber] = cache_get_field_int(0, "NumeroTel");
    pInfo[extraid][HouseOwner] = cache_get_field_int(0, "Maison");
    pInfo[extraid][BizOwner] = cache_get_field_int(0, "Commerce");
    pInfo[extraid][FacOwner] = cache_get_field_int(0, "FactionProprio");
    pInfo[extraid][VehicleOwner] = cache_get_field_int(0, "Vehicule1");
    pInfo[extraid][VehicleOwner2] = cache_get_field_int(0, "Vehicule2");
    pInfo[extraid][VehicleOwner3] = cache_get_field_int(0, "Vehicule3");
    pInfo[extraid][SecteID] = cache_get_field_int(0, "Faction");
    pInfo[extraid][Grade] = cache_get_field_int(0, "Grade");
    pInfo[extraid][PayeCheck] = cache_get_field_int(0, "ChequeJob");
    pInfo[extraid][PayeTime] = cache_get_field_int(0, "TempsTravail");
    pInfo[extraid][Montre] = cache_get_field_int(0, "Montre");
    pInfo[extraid][Gps] = cache_get_field_int(0, "GPS");
    pInfo[extraid][Canne] = cache_get_field_int(0, "Canne");
    pInfo[extraid][Phone] = cache_get_field_int(0, "Telephone");
    pInfo[extraid][Credits] = cache_get_field_int(0, "Credits");
    pInfo[extraid][CarteIden] = cache_get_field_int(0, "Identite");
    pInfo[extraid][DrogueFab1] = cache_get_field_int(0, "GramDrogue1");
    pInfo[extraid][DrogueFab2] = cache_get_field_int(0, "GramDrogue2");
    pInfo[extraid][DrogueFab3] = cache_get_field_int(0, "GramDrogue3");
    pInfo[extraid][Cocaine] = cache_get_field_int(0, "Cocaine");
    pInfo[extraid][Heroine] = cache_get_field_int(0, "Heroine");
    pInfo[extraid][Ecstacy] = cache_get_field_int(0, "Ecstacy");
    pInfo[extraid][Mort] = cache_get_field_int(0, "Mort");
    pInfo[extraid][JailTime] = cache_get_field_int(0, "JailTemps");
    pInfo[extraid][Amende] = cache_get_field_int(0, "Amende");
    pInfo[extraid][Facture] = cache_get_field_int(0, "Facture");
    pInfo[extraid][Emprunt] = cache_get_field_int(0, "Emprunt");
    pInfo[extraid][Lotto] = cache_get_field_int(0, "Warn");
    pInfo[extraid][Baned] = cache_get_field_int(0, "Bannis");
    pInfo[extraid][Permis] = cache_get_field_int(0, "Permis");
    pInfo[extraid][PermisPoint] = cache_get_field_int(0, "PointPermis");
    pInfo[extraid][PortArme] = cache_get_field_int(0, "PortArme");
    pInfo[extraid][LastPos] = cache_get_field_int(0, "Situation");
    pInfo[extraid][Weapon1] = cache_get_field_int(0, "Arme1");
    pInfo[extraid][Wep1Ammo] = cache_get_field_int(0, "Wep1Ammo");
    pInfo[extraid][Weapon2] = cache_get_field_int(0, "Arme2");
    pInfo[extraid][Wep2Ammo] = cache_get_field_int(0, "Wep2Ammo");
    pInfo[extraid][Weapon3] = cache_get_field_int(0, "Arme3");
    pInfo[extraid][Wep3Ammo] = cache_get_field_int(0, "Wep3Ammo");
    pInfo[extraid][Weapon4] = cache_get_field_int(0, "Arme4");
    pInfo[extraid][Wep4Ammo] = cache_get_field_int(0, "Wep4Ammo");
    pInfo[extraid][Weapon5] = cache_get_field_int(0, "Arme5");
    pInfo[extraid][Wep5Ammo] = cache_get_field_int(0, "Wep5Ammo");
    pInfo[extraid][Weapon6] = cache_get_field_int(0, "Arme6");
    pInfo[extraid][Wep6Ammo] = cache_get_field_int(0, "Wep6Ammo");
    pInfo[extraid][Weapon7] = cache_get_field_int(0, "Arme7");
    pInfo[extraid][Wep7Ammo] = cache_get_field_int(0, "Wep7Ammo");
            
    if (pInfo[extraid][Admin] > 0)
    {
        SendClientMessage(extraid, -1, "Vous кtes connectй en tant qu'admuinistrateur.");
                //SendAdminAction(extraid, "You have logged in a level %d admin.", pInfo[extraid][pAdmin]);
    }
    pInfo[extraid][pLogged] = 1;
    SendClientMessage(extraid, -1, "Connexion rйussi veuillez informer le fondateur");
    SetTimerEx("SpawnTimer", 1000, false, "d", extraid); 
}
I've not fixed your problem, just removed the extra brackets, and sorted out the indentation.
Find
Reply
Stinged
High-roller
*****
Posts: 1,578
Threads: 15
Joined: Feb 2013
Reputation: 0
#6

15.08.2016, 12:59
Quote:
Originally Posted by Vince
Посмотреть сообщение
cache_get_data is of little use if you don't check its output, i.e. whether there are actually any rows in the result.
Vince already gave the solution, why hasn't anyone implemented it?

Код:
case THREAD_LOAD_CHARACTER:
{
	if (cache_get_row_count(g_iHandle) == 0)
        {
                // No rows found
                return 1;
        }
 
				
	pInfo[extraid][pID] = cache_get_field_int(0, "ID");
	pInfo[extraid][Registered] = cache_get_field_int(0, "Enregistrer");
	pInfo[extraid][Admin] = cache_get_field_int(0, "Admin");
	pInfo[extraid][Level] = cache_get_field_int(0, "Level");
	pInfo[extraid][Exp] = cache_get_field_int(0, "Exp");
	pInfo[extraid][MaxExp] = cache_get_field_int(0, "MaxExp");
	pInfo[extraid][Skin] = cache_get_field_int(0, "Skin");
	pInfo[extraid][Gender] = cache_get_field_int(0, "Sexe");
	pInfo[extraid][Health] = cache_get_field_float(0, "Vie");
	pInfo[extraid][Armour] = cache_get_field_float(0, "Gillet");
	pInfo[extraid][HandMoney] = cache_get_field_int(0, "Cash");
	pInfo[extraid][BankMoney] = cache_get_field_int(0, "BanqueCash");
	pInfo[extraid][Mask] = cache_get_field_int(0, "Masque");
	pInfo[extraid][MaskID] = cache_get_field_int(0, "MasqueID");
	pInfo[extraid][PhoneNumber] = cache_get_field_int(0, "NumeroTel");
	pInfo[extraid][HouseOwner] = cache_get_field_int(0, "Maison");
	pInfo[extraid][BizOwner] = cache_get_field_int(0, "Commerce");
	pInfo[extraid][FacOwner] = cache_get_field_int(0, "FactionProprio");
	pInfo[extraid][VehicleOwner] = cache_get_field_int(0, "Vehicule1");
	pInfo[extraid][VehicleOwner2] = cache_get_field_int(0, "Vehicule2");
	pInfo[extraid][VehicleOwner3] = cache_get_field_int(0, "Vehicule3");
	pInfo[extraid][SecteID] = cache_get_field_int(0, "Faction");
	pInfo[extraid][Grade] = cache_get_field_int(0, "Grade");
	pInfo[extraid][PayeCheck] = cache_get_field_int(0, "ChequeJob");
	pInfo[extraid][PayeTime] = cache_get_field_int(0, "TempsTravail");
	pInfo[extraid][Montre] = cache_get_field_int(0, "Montre");
	pInfo[extraid][Gps] = cache_get_field_int(0, "GPS");
	pInfo[extraid][Canne] = cache_get_field_int(0, "Canne");
	pInfo[extraid][Phone] = cache_get_field_int(0, "Telephone");
	pInfo[extraid][Credits] = cache_get_field_int(0, "Credits");
	pInfo[extraid][CarteIden] = cache_get_field_int(0, "Identite");
	pInfo[extraid][DrogueFab1] = cache_get_field_int(0, "GramDrogue1");
	pInfo[extraid][DrogueFab2] = cache_get_field_int(0, "GramDrogue2");
	pInfo[extraid][DrogueFab3] = cache_get_field_int(0, "GramDrogue3");
	pInfo[extraid][Cocaine] = cache_get_field_int(0, "Cocaine");
	pInfo[extraid][Heroine] = cache_get_field_int(0, "Heroine");
	pInfo[extraid][Ecstacy] = cache_get_field_int(0, "Ecstacy");
	pInfo[extraid][Mort] = cache_get_field_int(0, "Mort");
	pInfo[extraid][JailTime] = cache_get_field_int(0, "JailTemps");
	pInfo[extraid][Amende] = cache_get_field_int(0, "Amende");
	pInfo[extraid][Facture] = cache_get_field_int(0, "Facture");
	pInfo[extraid][Emprunt] = cache_get_field_int(0, "Emprunt");
	pInfo[extraid][Lotto] = cache_get_field_int(0, "Warn");
	pInfo[extraid][Baned] = cache_get_field_int(0, "Bannis");
	pInfo[extraid][Permis] = cache_get_field_int(0, "Permis");
	pInfo[extraid][PermisPoint] = cache_get_field_int(0, "PointPermis");
	pInfo[extraid][PortArme] = cache_get_field_int(0, "PortArme");
	pInfo[extraid][LastPos] = cache_get_field_int(0, "Situation");
	pInfo[extraid][Weapon1] = cache_get_field_int(0, "Arme1");
	pInfo[extraid][Wep1Ammo] = cache_get_field_int(0, "Wep1Ammo");
	pInfo[extraid][Weapon2] = cache_get_field_int(0, "Arme2");
	pInfo[extraid][Wep2Ammo] = cache_get_field_int(0, "Wep2Ammo");
	pInfo[extraid][Weapon3] = cache_get_field_int(0, "Arme3");
	pInfo[extraid][Wep3Ammo] = cache_get_field_int(0, "Wep3Ammo");
	pInfo[extraid][Weapon4] = cache_get_field_int(0, "Arme4");
	pInfo[extraid][Wep4Ammo] = cache_get_field_int(0, "Wep4Ammo");
	pInfo[extraid][Weapon5] = cache_get_field_int(0, "Arme5");
	pInfo[extraid][Wep5Ammo] = cache_get_field_int(0, "Wep5Ammo");
	pInfo[extraid][Weapon6] = cache_get_field_int(0, "Arme6");
	pInfo[extraid][Wep6Ammo] = cache_get_field_int(0, "Wep6Ammo");
	pInfo[extraid][Weapon7] = cache_get_field_int(0, "Arme7");
	pInfo[extraid][Wep7Ammo] = cache_get_field_int(0, "Wep7Ammo");
			
	if (pInfo[extraid][Admin] > 0)
	{
		SendClientMessage(extraid, -1, "Vous кtes connectй en tant qu'admuinistrateur.");
		//SendAdminAction(extraid, "You have logged in a level %d admin.", pInfo[extraid][pAdmin]);
	}
	pInfo[extraid][pLogged] = 1;
	SendClientMessage(extraid, -1, "Connexion rйussi veuillez informer le fondateur");
	SetTimerEx("SpawnTimer", 1000, false, "d", extraid); 
}
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#7

15.08.2016, 18:36
Quote:
Originally Posted by Stinged
Посмотреть сообщение
Vince already gave the solution, why hasn't anyone implemented it?

Код:
case THREAD_LOAD_CHARACTER:
{
	if (cache_get_row_count(g_iHandle) == 0)
        {
                // No rows found
                return 1;
        }
 
				
	pInfo[extraid][pID] = cache_get_field_int(0, "ID");
	pInfo[extraid][Registered] = cache_get_field_int(0, "Enregistrer");
	pInfo[extraid][Admin] = cache_get_field_int(0, "Admin");
	pInfo[extraid][Level] = cache_get_field_int(0, "Level");
	pInfo[extraid][Exp] = cache_get_field_int(0, "Exp");
	pInfo[extraid][MaxExp] = cache_get_field_int(0, "MaxExp");
	pInfo[extraid][Skin] = cache_get_field_int(0, "Skin");
	pInfo[extraid][Gender] = cache_get_field_int(0, "Sexe");
	pInfo[extraid][Health] = cache_get_field_float(0, "Vie");
	pInfo[extraid][Armour] = cache_get_field_float(0, "Gillet");
	pInfo[extraid][HandMoney] = cache_get_field_int(0, "Cash");
	pInfo[extraid][BankMoney] = cache_get_field_int(0, "BanqueCash");
	pInfo[extraid][Mask] = cache_get_field_int(0, "Masque");
	pInfo[extraid][MaskID] = cache_get_field_int(0, "MasqueID");
	pInfo[extraid][PhoneNumber] = cache_get_field_int(0, "NumeroTel");
	pInfo[extraid][HouseOwner] = cache_get_field_int(0, "Maison");
	pInfo[extraid][BizOwner] = cache_get_field_int(0, "Commerce");
	pInfo[extraid][FacOwner] = cache_get_field_int(0, "FactionProprio");
	pInfo[extraid][VehicleOwner] = cache_get_field_int(0, "Vehicule1");
	pInfo[extraid][VehicleOwner2] = cache_get_field_int(0, "Vehicule2");
	pInfo[extraid][VehicleOwner3] = cache_get_field_int(0, "Vehicule3");
	pInfo[extraid][SecteID] = cache_get_field_int(0, "Faction");
	pInfo[extraid][Grade] = cache_get_field_int(0, "Grade");
	pInfo[extraid][PayeCheck] = cache_get_field_int(0, "ChequeJob");
	pInfo[extraid][PayeTime] = cache_get_field_int(0, "TempsTravail");
	pInfo[extraid][Montre] = cache_get_field_int(0, "Montre");
	pInfo[extraid][Gps] = cache_get_field_int(0, "GPS");
	pInfo[extraid][Canne] = cache_get_field_int(0, "Canne");
	pInfo[extraid][Phone] = cache_get_field_int(0, "Telephone");
	pInfo[extraid][Credits] = cache_get_field_int(0, "Credits");
	pInfo[extraid][CarteIden] = cache_get_field_int(0, "Identite");
	pInfo[extraid][DrogueFab1] = cache_get_field_int(0, "GramDrogue1");
	pInfo[extraid][DrogueFab2] = cache_get_field_int(0, "GramDrogue2");
	pInfo[extraid][DrogueFab3] = cache_get_field_int(0, "GramDrogue3");
	pInfo[extraid][Cocaine] = cache_get_field_int(0, "Cocaine");
	pInfo[extraid][Heroine] = cache_get_field_int(0, "Heroine");
	pInfo[extraid][Ecstacy] = cache_get_field_int(0, "Ecstacy");
	pInfo[extraid][Mort] = cache_get_field_int(0, "Mort");
	pInfo[extraid][JailTime] = cache_get_field_int(0, "JailTemps");
	pInfo[extraid][Amende] = cache_get_field_int(0, "Amende");
	pInfo[extraid][Facture] = cache_get_field_int(0, "Facture");
	pInfo[extraid][Emprunt] = cache_get_field_int(0, "Emprunt");
	pInfo[extraid][Lotto] = cache_get_field_int(0, "Warn");
	pInfo[extraid][Baned] = cache_get_field_int(0, "Bannis");
	pInfo[extraid][Permis] = cache_get_field_int(0, "Permis");
	pInfo[extraid][PermisPoint] = cache_get_field_int(0, "PointPermis");
	pInfo[extraid][PortArme] = cache_get_field_int(0, "PortArme");
	pInfo[extraid][LastPos] = cache_get_field_int(0, "Situation");
	pInfo[extraid][Weapon1] = cache_get_field_int(0, "Arme1");
	pInfo[extraid][Wep1Ammo] = cache_get_field_int(0, "Wep1Ammo");
	pInfo[extraid][Weapon2] = cache_get_field_int(0, "Arme2");
	pInfo[extraid][Wep2Ammo] = cache_get_field_int(0, "Wep2Ammo");
	pInfo[extraid][Weapon3] = cache_get_field_int(0, "Arme3");
	pInfo[extraid][Wep3Ammo] = cache_get_field_int(0, "Wep3Ammo");
	pInfo[extraid][Weapon4] = cache_get_field_int(0, "Arme4");
	pInfo[extraid][Wep4Ammo] = cache_get_field_int(0, "Wep4Ammo");
	pInfo[extraid][Weapon5] = cache_get_field_int(0, "Arme5");
	pInfo[extraid][Wep5Ammo] = cache_get_field_int(0, "Wep5Ammo");
	pInfo[extraid][Weapon6] = cache_get_field_int(0, "Arme6");
	pInfo[extraid][Wep6Ammo] = cache_get_field_int(0, "Wep6Ammo");
	pInfo[extraid][Weapon7] = cache_get_field_int(0, "Arme7");
	pInfo[extraid][Wep7Ammo] = cache_get_field_int(0, "Wep7Ammo");
			
	if (pInfo[extraid][Admin] > 0)
	{
		SendClientMessage(extraid, -1, "Vous кtes connectй en tant qu'admuinistrateur.");
		//SendAdminAction(extraid, "You have logged in a level %d admin.", pInfo[extraid][pAdmin]);
	}
	pInfo[extraid][pLogged] = 1;
	SendClientMessage(extraid, -1, "Connexion rйussi veuillez informer le fondateur");
	SetTimerEx("SpawnTimer", 1000, false, "d", extraid); 
}
The problem is no load and i no have message "SendClientMessage(extraid, -1, "Connexion rйussi veuillez informer le fondateur");"
Find
Reply
Stinged
High-roller
*****
Posts: 1,578
Threads: 15
Joined: Feb 2013
Reputation: 0
#8

15.08.2016, 19:00
There's propably an error in your query.
Post the mysql log and the query.
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#9

15.08.2016, 19:47
There's nothing in the mysql log and no error in the compile pawn

Код HTML:
case THREAD_LOGIN:
   		{
    	    cache_get_data(rows, fields, g_iHandle);

    	    if (!rows)
    	    {
    	        pInfo[extraid][pLoginAttempts]++;

    	        if (pInfo[extraid][pLoginAttempts] >= 3)
    	        {
    	            SendClientMessage(extraid, -1, "tas ete kick");
    	            Kick(extraid);
				}
				else
				{
    	        	Dialog_Show(extraid, LoginScreen, DIALOG_STYLE_PASSWORD, "connexion", "mauvais pass !!!!", "connecter", "kitter", pInfo[extraid][pLoginDate]);
    	        	//SendServerMessage(extraid, -1, "Notice: Incorrect password specified (%d/3 attempts).", PlayerData[extraid][pLoginAttempts]);
				}
			}
			else
			{
				static
					query[128];

				// Update the last login date.
                format(query, sizeof(query), "UPDATE `accounts` SET `IP` = '%s', `LoginDate` = '%s' WHERE `Username` = '%s'", pInfo[extraid][pIP], ReturnDate(), pInfo[extraid][pUsername]);
				mysql_tquery(g_iHandle, query);
				//mysql_tquery(g_iHandle, query, "OnQueryFinished", "dd", extraid, THREAD_LOAD_CHARACTER);

    			// Load the character data.
    			
				format(query, sizeof(query), "SELECT * FROM `characters` WHERE `ID` = '%s' LIMIT 1", pInfo[extraid][pID]);
				mysql_tquery(g_iHandle, query, "OnQueryFinished", "dd", extraid, THREAD_LOAD_CHARACTER);
			}
		}
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#10

16.08.2016, 13:32
Pleases help me :/
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help