Page Menu
Home
In-Portal Phabricator
Search
Configure Global Search
Log In
Files
F2111401
debug_sample.php
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Wed, Nov 18, 11:49 AM
Size
3 KB
Mime Type
text/x-php
Expires
Fri, Nov 20, 11:49 AM (1 h, 45 m)
Engine
blob
Format
Raw Data
Handle
990861
Attached To
rINP In-Portal
debug_sample.php
View Options
<?php
// uncomment next line to enable sql logging
define
(
'ADODB_OUTP'
,
'SQLLog'
);
define
(
'DOC_ROOT'
,
$_SERVER
[
'DOCUMENT_ROOT'
]);
define
(
'WINDOWS_ROOT'
,
'w:'
);
define
(
'WINDOWS_EDITOR'
,
'c:
\P
rogram Files
\Z
end
\Z
endStudio-4.0Beta
\b
in
\Z
DE.exe %F'
);
// %F - filename, %L - line number
define
(
'DBG_STYLESHEET'
,
'http://'
.
$_SERVER
[
'HTTP_HOST'
].
'/in-portal/admin/include/debug_styles.css'
);
//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_OUTPUT'
,
DOC_ROOT
.
'/inportal_sqls.txt'
);
// file where to store sql queries
define
(
'SQL_OVERWRITE'
,
1
);
// overwrite or not sql_log file
define
(
'DEBUG_MODE'
,
1
);
// global debugging
//define('DEBUG_HELP', 1); // allow to add missing help
if
(
defined
(
'DEBUG_MODE'
)
&&
constant
(
'DEBUG_MODE'
)
==
1
)
{
ini_set
(
'display_errors'
,
1
);
}
function
isSkipTable
(
$sql
)
{
static
$skipTables
=
Array
(
'Modules'
,
'Language'
,
'PermissionConfig'
,
'PermCache'
,
'SessionData'
,
'UserSession'
,
'Phrase'
,
'ConfigurationValues'
,
'PersistantSessionData'
,
'Events'
,
'EmailQueue'
,
'Permissions'
);
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
)
{
// add affected rows
$before
=
substr
(
$msg
,
0
,
$select_pos
);
$after
=
substr
(
$msg
,
$select_pos
,
strlen
(
$msg
));
$msg
=
$before
.
'AR: ['
.
$db
->
Affected_Rows
().
'] '
.
$after
;
}
if
(
$newline
)
$msg
.=
"<br>
\n
"
;
if
(
defined
(
'SQL_TO_SCREEN'
)
&&
SQL_TO_SCREEN
==
1
)
echo
$msg
;
if
(
defined
(
'SQL_TO_FILE'
)
&&
SQL_TO_FILE
==
1
)
{
if
(
$file_reset
==
false
&&
defined
(
'SQL_OVERWRITE'
)
&&
SQL_OVERWRITE
)
{
if
(
file_exists
(
SQL_OUTPUT
)
)
unlink
(
SQL_OUTPUT
);
$file_reset
=
true
;
}
$msg
=
str_replace
(
Array
(
"<hr />
\n
"
,
' <code></code>'
,
'<'
,
'>'
,
'"'
),
Array
(
''
,
''
,
'<'
,
'>'
,
'"'
),
$msg
);
$fp
=
fopen
(
SQL_OUTPUT
,
'a'
);
fwrite
(
$fp
,
$msg
);
fclose
(
$fp
);
}
}
/**
* @return string
* @desc Returnts trace results to place where called from
*/
function
trace
()
{
die
(
'Error: Depricated call. Use <b>$debugger->appendTrace();</b> instead'
);
/*$trace_results = debug_backtrace();
array_shift($trace_results);
echo 'Called from [<b>'.$trace_results[0]['function'].'</b>]<br>';
print_pre($trace_results);*/
}
function
DebugByFile
()
{
$ScriptName
=
basename
(
$_SERVER
[
'PHP_SELF'
]
);
switch
(
$ScriptName
)
{
case
'step3.php'
:
global
$objSession
;
$objSession
->
SetVariable
(
'import_sql_type'
,
'mysql'
);
$objSession
->
SetVariable
(
'import_server'
,
'localhost'
);
$objSession
->
SetVariable
(
'import_db'
,
'alex_in_portal'
);
//maris_inlink');
$objSession
->
SetVariable
(
'import_user'
,
'dev'
);
$objSession
->
SetVariable
(
'import_pass'
,
'dev-25-sql'
);
$objSession
->
SetVariable
(
'categoryid'
,
101
);
// resource id
$objSession
->
SetVariable
(
'import_category_id'
,
1
);
// category id
$objSession
->
SetVariable
(
'catnavbar'
,
'Home>Directory (debug_auto_complete)'
);
$objSession
->
SetVariable
(
'user_admin_names'
,
'admin'
);
$objSession
->
SetVariable
(
'user_admin_values'
,
11
);
$objSession
->
SetVariable
(
'user_regular_names'
,
'Member'
);
$objSession
->
SetVariable
(
'user_regular_values'
,
13
);
break
;
}
}
?>
Event Timeline
Log In to Comment