Dobrica

stock mysql_loading()
{
	new MySQLOpt: option_id = mysql_init_options();
	mysql_set_option(option_id, AUTO_RECONNECT, true);

	conectionBase = mysql_connect(MYSQL_HOSTNAME, MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE, option_id);
	if(conectionBase == MYSQL_INVALID_HANDLE || mysql_errno(conectionBase) != 0)
	{
		printf(" (Database) Fatal Error: Could not connect to MySQL >>> (Host: %s - DB: %s - User: %s).", MYSQL_HOSTNAME, MYSQL_DATABASE, MYSQL_USERNAME);
		print(" (Database) Note: Make sure that you have provided the correct connection credentials.");
		printf(" (Database) Error number: %d", mysql_errno(conectionBase));
		SendRconCommand("exit");
	}
	else
 	{
		print(" (Database) Connection successful toward MySQL Database Server!");
        printf(" (Database) Connected to MySQL >>> (Host: %s - DB: %s - User: %s).", MYSQL_HOSTNAME, MYSQL_DATABASE, MYSQL_USERNAME);
        print(" (Database) Users table has been loaded!");

  		new string;
		string = "CREATE TABLE ifNOT EXISTS `users`(\
		`id` INT, \
		`name` VARCHAR(24), \
		`ip` VARCHAR(18), \
		`longip` INT, \
		`password` VARCHAR(64), \
		`salt` VARCHAR(64), \
		`sec_question` VARCHAR("#MAX_SECURITY_QUESTION_SIZE"), \
		`posx` FLOAT(24) NOT NULL DEFAULT '1633.2408', \
		`posz` FLOAT(24) NOT NULL DEFAULT '-2326.1482', \
		`posy` FLOAT(24) NOT NULL DEFAULT '13.5469', \
		`sec_answer` VARCHAR(64), ";
		strcat(string, "`register_timestamp` INT, \
		`lastlogin_timestamp` INT, \
		`kills` INT, \
		`deaths` INT, \
		`score` INT, \
		`money` INT, \
		`adminlevel` INT, \
		`viplevel` INT, \
		`afk` INT, \
		PRIMARY KEY(`id`))");
		mysql_tquery(conectionBase, string);

		mysql_tquery(conectionBase, "CREATE TABLE ifNOT EXISTS `temp_blocked_users` (\
		`ip` VARCHAR(18), \
		`lock_timestamp` INT, \
		`user_id` INT)");
		mysql_tquery(conectionBase, string);
 	}
}

[17:18:45] [plugins/mysql] error #1064 while executing query "CREATE TABLE ifNOT EXISTS `users`(`id` INT, `name` VARCHAR(24), `ip` VARCHAR(18), `longip` INT, `password` VARCHAR(64), `salt` VARCHAR(64), `sec_question` VARCHAR(128), `posx` FLOAT(24) NOT NULL DEFAULT '1633.2408', `posz` FLOAT(24) NOT NULL DEFAULT '-2326.1482', `posy` FLOAT(24) NOT NULL DEFAULT '13.5469', `sec_answer` VARCHAR(64), `register_timestamp` INT, `lastlogin_timestamp` INT, `kills` INT, `deaths` INT, `score` INT, `money` INT, `adminlevel` INT, `viplevel` INT, `afk` INT, PRIMARY KEY(`id`))": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXISTS `users`(`id` INT, `name` VARCHAR(24), `ip` VARCHAR(18), `longip` INT, `pa' at line 1
[17:18:45] [plugins/mysql] error #1064 while executing query "CREATE TABLE ifNOT EXISTS `temp_blocked_users` (`ip` VARCHAR(18), `lock_timestamp` INT, `user_id` INT)": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXISTS `temp_blocked_users` (`ip` VARCHAR(18), `lock_timestamp` INT, `user_id` I' at line 1
[17:18:45] [plugins/mysql] error #1064 while executing query "CREATE TABLE ifNOT EXISTS `users`(`id` INT, `name` VARCHAR(24), `ip` VARCHAR(18), `longip` INT, `password` VARCHAR(64), `salt` VARCHAR(64), `sec_question` VARCHAR(128), `posx` FLOAT(24) NOT NULL DEFAULT '1633.2408', `posz` FLOAT(24) NOT NULL DEFAULT '-2326.1482', `posy` FLOAT(24) NOT NULL DEFAULT '13.5469', `sec_answer` VARCHAR(64), `register_timestamp` INT, `lastlogin_timestamp` INT, `kills` INT, `deaths` INT, `score` INT, `money` INT, `adminlevel` INT, `viplevel` INT, `afk` INT, PRIMARY KEY(`id`))": You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'EXISTS `users`(`id` INT, `name` VARCHAR(24), `ip` VARCHAR(18), `longip` INT, `pa' at line 1

public OnPlayerModelSelection(playerid, response, listid, modelid)
{
    if(listid == vozilolist)
	{
	    if(response)
	    {
    	    new Float:Pos;
	        GetPlayerPos(playerid,Pos,Pos,Pos);
		    SCM(playerid,-1,""SPLAVA" "ZUTA"Stvorio si Admin vozilo!");
            AdminVozilo = CreateVehicle(modelid,Pos,Pos,Pos,Pos,random(5),random(5),500);
            SetVehicleVirtualWorld(AdminVozilo, 0);
			PutPlayerInVehicle(playerid,AdminVozilo,0);
            Attach3DTextLabelToVehicle(avozila, AdminVozilo, 0.0, 0.0, 0.0);
            Update3DTextLabelText(avozila, 126267562, "[A/GM]");

	    }
	    else  if(!response)
{
SCM(playerid,-1,""CRVENA" "ZUTA"Odustao si od spawna A/GM Vozila!");
}
    	
	}
	return 1;
}

if(House_Info != 0)
{
    daje mu novac, resetuje mu varijablu..
    
    House_Info -= kolikojeorobao;
    idrobanekuce == -1;
}
else if(House_Info == 0)
{
    SendClientMessage(playerid,-1,"Kasa ove kuce je prazna, probaj drugu!");
    idrobanekuce == -1;
}