[Mapbender-commits] r4579 - in branches/2.6: http/frames resources/db/pgsql/UTF-8/update

[svn_mapbender at osgeo.org]

Author: tbaschetti
Date: 2009-08-31 03:56:25 -0400 (Mon, 31 Aug 2009)
New Revision: 4579

Modified:
   branches/2.6/http/frames/index.php
   branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql
Log:
enable favicon per gui using element_var
http://trac.osgeo.org/mapbender/ticket/514



Modified: branches/2.6/http/frames/index.php
===================================================================
--- branches/2.6/http/frames/index.php	2009-08-31 07:55:42 UTC (rev 4578)
+++ branches/2.6/http/frames/index.php	2009-08-31 07:56:25 UTC (rev 4579)
@@ -49,6 +49,16 @@
 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET;?>">
 <title><?php echo  $gui_id;?> - presented by Mapbender</title>
 <?php
+$sql = "SELECT * FROM gui_element_vars WHERE fkey_e_id = 'body' AND fkey_gui_id = $1 and var_name='favicon'";
+$v = array($gui_id);
+$t = array('s');
+$res = db_prep_query($sql,$v,$t);
+$cnt = 0;
+while($row = db_fetch_array($res)){
+	echo "<link rel=\"shortcut icon\" type=\"image/png\" href=\"".$row["var_value"]."\">\n";
+}
+?> 
+<?php
 $sql = "SELECT * FROM gui_element_vars WHERE fkey_e_id = 'body' AND fkey_gui_id = $1 and var_type='file/css'";
 $v = array($gui_id);
 $t = array('s');

Modified: branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql
===================================================================
--- branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql	2009-08-31 07:55:42 UTC (rev 4578)
+++ branches/2.6/resources/db/pgsql/UTF-8/update/update_2.6rc1_to_2.6rc2_pgsql_UTF-8.sql	2009-08-31 07:56:25 UTC (rev 4579)
@@ -133,3 +133,7 @@
 ALTER TABLE mb_user ADD COLUMN mb_user_valid_to date;
 ALTER TABLE mb_user ADD COLUMN mb_user_password_ticket varchar(100);
 
+-- enable favicon per gui using element_var
+-- http://trac.osgeo.org/mapbender/ticket/514
+INSERT INTO gui_element_vars(fkey_gui_id, fkey_e_id, var_name, var_value, context, var_type) VALUES('gui', 'body', 'favicon', '../img/favicon.png', 'favicon' ,'php_var');
+