[bira]

ok, if you installed this hack on 2.2.1 there's a small change.

If you haven't installed this hack, or installed it on 2.0.3, ignore this post.

In root/register.php

find this:

// Contract Old Posts in Thread (v1.0)
    $DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash[high],avatarid[/high],hideposts) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes([high](md5[/high]$password)[high])[/high]."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm','$options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash'[high],'$avatarid'[/high],'$hideposts')");
// Contract Old Posts in Thread (v1.0)

And add to it the code highlighted in the above line.

Sorry about this - I initially tested this on 2.0.3, and having tested it now on 2.2.1 as well - I noticed the ',avatarid' md5()and ".'$avatarid'" are missing from this query