function archiv()
{
    global $db, $game;
    global $page, $perpage, $start;
    global $archStat;
    $messageList = $db->query('SELECT m.time, m.sender, m.subject, m.id,u.user_name FROM (message_archiv m) LEFT JOIN (user u) on u.user_id=m.sender WHERE (m.receiver = "' . $game->player['user_id'] . '") ORDER BY m.time DESC LIMIT ' . $start . ', ' . $perpage);
    $game->out('<form method="post" action="' . parse_link('a=messages&a2=archiv&aremove=1') . '" name="archmessages">
<table width="90%" border="0" cellpadding="2" cellspacing="2" class="style_outer">
  <tr>
    <td>
      <table width="100%" border="0" cellpadding="0" cellspacing="0"  class="style_inner">
        <tr>
          <td width="2%"></td>
          <td width="30%"><b>' . constant($game->sprache("TEXT24")) . '</b></td>
          <td width="45%"><b>' . constant($game->sprache("TEXT27")) . '</b></td>
          <td width="19%"><b>' . constant($game->sprache("TEXT26")) . '</b></td>
          <td width="5%"><input name="check1" type="checkbox" onClick="flevToggleCheckboxes(\'archmessages\',true,false)"></td>
          <td width="2%"></td>
        <tr>
        <tr>
          <td height="6" colspan="6"></td>
        </tr>');
    if ($archStat['messages'] == 0) {
        $game->out('
        <tr>
          <td width="2%"></td>
          <td colspan="4"><i>' . constant($game->sprache("TEXT10")) . '</i></td>
          <td width="2%"></td>
        </tr>');
    } else {
        for ($i = 0; ($message = $db->fetchrow($messageList)) == true; $i++) {
            if ($message['sender'] == 0) {
                $userName = '******' . constant($game->sprache("TEXT11")) . '</b>';
            } else {
                if ($message['sender'] == SUPPORTUSER) {
                    $userName = '******' . constant($game->sprache("TEXT12")) . '</font></b>';
                } else {
                    if (!isset($message['user_name'])) {
                        $userName = '******' . constant($game->sprache("TEXT18")) . '</i>';
                    } else {
                        $userName = '******' . parse_link('a=stats&a2=viewplayer&id=' . $message['sender']) . '">' . $message['user_name'] . '</a>';
                    }
                }
            }
            $datum = date("d.m.y H:i", $message['time']);
            $game->out('
        <tr>
          <td width="2%"></td>
          <td width="30%">' . $userName . '</td>
          <td width="45%"><a href="' . parse_link('a=messages&a2=view&id=' . $message['id']) . '">' . $message['subject'] . '</a></td>
          <td width="19%">' . $datum . '</td>
          <td width="5%"><input type="checkbox" name="message' . $i . '" value="' . $message['id'] . '"></td>
          <td width="2%"></td>
        </tr>
        <tr>
          <td height="2" colspan="6"></td>
        </tr>');
        }
    }
    $links = navigation_show_pagelinks($page, $perpage, $archStat['messages'], 'a=messages&a2=archiv');
    $delete = '<a href="' . parse_link('a=messages&a2=archiv&aremoverequest=1') . '">' . constant($game->sprache("TEXT20")) . '</a>';
    if ($archStat['messages'] != 0) {
        $links2 = $delete;
    } else {
        $links2 = "";
    }
    $game->out('
        <tr>
          <td height="3" colspan="6"></td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<br>');
    if ($archStat['messages'] != 0) {
        $game->out('
<table width="90%" border="0" cellpadding="1" cellspacing="1" class="style_outer">
  <tr>
    <td>
      <table width="100%" border="0" cellpadding="2" cellspacing="2" class="style_inner">
        <tr>
          <td width="96%">
            <table width="100%" border="0" cellpadding="0" cellspacing="0">
              <tr>
                <td width="50%" align="left">' . constant($game->sprache("TEXT15")) . '</td>
                <td width="50%" align="right"><input style="width: 120px;" type="submit" class="button" value="' . constant($game->sprache("TEXT16")) . '"></td>
              </tr>
            </table>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
          ' . $links . '<br>
          ' . $links2 . '<br>');
    }
    $game->out('</form>');
}
function archiv()
{
    global $db;
    global $page, $perpage, $start;
    global $archStat;
    $messageList = $db->query('SELECT m.time, m.sender, m.subject, m.id,u.user_name FROM message_archiv m LEFT JOIN user u on u.user_id=m.sender WHERE (m.receiver = "' . SUPPORTUSER . '") ORDER BY m.time DESC LIMIT ' . $start . ', ' . $perpage);
    output('<form method="post" action="' . parse_link('p=messages&a2=archiv&aremove=1') . '">
	             <center>
	             <table width="90%" border="0" cellpadding="0" cellspacing="0"  class="style_inner">
					  <tr>
					   <td height="6" colspan="6"></td>
					  </tr>');
    if ($archStat['messages'] == 0) {
        output('<tr>
						 <td width="2%"></td>
					    <td colspan="4"><i>Nessun messaggio</i></td>
						 <td width="2%"></td>
					   </tr>');
    } else {
        for ($i = 0; ($message = $db->fetchrow($messageList)) == true; $i++) {
            if ($message['sender'] == 0) {
                $userName = '******';
            } else {
                if (!isset($message['user_name'])) {
                    $userName = '******';
                } else {
                    $userName = '******' . $message['sender'] . '" target=_blank>' . $message['user_name'] . '</a>';
                }
            }
            $datum = date("d.m.y H:i", $message['time']);
            output('<tr>
							<td width="2%"></td>
							<td width="30%">' . $userName . '</td>
							<td width="45%"><a href="' . parse_link('p=messages&a2=view&id=' . $message['id']) . '">' . $message['subject'] . '</a></td>
							<td width="19%">' . $datum . '</td>
							<td width="5%"><input type="checkbox" name="message' . $i . '" value="' . $message['id'] . '"></td>
							<td width="2%"></td>
							</tr>
							<tr>
							<td height="2" colspan="6"></td>
							</tr>');
        }
    }
    $links = navigation_show_pagelinks($page, $perpage, $archStat['messages'], 'p=messages&a2=archiv');
    $delete = '';
    if ($archStat['messages'] != 0) {
        $links2 = $delete;
    } else {
        $links2 = "";
    }
    output('  <tr>
					   <td height="3" colspan="6"></td>
					  </tr>
				    </table>
					 <br>');
    if ($archStat['messages'] != 0) {
        output('<table width="90%" border="0" cellpadding="2" cellspacing="0"  class="style_inner">
					  <tr>
					   <td width="2%">&nbsp;</td>
					   <td width="96%" colspan="4">
						 <table width="100%" border="0" cellpadding="0" cellspacing="0">
                    <tr>
                     <td width="50%" align="left">voci selezionate</td>
                     <td width="50%" align="right"></td>
                    </tr>
					    </table>
						<td width="2%">&nbsp;</td>
						</td>
					  </tr>
					  <tr>
					   <td height="5" colspan="6"></td>
					  </tr>
					  <tr>
					   <td width="100%" colspan="6" align="center">' . $links . '</td>
					  </tr>
					  <tr>
					   <td height="5" colspan="6"></td>
					  </tr>
					  <tr>
					   <td width="100%" colspan="6" align="center">' . $links2 . '</td>
					  </tr>
					 </table>');
    }
    output(' </center>
					</form>');
}