WHERE ff.auth_post != 3
AND (u.user_active = 1 OR u.user_id = -1)
AND t.topic_id IN ( SELECT topic_id
FROM ' . $phpbb_table_prefix . '_topics
LEFT JOIN ' . $phpbb_table_prefix . '_users u ON u.user_id = topic_poster
WHERE topic_status != 2
AND forum_id != 2
AND u.user_active = 1)
ORDER BY p.post_id ASC';
$req_post = mysql_query($sql_post);
$yml = array();
while ($data = mysql_fetch_array($req_post)) {
if ($data['poster_id'] == -1) {
$user = "******" . ' author_name: ' . $data['post_username'];
} else {
$user = "******" . ' sfGuardUser: '******'username']) . '_user';
}
$content = bbencode_second_pass($data['post_text'], $data['bbcode_uid']);
$content = str_replace("\n\r", ' ', $content);
$content = str_replace("\n", ' ', $content);
$content = str_replace("\r", "\n ", $content);
$content = str_replace("\t", ' ', $content);
$content = str_replace("(lien externe)", "", $content);
$content = str_replace(' class="postlink external"', "", $content);
$content = str_replace(' class="postlink"', "", $content);
$content = str_replace('<span> </span>', "", $content);
$content = str_replace('<span class="postbody">', "", $content);
$content = str_replace('</span>', "", $content);
$content = str_replace('<span class="genmed">', "", $content);
$yml['sfSimpleForumPost'][] = '
p_' . $data['post_id'] . ':
<?php
echo $faq->getQuestion();
?>
</p>
<p class="answer">
<?php
echo $faq->getAnswer();
?>
</p>
</div>
<?php
} else {
?>
<div class="question">
> <?php
echo link_to($faq->getQuestion(), 'sfFaq/index?faq_id=' . $faq->getId() . '&question=' . stripText($faq->getQuestion()));
?>
</div>
<?php
}
?>
<div class="question_separator"><?php
echo sfConfig::get('app_sfFaqPlugin_question_separator', '<hr />');
?>
</div>
<?php
}
?>
}
echo '<td width="5%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">';
//echo '<input type="image" src="pfeil.gif" onclick="startBefund('.$erg[result_fid].','.$erg[result_fid].','.$erg[result_id].');"> </font>'; //Auswahl
echo '<input type="image" src="befdruck.gif" onclick="druckBefund(' . $erg[result_pid] . ',' . $erg[result_fid] . ',' . $erg[result_id] . ',' . $null . ');"></font></td>';
//Auswahl
echo '<td width="10%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">' . formatDate2Local($erg[result_date], $date_format) . '</font></td>';
//Sende Datum
echo '<td width="10%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">' . $erg[result_dr] . '</font></td>';
//Arzt
echo '<td width="10%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">' . $erg[result_pid] . "<br>" . $erg[result_fid] . '</font></td>';
//FID
echo '<td width="10%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">' . PatName($erg[result_pid]) . '</font></td>';
//Patientenname
echo '<td width="10%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">' . $erg[result_id] . '<br>' . $erg[result_request_nr] . '</font></td>';
//Anforderungsnr
echo '<td width="50%" valign="top" align="' . $TP_ALIGN . '" bgcolor="' . $color . '"><FONT size="0" face="Arial">' . substr(stripText($erg[result_text]), 0, 400) . '</font></td>';
//Befundtext
echo '</tr>';
}
echo '</table>';
?>
<br><br><br>
<INPUT TYPE="hidden" name="myArzt" value="<?php
echo $my_user;
?>
">
<INPUT TYPE="hidden" name="myDep" value="<?php
echo $my_dep;
?>
">
function load_items_after_id($previous_id)
{
$this->db->select('*, db_items.legendary, db_items.id as item_id, db_items.name as item_name, db_items.id as id, db_item_slots.name AS slot_name, db_item_types.name as type_name, db_characters.name as character_name, db_characters.class, db_characters.color');
$this->db->join('db_characters', 'db_characters.id = db_items.character_id', 'inner');
$this->db->join('db_item_slots', 'db_item_slots.id = db_items.item_slot_id', 'inner');
$this->db->join('db_item_types', 'db_item_types.id = db_items.item_type_id', 'inner');
$this->db->where('date_added > ', strtotime("midnight"));
$this->db->order_by('db_items.id', 'ASC');
$query = $this->db->get_where('db_items', array('db_items.id >' => $previous_id));
$return_array = array();
foreach ($query->result() as $item) {
$this->db->select('*, db_stats.name as stat_name');
$this->db->join('db_stats', 'db_item_stats.stat_id = db_stats.id', 'l');
$stats_query = $this->db->get_where('db_item_stats', array('item_id' => $item->id));
$item->stats = $stats_query->result();
$item->date_added = date('h:i:sA', $item->date_added);
$item->url_name = stripText($item->item_name);
$return_array[] = $item;
}
return $return_array;
}
