Disqus Comment System - Version 2.87

Version Description

Version update for readme.txt and plugin directory assets

Release Info

Developer	iamfrancisyo
Plugin	Disqus Comment System
Version	2.87
Comparing to
See all releases

Code changes from version 2.86 to 2.87

Files changed (17) hide show

DEV +16 -0
assets/banner-772x250.png +0 -0
assets/screenshot-1.png +0 -0
assets/screenshot-10.png +0 -0
assets/screenshot-11.png +0 -0
assets/screenshot-2.png +0 -0
assets/screenshot-3.png +0 -0
assets/screenshot-4.png +0 -0
assets/screenshot-5.png +0 -0
assets/screenshot-6.png +0 -0
assets/screenshot-7.png +0 -0
assets/screenshot-8.png +0 -0
assets/screenshot-9.png +0 -0
disqus.php +2 -2
readme.txt +87 -25
tests/initial.sql +380 -0
tests/tests.php +128 -0

DEV ADDED Viewed

	@@ -0,0 +1,16 @@


1	+ This guide describes how to build disqus-wordpress from source.
2	+
3	+ ::
4	+
5	+ git clone git://github.com/disqus/disqus-wordpress.git disqus
6	+ cd disqus
7	+ git submodule update --init
8	+
9	+ Updating requires also updating submodules:
10	+
11	+ ::
12	+
13	+ git pull origin master
14	+ git submodule foreach git pull origin master
15	+
16	+

assets/banner-772x250.png ADDED Viewed

Binary file

assets/screenshot-1.png CHANGED Viewed

Binary file

assets/screenshot-10.png ADDED Viewed

Binary file

assets/screenshot-11.png ADDED Viewed

Binary file

assets/screenshot-2.png CHANGED Viewed

Binary file

assets/screenshot-3.png CHANGED Viewed

Binary file

assets/screenshot-4.png ADDED Viewed

Binary file

assets/screenshot-5.png ADDED Viewed

Binary file

assets/screenshot-6.png ADDED Viewed

Binary file

assets/screenshot-7.png ADDED Viewed

Binary file

assets/screenshot-8.png ADDED Viewed

Binary file

assets/screenshot-9.png ADDED Viewed

Binary file

disqus.php CHANGED Viewed

	@@ -4,7 +4,7 @@ Plugin Name: Disqus Comment System
4	Plugin URI: https://disqus.com/
5	Description: The Disqus comment system replaces your WordPress comment system with your comments hosted and powered by Disqus. Head over to the Comments admin page to set up your Disqus Comment System.
6	Author: Disqus <team@disqus.com>
7	- Version: 2.86
8	Author URI: https://disqus.com/
9	*/
10
	@@ -18,7 +18,7 @@ define('DISQUS_CAN_EXPORT', is_file(dirname(__FILE__) . '/export.php'));
18	if (!defined('DISQUS_DEBUG')) {
19	define('DISQUS_DEBUG', false);
20	}
21	- define('DISQUS_VERSION', '2.86');
22	define('DISQUS_SYNC_TIMEOUT', 30);
23
24	/**


4	Plugin URI: https://disqus.com/
5	Description: The Disqus comment system replaces your WordPress comment system with your comments hosted and powered by Disqus. Head over to the Comments admin page to set up your Disqus Comment System.
6	Author: Disqus <team@disqus.com>
7	+ Version: 2.87
8	Author URI: https://disqus.com/
9	*/
10

