Sponsorenverwaltung - Team StarCraft e.V.
 All Data Structures Files Functions Variables
db.php File Reference

Holds two global arrays ($db, $dbBack) containing the names of all of the tables in the datebase. More...

Go to the source code of this file.

Variables

 $db
 holds the names of sponsoring and usercake tables More...
 
 $dbBackup
 holds the names of the sponsoring backup tables More...
 

Detailed Description

Holds two global arrays ($db, $dbBack) containing the names of all of the tables in the datebase.

Holds two global arrays ($db, $dbBack) containing the names of all of the tables in the datebase. These arrays are used in the vast majority of SQL-statements.

This file depends on inc/mysql.php.

Version
1.0.0
Author
Daniel Seichter

Definition in file db.php.

Variable Documentation

$db
Initial value:
= array(
'configuration' => MYSQL_PREFIX_USERCAKE.'configuration',
'pages' => MYSQL_PREFIX_USERCAKE.'pages',
'permissions' => MYSQL_PREFIX_USERCAKE.'permissions',
'users' => MYSQL_PREFIX_USERCAKE.'users',
'user_permission' => MYSQL_PREFIX_USERCAKE.'user_permission_matches',
'car' => MYSQL_PREFIX.'car',
'category' => MYSQL_PREFIX.'category',
'contact_person' => MYSQL_PREFIX.'contact_person',
'production_facility' => MYSQL_PREFIX.'production_facility',
'sc_attachment' => MYSQL_PREFIX.'sc_attachment',
'sc_event' => MYSQL_PREFIX.'sc_event',
'sc_financial_donation' => MYSQL_PREFIX.'sc_financial_donation',
'sc_material_donation' => MYSQL_PREFIX.'sc_material_donation',
'sc_produced_part' => MYSQL_PREFIX.'sc_produced_part',
'sponsor' => MYSQL_PREFIX.'sponsor',
'sponsor_car' => MYSQL_PREFIX.'sponsor_car',
'sp_production_facility' => MYSQL_PREFIX.'sp_production_facility',
'status' => MYSQL_PREFIX.'status')

holds the names of sponsoring and usercake tables

Definition at line 23 of file db.php.

