[Weberp-svn] SF.net SVN: weberp:[5049] trunk
Brought to you by:
sotandeka,
tim_schofield
Menu
▾
▴
[Weberp-svn] SF.net SVN: weberp:[5049] trunk
|
From: <tim...@us...> - 2011-04-02 19:12:18
|
Revision: 5049
http://weberp.svn.sourceforge.net/weberp/?rev=5049&view=rev
Author: tim_schofield
Date: 2011-04-02 19:12:12 +0000 (Sat, 02 Apr 2011)
Log Message:
-----------
sql quoting changes
Modified Paths:
--------------
trunk/locale/zh_CN.utf8/Manual/ManualAPIFunctions.php
trunk/sql/mysql/weberp-demo.sql
trunk/sql/mysql/weberp-new.sql
Modified: trunk/locale/zh_CN.utf8/Manual/ManualAPIFunctions.php
===================================================================
--- trunk/locale/zh_CN.utf8/Manual/ManualAPIFunctions.php 2011-04-02 19:01:10 UTC (rev 5048)
+++ trunk/locale/zh_CN.utf8/Manual/ManualAPIFunctions.php 2011-04-02 19:12:12 UTC (rev 5049)
@@ -19,7 +19,7 @@
echo '<body>';
$weberpuser = $_SESSION['UserID'];
-$sql='SELECT password FROM www_users WHERE userid="'.$weberpuser.'"';
+$sql="SELECT password FROM www_users WHERE userid='".$weberpuser."'";
$result=DB_query($sql, $db);
$myrow=DB_fetch_array($result);
$weberppassword = $myrow[0];
Modified: trunk/sql/mysql/weberp-demo.sql
===================================================================
--- trunk/sql/mysql/weberp-demo.sql 2011-04-02 19:01:10 UTC (rev 5048)
+++ trunk/sql/mysql/weberp-demo.sql 2011-04-02 19:12:12 UTC (rev 5049)
@@ -111,16 +111,6 @@
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Dumping data for table `audittrail`
---
-
-LOCK TABLES `audittrail` WRITE;
-/*!40000 ALTER TABLE `audittrail` DISABLE KEYS */;
-INSERT INTO `audittrail` VALUES ('2011-01-20 16:58:26','admin','UPDATE currencies SET\n rate=\'0.6210704557167\'\n WHERE currabrev=\'GBP\''),('2011-01-20 16:58:26','admin','UPDATE currencies SET\n rate=\'0.7362143856291\'\n WHERE currabrev=\'EUR\''),('2011-01-20 16:58:26','admin','UPDATE currencies SET\n rate=\'0.94772877862033\'\n WHERE currabrev=\'CHF\''),('2011-01-20 16:58:26','admin','UPDATE currencies SET\n rate=\'0.99182802031952\'\n WHERE currabrev=\'USD\''),('2011-01-20 16:58:26','admin','UPDATE config SET confvalue = \'2011-01-20\' WHERE confname=\'UpdateCurrencyRatesDaily\''),('2011-01-20 17:01:26','admin','UPDATE config SET confvalue=\'61\' WHERE confname=\'DBUpdateNumber\''),('2011-01-20 17:03:40','admin','UPDATE config SET confvalue=\'61\' WHERE confname=\'DBUpdateNumber\''),('2011-01-20 17:06:02','admin','UPDATE config SET confvalue = \'4.0\' WHERE confname=\'VersionNumber\''),('2011-01-20 17:06:02','admin','UPDATE config SET confvalue=\'61\' WHERE confname=\'DBUpdateNumber\'');
-/*!40000 ALTER TABLE `audittrail` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `bankaccounts`
--
Modified: trunk/sql/mysql/weberp-new.sql
===================================================================
--- trunk/sql/mysql/weberp-new.sql 2011-04-02 19:01:10 UTC (rev 5048)
+++ trunk/sql/mysql/weberp-new.sql 2011-04-02 19:12:12 UTC (rev 5049)
@@ -110,16 +110,6 @@
/*!40101 SET character_set_client = @saved_cs_client */;
--
--- Dumping data for table `audittrail`
---
-
-LOCK TABLES `audittrail` WRITE;
-/*!40000 ALTER TABLE `audittrail` DISABLE KEYS */;
-INSERT INTO `audittrail` VALUES ('2011-01-20 17:11:08','admin','UPDATE config SET confvalue = \'4.0\' WHERE confname=\'VersionNumber\''),('2011-01-20 17:11:08','admin','UPDATE config SET confvalue=\'61\' WHERE confname=\'DBUpdateNumber\'');
-/*!40000 ALTER TABLE `audittrail` ENABLE KEYS */;
-UNLOCK TABLES;
-
---
-- Table structure for table `bankaccounts`
--
This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.
|
