[j_86]

Thanks again Cap'n Steve.

I have a few more modifications i'd like to make (and release them as addons later, or maybe even give them back to you to release a Version3? ).

I want to be able to send a PM to people who submitted a quote on approval/rejection.

I have this PM code;

PHP Code:

function SendPM($message,$title,$to,$from)
{
    global $DB_site;
    
    // Permssions Crap XD your getting a damn PM!! XD
    // Parse It Out
    $title = addslashes(htmlspecialchars_uni(fetch_censored_text($title)));
    $message = addslashes(fetch_censored_text($message));
    $to=$DB_site->query_first("select * from ".TABLE_PREFIX."user where userid='{$to}'");  // Grab Member Its Going TO
    $from=$DB_site->query_first("select * from ".TABLE_PREFIX."user where userid='{$from}'"); // Grab Member Its Coming FROM
    
    // Insert The Message
    $to_string["$to[userid]"] = $to['username'];
    $now=time();
    $DB_site->query("insert into ".TABLE_PREFIX."pmtext (fromuserid,fromusername,title,message,touserarray,iconid,dateline,showsignature  ,allowsmilie) values ('{$from['userid']}','".addslashes($from['username'])."','{$title}','{$message}','".addslashes(serialize($to_string))."','4','{$now}','1','1')");
    // id thingy
    $DB_site->query("insert into ".TABLE_PREFIX."pm (pmtextid, userid) values (".$DB_site->insert_id().", '{$to['userid']}')");
    
    if ($to['pmpopup'])
    {
        $DB_site->shutdown_query("UPDATE " . TABLE_PREFIX . "user SET pmtotal=pmtotal+1, pmunread=pmunread+1, pmpopup=2 WHERE userid='{$to['userid']}'");
    }
    else
    {
        $DB_site->shutdown_query("update ".TABLE_PREFIX."user set pmtotal=pmtotal+'1',pmunread=pmunread+'1' WHERE userid='{$to['userid']}'");
    }

    
    // Update pm count
    
} 


But I need to know where to put this code, and I also need to know in what variable the USERID is stored, when approving quotes.

I'm looking at inserting the PM code here -

Find:

PHP Code:

            $DB_site->query('
                UPDATE ' . TABLE_PREFIX . 'quotes SET
                approved = 1,
                quote = "' . $quote[$quoteid] . '",
                author = "' . $author[$quoteid] . '"
                ' . $contextval . '
                    WHERE quoteid = ' . intval($quoteid)
            ); 


Add under; (pm code above).

Thank you;

Jamie