-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Хост: localhost
-- Время создания: Июл 02 2011 г., 20:05
-- Версия сервера: 5.5.8
-- Версия PHP: 5.3.5

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

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

--
-- База данных: `sampbase`
--

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

--
-- Структура таблицы `vehicles`
--

CREATE TABLE IF NOT EXISTS `vehicles` (
    `id` int(15) NOT NULL AUTO_INCREMENT,
    `model` int(11) NOT NULL,
    `color1` int(11) NOT NULL DEFAULT '1',
    `color2` int(11) NOT NULL DEFAULT '1',
    `x` float NOT NULL,
    `y` float NOT NULL,
    `z` float NOT NULL,
    `r` float NOT NULL,
    `number` int(11) NOT NULL,
    `lock` int(11) NOT NULL DEFAULT '0',
    `insurance` int(11) NOT NULL DEFAULT '0',
    `fuel` int(11) NOT NULL DEFAULT '100',
    `life` int(11) NOT NULL DEFAULT '1000',
    `signaling` int(11) NOT NULL DEFAULT '0',
    `owner` varchar(255) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- Дамп данных таблицы `vehicles`
--

INSERT INTO `vehicles` (`id`, `model`, `color1`, `color2`, `x`, `y`, `z`, `r`, `number`, `lock`, `insurance`, `fuel`, `life`, `signaling`, `owner`) VALUES
(1, 411, 1, 1, -2094.06, -55.2239, 35.0244, 358.245, 0, 0, 0, 100, 1000, 0, '0'),
(2, 444, 1, 1, -2094.05, -38.0988, 35.0001, 1.0772, 0, 0, 0, 100, 1000, 0, '0'),
(3, 455, 1, 1, -2094.52, -13.7371, 35.0474, 1.2653, 0, 0, 0, 100, 1000, 0, '0');

public LoadVehicles()
{
   mysql_query("SELECT NULL FROM `vehicles`");
   mysql_store_result();
   new rows = mysql_num_rows();
   mysql_free_result();

   for (new id=0; id<=rows; id++)
   {

       new query[128];
       new Data[1024];
       new buffer[64];
       format(query, sizeof(query), "SELECT * FROM `vehicles` LIMIT %d,1",id);
       mysql_query(query);
       mysql_store_result();
       mysql_fetch_row(Data);

       mysql_get_field("id", buffer);
       transport[id][vsid] = strval(buffer);
    //by FiLE 402149086          www.samp-rus.com
    mysql_get_field("model", buffer);
       transport[id][vsmodel] = strval(buffer);

    mysql_get_field("color1", buffer);
       transport[id][vscolor1] = strval(buffer);

    mysql_get_field("color2", buffer);
       transport[id][vscolor2] = strval(buffer);

    mysql_get_field("x", buffer);
       transport[id][vsx] = strval(buffer);

    mysql_get_field("y", buffer);
       transport[id][vsy] = strval(buffer);

    mysql_get_field("z", buffer);
       transport[id][vsz] = strval(buffer);

    mysql_get_field("r", buffer);
       transport[id][vsr] = strval(buffer);

    mysql_get_field("number", buffer);
       transport[id][vsnumber] = strval(buffer);

    mysql_get_field("lock", buffer);
       transport[id][vslock] = strval(buffer);

    mysql_get_field("insurance", buffer);
       transport[id][vsinsurance] = strval(buffer);

    mysql_get_field("fuel", buffer);
       transport[id][vsfuel] = strval(buffer);

    mysql_get_field("life", buffer);
       transport[id][vslife] = strval(buffer);

    mysql_get_field("signaling", buffer);
       transport[id][vssignaling] = strval(buffer);

    mysql_get_field("owner", buffer);
       transport[id][vsowner] = strval(buffer);

          AddStaticVehicleEx(transport[id][vsmodel],transport[id][vsx],transport[id][vsy],transport[id][vsz],transport[id][vsr],transport[id][vscolor1],transport[id][vscolor2], 600000);
    printf("%d",transport[id][vsmodel]);
   }//by FiLE 402149086          www.samp-rus.com
   mysql_free_result();
      return 1;
}

enum tInfo
{
   vsid,
   vsmodel,
   vscolor1,
   vscolor2,
   vsx,
   vsy,
   vsz,
   vsr,
   vsnumber,
   vslock,
   vsinsurance,
   vsfuel,
   v slife,
   vssignaling,
   vsowner,
};
new transport[3][tInfo];
forward LoadVehicles();