MySQLicious-based del.icio.us Sidebar Item

Walter Cruz told me about MySQLicious, which mirrors your del.icio.us bookmarks in a MySQL database. I think it works much better than my previous del.icio.us sidebar solution, which used Magpie to snarf the del.icio.us RSS feed and built the sidebar item from the RSS feed.

Here's the setup as I'm using it:

1. Setup MySQLicious according to its instructions, but ensure that you use the same database that you use for your b2e installation.
2. Copy _mysqlicious.php to your preferred location (I put it in the same directory as my theme files).
3. Modify your _main.php file to call _mysqlicious.php as a sidebar item. Two variables ($deliciousUsername and $MySQLicious_Table) must be set. In addition, you may set a third variable, $MySQLicious_items, which determines how many bookmarks will be displayed.

Note: Ensure that your MySQLicious setup complies with the del.icio.us rules of usage so you don't get banned.

Here's the b2evolution forum thread.