function checkRowExists($tblname, $field, $grpinfo, $extracheck = "")
{
global $wpdb;
if ($field != "") {
$substr = "";
if ($extracheck = "idCheck") {
$substr = " and id!='" . $grpinfo['id'] . "'";
}
$sSQL = "select * from " . $tblname . " where " . $field . "='" . addslashes(wpmg_trimVal($grpinfo[$field])) . "' {$substr}";
$res = $wpdb->get_results($sSQL);
if (sizeof($res)) {
return true;
} else {
return false;
}
} else {
return false;
}
}
function wpmg_sendGroupConfirmationtoMember($id, $groupArray)
{
add_filter('wp_mail_content_type', 'wpmg_set_content_type');
global $objMem, $table_name_group, $table_name_message;
$siteTitle = get_bloginfo('name');
$siteUrl = home_url();
$siteEmail = get_bloginfo('admin_email');
$loginURL = wp_login_url();
$user = new WP_User($id);
$display_name = stripslashes($user->display_name);
$user_login = stripslashes($user->user_login);
$user_email = stripslashes($user->user_email);
$user_reg = stripslashes($user->user_registered);
$i = 1;
$grouplist = '';
if (count($groupArray) > 0) {
foreach ($groupArray as $key => $value) {
$get_group = $objMem->selectRows($table_name_group, "", " where id='" . $key . "'");
$group_name = $get_group[0]->title;
$grouplist .= $group_name . ", ";
}
$grouplist = wpmg_trimVal($grouplist, ", ");
}
$get_message = $objMem->selectRows($table_name_message, "", " where message_type = 'Emailuseronsuccessfullregisterationofagroup'");
$dataMessage = stripslashes($get_message[0]->description);
$message_subject = stripslashes($get_message[0]->message_subject);
$message = nl2br(str_replace(array('{%displayname%}', '{%name%}', '{%email%}', '{%site_title%}', '{%group_name%}', '{%group_url%}', '{%site_url%}', '{%site_email%}', '{%activation_url%}', '{%group_list%}', '{%login_url%}'), array($display_name, $user_login, $user_email, $siteTitle, $siteUrl, $siteEmail, $grouplist, $loginURL), $dataMessage));
$subject = nl2br(str_replace(array('{%displayname%}', '{%name%}', '{%email%}', '{%site_title%}', '{%group_name%}', '{%group_url%}', '{%site_url%}', '{%site_email%}', '{%activation_url%}', '{%group_list%}', '{%login_url%}'), array($display_name, $user_login, $user_email, $siteTitle, $grouplist, $siteUrl, $siteEmail, $grouplist, $loginURL), $message_subject));
$headers = 'From: ' . get_bloginfo('name') . ' <' . get_bloginfo('admin_email') . '>' . "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' . "\r\n";
wp_mail($user_email, $subject, $message, $headers);
}
