[Arto]

I recently converted a phpBB forum to vBulletin and at the same time migrated members' medals from phpBB's Medal System Mod v2.1.0 by ycl6 to YAAS v2.0.5. As the SQL table schemas for both award mods are very similar, this was fairly painless and can be accomplished through executing a few simple SQL statements. What follows is a quick how-to which hopefully will be useful for others looking to avoid manually importing the medals

First off, it is presupposed that you've imported your phpBB forum's data to vB using Jelsoft's ImpEx, that the import session is still active (that is, the importuserid field needs to exist in vB's user table) and that you've installed YAAS. Additionally, the queries are written for a situation where phpBB and vB share the same database, phpBB with the table prefix phpbb_ and vB without a table prefix; adjust to your specific setup where necessary.

The SQL queries can be executed from vB's admin panel (if you have the permissions), phpMyAdmin or the MySQL command-line client. (Needless to say, if you don't know understand what the SQL statements do, or are unable to adapt them to your specific situation, don't execute them!)

To begin, the following SQL statement will convert all medals from phpBB to YAAS, preserving the same row identifiers (which means you may get clashes unless you first delete the included example award in YAAS):

INSERT INTO award SELECT medal_id AS award_id, -1 AS award_cat_id, medal_name AS award_name, medal_description AS award_desc, medal_image AS award_icon_url, medal_image AS award_img_url, 1 AS award_icon_url FROM phpbb_medal;

Note that the awards are imported as un-categorized; you will need to manually assign them to an award category in YAAS's admin panel before they'll show up in vB's front end.

Next, you need to copy all the medal/award images from phpBB's medals/ directory to the images/medals/ directory under your vB installation. The image paths also need to be corrected in the database, which can be done with the following two SQL statements (replace the URL http://www.yourforumsite.com/forum/ with your vB forum's base URL):

UPDATE award SET award_icon_url = CONCAT('http://www.yourforumsite.com/forum/images/', award_icon_url);
UPDATE award SET award_img_url = CONCAT('http://www.yourforumsite.com/forum/images/', award_img_url);

Finally, the following SQL statement will import all issued awards to YAAS, mapping from the phpBB user to the correct vB member through the aforementioned importuserid field:

INSERT INTO award_user SELECT m.issue_id, m.medal_id AS award_id, u.userid AS userid, m.issue_reason, m.issue_time FROM phpbb_medal_user m LEFT JOIN user u ON m.user_id = u.importuserid;

That's all, folks Though I migrated from the Medal System Mod v2.1.0, the instructions will likely work for newer versions as well (and could be enhanced to import award categories as well, which were introduced in the Medal System Mod v2.2.0).