PHP-Fusion Mods
Navigacija
Apsauga
Apsauga Neleista registracija: 39452
Šiandien: 24
Prisijungę nariai
» Svečių: 3
» Narių: 0

» Viso narių: 10,235
» Naujausias: ruslanas tuk

Prisijungimų istorija:
Zbigniew@ 2 Dienos
tabuxnepamenu
sanpernepamenu
CepelinasXnepamenu
VV91DDnepamenu
Minusnepamenu
priezilviciunepamenu
EdvinasG1337nepamenu
rolandas94nepamenu
Edis2nepamenu
klubogerbejasnepamenu
Miskinisnepamenu
Pask. modai
Prisijungti
Vardas

Slaptažodis



Dar ne narys?
Registruotis.

Pamiršai slaptažodį?
Prašyk naujo!.

Naujausi prašymai
[L] testas
Narių apklausa
Ar dar kuriate tinklalapius?

Ne
Ne
0% [0 Balsai]

Taip
Taip
88% [7 Balsai]

Naudojuosi socialiniais tinklais
Naudojuosi socialiniais tinklais
13% [1 Balsas]

Balsai: 8
Kad galėtum balsuoti, turi prisijungti.
Pradėta: 2022-05-29 19:54
Shoutbox
You must login to post a message.

2026-05-11 16:51
Sveiki. Norėjau pasveikinti jus su atkaklumu arba ištverme. Tai viena iš dviejų paskutinių svetainių, paremtų v7. Ar negaila švaistyti ilgametės patirties ir pereiti prie v9?

2026-03-21 19:07

2025-07-13 17:07
svx, smagu kad dar atsiranda naujų narių Šypsosi2

2024-03-07 22:13
Oj Tabux… apkabinčiau už tą moderatorių 😁

2024-02-22 17:40
Šypsosi2 jo buvo laikai.. Senukai jau mes. Bega laikas greiciau nei noretusi. Smagu matyti kad uzsuka seni nariai, ne as vienas Šypsosi

Shoutbox Archive
Peržiūrėti temą
 Spausdinti temą
messages.php kodo isejimas
manex
#1 Spausdinti pranešimą
parašyta 2009-06-12 17:28
Naujokas



Reputacija: 0

Pranešimai: 8
Įstojo: 2008-04-15

Sveiki gal kas galtu i?imti i? messages.php options pasirinkimo koda, kad nariams nerodytu messages.php?folder=options linko tarp messages.php failo.

Netinkamas paveiksliukas

Kodas:

Download source  Code
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright 2002 - 2005 Nick Jones
| Mantas
+----------------------------------------------------*/
require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";
include LOCALE.LOCALESET.\"messages.php\";

