How to integrate AdAdmin with another existing application

[giuliopons]

[giuliopons]

You have your own application, with your users.
You want to allow your users to login into AdAdmin installation, without forcing them to sign up and login to AdAdmin.

---

First of all you have to create a record in table frw_utenti for each user of your system that you want to login into AdAdmin.
This are table information:

• id = auto increment user id integer
• username = the username
• password = the password encrypted with AdAdmin custom function
• nome = name of the user
• cognome = surname of the user
• fl_attivo = status of the user: active = 1 | deactivated = 0
• cd_profilo = the user level profile: 5 = advertiser | 10 = webmaster | 20 = administrator

You don't need to use AdAdmin custom encryption password, since with your custom login you don't need to use this password field to login the user!

For each user create a record and store the "id" in your own user table.

Now let's see how to perform login.

Since v.3.995 (#48) there is a new file inside your AdAdmin folders, this one:
/amb/src/_include/login-custom.class-example.php

This PHP class isn't included, so it's not used and contains a template code to add your own login system.

• Rename this class to prevent future update overwrites, for example: /amb/src/_include/login-custom.class.php
• Open your pons.settings.php file go to the end of that file and uncomment the DEFINE constant that points to the class, if the define isn't present, you can copy and paste to add it at the end of the file:
  define("CUSTOM_LOGIN_CLASS", "/amb/src/_include/login-custom.class.php");
• Now open the file and modify the isLogged() method of the class to make your own login.

This is how the process works:

1. from your application send the user to /amb/src/login.php file, with user and pass values in _POST
2. login.php now looks for login-custom.class.php, if it exists initialize the class and call the isLogged() method
3. inside the isLogged() method you can use user and pass sent to login.php, for example select the user from your own user table using this user and pass values
4. your own user table MUST have a relation with the frw_utenti table, storing the id of frw_utenti which corresponds to the user of your own user table
5. inside the isLogged() method you have to grab that id from db and pass it to the saveUserSession() method which logs you in.

---

This is an example of custom login class isLogged method:

function isLogged() {
	global $session,$logger,$conn;
	if (!defined('WEBDOMAIN')) return false;

	if ( $session->get("username")!="") {
		// user already logged in session
		return true;

	} else {

		//
		// add your login logic here
		//
		// ----------------------------------------------------------------------
		$username = isset($_POST['user']) ? $_POST['user'] : "";
		$password = isset($_POST['pass']) ? $_POST['pass'] : "";
	        $stm = $conn->prepare("SELECT adadmin_id from MYUSERS WHERE username=? and password = ?");
		$stm->bind_param("ss",  $username, $password);
                    $id = 0;
                    if ($stm->execute()) {
                            $result = $stm->get_result();
                            if ($r = $result->fetch_assoc()) {
                            $id = $r["adadmin_id"];
                     }
		// ----------------------------------------------------------------------
 	        //
		// this method will login in the user
		if( $this->saveUserSession($id) ) {

			$logger->addlog( "{custom login, user session id #".$session->get("idutente")."}" );
			return true;
		} else {
			$logger->addlog( "{custom login failed for ".$username."}" );
			return false;
		}

	}
}