[Avino]

Hello can anyone tell whether this error to me:

outside open the car

Here Error on mysql.log:

PHP код:

[16:31:56] [ERROR] CMySQLQuery::Execute[()] - (error #1064) 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 'CREATE TABLE IF NOT EXISTS `pRP_account_vehicle` (`id` int(11) NOT NULL AUTO_INC' at line 1 


and the script:

PHP код:

strcat(query,"CREATE TABLE IF NOT EXISTS `"#SERVERTAG"_account_vehicle` (`id` int(11) NOT NULL AUTO_INCREMENT,`Name` varchar(24) NOT NULL,`slot` int(2) NOT NULL,`modelid` int(4) NOT NULL,`x` float(10,3) NOT NULL,`y` float(10,3) NOT NULL,`z` float(10,3) NOT NULL,`a` float(10,3) NOT NULL,`interior` int(4) NOT NULL,`world` int(11) NOT NULL,`cc1` int(4) NOT NULL,`cc2` int(4) NOT NULL,`paintjob` int(2) NOT NULL DEFAULT '-1',`vehhp` float(10,3) NOT NULL,`abgeschlossen` int(2) NOT NULL,");
      strcat(query,"`t1` int(4) NOT NULL,`t2` int(4) NOT NULL,`t3` int(4) NOT NULL,`t4` int(4) NOT NULL,`t5` int(4) NOT NULL,`t6` int(4) NOT NULL,`t7` int(4) NOT NULL,`t8` int(4) NOT NULL,`t9` int(4) NOT NULL,`t10` int(4) NOT NULL,`t11` int(4) NOT NULL,`t12` int(4) NOT NULL,`t13` int(4) NOT NULL,`t14` int(4) NOT NULL,`Insurence` int(2) NOT NULL,`Schloss` int(2) NOT NULL,`Armourplating` int(2) NOT NULL,`Wirelesskey` int(2) NOT NULL,`TrackingDevice` int(2) NOT NULL,");
      strcat(query,"`angemeldet` int(2) NOT NULL,`preis` int(11) NOT NULL,`nummernschild` varchar(32) NOT NULL,`neon` int(2) NOT NULL,`motordown` int(2) NOT NULL,`failgas` int(2) NOT NULL,`tank` float(10,3) NOT NULL,`km` int(11) NOT NULL,`towed` int(2) NOT NULL,`towedfreeprice` int(11) NOT NULL,`towedreason` varchar(32) NOT NULL,`ticket` int(11) NOT NULL,`ticketfreeprice` int(11) NOT NULL,`ticketreason` varchar(32) NOT NULL,`kganja` int(11) NOT NULL,");
      strcat(query,"`kkokain` int(11) NOT NULL,`kopium` int(11) NOT NULL,`kmats` int(11) NOT NULL,`kwood` int(11) NOT NULL,`klunch` int(11) NOT NULL,`kc4` int(11) NOT NULL,`kwkanister` int(11) NOT NULL,`kkanister` int(11) NOT NULL,`key1` varchar(24) NOT NULL,`key2` varchar(24) NOT NULL,`key3` varchar(24) NOT NULL,`key4` varchar(24) NOT NULL,`key5` varchar(24) NOT NULL,`InGarage` int(4) NOT NULL,");
      strcat(query,"PRIMARY KEY (`id`))ENGINE=INNODB;"); 


the command for open my cars:

PHP код:

if(strcmp(cmd,"Privatveh",true) == 0)
    {
        new haveakey = GetPlayerKey(playerid);
        if(haveakey == -1)
        {
            if(GetPlayerVehicleCount(playerid) == 0)return SCM(playerid,GRAU,"[FEHLER]: Du besitzt kein eigenes Fahrzeug!");
        }
        if(haveakey != -1)
        {
            for(new slot=0;slot<MAX_PLAYER_VEHS;slot++)
            {
                if(IsValidVehicle(Pfahrzeug[slot][haveakey][Vehicle]))
                {
                    GetVehiclePos(Pfahrzeug[slot][haveakey][Vehicle],Pos[0],Pos[1],Pos[2]);
                    GetVehicleParamsEx(Pfahrzeug[slot][haveakey][Vehicle],engine,lights,alarm,doors,bonnet,boot,objective);
                    if(IsPlayerInRangeOfPoint(playerid,3.0,Pos[0],Pos[1],Pos[2]) || IsPlayerInVehicle(playerid,Pfahrzeug[slot][haveakey][Vehicle]))
                    {
                        format(string,sizeof(string),"~w~%s~n~%s",VehicleDefinations[Pfahrzeug[slot][haveakey][modelid]-400],(Pfahrzeug[slot][haveakey][Abgeschlossen] == 1?("~r~abgeschlossen"):("~g~aufgeschlossen")));
                        GTFP(playerid,string,2000,6);
                           SetVehicleParamsEx(Pfahrzeug[slot][haveakey][Vehicle],engine,lights,alarm,(Pfahrzeug[slot][haveakey][Abgeschlossen] == 1?VEHICLE_PARAMS_OFF:VEHICLE_PARAMS_ON),bonnet,boot,objective);
                        Pfahrzeug[slot][haveakey][Abgeschlossen] = (Pfahrzeug[slot][haveakey][Abgeschlossen] == 1?0:1);
                        if(!IsPlayerInVehicle(playerid,Pfahrzeug[slot][haveakey][Vehicle])) LockVehicle(Pfahrzeug[slot][haveakey][Vehicle]);
                        PlayerHearMusicInRange(Pos[0],Pos[1],Pos[2],1027,10,0,0);//x,y,z,soundid,radius,timer an = 1 wenn aus = 0,zeit wann timer music/sound beendet
                        return 1;
                    }
                }
            }
            return SCM(playerid,GRAU,"[FEHLER]: Du bist nicht in der Nдhe eines Fahrzeuges!");
        }
        for(new slot=0;slot<MAX_PLAYER_VEHS;slot++)
        {
            if(IsValidVehicle(Pfahrzeug[slot][playerid][Vehicle]))
            {
                   GetVehiclePos(Pfahrzeug[slot][playerid][Vehicle],Pos[0],Pos[1],Pos[2]);
                GetVehicleParamsEx(Pfahrzeug[slot][playerid][Vehicle],engine,lights,alarm,doors,bonnet,boot,objective);
                if(IsPlayerInRangeOfPoint(playerid,3.0,Pos[0],Pos[1],Pos[2]) || IsPlayerInVehicle(playerid,Pfahrzeug[slot][playerid][Vehicle]))
                {
                    format(string,sizeof(string),"~w~%s~n~%s",VehicleDefinations[Pfahrzeug[slot][playerid][modelid]-400],(Pfahrzeug[slot][playerid][Abgeschlossen] == 1?("~r~abgeschlossen"):("~g~aufgeschlossen")));
                    GTFP(playerid,string,2000,6);
                    SetVehicleParamsEx(Pfahrzeug[slot][playerid][Vehicle],engine,lights,alarm,(Pfahrzeug[slot][playerid][Abgeschlossen] == 1?VEHICLE_PARAMS_OFF:VEHICLE_PARAMS_ON),bonnet,boot,objective);
                    Pfahrzeug[slot][playerid][Abgeschlossen] = (Pfahrzeug[slot][playerid][Abgeschlossen] == 1?0:1);
                    if(!IsPlayerInVehicle(playerid,Pfahrzeug[slot][playerid][Vehicle])) LockVehicle(Pfahrzeug[slot][playerid][Vehicle]);
                    PlayerHearMusicInRange(Pos[0],Pos[1],Pos[2],1027,10,0,0);//x,y,z,soundid,radius,timer an = 1 wenn aus = 0,zeit wann timer music/sound beendet
                    return 1;
                }
            }
        }
        return SCM(playerid,GRAU,"[FEHLER]: Du bist nicht in der Nдhe eines Fahrzeuges!");
    } 


Can u see Error? Please help me und give me right syntax for mysql i use: MySQL plugin R34