function testDoco_show() { global $bx; $d = $this->_generate_records(array('page', 'header', 'doco'), 1); $db_config = new mock_db_configure(1); $db_config->add_query('fubar', 0); $db_config->add_record($d[0], 0); $db = new DB_SourceAgency(); $db->query('fubar'); $db->next_record(); $bx = $this->_create_default_box(); $this->capture_call('doco_show', 753, array(&$db)); $this->_checkFor_box_full($d[0]['page'] . ': ' . $d[0]['header'], $d[0]['doco']); $this->_check_db($db_config); }
function testShow_proposals() { global $db, $qs; $fname = 'show_proposals'; $qs = array(0 => $this->queries[$fname . '_1'], 1 => $this->queries[$fname . '_2'], 2 => $this->queries[$fname . '_3']); $db_config = new mock_db_configure(20); $args = $this->_generate_records(array('proid', 'content_id'), 10); $d1 = $this->_generate_records(array('content_id'), 10); $d2 = $this->_generate_records(array('creation', 'username', 'cost', 'license', 'status', 'cooperation', 'devid', 'valid', 'start', 'duration'), 10); $inst_nr = 0; // test one, no records $db_config->add_record($d1[0], 0); $db_config->add_query(sprintf($qs[0], $args[0]['proid'], $d1[0]['content_id']), 1); $db_config->add_record(false, 1); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 0, $args[0]); $inst_nr = 2; // test two: one record, cooperation == No, COUNT(*) == 0 $d2[0]['cooperation'] = 'No'; $inst_nr = $this->_config_db_show_proposals($db_config, $inst_nr, $args[1], $d1[1], $d2[0], -1, 0); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 1108, $args[1]); $this->_checkFor_show_proposals($args[1]['proid'], $d2[0], -1, 0); // test three: one record, cooperation == Yes, both COUNT(*) == 0 $d2[1]['cooperation'] = 'Yes'; $inst_nr = $this->_config_db_show_proposals($db_config, $inst_nr, $args[2], $d1[2], $d2[1], 0, 0); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 1274, $args[2]); $this->_checkFor_show_proposals($args[2]['proid'], $d2[1], 0, 0); // test four: one record, cooperation == No, COUNT(*) == 1 $d2[2]['cooperation'] = 'No'; $inst_nr = $this->_config_db_show_proposals($db_config, $inst_nr, $args[3], $d1[3], $d2[2], -1, 1); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 1224, $args[3]); $this->_checkFor_show_proposals($args[3]['proid'], $d2[2], -1, 1); // test five: one record, cooperation == Yes, both COUNT(*) == 1 $d2[3]['cooperation'] = 'Yes'; $inst_nr = $this->_config_db_show_proposals($db_config, $inst_nr, $args[4], $d1[4], $d2[3], 1, 1); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 1424, $args[4]); $this->_checkFor_show_proposals($args[4]['proid'], $d2[3], 1, 1); // test six: one record, cooperation == Yes ... $d2[4]['cooperation'] = 'Yes'; $inst_nr = $this->_config_db_show_proposals($db_config, $inst_nr, $args[5], $d1[5], $d2[4], 0, 1); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 1356, $args[5]); $this->_checkFor_show_proposals($args[5]['proid'], $d2[4], 0, 1); // test seven: one record, cooperation == Yes ... $d2[5]['cooperation'] = 'Yes'; $inst_nr = $this->_config_db_show_proposals($db_config, $inst_nr, $args[6], $d1[6], $d2[5], 1, 0); $db = new DB_SourceAgency(); $db->next_record(); $this->capture_call($fname, 1342, $args[6]); $this->_checkFor_show_proposals($args[6]['proid'], $d2[5], 1, 0); $this->_check_db($db_config); }
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();
function testFaqshow() { global $t, $bx; $db_config = new mock_db_configure(1); $d = $this->_generate_records(array('question', 'answer'), 1); $db_config->add_query('fubar', 0); $db_config->add_record($d[0], 0); $db = new DB_SourceAgency(); $db->query('fubar'); $db->next_record(); $bx = $this->_create_default_box(); $this->capture_call('faqshow', 778, array(&$db)); $this->_checkFor_box_full($t->translate('Question') . '</B>: ' . $d[0]['question'], '<b>' . $t->translate('Answer') . '</b>: ' . $d[0]['answer']); $this->_check_db($db_config); }
$bx->box_title($t->translate('Users') . ': ' . $t->translate($type)); $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># ' . $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();
// ."</b>\n"); // 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>• ' . 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>• ' . html_link('step2.php', array('proid' => $db_summary->f('proid')), $db_summary->f('project_title')) . '<br>[' . timestr(mktimestamp($db_summary->f('description_creation'))) . ']</div>'; } }