Extension:WordpressTeaser
This extension stores its source code on a wiki page. Please be aware that this code may be unreviewed or maliciously altered. They may contain security holes, outdated interfaces that are no longer compatible etc. Note: No localisation updates are provided for this extension by translatewiki.net. |
This extension is incompatible with MediaWiki 1.39 or any later release! You are advised against using this extension on a live site.
|
This extension is currently not actively maintained! Although it may still work, any bug reports or feature requests will more than likely be ignored. |
 Release status: unmaintained |
|
|---|---|
| Implementation | Tag |
| Description | This extension allows you to insert teaser (first paragraphs) from your Wordpress blog into a MediaWiki page. |
| Author(s) | Claus van Beek (ClausVB~mediawikiwikitalk) |
| Latest version | 0.9 (2009-11-20) |
| MediaWiki | |
| License | GPL (latest version) |
| Download | #Code |
Detailed description edit
This extension allows you to insert teaser (first paragraphs) from your Wordpress blog into a MediaWiki page. PHP5 and "mysqli" (see MySQL improved extension) are required. Work in progress ...
Installation edit
Afterwards continue with your MySQL settings.
MySQL and other settings edit
Your Wordpress installation should contain a file like
wp-config.php
with all your MySQL settings. Please copy your values to "wordpress.php".
// MySQL settings
define('WORDPRESS_HOST', 'localhost');
define('WORDPRESS_USER', 'mysql_user');
define('WORDPRESS_PASSWORD', 'mysql_password');
define('WORDPRESS_DATABASE', 'wordpress_mysql_database');
define('WORDPRESS_PREFIX', 'wordpress_');
Get help edit
First of all you can use
<wordpress>help</wordpress>
to get help. This will display all albums and all pictures, which are stored in your Wordpress database.
If you have further questions, please post them here (discussion).
Usage edit
To get help and general informations about your wordpress, please use
<wordpress>help</wordpress>
Work in progress ...
Code edit
I tried to comment my code. If you have any questions or need more comments on a special line, please let me know.
<?php
// MySQL settings
define('WORDPRESS_HOST', 'localhost');
define('WORDPRESS_USER', 'mysql_user');
define('WORDPRESS_PASSWORD', 'mysql_password');
define('WORDPRESS_DATABASE', 'wordpress_mysql_database');
define('WORDPRESS_PREFIX', 'wordpress_');
// Other settings
define('WORDPRESS_URI', 'http://your-domain.tld/wordpress/'); // trailing "/" is IMPORTANT
define('STRFTIME_LC_ALL', 'german');
define('STRFTIME_SETTINGS', '%A, %d. %B %Y (%H:%M:%S)'); // '%A, %B %d, %Y (%H:%M:%S)'
$wgExtensionFunctions[] = 'wordpress';
function wordpress()
{
global $wgParser;
$wgParser->setHook('wordpress', 'process_wordpress');
}
function process_wordpress($input, $args, $parser)
{
$db = new mysqli(WORDPRESS_HOST, WORDPRESS_USER, WORDPRESS_PASSWORD, WORDPRESS_DATABASE);
// If MySQL cannot be connected, do nothing and exit function
if (mysqli_connect_errno())
{
return '<h2>MySQL settings are wrong</h2> <p><strong>Error: "' . mysqli_connect_error() . '"</strong>. Please open</p> <pre>' . __FILE__ . '</pre> <p>and check WORDPRESS_HOST, WORDPRESS_USER, WORDPRESS_PASSWORD, WORDPRESS_DATABASE and WORDPRESS_PREFIX, please.</p>';
}
// SET all encodings from an to RDBMS to UTF-8
$db->query('SET character_set_results = utf8');
$db->query('SET character_set_client = utf8');
setlocale(LC_ALL, STRFTIME_LC_ALL);
/**
* help, e.g. <wordpress>help</wordpress>
**/
if ($input == 'help')
{
// Select basic stats
$select_stats = 'SELECT COUNT(*) AS how_many_posts, SUM(comment_count) AS sum_of_all_comments FROM ' . WORDPRESS_PREFIX . 'posts WHERE post_status = "publish"';
$result_stats = $db->query($select_stats)
or die('ERROR MySQL: ' . $db->error . '<pre>' . $select_stats . '</pre>');
$row_stats = $result_stats->fetch_assoc();
// Select date of last post and last comment
$select_last_date = 'SELECT MAX(post_date) AS last_post_date, MAX(comment_date) AS last_comment_date FROM ' . WORDPRESS_PREFIX . 'posts, ' . WORDPRESS_PREFIX . 'comments WHERE post_status = "publish" AND comment_approved = 1';
$result_last_date = $db->query($select_last_date)
or die('ERROR MySQL: ' . $db->error . '<pre>' . $select_last_date . '</pre>');
$row_last_date = $result_last_date->fetch_assoc();
// Select wordpress settings
$select_settings = 'SELECT option_value FROM ' . WORDPRESS_PREFIX . 'options
WHERE option_name = "home" OR option_name = "permalink_structure"';
$result_settings = $db->query($select_settings)
or die('ERROR MySQL: ' . $db->error . '<pre>' . $select_settings . '</pre>');
$row_settings = $result_settings->fetch_assoc();
$wordpress_home = $row_settings['option_value'] . '/';
$row_settings = $result_settings->fetch_assoc();
$wordpress_permalink_structure = $row_settings['option_value'];
// Introduction and help text
$output = '<h2><wordpress>help</wordpress></h2> <p>This help will try to teach a few basics about this extension. WordPress stores data in a MySQL database. To access this data you will have to provide a few things like user and password. Take a look at</p> <pre>' . __FILE__ . '</pre> <p>and change it to your needs.</p> <h2>Your WordPress statistics and settings</h2>';
$output .= '<ul>' . "\n";
$output .= ' <li><strong>Sum of all posts</strong>: ' . $row_stats['how_many_posts'] . '</li>' . "\n";
$output .= ' <li><strong>Sum of all comments</strong>: ' . $row_stats['sum_of_all_comments'] . '</li>' . "\n";
$output .= ' <li><strong>Last post</strong>: '
. strftime(STRFTIME_SETTINGS, strtotime($row_last_date['last_post_date']))
. '</li>' . "\n";
$output .= ' <li><strong>Last comment</strong>: '
. strftime(STRFTIME_SETTINGS, strtotime($row_last_date['last_comment_date']))
. '</li>' . "\n";
$output .= ' <li><strong>Settings "home"</strong>: ' . $wordpress_home . '</li>' . "\n";
$output .= ' <li><strong>Settings "permalink_structure"</strong>: ' . $wordpress_permalink_structure . '</li>' . "\n";
$output .= '</ul>' . "\n";
if (WORDPRESS_URI == $wordpress_home)
{
$check_uri_text = 'Constat "WORDPRESS_URI" is equal to "$wordpress_home"';
$color = 'green';
}
else
{
$check_uri_text = 'Constat "WORDPRESS_URI" is NOT equal to "$wordpress_home"';
$color = 'red';
}
$output .= '<p style="color: ' . $color . '">' . $check_uri_text . '</p>' . "\n";
return $output;
}
else
{
// Select date of last post and last comment
$select_posts = 'SELECT post_name, post_title, LEFT(post_content, 500) AS content, post_date, comment_count
FROM ' . WORDPRESS_PREFIX . 'posts WHERE post_status = "publish" and ID != 2
ORDER BY post_date DESC';
$result_posts = $db->query($select_posts)
or die('ERROR MySQL: ' . $db->error . '<pre>' . $select_posts . '</pre>');
while ($row_posts = $result_posts->fetch_assoc())
{
$comments = ($row_posts['comment_count'] == 0)
? 'Kommentare: 0'
: '<a href="' . WORDPRESS_URI . $row_posts['post_name'] . '.htm#comments" target="_blank">Kommentare: ' . $row_posts['comment_count'] . '</a>';
$date_and_time = strftime(STRFTIME_SETTINGS, strtotime($row_posts['post_date']));
$output .= '<fieldset>' . "\n";
$output .= '<legend>' . $row_posts['post_title'] . '</legend>' . "\n";
$output .= $row_posts['content'] . "\n";
$output .= '<p style="font-size: 90%;">erstellt am ' . $date_and_time . ' · <a href="' . WORDPRESS_URI . $row_posts['post_name'] . '.htm" target="_blank">Zum Blog</a> · ' . $comments . '</p>' . "\n";
$output .= '</fieldset>' . "\n";
}
return $output;
}
$db->close();
}
?>
Screenshots edit
Work in progress ...