Here is the code~
Code: Select all
$message = "
[url=\"modules.php?name=join_clan&op=accept&pid=$player_id&cid=$clan_id\"]<< ACCEPT >>[/url]
[url=\"modules.php?name=join_clan&op=reject&pid=$player_id&cid=$clan_id\"]<< REJECT >>[/url] ";
// Begin sending the PM.
$pm_subject = "Clan Invite from $clan_tag";
$privmsgs_date = time();
$recieving_user_profile = sql_query("SELECT user_id, username FROM ".$prefix."_users WHERE user_id = $recieving_user");
list($user_id, $username) = sql_fetch_row($recieving_user_profile);
$message = "$message";
$subject = "Clan Invite from $clan_tag";
if(empty($message) || empty($subject)) {
return;
}
$bbcode_uid = make_bbcode_uid();
$privmsg_message = prepare_message($message, 1, 1, 1, $bbcode_uid);
$sql = "INSERT INTO nuke_bbprivmsgs (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date ) VALUES ('1', '".$subject."', '$sending_user', '$recieving_user', ".$privmsgs_date.")";
if ( !$db->sql_query($sql, BEGIN_TRANSACTION) )
{
echo "Could not insert private message sent info";
}