";
return $definition;
}
function add_to_count($term) {
$records = db_query("select * from counts where term='$term'");
if (mysql_num_rows($records) == 0)
db_query("insert into counts values('$term', 1)");
else
db_query("update counts set count = count + 1 where term='$term'");
}
function set_up() {
db_connect();
$user_id = isset( $_COOKIE["userid"] ) ? $_COOKIE["userid"] : "";
if ($user_id == "") $user_id = uniqid("");
setcookie("userid", $user_id, time()+30*24*60*60);
return $user_id;
}
function get_term() {
$t2 = isset( $_REQUEST['term2'] ) ? $_REQUEST['term2'] : "";
return $t2 != "" ? $t2 : isset( $_REQUEST['term1'] ) ? $_REQUEST['term1'] : "";
}
// added dev 29th Nov 07
function get_CheckBoxValue()
{
$cbxv = isset( $_REQUEST['checkboxValue'] ) ? $_REQUEST['checkboxValue'] : "";
return trim( $cbxv );
}
function normalize($v, $n1, $n2, $m) {
return round((($v - $n1 + 1) * $m)/($n2 - $n1 + 1));
}
function make_link($t, $n) {
return "$t";
}
function encloud($a) {
$s = "";
foreach ($a as $k => $v)
$s .= make_link($k, $v) . " ";
return $s;
}
function do_cloud() {
$records = db_query("select * from counts order by count desc");
$n = mysql_num_rows($records);
if ($n > MAXCLOUDSIZE) $n = MAXCLOUDSIZE;
for ($i = 0; $i < $n; ++$i) {
$record = mysql_fetch_array($records);
$counts[$record["term"]] = $record["count"];
}
return make_cloud($counts);
}
function make_cloud($counts) {
$max = reset($counts);
$min = end($counts);
foreach ($counts as $k => $v)
$counts[$k] = normalize($v, $min, $max, 5);
ksort($counts);
return encloud($counts);
}
function get_history($user) {
$query = "select term from histories where user = \"$user\" order by n";
$records = db_query($query);
$n = mysql_num_rows($records);
if ($n == 0) return null;
for ($i = 0; $i < $n; ++$i) {
$record = mysql_fetch_array($records);
$hist[$i] = $record["term"];
}
return $hist;
}
function add_to_history($term, $user, $history) {
db_query("delete from histories where user=\"$user\"");
db_query("insert into histories values (\"$user\", \"$term\", 0)");
if ($history != null) {
$i = 1;
foreach ($history as $h) {
if ($h != $term && $i < HISTLEN) {
db_query("insert into histories values (\"$user\", \"$h\", $i)");
++$i;
}
}
}
}
function do_recent_searches($history) {
if ($history == null) return "";
$s = "";
return $s;
}
// Dev added Dec 30th 2007
function random( $n ) {
srand( time() );
return rand( 1, $n );
}
function getRandomDefinition( $asXML )
{
$dbRecords = mysql_query( 'SELECT count(*) FROM `topic`' ); // execute the sql
$count = mysql_fetch_array($dbRecords); // get the count return, this is an array of strings
$n = $count[ 0 ]; // turn the first array field into a number ie the no of records in db
$recNo = random( $n ); // generate a random number in range 1 -> db record count
//echo $n." ".$recNo;
$aQuery = "SELECT term, description FROM `topic` WHERE id =" . $recNo; // set sql to get that record
//echo $aQuery;
$dbRecords = mysql_query( $aQuery ); // execute the sql command to get the record
$definition = "";
$n = mysql_num_rows($dbRecords);
if ($n == 0) {
if ( $asXML )
{
return 'No TermNo definition was found.';
}
else
{ // assume Text wanted
return "
No definition for random value was found
";
}
}
else
{
if ( $asXML ) $definition .= '';
while ($row = mysql_fetch_array($dbRecords))
{
if ( $asXML )
{
$definition .= "". $row['term']."". $row['description']."";
}
else
{
$definition .= $row['term'].' is '. $row['definition'].' ';
}
}
if ( $asXML ) $definition .= "";
return $definition;
}
}
function getRandomQuestion()
{
$definition = "
If see this message something wrong! Check getRandomQuestion() function.
"; // setup empty definition to start with
$dbRecords= mysql_query( 'SELECT count(*) FROM `question`' ); // execute the sql
if ($dbRecords) {
$count = mysql_fetch_array($dbRecords); // get the count return, this is an array of strings
$n = $count[ 0 ]; // turn it the first array field into a number
$definition = ""; // setup empty definition to start with
if ($n == 0)
return "