[Database] element index

Package indexes

All elements
a b c d e g h l m n p q r s t u
a
top
Method addPending
CIB_DB::addPending() in CIB_DB.inc
Adds a user request for increased permissions
Method addRow
QueryResult::addRow() in QueryResult.inc
Appends a row to the stored result
Method assignCompNumbers
Method assignCompNumbersAffil
Method assignCompNumbersAlpha
Method availibleUserName
Check if a given username is available
b
top
Method buildAffilList
Method buildAffilLut
Method buildAffilLut
Method buildEventList
Method buildEventLut
Method buildPeopleLut
Method buildPeopleLut
Method buildSummaryList
c
top
Method calculatePersonTotal
Method checkForCentralAffiliation
Method CIB_DB
CIB_DB::CIB_DB() in CIB_DB.inc
CIB_DB Constructor.
Class CIB_DB
CIB_DB in CIB_DB.inc
CIB Core Module Database API.
Method commit
DB::commit() in DB.inc
Commit an extended transaction block
Class CompDB
CompDB in CompDB.inc
A minimal Database abstraction layer.
Method CompDB
CompDB::CompDB() in CompDB.inc
Page CIB_DB.inc
CIB_DB.inc in CIB_DB.inc
d
top
Variable $db
DB::$db in DB.inc
Variable $dbname
DB::$dbname in DB.inc
Method DB
DB::DB() in DB.inc
DB Constructor
Class DB
DB in DB.inc
A minimal Database abstraction layer.
Method denyPermissionToUser
Deny a pending permission request and notify user.
Method determineDeadlineMet
Page DB.inc
DB.inc in DB.inc
e
top
Variable $error
QueryResult::$error in QueryResult.inc
captured error message
Method expandTeamNamesFromID
Update Keys to include TeamNames.
g
top
Method getActiveMembers
Return a list of members for a given team.
Method getAffiliation
Returns an person's team memberships
Method getAffilListChoices
Method getAffilListChoicesSelect
Method getAgeCategories
Method getAgeCategoriesSelect
Method getAllEmail
CompDB::getAllEmail() in CompDB.inc
Method getAllEntriesFor
Returns an exhaustive set of entry information.
Method getAllTBAEmail
Method getApprovedOutsideComps
Return a list of approved non-hosted competitions.
Method getAvgEntries
Method getCanLevels
Return the list of canonical levels Returns a list of levels normally used by competitions of a given type.
Method getCanStyles
Return the list of canonical styles Returns a list of levels normally used by competitions of a given type.
Method getCaptainsEmails
List of email addresses Generates a list of email address for users meeting $type and $level requirements.
Method getCibServers
List of other known CIB servers.
Method getClosedComps
Return a list of closed competitions hosted by this server Returns a list of closed, hosted competitions. This was needed because the general getHostedComps() couldn't get multiple statuses as once.
Method getCompAnnouncements
Return a list of Competition Announcements.
Method getCompHistory
Returns a list of all competitions a person has competed in.
Method getCompsByDate
Return a list of competition between a given date range
Method getCompsOpenForRegistration
Return a list of competition names that are open
Method getCompStatusChoices
List of possible competitions status
Method getCompTypes
Return an list of configured competition types
Method getCompUnixNames
List of used CompUnix names
Method getConfigComps
Return a list of competition's a user is configuring.
Method getDBName
DB::getDBName() in DB.inc
Returns the database in use
Method getDBpass
DB::getDBpass() in DB.inc
Returns the current user's database password
Method getDBuser
DB::getDBuser() in DB.inc
Returns the database user connected as
Method getDocumentList
Return an list of documents Designed for returning lists of HowTos's and Help docuemnts, currently unused and probably broken.
Method getError
QueryResult::getError() in QueryResult.inc
Checks the error message
Method getEventCats
Method getHomeTown
ResultsDB::getHomeTown() in ResultsDB.inc
Returns an person's hometwon or "No adddress lists".
Method getHost
CompDB::getHost() in CompDB.inc
Method getHostedComps
Return a list of competitions being hosted by this server Returns a list of hosted competitions having a given $status, normally ordered by date (default value of $order) and a full unlimited/offset list.
Method getIdentificationByID
Returns a list of details about all requested IDs
Method getIncompleteReg
Method getLastOID
Get the last assigned OID
Method getMemberInformation
Return details for all members for a given team.
Method getMemberNames
Return a list of member names for a given team.
Method getMOTD
CompDB::getMOTD() in CompDB.inc
Method getNextTBA
CompDB::getNextTBA() in CompDB.inc
Method getNonApprovedOutsideComps
Return a list of outside competition advertisements pending approval.
Method getNumAffiliations
Method getNumCompetitors
Method getNumCouples
Method getNumEntries
Method getPackages
CompDB::getPackages() in CompDB.inc
Method getPackagesSelect
Method getPendingKey
Retrieve key information from a row identifier
Method getPendingKeys
Retrieve pending key information for a given user
Method getPendingPermissions
Fetch the list of pending permission requests that $user may approve.
Method getPeopleByName
Return a list of possible id matches for a given name.
Method getPersonIdDetails
Return full contact information for a person Coalesces all the contact information and team membership(s) a given person.
Method getPersonName
Returns an person's name.
Method getPersonPaid
Method getPersonWaived
Method getResultsFor
Returns an exhaustive set of placement information.
Method getRowAt
QueryResult::getRowAt() in QueryResult.inc
Returns the request row, without error checking
Method getSelectMembers
Method getSiteAnnouncements
Return a list of Site Level Announcements.
Method getStatsAffilListing
Method getStatsEventListing
Method getStatsFooter
Method getStatsHeader
Method getStatsSummary
Method getStatsSummary
Method getStatus
CompDB::getStatus() in CompDB.inc
Method getSyncRequests
Retrieve status of requests to sync records
Method getTeamAdmin
Return a list of teams to which $user can administer.
Method getTeamDetails
Return full contact information for a team.
Method getTeamIDs
CIB_DB::getTeamIDs() in CIB_DB.inc
List of used TeamIDs
Method getTeamMemberships
Return a list of teams to which $user belongs.
Method getTeamRequests
Retrieve status of requests for team membership Requests can go either way, a user can "petition" to join a team, requiring team admin approval, or a team admin can "invite" a user to join their team, pending user approval.
Method getTeams
Team_DB::getTeams() in Team_DB.inc
Return a list of teams
Method getTeams
CIB_DB::getTeams() in CIB_DB.inc
List of all known teams
Method getTotalOwed
Method getTotalPaid
Method getTotalWaived
Method getUpcomingComps
Return a list of competition names that are upcoming
Method getUserPasswordByName
Get a user's hased password.
Method getUserRoles
List of user access levels
Method get_medianEventRegistration
Method grantPermissionToUser
Grat a pending permission request and notify user.
h
top
Method helper_fillEvents
Method helper_getAgeCats
Method helper_getFeeCats
Method helper_limitOffset
returns a LIMIT n OFFSET m modification to a query.
Method helper_queryToArray
Execute a query that returns a list of paired values
Method helper_queryToArrayCategories
Execute a query that returns a list of paired values organized into categories
Method helper_queryToSimpleArray
Execute a query that returns a list of scalar values A convienence function used to unpack the QueryResult when a list of single column values is expected, for use in cases like SELECT id FROM ...
Method helper_singleValueQuery
Execute a query that returns a single scalar value A convienence function used to unpack the QueryResult when a single value is expected, for use in cases like SELECT count(*) FROM ...
l
top
Variable $lastOID
DB::$lastOID in DB.inc
Variable $lastUsed
StatsDB::$lastUsed in StatsDB.inc
Variable $lastUsed
CompDB::$lastUsed in CompDB.inc
m
top
Method medianQuery
StatsDB::medianQuery() in StatsDB.inc
n
top
Method nameCollisionTable
Method numRows
QueryResult::numRows() in QueryResult.inc
Return the number of rows in the QueryResult
p
top
Variable $password
DB::$password in DB.inc
Page PS_DB.inc
PS_DB.inc in PS_DB.inc
Method personConflicts
Method produceRegistrantArray
Method PS_DB
PS_DB::PS_DB() in PS_DB.inc
PrepStep DB Constructor.
Class PS_DB
PS_DB in PS_DB.inc
PrepStep Module Database API.
q
top
Page QueryResult.inc
QueryResult.inc in QueryResult.inc
Method query
DB::query() in DB.inc
Execute a query against the Database Preforms the query, returns a QueryResult in all cases, however the QueryResult is only useful in cases of SELECT queries. INSERTS will update the lastOID member variable.
Method QueryResult
QueryResult::QueryResult() in QueryResult.inc
QueryResult constructor
Class QueryResult
QueryResult in QueryResult.inc
A QueryResult captures the result of a SELECT statement.
r
top
Variable $results
QueryResult::$results in QueryResult.inc
full data from the DB
Variable $rows
QueryResult::$rows in QueryResult.inc
number of rows in this QueryResult
Page ResultsDB.inc
ResultsDB.inc in ResultsDB.inc
Method rebuildCategories
Method rebuildCategorySummary
Method rebuildEvents
Method rebuildPeople
Method rebuildSchoolInclude
Method rebuildSchools
Method rebuildStats
Method ResultsDB
ResultsDB::ResultsDB() in ResultsDB.inc
ResultsDB Constructor.
Class ResultsDB
ResultsDB in ResultsDB.inc
Result Tracker Module Database API.
Method retrieveAffilsRegistrations
Method rollback
DB::rollback() in DB.inc
Abort/Rollback an extended transaction block
s
top
Method setError
QueryResult::setError() in QueryResult.inc
Sets the error message
Method setMOTD
CompDB::setMOTD() in CompDB.inc
Method setStatus
CompDB::setStatus() in CompDB.inc
Method startTransaction
Start an extended transaction block Turn off auto-commit and begin an extended transaction block with the given isolation level.
Method StatsDB
StatsDB::StatsDB() in StatsDB.inc
***********************************************************
Class StatsDB
StatsDB in StatsDB.inc
************************************************************
t
top
Page Team_DB.inc
Team_DB.inc in Team_DB.inc
Method Team_DB
Team_DB::Team_DB() in Team_DB.inc
Team_DB Constructor.
Class Team_DB
Team_DB in Team_DB.inc
Team Module Database API.
u
top
Variable $user
DB::$user in DB.inc
a b c d e g h l m n p q r s t u