Odessa Content Sharing  





  Register now   Forgot password ?

Importing users from IPB

Php Exam Script Business (Paid version) : Importing users from IPB

You can import your existing users by editing "v_imported_users" view . Also , you can write your own hashing algorithm for password checking by editing "Imported_Users_Password_Hash" method that in "config.php" file.

 

Structure of v_imported_users view .

 

UserID = unique id of your user . Be sure , that they are not same as local "users" table . If they are same , you can change it by editing autoincrement of local "users" table .

Name = Name of user

Surname = Surname of user

UserName = Login of user

Password = Password of user

email = Email of user

branch_id = id from "branches" table

group_id = id from "user_groups" table

 

Here are the some examples of importing users from other systems

Here is the example of importing users from   Invision Power Board .   (Tested with version 3.4.5).

 

1)Execute the following lines of code in your MySQL database :

 

CREATE OR REPLACE VIEW v_imported_users

AS

SELECT

                                member_id AS UserID,

                                members_display_name AS `Name`,

                                '' AS `Surname`,

                                members_l_username AS `UserName`,

                                CONCAT(members_pass_hash, '[sep]', members_pass_salt) AS `Password`,

                                email AS `email`,

                                1 AS branch_id,

                                1 AS group_id,

                                'nophoto.jpg' as user_photo

FROM `ipb`.`members`

WHERE (`ipb`.`members`.`member_group_id` NOT IN (1, 5))

 

2)Change Imported_Users_Password_Hash method in config.php file of els PHP Web Quiz as below :

 

  function Imported_Users_Password_Hash($entered_password,$password_from_db)

  {

                      $password_details = explode('[sep]', $password_from_db);

                      $hashed_password = $password_details[0];

                      $salt = $password_details[1];

 

                    return md5( md5( $salt ) . md5( $entered_password ) )."[sep]".$salt;

  }


Installation
Php Web Quiz Business (Paid version) : How to install

Menu management
Php Exam Script Business (Paid version) :Menu management

Access management : Branches
Php Exam Script Business (Paid version) : Access management : Branches

Access management : Roles
Php Exam Script Business (Paid version) : Access management : Roles

Access management : Users
Php Exam Script Business (Paid version) : Access management : Users

Access management : Restoring password
Php Exam Script Business (Paid version) : Access management : Restoring password

Questions : Categories
Php Exam Script Business (Paid version) : Questions : Categories

Questions : Quizzes
Php Exam Script Business (Paid version) : Questions : Quizzes

Questions : Question management
Php Exam Script Business (Paid version) : Questions : Question management

Exams : Create Exam
Php Exam Script Business (Paid version) : Exams : Create Exam

Exams : Manage Exams
Php Exam Script Business (Paid version) : Exams : Manage Exams

Exams : Starting Exam
Php Exam Script Business (Paid version) : Exams : Starting Exam

Exams : Point calculation
Php Exam Script Business (Paid version) : Exams : Point calculation

Importing users from Wordpress
Php Exam Script Business (Paid version) : Importing users from Wordpress

Importing users from IPB
Php Exam Script Business (Paid version) : Importing users from IPB

Using mathematical symbols
Php Exam Script Business (Paid version) : Using mathematical symbols

Mail configuration
Php Exam Script Business (Paid version) : Mail configuration

Certificates
Php Exam Script Business (Paid version) : Certificates

Localization
Php Exam Script Business (Paid version) : Localization

API For importing questions
Php Exam Script Business (Paid version) : API For importing questions

Integration with facebook
Php Exam Script Business (Paid version) : Integration with facebook

Using Jing (Easy image adding)
Php Exam Script Business (Paid version) : Using Jing (Easy image adding)

Email templates
Php Exam Script Business (Paid version) : Email templates

Exam results templates
Php Exam Script Business (Paid version) : Exam results templates

Backend events
Php Exam Script Business (Paid version) : Backend events

Integration with LDAP
Php Exam Script Business (Paid version) : Integration with LDAP

Integration with Paypal
Php Exam Script Business (Paid version) : Receiving payments with Paypal

Integration with other payment systems
Php Exam Script Business (Paid version) : Integration with other payment systems

Helpdesk Management System
Php Exam Script Business (Paid version) : Helpdesk Management System