";
include("template/1.newsite.txt");
print "Digi Knowledge Base\n";
include("template/2.newsite.txt");
if($ta_os == "") {
print "TA Home > \n";
# print "Select OS:\n";
include("template/3.newsite.txt");
print "Digi Knowledge Base\n";
include("template/4.newsite.txt");
$query = "select table_table,table_name,table_value from select_table where table_table like 'ta_os' and table_name != '' order by table_value;";
$result = mysql_query($query);
$count = mysql_num_rows($result);
print "
| Choose your Operating System: | \n";
print "\n";
print " |
\n";
}
if($ta_os != "") {
if($ta_os != "kbase_any") {
$query = "select table_value from select_table where table_name = '$ta_os' and table_table = 'ta_os' order by table_value;";
$result = mysql_query($query);
$os = @mysql_result($result,0,"table_value");
} else {
$os = "Any OS";
}
if($os != "") {
print "TA Home > \n";
print "$os \n";
}
if($ta_prod == "") {
include("template/3.newsite.txt");
print "Digi Knowledge Base\n";
include("template/4.newsite.txt");
$query = "select table_table,table_name,table_value from select_table where table_table = 'ta_prod' and table_name != '' order by table_value;";
$result = mysql_query($query);
$count = mysql_num_rows($result);
# print "> Select Product:\n";
print "
| Choose your Product: | \n";
print "\n";
print " |
\n";
}
if($ta_prod != "") {
if($ta_prod != "kbase_any") {
$query = "select table_value from select_table where table_name = '$ta_prod' and table_table = 'ta_prod' order by table_value;";
$result = mysql_query($query);
$prod = @mysql_result($result,0,"table_value");
} else {
$prod = "Any Product";
}
if($prod != "") {
print "> $prod \n";
}
if($ta_subcat == "") {
$query = "select table_table,table_name,table_value from select_table where table_table = 'ta_subcat' and table_name != '' order by table_value;";
$result = mysql_query($query);
$count = mysql_num_rows($result);
# print "> Select Category:\n";
include("template/3.newsite.txt");
print "Digi Knowledge Base\n";
include("template/4.newsite.txt");
print "
| Choose your Category: | \n";
print "\n";
print " |
\n";
}
if($ta_subcat != "") {
if($ta_subcat != "kbase_any") {
$query = "select table_value from select_table where table_name = '$ta_subcat' and table_table = 'ta_subcat' order by table_value;";
$result = mysql_query($query);
$subcat = @mysql_result($result,0,"table_value");
} else {
$subcat = "Any Category";
}
if($subcat != "") {
print "> $subcat";
}
if($ta_n == "") {
## $query = "select ta_n,ta_t from ta_article where ta_os like '%$ta_os%' and ta_prod like '%$ta_prod%' and ta_subcat like '%$ta_subcat%' and ta_active = 'N'";
$querybase = "select ta_n,ta_t from ta_article";
$query = $querybase;
$queryappend = array ();
$queryappend2 = array ();
( $ta_os != "kbase_any" ) && array_push($queryappend, "ta_os like '%$ta_os%'");
( $ta_prod != "kbase_any" ) && array_push($queryappend, "ta_prod like '%$ta_prod%'");
( $ta_subcat != "kbase_any" ) && array_push($queryappend, "ta_subcat like '%$ta_subcat%'");
# This causes it to only pick up unapproved articles:
# array_push($queryappend2, "ta_active = 'N'");
array_push($queryappend, "ta_active = 'Y'");
array_push($queryappend, "ta_internal = 'fals'");
$query = $querybase;
# if ($queryappend2) { $query2 = $query . " where " . join(" and ", $queryappend2) . ";"; }
if ($queryappend) { $query .= " where " . join(" and ", $queryappend); }
# $query .= ";";
$query .= " order by ta_n;";
$result = mysql_query($query);
# if ($query2) { $result2 = mysql_query($query2); }
include("template/3.newsite.txt");
print "Digi Knowledge Base\n";
include("template/4.newsite.txt");
$count = mysql_num_rows($result);
print "\n";
print "| Query results ($count): |
|---|
\n";
for($id = 0; $id < $count; $id++) {
$url = mysql_result($result,$id,"ta_n");
$title = mysql_result($result,$id,"ta_t");
print "| $title |
";
}
if ($query2) {
$count = mysql_num_rows($result2);
print "| Unapproved articles ($count): |
|---|
\n";
for($id = 0; $id < $count; $id++) {
$url = mysql_result($result2,$id,"ta_n");
$title = mysql_result($result2,$id,"ta_t");
print "| $title |
";
}
}
print "
\n";
}
if($ta_n != "") {
$query = "select * from ta_article where ta_n = '$ta_n';";
# This only hits unapproved ta's: and ta_active = 'N';";
$result = mysql_query($query);
$ta = @mysql_result($result,0,"ta_n");
$title = @mysql_result($result,0,"ta_t");
if($ta != "") {
print "> $ta\n";
include("template/3.newsite.txt");
print "Digi Knowledge Base\n";
include("template/4.newsite.txt");
printf(ta_article("$ta_n"));
}
}
}
}
}
print "
";
include("template/5.newsite.txt");
mysql_close($db);
?>