if (isset($msg_send) && !($msg_send == \"\" || isNum($msg_send))) fallback(FUSION_SELF);

$settings['privmsg_subject_tooltip']=1;   // use subject tooltip to show message preview
$userdata['user_pm_ban']=0; // set to 1 to ban user from pm'ing. Used if adding new field 'user_pm_ban' to to 'xxx_users' table
$itemsperpage=20; // number of messages to display per page


function builduserclassoptionlist($selected_user_class=1,$restricted=false){
   global $locale;
   $user_class_option_list = \"\";
   $user_class_option_list .= \"\n\";
   $levels = array(101=>$locale['user1'], $locale['user2'], $locale['user3']);
   foreach ($levels as $level => $modlevel) {
      if ($level==$selected_user_class) { $sel = \" selected\"; } else { $sel=\"\"; }
      if ($restricted) { $userlevel = iUSER; } else { $userlevel = max(array_keys($levels)); }
      if ($level<=$userlevel) $user_class_option_list.=\"\n\";
   }

   $groups_qry = dbquery(\"SELECT group_id,group_name FROM \".DB_PREFIX.\"user_groups\");
   if (dbrows($groups_qry) != 0) {
   $user_class_option_list .= \"\n\";
      while ($user_groups = dbarray($groups_qry)) {
         $sel = ($user_groups['group_id'] == $selected_user_class ? \" selected\" : \"\");
         $user_class_option_list.=\"\n\";            
      }
   }
   
   return $user_class_option_list;
}
function builduseroptionlist($selected_user_id=1){
   global $locale;
   $user_option_list = \"\";
   $levels = array(
      0 => array($locale['user3'], \"103\"),
      1 => array($locale['user2'], \"102\"),
      2 => array($locale['user1'], \"101\")
   );
   while(list($key, $user_level) = each($levels)) {
       $uresult = dbquery(\"SELECT * FROM \".DB_PREFIX.\"users WHERE user_level='\".$user_level['1'].\"' ORDER BY user_name\");
      if (dbrows($uresult) > 0) {
         $user_option_list .= \"\n\";
         while ($udata = dbarray($uresult)) {
            $sel = ($udata['user_id'] == $selected_user_id ? \" selected\" : \"\");
            $user_option_list .= \"\n\";
         }
         $user_option_list .= \"
\n\";
      }
   }

   return $user_option_list;
}
function displayMessagePreview($prev_subject,$prev_message,$site_broadcast=false){
   global $locale,$settings,$userdata;
   opentable($locale['438']);
   if (isset($_POST['chk_sitebroadcast'])) {
      $prev_recipient = $locale['408'];
   } else {
      $prev_recipient = \"\".$userdata['user_name'].\"\";
   }
   $prev_msgdate=strftime($settings['longdate'], time()+($settings['timeoffset']*3600));
   echo \"















\".$locale['406'].\": \".$prev_recipient.\"
\".$locale['407'].\": \".$prev_msgdate.\"
\".$locale['405'].\": \".$prev_subject.\"
\".$prev_message.\"
\n\";
   closetable();
   tablebreak();
}

$msg_folders = array(\"inbox\" => 0, \"sentbox\" => 1, \"savebox\" => 2, \"options\" => 3);

$folder_status = array(
   array(\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"),
   array(\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"),
   array(\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\"),
   array(\"\",\"\",\"\",\"\",\"\",\"\",\"\",\"\")
);

// Save user options
if (isset($saveoptions)) {
   $pm_email_notify = isNum($_POST['pm_email_notify']) ? $_POST['pm_email_notify'] : \"0\";
   $pm_save_sent = isNum($_POST['pm_save_sent']) ? $_POST['pm_save_sent'] : \"0\";
   if ($_POST['update_type']==\"new\") {
      dbquery(\"INSERT INTO \".$db_prefix.\"messages_options VALUES ('\".$userdata['user_id'].\"', '$pm_email_notify', '$pm_save_sent', '0', '0', '0')\");

   } else {
      dbquery(\"UPDATE \".$db_prefix.\"messages_options SET pm_email_notify='$pm_email_notify', pm_save_sent='$pm_save_sent' WHERE user_id='\".$userdata['user_id'].\"'\");
   }
   $message = $locale['624'];
}

if (!isset($folder)) $folder=\"inbox\";
if (!array_key_exists($folder,$msg_folders)) $folder=\"inbox\";
$folder_stat=$folder_status[$msg_folders[$folder]];
$result_where_message_folder=\"message_folder=\".$msg_folders[$folder];
if (isset($msg_view)) {
   if (!isNum($msg_view)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_view;
} elseif (isset($msg_reply)) {
   if (!isNum($msg_reply)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_reply;
} elseif (isset($_POST['reply_preview'])) {
   if (!isNum($msg_reply_preview)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_reply_preview;
   $msg_reply = $msg_reply_preview;
} elseif (isset($msg_setread)) {
   if (!isNum($msg_setread)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_setread;
} elseif (isset($msg_setunread)) {
   if (!isNum($msg_setunread)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_setunread;
} elseif (isset($msg_save)) {
   if (!isNum($msg_save)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_save;
   $cnt_messages = '1';
} elseif (isset($msg_unsave)) {
   if (!isNum($msg_unsave)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_unsave;
   $cnt_messages = '1';
} elseif (isset($msg_delete)) {
   if (!isNum($msg_delete)) fallback(\"messages.php\");
   $result_where_message_id=\"message_id=\".$msg_delete;
} elseif (isset($chk_mark)) {
   if (is_array($chk_mark) && count($chk_mark) > 1) {
      // Count how many elements (messages) in array
      $cnt_messages = count($chk_mark);
      foreach ($chk_mark as $thisnum) { if (!isNum($thisnum)) { fallback(\"messages.php\"); } }
      $result_where_message_id = \"message_id IN(\".implode(',',$chk_mark).\")\";
   } else {
      $cnt_messages = '1';
      $result_where_message_id = \"message_id=\".(isNum($chk_mark[0]) ? $chk_mark[0] : \"0\");
   }
}

$result_where_message_to=\"message_to=\".$userdata['user_id']; // a double check to make sure the script only operates on the current users messages

$sender_id = (isset($_POST['chk_sitebroadcast']) ? 0 : $userdata['user_id']);

if (isset($_POST['send_preview']) || isset($_POST['reply_preview'])) {
   if(isset($_POST['chk_showsig'])) $checked_sig=\" checked\";
   if(isset($_POST['chk_disablesmileys'])) $checked_smileys=\" checked\";
   if(isset($_POST['chk_sendtoall'])) $checked_sendtoall=\" checked\";
   if(isset($_POST['chk_sitebroadcast'])) $checked_sitebroadcast=\" checked\";
   $prev_subject=stripinput($_POST['subject']);
   $prev_message=stripinput($_POST['message']);
   if ($checked_sig) $prev_message = $prev_message.\"\n\n\".$userdata['user_sig'];
   if (!$checked_smileys) $prev_message = parsesmileys($prev_message);
   $prev_message = nl2br(parseubb($prev_message));
   // $msg_send = $msg_to;
}
if(iGUEST){ // not logged in - display \"iMEMBERs only\"
   opentable($locale['400']);
   echo \"

\".$locale['483'].\"

\n\";
} elseif ($userdata['user_pm_ban'] == \"1\"){ // user is banned from pm'ing
   opentable($locale['400']);
   echo \"

\".$locale['484'].\"

\n\";
} elseif (isset($_POST['btn_cancel'])) { // handle cancel button
   redirect(FUSION_SELF.\"?folder=\".$folder);
} elseif (isset($_POST['btn_setread']) || isset($msg_setread)) { // set message as read
   dbquery(\"UPDATE \".$db_prefix.\"messages SET message_read=1 WHERE \".$result_where_message_id.\" AND \".$result_where_message_to);
   redirect(FUSION_SELF.\"?folder=\".$folder);
} elseif (isset($_POST['btn_setunread']) || isset($msg_setunread)) { // set message as un-read
   dbquery(\"UPDATE \".$db_prefix.\"messages SET message_read=0 WHERE \".$result_where_message_id.\" AND \".$result_where_message_to);
   redirect(FUSION_SELF.\"?folder=\".$folder);
} elseif (isset($_POST['btn_save']) || isset($msg_save)) { // move message to 'savebox' folder
   // Count how many messages in archive/savebox
   $cnt_savebox_qry = dbquery(\"SELECT COUNT(message_id) cnt_savebox FROM \".$db_prefix.\"messages WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='2' GROUP BY message_to\");
   if (dbrows($cnt_savebox_qry) != 0) { $cnt_savebox = dbresult($cnt_savebox_qry,0); }
   // Get limit
   $limit_savebox = dbresult(dbquery(\"SELECT pm_savebox FROM \".$db_prefix.\"messages_options WHERE user_id='0'\"),0);
   // Check if current + new messages is > limit
   if ($limit_savebox != '0' && ($cnt_messages + $cnt_savebox) > $limit_savebox) { $error = $locale['629']; }
   if (isset($error)) {
      opentable($locale['627']);
      echo \"

\".$error.\"

\";
   } else {
      $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_folder=2 WHERE \".$result_where_message_id.\" AND \".$result_where_message_to);
      redirect(FUSION_SELF.\"?folder=\".$folder);
   }
} elseif (isset($_POST['btn_unsave']) || isset($msg_unsave)){ // move message to 'inbox' folder
   // Count how many messages in inbox
   $cnt_inbox_qry = dbquery(\"SELECT COUNT(message_id) cnt_inbox FROM \".$db_prefix.\"messages WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='0' GROUP BY message_to\");
   if (dbrows($cnt_inbox_qry) != 0) { $cnt_inbox = dbresult($cnt_inbox_qry,0); }
   // Get limit
   $limit_inbox=dbresult(dbquery(\"SELECT pm_inbox FROM \".$db_prefix.\"messages_options WHERE user_id='0'\"),0);
   // Check if current + new messages is > limit
   if ( $limit_inbox != '0' && ($cnt_messages + $cnt_inbox) > $limit_inbox) { $error = $locale['629']; }
   
   if (isset($error)) {
      opentable($locale['627']);
      echo \"

\".$error.\"

\";
   } else {
      dbquery(\"UPDATE \".$db_prefix.\"messages SET message_folder=0 WHERE \".$result_where_message_id.\" AND \".$result_where_message_to);
      redirect(FUSION_SELF.\"?folder=\".$folder);
   }
} elseif (isset($_POST['btn_delete']) || isset($msg_delete)) { // delete message
   if (!isset($msg_delete) && !isset($chk_mark)) fallback(\"messages.php\");
   $result = dbquery(\"DELETE FROM \".$db_prefix.\"messages WHERE \".$result_where_message_id.\" AND \".$result_where_message_to);
   redirect(FUSION_SELF.\"?folder=\".$folder);
} elseif (isset($msg_view)) { // view message
$result=dbquery(
      \"SELECT tm.*, user_id, user_name, user_avatar FROM \".$db_prefix.\"messages tm LEFT JOIN \".$db_prefix.\"users \".
      \"ON message_from=user_id WHERE \".$result_where_message_id.\" AND \".$result_where_message_to
   );
   if (dbrows($result) == \"1\"){
      $data=dbarray($result);
      if (!$data['user_avatar']) { $data['user_avatar'] = 'noimage.gif'; }
      $avatar = $data['user_avatar'];
      $subject = $data['message_subject'];
      $message = parseubb(nl2br($data['message_message']));
      if ($data['message_smileys']==\"y\") $message=parsesmileys($message);
      $msgdate = strftime($settings['longdate'], $data['message_datestamp']+($settings['timeoffset']*3600));
      if ($data['message_read'] == 0) {
         $result=dbquery(\"UPDATE \".$db_prefix.\"messages SET message_read='1' WHERE \".$result_where_message_id.\" AND \".$result_where_message_to);
      }
      $msg_fld_name = array_search($data['message_folder'],$msg_folders);
      opentable($locale['431'].\" (\".$msg_fld_name.\")\");
      echo \"














\".($data['message_folder']==1?$locale['421']:$locale['406']).\": \";
      if ($data['message_from'] == 0) {
         echo $locale['408'];
      } else {
         echo \"
\".$data['user_name'].\"
\";
      }
      echo \"
\".($data['message_folder']==1?$locale['426']:$locale['407']).\":\".$msgdate.\"
\".$locale['405'].\": \".$subject.\"
\".$message.\"






> \n\";
      if ($data['message_folder'] != \"1\" && $data['user_id'] != \"0\") {
         echo \"> \";
      }
      if ($data['message_folder']== \"2\") {
         echo \"> \";
      } else {
         echo \"> \";
      }
      echo \">
>
\n\";
   } else {
opentable($locale['480']);
      echo \"

\".$locale['481'].\"

\n\";
   }
} elseif (isset($msg_send)||isset($_POST['send_preview'])){ // write message
   if ($msg_send <> \"\" && (((int)$msg_send) == $msg_send)){
      $type = \"user\";
      $uresult=dbquery(\"SELECT user_name, user_avatar FROM \".$db_prefix.\"users WHERE user_id='\".$msg_send.\"'\");
      $rows=dbrows($uresult);
      if ($rows == 1) $data=dbarray($uresult);
      if (!$data['user_avatar']) { $data['user_avatar'] = 'noimage.gif'; }
      $avatar = $data['user_avatar'];
   } else {
      $rows = 1;
   }
   if ($rows == 1){
      if (isset($_POST['send_preview'])) displayMessagePreview($prev_subject,$prev_message);
      opentable($locale['420']);
      echo \"























\".$locale['421'].\": \";
      if (($msg_send <> \"\") && !isset($prev_message)) {
         echo \"
\".$data['user_name'].\"
\";
      } else {
         echo \"\";
         if(iSUPERADMIN){
            if (!isset($msg_to_class)) $msg_to_class = 1;
            echo \">\".$locale['434'].\":
            \";
         }
      }
   
      echo \"
\".$locale['405'].\":
\".$locale['422'].\":

>', '');\\">
>', '');\\">
>', '');\\">
>
>
>
>
>', '');\\">
>
Download source  Code
', '


');\\">
>', '');\\">


\".displaysmileys(\"message\").\"
\".$locale['425'].\":
\".$locale['427'];
if ($userdata['user_sig']) echo \"
\n\".$locale['428'];
if (iADMIN) echo \"
\n\".$locale['441'];
echo \"






>



\n\";
   } else {
      opentable($locale['480']);
      echo \"

\".$locale['482'].\"

\n\";
   }
} elseif (isset($_POST['send_message'])) { // send message
   $smileys = (isset($_POST['chk_disablesmileys']) ? \"n\" : \"y\");
   $subject = stripinput($_POST['subject']);
   $message = stripinput($_POST['message']);
   if (isset($_POST['chk_showsig'])) $message.=\"\n\n\".$userdata['user_sig'];
   // Get PM folder restrictions
   // (room for future option to restrict number of pm's for a specific user)
   $limits = dbarray(dbquery(\"SELECT pm_inbox,pm_sentbox FROM \".$db_prefix.\"messages_options WHERE user_id='0'\"));
   $limit_inbox = $limits['pm_inbox'];
   $limit_sentbox = $limits['pm_sentbox'];
   if (isset($_POST['chk_sendtoall'])) {
      // Determine if Group or User Level
      if (strstr($msg_to_class, \"g-\")) {
         $msg_to_class = str_replace(\"g-\", \"\", $msg_to_class);
         // Select all users from users table and loop through list
         $user_groups_qry = dbquery(\"SELECT user_id,user_groups FROM \".$db_prefix.\"users\");
         while ($ugroups = dbarray($user_groups_qry)) {
            // Explode the array into a list of user group id's
            $user_groups = explode(\".\", $ugroups['user_groups']);
            // If there's a match, then send to that user
            if (in_array($msg_to_class, $user_groups)) {
               $uresult = dbquery(\"SELECT * FROM \".$db_prefix.\"users WHERE user_id=\".$ugroups['user_id']);
               while($udata=dbarray($uresult)){
                  if ($udata['user_id'] != $userdata['user_id']) $result = dbquery(\"INSERT INTO \".$db_prefix.\"messages VALUES('','\".$udata['user_id'].\"','\".$sender_id.\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','0')\");
                  // Lookup receiving users options
                  $options_qry = dbquery(\"SELECT * FROM \".$db_prefix.\"messages_options WHERE user_id='\".$udata['user_id'].\"'\");
                  if (dbrows($options_qry) != 0) { $options = dbarray($options_qry); } else { unset($options); }
                  // Send notification email if user option is set
                  if (isset($options) && $options['pm_email_notify'] == \"1\") {
                     sendemail($udata['user_name'],$udata['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$udata['user_name'].$locale['626']);
                  }
               }
            }
         }
      } else {
         $uresult = dbquery(\"SELECT * FROM \".$db_prefix.\"users WHERE user_level='\".$msg_to_class.\"' ORDER BY user_id\");
         while($udata = dbarray($uresult)){
            if ($udata['user_id'] != $userdata['user_id']) $result=dbquery(\"INSERT INTO \".$db_prefix.\"messages VALUES('','\".$udata['user_id'].\"','\".$sender_id.\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','0')\");
            // Lookup receiving users options
            $options_qry = dbquery(\"SELECT * FROM \".$db_prefix.\"messages_options WHERE user_id='\".$udata['user_id'].\"'\");
            if (dbrows($options_qry) != 0) { $options = dbarray($options_qry); } else { unset($options); }
            // Send notification email if user option is set
            if (isset($options) && $options['pm_email_notify'] == \"1\") {
               sendemail($udata['user_name'],$udata['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$udata['user_name'].$locale['626']);
            }
         }
      }
      
   } elseif (isset($msg_to) && (((int)$msg_to) == $msg_to)) {
      // Count inbox usage
      $cnt_inbox_qry = dbquery(\"SELECT COUNT(message_id) cnt_inbox FROM \".$db_prefix.\"messages WHERE message_to='\".$msg_to.\"' AND message_folder='0' GROUP BY message_to\");
      if (dbrows($cnt_inbox_qry) != 0) { $cnt_inbox = dbresult($cnt_inbox_qry, 0); } else { $cnt_inbox = 0; }
      // Check if user has reached inbox limit
      if ($limit_inbox == \"0\" || ($cnt_inbox < $limit_inbox)) {
         $result=dbquery(\"INSERT INTO \".$db_prefix.\"messages VALUES('','\".$msg_to.\"','\".$sender_id.\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','0')\");
      } else {
         $error = $locale['628'];
      }
      // Get user options
      $options_qry = dbquery(\"SELECT pm_email_notify FROM \".$db_prefix.\"messages_options WHERE user_id='\".$msg_to.\"'\");
      if (dbrows($options_qry) != 0) {
         $options = dbarray($options_qry);
      } else {
          $options = dbarray(dbquery(\"SELECT pm_email_notify FROM \".$db_prefix.\"messages_options WHERE user_id='0'\"));
      }
      // Send notification email if user option is set
      if ($options['pm_email_notify'] == \"1\") {
         $uresult = dbquery(\"SELECT * FROM \".$db_prefix.\"users WHERE user_id='\".$msg_to.\"'\");
         $udata = dbarray($uresult);
         sendemail($udata['user_name'],$udata['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$udata['user_name'].$locale['626']);
      }
   }
   // If there's an error, display error and don't save PM
   if (isset($error)) {
      opentable($locale['627']);
      echo \"

\".$error.\"

\";
   } else {
      // Lookup sending users options
      $options_qry = dbquery(\"SELECT pm_save_sent FROM \".$db_prefix.\"messages_options WHERE user_id='\".$userdata['user_id'].\"'\");
      if (dbrows($options_qry) != 0) {
         $options = dbarray($options_qry);
      } else {
         $options = dbarray(dbquery(\"SELECT pm_save_sent FROM \".$db_prefix.\"messages_options WHERE user_id='0'\"));
      }
      if ($options['pm_save_sent'] == \"1\") {
         // Check how many messages in sentbox
         $cnt_sentbox_qry=dbquery(\"SELECT COUNT(message_id) cnt_sentbox FROM \".$db_prefix.\"messages WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='1' GROUP BY message_to\");
         if (dbrows($cnt_sentbox_qry) != 0) { $cnt_sentbox = dbresult($cnt_sentbox_qry, 0); } else { $cnt_sentbox = 0; }
         // If equal to or greater than limit, delete difference (delete oldest sent messages)
         if ($limit_sentbox != \"0\" && $cnt_sentbox >= $limit_sentbox) {
            $difference = $cnt_sentbox - $limit_sentbox + 1;
            $del_sent_qry = dbquery(\"SELECT message_id FROM \".$db_prefix.\"messages WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='1' ORDER BY message_id ASC LIMIT 0,\".$difference);

            while ($del_pm = dbarray($del_sent_qry)) { dbquery(\"DELETE FROM \".$db_prefix.\"messages WHERE message_id='\".$del_pm['message_id'].\"'\");}
         }
         $result = dbquery(\"INSERT INTO \".$db_prefix.\"messages VALUES('','\".$userdata['user_id'].\"','\".$msg_to.\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','1')\");
      }
      redirect(FUSION_SELF.\"?folder=\".$folder);
   }
} elseif (isset($msg_reply) || isset($_POST['reply_preview'])) { // reply to message
   $result=dbquery(
      \"SELECT * FROM \".$db_prefix.\"messages LEFT JOIN \".$db_prefix.\"users \".
      \"ON message_from=user_id WHERE \".$result_where_message_id.\" AND \".$result_where_message_to
   );

   if(dbrows($result)) {
      if (isset($_POST['reply_preview'])) displayMessagePreview($prev_subject,$prev_message);
      $data = dbarray($result);
      if (!$data['user_avatar']) { $data['user_avatar'] = 'noimag.gif'; }
      $avatar = $data['user_avatar'];
      $recipient = \"
\".$data['user_name'].\"
\";
      $subject = ($data['message_subject']);
      if (!strstr($subject,\"RE: \")) $subject=\"RE: \".$subject;
      $orig_message = parseubb(nl2br($data['message_message']));
      if ($data['message_smileys'] == \"y\") $orig_message = parsesmileys($orig_message);
      $msgdate = strftime($settings['longdate'], $data['message_datestamp']+($settings['timeoffset']*3600));
      $insert = \"
\".$data['user_name'].\" ra? :\n\".$data['message_message'].\"
\";
      opentable($locale['439']);
      echo \"





























\".$locale['421'].\": \".$recipient.\"
\".$locale['405'].\":
\".$locale['422'].\": \".$orig_message.\"

\".sprintf($locale['440'], $msgdate).\"
\".(0?$locale['422']:$locale['433']).\":

>', '');\\">
>', '');\\">
>', '');\\">
>
>
>
>
>', '');\\">
>

');\">
>', '');\">


".displaysmileys("message")."
".$locale['425'].":
".$locale['427'];
if ($userdata[user_sig]) echo "
\n".$locale['428'];
echo "

\n



>



\n";
} else {
opentable($locale['480']);
echo "

".$locale['481']."

\n";
}
} elseif (isset($_POST['reply_message'])) { // send message
$smileys = (isset($_POST['chk_disablesmileys']) ? "n" : "y");
$subject = stripinput($_POST['subject']);
$message = stripinput($_POST['message']);
if (isset($_POST['chk_showsig'])) $message.="\n\n".$userdata['user_sig'];
if (isset($msg_to)&&(((int)$msg_to) == $msg_to)){
// Get message limits
$limits = dbarray(dbquery("SELECT pm_inbox,pm_sentbox FROM ".$db_prefix."messages_options WHERE user_id='0'"));
$limit_inbox = $limits['pm_inbox'];
$limit_sentbox = $limits['pm_sentbox'];
// Count inbox usage
$cnt_inbox_qry = dbquery("SELECT COUNT(message_id) cnt_inbox FROM ".$db_prefix."messages WHERE message_to='".$msg_to."' AND message_folder='0' GROUP BY message_to");
if (dbrows($cnt_inbox_qry)!=0) { $cnt_inbox = dbresult($cnt_inbox_qry,0); } else { $cnt_inbox = 0; }
// Check if user has reached inbox limit
if ($limit_inbox == "0" || ($cnt_inbox < $limit_inbox)) {
$result = dbquery("INSERT INTO ".$db_prefix."messages VALUES('', '".$msg_to."', '".$userdata['user_id']."', '".$subject."', '".$message."', '".$smileys."', '0', '".time()."', 0)");
} else {
$error = $locale['628'];
}
// Get user options
$options_qry = dbquery("SELECT pm_email_notify FROM ".$db_prefix."messages_options WHERE user_id='".$msg_to."'");
if (dbrows($options_qry) != 0) {
$options = dbarray($options_qry);
} else {
$options = dbarray(dbquery("SELECT pm_email_notify FROM ".$db_prefix."messages_options WHERE user_id='0'"));
}
// Send notification email if user option is set
if ($options['pm_email_notify'] == "1") {
$uresult = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_id='".$msg_to."'");
$udata = dbarray($uresult);
sendemail($udata['user_name'],$udata['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$udata['user_name'].$locale['626']);
}
// Lookup sending users options
$options_qry = dbquery("SELECT pm_save_sent FROM ".$db_prefix."messages_options WHERE user_id='".$userdata['user_id']."'");
if (dbrows($options_qry) != 0) {
$options = dbarray($options_qry);
} else {
$options = dbarray(dbquery("SELECT pm_save_sent FROM ".$db_prefix."messages_options WHERE user_id='0'"));
}
if ($options['pm_save_sent'] == "1") {
// Check how many messages in sentbox
$cnt_sentbox_qry=dbquery("SELECT COUNT(message_id) cnt_sentbox FROM ".$db_prefix."messages WHERE message_to='".$userdata['user_id']."' AND message_folder='1' GROUP BY message_to");
if (dbrows($cnt_sentbox_qry) != 0) { $cnt_sentbox = dbresult($cnt_sentbox_qry,0); } else { $cnt_sentbox = 0; }
// If equal to or greater than limit, delete difference (delete oldest sent messages)
if ($limit_sentbox != "0" && $cnt_sentbox >= $limit_sentbox) {
$difference = $cnt_sentbox - $limit_sentbox + 1;
$del_sent_qry = dbquery("SELECT message_id FROM ".$db_prefix."messages WHERE message_to='".$userdata['user_id']."' AND message_folder='1' ORDER BY message_id ASC LIMIT 0,".$difference);
while ($del_pm = dbarray($del_sent_qry)) { dbquery("DELETE FROM ".$db_prefix."messages WHERE message_id='".$del_pm['message_id']."'");}
}
}

}
if (isset($error)) {
opentable($locale['627']);
echo "

".$error."

";
} else {
if ($options['pm_save_sent'] == '1') {
$result = dbquery("INSERT INTO ".$db_prefix."messages VALUES('','".$userdata['user_id']."','".$msg_to."','".$subject."','".$message."','".$smileys."','0','".time()."','1')");
}
redirect(FUSION_SELF."?folder=".$folder);
}
} else {
$srch_fields = array(
//code=>array(add_slashes,'field name','display name');
"s" => array(1,'message_subject',$locale['462']),
"m" => array(1,'message_message',$locale['463']),
"f" => array(0,'user_name',$locale['464'])
);
$sort_fields=array(
//code=>array('field name','display name');
"d" => array('message_datestamp DESC',$locale['465']),
"f" => array('message_from',$locale['464']),
"s" => array('message_subject',$locale['462'])
);
if (isset($_POST['srch_reset'])) {
unset($show,$srch_text,$srch_type,$sort_type);
} elseif (isset($srch_text) && $srch_text<>"" && $srch_type <> "") {
if ($srch_fields[$srch_type][0]) { $srch_text2 = stripinput($srch_text); } else { $srch_text2 = $srch_text; }
$srch_text2 = str_replace(array('?','*'), array('_','%'), $srch_text2);
$srch_where = " AND ".$srch_fields[$srch_type][1]." LIKE '$srch_text2'";
} elseif(isset($show)){
$show = strtolower($show);
if ($show!="all") $srch_where=" AND LEFT(user_name,1)='".$show."'";
} else {
$srch_text="";
$srch_where="";
}
if (isset($sort_type) && $sort_type <> "") {
$sort_where = $sort_fields[$sort_type][0];
} else {
$sort_where = "message_datestamp DESC";
}
if ($srch_text != ""){
$title = sprintf($locale['458'], $srch_text, $srch_fields[$srch_type][2]);
} elseif (isset($show)) {
($show != "all" ? $title = sprintf($locale['459'], $show) : "");
} else {
$title = "";
}
if(isset($sort_type)){
$title.=sprintf($locale['460'],$sort_fields[$sort_type][1]);
}
if($title != ""){
$title="



".$title."

\n";
}
opentable($locale['400']);
$data = dbarray(dbquery(
"SELECT COUNT(message_id) cnt_total, COUNT(IF(message_folder=0, 1, null)) cnt_inbox, ".
"COUNT(IF(message_folder=1, 1, null)) cnt_sentbox, COUNT(IF(message_folder=2, 1, null)) cnt_savebox ".
"FROM ".$db_prefix."messages WHERE ".$result_where_message_to." GROUP BY message_to"
));
// Get folder size restrictions (room for future option to restrict number of pm's for a specific user)
$limit = dbarray(dbquery("SELECT * FROM ".$db_prefix."messages_options WHERE user_id='0'"));
if (isset($data['cnt_total'])) { $cnt_total = $data['cnt_total']; } else { $cnt_total = "0"; }
if (isset($data['cnt_inbox'])) { $cnt_inbox = $data['cnt_inbox']; } else { $cnt_inbox = "0"; }
if (isset($data['cnt_sentbox'])) { $cnt_sentbox = $data['cnt_sentbox']; } else { $cnt_sentbox = "0"; }
if (isset($data['cnt_savebox'])) { $cnt_savebox = $data['cnt_savebox']; } else { $cnt_savebox = "0"; }
$limit_inbox = $limit['pm_inbox'];
$limit_sentbox = $limit['pm_sentbox'];
$limit_savebox = $limit['pm_savebox'];

// Set display of top bar
if ($limit_inbox != "0") { $inbox_display = " (".$cnt_inbox."/".$limit_inbox.")"; } else { $inbox_display = " (".$cnt_inbox.")"; }
if ($limit_sentbox != "0") { $sentbox_display = " (".$cnt_sentbox."/".$limit_sentbox.")"; } else { $sentbox_display = " (".$cnt_sentbox.")"; }
if ($limit_savebox != "0") { $savebox_display = " (".$cnt_savebox."/".$limit_savebox.")"; } else { $savebox_display = " (".$cnt_savebox.")"; }

if ($cnt_total !=0 || $folder != "settings"){
tablebreak();
echo $title."





>


\n
\n
\n
\n

\n".$folder_stat[0]."".$locale['402'].$inbox_display."".$folder_stat[1]."\n \n".$folder_stat[2]."".$locale['403'].$sentbox_display."".$folder_stat[3]."\n \n".$folder_stat[4]."".$locale['404'].$savebox_display."".$folder_stat[5]."\n \n".$folder_stat[6]."".$locale['620']."".$folder_stat[7]."\n

\n";
tablebreak();
// Display Options Page
if ($folder == "options") {
$options_qry = dbquery("SELECT * FROM ".$db_prefix."messages_options WHERE user_id='".$userdata['user_id']."'");
if (dbrows($options_qry) != 0) {
$options = dbarray($options_qry);
$update_type = "update";
} else {
$update_type = "new";
}
// Select default value for options
$displayoptions['pm_email_notify'][0] = "";
$displayoptions['pm_email_notify'][1] = "";
$displayoptions['pm_save_sent'][0] = "";
$displayoptions['pm_save_sent'][1] = "";
// If value is set to '1' then display the correct default value of yes
$default_options = dbarray(dbquery("SELECT pm_email_notify,pm_save_sent FROM ".$db_prefix."messages_options WHERE user_id='0'"),0);
if ($default_options['pm_email_notify'] == 1) { rsort($displayoptions['pm_email_notify']); }
if ($default_options['pm_save_sent'] == 1) { rsort($displayoptions['pm_save_sent']); }

echo "

















".$locale['620']."
".$locale['621']."

".$locale['622']."






\n";
} else {
$rows=dbresult(dbquery(
"SELECT COUNT(*) FROM ".$db_prefix."messages LEFT JOIN ".$db_prefix."users ON user_id=message_from ".
"WHERE ".$result_where_message_folder." AND ".$result_where_message_to.$srch_where
),0);
if(!isset($rowstart) || !isNum($rowstart)) $rowstart=0;
$result=dbquery(
"SELECT * FROM ".$db_prefix."messages LEFT JOIN ".$db_prefix."users ".
"ON user_id=message_from WHERE ".$result_where_message_folder." AND ".$result_where_message_to.$srch_where.
" ORDER BY message_read,".$sort_where." LIMIT ".$rowstart.",".$itemsperpage
);
$msgcount=dbrows($result);
if($msgcount>0){
echo "
\n






\n";
$unread_shown=0;
$r=0;
while ($data = dbarray($result)) {
if (!$data['user_avatar']) { $data['user_avatar'] = 'noimage.gif'; }
$avatar = $data['user_avatar'];
$msgdate=strftime($settings['forumdate'], $data['message_datestamp']+($settings['timeoffset']*3600));
if($data['message_read']<>$unread_shown){
if ($r > 0)echo "\n";
$unread_shown = 1;
}
echo "\n\n\n\n";
$r++;
echo "\n";
}
echo "
".$locale['405']." ".($msg_folders[$folder]==1?$locale['421']:$locale['406'])." ".$locale['407']."
";
if ($data['message_read'] == 0){echo "";}
echo "";
$msg_title=($settings['privmsg_subject_tooltip']?substr(stripslashes($data['message_message']),0,75)."'":$locale['505']);
echo "".$data['message_subject']."";
if ($data['message_read'] == 0){echo "
";}
echo "
";
if ($data['message_from'] == 0){
echo $locale['408'];
} else {
echo "
".$data['user_name']."
";
}
echo "
".$msgdate."

\n";
} else {
echo "

".($srch_where==""?$locale['461']:$locale['453'])."

\n";
}
if($msgcount>0){
tablebreak();
echo "\n
\n
\n\n
>
>
".$locale['409']." \n";
if($folder=='savebox'){
echo " ";
} else {
echo " ";
}
echo "

\n
\n";
tablebreak();
}
if ($msgcount > 0 || $srch_where != ""){
echo "
\n".$locale['417']." ".$locale['418']."";
$srch_letters=array('A','B','C','D','E','F','G','H','I','J','K','L','M','N','O','P'
 
PM
zDon
#2 Spausdinti pranešimą
parašyta 2009-06-12 17:29
Vartotojo avataras

Geradarys



Reputacija: 0

Pranešimai: 598
Įstojo: 2008-08-11

Tvarkyk kod ... Sudjai betkaip....
ELECKTRIK !!!
===================================
?i svetain skirta padti pasidaryti, o ne padaryti u? jus.
 
PM
manex
#3 Spausdinti pranešimą
parašyta 2009-06-12 17:54
Naujokas



Reputacija: 0

Pranešimai: 8
Įstojo: 2008-04-15

manex para?:
Sveiki gal kas galtu i?imti i? messages.php options pasirinkimo koda, kad nariams nerodytu messages.php?folder=options linko tarp messages.php failo.

Netinkamas paveiksliukas

Kodas:

Download source  Code
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright 2002 - 2006 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once \"maincore.php\";
require_once \"subheader.php\";
require_once \"side_left.php\";
include LOCALE.LOCALESET.\"messages.php\";

if (!iMEMBER) fallback(\"index.php\");

$msg_settings = dbarray(dbquery(\"SELECT * FROM \".$db_prefix.\"messages_options WHERE user_id='0'\"));

if (!isset($folder) || !preg_match(\"/^(inbox|outbox|archive|options)$/\", $folder)) $folder = \"inbox\";
if (isset($_POST['msg_send']) && isNum($_POST['msg_send'])) $msg_send = $_POST['msg_send'];
if (isset($_POST['msg_to_group']) && isNum($_POST['msg_to_group'])) $msg_to_group = $_POST['msg_to_group'];

$msg_ids = \"\"; $check_count = 0;

if (isset($_POST['check_mark'])) {
   if (is_array($_POST['check_mark']) && count($_POST['check_mark']) > 1) {
      foreach ($_POST['check_mark'] as $thisnum) {
         if (isNum($thisnum)) $msg_ids .= ($msg_ids ? \",\" : \"\").$thisnum;
         $check_count++;
      }
   } else {
      if (isNum($_POST['check_mark'][0])) $msg_ids = $_POST['check_mark'][0];
      $check_count = 1;
   }
}

if (isset($_POST['save_options'])) {
   $pm_email_notify = isNum($_POST['pm_email_notify']) ? $_POST['pm_email_notify'] : \"0\";
   $pm_save_sent = isNum($_POST['pm_save_sent']) ? $_POST['pm_save_sent'] : \"0\";
   if ($_POST['update_type'] == \"insert\") {
      $result = dbquery(\"INSERT INTO \".$db_prefix.\"messages_options (user_id, pm_email_notify, pm_save_sent, pm_inbox, pm_savebox, pm_sentbox) VALUES ('\".$userdata['user_id'].\"', '$pm_email_notify', '$pm_save_sent', '0', '0', '0')\");
   } else {
      $result = dbquery(\"UPDATE \".$db_prefix.\"messages_options SET pm_email_notify='$pm_email_notify', pm_save_sent='$pm_save_sent' WHERE user_id='\".$userdata['user_id'].\"'\");
   }
   redirect(FUSION_SELF.\"?folder=options\");
}

if (isset($msg_id) && isNum($msg_id)) {
   if (isset($_POST['save'])) {
      $archive_total = dbcount(\"(message_id)\", \"messages\", \"message_to='\".$userdata['user_id'].\"' AND message_folder='2'\");
      if ($msg_settings['pm_savebox'] == \"0\" || ($archive_total + 1) <= $msg_settings['pm_savebox']) {
         $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_folder='2' WHERE message_id='$msg_id' AND message_to='\".$userdata['user_id'].\"'\");
      } else {
         $error = \"1\";
      }
      redirect(FUSION_SELF.\"?folder=archive\".($error ? \"&error=$error\" : \"\"));
   } elseif (isset($_POST['unsave'])) {
      $inbox_total = dbcount(\"(message_id)\", \"messages\", \"message_to='\".$userdata['user_id'].\"' AND message_folder='0'\");
      if ($msg_settings['pm_inbox'] == \"0\" || ($inbox_total + 1) <= $msg_settings['pm_inbox']) {
         $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_folder='0' WHERE message_id='$msg_id' AND message_to='\".$userdata['user_id'].\"'\");
      } else {
         $error = \"1\";
      }
      redirect(FUSION_SELF.\"?folder=archive\".($error ? \"&error=$error\" : \"\"));
   } elseif (isset($_POST['delete'])) {
      $result = dbquery(\"DELETE FROM \".$db_prefix.\"messages WHERE message_id='$msg_id' AND message_to='\".$userdata['user_id'].\"'\");
      redirect(FUSION_SELF.\"?folder=$folder\");
   }
}

if ($msg_ids && $check_count > 0) {
   if (isset($_POST['save_msg'])) {
      $archive_total = dbcount(\"(message_id)\", \"messages\", \"message_to='\".$userdata['user_id'].\"' AND message_folder='2'\");
      if ($msg_settings['pm_savebox'] == \"0\" || ($archive_total + $check_count) <= $msg_settings['pm_savebox']) {
         $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_folder='2' WHERE message_id IN(\".$msg_ids.\") AND message_to='\".$userdata['user_id'].\"'\");
      } else {
         $error = \"1\";
      }
   } elseif (isset($_POST['unsave_msg'])) {
      $inbox_total = dbcount(\"(message_id)\", \"messages\", \"message_to='\".$userdata['user_id'].\"' AND message_folder='0'\");
      if ($msg_settings['pm_inbox'] == \"0\" || ($inbox_total + $check_count) <= $msg_settings['pm_inbox']) {
         $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_folder='0' WHERE message_id IN(\".$msg_ids.\") AND message_to='\".$userdata['user_id'].\"'\");
      } else {
         $error = \"1\";
      }
   } elseif (isset($_POST['read_msg'])) {
      $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_read='1' WHERE message_id IN(\".$msg_ids.\") AND message_to='\".$userdata['user_id'].\"'\");
   } elseif (isset($_POST['unread_msg'])) {
      $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_read='0' WHERE message_id IN(\".$msg_ids.\") AND message_to='\".$userdata['user_id'].\"'\");
   } elseif (isset($_POST['delete_msg'])) {
      $result = dbquery(\"DELETE FROM \".$db_prefix.\"messages WHERE message_id IN(\".$msg_ids.\") AND message_to='\".$userdata['user_id'].\"'\");
   }
   redirect(FUSION_SELF.\"?folder=$folder\".($error ? \"&error=$error\" : \"\"));
}

if (isset($_POST['send_message'])) {
   $error = \"\";
   $result = dbquery(\"SELECT * FROM \".$db_prefix.\"messages_options WHERE user_id='\".$userdata['user_id'].\"'\");
   if (dbrows($result)) {
      $my_settings = dbarray($result);
   } else {
      $my_settings['pm_save_sent'] = $msg_settings['pm_save_sent'];
      $my_settings['pm_email_notify'] = $msg_settings['pm_email_notify'];
   }
   $subject = stripinput(trim($_POST['subject']));
   $message = stripinput(trim($_POST['message']));
   if ($subject == \"\" || $message == \"\") fallback(FUSION_SELF.\"?folder=inbox\");
   $smileys = isset($_POST['chk_disablesmileys']) ? \"n\" : \"y\";
   require_once INCLUDES.\"sendmail_include.php\";
   if (iADMIN && isset($_POST['chk_sendtoall']) && isNum($_POST['msg_to_group'])) {
      $msg_to_group = $_POST['msg_to_group'];
      if ($msg_to_group == \"101\" || $msg_to_group == \"102\" || $msg_to_group == \"103\") {
         $result = dbquery(
            \"SELECT u.user_id, u.user_name, u.user_email, mo.pm_email_notify FROM \".$db_prefix.\"users u
            LEFT JOIN \".$db_prefix.\"messages_options mo USING(user_id)
            WHERE user_level>='\".$msg_to_group.\"'\"
         );
         if (dbrows($result)) {
            while ($data = dbarray($result)) {
               if ($data['user_id'] != $userdata['user_id']) {
                  $result2 = dbquery(\"INSERT INTO \".$db_prefix.\"messages (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES('\".$data['user_id'].\"','\".$userdata['user_id'].\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','0')\");
                  $send_email = isset($data['pm_email_notify']) ? $data['pm_email_notify'] : $msg_settings['pm_email_notify'];
                  if ($send_email == \"1\") sendemail($data['user_name'],$data['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$data['user_name'].$locale['626']);
               }
            }
         } else {
            fallback(FUSION_SELF.\"?folder=inbox\");
         }
      } else {
         $result = dbquery(
            \"SELECT u.user_id, u.user_name, u.user_email, mo.pm_email_notify FROM \".$db_prefix.\"users u
            LEFT JOIN \".$db_prefix.\"messages_options mo USING(user_id)
            WHERE user_groups REGEXP('^\\\.{$msg_to_group}$|\\\.{$msg_to_group}\\\.|\\\.{$msg_to_group}$')\"
         );
         if (dbrows($result)) {
            while ($data = dbarray($result)) {
               if ($data['user_id'] != $userdata['user_id']) {
                  $result2 = dbquery(\"INSERT INTO \".$db_prefix.\"messages (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES('\".$data['user_id'].\"','\".$userdata['user_id'].\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','0')\");
                  $send_email = isset($data['pm_email_notify']) ? $data['pm_email_notify'] : $msg_settings['pm_email_notify'];
                  if ($send_email == \"1\") sendemail($data['user_name'],$data['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$data['user_name'].$locale['626']);
               }
            }
         } else {
            fallback(FUSION_SELF.\"?folder=inbox\");
         }
      }
   } elseif (isNum($msg_send)) {
      $result = dbquery(
         \"SELECT u.user_id, u.user_name, u.user_email, mo.pm_email_notify, COUNT(message_id) as message_count FROM \".$db_prefix.\"users u
         LEFT JOIN \".$db_prefix.\"messages_options mo USING(user_id)
         LEFT JOIN \".$db_prefix.\"messages ON message_to=u.user_id AND message_folder='0'
         WHERE u.user_id='\".$msg_send.\"' GROUP BY u.user_id\"
      );
      if (dbrows($result)) {
         $data = dbarray($result);
         if ($data['user_id'] != $userdata['user_id']) {
            if ($msg_settings['pm_inbox'] == \"0\" || ($data['message_count'] + 1) <= $msg_settings['pm_inbox']) {
               $result = dbquery(\"INSERT INTO \".$db_prefix.\"messages (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES('\".$data['user_id'].\"','\".$userdata['user_id'].\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','0','\".time().\"','0')\");
               $send_email = isset($data['pm_email_notify']) ? $data['pm_email_notify'] : $msg_settings['pm_email_notify'];
               if ($send_email == \"1\") sendemail($data['user_name'],$data['user_email'],$settings['siteusername'],$settings['siteemail'],$locale['625'],$data['user_name'].$locale['626']);
            } else {
               $error = \"2\";
            }
         }
      } else {
         fallback(FUSION_SELF.\"?folder=inbox\");
      }
   }
   if (!$error) {
      $result =dbquery(
         \"SELECT COUNT(message_id) AS outbox_count, MIN(message_id) AS last_message FROM \".$db_prefix.\"messages
         WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='1' GROUP BY message_to\"
      );
      $cdata = dbarray($result);
      if ($my_settings['pm_save_sent']) {
         if ($msg_settings['pm_sentbox'] != \"0\" && ($cdata['outbox_count'] + 1) > $msg_settings['pm_sentbox']) {
            $result = dbquery(\"DELETE FROM \".$db_prefix.\"messages WHERE message_id='\".$cdata['last_message'].\"' AND message_to='\".$userdata['user_id'].\"'\");
         }
         if (isset($_POST['chk_sendtoall']) && isNum($_POST['msg_to_group'])) {
            $outbox_user = $userdata['user_id'];
         } elseif (isset($msg_send) && isNum($msg_send)) {
            $outbox_user = $msg_send;
         } else {
            $msg_send = \"\";
         }
         if ($msg_send) { $result = dbquery(\"INSERT INTO \".$db_prefix.\"messages (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES ('\".$userdata['user_id'].\"','\".$outbox_user.\"','\".$subject.\"','\".$message.\"','\".$smileys.\"','1','\".time().\"','1')\"); }
      }
   }
   redirect(FUSION_SELF.\"?folder=inbox\".($error ? \"&error=$error\" : \"\"));
}

if (isset($error)) {
   if ($error == \"1\") {
      $message = $locale['629'];
   } elseif ($error == \"2\") {
      $message = $locale['628'];
   } else {
      $message = \"\";
   }
   opentable($locale['627']);
   echo \"
\".$message.\"
\n\";
   closetable();
   tablebreak();
}

if (!isset($msg_send) && !isset($msg_read) && $folder != \"options\") {
   if (!isset($rowstart) || !isNum($rowstart)) $rowstart = 0;
   $bdata = dbarray(dbquery(
      \"SELECT COUNT(IF(message_folder=0, 1, null)) inbox_total,
      COUNT(IF(message_folder=1, 1, null)) outbox_total, COUNT(IF(message_folder=2, 1, null)) archive_total
      FROM \".$db_prefix.\"messages WHERE message_to='\".$userdata['user_id'].\"' GROUP BY message_to\"
   ));
   $bdata['inbox_total'] = isset($bdata['inbox_total']) ? $bdata['inbox_total'] : \"0\";
   $bdata['outbox_total'] = isset($bdata['outbox_total']) ? $bdata['outbox_total'] : \"0\";
   $bdata['archive_total'] = isset($bdata['archive_total']) ? $bdata['archive_total'] : \"0\";
   if ($folder == \"inbox\") {
      $total_rows = $bdata['inbox_total'];
      $result = dbquery(
         \"SELECT m.*, u.user_id, u.user_name FROM \".$db_prefix.\"messages m
         LEFT JOIN \".$db_prefix.\"users u ON m.message_from=u.user_id
         WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='0'
         ORDER BY message_datestamp DESC LIMIT $rowstart,20\"
      );
   } elseif ($folder == \"outbox\") {
      $total_rows = $bdata['outbox_total'];
      $result = dbquery(
         \"SELECT m.*, u.user_id, u.user_name FROM \".$db_prefix.\"messages m
         LEFT JOIN \".$db_prefix.\"users u ON m.message_from=u.user_id
         WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='1'
         ORDER BY message_datestamp DESC LIMIT $rowstart,20\"
      );
   } elseif ($folder == \"archive\") {
      $total_rows = $bdata['archive_total'];
      $result = dbquery(
         \"SELECT m.*, u.user_id, u.user_name FROM \".$db_prefix.\"messages m
         LEFT JOIN \".$db_prefix.\"users u ON m.message_from=u.user_id
         WHERE message_to='\".$userdata['user_id'].\"' AND message_folder='2'
         ORDER BY message_datestamp DESC LIMIT $rowstart,20\"
      );
   }
   opentable($locale['400']);
   if ($total_rows) echo \"\n\";
   echo \"\n\";
   echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n
\".$locale['401'].\"\".$locale['402'].\" [\".$bdata['inbox_total'].\"/\".$msg_settings['pm_inbox'].\"]\".$locale['403'].\" [\".$bdata['outbox_total'].\"/\".$msg_settings['pm_sentbox'].\"]\".$locale['404'].\" [\".$bdata['archive_total'].\"/\".$msg_settings['pm_savebox'].\"]\".$locale['425'].\"
\n\";
   if ($total_rows) {
      echo \"\n\";
      echo \"\n\n\";
      echo \"\n\";
      echo \"\n\n\";
      while ($data = dbarray($result)) {
         $message_subject = $data['message_subject'];
         if (!$data['message_read']) $message_subject = \"\".$message_subject.\"\";
         echo \"\n\n\";
         echo \"\n\";
         echo \"\n\n\";
      }
      echo \"
\".$locale['405'].\"\".($folder != \"outbox\" ? $locale['406'] : $locale['421']).\"\".$locale['407'].\"
\n\";
         echo \"\".$message_subject.\"
\".$data['user_name'].\"\".showdate(\"shortdate\", $data['message_datestamp']).\"
\n\";
      
      echo \"\n\";
      echo \"\n\n\";
      echo \"\n\n
>\".$locale['410'].\" |\n\";
      echo \">\".$locale['411'].\"
\".$locale['409'].\"\n\";
      if ($folder == \"inbox\") echo \"\n\";
      if ($folder == \"archive\") echo \"\n\";
      echo \"\n\";
      echo \"\n\";
      echo \"\n\";
      echo \"
\n\n\";
   } else {
      echo \"

\".$locale['461'].\"

\";
   }
   echo \"\n\";
   closetable();
   if ($total_rows > 20) echo \"
\n\".makePageNav($rowstart,20,$total_rows,3,FUSION_SELF.\"?folder=$folder&\").\"\n
\n\";
} elseif ($folder == \"options\") {
   $result = dbquery(\"SELECT * FROM \".$db_prefix.\"messages_options WHERE user_id='\".$userdata['user_id'].\"'\");
   if (dbrows($result)) {
      $my_settings = dbarray($result);
      $update_type = \"update\";
   } else {
      $my_settings['pm_save_sent'] = 0;
      $my_settings['pm_email_notify'] = 0;
      $update_type = \"insert\";
   }
   $bdata = dbarray(dbquery(
      \"SELECT COUNT(IF(message_folder=0, 1, null)) inbox_total,
      COUNT(IF(message_folder=1, 1, null)) outbox_total, COUNT(IF(message_folder=2, 1, null)) archive_total
      FROM \".$db_prefix.\"messages WHERE message_to='\".$userdata['user_id'].\"' GROUP BY message_to\"
   ));
   $bdata['inbox_total'] = isset($bdata['inbox_total']) ? $bdata['inbox_total'] : \"0\";
   $bdata['outbox_total'] = isset($bdata['outbox_total']) ? $bdata['outbox_total'] : \"0\";
   $bdata['archive_total'] = isset($bdata['archive_total']) ? $bdata['archive_total'] : \"0\";
   opentable($locale['400']);
   echo \"\n\";
   echo \"\n\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n
\".$locale['401'].\"\".$locale['402'].\" [\".$bdata['inbox_total'].\"/\".$msg_settings['pm_inbox'].\"]\".$locale['403'].\" [\".$bdata['outbox_total'].\"/\".$msg_settings['pm_sentbox'].\"]\".$locale['404'].\" [\".$bdata['archive_total'].\"/\".$msg_settings['pm_savebox'].\"]\".$locale['425'].\"
\n\";
   tablebreak();
   echo \"
\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\";
   echo \"\n\n\";
   echo \"
\".$locale['621'].\"
\".$locale['622'].\"
\n\";
   echo \"
\n\";
   echo \"
\n\";
   closetable();
} elseif ((isset($msg_read) && isNum($msg_read)) && ($folder == \"inbox\" || $folder == \"archive\" || $folder == \"outbox\")) {
   $result = dbquery(
      \"SELECT m.*, u.user_id, u.user_name FROM \".$db_prefix.\"messages m
      LEFT JOIN \".$db_prefix.\"users u ON m.message_from=u.user_id
      WHERE message_to='\".$userdata['user_id'].\"' AND message_id='$msg_read'\"
   );
   if (dbrows($result)) {
      $data = dbarray($result);
      $result = dbquery(\"UPDATE \".$db_prefix.\"messages SET message_read='1' WHERE message_id='\".$data['message_id'].\"'\");
      $message_message = $data['message_message'];
      if ($data['message_smileys'] == \"y\") $message_message = parsesmileys($message_message);
      opentable($locale['431']);
      echo \"
\n\";
      echo \"\n\n\";
      echo \"\n\";
      echo \"\n\n\";
      echo \"\n\n\";
      echo \"\n\n\";
      echo \"\n\n\";
      echo \"\n\n\";
      echo \"\n\n\n\";
      echo \"
\".($folder != \"outbox\" ? $locale['406'] : $locale['421']).\"\".$data['user_name'].\"
\".$locale['407'].\"\".showdate(\"longdate\", $data['message_datestamp']).\"
\".$locale['405'].\"\".$data['message_subject'].\"
\".nl2br(parseubb($message_message)).\"
\n\";
      echo \"\n\";
      echo \"\n\n\";
      echo \"\n\n
\".$locale['432'].\"\n\";
      if ($folder == \"inbox\" && $data['message_folder'] == 0) echo \"\n\";
      if ($folder == \"inbox\" && $data['message_folder'] == 0) echo \"\n\";
      if ($folder == \"archive\" && $data['message_folder'] == 2) echo \"\n\";
      echo \"\n\";
      echo \"
\n
\n\";
      closetable();
   } else {
      fallback(FUSION_SELF);
   }
} elseif (isset($msg_send) && isNum($msg_send)) {
   if (isset($_POST['send_preview'])) {
      $subject = stripinput($_POST['subject']);
      $message = stripinput($_POST['message']);
      $message_preview = $message;
      if (isset($_POST['chk_sendtoall']) && isNum($_POST['msg_to_group'])) {
         $msg_to_group = $_POST['msg_to_group'];
         $sendtoall_chk = \" checked\";
         $msg_to_group_state = \"\";
         $msg_send_state = \" disabled\";
      } else {
         $sendtoall_chk = \"\";
         $msg_to_group_state = \" disabled\";
         $msg_send_state = \"\";
      }
      $disablesmileys_chk = isset($_POST['chk_disablesmileys']) ? \" checked\" : \"\";
      if (!$disablesmileys_chk) $message_preview = parsesmileys($message_preview);
      opentable($locale['438']);
      echo \"\n\n\";
      echo \"\n\n\";
      echo \"
\".nl2br(parseubb($message_preview)).\"
\n\";
      closetable();
   } else {
      $subject = \"\"; $message = \"\"; $msg_send_state = \"\"; $msg_to_group = \"\";
      $msg_to_group_state = \" disabled\"; $sendtoall_chk = \"\"; $disablesmileys_chk = \"\";   
   }   
   
   if (isset($msg_id) && isNum($msg_id)) {
      $result = dbquery(
         \"SELECT m.*, u.user_id, u.user_name FROM \".$db_prefix.\"messages m
         LEFT JOIN \".$db_prefix.\"users u ON m.message_from=u.user_id
         WHERE message_to='\".$userdata['user_id'].\"' AND message_id='$msg_id'\"
      );
      $data = dbarray($result);
      $msg_send = $data['user_id'];
      if ($subject == \"\") $subject = (!strstr($data['message_subject'], \"RE: \") ? \"RE: \" : \"\").$data['message_subject'];
      $reply_message = $data['message_message'];
      if ($data['message_smileys'] == \"y\") $reply_message = parsesmileys($reply_message);
   } else {
      $reply_message = \"\";
   }
      
   if (!isset($_POST['chk_sendtoall']) || $msg_send != \"0\") {
      $user_list = \"\"; $user_types = \"\"; $sel = \"\";
      $result = dbquery(\"SELECT u.user_id, u.user_name FROM \".$db_prefix.\"users u ORDER BY user_level DESC, user_name ASC\");
      while ($data = dbarray($result)) {
         if ($data['user_id'] != $userdata['user_id']) {
            $sel = ($msg_send == $data['user_id'] ? \" selected\" : \"\");
            $user_list .= \"\n\";
         }
      }
   }

   if ($msg_send == 0) { $user_list .= \"\n\"; }
   
   if (iADMIN && !isset($msg_id)) {
      $user_groups = getusergroups();
      while(list($key, $user_group) = each($user_groups)){
         if ($user_group['0'] != \"0\") {
            $sel = ($msg_to_group == $user_group['0'] ? \" selected\" : \"\");
            $user_types .= \"\n\";
         }
      }
   }

   opentable($locale['420']);
   echo \"
\n\";
   echo \"\n\";
   echo \"\n\n\";
   if ($msg_send == \"0\") {
      echo \"\n\n\";
   echo \"\n\n\";
   echo \"\n\n\";
   if ($reply_message) {
      echo \"\n\n\";
      echo \"\n\n\";
   }
   echo \"\n\n\";
   echo \"\n\n\";
   echo \"\n\n\n\n\";
   echo \"\n\n\";
   echo \"\n\n\";
   echo \"
\".$locale['421'].\":\n\";
   } else {
      $udata = dbarray(dbquery(\"SELECT u.user_id, u.user_name FROM \".$db_prefix.\"users u WHERE user_id='$msg_send'\"));
      echo \"
\n\";
      echo \"\".$udata['user_name'].\"\n\";
   }
   if (iADMIN && !isset($msg_id)) {
      echo \"\n\";
      echo \"\".$locale['434'].\": \n\";
   }
   echo \"
\".$locale['405'].\":
\".$locale['422'].\":\".nl2br(parseubb($reply_message)).\"
\".($reply_message ? $locale['433'] : $locale['422']).\":
\n\";
   echo \">', '');\\">\n\";
   echo \">');\\">\n\";
   echo \">', '');\\">\n\";
   echo \">\n\";
   echo \">\n\";
   echo \">\n\";
   echo \">\n\";
   echo \">', '');\\">\n\";
   echo \">
Download source  Code
', '


');\\">\n\";
   echo \">', '');\\">

\n\";
   echo displaysmileys(\"message\").\"
\".$locale['425'].\":\n\".$locale['427'].\"
\n\";
   echo \"\n\";
   echo \"\n\n\";
   echo \"\n\n\";
   echo \"
\".$locale['435'].\"\n\n\";
   echo \"\n
\n
\n\";
   closetable();
   echo \"\n\";

} else {
   fallback(FUSION_SELF);
}

require_once \"side_right.php\";
require_once \"footer.php\";
?>


 
PM
Peršokti į forumą: