Problema mysql

[MariaN47]

Salut am facut un sitem de login si m-a cam lovit erorile astea: 

Folosesc ultima versiune de MYSQL

C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1017) : error 017: undefined symbol "cache_get_value_name_int"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1018) : error 017: undefined symbol "cache_get_value_name_int"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1020) : error 017: undefined symbol "cache_get_value_name"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1021) : error 017: undefined symbol "cache_get_value_name"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1022) : error 017: undefined symbol "cache_get_value_name"
Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase

lini
 		1017	PlayerInfo[playerid][pSQLID] = cache_get_value_name_int(0, "ID");
		1018	PlayerInfo[playerid][pGender] = cache_get_value_name_int(0, "Gender");
	
		1020	cache_get_value_name(0, "Name", result); format(PlayerInfo[playerid][pName], MAX_PLAYER_NAME , result);
		1021	cache_get_value_name(0, "Password", result); format(PlayerInfo[playerid][pPassword], 32 , result);
		1022	cache_get_value_name(0, "pEmail", result); format(PlayerInfo[playerid][pEmail], 32 , result);

 

Edited June 16, 2020 by MariaN47

[KB.HERO]

55 minutes ago, MariaN47 said:

Salut am facut un sitem de login si m-a cam lovit erorile astea: 

Folosesc ultima versiune de MYSQL

C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1017) : error 017: undefined symbol "cache_get_value_name_int"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1018) : error 017: undefined symbol "cache_get_value_name_int"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1020) : error 017: undefined symbol "cache_get_value_name"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1021) : error 017: undefined symbol "cache_get_value_name"
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(1022) : error 017: undefined symbol "cache_get_value_name"
Pawn compiler 3.2.3664              Copyright (c) 1997-2006, ITB CompuPhase

lini
 		1017	PlayerInfo[playerid][pSQLID] = cache_get_value_name_int(0, "ID");
		1018	PlayerInfo[playerid][pGender] = cache_get_value_name_int(0, "Gender");
	
		1020	cache_get_value_name(0, "Name", result); format(PlayerInfo[playerid][pName], MAX_PLAYER_NAME , result);
		1021	cache_get_value_name(0, "Password", result); format(PlayerInfo[playerid][pPassword], 32 , result);
		1022	cache_get_value_name(0, "pEmail", result); format(PlayerInfo[playerid][pEmail], 32 , result);

 

Ai inlocuit in pawno/include/a_mysql cu cel nou ?

Edited June 16, 2020 by KB.HERO

[MariaN47]

@KB.HERO l-am pus cum trebuie dar acum am multe warning-uri...

C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(143) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(320) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(321) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(609) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(610) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(628) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(629) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(651) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(652) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(660) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(661) : warning 213: tag mismatch
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(682) : warning 202: number of arguments does not match definition
C:\Users\buloi\OneDrive\Desktop\Gamemode 0\gamemodes\RPG-LS.RO.pwn(683) : warning 202: number of arguments does not match definition
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase



mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `Name`-'%s' LIMIT1", GetName(playerid)); // 320
mysql_tquery(SQL, gQuery, "checkAccount", "i", playerid); // 321

mysql_format(SQL, gQuery, sizeof(gQuery), "INSERT INTO `users` (`Name`, `Password`) VALUES ('%s', '%s' )", GetName(playerid), inputtext);	//609
mysql_tquery(SQL, gQuery, "insertAccount", "i", playerid); // 610

mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `users` SET `Email`-'%s' WHERE `ID`-'%d'", inputtext, PlayerInfo[playerid][pSQLID]);	 // 628
mysql_tquery(SQL, gQuery, "", "", playerid); // 629

mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE `users` SET `Gender`-'%s' WHERE `ID`-'%d'", PlayerInfo[playerid][pGender], PlayerInfo[playerid][pSQLID]); // 651

mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `Name`-'%s' LIMIT1", GetName(playerid)); //660
mysql_tquery(SQL, gQuery, "onLogin", "i", playerid); //661

PlayerInfo[playerid][pSQLID] = cache_get_value_name_int(0, "ID");   //682
PlayerInfo[playerid][pGender] = cache_get_value_name_int(0, "Gender"); //683
mysql_tquery(SQL, gQuery, "", "", playerid); // 652

 

[MariaN47]

Am rezolvat erorile in GM dar acum am in consola...

 

   Error: Function not registered: 'cache_get_row_count'
   Error: Function not registered: 'mysql_connect'
   Error: Function not registered: 'mysql_format'
   Error: Function not registered: 'mysql_tquery'
   Error: Function not registered: 'cache_get_value_name_int'
   Error: Function not registered: 'cache_get_value_name'
   Error: Function not registered: 'cache_insert_id'

 

[BaFFyJunior]

Ai pus pluginul de la mysql r41 in fisierul server.cfg la linia plugins? Pentru localhost foloseste extensia .dll, pentru host .so.

[MariaN47]

@BaFFyJunior aveam pus mysql.dll in plugins in server.cfg

Edited June 17, 2020 by MariaN47

[BaFFyJunior]

Nu am inteles raspunsul... ai rezolvat problema sau inca exista?

[MariaN47]

@BaFFyJunior tot am acele erori in consola