Amil_Pawno

//

22:16:19  	Error: MySQL shutdown unexpectedly.
22:16:19  	This may be due to a blocked port, missing dependencies, 
22:16:19  	improper privileges, a crash, or a shutdown by another method.
22:16:19  	Press the Logs button to view error logs and check
22:16:19  	the Windows Event Viewer for more clues
22:16:19  	If you need more help, copy and post this
22:16:19  	entire log window on the forums

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	switch(dialogid)
	{
	    case d_login:
	    {
	        if(!response) return Kick(playerid);
	      
	        new buf, name;
	        SHA256_PassHash(inputtext, PlayerInfo, buf, 65);
	      
	        if(strcmp(buf, PlayerInfo) == 0)
	        {
				GetPlayerName(playerid, name, sizeof(name));
	            mysql_format(handle, query, sizeof(query), "SELECT * FROM players WHERE name = `%e` LIMIT 1", name);
	            mysql_tquery(handle, query, "OnAccountLoad", "i", playerid);
			}
			else
			{
			    ShowPlayerDialog(playerid, d_login, DIALOG_STYLE_PASSWORD, "Prijava", "Lozinka koju ste uneli nije ispravna, pokusajte ponovo:", "Dalje", "Izlaz");
			}
		}
		case d_register:
		{
		    if(!response) return Kick(playerid);
		  
		    if(strlen(inputtext) < 6 || strlen(inputtext) > 20) // ako je lozinka kraca od 6 i duza od 20 karaktera vraca dialog
		    {
		        ShowPlayerDialog(playerid, d_register, DIALOG_STYLE_INPUT, "Registracija", "Vas racun nije pronadjen, molimo vas upisite lozinku da se registrujete:", "Dalje", "Izlaz");
		        return true;
			}

			 for (new i = 0; i < 10; i++) {
			    PlayerInfo = random(100) + 50;
			 }
			
			 PlayerInfo = 0;
			 SHA256_PassHash(inputtext, PlayerInfo, PlayerInfo, 65);

			 // sada unosimo u bazu podatke igraca
			 new query, name;
			 GetPlayerName(playerid, name, sizeof(name));
			
			 mysql_format(handle, query, sizeof(query), "INSERT INTO players SET \
			                                                name=`%e`,\
			                                                password=`%e`,\
			                                                salt=`%e`,\
			                                                regdate=NOW()", name, PlayerInfo, PlayerInfo);
			                                              
            mysql_tquery(handle, query, "OnPlayerRegister", "d", playerid);
		}
	}
	return true;
}

C:\Users\namik\Desktop\MySQL Tokyo\gamemodes\tokyo-rp.pwn(248) : error 017: undefined symbol "query"
C:\Users\namik\Desktop\MySQL Tokyo\gamemodes\tokyo-rp.pwn(248) : error 017: undefined symbol "query"
C:\Users\namik\Desktop\MySQL Tokyo\gamemodes\tokyo-rp.pwn(248) : error 029: invalid expression, assumed zero
C:\Users\namik\Desktop\MySQL Tokyo\gamemodes\tokyo-rp.pwn(248) : fatal error 107: too many error messages on one line

CMD:postaviadmina(playerid, params[])
{
	if(!IsPlayerAdmin(playerid)) return SendClientMessage(playerid, -1, ""CRVENA"Niste RCON Admin");
	new id, level;
	if(sscanf(params, "ud", id, level)) return SendClientMessage(playerid, -1, ""CRVENA"Upotreba "BIJELA"| /postaviadmina ");
	if(level > 7) return SendClientMessage(playerid, -1, ""CRVENA"Admin level nemoze biti veci od 7");
	if(level == 0)
	{
		PlayerInfo = 0;
		PlayerInfo = 1;
		SetPlayerSkin(id, 1);
		SavePlayer(id);
		SendClientMessage(id, -1, ""CRVENA"T:RP ADMIN "BIJELA"| Skinut ti je Admin!");
	}
	else
	{
		PlayerInfo = level;
		PlayerInfo = 295;
		SetPlayerSkin(id, 295);
		SavePlayer(id);
		va_SendClientMessage(id, -1, ""CRVENA"T:RP ADMIN "BIJELA"| Posatao si admin level %d", level);
	}
	return 1;
}

[Pawn.CMD] HandleCommand: AMX error occurred in pc_cmd_postaviadmina: Invalid instruction

#define Posao_Nema      	0
#define Posao_BusVozac      1
#define Posao_Postar      	2

forward TDUpdate(playerid);
public TDUpdate(playerid)
{
	//BANKA
	new bankastring;
	format(bankastring, sizeof(bankastring), "%d$", PlayerInfo);
	TextDrawSetString(IGTD, bankastring);

#define Posao_Nema      	0
#define Posao_BusVozac      1
#define Posao_Postar      	2

forward TDUpdate(playerid);
public TDUpdate(playerid)
{
	//BANKA
	new bankastring;
	format(bankastring, sizeof(bankastring), "%d$", PlayerInfo);
	TextDrawSetString(IGTD, bankastring);