Index: trunk/tools/debug_sample.php =================================================================== diff -u -N -r842 -r854 --- trunk/tools/debug_sample.php (.../debug_sample.php) (revision 842) +++ trunk/tools/debug_sample.php (.../debug_sample.php) (revision 854) @@ -10,9 +10,12 @@ //define('SQL_TO_SCREEN', 1); // output sql queries to screen + + define('SQL_ERROR_DIE', 1); + //define('SQL_PROFILE', 1); + // sql logging to file define('SQL_TO_FILE', 1); // output sql queries to file - define('SQL_ERROR_DIE', 1); define('SQL_OUTPUT', DOC_ROOT.'/inportal_sqls.txt'); // file where to store sql queries define('SQL_OVERWRITE', 1); // overwrite or not sql_log file @@ -24,31 +27,33 @@ define('DEBUG_ACTIONS', SHOW_REQUEST + FRONT_SHOW_REQUEST); //define('DEBUG_HELP', 1); // allow to add missing help - // For local license testing - //define('GET_LICENSE_URL', 'http://maris.prod.intechnic.lv/in-business/license.php'); - if( defined('DEBUG_MODE') && constant('DEBUG_MODE') == 1 ) { ini_set('display_errors', 1); } - function SQLLog($msg, $newline = true) + function isSkipTable($sql) { - static $file_reset = false; - - $db =& GetADODBConnection(); - // telestial specific: begin - static $prefix = ''; - $prefix = GetTablePrefix(); - // 'Theme' - $skip_tables = Array( 'Modules','Language','PermissionConfig','PermCache', + static $skipTables = Array('Modules','Language','PermissionConfig','PermCache', 'SessionData','UserSession','Phrase','ConfigurationValues', 'PersistantSessionData','Events','EmailQueue', 'Permissions'); - foreach($skip_tables as $table) - if( strpos($msg, $prefix.$table) !== false ) return false; - // telestial specific: end + static $prefix = ''; + $prefix = GetTablePrefix(); + foreach($skipTables as $table) + { + if( strpos($sql, $prefix.$table) !== false ) return true; + } + return false; + } + + function SQLLog($msg, $newline = true) + { + static $file_reset = false; + $db =& GetADODBConnection(); + if( isSkipTable($msg) ) return false; + $select_pos = strpos($msg, 'SELECT '); if($select_pos !== false) {