[Web-erp-svn] SF.net SVN: web-erp:[7949] trunk

[<tu...@us...>]

Revision: 7949
          http://sourceforge.net/p/web-erp/reponame/7949
Author:   turbopt
Date:     2018-02-10 02:36:28 +0000 (Sat, 10 Feb 2018)
Log Message:
-----------
PaulT: MRPReschedules.php, MRPShortages.php: Use DB_table_exists() from commit 7943 to replace table check query.

Modified Paths:
--------------
    trunk/MRPReschedules.php
    trunk/MRPShortages.php
    trunk/doc/Change.log

Modified: trunk/MRPReschedules.php
===================================================================
--- trunk/MRPReschedules.php	2018-02-10 01:46:00 UTC (rev 7948)
+++ trunk/MRPReschedules.php	2018-02-10 02:36:28 UTC (rev 7949)
@@ -5,9 +5,7 @@
 
 include('includes/session.php');
 
-$sql = "SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_SCHEMA = '" . $_SESSION['DatabaseName'] . "' AND TABLE_NAME = 'mrprequirements'";
-$result=DB_query($sql);
-if (DB_num_rows($result)==0) {
+if ( !DB_table_exists('mrprequirements') ) {
 	$Title='MRP error';
 	include('includes/header.php');
 	echo '<br />';

Modified: trunk/MRPShortages.php
===================================================================
--- trunk/MRPShortages.php	2018-02-10 01:46:00 UTC (rev 7948)
+++ trunk/MRPShortages.php	2018-02-10 02:36:28 UTC (rev 7949)
@@ -4,11 +4,7 @@
 
 include('includes/session.php');
 
-//ANSI SQL???
-$sql = "SELECT TABLE_NAME FROM information_schema.tables WHERE TABLE_SCHEMA = '" . $_SESSION['DatabaseName'] . "' AND TABLE_NAME = 'mrprequirements'";
-
-$result=DB_query($sql);
-if (DB_num_rows($result)==0) {
+if ( !DB_table_exists('mrprequirements') ) {
 	$Title=_('MRP error');
 	include('includes/header.php');
 	echo '<br />';

Modified: trunk/doc/Change.log
===================================================================
--- trunk/doc/Change.log	2018-02-10 01:46:00 UTC (rev 7948)
+++ trunk/doc/Change.log	2018-02-10 02:36:28 UTC (rev 7949)
@@ -1,5 +1,6 @@
 webERP Change Log
 
+9/2/18   PaulT: MRPReschedules.php, MRPShortages.php: Use DB_table_exists() from commit 7943 to replace table check query.
 9/2/18   PaulT: Remove the last of the remaining URL 'SID' references.
 9/2/18   Paul Becker (PaulT commit): StockLocMovements.php, StockMovements.php: Add serial number column to output. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8088)
 9/2/18   Paul Becker (PaulT commit): InternalStockRequestFulfill.php: Add controlled stock handling within this script. (Reported in forums: http://www.weberp.org/forum/showthread.php?tid=8086)