MySQL Help
#1

In my .pwn i have code like this:


format(Query, sizeof(Query), "INSERT INTO `playerinfo` (`user`, `password`, `kills`, `deaths`, `score`, `money`, IP) VALUES ('%s', '%s', 0, 0, 0, 0, '%s')", escpname, escpass, PIP); //Insert string


but in .sql


Код:
CREATE TABLE IF NOT EXISTS `playeraccounts` (
  `playerName` varchar(24) NOT NULL,
  `playerPassword` varchar(129) NOT NULL,
  `playerAge` int(2) NOT NULL,
  `playerGender` int(1) NOT NULL,
  `playerOrigin` varchar(12) NOT NULL,
  `playerLevel` int(3) NOT NULL,
  `playerRespect` int(4) NOT NULL,
  `playerNRespect` int(4) NOT NULL,
  `playerSkin` int(3) NOT NULL,
  `playerGSkin` int(3) NOT NULL,
  `playerCash` int(8) NOT NULL,
  `playerBankCash` int(8) NOT NULL,
  `playerJob` int(2) NOT NULL,
  `playerHouse` int(3) NOT NULL,
  `playerRentHouse` int(3) NOT NULL,
  `playerBizz` int(3) NOT NULL,
  `playerCOBizz` int(3) NOT NULL,
  `playerCar` int(3) NOT NULL,
  `playerBike` int(3) NOT NULL,
  `playerBicycle` int(3) NOT NULL,
  `playerAdmin` int(4) NOT NULL,
  `playerLeader` int(2) NOT NULL,
  `playerMember` int(2) NOT NULL,
  `playerRank` int(1) NOT NULL,
  `playerGamedude` int(1) NOT NULL,
  `playerDonator` int(5) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
I need to change playerinfo to playeraccounts and other? Right?
Reply


Messages In This Thread
MySQL Help - by undeR. - 12.06.2011, 00:08
Re: MySQL Help - by swieberdevos - 12.06.2011, 00:15
Re: MySQL Help - by undeR. - 12.06.2011, 00:20
Re: MySQL Help - by Cyanide - 12.06.2011, 00:43
Re: MySQL Help - by undeR. - 12.06.2011, 00:44
Re: MySQL Help - by Forever Alone - 12.06.2011, 02:27
Re: MySQL Help - by Scenario - 12.06.2011, 03:24

Forum Jump:


Users browsing this thread: 1 Guest(s)