API tools faq
paste
Advertisement
Faguss

UserSpice messages.php with Brandin's patch

Faguss
Jul 5th, 2017
316
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 15.87 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /*
  3. UserSpice 4
  4. An Open Source PHP User Management System
  5. by the UserSpice Team at http://UserSpice.com
  6.  
  7. This program is free software: you can redistribute it and/or modify
  8. it under the terms of the GNU General Public License as published by
  9. the Free Software Foundation, either version 3 of the License, or
  10. (at your option) any later version.
  11.  
  12. This program is distributed in the hope that it will be useful,
  13. but WITHOUT ANY WARRANTY; without even the implied warranty of
  14. MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  15. GNU General Public License for more details.
  16.  
  17. You should have received a copy of the GNU General Public License
  18. along with this program.  If not, see <http://www.gnu.org/licenses/>.
  19. */
  20. ?>
  21. <?php
  22. require_once '../users/init.php';
  23. require_once $abs_us_root.$us_url_root.'users/includes/header.php';
  24. require_once $abs_us_root.$us_url_root.'users/includes/navigation.php';
  25. ?>
  26.  
  27. <?php if (!securePage($_SERVER['PHP_SELF'])){die();}
  28. if($settings->messaging != 1){
  29.   Redirect::to('account.php?err=Messaging+is+disabled');
  30. }
  31. $validation = new Validate();
  32. $errors = [];
  33. $successes = [];
  34. $exempt = $db->query("SELECT msg_exempt FROM settings")->first()->msg_exempt;
  35.    
  36. if (strlen($exempt) == 0)
  37.     $exempt = 0;
  38.    
  39. $userData = $db->query("SELECT id, username FROM users WHERE id NOT IN ($exempt) AND id!={$user->data()->id}")->results();
  40. ?>
  41. <?php
  42. if (!empty($_POST)) {
  43.   //Delete User Checkboxes
  44.   if (!empty($_POST['archive'])){
  45.     $deletions = $_POST['archive'];
  46.     if ($deletion_count = archiveThreads($deletions,$user->data()->id,1)){
  47.       $successes[] = lang("MESSAGE_ARCHIVE_SUCCESSFUL", array($deletion_count));
  48.     }
  49.     else {
  50.       $errors[] = lang("SQL_ERROR");
  51.     }
  52.   }
  53.   if (!empty($_POST['unarchive'])){
  54.     $deletions = $_POST['unarchive'];
  55.     if ($deletion_count = archiveThreads($deletions,$user->data()->id,0)){
  56.       $successes[] = lang("MESSAGE_UNARCHIVE_SUCCESSFUL", array($deletion_count));
  57.     }
  58.     else {
  59.       $errors[] = lang("SQL_ERROR");
  60.     }
  61.   }
  62. if(!empty($_POST['send_message'])){
  63.    
  64.     if (empty(Input::get('user_id'))) {
  65.     $errors[] = "Unknown recipient"; }
  66.  
  67.     if (strlen(Input::get('msg_body')) == 0) {
  68.     $errors[] = "Message cannot be empty"; }
  69.    
  70.   $date = date("Y-m-d H:i:s");
  71.  
  72.   $thread = array(
  73.     'msg_from'    => $user->data()->id,
  74.     'msg_to'      => Input::get('user_id'),
  75.     'msg_subject' => Input::get('msg_subject'),
  76.     'last_update' => $date,
  77.     'last_update_by' => $user->data()->id,
  78.   );
  79.     if (empty($errors)) {
  80.     $db->insert('message_threads',$thread); }
  81.   $newThread = $db->lastId();
  82.  
  83.  
  84.   $fields = array(
  85.     'msg_from'    => $user->data()->id,
  86.     'msg_to'      => Input::get('user_id'),
  87.     'msg_body'    => Input::get('msg_body'),
  88.     'msg_thread'  => $newThread,
  89.     'sent_on'     => $date,
  90.   );
  91.  
  92.     if (empty($errors)) {
  93.   $db->insert('messages',$fields);
  94.  
  95.     $successes[] = "Your message has been sent!"; }
  96. }
  97.  
  98. if(!empty($_POST['send_mass_message'])){
  99.   $date = date("Y-m-d H:i:s");
  100.  
  101.  
  102.     foreach($userData as $v1) {
  103.   $thread = array(
  104.     'msg_from'    => $user->data()->id,
  105.     'msg_to'      => $v1->id,
  106.     'msg_subject' => Input::get('msg_subject'),
  107.     'last_update' => $date,
  108.     'last_update_by' => $user->data()->id,
  109.   );
  110.   $db->insert('message_threads',$thread);
  111.   $newThread = $db->lastId();
  112.  
  113.  
  114.   $fields = array(
  115.     'msg_from'    => $user->data()->id,
  116.     'msg_to'      => $v1->id,
  117.     'msg_body'    => Input::get('msg_body'),
  118.     'msg_thread'  => $newThread,
  119.     'sent_on'     => $date,
  120.   );
  121.  
  122.   $db->insert('messages',$fields);
  123.     }
  124.  
  125.   $successes[] = "Your mass message has been sent!";
  126. } }
  127. $messagesQ = $db->query("SELECT * FROM message_threads WHERE msg_to = ? OR msg_from = ? ORDER BY last_update DESC",array($user->data()->id,$user->data()->id));
  128. $messages = $messagesQ->results();
  129. $messagesCount = $messagesQ->count();
  130. $archiveCount = $db->query("SELECT id FROM message_threads WHERE msg_from = ? AND archive_from = ?",array($user->data()->id,1));
  131. $archiveCountCount = $archiveCount->count();
  132. $archiveCount2 = $db->query("SELECT id FROM message_threads WHERE msg_to = ? AND archive_to = ?",array($user->data()->id,1));
  133. $archiveCountCount2 = $archiveCount2->count();
  134. $count = $messagesCount - $archiveCountCount - $archiveCountCount2;
  135. ?>
  136. <div id="page-wrapper">
  137.  
  138. <div class="container">
  139.  
  140. <?=resultBlock($errors,$successes);?>
  141. <?=$validation->display_errors();?>
  142.  
  143.  
  144. <div class="row">
  145.       <div class="col-sm-12">
  146.         <div class="row" id="maindiv">
  147.           <div>
  148.         <h1><?php if (checkMenu(2,$user->data()->id)){  ?><div class="btn-group pull-left"><button type="button" class="btn btn-info" data-toggle="modal" data-target="#composemass"><i class="glyphicon glyphicon-plus"></i> New Mass Message</button></div><?php } ?> <center>Conversations <div class="btn-group pull-right"><button type="button" class="btn btn-info" data-toggle="modal" data-target="#compose"><i class="glyphicon glyphicon-plus"></i> New Message</button></div></center></h1>
  149.       </div>
  150.         <?php if($count > 0) {?><label><input type="checkbox" id="checkall" value="1"
  151.         onclick="checkCheckboxes(this.id, 'maindiv');" >
  152.         [ check/uncheck all ]</label><?php } ?>
  153.       <form name="threads" action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
  154.         <center><table class="table table-striped">
  155.           <thead>
  156.             <tr>
  157.               <th></th>
  158.               <th></th>
  159.             </tr>
  160.           </thead>
  161.           <tbody>
  162.             <tr>
  163.             <?php if($count > 0) {?>
  164.               <?php foreach($messages as $m){ ?>
  165.               <?php
  166.               if($m->msg_from == $user->data()->id) { if($m->archive_from == 0) { $archived = 0; } else { $archived = 1; } } else { if($m->archive_to == 0) { $archived = 0; } else { $archived = 1; }}
  167.               if($archived == 0) {
  168.             if($m->msg_from == $user->data()->id) { $findId = $m->msg_to; } else { $findId = $m->msg_from; }
  169.             $findUser = $db->query("SELECT picture,email FROM users WHERE id = $findId");
  170.             $foundUser = $findUser->first();
  171.              $grav = empty($foundUser->picture) ? get_gravatar(strtolower(trim($foundUser->email))) : $foundUser->picture; ?>
  172.             <?php $lastmessage = strtotime($m->last_update);
  173.                 $difference = ceil((time() - $lastmessage) / (60 * 60 * 24));
  174.                 // if($difference==0) { $last_update = "Today, "; $last_update .= date("g:i A",$lastmessage); }
  175.                 if($difference >= 0 && $difference < 7) {
  176.                     $today = date("j");
  177.                     $last_message = date("j",$lastmessage);
  178.                     if($today==$last_message) { $last_update = "Today, "; $last_update .= date("g:i A",$lastmessage); }
  179.                     else {
  180.                 $last_update = date("l g:i A",$lastmessage); } }
  181.                 elseif($difference >= 7) { $last_update = date("M j, Y g:i A",$lastmessage); }
  182.                 $replies = $db->query("SELECT COUNT(*) AS count FROM messages WHERE msg_thread = ? GROUP BY msg_thread",array($m->id));
  183.                 $repliescount = $replies->count();
  184.                 ?>
  185.                 <td style="width:100px">
  186.                     <center>
  187.                         <span class="chat-img pull-left" style="padding-right:5px">
  188.                             <a class="nounderline" href="message.php?id=<?=$m->id?>">
  189.                                 <img src="<?=$grav ?>" width="75" class="img-thumbnail">
  190.                             </a>
  191.                         </span>
  192.                     </center>
  193.                 </td>
  194.                 <td class="pull-left">
  195.                     <h4>
  196.                         <input type="checkbox" name="archive[<?=$m->id?>]" value="<?=$m->id?>"/>
  197.                         <a class="nounderline" href="message.php?id=<?=$m->id?>">  
  198.                             <?=$m->msg_subject?> - with <?php if($m->msg_from == $user->data()->id) { echouser($m->msg_to); } else { echouser($m->msg_from); } ?>
  199.                         </a>
  200.                         <?php $unread = $db->query("SELECT * FROM messages WHERE msg_thread = ? AND msg_to = ? AND msg_read = ?",array($m->id,$user->data()->id,0));
  201.                                 $unreadCount = $unread->count();?>
  202.                     <?php if($unreadCount > 0) {?> - <font color="red"><?=$unreadCount?> New Message<?php if($unreadCount > 1) {?>s<?php } ?></font><?php } ?></h4>
  203.                     <a class="nounderline" href="message.php?id=<?=$m->id?>">
  204.                         Updated <?=$last_update?> by <?php echouser($m->last_update_by);?>
  205.                     </a>
  206.             </tr>
  207.             <?php } } } else {?>
  208.             <td colspan="2"><center><h3>No Conversations</h3></center></td></tr>
  209.             <?php } ?>
  210.               </tbody>
  211.             </table></center>
  212.             <?php if($count > 0) {?><div class="btn-group pull-right"><input class='btn btn-danger' type='submit' name='Submit' value='Archive Selected Threads' /></div><?php } ?>
  213.                 </form>
  214.                 <br /><?php if(($archiveCountCount + $archiveCountCount2) > 0) {?><center><a href="#" data-toggle="modal" data-target="#archived">View Archived Threads</a></center><?php } ?>
  215.             </div><!-- End of main content section --><br />
  216.           </div> <!-- /.col -->
  217.          
  218. <div id="compose" class="modal fade" role="dialog">
  219.   <div class="modal-dialog">
  220.  
  221.     <!-- Modal content-->
  222.     <div class="modal-content">
  223.       <div class="modal-header">
  224.         <button type="button" class="close" data-dismiss="modal">&times;</button>
  225.         <h4 class="modal-title">New Message</h4>
  226.       </div>
  227.       <div class="modal-body">
  228. <form name="create_message" action="messages.php" method="post">
  229.  
  230.                 <label>Select a user:</label>
  231.                 <select name="user_id" id="combobox" class="form-control combobox" required>
  232.                 <option readonly></option>
  233.                 <?php
  234.                 foreach($userData as $v1) {?>
  235.                 <option value="<?=$v1->id;?>"><?=$v1->username;?></option>
  236.                 <?php } ?>
  237.                 </select><br />
  238.               <label>Subject:</label>
  239.                 <input required size='100' class='form-control' type='text' name='msg_subject' value='' required/>
  240.                 <br /><label>Body:</label>
  241.                 <textarea rows="20" cols="80"  id="mytextarea" name="msg_body"></textarea>
  242.                 <input required type="hidden" name="csrf" value="<?=Token::generate();?>" >
  243.               </p>
  244.               <p>
  245.                   <br />
  246.       </div>
  247.       <div class="modal-footer">
  248.       <div class="btn-group">   <input type="hidden" name="csrf" value="<?=Token::generate();?>" />
  249.     <input class='btn btn-primary' type='submit' name="send_message" value='Send Message' class='submit' /></div>
  250.     </form>
  251.          <div class="btn-group"><button type="button" class="btn btn-default" data-dismiss="modal">Close</button></div>
  252.       </div>
  253.     </div>
  254.     </div>
  255.   </div>
  256.  
  257.   <div id="archived" class="modal fade" role="dialog">
  258.   <div class="modal-dialog">
  259.  
  260.     <!-- Modal content-->
  261.     <div class="modal-content">
  262.       <div class="modal-header">
  263.         <button type="button" class="close" data-dismiss="modal">&times;</button>
  264.         <h4 class="modal-title">Archived Threads</h4>
  265.       </div>
  266.       <div class="modal-body" id="archivediv">
  267.       <?php $messagesQ2 = $db->query("SELECT * FROM message_threads WHERE (msg_to = ? OR msg_from = ?) AND (archive_to = ? OR archive_from = ?) ORDER BY last_update DESC",array($user->data()->id,$user->data()->id,1,1));
  268.             $messages2 = $messagesQ2->results();
  269.             $messagesCount2 = $messagesQ2->count(); ?>
  270.             <?php if($messagesCount2 > 0) {?><label><input type="checkbox" id="checkall" value="1"
  271.         onclick="checkCheckboxes(this.id, 'archivediv');" >
  272.         [ check/uncheck all ]</label><?php } ?>
  273. <form name="uthreads" action="<?php echo $_SERVER['PHP_SELF'];?>" method="post">
  274.         <center><table class="table table-striped">
  275.           <thead>
  276.             <tr>
  277.               <th></th>
  278.               <th></th>
  279.             </tr>
  280.           </thead>
  281.           <tbody>
  282.             <tr>
  283.             <?php if($messagesCount2 > 0) {?>
  284.               <?php foreach($messages2 as $m2){ ?>
  285.               <?php
  286.             if($m2->msg_from == $user->data()->id) { $findId = $m2->msg_to; } else { $findId = $m2->msg_from; }
  287.             $findUser = $db->query("SELECT picture,email FROM users WHERE id = $findId");
  288.             $foundUser = $findUser->first();
  289.             $grav = empty($foundUser->picture) ? get_gravatar(strtolower(trim($foundUser->email))) : $foundUser->picture; ?>
  290.             <?php $lastmessage = strtotime($m2->last_update);
  291.                 $difference = ceil((time() - $lastmessage) / (60 * 60 * 24));
  292.                 // if($difference==0) { $last_update = "Today, "; $last_update .= date("g:i A",$lastmessage); }
  293.                 if($difference >= 0 && $difference < 7) {
  294.                     $today = date("j");
  295.                     $last_message = date("j",$lastmessage);
  296.                     if($today==$last_message) { $last_update = "Today, "; $last_update .= date("g:i A",$lastmessage); }
  297.                     else {
  298.                 $last_update = date("l g:i A",$lastmessage); } }
  299.                 elseif($difference >= 7) { $last_update = date("M j, Y g:i A",$lastmessage); }
  300.                 $replies = $db->query("SELECT COUNT(*) AS count FROM messages WHERE msg_thread = ? GROUP BY msg_thread",array($m2->id));
  301.                 $repliescount = $replies->count();
  302.                 ?>
  303.                 <td style="width:100px">
  304.                     <center>
  305.                         <span class="chat-img pull-left" style="padding-right:5px">
  306.                             <a class="nounderline" href="message.php?id=<?=$m2->id?>">
  307.                                 <img src="<?=$grav ?>" width="75" class="img-thumbnail">
  308.                             </a>
  309.                         </span>
  310.                     </center>
  311.                 </td>
  312.                 <td class="pull-left">
  313.                     <h4>
  314.                         <input type="checkbox" name="unarchive[<?=$m2->id?>]" value="<?=$m2->id?>"/>
  315.                         <a class="nounderline" href="message.php?id=<?=$m2->id?>">  
  316.                             <?=$m2->msg_subject?> - with <?php if($m2->msg_from == $user->data()->id) { echouser($m2->msg_to); } else { echouser($m2->msg_from); } ?>
  317.                         </a>
  318.                     </h4>
  319.                     <a class="nounderline" href="message.php?id=<?=$m2->id?>">
  320.                         Updated <?=$last_update?> by <?php echouser($m2->last_update_by);?>
  321.                     </a>
  322.             </tr>
  323.             <?php } } else {?>
  324.             <td colspan="2"><center><h3>No Archived Conversations</h3></center></td></tr>
  325.             <?php } ?>
  326.               </tbody>
  327.             </table></center>
  328.                   <br />
  329.       </div>
  330.       <div class="modal-footer">
  331.       <div class="btn-group">   <input type="hidden" name="csrf" value="<?=Token::generate();?>" />
  332.     <input class='btn btn-primary' type='submit' name="Submit" value='Unarchive Selected Threads' class='submit' /></div>
  333.     </form>
  334.          <div class="btn-group"><button type="button" class="btn btn-default" data-dismiss="modal">Close</button></div>
  335.       </div>
  336.     </div>
  337.     </div>
  338.   </div>
  339.  
  340.   <div id="composemass" class="modal fade" role="dialog">
  341.   <div class="modal-dialog">
  342.  
  343.     <!-- Modal content-->
  344.     <div class="modal-content">
  345.       <div class="modal-header">
  346.         <button type="button" class="close" data-dismiss="modal">&times;</button>
  347.         <h4 class="modal-title">New Mass Message</h4>
  348.       </div>
  349.       <div class="modal-body">
  350. <form name="create_mass_message" action="messages.php" method="post">
  351.  
  352.               <label>Subject:</label>
  353.                 <input required size='100' class='form-control' type='text' name='msg_subject' value='' required/>
  354.                 <br /><label>Body:</label>
  355.                 <textarea rows="20" cols="80"  id="mytextarea2" name="msg_body"></textarea>
  356.                 <input required type="hidden" name="csrf" value="<?=Token::generate();?>" >
  357.               </p>
  358.               <p>
  359.                   <br />
  360.       </div>
  361.       <div class="modal-footer">
  362.       <div class="btn-group">   <input type="hidden" name="csrf" value="<?=Token::generate();?>" />
  363.     <input class='btn btn-primary' type='submit' name="send_mass_message" value='Send Message' class='submit' /></div>
  364.     </form>
  365.          <div class="btn-group"><button type="button" class="btn btn-default" data-dismiss="modal">Close</button></div>
  366.       </div>
  367.     </div>
  368.     </div>
  369.   </div>
  370.          
  371.         </div> <!-- /.row -->
  372.       </div> <!-- /.container -->
  373.     </div> <!-- /.wrapper -->
  374.  
  375.  
  376.     <!-- footers -->
  377.     <?php require_once $abs_us_root.$us_url_root.'users/includes/page_footer.php'; // the final html footer copyright row + the external js calls ?>
  378.  
  379.     <!-- Place any per-page javascript here -->
  380.     <script src='https://cdn.tinymce.com/4/tinymce.min.js'></script>
  381.     <script src="../usersc/js/bootstrap-combobox.js"></script>
  382.     <script src="../usersc/js/messages.php.js"></script>
  383.  
  384.     <?php require_once $abs_us_root.$us_url_root.'users/includes/html_footer.php'; // currently just the closing /body and /html ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!