homehomemembers areafeaturespricingdemonstrationorder onlinesupportDevelopment Teamonline manualAlbinator Merchandisecontact us

 contents  FAQ's  Moving Servers
Manual ~ Albinator
go to the bottom close 
Search manual
> Integrating using exsiting user tables < 


Albinator can perfectly use the user tables of your current database (most of them). Also it can access any other cookies set by someother login system and recognize the user and let him/her in, thus avoiding the problem of re-logging.

Integrating the Login system

For the login procedure there are some requirements of cookies being set:

  • username
  • sessiontime
  • password (md5ied)

The names of the cookies do not matter but the content does. If your current logging system sets these cookies you can integrate Albinator with it, follow the simple steps below:

  • Open config.php
  • You will see sample settings under named vbulletin:

  • As you can see above, you need to copy/paste the setting under vBulletin heading.
  • Comment (Add //) in front of setting under Albinator Settings
  • Now remove the commets (Remove //) from the front of those you just copy/pasted.

Setting the options:

  • $integrate_db = true; : leave this as it is.
  • $integrate_known = 'SOME_NAME'; : Give this a unique name NOT vb!
  • $db_register_url = 'http://yoursite.com/register.php; : Path to your registeration page.
  • $fld_uid = "name"; : Name of the username field in your user_table
  • $fld_password = "name"; : Name of the password field in your user_table
  • $fld_session = "name"; : Name of the session field in your user_table
  • $tbl_user_alter = "name"; Name of the usertable you wish to use. (remember this table should in the same database as the one albinator is installed in.)
  • $cookiedomain = "name"; Optional additional to the cookie if you use the cookies specific to your domain.
  • $cookie_uid = "name"; : Name of the username cookie your logging system sets
  • $cookie_password = "name"; : Name of the password cookie your logging system sets
  • $cookie_session = "name"; : Name of the session cookie your logging system sets

Lastly, You need to set a cookie named uid with username in it from your login system for Albinator.
That's it! your login system should work with Albinator now.

Please Note: We have tested this with many databases and did not have any problems, but we can't assure you the working of it with your's.

 

Implicating changes to various user tables made via Albinator:

See there are two types of changes needed:

  • Once when the new user (not in albinator tables) comes to Albinator for the first time.
  • Changes made by user using the settings options, (password changes, email changes).

For these you need to do some manual work and would require some php knowledge:

Files needed to be edited:

  • user/settings.php
  • user/dbintegrate_disp.php
  • user/admin/usrmngt.php
  • essential/integrationfuncs.php
  • essential/integration.inc.php
  • essential/language/LANGCODE.admin.php

You can search for the following example which is already implemented:

if($integrate_db && $intergrate_known == "vb")

and add another below it, as:

else if($integrate_db && $intergrate_known == "YOUR_UNIQUE_NAME")

Remember the YOUR_UNIQUE_NAME is to be replaced with the value you entered for the $integrate_known variable above and place the code below it specific to your database.

e.g. the following code in login.php which gets user information:

$result = $DB_albinator->query( "SELECT userid,username,password FROM $tbl_user_alter WHERE username='".addslashes($uidform)."'" );

Therefore your query can look like:

$result = $DB_albinator->query( "SELECT $fld_uid, $fld_password FROM $tbl_user_alter WHERE $fld_uid='".addslashes($uidform)."'" );

 

Thats the most part of it, if you feel you need any help please mail us.

 

top of the page 
 << FAQ's
Manual version 2.0.7 updated 3/21/2004. Copyright © 2001-2008 Albinator. All rights reserved.

Copyright © 2001-2008 Albinator. All rights reserved.