</td>
						<td bgcolor="#AAAAAA" width="10%" valign="top" align="center">
							Autor
						</td>
						<td bgcolor="#AAAAAA" width="10%" valign="top" align="center">
							Visualizações
						</td>
						<td bgcolor="#AAAAAA" width="20%" valign="top" align="center">
							Última Mensagem
						</td>
					</tr>

<?php 
    $children = new Topic();
    $children->SetDatabase($database);
    $children->SetTopic($data["topc_id"]);
    $result0 = $children->SelectByTopic();
    while ($data0 = $database->FetchArray($result0)) {
        $users_info = new UserInfo();
        $users_info->SetDatabase($database);
        $users_info->SetUser($data0["topc_user_id"]);
        $users_info->SelectByUser();
        $messages = new Message();
        $messages->SetDatabase($database);
        $messages->SetTopic($data0["topc_id"]);
        $p_topic = new Topic();
        $p_topic->SetDatabase($database);
        $p_topic->SetId($data0["topc_id"]);
        $p_topic->SelectById();
        ?>
Example #2
0
$result0 = $areas->SelectByLevel();
while ($data0 = $database->FetchArray($result0)) {
    ?>

					<tr>
						<td bgcolor="#DDDDDD" width="100%" valign="top" align="left" colspan="4">
							<?php 
    echo $data0["topc_title"];
    ?>
						</td>
					</tr>

<?php 
    $forums = new Topic();
    $forums->SetDatabase($database);
    $forums->SetTopic($data0["topc_id"]);
    $result1 = $forums->SelectByTopic();
    while ($data1 = $database->FetchArray($result1)) {
        ?>

					<tr>
						<td bgcolor="#FFFFFF" width="60%" valign="top" align="left">
							<a href="/pages/pgForumTopics.php?p_topc_id=<?php 
        echo $data1["topc_id"];
        ?>
"><?php 
        echo $data1["topc_title"];
        ?>
</a> - <?php 
        echo $data1["topc_text"];
        ?>
Example #3
0
     $date = new Date();
     $date->SetConverted($topc_date);
     $date->ConvertToDate();
     if ($date->VerifyDate()) {
         $message = $date->GetMessage();
         $message_position = 2;
     } else {
         $topic = new Topic();
         $topic->SetDatabase($database);
         $topic->SetId($topc_id);
         $topic->SetTitle(str_replace("\"", "\\\"", $topc_title));
         $topic->SetText(str_replace("\"", "\\\"", $topc_text));
         $topic->SetDate($date->GetDate());
         $topic->SetLevel($topc_level);
         $topic->SetUser($topc_user_id);
         $topic->SetTopic($topc_topc_id);
         if ($topic->Update()) {
             $message_position = 7;
             $message = $screen_module_name . " alterado com sucesso.";
         } else {
             $message_position = 7;
             $message = "Problemas na operação.";
         }
     }
 }
 if ($action == 4) {
     $topic = new Topic();
     $topic->SetDatabase($database);
     $topic->SetId($topc_id);
     if ($topic->Delete()) {
         $date = new Date();