<?php

require_once 'database.php';

require_once 'common.php';

$queryfuncs = array();

function render_extension_list($wantname, $query)

{

$count = db_num_rows($query);

if (($wantname) and ($count > 1))

write_error('(Unexpected number of results from database!)');

print("<ul>\n");

while ( ($row = db_fetch_array($query)) != false )

{

$url = get_alext_url($row['extname']);

print(" <li><a href='$url'>${row['extname']}</a>\n");

} // while

print("</ul>\n<p>Total results: $count\n");

} // render_extension_list

$queryfuncs['extension'] = 'find_extension';

function find_extension($wantname)

{

if ($wantname)

{

$sqlwantname = db_escape_string($wantname);

} // if

$query = do_dbquery($sql);

if ($query == false)

return; // error output is handled in database.php ...

else

db_free_result($query);

} // find_extension

function find_token($additionalsql, $wantname)

{

$sql = 'select tok.tokenname as tokenname,' .

' tok.tokenval as tokenval,' .

' from alextreg_tokens as tok' .

' left outer join alextreg_extensions as ext' .

' on tok.extid=ext.id' .

$additionalsql;

$query = do_dbquery($sql);

if ($query == false)

return; // error output is handled in database.php ...

else

{

$count = db_num_rows($query);

if (($wantname) and ($count > 1))

write_error('(Unexpected number of results from database!)');

print("<ul>\n");

while ( ($row = db_fetch_array($query)) != false )

{

$hex = sprintf("0x%X", $row['tokenval']); // !!! FIXME: faster way to do this?

print(" <li>${row['tokenname']} ($hex)");

print(" from <a href='$url'>${row['extname']}</a>\n");

} // while

} // else

db_free_result($query);

} // find_token

$queryfuncs['tokenname'] = 'find_tokenname';

function find_tokenname($wantname)

{

$additionalsql = '';

if ($wantname)

{

$sqlwantname = db_escape_string($wantname);

} // if

find_token($additionalsql, $wantname);

} // find_tokenname

function find_tokenvalue($wantname)

{

$additionalsql = '';

if ($wantname)

{

$sqlwantname = db_escape_string($wantname);

} // if

find_token($additionalsql, $wantname);

$queryfuncs['entrypoint'] = 'find_entrypoint';

function find_entrypoint($wantname)

{

$sql = 'select ent.entrypointname as entrypointname,' .

' ext.extname as extname' .

' from alextreg_entrypoints as ent' .

' left outer join alextreg_extensions as ext' .

' on ent.extid=ext.id';

if ($wantname)

{

$sqlwantname = db_escape_string($wantname);

$sql .= " where ent.entrypointname='$sqlwantname'";

} // if

$query = do_dbquery($sql);

if ($query == false)

return; // error output is handled in database.php ...

else

{

$count = db_num_rows($query);

if (($wantname) and ($count > 1))

write_error('(Unexpected number of results from database!)');

print("<ul>\n");

while ( ($row = db_fetch_array($query)) != false )

{

print(" <li>${row['entrypointname']} ");

print(" from <a href='$url'>${row['extname']}</a>\n");

} // while

print("</ul>\n<p>Total results: $count\n");

} // else

db_free_result($query);

} // find_entrypoint

$queryfuncs['anything'] = 'find_anything';

function find_anything($wantname)

{

find_extension($wantname);

find_tokenname($wantname);

find_tokenvalue($wantname);

find_entrypoint($wantname);

} // find_anything

global $queryfuncs;

$queryfunc = $queryfuncs[$wanttype];

if (!isset($queryfunc))

{

write_error('Invalid search type.');

return;

} // if

$queryfunc($wantname);

echo "\n<hr>\n";

} // do_find

$operations['op_findone'] = 'op_findone';

function op_findone()

{

$wanttype = $_REQUEST['wanttype'];

$wantname = $_REQUEST['wantname'];

if ( (empty($wantname)) or (empty($wanttype)) )

{

write_error('Please fill out all fields.');

return;

} // if

function show_one_extension($extrow)

{

$extname = $extrow['extname'];

$extid = $extrow['id'];

$wikiurl = get_alext_wiki_url($extname);

echo "<p>$extname (<a href='${wikiurl}'>docs</a>)\n";

echo "<p>Tokens:\n<ul>\n";

$sql = 'select * from alextreg_tokens as tok' .

' left outer join alextreg_extensions as ext' .

' on tok.extid=ext.id';

$query = do_dbquery($sql);

if ($query == false)

return; // uh...?

else if ($query == 0)

echo " <li> (no new tokens.)\n";

else

{

while ( ($row = db_fetch_array($query)) != false )

{

$hex = sprintf("0x%X", $row['tokenval']); // !!! FIXME: faster way to do this?

echo " <li> ${row['tokenname']} ($hex):";

echo " added ${row['entrydate']},";

echo " last modified ${row['lastedit']}\n";

} // while

} // else

db_free_results($query);

echo "</ul>\n";

echo "<p>Entry points:\n<ul>\n";

$sql = 'select * from alextreg_entrypoints as ent' .

' left outer join alextreg_extensions as ext' .

' on ent.extid=ext.id';

$query = do_dbquery($sql);

if ($query == false)

return; // uh...?

else if ($query == 0)

echo " <li> (no new entry points.)\n";

else

{

while ( ($row = db_fetch_array($query)) != false )

{

echo " <li> ${row['entrypointname']}:";

echo " added ${row['entrydate']},";

echo " last modified ${row['lastedit']}\n";

} // while

} // else

db_free_results($query);

echo "</ul>\n";

echo "<hr>\n";

} // show_one_extension

$operations['op_findall'] = 'op_findall';

function op_findall()

{

$operations['op_showext'] = 'op_showext';

function op_showext()

{

$extname = $_REQUEST['extname'];

if (empty($extname))

{

write_error('No extension specified.');

return;

} // if

$sqlwantname = db_escape_string($wantname);

$sql = "select * from alextreg_extensions" .

" where extname='$sqlwantname'";

$query = do_dbquery($sql);

if ($query == false)

return; // error output is handled in database.php ...

else if (db_num_rows($query) == 0)

write_error('No such extension.');

else

{

// just in case there's more than one for some reason...

while ( ($row = db_fetch_array($query)) != false )

show_one_extension($row);

} // else

db_free_result($query);

} // op_showext

function render_search_ui()

{

print <<<EOF

<p>

Where do you want to go today?

<p>

<form method="post" action="${_SERVER['PHP_SELF']}">

I want

<select name="wanttype" size="1">

<option selected value="extension">an extension</option>

<option value="tokenname">a token name</option>

<option value="tokenvalue">a token value</option>

<option value="entrypoint">an entry point</option>

<option value="anything">anything</option>

</select>

named <input type="text" name="wantname" value="">.

<input type="hidden" name="operation" value="op_findone">

<input type="submit" name="form_submit" value="Go!">

<input type="reset" value="Clear">

</form>

<p>

...or...

<p>

<form method="post" action="${_SERVER['PHP_SELF']}">

I want a list of all known

<select name="wanttype" size="1">

<option selected value="extension">extensions</option>

<option value="tokenname">tokens</option>

<option value="entrypoint">entry points</option>

</select>.

<input type="hidden" name="operation" value="op_findall">

<input type="submit" name="form_submit" value="Go!">

</form>

EOF;

} // render_search_ui