emanuele

General idea behind login integration

Dec 25th, 2014
164
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function integrate_login_external_db($user, $hashed_pwd, $cookietime)
  2. {
  3.     $db = database();
  4.     $request = $db->query('', '
  5.         SELECT username, playername, guid
  6.         FROM the_members_table
  7.         WHERE username = {string:username}
  8.         LIMIT 1'
  9.         array(
  10.             'username' => $user,
  11.         )
  12.     );
  13.     if ($db->num_rows($request) != 1)
  14.         return 'retry';
  15.  
  16.     $user = $db->fetch_assoc($request);
  17.     $db->free_result($request);
  18.  
  19.     $request = $db->query('', '
  20.         SELECT id_member
  21.         FROM {db_prefix}members
  22.         WHERE id_member = {int:current_member}',
  23.         array(
  24.             'current_member' => $user['guid'],
  25.         )
  26.     );
  27.  
  28.     // Members doesn't exist yet
  29.     if ($db->num_rows($request) == 0)
  30.     {
  31.         // create the user (I'm in a hurry now and I don't have time to write the code)
  32.     }
  33.  
  34.     return '';
  35. }
Advertisement
Add Comment
Please, Sign In to add comment