// include_once '/home/bubblebox/funny-games.biz/htdocs/newfg/includes/configuration/inc_cfg_main.php';
include_once '/home/bubblebox/funny-games.biz/htdocs/newfg/includes/library/inc_lib_category_basic.php';
include_once '/home/bubblebox/funny-games.biz/htdocs/newfg/includes/function/inc_fun_db_query.php';
Foreach ($lib_category as $key=>$value) {
$arr = db_query("
SELECT
count(id_row) as num
FROM
fg_bookmark
WHERE
id_user = '" .$userId . "'
and
id_sort = '" . $key . "'
", 1);
echo "
(" . $arr['num'] . ") ";
} // end foreach..
if (empty($_GET['id_sort'])) {
$id_sort = 1;
} else {
$id_sort = $_GET['id_sort'];
} // end if..
?>
if ($id_sort < 5 and $id_sort <> 3 ) {
$result = db_query("
SELECT
A.id_row,
A.id_content,
B.file_name,
B.name_img,
B.name,
B.title
FROM
fg_bookmark as A
INNER JOIN
fg_content_" . $lib_category_key_inverse[$id_sort] . " as B
ON
B.id_row = A.id_content
WHERE
A.id_sort = '" . $id_sort . "'
and
A.id_user = '" . $userId . "'
");
While ($arr = mysqli_fetch_array($result)) {
if ($id_sort == 4) {
$arr['name_img'] = 'cartoon/' . $arr['name_img'];
$arr['file_name'] = 'cartoon/' . $arr['file_name'];
} // end if..
if ($id_sort == 1 or $id_sort == 2) {
$arr['name_img'] = 'game/' . $arr['name_img'];
} // end if..
echo "
";
} // end while..
} // end if..
/*if ($id_sort == 3 ) {
$result = db_query("
SELECT
A.id_row,
A.id_content,
B.title,
B.id_images,
B.shot_description
FROM
fg_bookmark as A
INNER JOIN
fg_content_full_game as B
ON
B.id_row = A.id_content
WHERE
A.id_sort = 3
and
A.id_user = '" . $userId. "'
");
if (mysql_num_rows($result) == 0) {
echo "
No bookmarks |
";
} // end if..
include_once '/home/bubblebox/funny-games.biz/htdocs/newfgfg/function/inc_fun_url_full_game.php';
include_once '/home/bubblebox/funny-games.biz/htdocs/newfgfg/function/inc_konvert_name_on_url.php';
While ($arr = mysqli_fetch_array($result)) {
echo "
 |
" . $arr['title'] . "
" . $arr['shot_description'] . "
| "; ?>
'>
|
} // end while..
} // end if..
*/
if ($id_sort == 5) {
$result = db_query("
SELECT
A.id_row,
A.id_content,
B.file_name,
B.page_name,
B.name,
B.title
FROM
fg_bookmark as A
INNER JOIN
fg_content_" . $lib_category_key_inverse[$id_sort] . " as B
ON
B.id_row = A.id_content
WHERE
A.id_sort = '" . $id_sort . "'
and
A.id_user = '" . $userId . "'
");
While ($arr = mysqli_fetch_array($result)) {
$temp_arr = explode(".", $arr['file_name']);
$arr['name_img'] = 'video/' . $arr['id_content'] . '-' . $temp_arr[0] . '.jpg';
$arr['file_name'] = 'videos/' . $arr['id_content'] . '-' . $arr['page_name'];
echo "
";
} // end while..
} // end if..
if ($id_sort == 6) {
$result = db_query("
SELECT
A.id_row,
A.id_content,
B.file_name,
B.page_name,
B.name,
B.title,
C.file_name as category_file_name
FROM
fg_bookmark as A
INNER JOIN
fg_content_" . $lib_category_key_inverse[$id_sort] . " as B
ON
B.id_row = A.id_content
LEFT JOIN
fg_category as C
ON
B.id_category = C.id_row
WHERE
A.id_sort = '" . $id_sort . "'
and
A.id_user = '" . $userId . "'
");
if (mysql_num_rows($result) == 0) {
echo "
No bookmarks |
";
} // end if..
While ($arr = mysqli_fetch_array($result)) {
echo "
";
$arr_temp = explode("-", $arr['category_file_name']);
// $arr['name_img'] = 'http://www.funny-games.biz/pictures/' . $arr_temp[0] . '/thumbs/' . $arr['file_name'] . '.jpg';
$arr['name_img'] = 'picture/' . $arr['id_content'] . '-' . $arr['file_name']. '.jpg';
$arr['file_name'] = 'pictures/' . $arr['id_content'] . '-' . $arr['page_name'];
echo "
 |
";
echo"
" . $arr['name'] . "
" . $arr['title'] . "
| "; ?>
'>
|
} // end while..
} // end if..
if ($id_sort == 7) {
$result = db_query("
SELECT
A.id_row,
A.id_content,
B.file_name,
B.name,
B.title
FROM
fg_bookmark as A
INNER JOIN
fg_content_" . $lib_category_key_inverse[$id_sort] . " as B
ON
B.id_row = A.id_content
WHERE
A.id_sort = '" . $id_sort . "'
and
A.id_user = '" . $userId . "'
");
if (mysql_num_rows($result) == 0) {
echo "
No bookmarks |
";
} // end if..
While ($arr = mysqli_fetch_array($result)) {
echo "
" . $arr['name'] . "
" . $arr['title'] . "
| "; ?>
'>
|
} // end while..
} // end if..
?>