PHP DB_SourceAgency::fの例

コード例 #1

ファイル: users.php プロジェクト: BackupTheBerlios/sourceagency

    $bx->box_body_begin();
    $bx->box_columns_begin(5);
    $bx->box_column('right', '5%', '', '<b>' . $t->translate('No.') . '</b>');
    $bx->box_column('center', '25%', '', '<b>#&nbsp;' . $t->translate('Projects') . '</b>');
    $bx->box_column('center', '25%', '', '<b>' . $t->translate('Username') . '</b>');
    $bx->box_column('center', '25%', '', '<b>' . $t->translate('Realname') . '</b>');
    $bx->box_column('center', '25%', '', '<b>' . $t->translate('E-Mail') . '</b>');
    $bx->box_next_row_of_columns();
    $i = 1;
    $colors = array(0 => '#FFFFFF', 1 => '#DFDFDF');
    while ($db->next_record()) {
        $bgcolor = $colors[$i % 2];
        $db2 = new DB_SourceAgency();
        $db2->query("SELECT COUNT(*) FROM description " . "WHERE description_user='******' AND status>'0'");
        $db2->next_record();
        $num = '[' . sprintf('%03d', $db2->f("COUNT(*)")) . ']';
        $bx->box_column('right', '', $bgcolor, $i);
        $bx->box_column('center', '', $bgcolor, $num);
        $user = $db->f('username');
        $bx->box_column('center', '', $bgcolor, sprintf("<a target=\"_blank\" href=\"" . $g_dev_counter_url . "\">%s</a>", $user, $user));
        $bx->box_column('center', '', $bgcolor, $db->f('realname'));
        $bx->box_column('center', '', $bgcolor, html_link('mailto:' . $db->f('email_usr'), '', ereg_replace('@', ' at ', htmlentities($db->f('email_usr')))));
        $bx->box_next_row_of_columns();
        $i++;
    }
    $bx->box_columns_end();
    $bx->box_body_end();
    $bx->box_end();
}
end_content();
require 'include/footer.inc';

コード例 #2

ファイル: backend.php プロジェクト: BackupTheBerlios/sourceagency

echo "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n";
echo "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n";
echo "           \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n";
echo "<rss version=\"0.91\">\n";
echo "  <channel>\n";
echo "    <title>" . $sys_name . "</title>\n";
echo "    <link>" . $sys_url . "</link>\n";
echo "    <description>" . $sys_name . " - " . $sys_title . "</description>\n";
echo "    <language>en-us</language>\n";
echo "  <image>\n";
echo "    <title>" . $sys_name . "</title>\n";
echo "    <url>" . $sys_url . $sys_logo_image . "</url>\n";
echo "    <link>" . $sys_url . "</link>\n";
echo "    <description>" . $sys_name . " - " . $sys_title . "</description>\n";
echo "    <width>66</width>\n";
echo "    <height>73</height>\n";
echo "  </image>\n";
$db = new DB_SourceAgency();
$db->query("SELECT * FROM description,auth_user WHERE " . "description_user=username AND description.status>'1' " . "ORDER BY description_creation DESC limit 10");
$i = 0;
while ($db->next_record()) {
    echo "  <item>\n";
    echo "    <title>" . $db->f("project_title") . " " . $db->f("type") . "</title>\n";
    echo "    <link>" . $sys_url . "probyid.php?id=" . $db->f("proid") . "</link>\n";
    echo "    <description>" . wrap($db->f("description")) . "</description>\n";
    echo "  </item>\n";
    $i++;
}
echo "  </channel>\n";
echo "</rss>\n";
@page_close();

コード例 #3

ファイル: index.php プロジェクト: BackupTheBerlios/sourceagency

//    echo '<p>'.$db_summary->f('description');
//    echo '<p>type <b>'.$db_summary->f('type').'</b> volume <b>'
//      .$db_summary->f('volume')."</b>\n<br>";
//    echo '<hr>';
//  }
//  $bx->box_body_end();
//  $bx->box_end();
$bx->box_column_finish();
$bx->box_column_start('right', '35%', '');
$bx->box_begin();
$bx->box_title($t->translate('Recent Projects'));
$bx->box_body_begin();
$db_summary->query("SELECT * FROM description WHERE status > '0' ORDER " . "BY description_creation DESC LIMIT 10");
if ($db_summary->num_rows() > 0) {
    while ($db_summary->next_record()) {
        echo '<div class=newsind>&#149;&nbsp;' . html_link('summary.php', array('proid' => $db_summary->f('proid')), $db_summary->f('project_title')) . '<br>[' . timestr(mktimestamp($db_summary->f('description_creation'))) . ']</div>';
    }
}
$bx->box_body_end();
$bx->box_end();
print "<br>\n";
$bx->box_begin();
$bx->box_title($t->translate('Developing Proposals Wanted'));
$bx->box_body_begin();
$db_summary->query("SELECT * FROM description,configure WHERE status = '2'" . " AND description.proid=configure.proid AND " . "other_developing_proposals='Yes' ORDER BY " . "description_creation DESC LIMIT 5");
if ($db_summary->num_rows() > 0) {
    while ($db_summary->next_record()) {
        echo '<div class=newsind>&#149;&nbsp;' . html_link('step2.php', array('proid' => $db_summary->f('proid')), $db_summary->f('project_title')) . '<br>[' . timestr(mktimestamp($db_summary->f('description_creation'))) . ']</div>';
    }
}
$bx->box_body_end();