18	if (!defined('DISQUS_DEBUG')) {
19	define('DISQUS_DEBUG', false);
20	}
21	+ define('DISQUS_VERSION', '2.87');
22	define('DISQUS_SYNC_TIMEOUT', 30);
23
24	/**

readme.txt CHANGED Viewed

@@ -1,39 +1,89 @@
             === Disqus Comment System ===
-            -
            Contributors: disqus, alexkingorg, crowdfavorite, zeeg, tail, thetylerhayes, ryanv12
             Tags: comments, threaded, email, notification, spam, avatars, community, profile, widget, disqus
             Requires at least: 3.2
             Tested up to: 4.6.1
-            -
            Stable tag: 2.86
-            -
            The Disqus comment system replaces your WordPress comment system with your comments hosted and powered by Disqus.
             == Description ==
-            -
            Disqus, pronounced "discuss", is a service and tool for web comments and
-            -
            discussions. Disqus makes commenting easier and more interactive,
-            -
            while connecting websites and commenters across a thriving discussion
-            -
            community.
-            -
            The Disqus for WordPress plugin seamlessly integrates using the Disqus API and by syncing with WordPress comments.
-            -
            = Disqus for WordPress =
-            -
            * Uses the Disqus API
-            -
            * Comments indexable by search engines (SEO-friendly)
-            -
            * Support for importing existing comments
-            -
            * Auto-sync (backup) of comments with Disqus and WordPress database
             = Disqus Features =
-            -
            * Threaded comments and replies
-            -
            * Notifications and reply by email
-            -
            * Subscribe and RSS options
-            -
            * Aggregated comments and social mentions
-            -
            * Powerful moderation and admin tools
-            -
            * Full spam filtering, blacklists and whitelists
-            -
            * Support for Disqus community widgets
-            -
            * Connected with a large discussion community
-            -
            * Increased exposure and readership
             == Installation ==
@@ -48,18 +98,30 @@ The Disqus for WordPress plugin seamlessly integrates using the Disqus API and b
 . From your blog administration, click on Comments to change settings
                (WordPress 2.0 users can find the settings under Options > Disqus.)
-            -
            = More documentation =
             Go to [https://disqus.com/help/wordpress](https://disqus.com/help/wordpress)
             == Screenshots ==
 . Disqus Comments
-            -
            2. Discovery Box (part of Disqus Comments)
-            -
            3. Moderation Interface
             == Changelog ==
             = 2.86 =
             * Don't attempt to use cURL on IIS servers


1	=== Disqus Comment System ===
2	+ Contributors: disqus, alexkingorg, crowdfavorite, zeeg, tail, thetylerhayes, ryanv12, iamfrancisyo, brevityness
3	Tags: comments, threaded, email, notification, spam, avatars, community, profile, widget, disqus
4	Requires at least: 3.2
5	Tested up to: 4.6.1
6	+ Stable tag: 2.87
7
8	+ Disqus is the web's most popular comment system. Use Disqus to increase engagement, retain readers, and grow your audience.
9
10	== Description ==
11
12	+ [Disqus](https://disqus.com/) is the web’s most popular commenting system trusted by millions of publishers to increase reader engagement, grow audience and traffic, and monetize content. Disqus helps publishers of all sizes engage directly with their audiences to build loyalty, retain readers, and foster thriving communities.



13
14	+ The Disqus for WordPress plugin lets site owners and developers easily add Disqus to their sites, replacing the default WordPress comment system. Disqus installs in minutes and imports your existing comments so you don’t lose any.
15
16	+ = Why Disqus? =
17
18	+ * Simple one-click installation that seamlessly integrates with WordPress without ever needing to edit a single line of code or losing any of your existing comments
19	+ * Keep users engaged on your site longer with a commenting experience readers love
20	+ * Bring users back to your site with web and email notifications and personalized digests
21	+ * Improve SEO ranking with user generated content
22	+ * Keep spam out with our best-in-class anti-spam filter powered by Akismet
23	+ * Single profile for commenting on over 4 million sites including social login support for Facebook, Twitter, and Google accounts
24	+ * Trusted by sites like Wired, The Atlantic, and EW
25
26	= Disqus Features =
27
28	+ * Syncs comments automatically to WordPress for backup and flexibility if you ever decide to switch to a different platform
29	+ * Loads asynchronously with advanced caching so that Disqus doesn’t affect your site’s performance
30	+ * Monetization options to grow revenue
31	+ * Export comments to WordPress-compatible XML to backup or migrate to another system
32	+ * Analytics dashboard for measuring overall engagement on your site
33	+ * Mobile responsive design
34	+
35	+ = Engagement Features =
36	+
37	+ * Realtime comments system with fun discussion interactions: voting, photo and video upload, rich media embed (Youtube, Twitter, Vimeo, and more), spoiler tags, mentions
38	+ * Comment text formatting (e.g. bold, link, italics, quote) using HTML tags as well as code syntax highlighting
39	+ * Threaded comment display (nested 3 levels) with ability to collapse individual threads
40	+ * Sort discussion by oldest, newest, and best comments
41	+ * Flexible login options - Social login with Facebook, Twitter, and Google, SSO, and guest commenting support
42	+ * Instant activity notifications, email notifications, and digests pull readers back in
43	+ * User profiles that show you recent comment history and frequented communities
44	+ * Discovery widget that shows active discussions happening elsewhere on your site
45	+
46	+ = Moderation Features =
47	+
48	+ * Automatic anti-spam filter powered by Akismet
49	+ * Automated pre-moderation controls to flag comments based on links, user reputation
50	+ * Moderate directly in the discussion, via email, or moderation panel
51	+ * Email notifications for newly posted comments, replies
52	+ * Moderation Panel that lets you search, filter, sort, and manage your comments
53	+ * Self-moderation tools like user blocking, comment flagging
54	+
55	+ == Support ==
56	+
57	+ * Search our [Knowledge Base](https://help.disqus.com/) for solutions to common troubleshooting questions
58	+ * Check out our support community, [Discuss Disqus](https://disqus.com/home/channel/discussdisqus/), to see if your question has been answered
59	+ * Talk to our Support team at [disqus.com/support](disqus.com/support)
60	+ * Visit our [Getting Started](https://help.disqus.com/customer/en/portal/articles/1264625-getting-started) page to learn the basics of Disqus
61	+
62	+ == Frequently Asked Questions ==
63	+
64	+ = Is Disqus free to use on my site? =
65	+
66	+ Yes! Disqus is free to use. We also provide [subscription plans](https://help.disqus.com/customer/en/portal/articles/2759918-disqus-pricing-and-plans) for larger, commercial sites that want access to more powerful moderation and audience tools and customization.
67	+
68	+ = How do I customize the look-and-feel of Disqus? =
69	+
70	+ Disqus automatically checks your site's font and background color and adapts to either a light or dark color scheme, along with a serif or sans-serif font. If these are detected incorrectly, you can [override them](https://help.disqus.com/customer/en/portal/articles/545277-disqus-appearance-tweaks) in your Settings.
71	+
72	+ = Will I lose comments if I deactivate Disqus? =
73	+
74	+ The Disqus for WordPress plugin automatically syncs comments back to WordPress. These comments will remain in WordPress should Disqus be deactivated or removed. You can also [export your comments](https://help.disqus.com/customer/en/portal/articles/1104797-importing-exporting#exporting) from Disqus at any time.
75	+
76	+ = Can I import my existing WordPress comments into Disqus? =
77	+
78	+ Yes, you can import your existing WordPress comments into Disqus during installation.
79	+
80	+ = How do I set up Single Sign-On (SSO)? =
81	+
82	+ SSO allows users in your database to comment without requiring them to register with Disqus. Access to SSO is currently available as an add-on for users with a [Pro subscription](https://help.disqus.com/customer/en/portal/articles/2759918-disqus-pricing-and-plans#pro-plan). If you would like to enable this feature, [contact our Support team](https://disqus.com/support/?article=contact_SSO). Also check out our guide for [setting up SSO on WordPress](https://help.disqus.com/customer/portal/articles/1148635).
83	+
84	+ = I’m experiencing an issue with my installation of Disqus. =
85	+
86	+ Check out our [WordPress Troubleshooting guide](https://help.disqus.com/customer/portal/articles/472005-wordpress-troubleshooting) with specific solutions for potential problems you might be experiencing.
87
88	== Installation ==
89

98	2. From your blog administration, click on Comments to change settings
99	(WordPress 2.0 users can find the settings under Options > Disqus.)
100
101	+ = Installation trouble? =
102
103	Go to [https://disqus.com/help/wordpress](https://disqus.com/help/wordpress)
104
105	== Screenshots ==
106
107	1. Disqus Comments
108	+ 2. Comment Reply
109	+ 3. Disqus Audience Platform
110	+ 4. Featured Comment
111	+ 5. Discovery Box (part of Disqus Comments)
112	+ 6. Mentions
113	+ 7. Real-time Comments
114	+ 8. Commenter User Profile
115	+ 9. Moderation Panel
116	+ 10. Moderation Panel Comments
117	+ 11. Moderate by Email Notifications
118
119	== Changelog ==
120
121	+ = 2.87 =
122	+
123	+ * Version update for readme.txt and plugin directory assets
124	+
125	= 2.86 =
126
127	* Don't attempt to use cURL on IIS servers

tests/initial.sql ADDED Viewed

	@@ -0,0 +1,380 @@


1	+ -- MySQL dump 10.13 Distrib 5.1.48, for apple-darwin10.4.0 (i386)
2	+ --
3	+ -- Host: localhost Database: wordpress
4	+ -- ------------------------------------------------------
5	+ -- Server version 5.1.48
6	+
7	+ /!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
8	+ /!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
9	+ /!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
10	+ /!40101 SET NAMES utf8 /;
11	+ /!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE /;
12	+ /!40103 SET TIME_ZONE='+00:00' /;
13	+ /!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;
14	+ /!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 /;
15	+ /!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' /;
16	+ /!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
17	+
18	+ --
19	+ -- Table structure for table `wp_commentmeta`
20	+ --
21	+
22	+ DROP TABLE IF EXISTS `wp_commentmeta`;
23	+ /!40101 SET @saved_cs_client = @@character_set_client /;
24	+ /!40101 SET character_set_client = utf8 /;
25	+ CREATE TABLE `wp_commentmeta` (
26	+ `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
27	+ `comment_id` bigint(20) unsigned NOT NULL DEFAULT '0',
28	+ `meta_key` varchar(255) DEFAULT NULL,
29	+ `meta_value` longtext,
30	+ PRIMARY KEY (`meta_id`),
31	+ KEY `comment_id` (`comment_id`),
32	+ KEY `meta_key` (`meta_key`)
33	+ ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
34	+ /!40101 SET character_set_client = @saved_cs_client /;
35	+
36	+ --
37	+ -- Dumping data for table `wp_commentmeta`
38	+ --
39	+
40	+ LOCK TABLES `wp_commentmeta` WRITE;
41	+ /!40000 ALTER TABLE `wp_commentmeta` DISABLE KEYS /;
42	+ /!40000 ALTER TABLE `wp_commentmeta` ENABLE KEYS /;
43	+ UNLOCK TABLES;
44	+
45	+ --
46	+ -- Table structure for table `wp_comments`
47	+ --
48	+
49	+ DROP TABLE IF EXISTS `wp_comments`;
50	+ /!40101 SET @saved_cs_client = @@character_set_client /;
51	+ /!40101 SET character_set_client = utf8 /;
52	+ CREATE TABLE `wp_comments` (
53	+ `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
54	+ `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0',
55	+ `comment_author` tinytext NOT NULL,
56	+ `comment_author_email` varchar(100) NOT NULL DEFAULT '',
57	+ `comment_author_url` varchar(200) NOT NULL DEFAULT '',
58	+ `comment_author_IP` varchar(100) NOT NULL DEFAULT '',
59	+ `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
60	+ `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
61	+ `comment_content` text NOT NULL,
62	+ `comment_karma` int(11) NOT NULL DEFAULT '0',
63	+ `comment_approved` varchar(20) NOT NULL DEFAULT '1',
64	+ `comment_agent` varchar(255) NOT NULL DEFAULT '',
65	+ `comment_type` varchar(20) NOT NULL DEFAULT '',
66	+ `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
67	+ `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
68	+ PRIMARY KEY (`comment_ID`),
69	+ KEY `comment_approved` (`comment_approved`),
70	+ KEY `comment_post_ID` (`comment_post_ID`),
71	+ KEY `comment_approved_date_gmt` (`comment_approved`,`comment_date_gmt`),
72	+ KEY `comment_date_gmt` (`comment_date_gmt`)
73	+ ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8;
74	+ /!40101 SET character_set_client = @saved_cs_client /;
75	+
76	+ --
77	+ -- Dumping data for table `wp_comments`
78	+ --
79	+
80	+ LOCK TABLES `wp_comments` WRITE;
81	+ /!40000 ALTER TABLE `wp_comments` DISABLE KEYS /;
82	+ INSERT INTO `wp_comments` VALUES (1,1,'Mr WordPress','','http://wordpress.org/','','2010-06-08 01:27:22','2010-06-08 01:27:22','Hi, this is a comment.<br />To delete a comment, just log in and view the post's comments. There you will have the option to edit or delete them.',0,'1','','',0,0),(2,1,'dcramer','dcramer@gmail.com','','127.0.0.1','2010-06-08 01:32:37','2010-06-08 06:32:37','Testing',0,'1','Disqus/1.0:47','',0,0),(3,1,'David Cramer','dcramer@gmail.com','http://www.davidcramer.net','127.0.0.1','2010-06-08 17:15:14','2010-06-08 22:15:14','Here's one more test',0,'1','Disqus/1.0:48','',0,0);
83	+ /!40000 ALTER TABLE `wp_comments` ENABLE KEYS /;
84	+ UNLOCK TABLES;
85	+
86	+ --
87	+ -- Table structure for table `wp_links`
88	+ --
89	+
90	+ DROP TABLE IF EXISTS `wp_links`;
91	+ /!40101 SET @saved_cs_client = @@character_set_client /;
92	+ /!40101 SET character_set_client = utf8 /;
93	+ CREATE TABLE `wp_links` (
94	+ `link_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
95	+ `link_url` varchar(255) NOT NULL DEFAULT '',
96	+ `link_name` varchar(255) NOT NULL DEFAULT '',
97	+ `link_image` varchar(255) NOT NULL DEFAULT '',
98	+ `link_target` varchar(25) NOT NULL DEFAULT '',
99	+ `link_description` varchar(255) NOT NULL DEFAULT '',
100	+ `link_visible` varchar(20) NOT NULL DEFAULT 'Y',
101	+ `link_owner` bigint(20) unsigned NOT NULL DEFAULT '1',
102	+ `link_rating` int(11) NOT NULL DEFAULT '0',
103	+ `link_updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
104	+ `link_rel` varchar(255) NOT NULL DEFAULT '',
105	+ `link_notes` mediumtext NOT NULL,
106	+ `link_rss` varchar(255) NOT NULL DEFAULT '',
107	+ PRIMARY KEY (`link_id`),
108	+ KEY `link_visible` (`link_visible`)
109	+ ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
110	+ /!40101 SET character_set_client = @saved_cs_client /;
111	+
112	+ --
113	+ -- Dumping data for table `wp_links`
114	+ --
115	+
116	+ LOCK TABLES `wp_links` WRITE;
117	+ /!40000 ALTER TABLE `wp_links` DISABLE KEYS /;
118	+ INSERT INTO `wp_links` VALUES (1,'http://codex.wordpress.org/','Documentation','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(2,'http://wordpress.org/development/','Development Blog','','','','Y',1,0,'0000-00-00 00:00:00','','','http://wordpress.org/development/feed/'),(3,'http://wordpress.org/extend/ideas/','Suggest Ideas','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(4,'http://wordpress.org/support/','Support Forum','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(5,'http://wordpress.org/extend/plugins/','Plugins','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(6,'http://wordpress.org/extend/themes/','Themes','','','','Y',1,0,'0000-00-00 00:00:00','','',''),(7,'http://planet.wordpress.org/','WordPress Planet','','','','Y',1,0,'0000-00-00 00:00:00','','','');
119	+ /!40000 ALTER TABLE `wp_links` ENABLE KEYS /;
120	+ UNLOCK TABLES;
121	+
122	+ --
123	+ -- Table structure for table `wp_options`
124	+ --
125	+
126	+ DROP TABLE IF EXISTS `wp_options`;
127	+ /!40101 SET @saved_cs_client = @@character_set_client /;
128	+ /!40101 SET character_set_client = utf8 /;
129	+ CREATE TABLE `wp_options` (
130	+ `option_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
131	+ `blog_id` int(11) NOT NULL DEFAULT '0',
132	+ `option_name` varchar(64) NOT NULL DEFAULT '',
133	+ `option_value` longtext NOT NULL,
134	+ `autoload` varchar(20) NOT NULL DEFAULT 'yes',
135	+ PRIMARY KEY (`option_id`),
136	+ UNIQUE KEY `option_name` (`option_name`)
137	+ ) ENGINE=MyISAM AUTO_INCREMENT=192 DEFAULT CHARSET=utf8;
138	+ /!40101 SET character_set_client = @saved_cs_client /;
139	+
140	+ --
141	+ -- Dumping data for table `wp_options`
142	+ --
143	+
144	+ LOCK TABLES `wp_options` WRITE;
145	+ /!40000 ALTER TABLE `wp_options` DISABLE KEYS /;
146	+ INSERT INTO `wp_options` VALUES (1,0,'_transient_random_seed','e69b4e983acc5f314184ba789733f808','yes'),(2,0,'siteurl','http://localhost/~dcramer/wordpress-2.9','yes'),(3,0,'blogname','WordPress 2.9','yes'),(4,0,'blogdescription','Just another WordPress weblog','yes'),(5,0,'users_can_register','0','yes'),(6,0,'admin_email','dcramer@gmail.com','yes'),(7,0,'start_of_week','1','yes'),(8,0,'use_balanceTags','0','yes'),(9,0,'use_smilies','1','yes'),(10,0,'require_name_email','1','yes'),(11,0,'comments_notify','1','yes'),(12,0,'posts_per_rss','10','yes'),(13,0,'rss_use_excerpt','0','yes'),(14,0,'mailserver_url','mail.example.com','yes'),(15,0,'mailserver_login','login@example.com','yes'),(16,0,'mailserver_pass','password','yes'),(17,0,'mailserver_port','110','yes'),(18,0,'default_category','1','yes'),(19,0,'default_comment_status','open','yes'),(20,0,'default_ping_status','open','yes'),(21,0,'default_pingback_flag','1','yes'),(22,0,'default_post_edit_rows','10','yes'),(23,0,'posts_per_page','10','yes'),(24,0,'date_format','F j, Y','yes'),(25,0,'time_format','g:i a','yes'),(26,0,'links_updated_date_format','F j, Y g:i a','yes'),(27,0,'links_recently_updated_prepend','<em>','yes'),(28,0,'links_recently_updated_append','</em>','yes'),(29,0,'links_recently_updated_time','120','yes'),(30,0,'comment_moderation','0','yes'),(31,0,'moderation_notify','1','yes'),(32,0,'permalink_structure','','yes'),(33,0,'gzipcompression','0','yes'),(34,0,'hack_file','0','yes'),(35,0,'blog_charset','UTF-8','yes'),(36,0,'moderation_keys','','no'),(37,0,'active_plugins','a:1:{i:0;s:17:\"disqus/disqus.php\";}','yes'),(38,0,'home','http://localhost/~dcramer/wordpress-2.9','yes'),(39,0,'category_base','','yes'),(40,0,'ping_sites','http://rpc.pingomatic.com/','yes'),(41,0,'advanced_edit','0','yes'),(42,0,'comment_max_links','2','yes'),(43,0,'gmt_offset','0','yes'),(44,0,'default_email_category','1','yes'),(45,0,'recently_edited','','no'),(46,0,'use_linksupdate','0','yes'),(47,0,'template','default','yes'),(48,0,'stylesheet','default','yes'),(49,0,'comment_whitelist','1','yes'),(50,0,'blacklist_keys','','no'),(51,0,'comment_registration','0','yes'),(52,0,'rss_language','en','yes'),(53,0,'html_type','text/html','yes'),(54,0,'use_trackback','0','yes'),(55,0,'default_role','subscriber','yes'),(56,0,'db_version','12329','yes'),(57,0,'uploads_use_yearmonth_folders','1','yes'),(58,0,'upload_path','','yes'),(59,0,'secret','^mmMx31fC%rXXK&%aCQz$GcUHt@rEWY8w)B9GFwQ@cwRzOyKs)e)l!)h%XPlaH$','yes'),(60,0,'blog_public','1','yes'),(61,0,'default_link_category','2','yes'),(62,0,'show_on_front','posts','yes'),(63,0,'tag_base','','yes'),(64,0,'show_avatars','1','yes'),(65,0,'avatar_rating','G','yes'),(66,0,'upload_url_path','','yes'),(67,0,'thumbnail_size_w','150','yes'),(68,0,'thumbnail_size_h','150','yes'),(69,0,'thumbnail_crop','1','yes'),(70,0,'medium_size_w','300','yes'),(71,0,'medium_size_h','300','yes'),(72,0,'avatar_default','mystery','yes'),(73,0,'enable_app','0','yes'),(74,0,'enable_xmlrpc','0','yes'),(75,0,'large_size_w','1024','yes'),(76,0,'large_size_h','1024','yes'),(77,0,'image_default_link_type','file','yes'),(78,0,'image_default_size','','yes'),(79,0,'image_default_align','','yes'),(80,0,'close_comments_for_old_posts','0','yes'),(81,0,'close_comments_days_old','14','yes'),(82,0,'thread_comments','0','yes'),(83,0,'thread_comments_depth','5','yes'),(84,0,'page_comments','1','yes'),(85,0,'comments_per_page','50','yes'),(86,0,'default_comments_page','newest','yes'),(87,0,'comment_order','asc','yes'),(88,0,'sticky_posts','a:0:{}','yes'),(89,0,'widget_categories','a:2:{i:2;a:0:{}s:12:\"_multiwidget\";i:1;}','yes'),(90,0,'widget_text','a:2:{i:2;a:0:{}s:12:\"_multiwidget\";i:1;}','yes'),(91,0,'widget_rss','a:2:{i:2;a:0:{}s:12:\"_multiwidget\";i:1;}','yes'),(92,0,'timezone_string','','yes'),(93,0,'embed_autourls','1','yes'),(94,0,'embed_size_w','','yes'),(95,0,'embed_size_h','600','yes'),(96,0,'wp_user_roles','a:5:{s:13:\"administrator\";a:2:{s:4:\"name\";s:13:\"Administrator\";s:12:\"capabilities\";a:54:{s:13:\"switch_themes\";b:1;s:11:\"edit_themes\";b:1;s:16:\"activate_plugins\";b:1;s:12:\"edit_plugins\";b:1;s:10:\"edit_users\";b:1;s:10:\"edit_files\";b:1;s:14:\"manage_options\";b:1;s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:6:\"import\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:10:\"edit_pages\";b:1;s:4:\"read\";b:1;s:8:\"level_10\";b:1;s:7:\"level_9\";b:1;s:7:\"level_8\";b:1;s:7:\"level_7\";b:1;s:7:\"level_6\";b:1;s:7:\"level_5\";b:1;s:7:\"level_4\";b:1;s:7:\"level_3\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:17:\"edit_others_pages\";b:1;s:20:\"edit_published_pages\";b:1;s:13:\"publish_pages\";b:1;s:12:\"delete_pages\";b:1;s:19:\"delete_others_pages\";b:1;s:22:\"delete_published_pages\";b:1;s:12:\"delete_posts\";b:1;s:19:\"delete_others_posts\";b:1;s:22:\"delete_published_posts\";b:1;s:20:\"delete_private_posts\";b:1;s:18:\"edit_private_posts\";b:1;s:18:\"read_private_posts\";b:1;s:20:\"delete_private_pages\";b:1;s:18:\"edit_private_pages\";b:1;s:18:\"read_private_pages\";b:1;s:12:\"delete_users\";b:1;s:12:\"create_users\";b:1;s:17:\"unfiltered_upload\";b:1;s:14:\"edit_dashboard\";b:1;s:14:\"update_plugins\";b:1;s:14:\"delete_plugins\";b:1;s:15:\"install_plugins\";b:1;s:13:\"update_themes\";b:1;s:14:\"install_themes\";b:1;}}s:6:\"editor\";a:2:{s:4:\"name\";s:6:\"Editor\";s:12:\"capabilities\";a:34:{s:17:\"moderate_comments\";b:1;s:17:\"manage_categories\";b:1;s:12:\"manage_links\";b:1;s:12:\"upload_files\";b:1;s:15:\"unfiltered_html\";b:1;s:10:\"edit_posts\";b:1;s:17:\"edit_others_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:10:\"edit_pages\";b:1;s:4:\"read\";b:1;s:7:\"level_7\";b:1;s:7:\"level_6\";b:1;s:7:\"level_5\";b:1;s:7:\"level_4\";b:1;s:7:\"level_3\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:17:\"edit_others_pages\";b:1;s:20:\"edit_published_pages\";b:1;s:13:\"publish_pages\";b:1;s:12:\"delete_pages\";b:1;s:19:\"delete_others_pages\";b:1;s:22:\"delete_published_pages\";b:1;s:12:\"delete_posts\";b:1;s:19:\"delete_others_posts\";b:1;s:22:\"delete_published_posts\";b:1;s:20:\"delete_private_posts\";b:1;s:18:\"edit_private_posts\";b:1;s:18:\"read_private_posts\";b:1;s:20:\"delete_private_pages\";b:1;s:18:\"edit_private_pages\";b:1;s:18:\"read_private_pages\";b:1;}}s:6:\"author\";a:2:{s:4:\"name\";s:6:\"Author\";s:12:\"capabilities\";a:10:{s:12:\"upload_files\";b:1;s:10:\"edit_posts\";b:1;s:20:\"edit_published_posts\";b:1;s:13:\"publish_posts\";b:1;s:4:\"read\";b:1;s:7:\"level_2\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:12:\"delete_posts\";b:1;s:22:\"delete_published_posts\";b:1;}}s:11:\"contributor\";a:2:{s:4:\"name\";s:11:\"Contributor\";s:12:\"capabilities\";a:5:{s:10:\"edit_posts\";b:1;s:4:\"read\";b:1;s:7:\"level_1\";b:1;s:7:\"level_0\";b:1;s:12:\"delete_posts\";b:1;}}s:10:\"subscriber\";a:2:{s:4:\"name\";s:10:\"Subscriber\";s:12:\"capabilities\";a:2:{s:4:\"read\";b:1;s:7:\"level_0\";b:1;}}}','yes'),(97,0,'cron','a:3:{i:1279200449;a:3:{s:16:\"wp_version_check\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:17:\"wp_update_plugins\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}s:16:\"wp_update_themes\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:10:\"twicedaily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:43200;}}}i:1279243652;a:1:{s:19:\"wp_scheduled_delete\";a:1:{s:32:\"40cd750bba9870f18aada2478b24840a\";a:3:{s:8:\"schedule\";s:5:\"daily\";s:4:\"args\";a:0:{}s:8:\"interval\";i:86400;}}}s:7:\"version\";i:2;}','yes'),(116,0,'nonce_salt','dObGEkaP!EbxXdrZaB#cUr!z6e@R2TTz@EOFuylzcBCkw68F!MxntgHVx6wvHLX','yes'),(117,0,'current_theme','WordPress Default','yes'),(118,0,'can_compress_scripts','1','yes'),(145,0,'disqus_forum_url','davidcramer','yes'),(146,0,'disqus_partner_key','','yes'),(147,0,'disqus_replace','all','yes'),(148,0,'disqus_api_key','QwQ2JLakdGd95BZ8w6ixbwHrggCQh0KMYEnBri8Z4MU9ERQyhh7M5MUG8hRj6FoI','yes'),(191,0,'disqus_user_api_key','','yes');
147	+ /!40000 ALTER TABLE `wp_options` ENABLE KEYS /;
148	+ UNLOCK TABLES;
149	+
150	+ --
151	+ -- Table structure for table `wp_postmeta`
152	+ --
153	+
154	+ DROP TABLE IF EXISTS `wp_postmeta`;
155	+ /!40101 SET @saved_cs_client = @@character_set_client /;
156	+ /!40101 SET character_set_client = utf8 /;
157	+ CREATE TABLE `wp_postmeta` (
158	+ `meta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
159	+ `post_id` bigint(20) unsigned NOT NULL DEFAULT '0',
160	+ `meta_key` varchar(255) DEFAULT NULL,
161	+ `meta_value` longtext,
162	+ PRIMARY KEY (`meta_id`),
163	+ KEY `post_id` (`post_id`),
164	+ KEY `meta_key` (`meta_key`)
165	+ ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
166	+ /!40101 SET character_set_client = @saved_cs_client /;
167	+
168	+ --
169	+ -- Dumping data for table `wp_postmeta`
170	+ --
171	+
172	+ LOCK TABLES `wp_postmeta` WRITE;
173	+ /!40000 ALTER TABLE `wp_postmeta` DISABLE KEYS /;
174	+ /!40000 ALTER TABLE `wp_postmeta` ENABLE KEYS /;
175	+ UNLOCK TABLES;
176	+
177	+ --
178	+ -- Table structure for table `wp_posts`
179	+ --
180	+
181	+ DROP TABLE IF EXISTS `wp_posts`;
182	+ /!40101 SET @saved_cs_client = @@character_set_client /;
183	+ /!40101 SET character_set_client = utf8 /;
184	+ CREATE TABLE `wp_posts` (
185	+ `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
186	+ `post_author` bigint(20) unsigned NOT NULL DEFAULT '0',
187	+ `post_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
188	+ `post_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
189	+ `post_content` longtext NOT NULL,
190	+ `post_title` text NOT NULL,
191	+ `post_excerpt` text NOT NULL,
192	+ `post_status` varchar(20) NOT NULL DEFAULT 'publish',
193	+ `comment_status` varchar(20) NOT NULL DEFAULT 'open',
194	+ `ping_status` varchar(20) NOT NULL DEFAULT 'open',
195	+ `post_password` varchar(20) NOT NULL DEFAULT '',
196	+ `post_name` varchar(200) NOT NULL DEFAULT '',
197	+ `to_ping` text NOT NULL,
198	+ `pinged` text NOT NULL,
199	+ `post_modified` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
200	+ `post_modified_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
201	+ `post_content_filtered` text NOT NULL,
202	+ `post_parent` bigint(20) unsigned NOT NULL DEFAULT '0',
203	+ `guid` varchar(255) NOT NULL DEFAULT '',
204	+ `menu_order` int(11) NOT NULL DEFAULT '0',
205	+ `post_type` varchar(20) NOT NULL DEFAULT 'post',
206	+ `post_mime_type` varchar(100) NOT NULL DEFAULT '',
207	+ `comment_count` bigint(20) NOT NULL DEFAULT '0',
208	+ PRIMARY KEY (`ID`),
209	+ KEY `post_name` (`post_name`),
210	+ KEY `type_status_date` (`post_type`,`post_status`,`post_date`,`ID`),
211	+ KEY `post_parent` (`post_parent`)
212	+ ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
213	+ /!40101 SET character_set_client = @saved_cs_client /;
214	+
215	+ --
216	+ -- Dumping data for table `wp_posts`
217	+ --
218	+
219	+ LOCK TABLES `wp_posts` WRITE;
220	+ /!40000 ALTER TABLE `wp_posts` DISABLE KEYS /;
221	+ INSERT INTO `wp_posts` VALUES (1,1,'2010-06-08 01:27:22','2010-06-08 01:27:22','Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!','Hello world!','','publish','open','open','','hello-world','','','2010-06-08 01:27:22','2010-06-08 01:27:22','',0,'http://localhost/~dcramer/wordpress-2.9/?p=1',0,'post','',3),(2,1,'2010-06-08 01:27:22','2010-06-08 01:27:22','This is an example of a WordPress page, you could edit this to put information about yourself or your site so readers know where you are coming from. You can create as many pages like this one or sub-pages as you like and manage all of your content inside of WordPress.','About','','publish','open','open','','about','','','2010-06-08 01:27:22','2010-06-08 01:27:22','',0,'http://localhost/~dcramer/wordpress-2.9/?page_id=2',0,'page','',0);
222	+ /!40000 ALTER TABLE `wp_posts` ENABLE KEYS /;
223	+ UNLOCK TABLES;
224	+
225	+ --
226	+ -- Table structure for table `wp_term_relationships`
227	+ --
228	+
229	+ DROP TABLE IF EXISTS `wp_term_relationships`;
230	+ /!40101 SET @saved_cs_client = @@character_set_client /;
231	+ /!40101 SET character_set_client = utf8 /;
232	+ CREATE TABLE `wp_term_relationships` (
233	+ `object_id` bigint(20) unsigned NOT NULL DEFAULT '0',
234	+ `term_taxonomy_id` bigint(20) unsigned NOT NULL DEFAULT '0',
235	+ `term_order` int(11) NOT NULL DEFAULT '0',
236	+ PRIMARY KEY (`object_id`,`term_taxonomy_id`),
237	+ KEY `term_taxonomy_id` (`term_taxonomy_id`)
238	+ ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
239	+ /!40101 SET character_set_client = @saved_cs_client /;
240	+
241	+ --
242	+ -- Dumping data for table `wp_term_relationships`
243	+ --
244	+
245	+ LOCK TABLES `wp_term_relationships` WRITE;
246	+ /!40000 ALTER TABLE `wp_term_relationships` DISABLE KEYS /;
247	+ INSERT INTO `wp_term_relationships` VALUES (1,2,0),(2,2,0),(3,2,0),(4,2,0),(5,2,0),(6,2,0),(7,2,0),(1,1,0);
248	+ /!40000 ALTER TABLE `wp_term_relationships` ENABLE KEYS /;
249	+ UNLOCK TABLES;
250	+
251	+ --
252	+ -- Table structure for table `wp_term_taxonomy`
253	+ --
254	+
255	+ DROP TABLE IF EXISTS `wp_term_taxonomy`;
256	+ /!40101 SET @saved_cs_client = @@character_set_client /;
257	+ /!40101 SET character_set_client = utf8 /;
258	+ CREATE TABLE `wp_term_taxonomy` (
259	+ `term_taxonomy_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
260	+ `term_id` bigint(20) unsigned NOT NULL DEFAULT '0',
261	+ `taxonomy` varchar(32) NOT NULL DEFAULT '',
262	+ `description` longtext NOT NULL,
263	+ `parent` bigint(20) unsigned NOT NULL DEFAULT '0',
264	+ `count` bigint(20) NOT NULL DEFAULT '0',
265	+ PRIMARY KEY (`term_taxonomy_id`),
266	+ UNIQUE KEY `term_id_taxonomy` (`term_id`,`taxonomy`),
267	+ KEY `taxonomy` (`taxonomy`)
268	+ ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
269	+ /!40101 SET character_set_client = @saved_cs_client /;
270	+
271	+ --
272	+ -- Dumping data for table `wp_term_taxonomy`
273	+ --
274	+
275	+ LOCK TABLES `wp_term_taxonomy` WRITE;
276	+ /!40000 ALTER TABLE `wp_term_taxonomy` DISABLE KEYS /;
277	+ INSERT INTO `wp_term_taxonomy` VALUES (1,1,'category','',0,1),(2,2,'link_category','',0,7);
278	+ /!40000 ALTER TABLE `wp_term_taxonomy` ENABLE KEYS /;
279	+ UNLOCK TABLES;
280	+
281	+ --
282	+ -- Table structure for table `wp_terms`
283	+ --
284	+
285	+ DROP TABLE IF EXISTS `wp_terms`;
286	+ /!40101 SET @saved_cs_client = @@character_set_client /;
287	+ /!40101 SET character_set_client = utf8 /;
288	+ CREATE TABLE `wp_terms` (
289	+ `term_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
290	+ `name` varchar(200) NOT NULL DEFAULT '',
291	+ `slug` varchar(200) NOT NULL DEFAULT '',
292	+ `term_group` bigint(10) NOT NULL DEFAULT '0',
293	+ PRIMARY KEY (`term_id`),
294	+ UNIQUE KEY `slug` (`slug`),
295	+ KEY `name` (`name`)
296	+ ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
297	+ /!40101 SET character_set_client = @saved_cs_client /;
298	+
299	+ --
300	+ -- Dumping data for table `wp_terms`
301	+ --
302	+
303	+ LOCK TABLES `wp_terms` WRITE;
304	+ /!40000 ALTER TABLE `wp_terms` DISABLE KEYS /;
305	+ INSERT INTO `wp_terms` VALUES (1,'Uncategorized','uncategorized',0),(2,'Blogroll','blogroll',0);
306	+ /!40000 ALTER TABLE `wp_terms` ENABLE KEYS /;
307	+ UNLOCK TABLES;
308	+
309	+ --
310	+ -- Table structure for table `wp_usermeta`
311	+ --
312	+
313	+ DROP TABLE IF EXISTS `wp_usermeta`;
314	+ /!40101 SET @saved_cs_client = @@character_set_client /;
315	+ /!40101 SET character_set_client = utf8 /;
316	+ CREATE TABLE `wp_usermeta` (
317	+ `umeta_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
318	+ `user_id` bigint(20) unsigned NOT NULL DEFAULT '0',
319	+ `meta_key` varchar(255) DEFAULT NULL,
320	+ `meta_value` longtext,
321	+ PRIMARY KEY (`umeta_id`),
322	+ KEY `user_id` (`user_id`),
323	+ KEY `meta_key` (`meta_key`)
324	+ ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
325	+ /!40101 SET character_set_client = @saved_cs_client /;
326	+
327	+ --
328	+ -- Dumping data for table `wp_usermeta`
329	+ --
330	+
331	+ LOCK TABLES `wp_usermeta` WRITE;
332	+ /!40000 ALTER TABLE `wp_usermeta` DISABLE KEYS /;
333	+ INSERT INTO `wp_usermeta` VALUES (1,1,'nickname','admin'),(2,1,'rich_editing','true'),(3,1,'comment_shortcuts','false'),(4,1,'admin_color','fresh'),(5,1,'wp_capabilities','a:1:{s:13:\"administrator\";b:1;}'),(7,1,'wp_user_level','10');
334	+ /!40000 ALTER TABLE `wp_usermeta` ENABLE KEYS /;
335	+ UNLOCK TABLES;
336	+
337	+ --
338	+ -- Table structure for table `wp_users`
339	+ --
340	+
341	+ DROP TABLE IF EXISTS `wp_users`;
342	+ /!40101 SET @saved_cs_client = @@character_set_client /;
343	+ /!40101 SET character_set_client = utf8 /;
344	+ CREATE TABLE `wp_users` (
345	+ `ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
346	+ `user_login` varchar(60) NOT NULL DEFAULT '',
347	+ `user_pass` varchar(64) NOT NULL DEFAULT '',
348	+ `user_nicename` varchar(50) NOT NULL DEFAULT '',
349	+ `user_email` varchar(100) NOT NULL DEFAULT '',
350	+ `user_url` varchar(100) NOT NULL DEFAULT '',
351	+ `user_registered` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
352	+ `user_activation_key` varchar(60) NOT NULL DEFAULT '',
353	+ `user_status` int(11) NOT NULL DEFAULT '0',
354	+ `display_name` varchar(250) NOT NULL DEFAULT '',
355	+ PRIMARY KEY (`ID`),
356	+ KEY `user_login_key` (`user_login`),
357	+ KEY `user_nicename` (`user_nicename`)
358	+ ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
359	+ /!40101 SET character_set_client = @saved_cs_client /;
360	+
361	+ --
362	+ -- Dumping data for table `wp_users`
363	+ --
364	+
365	+ LOCK TABLES `wp_users` WRITE;
366	+ /!40000 ALTER TABLE `wp_users` DISABLE KEYS /;
367	+ INSERT INTO `wp_users` VALUES (1,'admin','$P$BPK0.c48l9CzwhitsInt6VZcoLRKL6/','admin','dcramer@gmail.com','','2010-06-08 01:27:22','',0,'admin');
368	+ /!40000 ALTER TABLE `wp_users` ENABLE KEYS /;
369	+ UNLOCK TABLES;
370	+ /!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
371	+
372	+ /!40101 SET SQL_MODE=@OLD_SQL_MODE /;
373	+ /!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
374	+ /!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
375	+ /!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
376	+ /!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
377	+ /!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
378	+ /!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
379	+
380	+ -- Dump completed on 2011-02-01 13:39:37

tests/tests.php ADDED Viewed

	@@ -0,0 +1,128 @@


1	+ <?php
2	+
3	+ require_once(dirname(__FILE__) . '/../lib/wp-cli.php');
4	+ require_once(dirname(__FILE__) . '/../disqus.php');
5	+
6	+ require_once('PHPUnit/Autoload.php');
7	+
8	+ if (!defined('DISQUS_TEST_DATABASE')) {
9	+ define('DISQUS_TEST_DATABASE', sprintf('%s_test', DB_NAME));
10	+ }
11	+ class DisqusPluginTest extends PHPUnit_Framework_TestCase {
12	+ /**
13	+ * Sets up our database and fixtures.
14	+ */
15	+ protected function setUp() {
16	+ global $wpdb;
17	+
18	+ // If only we could use transactions for our fixture :(
19	+ shell_exec(sprintf('mysql -u%s -p%s -D%s -h%s < initial.sql', DB_USER, DB_PASSWORD, DISQUS_TEST_DATABASE, DB_HOST));
20	+
21	+ $res = $wpdb->get_results('show tables');
22	+ assert(count($res) == 11);
23	+ }
24	+
25	+ protected function query($query) {
26	+ global $wpdb;
27	+
28	+ $result = $wpdb->query($query);
29	+ if ($result === false) {
30	+ throw new Exception(sprintf('Database error: %s', $wpdb->last_error));
31	+ }
32	+ }
33	+
34	+ public function test_pending_posts_api() {
35	+ dsq_add_pending_post_id(1);
36	+ $this->assertEquals(dsq_get_pending_post_ids(), array(1));
37	+
38	+ dsq_clear_pending_post_ids(array(1));
39	+ $this->assertEquals(dsq_get_pending_post_ids(), array());
40	+ }
41	+
42	+ // /**
43	+ // * Tests the dsq_sync_post function.
44	+ // */
45	+ // public function testSyncPost() {
46	+ // global $wpdb;
47	+ //
48	+ // $post_id = $wpdb->get_var($wpdb->prepare('SELECT max(comment_date) FROM ' . $wpdb->comments . ' WHERE comment_post_ID = %d AND comment_agent LIKE \'Disqus/%%\'', $post->ID));
49	+ //
50	+ //
51	+ // dsq_sync_post();
52	+ // }
53	+ //
54	+ // /**
55	+ // * Tests the dsq_sync_comments function.
56	+ // */
57	+ // public function testSyncComments() {
58	+ // global $wpdb;
59	+ //
60	+ // $post_id = $wpdb->get_var($wpdb->prepare('SELECT max(comment_date) FROM ' . $wpdb->comments . ' WHERE comment_post_ID = %d AND comment_agent LIKE \'Disqus/%%\'', $post->ID));
61	+ //
62	+ // dsq_sync_comments($comments);
63	+ // }
64	+ }
65	+
66	+ function main() {
67	+ function cleanup() {
68	+ global $wpdb;
69	+
70	+ // we need to ensure that we switch off this database
71	+ $wpdb->select(null);
72	+
73	+ // drop our test database
74	+ // XXX: why cant we use $wpdb->query ?
75	+ mysql_query(sprintf('DROP DATABASE `%s`', DISQUS_TEST_DATABASE)) or die(mysql_error());
76	+ }
77	+
78	+ global $wpdb;
79	+ // $this->query(sprintf('DROP DATABASE IF EXISTS `%s`', DISQUS_TEST_DATABASE));
80	+ // check existance of test db
81	+ $exists = $wpdb->get_var($wpdb->prepare('SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = \'%s\'', DISQUS_TEST_DATABASE));
82	+
83	+ if (!empty($exists)) {
84	+ printf("Test database '%s' already exists. Continuing will drop this database and all data!\nContinue? [y/n]\n", $exists);
85	+ $handle = fopen ("php://stdin","r");
86	+ $line = strtolower(trim(fgets($handle)));
87	+ if($line != 'yes' && $line != 'y'){
88	+ echo "ABORTING!\n";
89	+ exit;
90	+ }
91	+ }
92	+ // setup database
93	+ $wpdb->query(sprintf('CREATE DATABASE `%s`', DISQUS_TEST_DATABASE));
94	+ $wpdb->select(DISQUS_TEST_DATABASE);
95	+
96	+ // $fp = fopen('initial.sql', 'r');
97	+ // $buffer = '';
98	+ // while (($line = fgets($fp)) !== false) {
99	+ // $buffer .= trim($line);
100	+ // if (strpos($line, ';')) {
101	+ // if (!empty($buffer)) {
102	+ // $this->query($buffer);
103	+ // }
104	+ // $buffer = '';
105	+ // }
106	+ // }
107	+ //
108	+
109	+ try {
110	+ $suite = new PHPUnit_Framework_TestSuite('DisqusPluginTest');
111	+ $result = $suite->run();
112	+
113	+ require_once('PHPUnit/TextUI/ResultPrinter.php');
114	+
115	+ $printer = new PHPUnit_TextUI_ResultPrinter();
116	+ $printer->printResult($result);
117	+
118	+ cleanup();
119	+ } catch (Exception $ex) {
120	+ cleanup();
121	+
122	+ throw $ex;
123	+ }
124	+ }
125	+
126	+ main();
127	+
128	+ ?>