[Astlinux-commits] SF.net SVN: astlinux:[5997] branches/1.0/package/webinterface/altweb

[<abe...@us...>]

Revision: 5997
          http://astlinux.svn.sourceforge.net/astlinux/?rev=5997&view=rev
Author:   abelbeck
Date:     2013-03-16 18:26:14 +0000 (Sat, 16 Mar 2013)
Log Message:
-----------
web interface, customize phpliteadmin.php more to use <input type='text' instead of <textarea
for Search, Insert and Browse -> {edit} screens.  Also set empty string defaults to the standard schema

Modified Paths:
--------------
    branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php
    branches/1.0/package/webinterface/altweb/common/sqldata.sql

Modified: branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php
===================================================================
--- branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php	2013-03-15 22:18:51 UTC (rev 5996)
+++ branches/1.0/package/webinterface/altweb/admin/phpliteadmin.php	2013-03-16 18:26:14 UTC (rev 5997)
@@ -2976,7 +2976,9 @@
 					  if($type=="INTEGER" || $type=="REAL" || $type=="NULL")
 						  echo "<input type='text' name='".htmlencode($field)."'/>";
 					  else
-						  echo "<textarea name='".htmlencode($field)."' wrap='hard' rows='1' cols='60'></textarea>";
+						  //AstLinux//
+						  echo "<input type='text' size='60' name='".htmlencode($field)."'/>";
+						  //echo "<textarea name='".htmlencode($field)."' wrap='hard' rows='1' cols='60'></textarea>";
 					  echo "</td>";
 					  echo "</tr>";
 					}
@@ -3445,7 +3447,9 @@
 						if($scalarField)
 							echo "<input type='text' id='row_".$j."_field_".$i."_value' name='".$j.":".$field_html."' value='".deQuoteSQL($result[$i][4])."' onblur='changeIgnore(this, \"row_".$j."_ignore\");' onclick='notNull(\"row_".$j."_field_".$i."_null\");'/>";
 						else
-							echo "<textarea id='row_".$j."_field_".$i."_value' name='".$j.":".$field_html."' rows='5' cols='60' onclick='notNull(\"row_".$j."_field_".$i."_null\");' onblur='changeIgnore(this, \"row_".$j."_ignore\");'>".deQuoteSQL($result[$i][4])."</textarea>";
+							//AstLinux//
+							echo "<input type='text' size='60' id='row_".$j."_field_".$i."_value' name='".$j.":".$field_html."' value='".deQuoteSQL($result[$i][4])."' onblur='changeIgnore(this, \"row_".$j."_ignore\");' onclick='notNull(\"row_".$j."_field_".$i."_null\");'/>";
+							//echo "<textarea id='row_".$j."_field_".$i."_value' name='".$j.":".$field_html."' rows='5' cols='60' onclick='notNull(\"row_".$j."_field_".$i."_null\");' onblur='changeIgnore(this, \"row_".$j."_ignore\");'>".deQuoteSQL($result[$i][4])."</textarea>";
             		echo "</td>";
             		echo "</tr>";
 					}
@@ -3547,7 +3551,9 @@
 								if($type=="INTEGER" || $type=="REAL" || $type=="NULL")
 									echo "<input type='text' name='".htmlencode($pks[$j]).":".htmlencode($field)."' value='".htmlencode($value)."' onblur='changeIgnore(this, \"".$j."\", \"".htmlencode($pks[$j]).":".htmlencode($field)."_null\")' />";
 								else
-									echo "<textarea name='".htmlencode($pks[$j]).":".htmlencode($field)."' wrap='hard' rows='1' cols='60' onblur='changeIgnore(this, \"".$j."\", \"".htmlencode($pks[$j]).":".htmlencode($field)."_null\")'>".htmlencode($value)."</textarea>";
+									//AstLinux//
+									echo "<input type='text' size='60' name='".htmlencode($pks[$j]).":".htmlencode($field)."' value='".htmlencode($value)."' onblur='changeIgnore(this, \"".$j."\", \"".htmlencode($pks[$j]).":".htmlencode($field)."_null\")' />";
+									//echo "<textarea name='".htmlencode($pks[$j]).":".htmlencode($field)."' wrap='hard' rows='1' cols='60' onblur='changeIgnore(this, \"".$j."\", \"".htmlencode($pks[$j]).":".htmlencode($field)."_null\")'>".htmlencode($value)."</textarea>";
 								echo "</td>";
 								echo "</tr>";
 							}

Modified: branches/1.0/package/webinterface/altweb/common/sqldata.sql
===================================================================
--- branches/1.0/package/webinterface/altweb/common/sqldata.sql	2013-03-15 22:18:51 UTC (rev 5996)
+++ branches/1.0/package/webinterface/altweb/common/sqldata.sql	2013-03-16 18:26:14 UTC (rev 5997)
@@ -2,33 +2,33 @@
 CREATE TABLE IF NOT EXISTS 'sip_users' (
   'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
   'sipuser' TEXT NOT NULL,
-  'lastname' TEXT,
-  'firstname' TEXT,
+  'lastname' TEXT DEFAULT '',
+  'firstname' TEXT DEFAULT '',
   'out_cxid' INTEGER DEFAULT 7,
   'vm' INTEGER DEFAULT 0,
-  'vmbox' TEXT,
-  'email' TEXT,
-  'ext_intern' TEXT,
-  'ext_extern' TEXT,
-  'fax_ext' TEXT,
-  'fax_email' TEXT,
-  'xmpp_jid' TEXT
+  'vmbox' TEXT DEFAULT '',
+  'email' TEXT DEFAULT '',
+  'ext_intern' TEXT DEFAULT '',
+  'ext_extern' TEXT DEFAULT '',
+  'fax_ext' TEXT DEFAULT '',
+  'fax_email' TEXT DEFAULT '',
+  'xmpp_jid' TEXT DEFAULT ''
 );
 
 CREATE TABLE IF NOT EXISTS 'out_context' (
   'id' INTEGER PRIMARY KEY NOT NULL,
   'context' TEXT NOT NULL,
-  'description' TEXT
+  'description' TEXT DEFAULT ''
 );
 
 CREATE TABLE IF NOT EXISTS 'ip_phones' (
   'id' INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
-  'type' TEXT,
-  'firmware' TEXT,
-  'hostname' TEXT,
-  'ipv4' TEXT,
-  'ipv6' TEXT,
-  'mac' TEXT,
+  'type' TEXT DEFAULT '',
+  'firmware' TEXT DEFAULT '',
+  'hostname' TEXT DEFAULT '',
+  'ipv4' TEXT DEFAULT '',
+  'ipv6' TEXT DEFAULT '',
+  'mac' TEXT DEFAULT '',
   'sipuser_id' INTEGER
 );
 

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.