Question #63608 on phpns changed:
https://answers.launchpad.net/phpns/+question/63608
Status: Open => Answered
alecwh proposed the following answer:
Here is the SQL dump for a default installation of phpns with a username
and password as "admin".
I've never pasted something like this into Launchpad, hopefully it
doesn't mess any of it when formatting. If it does, I can upload the
.sql file to my personal server for you. Just let me know...
-- phpMyAdmin SQL Dump
-- version 2.11.8.1deb1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Mar 21, 2009 at 11:54 AM
-- Server version: 5.0.67
-- PHP Version: 5.2.6-2ubuntu4.1
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `sqldump`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpns_articles`
--
CREATE TABLE IF NOT EXISTS `phpns_articles` (
`id` int(25) NOT NULL auto_increment,
`article_title` varchar(150) NOT NULL,
`article_sef_title` varchar(150) NOT NULL,
`article_subtitle` varchar(150) NOT NULL,
`article_author` varchar(100) NOT NULL,
`article_cat` varchar(15) NOT NULL,
`article_text` varchar(20000) NOT NULL,
`article_exptext` varchar(20000) NOT NULL,
`article_imgid` varchar(100) NOT NULL,
`allow_comments` varchar(1) NOT NULL,
`start_date` varchar(15) NOT NULL,
`end_date` varchar(15) NOT NULL,
`active` varchar(1) NOT NULL,
`approved` varchar(1) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`),
KEY `article_title` (`article_title`,`timestamp`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `phpns_articles`
--
INSERT INTO `phpns_articles` (`id`, `article_title`, `article_sef_title`,
`article_subtitle`, `article_author`, `article_cat`, `article_text`,
`article_exptext`, `article_imgid`, `allow_comments`, `start_date`, `end_date`,
`active`, `approved`, `timestamp`, `ip`) VALUES
(1, 'Welcome to phpns!', '', '', 'admin', 'all', '<p>If you see are
viewing this message, the phpns installation was a success! This article is
filed under &quot;Site Wide News&quot;, which is the default category
that is created during installation.</p><p><font
color="#000000">You are free to modify this message, or delete it
all together</font>. Why should you use
phpns?</p><ul><li><strong>It's
free</strong>. Phpns is released under the GPL license, which gives you
the ability to change it, redistribute it, and use it personally or
professionally.</li><li><strong>It's easy to
integrate</strong>. Only one line of code is necessary on your website
(<?php include(''path/to/shownews.php''); ?>, and you have a dynamic, fully
functional news system. </li><li><strong>It's easy to
install</strong>. The guided installation will have you up and running in
minutes, asking you just a few questions about your database
setup.</li></ul>', 'What does &quot;free&quot; mean?
<blockquote>To the phpns developers, the word &quot;free&quot;
means more than just the cost of the product. The word free means that
<strong>you are free</strong> to modify anything you want about
phpns, without any license restrictions.</blockquote><p>Why is
phpns free in both price and
modification?</p><blockquote><p>Because we believe in the
open-source message. Closed source applications restrict the user from
customizing the way the system works, and prevents the communitiy from
contributing to the package. Plus, we love seeing our software being put to
good use, and we love seeing modifications of our
work!</p></blockquote><p>Why don't you require a
&quot;Powered by phpns&quot; message at the bottom of each page, like
other news systems?</p><blockquote><p>Because we hate
that.</p></blockquote><p>What can I do to help the
project?</p><blockquote><p>If you would like to be a part of
the project, we always appreciate help. What you can
do:</p><ul><li>Spread the word. Recommend our system to your
friends and co-workers!</li><li>Report bugs you've encountered
at the <a href="http://launchpad.net/phpns">phpns launchpad
website</a>. </li><li>Submit reviews to software review
websites around the internet. As long as they are honest, this is a great way
to help us.</li><li>Donate. This helps with hosting/domain costs,
and you'll get your name on the website along with a message and URL of
your blog/website.</li><li>Become a sponsor. If you're a
hosting service, business, or organization, we're always looking for
funding and bandwith.</li><li>Develop. Contact us on the website if
you think we could use your services.</li></ul>That's it.
Enjoy phpns!<br /></blockquote>', 'imgid', '0', '', '', '1', '1',
'1237657940', '127.0.0.1');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_banlist`
--
CREATE TABLE IF NOT EXISTS `phpns_banlist` (
`id` int(10) NOT NULL auto_increment,
`ip` varchar(15) NOT NULL,
`banned_by` varchar(20) NOT NULL,
`reason` varchar(5000) NOT NULL,
`timestamp` varchar(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `phpns_banlist`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpns_categories`
--
CREATE TABLE IF NOT EXISTS `phpns_categories` (
`id` int(15) NOT NULL auto_increment,
`cat_name` varchar(100) NOT NULL,
`cat_parent` varchar(10000) NOT NULL,
`cat_author` varchar(100) NOT NULL,
`cat_desc` varchar(1000) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
--
-- Dumping data for table `phpns_categories`
--
INSERT INTO `phpns_categories` (`id`, `cat_name`, `cat_parent`, `cat_author`,
`cat_desc`, `timestamp`, `ip`) VALUES
(1, 'Site Wide News', '', 'admin', 'This is for general news on your website.',
'1237657940', '127.0.0.1');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_comments`
--
CREATE TABLE IF NOT EXISTS `phpns_comments` (
`id` int(25) NOT NULL auto_increment,
`article_id` varchar(25) NOT NULL,
`comment_text` varchar(1000) NOT NULL,
`website` varchar(100) NOT NULL,
`comment_author` varchar(20) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`approved` varchar(1) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `phpns_comments`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpns_cookielog`
--
CREATE TABLE IF NOT EXISTS `phpns_cookielog` (
`id` int(20) NOT NULL auto_increment,
`user_id` varchar(15) NOT NULL,
`rank_id` varchar(15) NOT NULL,
`cookie_id` varchar(32) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `phpns_cookielog`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpns_gconfig`
--
CREATE TABLE IF NOT EXISTS `phpns_gconfig` (
`id` int(5) NOT NULL auto_increment,
`name` varchar(100) NOT NULL,
`v1` varchar(17) NOT NULL,
`v2` varchar(10) NOT NULL,
`v3` varchar(1000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ;
--
-- Dumping data for table `phpns_gconfig`
--
INSERT INTO `phpns_gconfig` (`id`, `name`, `v1`, `v2`, `v3`) VALUES
(15, 'siteonline', '0', '0', '0'),
(16, 'def_rsslimit', '', '', '3'),
(17, 'def_rssorder', 'desc', '', ''),
(18, 'def_items_per_page', '10', '', ''),
(19, 'def_rsstitle', '', '', 'RSS feed for localhost'),
(20, 'def_rssdesc', '', '', 'An RSS feed from localhost'),
(21, 'def_rssenabled', '1', '', ''),
(22, 'def_limit', '10', '', ''),
(23, 'def_order', 'desc', '', ''),
(24, 'def_offset', '0', '', ''),
(25, 'timestamp_format', '', '', 'l F d, Y g:i a'),
(26, 'def_comlimit', '', '', '100000'),
(27, 'def_comenabled', '1', '', ''),
(28, 'def_comorder', 'asc', '', ''),
(29, 'global_message', '', '', 'Welcome to the phpns admin panel! Click
''change message'' to modify/delete this message.'),
(30, 'siteonline', '0', '0', '0'),
(31, 'wysiwyg', 'yes', '', ''),
(32, 'sys_time_format', 'l F d, Y g:i a', '', ''),
(33, 'line', 'yes', '', '');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_images`
--
CREATE TABLE IF NOT EXISTS `phpns_images` (
`id` int(15) NOT NULL auto_increment,
`user_id` varchar(15) NOT NULL,
`image_filepath` varchar(500) NOT NULL,
`alt_description` varchar(100) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
--
-- Dumping data for table `phpns_images`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpns_ranks`
--
CREATE TABLE IF NOT EXISTS `phpns_ranks` (
`id` int(15) NOT NULL auto_increment,
`rank_title` varchar(100) NOT NULL,
`rank_desc` varchar(1000) NOT NULL,
`rank_author` varchar(100) NOT NULL,
`permissions` varchar(100) NOT NULL,
`category_list` varchar(200) NOT NULL,
`timestamp` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Dumping data for table `phpns_ranks`
--
INSERT INTO `phpns_ranks` (`id`, `rank_title`, `rank_desc`, `rank_author`,
`permissions`, `category_list`, `timestamp`) VALUES
(1, 'Administrators', 'Any user assigned to this rank will have full access.',
'admin', '1,1,1,1,1,1,1,1,1,1,1,1', 'all', '1237657940');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_syslog`
--
CREATE TABLE IF NOT EXISTS `phpns_syslog` (
`id` int(24) NOT NULL auto_increment,
`task` varchar(20) NOT NULL,
`description` varchar(200) NOT NULL,
`user` int(5) NOT NULL,
`page` varchar(120) NOT NULL,
`timestamp` varchar(12) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
--
-- Dumping data for table `phpns_syslog`
--
INSERT INTO `phpns_syslog` (`id`, `task`, `description`, `user`, `page`,
`timestamp`) VALUES
(1, 'INSTALL', 'User <i>admin</i> has installed phpns!', 1,
'/phpns/install/', '1237657940'),
(12, 'login', 'User <i>admin</i> has <strong>logged
in</strong>.', 1, 'login.php?do=p', '1237657996');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_templates`
--
CREATE TABLE IF NOT EXISTS `phpns_templates` (
`id` int(15) NOT NULL auto_increment,
`template_name` varchar(100) NOT NULL,
`template_desc` varchar(1000) NOT NULL,
`template_author` varchar(100) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`html_article` varchar(5000) NOT NULL,
`html_comment` varchar(5000) NOT NULL,
`html_form` varchar(5000) NOT NULL,
`html_pagination` varchar(5000) NOT NULL,
`template_selected` varchar(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `phpns_templates`
--
INSERT INTO `phpns_templates` (`id`, `template_name`, `template_desc`,
`template_author`, `timestamp`, `html_article`, `html_comment`, `html_form`,
`html_pagination`, `template_selected`) VALUES
(1, 'Default', 'This is the default phpns template.', 'Phpns-team',
'1194252704', '<div style="margin-bottom: 30px; min-height:
130px;">\r\n <h2 style="margin-bottom: 0pt"><a
href="{article_href}" style="text-decoration:
none;">{title}</a></h2>\r\n
<h3><em>{sub_title}</em></h3>\r\n <h4
style="margin: 0 0 0 3em; font-weight: normal;">Posted by <a
href="#">{author}</a> on {date}</h4>\r\n <span
style="float: right"><a
href="{image_location}">{image}</a></span>\r\n<div
style="float:right; padding: 0 0 10px 10px">{reddit}
{digg}</div>\r\n {main_article}\r\n {extended_article}\r\n
<div id="comments" style="text-align: right; clear:
both;">\r\n <strong><a
href="{article_href}#comments">{comment_count}
comments</a></strong>\r\n </div>\r\n</div>\r\n',
'<div style="background: #eee; margin: 20px 0 0 5%; padding:
5px;">\r\n <div style="border: 1px solid #ccc; padding:
3px; background: #ccc; margin-bo\nttom: 5px;"> \r\n
<div style="text-align: right; float: right"> {timestamp}
{admin}</div> \r\n <strong>Posted by <a
href="{website}">{author}</a></strong> as {ip}\r\n
</div>\r\n {comment}\r\n</div>', '<form
style="margin-top: 50px;" action="{action}"
method="post">\r\n <input type="text"
name="name" id="name" /> <label
for="name">Name (required)</label><br />\r\n <input
type="text" name="email" id="email" />
<label for="email">Email (not publishe\nd)
(required)</label><br />\r\n <input type="text"
name="website" id="website" /> <label
for="website">Website</label><br />\r\n
<textarea cols="3" rows="5" name="comment"
style="width:100%; height: 150px"></textarea><br
/>\r\n <input type="text" name="captcha"
style="width: 100px" /> <label
for="captcha"><strong>What is
{captcha_question}?</strong></label><br />\r\n
{hidden_data}\r\n {captcha_answer}\r\n <input
type="submit" value="Submit comment" id="submit"
/>\r\n</form>\r\n\r\n', '\n<a style="padding: 3px; margin:
10px; border: 1px solid #888;"
href="{previous_page}">Previous Page</a> {middle_pages}
<a style="padding: 3px; margin: 10px; border: 1px solid #888;"
href="{next_page}">Next Page</a>', '1');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_themes`
--
CREATE TABLE IF NOT EXISTS `phpns_themes` (
`id` int(10) NOT NULL auto_increment,
`theme_name` varchar(100) NOT NULL,
`theme_author` varchar(100) NOT NULL,
`theme_dir` varchar(200) NOT NULL,
`base_dir` varchar(50) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`theme_selected` varchar(1) NOT NULL,
`permissions` varchar(10000) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;
--
-- Dumping data for table `phpns_themes`
--
INSERT INTO `phpns_themes` (`id`, `theme_name`, `theme_author`, `theme_dir`,
`base_dir`, `timestamp`, `theme_selected`, `permissions`) VALUES
(1, 'default', 'phpns team', 'themes/default/', 'default', '1237657940', '1',
'');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_userlogin`
--
CREATE TABLE IF NOT EXISTS `phpns_userlogin` (
`id` int(20) NOT NULL auto_increment,
`username` varchar(15) NOT NULL,
`rank_id` varchar(15) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`),
KEY `user_id` (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=83 ;
--
-- Dumping data for table `phpns_userlogin`
--
INSERT INTO `phpns_userlogin` (`id`, `username`, `rank_id`, `timestamp`, `ip`)
VALUES
(82, 'admin', '1', '1237657996', '127.0.0.1');
-- --------------------------------------------------------
--
-- Table structure for table `phpns_users`
--
CREATE TABLE IF NOT EXISTS `phpns_users` (
`id` int(15) NOT NULL auto_increment,
`user_name` varchar(100) NOT NULL,
`full_name` varchar(150) NOT NULL,
`email` varchar(100) NOT NULL,
`password` varchar(40) NOT NULL,
`timestamp` varchar(15) NOT NULL,
`ip` varchar(15) NOT NULL,
`msn` varchar(100) NOT NULL,
`aim` varchar(100) NOT NULL,
`yahoo` varchar(100) NOT NULL,
`skype` varchar(100) NOT NULL,
`display_picture` varchar(150) NOT NULL,
`rank_id` varchar(15) NOT NULL,
`notifications` varchar(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
--
-- Dumping data for table `phpns_users`
--
INSERT INTO `phpns_users` (`id`, `user_name`, `full_name`, `email`, `password`,
`timestamp`, `ip`, `msn`, `aim`, `yahoo`, `skype`, `display_picture`,
`rank_id`, `notifications`) VALUES
(1, 'admin', 'admin', 'ad...@example.org',
'd033e22ae348aeb5660fc2140aec35850c4da997', '1237657940', '127.0.0.1', '', '',
'', '', '', '1', '1');
You received this question notification because you are a member of
Phpns-team, which is an answer contact for phpns.
_______________________________________________
Mailing list: https://launchpad.net/~phpns-team
Post to : phpns-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~phpns-team
More help : https://help.launchpad.net/ListHelp
