x-tools / xtools

     * @param string $usernameOrIp The username or IP address.

     * @return integer The user's ID.

     */

    public function getUserId($usernameOrIp)

    {

        $userTable = $this->labsHelper->getTable('user');

        $sql = "SELECT user_id FROM $userTable WHERE user_name = :username LIMIT 1";

        $resultQuery = $this->replicas->prepare($sql);

        $resultQuery->bindParam("username", $usernameOrIp);

        $resultQuery->execute();

        $userId = (int)$resultQuery->fetchColumn();

        return $userId;

    }

    /**

     * Get total edit counts for the top 10 projects for this user.

     * @param string $username The username to find.

     * @return int

     */

    public function getId($databaseName, $username)

    {

        $userTable = $this->getTableName($databaseName, 'user');

        $sql = "SELECT user_id FROM $userTable WHERE user_name = :username LIMIT 1";

        $resultQuery = $this->projectsConnection->prepare($sql);

        $resultQuery->bindParam("username", $username);

        $resultQuery->execute();

        $userId = (int)$resultQuery->fetchColumn();

        return $userId;

    }

}