Parašė Gugiss· 2008 Rugp. 23 23:08:20
#31
Ok duodu abejų lentelių sturktūrą ir naujienų kodą, gal padėsit genijai:
gameindex
CREATE TABLE IF NOT EXISTS `ccms_gameindex` (
`id` int(11) NOT NULL auto_increment,
`game_title` varchar(100) NOT NULL,
`category` varchar(55) NOT NULL default '',
`description` text NOT NULL,
`box` varchar(100) NOT NULL default '',
`date` varchar(55) NOT NULL default '',
`gamespecs` text NOT NULL,
`views` int(10) NOT NULL default '0',
`burl` varchar(100) NOT NULL default '',
`rdate` int(11) NOT NULL default '0',
`developer` varchar(55) NOT NULL default '',
`publisher` varchar(55) NOT NULL default '',
`esrb` varchar(55) NOT NULL default '',
`price` varchar(55) NOT NULL default '',
`mokestis` varchar(55) character set utf8 collate utf8_lithuanian_ci NOT NULL,
`buylink` varchar(100) NOT NULL,
`genre` varchar(55) NOT NULL default '',
`rank` int(11) NOT NULL default '0',
`rating` decimal(2,1) NOT NULL default '0.0',
`release_uk` varchar(255) NOT NULL default '',
`release_jp` varchar(255) NOT NULL default '',
`aka` varchar(255) NOT NULL default '',
`bid` int(5) NOT NULL,
`allow_rating` int(11) NOT NULL default '1',
PRIMARY KEY (`id`),
FULLTEXT KEY `mokestis` (`mokestis`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;
INSERT INTO `ccms_gameindex` (`id`, `game_title`, `category`, `description`, `box`, `date`, `gamespecs`, `views`, `burl`, `rdate`, `developer`, `publisher`, `esrb`, `price`, `mokestis`, `buylink`, `genre`, `rank`, `rating`, `release_uk`, `release_jp`, `aka`, `bid`, `allow_rating`) VALUES
(1, 'Age of Conan - Hyborian Adventures', 'pc', '', 'images/uploads/20080823_ageofconan_box.jpg', '2008-05-20', '', 51, 'forum-2.html', 20080520, 'Funcom', '---', 'Adults Only 18+', '€49.99', '€12.99', 'http://www.ageofconan.com/order_UK.html', 'Fantasy', 0, 0.0, '2008--', '2008--', 'AoC', 2, 1),
news
CREATE TABLE IF NOT EXISTS `ccms_news` (
`news_id` int(11) NOT NULL auto_increment,
`title` varchar(250) NOT NULL default '',
`prev_news` text NOT NULL,
`news` text NOT NULL,
`author` varchar(99) NOT NULL default '',
`archive_month` varchar(99) NOT NULL default '',
`source` varchar(99) NOT NULL default '',
`source_text` varchar(99) NOT NULL default '',
`date` varchar(99) NOT NULL default '',
`views` int(11) NOT NULL default '0',
`rating` decimal(2,1) NOT NULL default '0.0',
`platform` varchar(250) NOT NULL default '',
`game` varchar(250) NOT NULL default '',
`featured` int(11) NOT NULL default '0',
`image` varchar(255) NOT NULL default '',
`link` varchar(255) NOT NULL default '',
`tag` varchar(25) NOT NULL default '',
`news2` text NOT NULL,
`timestamp` int(10) NOT NULL,
`allow_rating` int(11) NOT NULL,
`allow_comments` int(11) NOT NULL,
PRIMARY KEY (`news_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
INSERT INTO `ccms_news` (`news_id`, `title`, `prev_news`, `news`, `author`, `archive_month`, `source`, `source_text`, `date`, `views`, `rating`, `platform`, `game`, `featured`, `image`, `link`, `tag`, `news2`, `timestamp`, `allow_rating`, `allow_comments`) VALUES
(1, 'MMORPG WORLD', 'This is gooood.', '<p>jaaaaaaaaaaaa</p>', 'Gugis', 'August 2008', '', '', 'Aug 23, 2008 18:44', 8, 0.0, '', 'World of Warcraft', 1, '', '', '', '<p>jaaaaaaaaajaaaaaaaa</p>', 1219506300, 1, 1),
kodas
<tr>
<td height="24" width="237" background="images/latest_right1.jpg" style="padding-left: 1px;">
<table cellpadding="0" align="center" cellspacing="0" border="0" width="237">
<tr>
<td width="2%" style="padding-left: 4px;"><img hspace="4" src="images/aero2.gif"></td>
<td width="73%"><a href="<?echo "naujiena-$row[news_id].html"?>" class="featured_list">
Redagavo Gugiss· 2008 Rugp. 24 12:08:38