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'] . ':
Ejemplo n.º 2
0
						<?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;
 }