# HG changeset patch
# User Matti Hamalainen <ccr@tnsp.org>
# Date 1422357224 -7200
# Node ID 30bb894cfb5834be2a8103f471900883ec33ae83
# Parent  9858b93387a2a0d33e81a7af47a840e7a9640dcf
Updated a bit.

diff -r 9858b93387a2 -r 30bb894cfb58 urlredirect.php.txt
--- a/urlredirect.php.txt	Tue Jan 27 08:44:15 2015 +0200
+++ b/urlredirect.php.txt	Tue Jan 27 13:13:44 2015 +0200
@@ -1,7 +1,7 @@
 <?
 /* ==========================================================
  * URLLog PHP-script for redirecting ShortURLs
- * (C) Copyright 2006-2011 Tecnic Software productions (TNSP)
+ * (C) Copyright 2006-2015 Tecnic Software productions (TNSP)
  * ==========================================================
  * How to set up short URL redirection:
  *
@@ -26,8 +26,18 @@
  *
  * 6) Profit.
  */
-// SQLite3 database file path and name
-$dbFilename = "/path/to/urllog.sqlite";
+try {
+  // You need to uncomment and configure one of the PDO object
+  // initialization lines below, depending on what kind of SQL
+  // database you are using.
+
+  // If using SQLite3, set the filename / path there:
+  //$db = new PDO("sqlite:/path/to/urllog.sqlite");
+}
+catch (PDOException $e) {
+  myerr("Could not connect to URL database: ".$e->getMessage().".");
+}
+
 
 // ==========================================================
 // Helper functions
@@ -71,14 +81,7 @@
   myerr("Invalid ID.");
 
 
-// Find the URL
-try {
-  $db = new PDO("sqlite:".$dbFilename);
-}
-catch (PDOException $e) {
-  myerr("Could not connect to URL database: ".$e->getMessage().".");
-}
-
+// Find the matching URL, if any
 foreach ($db->query("SELECT url FROM urls WHERE id=".$urlID) as $row)
 {
   header("Location: ".$row["url"]);