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%"> </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%"> </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>'); }