Git commit e8ec87955cf5e4e355986959ea3ed8693ee102cb by Chris Howells.
Committed on 19/10/2006 at 12:48.
Pushed by whiting into branch 'master'.

go away

D  +0    -61   banking/admin.php
D  +0    -38   banking/authorise.inc
D  +0    -58   banking/common.inc
D  +0    -73   banking/edit.php
D  +0    -195  banking/index.php
D  +0    -64   banking/submit.php

http://commits.kde.org/websites/konqueror-org/e8ec87955cf5e4e355986959ea3ed=
8693ee102cb

diff --git a/banking/admin.php b/banking/admin.php
deleted file mode 100644
index 2af2fb0..0000000
--- a/banking/admin.php
+++ /dev/null
@@ -1,61 +0,0 @@
-<?php
-//error_reporting(E_ALL);
-//ini_set('display_errors', 1);
-?>
-<?php
-  include("authorise.inc");
-  authorise();
-  $site_root =3D "../";
-  $page_title =3D "Konqueror - Online Banking";
-  include("konqueror.inc");
-  include("header.inc");
-  include("common.inc");
-?>
-
-<?php
-	include_once("common.inc");
-
-	$id =3D $_GET['id'];
-
-	$sql =3D "SELECT banks.country, banks.url, banks.name, compat.comment, co=
mpat.kde30, compat.kde31 FROM banks, compat WHERE banks.id =3D '$id' AND co=
mpat.bank =3D '$id'";
-	$query =3D mysql_query($sql) or die("MySQL error: " . mysql_error());
-
-	$row =3D mysql_fetch_array($query);
-	echo "<h1>" . $row['country'] . " - " . $row['name'] . "</h1>";
-?>
-
-
-<form action=3D"<?php echo $_SERVER['PHP_SELF'] ?>" method=3D"POST">
-<input type=3D"hidden" name=3D"submitted" value=3D"true" />
-<table border=3D"0">
-<tr>
-<td>
-Name
-</td>
-<td>
-<input type=3D"text" name=3D"name" value=3D"<?php echo stripslashes($row['=
name']) ?>" />
-</td>
-</tr>
-<tr>
-<td>
-Url
-</td>
-<td>
-<input type=3D"text" name=3D"url" value=3D"<?php echo $row['url'] ?>" />
-</td>
-</tr>
-<tr>
-<td>
-Comment
-</td>
-<td>
-<textarea cols=3D"70" rows=3D"5" name=3D"comment"><?php echo stripslashes(=
$row['comment']) ?></textarea>
-</td>
-</tr>
-</table>
-<input type=3D"submit" caption=3D"Submit" />
-</form>
-
-<?php
- include("footer.inc");
-?>
diff --git a/banking/authorise.inc b/banking/authorise.inc
deleted file mode 100644
index bea84d7..0000000
--- a/banking/authorise.inc
+++ /dev/null
@@ -1,38 +0,0 @@
-<?php
-include("auth.inc");
-
-function authorise()
-{
-	global $host, $username, $password;
-
-	$auth_check =3D mysql_connect($host, $username, $password) or die (mysql_=
error());
-        $db =3D mysql_select_db("wwwkonqueror", $auth_check);
-	//$auth_check =3D mysql_connect("localhost, "konqueror", "konqueror") or =
die (mysql_error());
-	//$db =3D mysql_select_db("wwwkonqueror", $auth_check);
-
-	$auth =3D false;
-
-	if (isset($_SERVER['PHP_AUTH_USER']) && isset($_SERVER['PHP_AUTH_PW']))
-	{
-		$sql =3D "SELECT * from auth";
-		$query =3D mysql_query($sql, $auth_check) or die("error " . mysql_error(=
));
-		while ($row =3D mysql_fetch_array($query))
-		{
-			if (($row['user'] =3D=3D $_SERVER['PHP_AUTH_USER']) && ($row['pass'] =
=3D=3D $_SERVER['PHP_AUTH_PW']))
-			{
-				$auth =3D true;
-			}
-		}
-	}
-
-	if (!$auth)
-	{
-		header("WWW-Authenticate: Basic realm=3D\"Private\"");
-		header("HTTP/1.0 401 Unauthorized");
-		exit();
-	}
-
-	mysql_close($auth_check);
-}
-
-?>
diff --git a/banking/common.inc b/banking/common.inc
deleted file mode 100644
index 5533d7c..0000000
--- a/banking/common.inc
+++ /dev/null
@@ -1,58 +0,0 @@
-<?php
-include("auth.inc");
-mysql_connect($host, $username, $password);
-mysql_select_db("wwwkonqueror");
-//mysql_connect("localhost", "konqueror", "konqueror");
-//mysql_select_db("konqueror");
-
-function parseCompat($value)
-{
-	if ($value =3D=3D "four")
-	{
-		return "Works";
-	}
-	else
-	if ($value =3D=3D "three")
-	{
-		return "Small Problems";
-	}
-	if ($value =3D=3D "two")
-	{
-		return "UA Change";
-	}
-	if ($value =3D=3D "one")
-	{
-		return "Not Work";
-	}
-	else
-	{
-		return "Unknown";
-	}
-}
-
-function returnStatistic($sql)
-{
-	$query =3D mysql_query($sql);
-        return mysql_num_rows($query);
-}
-
-function country($string)
-{
-	$country =3D addslashes($string);
-	if (ereg("^[A-Z]{2}$", $string))
-	{
-		$sql =3D "SELECT name FROM country WHERE iso =3D '$country'";
-		$query =3D mysql_query($sql);
-		$value =3D mysql_fetch_array($query);
-		return $value['name'];
-	}
-	else
-	{
-		$sql =3D "SELECT iso FROM country WHERE name =3D '$country'";
-		$query =3D mysql_query($sql);
-		$value =3D mysql_fetch_array($query);
-		return $value['iso'];
-	}
-}
-
-?>
diff --git a/banking/edit.php b/banking/edit.php
deleted file mode 100644
index 22cd93e..0000000
--- a/banking/edit.php
+++ /dev/null
@@ -1,73 +0,0 @@
-<?php
-//error_reporting(E_ALL);
-//ini_set('display_errors', 1);
-?>
-
-<?php
-  $site_root =3D "../";
-  $page_title =3D "Konqueror - Online Banking";
-  include("konqueror.inc");
-  include("header.inc");
-  include("common.inc");
-?>
-
-<?php
-	if (isset($_GET['id']) && isset($_GET['test']))
-	{
-?>
-
-<h2>Replace the following details...</h2>
-
-<?php
-	$selected =3D $_GET['id'];
-	echo "<table border=3D\"0\">\n";
-	echo "<tr id=3D\"leftmenu\">\n<td><h4>Bank</h4></td>\n<td><h4>Comment</h4=
></td>\n<td><h4>KDE 3.0</h4></td>\n<td><h4>KDE 3.1</h4></td>\n<td><h4>KDE 3=
.2</h4></td>\n</tr>\n";
-	$sql =3D "SELECT banks.id, banks.country, banks.url, banks.name, compat.c=
omment, compat.kde30, compat.kde31, compat.kde32 FROM banks, compat WHERE b=
anks.id =3D '$selected' AND compat.bank =3D '$selected'";
-	$query =3D mysql_query($sql);
-	$row =3D mysql_fetch_array($query);
-	echo "<tr>\n";
-	echo "<td valign=3D\"top\"><a href=3D\"" . $row['url'] ."\">" . stripslas=
hes($row['name']) . "</a></td>\n";
-	echo "<td>" . stripslashes($row['comment']) . "</td>\n";
-	echo "<td>" . parseCompat($row['kde30']) . "</td>\n";
-	echo "<td>" . parseCompat($row['kde31']) . "</td>\n";
-	echo "<td>" . parseCompat($row['kde32']) . "</td>\n";
-	echo "</tr>\n";
-	echo "</table>\n";
-?>
-
-<h2>...with the new details</h2>
-
-<form action=3D"submit.php" method=3D"POST">
-<input type=3D"hidden" name=3D"edit" value=3D"true" />
-<label for=3D"nameofbank">Name of Bank:</label>
-<input type=3D"text" name=3D"nameofbank" id=3D"nameofbank" value=3D"<?php =
echo stripslashes($row['name']) ?>" /><br />
-<label for=3D"url">URL:</label>
-<input type=3D"text" name=3D"url" id=3D"url"  value=3D"<?php echo stripsla=
shes($row['url']) ?>"/><br />
-<label for=3D"version">KDE Version:</label>
-<select size=3D"1" name=3D"version" title=3D"Version" id=3D"version">
-<option value=3D"kde30">KDE 3.0</option>
-<option value=3D"kde31">KDE 3.1</option>
-<option value=3D"kde32">KDE 3.2</option>
-</select><br />
-<label for=3D"rating">Rate how well Konqueror works with the site:</label>
-<select size=3D"1" name=3D"rating" title=3D"Rating" id=3D"rating">
-<option value=3D"four">Perfectly</option>
-<option value=3D"three">Very well, with minor problems</option>
-<option value=3D"two">UserAgent needs changing</option>
-<option value=3D"one">Not at all</option>
-</select><br />
-<label for=3D"comment">Comments:</label>
-<textarea rows=3D"4" cols=3D"70" name=3D"comment" id=3D"comment"><?php ech=
o stripslashes($row['comment']) ?></textarea><br />
-<label for=3D"submitter">Submitter Name:</label>
-<input type=3D"text" name=3D"submitter" id=3D"submitter" /><br />
-<label for=3D"email">Submitter E-Mail:</label>
-<input type=3D"text" name=3D"email" id=3D"email" /><br />
-<input type=3D"submit" value=3D"Submit" />
-</form>
-
-<?php
-	}
-?>
-<?php
- include("footer.inc");
-?>
diff --git a/banking/index.php b/banking/index.php
deleted file mode 100644
index eff572e..0000000
--- a/banking/index.php
+++ /dev/null
@@ -1,195 +0,0 @@
-<?php
-//error_reporting(E_ALL);
-//ini_set('display_errors', 1);
-?>
-
-<?php
-  $site_root =3D "../";
-  $page_title =3D "Konqueror - Online Banking";
-  include("konqueror.inc");
-  include("header.inc");
-  include("common.inc");
-?>
-
-<?php
-	$country =3D "";
-	if (!isset($_GET['country']))
-	{
-?>
-
-<h2>Country Selection</h2>
-
-<form action=3D"<?php echo $_SERVER['PHP_SELF'] ?>" method=3D"GET">
-<select size=3D"1" name=3D"country" title=3D"Country">
-<option value=3D"all">All</option>
-<?php
-$sql =3D "SELECT DISTINCT country FROM banks ORDER BY country";
-$query =3D mysql_query($sql);
-while ($row =3D mysql_fetch_array($query))
-{
-	echo "<option value=3D\"" . $row['country'] . "\">" . country($row['count=
ry']) . "</option>\n";
-}
-?>
-</select>
-<input type=3D"submit" caption=3D"Submit" />
-</form>
-
-<p>If your country is not listed in the above list please use the form bel=
ow to submit details.</p>
-
-<h2>Statistics</h2>
-<ul>
-<li>Number of countries: <?php echo returnStatistic("SELECT DISTINCT count=
ry FROM banks") ?></li>
-</ul>
-
-<table border=3D"1">
-<tr>
-<td>
-Version
-</td>
-<td>
-Does not work
-</td>
-<td>
-UA change
-</td>
-<td>
-Works mostly
-</td>
-<td>
-Works perfectly
-</td>
-</tr>
-
-<?php
-for ($i =3D 0; $i <=3D 2; $i++)
-{
-?>
-
-<tr>
-<td>
-Konqueror 3.<?php echo $i ?>
-</td>
-<td>
-<?php echo returnStatistic("SELECT * FROM compat WHERE kde3" . $i . " =3D =
'one'") ?>
-</td>
-<td>
-<?php echo returnStatistic("SELECT * FROM compat WHERE kde3" . $i . " =3D =
'two'") ?>
-</td>
-<td>
-<?php echo returnStatistic("SELECT * FROM compat WHERE kde3" . $i . " =3D =
'three'") ?>
-</td>
-<td>
-<?php echo returnStatistic("SELECT * FROM compat WHERE kde3" . $i . " =3D =
'four'") ?>
-</td>
-</tr>
-
-<?php
-}
-?>
-</table>
-
-<?php
-	}
-	else if (isset($_GET['country']))
-	{
-?>
-
-<?php
-	$selected =3D $_GET['country'];
-	echo "<table border=3D\"0\">";
-	$sql =3D "";
-	if ($selected =3D=3D "all")
-	{
-		$sql =3D "SELECT DISTINCT country FROM banks ORDER BY country";
-	}
-	else
-	{
-		$sql =3D "SELECT DISTINCT country FROM banks WHERE country =3D '$selecte=
d'";
-	}
-	$query =3D mysql_query($sql);
-	$num =3D mysql_num_rows($query);
-
-	if ($num =3D=3D 0)
-	{
-		echo "<p>No banks known for selected country.</p>";
-	}
-	while ($row =3D mysql_fetch_array($query))
-	{
-		$country =3D $row['country'];
-		echo "<tr><td colspan=3D\"4\"><h2>" . country($row['country']) . "</h2><=
/td></tr>\n";
-		echo "<tr id=3D\"leftmenu\">\n<td><h4>Bank</h4></td>\n<td><h4>Comment</h=
4></td>\n<td><h4>KDE 3.0</h4></td>\n<td><h4>KDE 3.1</h4></td>\n<td><h4>KDE =
3.2</h4></td>\n<td><h4>Edit</h4></td>\n</tr>\n";
-		$sql2 =3D "SELECT banks.id, banks.country, banks.url, banks.name, compat=
.comment, compat.kde30, compat.kde31, compat.kde32 FROM banks, compat WHERE=
 banks.id =3D compat.bank AND country =3D '$country' ORDER BY banks.name";
-		$query2 =3D mysql_query($sql2);
-		$alternate =3D false;
-		while($row2 =3D mysql_fetch_array($query2))
-		{
-			$alternate =3D !$alternate;
-			if ($alternate)
-			{
-				$color =3D "newsbox2";
-			}
-			else
-			{
-				$color =3D "newsbox1";
-			}
-			echo "<tr class=3D\"$color\">\n";
-			echo "<td valign=3D\"top\"><a href=3D\"" . $row2['url'] ."\">" . strips=
lashes($row2['name']) . "</a></td>\n";
-			echo "<td>" . stripslashes($row2['comment']) . "</td>\n";
-			echo "<td>" . parseCompat($row2['kde30']) . "</td>\n";
-			echo "<td>" . parseCompat($row2['kde31']) . "</td>\n";
-			echo "<td>" . parseCompat($row2['kde32']) . "</td>\n";
-			echo "<td><a href=3D\"edit.php" . "?id=3D" . $row2['id'] . "\">Edit</a>=
</td>\n";
-			echo "</tr>\n";
-		}
-	}
-	echo "</table>\n";
-?>
-
-<?php
-	}
-?>
-
-<h2>Add New Entry</h2>
-
-<form action=3D"submit.php" method=3D"POST">
-<input type=3D"hidden" name=3D"new" value=3D"true" />
-<label for=3D"nameofbank">Name of Bank:</label>
-<input type=3D"text" name=3D"nameofbank" id=3D"nameofbank" /><br />
-<label for=3D"url">URL:</label>
-<input type=3D"text" name=3D"url" id=3D"url" /><br />
-<label for=3D"country">Country:</label>
-<select size=3D"1" name=3D"country" title=3D"Country" id=3D"country">
-<?php                   =

-$sql =3D "SELECT name FROM country ORDER BY name";
-$query =3D mysql_query($sql);
-while ($row =3D mysql_fetch_array($query))
-{       =

-        echo "<option value=3D\"" . country($row['name']) . "\">" . $row['=
name'] . "</option>\n";
-}
-?>
-</select><br />
-<label for=3D"version">KDE Version:</label>
-<select size=3D"1" name=3D"version" title=3D"Version" id=3D"version">
-<option value=3D"kde30">KDE 3.0</option>
-<option value=3D"kde31">KDE 3.1</option>
-<option value=3D"kde32">KDE 3.2</option>
-</select><br />
-<label for=3D"rating">Rate how well Konqueror works with the site:</label>
-<select size=3D"1" name=3D"rating" title=3D"Rating" id=3D"rating">
-<option value=3D"four">Perfectly</option>
-<option value=3D"three">Very well, with minor problems</option>
-<option value=3D"two">UserAgent needs changing</option>
-<option value=3D"one">Not at all</option>
-</select><br />
-<label for=3D"comment">Comments:</label>
-<textarea rows=3D"4" cols=3D"70" name=3D"comment" id=3D"comment"></textare=
a><br />
-<label for=3D"submitter">Submitter Name:</label>
-<input type=3D"text" name=3D"submitter" id=3D"submitter" /><br />
-<label for=3D"email">Submitter E-Mail:</label>
-<input type=3D"text" name=3D"email" id=3D"email" /><br />
-<input type=3D"submit" value=3D"Submit" />
-</form>
-
-<?php
- include("footer.inc");
-?>
diff --git a/banking/submit.php b/banking/submit.php
deleted file mode 100644
index f6a8f4d..0000000
--- a/banking/submit.php
+++ /dev/null
@@ -1,64 +0,0 @@
-<?php
-  $site_root =3D "../";
-  $page_title =3D "Konqueror - Online Banking";
-  include("konqueror.inc");
-  include("header.inc");
-  include("common.inc");
-?>
-
-<?php
-	if (isset($_POST['new']))
-	{
-?>
-
-<?php
-	$name =3D addslashes($_POST['nameofbank']);
-	$url =3D addslashes($_POST['url']);
-	$country =3D country($_POST['country']);
-	$version =3D $_POST['version'];
-	$rating =3D $_POST['rating'];
-	$comment =3D addslashes($_POST['comment']);
-	$submitter =3D addslashes($_POST['submitter']);
-	$email =3D addslashes($_POST['email']);
-
-	$sql =3D "INSERT INTO banks (id, name, url, country) VALUES (NULL, '$coun=
try', '$url', '$name')";
-	mysql_query($sql) or die("MySQL Error: " . mysql_error());
-
-	$sql =3D "SELECT id FROM banks ORDER BY id DESC LIMIT 1";
-	$query =3D mysql_query($sql) or die ("MySQL Error: " . mysql_error());
-	$row =3D mysql_fetch_array($query);
-	$id =3D $row['id'];
-
-	$sql =3D "INSERT INTO compat (bank, comment, $version, display) VALUES ($=
id, '$comment', '$rating', '0')";
-	mysql_query($sql) or die("MySQL Error: " . mysql_error());
-	$sql =3D "INSERT INTO submitter VALUES ($id, '$submitter', '$email')";
-	mysql_query($sql) or die("MySQL Errord: " . mysql_error());
-
-	$body =3D "Moderate at http://www.konqueror.org/banking/moderate.php";
-	$title =3D "Konqueror Banking New Entry";
-?>
-
-<?php
-	}
-	else if (isset($_POST['edit']))
-	{
-?>
-
-<?php
-	$body =3D "Moderate at http://www.konqueror.org/banking/moderate.php";
-	$title =3D "Konqueror Banking Edited Entry";
-?>
-
-<?php
-	}
-?>
-
-<p>Thank you for your submission, it will be checked and will appear on th=
e site shortly.</p>
-
-<?php
-	mail("kde-www@kde.org", $title, $body);
-?>
-
-<?php
- include("footer.inc");
-?>