<?php
// Benötigte Dateien und Variablen von phpBB
define('IN_PHPBB', true);
$phpbb_root_path = './';
$phpEx = substr(strrchr(__FILE__, '.'), 1);
include($phpbb_root_path . 'common.' . $phpEx);
// Da wir weiter unten noch einen Avatar anzeigen lassen wollen,
// benötigen wir noch die dazu passende Funktion
// die in der Datein includes/functions_display.php vorhanden ist.
include($phpbb_root_path . 'includes/functions_display.' . $phpEx);
// Session auslesen und Benutzer-Informationen laden
$user->session_begin(); // Session auslesen
$auth->acl($user->data); // Benutzer-Informationen laden
$user->setup('mods/meine_sprach_datei'); // Sprachvariablen aus eigener Sprach Datei laden
//FAV1URL
$sql = 'SELECT fav_url1 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('fav1url', array(
'FAV_URL1' => $row['fav_url1'],
));
}
$db->sql_freeresult($result);
//FAV2URL
$sql = 'SELECT fav_url2 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('fav2url', array(
'FAV_URL2' => $row['fav_url2'],
));
}
$db->sql_freeresult($result);
//FAV3URL
$sql = 'SELECT fav_url3 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('fav3url', array(
'FAV_URL3' => $row['fav_url3'],
));
}
$db->sql_freeresult($result);
//FAV4URL
$sql = 'SELECT fav_url4 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('fav4url', array(
'FAV_URL4' => $row['fav_url4'],
));
}
$db->sql_freeresult($result);
//FAV5URL
$sql = 'SELECT fav_url5 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('fav5url', array(
'FAV_URL5' => $row['fav_url5'],
));
}
$db->sql_freeresult($result);
//FAV6URL
$sql = 'SELECT fav_url6 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('fav6url', array(
'FAV_URL6' => $row['fav_url6'],
));
}
$db->sql_freeresult($result);
//FAV1ID
$sql = 'SELECT fav_id1 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('forumname1', array(
'FORUMNAME1' => $row['fav_id1'],
));
}
$db->sql_freeresult($result);
//FAV2ID
$sql = 'SELECT fav_id2 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('forumname2', array(
'FORUMNAME2' => $row['fav_id2'],
));
}
$db->sql_freeresult($result);
//FAV3ID
$sql = 'SELECT fav_id3 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('forumname3', array(
'FORUMNAME3' => $row['fav_id3'],
));
}
$db->sql_freeresult($result);
//FAV4ID
$sql = 'SELECT fav_id4 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('forumname4', array(
'FORUMNAME4' => $row['fav_id4'],
));
}
$db->sql_freeresult($result);
//FAV5ID
$sql = 'SELECT fav_id5 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('forumname5', array(
'FORUMNAME5' => $row['fav_id5'],
));
}
$db->sql_freeresult($result);
//FAV6ID
$sql = 'SELECT fav_id6 FROM ' . USERS_TABLE . " WHERE user_id = '" . $user->data['user_id'] . "';";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result))
{
$template->assign_block_vars('forumname6', array(
'FORUMNAME6' => $row['fav_id6'],
));
}
$db->sql_freeresult($result);
?>