PDA       
        -
   
!
 
 :     
  
 

>  , ,
AntohA  
 ۩  [x]






*


:
: 25
: 30016
: 5 , 9 , 9
:




. , . . .

<?php include './include/header.inc.php';
#
mysql_query('SET NAMES utf8');
mysql_query('SET CHARACTER SET utf8');
mysql_query('SET COLLATION_CONNECTION="utf8_general_ci"');
$errors = array();
$StatusID = isset($_POST['idstatus']) ? $_POST['idstatus'] : NULL;
$message_adm = isset($_POST['message_adm']) ? $_POST['message_adm'] : NULL;
if (isset($_GET['id'])) {$id=$_GET['id'];}
$sql = "SELECT * FROM `trouble`";
$result = mysql_query("SELECT * FROM `trouble`
LEFT JOIN `otdels` ON `otdels`.`id_otdels` = `trouble`.`idotdel`
LEFT JOIN `status` ON `status`.`id_status` = `trouble`.`idstatus`
LEFT JOIN `types` ON `types`.`id_type` = `trouble`.`idtype`
LEFT JOIN `trouble_message` ON `trouble_message`.`id_trouble` = `trouble`.`id` WHERE id='
$id'",$db);




if(isset($_POST['submit'])){
if (isset($_GET['id'])) {$ID1=$_GET['id'];}


$CheckStatus = mysql_query("SELECT COUNT(*) AS `count`
FROM `status`
WHERE `id_status` = "
.(int)$StatusID) or die(mysql_error());
if(mysql_num_rows($CheckStatus) == 0){
$errors[] = ' !';
echo' ! &nbsp&nbsp';
}else
$update = mysql_query("UPDATE trouble SET `idstatus` = '".(int)$StatusID."'
WHERE `id` ='"
.$ID1."'") or die (mysql_error());
}
ob_start();
$services = mysql_query("SELECT * FROM `status` ") or die(mysql_error());
while($Array = mysql_fetch_assoc($services)){
echo '<option value="'.$Array['id_status'].'">'.$Array['status'].'</option>';
}
$Statuslist = ob_get_contents();
ob_end_clean();
$Array = mysql_fetch_assoc($result);
?>
<div id="wh" align="justify" >
<!--
-->

<
center>
</
a>
<
h3> :</a></h3>
<
center><form method="POST">
<
table>
<
br/></br>
<
center><h3> :<?php echo $_GET['id'];?></h3>
<
table>
<
tr>
<
td class="trouble1" id="trb1"></td>
<
td class="trouble1" id="trb2"></td>
<
td id="trb1"></td>
<
td class="trouble1" id="trb2"></td>
<
td class="trouble1" id="trb2"></td>
</
tr>
<
tr>
<
td class="trouble2"><?php echo $Array['fio'];?></td>
<
td class="trouble2"> <?php echo $Array['type'];?></td>
<
td></td>
<
td class="trouble2"><?php echo $Array['phone'];?></td>
<
td class="trouble2"><select name="idtype">
<?php echo $Statuslist;?></select></td>
</
tr>
<
tr>
</
br><td><input name="submit" type="submit" class="button" value=""></td>
</
tr>
<
tr>
<
td></td><td></td><td><h3> :</h3></td>
</
tr>
</
form>
</
table>
<
br></br>
<?php
$result = mysql_query("SELECT `date_message`,`message` FROM `trouble`
LEFT JOIN `trouble_message` ON `trouble_message`.`id_trouble` = `trouble`.`id`
WHERE id='
$id'",$db);
if (mysql_num_rows ($result) != 0)
$myrow = mysql_fetch_array ($result);
do
{
printf ("<tr><td><h9> %s</h9></td></tr></br><tr><td><h8> %s</h8></td></tr>",
$myrow["date_message"],$myrow["message"]);
}
while ($myrow = mysql_fetch_array ($result));

$result3 = mysql_query("SELECT * FROM `trouble_message_adm`
LEFT JOIN `trouble_message` ON `trouble_message`.`id_message` = `trouble_message_adm`.`idmessage`"
,$db);
if (mysql_num_rows ($result3) != 0)
$myrow = mysql_fetch_array ($result3);
do
{
printf ("<tr><td><h9> %s</h9></td></tr></br><tr><td><h8> %s</h8></td></tr>",
$myrow["date_message"],$myrow["message_adm"]);
}
while ($myrow = mysql_fetch_array ($result3));

?>
<div></br></br>
<
center><form method="POST"></br></br></br></br>
<
table>
<
tr>
<
td valign="top"><h4>:</h4></td>
<
td><textarea name="message_adm" cols="70" rows="6" ><?php echo $message_adm;?></textarea></td>
</
tr><td></td>
<
td></br>
<
input name="submit3" type="submit" class="button" value="">
<
input class="button" type="reset" value="">
</
td>
</
form>
</
table></div></div>
<?php
if(isset($_POST['submit3'])){
if (isset($_GET['id'])) {$ID=$_GET['id'];}
$result4 = mysql_query("SELECT * FROM `trouble_message` WHERE id_message = (SELECT MAX(id_message) FROM `trouble_message` )",$db);
$MesID=LAST_INSERT_ID();
$INSERT = mysql_query("INSERT INTO `trouble_message_adm` SET
`idmessage` = 'id_message',
`message_adm` = '"
.mysql_real_escape_string($message_adm)."',
`ip` = '"
.$_SERVER['REMOTE_ADDR']."'")or die(mysql_error());
?> </div><script>window.location = 'view-trouble.php?id=<?=$ID?>'</script><?exit;
}
include './include/footer.inc.php'; ?>

-- phpMyAdmin SQL Dump
-- version 3.4.3
-- http://www.phpmyadmin.net
--
-- : mysql-srv25931.ht-systems.ru
-- : 08 2012 ., 15:50
-- : 5.1.56
-- PHP: 5.2.17

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

--

--

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

--
-- `news`
--

CREATE TABLE IF NOT EXISTS `news` (
`id` int(5) unsigned NOT NULL AUTO_INCREMENT,
`article` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`s_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`b_text` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- `news`
--

INSERT INTO `news` (`id`, `article`, `s_text`, `b_text`, `date`) VALUES
(1, '?????? ?????????? ???????????? ??? DrWeb', '?????? ?????????? ???????????? ??? ? ????? http://download.drweb.com\r\n\r\n??????? ???????? ?? ??????? ??????? ??????????? ??????\r\n??? ?????????? ??? ? ????? http://download.drweb.com/bases/,\r\n?.?. ?? ftp://ftp.drweb.ru ?????????? ?????? :(\r\n??? ?????? ?????????????? ??? ???? ?????\r\n', '?????? ?????????? ???????????? ??? ? ????? http://download.drweb.com\r\n\r\n??????? ???????? ?? ??????? ??????? ??????????? ??????\r\n??? ?????????? ??? ? ????? http://download.drweb.com/bases/,\r\n?.?. ?? ftp://ftp.drweb.ru ?????????? ?????? :(\r\n??? ?????? ?????????????? ??? ???? ?????\r\n\r\n\r\n#!/bin/sh\r\n#\r\n# Copyright 2005 AXiZ [unix#li.ru]. All rights reserved.\r\n# License: GNU GPL.\r\n#\r\n# ?????? ??? ?????????? ?????????? ? ????? http://download.drweb.com\r\n\r\n# ??????????, ???? ????? ???????????? ??????????\r\n# cd /var/ftp/updates/drwzip\r\ncd /home/test\r\n\r\n# ??? ??????? ???? ??? ?????????? ??? ? ?????\r\nlynx --dump http://download.drweb.com/bases/ | grep http://download.drweb.com/files/bases/drw |
\\\r\n awk -F " " ''{print $2}'' > /tmp/drweburl;\r\n\r\n# ?????? :)\r\nwget --timestamping -nv -t 2 -i /tmp/drweburl\r\n\r\n# ?????? ?? ???? ??????????, ????? ??????????? ??? ???-?? ??? ??????? :-)\r\n# ? ???? ? ????? ??????? ?????????? ?????????? ? ????????????? ??? ?? ????? ???????????\r\n\r\n\r\n', '2011-08-24 07:31:54'),
(2, '?????? ?????????? ???????????? ??? DrWeb', '?????? ?????????? ???????????? ??? ? ????? http://download.drweb.com\r\n\r\n??????? ???????? ?? ??????? ??????? ??????????? ??????\r\n??? ?????????? ??? ? ????? http://download.drweb.com/bases/,\r\n?.?. ?? ftp://ftp.drweb.ru ?????????? ?????? :(\r\n??? ?????? ?????????????? ??? ???? ?????\r\n', '?????? ?????????? ???????????? ??? ? ????? http://download.drweb.com\r\n\r\n??????? ???????? ?? ??????? ??????? ??????????? ??????\r\n??? ?????????? ??? ? ????? http://download.drweb.com/bases/,\r\n?.?. ?? ftp://ftp.drweb.ru ?????????? ?????? :(\r\n??? ?????? ?????????????? ??? ???? ?????\r\n\r\n\r\n#!/bin/sh\r\n#\r\n# Copyright 2005 AXiZ [unix#li.ru]. All rights reserved.\r\n# License: GNU GPL.\r\n#\r\n# ?????? ??? ?????????? ?????????? ? ????? http://download.drweb.com\r\n\r\n# ??????????, ???? ????? ???????????? ??????????\r\n# cd /var/ftp/updates/drwzip\r\ncd /home/test\r\n\r\n# ??? ??????? ???? ??? ?????????? ??? ? ?????\r\nlynx --dump http://download.drweb.com/bases/ | grep http://download.drweb.com/files/bases/drw |
\\\r\n awk -F " " ''{print $2}'' > /tmp/drweburl;\r\n\r\n# ?????? :)\r\nwget --timestamping -nv -t 2 -i /tmp/drweburl\r\n\r\n# ?????? ?? ???? ??????????, ????? ??????????? ??? ???-?? ??? ??????? :-)\r\n# ? ???? ? ????? ??????? ?????????? ?????????? ? ????????????? ??? ?? ????? ???????????\r\n\r\n\r\n', '2011-08-24 07:31:54'),
(3, ' DrWeb', ' http://download.drweb.com\r\n\r\n \r\n http://download.drweb.com/bases/,\r\n.. ftp://ftp.drweb.ru :(\r\n \r\n', '\r\n#!/bin/sh\r\n#\r\n# Copyright 2005 AXiZ [unix#li.ru]. All rights reserved.\r\n# License: GNU GPL.\r\n#\r\n# http://download.drweb.com\r\n\r\n# , \r\n# cd /var/ftp/updates/drwzip\r\ncd /home/test\r\n\r\n# \r\nlynx --dump http://download.drweb.com/bases/ | grep http://download.drweb.com/files/bases/drw |
\\\r\n awk -F " " ''{print $2}'' > /tmp/drweburl;\r\n\r\n# :)\r\nwget --timestamping -nv -t 2 -i /tmp/drweburl\r\n\r\n# , - :-)\r\n# \r\n', '2011-08-24 07:34:35'),
(4, 'DDDDDDDDDDD', 'sdsd !!!!', 'sdsd !!!!sdsd !!!!sdsd !!!!sdsd !!!!sdsd !!!!sdsd !!!!sdsd !!!!sdsd !!!!sdsd !!!!', '2011-08-26 06:40:24'),
(5, 'terye', 'rygfhygfhdgfdh', 'gfdhdfhgddf', '2011-08-26 06:47:05'),
(6, 'ghsdfjgklsdfljkgsdfklgjs', '\r\nADOBE® FLASH® CS4 PROFESSIONAL\r\n˜сполŒзование Flash\r\nŸшименение Adobe Flash CS4 Professional pdf (15 mb)\r\n˜сполŒзование Adobe Media Encoder CS4 pdf (1.5 mb)\r\n\r\nActionScript 3.0 и компоненты\r\nŸшогшаммишование на Adobe ActionScript 3.0 pdf (10 mb)\r\n˜сполŒзование компонентов Adobe ActionScript 3.0 pdf (3.2 mb)\r\nСпшавочник по языкƒ ActionScript 3.0 и компонентам локалŒно zip (8.5 mb) chm (7.4 mb/rar)\r\n\r\nСпшавка по Flash Player 11 (6,4 mb)(EN)\r\n\r\n\r\nAdobe AIR\r\nРƒководства по началƒ шаботы с Adobe AIR 1.1 для Adobe Flash CS4 Professional\r\nРазшаботка пшиложений Adobe AIR 1.1 с помощŒŽ Adobe Flash CS4 Professional pdf (4.8 mb)\r\nРазшаботка пшиложений Adobe AIR 1.5 с помощŒŽ Adobe Flash CS4 Professional PDF (5,3 mb)\r\n\r\nFlex\r\nСпшавочник по языкƒ Adobe® Flex® 4 ActionScript® 3.0 (RU)\r\n˜сполŒзование ADOBE® FLASH® BUILDER 4 (RU PDF)\r\n\r\nШпашгалка для желаŽщих шƒсифицишоватŒ хелп.', '\r\nADOBE® FLASH® CS4 PROFESSIONAL\r\n˜сполŒзование Flash\r\nŸшименение Adobe Flash CS4 Professional pdf (15 mb)\r\n˜сполŒзование Adobe Media Encoder CS4 pdf (1.5 mb)\r\n\r\nActionScript 3.0 и компоненты\r\nŸшогшаммишование на Adobe ActionScript 3.0 pdf (10 mb)\r\n˜сполŒзование компонентов Adobe ActionScript 3.0 pdf (3.2 mb)\r\nСпшавочник по языкƒ ActionScript 3.0 и компонентам локалŒно zip (8.5 mb) chm (7.4 mb/rar)\r\n\r\nСпшавка по Flash Player 11 (6,4 mb)(EN)\r\n\r\n\r\nAdobe AIR\r\nРƒководства по началƒ шаботы с Adobe AIR 1.1 для Adobe Flash CS4 Professional\r\nРазшаботка пшиложений Adobe AIR 1.1 с помощŒŽ Adobe Flash CS4 Professional pdf (4.8 mb)\r\nРазшаботка пшиложений Adobe AIR 1.5 с помощŒŽ Adobe Flash CS4 Professional PDF (5,3 mb)\r\n\r\nFlex\r\nСпшавочник по языкƒ Adobe® Flex® 4 ActionScript® 3.0 (RU)\r\n˜сполŒзование ADOBE® FLASH® BUILDER 4 (RU PDF)\r\n\r\nШпашгалка для желаŽщих шƒсифицишоватŒ хелп.\r\nADOBE® FLASH® CS4 PROFESSIONAL\r\n˜сполŒзование Flash\r\nŸшименение Adobe Flash CS4 Professional pdf (15 mb)\r\n˜сполŒзование Adobe Media Encoder CS4 pdf (1.5 mb)\r\n\r\nActionScript 3.0 и компоненты\r\nŸшогшаммишование на Adobe ActionScript 3.0 pdf (10 mb)\r\n˜сполŒзование компонентов Adobe ActionScript 3.0 pdf (3.2 mb)\r\nСпшавочник по языкƒ ActionScript 3.0 и компонентам локалŒно zip (8.5 mb) chm (7.4 mb/rar)\r\n\r\nСпшавка по Flash Player 11 (6,4 mb)(EN)\r\n\r\n\r\nAdobe AIR\r\nРƒководства по началƒ шаботы с Adobe AIR 1.1 для Adobe Flash CS4 Professional\r\nРазшаботка пшиложений Adobe AIR 1.1 с помощŒŽ Adobe Flash CS4 Professional pdf (4.8 mb)\r\nРазшаботка пшиложений Adobe AIR 1.5 с помощŒŽ Adobe Flash CS4 Professional PDF (5,3 mb)\r\n\r\nFlex\r\nСпшавочник по языкƒ Adobe® Flex® 4 ActionScript® 3.0 (RU)\r\n˜сполŒзование ADOBE® FLASH® BUILDER 4 (RU PDF)\r\n\r\nШпашгалка для желаŽщих шƒсифицишоватŒ хелп.\r\nADOBE® FLASH® CS4 PROFESSIONAL\r\n˜сполŒзование Flash\r\nŸшименение Adobe Flash CS4 Professional pdf (15 mb)\r\n˜сполŒзование Adobe Media Encoder CS4 pdf (1.5 mb)\r\n\r\nActionScript 3.0 и компоненты\r\nŸшогшаммишование на Adobe ActionScript 3.0 pdf (10 mb)\r\n˜сполŒзование компонентов Adobe ActionScript 3.0 pdf (3.2 mb)\r\nСпшавочник по языкƒ ActionScript 3.0 и компонентам локалŒно zip (8.5 mb) chm (7.4 mb/rar)\r\n\r\nСпшавка по Flash Player 11 (6,4 mb)(EN)\r\n\r\n\r\nAdobe AIR\r\nРƒководства по началƒ шаботы с Adobe AIR 1.1 для Adobe Flash CS4 Professional\r\nРазшаботка пшиложений Adobe AIR 1.1 с помощŒŽ Adobe Flash CS4 Professional pdf (4.8 mb)\r\nРазшаботка пшиложений Adobe AIR 1.5 с помощŒŽ Adobe Flash CS4 Professional PDF (5,3 mb)\r\n\r\nFlex\r\nСпшавочник по языкƒ Adobe® Flex® 4 ActionScript® 3.0 (RU)\r\n˜сполŒзование ADOBE® FLASH® BUILDER 4 (RU PDF)\r\n\r\nШпашгалка для желаŽщих шƒсифицишоватŒ хелп.\r\nADOBE® FLASH® CS4 PROFESSIONAL\r\n˜сполŒзование Flash\r\nŸшименение Adobe Flash CS4 Professional pdf (15 mb)\r\n˜сполŒзование Adobe Media Encoder CS4 pdf (1.5 mb)\r\n\r\nActionScript 3.0 и компоненты\r\nŸшогшаммишование на Adobe ActionScript 3.0 pdf (10 mb)\r\n˜сполŒзование компонентов Adobe ActionScript 3.0 pdf (3.2 mb)\r\nСпшавочник по языкƒ ActionScript 3.0 и компонентам локалŒно zip (8.5 mb) chm (7.4 mb/rar)\r\n\r\nСпшавка по Flash Player 11 (6,4 mb)(EN)\r\n\r\n\r\nAdobe AIR\r\nРƒководства по началƒ шаботы с Adobe AIR 1.1 для Adobe Flash CS4 Professional\r\nРазшаботка пшиложений Adobe AIR 1.1 с помощŒŽ Adobe Flash CS4 Professional pdf (4.8 mb)\r\nРазшаботка пшиложений Adobe AIR 1.5 с помощŒŽ Adobe Flash CS4 Professional PDF (5,3 mb)\r\n\r\nFlex\r\nСпшавочник по языкƒ Adobe® Flex® 4 ActionScript® 3.0 (RU)\r\n˜сполŒзование ADOBE® FLASH® BUILDER 4 (RU PDF)\r\n\r\nШпашгалка для желаŽщих шƒсифицишоватŒ хелп.', '2011-08-26 06:47:23'),
(7, 'Тест', 'тест', 'аывпавып', '2011-09-26 08:05:49'),
(8, 'gfhdfghgfh', 'gfhgfhgf', 'hgfhg', '2011-09-26 08:12:54');

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

--
-- `otdels`
--

CREATE TABLE IF NOT EXISTS `otdels` (
`id_otdels` int(11) NOT NULL AUTO_INCREMENT,
`otdels` varchar(300) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_otdels`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- `otdels`
--

INSERT INTO `otdels` (`id_otdels`, `otdels`) VALUES
(1, 'OAO'),
(2, 'MTO');

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

--
-- `rights`
--

CREATE TABLE IF NOT EXISTS `rights` (
`rights_id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`rights` varchar(100) NOT NULL,
PRIMARY KEY (`rights_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

--
-- `rights`
--

INSERT INTO `rights` (`rights_id`, `rights`) VALUES
(1, ''),
(2, ''),
(3, '');

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

--
-- `status`
--

CREATE TABLE IF NOT EXISTS `status` (
`id_status` int(5) NOT NULL AUTO_INCREMENT,
`status` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id_status`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- `status`
--

INSERT INTO `status` (`id_status`, `status`) VALUES
(1, ''),
(2, ' '),
(3, ' Ը');

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

--
-- `trouble`
--

CREATE TABLE IF NOT EXISTS `trouble` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`idotdel` int(11) unsigned NOT NULL DEFAULT '0',
`fio` text NOT NULL,
`phone` varchar(18) CHARACTER SET latin1 NOT NULL,
`idtype` int(11) unsigned NOT NULL DEFAULT '0',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`idstatus` int(11) unsigned NOT NULL DEFAULT '1',
`ip` text NOT NULL,
`idpass` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;

--
-- `trouble`
--

INSERT INTO `trouble` (`id`, `idotdel`, `fio`, `phone`, `idtype`, `date`, `idstatus`, `ip`, `idpass`) VALUES
(1, 1, ' ', '957-08-05', 1, '2011-12-04 11:03:03', 0, '192.168.1.97', 0),
(2, 1, ' ', '957-09-57', 1, '2011-12-04 11:19:12', 0, '192.168.1.97', 0),
(4, 1, ' ', '957-08-05', 1, '2011-12-04 12:19:31', 0, '192.168.1.97', 0),
(5, 1, ' ', '957-08-05', 1, '2011-12-05 02:53:26', 0, '192.168.1.97', 0),
(6, 1, ' ', '957-08-05', 1, '2011-12-05 03:14:45', 0, '192.168.1.97', 0),
(7, 1, ' ', '957-08-05', 1, '2011-12-05 03:34:36', 1, '192.168.1.97', 0),
(8, 1, ' ', '957-08-05', 1, '2011-12-05 04:23:34', 0, '192.168.1.97', 0);

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

--
-- `trouble_message`
--

CREATE TABLE IF NOT EXISTS `trouble_message` (
`id_message` int(11) NOT NULL AUTO_INCREMENT,
`id_trouble` int(11) NOT NULL,
`message` text CHARACTER SET utf8 NOT NULL,
`ip` varchar(19) CHARACTER SET utf8 NOT NULL,
`date_message` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_message`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- `trouble_message`
--

INSERT INTO `trouble_message` (`id_message`, `id_trouble`, `message`, `ip`, `date_message`) VALUES
(1, 1, '985', '192.168.1.97', '2011-12-04 11:03:03'),
(2, 2, '985', '192.168.1.97', '2011-12-04 11:19:12'),
(3, 3, 'bhgfjhgbn', '192.168.1.97', '2011-12-04 11:40:02'),
(4, 4, 'hcgfvnb ', '192.168.1.97', '2011-12-04 12:19:31'),
(5, 5, '95756dfsg', '192.168.1.97', '2011-12-05 02:53:26'),
(6, 5, 'vb', '192.168.1.97', '2011-12-05 02:57:39'),
(7, 6, 'fgcv', '192.168.1.97', '2011-12-05 03:14:45'),
(8, 7, 'jhgjh', '192.168.1.97', '2011-12-05 03:34:36'),
(9, 7, 'hj', '192.168.1.97', '2011-12-05 03:34:41'),
(10, 7, 'hjk', '192.168.1.97', '2011-12-05 03:34:43'),
(11, 8, '', '192.168.1.97', '2011-12-05 04:23:34'),
(12, 1, 'папрап', '178.140.218.178', '2012-04-07 12:48:22'),
(13, 1, 'оррпо', '178.140.218.178', '2012-04-07 12:48:24'),
(14, 1, 'орлрпол', '178.140.218.178', '2012-04-07 12:48:26'),
(15, 8, 'ап', '178.140.218.178', '2012-04-07 19:21:05');

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

--
-- `trouble_message_adm`
--

CREATE TABLE IF NOT EXISTS `trouble_message_adm` (
`id_message_adm` int(11) NOT NULL AUTO_INCREMENT,
`idmessage` int(11) NOT NULL,
`message_adm` text CHARACTER SET utf8 NOT NULL,
`ip` varchar(19) CHARACTER SET utf8 NOT NULL,
`date_message` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id_message_adm`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=33 ;

--
-- `trouble_message_adm`
--

INSERT INTO `trouble_message_adm` (`id_message_adm`, `idmessage`, `message_adm`, `ip`, `date_message`) VALUES
(32, 0, '', '178.140.218.178', '2012-04-08 08:09:25');

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

--
-- `types`
--

CREATE TABLE IF NOT EXISTS `types` (
`id_type` int(11) unsigned NOT NULL AUTO_INCREMENT,
`type` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
`isactive` tinyint(1) unsigned NOT NULL DEFAULT '1',
PRIMARY KEY (`id_type`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- `types`
--

INSERT INTO `types` (`id_type`, `type`, `isactive`) VALUES
(1, 'Computers', 1),
(2, 'Phone', 1),
(3, 'Monitor', 1);

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

--
-- `users`
--

CREATE TABLE IF NOT EXISTS `users` (
`user_id` int(11) NOT NULL AUTO_INCREMENT,
`login` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
`name` varchar(150) CHARACTER SET utf8 NOT NULL,
`patronymic` varchar(150) CHARACTER SET utf8 NOT NULL,
`surname` varchar(150) CHARACTER SET utf8 NOT NULL,
`password` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
`idrights` int(11) DEFAULT NULL,
`otdel_id` int(11) DEFAULT NULL,
`phone` varchar(20) NOT NULL,
`date` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`hash` varchar(32) CHARACTER SET utf8 DEFAULT NULL,
`activate` int(1) DEFAULT NULL,
`user_ip` text CHARACTER SET utf8 NOT NULL,
PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=46 ;

--
-- `users`
--

INSERT INTO `users` (`user_id`, `login`, `name`, `patronymic`, `surname`, `password`, `idrights`, `otdel_id`, `phone`, `date`, `hash`, `activate`, `user_ip`) VALUES
(45, 'admin2', '', '', '', 'ec6a6536ca304edf844d1d248a4f08dc', 2, NULL, '657457645', '2012-04-07 16:30:52', 'f46068d65c36ec296d39bfa012c8f01c', NULL, '2995575474'),
(44, 'admin', '', '', '', 'c3284d0f94606de1fd2af172aba15bf3', 1, NULL, '957-08-05', '2012-04-07 13:40:11', '6f4b1ade78264e3a75f704f4d5dd13a1', NULL, '2995575474');

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





6 , 4 (8.04.2012 - 15:00) I++ ():
php , .

, ... dry.gif

20 , 33 (8.04.2012 - 15:20) AntohA ():
??

49 , 27 (8.04.2012 - 16:10) AntohA ():
id id , ?

1 , 34 , 31 (8.04.2012 - 17:44) Dagot ():
) id .

"" ""

( )

)

10 , 8 (8.04.2012 - 17:54) AntohA ():

11 , 40 (8.04.2012 - 18:06) Dagot ():
?
, .


AntohA - 8.04.2012 - 16:21
PM  e-mail
    0         1-2
1 (1 0 )
0 :
« | PHP + SQL | »