✏️ Edit: usermanager.php
Path:
/home/thiqat5/admincrud.thiqatech.com/sql/lib/usermanager.php
Size: 2.11 KB · Modified: 2023-08-20 10:31:19 · Perm: 0644 · Writable
← Back to directory
👁 View
⬇ Download
<?php /** * This file is a part of MyWebSQL package * library classes to manage mysql users and permissions * * @file: lib/usermanager.php * @author Ovais Tariq <http://ovaistariq.net> * @maintainer Samnan ur Rehman * @copyright (c) 2008-2014 Samnan ur Rehman * @web http://mywebsql.net * @license http://mywebsql.net/license */ include_once 'privileges.php'; include_once 'user.php'; class UserManager { protected $db; protected $legacy; public function __construct( $db, $legacy = false ) { $this->db = $db; $this->legacy = (bool)$legacy; User::setDb( $this->db ); } public function getUser($userName, $host = '%') { $user = User::factory( $this->legacy ); $user->userName = $userName; $user->host = $host; return $user; } public function add($userName, $host = '%', $password = '', $native = false) { $user = User::factory( $this->legacy ); $user->userName = $userName; $user->host = $host; $user->password = $password; return $user->add($native); } public function update($currUsername, $currHost, $newUsername, $newHost) { $user = User::factory( $this->legacy ); $user->userName = $currUsername; $user->host = $currHost; return $user->update( $newUsername, $newHost ); } public function updatePassword($userName, $host, $newPassword, $native = false) { $user = User::factory( $this->legacy ); $user->userName = $userName; $user->host = $host; return $user->updatePassword( $newPassword, $native ); } public function delete($userName, $host) { $user = User::factory( $this->legacy ); $user->userName = $userName; $user->host = $host; return $user->delete(); } public function getUsersList() { $tblName = Privileges::$privilegesTable; $sql = "SELECT `User`, `Host` FROM $tblName ORDER BY `User`, `Host`"; if( false == $this->db->query( $sql ) ) return array(); $users = array(); while( $row = $this->db->fetchRow() ) { $user = User::factory( $this->legacy ); $user->userName = $row['User']; $user->host = $row['Host']; $user->password = ''; $users[] = $user; } return $users; } }
💾 Save
Cancel
Save as UTF-8, newlines normalized to LF