From 77deb2bd910e85faaff21344b64dab9338b6f8ae Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Thu, 16 Aug 2007 00:24:33 +0000
Subject: added GPL2 as our license this was an agreeable action to Simo,
 Jason, and Paul we are the remaining principal authors

---
 COPYING | 339 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 339 insertions(+)
 create mode 100644 COPYING

diff --git a/COPYING b/COPYING
new file mode 100644
index 0000000..d511905
--- /dev/null
+++ b/COPYING
@@ -0,0 +1,339 @@
+		    GNU GENERAL PUBLIC LICENSE
+		       Version 2, June 1991
+
+ Copyright (C) 1989, 1991 Free Software Foundation, Inc.,
+ 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
+ Everyone is permitted to copy and distribute verbatim copies
+ of this license document, but changing it is not allowed.
+
+			    Preamble
+
+  The licenses for most software are designed to take away your
+freedom to share and change it.  By contrast, the GNU General Public
+License is intended to guarantee your freedom to share and change free
+software--to make sure the software is free for all its users.  This
+General Public License applies to most of the Free Software
+Foundation's software and to any other program whose authors commit to
+using it.  (Some other Free Software Foundation software is covered by
+the GNU Lesser General Public License instead.)  You can apply it to
+your programs, too.
+
+  When we speak of free software, we are referring to freedom, not
+price.  Our General Public Licenses are designed to make sure that you
+have the freedom to distribute copies of free software (and charge for
+this service if you wish), that you receive source code or can get it
+if you want it, that you can change the software or use pieces of it
+in new free programs; and that you know you can do these things.
+
+  To protect your rights, we need to make restrictions that forbid
+anyone to deny you these rights or to ask you to surrender the rights.
+These restrictions translate to certain responsibilities for you if you
+distribute copies of the software, or if you modify it.
+
+  For example, if you distribute copies of such a program, whether
+gratis or for a fee, you must give the recipients all the rights that
+you have.  You must make sure that they, too, receive or can get the
+source code.  And you must show them these terms so they know their
+rights.
+
+  We protect your rights with two steps: (1) copyright the software, and
+(2) offer you this license which gives you legal permission to copy,
+distribute and/or modify the software.
+
+  Also, for each author's protection and ours, we want to make certain
+that everyone understands that there is no warranty for this free
+software.  If the software is modified by someone else and passed on, we
+want its recipients to know that what they have is not the original, so
+that any problems introduced by others will not reflect on the original
+authors' reputations.
+
+  Finally, any free program is threatened constantly by software
+patents.  We wish to avoid the danger that redistributors of a free
+program will individually obtain patent licenses, in effect making the
+program proprietary.  To prevent this, we have made it clear that any
+patent must be licensed for everyone's free use or not licensed at all.
+
+  The precise terms and conditions for copying, distribution and
+modification follow.
+
+		    GNU GENERAL PUBLIC LICENSE
+   TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION
+
+  0. This License applies to any program or other work which contains
+a notice placed by the copyright holder saying it may be distributed
+under the terms of this General Public License.  The "Program", below,
+refers to any such program or work, and a "work based on the Program"
+means either the Program or any derivative work under copyright law:
+that is to say, a work containing the Program or a portion of it,
+either verbatim or with modifications and/or translated into another
+language.  (Hereinafter, translation is included without limitation in
+the term "modification".)  Each licensee is addressed as "you".
+
+Activities other than copying, distribution and modification are not
+covered by this License; they are outside its scope.  The act of
+running the Program is not restricted, and the output from the Program
+is covered only if its contents constitute a work based on the
+Program (independent of having been made by running the Program).
+Whether that is true depends on what the Program does.
+
+  1. You may copy and distribute verbatim copies of the Program's
+source code as you receive it, in any medium, provided that you
+conspicuously and appropriately publish on each copy an appropriate
+copyright notice and disclaimer of warranty; keep intact all the
+notices that refer to this License and to the absence of any warranty;
+and give any other recipients of the Program a copy of this License
+along with the Program.
+
+You may charge a fee for the physical act of transferring a copy, and
+you may at your option offer warranty protection in exchange for a fee.
+
+  2. You may modify your copy or copies of the Program or any portion
+of it, thus forming a work based on the Program, and copy and
+distribute such modifications or work under the terms of Section 1
+above, provided that you also meet all of these conditions:
+
+    a) You must cause the modified files to carry prominent notices
+    stating that you changed the files and the date of any change.
+
+    b) You must cause any work that you distribute or publish, that in
+    whole or in part contains or is derived from the Program or any
+    part thereof, to be licensed as a whole at no charge to all third
+    parties under the terms of this License.
+
+    c) If the modified program normally reads commands interactively
+    when run, you must cause it, when started running for such
+    interactive use in the most ordinary way, to print or display an
+    announcement including an appropriate copyright notice and a
+    notice that there is no warranty (or else, saying that you provide
+    a warranty) and that users may redistribute the program under
+    these conditions, and telling the user how to view a copy of this
+    License.  (Exception: if the Program itself is interactive but
+    does not normally print such an announcement, your work based on
+    the Program is not required to print an announcement.)
+
+These requirements apply to the modified work as a whole.  If
+identifiable sections of that work are not derived from the Program,
+and can be reasonably considered independent and separate works in
+themselves, then this License, and its terms, do not apply to those
+sections when you distribute them as separate works.  But when you
+distribute the same sections as part of a whole which is a work based
+on the Program, the distribution of the whole must be on the terms of
+this License, whose permissions for other licensees extend to the
+entire whole, and thus to each and every part regardless of who wrote it.
+
+Thus, it is not the intent of this section to claim rights or contest
+your rights to work written entirely by you; rather, the intent is to
+exercise the right to control the distribution of derivative or
+collective works based on the Program.
+
+In addition, mere aggregation of another work not based on the Program
+with the Program (or with a work based on the Program) on a volume of
+a storage or distribution medium does not bring the other work under
+the scope of this License.
+
+  3. You may copy and distribute the Program (or a work based on it,
+under Section 2) in object code or executable form under the terms of
+Sections 1 and 2 above provided that you also do one of the following:
+
+    a) Accompany it with the complete corresponding machine-readable
+    source code, which must be distributed under the terms of Sections
+    1 and 2 above on a medium customarily used for software interchange; or,
+
+    b) Accompany it with a written offer, valid for at least three
+    years, to give any third party, for a charge no more than your
+    cost of physically performing source distribution, a complete
+    machine-readable copy of the corresponding source code, to be
+    distributed under the terms of Sections 1 and 2 above on a medium
+    customarily used for software interchange; or,
+
+    c) Accompany it with the information you received as to the offer
+    to distribute corresponding source code.  (This alternative is
+    allowed only for noncommercial distribution and only if you
+    received the program in object code or executable form with such
+    an offer, in accord with Subsection b above.)
+
+The source code for a work means the preferred form of the work for
+making modifications to it.  For an executable work, complete source
+code means all the source code for all modules it contains, plus any
+associated interface definition files, plus the scripts used to
+control compilation and installation of the executable.  However, as a
+special exception, the source code distributed need not include
+anything that is normally distributed (in either source or binary
+form) with the major components (compiler, kernel, and so on) of the
+operating system on which the executable runs, unless that component
+itself accompanies the executable.
+
+If distribution of executable or object code is made by offering
+access to copy from a designated place, then offering equivalent
+access to copy the source code from the same place counts as
+distribution of the source code, even though third parties are not
+compelled to copy the source along with the object code.
+
+  4. You may not copy, modify, sublicense, or distribute the Program
+except as expressly provided under this License.  Any attempt
+otherwise to copy, modify, sublicense or distribute the Program is
+void, and will automatically terminate your rights under this License.
+However, parties who have received copies, or rights, from you under
+this License will not have their licenses terminated so long as such
+parties remain in full compliance.
+
+  5. You are not required to accept this License, since you have not
+signed it.  However, nothing else grants you permission to modify or
+distribute the Program or its derivative works.  These actions are
+prohibited by law if you do not accept this License.  Therefore, by
+modifying or distributing the Program (or any work based on the
+Program), you indicate your acceptance of this License to do so, and
+all its terms and conditions for copying, distributing or modifying
+the Program or works based on it.
+
+  6. Each time you redistribute the Program (or any work based on the
+Program), the recipient automatically receives a license from the
+original licensor to copy, distribute or modify the Program subject to
+these terms and conditions.  You may not impose any further
+restrictions on the recipients' exercise of the rights granted herein.
+You are not responsible for enforcing compliance by third parties to
+this License.
+
+  7. If, as a consequence of a court judgment or allegation of patent
+infringement or for any other reason (not limited to patent issues),
+conditions are imposed on you (whether by court order, agreement or
+otherwise) that contradict the conditions of this License, they do not
+excuse you from the conditions of this License.  If you cannot
+distribute so as to satisfy simultaneously your obligations under this
+License and any other pertinent obligations, then as a consequence you
+may not distribute the Program at all.  For example, if a patent
+license would not permit royalty-free redistribution of the Program by
+all those who receive copies directly or indirectly through you, then
+the only way you could satisfy both it and this License would be to
+refrain entirely from distribution of the Program.
+
+If any portion of this section is held invalid or unenforceable under
+any particular circumstance, the balance of the section is intended to
+apply and the section as a whole is intended to apply in other
+circumstances.
+
+It is not the purpose of this section to induce you to infringe any
+patents or other property right claims or to contest validity of any
+such claims; this section has the sole purpose of protecting the
+integrity of the free software distribution system, which is
+implemented by public license practices.  Many people have made
+generous contributions to the wide range of software distributed
+through that system in reliance on consistent application of that
+system; it is up to the author/donor to decide if he or she is willing
+to distribute software through any other system and a licensee cannot
+impose that choice.
+
+This section is intended to make thoroughly clear what is believed to
+be a consequence of the rest of this License.
+
+  8. If the distribution and/or use of the Program is restricted in
+certain countries either by patents or by copyrighted interfaces, the
+original copyright holder who places the Program under this License
+may add an explicit geographical distribution limitation excluding
+those countries, so that distribution is permitted only in or among
+countries not thus excluded.  In such case, this License incorporates
+the limitation as if written in the body of this License.
+
+  9. The Free Software Foundation may publish revised and/or new versions
+of the General Public License from time to time.  Such new versions will
+be similar in spirit to the present version, but may differ in detail to
+address new problems or concerns.
+
+Each version is given a distinguishing version number.  If the Program
+specifies a version number of this License which applies to it and "any
+later version", you have the option of following the terms and conditions
+either of that version or of any later version published by the Free
+Software Foundation.  If the Program does not specify a version number of
+this License, you may choose any version ever published by the Free Software
+Foundation.
+
+  10. If you wish to incorporate parts of the Program into other free
+programs whose distribution conditions are different, write to the author
+to ask for permission.  For software which is copyrighted by the Free
+Software Foundation, write to the Free Software Foundation; we sometimes
+make exceptions for this.  Our decision will be guided by the two goals
+of preserving the free status of all derivatives of our free software and
+of promoting the sharing and reuse of software generally.
+
+			    NO WARRANTY
+
+  11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY
+FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW.  EXCEPT WHEN
+OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES
+PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED
+OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF
+MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.  THE ENTIRE RISK AS
+TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU.  SHOULD THE
+PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING,
+REPAIR OR CORRECTION.
+
+  12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
+WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR
+REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES,
+INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING
+OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED
+TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY
+YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER
+PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE
+POSSIBILITY OF SUCH DAMAGES.
+
+		     END OF TERMS AND CONDITIONS
+
+	    How to Apply These Terms to Your New Programs
+
+  If you develop a new program, and you want it to be of the greatest
+possible use to the public, the best way to achieve this is to make it
+free software which everyone can redistribute and change under these terms.
+
+  To do so, attach the following notices to the program.  It is safest
+to attach them to the start of each source file to most effectively
+convey the exclusion of warranty; and each file should have at least
+the "copyright" line and a pointer to where the full notice is found.
+
+    <one line to give the program's name and a brief idea of what it does.>
+    Copyright (C) <year>  <name of author>
+
+    This program is free software; you can redistribute it and/or modify
+    it under the terms of the GNU General Public License as published by
+    the Free Software Foundation; either version 2 of the License, or
+    (at your option) any later version.
+
+    This program is distributed in the hope that it will be useful,
+    but WITHOUT ANY WARRANTY; without even the implied warranty of
+    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
+    GNU General Public License for more details.
+
+    You should have received a copy of the GNU General Public License along
+    with this program; if not, write to the Free Software Foundation, Inc.,
+    51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
+
+Also add information on how to contact you by electronic and paper mail.
+
+If the program is interactive, make it output a short notice like this
+when it starts in an interactive mode:
+
+    Gnomovision version 69, Copyright (C) year name of author
+    Gnomovision comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
+    This is free software, and you are welcome to redistribute it
+    under certain conditions; type `show c' for details.
+
+The hypothetical commands `show w' and `show c' should show the appropriate
+parts of the General Public License.  Of course, the commands you use may
+be called something other than `show w' and `show c'; they could even be
+mouse-clicks or menu items--whatever suits your program.
+
+You should also get your employer (if you work as a programmer) or your
+school, if any, to sign a "copyright disclaimer" for the program, if
+necessary.  Here is a sample; alter the names:
+
+  Yoyodyne, Inc., hereby disclaims all copyright interest in the program
+  `Gnomovision' (which makes passes at compilers) written by James Hacker.
+
+  <signature of Ty Coon>, 1 April 1989
+  Ty Coon, President of Vice
+
+This General Public License does not permit incorporating your program into
+proprietary programs.  If your program is a subroutine library, you may
+consider it more useful to permit linking proprietary applications with the
+library.  If this is what you want to do, use the GNU Lesser General
+Public License instead of this License.
-- 
cgit v1.2.3-70-g09d2


From ac0f6b855e271c7a676cde008f172e26c68c630d Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Thu, 16 Aug 2007 00:24:35 +0000
Subject: Added XSS patches from Joerie de Gram.

---
 web/html/index.php | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

diff --git a/web/html/index.php b/web/html/index.php
index 2e697df..eddf3ed 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -14,10 +14,10 @@ $login_error = "";
 if (isset($_REQUEST["user"]) || isset($_REQUEST["pass"])) {
 	# Attempting to log in
 	#
-	if (!isset($_REQUEST['user'])) {
+	if (!isset($_REQUEST["user"])) {
 		$login_error = __("You must supply a username.");
 	}
-	if (!isset($_REQUEST['pass'])) {
+	if (!isset($_REQUEST["pass"])) {
 		$login_error = __("You must supply a password.");
 	}
 	if (!$login_error) {
@@ -33,12 +33,12 @@ if (isset($_REQUEST["user"]) || isset($_REQUEST["pass"])) {
 		$result = db_query($q, $dbh);
 		if (!$result) {
 			$login_error = __("Error looking up username, %s.",
-						array($_REQUEST["user"]));
+						array(htmlspecialchars($_REQUEST["user"])));
 		} else {
 			$row = mysql_fetch_row($result);
 			if (empty($row)) {
 				$login_error = __("Incorrect password for username, %s.",
-						array($_REQUEST["user"]));
+						array(htmlspecialchars($_REQUEST["user"])));
 			} elseif ($row[1]) {
 				$login_error = __("Your account has been suspended.");
 			}
@@ -223,12 +223,12 @@ $safe_count = $row[0];
 $user = username_from_sid($_COOKIE["AURSID"]);
 
 if (!empty($user)) {
-    $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Users.Username='$user'";
+    $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'unsupported' AND Users.Username='".mysql_real_escape_string($user)."'";
     $result = db_query($q, $dbh);
     $row = mysql_fetch_row($result);
     $maintainer_unsupported_count = $row[0];
     
-    $q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='$user'";
+    $q = "SELECT count(*) FROM Packages,Users WHERE Packages.OutOfDate = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
     $result = db_query($q, $dbh);
     $row = mysql_fetch_row($result);
     $flagged_outdated = $row[0];
@@ -253,7 +253,7 @@ if (!empty($user)) {
     $atype = account_from_sid($_COOKIE["AURSID"]);
     
     if ($atype == 'Trusted User') {    
-        $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'community' AND Users.Username='$user'";
+        $q = "SELECT count(*) FROM Packages,PackageLocations,Users WHERE Packages.MaintainerUID = Users.ID AND Packages.LocationID = PackageLocations.ID AND PackageLocations.Location = 'community' AND Users.Username='".mysql_real_escape_string($user)."'";
         $result = db_query($q, $dbh);
         $row = mysql_fetch_row($result);
         $maintainer_community_count = $row[0];
@@ -278,7 +278,7 @@ if (!empty($user)) {
     print "<tr>";
     print "<td class='boxSoft'>";
     if ($atype == 'Trusted User') {
-	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.VerifiedBy = Users.ID AND Users.Username='$user'";
+	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.VerifiedBy = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
 	$result = db_query($q, $dbh);
 	$row = mysql_fetch_row($result);
 	$flagged_safe = $row[0];
@@ -287,7 +287,7 @@ if (!empty($user)) {
     }
     else
     {
-	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='$user'";
+	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.MaintainerUID = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
 	$result = db_query($q, $dbh);
 	$row = mysql_fetch_row($result);
 	$flagged_safe = $row[0];
-- 
cgit v1.2.3-70-g09d2


From 1e9b3e2db08a02a877e06c00a9320e6493bbaf80 Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Thu, 16 Aug 2007 00:24:37 +0000
Subject: committed old schema change from old version

---
 support/schema/aur-schema.sql | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/support/schema/aur-schema.sql b/support/schema/aur-schema.sql
index 6c601f1..7e3bf2d 100644
--- a/support/schema/aur-schema.sql
+++ b/support/schema/aur-schema.sql
@@ -106,7 +106,7 @@ INSERT INTO PackageLocations (Location) VALUES ('unstable');
 --
 CREATE TABLE Packages (
 	ID INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
-	Name CHAR(32) NOT NULL,
+	Name CHAR(64) NOT NULL,
 	Version CHAR(32) NOT NULL DEFAULT '',
 	CategoryID TINYINT UNSIGNED NOT NULL DEFAULT 1,
 	Description CHAR(255) NOT NULL DEFAULT "An Arch Package",
-- 
cgit v1.2.3-70-g09d2


From fe84915465ac941356f50cc07925e3fd42615955 Mon Sep 17 00:00:00 2001
From: pjmattal <pjmattal>
Date: Thu, 16 Aug 2007 00:24:43 +0000
Subject: added language for version 1.3.1

---
 VERSIONS.txt       | 1 +
 web/html/index.php | 2 +-
 2 files changed, 2 insertions(+), 1 deletion(-)

diff --git a/VERSIONS.txt b/VERSIONS.txt
index f991a52..9b598fc 100644
--- a/VERSIONS.txt
+++ b/VERSIONS.txt
@@ -17,3 +17,4 @@ Version 1.2.8 = Revision 273 (01/04/05)
 Version 1.2.9 = Revision 281 (06/09/06)
 Version 1.2.10 = Revision 299 (08/09/06)
 Version 1.3.0 = Revision 332 (02/22/07)
+Version 1.3.1 = Revision 360 (09/19/07)
diff --git a/web/html/index.php b/web/html/index.php
index eddf3ed..56c52a2 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -359,6 +359,6 @@ print "</tr>\n";
 print "</table>\n";
 # End Table 1
 
-html_footer("<b>Version 1.3.0</b> \$Id$");
+html_footer("<b>Version 1.3.1</b> \$Id$");
 # vim: ts=2 sw=2 noet ft=php
 ?>
-- 
cgit v1.2.3-70-g09d2


From 14df0d4b8d95f4c0240c0bd98c6ce9b74706e3ca Mon Sep 17 00:00:00 2001
From: swiergot <swiergot>
Date: Thu, 16 Aug 2007 00:25:04 +0000
Subject: - Applied a patch from Loui to fix session removal. - Replaced all
 occurences of mysql_escape_string()   with mysql_real_escape_string().

---
 web/html/account.php   |  2 +-
 web/html/index.php     |  4 ++--
 web/html/logout.php    |  4 ++--
 web/html/pkgedit.php   |  2 +-
 web/html/pkgsubmit.php | 46 +++++++++++++++++++++++-----------------------
 web/lib/acctfuncs.inc  | 36 ++++++++++++++++++------------------
 web/lib/aur.inc        | 22 +++++++++++-----------
 web/lib/pkgfuncs.inc   | 26 +++++++++++++-------------
 8 files changed, 71 insertions(+), 71 deletions(-)

diff --git a/web/html/account.php b/web/html/account.php
index eeb1e40..fba90dd 100644
--- a/web/html/account.php
+++ b/web/html/account.php
@@ -106,7 +106,7 @@ if (isset($_COOKIE["AURSID"])) {
 			$q.= "WHERE AccountTypes.ID = Users.AccountTypeID ";
 			$q.= "AND Users.ID = Sessions.UsersID ";
 			$q.= "AND Sessions.SessionID = '";
-			$q.= mysql_escape_string($_COOKIE["AURSID"])."'";
+			$q.= mysql_real_escape_string($_COOKIE["AURSID"])."'";
 			$result = db_query($q, $dbh);
 			if (!mysql_num_rows($result)) {
 				print __("Could not retrieve information for the specified user.");
diff --git a/web/html/index.php b/web/html/index.php
index 56c52a2..3915483 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -28,8 +28,8 @@ if (isset($_REQUEST["user"]) || isset($_REQUEST["pass"])) {
 		$_REQUEST["pass"] = md5($_REQUEST["pass"]);
 		$dbh = db_connect();
 		$q = "SELECT ID, Suspended FROM Users ";
-		$q.= "WHERE Username = '" . mysql_escape_string($_REQUEST["user"]) . "' ";
-		$q.= "AND Passwd = '" . mysql_escape_string($_REQUEST["pass"]) . "'";
+		$q.= "WHERE Username = '" . mysql_real_escape_string($_REQUEST["user"]) . "' ";
+		$q.= "AND Passwd = '" . mysql_real_escape_string($_REQUEST["pass"]) . "'";
 		$result = db_query($q, $dbh);
 		if (!$result) {
 			$login_error = __("Error looking up username, %s.",
diff --git a/web/html/logout.php b/web/html/logout.php
index dac7831..be4027f 100644
--- a/web/html/logout.php
+++ b/web/html/logout.php
@@ -11,9 +11,9 @@ set_lang();                 # this sets up the visitor's language
 # sending any HTML output.
 #
 if (isset($_COOKIE["AURSID"])) {
-	$q = "DELETE FROM Sessions WHERE SessionID = '";
-	$q.= mysql_escape_string($_COOKIE["AURSID"]) . "'";
 	$dbh = db_connect();
+	$q = "DELETE FROM Sessions WHERE SessionID = '";
+	$q.= mysql_real_escape_string($_COOKIE["AURSID"]) . "'";
 	db_query($q, $dbh);
 	setcookie("AURSID", "", time() - (60*60*24*30), "/");
 	setcookie("AURLANG", "", time() - (60*60*24*30), "/");
diff --git a/web/html/pkgedit.php b/web/html/pkgedit.php
index bb19144..36befbb 100644
--- a/web/html/pkgedit.php
+++ b/web/html/pkgedit.php
@@ -73,7 +73,7 @@ if ($_REQUEST["add_Comment"]) {
 		$q = "INSERT INTO PackageComments ";
 		$q.= "(PackageID, UsersID, Comments, CommentTS) VALUES (";
 		$q.= intval($_REQUEST["ID"]).", ".uid_from_sid($_COOKIE["AURSID"]) . ", ";
-		$q.= "'".mysql_escape_string($_REQUEST["comment"])."', ";
+		$q.= "'".mysql_real_escape_string($_REQUEST["comment"])."', ";
 		$q.= "UNIX_TIMESTAMP())";
 		db_query($q, $dbh);
 		print __("Comment has been added.")."<br />&nbsp;<br />\n";
diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php
index 9f55e54..59b4183 100644
--- a/web/html/pkgsubmit.php
+++ b/web/html/pkgsubmit.php
@@ -374,7 +374,7 @@ if ($_COOKIE["AURSID"]) {
 			# purged.
 			#
 			$q = "SELECT * FROM Packages ";
-			$q.= "WHERE Name = '".mysql_escape_string($new_pkgbuild['pkgname'])."'";
+			$q.= "WHERE Name = '".mysql_real_escape_string($new_pkgbuild['pkgname'])."'";
 			$result = db_query($q, $dbh);
 			$pdata = mysql_fetch_assoc($result);
 
@@ -402,13 +402,13 @@ if ($_COOKIE["AURSID"]) {
 				} else {
 					$q.="ModifiedTS = UNIX_TIMESTAMP(), ";
 				}
-				$q.="Name='".mysql_escape_string($new_pkgbuild['pkgname'])."', ";
-				$q.="Version='".mysql_escape_string($new_pkgbuild['pkgver'])."-".
-				  mysql_escape_string($new_pkgbuild['pkgrel'])."',";
-				$q.="CategoryID=".mysql_escape_string($_REQUEST['category']).", ";
-                $q.="License='".mysql_escape_string($new_pkgbuild['license'])."', ";
-                $q.="Description='".mysql_escape_string($new_pkgbuild['pkgdesc'])."', ";
-				$q.="URL='".mysql_escape_string($new_pkgbuild['url'])."', ";
+				$q.="Name='".mysql_real_escape_string($new_pkgbuild['pkgname'])."', ";
+				$q.="Version='".mysql_real_escape_string($new_pkgbuild['pkgver'])."-".
+				  mysql_real_escape_string($new_pkgbuild['pkgrel'])."',";
+				$q.="CategoryID=".mysql_real_escape_string($_REQUEST['category']).", ";
+                $q.="License='".mysql_real_escape_string($new_pkgbuild['license'])."', ";
+                $q.="Description='".mysql_real_escape_string($new_pkgbuild['pkgdesc'])."', ";
+				$q.="URL='".mysql_real_escape_string($new_pkgbuild['url'])."', ";
 				$q.="LocationID=2, ";
 				if (account_from_sid($_COOKIE["AURSID"]) == "Trusted User" || account_from_sid($_COOKIE["AURSID"]) == "Developer") {
 					$q.="Safe=1, VerifiedBy=".uid_from_sid($_COOKIE["AURSID"]).", ";
@@ -416,9 +416,9 @@ if ($_COOKIE["AURSID"]) {
 					$q.="Safe=0, ";
 				}
 				$fspath=$INCOMING_DIR.$pkg_name."/".$_FILES["pfile"]["name"];
-				$q.="FSPath='".mysql_escape_string($fspath)."', ";
+				$q.="FSPath='".mysql_real_escape_string($fspath)."', ";
 				$urlpath=$URL_DIR.$pkg_name."/".$_FILES["pfile"]["name"];
-				$q.="URLPath='".mysql_escape_string($urlpath)."' ";
+				$q.="URLPath='".mysql_real_escape_string($urlpath)."' ";
 				$q.="WHERE ID = " . $pdata["ID"];
 				$result = db_query($q, $dbh);
 
@@ -461,7 +461,7 @@ if ($_COOKIE["AURSID"]) {
 				$sources = explode(" ", $new_pkgbuild['source']);
 				while (list($k, $v) = each($sources)) {
 					$q = "INSERT INTO PackageSources (PackageID, Source) VALUES (";
-					$q .= $pdata["ID"].", '".mysql_escape_string($v)."')";
+					$q .= $pdata["ID"].", '".mysql_real_escape_string($v)."')";
 					db_query($q, $dbh);
 				}
 
@@ -470,7 +470,7 @@ if ($_COOKIE["AURSID"]) {
 				$q = "INSERT INTO PackageComments ";
 				$q.= "(PackageID, UsersID, Comments, CommentTS) VALUES (";
 				$q.= $pdata["ID"] . ", " . uid_from_sid($_COOKIE['AURSID']);
-				$q.= ", '" . mysql_escape_string($_REQUEST["comments"]);
+				$q.= ", '" . mysql_real_escape_string($_REQUEST["comments"]);
 				$q.= "', UNIX_TIMESTAMP())";
 				db_query($q);
 
@@ -484,13 +484,13 @@ if ($_COOKIE["AURSID"]) {
 				}
 				$q.= " SubmittedTS, SubmitterUID, MaintainerUID, FSPath, URLPath) ";
 				$q.= "VALUES ('";
-				$q.= mysql_escape_string($new_pkgbuild['pkgname'])."', '";
-                $q.= mysql_escape_string($new_pkgbuild['license'])."', '";
-				$q.= mysql_escape_string($new_pkgbuild['pkgver'])."-".
-				  mysql_escape_string($new_pkgbuild['pkgrel'])."', ";
-				$q.= mysql_escape_string($_REQUEST['category']).", '";
-				$q.= mysql_escape_string($new_pkgbuild['pkgdesc'])."', '";
-				$q.= mysql_escape_string($new_pkgbuild['url']);
+				$q.= mysql_real_escape_string($new_pkgbuild['pkgname'])."', '";
+                $q.= mysql_real_escape_string($new_pkgbuild['license'])."', '";
+				$q.= mysql_real_escape_string($new_pkgbuild['pkgver'])."-".
+				  mysql_real_escape_string($new_pkgbuild['pkgrel'])."', ";
+				$q.= mysql_real_escape_string($_REQUEST['category']).", '";
+				$q.= mysql_real_escape_string($new_pkgbuild['pkgdesc'])."', '";
+				$q.= mysql_real_escape_string($new_pkgbuild['url']);
 				$q.= "', 2, ";
 				if (account_from_sid($_COOKIE["AURSID"]) == "Trusted User" || account_from_sid($_COOKIE["AURSID"]) == "Developer") {
 					$q.= "1, ".uid_from_sid($_COOKIE["AURSID"]).", ";
@@ -499,9 +499,9 @@ if ($_COOKIE["AURSID"]) {
 				$q.= uid_from_sid($_COOKIE["AURSID"]).", ";
 				$q.= uid_from_sid($_COOKIE["AURSID"]).", '";
 				$fspath=$INCOMING_DIR.$pkg_name."/".$_FILES["pfile"]["name"];
-				$q.= mysql_escape_string($fspath)."', '";
+				$q.= mysql_real_escape_string($fspath)."', '";
 				$urlpath=$URL_DIR.$pkg_name."/".$_FILES["pfile"]["name"];
-				$q.= mysql_escape_string($urlpath)."')";
+				$q.= mysql_real_escape_string($urlpath)."')";
 				$result = db_query($q, $dbh);
 #				print $result . "<br>";
 
@@ -539,7 +539,7 @@ if ($_COOKIE["AURSID"]) {
 				$sources = explode(" ", $new_pkgbuild['source']);
 				while (list($k, $v) = each($sources)) {
 					$q = "INSERT INTO PackageSources (PackageID, Source) VALUES (";
-					$q .= $packageID.", '".mysql_escape_string($v)."')";
+					$q .= $packageID.", '".mysql_real_escape_string($v)."')";
 					db_query($q, $dbh);
 				}
 
@@ -548,7 +548,7 @@ if ($_COOKIE["AURSID"]) {
 				$q = "INSERT INTO PackageComments ";
 				$q.= "(PackageID, UsersID, Comments, CommentTS) VALUES (";
 				$q.= $packageID . ", " . uid_from_sid($_COOKIE["AURSID"]) . ", '";
-				$q.= mysql_escape_string($_REQUEST["comments"]);
+				$q.= mysql_real_escape_string($_REQUEST["comments"]);
 				$q.= "', UNIX_TIMESTAMP())";
 				db_query($q, $dbh);
 			}
diff --git a/web/lib/acctfuncs.inc b/web/lib/acctfuncs.inc
index fe8aefb..fa6df45 100644
--- a/web/lib/acctfuncs.inc
+++ b/web/lib/acctfuncs.inc
@@ -206,7 +206,7 @@ function process_account_form($UTYPE,$TYPE,$A,$U="",$T="",$S="",$E="",
 		# NOTE: a race condition exists here if we care...
 		#
 		$q = "SELECT COUNT(*) AS CNT FROM Users ";
-		$q.= "WHERE Username = '".mysql_escape_string($U)."'";
+		$q.= "WHERE Username = '".mysql_real_escape_string($U)."'";
 		if ($TYPE == "edit") {
 			$q.= " AND ID != ".intval($UID);
 		}
@@ -224,7 +224,7 @@ function process_account_form($UTYPE,$TYPE,$A,$U="",$T="",$S="",$E="",
 		# NOTE: a race condition exists here if we care...
 		#
 		$q = "SELECT COUNT(*) AS CNT FROM Users ";
-		$q.= "WHERE Email = '".mysql_escape_string($E)."'";
+		$q.= "WHERE Email = '".mysql_real_escape_string($E)."'";
 		if ($TYPE == "edit") {
 			$q.= " AND ID != ".intval($UID);
 		}
@@ -250,12 +250,12 @@ function process_account_form($UTYPE,$TYPE,$A,$U="",$T="",$S="",$E="",
 			$P = md5($P);
 			$q = "INSERT INTO Users (AccountTypeID, Suspended, Username, Email, ";
 			$q.= "Passwd, RealName, LangPreference, IRCNick, NewPkgNotify) ";
-			$q.= "VALUES (1, 0, '".mysql_escape_string($U)."'";
-			$q.= ", '".mysql_escape_string($E)."'";
-			$q.= ", '".mysql_escape_string($P)."'";
-			$q.= ", '".mysql_escape_string($R)."'";
-			$q.= ", '".mysql_escape_string($L)."'";
-			$q.= ", '".mysql_escape_string($I)."'";
+			$q.= "VALUES (1, 0, '".mysql_real_escape_string($U)."'";
+			$q.= ", '".mysql_real_escape_string($E)."'";
+			$q.= ", '".mysql_real_escape_string($P)."'";
+			$q.= ", '".mysql_real_escape_string($R)."'";
+			$q.= ", '".mysql_real_escape_string($L)."'";
+			$q.= ", '".mysql_real_escape_string($I)."'";
 			if ($N) {
 				$q.= ", 1)";
 			} else {
@@ -281,7 +281,7 @@ function process_account_form($UTYPE,$TYPE,$A,$U="",$T="",$S="",$E="",
 
 			#md5 hash the password
 			$q = "UPDATE Users SET ";
-			$q.= "Username = '".mysql_escape_string($U)."'";
+			$q.= "Username = '".mysql_real_escape_string($U)."'";
 			if ($T) {
 				$q.= ", AccountTypeID = ".intval($T);
 			}
@@ -290,13 +290,13 @@ function process_account_form($UTYPE,$TYPE,$A,$U="",$T="",$S="",$E="",
 			} else {
 				$q.= ", Suspended = 0";
 			}
-			$q.= ", Email = '".mysql_escape_string($E)."'";
+			$q.= ", Email = '".mysql_real_escape_string($E)."'";
 			if ($P) {
-				$q.= ", Passwd = '".mysql_escape_string(md5($P))."'";
+				$q.= ", Passwd = '".mysql_real_escape_string(md5($P))."'";
 			}
-			$q.= ", RealName = '".mysql_escape_string($R)."'";
-			$q.= ", LangPreference = '".mysql_escape_string($L)."'";
-			$q.= ", IRCNick = '".mysql_escape_string($I)."'";
+			$q.= ", RealName = '".mysql_real_escape_string($R)."'";
+			$q.= ", LangPreference = '".mysql_real_escape_string($L)."'";
+			$q.= ", IRCNick = '".mysql_real_escape_string($I)."'";
 			$q.= ", NewPkgNotify = ";
 			if ($N) {
 				$q.= "1 ";
@@ -435,19 +435,19 @@ function search_results_page($UTYPE,$O=0,$SB="",$U="",$T="",
 		$search_vars[] = "S";
 	}
 	if ($U) {
-		$q.= "AND Username LIKE '%".mysql_escape_string($U)."%' ";
+		$q.= "AND Username LIKE '%".mysql_real_escape_string($U)."%' ";
 		$search_vars[] = "U";
 	}
 	if ($E) {
-		$q.= "AND Email LIKE '%".mysql_escape_string($E)."%' ";
+		$q.= "AND Email LIKE '%".mysql_real_escape_string($E)."%' ";
 		$search_vars[] = "E";
 	}
 	if ($R) {
-		$q.= "AND RealName LIKE '%".mysql_escape_string($R)."%' ";
+		$q.= "AND RealName LIKE '%".mysql_real_escape_string($R)."%' ";
 		$search_vars[] = "R";
 	}
 	if ($I) {
-		$q.= "AND IRCNick LIKE '%".mysql_escape_string($I)."%' ";
+		$q.= "AND IRCNick LIKE '%".mysql_real_escape_string($I)."%' ";
 		$search_vars[] = "I";
 	}
 	switch ($SB) {
diff --git a/web/lib/aur.inc b/web/lib/aur.inc
index 4614631..063f903 100644
--- a/web/lib/aur.inc
+++ b/web/lib/aur.inc
@@ -93,7 +93,7 @@ function check_sid() {
 		#
 		$dbh = db_connect();
 		$q = "SELECT LastUpdateTS, UNIX_TIMESTAMP() FROM Sessions ";
-		$q.= "WHERE SessionID = '" . mysql_escape_string($_COOKIE["AURSID"]) . "'";
+		$q.= "WHERE SessionID = '" . mysql_real_escape_string($_COOKIE["AURSID"]) . "'";
 		$result = db_query($q, $dbh);
 		if (!$result) {
 			# Invalid SessionID - hacker alert!
@@ -118,7 +118,7 @@ function check_sid() {
 			# the main page where they can log in again.
 			#
 			$q = "DELETE FROM Sessions WHERE SessionID = '";
-			$q.= mysql_escape_string($_COOKIE["AURSID"]) . "'";
+			$q.= mysql_real_escape_string($_COOKIE["AURSID"]) . "'";
 			db_query($q, $dbh);
 
 			setcookie("AURSID", "", time() - (60*60*24*30), "/");
@@ -129,7 +129,7 @@ function check_sid() {
 			# and update the idle timestamp
 			#
 			$q = "UPDATE Sessions SET LastUpdateTS = UNIX_TIMESTAMP() ";
-			$q.= "WHERE SessionID = '".mysql_escape_string($_COOKIE["AURSID"])."'";
+			$q.= "WHERE SessionID = '".mysql_real_escape_string($_COOKIE["AURSID"])."'";
 			db_query($q, $dbh);
 		}
 	}
@@ -172,7 +172,7 @@ function username_from_id($id="") {
 		return "";
 	}
 	$dbh = db_connect();
-	$q = "SELECT Username FROM Users WHERE ID = " . mysql_escape_string($id);
+	$q = "SELECT Username FROM Users WHERE ID = " . mysql_real_escape_string($id);
 	$result = db_query($q, $dbh);
 	if (!$result) {
 		return "None";
@@ -193,7 +193,7 @@ function username_from_sid($sid="") {
 	$q = "SELECT Username ";
 	$q.= "FROM Users, Sessions ";
 	$q.= "WHERE Users.ID = Sessions.UsersID ";
-	$q.= "AND Sessions.SessionID = '" . mysql_escape_string($sid) . "'";
+	$q.= "AND Sessions.SessionID = '" . mysql_real_escape_string($sid) . "'";
 	$result = db_query($q, $dbh);
 	if (!$result) {
 		return "";
@@ -213,7 +213,7 @@ function email_from_sid($sid="") {
 	$q = "SELECT Email ";
 	$q.= "FROM Users, Sessions ";
 	$q.= "WHERE Users.ID = Sessions.UsersID ";
-	$q.= "AND Sessions.SessionID = '" . mysql_escape_string($sid) . "'";
+	$q.= "AND Sessions.SessionID = '" . mysql_real_escape_string($sid) . "'";
 	$result = db_query($q, $dbh);
 	if (!$result) {
 		return "";
@@ -235,7 +235,7 @@ function account_from_sid($sid="") {
 	$q.= "FROM Users, AccountTypes, Sessions ";
 	$q.= "WHERE Users.ID = Sessions.UsersID ";
 	$q.= "AND AccountTypes.ID = Users.AccountTypeID ";
-	$q.= "AND Sessions.SessionID = '" . mysql_escape_string($sid) . "'";
+	$q.= "AND Sessions.SessionID = '" . mysql_real_escape_string($sid) . "'";
 	$result = db_query($q, $dbh);
 	if (!$result) {
 		return "";
@@ -255,7 +255,7 @@ function uid_from_sid($sid="") {
 	$q = "SELECT Users.ID ";
 	$q.= "FROM Users, Sessions ";
 	$q.= "WHERE Users.ID = Sessions.UsersID ";
-	$q.= "AND Sessions.SessionID = '" . mysql_escape_string($sid) . "'";
+	$q.= "AND Sessions.SessionID = '" . mysql_real_escape_string($sid) . "'";
 	$result = db_query($q, $dbh);
 	if (!$result) {
 		return 0;
@@ -329,7 +329,7 @@ function set_lang() {
 		$q = "SELECT LangPreference FROM Users, Sessions ";
 		$q.= "WHERE Users.ID = Sessions.UsersID ";
 		$q.= "AND Sessions.SessionID = '";
-		$q.= mysql_escape_string($_COOKIE["AURSID"])."'";
+		$q.= mysql_real_escape_string($_COOKIE["AURSID"])."'";
 		$result = db_query($q, $dbh);
 		if (!$result) {
 			$LANG = "en";
@@ -491,7 +491,7 @@ function can_overwrite_pkg($name="", $sid="") {
 	if (!$name || !$sid) {return 0;}
 	$dbh = db_connect();
 	$q = "SELECT SubmitterUID, MaintainerUID, AURMaintainerUID ";
-	$q.= "FROM Packages WHERE Name = '".mysql_escape_string($name)."'";
+	$q.= "FROM Packages WHERE Name = '".mysql_real_escape_string($name)."'";
 	$result = db_query($q, $dbh);
 	if (!$result) {return 0;}
 	$row = mysql_fetch_row($result);
@@ -561,7 +561,7 @@ function uid_from_username($username="")
 		return "";
 	}
 	$dbh = db_connect();
-	$q = "SELECT ID FROM Users WHERE Username = '".mysql_escape_string($username)
+	$q = "SELECT ID FROM Users WHERE Username = '".mysql_real_escape_string($username)
 				."'";
 	$result = db_query($q, $dbh);
 	if (!$result) {
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index de2f16c..d1da9bc 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -125,7 +125,7 @@ function package_exists($name="") {
 	if (!$name) {return NULL;}
 	$dbh = db_connect();
 	$q = "SELECT ID FROM Packages ";
-	$q.= "WHERE Name = '".mysql_escape_string($name)."' ";
+	$q.= "WHERE Name = '".mysql_real_escape_string($name)."' ";
 	$q.= "AND DummyPkg = 0";
 	$result = db_query($q, $dbh);
 	if (!$result) {return NULL;}
@@ -141,7 +141,7 @@ function package_dependencies($pkgid=0) {
 		$dbh = db_connect();
 		$q = "SELECT DepPkgID, Name, DummyPkg, DepCondition FROM PackageDepends, Packages ";
 		$q.= "WHERE PackageDepends.DepPkgID = Packages.ID ";
-		$q.= "AND PackageDepends.PackageID = ".mysql_escape_string($pkgid);
+		$q.= "AND PackageDepends.PackageID = ".mysql_real_escape_string($pkgid);
 		$q.= " ORDER BY Name";
 		$result = db_query($q, $dbh);
 		if (!$result) {return array();}
@@ -161,14 +161,14 @@ function create_dummy($pname="", $sid="") {
 		if (!$uid) {return NULL;}
 		$dbh = db_connect();
 		$q = "SELECT ID FROM Packages WHERE Name = '";
-		$q.= mysql_escape_string($pname)."'";
+		$q.= mysql_real_escape_string($pname)."'";
 		$result = db_query($q, $dbh);
 		if (!mysql_num_rows($result)) {
 			# Insert the dummy
 			#
 			$q = "INSERT INTO Packages (Name, Description, URL, SubmittedTS, ";
 			$q.= "SubmitterUID, DummyPkg) VALUES ('";
-			$q.= mysql_escape_string($pname)."', 'A dummy package', '/#', ";
+			$q.= mysql_real_escape_string($pname)."', 'A dummy package', '/#', ";
 			$q.= "UNIX_TIMESTAMP(), ".$uid.", 1)";
 			$result = db_query($q, $dbh);
 			if (!$result) {
@@ -193,7 +193,7 @@ function package_comments($pkgid=0) {
 		$q = "SELECT PackageComments.ID, UserName, UsersID, Comments, CommentTS ";
 		$q.= "FROM PackageComments, Users ";
 		$q.= "WHERE PackageComments.UsersID = Users.ID";
-		$q.= " AND PackageID = ".mysql_escape_string($pkgid);
+		$q.= " AND PackageID = ".mysql_real_escape_string($pkgid);
 		$q.= " AND DelUsersID = 0"; # only display non-deleted comments
 		$q.= " ORDER BY CommentTS DESC";
 		$result = db_query($q, $dbh);
@@ -212,7 +212,7 @@ function package_sources($pkgid=0) {
 	if ($pkgid) {
 		$dbh = db_connect();
 		$q = "SELECT Source FROM PackageSources ";
-		$q.= "WHERE PackageID = ".mysql_escape_string($pkgid);
+		$q.= "WHERE PackageID = ".mysql_real_escape_string($pkgid);
 		$q.= " ORDER BY Source";
 		$result = db_query($q, $dbh);
 		if (!$result) {return array();}
@@ -234,7 +234,7 @@ function pkgvotes_from_sid($sid="") {
 	$q.= "FROM PackageVotes, Users, Sessions ";
 	$q.= "WHERE Users.ID = Sessions.UsersID ";
 	$q.= "AND Users.ID = PackageVotes.UsersID ";
-	$q.= "AND Sessions.SessionID = '".mysql_escape_string($sid)."'";
+	$q.= "AND Sessions.SessionID = '".mysql_real_escape_string($sid)."'";
 	$result = db_query($q, $dbh);
 	if ($result) {
 		while ($row = mysql_fetch_row($result)) {
@@ -901,10 +901,10 @@ function pkg_search_page($SID="") {
 		#search by maintainer
 		if ($_REQUEST["SeB"] == "m"){
 			if (!$has_where) {
-				$q.= "WHERE Username = '".mysql_escape_string($K)."' ";
+				$q.= "WHERE Username = '".mysql_real_escape_string($K)."' ";
 				$has_where = 1;
 			} else {
-				$q.= "AND Username = '".mysql_escape_string($K)."' ";
+				$q.= "AND Username = '".mysql_real_escape_string($K)."' ";
 			}
         } elseif ($_REQUEST["SeB"] == "s") {
 			if (!$has_where) {
@@ -916,12 +916,12 @@ function pkg_search_page($SID="") {
 		# the default behaivior, query the name/description
 		} else {
 			if (!$has_where) {
-				$q.= "WHERE (Name LIKE '%".mysql_escape_string($K)."%' OR ";
-				$q.= "Description LIKE '%".mysql_escape_string($K)."%') ";
+				$q.= "WHERE (Name LIKE '%".mysql_real_escape_string($K)."%' OR ";
+				$q.= "Description LIKE '%".mysql_real_escape_string($K)."%') ";
 				$has_where = 1;
 			} else {
-				$q.= "AND (Name LIKE '%".mysql_escape_string($K)."%' OR ";
-				$q.= "Description LIKE '%".mysql_escape_string($K)."%') ";
+				$q.= "AND (Name LIKE '%".mysql_real_escape_string($K)."%' OR ";
+				$q.= "Description LIKE '%".mysql_real_escape_string($K)."%') ";
 			}
 		}
 	}
-- 
cgit v1.2.3-70-g09d2


From 10f3445394f3994673b296a0e68a1caefade35e6 Mon Sep 17 00:00:00 2001
From: eliott <eliott@cactuswax.net>
Date: Wed, 15 Aug 2007 21:01:54 -0700
Subject: Convert <? to <?php

---
 web/html/account.php         | 2 +-
 web/html/hacker.php          | 2 +-
 web/html/index.php           | 2 +-
 web/html/logout.php          | 2 +-
 web/html/packages.php        | 2 +-
 web/html/pkgedit.php         | 2 +-
 web/html/pkgsubmit.php       | 2 +-
 web/html/rss2.php            | 2 +-
 web/html/template.php        | 2 +-
 web/html/testpo.php          | 2 +-
 web/html/timeout.php         | 2 +-
 web/lang/account_po.inc      | 2 +-
 web/lang/acctfuncs_po.inc    | 2 +-
 web/lang/aur_po.inc          | 2 +-
 web/lang/ca/account_po.inc   | 2 +-
 web/lang/ca/acctfuncs_po.inc | 2 +-
 web/lang/ca/aur_po.inc       | 2 +-
 web/lang/ca/common_po.inc    | 2 +-
 web/lang/ca/hacker_po.inc    | 2 +-
 web/lang/ca/index_po.inc     | 2 +-
 web/lang/ca/logout_po.inc    | 2 +-
 web/lang/ca/pkgedit_po.inc   | 2 +-
 web/lang/ca/pkgfuncs_po.inc  | 2 +-
 web/lang/ca/search_po.inc    | 2 +-
 web/lang/ca/submit_po.inc    | 2 +-
 web/lang/ca/template_po.inc  | 2 +-
 web/lang/ca/test_po.inc      | 2 +-
 web/lang/ca/timeout_po.inc   | 2 +-
 web/lang/common_po.inc       | 2 +-
 web/lang/de/account_po.inc   | 2 +-
 web/lang/de/acctfuncs_po.inc | 2 +-
 web/lang/de/aur_po.inc       | 2 +-
 web/lang/de/common_po.inc    | 2 +-
 web/lang/de/hacker_po.inc    | 2 +-
 web/lang/de/index_po.inc     | 2 +-
 web/lang/de/logout_po.inc    | 2 +-
 web/lang/de/pkgedit_po.inc   | 2 +-
 web/lang/de/pkgfuncs_po.inc  | 2 +-
 web/lang/de/search_po.inc    | 2 +-
 web/lang/de/submit_po.inc    | 2 +-
 web/lang/de/template_po.inc  | 2 +-
 web/lang/de/test_po.inc      | 2 +-
 web/lang/de/timeout_po.inc   | 2 +-
 web/lang/en/account_po.inc   | 2 +-
 web/lang/en/acctfuncs_po.inc | 2 +-
 web/lang/en/aur_po.inc       | 2 +-
 web/lang/en/common_po.inc    | 2 +-
 web/lang/en/hacker_po.inc    | 2 +-
 web/lang/en/index_po.inc     | 4 ++--
 web/lang/en/logout_po.inc    | 2 +-
 web/lang/en/pkgedit_po.inc   | 4 ++--
 web/lang/en/pkgfuncs_po.inc  | 2 +-
 web/lang/en/search_po.inc    | 2 +-
 web/lang/en/submit_po.inc    | 2 +-
 web/lang/en/template_po.inc  | 2 +-
 web/lang/en/test_po.inc      | 2 +-
 web/lang/en/timeout_po.inc   | 4 ++--
 web/lang/es/account_po.inc   | 2 +-
 web/lang/es/acctfuncs_po.inc | 2 +-
 web/lang/es/aur_po.inc       | 2 +-
 web/lang/es/common_po.inc    | 2 +-
 web/lang/es/hacker_po.inc    | 2 +-
 web/lang/es/index_po.inc     | 2 +-
 web/lang/es/logout_po.inc    | 2 +-
 web/lang/es/pkgedit_po.inc   | 2 +-
 web/lang/es/pkgfuncs_po.inc  | 2 +-
 web/lang/es/search_po.inc    | 2 +-
 web/lang/es/submit_po.inc    | 2 +-
 web/lang/es/template_po.inc  | 2 +-
 web/lang/es/test_po.inc      | 2 +-
 web/lang/es/timeout_po.inc   | 2 +-
 web/lang/fr/account_po.inc   | 2 +-
 web/lang/fr/acctfuncs_po.inc | 2 +-
 web/lang/fr/aur_po.inc       | 4 ++--
 web/lang/fr/common_po.inc    | 2 +-
 web/lang/fr/hacker_po.inc    | 4 ++--
 web/lang/fr/index_po.inc     | 2 +-
 web/lang/fr/pkgedit_po.inc   | 4 ++--
 web/lang/fr/pkgfuncs_po.inc  | 4 ++--
 web/lang/fr/search_po.inc    | 2 +-
 web/lang/fr/submit_po.inc    | 2 +-
 web/lang/fr/template_po.inc  | 4 ++--
 web/lang/fr/test_po.inc      | 4 ++--
 web/lang/fr/timeout_po.inc   | 2 +-
 web/lang/hacker_po.inc       | 2 +-
 web/lang/index_po.inc        | 2 +-
 web/lang/it/account_po.inc   | 2 +-
 web/lang/it/acctfuncs_po.inc | 2 +-
 web/lang/it/aur_po.inc       | 2 +-
 web/lang/it/common_po.inc    | 2 +-
 web/lang/it/hacker_po.inc    | 2 +-
 web/lang/it/index_po.inc     | 2 +-
 web/lang/it/logout_po.inc    | 2 +-
 web/lang/it/pkgedit_po.inc   | 2 +-
 web/lang/it/pkgfuncs_po.inc  | 2 +-
 web/lang/it/search_po.inc    | 2 +-
 web/lang/it/submit_po.inc    | 2 +-
 web/lang/it/template_po.inc  | 2 +-
 web/lang/it/test_po.inc      | 2 +-
 web/lang/it/timeout_po.inc   | 2 +-
 web/lang/logout_po.inc       | 2 +-
 web/lang/pkgedit_po.inc      | 2 +-
 web/lang/pkgfuncs_po.inc     | 2 +-
 web/lang/pl/account_po.inc   | 2 +-
 web/lang/pl/acctfuncs_po.inc | 2 +-
 web/lang/pl/aur_po.inc       | 4 ++--
 web/lang/pl/common_po.inc    | 4 ++--
 web/lang/pl/hacker_po.inc    | 4 ++--
 web/lang/pl/index_po.inc     | 4 ++--
 web/lang/pl/logout_po.inc    | 2 +-
 web/lang/pl/pkgedit_po.inc   | 4 ++--
 web/lang/pl/pkgfuncs_po.inc  | 2 +-
 web/lang/pl/search_po.inc    | 2 +-
 web/lang/pl/submit_po.inc    | 4 ++--
 web/lang/pl/template_po.inc  | 4 ++--
 web/lang/pl/test_po.inc      | 2 +-
 web/lang/pl/timeout_po.inc   | 4 ++--
 web/lang/pt/account_po.inc   | 2 +-
 web/lang/pt/acctfuncs_po.inc | 2 +-
 web/lang/pt/aur_po.inc       | 2 +-
 web/lang/pt/common_po.inc    | 2 +-
 web/lang/pt/hacker_po.inc    | 2 +-
 web/lang/pt/index_po.inc     | 2 +-
 web/lang/pt/logout_po.inc    | 2 +-
 web/lang/pt/pkgedit_po.inc   | 2 +-
 web/lang/pt/pkgfuncs_po.inc  | 2 +-
 web/lang/pt/search_po.inc    | 2 +-
 web/lang/pt/submit_po.inc    | 2 +-
 web/lang/pt/template_po.inc  | 2 +-
 web/lang/pt/test_po.inc      | 2 +-
 web/lang/pt/timeout_po.inc   | 2 +-
 web/lang/ru/account_po.inc   | 2 +-
 web/lang/ru/acctfuncs_po.inc | 2 +-
 web/lang/ru/aur_po.inc       | 2 +-
 web/lang/ru/common_po.inc    | 2 +-
 web/lang/ru/hacker_po.inc    | 2 +-
 web/lang/ru/index_po.inc     | 2 +-
 web/lang/ru/logout_po.inc    | 2 +-
 web/lang/ru/pkgedit_po.inc   | 2 +-
 web/lang/ru/pkgfuncs_po.inc  | 2 +-
 web/lang/ru/search_po.inc    | 2 +-
 web/lang/ru/submit_po.inc    | 2 +-
 web/lang/ru/template_po.inc  | 2 +-
 web/lang/ru/test_po.inc      | 2 +-
 web/lang/ru/timeout_po.inc   | 2 +-
 web/lang/search_po.inc       | 2 +-
 web/lang/submit_po.inc       | 2 +-
 web/lang/template_po.inc     | 2 +-
 web/lang/test_po.inc         | 2 +-
 web/lang/timeout_po.inc      | 2 +-
 web/lib/acctfuncs.inc        | 2 +-
 web/lib/aur.inc              | 2 +-
 web/lib/pkgfuncs.inc         | 2 +-
 web/lib/translator.inc       | 2 +-
 web/utils/genpopo            | 2 +-
 web/utils/translation_tool   | 2 +-
 156 files changed, 173 insertions(+), 173 deletions(-)

diff --git a/web/html/account.php b/web/html/account.php
index fba90dd..fd9cc61 100644
--- a/web/html/account.php
+++ b/web/html/account.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/hacker.php b/web/html/hacker.php
index 9006413..ef54bb6 100644
--- a/web/html/hacker.php
+++ b/web/html/hacker.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/index.php b/web/html/index.php
index 3915483..7d28d75 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/logout.php b/web/html/logout.php
index be4027f..76736b7 100644
--- a/web/html/logout.php
+++ b/web/html/logout.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/packages.php b/web/html/packages.php
index 683d23e..4cb8c47 100644
--- a/web/html/packages.php
+++ b/web/html/packages.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/pkgedit.php b/web/html/pkgedit.php
index 36befbb..e617b75 100644
--- a/web/html/pkgedit.php
+++ b/web/html/pkgedit.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php
index 59b4183..89ecfa4 100644
--- a/web/html/pkgsubmit.php
+++ b/web/html/pkgsubmit.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/rss2.php b/web/html/rss2.php
index bba030a..cb09423 100644
--- a/web/html/rss2.php
+++ b/web/html/rss2.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/template.php b/web/html/template.php
index 1f81681..175ba0b 100644
--- a/web/html/template.php
+++ b/web/html/template.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/testpo.php b/web/html/testpo.php
index b440d15..75da92a 100644
--- a/web/html/testpo.php
+++ b/web/html/testpo.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/html/timeout.php b/web/html/timeout.php
index 1c14e65..94a8637 100644
--- a/web/html/timeout.php
+++ b/web/html/timeout.php
@@ -1,4 +1,4 @@
-<?
+<?php
 
 set_include_path(get_include_path() . PATH_SEPARATOR . '../lib' . PATH_SEPARATOR . '../lang');
 
diff --git a/web/lang/account_po.inc b/web/lang/account_po.inc
index 8559954..86c015b 100644
--- a/web/lang/account_po.inc
+++ b/web/lang/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/acctfuncs_po.inc b/web/lang/acctfuncs_po.inc
index b71800d..3e0471c 100644
--- a/web/lang/acctfuncs_po.inc
+++ b/web/lang/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/aur_po.inc b/web/lang/aur_po.inc
index 9fca5ac..631f4cf 100644
--- a/web/lang/aur_po.inc
+++ b/web/lang/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/ca/account_po.inc b/web/lang/ca/account_po.inc
index e0c9654..a29c5ae 100644
--- a/web/lang/ca/account_po.inc
+++ b/web/lang/ca/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/acctfuncs_po.inc b/web/lang/ca/acctfuncs_po.inc
index 81c2ee2..6770506 100644
--- a/web/lang/ca/acctfuncs_po.inc
+++ b/web/lang/ca/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/aur_po.inc b/web/lang/ca/aur_po.inc
index 2b86971..2396b8b 100644
--- a/web/lang/ca/aur_po.inc
+++ b/web/lang/ca/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/common_po.inc b/web/lang/ca/common_po.inc
index 81a7b58..150a61f 100644
--- a/web/lang/ca/common_po.inc
+++ b/web/lang/ca/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/hacker_po.inc b/web/lang/ca/hacker_po.inc
index 42bccb2..9be6019 100644
--- a/web/lang/ca/hacker_po.inc
+++ b/web/lang/ca/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/index_po.inc b/web/lang/ca/index_po.inc
index 60d976e..cd930a2 100644
--- a/web/lang/ca/index_po.inc
+++ b/web/lang/ca/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/logout_po.inc b/web/lang/ca/logout_po.inc
index b3901d3..b542de8 100644
--- a/web/lang/ca/logout_po.inc
+++ b/web/lang/ca/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/pkgedit_po.inc b/web/lang/ca/pkgedit_po.inc
index fee271a..9de39a5 100644
--- a/web/lang/ca/pkgedit_po.inc
+++ b/web/lang/ca/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/pkgfuncs_po.inc b/web/lang/ca/pkgfuncs_po.inc
index a4fbdc3..c005ba6 100644
--- a/web/lang/ca/pkgfuncs_po.inc
+++ b/web/lang/ca/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/search_po.inc b/web/lang/ca/search_po.inc
index 9b58f9a..83641cc 100644
--- a/web/lang/ca/search_po.inc
+++ b/web/lang/ca/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/submit_po.inc b/web/lang/ca/submit_po.inc
index 5605a03..664b3e7 100644
--- a/web/lang/ca/submit_po.inc
+++ b/web/lang/ca/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/template_po.inc b/web/lang/ca/template_po.inc
index 3bf261e..5ea5ee6 100644
--- a/web/lang/ca/template_po.inc
+++ b/web/lang/ca/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/test_po.inc b/web/lang/ca/test_po.inc
index 9d1105d..3f5ddad 100644
--- a/web/lang/ca/test_po.inc
+++ b/web/lang/ca/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/ca/timeout_po.inc b/web/lang/ca/timeout_po.inc
index e815b2f..b5ea0b9 100644
--- a/web/lang/ca/timeout_po.inc
+++ b/web/lang/ca/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Catalan (Català) translation
 # Translator: Sergio Jovani Guzman <moret.sjg@gmail.com>
 
diff --git a/web/lang/common_po.inc b/web/lang/common_po.inc
index c9c371c..f4752ca 100644
--- a/web/lang/common_po.inc
+++ b/web/lang/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/de/account_po.inc b/web/lang/de/account_po.inc
index 1fd4603..9325fe9 100644
--- a/web/lang/de/account_po.inc
+++ b/web/lang/de/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/acctfuncs_po.inc b/web/lang/de/acctfuncs_po.inc
index 763458c..e73fb74 100644
--- a/web/lang/de/acctfuncs_po.inc
+++ b/web/lang/de/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/aur_po.inc b/web/lang/de/aur_po.inc
index df01f0a..32e6b95 100644
--- a/web/lang/de/aur_po.inc
+++ b/web/lang/de/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/common_po.inc b/web/lang/de/common_po.inc
index fee9fc5..91faa2e 100644
--- a/web/lang/de/common_po.inc
+++ b/web/lang/de/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/hacker_po.inc b/web/lang/de/hacker_po.inc
index e16e311..e8298fa 100644
--- a/web/lang/de/hacker_po.inc
+++ b/web/lang/de/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/index_po.inc b/web/lang/de/index_po.inc
index 5075604..bbc4159 100644
--- a/web/lang/de/index_po.inc
+++ b/web/lang/de/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/logout_po.inc b/web/lang/de/logout_po.inc
index 12bb803..8a0ed37 100644
--- a/web/lang/de/logout_po.inc
+++ b/web/lang/de/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/pkgedit_po.inc b/web/lang/de/pkgedit_po.inc
index 7efaf20..3d775c4 100644
--- a/web/lang/de/pkgedit_po.inc
+++ b/web/lang/de/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/pkgfuncs_po.inc b/web/lang/de/pkgfuncs_po.inc
index 3b7106e..78b2c86 100644
--- a/web/lang/de/pkgfuncs_po.inc
+++ b/web/lang/de/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/search_po.inc b/web/lang/de/search_po.inc
index 53b5cc1..dce8c72 100644
--- a/web/lang/de/search_po.inc
+++ b/web/lang/de/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/submit_po.inc b/web/lang/de/submit_po.inc
index a265ad4..e8355a0 100644
--- a/web/lang/de/submit_po.inc
+++ b/web/lang/de/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/template_po.inc b/web/lang/de/template_po.inc
index 725d323..024d767 100644
--- a/web/lang/de/template_po.inc
+++ b/web/lang/de/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/test_po.inc b/web/lang/de/test_po.inc
index a9468c9..a957522 100644
--- a/web/lang/de/test_po.inc
+++ b/web/lang/de/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/de/timeout_po.inc b/web/lang/de/timeout_po.inc
index e7f51d6..49cb9bd 100644
--- a/web/lang/de/timeout_po.inc
+++ b/web/lang/de/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # German (Deutsch) translation
 # Translators: Pierre Schmitz <pierre@archlinux.de>, Matthias Gorissen <siquame@web.de>, Lukas Kropatschek, Niclas Pfeifer
 
diff --git a/web/lang/en/account_po.inc b/web/lang/en/account_po.inc
index 3fec4eb..bb0af6d 100644
--- a/web/lang/en/account_po.inc
+++ b/web/lang/en/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/acctfuncs_po.inc b/web/lang/en/acctfuncs_po.inc
index 3a65b89..4af9cea 100644
--- a/web/lang/en/acctfuncs_po.inc
+++ b/web/lang/en/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/aur_po.inc b/web/lang/en/aur_po.inc
index 00b1bb0..1542817 100644
--- a/web/lang/en/aur_po.inc
+++ b/web/lang/en/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/common_po.inc b/web/lang/en/common_po.inc
index a59201b..0d04caa 100644
--- a/web/lang/en/common_po.inc
+++ b/web/lang/en/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/hacker_po.inc b/web/lang/en/hacker_po.inc
index 64f233f..a400a28 100644
--- a/web/lang/en/hacker_po.inc
+++ b/web/lang/en/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/index_po.inc b/web/lang/en/index_po.inc
index 09e3636..abd93fe 100644
--- a/web/lang/en/index_po.inc
+++ b/web/lang/en/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
@@ -93,4 +93,4 @@ $_t["en"]["Packages added or updated in the past 7 days"] = "Packages added or u
 
 $_t["en"]["Out-of-date"] = "Out-of-date";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/en/logout_po.inc b/web/lang/en/logout_po.inc
index 6ebdac5..cf91aa2 100644
--- a/web/lang/en/logout_po.inc
+++ b/web/lang/en/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/pkgedit_po.inc b/web/lang/en/pkgedit_po.inc
index ce6a08d..a5967d3 100644
--- a/web/lang/en/pkgedit_po.inc
+++ b/web/lang/en/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
@@ -33,4 +33,4 @@ $_t["en"]["Comment has been added."] = "Comment has been added.";
 
 $_t["en"]["Select new category"] = "Select new category";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/en/pkgfuncs_po.inc b/web/lang/en/pkgfuncs_po.inc
index 592b696..220cdb3 100644
--- a/web/lang/en/pkgfuncs_po.inc
+++ b/web/lang/en/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/search_po.inc b/web/lang/en/search_po.inc
index e4753aa..8feb57b 100644
--- a/web/lang/en/search_po.inc
+++ b/web/lang/en/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/submit_po.inc b/web/lang/en/submit_po.inc
index 4ac72e1..9f21b72 100644
--- a/web/lang/en/submit_po.inc
+++ b/web/lang/en/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/template_po.inc b/web/lang/en/template_po.inc
index 06f1fae..db437be 100644
--- a/web/lang/en/template_po.inc
+++ b/web/lang/en/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/test_po.inc b/web/lang/en/test_po.inc
index 2754ed4..28c0e10 100644
--- a/web/lang/en/test_po.inc
+++ b/web/lang/en/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/en/timeout_po.inc b/web/lang/en/timeout_po.inc
index 919de4d..b1cfb08 100644
--- a/web/lang/en/timeout_po.inc
+++ b/web/lang/en/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
@@ -15,4 +15,4 @@ $_t["en"]["Click on the Home link above to log in."] = "Click on the Home link a
 
 $_t["en"]["Your session has timed out.  You must log in again."] = "Your session has timed out.  You must log in again.";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/es/account_po.inc b/web/lang/es/account_po.inc
index e50b9d3..825274c 100644
--- a/web/lang/es/account_po.inc
+++ b/web/lang/es/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/acctfuncs_po.inc b/web/lang/es/acctfuncs_po.inc
index 4454a10..706740a 100644
--- a/web/lang/es/acctfuncs_po.inc
+++ b/web/lang/es/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/aur_po.inc b/web/lang/es/aur_po.inc
index cbc3784..4410b1e 100644
--- a/web/lang/es/aur_po.inc
+++ b/web/lang/es/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/common_po.inc b/web/lang/es/common_po.inc
index 8fb4540..68dad39 100644
--- a/web/lang/es/common_po.inc
+++ b/web/lang/es/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/hacker_po.inc b/web/lang/es/hacker_po.inc
index f75ca7b..046cbf5 100644
--- a/web/lang/es/hacker_po.inc
+++ b/web/lang/es/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/index_po.inc b/web/lang/es/index_po.inc
index a59744f..77e5ee9 100644
--- a/web/lang/es/index_po.inc
+++ b/web/lang/es/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/logout_po.inc b/web/lang/es/logout_po.inc
index c0f9b83..5bd5860 100644
--- a/web/lang/es/logout_po.inc
+++ b/web/lang/es/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/pkgedit_po.inc b/web/lang/es/pkgedit_po.inc
index e944bbf..9787d3a 100644
--- a/web/lang/es/pkgedit_po.inc
+++ b/web/lang/es/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/pkgfuncs_po.inc b/web/lang/es/pkgfuncs_po.inc
index e1ab015..22e24e0 100644
--- a/web/lang/es/pkgfuncs_po.inc
+++ b/web/lang/es/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/search_po.inc b/web/lang/es/search_po.inc
index e54768a..d8dd957 100644
--- a/web/lang/es/search_po.inc
+++ b/web/lang/es/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/submit_po.inc b/web/lang/es/submit_po.inc
index 10eaa0e..53d728b 100644
--- a/web/lang/es/submit_po.inc
+++ b/web/lang/es/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/template_po.inc b/web/lang/es/template_po.inc
index 6bd9b69..21e45fc 100644
--- a/web/lang/es/template_po.inc
+++ b/web/lang/es/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/test_po.inc b/web/lang/es/test_po.inc
index ba5b678..83bc7dc 100644
--- a/web/lang/es/test_po.inc
+++ b/web/lang/es/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/es/timeout_po.inc b/web/lang/es/timeout_po.inc
index 92b620e..3ed6d21 100644
--- a/web/lang/es/timeout_po.inc
+++ b/web/lang/es/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Spanish (Español) translation
 # Translator: Víctor Martínez Romanos <vmromanos@gmail.com>
 
diff --git a/web/lang/fr/account_po.inc b/web/lang/fr/account_po.inc
index 43803c1..dea18d1 100644
--- a/web/lang/fr/account_po.inc
+++ b/web/lang/fr/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/fr/acctfuncs_po.inc b/web/lang/fr/acctfuncs_po.inc
index de47a4a..0c10757 100644
--- a/web/lang/fr/acctfuncs_po.inc
+++ b/web/lang/fr/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/fr/aur_po.inc b/web/lang/fr/aur_po.inc
index f0f3d3c..491a1a6 100644
--- a/web/lang/fr/aur_po.inc
+++ b/web/lang/fr/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
@@ -21,4 +21,4 @@ $_t["fr"]["Home"] = "Accueil";
 
 $_t["fr"]["Packages"] = "Paquets";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/fr/common_po.inc b/web/lang/fr/common_po.inc
index bf40bc1..e3b54a8 100644
--- a/web/lang/fr/common_po.inc
+++ b/web/lang/fr/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/fr/hacker_po.inc b/web/lang/fr/hacker_po.inc
index 0af11c1..d348e6a 100644
--- a/web/lang/fr/hacker_po.inc
+++ b/web/lang/fr/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
@@ -9,4 +9,4 @@ $_t["fr"]["Your session id is invalid."] = "Votre identifiant de session n'est p
 
 $_t["fr"]["If this problem persists, please contact the site administrator."] = "Si ce problème persiste, contactez s'il vous plaît l'administrateur du site.";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/fr/index_po.inc b/web/lang/fr/index_po.inc
index 0a9dbf0..7604978 100644
--- a/web/lang/fr/index_po.inc
+++ b/web/lang/fr/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/fr/pkgedit_po.inc b/web/lang/fr/pkgedit_po.inc
index 2a5f245..d3c977c 100644
--- a/web/lang/fr/pkgedit_po.inc
+++ b/web/lang/fr/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
@@ -27,4 +27,4 @@ $_t["fr"]["Comment has been added."] = "Le commentaire a été ajouté.";
 
 $_t["fr"]["Select new category"] = "Sélectionnez une nouvelle catégorie";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/fr/pkgfuncs_po.inc b/web/lang/fr/pkgfuncs_po.inc
index 8fad7aa..03ee808 100644
--- a/web/lang/fr/pkgfuncs_po.inc
+++ b/web/lang/fr/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
@@ -159,4 +159,4 @@ $_t["fr"]["Unsafe"] = "Non sûr";
 
 $_t["fr"]["unknown"] = "inconnu";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/fr/search_po.inc b/web/lang/fr/search_po.inc
index ec7f3cd..d3a0e26 100644
--- a/web/lang/fr/search_po.inc
+++ b/web/lang/fr/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/fr/submit_po.inc b/web/lang/fr/submit_po.inc
index 99e41d8..f348bd2 100644
--- a/web/lang/fr/submit_po.inc
+++ b/web/lang/fr/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/fr/template_po.inc b/web/lang/fr/template_po.inc
index 93de467..c9a0466 100644
--- a/web/lang/fr/template_po.inc
+++ b/web/lang/fr/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
@@ -7,4 +7,4 @@ global $_t;
 
 $_t["fr"]["Hi, this is worth reading!"] = "Salut, ceci vaut la peine d'être lu!";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/fr/test_po.inc b/web/lang/fr/test_po.inc
index 8089b7c..3a32cb6 100644
--- a/web/lang/fr/test_po.inc
+++ b/web/lang/fr/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
@@ -13,4 +13,4 @@ $_t["fr"]["Hello, again!"] = "Salut encore!";
 
 $_t["fr"]["My current language tag is: '%s'."] = "Mon choix actuel de langue est: '%s'.";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/fr/timeout_po.inc b/web/lang/fr/timeout_po.inc
index 77c1c2e..ee18018 100644
--- a/web/lang/fr/timeout_po.inc
+++ b/web/lang/fr/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # French (Français) translation
 # Translator: Morgan LEFIEUX <comete@archlinuxfr.org>
 
diff --git a/web/lang/hacker_po.inc b/web/lang/hacker_po.inc
index 8e446a7..6788521 100644
--- a/web/lang/hacker_po.inc
+++ b/web/lang/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/index_po.inc b/web/lang/index_po.inc
index c5f9df3..ecf02b4 100644
--- a/web/lang/index_po.inc
+++ b/web/lang/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/it/account_po.inc b/web/lang/it/account_po.inc
index 0ebc858..8c65697 100644
--- a/web/lang/it/account_po.inc
+++ b/web/lang/it/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/acctfuncs_po.inc b/web/lang/it/acctfuncs_po.inc
index aaff645..26c4d4d 100644
--- a/web/lang/it/acctfuncs_po.inc
+++ b/web/lang/it/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/aur_po.inc b/web/lang/it/aur_po.inc
index 4117b4c..87d0ebf 100644
--- a/web/lang/it/aur_po.inc
+++ b/web/lang/it/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/common_po.inc b/web/lang/it/common_po.inc
index defdecf..861ae00 100644
--- a/web/lang/it/common_po.inc
+++ b/web/lang/it/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/hacker_po.inc b/web/lang/it/hacker_po.inc
index e0531a1..78c1f58 100644
--- a/web/lang/it/hacker_po.inc
+++ b/web/lang/it/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/index_po.inc b/web/lang/it/index_po.inc
index f5793b7..cef6e8c 100644
--- a/web/lang/it/index_po.inc
+++ b/web/lang/it/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/logout_po.inc b/web/lang/it/logout_po.inc
index a9ec8d8..2075be9 100644
--- a/web/lang/it/logout_po.inc
+++ b/web/lang/it/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/pkgedit_po.inc b/web/lang/it/pkgedit_po.inc
index fdeb6cf..731904a 100644
--- a/web/lang/it/pkgedit_po.inc
+++ b/web/lang/it/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/pkgfuncs_po.inc b/web/lang/it/pkgfuncs_po.inc
index 7cdda1b..b674687 100644
--- a/web/lang/it/pkgfuncs_po.inc
+++ b/web/lang/it/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/search_po.inc b/web/lang/it/search_po.inc
index 4acd2e6..0c83ca5 100644
--- a/web/lang/it/search_po.inc
+++ b/web/lang/it/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/submit_po.inc b/web/lang/it/submit_po.inc
index 604f019..f2dc8e5 100644
--- a/web/lang/it/submit_po.inc
+++ b/web/lang/it/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/template_po.inc b/web/lang/it/template_po.inc
index 4bde2ee..defe7ac 100644
--- a/web/lang/it/template_po.inc
+++ b/web/lang/it/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/test_po.inc b/web/lang/it/test_po.inc
index 26694d9..40be513 100644
--- a/web/lang/it/test_po.inc
+++ b/web/lang/it/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/it/timeout_po.inc b/web/lang/it/timeout_po.inc
index 8071faf..2d52bc8 100644
--- a/web/lang/it/timeout_po.inc
+++ b/web/lang/it/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Italian (Italiano) translation
 # Translators: Giovanni Scafora <linuxmania@gmail.com> and Pierluigi Picciau <pierluigi88@gmail.com>
 
diff --git a/web/lang/logout_po.inc b/web/lang/logout_po.inc
index 154f7e2..41adfc8 100644
--- a/web/lang/logout_po.inc
+++ b/web/lang/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pkgedit_po.inc b/web/lang/pkgedit_po.inc
index fdd4d61..49e7ae4 100644
--- a/web/lang/pkgedit_po.inc
+++ b/web/lang/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pkgfuncs_po.inc b/web/lang/pkgfuncs_po.inc
index ce08b8c..3225952 100644
--- a/web/lang/pkgfuncs_po.inc
+++ b/web/lang/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pl/account_po.inc b/web/lang/pl/account_po.inc
index c96e9a1..6072686 100644
--- a/web/lang/pl/account_po.inc
+++ b/web/lang/pl/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
diff --git a/web/lang/pl/acctfuncs_po.inc b/web/lang/pl/acctfuncs_po.inc
index 1dc6cde..4b94e9d 100644
--- a/web/lang/pl/acctfuncs_po.inc
+++ b/web/lang/pl/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
diff --git a/web/lang/pl/aur_po.inc b/web/lang/pl/aur_po.inc
index 86a2762..0cfee72 100644
--- a/web/lang/pl/aur_po.inc
+++ b/web/lang/pl/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -27,4 +27,4 @@ $_t["pl"]["Bugs"] = "Błędy";
 
 $_t["pl"]["My Packages"] = "Moje pakiety";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/common_po.inc b/web/lang/pl/common_po.inc
index 4ac4c19..6797c39 100644
--- a/web/lang/pl/common_po.inc
+++ b/web/lang/pl/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -17,4 +17,4 @@ $_t["pl"]["Less"] = "Poprzednie";
 $_t["pl"]["More"] = "Następne";
 $_t["pl"]["Username"] = "Użytkownik";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/hacker_po.inc b/web/lang/pl/hacker_po.inc
index 4cb8781..92c1641 100644
--- a/web/lang/pl/hacker_po.inc
+++ b/web/lang/pl/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -8,4 +8,4 @@ global $_t;
 $_t["pl"]["Your session id is invalid."] = "Twój identyfikator sesji jest nieprawidłowy.";
 $_t["pl"]["If this problem persists, please contact the site administrator."] = "Jeżeli ten problem się powtarza, skontaktuj się z administratorem strony.";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/index_po.inc b/web/lang/pl/index_po.inc
index 6eb6adb..c67215d 100644
--- a/web/lang/pl/index_po.inc
+++ b/web/lang/pl/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -68,4 +68,4 @@ $_t["pl"]["Flagged as safe"] = "Oznaczonych jako bezpieczne";
 
 $_t["pl"]["My Statistics"] = "Moje statystyki";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/logout_po.inc b/web/lang/pl/logout_po.inc
index 1d5326f..5ac7a82 100644
--- a/web/lang/pl/logout_po.inc
+++ b/web/lang/pl/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
diff --git a/web/lang/pl/pkgedit_po.inc b/web/lang/pl/pkgedit_po.inc
index df8dc79..a506dc2 100644
--- a/web/lang/pl/pkgedit_po.inc
+++ b/web/lang/pl/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -19,4 +19,4 @@ $_t["pl"]["Invalid category ID."] = "Nieprawidłowy identyfikator kategorii.";
 $_t["pl"]["Select new category"] = "Wybierz nową kategorię";
 $_t["pl"]["You've found a bug if you see this...."] = "Jeżeli to widzisz, to znalazłeś błąd...";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/pkgfuncs_po.inc b/web/lang/pl/pkgfuncs_po.inc
index 63ccccf..34f8bca 100644
--- a/web/lang/pl/pkgfuncs_po.inc
+++ b/web/lang/pl/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
diff --git a/web/lang/pl/search_po.inc b/web/lang/pl/search_po.inc
index 31838f1..2c4a634 100644
--- a/web/lang/pl/search_po.inc
+++ b/web/lang/pl/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
diff --git a/web/lang/pl/submit_po.inc b/web/lang/pl/submit_po.inc
index 95258a5..bbcb301 100644
--- a/web/lang/pl/submit_po.inc
+++ b/web/lang/pl/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -56,4 +56,4 @@ $_t["pl"]["Missing license variable in PKGBUILD."] = "W pliku PKGBUILD brakuje z
 
 $_t["pl"]["Missing arch variable in PKGBUILD."] = "W pliku PKGBUILD brakuje zmiennej arch.";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/template_po.inc b/web/lang/pl/template_po.inc
index 6c61d37..266e421 100644
--- a/web/lang/pl/template_po.inc
+++ b/web/lang/pl/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -7,4 +7,4 @@ global $_t;
 
 $_t["pl"]["Hi, this is worth reading!"] = "Witaj, warto to przeczytać!";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pl/test_po.inc b/web/lang/pl/test_po.inc
index b04cbd7..847a0ab 100644
--- a/web/lang/pl/test_po.inc
+++ b/web/lang/pl/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
diff --git a/web/lang/pl/timeout_po.inc b/web/lang/pl/timeout_po.inc
index 8fbc2a6..867a8ef 100644
--- a/web/lang/pl/timeout_po.inc
+++ b/web/lang/pl/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Polish (Polski) translation
 # Translator: Jaroslaw Swierczynski <swiergot@gmail.com>
 
@@ -8,4 +8,4 @@ global $_t;
 $_t["pl"]["Click on the Home link above to log in."] = "Kliknij na linku Start powyżej aby się zalogować.";
 $_t["pl"]["Your session has timed out.  You must log in again."] = "Twoja sesja wygasła. Musisz zalogować się ponownie.";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lang/pt/account_po.inc b/web/lang/pt/account_po.inc
index da5e8ec..96dd237 100644
--- a/web/lang/pt/account_po.inc
+++ b/web/lang/pt/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/acctfuncs_po.inc b/web/lang/pt/acctfuncs_po.inc
index 289a896..c7d158a 100644
--- a/web/lang/pt/acctfuncs_po.inc
+++ b/web/lang/pt/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/aur_po.inc b/web/lang/pt/aur_po.inc
index 61f57d5..998c619 100644
--- a/web/lang/pt/aur_po.inc
+++ b/web/lang/pt/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/common_po.inc b/web/lang/pt/common_po.inc
index 25360fa..5bc3e6d 100644
--- a/web/lang/pt/common_po.inc
+++ b/web/lang/pt/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/hacker_po.inc b/web/lang/pt/hacker_po.inc
index 792474c..542b785 100644
--- a/web/lang/pt/hacker_po.inc
+++ b/web/lang/pt/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/index_po.inc b/web/lang/pt/index_po.inc
index bf3a9cb..7fe4283 100644
--- a/web/lang/pt/index_po.inc
+++ b/web/lang/pt/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/logout_po.inc b/web/lang/pt/logout_po.inc
index 3731e42..671f9ba 100644
--- a/web/lang/pt/logout_po.inc
+++ b/web/lang/pt/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/pkgedit_po.inc b/web/lang/pt/pkgedit_po.inc
index 3daea31..083c232 100644
--- a/web/lang/pt/pkgedit_po.inc
+++ b/web/lang/pt/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/pkgfuncs_po.inc b/web/lang/pt/pkgfuncs_po.inc
index 9f0065f..cc5ee48 100644
--- a/web/lang/pt/pkgfuncs_po.inc
+++ b/web/lang/pt/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/search_po.inc b/web/lang/pt/search_po.inc
index 94e4b3a..79c5215 100644
--- a/web/lang/pt/search_po.inc
+++ b/web/lang/pt/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/submit_po.inc b/web/lang/pt/submit_po.inc
index c07b950..10d1159 100644
--- a/web/lang/pt/submit_po.inc
+++ b/web/lang/pt/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/template_po.inc b/web/lang/pt/template_po.inc
index 84172f3..ed4a1d0 100644
--- a/web/lang/pt/template_po.inc
+++ b/web/lang/pt/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/test_po.inc b/web/lang/pt/test_po.inc
index 9bb9293..040e736 100644
--- a/web/lang/pt/test_po.inc
+++ b/web/lang/pt/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/pt/timeout_po.inc b/web/lang/pt/timeout_po.inc
index 21cc597..7e6c667 100644
--- a/web/lang/pt/timeout_po.inc
+++ b/web/lang/pt/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/ru/account_po.inc b/web/lang/ru/account_po.inc
index f878718..73eb0ce 100644
--- a/web/lang/ru/account_po.inc
+++ b/web/lang/ru/account_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/acctfuncs_po.inc b/web/lang/ru/acctfuncs_po.inc
index 76cac5c..8e02a90 100644
--- a/web/lang/ru/acctfuncs_po.inc
+++ b/web/lang/ru/acctfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/aur_po.inc b/web/lang/ru/aur_po.inc
index 70f1004..d7c6701 100644
--- a/web/lang/ru/aur_po.inc
+++ b/web/lang/ru/aur_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/common_po.inc b/web/lang/ru/common_po.inc
index 4d89aba..f5c7607 100644
--- a/web/lang/ru/common_po.inc
+++ b/web/lang/ru/common_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/hacker_po.inc b/web/lang/ru/hacker_po.inc
index 43c591a..5a167ca 100644
--- a/web/lang/ru/hacker_po.inc
+++ b/web/lang/ru/hacker_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/index_po.inc b/web/lang/ru/index_po.inc
index a42b8e4..653511a 100644
--- a/web/lang/ru/index_po.inc
+++ b/web/lang/ru/index_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/logout_po.inc b/web/lang/ru/logout_po.inc
index fcc885c..86d3eaf 100644
--- a/web/lang/ru/logout_po.inc
+++ b/web/lang/ru/logout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/pkgedit_po.inc b/web/lang/ru/pkgedit_po.inc
index cc9e9b9..c2ed68a 100644
--- a/web/lang/ru/pkgedit_po.inc
+++ b/web/lang/ru/pkgedit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/pkgfuncs_po.inc b/web/lang/ru/pkgfuncs_po.inc
index af188ad..c78157e 100644
--- a/web/lang/ru/pkgfuncs_po.inc
+++ b/web/lang/ru/pkgfuncs_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/search_po.inc b/web/lang/ru/search_po.inc
index 7462ed1..3dbec13 100644
--- a/web/lang/ru/search_po.inc
+++ b/web/lang/ru/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/submit_po.inc b/web/lang/ru/submit_po.inc
index 53694fe..02e472a 100644
--- a/web/lang/ru/submit_po.inc
+++ b/web/lang/ru/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/template_po.inc b/web/lang/ru/template_po.inc
index 7fb86df..86c3e9b 100644
--- a/web/lang/ru/template_po.inc
+++ b/web/lang/ru/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/test_po.inc b/web/lang/ru/test_po.inc
index afead61..381abe3 100644
--- a/web/lang/ru/test_po.inc
+++ b/web/lang/ru/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/ru/timeout_po.inc b/web/lang/ru/timeout_po.inc
index 3f89977..8dce6bb 100644
--- a/web/lang/ru/timeout_po.inc
+++ b/web/lang/ru/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # Russian (Русский) translation
 # Translator: Sergej Pupykin <ps@lx-ltd.ru>
 
diff --git a/web/lang/search_po.inc b/web/lang/search_po.inc
index 32db9da..f9272b9 100644
--- a/web/lang/search_po.inc
+++ b/web/lang/search_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/submit_po.inc b/web/lang/submit_po.inc
index 10af34a..d9e7a1c 100644
--- a/web/lang/submit_po.inc
+++ b/web/lang/submit_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/template_po.inc b/web/lang/template_po.inc
index 51c0ce7..8d65fc0 100644
--- a/web/lang/template_po.inc
+++ b/web/lang/template_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/test_po.inc b/web/lang/test_po.inc
index 6e7584e..a2c5c5c 100644
--- a/web/lang/test_po.inc
+++ b/web/lang/test_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lang/timeout_po.inc b/web/lang/timeout_po.inc
index 0e2e8d0..d56c0bd 100644
--- a/web/lang/timeout_po.inc
+++ b/web/lang/timeout_po.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/lib/acctfuncs.inc b/web/lib/acctfuncs.inc
index fa6df45..5de16dd 100644
--- a/web/lib/acctfuncs.inc
+++ b/web/lib/acctfuncs.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 include_once("acctfuncs_po.inc");
 
 # Display the standard Account form, pass in default values if any
diff --git a/web/lib/aur.inc b/web/lib/aur.inc
index 063f903..cce5384 100644
--- a/web/lib/aur.inc
+++ b/web/lib/aur.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 header('Content-Type: text/html; charset=utf-8');
 header('Cache-Control: no-cache, must-revalidate');
 header('Expires: Tue, 11 Oct 1988 22:00:00 GMT'); // quite a special day
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index d1da9bc..b9ad0d4 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 include_once("pkgfuncs_po.inc");
 include_once("config.inc");
 
diff --git a/web/lib/translator.inc b/web/lib/translator.inc
index 7b33655..bfae276 100644
--- a/web/lib/translator.inc
+++ b/web/lib/translator.inc
@@ -1,4 +1,4 @@
-<?
+<?php
 # this include file provides support for i18n
 #
 
diff --git a/web/utils/genpopo b/web/utils/genpopo
index 652f9fc..bfe3492 100755
--- a/web/utils/genpopo
+++ b/web/utils/genpopo
@@ -13,7 +13,7 @@
 #
 
 INC_HEADER = """\
-<?
+<?php
 # INSTRUCTIONS TO TRANSLATORS
 #
 # This file contains the i18n translations for a subset of the
diff --git a/web/utils/translation_tool b/web/utils/translation_tool
index 0341da3..ae9ae1d 100755
--- a/web/utils/translation_tool
+++ b/web/utils/translation_tool
@@ -23,7 +23,7 @@ if len(trans_abbrv) != 2:
 
 
 INC_HEADER = """\
-<?
+<?php
 # %s (%s) translation
 # Translator: %s <%s>
 
-- 
cgit v1.2.3-70-g09d2


From 8d11961ee75c5372d3cfd104ee83242127fcffa5 Mon Sep 17 00:00:00 2001
From: Paul Mattal <pjmattal@pedantic.in.mattal.com>
Date: Sat, 22 Sep 2007 08:06:20 -0400
Subject: Added Italian language patch 20070921 from Giovanni Scafora

---
 web/lang/it/account_po.inc   |  8 ++++----
 web/lang/it/acctfuncs_po.inc |  6 +++---
 web/lang/it/index_po.inc     | 18 +++++++++---------
 web/lang/it/pkgedit_po.inc   |  6 +++---
 web/lang/it/pkgfuncs_po.inc  | 38 +++++++++++++++++++-------------------
 web/lang/it/submit_po.inc    |  6 +++---
 web/lang/it/timeout_po.inc   |  4 ++--
 7 files changed, 43 insertions(+), 43 deletions(-)

diff --git a/web/lang/it/account_po.inc b/web/lang/it/account_po.inc
index 8c65697..be2aa70 100644
--- a/web/lang/it/account_po.inc
+++ b/web/lang/it/account_po.inc
@@ -5,19 +5,19 @@
 include_once("translator.inc");
 global $_t;
 
-$_t["it"]["Use this form to update your account."] = "Utilizzare questo modulo per aggiornare un account.";
+$_t["it"]["Use this form to update your account."] = "Utilizza questo modulo per aggiornare un account.";
 
-$_t["it"]["Leave the password fields blank to keep your same password."] = "Lasciare vuoti i campi relativi alla password per mantenerla invariata.";
+$_t["it"]["Leave the password fields blank to keep your same password."] = "Lascia vuoti i campi relativi alla password per mantenerla invariata.";
 
 $_t["it"]["You are not allowed to access this area."] = "Non si dispone dei permessi necessari per accedere.";
 
 $_t["it"]["Could not retrieve information for the specified user."] = "Non è stato possibile trovare le informazioni sull'utente specificato.";
 
-$_t["it"]["Use this form to search existing accounts."] = "Utilizzare questo modulo per cercare account esistenti.";
+$_t["it"]["Use this form to search existing accounts."] = "Utilizza questo modulo per cercare account esistenti.";
 
 $_t["it"]["You do not have permission to edit this account."] = "Non si dispone dei permessi necessari per modificare questo account.";
 
-$_t["it"]["Use this form to create an account."] = "Utilizzare questo modulo per creare un account.";
+$_t["it"]["Use this form to create an account."] = "Utilizza questo modulo per creare un account.";
 
 $_t["it"]["You must log in to view user information."] = "Bisogna essere autenticati per poter visualizzare le informazioni sull'utente.";
 
diff --git a/web/lang/it/acctfuncs_po.inc b/web/lang/it/acctfuncs_po.inc
index 26c4d4d..e08d342 100644
--- a/web/lang/it/acctfuncs_po.inc
+++ b/web/lang/it/acctfuncs_po.inc
@@ -47,7 +47,7 @@ $_t["it"]["Last Voted"] = "Ultimo votato";
 
 $_t["it"]["Real Name"] = "Nome reale";
 
-$_t["it"]["Edit Account"] = "Modificare l'account";
+$_t["it"]["Edit Account"] = "Modifica l'account";
 
 $_t["it"]["Password fields do not match."] = "I campi password non corrispondono.";
 
@@ -61,11 +61,11 @@ $_t["it"]["No more results to display."] = "Non vi sono ulteriori risultati da v
 
 $_t["it"]["Type"] = "Tipo";
 
-$_t["it"]["Click on the Home link above to login."] = "Fare clic su Inizio per autenticarsi.";
+$_t["it"]["Click on the Home link above to login."] = "Clicca su Inizio per autenticarti.";
 
 $_t["it"]["Sort by"] = "Ordina per";
 
-$_t["it"]["Re-type password"] = "Riscrivere la password";
+$_t["it"]["Re-type password"] = "Riscrivi la password";
 
 $_t["it"]["Language is not currently supported."] = "Lingua attualmente non supportata.";
 
diff --git a/web/lang/it/index_po.inc b/web/lang/it/index_po.inc
index cef6e8c..f316aea 100644
--- a/web/lang/it/index_po.inc
+++ b/web/lang/it/index_po.inc
@@ -5,9 +5,9 @@
 include_once("translator.inc");
 global $_t;
 
-$_t["it"]["You must supply a password."] = "E' necessario inserire una password.";
+$_t["it"]["You must supply a password."] = "È necessario inserire una password.";
 
-$_t["it"]["You must supply a username."] = "E' necessario inserire il nome utente.";
+$_t["it"]["You must supply a username."] = "È necessario inserire il nome utente.";
 
 $_t["it"]["After that, this can be filled in with more meaningful text."] = "Dopotutto, questo potrebbe essere riempito con un messaggio più significativo.";
 
@@ -27,7 +27,7 @@ $_t["it"]["Error trying to generate session id."] = "Errore durante la generazio
 
 $_t["it"]["For now, it's just a place holder."] = "Per adesso, è solo un segnaposto.";
 
-$_t["it"]["It's more important to get the login functionality finished."] = "E' più importante avere la funzionalità di autenticazione completata.";
+$_t["it"]["It's more important to get the login functionality finished."] = "È più importante avere la funzionalità di autenticazione completata.";
 
 $_t["it"]["Error looking up username, %s."] = "Errore durante la ricerca del nome utente %s.";
 
@@ -47,13 +47,13 @@ $_t["it"]["Email discussion about the AUR takes place on the %sTUR Users List%s.
 
 $_t["it"]["Recent Updates"] = "Aggiornamenti recenti";
 
-$_t["it"]["Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information. Contributed PKGBUILDs <b>must</b> conform to the %hArch Packaging Standards%h otherwise they will be deleted!"] = "Benvenuto in AUR! Per ottenere maggiori informazioni, leggere %hAUR User Guidelines%h e %hAUR TU Guidelines%h. I PKGBUILD inviati <b>devono</b> essere conformi agli %hArch Packaging Standards%h altrimenti saranno cancellati!";
+$_t["it"]["Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information. Contributed PKGBUILDs <b>must</b> conform to the %hArch Packaging Standards%h otherwise they will be deleted!"] = "Benvenuto in AUR! Per ottenere maggiori informazioni, leggi le %hAUR User Guidelines%h e %hAUR TU Guidelines%h. I PKGBUILD inviati <b>devono</b> essere conformi agli %hArch Packaging Standards%h altrimenti saranno cancellati!";
 
 $_t["it"]["Community"] = "Community";
 
 $_t["it"]["Package Counts"] = "Conteggio dei pacchetti";
 
-$_t["it"]["Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information."] = "Benvenuto in AUR! Per ottenere maggiori informazioni, leggere %hAUR User Guidelines%h e %hAUR TU Guidelines%h.";
+$_t["it"]["Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information."] = "Benvenuto in AUR! Per ottenere maggiori informazioni, leggi le %hAUR User Guidelines%h e %hAUR TU Guidelines%h.";
 
 $_t["it"]["Unsupported"] = "Unsupported";
 
@@ -69,9 +69,9 @@ $_t["it"]["Packages in unsupported"] = "Pacchetti in unsupported";
 
 $_t["it"]["Packages in [community]"] = "Pacchetti in [community]";
 
-$_t["it"]["Remember to vote for your favourite packages! The most popular packages are provided as binary packages in [community]."] = "Ricordate di votare i vostri pacchetti preferiti! I pacchetti più votati sono disponibili in [community] come precompilati.";
+$_t["it"]["Remember to vote for your favourite packages! The most popular packages are provided as binary packages in [community]."] = "Ricorda di votare i tuoi pacchetti preferiti! I pacchetti più votati saranno disponibili in [community] come precompilati.";
 
-$_t["it"]["Remember to vote for your favourite packages!"] = "Ricordate di votare i vostri pacchetti preferiti!";
+$_t["it"]["Remember to vote for your favourite packages!"] = "Ricorda di votare i tuoi pacchetti preferiti!";
 
 $_t["it"]["The most popular packages will be provided as binary packages in [community]."] = "I pacchetti più votati saranno disponibili in [community] come precompilati.";
 
@@ -85,9 +85,9 @@ $_t["it"]["Out-of-date"] = "Non aggiornati";
 
 $_t["it"]["User Statistics"] = "Statistiche dell'utente";
 
-$_t["it"]["Flagged as safe by me"] = "Segnato come sicuro da me";
+$_t["it"]["Flagged as safe by me"] = "Pacchetti verificati";
 
-$_t["it"]["Flagged as safe"] = "Segnato come sicuro";
+$_t["it"]["Flagged as safe"] = "Considerato sicuro";
 
 $_t["it"]["My Statistics"] = "Le mie statistiche";
 
diff --git a/web/lang/it/pkgedit_po.inc b/web/lang/it/pkgedit_po.inc
index 731904a..9df8ebc 100644
--- a/web/lang/it/pkgedit_po.inc
+++ b/web/lang/it/pkgedit_po.inc
@@ -9,7 +9,7 @@ $_t["it"]["Missing package ID."] = "Manca l'ID del pacchetto.";
 
 $_t["it"]["Invalid category ID."] = "ID della categoria non valido.";
 
-$_t["it"]["Enter your comment below."] = "Inserire un commento qui sotto.";
+$_t["it"]["Enter your comment below."] = "Inserisci un commento qui sotto.";
 
 $_t["it"]["You are not allowed to delete this comment."] = "Non è possibile cancellare questo commento.";
 
@@ -23,8 +23,8 @@ $_t["it"]["Comment has been deleted."] = "Il commento è stato cancellato.";
 
 $_t["it"]["You've found a bug if you see this...."] = "Se vedi questo, hai appena trovato un bug....";
 
-$_t["it"]["Comment has been added."] = "Il commento è stato aggiunto.";
+$_t["it"]["Comment has been added."] = "Il commento è stato inserito.";
 
-$_t["it"]["Select new category"] = "Selezionare una nuova categoria";
+$_t["it"]["Select new category"] = "Seleziona una nuova categoria";
 
 ?>
\ No newline at end of file
diff --git a/web/lang/it/pkgfuncs_po.inc b/web/lang/it/pkgfuncs_po.inc
index b674687..58668c3 100644
--- a/web/lang/it/pkgfuncs_po.inc
+++ b/web/lang/it/pkgfuncs_po.inc
@@ -13,15 +13,15 @@ $_t["it"]["Comment by: %h%s%h on %h%s%h"] = "Commento lasciato da: %h%s%h il %h%
 
 $_t["it"]["Location"] = "Posizione";
 
-$_t["it"]["Delete comment"] = "Eliminare il commento";
+$_t["it"]["Delete comment"] = "Elimina il commento";
 
 $_t["it"]["Go"] = "Cerca";
 
-$_t["it"]["Unflag Out-of-date"] = "Segnare come aggiornato";
+$_t["it"]["Unflag Out-of-date"] = "Pacchetto aggiornato";
 
-$_t["it"]["Go back to %hpackage details view%h."] = "Ritornare alla %hvista dettagli del pacchetto%h.";
+$_t["it"]["Go back to %hpackage details view%h."] = "Ritorna alla %hvista dettagli del pacchetto%h.";
 
-$_t["it"]["Error retrieving package details."] = "Errore nel recupero dei dettagli del pacchetto.";
+$_t["it"]["Error retrieving package details."] = "Si è verificato un errore durante il recupero dei dettagli del pacchetto.";
 
 $_t["it"]["Description"] = "Descrizione";
 
@@ -31,13 +31,13 @@ $_t["it"]["Keywords"] = "Parola chiave";
 
 $_t["it"]["Dependencies"] = "Dipendenze";
 
-$_t["it"]["Disown Packages"] = "Abbandonare i pacchetti";
+$_t["it"]["Disown Packages"] = "Abbandona i pacchetti";
 
 $_t["it"]["Package details could not be found."] = "Impossibile trovare i dettagli del pacchetto.";
 
 $_t["it"]["Package Details"] = "Dettagli del pacchetto";
 
-$_t["it"]["Error retrieving package list."] = "Errore nel recupero della lista dei pacchetti.";
+$_t["it"]["Error retrieving package list."] = "Si è verificato un errore durante il recupero della lista dei pacchetti.";
 
 $_t["it"]["Files"] = "File";
 
@@ -47,7 +47,7 @@ $_t["it"]["Name"] = "Nome";
 
 $_t["it"]["Per page"] = "Per pagina";
 
-$_t["it"]["Go back to %hsearch results%h."] = "Ritornare ai %hrisultati della ricerca%h.";
+$_t["it"]["Go back to %hsearch results%h."] = "Ritorna ai %hrisultati della ricerca%h.";
 
 $_t["it"]["No packages matched your search criteria."] = "Nessun pacchetto corrisponde ai criteri della ricerca.";
 
@@ -55,21 +55,21 @@ $_t["it"]["O%hrphan"] = "O%hrfano";
 
 $_t["it"]["orphan"] = "orfano";
 
-$_t["it"]["Un-Vote"] = "Rimuovere il voto";
+$_t["it"]["Un-Vote"] = "Rimuovi il voto";
 
-$_t["it"]["change category"] = "Cambiare categoria";
+$_t["it"]["change category"] = "Cambia categoria";
 
-$_t["it"]["UnNotify"] = "Togliere la notifica";
+$_t["it"]["UnNotify"] = "Togli la notifica";
 
-$_t["it"]["Delete Packages"] = "Eliminare i pacchetti";
+$_t["it"]["Delete Packages"] = "Elimina i pacchetti";
 
 $_t["it"]["Maintainer"] = "Responsabile";
 
-$_t["it"]["Add Comment"] = "Aggiungere un commento";
+$_t["it"]["Add Comment"] = "Aggiungi un commento";
 
 $_t["it"]["Tarball"] = "Archivio";
 
-$_t["it"]["Flag Out-of-date"] = "Segnare come non aggiornato";
+$_t["it"]["Flag Out-of-date"] = "Pacchetto non aggiornato";
 
 $_t["it"]["Manage"] = "Organizza";
 
@@ -87,7 +87,7 @@ $_t["it"]["O%hut-of-Date"] = "N%hon aggiornato";
 
 $_t["it"]["Vote"] = "Vota";
 
-$_t["it"]["Adopt Packages"] = "Adottare i pacchetti";
+$_t["it"]["Adopt Packages"] = "Adotta i pacchetti";
 
 $_t["it"]["Yes"] = "Si";
 
@@ -101,7 +101,7 @@ $_t["it"]["Voted"] = "Votato";
 
 $_t["it"]["No New Comment Notification"] = "Nessuna notifica di nuovo commento";
 
-$_t["it"]["New Comment Notification"] = "Notifica di nuovo commento";
+$_t["it"]["New Comment Notification"] = "Notifica di un nuovo commento";
 
 $_t["it"]["Comments"] = "Commenti";
 
@@ -109,13 +109,13 @@ $_t["it"]["The above files have been verified (by %s) and are safe to use."] = "
 
 $_t["it"]["Be careful! The above files may contain malicious code that can damage your system."] = "Attenzione! I file potrebbero contenere codice pericoloso in grado di danneggiare il vostro sistema.";
 
-$_t["it"]["Flag Safe"] = "Segnare come sicuro";
+$_t["it"]["Flag Safe"] = "Pacchetto sicuro";
 
-$_t["it"]["Flag Package Safe To Use"] = "Segnare il pacchetto come sicuro da utilizzare";
+$_t["it"]["Flag Package Safe To Use"] = "Pacchetto sicuro";
 
-$_t["it"]["Unflag Safe"] = "Segnare come non sicuro";
+$_t["it"]["Unflag Safe"] = "Pacchetto non sicuro";
 
-$_t["it"]["Unflag Package Safe To Use"] = "Segnare il pacchetto come non sicuro da utilizzare";
+$_t["it"]["Unflag Package Safe To Use"] = "Pacchetto non sicuro";
 
 $_t["it"]["Safe"] = "Sicuri";
 
diff --git a/web/lang/it/submit_po.inc b/web/lang/it/submit_po.inc
index f2dc8e5..372c60d 100644
--- a/web/lang/it/submit_po.inc
+++ b/web/lang/it/submit_po.inc
@@ -21,7 +21,7 @@ $_t["it"]["You must create an account before you can upload packages."] = "Bisog
 
 $_t["it"]["Package upload successful."] = "Invio completato con successo.";
 
-$_t["it"]["Overwrite existing package?"] = "Sovrascrivere il pacchetto esistente?";
+$_t["it"]["Overwrite existing package?"] = "Sovrascrivi il pacchetto esistente?";
 
 $_t["it"]["You did not specify a package name."] = "Non è stato specificato un nome per il pacchetto.";
 
@@ -61,9 +61,9 @@ $_t["it"]["Error - No file uploaded"] = "Errore, nessun file inviato.";
 
 $_t["it"]["You are not allowed to overwrite the %h%s%h package."] = "Non si dispone dei permessi per poter sovrascrivere il pacchetto %h%s%h.";
 
-$_t["it"]["Select Location"] = "Selezionare la posizione";
+$_t["it"]["Select Location"] = "Seleziona la posizione";
 
-$_t["it"]["Select Category"] = "Selezionare la categoria";
+$_t["it"]["Select Category"] = "Seleziona la categoria";
 
 $_t["it"]["Comment"] = "Commento";
 
diff --git a/web/lang/it/timeout_po.inc b/web/lang/it/timeout_po.inc
index 2d52bc8..7b25780 100644
--- a/web/lang/it/timeout_po.inc
+++ b/web/lang/it/timeout_po.inc
@@ -5,8 +5,8 @@
 include_once("translator.inc");
 global $_t;
 
-$_t["it"]["Click on the Home link above to log in."] = "Fare clic su Inizio per autenticarsi.";
+$_t["it"]["Click on the Home link above to log in."] = "Clicca su Inizio per autenticarti.";
 
-$_t["it"]["Your session has timed out.  You must log in again."] = "La sessione è scaduta. Autenticarsi di nuovo.";
+$_t["it"]["Your session has timed out.  You must log in again."] = "La sessione è scaduta, autenticati di nuovo.";
 
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2


From ac8291a5dcbfe9edf53d627be1139fe52708d4ce Mon Sep 17 00:00:00 2001
From: eliott <eliott@cactuswax.net>
Date: Sat, 22 Sep 2007 12:09:00 -0700
Subject: Changes to bring the main arch site theme to the aur.

---
 .gitignore                     |   3 +
 web/html/css/arch.css          | 449 +++++++++++++++++++++++++++++++++++++++++
 web/html/images/logo.png       | Bin 0 -> 15730 bytes
 web/html/images/tab.png        | Bin 0 -> 107 bytes
 web/html/images/title.png      | Bin 0 -> 6465 bytes
 web/html/images/title_back.png | Bin 0 -> 168 bytes
 web/lang/en/pkgfuncs_po.inc    |   4 +-
 web/lib/aur.inc                | 166 +++++++--------
 web/lib/pkgfuncs.inc           | 360 ++++++++++++++-------------------
 9 files changed, 676 insertions(+), 306 deletions(-)
 create mode 100644 .gitignore
 create mode 100644 web/html/css/arch.css
 create mode 100644 web/html/images/logo.png
 create mode 100644 web/html/images/tab.png
 create mode 100644 web/html/images/title.png
 create mode 100644 web/html/images/title_back.png

diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..9e572ce
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1,3 @@
+*.swp
+web/lib/config.inc
+
diff --git a/web/html/css/arch.css b/web/html/css/arch.css
new file mode 100644
index 0000000..7d8f41f
--- /dev/null
+++ b/web/html/css/arch.css
@@ -0,0 +1,449 @@
+* { margin: 0; padding: 0; }
+* ul { padding: 20px; }
+body {
+	background: url("/images/title_back.png") repeat-x top left #fbf8f1;
+	padding: 0 30px;
+	color: #46494d;
+	font-family: Bitstream Vera Sans, Lucida Grande, Arial, sans-serif;
+}
+/*
+ * Divs
+ */
+#head_container {
+	height: 175px;
+}
+#main_nav ul {
+	list-style: none;
+	padding-right: 10px;
+	padding-top: 48px;
+}
+#main_nav ul li {
+	display: block;
+	float: right;
+	width: 67px;
+	height: 20px;
+	padding-top: 2px;
+	margin-left: 3px;
+	background: url("/images/tab.png") repeat-x bottom left #fbf8f1;
+	text-align: center;
+	font-size: 13px;
+}
+#main_nav ul li[class~=selected] {
+	background: #fbf8f1;
+}
+#main_nav ul li a {
+	text-decoration: none;
+}
+#sub_nav ul {
+	list-style: none;
+	padding-right: 10px;
+	padding-top: 5px;
+}
+#sub_nav ul li {
+	display: block;
+	float: right;
+	width: 87px;
+	height: 20px;
+	padding-top: 2px;
+	margin-left: 3px;
+	background: url("/images/tab.png") repeat-x bottom left #fbf8f1;
+	border: 1px solid #cccccc;
+	text-align: center;
+	font-size: 13px;
+}
+#sub_nav ul li[class~=selected] {
+	background: #fbf8f1;
+}
+#sub_nav ul li a {
+	text-decoration: none;
+}
+
+#lang_sub {
+   display: block;
+   position: absolute;
+   top: 0;
+   right: 20px;
+}
+#lang_sub ul {
+	list-style: none;
+}
+#lang_sub ul a {
+   text-decoration: none;
+   color: #000000;
+}
+#lang_sub ul a:hover {
+   color: #FF0000;
+}
+#lang_sub ul li {
+	display: block;
+	float: right;
+	margin-left: 6px;
+	font-size: 10px;
+	text-align: center;
+}
+
+#title {
+	height: 140px;
+	float: left;
+}
+#updates {
+	font-size: small;
+	/*position: relative;*/
+	top: 0px;
+	background: #f6efe0;
+	border: 1px solid #eee4cb;
+	padding: 10px;
+}
+#ads {
+	float: right;
+}
+#logo {
+	float: left;
+	width: 140px;
+	height: 140px;
+}
+#titleimg {
+	float: left;
+}
+#devlist {
+	width: 80%;
+	padding: 10px;
+	margin-left: auto;
+	margin-right: auto;
+	border-top: 1px dashed black;
+	border-bottom: 1px dashed black;
+	text-align: center;
+}
+.clear {
+	clear: both;
+	margin: 0;
+	padding: 0;
+}
+.right {
+	float: right;
+	width: 320px;
+	padding: 0 10px 10px 0;
+}
+.left {
+	padding: 10px;
+	margin: 0 360px 0 0;
+}
+.left p {
+	text-align: justify;
+	padding-bottom: 10px;
+}
+.box {
+	padding: 10px;
+	background: #e1e3e6;
+	border: 1px solid #8faecd;
+}
+.greybox {
+	padding: 10px;
+	background: #f6efe0;
+	border: 1px solid #eee4cb;
+}
+div.listing {
+	padding-right: 10px;
+	border-left: 1px solid #387cbf;
+}
+.error {
+	color: #dd0000;
+	font-size: small;
+}
+.foot {
+	clear: both;
+	text-align: center;
+	font-size: 0.8em;
+}
+#search {
+	float: right;
+	position: relative;
+	top: -2em;
+	font-size: 0.8em;
+}
+#search input {
+	background: #f6efe0;
+	border: 1px solid #eee4cb;
+}
+.smalltext {
+	text-align: right;
+	font-size: x-small;
+}
+/*
+ * Headers
+ */
+h2 {
+	margin: 20px 0 10px 0;
+}
+h2.title {
+	border-bottom: 1px solid #46494d;
+}
+h3 {
+	margin-bottom: 10px;
+}
+h3.title {
+	text-align: right;
+	border-bottom: 1px solid #46494d;
+}
+h4.title {
+	text-align: left;
+	border-bottom: 1px solid #46494d;
+}
+h4.news {
+	border-bottom: 1px dotted #8faecd;
+}
+div.listing h4 {
+	background: #d1d3d6;
+	border-top: 1px double #387cbf;
+	padding: 3px;
+}
+/*
+ * Paragraphs, Anchors, Images
+ */
+p {
+	padding-bottom: 20px;
+}
+p.news {
+	text-align: left;
+	font-size: small;
+}
+a {
+	color: #35526f;
+	font-weight: bold;
+	text-decoration: underline;
+}
+.news a {
+	text-decoration: none;
+}
+#about {
+	position: relative;
+	top: -9px;
+}
+#about a {
+	text-decoration: none;
+}
+.community a {
+	text-decoration: none;
+}
+ol {
+	padding-left: 45px;
+}
+ul.small {
+	list-style: none;
+	font-size: x-small;
+}
+ul.links {
+	list-style: none;
+	font-size: small;
+	padding: 0px 0px 20px 20px;
+}
+img {
+	border: none;
+}
+hr {
+	border: none;
+	border-top: 1px solid #46494d;
+}
+.greybox input, button, textarea, select {
+	background: #e1e3e6;
+	border: 1px solid #8faecd;
+}
+.box input, button {
+	padding: 2px;
+	background: #c1c3f6;
+	font-size: x-small;
+	border: 1px solid #8faecd;
+}
+button#f_trigger {
+	background: #e1e3e6;
+}
+/*
+ * Table stuff
+ */
+table.center {
+	margin-left: auto;
+	margin-right: auto;
+}
+table#releases {
+	font-size: small;
+	width: 100%;
+}
+table#releases td {
+	padding-right: 20px;
+}
+table#repolinks {
+	font-size: small;
+	width: 100%;
+}
+table#repolinks td {
+	text-align: right;
+}
+table#repolinks th {
+	text-align: left;
+}
+table#art {
+	text-align: center;
+	margin-left: auto;
+	margin-right: auto;
+}
+.devpic {
+	vertical-align: top;
+	padding-right: 15px;
+}
+table.deventry {
+	padding-bottom: 25px;
+}
+.deventry th {
+	text-align: left;
+	vertical-align: top;
+	white-space: nowrap;
+}
+.deventry td {
+	border-bottom: 1px solid black;
+	width: 100%;
+}
+table.results {
+	padding: 0px;
+	border-collapse: collapse;
+}
+.results th {
+	background: #e1e3e6;
+	border-bottom: 1px solid #46494d;
+	border-top: 1px solid #46494d;
+	text-align: left;
+	padding-top: 0px;
+	padding-bottom: 0px;
+	padding-right: 5px;
+}
+.results th>a {
+	text-decoration: none;
+	color: #46494d;
+}
+.results td {
+	padding-right: 5px;
+	vertical-align: top;
+	font-size: 0.8em;
+}
+.listing th {
+	background: #d1d3d6;
+	border-left: 1px solid #387cbf;
+	font-size: small;
+	vertical-align: top;
+	text-align: left;
+	padding: 2px;
+}
+.listing td {
+	font-size: small;
+	padding: 2px;
+}
+blockquote.code {
+	background: #c1c3f6;
+	border: 1px solid #8faecd;
+	margin-left: auto;
+	margin-right: auto;
+	white-space: nowrap;
+	padding: 5px;
+	font-family: Courier, Courier New, Monospace;
+}
+/*
+ * Wiki Styles
+ */
+h1.wiki {
+	border-bottom: 1px solid #46494d;
+}
+div.wikifoot_l {
+	font-size: x-small;
+	text-align: left;
+	padding-top: 25px;
+}
+div.wikifoot_r {
+	font-size: x-small;
+	text-align: right;
+	float: right;
+	padding-top: 25px;
+}
+.wikibody {
+	padding-top: 15px;
+}
+.wikibody ol {
+	padding-left: 28px;
+	padding-top: 0px;
+}
+.wikibody ul {
+	padding-left: 25px;
+	padding-top: 0px;
+}
+.wikibody dd {
+	padding-left: 30px;
+}
+.wikibody pre code {
+	background: #c1c3f6;
+	border: 1px solid #8faecd;
+	margin-left: auto;
+	margin-right: auto;
+	white-space: nowrap;
+	padding: 5px;
+	font-family: Courier, Courier New, Monospace;
+}
+.wikibody blockquote {
+	padding-left: 30px;
+}
+.wikibody td {
+	padding: 5px;
+	border: 1px solid black;
+}
+
+/* Used by Django's FormWrappers */
+textarea.vLargeTextField {
+	width: 450px;
+	height: 250px;
+}
+.pkgr2 {
+	background-color: #eee4cb;
+}
+#maincontent {
+    width: 100%;
+    text-align: left;
+}
+#maincontent > table {
+    width: 90%;
+    margin-left: 5%;
+    margin-right: 5%;
+}
+.pkgbox {
+    width: 90%;
+    margin-left: 5%;
+    margin-right: 5%;
+    background-color: #ffffff;
+    border-width: 2px;
+    border-color: #dddddd;
+    border-style: solid;
+    text-align: left;
+    padding: 3px;
+}
+.pkgboxtitle {
+    border-width: 2px;
+    border-style: solid;
+    border-color: #dddddd;
+    border-top-width: 1px;
+    border-top-color: #ffffff;
+    border-left-width: 1px;
+    border-left-color: #ffffff;
+    background-color: #f1f2f4;
+    text-align: right;
+    padding-top: 2px;
+    padding-bottom: 2px;
+    padding-right: 10px;
+}
+.pkgboxbody, .pkgboxbody-comment {
+    padding: 10px;
+}
+.pkgboxbody input {
+    margin-right: 10px;
+}
+
+.pkgboxbody-comment > table {
+    border-collapse: separate;
+    border-spacing: 0 15px;
+}
+
diff --git a/web/html/images/logo.png b/web/html/images/logo.png
new file mode 100644
index 0000000..b2b6d86
Binary files /dev/null and b/web/html/images/logo.png differ
diff --git a/web/html/images/tab.png b/web/html/images/tab.png
new file mode 100644
index 0000000..56d2e61
Binary files /dev/null and b/web/html/images/tab.png differ
diff --git a/web/html/images/title.png b/web/html/images/title.png
new file mode 100644
index 0000000..e16971a
Binary files /dev/null and b/web/html/images/title.png differ
diff --git a/web/html/images/title_back.png b/web/html/images/title_back.png
new file mode 100644
index 0000000..95c98d7
Binary files /dev/null and b/web/html/images/title_back.png differ
diff --git a/web/lang/en/pkgfuncs_po.inc b/web/lang/en/pkgfuncs_po.inc
index 220cdb3..dcd46f4 100644
--- a/web/lang/en/pkgfuncs_po.inc
+++ b/web/lang/en/pkgfuncs_po.inc
@@ -31,7 +31,7 @@ $_t["en"]["Error retrieving package details."] = "Error retrieving package detai
 
 $_t["en"]["Description"] = "Description";
 
-$_t["en"]["My Packages"] = "My Packages";
+$_t["en"]["My Packages"] = "My Pkgs";
 
 $_t["en"]["Keywords"] = "Keywords";
 
@@ -151,4 +151,4 @@ $_t["en"]["License"] = "License";
 
 $_t["en"]["unknown"] = "unknown";
 
-?>
\ No newline at end of file
+?>
diff --git a/web/lib/aur.inc b/web/lib/aur.inc
index cce5384..ce662f7 100644
--- a/web/lib/aur.inc
+++ b/web/lib/aur.inc
@@ -359,100 +359,77 @@ function html_header() {
 	global $_SERVER;
 	global $_COOKIE;
 	global $LANG;
-	print "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
-	print "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\"";
-	print " \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n";
-	print "<html xmlns=\"http://www.w3.org/1999/xhtml\"";
-	print " xml:lang=\"".$LANG."\" lang=\"".$LANG."\">\n";
-	print "<head>\n";
-	print "<title>AUR (".$LANG.")</title>\n";
-	print "<link rel='stylesheet' type='text/css' href='/css/fonts.css'/>\n";
-	print "<link rel='stylesheet' type='text/css' href='/css/containers.css'/>\n";
-	print "<link rel='shortcut icon' href='/images/favicon.ico'/>\n";
-	print "<link rel='alternate' type='application/rss+xml' title='Newest Packages RSS' href='/rss2.php' />\n";
-	print "<meta http-equiv=\"Content-Type\"";
-	print " content=\"text/html; charset=UTF-8\" />\n";
-	print "</head>\n";
-	print "<body bgcolor='white'>\n";
-	print "<table cellspacing='0' ";
-	print "style='background-color: #000; width: 100%;'>\n";
-	print "    <tr>\n";
-	print "        <td class='preHeader'><span class='preHeader'>";
-	print __("%s: %sAn ArchLinux project%s", array("AUR", "<a href=\"http://www.archlinux.org\">", "</a>"));
-	print "</span></td>\n";
-	print "    </tr>\n";
-	print "    <tr>\n";
-	print "        <td class='headerFill'>\n";
-	print "            <table width='100%'>\n";
-	print "            <tr>\n";
-	print "                <td class='headerDisplay'><a href='/index.php'>";
-
-	# XXX Can I scale a PNG like this?
-	#
-	print "<img src='/images/AUR-logo-80.png' width='85' height='45' ";
-	print "alt='AUR' border='0' /></a></td>\n";
-	print "                <td class='headerDisplay' valign='top' align='right'>";
-	print "<span class='preHeader'>ArchLinux User-community Repository</span><br />";
-
-	# XXX CSS help - a:link, a:visited, etc are defined, but I don't want to
-	# use the defaults.  Is this the way to override them?
-	#
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=en'><span class='sideBarSmallHeader'>English</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=pl'><span class='sideBarSmallHeader'>Polski</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=it'><span class='sideBarSmallHeader'>Italiano</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=ca'><span class='sideBarSmallHeader'>Català</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=pt'><span class='sideBarSmallHeader'>Português</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=es'><span class='sideBarSmallHeader'>Español</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=de'><span class='sideBarSmallHeader'>Deutsch</span></a> ";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=fr'><span class='sideBarSmallHeader'>Français</span></a>";
-	print "<a href='".$_SERVER["PHP_SELF"]."?setlang=ru'><span class='sideBarSmallHeader'>Русский</span></a>";
-	print "                </td>\n";
-	print "            </tr>\n";
-	print "            </table>\n";
-	print "        </td>\n";
-	print "    </tr>\n";
-
-	# Menu items
-	#
-	print "    <tr>\n";
-	print "        <td class='mainLinks' align='center'>";
-	print "              <span class='f2'><span class='black'>.:</span>";
-	print "            <a href='/index.php'>".__("Home")."</a> ";
-	print "              <span class='black'> - </span> ";
-	print "            <a href='/account.php'>".__("Accounts")."</a> ";
-	print "               <span class='black'> - </span> ";
-	print "            <a href='/packages.php'>".__("Packages")."</a> ";
+	echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
+	echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Strict//EN\"";
+	echo " \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd\">\n";
+	echo "<html xmlns=\"http://www.w3.org/1999/xhtml\"";
+	echo " xml:lang=\"".$LANG."\" lang=\"".$LANG."\">\n";
+	echo "<head>\n";
+	echo "<title>AUR (".$LANG.")</title>\n";
+	echo "<link rel='stylesheet' type='text/css' href='/css/fonts.css'/>\n";
+	echo "<link rel='stylesheet' type='text/css' href='/css/containers.css'/>\n";
+	echo "<link rel='stylesheet' type='text/css' href='/css/arch.css'/>\n";
+	echo "<link rel='shortcut icon' href='/images/favicon.ico'/>\n";
+	echo "<link rel='alternate' type='application/rss+xml' title='Newest Packages RSS' href='/rss2.php' />\n";
+	echo "<meta http-equiv=\"Content-Type\"";
+	echo " content=\"text/html; charset=UTF-8\" />\n";
+   echo "</head>\n";
+   echo "<body bgcolor='white'>\n";
+   echo <<<END1
+<div id="head_container">
+   <div id="title">
+      <div id="logo"><a href="/"><img src="/images/logo.png" alt="Arch Logo" /></a></div>
+      <div id="titleimg"><a href="/"><img src="/images/title.png" alt="Arch Linux" /></a></div>
+   </div>
+   <div style="float: right; color: #eeeeee; font-size: small">
+   </div>
+   <div id="main_nav">
+      <ul>
+         <li><a href="http://www.archlinux.org/download/">Get Arch</a></li>
+         <li class="selected"><a href="http://aur.archlinux.org">AUR</a></li>
+         <li><a href="http://bugs.archlinux.org">Bugs</a></li>
+         <li><a href="http://wiki.archlinux.org">Wiki</a></li>
+         <li><a href="http://bbs.archlinux.org">Forums</a></li>
+         <li><a href="http://www.archlinux.org">Home</a></li>
+      </ul>
+   </div>
+   <div id="sub_nav">
+      <ul>
+
+END1;
 	if ($_COOKIE["AURSID"]) {
-		# Only display these items if the visitor is logged in.  This should
-		# be a safe check because check_sid() has been called prior to
-		# html_header().
-		#
-		print "               <span class='black'> - </span> ";
-		print "            <a href='/pkgsubmit.php'>".__("Submit")."</a> ";
+      # This is a usability change, so we can go to My Packages page
+      # with just one click
+      # Added by: dsa <dsandrade@gmail.com>
+      echo '        <li><a href="/logout.php">'.__("Logout")."</a></li>\n";
+      echo '        <li><a href="/pkgsubmit.php">'.__("Submit")."</a></li>\n";
+      echo '        <li><a href="/packages.php?do_MyPackages=1">'.__("My Packages")."</a></li>\n";
 	}
-	print "               <span class='black'> - </span> ";
-	print "            <a href='http://bugs.archlinux.org/index.php?tasks=all&project=2'>".__("Bugs")."</a> ";
-	print "               <span class='black'> - </span> ";
-	print "            <a href='http://www.archlinux.org/mailman/listinfo/tur-users'>".__("Discussion")."</a> ";
-	if ($_COOKIE["AURSID"]) {
-        # This is a usability change, so we can go to My Packages page
-        # with just one click
-        # Added by: dsa <dsandrade@gmail.com>
-        print "               <span class='black'> - </span> ";
-        print "            <a href='/packages.php?do_MyPackages=1'>".__("My Packages")."</a> ";        
-    
-		print "               <span class='black'> - </span> ";
-		print "            <a href='/logout.php'>".__("Logout")."</a> ";
-	}
-	print "                <span class='black'>:.</span></span>";
-	print "        </td>";
-	print "    </tr>";
-	print "    <tr>\n";
-	print "        <td class='contentDisplay'>\n";
-	print "        &nbsp;<br />\n";
-	print "<!-- Start of main content -->\n\n";
-
-	return;
+   echo '        <li><a href="http://www.archlinux.org/mailman/listinfo/tur-users/">'.__("Discussion")."</a></li>\n";
+   echo '        <li><a href="http://bugs.archlinux.org/index.php?tasks=all&project=2">'.__("Bugs")."</a></li>\n";
+   echo '        <li><a href="/packages.php">'.__("Packages")."</a></li>\n";
+   echo '        <li><a href="/account.php">'.__("Accounts")."</a></li>\n";
+   echo '        <li><a href="/index.php">AUR-'.__("Home")."</a></li>\n";
+   echo "     </ul>\n";
+   echo "   </div>\n";
+   echo '   <div id="lang_sub">'."\n";
+   echo "      <ul>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=ru' title='Русский'>RU</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=fr' title='Français'>FR</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=de' title='Deutsch'>DE</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=es' title='Español'>ES</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=pt' title='Português'>PT</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=ca' title='Català'>CA</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=it' title='Italiano'>IT</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=pl' title='Polski'>PL</a></li>\n";
+   echo "         <li><a href='".$_SERVER["PHP_SELF"]."?setlang=en' title='English'>EN</a></li>\n";
+   echo "         <li>Lang: </li>\n";
+   echo "      </ul>\n";
+   echo "   </div>\n";
+   echo "</div>\n";
+   echo "<div id=\"maincontent\">\n";
+   echo "<!-- Start of main content -->\n\n";
+   return;
 }
 
 
@@ -461,9 +438,6 @@ function html_header() {
 function html_footer($ver="") {
 	print "\n\n<!-- End of main content -->\n";
 	print "        <br />\n";
-	print "        </td>\n";
-	print "    </tr>\n";
-	print "</table>\n";
 	if ($ver) {
 		print "<p>\n";
 		print "<table border='0' cellpadding='0' cellspacing='0' width='97%'>\n";
@@ -471,7 +445,7 @@ function html_footer($ver="") {
 		print "</table>\n";
 		print "</p>\n";
 	}
-	print "<br />\n";
+	print "</div>\n";
 	print "</body>\n</html>";
 	return;
 }
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index b9ad0d4..de1dc5f 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -268,36 +268,19 @@ function package_details($id=0, $SID="") {
 		} else {
 
 			# print out package details
-			#
-			print "<br />\n";
-			print "<center>\n";
-			print "<table cellspacing='3' class='boxSoft'>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoftTitle' align='right'>";
-			print "<span class='f3'>".__("Package Details")."</span></td>\n";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft'>\n";
-			print "<center>\n";
-			print "<table>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f2'>";
-			print $row["Name"] . " " . $row["Version"]."</span></td>\n";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f3'>";
-			print "<a href='".$row["URL"]."'>".$row["URL"]."</a></span></td>\n";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f3'>".$row["Description"];
-			print "</a></span></td>\n";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='30'></td>";
-			print "</tr>\n";
-
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f3'>";
+            #
+            echo "<div class=\"pkgbox\">\n";
+            echo "  <div class=\"pkgboxtitle\"><span class=\"f3\">".__("Package Details")."</span></div>\n";
+            echo "  <div class=\"pkgboxbody\">\n";
+			echo "    <table>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f2'>";
+			echo $row["Name"] . " " . $row["Version"]."</span></td></tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f3'>";
+			echo "<a href='".$row["URL"]."'>".$row["URL"]."</a></span></td></tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f3'>".$row["Description"];
+			echo "</a></span></td></tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='30'></td></tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f3'>";
 			if ($row["Location"] == "unsupported" and ( 
 					uid_from_sid($SID) == $row["MaintainerUID"] or
 					(account_from_sid($SID) == "Developer" or
@@ -309,87 +292,65 @@ function package_details($id=0, $SID="") {
 			} else {
 				$edit_cat = $row["Category"];
 			}
-			print $row["Location"]." :: ".$edit_cat."</span></td>";
-
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f3'>".__("Maintainer").": ";
+			echo $row["Location"]." :: ".$edit_cat."</span></td></tr>\n";
+			echo "        <tr><td class='boxSoft' colspan='2'><span class='f3'>".__("Maintainer").": ";
 			if ($row["MaintainerUID"]) {
 				$maintainer = username_from_id($row["MaintainerUID"]);
 				if ($SID) {
-					print "<a href='/account.php?Action=AccountInfo&ID=";
-					print $row["MaintainerUID"] . "'>";
-					print $maintainer . "</a></span></td>";
+					echo "<a href='/account.php?Action=AccountInfo&ID=";
+					echo $row["MaintainerUID"] . "'>";
+					echo $maintainer . "</a></span></td>";
 				} else {
-					print $maintainer . "</span></td>";
+					echo $maintainer . "</span></td>";
 				}
 			} else {
 				$maintainer = "None";
-				print $maintainer . "</span></td>";
+				echo $maintainer . "</span></td>";
 			}
-			print "</tr>\n";
-			
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f3'>".__("Votes").": ";
-			print $row["NumVotes"] . "</span></td>";
-			print "</tr>\n";
+			echo "      </tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f3'>".__("Votes").": ";
+			echo $row["NumVotes"] . "</span></td></tr>\n";
             
             # In case of wanting to put a custom message
             $msg = __("unknown");
             $license = $row["License"] == "" ? $msg : $row["License"];
             
-            print "<tr>\n";
-            print "  <td class='boxSoft' colspan='2'><br><span class='f3'>".__("License").": ".$license;
-            print "</a></span></td>\n";
-            print "</tr>\n";            
-
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='15'></td>";
-			print "</tr>\n";
+            echo "      <tr><td class='boxSoft' colspan='2'><br><span class='f3'>".__("License").": ".$license;
+            echo "</a></span></td></tr>\n";            
+			echo "      <tr><td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='15'></td></tr>\n";
 
 			# Print the timestamps for last updates
 			$updated_time = ($row["ModifiedTS"] == 0) ? "(unknown)" : gmdate("r", intval($row["ModifiedTS"]));
 			$submitted_time = ($row["SubmittedTS"] == 0) ? "(unknown)" : gmdate("r", intval($row["SubmittedTS"]));
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'>";
-			print "<span class='f3'>";
-			print __("Last Updated").": ".$updated_time."<br>";
-			print __("First Submitted").": ".$submitted_time;
-			print "</span>";
-			print "</td>\n";
-			print "</tr>\n";
-
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='15'></td>";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><span class='f3'>";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f3'>";
+			echo __("Last Updated").": ".$updated_time."<br>";
+			echo __("First Submitted").": ".$submitted_time."</span></td></tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='15'></td></tr>\n";
+			echo "      <tr><td class='boxSoft' colspan='2'><span class='f3'>";
 			if ($row["LocationID"] == 2) {
 				global $URL_DIR;
 				$urlpath = $URL_DIR.$row["Name"]."/".$row["Name"];
-				print "<a href='$urlpath.tar.gz'>".__("Tarball")."</a> :: <a href='$urlpath'>".__("Files")."</a> :: <a href='$urlpath/PKGBUILD'>PKGBUILD</a></span></td>";
+				echo "<a href='$urlpath.tar.gz'>".__("Tarball")."</a> :: <a href='$urlpath'>".__("Files")."</a> :: <a href='$urlpath/PKGBUILD'>PKGBUILD</a></span></td>";
 			} elseif ($row["LocationID"] == 3) {
-			  print "<a href='http://cvs.archlinux.org/cgi-bin/viewcvs.cgi/" . $row["Category"] . "/" . $row["Name"] . "/?cvsroot=AUR&only_with_tag=CURRENT'>CVS</td>";
+			  echo "<a href='http://cvs.archlinux.org/cgi-bin/viewcvs.cgi/" . $row["Category"] . "/" . $row["Name"] . "/?cvsroot=AUR&only_with_tag=CURRENT'>CVS</td>";
 			}
-			print "</tr>\n";
+			echo "</tr>\n";
 			if ($row["LocationID"] == 2) {
-			  print "<tr>\n";
-			  print "  <td colspan='2'>";
+			  echo "      <tr><td colspan='2'>";
 			  if ($row["Safe"]) {
-			    print "<span class='f7'>".__("The above files have been verified (by %s) and are safe to use.", array(username_from_id($row["VerifiedBy"])))."</span></td>";
+			    echo "<span class='f7'>".__("The above files have been verified (by %s) and are safe to use.", array(username_from_id($row["VerifiedBy"])))."</span></td>";
 			  } else {
-			    print "<span class='f6'>".__("Be careful! The above files may contain malicious code that can damage your system.")."</span></td>";
-			  }
+			    echo "<span class='f6'>".__("Be careful! The above files may contain malicious code that can damage your system.")."</span></td>";
+              }
+              echo "      </tr>\n";
 			}
-			print "<tr>\n";
-			print "  <td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='30'></td>";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td valign='top' style='padding-right: 10'>";
-			print "<table class='boxSoft' style='width: 200px'>";
-			print "<tr><td class='boxSoftTitle'><span class='f3'>";
-			print __("Dependencies")."</span></td></tr>\n";
-			print "<tr><td class='boxSoft'>";
+			echo "      <tr><td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='30'></td></tr>\n";
+            echo "      <tr>\n";
+            echo "        <td valign='top' style='padding-right: 10'>\n";
+			echo "          <table class='boxSoft' style='width: 200px'>\n";
+			echo "            <tr><td class='boxSoftTitle'><span class='f3'>";
+			echo __("Dependencies")."</span></td></tr>\n";
+			echo "            <tr><td class='boxSoft'>";
 			$deps = package_dependencies($row["ID"]); # $deps[0] = array('id','name', 'dummy');
 			while (list($k, $darr) = each($deps)) {
 				$url = "<a href='/packages.php?do_Details=1&ID=".$darr[0];
@@ -404,196 +365,179 @@ function package_details($id=0, $SID="") {
                                                
                 // $darr[3] is the DepCondition                                               
                                                
-				if ($darr[2] == 0) print $url."'>".$darr[1].$darr[3]."</a><br />\n";
-				else print "<a href='#'>".$darr[1].$darr[3]."</a><br />\n";
+				if ($darr[2] == 0) echo $url."'>".$darr[1].$darr[3]."</a><br />\n";
+				else echo "<a href='#'>".$darr[1].$darr[3]."</a><br />\n";
 			}
-			print "</td></tr>\n";
-			print "</table></td>";
-
-			print "  <td valign='top'>";
-			print "<table class='boxSoft' style='width: 200px'>";
-			print "<tr><td class='boxSoftTitle'><span class='f3'>";
-			print __("Sources")."</span></td></tr>\n";
-			print "<tr><td class='boxSoft'>";
+            echo "</td></tr>\n";
+            echo "          </table>\n";
+            echo "        </td>\n";
+			echo "        <td valign='top'>\n";
+			echo "          <table class='boxSoft' style='width: 200px'>\n";
+			echo "            <tr><td class='boxSoftTitle'><span class='f3'>";
+			echo __("Sources")."</span></td></tr>\n";
+			echo "            <tr><td class='boxSoft'>";
 			$sources = package_sources($row["ID"]); # $sources[0] = 'src';
 			while (list($k, $src) = each($sources)) {
 				$parsed_url = parse_url($src);
 				if ($parsed_url['scheme'])
 				{
 					//It is an external source
-					print "<a href='".$src."'>".$src."</a><br />\n";
+					echo "<a href='".$src."'>".$src."</a><br />\n";
 				}
 				else 
 				{
 					//It is presumably an internal source
 					if ($row["LocationID"] == 2) {
-						print "<a href='".dirname($row['URLPath'])."/".$row['Name'];
-						print "/".$src."'>".$src."</a><br />\n";
+						echo "<a href='".dirname($row['URLPath'])."/".$row['Name'];
+						echo "/".$src."'>".$src."</a><br />\n";
 					} elseif ($row["LocationID"] == 3) {
-						print "<a href='http://cvs.archlinux.org/cgi-bin/viewcvs.cgi/*checkout*/".$row["Category"]."/".$row["Name"]."/".$src."/?rev=HEAD&cvsroot=AUR&only_with_tag=CURRENT'>";
-						print $src."</a><br />\n";
+						echo "<a href='http://cvs.archlinux.org/cgi-bin/viewcvs.cgi/*checkout*/".$row["Category"]."/".$row["Name"]."/".$src."/?rev=HEAD&cvsroot=AUR&only_with_tag=CURRENT'>";
+						echo $src."</a><br />\n";
 					}
 				}
 			}
-			print "</td></tr>\n";
-			print "</table></td>";
-			print "</tr>\n";
-			print "<tr>\n";
-			print "  <td colspan='2'><img src='/images/pad.gif' height='2'>";
-			print "</td></tr>\n";
-			print "</table>\n";
-			print "</center>\n";
-			print "  </td>\n";
-			print "</tr>\n";
+			echo "</td></tr>\n";
+            echo "          </table>\n";
+            echo "        </td>\n";
+			echo "      </tr>\n";
+			echo "    </table>\n";
+            echo "  </div>\n";
+            echo "</div>\n\n";
+            echo "<br />\n\n";
 
-			print "</table><br />\n";
 
 			# Actions Bar
 			#
 			if ($SID) {
-				print "<table cellspacing='3' class='boxSoft'>\n";
-				print "<tr><td class='boxSoftTitle' align='right'><span class='f3'>".__("Actions")."</span></td></tr>\n";
-				print "<tr>\n";
-				print "<td class='boxSoft'><form action='/packages.php' method='post'>\n";
-				print "<input type='hidden' name='IDs[".$row["ID"]."]' value='1'>\n";
-				print "<input type='hidden' name='ID' value='".$row["ID"]."'>\n";
+                echo "<div class=\"pkgbox\">\n";
+                echo "  <div class=\"pkgboxtitle\"><span class=\"f3\">".__("Actions")."</span></div>\n";
+                echo "  <div class=\"pkgboxbody\">\n";
+                echo "    <form action='/packages.php' method='post'>\n";
+				echo "      <input type='hidden' name='IDs[".$row["ID"]."]' value='1'>\n";
+				echo "      <input type='hidden' name='ID' value='".$row["ID"]."'>\n";
 				# Voting Button
 				#
 				$q = "SELECT * FROM PackageVotes WHERE UsersID = ".uid_from_sid($SID);
 				$q.= " AND PackageID = ".$row["ID"];
 				if (!mysql_num_rows(db_query($q, $dbh))) {
-					print "<input type='submit' class='button' name='do_Vote'";
-					print " value='".__("Vote")."'>";
+					echo "      <input type='submit' class='button' name='do_Vote'";
+					echo " value='".__("Vote")."'>";
 				} else {
-					print "<input type='submit' class='button' name='do_UnVote'";
-					print " value='".__("Un-Vote")."'>";
+					echo "<input type='submit' class='button' name='do_UnVote'";
+					echo " value='".__("Un-Vote")."'>";
 				}
 				# Comment Nofify Button
 				#
 				$q = "SELECT * FROM CommentNotify WHERE UserID = ".uid_from_sid($SID);
 				$q.= " AND PkgID = ".$row["ID"];
 				if (!mysql_num_rows(db_query($q, $dbh))) {
-					print "<input type='submit' class='button' name='do_Notify'";
-					print " value='".__("Notify")."' title='".__("New Comment Notification")."'>";
+					echo "<input type='submit' class='button' name='do_Notify'";
+					echo " value='".__("Notify")."' title='".__("New Comment Notification")."'>";
 				} else {
-					print "<input type='submit' class='button' name='do_UnNotify'";
-					print " value='".__("UnNotify")."' title='".__("No New Comment Notification")."'>";
+					echo "<input type='submit' class='button' name='do_UnNotify'";
+					echo " value='".__("UnNotify")."' title='".__("No New Comment Notification")."'>";
 				}
 				# Flag Safe Button
 				#
-				if ($row["LocationID"] == 2 && (account_from_sid($SID) == "Trusted User" || account_from_sid($SID) == "Developer"))
-				{
-					if ($row["Safe"] == 0)
-					{
-						print "<input type='submit' class='button' name='do_FlagSafe'";
-						print " value='".__("Flag Safe")."' title='".__("Flag Package Safe To Use")."'>";
-					}
-					else
-					{
-						print "<input type='submit' class='button' name='do_UnFlagSafe'";
-						print " value='".__("Unflag Safe")."' title='".__("Unflag Package Safe To Use")."'>";
+				if ($row["LocationID"] == 2 && (account_from_sid($SID) == "Trusted User" || account_from_sid($SID) == "Developer")) {
+					if ($row["Safe"] == 0) {
+						echo "<input type='submit' class='button' name='do_FlagSafe'";
+						echo " value='".__("Flag Safe")."' title='".__("Flag Package Safe To Use")."'>";
+					} else {
+						echo "<input type='submit' class='button' name='do_UnFlagSafe'";
+						echo " value='".__("Unflag Safe")."' title='".__("Unflag Package Safe To Use")."'>";
 					}
+                }
+
+                if ($row["OutOfDate"] == 0) {
+                    echo "<input type='submit' class='button' name='do_Flag'";
+                    echo " value='".__("Flag Out-of-date")."'>\n";
+                } else {
+                    echo "<input type='submit' class='button' name='do_UnFlag'";
+                    echo " value='".__("Unflag Out-of-date")."'>\n";
 				}
-					if ($row["OutOfDate"] == 0)
-					{
-						print "<input type='submit' class='button' name='do_Flag'";
-						print "	value='".__("Flag Out-of-date")."'>\n";
-					}
-					else
-					{
-						print "<input type='submit' class='button' name='do_UnFlag'";
-						print "	value='".__("Unflag Out-of-date")."'>\n";
-					}
 					
-					if ($row["AURMaintainerUID"] == 0 && $row["MaintainerUID"] == 0)
-					{
-						print "<input type='submit' class='button' name='do_Adopt'";
-						print "	value='".__("Adopt Packages")."'>\n";
-					}
+                if ($row["AURMaintainerUID"] == 0 && $row["MaintainerUID"] == 0) {
+                    echo "<input type='submit' class='button' name='do_Adopt'";
+                    echo " value='".__("Adopt Packages")."'>\n";
+                }
 					
-					if ($row["MaintainerUID"] == uid_from_sid($SID))
-					{
-						print "<input type='submit' class='button' name='do_Disown'";
-						print "	value='".__("Disown Packages")."'>\n";
-					}	
+				if ($row["MaintainerUID"] == uid_from_sid($SID)) {
+					echo "<input type='submit' class='button' name='do_Disown'";
+					echo " value='".__("Disown Packages")."'>\n";
+				}	
 					
-					if ($row["MaintainerUID"] == uid_from_sid($SID) ||
-					    account_from_sid($SID) == "Trusted User" ||
-					    account_from_sid($SID) == "Developer")
-					{
-						print "<input type='submit' class='button' name='do_Delete'";
-						print "	value='".__("Delete Packages")."'>\n";
-					}
+				if ($row["MaintainerUID"] == uid_from_sid($SID) ||
+				    account_from_sid($SID) == "Trusted User" ||
+				    account_from_sid($SID) == "Developer") {
+					echo "<input type='submit' class='button' name='do_Delete'";
+					echo " value='".__("Delete Packages")."'>\n";
+				}
 						
-				print "</form></td></tr>\n";				
-				print "</table><br />\n";
+                echo "    </form>\n";
+                echo "  </div>\n";
+                echo "</div>\n";
+                echo "\n<br />\n\n";
 			}
 			
 			# Comments
 			#
-			print "<table cellspacing='3' class='boxSoft'>\n";
-			print "<tr><td class='boxSoftTitle' align='right'><span class='f3'>".__("Comments")."</span></td></tr>\n";
-			print "<tr>\n";
-			print "<td class='boxSoft'>";	
-
-			print "<table width='100%'>\n";
+            echo "<div class=\"pkgbox\">\n";
+            echo "  <div class=\"pkgboxtitle\"><span class=\"f3\">".__("Comments")."</span></div>\n";
+            echo "  <div class=\"pkgboxbody-comment\">\n";
+			echo "    <table width='100%'>\n";
 			$comments = package_comments($row["ID"]);
 			if (!empty($comments)) {
 				while (list($indx, $carr) = each($comments)) {
-					print "<tr>\n";
-					print "  <td class='boxSoft' colspan='2'>";
-					print "<img src='/images/pad.gif' height='2'></td></tr>\n";
-
-					print "<tr>\n";
-					print "  <td valign='top' style='padding-right: 10' colspan='2'>";
-					print "<table class='boxSoft' width='100%'>";
-					print "<tr><td class='boxSoftTitle'><span class='f3'>";
+
+					echo "      <tr>\n";
+					echo "        <td valign='top' style='padding-right: 10' colspan='2'>\n";
+					echo "          <table class='boxSoft' width='100%'>\n";
+                    echo "            <tr>\n";
+                    echo "              <td class='boxSoftTitle'><span class='f3'>";
 					if (canDeleteComment($carr["ID"], account_from_sid($SID), $SID)) {
 						$durl = "<a href='/pkgedit.php?del_Comment=1";
 						$durl.= "&comment_id=".$carr["ID"]."&ID=".$row["ID"];
 						$durl.= "'><img src='/images/x.png' border='0'";
 						$durl.= " alt=\"".__("Delete comment")."\"></a>";
 
-					  print $durl . "&nbsp;&nbsp;";
+					  echo $durl . "&nbsp;&nbsp;";
 					}
 					if ($SID) {
-						print __("Comment by: %h%s%h on %h%s%h",
+						echo __("Comment by: %h%s%h on %h%s%h",
 							array("<a href='/account.php?Action=AccountInfo&ID=".$carr["UsersID"]."'><b>",$carr["UserName"],"</b></a>",
 							      "<i>",gmdate("Ymd [H:i:s]",$carr["CommentTS"]),"</i>"));
 					} else {
-						print __("Comment by: %h%s%h on %h%s%h",
+						echo __("Comment by: %h%s%h on %h%s%h",
 							array("<b>",$carr["UserName"],"</b>",
 							      "<i>",gmdate("Ymd [H:i:s]",$carr["CommentTS"]),"</i>"));
 					}
-					print "</span>";
-					print "<tr><td class='boxSoft'>";
-					print "<code>\n";
-					print str_replace("\n", "<br>", str_replace('"',"&quot;", htmlspecialchars(strip_tags(stripslashes($carr["Comments"])))));
-					print "</code>\n";
-					print "</td></tr>\n";
-					print "</table>\n";
-					print "  </td>\n";
-					print "</tr>\n";
+                    echo "</span></td>\n";
+                    echo "            </tr>\n";
+                    echo "            <tr>\n";
+                    echo "              <td class='boxSoft'>";
+					echo "<code>\n";
+					echo str_replace("\n", "<br>", str_replace('"',"&quot;", htmlspecialchars(strip_tags(stripslashes($carr["Comments"])))));
+                    echo "</code></td>\n";
+                    echo "            </tr>\n";
+					echo "          </table>\n";
+					echo "        </td>\n";
+					echo "      </tr>\n";
 				}
 			}
 
-			print "<tr>\n";
-			print "  <td colspan='2'><img src='/images/pad.gif' height='2'>";
-			print "</td></tr>\n";
-			print "<tr>\n";
-			print "  <td colspan='2'>";
-			print "<form action='/pkgedit.php' method='post'>\n";
-			print "<input type='hidden' name='ID' value='".$row["ID"]."'>\n";
-			print "<input type='submit' class='button' name='add_Comment' value=\"";
-			print __("Add Comment")."\">";
-			print "</form>\n";
-			print "  </td>";
-			print "</tr>\n";
-
-			print "</table>\n";
-
-			
-			print "</td></tr></table>\n";
+			echo "      <tr>\n";
+			echo "        <td colspan='2'>\n";
+			echo "          <form action='/pkgedit.php' method='post'>\n";
+			echo "            <input type='hidden' name='ID' value='".$row["ID"]."'>\n";
+			echo "            <input type='submit' class='button' name='add_Comment' value=\"";
+			echo __("Add Comment")."\">\n";
+			echo "          </form>\n";
+			echo "        </td>\n";
+			echo "      </tr>\n";
+			echo "    </table>\n";
+            echo "  </div>\n";
+            echo "</div>\n";
 			
 		}
 	}
-- 
cgit v1.2.3-70-g09d2


From 6a39da70fb9cfd6050deb1016fe0183157d8fb46 Mon Sep 17 00:00:00 2001
From: tardo <tardo@nagi-fanboi.net>
Date: Sat, 22 Sep 2007 17:01:40 -0400
Subject: Incomplete comment patch. FS 7968, 5128, 7383.

Properly parse comments from database.
Thanks to Thralas for input.

Signed-off-by: tardo <tardo@nagi-fanboi.net>
---
 web/lib/pkgfuncs.inc | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index b9ad0d4..cd339c1 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -568,7 +568,7 @@ function package_details($id=0, $SID="") {
 					print "</span>";
 					print "<tr><td class='boxSoft'>";
 					print "<code>\n";
-					print str_replace("\n", "<br>", str_replace('"',"&quot;", htmlspecialchars(strip_tags(stripslashes($carr["Comments"])))));
+					print nl2br(htmlspecialchars($carr["Comments"]));
 					print "</code>\n";
 					print "</td></tr>\n";
 					print "</table>\n";
-- 
cgit v1.2.3-70-g09d2


From 61ddbc18e7836a3b2e334b23ea637a2a0eea9006 Mon Sep 17 00:00:00 2001
From: tardo <tardo@nagi-fanboi.net>
Date: Sat, 22 Sep 2007 17:09:26 -0400
Subject: Reverse dependency lookup. FS 4556, 5269.

Ugly hack, could use beautification.
Also includes english translation addition.
If url sources are too long, page could ugly...

Signed-off-by: tardo <tardo@nagi-fanboi.net>
---
 web/lang/en/pkgfuncs_po.inc |  4 +++-
 web/lib/pkgfuncs.inc        | 45 +++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 48 insertions(+), 1 deletion(-)

diff --git a/web/lang/en/pkgfuncs_po.inc b/web/lang/en/pkgfuncs_po.inc
index 220cdb3..b6a704b 100644
--- a/web/lang/en/pkgfuncs_po.inc
+++ b/web/lang/en/pkgfuncs_po.inc
@@ -151,4 +151,6 @@ $_t["en"]["License"] = "License";
 
 $_t["en"]["unknown"] = "unknown";
 
-?>
\ No newline at end of file
+$_t["en"]["Required by"] = "Required by";
+
+?>
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index cd339c1..395200b 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -152,6 +152,25 @@ function package_dependencies($pkgid=0) {
 	return $deps;
 }
 
+# reverse deps by tardo
+#
+function package_required($pkgid=0) {
+	$deps = array();
+	if ($pkgid) {
+		$dbh = db_connect();
+		$q = "SELECT PackageID, Name, DummyPkg from PackageDepends, Packages ";
+		$q.= "WHERE PackageDepends.PackageID = Packages.ID ";
+		$q.= "AND PackageDepends.DepPkgID = ";
+		$q.= mysql_real_escape_string($pkgid);
+		$result = db_query($q, $dbh);
+		if (!$result) {return array();}
+		while ($row = mysql_fetch_row($result)) {
+			$deps[] = $row;
+		}
+	}
+	return $deps;
+}
+
 # create a dummy package and return it's Packages.ID  if it already exists,
 # return the existing ID
 #
@@ -402,6 +421,32 @@ function package_details($id=0, $SID="") {
 				}
 				reset($pkgsearch_vars);
                                                
+                // $darr[3] is the DepCondition                                               
+                                               
+				if ($darr[2] == 0) print $url."'>".$darr[1].$darr[3]."</a><br />\n";
+				else print "<a href='#'>".$darr[1].$darr[3]."</a><br />\n";
+			}
+			print "</td></tr>\n";
+			print "</table></td>";
+
+			# reverse-deps by tardo - could use some beautification
+			print "  <td valign='top'>";
+			print "<table class='boxSoft' style='width: 200px'>";
+			print "<tr><td class='boxSoftTitle'><span class='f3'>";
+			print __("Required by")."</span></td></tr>\n";
+			print "<tr><td class='boxSoft'>";
+			$deps = package_required($row["ID"]);
+			while (list($k, $darr) = each($deps)) {
+				$url = "<a href='/packages.php?do_Details=1&ID=".$darr[0];
+				while(list($k, $var) = each($pkgsearch_vars)) {
+					if (($var == "do_MyPackages" || $var == "do_Orphans") && $_REQUEST[$var]) {
+						$url .= "&".$var."=1";
+					} else {
+						$url .= "&".$var."=".rawurlencode(stripslashes($_REQUEST[$var]));
+					}
+				}
+				reset($pkgsearch_vars);
+                                               
                 // $darr[3] is the DepCondition                                               
                                                
 				if ($darr[2] == 0) print $url."'>".$darr[1].$darr[3]."</a><br />\n";
-- 
cgit v1.2.3-70-g09d2


From adafc112f6f14a5ab7249a622da5d74a8f52a3ed Mon Sep 17 00:00:00 2001
From: tardo <tardo@nagi-fanboi.net>
Date: Sat, 22 Sep 2007 17:14:14 -0400
Subject: Add link to TU's homepage in "Flagged safe by". FS 4138.

Simple feature request. Not sure what purpose it serves.

Signed-off-by: tardo <tardo@nagi-fanboi.net>
---
 web/lang/en/pkgfuncs_po.inc | 2 ++
 web/lib/pkgfuncs.inc        | 2 +-
 2 files changed, 3 insertions(+), 1 deletion(-)

diff --git a/web/lang/en/pkgfuncs_po.inc b/web/lang/en/pkgfuncs_po.inc
index b6a704b..4ab3cd6 100644
--- a/web/lang/en/pkgfuncs_po.inc
+++ b/web/lang/en/pkgfuncs_po.inc
@@ -153,4 +153,6 @@ $_t["en"]["unknown"] = "unknown";
 
 $_t["en"]["Required by"] = "Required by";
 
+$_t["en"]["The above files have been verified (by %h%s%h) and are safe to use."] = "The above files have been verified (by %h%s%h) and are safe to use.";
+
 ?>
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 395200b..3bbfcb7 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -395,7 +395,7 @@ function package_details($id=0, $SID="") {
 			  print "<tr>\n";
 			  print "  <td colspan='2'>";
 			  if ($row["Safe"]) {
-			    print "<span class='f7'>".__("The above files have been verified (by %s) and are safe to use.", array(username_from_id($row["VerifiedBy"])))."</span></td>";
+			    print "<span class='f7'>".__("The above files have been verified (by %h%s%h) and are safe to use.", array("<a href='/account.php?Action=AccountInfo&ID=".$row["VerifiedBy"]."'>", username_from_id($row["VerifiedBy"]), "</a>"))."</span></td>";
 			  } else {
 			    print "<span class='f6'>".__("Be careful! The above files may contain malicious code that can damage your system.")."</span></td>";
 			  }
-- 
cgit v1.2.3-70-g09d2


From 4548b0d08b592180bd4cd66ec127d0069f27c792 Mon Sep 17 00:00:00 2001
From: tardo <tardo@nagi-fanboi.net>
Date: Sat, 22 Sep 2007 18:08:14 -0400
Subject: Notify by email when package is flagged out of date. FS 3231.

In addition to the above, it does not notify if the user that flags package out of date is the same as the owner of the package.
The body of the email could use work as well I suppose.

Signed-off-by: tardo <tardo@nagi-fanboi.net>
---
 web/html/packages.php | 21 +++++++++++++++++++++
 1 file changed, 21 insertions(+)

diff --git a/web/html/packages.php b/web/html/packages.php
index 4cb8c47..0559060 100644
--- a/web/html/packages.php
+++ b/web/html/packages.php
@@ -66,6 +66,27 @@ if (isset($_REQUEST["do_Flag"])) {
 			print "<p>\n";
 			print __("The selected packages have been flagged out-of-date.");
 			print "</p>\n";
+			
+			# notification by tardo.
+			$f_name = username_from_sid($_COOKIE['AURSID']);
+			$f_email = email_from_sid($_COOKIE['AURSID']);
+			$f_uid = uid_from_sid($_COOKIE['AURSID']);
+			$q = "SELECT Packages.Name, Users.Email, Packages.ID ";
+			$q.= "FROM Packages, Users ";
+			$q.= "WHERE Packages.ID IN (" . $flag .") ";
+			$q.= "AND Users.ID = Packages.MaintainerUID ";
+			$q.= "AND Users.ID != " . $f_uid;
+			$result = db_query($q, $dbh);
+			if (mysql_num_rows($result)) {
+				while ($row = mysql_fetch_assoc($result)) {
+					# construct email
+					$body = "Your package " . $row['Name'] . " has been flagged out of date by " . $f_name . ". You may view your package at:\nhttp://aur.archlinux.org/packages.php?do_Details=1&ID=" . $row['ID'];
+					$body = wordwrap($body, 70);
+					$headers = "To: ".$row['Email']."\nReply-to: nobody@archlinux.org\nFrom:aur-notify@archlinux.org\nX-Mailer: PHP\nX-MimeOLE: Produced By AUR\n";
+					@mail(' ', "AUR Out-of-date Notification for ".$row['Name'], $body, $headers);
+				}
+			}
+			
 		} else {
 			print "<p>\n";
 			print __("You did not select any packages to flag.");
-- 
cgit v1.2.3-70-g09d2


From 9cba3937d0847d1065b3da7322ffe7ea22108319 Mon Sep 17 00:00:00 2001
From: tardo <tardo@nagi-fanboi.net>
Date: Sat, 22 Sep 2007 18:30:28 -0400
Subject: Cosmetic: Show flagged out of date on package page.

Add a simple warning under "Tarball :: Files :: PKGBUILD" if package is out of date.

Signed-off-by: tardo <tardo@nagi-fanboi.net>
---
 web/lang/en/pkgfuncs_po.inc | 2 ++
 web/lib/pkgfuncs.inc        | 4 ++++
 2 files changed, 6 insertions(+)

diff --git a/web/lang/en/pkgfuncs_po.inc b/web/lang/en/pkgfuncs_po.inc
index 4ab3cd6..1395062 100644
--- a/web/lang/en/pkgfuncs_po.inc
+++ b/web/lang/en/pkgfuncs_po.inc
@@ -155,4 +155,6 @@ $_t["en"]["Required by"] = "Required by";
 
 $_t["en"]["The above files have been verified (by %h%s%h) and are safe to use."] = "The above files have been verified (by %h%s%h) and are safe to use.";
 
+$_t["en"]["This package has been flagged out of date."] = "This package has been flagged out of date.";
+
 ?>
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index 3bbfcb7..5cab842 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -400,6 +400,10 @@ function package_details($id=0, $SID="") {
 			    print "<span class='f6'>".__("Be careful! The above files may contain malicious code that can damage your system.")."</span></td>";
 			  }
 			}
+			if ($row["OutOfDate"] == 1) {
+				print "\n<tr><td colspan='2'>";
+				print "<span class='f6'>".__("This package has been flagged out of date.")."</span></td></tr>";
+			}
 			print "<tr>\n";
 			print "  <td class='boxSoft' colspan='2'><img src='/images/pad.gif' height='30'></td>";
 			print "</tr>\n";
-- 
cgit v1.2.3-70-g09d2


From aebdd21b58046f647c7c500dde5152ba774303ab Mon Sep 17 00:00:00 2001
From: eliott <eliott@cactuswax.net>
Date: Mon, 24 Sep 2007 07:57:35 -0700
Subject: More changes to page styles.

---
 web/html/account.php   |  7 +++++++
 web/html/css/arch.css  | 20 +++++++++++++++-----
 web/html/index.php     | 17 ++++++++---------
 web/html/pkgsubmit.php |  8 +++++---
 web/lib/pkgfuncs.inc   | 18 +++++++++---------
 5 files changed, 44 insertions(+), 26 deletions(-)

diff --git a/web/html/account.php b/web/html/account.php
index fd9cc61..3d98171 100644
--- a/web/html/account.php
+++ b/web/html/account.php
@@ -13,6 +13,10 @@ html_header();              # print out the HTML header
 
 # Main page processing here
 #
+echo "<div class=\"pgbox\">\n";
+echo "  <div class=\"pgboxtitle\"><span class=\"f3\">".__("Accounts")."</span></div>\n";
+echo "  <div class=\"pgboxbody\">\n";
+
 if (isset($_COOKIE["AURSID"])) {
 	# visitor is logged in
 	#
@@ -148,6 +152,9 @@ if (isset($_COOKIE["AURSID"])) {
 	}
 }
 
+echo "  </div>";
+echo "</div>";
+
 html_footer("\$Id$");
 # vim: ts=2 sw=2 noet ft=php
 ?>
diff --git a/web/html/css/arch.css b/web/html/css/arch.css
index 7d8f41f..65f3cff 100644
--- a/web/html/css/arch.css
+++ b/web/html/css/arch.css
@@ -410,7 +410,7 @@ textarea.vLargeTextField {
     margin-left: 5%;
     margin-right: 5%;
 }
-.pkgbox {
+.pgbox {
     width: 90%;
     margin-left: 5%;
     margin-right: 5%;
@@ -421,7 +421,17 @@ textarea.vLargeTextField {
     text-align: left;
     padding: 3px;
 }
-.pkgboxtitle {
+.frontpgboxbody {
+    padding: 10px;
+}
+.frontpgboxbody > table {
+    width: 100%;
+}
+.boxSoftTitle {
+    text-align: right;
+}
+
+.pgboxtitle {
     border-width: 2px;
     border-style: solid;
     border-color: #dddddd;
@@ -435,14 +445,14 @@ textarea.vLargeTextField {
     padding-bottom: 2px;
     padding-right: 10px;
 }
-.pkgboxbody, .pkgboxbody-comment {
+.pgboxbody, .pgboxbody-comment {
     padding: 10px;
 }
-.pkgboxbody input {
+.pgboxbody input {
     margin-right: 10px;
 }
 
-.pkgboxbody-comment > table {
+.pgboxbody-comment > table {
     border-collapse: separate;
     border-spacing: 0 15px;
 }
diff --git a/web/html/index.php b/web/html/index.php
index 7d28d75..d76d13d 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -79,19 +79,19 @@ if (isset($_REQUEST["user"]) || isset($_REQUEST["pass"])) {
 html_header();
 
 # Big Top Level Table (Table 1)
-print "<table border='0' cellpadding='0' cellspacing='3' width='90%'>\n";
-print "<tr>\n";
+echo "<div class=\"pgbox\">\n";
+echo "  <div class=\"pgboxtitle\"><span class=\"f3\">AUR-".__("Home")."</span></div>\n";
+echo "  <div class=\"frontpgboxbody\">\n";
+echo "<table border='0' cellpadding='0' cellspacing='3' width='90%'>\n";
+echo "<tr>\n";
 
 # MAIN: Top Left
 print "<td class='boxSoft' valign='top'>";
 
 print "<p>".__("Welcome to the AUR! Please read the %hAUR User Guidelines%h and %hAUR TU Guidelines%h for more information.", array('<a href="http://wiki.archlinux.org/index.php/AUR_User_Guidelines">', '</a>', '<a href="http://wiki.archlinux.org/index.php/AUR_Trusted_User_Guidelines">', '</a>'))."<br>";
 print __("Contributed PKGBUILDs <b>must</b> conform to the %hArch Packaging Standards%h otherwise they will be deleted!", array('<a href="http://wiki.archlinux.org/index.php/Arch_Packaging_Standards">', '</a>'))."</p>";
-#print "<p>".__("If you have feedback about the AUR, please leave it in %hFlyspray%h.", array('<a href="http://bugs.archlinux.org/index.php?tasks=all&amp;project=2">', '</a>'))."<br>";
-#print __("Email discussion about the AUR takes place on the %sTUR Users List%s.", array('<a href="http://www.archlinux.org/mailman/listinfo/tur-users">', '</a>'))."</p>";
 print "<p>".__("Remember to vote for your favourite packages!")."<br>";
 print __("The most popular packages will be provided as binary packages in [community].")."</p>";
-#print "<p>".__("Though we can't vouch for their contents, we provide a %hlist of user repositories%h for your convenience.", array('<a href="http://wiki2.archlinux.org/index.php/Unofficial%20Repositories">', '</a>'))."</p>";
 
 # MAIN: Top Right
 print "</td>";
@@ -178,9 +178,6 @@ print "</tr>";
 print "</table>";
 # End Table 2
 
-#print "  <td>&nbsp;&nbsp;</td>";
-#print "  <td align='left' valign='top' nowrap>\n";
-
 # MAIN: Bottom Right
 print "</td>";
 print "<td class='boxSoft' valign='top'>";
@@ -357,8 +354,10 @@ print "</table>";
 print "  </td>";
 print "</tr>\n";
 print "</table>\n";
+echo "</div>\n";
 # End Table 1
-
+echo "  </div>";
+echo "</div>";
 html_footer("<b>Version 1.3.1</b> \$Id$");
 # vim: ts=2 sw=2 noet ft=php
 ?>
diff --git a/web/html/pkgsubmit.php b/web/html/pkgsubmit.php
index 89ecfa4..24aeea5 100644
--- a/web/html/pkgsubmit.php
+++ b/web/html/pkgsubmit.php
@@ -9,7 +9,9 @@ include("config.inc");      # configuration file with dir locations
 set_lang();                 # this sets up the visitor's language
 check_sid();                # see if they're still logged in
 html_header();              # print out the HTML header
-print "<center>\n";
+echo "<div class=\"pgbox\">\n";
+echo "  <div class=\"pgboxtitle\"><span class=\"f3\">".__("Submit")."</span></div>\n";
+echo "  <div class=\"pgboxbody\">\n";
 
 # Debugging
 $DBUG = 0;
@@ -665,8 +667,8 @@ if ($_COOKIE["AURSID"]) {
 	print __("You must create an account before you can upload packages.");
 	print "<br />\n";
 }
-
-print "</center>\n";
+echo "  </div>\n";
+echo "</div>\n";
 html_footer("\$Id$");
 # vim: ts=2 sw=2 noet ft=php
 ?>
diff --git a/web/lib/pkgfuncs.inc b/web/lib/pkgfuncs.inc
index de1dc5f..3089ccb 100644
--- a/web/lib/pkgfuncs.inc
+++ b/web/lib/pkgfuncs.inc
@@ -269,9 +269,9 @@ function package_details($id=0, $SID="") {
 
 			# print out package details
             #
-            echo "<div class=\"pkgbox\">\n";
-            echo "  <div class=\"pkgboxtitle\"><span class=\"f3\">".__("Package Details")."</span></div>\n";
-            echo "  <div class=\"pkgboxbody\">\n";
+            echo "<div class=\"pgbox\">\n";
+            echo "  <div class=\"pgboxtitle\"><span class=\"f3\">".__("Package Details")."</span></div>\n";
+            echo "  <div class=\"pgboxbody\">\n";
 			echo "    <table>\n";
 			echo "      <tr><td class='boxSoft' colspan='2'><span class='f2'>";
 			echo $row["Name"] . " " . $row["Version"]."</span></td></tr>\n";
@@ -409,9 +409,9 @@ function package_details($id=0, $SID="") {
 			# Actions Bar
 			#
 			if ($SID) {
-                echo "<div class=\"pkgbox\">\n";
-                echo "  <div class=\"pkgboxtitle\"><span class=\"f3\">".__("Actions")."</span></div>\n";
-                echo "  <div class=\"pkgboxbody\">\n";
+                echo "<div class=\"pgbox\">\n";
+                echo "  <div class=\"pgboxtitle\"><span class=\"f3\">".__("Actions")."</span></div>\n";
+                echo "  <div class=\"pgboxbody\">\n";
                 echo "    <form action='/packages.php' method='post'>\n";
 				echo "      <input type='hidden' name='IDs[".$row["ID"]."]' value='1'>\n";
 				echo "      <input type='hidden' name='ID' value='".$row["ID"]."'>\n";
@@ -482,9 +482,9 @@ function package_details($id=0, $SID="") {
 			
 			# Comments
 			#
-            echo "<div class=\"pkgbox\">\n";
-            echo "  <div class=\"pkgboxtitle\"><span class=\"f3\">".__("Comments")."</span></div>\n";
-            echo "  <div class=\"pkgboxbody-comment\">\n";
+            echo "<div class=\"pgbox\">\n";
+            echo "  <div class=\"pgboxtitle\"><span class=\"f3\">".__("Comments")."</span></div>\n";
+            echo "  <div class=\"pgboxbody-comment\">\n";
 			echo "    <table width='100%'>\n";
 			$comments = package_comments($row["ID"]);
 			if (!empty($comments)) {
-- 
cgit v1.2.3-70-g09d2


From 4e4f2728c1c4e4bf030b579dc41b530b06166271 Mon Sep 17 00:00:00 2001
From: eliott <eliott@cactuswax.net>
Date: Mon, 24 Sep 2007 09:23:41 -0700
Subject: Phrakture requested fonts to be more similar to main arch site. Added
 css to make it similar.

---
 web/html/css/containers.css | 5 +----
 web/html/css/fonts.css      | 9 +--------
 2 files changed, 2 insertions(+), 12 deletions(-)

diff --git a/web/html/css/containers.css b/web/html/css/containers.css
index 2a0a0e4..006c4ff 100644
--- a/web/html/css/containers.css
+++ b/web/html/css/containers.css
@@ -3,7 +3,6 @@
 		border:				0px;
 		margin:				0px;
 		padding:			0px;
-		font-family:		arial,verdana,tahoma;
 	}
 	
 /* Main Wrapper Data Format */
@@ -182,7 +181,6 @@
 	td.text
 	{
 		color:	#000;
-		font-family: verdana;
 		font-size: 12px;
 	}
 	th
@@ -198,7 +196,7 @@
 	input,textarea,select
 	{
 		background-color: rgb(108,131,176);
-		font-family: courier;
+		font-family: monospace;
 		font-size: 12px;
 		background-color: #ccc;
 		border: #000000 1px solid;
@@ -210,6 +208,5 @@
 		background-color: #fff;
 		color: rgb(108,131,176);
 		border: 1px dashed rgb(108,131,176);
-		font-family: trebuchet ms, tahoma, verdana;
 		font-size: 12px;
 	}
diff --git a/web/html/css/fonts.css b/web/html/css/fonts.css
index 8a60e05..fdeddbe 100644
--- a/web/html/css/fonts.css
+++ b/web/html/css/fonts.css
@@ -2,11 +2,10 @@
 	span /* Applicable by default in all fonts */
 	{
 		color:				#666;
-		font-family:		verdana, trebuchet ms, tahoma, luxi sans;
+		font-family:		Bitstream Vera Sans, Lucida Grande, Arial, sans-serif;
 	}
 	span.f1 /* Important */
 	{
-		font-family:		verdana;
 		font-size:			20px;
 		letter-spacing:		1px;
 	}
@@ -25,13 +24,11 @@
 	span.f4 /* Content Text */
 	{
 		color:				#444;
-		font-family:		verdana;
 		font-size:			12px;
 	}
 	span.f5 /* Content Small */
 	{
 		color:				#333;
-		font-family:		trebuchet ms, tahoma, verdana;
 		font-size:			11px;
 	}
 	span.f6 /* Red Message */
@@ -55,13 +52,11 @@
 	span.error /* Content Text */
 	{
 		color:				#900;
-		font-family:		verdana;
 		font-size:			12px;
 	}
 	span.warning /* Content Text */
 	{
 		color:				#C0C000;
-		font-family:		verdana;
 		font-size:			12px;
 	}
 	
@@ -95,7 +90,6 @@
 		color:				rgb( 201, 209, 226 );
 		font-weight:		bold;
 		font-size:			11px;
-		font-family:		tahoma, trebuchet ms, verdana;
 		padding-right:		8px;
 		word-spacing:		8px;
 	}
@@ -104,7 +98,6 @@
 		color:				#fff;
 		font-weight:		bold;
 		font-size:			11px;
-		font-family:		tahoma, trebuchet ms, verdana;
 		padding-right:		8px;
 	}
 
-- 
cgit v1.2.3-70-g09d2


From cb7cec5028316bc235574258bb73af8f9f643bef Mon Sep 17 00:00:00 2001
From: Paul Mattal <paul@mattal.com>
Date: Tue, 25 Sep 2007 10:19:12 -0400
Subject: Regression to front page "Flagged as safe by me" language Developers
 should be treated the same as TUs

---
 web/html/index.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/web/html/index.php b/web/html/index.php
index d76d13d..4e38e1e 100644
--- a/web/html/index.php
+++ b/web/html/index.php
@@ -274,7 +274,7 @@ if (!empty($user)) {
     # Number of safe packages
     print "<tr>";
     print "<td class='boxSoft'>";
-    if ($atype == 'Trusted User') {
+    if ($atype == 'Trusted User' || $atype == 'Developer') {
 	$q = "SELECT count(*) FROM Packages,Users WHERE Packages.Safe = 1 AND Packages.VerifiedBy = Users.ID AND Users.Username='".mysql_real_escape_string($user)."'";
 	$result = db_query($q, $dbh);
 	$row = mysql_fetch_row($result);
-- 
cgit v1.2.3-70-g09d2


From 7c7685ce82f1779f6f991533df7f5e6d6ac8fe21 Mon Sep 17 00:00:00 2001
From: Paul Mattal <pjmattal@brahms.out.elys.com>
Date: Tue, 25 Sep 2007 10:44:04 -0400
Subject: AUR Italian Translation patch 20070925 from Giovanni Scafora

---
 web/lang/it/index_po.inc    | 2 ++
 web/lang/it/pkgfuncs_po.inc | 2 ++
 2 files changed, 4 insertions(+)

diff --git a/web/lang/it/index_po.inc b/web/lang/it/index_po.inc
index f316aea..e3e7a8c 100644
--- a/web/lang/it/index_po.inc
+++ b/web/lang/it/index_po.inc
@@ -91,4 +91,6 @@ $_t["it"]["Flagged as safe"] = "Considerato sicuro";
 
 $_t["it"]["My Statistics"] = "Le mie statistiche";
 
+$_t["it"]["Home"] = "Inizio";
+
 ?>
\ No newline at end of file
diff --git a/web/lang/it/pkgfuncs_po.inc b/web/lang/it/pkgfuncs_po.inc
index 58668c3..8750891 100644
--- a/web/lang/it/pkgfuncs_po.inc
+++ b/web/lang/it/pkgfuncs_po.inc
@@ -163,4 +163,6 @@ $_t["it"]["All"] = "Tutti";
 
 $_t["it"]["Unsafe"] = "Non sicuri";
 
+$_t["it"]["Accounts"] = "Account";
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2


From d1c9422095b9981f608b75f0b78e412983ba7aff Mon Sep 17 00:00:00 2001
From: Paul Mattal <paul@mattal.com>
Date: Wed, 26 Sep 2007 08:19:34 -0400
Subject: italian_20070926.diff patch from Giovanni Scafora

---
 web/lang/it/pkgfuncs_po.inc | 20 +++++++++++++-------
 1 file changed, 13 insertions(+), 7 deletions(-)

diff --git a/web/lang/it/pkgfuncs_po.inc b/web/lang/it/pkgfuncs_po.inc
index 8750891..b13aabc 100644
--- a/web/lang/it/pkgfuncs_po.inc
+++ b/web/lang/it/pkgfuncs_po.inc
@@ -135,23 +135,23 @@ $_t["it"]["Search by"] = "Cerca per";
 
 $_t["it"]["Submitter"] = "Contributore";
 
-$_t["it"]["Leave the password fields blank to keep your same password."] = "Lasciare vuoti i campi relativi alla password per mantenerla invariata.";
+$_t["it"]["Leave the password fields blank to keep your same password."] = "Lascia vuoti i campi relativi alla password per mantenerla invariata.";
 
 $_t["it"]["You have been successfully logged out."] = "Disconnesso.";
 
-$_t["it"]["You must log in to view user information."] = "Bisogna autenticarsi per visualizzare queste informazioni.";
+$_t["it"]["You must log in to view user information."] = "Devi autenticarti per visualizzare queste informazioni.";
 
 $_t["it"]["Could not retrieve information for the specified user."] = "Non è stato possibile trovare le informazioni sull'utente specificato.";
 
-$_t["it"]["You do not have permission to edit this account."] = "Non si dispone dei permessi necessari per modificare questo account.";
+$_t["it"]["You do not have permission to edit this account."] = "Non disponi dei permessi necessari per modificare questo account.";
 
-$_t["it"]["Use this form to search existing accounts."] = "Utilizzare questo modulo per cercare account esistenti.";
+$_t["it"]["Use this form to search existing accounts."] = "Utilizza questo modulo per cercare account esistenti.";
 
-$_t["it"]["Use this form to create an account."] = "Utilizzare questo modulo per creare un account.";
+$_t["it"]["Use this form to create an account."] = "Utilizza questo modulo per creare un account.";
 
-$_t["it"]["Use this form to update your account."] = "Utilizzare questo modulo per aggiornare il vostro account.";
+$_t["it"]["Use this form to update your account."] = "Utilizza questo modulo per aggiornare il vostro account.";
 
-$_t["it"]["You are not allowed to access this area."] = "Non si dispone dei permessi necessari per accedere.";
+$_t["it"]["You are not allowed to access this area."] = "Non disponi dei permessi necessari per accedere.";
 
 $_t["it"]["Status"] = "Stato";
 
@@ -165,4 +165,10 @@ $_t["it"]["Unsafe"] = "Non sicuri";
 
 $_t["it"]["Accounts"] = "Account";
 
+$_t["it"]["This package has been flagged out of date."] = "Questo pacchetto è stato segnato come non aggiornato.";
+
+$_t["it"]["The above files have been verified (by %h%s%h) and are safe to use."] = "I file sono stati verificati (da %h%s%h) ed il loro utilizzo è da considerarsi sicuro.";
+
+$_t["it"]["Required by"] = "Richiesto da";
+
 ?>
\ No newline at end of file
-- 
cgit v1.2.3-70-g09d2