function SelectCondition($name, $select = '') { $conditions = GetAllRows('code, c_description', '`condition`', "where type='C' order by lvl"); //$conditions = array(array("P","Perfect"),array("E","Excellent"),array("G","Good"),array("F","Fair"),array("O","Poor"),array("B","Broken/Junk")); $output = "<select name=" . $name . ">"; foreach ($conditions as $cond) { if ($select == $cond['code']) { $sel = 'selected'; } else { $sel = ''; } $output .= "<option " . $sel . " value='" . $cond['code'] . "'>" . $cond['c_description'] . "</option>"; } $output .= "</select>"; return $output; }
function AddGame() { $game_console = GetAllRows('*', 'game_console_system'); $game_genre = GetAllRows('*', 'game_genre'); $game_media = GetAllRows('*', 'games_media'); $game_publisher = GetAllRows('*', 'game_publisher'); echo '<div> <form action="index.php?action=insert_game" method="post"> Game name: <input type="text" name="g_name" value="" maxlength="255" /><br /> Console: ' . SelectConsole($game_console, "console") . '<br /> Release Date: <input type="text" name="date" value="" maxlength="255" /><br /> Publisher:' . SelectPublisher($game_publisher, "pub") . ' <br /> Beaten?: <input type="text" name="beat" value="" maxlength="255" /><br /> Rank: <input type="text" name="rank" value="" maxlength="20" /><br /> Genre: ' . SelectGenre($game_genre, "genre") . '<br /> Players: <input type="text" name="plr" value="" maxlength="4" /><br /> Media Type: ' . SelectMedia($game_media, "media") . ' <br /> Other Info: <input type="text" name="info" value="" maxlength="255" /><br /> <input type="hidden" name="action" value="insert_game" /> <input type="submit" value="Submit" /> <form> <br />'; }
$sqldump = "-- " . $OrgName . " " . $SQLDumper . "\n"; $sqldump .= "-- version " . $VerInfo['iDB_Ver_SVN'] . "\n"; $sqldump .= "-- " . $iDBHome . "support/\n"; $sqldump .= "--\n"; $sqldump .= "-- Host: " . $Settings['sqlhost'] . "\n"; $sqldump .= "-- Generation Time: " . GMTimeGet('F d, Y \\a\\t h:i A', $_SESSION['UserTimeZone'], 0, $_SESSION['UserDST']) . "\n"; $sqldump .= "-- Server version: " . sql_server_info($SQLStat) . "\n"; $sqldump .= "-- PHP Version: " . phpversion() . "\n\n"; $sqldump .= "SET SESSION SQL_MODE='ANSI_QUOTES,NO_AUTO_VALUE_ON_ZERO';\n\n"; $sqldump .= "--\n"; $sqldump .= "-- Database: \"" . $Settings['sqldb'] . "\"\n"; $sqldump .= "--\n\n"; $sqldump .= "-- --------------------------------------------------------\n\n"; while ($renee_s < $num) { $tnum = $num - 1; $trow = GetAllRows($TableNames[$renee_s]); $numz = count($trow); $kazuki_p = 0; $sqldump .= "--\n"; $sqldump .= "-- Table structure for table \"" . $TableNames[$renee_s] . "\"\n"; $sqldump .= "--\n\n"; $sqldump .= $FullTable[$renee_s] . "\n"; while ($kazuki_p < $numz) { $tnumz = $numz - 1; $srow = null; $srowvalue = null; $trownew = $trow[$kazuki_p]; $trowname = array_keys($trownew); $nums = count($trownew); $il = 0; while ($il < $nums) {
function CreDebView($is_data = false, $lot = -1, $data = '', &$sum_of = 0, $return = false) { if ($lot == -1) { echo "error on lot#."; return false; } $summation_cr_db = 0; $all_cr = 0; $all_db = 0; if (!$is_data) { $data = GetAllRows('*', 'cre_deb', ' where lot=' . $lot); } $output = "Credit/Debit table<br />\r\n\t<table border='1'>\r\n\t\t<thead>\r\n\t\t\t<th>Transaction #</th>\r\n\t\t\t<th>Credit</th>\r\n\t\t\t<th>Debit</th>\r\n\t\t\t<th>Reason</th>\r\n\t\t</thead>\r\n\t\t<tbody>"; foreach ($data as $cr_db) { $output .= "<tr>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t" . $cr_db['cd_trans_num'] . "\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t" . $cr_db['credit'] . "\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t" . $cr_db['debit'] . "\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t" . $cr_db['cd_note'] . "\r\n\t\t\t\t</td>\r\n\t\t\t</tr>"; $all_cr = $all_cr + $cr_db['credit']; $all_db = $all_db + $cr_db['debit']; $summation_cr_db = $summation_cr_db + ($cr_db['credit'] - $cr_db['debit']); } $output .= "</tbody>\r\n\t\t<tfoot>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\tAll Credit= \$" . $all_cr . "\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\tAll Debit= \$" . $all_db . "\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\tOver all Total= \$" . $summation_cr_db . "\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t</tfoot>\r\n\t</table>"; $sum_of = $summation_cr_db; if (!$return) { echo $output; } else { return $output; } }
function GetItems($not_in = "'D','W'", $what = 'lot, item_description', $other = '') { return GetAllRows($what, 'item', "where i_state not in(" . $not_in . ")" . $other); }