Referenced by accessGranted(), addCar(), addCategory(), addPermission(), addProductionFacility(), addSponsor(), addSponsorCar(), addSponsorCarAttachment(), addSponsorCarEvent(), addSponsorCarFinancialDonation(), addSponsorCarMaterialDonation(), addSponsorCarProducedPart(), addSponsorContactPerson(), addSponsorProductionFacility(), addStatus(), LoggedInUser\checkPermission(), contactPersonExists(), createPages(), createPermission(), deleteCar(), deleteCategory(), deletePages(), deletePermission(), deleteProductionFacility(), deleteSponsor(), deleteSponsorCar(), deleteSponsorCarAttachment(), deleteSponsorCarEvent(), deleteSponsorCarFinancialDonation(), deleteSponsorCarMaterialDonation(), deleteSponsorCarProducedPart(), deleteSponsorContactPerson(), deleteSponsorProductionFacility(), deleteStatus(), deleteUsers(), deleteUsersPermanently(), emailExists(), emailUsernameLinked(), fetchAllCars(), fetchAllCategories(), fetchAllMatches(), fetchAllPages(), fetchAllPermissions(), fetchAllProductionFacilities(), fetchAllSponsors(), fetchAllSponsorsWithDeletedCars(), fetchAllStatus(), fetchAllUsers(), fetchCarDetails(), fetchCategoryDetails(), fetchContactPersonDetailsForVCard(), fetchContactPersonsWithMailAdresses(), fetchMailAdresses(), fetchMailAdressesNewsletter(), fetchPageDetails(), fetchPageIdForName(), fetchPermissionDetails(), fetchPermissionUsers(), fetchPossibleNewSponsorCars(), fetchProductionFacilityDetails(), fetchSponsorAddresses(), fetchSponsorCarAttachments(), fetchSponsorCarDetails(), fetchSponsorCarEvents(), fetchSponsorCarFinancialDonations(), fetchSponsorCarMaterialDonation(), fetchSponsorCarNames(), fetchSponsorCarProducedParts(), fetchSponsorContactPersons(), fetchSponsorDetails(), fetchSponsorEditDataForEditSections(), fetchSponsorLatestEditData(), fetchSponsorMailNewsletter(), fetchSponsorProductionFacilities(), fetchStatusDetails(), fetchUserDetails(), fetchUsername(), fetchUserPermissions(), flagPassword(), getLastActivity(), getStoredSession(), getTableNameForEditSection(), getTableRowLock(), hasOnetimePassword(), hasOnetimePasswordExpired(), hasValidMail(), isAdministrator(), isCarLocked(), isCategoryLocked(), isProductionFacilityLocked(), isStatusLocked(), isUserAdministrator(), isUserLoggedIn(), lockCar(), lockCategory(), lockProductionFacility(), lockStatus(), lockTableRow(), mobileExists(), pageIdExists(), permissionIdExists(), permissionNameExists(), removePermission(), renewCarLock(), renewCategoryLock(), renewProductionFacilityLock(), renewStatusLock(), resetStoredSession(), resetValidMail(), searchDatabase(), sessionIdExists(), setMailValid(), LoggedInUser\setStoredSession(), setUserActive(), setUserIDIncrement(), setUserLocked(), setValidMail(), LoggedInUser\signupTimeStamp(), unlockCar(), unlockCategory(), unlockProductionFacility(), unlockStatus(), updateCar(), updateCategory(), LoggedInUser\updateEmail(), updateEmail(), updateFirstname(), updateLastActivationRequest(), LoggedInUser\updateLastActivity(), updateLastname(), updateMailConfirmationToken(), updateMobile(), updatePageState(), LoggedInUser\updatePassword(), updatePasswordFromToken(), updatePermissionName(), updateProductionFacility(), updateSponsorCarAttachments(), updateSponsorCarDetails(), updateSponsorCarEvents(), updateSponsorCarFinancialDonations(), updateSponsorCarMaterialDonations(), updateSponsorCarProducedParts(), updateSponsorContactPersons(), updateSponsorDetails(), updateSponsorProductionFacilities(), updateStatus(), updateTitle(), updateUsername(), User\userCakeAddUser(), userIdExists(), usernameExists(), and validateActivationToken().

$dbBackup
Initial value:
= array(
'car' => MYSQL_PREFIX_BACKUP.'car',
'category' => MYSQL_PREFIX_BACKUP.'category',
'contact_person' => MYSQL_PREFIX_BACKUP.'contact_person',
'production_facility' => MYSQL_PREFIX_BACKUP.'production_facility',
'sc_attachment' => MYSQL_PREFIX_BACKUP.'sc_attachment',
'sc_event' => MYSQL_PREFIX_BACKUP.'sc_event',
'sc_financial_donation' => MYSQL_PREFIX_BACKUP.'sc_financial_donation',
'sc_material_donation' => MYSQL_PREFIX_BACKUP.'sc_material_donation',
'sc_produced_part' => MYSQL_PREFIX_BACKUP.'sc_produced_part',
'sponsor' => MYSQL_PREFIX_BACKUP.'sponsor',
'sponsor_car' => MYSQL_PREFIX_BACKUP.'sponsor_car',
'sp_production_facility' => MYSQL_PREFIX_BACKUP.'sp_production_facility',
'status' => MYSQL_PREFIX_BACKUP.'status')

holds the names of the sponsoring backup tables

Definition at line 44 of file db.php.

Referenced by countUserReferences(), deleteSponsorCarPermanently(), deleteSponsorPermanently(), fetchAllDeletedSponsorCarsForSponsor(), fetchAllDeletedSponsors(), fetchAllSponsorsWithDeletedCars(), fetchDeletedSponsorCars(), fetchSponsorEditDataForEditSections(), fetchSponsorLatestEditData(), and isSponsorDeleted().