[dasto_fantasto]

Evening,

I am making CAR system with Mysql i made that you can buy car and insert into MySQL information.
UNIQUE ID CARD ID and so on...
But how to know which car belongs to me? i confused becouse all cars ID's are the same.
For example buffalo ID 402 so if i buy buffalo ID will be 402 and if buffalo buy my friend ID will be same (402)
Can annyone help me to figure out how to make cars and players identification.
Like when i enter my bought car it would show message you have entered your bought car when my friend will enter car he will get message that he entered his car not when i enter message show to me and to my friend.


THANK YOU GOOD PEOPLE

[Infinity90]

Well, you will need to show us your code. We can not do anything without Code or Errors / Warnings.

[leonardo1434]

Just stock their cars into their personal file's, instead of make it as a global,therefore you'll just have to check in their own files if he is the real one, otherwise remove it from the car.

i have no idea how to do it in mysql, cause i had never tried before, but soon as possible when i learn feel tips i'll able to move on to next step.

[showarn]

Mysql Table

Код:

CREATE TABLE IF NOT EXISTS `cars` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Model` int(11) NOT NULL,
  `LocationX` float NOT NULL,
  `LocationY` float NOT NULL,
  `LocationZ` float NOT NULL,
  `Angle` float NOT NULL,
  `Color1` int(11) NOT NULL,
  `Color2` int(11) NOT NULL,
  `Owner` text NOT NULL,
  `Description` text NOT NULL,
  `Value` int(11) NOT NULL,
  `License` text NOT NULL,
  `Owned` int(11) NOT NULL,
  `Lock` int(11) NOT NULL,
  `Mod0` int(11) NOT NULL,
  `Mod1` int(11) NOT NULL,
  `Mod2` int(11) NOT NULL,
  `Mod3` int(11) NOT NULL,
  `Mod4` int(11) NOT NULL,
  `Mod5` int(11) NOT NULL,
  `Mod6` int(11) NOT NULL,
  `Mod7` int(11) NOT NULL,
  `Mod8` int(11) NOT NULL,
  `Mod9` int(11) NOT NULL,
  `Donate` int(11) NOT NULL,
  `Fuel` int(11) NOT NULL,
  `TrunkWeapon1` int(11) NOT NULL,
  `TrunkAmmo1` int(11) NOT NULL,
  `TrunkWeapon2` int(11) NOT NULL,
  `TrunkAmmo2` int(11) NOT NULL,
  `TrunkWeapon3` int(11) NOT NULL,
  `TrunkAmmo3` int(11) NOT NULL,
  `TrunkWeapon4` int(11) NOT NULL,
  `TrunkAmmo4` int(11) NOT NULL,
  `TrunkArmour` float NOT NULL,
  `TrunkCounter` int(11) NOT NULL,
  `Alarm` int(11) NOT NULL,
  `TrunkDrugs` int(11) NOT NULL,
  `TrunkMats` int(11) NOT NULL,
  `Impounded` int(11) NOT NULL,
  `ImpoundedPrice` int(11) NOT NULL,
  `Insurance` int(11) NOT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2023 ;

/*!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]

You need to link it to the player table. I'll take you have auto increment ids for your player's table as well. Store those ids in Pawn when loading and use it whenever you need to fetch some player related data from different tables.