[TyX]

Hello! I have and I need help creating a table in PHPmyAdmin

Code:

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.netnl6620807decadd...0.42871740-- Host: localhost
-- Generation Time: Jul 19, 2012 at 10:26 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `rgaming_gol`
--

-- --------------------------------------------------------

--
-- Table structure for table `dealercars`
--

CREATE TABLE IF NOT EXISTS `dealercars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dealerid` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Name` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Model` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Price` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Active` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=141 ;

--
-- Dumping data for table `cars`
--

INSERT INTO `dealercars` (`id`,`dealerid`, `Name`, `Model`, `Price`,`active`)/ VALUES


-- --------------------------------------------------------

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

I wrote everything you need but it gives me this error

Code:

Eroare

Comanda SQL:

--
-- Dumping data for table `cars`
--
INSERT INTO `dealercars` ( `id` , `dealerid` , `Name` , `Model` , `Price` , `active` ) /
VALUES -- --------------------------------------------------------
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;

MySQL zice: Documentație
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/ VALUES

-- --------------------------------------------------------

/*!' at line 5

where I wrong?

[Niko_boy]

may be INSERT query is incomplete as no VALUES is there?

Code:

INSERT INTO `dealercars` ( `id` , `dealerid` , `Name` , `Model` , `Price` , `active` ) VALUES (1,1,'NameZ',411,11111,1);

[TyX]

so good?

Code:

-- phpMyAdmin SQL Dump
-- version 3.4.5
-- http://www.phpmyadmin.netnl6620807ded3e5...2.41067130-- Host: localhost
-- Generation Time: Jul 19, 2012 at 10:26 PM
-- Server version: 5.5.16
-- PHP Version: 5.3.8

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `rgaming_gol`
--

-- --------------------------------------------------------

--
-- Table structure for table `dealercars`
--

CREATE TABLE IF NOT EXISTS `dealercars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `dealerid` int(11) NOT NULL AUTO_INCREMENT,
  `Name` int(11) NOT NULL AUTO_INCREMENT,
  `Model` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Price` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Active` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=141 ;

--
-- Dumping data for table `cars`
--

INSERT INTO `dealercars` (`id`,`dealerid`, `Name`, `Model`, `Price`,`active`) VALUES  ('%d','%d', '%s', '%d', '%d', '1')



-- --------------------------------------------------------

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[Vince]

Where did you get this dump in the first place? And more importantly: what's its purpose? If there is no data to insert then leave out the insert queries.

[TyX]

purpose is to add cars through a command when you are on the server as admin

Code:

 if(strcmp(cmd, "/createcar", true) == 0)
	{
	    if(IsPlayerConnected(playerid))
	    {
	        if(PlayerData[playerid][pAdmin] < 6)
	    	{
	    	    SendError(playerid,cmd);
	    	    return 1;
			}
			new PlayerName[MAX_PLAYER_NAME];
	        GetPlayerName(playerid, PlayerName, sizeof(PlayerName));
	        if(EsteManager(playerid))//omg,
		    {
				if(CreatedCar != 0)//
				{
				    SendClientMessage(playerid, COLOR_GRAD1, "You can create a personal car before resart (reason /veh)");
				    return 1;
				}
				tmp = strtok(cmdtext, idx);
				if(!strlen(tmp))
				{
					SendUsage(playerid,"/createcar [model] [value]");
					return 1;
				}
				new model = strval(tmp);
				tmp = strtok(cmdtext, idx);
				if(!strlen(tmp))
				{
					SendUsage(playerid,"/createcar [model] [value]");
					return 1;
				}
				new value = strval(tmp);
				new Float:x1,Float:y1,Float:z1;
				GetPlayerPos(playerid,x1,y1,z1);
	   			if(model < 400 || model > 611)
	   			{
	   			    return 1;
	   			}
    			for(new i=1;i<=sizeof(CarData);i++)
				{
				    if(CarData[i][cModel] == 0)
				    {
                        CarData[i][cModel] = model;
				        CarData[i][cValue] = value;
				        CarData[i][cLocationx] = x1;
						CarData[i][cLocationy] = y1;
						CarData[i][cLocationz] = z1;
						CarData[i][cOwned] = 0;
				        AddStaticVehicle(model,x1,y1,z1,0,0,0);
      				    format(string, sizeof(string), "%s.",ArIsim[model-400]);
 				        strmid(CarData[i][cDescription], string, 0, strlen(string), 255);
                        new idd;
						mysql_query("SELECT * FROM `cars`");
						mysql_store_result();
						idd = mysql_num_rows()+1;
						mysql_free_result();
						format(string, sizeof(string),"INSERT INTO `cars` (`'id`, `Model`, `Locationx`, `Locationy`, `Locationz`, `Description`, `Value`, `Owned`)\
						VALUES ('%d', '%d', '%f', '%f', '%f', '%s', '%d', '%d'",  idd, CarData[i][cModel], CarData[i][cLocationx], CarData[i][cLocationy], CarData[i][cLocationz], CarData[i][cDescription], CarData[i][cValue], CarData[i][cOwned]);
						mysql_query(string);
						SendClientMessage(playerid,COLOR_WHITE,"The car was successfully created!");
						return 1;
				    }
                }
			}
		}
		return 1;
	}

This is the command that is in gamemode

[TyX]

enibody chen help me?

[TyX]

up chen help me?