View difference between Paste ID: NbyAcBgx and vSC5bf4q
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
}