[pet0etie]

last night i had the forum crashing after installing this plugin (so nobody could consult the main forum page)

on our forum we have a user called "/!\K.v.K./!\Boechie/!\" who has posted in a thread ... being the last one to post, his name, avatar and posting time is (should be) displayed on the index-page

but ... when i check your code u are using this query :

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `" . TABLE_PREFIX . "user` WHERE username = \"".$lastpostinfo[lastposter]."\"";

putting in the name of "/!\K.v.K./!\Boechie/!\" into that query i get :

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `user` WHERE username = \"/!\K.v.K./!\Boechie/!\\"";

your query is getting 'screwed up' because he sees the last \ of the name "/!\K.v.K./!\Boechie/!\" as an escape-character

shouldn't the query be changed towards this query ?

$q_text = "SELECT userid, avatarid, avatarrevision  FROM `" . TABLE_PREFIX . "user` WHERE username = \"". $vbulletin->db->escape_string($lastpostinfo[lastposter]) ."\"";

thanks for looking up / solving the problem

pet0etie