\n
\n";
echo "".nl2br(parseubb($message_preview))." \n \n";
echo "Odbiorcy: ";
$result = dbquery("SELECT user_id, user_imie, user_nazwisko FROM ".DB_USERS." WHERE user_groups_woj LIKE '%".$_POST['woj']."%' AND user_groups LIKE '%".$_POST['ros']."%'");
while ($data2 = dbarray($result)) {
echo " ".$data2['user_imie']." ".$data2['user_nazwisko']." ";
}
echo " \n \n";
echo "\n";
closetable();
} else {
$subject = ""; $message = ""; $msg_send_state = ""; $msg_to_group = "";
$msg_to_group_state = " disabled"; $sendtoall_chk = ""; $disablesmileys_chk = "";
}
if(isset($_POST['send_message']))
{
$subject = stripinput(trim($_POST['subject']));
$message = stripinput(trim($_POST['message']));
$smileys = isset($_POST['chk_disablesmileys']) ? "n" : "y";
if(isset($_POST['ros']) && isnum($_POST['ros'])){
$where = "user_groups LIKE '%".$_POST['ros']."%'";
} elseif(isset($_POST['woj']) && isnum($_POST['woj'])){
$where = "user_groups_woj LIKE '%".$_POST['woj']."%'";
} else {
redirect(FUSION_SELF.$aidlink);
}
$users_id = array();
$wynik = dbquery("SELECT user_id FROM ".DB_USERS." WHERE user_status=0 AND ".$where);
if(dbrows($wynik) > 0) {
while($r = dbarray($wynik))
{
$users_id[]=$r['user_id'];
}
}
for ($i=0;isset($users_id[$i]);$i++)
{
$result2 = dbquery("INSERT INTO ".DB_MESSAGES." (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES('".$users_id[$i]."','".$userdata['user_id']."','".$subject."','".$message."','".$smileys."','0','".time()."','0')");
}
$licznik = dbcount("(user_id)", DB_USERS, "user_groups_woj LIKE '%".$_POST['woj']."%' AND user_groups LIKE '%".$_POST['ros']."%'");
echo "Wiadomość została wysłana. Liczba odbiorców: ".$licznik."
";
}
//województwo
if(isset($_POST['woj'])) {
$woj = $_POST['woj'];
} else {
$woj = '';
}
$woj1 = "";
$result = dbquery("SELECT group_id, group_name FROM ".DB_USER_GROUPS_WOJ." ORDER BY group_name ASC");
if(dbrows($result) > 0) {
$woj1 .= "--- ";
while($data = dbarray($result)) {
$woj1 .= "".$data['group_name']." ";
}
}
//roślny
if(isset($_POST['ros'])) {
$ros = $_POST['ros'];
} else {
$ros = '';
}
$ros1 = "";
$result = dbquery("SELECT group_id, group_name FROM ".DB_USER_GROUPS." ORDER BY group_name ASC");
if(dbrows($result) > 0) {
$ros1 .= "--- ";
while($data = dbarray($result)) {
$ros1 .= "".$data['group_name']." ";
}
}
opentable('Wyślij wiadomość');
echo "\n";
echo "\n";
closetable();
} else {
echo "Opcja niedostępna ";
}
require_once THEMES."templates/footer.php";
?>