SHOW:
|
|
- or go back to the newest paste.
| 1 | - | function integrate_external_app() |
| 1 | + | function integrate_login_external_db($user, $hashed_pwd, $cookietime) |
| 2 | {
| |
| 3 | - | $user = fetch_user_from_external_app(); |
| 3 | + | $db = database(); |
| 4 | - | if ($user->isNotGuest()) |
| 4 | + | $request = $db->query('', '
|
| 5 | SELECT username, playername, guid | |
| 6 | - | create_or_update_user_in_forum_db(); |
| 6 | + | FROM the_members_table |
| 7 | - | return $user->id; |
| 7 | + | WHERE username = {string:username}
|
| 8 | LIMIT 1' | |
| 9 | - | else |
| 9 | + | array( |
| 10 | 'username' => $user, | |
| 11 | - | return 0; |
| 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 | } |