profile plugin

[ZiNgA BuRgA]

You'll have to review your logic on this one.
Imagine explaining every line of code.
For example, explain to me what this query does:

PHP Code:

$query = $db->query("select * FROM ".TABLE_PREFIX."userfields WHERE name='msn'");

---

Also tell me what results it returns.

I'm not going to write the whole plugin for you - it will teach you nothing, in the end.