Administrace komentářů

CREATE TABLE `photos` (
  `id` int(8) NOT NULL auto_increment,
  `titulek` varchar(50) character set latin2 default NULL,
  `popis` text character set latin2,
  `vkladatel` varchar(50) character set latin2 default NULL,
  `vkladatel_email` varchar(50) character set latin2 default NULL,
  `kategorie` varchar(20) character set latin2 default NULL,
  `lokalita` varchar(50) character set latin2 default NULL,
  `jezdec` varchar(50) character set latin2 default NULL,
  `zobrazeno` int(8) default '0',
  `hodnoceno` int(5) default NULL,
  `hodnoceni` int(5) default NULL,
  `last_vote` varchar(20) character set latin2 default NULL,
  `ip` varchar(16) character set latin2 default NULL,
  `ins_time` datetime NOT NULL default '0000-00-00 00:00:00',
  `last_com_user` varchar(50) character set latin2 default NULL,
  `last_com_time` datetime default NULL,
  `category` int(2) default NULL,
  PRIMARY KEY  (`id`),
  KEY `hodnoceno` (`hodnoceno`),
  KEY `hodnoceni` (`hodnoceni`),
  KEY `vkladatel` (`vkladatel`),
  KEY `datum` (`datum`),
  KEY `ip` (`ip`),
  KEY `jezdec` (`jezdec`),
  KEY `ins_time` (`ins_time`),
  KEY `category` (`category`),
  KEY `lokalita` (`lokalita`)
) ENGINE=MyISAM;

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

-- 
-- Table structure for table `photos_comments`
-- 

CREATE TABLE `photos_comments` (
  `id` int(10) NOT NULL auto_increment,
  `photo_id` int(10) NOT NULL default '0',
  `jmeno` varchar(50) character set latin2 default NULL,
  `mail` varchar(50) character set latin2 default NULL,
  `comment` text character set latin2,
  `datum` varchar(20) character set latin2 default NULL,
  `ip` varchar(16) character set latin2 default NULL,
  `auth` int(8) default NULL,
  PRIMARY KEY  (`id`),
  KEY `photo_id` (`photo_id`)
);

SELECT photos.id AS id, titulek,datum,vkladatel, vkladatel_email,popis, lokalita,jezdec,zobrazeno,hodnoceno,hodnoceni,last_vote, photos_categories.category AS category, photos_categories.id AS cat_id FROM photos, photos_categories WHERE photos.category = photos_categories.id AND photos.id=36244 LIMIT 1

SELECT id,titulek,hodnoceni/hodnoceno,hodnoceno FROM photos WHERE ins_time > CURRENT_TIMESTAMP - INTERVAL 7 DAY AND hodnoceno>10 ORDER BY (hodnoceni/hodnoceno) ASC LIMIT 10

SELECT jmeno,mail,datum, comment,ip,id FROM photos_comments WHERE photo_id='33935' ORDER BY id