creating a REPORT system

[MyPornLife.info]

hey im trying to create a REPORT system for my article mod.

i used these codes in article_report.php file to do that:

PHP Code:

$forumid= ''; //this tis the forum id where report is generated as a thread.

$ID = $vbulletin->input->clean_gpc('r', 'id', TYPE_UINT);


$userid = $vbulletin->userinfo['userid'];
$username = $vbulletin->userinfo['username'];



$ip = ''; // I need this code...how to get current user's ip



$reason = $vbulletin->input->clean_gpc('r', 'reason', TYPE_NOHTML);

$reason_bb = '[url='.$vbulletin->options[bburl].'/member.php?u='.$userid.']'.$username.'[/url] has reported a article.'.'\n\n'.'Reason:[quote]'.$reason.'[/quote]'.'\n\n'.'article: [url='.$vbulletin->options[bburl].'/article.php?id='.$ID.']'.$title.'[/url]';

$reason_html = '<a href="'.$vbulletin->options[bburl].'/member.php?u='.$userid.'" target="_blank">'.$username.'</a> has reported an article.<br /><br />Reason:<div style="margin:20px; margin-top:5px; "><div class="smallfont" style="margin-bottom:2px">Quote:</div><table cellpadding="6" cellspacing="0" border="0" width="100%"><tr><td class="alt2" style="border:1px inset">'.$reason.'</td></tr></table><br /><br />article: <a href="'.$vbulletin->options[bburl].'/article.php?id='.$ID.'">'.$title.'</a>';



$db->query_write("INSERT INTO " . TABLE_PREFIX . "post (`username`, `userid`, `title`, `dateline`, `pagetext`, `allowsmilie`, `ipaddress`, `visible`) VALUES ('".$username."', '".$userid."', 'Reported article', '". TIMENOW ."', '".$reason_bb."', '1', '".$ip."', '1')");

$postid = $vbulletin->GPC['postid'] = $db->insert_id();

$db->query_write("INSERT INTO " . TABLE_PREFIX . "postparsed (`postid`, `dateline`, `styleid`, `languageid`, `pagetext_html`) VALUES ('".$postid."', '". TIMENOW ."', '1', '1', '".$reason_html."')");



$db->query_write("INSERT INTO " . TABLE_PREFIX . "thread (`title`, `firstpostid`, `lastpostid`, `lastpost`, `forumid`, `open`, `postusername`, `postuserid`, `lastposter`, `dateline`, `visible`) VALUES ('Reported article', '".$postid."', '".$postid."', '". TIMENOW ."', '".$forumid."', '1', '".$username."', '".$userid."', '".$username."', '". TIMENOW ."', '1')");

$threadid = $vbulletin->GPC['threadid'] = $db->insert_id();

$db->query_write("UPDATE " . TABLE_PREFIX . "post SET threadid='".$threadid."' WHERE postid=".$postid); 


now three questions:

1. this is really full of mess. is there any clean & easiest way to create such thing? (maybe using vbulletin's existed function & class...as i dont hav much idea on abt them)
2. at $ip variable....i dunno how to get current user's ip address using vbulletin class
3. in this way...it can generate a report thread in desired forum/section. but in index page its not showing as last post.


help me plz

--------------- Added [DATE]1257114305[/DATE] at [TIME]1257114305[/TIME] ---------------

anyone??