class vB_UserChangeLog

Select and search functions for the userlog changes

Properties

vB_Database $dbobject The vBulletin database object
boolean $execute Execute or just build the query?
boolean $just_count Full query or just count?
protected vB_dB_Assertor $assertor The vBulletin DB Assertor object

Methods

__construct(vBulletin $registry)

Constructor

set_execute(boolean $execute = false)

Set the execute flag

set_just_count(boolean $just_count = false)

Set the just_count flag

mixed
sql_select_by_userid($userid, $time_start = 0, $time_end = 0, $page = 0, $limit = 100)

Select the userlog by user

mixed
sql_select_by_username($fieldname, $time_start = 0, $time_end = 0, $page = 0, $limit = 100)

Select the userlog by username

mixed
sql_select_core(mixed $cond_value, integer $cond_type, integer $time_start, integer $time_end, integer $page, integer $limit)

Select query builder / executer

Details

at line 61
__construct(vBulletin $registry)

Constructor

Parameters

vBulletin $registry database Instance

at line 81
set_execute(boolean $execute = false)

Set the execute flag

Parameters

boolean $execute

at line 98
set_just_count(boolean $just_count = false)

Set the just_count flag

Parameters

boolean $just_count

at line 120
mixed sql_select_by_userid($userid, $time_start = 0, $time_end = 0, $page = 0, $limit = 100)

Select the userlog by user

Parameters

$userid
$time_start
$time_end
$page
$limit

Return Value

mixed sql query (no execute) / select resultset (execute + no just_count) / selected count (execute + just_count)

at line 134
mixed sql_select_by_username($fieldname, $time_start = 0, $time_end = 0, $page = 0, $limit = 100)

Select the userlog by username

Parameters

$fieldname
$time_start
$time_end
$page
$limit

Return Value

mixed sql query (no execute) / select resultset (execute + no just_count) / selected count (execute + just_count)

at line 152
mixed sql_select_core(mixed $cond_value, integer $cond_type, integer $time_start, integer $time_end, integer $page, integer $limit)

Select query builder / executer

Parameters

mixed $cond_value condition value
integer $cond_type condition type (reference: in this file define('USERCHANGELOG_COND_TYPE_*'))
integer $time_start minimum time (UNIX_TIMESTAMP)
integer $time_end maximum time (UNIX_TIMESTAMP)
integer $page which page we want to select
integer $limit how many row on the page

Return Value

mixed sql query (no execute) / select resultset (execute + no just_count) / selected count (execute + just_count)