» tagged pages
» logout
BozPages
Return to BozPages

How BozPages Works

(or Cancel)

(Editing anonymously: to be credited for your changes, login or register a new account)

other page actions:

Tags Applied to this Topic

1 person has tagged this page:

Bozpages is fairly simple, users create pages that are associated with rss feeds.

In order to not require registration, pages are never destroyed or changed, instead a new version of the page is made on every page change.

Projects used

Source Codes

Source code can be found in these files:

Database structure

-- Database: `bozpages`
--

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

--
-- Table structure for table `bozpages`
--

CREATE TABLE `bozpages` (
 `id` int(11) NOT NULL auto_increment,
 `hitCount` int(11) NOT NULL default '0',
 `hash` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`id`),
 KEY `hitCount` (`hitCount`),
 KEY `hash` (`hash`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8484 ;

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

--
-- Table structure for table `feeds`
--

CREATE TABLE `feeds` (
 `id` int(11) NOT NULL auto_increment,
 `url` varchar(255) NOT NULL default '',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `url` (`url`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4042 ;

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

--
-- Table structure for table `feeds_for_page`
--

CREATE TABLE `feeds_for_page` (
 `feed_id` int(11) NOT NULL default '0',
 `boz_id` int(11) NOT NULL default '0',
 `linkedDate` timestamp NOT NULL default CURRENT_TIMESTAMP on update
CURRENT_TIMESTAMP,
 KEY `feed_id` (`feed_id`),
 KEY `boz_id` (`boz_id`),
 KEY `linkedDate` (`linkedDate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

Username:
Password:
(or Cancel)