$search_deleted = array(1 => array("<b>Skjul alle</b> slettede forumtråder og forumsvar", " AND ft_deleted = 0", " AND ft_deleted = 0 AND fr.fr_deleted = 0"), array("<b>Skjul</b> slettede <b>forumsvar</b>, <b>vis</b> slettede <b>forumtråder</b>", "", " AND fr.fr_deleted = 0"), array("<b>Vis slettede</b> forumtråder og forumsvar", "", "")); $id = requestval("d"); $search_deleted_id = isset($search_deleted[$id]) && $allow_deleted ? $id : 1; // sortering $sort = new sorts("sort"); $sort->append("asc", "Tittel", "ft_title, ft_time DESC"); $sort->append("desc", "Tittel", "ft_title DESC, ft_time DESC"); $sort->append("asc", "Dato", "ft_time"); $sort->append("desc", "Dato", "ft_time DESC"); $sort->append("asc", "Antall svar", "ft_replies, ft_time DESC"); $sort->append("desc", "Antall svar", "ft_replies DESC, ft_time DESC"); $sort->append("asc", "Antall visninger", "ft_views"); $sort->append("desc", "Antall visninger", "ft_views DESC"); $sort->append("asc", "Siste innlegg", "IFNULL(ft_last_reply, ft_time)"); $sort->append("desc", "Siste innlegg", "IFNULL(ft_last_reply, ft_time) DESC"); $sort->set_active(requestval("sort"), 3); // søkeform echo ' <div class="bg1_c small"> <h1 class="bg1">Søk i forum<span class="left"></span><span class="right"></span></h1> <form action="" method="get"> <div class="bg1"> <dl class="dl_20 dl_2x"> <dt>Tittel</dt> <dd><input type="text" name="qs" value="' . htmlspecialchars(requestval("qs")) . '" class="styled w150" /></dd> <dt>Innhold</dt> <dd><input type="text" name="qt" value="' . htmlspecialchars(requestval("qt")) . '" class="styled w300" /></dd> <dt>Søk i forum</dt> <dd>
$sort->append("desc", "Registrert", "up_created_time DESC"); $sort->append("asc", "E-postadresse", "u_email"); $sort->append("desc", "E-postadresse", "u_email DESC"); $sort->append("asc", "Sist pålogget", "up_last_online"); $sort->append("desc", "Sist pålogget", "up_last_online DESC"); $sort->append("asc", "Hits", "up_hits"); $sort->append("desc", "Hits", "up_hits DESC"); $sort->append("asc", "Rank", "up_points"); $sort->append("desc", "Rank", "up_points DESC"); $sort->append("asc", "Penger", "money"); $sort->append("desc", "Penger", "money DESC"); $sort->append("asc", "Fødselsdato", "u_birth"); $sort->append("desc", "Fødselsdato", "u_birth DESC"); $sort->append("asc", "Spiller ID", "up_id"); $sort->append("desc", "Spiller ID", "up_id DESC"); $sort->set_active(getval("sort"), 11); $pagei = new pagei(pagei::ACTIVE_GET, "side", pagei::PER_PAGE, 100); $sort_info = $sort->active(); $result = $pagei->query("\n\t\t\tSELECT\n\t\t\t\tu_id, u_access_level, u_online_ip, u_email, u_birth, u_online_ip,\n\t\t\t\tup_id, up_name, up_access_level, up_hits, up_points, up_cash+up_bank AS money, up_created_time, up_last_online\n\t\t\tFROM users\n\t\t\t\tJOIN users_players ON up_u_id = u_id\n\t\t\tWHERE " . implode(" OR ", $where) . "\n\t\t\tGROUP BY up_id\n\t\t\tORDER BY {$sort_info['params']}"); function ip_sessions_link($ip) { return '<a href="ip_sessions?ip=' . urlencode($ip) . '">' . htmlspecialchars($ip) . '</a> (<a href="http://www.ripe.net/fcgi-bin/whois?form_type=simple&full_query_string=&searchtext=' . urlencode($ip) . '&do_search=Search">RIPE</a>)'; } $list = array(); if (count($u_id) > 0) { $list[] = '<span class="dark">Bruker ID:</span> ' . implode(", ", $u_id); } if (count($up_id) > 0) { $list[] = '<span class="dark">Spiller ID:</span> ' . implode(", ", $up_id); } if (count($up_name) > 0) {
/** * View list of contacts */ public function action_list() { $sort_k = new \sorts("sort", "/kontakter"); $sort_k->append("asc", "Navn", "up_name"); $sort_k->append("desc", "Navn", "up_name DESC"); $sort_k->append("asc", "Sist aktiv", "up_last_online DESC"); $sort_k->append("desc", "Sist aktiv", "up_last_online"); $sort_k->append("asc", "Lagt til som kontakt", "uc_time"); $sort_k->append("desc", "Lagt til som kontakt", "uc_time DESC"); $sort_k->set_active(getval('sort'), 0); $sort_b = new \sorts("sort", "/kontakter"); $sort_b->append("asc", "Navn", "up_name"); $sort_b->append("desc", "Navn", "up_name DESC"); $sort_b->append("asc", "Sist aktiv", "up_last_online DESC"); $sort_b->append("desc", "Sist aktiv", "up_last_online"); $sort_b->append("asc", "Lagt til som blokkering", "uc_time"); $sort_b->append("desc", "Lagt til som blokkering", "uc_time DESC"); $sort_b->set_active(getval('sort'), 0); $sort_by = $sort_k->active()['params']; $contacts = Contact::getContacts($this->user, $sort_by); $by_type = array(Contact::TYPE_FRIEND => array(), Contact::TYPE_BLOCK => array()); foreach ($contacts as $contact) { $by_type[$contact->getType()][] = $contact; } return View::forge("users/contacts/list", array("friends" => $by_type[Contact::TYPE_FRIEND], "blocks" => $by_type[Contact::TYPE_BLOCK], "friends_sort" => $sort_k, "blocks_sort" => $sort_b)); }
/** * Vis fengsel */ protected function show() { // er vi i fengsel nå? if ($wait = $this->up->fengsel_wait()) { ess::$b->page->add_js_domready('$("fengsel_dusor").focus();'); echo ' <div class="bg1_c xsmall"> <h1 class="bg1">Du er i fengsel<span class="left"></span><span class="right"></span></h1> <p class="h_right"><a href="node/16">Hjelp</a></p> <div class="bg1"> <p>Du befinner deg for øyeblikket i fengsel og slipper ut om ' . game::counter($wait, true) . '.</p>' . (!$this->up->is_nostat() ? ' <form action="" method="post"> <input type="hidden" name="sid" value="' . login::$info['ses_id'] . '" /> <input type="hidden" name="expire" value="' . $this->up->data['up_fengsel_time'] . '" /> <dl class="dd_right"> <dt>Dusør for å bryte deg ut</dt> <dd><input type="text" class="styled w80" name="amount" id="fengsel_dusor" value="' . game::format_cash($this->up->data['up_fengsel_dusor']) . '" /></dd> </dl> <p class="c">' . show_sbutton($this->up->data['up_fengsel_dusor'] > 0 ? "Endre dusør" : "Sett dusør", 'name="dusor"') . '</p> <p class="c">Spilleren som bryter ut mottar kun ' . self::DUSOR_PROFIT * 100 . ' % av dusøren.</p> </form>' : '') . ' </div> </div>'; } // sortering $sort = new sorts("sort"); $sort->append("asc", "Spiller", "up_name"); $sort->append("desc", "Spiller", "up_name DESC"); $sort->append("asc", "Wanted nivå", "up_wanted_level, up_fengsel_time DESC"); $sort->append("desc", "Wanted nivå", "up_wanted_level DESC, up_fengsel_time DESC"); $sort->append("asc", "Tid igjen", "up_fengsel_time"); $sort->append("desc", "Tid igjen", "up_fengsel_time DESC"); $sort->set_active(requestval("sort"), 5); // hent folk i fengsel $sort_info = $sort->active(); $pagei = new pagei(pagei::ACTIVE_GET, "side", pagei::PER_PAGE, 15); $result = $pagei->query("\n\t\t\tSELECT up_id, up_name, up_access_level, up_fengsel_time, up_fengsel_num, up_fengsel_dusor, ROUND(up_fengsel_dusor * " . self::DUSOR_PROFIT . ") up_fengsel_dusor_get, up_wanted_level\n\t\t\tFROM users_players\n\t\t\tWHERE up_fengsel_time > " . time() . " AND up_access_level != 0\n\t\t\tORDER BY {$sort_info['params']}"); $num = $result->rowCount(); echo ' <div class="bg1_c ' . ($num == 0 ? 'xsmall' : 'xlarge') . '"> <h1 class="bg1">Fengsel<span class="left"></span><span class="right"></span></h1> <p class="h_right"><a href="node/16">Hjelp</a></p> <div class="bg1"> <form action="" method="post"> <p class="c dark">Ditt wanted nivå er på ' . game::format_number($this->up->data['up_wanted_level'] / 10, 1) . ' %.</p>'; if ($num == 0) { echo ' <p class="c dark">Ingen er i fengselet for øyeblikket.</p> <p class="c"><a href="' . htmlspecialchars(game::address("fengsel", $_GET)) . '" class="button">Oppdater</a></p>'; } else { echo ' <table class="table center" width="100%"> <thead> <tr> <th>Spiller ' . $sort->show_link(0, 1) . '</th> <th>Wanted<br />nivå ' . $sort->show_link(2, 3) . '</th> <th>Utbrytning<br />sannsynlighet</th> <th>Ca. poeng</th> <th>Dusør</th> <th>Tid igjen ' . $sort->show_link(4, 5) . '</th> </tr> </thead> <tbody>'; $i = 0; while ($row = $result->fetch()) { $prefix = ""; $attr = new attr("class"); if (++$i % 2 == 0) { $attr->add("color"); } if (!$this->up->fengsel_check()) { $attr->add("box_handle"); $prefix = '<input type="radio" name="up_id" value="' . $row['up_id'] . '_' . $row['up_fengsel_time'] . '_' . $row['up_fengsel_dusor'] . '" /> '; } $time = $row['up_fengsel_time'] - time(); $prob = self::calc_prob($time, $row['up_wanted_level'] / 10); $points = self::calc_points($prob); echo ' <tr' . $attr->build() . '> <td>' . $prefix . game::profile_link($row['up_id'], $row['up_name'], $row['up_access_level']) . '</td> <td class="c">' . game::format_number($row['up_wanted_level'] / 10, 1) . ' %</td> <td class="c">' . game::format_number($prob, 1) . ' %</td> <td class="c">' . game::format_num($points) . '</td> <td class="r nowrap">' . game::format_cash($row['up_fengsel_dusor_get']) . '</td> <td class="r">' . game::counter($time) . '</td> </tr>'; } echo ' </tbody> </table> <p class="c">' . (($wait = $this->up->fengsel_wait()) == 0 ? ' ' . show_sbutton("Bryt ut", 'name="brytut"') : ' Du er i fengsel og slipper ut om ' . game::counter($wait, true) . '. </p> <p class="c">') . ' <a href="' . htmlspecialchars(game::address("fengsel", $_GET)) . '" class="button">Oppdater</a> </p>'; // flere sider? if ($pagei->pages > 1) { echo ' <div class="hr"></div> <p class="c"> ' . $pagei->pagenumbers() . ' </p>'; } } echo ' </form> </div> </div>'; // testing if (!MAIN_SERVER || access::is_nostat() && access::has("mod")) { echo ' <div class="bg1_c xxsmall bg1_padding"> <h1 class="bg1">' . (MAIN_SERVER ? 'No-stat' : 'Testing') . '<span class="left"></span><span class="right"></span></h1> <div class="bg1"> <form action="" method="post">' . ($this->up->fengsel_check() ? ' <p class="c">' . show_sbutton("Gå ut av fengsel", 'name="remove"') . '</p>' : ' <dl class="dd_right dl_2x"> <dt>Tid</dt> <dd><input type="text" name="time" value="' . htmlspecialchars(postval("time", 20)) . '" class="styled w40" /> sekunder</dd> </dl> <p class="c">' . show_sbutton("Gå inn i fensgel") . '</p>') . ' </form> </div> </div>'; } }
$search_from[4][1] = " AND up.up_name IN (" . implode(",", array_map(array($_base->db, "quote"), $search_from[4][2])) . ")"; } } //$title = ucwords($search_where[$search_where_id][0]); $_base->page->add_title("Meldinger", "Søk"); // sortering $sort = new sorts("sort"); $sort->append("asc", "Avsender", "up_name, im_time DESC"); $sort->append("desc", "Avsender", "up_name DESC, im_time DESC"); $sort->append("asc", "Emne", "it_title, im_time DESC"); $sort->append("desc", "Emne", "it_title DESC, im_time DESC"); $sort->append("asc", "Innhold", "id_text"); $sort->append("desc", "Innhold", "id_text DESC"); $sort->append("asc", "Dato", "im_time"); $sort->append("desc", "Dato", "im_time DESC"); $sort->set_active(postval("sort"), 7); // søkeform echo ' <h1>Søk - Meldinger</h1> <p class="h_right"><a href="' . htmlspecialchars(game::address("innboks", $_GET)) . '">Tilbake</a></p> <form action="' . htmlspecialchars(game::address(PHP_SELF, $_GET, array("alle", "innboks", "utboks", "side"))) . '" method="post"> <div class="section" style="width: 410px; margin-left: auto; margin-right: auto"> <h2>Søk</h2> <dl class="dl_20 dl_2x"> <dt>Tittel</dt> <dd><input type="text" name="title" value="' . htmlspecialchars(postval("title")) . '" class="styled w150" /></dd> <dt>Innhold</dt> <dd><input type="text" name="text" value="' . htmlspecialchars(postval("text")) . '" class="styled w300" /></dd> <dt>Av?</dt>
/** * Vervede spillere */ protected static function page_vervede() { global $__server; ess::$b->page->add_title("Vervede spillere"); // sortering $sort = new sorts("sort"); $sort->append("asc", "Spillernavn", "rec.up_name"); $sort->append("desc", "Spillernavn", "rec.up_name DESC"); $sort->append("asc", "Sist pålogget", "rec.up_last_online"); $sort->append("desc", "Sist pålogget", "rec.up_last_online DESC"); $sort->append("asc", "Registrert", "rec.up_created_time"); $sort->append("desc", "Registrert", "rec.up_created_time DESC"); $sort->append("asc", "Rankbonus", "u2.u_recruiter_points_bonus"); $sort->append("desc", "Rankbonus", "u2.u_recruiter_points_bonus DESC"); $sort->set_active(requestval("sort"), 5); // hent spillerene vi har vervet $sort_info = $sort->active(); $pagei = new pagei(pagei::ACTIVE_GET, "side", pagei::PER_PAGE, 50); $result = $pagei->query("\n\t\t\tSELECT rec.up_id, rec.up_name, rec.up_access_level, rec.up_last_online, rec.up_created_time, u2.u_recruiter_points_bonus\n\t\t\tFROM\n\t\t\t\tusers_players rec,\n\t\t\t\tusers_players self,\n\t\t\t\tusers u1,\n\t\t\t\tusers u2\n\t\t\tWHERE u1.u_id = " . page_min_side::$active_user->id . " AND self.up_u_id = u1.u_id AND self.up_id = rec.up_recruiter_up_id AND u2.u_id = rec.up_u_id\n\t\t\tORDER BY {$sort_info['params']}"); echo ' <div class="bg1_c xmedium"> <h1 class="bg1">Vervede spillere<span class="left2"></span><span class="right2"></span></h1> <div class="bg1"> <ol> <li>Du gir ut denne linken til en du ønsker å verve: <a href="' . $__server['path'] . '/' . page_min_side::$active_player->id . '" target="_blank">' . $__server['path'] . '/' . page_min_side::$active_player->id . '</a></li> <li>Personen åpner linken</li> <li>Når personen registrerer seg vil brukeren være vervet av deg</li> </ol> <p class="c"><a href="' . ess::$s['relative_path'] . '/node/60">Mer informasjon om verving »</a></p>'; if ($pagei->total == 0) { echo ' <p class="c">Du har ikke vervet noen spillere.</p>'; } else { echo ' <p>Du har vervet ' . $pagei->total . ' spiller' . ($pagei->total == 1 ? '' : 'e') . ':</p> <table class="table spacerfix center' . ($pagei->pages == 1 ? ' tablemb' : '') . '"> <thead> <tr> <td>Spiller <nobr>' . $sort->show_link(0, 1) . '</nobr></td> <td>Sist pålogget <nobr>' . $sort->show_link(2, 3) . '</nobr></td> <td>Tid vervet <nobr>' . $sort->show_link(4, 5) . '</nobr></td> <td>Rankbonus <nobr>' . $sort->show_link(6, 7) . '</nobr></td> </tr> </thead> <tbody>'; $color = true; while ($row = $result->fetch()) { echo ' <tr' . ($color = !$color ? ' class="color"' : '') . '> <td>' . game::profile_link($row['up_id'], $row['up_name'], $row['up_access_level']) . '</td> <td class="r">' . game::timespan($row['up_last_online'], game::TIME_ABS) . '</td> <td class="r">' . ess::$b->date->get($row['up_created_time'])->format() . '</td> <td class="r">' . game::format_number($row['u_recruiter_points_bonus']) . '</td> </tr>'; } echo ' </tbody> </table>' . ($pagei->pages > 1 ? ' <p class="c">' . $pagei->pagenumbers() . '</p>' : ''); } echo ' </div> </div>'; }
/** Søkefunksjon */ public static function action_search() { access::need("crewet"); ess::$b->page->add_title("Søk"); // hvem som skal ha kunnet skrevet det man søker på $search_from = array(1 => array("Alle", ""), array("Meg selv", " AND sum_up_id = up_ref.up_id"), array("Andre", " AND sum_up_id != up_ref.up_id"), array('Spesifiser', NULL, array())); $id = requestval("f"); $search_from_id = isset($search_from[$id]) ? $id : 1; // sjekk etter spillere? if ($search_from_id == 4) { $name = trim(postval("up")); // sett opp brukernavnene $names = explode(",", $name); foreach ($names as $name) { $name = trim($name); if (empty($name)) { continue; } if (preg_match('/^[0-9a-zA-Z\\-_ ]+$/Du', $name)) { $search_from[4][2][] = $name; } else { ess::$b->page->add_message('Ugyldig spillernavn: <b>' . htmlspecialchars($name) . '</b>.', "error"); } } if (count($search_from[4][2]) == 0) { $search_from_id = 1; } else { $search_from[4][1] = " AND up_sum.up_name IN (" . implode(",", array_map(array(ess::$b->db, "quote"), $search_from[4][2])) . ")"; } } // søke kun blant den som sendte inn henvendelsen eller de som svarte? // MERK: tar ikke høyde for at brukere skifter spiller $search_by = array(1 => array("Alle", ""), array("Innsender", " AND sum_up_id = su_up_id"), array("Crewet", " AND sum_up_id != su_up_id")); $id = requestval("fb"); $search_by_id = isset($search_by[$id]) ? $id : 1; // kategorier $search_kat = array(); foreach (self::$kategorier as $info) { $search_kat[$info['id']] = array($info['name'], "su_category = {$info['id']}"); } $search_kat_active = array(); $search_kat_query = array(); foreach ($_REQUEST as $key => $dummy) { $match = false; if (preg_match("/^k(\\d+)\$/Du", $key, $match)) { if (isset($search_kat[$match[1]])) { $search_kat_active[] = $match[1]; $search_kat_query[] = $search_kat[$match[1]][1]; } } } if (count($search_kat_query) > 0 && count($search_kat_query) != count($search_kat)) { $search_kat_query = " AND (" . implode(" OR ", $search_kat_query) . ")"; $more = true; } else { if (count($search_kat_active) == 0) { $search_kat_active = array_keys($search_kat); } $search_kat_query = ""; } // sortering $sort = new sorts("sort"); $sort->append("asc", "Avsender", "up_name, sum_time DESC"); $sort->append("desc", "Avsender", "up_name DESC, sum_time DESC"); $sort->append("asc", "Tittel", "su_title, sum_time DESC"); $sort->append("desc", "Tittel", "su_title DESC, sum_time DESC"); #$sort->append("asc", "Innhold", "id_text"); #$sort->append("desc", "Innhold", "id_text DESC"); $sort->append("asc", "Tid", "sum_time"); $sort->append("desc", "Tid", "sum_time DESC"); $sort->set_active(postval("sort"), 5); // søkeskjema echo ' <h1>Søk i support</h1> <p class="h_right"><a href="./">Tilbake</a></p> <form action="" method="post"> <div class="section" style="width: 410px; margin-left: auto; margin-right: auto"> <h2>Søk</h2> <dl class="dl_20 dl_2x"> <dt>Tittel</dt> <dd><input type="text" name="title" value="' . htmlspecialchars(postval("title")) . '" class="styled w150" /></dd> <dt>Innhold</dt> <dd><input type="text" name="text" value="' . htmlspecialchars(postval("text")) . '" class="styled w300" /></dd> <dt>Av?</dt> <dd>'; $i = 0; foreach ($search_from as $key => $item) { if (++$i == count($search_from)) { break; } echo ' <input type="radio" id="f_' . $key . '" name="f" value="' . $key . '"' . ($search_from_id == $key ? ' checked="checked"' : '') . ' /><label for="f_' . $key . '"> ' . htmlspecialchars($item[0]) . '</label>'; } echo ' </dd> <dt> </dt> <dd><input type="radio" id="f_' . $key . '" name="f" value="' . $key . '"' . ($search_from_id == $key ? ' checked="checked"' : '') . ' onclick="$(\'u_name\').focus()" /><label for="f_' . $key . '"> Spesifiser: </label><input type="text" name="up" value="' . htmlspecialchars(postval("up")) . '" class="styled w100" id="u_name" onfocus="$(\'f_' . $key . '\').checked=true" /></dd> <dt>Hvilke meldinger?</dt> <dd>'; foreach ($search_by as $key => $item) { echo ' <input type="radio" id="fb_' . $key . '" name="fb" value="' . $key . '"' . ($search_by_id == $key ? ' checked="checked"' : '') . ' /><label for="fb_' . $key . '"> ' . htmlspecialchars($item[0]) . '</label>'; } echo ' </dd> <dt>Kategorier</dt> <dd>'; $i = 0; foreach ($search_kat as $key => $item) { if ($i++ > 0) { echo '<br />'; } echo ' <input type="checkbox" id="kat?' . $key . '" name="k' . $key . '" value="1"' . (in_array($key, $search_kat_active) ? ' checked="checked"' : '') . ' /><label for="kat_' . $key . '"> ' . htmlspecialchars($item[0]) . '</label>'; } echo ' </dd> </dl> <h3 class="c"> ' . show_sbutton("Utfør søk", 'name="search"') . ' </h3> </div> </form>'; // søke? if (isset($_POST['search'])) { $title_search = postval("title"); $text_search = postval("text"); // finn ut delene av spørringen $title_parts = search_query($title_search); $text_parts = search_query($text_search); if (count($title_parts[0]) == 0 && count($text_parts[0]) == 0 && $search_from_id != 4 && $search_kat_query == "") { echo ' <h2>Søkeresultater</h2> <p>Ingen søkekriterier.</p>'; } else { // sett opp søkespørringen $search = ""; if (count($title_parts[0]) > 0) { $search .= " AND su_title" . implode(" AND su_title", $title_parts[0]); } if (count($text_parts[0]) > 0) { $search .= " AND sum_text" . implode(" AND sum_text", $text_parts[0]); } // sortering $sort_info = $sort->active(); // sidetall - hent henvendelsene på denne siden $pagei = new pagei(pagei::ACTIVE_POST, "side", pagei::PER_PAGE, 50); $result = $pagei->query("\n\t\t\t\t\tSELECT su_id, su_up_id, su_category, su_title, su_time, su_solved, sum_id, sum_up_id, sum_time, sum_text, up_sum.up_name, up_sum.up_access_level\n\t\t\t\t\tFROM support\n\t\t\t\t\t\tJOIN support_messages ON sum_su_id = su_id\n\t\t\t\t\t\tJOIN users_players up_sum ON up_sum.up_id = sum_up_id,\n\t\t\t\t\t\tusers_players up_ref\n\t\t\t\t\tWHERE up_ref.up_u_id = " . login::$user->id . "{$search_from[$search_from_id][1]}{$search_by[$search_by_id][1]}{$search_kat_query}{$search}\n\t\t\t\t\tGROUP BY sum_id" . (count($text_parts[0]) == 0 && $search_from_id == 1 ? ", su_id" : "") . "\n\t\t\t\t\tORDER BY {$sort_info['params']}", array_merge($title_parts[2], $text_parts[2])); $info = array(); foreach ($title_parts[1] as $part) { $info[] = '<b>Tittel:</b> ' . htmlspecialchars($part); } foreach ($text_parts[1] as $part) { $info[] = '<b>Innhold:</b> ' . htmlspecialchars($part); } if ($search_from_id == 4) { if (count($search_from[4][2]) == 1) { $info[] = '<b>Spiller:</b> <user="******" />'; } else { $u = array(); foreach ($search_from[4][2] as $name) { $u[] = '<user="******" />'; } $info[] = '<b>Spiller:</b> ' . implode(" eller ", $u); } } $info = implode(" ", $info); echo ' <h2>Søkeresultater</h2> <p>Søkekriterier: ' . $info . '</p>'; // fant vi noe? if ($pagei->total == 0) { echo ' <p>Fant ingen treff.</p>'; } else { echo ' <p>Antall treff: <b>' . $pagei->total . '</b></p> <form action="" method="post">'; foreach ($_POST as $key => $value) { if ($key == "side" || $key == "sort") { continue; } echo ' <input type="hidden" name="' . htmlspecialchars($key) . '" value="' . htmlspecialchars($value) . '" />'; } echo ' <input type="hidden" name="sort" id="sort_sort" value="' . $sort->active . '" /> <table class="table' . ($pagei->pages == 1 ? ' tablemb' : '') . '" width="100%"> <thead> <tr> <th><span class="tools_r">' . $sort->show_button(0, 1) . '</span> Spiller</th> <th><span class="tools_r">' . $sort->show_button(2, 3) . '</span> Henvendelse</th> <th><span class="tools_r">Tekst</th> <th><span class="tools_r">' . $sort->show_button(4, 5) . '</span> Tid</th> </tr> </thead> <tbody>'; ess::$b->page->add_css(' .su_not_solved { color: #FF0000; font-weight: bold } .sum_up { white-space: nowrap; width: 100px } .su_time { text-align: center; white-space: nowrap; color: #888888; width: 100px }'); $i = 0; while ($row = $result->fetch()) { $content = trim(strip_tags(game::bb_to_html($row['sum_text']))); $length = mb_strlen($content); $max = 60; if (mb_strlen($content) > $max) { $content = mb_substr($content, 0, $max - 4) . " ..."; } echo ' <tr' . (++$i % 2 == 0 ? ' class="color"' : '') . '> <td class="sum_up">' . game::profile_link($row['sum_up_id'], $row['up_name'], $row['up_access_level']) . '</td> <td><a href="./?a=show&su_id=' . $row['su_id'] . '">' . htmlspecialchars($row['su_title']) . '</a>' . ($row['su_solved'] == 0 ? ' <span class="su_not_solved">(Uløst)</span>' : '') . '</td> <td class="dark">' . htmlspecialchars($content) . ' (' . $length . ' tegn)</td> <td class="su_time">' . ess::$b->date->get($row['sum_time'])->format() . '</td> </tr>'; } echo ' </tbody> </table>'; // flere sider? if ($pagei->pages > 1) { echo ' <div class="hr"></div> <p class="c"> ' . $pagei->pagenumbers("input") . ' </p>'; } echo ' </form>'; } } } }