Home ';
if($PASSWORD_OK){
echo 'Logout ' . "\n";
}else{
echo 'Login ' . "\n";
};
if($INFO_SHOW_STATS_LINK == true){
echo 'Stats ';
};
if($INFO_SHOW_ABOUT_LINK == true){
echo 'About ';
};
?>
Read Later
Add:
close();
?>
2){
$db_query = $db->query('insert into ' . $INFO_TABLE_NAME .
'(URL,DESCRIPTION,STATUS,IMPORTANT,SHOWBOTH,CATEGORY,DATE) values ' .
'("' . $_GET["URL"]. '", " ' . $_GET["DESCRIPTION"] . '", "N",0,0,"OTHER","TODAY");');
if(!$db_query)
{
echo "Something went wrong";
$db->close();
die();
};
};
};
}elseif($_GET["action"]=="edit")
{
if(!$REQUIRE_PASSWORD_TO_EDIT || ($REQUIRE_PASSWORD_TO_EDIT && $PASSWORD_OK)){
$db_query = $db->query("select * from $INFO_TABLE_NAME where ID=".$_GET["ID"]."");
$db_query_result = $db_query->fetchArray(SQLITE3_ASSOC);
?>
query("update $INFO_TABLE_NAME set URL = '" . $_GET["URL"] . "' where ID = " . $_GET["ID"] . "");
$db->query("update $INFO_TABLE_NAME set DESCRIPTION = '" . $_GET["DESCRIPTION"] . "' where ID = " . $_GET["ID"] ."");
$db->query("update $INFO_TABLE_NAME set CATEGORY = '" . $_GET["CATEGORY"] . "' where ID = " . $_GET["ID"] ."");
$db->query("update $INFO_TABLE_NAME set STATUS = '" . $_GET["STATUS"] . "' where ID = " . $_GET["ID"] ."");
if(isset($_GET["IMPORTANT"])){
$db->query("update $INFO_TABLE_NAME set IMPORTANT = 1 where ID = " . $_GET["ID"] ."");
}else{
$db->query("update $INFO_TABLE_NAME set IMPORTANT = 0 where ID = " . $_GET["ID"] ."");
};
if(isset($_GET["SHOWBOTH"])){
$db->query("update $INFO_TABLE_NAME set SHOWBOTH = 1 where ID = " . $_GET["ID"] ."");
}else{
$db->query("update $INFO_TABLE_NAME set SHOWBOTH = 0 where ID = " . $_GET["ID"] ."");
};
};
}elseif($_GET["action"]=="delete")
{
if(!$REQUIRE_PASSWORD_TO_EDIT || ($REQUIRE_PASSWORD_TO_EDIT && $PASSWORD_OK)){
$db->query("delete from $INFO_TABLE_NAME where ID=" . $_GET["ID"] . "");
};
}elseif($_GET["action"]=="stats")
{
echo "Require password to view: $REQUIRE_PASSWORD_TO_VIEW
\n";
echo "Require password to add: $REQUIRE_PASSWORD_TO_ADD
\n";
echo "Require password to edit: $REQUIRE_PASSWORD_TO_EDIT
\n";
$db->close();
echo "