Согласен с Армусом,но шмотки там вобще не все,вот тебе решил помочь,здесь весь магаз со всеми шмотками:
<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'>CREATE TABLE `shop` (
`otdel` int(2) NOT NULL default '0',
`name` varchar(255) NOT NULL default '',
`kol` int(11) NOT NULL default '0',
`city` int(11) NOT NULL default '1',
KEY `otdel` (`otdel`),
KEY `name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `shop` VALUES ('1', 'knife1', '999', '1');
INSERT INTO `shop` VALUES ('1', 'knife2', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife3', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife4', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife5', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife6', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife7', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife8', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife9', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife10', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife11', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife12', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_2', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_3', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_4', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_5', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_6', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_7', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_8', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife_9', '1000', '1');
INSERT INTO `shop` VALUES ('1', 'knife5_1', '999', '1');
INSERT INTO `shop` VALUES ('2', 'sword1', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword2', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword3', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword4', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword5', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword6', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword7', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword8', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword9', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_1', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_2', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_3', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_4', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_5', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_6', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_7', '1000', '1');
INSERT INTO `shop` VALUES ('2', 'sword_8', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe1', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe3', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe4', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe5', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe6', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe7', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe8', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe9', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe10', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe11', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe12', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_1', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_2', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_3', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_4', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_5', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_6', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_7', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_8', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_9', '1000', '1');
INSERT INTO `shop` VALUES ('3', 'axe_10', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_1', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_2', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_3', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_4', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_5', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_6', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_7', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_8', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_9', '1000', '1');
INSERT INTO `shop` VALUES ('4', 'dubina_10', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor1', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor2', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor3', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor4', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor5', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor6', '1000', '1');
INSERT INTO `shop` VALUES ('8', 'armor7', '1000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_1', '1000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_2', '1000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_3', '1000', '1');
INSERT INTO `shop` VALUES ('14', 'ring7', '1000', '1');
INSERT INTO `shop` VALUES ('14', 'ring6', '1000', '1');
INSERT INTO `shop` VALUES ('14', 'ring5', '1000', '1');
INSERT INTO `shop` VALUES ('14', 'ring4', '1000', '1');
INSERT INTO `shop` VALUES ('14', 'ring10', '1000', '1');
INSERT INTO `shop` VALUES ('14', 'ring14', '1000', '1');
INSERT INTO `shop` VALUES ('13', 'amulet28', '1000', '1');
INSERT INTO `shop` VALUES ('13', 'amulet1', '1000', '1');
INSERT INTO `shop` VALUES ('12', 'boots1', '1000', '1');
INSERT INTO `shop` VALUES ('12', 'boot1', '1000', '1');
INSERT INTO `shop` VALUES ('15', 'bracer16', '1000', '1');
INSERT INTO `shop` VALUES ('15', 'bracer15', '982', '1');
INSERT INTO `shop` VALUES ('15', 'bracer14', '999', '1');
INSERT INTO `shop` VALUES ('15', 'bracer13', '1000', '1');
INSERT INTO `shop` VALUES ('15', 'bracer12', '998', '1');
INSERT INTO `shop` VALUES ('15', 'bracer11', '1000', '1');
INSERT INTO `shop` VALUES ('15', 'bracer10', '997', '1');
INSERT INTO `shop` VALUES ('15', 'bracer9', '998', '1');
INSERT INTO `shop` VALUES ('15', 'bracer8', '998', '1');
INSERT INTO `shop` VALUES ('15', 'bracer7', '998', '1');
INSERT INTO `shop` VALUES ('15', 'bracer6', '1000', '1');
INSERT INTO `shop` VALUES ('15', 'bracer5', '1000', '1');
INSERT INTO `shop` VALUES ('15', 'bracer4', '999', '1');
INSERT INTO `shop` VALUES ('15', 'bracer2', '985', '1');
INSERT INTO `shop` VALUES ('15', 'bracer1', '993', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_1', '999', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_2', '988', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_3', '998', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_4', '997', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi4', '997', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_5', '999', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_6', '999', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_7', '998', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_8', '1000', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_9', '1000', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_10', '1000', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_12', '993', '1');
INSERT INTO `shop` VALUES ('16', 'naruchi_11', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet1', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet2', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet3', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet4', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet5', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet6', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet7', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet8', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet9', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet10', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet11', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_1', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_2', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_3', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_4', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_5', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_6', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_7', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_8', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_9', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_10', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_11', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_12', '1000', '1');
INSERT INTO `shop` VALUES ('6', 'helmet_13', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_1', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_2', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_3', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_4', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_5', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_6', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_7', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shield_8', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shit1', '1000', '1');
INSERT INTO `shop` VALUES ('10', 'shit2', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addhp100', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addhp200', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addhp300', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addhp400', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'healing1', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'reset', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'attack', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'blood_atack', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'blood_attack', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'mol15', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'unset', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'unset10', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'water10', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'water20', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addenergy10', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addenergy30', '1000', '1');
INSERT INTO `shop` VALUES ('18', 'addenergy60', '1000', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila2_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila2_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila2_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila2_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila4_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila4_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila4_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila4_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila6_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila6_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila6_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila6_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost2_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost2_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost2_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost2_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost4_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost4_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost4_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost4_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost6_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost6_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost6_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_lovkost6_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta2_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta2_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta2_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta2_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta4_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta4_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta4_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta4_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta6_1chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta6_2chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta6_4chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_inta6_6chas', '999', '1');
INSERT INTO `shop` VALUES ('19', 'elik_sila10_24chas', '999', '1');
INSERT INTO `shop` VALUES ('20', 'kirka', '998', '1');
INSERT INTO `shop` VALUES ('20', 'kuznec', '1000', '1');
INSERT INTO `shop` VALUES ('20', 'ogran', '1000', '1');
INSERT INTO `shop` VALUES ('21', 'bilet', '1000', '1');
INSERT INTO `shop` VALUES ('21', 'bilet_evial', '1000', '1');
INSERT INTO `shop` VALUES ('43', 'aamulet1', '992', '1');
INSERT INTO `shop` VALUES ('43', 'aamulet2', '983', '1');
INSERT INTO `shop` VALUES ('36', 'aarmor2', '997', '1');
INSERT INTO `shop` VALUES ('32', 'aaxe1', '991', '1');
INSERT INTO `shop` VALUES ('42', 'aboots1', '998', '1');
INSERT INTO `shop` VALUES ('34', 'ahelmet1', '998', '1');
INSERT INTO `shop` VALUES ('39', 'anaruchi1', '988', '1');
INSERT INTO `shop` VALUES ('44', 'aring1', '976', '1');
INSERT INTO `shop` VALUES ('40', 'ashield1', '993', '1');
INSERT INTO `shop` VALUES ('31', 'asword1', '985', '1');
INSERT INTO `shop` VALUES ('34', 'ahelmet2', '982', '1');
INSERT INTO `shop` VALUES ('44', 'forcering', '929', '1');
INSERT INTO `shop` VALUES ('38', '77777', '979', '1');
INSERT INTO `shop` VALUES ('32', '777777', '972', '1');
INSERT INTO `shop` VALUES ('36', '7777777', '978', '1');
INSERT INTO `shop` VALUES ('42', 'aboot1', '982', '1');
INSERT INTO `shop` VALUES ('18', 'invisible', '998', '1');
INSERT INTO `shop` VALUES ('40', '7777777777', '983', '1');
INSERT INTO `shop` VALUES ('39', '77777777777', '977', '1');
INSERT INTO `shop` VALUES ('37', 'braslet777', '85', '1');
INSERT INTO `shop` VALUES ('51', 'flowers1', '998', '1');
INSERT INTO `shop` VALUES ('46', 'addhp500[mf]', '95', '0');
INSERT INTO `shop` VALUES ('44', 'goldring', '996', '1');
INSERT INTO `shop` VALUES ('41', '13513', '994', '1');
INSERT INTO `shop` VALUES ('86', 'attack', '0', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_elf', '998', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_ork', '1000', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_people', '1000', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_gnom', '1000', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_elf2', '1000', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_ork2', '1000', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_people2', '1000', '1');
INSERT INTO `shop` VALUES ('62', 'amulet_gnom2', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_gnom', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_people', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_elf', '999', '1');
INSERT INTO `shop` VALUES ('60', 'shield_ork', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_gnom2', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_elf2', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_ork2', '1000', '1');
INSERT INTO `shop` VALUES ('60', 'shield_people2', '1000', '1');
INSERT INTO `shop` VALUES ('50', 'knife_elf', '998', '1');
INSERT INTO `shop` VALUES ('50', 'knife_elf2', '999', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_people2', '1000', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_ork2', '1000', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_elf2', '999', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_gnom2', '1000', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_people', '1000', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_gnom', '1000', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_elf', '999', '1');
INSERT INTO `shop` VALUES ('59', 'naruchi_ork', '1000', '1');
INSERT INTO `shop` VALUES ('52', 'axe_ork2', '1000', '1');
INSERT INTO `shop` VALUES ('52', 'axe_ork', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_gnom', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_people', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_elf', '999', '1');
INSERT INTO `shop` VALUES ('61', 'belt_ork', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_gnom2', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_elf2', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_people2', '1000', '1');
INSERT INTO `shop` VALUES ('61', 'belt_ork2', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_people', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_ork', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_elf', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_gnom', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_people2', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_ork2', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_gnom2', '1000', '1');
INSERT INTO `shop` VALUES ('54', 'helmet_elf2', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr1', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr2', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr3', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr4', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr5', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr6', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr7', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr8', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr9', '1000', '1');
INSERT INTO `shop` VALUES ('100', 'otkr10', '1000', '1');
INSERT INTO `shop` VALUES ('101', 'flowers1', '498', '1');
INSERT INTO `shop` VALUES ('101', 'flowers2', '500', '1');
INSERT INTO `shop` VALUES ('101', 'flowers3', '500', '1');
INSERT INTO `shop` VALUES ('101', 'flowers4', '497', '1');
INSERT INTO `shop` VALUES ('101', 'flowers5', '472', '1');
INSERT INTO `shop` VALUES ('101', 'byket1', '999', '1');
INSERT INTO `shop` VALUES ('101', 'byket2', '1000', '1');
INSERT INTO `shop` VALUES ('101', 'byket3', '1000', '1');
INSERT INTO `shop` VALUES ('101', 'byket4', '1000', '1');
INSERT INTO `shop` VALUES ('101', 'byket5', '1000', '1');
INSERT INTO `shop` VALUES ('101', 'byket6', '1000', '1');
INSERT INTO `shop` VALUES ('101', 'byket7', '1000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_7', '100000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_6', '10000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_5', '100000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_4', '1000000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_8', '100000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_9', '100000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_10', '1000000', '1');
INSERT INTO `shop` VALUES ('11', 'belt_11', '1000000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_1', '100000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_2', '10000000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_3', '100000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_4', '100000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_5', '1000000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_6', '100000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_7', '100000000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_8', '100000000', '1');
INSERT INTO `shop` VALUES ('12', 'boots_9', '100000', '1');
</div>
А вот и код самого файла shop.php:
<div class='codetop'>CODE</div><div class='codemain' style='height:200px;white-space:pre;overflow:auto'><?
if (!is_numeric($otdel)&&isset($otdel))
die ('Попытка взлома, ничего не выйдет!!');
require_once("inc/module.php");
if ($stat['bloked']) echo"<script>top.location='index.php?action=logout'</script>";
if ($stat['t_time']) { header("Location: prison.php"); exit; }
elseif ($stat['k_time']) { header("Location: academy.php"); exit; }
elseif ($stat['battle']) { header("Location: battle.php"); exit; }
elseif ($stat['room'] != 7) { header("Location: main.php"); exit; }
else {
if (!isset($otdel)) $otdel=1;
if (!empty($buy))
include("inc/shop/buy.php");
if (!empty($sale))
include("inc/shop/sale_fnc.php");
$title = 'Магазин';
include("inc/shop/otdels.php");
echo"<link rel=stylesheet type='text/css' href='i/shop_new.css'>
<body bgcolor='#F5FFDA'>
<table border='0' width='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='100%' align='center'>
<table border='0' width='95%' height='28' cellspacing='0' cellpadding='0'>
<tr>
<td align='center'>
<table border='0' height='28' cellspacing='0' cellpadding='0'>
<tr>
<td width='83' height='4'><img src='i/inman_t11.gif' width='83' height='4' alt=''></td>
<td height='4' background='i/inman_t12.gif'></td>
<td width='80' height='4'><img src='i/inman_t13.gif' width='80' height='4' alt=''></td>
</tr>
<tr>
<td width='83'>
<img src='i/inman_t20.gif' width='83' height='20' alt=''></td>
<td background='i/inman_t21.gif' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
<td width='80'><img src='i/inman_t22.gif' width='80' height='20' alt=''></td>
</tr>
<tr>
<td width='83' height='4'><img src='i/inman_t29.gif' width='83' height='4' alt=''></td>
<td height='4' background='i/inman_t30.gif'></td>
<td width='80' height='4'><img src='i/inman_t31.gif' width='80' height='4' alt=''></td>
</tr>
</table>
</td>
<td width='100%' align='center'>
<table border='0' height='28' cellspacing='0' cellpadding='0' width='100%'>
<tr>
<td height='4' background='i/inman_t14.gif' width='100%'></td>
</tr>
<tr>
<td background='i/inman_t23.gif' width='100%' align='center'>
<font face='Verdana'>
Магазин</font>
</td>
</tr>
<tr>
<td height='4' background='i/inman_t32.gif' width='100%'></td>
</tr>
</table>
</td>
<td align='center'>
<table border='0' height='28' cellspacing='0' cellpadding='0'>
<tr>
<td width='80' height='4'><img src='i/inman_t15.gif' width='80' height='4' alt=''></td>
<td height='4' background='i/inman_t16.gif'></td>
<td width='81' height='4'><img src='i/inman_t15_1.gif' width='81' height='4' alt=''></td>
<td width='80' height='4'><img src='i/inman_t15.gif' width='80' height='4' alt=''></td>
<td height='4' background='i/inman_t16.gif'></td>
<td width='81' height='4'><img src='i/inman_t17.gif' width='81' height='4' alt=''></td>
</tr>
<tr>
<td width='80'><img src='i/inman_t24.gif' width='80' height='20' alt=''></td>
<td background='i/inman_t25.gif' align='center'><a href='shop.php?otdel=".$otdel."'><img src='i/shop/link_refresh.gif'></a></td>
<td width='81'><img src='i/inman_t26_1.gif' width='81' height='20' alt=''></td>
<td width='80'><img src='i/inman_t24.gif' width='80' height='20' alt=''></td>
<td background='i/inman_t25.gif' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
<td width='81'><img src='i/inman_t26.gif' width='81' height='20' alt=''></td>
</tr>
<tr>
<td width='80' height='4'><img src='i/inman_t33.gif' width='80' height='4' alt=''></td>
<td height='4' background='i/inman_t34.gif'></td>
<td width='81' height='4'><img src='i/inman_t35.gif' width='81' height='4' alt=''></td>
<td width='80' height='4'><img src='i/inman_t33.gif' width='80' height='4' alt=''></td>
<td height='4' background='i/inman_t34.gif'></td>
<td width='81' height='4'><img src='i/inman_t35.gif' width='81' height='4' alt=''></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width='100%' align='center'>
<table border='0' width='100%' height='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='22' height='100%'>
<table border='0' width='22' height='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='22' height='25'>
<img src='i/inman_b11.gif' width='22' height='25' alt=''></td>
</tr>
<tr>
<td width='22' height='69'><img src='i/inman_b12.gif' width='22' height='69' alt=''></td>
</tr>
<tr>
<td width='22' height='100%' background='i/inman_b13.gif'></td>
</tr>
<tr>
<td width='22' height='69'><img src='i/inman_b14.gif' width='22' height='69' alt=''></td>
</tr>
<tr>
<td width='22' height='25'><img src='i/inman_b15.gif' width='22' height='25' alt=''></td>
</tr>
</table>
</td>
<td height='100%'>
<table border='0' width='100%' height='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='100%' height='25'>
<table border='0' width='100%' height='25' cellspacing='0' cellpadding='0'>
<tr>
<td width='51' height='25'>
<img src='i/inman_b211.gif' width='51' height='25' alt=''></td>
<td background='i/inman_b212.gif' valign='middle'>
<table border='0' height='22' cellspacing='0' cellpadding='0'>
<tr>
<td width='10' height='22'></td>
<td width='43' height='22'><img border='0' src='i/inman_rb01.gif' width='43' height='22'></td>
<td background='i/inman_rb02.gif' height='22' valign='middle'>
<font color='#FFFFFF' face='Verdana' size='2'>У вас на счету:
".$stat['credits']." зм.</font></td>
<td width='43' height='22'><img border='0' src='i/inman_rb03.gif' width='43' height='22'></td>
</tr>
</table>
</td>
<td width='51' height='25'>
<img src='i/inman_b213.gif' width='51' height='25' alt=''></td>
</tr>
</table>
</td>
</tr>
<tr>
<td width='100%' height='100%' background='i/inman_fon.gif'>
<table border='0' width='100%' height='100%' cellspacing='0' cellpadding='0' style='padding: 5'>
<tr>
<td width='80%' height='100%' align='center' valign='top'>";
if (!empty($msg)) echo"<center><FONT COLOR=RED>
$msg</font></center>
";
if ($otdel == 100) include('inc/shop/sale.php');
else include('inc/shop/_otdels_.php');
echo"
</td>
<td width='20%' height='100%' valign='top'>
<table border='1' background='i/inman_fon2.gif' cellpadding='0' cellspacing='0' style='border-collapse: collapse; border-style: solid; padding: 2' bordercolor='#D8C792' width='98%'>
<tr>
<td width='100%' colspan='2' align='center'>
Оружие:</td>
</tr>
<tr>
<td width='50%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
<tr>
<td width='50%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
</table>
<table border='1' background='i/inman_fon2.gif' cellpadding='0' cellspacing='0' style='border-collapse: collapse; border-style: solid; padding: 2' bordercolor='#D8C792' width='98%'>
<tr>
<td width='100%' colspan='2' align='center'>
Амуниция:</td>
</tr>
<tr>
<td width='50%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
<tr>
<td width='50%' align='center'><a href='?otdel=8'>Тяжёлая броня</a></td>
<td width='50%' align='center'><a href='?otdel=15'>Браслеты</a></td>
</tr>
<tr>
<td width='50%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
<tr>
<td width='50%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
</table>
<table border='1' background='i/inman_fon2.gif' cellpadding='0' cellspacing='0' style='border-collapse: collapse; border-style: solid; padding: 2' bordercolor='#D8C792' width='98%'>
<tr>
<td width='100%' colspan='2' align='center'>
Ювелирные украшения:</td>
</tr>
<tr>
<td width='33%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
</table>
<table border='1' background='i/inman_fon2.gif' cellpadding='0' cellspacing='0' style='border-collapse: collapse; border-style: solid; padding: 2' bordercolor='#D8C792' width='98%'>
<tr>
<td width='100%' colspan='2' align='center'>
Магия:</td>
</tr>
<tr>
<td width='33%' align='center'>
Вам необходимо зарегистрироваться для просмотра ссылок
</td>
</tr>
</table>
<table border='1' background='i/inman_fon2.gif' cellpadding='0' cellspacing='0' style='border-collapse: collapse; border-style: solid; padding: 2' bordercolor='#D8C792' width='98%'>
<tr>
<td width='100%' colspan='2' align='center'>Работа:</td>
</tr>
<tr>
<td width='100%' align='center' colspan='2'><a href='?otdel=20'>Инструменты</a></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width='100%' height='25'>
<table border='0' width='100%' height='25' cellspacing='0' cellpadding='0'>
<tr>
<td width='51' height='25'>
<img src='i/inman_b231.gif' width='51' height='25' alt=''></td>
<td background='i/inman_b232.gif'></td>
<td width='51' height='25'>
<img src='i/inman_b233.gif' width='51' height='25' alt=''></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
<td width='22' height='100%'>
<table border='0' width='22' height='100%' cellspacing='0' cellpadding='0'>
<tr>
<td width='22' height='25'>
<img src='i/inman_b21.gif' width='22' height='25' alt=''></td>
</tr>
<tr>
<td width='22' height='69'><img src='i/inman_b22.gif' width='22' height='69' alt=''></td>
</tr>
<tr>
<td width='22' height='100%' background='i/inman_b23.gif'></td>
</tr>
<tr>
<td width='22' height='69'><img src='i/inman_b24.gif' width='22' height='69' alt=''></td>
</tr>
<tr>
<td width='22' height='25'><img src='i/inman_b25.gif' width='22' height='25' alt=''></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</body>";
}
?>
</div>
Думаю поймёшь што с этим делать=)
От спасибки тоже не откажусь