mURL

This is a re-write in cakePHP for the original custom mURL.net application.

Setup

• Download the latest from GitHub onto a new directory hierarchy.
• Download the latest cakePHP1.3 and place at same level as this README file as cake.
• Create MySQL database with the sctructure defined below.
• Create file config/database.php based on the sample provided.
• Create file config/murl.php based on the sample provided.
• Add a ban to the domain hosting mURL to prevent loops.

Database

--
-- Table structure for table `hits`
--

CREATE TABLE `hits` (
  `id` int(11) NOT NULL auto_increment,
  `murl_id` int(11) NOT NULL,
  `remote` varchar(20) default NULL,
  `referer` varchar(255) default NULL,
  `agent` varchar(255) default NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

--
-- Table structure for table `murls`
--

CREATE TABLE `murls` (
 `id` int(11) NOT NULL auto_increment,
  `code` varchar(255) NOT NULL default '',
  `protect` varchar(255) NOT NULL,
  `uri` varchar(255) NOT NULL,
  `created` datetime default NULL,
  `modified` datetime default NULL,
  `destruct` tinyint(1) NOT NULL default '0',
  `private` tinyint(1) NOT NULL default '0',
  `hits` int(11) NOT NULL default '0',
  `remote` varchar(20) NOT NULL default '0.0.0.0',
  `referer` varchar(255) NOT NULL,
  `agent` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `nick` (`code`),
  KEY `nick_index` (`code`(10))
) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=latin1;

--
-- Table structure for table `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `ban` varchar(255) NOT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `message` varchar(255) NOT NULL,
  `hits` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` char(50) DEFAULT NULL,
    `password` char(40) DEFAULT NULL,
    PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;

Contributing

1. Fork it.
2. Create a branch (git checkout -b my_murl)
3. Commit your changes (git commit -am "Added Cool Feature")
4. Push to the branch (git push origin my_murl)
5. Create an Issue with a link to your branch