Code: Selecteer alles
<?php
/***************************************************************************
* activity.php
* ----------------
* Version : 1.0.8
* Email : austin@austin-inc.net
* Site : http://phpbb-amod.com
* Copyright : aUsTiN-Inc 2003/4
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include_once($phpbb_root_path . 'extension.inc');
include_once($phpbb_root_path . 'common.'.$phpEx);
include_once($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_activity.' . $phpEx);
include_once($phpbb_root_path . 'includes/functions_amod_plus.'. $phpEx);
include_once($phpbb_root_path . 'includes/bbcode.'. $phpEx);
// Start session management
$userdata = session_pagestart($user_ip, PAGE_ACTIVITY);
init_userprefs($userdata);
// End session management
/* Start Version Check */
VersionCheck();
/* End Version Check */
$user_id = $userdata['user_id'];
if($board_config['ina_guest_play'] == "2")
{
if (!$userdata['session_logged_in'] && $user_id == ANONYMOUS)
{
$header_location = ( @preg_match("/Microsoft|WebSTAR|Xitami/", getenv("SERVER_SOFTWARE")) ) ? "Refresh: 0; URL=" : "Location: ";
header($header_location . append_sid("login.$phpEx?redirect=activity.$phpEx", true));
exit;
}
}
UpdateSessions();
BanCheck();
UpdateActivitySession();
$start = ( isset($HTTP_GET_VARS['start']) ) ? intval($HTTP_GET_VARS['start']) : 0;
$finish = $board_config['games_per_page'];
if($board_config['use_rewards_mod'])
{
if($board_config['use_point_system'])
{
include($phpbb_root_path .'includes/functions_points.'. $phpEx);
}
if($board_config['use_cash_system'] || $board_config['use_allowance_system'])
{
include($phpbb_root_path .'includes/rewards_api.'. $phpEx);
}
}
CheckGambles();
UpdateGamblePoints();
if($mode != "game")
{
UpdateUsersPage($userdata['user_id'], $_SERVER['REQUEST_URI']);
}
if (isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']))
{
$mode = (isset($HTTP_GET_VARS['mode'])) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
}
else
{
if( isset($HTTP_POST_VARS['game']) )
{
$mode = "game";
}
else if( isset($HTTP_POST_VARS['stats']) )
{
$mode = "stats";
}
else
{
$mode = "";
}
}
if($mode == "category_play" && !$HTTP_GET_VARS['cat'])
{
$template->set_filenames(array('body' => 'activity_cat_page_body.tpl') );
$q = "SELECT COUNT(game_id) AS total_games
FROM ". iNA_GAMES ."";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_games_here = $row['total_games'];
$q = "SELECT SUM(played) AS total_played
FROM ". iNA_GAMES ."";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_played = number_format($row['total_played']);
if(!$total_played) $total_played = 0;
$new_length = time() - 86400 * $board_config['ina_new_game_limit'];
$q = "SELECT COUNT(game_id) AS total_new
FROM ". iNA_GAMES ."
WHERE install_date > '". $new_length ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_new = $row['total_new'];
if(!$total_new) $total_new = 0;
$pop_limit = $board_config['ina_pop_game_limit'];
$q = "SELECT COUNT(game_id) AS total_popular
FROM ". iNA_GAMES ."
WHERE played > '". $pop_limit ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_pop = $row['total_popular'];
if(!$total_pop) $total_pop = 0;
$template->assign_block_vars("main_cats", array(
"TITLE_1" => $lang['main_cat_title_1'],
"TITLE_2" => $lang['main_cat_title_2'],
"TITLE_3" => $lang['main_cat_title_3'],
"TITLE_4" => $lang['main_cat_title_4'],
"TITLE_5" => $lang['main_cat_title_5'],
"TITLE_6" => $lang['main_cat_title_6'],
"T_GAMES_P" => $total_played,
"P_GAMES" => $total_pop,
"N_GAMES" => $total_new,
"GAMES" => $total_games_here,
"GAMES_T" => $board_config['sitename'] ."'s ". $lang['admin_games'],
"GAMES_D" => $lang['main_cat_all_desc'],
"GAMES_I" => "<a href='activity.". $phpEx ."?sid=". $userdata['session_id'] ."'><img src='". $board_config['ina_use_logo'] ."' border='0'></a>")
);
$q = "SELECT *
FROM ". INA_CATEGORY ."
WHERE cat_id > '0'";
$r = $db -> sql_query($q);
while($row = $db -> sql_fetchrow($r))
{
$cat_img = $row['cat_img'];
$cat_desc = $row['cat_desc'];
$cat_name = $row['cat_name'];
$cat_id = $row['cat_id'];
$q1 = "SELECT COUNT(game_id) AS total_games
FROM ". iNA_GAMES ."
WHERE cat_id = '". $cat_id ."'";
$r1 = $db -> sql_query($q1);
$row1 = $db -> sql_fetchrow($r1);
$total_games = $row1['total_games'];
$q2 = "SELECT SUM(played) AS total_played
FROM ". iNA_GAMES ."
WHERE cat_id = '". $cat_id ."'";
$r2 = $db -> sql_query($q2);
$row2 = $db -> sql_fetchrow($r2);
$total_played = number_format($row2['total_played']);
if(!$total_played) $total_played = 0;
$q3 = "SELECT COUNT(game_id) AS total_new
FROM ". iNA_GAMES ."
WHERE cat_id = '". $cat_id ."'
AND install_date > '". $new_length ."'";
$r3 = $db -> sql_query($q3);
$row3 = $db -> sql_fetchrow($r3);
$total_new = $row3['total_new'];
if(!$total_new) $total_new = 0;
$q4 = "SELECT COUNT(game_id) AS total_popular
FROM ". iNA_GAMES ."
WHERE cat_id = '". $cat_id ."'
AND played > '". $board_config['ina_pop_game_limit'] ."'";
$r4 = $db -> sql_query($q4);
$row4 = $db -> sql_fetchrow($r4);
$total_pop = $row4['total_popular'];
if(!$total_pop) $total_pop = 0;
if(!$cat_desc) $cat_desc = $lang['main_cat_no_desc'];
if(file_exists($cat_img) == 0)
{
$cat_img = "";
$cat_name = "<a href='activity.". $phpEx ."?mode=category_play&cat=". $cat_id ."&sid=". $userdata['session_id'] ."'>". $cat_name ."</a>";
}
else
{
$cat_img = "<a href='activity.". $phpEx ."?mode=category_play&cat=". $cat_id ."&sid=". $userdata['session_id'] ."'><img src='./". $cat_img ."' border='0'></a>";
$cat_name = $cat_name;
}
$template->assign_block_vars("main_cats_rows", array(
"ONE" => $cat_name ."<br>". $cat_img,
"TWO" => $cat_desc,
"THREE" => $total_games,
"FOUR" => $total_played,
"FIVE" => $total_new,
"SIX" => $total_pop)
);
}
}
else
{
$q = "SELECT game_id
FROM ". iNA_GAMES ."
WHERE disabled <> '0'
ORDER BY RAND()
LIMIT 1";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$random_game = append_sid("activity.". $phpEx ."?mode=game&id=". $row['game_id'] ."&parent=true");
$random_image = "images/amod_random.gif";
if($mode == "challenge")
{
$who = $_GET['user'];
$who_id = $_GET['user'];
$game = $_GET['game'];
if($who == $userdata['user_id'])
{
message_die(GENERAL_MESSAGE, $lang['challenge_self_error'], $lang['challenge_information']);
}
$returned = ChallengeSelected($who, $game);
$returned_data = explode("%RETURNED%", $returned);
$who = $returned_data[0];
$game = $returned_data[1];
$message_sent = $board_config['ina_challenge_msg'];
$message_sent = $who .", ". $message_sent;
$message_sent = str_replace("%n%", $userdata['username'], $message_sent);
$message_sent = str_replace("%g%", $game, $message_sent);
$top = $lang['pm_msg_top'];
$middle = "<br>------------------------------------------------------------------<br>";
$bottom = $lang['pm_msg_bottom'];
send_challenge_pm($who_id, $board_config['ina_challenge_sub'], $message_sent);
message_die(GENERAL_MESSAGE, $top . $middle . $message_sent . $middle . $bottom, "Information");
}
if(isset($HTTP_POST_VARS['order']))
{
$sort_order = ($HTTP_POST_VARS['order'] == 'DESC') ? 'DESC' : 'ASC';
}
elseif(isset($HTTP_GET_VARS['order']))
{
$sort_order = ($HTTP_GET_VARS['order'] == 'DESC') ? 'DESC' : 'ASC';
}
else
{
$sort_order = 'DESC';
}
if($board_config['use_point_system'])
{
$game_cost = $board_config['points_name'];
}
else
{
$game_cost = $lang['game_cost'];
}
if($board_config['use_rewards_mod'])
{
$mode_types_text = array($game_cost, $lang['game_bonuses'], $lang['game_played'], $lang['order_alphabetical'], $lang['sort_order_newest'], $lang['sort_order_oldest'], $lang['sort_order_reverse']);
$mode_types = array('game_charge', 'game_bonus', 'game_played', 'proper_name', 'install_dateN', 'install_dateO', 'reverse_list');
}
else
{
$mode_types_text = array($lang['game_played'], $lang['order_alphabetical'], $lang['sort_order_newest'], $lang['sort_order_oldest'], $lang['sort_order_reverse']);
$mode_types = array('game_played', 'proper_name', 'install_dateN', 'install_dateO', 'reverse_list');
}
$select_sort_mode = '<select name="mode">';
for($i = 0; $i < count($mode_types_text); $i++)
{
$selected = ( $mode == $mode_types[$i] ) ? ' selected="selected"' : '';
$select_sort_mode .= '<option value="' . $mode_types[$i] . '"' . $selected . '>' . $mode_types_text[$i] . '</option>';
}
$select_sort_mode .= '</select>';
$select_sort_order = '<select name="order">';
if($sort_order == 'DESC')
{
$select_sort_order .= '<option value="DESC" selected="selected">' . $lang['Sort_Descending'] . '</option><option value="ASC">' . $lang['Sort_Ascending'] . '</option>';
}
else
{
$select_sort_order .= '<option value="DESC">' . $lang['Sort_Descending'] . '</option><option value="ASC" selected="selected">' . $lang['Sort_Ascending'] . '</option>';
}
$select_sort_order .= '</select>';
$admin_d = AdminDefaultOrder();
switch($mode)
{
case 'install_dateN':
$order_by = "install_date DESC LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
case 'install_dateO':
$order_by = "proper_name ASC LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
case 'reverse_list':
$order_by = "reverse_list $sort_order LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
case 'proper_name':
$order_by = "proper_name $sort_order LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
case 'game_charge':
$order_by = "game_charge $sort_order LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
case 'game_bonus':
$order_by = "game_bonus $sort_order LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
case 'game_played':
$order_by = "played $sort_order LIMIT $start,". $board_config['games_per_page'];
$mode = "";
break;
default:
$order_by = "$admin_d LIMIT $start, ". $board_config['games_per_page'];
break;
}
$template->set_filenames(array('body' => 'activity2_body.tpl') );
$links = SetHeaderLinks();
$template->assign_block_vars("links_check", array(
"LINKS" => $links ." ::"));
/* Start Info Box */
if($userdata['user_level'] != ADMIN) $where_disabled = "WHERE disabled > '0'";
if($userdata['user_level'] == ADMIN) $where_disabled = "";
/* Get last trophy game played */
$q = "SELECT a.*, b.username
FROM ". INA_TROPHY ." a, ". USERS_TABLE ." b
WHERE a.player = b.user_id
ORDER BY a.date DESC
LIMIT 1";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$game = $row['game_name'];
$name = $row['player'];
$when = $row['date'];
$score = $row['score'];
$trophy = $row['username'];
if($name != ANONYMOUS)
{
$trophy_link = "<a href='". append_sid("profile.$phpEx?mode=viewprofile&u=$name") ."' class='nav'>". $trophy ."</a>";
}
else
{
$trophy_link = "Anonymous";
}
$q = "SELECT *
FROM ". iNA_GAMES ."
WHERE game_name = '". $game ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$t_game_id = $row['game_id'];
$t_game_name = $row['proper_name'];
/* Get total games played, most game played, least game played */
$q = "SELECT *
FROM ". iNA_GAMES ."
$where_disabled
ORDER BY played DESC
LIMIT 1";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$f_game_id = $row['game_id'];
$f_game_name = $row['proper_name'];
$f_game_played = $row['played'];
$q = "SELECT *
FROM ". iNA_GAMES ."
$where_disabled
ORDER BY played ASC
LIMIT 1";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$lf_game_id = $row['game_id'];
$lf_game_name = $row['proper_name'];
$lf_game_played = $row['played'];
$q = "SELECT SUM(played) AS total_games_played
FROM ". iNA_GAMES ."";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total = $row['total_games_played'];
$q = "SELECT COUNT(comment) AS total_comments_left
FROM ". $table_prefix ."ina_trophy_comments";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_comments = $row['total_comments_left'];
$q = "SELECT COUNT(game_id) AS total_games_available
FROM ". iNA_GAMES ."";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_games_available = $row['total_games_available'];
$q = "SELECT COUNT(game_id) AS total_bets_made
FROM ". $table_prefix ."ina_gamble";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_bets_made = $row['total_bets_made'];
$q = "SELECT SUM(count) AS total_challenges_sent
FROM ". $table_prefix ."ina_challenge_users";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_challenges_sent = $row['total_challenges_sent'];
$totals_lines = $lang['info_box_total_game_played'] ." ". number_format($total) ."<br>".
$lang['info_box_total_comments'] ." ". number_format($total_comments) ."<br>".
$lang['info_box_total_challenges'] ." ". number_format($total_challenges_sent) ."<br>".
$lang['info_box_total_bets'] ." ". number_format($total_bets_made) ."<br>".
$lang['info_box_total_gaems'] ." ". number_format($total_games_available) ."<br>";
$trophy_game_3 = str_replace("%l%", "<a href='". append_sid("activity.$phpEx?mode=game&id=$t_game_id&parent=true") ."' class='nav'>". $lang['info_box_link_here'] ."</a>", $lang['info_box_trophy_3']);
/* Info for the person with the most trophies */
$q = "SELECT *
FROM ". USERS_TABLE ."
ORDER BY user_trophies DESC
LIMIT 0, 1";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$usersname = $row['username'];
$usersid = $row['user_id'];
$userstrophies = $row['user_trophies'];
if($usersid != ANONYMOUS)
{
$top_player1 = str_replace("%n%", "<a href='". append_sid("profile.$phpEx?mode=viewprofile&u=$usersid") ."' class='nav'>". $usersname ."</a>", $lang['info_box_top_trophy_holder1']);
}
else
{
$top_player1 = str_replace("%n%", $usersname, $lang['info_box_top_trophy_holder1']);
}
$top_player2 = str_replace("%t%", "<a href='". append_sid("activity_top_scores_search.$phpEx?user=$usersname") ."' class='nav'>". $userstrophies ."</a>", $top_player1);
$top_player = $top_player2;
/* Get all the info for the viewing user */
$cpu_id = $userdata['user_id'];
$cpu_username = $userdata['username'];
$q = "SELECT *
FROM ". INA_LAST_GAME ."
WHERE user_id = '". $cpu_id ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$exists = $row['user_id'];
$game = $row['game_id'];
$when = $row['date'];
if($exists)
{
$q = "SELECT proper_name
FROM ". iNA_GAMES ."
WHERE game_id = '". $game ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$l_game_name = $row['proper_name'];
$last = str_replace("%g%", "<a href='". append_sid("activity.$phpEx?mode=game&id=$game&parent=true") ."' class='nav'>$l_game_name</a>", $lang['personal_info_last_game']);
$last2 = str_replace("%d%", create_date($board_config['default_dateformat'], $when, $board_config['board_timezone']), $last);
$template->assign_block_vars("personal_info_box", array(
"LAST_GAME_PLAYED" => "<b>¤</b> ". $last2)
);
}
$q = "SELECT COUNT(*) AS total
FROM ". iNA_SCORES ."
WHERE player = '". $userdata['username'] ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_scores = $row['total'];
if(!$total_scores) $total_scores == "0";
$q = "SELECT SUM(count) AS total
FROM ". INA_CHALLENGE_USERS ."
WHERE user_from = '". $userdata['user_id'] ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_challenges_sent = $row['total'];
if(!$total_challenges_sent) $total_challenges_sent == "0";
$q = "SELECT SUM(count) AS total
FROM ". INA_CHALLENGE_USERS ."
WHERE user_to = '". $userdata['user_id'] ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_challenges_recieved = $row['total'];
if(!$total_challenges_recieved) $total_challenges_recieved == "0";
$q = "SELECT COUNT(player) AS total
FROM ". INA_TROPHY_COMMENTS ."
WHERE player = '". $userdata['user_id'] ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$total_comments_left = $row['total'];
if(!$total_comments_left) $total_comments_left == "0";
if($userdata['user_id'] != ANONYMOUS) $users_link = "<a href='". append_sid("profile.$phpEx?mode=viewprofile&u=". $userdata['user_id']) ."' class='nav'>". $userdata['username'] ."</a>";
if($userdata['user_id'] == ANONYMOUS) $users_link = "Anonymous";
if($userdata['user_id'] != ANONYMOUS) $sent_link = "<b>¤</b> ". str_replace("%t%", "<a href='". append_sid("challenges.$phpEx?mode=check_user&u=". $userdata['user_id']) ."' class='nav'>". $total_challenges_sent ."</a>", $lang['personal_info_challenges_1']);
if($userdata['user_id'] == ANONYMOUS) $sent_link = "<b>¤</b> ". str_replace("%t%", $total_challenges_sent, $lang['personal_info_challenges_1']);
/* Select info for last game played */
$q = "SELECT a.game_id, a.user_id, a.date, b.username, c.proper_name
FROM ". INA_LAST_GAME ." a, ". USERS_TABLE ." b, ". iNA_GAMES ." c
WHERE a.user_id = b.user_id
AND c.game_id = a.game_id
ORDER BY a.date DESC
LIMIT 1";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$newest_game = $row['game_id'];
$newest_user = $row['user_id'];
$newest_date = $row['date'];
$newest_name = $row['username'];
$newest_game_name = $row['proper_name'];
$newlink = str_replace("%g%", "<a href='". append_sid("activity.$phpEx?mode=game&id=$newest_game&parent=true") ."' class='nav'>$newest_game_name</a>", $lang['personal_info_newest_game1']);
if($newest_user != ANONYMOUS)
{
$newlink2 = str_replace("%u%", "<a href='". append_sid("profile.$phpEx?mode=viewprofile&u=$newest_user") ."' class='nav'>$newest_name</a>", $newlink);
}
else
{
$newlink2 = str_replace("%u%", $newest_name, $newlink);
}
$newest_game_played_link = $newlink2;
$newest_game_played_title = $lang['personal_info_newest_game'];
if($userdata['user_trophies'] == 1)
{
$lang_to_use = $lang['personal_info_trophies_1'];
}
else
{
$lang_to_use = $lang['personal_info_trophies'];
}
if($total_scores == 1)
{
$game_lang = $lang['personal_info_game_played'];
}
else
{
$game_lang = $lang['personal_info_games_played'];
}
if($userdata['user_trophies'] > 0) $users_trophies = "<b>¤</b> ". str_replace("%t%", "<a href='". append_sid("activity_top_scores_search.$phpEx?user=". $userdata['username']) ."' class='nav'>". $userdata['user_trophies'] ."</a>", $lang_to_use);
if($userdata['user_trophies'] < 1) $users_trophies = "<b>¤</b> ". str_replace("%t%", $userdata['user_trophies'], $lang_to_use);
if($board_config['use_cash_system'] || $board_config['use_allowance_system']) $cash_fix = $board_config['default_reward_dbfield'];
if(($board_config['use_rewards_mod']) && ($board_config['use_point_system'])) $onhand = "<b>¤</b> ". str_replace("%p%", number_format($userdata['user_points']) ." ". $board_config['points_name'], $lang['info_box_user_points']);
if(($board_config['use_rewards_mod']) && ($board_config['use_cash_system'] || $board_config['use_allowance_system'])) $onhand = "<b>¤</b> ". str_replace("%p%", number_format($userdata[$cash_fix]) ." ". $board_config['ina_cash_name'], $lang['info_box_user_points']);
if(!$board_config['use_rewards_mod']) $onhand = "";
$template->assign_block_vars("info_box", array(
"MOST_POPULAR_1" => $lang['info_box_popular_1'] . $f_game_name .".",
"MOST_POPULAR_2" => " ". str_replace("%g%", $f_game_played, $lang['info_box_popular_2']),
"MOST_POPULAR_3" => " ". str_replace("%l%", "<a href='". append_sid("activity.$phpEx?mode=game&id=$f_game_id&parent=true") ."' class='nav''>". $lang['info_box_link_here'] ."</a>", $lang['info_box_least_popular_3']),
"LEAST_POPULAR_1" => $lang['info_box_least_popular_1'] . $lf_game_name .".",
"LEAST_POPULAR_2" => " ". str_replace("%g%", $lf_game_played, $lang['info_box_least_popular_2']),
"LEAST_POPULAR_3" => " ". str_replace("%l%", "<a href='". append_sid("activity.$phpEx?mode=game&id=$lf_game_id&parent=true") ."' class='nav'>". $lang['info_box_link_here'] ."</a>", $lang['info_box_least_popular_3']),
"TOTAL_GAMES_PLAYED" => $totals_lines,
"TROPHY_GAME" => $trophy_link,
"TROPHY_GAME_1" => $lang['info_box_trophy_1'],
"TROPHY_GAME_2" => str_replace("%g%", $t_game_name, $lang['info_box_trophy_2']),
"TROPHY_GAME_3" => $trophy_game_3,
"TROPHY_TOP_HOLDER1" => "<br>". $top_player,
"TROPHY_TOP_HOLDER" => $lang['info_box_top_trophy_holder'],
"USERNAME" => $users_link,
"TOTAL_GAMES_LINK" => "<b>¤</b> ". str_replace("%t%", "<a href='". append_sid("activity_highscores.$phpEx?mode=highscore&player_search=". $userdata['username']) ."' class='nav'>". $total_scores ."</a>", $game_lang),
"FAVORITES_LINK" => "<b>¤</b> <a href='activity_favs.". $phpEx ."?sid=". $userdata['session_id'] ."' class='mainmenu'>". $lang['favorites_info_link'] ."</a>",
"TOTAL_CHALLENGES_SENT" => $sent_link,
"TOTAL_CHALLENGES_RECIEVED" => "<b>¤</b> ". str_replace("%t%", $total_challenges_recieved, $lang['personal_info_challenges_2']),
"TOTAL_COMMENTS_LEFT" => "<b>¤</b> ". str_replace("%t%", $total_comments_left, $lang['personal_info_comments']),
"TOTAL_TROPHIES_HELD" => $users_trophies,
"LAST_GAME_PLAYED" => $newest_game_played_link,
"TOTAL_ONHAND_POINTS" => $onhand,
"L_NEWEST_TITLE" => $newest_game_played_title,
"L_INFO_TITLE" => $lang['info_box_title'],
"L_INFO_TITLE1" => $lang['info_box_title1'],
"L_INFO_TITLE2" => $lang['info_box_title2'],
"L_INFO_TITLE3" => $lang['info_box_title3'])
);
/* End Info Box */
if($mode == "game")
{
$game_id = (isset($HTTP_GET_VARS['id'])) ? intval($HTTP_GET_VARS['id']) : 0;
$cheat_var = time();
InsertPlayingGame($userdata['user_id'], $game_id);
/* Start insert starting game */
$sql = "SELECT user_id
FROM ". INA_CHEAT ."
WHERE player = '". $userdata['user_id'] ."'";
$result = $db -> sql_query($sql);
$row = $db -> sql_fetchrow($result);
$there = $row['user_id'];
if(!$there)
{
$sql = "INSERT INTO ". INA_CHEAT ."
VALUES ('". $game_id ."', '". $userdata['user_id'] ."')";
$result = $db -> sql_query($sql);
}
else
{
$sql = "UPDATE ". INA_CHEAT ."
SET game_id = '". $game_id ."'
WHERE player = '". $userdata['user_id'] ."'";
$result = $db -> sql_query($sql);
}
/* End insert starting game */
$sql = "SELECT user_id
FROM ". INA_LAST_GAME ."
WHERE user_id = '". $userdata['user_id'] ."'";
$result = $db -> sql_query($sql);
$row = $db -> sql_fetchrow($result);
$exists = $row['user_id'];
if(!$exists)
{
$sql = "INSERT INTO ". INA_LAST_GAME ."
VALUES ('". $game_id ."', '". $userdata['user_id'] ."', '". time() ."')";
$result = $db -> sql_query($sql);
}
else
{
$sql = "UPDATE ". INA_LAST_GAME ."
SET game_id = '". $game_id ."', date = '". time() ."'
WHERE user_id = '". $userdata['user_id'] ."'";
$result = $db -> sql_query($sql);
}
$sql = "SELECT *
FROM ". iNA_GAMES ."
WHERE game_id = '". $game_id ."'";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['no_game_data'], "", __LINE__, __FILE__, $sql);
}
$game_info = $db->sql_fetchrow($result);
if($_GET['parent']) $parent = "&parent=true";
$gamepath = 'game.php?id='. $game_id . $parent ."&x=". $cheat_var;
$game_charge = $game_info['game_charge'];
if($board_config['use_point_system'] && $board_config['use_rewards_mod'])
{
if ($userdata['user_points'] >= $game_charge)
{
subtract_points($user_id,$game_charge);
}
else
{
$gen_simple_header = TRUE;
message_die(GENERAL_MESSAGE, $lang['not_enough_points'], '', __LINE__, __FILE__, $sql);
}
}
if(($board_config['use_cash_system'] || $board_config['use_allowance_system']) && $board_config['use_rewards_mod'])
{
if (get_reward($user_id) >= $game_charge)
{
subtract_reward($user_id,$game_charge);
}
else
{
$gen_simple_header = TRUE;
message_die(GENERAL_MESSAGE, $lang['not_enough_reward'], '', __LINE__, __FILE__, $sql);
}
}
$sql = "UPDATE ". iNA_GAMES ."
SET played = played + '1'
WHERE game_id = '". $game_id ."'";
if (!$db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['no_game_update'], __LINE__, __FILE__, $sql);
}
$q = "UPDATE ". SESSIONS_TABLE ."
SET session_page = '". PAGE_PLAYING_GAMES ."'
WHERE session_user_id = '". $userdata['user_id'] ."'";
$r = $db -> sql_query($q);
$q = "UPDATE ". USERS_TABLE ."
SET user_session_page = '". PAGE_PLAYING_GAMES ."'
WHERE user_id = '". $userdata['user_id'] ."'";
$r = $db -> sql_query($q);
redirect(append_sid($gamepath, true));
}
elseif($mode == "stats")
{
$game_id = (isset($HTTP_GET_VARS['id'])) ? intval($HTTP_GET_VARS['id']) : 0;
$sql = "SELECT *
FROM ". iNA_GAMES ."
WHERE game_id = '". $game_id ."'";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['no_game_data'], "", __LINE__, __FILE__, $sql);
}
$game_info = $db->sql_fetchrow($result);
$sql = "SELECT *
FROM ". INA_CATEGORY ."
WHERE cat_id = '". $game_info['cat_id'] ."'";
$result = $db->sql_query($sql);
$cat_info = $db->sql_fetchrow($result);
if($game_info['reverse_list'])
{
$list_type = 'ASC';
}
else
{
$list_type = 'DESC';
}
$sql = "SELECT *
FROM ". iNA_SCORES ."
WHERE game_name = '". $game_info['game_name'] ."'
ORDER BY score $list_type";
if(!$result = $db->sql_query($sql))
{
message_die(GENERAL_ERROR, $lang['no_score_data'], "", __LINE__, __FILE__, $sql);
}
$score_info = $db->sql_fetchrow($result);
$best_score = $score_info['score'];
$best_player = $score_info['player'];
if($game_info['game_charge'])
{
$cost = $game_info['game_charge'] . " ";
}
else
{
$cost = $lang['game_free'];
}
if($board_config['use_point_system'] && ($game_info['game_charge'] > 0))
{
$cost .= $board_config['points_name'];
}
if($game_info['instructions'])
{
$instructions = $game_info['instructions'];
}
else
{
$instructions = $lang['game_no_instructions'];
}
$borrowed = $game_info['played'] * $game_info['game_charge'];
$template->set_filenames(array('body' => 'activity_stats.tpl') );
$template->assign_vars(array(
"L_TITLE" => $lang['info_page_title'],
"L_TITLE_2" => $lang['info_page_title_2'],
"L_PLAYED" => $lang['info_page_played'],
"L_PLAYER" => $lang['info_page_player'],
"L_COST" => $lang['info_page_cost'],
"L_SCORE" => $lang['info_page_score'],
"L_BONUS" => $lang['info_page_bonus'],
"L_CATEGORY" => $lang['info_page_category'],
"L_BORROWED" => $lang['info_page_borrowed'],
"NAME" => $game_info['game_name'],
"PATH" => $game_info['game_path'],
"DESC" => $game_info['game_desc'],
"PLAYED" => number_format($game_info['played']),
"COST" => number_format($cost),
"BORROWED" => number_format($borrowed),
"CATEGORY" => $cat_info['cat_name'],
"BONUS" => $game_info['game_bonus'],
"BEST_PLAYER" => $best_player,
"BEST_SCORE" => FormatScores($best_score),
"INSTRUCTIONS" => $instructions)
);
}
else
{
/* First Time Use, Transfer The Highest Scores To The New activity.php */
$q1 = "SELECT COUNT(*) AS total
FROM ". INA_TROPHY ."";
$r1 = $db -> sql_query($q1);
$row1 = $db -> sql_fetchrow($r1);
$game_n = $row1['total'];
if(!$game_n)
{
$q = "SELECT * , MAX(score) AS highest
FROM ". iNA_SCORES ."
GROUP BY game_name";
$r = $db -> sql_query($q);
while($row = $db -> sql_fetchrow($r))
{
$h_p = $row['player'];
$h_s = $row['highest'];
$h_g = $row['game_name'];
$h_t = time();
$q1 = "SELECT user_id
FROM ". USERS_TABLE ."
WHERE username = '". $h_p ."'";
$r1 = $db -> sql_query($q1);
$row1 = $db -> sql_fetchrow($r1);
$n_h_p = $row1['user_id'];
if(!$n_h_p) $n_h_p = $userdata['user_id'];
$q2 = "INSERT INTO ". INA_TROPHY ."
VALUES ('". $h_g ."', '". $n_h_p ."', '". $h_s ."', '". $h_t ."')";
$r2 = $db -> sql_query($q2);
}
}
/* Finished With First Time Use */
/* Fix For When Adding New Games, Them Not Appearing In The Games List */
$q = "SELECT *
FROM ". iNA_GAMES ."
WHERE played < '1'";
$r = $db -> sql_query($q);
while($row = $db -> sql_fetchrow($r))
{
$game_n = $row['game_name'];
$game_o = $row['reverse_list'];
if($game_o)
{
$New_score = '1000';
}
else
{
$New_score = '1';
}
$q1 = "INSERT INTO ". iNA_SCORES ."
VALUES ('". $game_n ."', '". $userdata['username'] ."', '". $New_score ."', '". time() ."')";
$r1 = $db -> sql_query($q1);
$q2 = "SELECT game_name
FROM ". INA_TROPHY ."
WHERE game_name = '". $game_n ."'";
$r2 = $db -> sql_query($q2);
$row = $db -> sql_fetchrow($r2);
$exists = $row['game_name'];
if(!$exists)
{
$q3 = "INSERT INTO ". INA_TROPHY ."
VALUES ('". $game_n ."', '". $userdata['user_id'] ."', '". $New_score ."', '". time() ."')";
$r3 = $db -> sql_query($q3);
}
$q4 = "UPDATE ". iNA_GAMES ."
SET played = '1'
WHERE game_name = '". $game_n ."'";
$r4 = $db -> sql_query($q4);
}
/* Finished With Adding New Games Bug. */
$template->set_filenames(array('body' => 'activity2_body.tpl') );
/* Start Whos In The Games */
if($board_config['ina_use_online'] == "1")
{
$expired = time() - 300;
$q = "SELECT COUNT(*) AS total
FROM ". INA_SESSIONS ."
WHERE playing = '0'
AND playing_time >= '". $expired ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$playing_guests = $row['total'];
if($playing_guests == "0")
{
$message3 = $lang['online_no_guests'];
$message4 = "";
$playing_guests = "";
}
elseif($playing_guests == "1")
{
$message3 = $lang['online_g_one_1'];
$message4 = $lang['online_g_one_2'];
}
else
{
$message3 = $lang['online_g_1'];
$message4 = $lang['online_g_2'];
}
$q = "SELECT COUNT(*) AS total
FROM ". INA_SESSIONS ."
WHERE playing = '1'
AND playing_time >= '". $expired ."'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$playing_members = $row['total'];
if($playing_members == "0")
{
$message1 = $lang['online_no_members'] ;
$message2 = "";
$playing_members = "";
}
elseif($playing_members == "1")
{
$message1 = $lang['online_m_one_1'];
$message2 = $lang['online_m_one_2'];
}
else
{
$message1 = $lang['online_m_1'];
$message2 = $lang['online_m_2'];
}
$q = "SELECT COUNT(*) AS total
FROM ". USERS_TABLE ."
WHERE ( user_session_page = ". PAGE_ACTIVITY ." OR user_session_page = ". PAGE_PLAYING_GAMES ." )
AND user_session_time >= '". $expired ."'
AND user_allow_viewonline = '0'";
$r = $db -> sql_query($q);
$row = $db -> sql_fetchrow($r);
$playing_hidden = $row['total'];
if($playing_hidden == "0")
{
$message5 = $lang['online_no_hidden'] ;
}
elseif($playing_hidden == "1")
{
$message5 = $lang['online_one_hidden'];
}
else
{
$message5 = str_replace("%n%", $playing_hidden, $lang['online_x_hidden']);
}
$template->assign_block_vars("playing_games", array(
"TOTAL_PLAYING" => $playing_total,
"TOTAL_M_PLAYING" => $playing_members,
"TOTAL_G_PLAYING" => $playing_guests,
"ONLINE_TITLE" => $lang['online_title_bar'],
"CURRENTLY_PLAYING1" => $message1,
"CURRENTLY_PLAYING2" => $message2,
"CURRENTLY_PLAYING3" => $message3,
"CURRENTLY_PLAYING4" => $message4 ."<br><a href='activity_whos_where.". $phpEx ."?sid=". $userdata['session_id'] ."' class='mainmenu'>". $lang['whos_where_link'] ."</a><br>",
"CURRENTLY_PLAYING5" => $message5,
"MAIN_COLOR1" => "[ <font color=". $theme['fontcolor2'] .">". $lang['online_viewing_games'] ."</font> ]",
"MAIN_SEPERATOR" => "<b> :: </b>",
"MAIN_COLOR2" => "[ <font color=". $theme['fontcolor3'] .">". $lang['online_playing_games'] ."</font> ]")
);
$q = "SELECT *
FROM ". INA_SESSIONS ."
WHERE playing = '1'
AND playing_time >= '". $expired ."'";
$r = $db -> sql_query($q);
while($row = $db -> sql_fetchrow($r))
{
$playing_id = $row['playing_id'];
if($userdata['user_level'] == ADMIN) $admin_hidden = "";
if($userdata['user_level'] != ADMIN) $admin_hidden = "AND user_allow_viewonline = '1'";
$q1 = "SELECT username, user_session_page, user_allow_viewonline
FROM ". USERS_TABLE ."
WHERE user_id = '". $playing_id ."'
$admin_hidden";
$r1 = $db -> sql_query($q1);
$row = $db -> sql_fetchrow($r1);
$playing_user = $row['username'];
$playing_where = $row['user_session_page'];
$playing_hidden = $row['user_allow_viewonline'];
if((!$playing_hidden) && ($userdata['user_level'] == ADMIN)) $playing_user = '<i>'. $playing_user .'</i>';
$color = '';
if($playing_where == PAGE_ACTIVITY)
{
$playing_user = '<b>'. $playing_user .'</b>';
$color = $theme['fontcolor2'];
}
elseif($playing_where == PAGE_PLAYING_GAMES)
{
$playing_user = '<b>'. $playing_user .'</b>';
$color = $theme['fontcolor3'];
}
if($playing_id != "-1")
{
$username_link = "<a href='". $phpbb_root_path ."profile.". $phpEx ."?mode=viewprofile&u=". $playing_id ."&sid=". $userdata['session_id'] ."' class='nav'><font color='". $color ."'>". $playing_user ."</font></a>";
}
$template->assign_block_vars("playing", array(
"USERNAME" => $username_link,
"USER_NUMBER" => " ",
"MAIN_SEPERATOR" => " ")
);
}
}
CleanInaSessions($expired);
/* End Whos In The Games */
if($board_config['use_gamelib'] == 1)
{
$gamelib_link = "<div align=\"center\"><span class=\"copyright\">" . $lang['game_lib_link'] . "</span></div>";
}
if($board_config['use_gamelib'] == 0)
{
$gamelib_link = '';
}
if($board_config['use_point_system'] && $board_config['use_rewards_mod'])
{
$template->assign_vars(array("L_MONEY" => $board_config['points_name']));
}
elseif(($board_config['use_cash_system'] || $board_config['use_allowance_system']) && $board_config['use_rewards_mod'])
{
$template->assign_vars(array("L_MONEY" => $lang['game_cost']));
}
else
{
$template->assign_vars(array("L_MONEY" => $lang['game_number']));
}
/* Start Newest Games */
if($HTTP_GET_VARS['mode'] != "category_play")
{
if($board_config['ina_use_newest'] == 1)
{
$template->assign_block_vars("newest_only", array(
"NEWEST_TITLE" => $lang['newest_title_1'] . $board_config['ina_new_game_count'] . $lang['newest_title_2'],
"U_TROPHY" => append_sid("activity_top_scores.$phpEx"),
"L_TROPHY" => $lang['trophy_page'],
"L_STATS" => $lang['stats'],
"L_COST" => $lang['cost'],
"L_T_HOLDER" => $lang['trophy_holder'],
"L_R_UP" => $lang['runner_up'],
"L_GAMES" => $lang['game_list'],
"L_SCORES" => $lang['game_score'],
"L_INFO" => $lang['game_info'],
"L_PLAYER" => $lang['game_best_player'])
);
if($userdata['user_level'] == ADMIN)
{
$where_clause = "";
}
else
{
$where_clause = "WHERE disabled = '1'";
}
$q = "SELECT *
FROM ". iNA_GAMES ."
$where_clause
ORDER BY install_date DESC
LIMIT 0, ". $board_config['ina_new_game_count'];
$r = $db -> sql_query($q);
$game_count = $db -> sql_numrows($r);
$game_rows = $db -> sql_fetchrowset($r);
// Setup Downloads Array ------------------------------------------------------ Dashe |
if($board_config['server_name'] == "phpbb-amod.com")
{
$q1 = "SELECT lid, url
FROM ". $table_prefix ."downloads_downloads";
$r1 = $db -> sql_query($q1);
$download_data = $db -> sql_fetchrowset($r1);
}
// Setup Game Ratings Array --------------------------------------------------- Dashe |
$q2 = "SELECT game_id, COUNT(*) AS total_ratings, SUM(rating) AS game_rated
FROM ". INA_RATINGS ."
GROUP BY game_id";
$r2 = $db -> sql_query($q2);
$rating_data = $db -> sql_fetchrowset($r2);
// Setup Comments Array ------------------------------------------------------- Dashe |
$q3 = "SELECT game, COUNT(game) AS total_comments
FROM ". INA_TROPHY_COMMENTS ."
GROUP BY game";
$r3 = $db -> sql_query($q3);
$comment_data = $db -> sql_fetchrowset($r3);
// Setup Favorites Array ------------------------------------------------------- Dashe |
$q4 = "SELECT games
FROM ". INA_FAVORITES ."
WHERE user = '". $userdata['user_id'] ."'";
$r4 = $db -> sql_query($q4);
$favorites_data = $db -> sql_fetchrowset($r4);
for($i = 0; $i < $game_count; $i++)
{
$game_id = $game_rows[$i]['game_id'];
$game_name = $game_rows[$i]['game_name'];
$game_path = $game_rows[$i]['game_path'];
$game_desc = $game_rows[$i]['game_desc'];
$win_width = $game_rows[$i]['win_width'];
$win_height = $game_rows[$i]['win_height'];
$game_fees = $game_rows[$i]['game_charge'];
$game_played = $game_rows[$i]['played'];
$game_date = $game_rows[$i]['install_date'];
$game_proper = $game_rows[$i]['proper_name'];
// Get Download Link From Array --------------------------------------- Dashe |
unset($download_link);
for($j = 0; $j <= count($download_data); $j++)
{
if(eregi("http://phpbb-amod.com/games/games/". $game_rows[$i]["game_name"] .".zip", $download_data[$j]["url"]))
{
$download_link = "<br><b>·</b> <a href='downloads.php?mode=download&cid=1&lid=". $download_data[$j]['lid'] ."&sid=". $userdata['session_id'] ."' class='nav'><font color='#339933'>Download This</font></a><br>";
break;
}
}
// Get Game Rating From Array ---------------------------------------- Dashe |
unset($total_votes_given, $total_rating_given);
for($j = 0; $j <= count($rating_data); $j++)
{
if($game_rows[$i]["game_id"] == $rating_data[$j]["game_id"])
{
$total_votes_given = $rating_data[$j]["total_ratings"];
$total_rating_given = $rating_data[$j]["game_rated"];
break;
}
}
if($total_votes_given > 0)
{
$game_rating = round($total_rating_given / $total_votes_given);
}
else
{
$game_rating = 0;
$total_votes_given = $lang['no_votes_cast'];
}
// Get Game Comments From Array -------------------------------- Dashe |
unset($total_comments);
for($j = 0; $j <= count($comment_data); $j++)
{
if($game_rows[$i]["game_name"] == $comment_data[$j]["game"])
{
$total_comments = $comment_data[$j]["total_comments"];
break;
}
}
if($total_comments < 1) $total_comments_shown = $lang['no_votes_cast'];
if($total_comments) $total_comments_shown = $total_comments;
// Get Favorites Data From Array ------------------------------- Dashe |
unset($favorites_link);
for($j = 0; $j <= count($favorites_data); $j++)
{
if(eregi(quotemeta("S". $game_rows[$i]["game_id"] ."E"), $favorites_data[$j]["games"]))
{
$favorites_link = "<a href='activity_favs.". $phpEx ."?mode=del_fav&game=". $game_id ."&sid=". $userdata['session_id'] ."'><img src='./images/r_favorite_game.jpg' border='0' alt='". $lang['favorites_r_mouse_over'] ."'></a>";
break;
}
else
{
$favorites_link = "<a href='activity_favs.". $phpEx ."?mode=add_fav&game=". $game_id ."&sid=". $userdata['session_id'] ."'><img src='./images/favorite_game.jpg' border='0' alt='". $lang['favorites_mouse_over'] ."'></a>";
break;
}
}
$game_rating_image = "<img src='./images/activity_game_ratings/". $game_rating .".gif' border='0' alt='". $game_rating ."'>";
$rating_title = $game_proper ."'s ". $lang['game_rating_title'];
if($total_votes_given == 1) $rating_votes_cast = str_replace("%V%", $total_votes_given, $lang['game_rating_votes_one']);
if($total_votes_given != 1) $rating_votes_cast = str_replace("%V%", $total_votes_given, $lang['game_rating_votes']);
$rating_submit = "<a href='activity_rating.". $phpEx ."?mode=rate&game=". $game_rows[$i]["game_id"] ."&sid=". $userdata['session_id'] ."' claa='mainmenu'>". $lang['game_rating_submit'] ."</a>";
if($game_rows[$i]['reverse_list'])
{
$list_type = 'ASC';
}
else
{
$list_type = 'DESC';
}
$q1 = "SELECT t.*, u.user_id, u.username
FROM ". INA_TROPHY ." t, ". USERS_TABLE ." u
WHERE t.game_name = '". $game_name ."'
AND t.player = u.user_id";
$r1 = $db -> sql_query($q1);
$row1 = $db -> sql_fetchrow($r1);
$top_player1 = $row1['player'];
$top_player11 = $row1['player'];
$t_player_id = $row1['user_id'];
$top_score1 = $row1['score'];
$top_date = $row1['date'];
$top_date = create_date($board_config['default_dateformat'], $top_date, $board_config['board_timezone']);
$top_score = FormatScores($top_score1);
$top_player1 = $row1['username'];
if($top_player1 == "Anonymous") $top_player = "Anonymous";
if(($top_player1 <> "Anonymous") && (strlen($top_player1) > 1)) $top_player = "<a href='". append_sid("profile.$phpEx?mode=viewprofile&u=$t_player_id") ."' class='nav'>$top_player1</a>";
$q2 = "SELECT *
FROM ". iNA_SCORES ."
WHERE player <> '". $top_player1 ."'
AND game_name = '". $game_name ."'
ORDER BY score $list_type, date DESC";
if(!$r2 = $db -> sql_query($q2))
{
message_die(GENERAL_ERROR, $lang['no_score_data'], "", __LINE__, __FILE__, $q2);
}
$score_info_a = $db -> sql_fetchrow($r2);
$best_score_a = $score_info_a['player'];
$best_score1 = $score_info_a['score'];
$best_player1 = $score_info_a['player'];
$q3 = "SELECT user_id
FROM ". USERS_TABLE ."
WHERE username = '" . $best_score_a . "'";
if(!$r3 = $db -> sql_query($q3))
{
message_die(GENERAL_ERROR, $lang['no_score_data'], "", __LINE__, __FILE__, $q3);
}
$score_info = $db -> sql_fetchrow($r3);
$b_player_id = $score_info['user_id'];
$best_score = FormatScores($best_score1);
if($best_player1 == "Anonymous") $best_player = "Anonymous";
if(($best_player1 <> "Anonymous") && (strlen($best_player1) > 1)) $best_player = "<a href='". append_sid("profile.$phpEx?mode=viewprofile&u=$b_player_id") ."' class='nav'>$best_player1</a>";
if($game_rows[$i]['game_show_score'] != '1')
{
$highscore_link = '';
$best_score = '';
$best_player = '';
}
else
{
$highscore_link = "<a href='" . append_sid("activity_highscores.$phpEx?mode=highscore&game_name=$game_name") . "' class='nav'> " . $lang['game_highscores'] . "</a>";
$best_score = $best_score;
}
$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];
if(strlen($best_player) < 1 || $best_score < "1")
{
$best_player = $lang['no_one_yet'];
}
if(($game_fees) && ($board_config['use_point_system']) && ($board_config['use_rewards_mod']))
{
$cost = $game_fees ." ". $board_config['points_name'];
}
elseif(($board_config['use_cash_system'] || $board_config['use_allowance_system']) && $board_config['use_rewards_mod'])
{
$cash_fix = "'". $board_config['default_cash'] ."'";
$cost = $game_fees ." ". $board_config[$cash_fix];
}
else
{
$cost = $lang['game_free'];
}
$game_link = CheckGameImages($game_name);
$button_link = $board_config['ina_button_option'];
if($button_link == "1")
{
$image_link = "<a class='nav' href=\"javascript:Gk_PopTart('activity.$phpEx?mode=game&id=$game_id&sid=". $userdata['session_id'] ."', 'New_Window', '$win_width', '$win_height', 'no')\" onclick=\"blur()\">";
}
else
{
$image_link = "<a href='". append_sid("activity.$phpEx?mode=game&id=$game_id&parent=true") ."' class='nav'>";
}
$challenge = $board_config['ina_challenge'];
if(($challenge == "1") && ($t_player_id <> "-1")) $challenge_link = "<a href='". append_sid("activity.$phpEx?mode=challenge&user=". $t_player_id ."&game=". $game_id) ."' class='nav'>". $lang['challenge_link_key'] ."</a>";
if($challenge <> "1" || $t_player_id == "-1") $challenge_link = $lang['challenge_link_key'];
$q3 = "SELECT COUNT(*) AS total_comments
FROM ". $table_prefix ."ina_trophy_comments
WHERE game = '". $game_name ."'";
$r3 = $db -> sql_query($q3);
$row = $db -> sql_fetchrow($r3);
$total_comments = $row['total_comments'];
if(!$total_comments) $total_comments_shown = $lang['no_votes_cast'];
if($total_comments) $total_comments_shown = $total_comments;
if($userdata['user_level'] == ADMIN) $admin_edit = "<br>» <a href='admin/admin_activity.$phpEx?mode=edit&id=". $game_id ."&sid=". $userdata['session_id'] ."' class='nav'>". $lang['admin_edit_link'] ."</a>";
if($userdata['user_level'] != ADMIN) $admin_edit = "";
$games_cost_line = "<br>» ". $lang['cost'] .": "
Klinkt raar maar is verwijderd door iemand
