I'm just finishing something of a large migration from an old Xoops site to Drupal. I've not had to get too down and dirty with the Xoops database, for which I'm quite happy as it wasn't so coherent after lots of upgrades and customisations.
The Knight Drupal Initiative is an ongoing grant program for Drupal development. To make the program successful, community review of proposals is essential.
One of the issues with user generated content multi-lingual sites is that content will often be in only one language, or maybe translated into a few others.
At last I overcame my fear of Views 2.0 and have added it to my D6 effort for Quick Tabs. (Previously my D6 version only allowed you to add blocks to your tabs.) My colleague, Hubert a.k.a.