Import from Reviews Module Reply to topic

Please enter your server specs in your user profile! 😢

I'd have to review the tables but it is possible.

I can look at 'averaging' - will depend on how many db queries it adds to the system - it will probably be an extra field since the ratings are in different tables, and to preserve the original reviewer's rating.

btw, not an overnight exercise - need to find some time for it

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Please enter your server specs in your user profile! 😢

How many reviews in your database?
MReviews uses categories and sub-categories, so these would have to be manually entered in the reviews and comments tables

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Please enter your server specs in your user profile! 😢

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Please enter your server specs in your user profile! 😢

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):

Please enter your server specs in your user profile! 😢

This is really basic, but it worked fine on a very small test database.
It doesn't affect your reviews database, but backup those tables anyway.
Copy the code below and create a file with some obscure name and place it in your root directory, then run it.
Please feedback results here.<?php ########################################################################## # File to convert an existing Reviews database to a NEW MReviews database # It is extremely basic. # Install the latest MReviews module, as new. # BACKUP your Reviews databases BEFORE doing anything else!!! # Give this file some obscure name and run it in your root directory. # Run this file ONCE - should be fine for small databases, say 500 or so. # DELETE this file when it's finished. # Check your MReviews database for the data. # Adjust Category and Sub-Category title through admin interface. # Delete any superfluous example categories etc. # Happy MReviewing ########################################################################## include("includes/cmsinit.inc"); global $db, $prefix, $user_prefix; $result = $db->sql_query('SELECT * FROM '.$prefix.'_reviews', true); if ($db->sql_numrows($result) > 0) { while ($row = $db->sql_fetchrow($result)) { $db->sql_query("INSERT INTO ".$prefix."_MReviews SET rid='$row[id]', cid='1', scid='1', date='$row[date]', author='".Fix_Quotes($row['reviewer'])."', author_email='".Fix_Quotes($row['email'])."', author_user='0', author_ip='0', pagename='".Fix_Quotes($row['title'])."', content='".Fix_Quotes($row['text'])."', cover='".Fix_Quotes($row['cover'])."', r_link='".Fix_Quotes($row['url'])."', r_link_title='".Fix_Quotes($row['url_title'])."', score='$row[score]', counter='$row[hits]'"); } } $db->sql_freeresult($result); $result2 = $db->sql_query("SELECT u.username, m.author FROM ".$user_prefix."_users AS u INNER JOIN ".$prefix."_MReviews AS m ON ( u.username = m.author)"); while (list($uname) = $db->sql_fetchrow($result2, SQL_NUM)) { $db->sql_query("UPDATE ".$prefix."_MReviews SET author_user='1' WHERE author='".$uname."'"); } $db->sql_freeresult($result2); $result3 = $db->sql_query('SELECT * FROM '.$prefix.'_reviews_comments', true); if ($db->sql_numrows($result3) > 0) { while ($row3 = $db->sql_fetchrow($result3)) { $db->sql_query("INSERT INTO ".$prefix."_MReviews_comments SET rid='$row3[rid]', userid='".Fix_Quotes($row3['userid'])."', userip='0', com_id='$row3[cid]', date='$row3[date]', comments='".Fix_Quotes($row3['comments'])."', score='$row3[score]'"); } } $db->sql_freeresult($result3); echo "Finished converting Reviews to MReviews - please delete this file"; ?>

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):