$figure = "";

opentable($locale['figure_510']);

if (!isset($_GET['action']) || $_GET['action'] == "1") {

   if (isset($_GET['delete']) && isnum($_GET['delete'])) {

      $result = dbquery("SELECT submit_criteria, submit_user FROM ".DB_FIGURE_SUBMISSIONS." WHERE submit_id='".$_GET['delete']."'");

      if (dbrows($result)) {

         $datab = dbarray($result);

         $data = unserialize($datab['submit_criteria']);

         if (!empty($data['figure_image']) && file_exists(IMAGES_FIGURE.$data['figure_image'])) { unlink(IMAGES_FIGURE.$data['figure_image']); }

         if (!empty($data['figure_file']) && file_exists(FIGURES.$data['figure_file'])) { @unlink(FIGURES.$data['figure_file']); }

         $result = dbquery("DELETE FROM ".DB_FIGURE_SUBMISSIONS." WHERE submit_id='".$_GET['delete']."'");

         require_once(INCLUDES."infusions_include.php");

         send_pm($datab['submit_user'], $userdata['user_id'], $locale['figure_530'], $locale['figure_531']);

         echo "<br /><div style='text-align:center'>".$locale['figure_501']."<br /><br />\n";

         echo "<a href='".FUSION_SELF.$aidlink."'>".$locale['figure_502']."</a><br /><br />\n";

         echo "<a href='../figure_admin.php".$aidlink."'>".$locale['figure_503']."</a></div><br />\n";

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $result = dbquery("SELECT submit_id, submit_criteria FROM ".DB_FIGURE_SUBMISSIONS." ORDER BY submit_datestamp DESC");

      if (dbrows($result)) {

         while ($data = dbarray($result)) {

            $submit_criteria = unserialize($data['submit_criteria']);

            $figure .= "<tr>\n<td class='tbl1'>".$submit_criteria['figure_title']."</td>\n";

            $figure .= "<td align='right' width='1%' class='tbl1' style='white-space:nowrap'><span class='small'><a href='".FUSION_SELF.$aidlink."&amp;action=2&amp;submit_id=".$data['submit_id']."'>".$locale['figure_517']."</a></span> |\n";

            $figure .= "<span class='small'><a href='".FUSION_SELF.$aidlink."&amp;delete=".$data['submit_id']."'>".$locale['figure_131']."</a></span></td>\n</tr>\n";

         }

      } else {

         $figure = "<tr>\n<td colspan='2' class='tbl1'>".$locale['figure_515']."</td>\n</tr>\n";

      }

      

      echo "<table cellpadding='0' cellspacing='1' width='400' class='tbl-border center'>\n<tr>\n";

      echo "<td colspan='2' class='tbl2'><a id='figure_submissions' name='figure_submissions'></a>\n".$locale['figure_512']."</td>\n";

      echo "</tr>\n".$figure."</table>\n";

   }

}

if ((isset($_GET['action']) && $_GET['action'] == "2")) {

   if (isset($_POST['publish']) && (isset($_GET['submit_id']) && isnum($_GET['submit_id']))) {

      $result = dbquery(

         "SELECT ts.*, tu.user_id, tu.user_name FROM ".DB_FIGURE_SUBMISSIONS." ts

         LEFT JOIN ".DB_USERS." tu ON ts.submit_user=tu.user_id

         WHERE submit_id='".$_GET['submit_id']."'"

      );

      if (dbrows($result)) {

         $data = dbarray($result);

         $datab = unserialize($data['submit_criteria']);

         if (isset($_POST['del_image'])) {

            if (!empty($datab['figure_image']) && file_exists(IMAGES_FIGURE.$datab['figure_image'])) { unlink(IMAGES_FIGURE.$datab['figure_image']); }

            $figure_image = "";

         } else {

            $figure_image = $datab['figure_image'];

         }

         $figure_title = stripinput($_POST['figure_title']);

require_once INCLUDES."sendmail_include.php";



      $subject = "Hinweis: Anftrag";



      $nachricht = sprintf("Es wurde ein Antrag gestellt.<br />");



      $nachricht .= sprintf("Warte auf Antwort.<br />");



      $query = dbquery("INSERT INTO ".DB_MESSAGES." (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES ('1', '".$userdata['user_id']."', '".$subject."', '".$nachricht."', 'n', '0', '".time()."', '0')");

require_once INCLUDES."sendmail_include.php";

      $subject = "Hinweis: Anftrag";

      $nachricht = sprintf("Es wurde ein Antrag gestellt.<br />");

      $nachricht .= sprintf("Warte auf Antwort.<br />");

      $query = dbquery("INSERT INTO ".DB_MESSAGES." (message_to, message_from, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES ('1', '".$userdata['user_id']."', '".$subject."', '".$nachricht."', 'n', '0', '".time()."', '0')");

send_pm(-103, 1, "Figure Submission", "Figure Submission is done", "y", true);

         require_once(INCLUDES."infusions_include.php");

###### PN an User ID 1 von User ID 2 inc. PN Ausgang bei User ID 2

         send_pm('1', '2', 'Ich bin ein Test', 'Hallo Test V9');



###### PN an User ID 1 von User ID 2 Ohne PN in Ausgang bei User ID 2

      $query2 = dbquery("INSERT INTO ".DB_MESSAGES." (message_to, message_from, message_user, message_subject, message_message, message_smileys, message_read, message_datestamp, message_folder) VALUES ('1', '2', '1', 'Ich bin ein Test 1', 'Ich bin ein Test 1', 'n', '0', '".time()."', '0')");

if (!function_exists('send_pm')) {

   /**

    * Send PM to a user or group

    *

    * @param        $to - Recepient Either group_id or user_id

    * @param        $from - Sender's user id

    * @param        $subject - Message subject

    * @param        $message - Message body

    * @param string $smileys - use smileys or not

    * @param bool   $to_group - set to true if sending to the entire user group's members

    */

   function send_pm($to, $from, $subject, $message, $smileys = "y", $to_group = false) {

      \PHPFusion\PrivateMessages::send_pm($to, $from, $subject, $message, $smileys, $to_group);

   }

}