Public Member Functions | |
createNewUser ($pDb, $sFirstName, $sLastName, $sFieldOfStudy, $sEmail, $sPw) | |
deleteUser ($pDb, $sUserID) | |
changeUserPassword ($pDb, $sUserEmail, $sNewPw) | |
changeAdminPassword ($pDb, $sAdminName, $sNewPw) | |
createTrainingData ($pDb, $sUserID, $sPw) | |
getLoginData ($pDb, $sUserName) | |
getLoginDataById ($pDb, $sUserID) | |
setLastLoginDate ($pDb, $sUserName) | |
resetAllUserDb ($pDb) | |
buildUserTable ($pDb) | |
changeUserInfo ($pDb, $sUserID, $sFirstName, $sLastName, $sFieldOfStudy) | |
showActualDataUserDB ($pDb, $sUserID, $sPw) |
pgsqlcommands::createNewUser | ( | $ | pDb, | |
$ | sFirstName, | |||
$ | sLastName, | |||
$ | sFieldOfStudy, | |||
$ | sEmail, | |||
$ | sPw | |||
) |
Creates a new user.
$pDb | Pointer to database connection. | |
$sFirstName | First name of new user. | |
$sLastName | Last name of new user. | |
$sFieldOfStudy | Field of study of the new user. | |
$sEmail | E-mail address of the new user. | |
$sPw | Password of the new user. |
Implements iDatabaseCommands.
pgsqlcommands::deleteUser | ( | $ | pDb, | |
$ | sUserID | |||
) |
Delete a user.
$pDb | Pointer to database connection. | |
$sUserID | ID of the user to delete. |
Implements iDatabaseCommands.
pgsqlcommands::changeUserPassword | ( | $ | pDb, | |
$ | sUserEmail, | |||
$ | sNewPw | |||
) |
Change user password.
$pDb | Pointer to database connection. | |
$sUserEmail | E-mail address of the user which wants to change his password. | |
$sNewPw | New password. |
Implements iDatabaseCommands.
pgsqlcommands::changeAdminPassword | ( | $ | pDb, | |
$ | sAdminName, | |||
$ | sNewPw | |||
) |
Change administrator password.
$pDb | Pointer to database connection. | |
$sAdminName | Name of the administrator user. | |
$sNewPw | New password. |
Implements iDatabaseCommands.
pgsqlcommands::createTrainingData | ( | $ | pDb, | |
$ | sUserID, | |||
$ | sPw | |||
) |
Creates training data or resets user database to initial values.
$pDb | Pointer to database connection. | |
$sUserID | User ID. | |
$sPw | Password. |
Implements iDatabaseCommands.
pgsqlcommands::getLoginData | ( | $ | pDb, | |
$ | sUserName | |||
) |
Get login data by user name (e-mail address).
$pDb | Pointer to database connection. | |
$sUserName | User name (e-mail address). |
Implements iDatabaseCommands.
pgsqlcommands::getLoginDataById | ( | $ | pDb, | |
$ | sUserID | |||
) |
Get login data by user ID.
$pDb | Pointer to database connection. | |
$sUserID | User ID. |
Implements iDatabaseCommands.
pgsqlcommands::setLastLoginDate | ( | $ | pDb, | |
$ | sUserName | |||
) |
Set login date (format Y-M-D, e.g. 2007-10-14) of user (actual date used, according to server date).
$pDb | Pointer to database connection. | |
$sUserName | E-mail address of the user. |
Implements iDatabaseCommands.
pgsqlcommands::resetAllUserDb | ( | $ | pDb | ) |
Reset all user databases.
$pDb | Pointer to database connection. |
Implements iDatabaseCommands.
pgsqlcommands::buildUserTable | ( | $ | pDb | ) |
Build table for user administration.
$pDb | Pointer to database connection. |
Implements iDatabaseCommands.
pgsqlcommands::changeUserInfo | ( | $ | pDb, | |
$ | sUserID, | |||
$ | sFirstName, | |||
$ | sLastName, | |||
$ | sFieldOfStudy | |||
) |
Change user information.
$pDb | Pointer to database connection. | |
$sUserID | User ID. | |
$sFirstName | New first name. | |
$sLastName | New last name. | |
$sFieldOfStudy | New field of study. |
Implements iDatabaseCommands.
pgsqlcommands::showActualDataUserDB | ( | $ | pDb, | |
$ | sUserID, | |||
$ | sPw | |||
) |
Builds table which shows the actual data in the database.
$pDb | Pointer to database connection. | |
$sUserID | User ID. | |
$sPw | Password. |
Implements iDatabaseCommands.