<p class="c">Alle rapporteringer denne brukeren er involvert i.</p>'; $where = " AND (r_source_up_id = up_id OR r_up_id = up_id)"; } $pagei = new pagei(pagei::ACTIVE_POST, "s", pagei::PER_PAGE, 10); $result = $pagei->query("\n\tSELECT r_id, r_source_up_id, r_up_id, r_type, r_type_id, r_time, r_note, r_state, r_crew_up_id, r_crew_note, r_crew_time\n\tFROM rapportering, users_players\n\tWHERE up_u_id = {$user->id}{$where}\n\tORDER BY IFNULL(r_crew_time, r_time) DESC"); if ($pagei->total == 0) { ajax::html(parse_html($data . ' <p class="c">Ingen oppføringer ble funnet.</p>')); } $raps = array(); while ($row = $result->fetch()) { $raps[] = $row; } rapportering::generate_prerequisite($raps); $data .= ' <p class="c">' . $pagei->pagenumbers_ajax() . '</p>'; foreach ($raps as $row) { $data .= ' <div class="rap_wrap"> <p class="rap_time">Innsendt <span>' . ess::$b->date->get($row['r_time'])->format() . '</span></p> <p class="rap_w"><user id="' . $row['r_source_up_id'] . '" /> rapporterte <span class="rap_u"><user id="' . $row['r_up_id'] . '" /></span></p> <div class="col2_w"> <div class="col_w left"> <div class="col"> <p>Rapportert: <a href="' . rapportering::generate_link($row) . '">' . rapportering::$types[$row['r_type']] . '</a></p>'; if ($row['r_state'] <= 0) { $data .= ' <p><b>Ubehandlet rapportering</b></p>'; } elseif ($row['r_state'] == 1) { $data .= ' <p>Blir behandlet av <user id="' . $row['r_crew_up_id'] . '" /><br />(' . ess::$b->date->get($row['r_crew_time'])->format() . ')</p>';