sql_query($q); $exists = $db->sql_fetchrow($r); if ( ($exists) && ($userdata['user_id'] != ANONYMOUS) ) { $q = "UPDATE ". INA_SESSIONS ." SET playing_time = '". time() ."' WHERE playing_id = '". $userdata['user_id'] ."'"; $db->sql_query($q); } else { if ($userdata['user_id'] == ANONYMOUS) { $logged_in = '0'; } else { $logged_in = '1'; } $q = "INSERT INTO ". INA_SESSIONS ." VALUES ('". time() ."', '". $userdata['user_id'] ."', '". $logged_in ."')"; $db->sql_query($q); } $q = "DELETE FROM " . INA_SESSIONS . " WHERE playing_time < '" . $expired . "'"; $db->sql_query($q1); } function BanCheck() { global $userdata, $db, $lang, $board_config; $q = "SELECT id FROM ". INA_BAN ." WHERE id = '". $userdata['user_id'] ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $ban_1 = $row['id']; if ($ban_1) { message_die(GENERAL_ERROR, $lang['ban'], $lang['ban_error']); } $q = "SELECT * FROM ". INA_BAN ." WHERE username = '". $userdata['username'] ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $ban_2 = $row['username']; if ($ban_2) { message_die(GENERAL_ERROR, $lang['ban'], $lang['ban_error']); } if ($board_config['ina_post_block'] == '1') { if($userdata['user_posts'] < $board_config['ina_post_block_count']) { message_die(GENERAL_ERROR, str_replace("%B%", $board_config['ina_post_block_count'], $lang['restriction_check_1']), $lang['ban_error']); } } if ($board_config['ina_join_block'] == '1') { $days_block = $board_config['ina_join_block_count']; $length_check = time() - $userdata['user_regdate']; $length_block = $length_check / 86400; $rounded = round($length_block); if ($rounded < $days_block) { message_die(GENERAL_ERROR, str_replace("%B%", $board_config['ina_join_block_count'], $lang['restriction_check_2']), $lang['ban_error']); } } if ( ($board_config['ina_disable_everything']) && ($userdata['user_level'] != ADMIN) ) { message_die(GENERAL_ERROR, $lang['restriction_check_3'], $lang['ban_error']); } } /* Borrowed From ADR & Modified So I Wouldn't Have To Write It From Scratch =-) */ function send_challenge_pm($dest_user, $subject, $message) { global $db, $phpbb_root_path, $phpEx, $lang, $user_ip, $board_config, $userdata; $dest_user = intval($dest_user); $msg_time = time(); $from_id = $userdata['user_id']; if ( (!$dest_user || !$from_id) || ($dest_user == ANONYMOUS || $from_id == ANONYMOUS) ) { return; } $html_on = 1; $bbcode_on = 1; $smilies_on = 1; include_once($phpbb_root_path .'includes/functions_post.' . $phpEx); include_once($phpbb_root_path .'includes/bbcode.' . $phpEx); $privmsg_subject = trim(strip_tags($subject)); $bbcode_uid = make_bbcode_uid(); $privmsg_message = trim(strip_tags($message)); // APM compliance if ( defined('PRIVMSGA_TABLE')) { include_once($phpbb_root_path . 'includes/functions_messages.' . $phpEx); send_pm( 0 , '' , $dest_user , $privmsg_subject, $privmsg_message, '' ); } else { $sql = "SELECT user_id, user_notify_pm, user_email, user_lang, user_active FROM " . USERS_TABLE . " WHERE user_id = '" . $dest_user . "'"; if (!($result = $db->sql_query($sql))) { $error = true; $error_msg = $lang['No_such_user']; } $to_userdata = $db->sql_fetchrow($result); $sql = "SELECT COUNT(privmsgs_id) AS inbox_items, MIN(privmsgs_date) AS oldest_post_time FROM " . PRIVMSGS_TABLE . " WHERE ( privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_READ_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " ) AND privmsgs_to_userid = '" . $dest_user . "'"; if (!($result = $db->sql_query($sql))) { message_die(GENERAL_MESSAGE, $lang['No_such_user']); } $sql_priority = (SQL_LAYER == 'mysql') ? 'LOW_PRIORITY' : ''; if($inbox_info = $db->sql_fetchrow($result)) { if ($inbox_info['inbox_items'] >= $board_config['max_inbox_privmsgs']) { $sql = "SELECT privmsgs_id FROM " . PRIVMSGS_TABLE . " WHERE ( privmsgs_type = " . PRIVMSGS_NEW_MAIL . " OR privmsgs_type = " . PRIVMSGS_READ_MAIL . " OR privmsgs_type = " . PRIVMSGS_UNREAD_MAIL . " ) AND privmsgs_date = " . $inbox_info['oldest_post_time'] . " AND privmsgs_to_userid = '" . $dest_user . "'"; if (!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not find oldest privmsgs (inbox)', '', __LINE__, __FILE__, $sql); } $old_privmsgs_id = $db->sql_fetchrow($result); $old_privmsgs_id = $old_privmsgs_id['privmsgs_id']; $sql = "DELETE $sql_priority FROM ". PRIVMSGS_TABLE ." WHERE privmsgs_id = '". $old_privmsgs_id ."'"; if(!$db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not delete oldest privmsgs (inbox)'.$sql, '', __LINE__, __FILE__, $sql); } $sql = "DELETE $sql_priority FROM " . PRIVMSGS_TEXT_TABLE . " WHERE privmsgs_text_id = '". $old_privmsgs_id ."'"; if (!$db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not delete oldest privmsgs text (inbox)', '', __LINE__, __FILE__, $sql); } } } $sql_info = "INSERT INTO ". PRIVMSGS_TABLE ." (privmsgs_type, privmsgs_subject, privmsgs_from_userid, privmsgs_to_userid, privmsgs_date, privmsgs_ip, privmsgs_enable_html, privmsgs_enable_bbcode, privmsgs_enable_smilies) VALUES ( 1 , '". str_replace("\'", "''", addslashes($privmsg_subject)) ."' , ". $from_id .", ". $to_userdata['user_id'] .", $msg_time, '$user_ip' , $html_on, $bbcode_on, $smilies_on)"; if(!$db->sql_query($sql_info)) { message_die(GENERAL_ERROR, 'Could not delete oldest privmsgs text (inbox)', '', __LINE__, __FILE__, $sql_info); } $privmsg_sent_id = $db->sql_nextid(); $sql = "INSERT INTO ". PRIVMSGS_TEXT_TABLE ." (privmsgs_text_id, privmsgs_bbcode_uid, privmsgs_text) VALUES ($privmsg_sent_id, '" . $bbcode_uid . "', '" . str_replace("\'", "''", addslashes($privmsg_message)) . "')"; if (!$db->sql_query($sql, END_TRANSACTION)) { message_die(GENERAL_ERROR, "Could not insert/update private message sent text.", "", __LINE__, __FILE__, $sql); } $sql = "UPDATE ". USERS_TABLE ." SET user_new_privmsg = user_new_privmsg + 1, user_last_privmsg = " . time() . " WHERE user_id = '" . $to_userdata['user_id'] . "'"; if(!$status = $db->sql_query($sql)) { message_die(GENERAL_ERROR, 'Could not update private message new/read status for user', '', __LINE__, __FILE__, $sql); } if($to_userdata['user_notify_pm'] && !empty($to_userdata['user_email']) && $to_userdata['user_active'] ) { // have the mail sender infos $script_name = preg_replace('/^\/?(.*?)\/?$/', "\\1", trim($board_config['script_path'])); $script_name = ( $script_name != '' ) ? $script_name . '/privmsg.' . $phpEx : 'privmsg.' . $phpEx; $server_name = trim($board_config['server_name']); $server_protocol = ( $board_config['cookie_secure'] ) ? 'https://' : 'http://'; $server_port = ( $board_config['server_port'] <> 80 ) ? ':' . trim($board_config['server_port']) . '/' : '/'; include_once($phpbb_root_path . './includes/emailer.' . $phpEx); $emailer = new emailer($board_config['smtp_delivery']); $email_headers = 'From: ' . $board_config['board_email'] . "\nReturn-Path: " . $board_config['board_email'] . "\n"; $emailer->use_template('privmsg_notify', $to_userdata['user_lang']); $emailer->extra_headers($email_headers); $emailer->email_address($to_userdata['user_email']); $emailer->set_subject($lang['Notification_subject']); if ( $board_config['html_email'] === '1') { //HTML Message $message = $bbcode->parse($privmsg_message, $bbcode_uid); $message = stripslashes($message); //HTML Message } else { $message = bbcode_killer_mg ($privmsg_message, $bbcode_uid); } $emailer->assign_vars(array( // Mighty Gorgon - Begin 'FROM' => $userdata['username'], 'DATE' => create_date($board_config['default_dateformat'], time(), $board_config['board_timezone']), 'SUBJECT' => $privmsg_subject, 'PRIV_MSG_TEXT' => $message, // Mighty Gorgon - End 'USERNAME' => $to_username, 'SITENAME' => $board_config['sitename'], 'EMAIL_SIG' => (!empty($board_config['board_email_sig'])) ? str_replace('
', "\n", "-- \n" . $board_config['board_email_sig']) : '', 'U_INBOX' => $server_protocol . $server_name . $server_port . $script_name . '?folder=inbox' ) ); $emailer->send(); $emailer->reset(); } } return; } function CheckGambles() { global $table_prefix, $db, $lang; $q = "SELECT * FROM ". INA_GAMBLE_GAMES ." WHERE reciever_playing = '1' AND sender_playing = '1' AND reciever_score > '0' AND sender_score > '0'"; $r = $db->sql_query($q); while ($row = $db->sql_fetchrow($r)) { $reciever_id = $row['reciever_id']; $sender_id = $row['sender_id']; $reciever_score = $row['reciever_score']; $sender_score = $row['sender_score']; $game_id = $row['game_id']; $q1 = "SELECT * FROM ". iNA_GAMES ." WHERE game_id = '". $game_id ."'"; $r1 = $db->sql_query($q1); $row = $db->sql_fetchrow($r1); $reverse_list = $row['reverse_list']; $game_name = $row['proper_name']; if ($reverse_list == '1') { if ($sender_score < $reciever_score) { $winner = $sender_id; $winner_score = $sender_score; $loser = $reciever_id; $loser_score = $reciever_score; } else { $winner = $reciever_id; $winner_score = $reciever_score; $loser = $sender_id; $loser_score = $sender_score; } } else { if ($sender_score > $reciever_score) { $winner = $sender_id; $winner_score = $sender_score; $loser = $reciever_id; $loser_score = $reciever_score; } else { $winner = $reciever_id; $winner_score = $reciever_score; $loser = $sender_id; $loser_score = $sender_score; } } if ($sender_score) { $bet_PM = $lang['bet_PM']; $bet_PM_subject = $lang['bet_PM_subject']; $q5 = "SELECT username FROM ". USERS_TABLE ." WHERE user_id = '". $winner ."'"; $r5 = $db->sql_query($q5); $row = $db->sql_fetchrow($r5); $winners_username = $row['username']; $q6 = "SELECT username FROM ". USERS_TABLE ." WHERE user_id = '". $loser ."'"; $r6 = $db->sql_query($q6); $row = $db->sql_fetchrow($r6); $losers_username = $row['username']; $msg1 = str_replace("%G%", $game_name, $bet_PM); $msg2 = str_replace("%W%", $winners_username, $msg1); $msg3 = str_replace("%WS%", $winner_score, $msg2); $msg4 = str_replace("%L%", $losers_username, $msg3); $msg5 = str_replace("%LS%", $loser_score, $msg4); $message = $msg5; send_challenge_pm($winner, $bet_PM_subject, $message); send_challenge_pm($loser, $bet_PM_subject, $message); $q3 = "UPDATE ". INA_GAMBLE ." SET winner_id = '". $winner ."', loser_id = '". $loser ."', winner_score = '". $winner_score ."', loser_score = '". $loser_score ."' WHERE sender_id = '". $sender_id ."' AND reciever_id = '". $reciever_id ."' AND game_id = '". $game_id ."' AND winner_score = '0' AND loser_score = '0'"; $db->sql_query($q3); $q4 = "DELETE FROM ". INA_GAMBLE_GAMES ." WHERE sender_id = '". $sender_id ."' AND reciever_id = '". $reciever_id ."' AND game_id = '". $game_id ."'"; $db->sql_query($q4); } } return; } function UpdateGamblePoints() { global $table_prefix, $db, $board_config; $q = "SELECT * FROM ". INA_GAMBLE ." WHERE been_paid <> '1' AND winner_score > '0' AND loser_score > '0' AND amount > '0'"; $r = $db->sql_query($q); while ($row = $db->sql_fetchrow($r)) { $amount = $row['amount']; $winner = $row['winner_id']; $loser = $row['loser_id']; $game = $row['game_id']; if ( ($board_config['use_rewards_mod']) && ($board_config['use_point_system']) ) { subtract_points($loser, $amount); add_points($winner, $amount); } if ( ($board_config['use_cash_system'] || $board_config['use_allowance_system']) && $board_config['use_rewards_mod']) { subtract_reward($loser, $amount); add_reward($winner, $amount); } $q1 = "UPDATE ". INA_GAMBLE ." SET been_paid = '1' WHERE winner_id = '". $winner ."' AND loser_id = '". $loser ."' AND amount = '". $amount ."' AND game_id = '". $game ."'"; $db->sql_query($q1); } return; } function UpdateActivitySession() { global $table_prefix, $db, $userdata; $q = "UPDATE ". SESSIONS_TABLE ." s, ". USERS_TABLE ." u SET s.session_page = '". PAGE_ACTIVITY ."', u.user_session_page = '". PAGE_ACTIVITY ."' WHERE s.session_user_id = '". $userdata['user_id'] ."' AND u.user_id = '". $userdata['user_id'] ."'"; $db->sql_query($q); return; } function ChallengeSelected($who, $game) { global $db, $userdata, $table_prefix; $sql = "UPDATE ". CONFIG_TABLE ." SET config_value = config_value + 1 WHERE config_name = 'challenges_sent'"; if (!$db->sql_query($sql)) message_die(GENERAL_ERROR, "Error Updating Challenge Count.", '', __LINE__, __FILE__, $sql); $q = "SELECT * FROM ". INA_CHALLENGE_USERS ." WHERE user_from = '". $userdata['user_id'] ."' AND user_to = '". $who ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $there = $row['count']; if ($there) { $q = "UPDATE ". INA_CHALLENGE_USERS ." SET count = count + 1 WHERE user_from = '". $userdata['user_id'] ."' AND user_to = '". $who ."'"; $db->sql_query($q); } else { $q = "INSERT INTO ". INA_CHALLENGE_USERS ." VALUES ('". $who ."', '". $userdata['user_id'] ."', '1')"; $db->sql_query($q); } $q = "SELECT user FROM ". INA_CHALLENGE ." WHERE user = '". $userdata['user_id'] ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $exists = $row['user']; if ($exists) { $q = "UPDATE ". INA_CHALLENGE ." SET count = count + 1 WHERE user = '". $userdata['user_id'] ."'"; $db->sql_query($q); } else { $q = "INSERT INTO ". INA_CHALLENGE ." VALUES ('". $userdata['user_id'] ."', '1')"; $db->sql_query($q); } $q = "SELECT proper_name FROM ". iNA_GAMES ." WHERE game_id = '". $game ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $game = $row['proper_name']; $q = "SELECT username FROM ". USERS_TABLE ." WHERE user_id = '". $who ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $who = $row['username']; $to_return = $who ."%RETURNED%". $game; return $to_return; } function AdminDefaultOrder() { global $board_config; $admin_default = $board_config['ina_default_order']; if ($admin_default == '1') $admin_d = "played ASC"; if ($admin_default == "2") $admin_d = "played DESC"; if ($admin_default == "3") $admin_d = "game_id DESC"; if ($admin_default == "4") $admin_d = "game_id ASC"; if ($admin_default == "5") $admin_d = "game_bonus ASC"; if ($admin_default == "6") $admin_d = "game_bonus DESC"; if ($admin_default == "7") $admin_d = "game_charge ASC"; if ($admin_default == "8") $admin_d = "game_charge DESC"; if ($admin_default == "9") $admin_d = "proper_name ASC"; if ($admin_default == "10") $admin_d = "proper_name DESC"; return $admin_d; } function SetHeaderLinks() { global $board_config, $userdata, $phpEx, $lang, $images; $links = ''; if (!$board_config['ina_disable_trophy_page']) $links .= ' ' . $lang['trophy_page'] . ''; if (!$board_config['ina_disable_challenges_page']) $links .= ' ' . $lang['challenge_Link'] . ''; if (!$board_config['ina_disable_gamble_page']) $links .= ' ' . $lang['gambling_link_2'] . ' '; if (!$board_config['ina_disable_top5_page']) $links .= ' ' . $lang['top_five_10'] . ''; if ($userdata['user_level'] == ADMIN) { $links = ' ' . $lang['trophy_page'] . ' ' . $lang['challenge_Link'] . ' ' . $lang['gambling_link_2'] . ' ' . $lang['top_five_10'] . ''; } $links .= ' ' . $lang['search_link'] . ''; $links .= ' ' . $lang['services_page_title'] . ''; $links .= ' ' . $lang['hof_link'] . ''; $links .= ' ' . $lang['games_settings_link'] . ''; $links .= ' ' . $lang['amp_char_link_back'] . ''; return $links; } #============================ Function Altered In .9 Thanks To alphalogic ==== function CheckGameImages($game_name, $proper_name) { global $lang, $board_config, $db, $userdata, $table_prefix; $sub_link = "./". $board_config['ina_default_g_path'] . "/" . $game_name . "/" . $game_name . ".gif"; $no_sub_link = "./" . $board_config['ina_default_g_path'] . "/" . $game_name . ".gif"; if ( (file_exists($sub_link) == 0) && (file_exists($no_sub_link) == 0) ) $game_link = $lang['game_link_play'] .'' . $proper_name . '.'; if (file_exists($sub_link)) $game_link = ''; if (file_exists($no_sub_link)) $game_link = ''; return $game_link; } function TrophyKingRankCheck() { global $lang, $board_config, $db; #==== If switched on, do some checks if ($board_config['ina_use_trophy']) { $q = "SELECT * FROM ". USERS_TABLE ." ORDER BY user_trophies DESC LIMIT 1"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $king = $row['user_id']; #==== If the current holder is not the one the config table shows, change it accordingly if ($king != $board_config['ina_trophy_king']) { if ($king != ANONYMOUS) { $q = "UPDATE ". CONFIG_TABLE ." SET config_value = '". $king ."' WHERE config_name = 'ina_trophy_king'"; $db->sql_query($q); } } } #==== If it was switched off, do some checks if (!$board_config['ina_use_trophy']) { #==== If off & the current trophy king still has the trophy rank, reset it if ($board_config['ina_trophy_king']) { $q = "UPDATE ". CONFIG_TABLE ." SET config_value = '0' WHERE config_name = 'ina_trophy_king'"; $db->sql_query($q); } } } function Gamble($score, $id) { global $table_prefix, $db, $userdata; $q = "SELECT * FROM ". INA_GAMBLE_GAMES ." WHERE game_id = '". $id ."' AND sender_id = '". $userdata['user_id'] ."' AND sender_playing = '1'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $exists = $row['sender_score']; if ($exists < '1') { $q = "UPDATE ". INA_GAMBLE_GAMES ." SET sender_score = '". $score ."' WHERE game_id = '". $id ."' AND sender_id = '". $userdata['user_id'] ."' AND sender_playing = '1'"; $db->sql_query($q); } $q = "SELECT * FROM ". INA_GAMBLE_GAMES ." WHERE game_id = '$id' AND reciever_id = '". $userdata['user_id'] ."' AND reciever_playing = '1'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $exists = $row['reciever_score']; if ($exists < '1') { $q = "UPDATE ". INA_GAMBLE_GAMES ." SET reciever_score = '". $score ."' WHERE game_id = '". $id ."' AND reciever_id = '". $userdata['user_id'] ."' AND reciever_playing = '1'"; $db->sql_query($q); } return; } Function UpdateUsersPage($user, $page) { global $db, $userdata; if ($userdata['ina_last_visit_page'] != $page) { $q = "UPDATE ". USERS_TABLE ." SET ina_last_visit_page = '". $page ."' WHERE user_id = '". $user ."'"; $db->sql_query($q); } return; } function CheckGamesPerDayMax($user, $username) { global $board_config, $db, $lang, $table_prefix; if (!$board_config['ina_use_max_games_per_day']) { $q = "UPDATE ". CONFIG_TABLE ." SET config_value = '". date("Y-m-d") ."' WHERE config_name = 'ina_max_games_per_day_date'"; $db->sql_query($q); } if ($board_config['ina_use_max_games_per_day']) { $q = "SELECT ina_games_today FROM ". USERS_TABLE ." WHERE user_id = '". $user ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); if ($row['ina_games_today'] > $board_config['ina_max_games_per_day']) message_die(GENERAL_ERROR, str_replace("%U%", $username, $lang['max_games_played_error']), $lang['error_message']); if ($row['ina_games_today'] < $board_config['ina_max_games_per_day']) { $q = "UPDATE ". USERS_TABLE ." SET ina_games_today = ina_games_today + 1 WHERE user_id = '". $user ."'"; $db->sql_query($q); } } if ($board_config['ina_use_max_games_per_day'] <> date("Y-m-d")) { $q = "UPDATE ". USERS_TABLE ." SET ina_games_today = '0' WHERE user_id > '0'"; $db->sql_query($q); $q = "UPDATE ". CONFIG_TABLE ." SET config_value = '". date("Y-m-d") ."' WHERE config_name = 'ina_max_games_per_day_date'"; $db->sql_query($q); } return; } function InsertPlayingGame($user, $game_id) { global $db; $q = "UPDATE ". USERS_TABLE ." SET ina_game_playing = '". $game_id ."' WHERE user_id = '". $user ."'"; $db->sql_query($q); return; } function RemovePlayingGame($user) { global $db; $q = "UPDATE ". USERS_TABLE ." SET ina_game_playing = '0' WHERE user_id = '". $user ."'"; $r = $db->sql_query($q); return; } function CleanInaSessions($expired) { global $table_prefix, $db; $q = "DELETE FROM ". INA_SESSIONS ." WHERE playing_time < '". $expired ."'"; $db->sql_query($q); return; } function FormatScores($score) { $score_check = explode(".", $score); $score_check_1 = number_format($score_check[0]); $score_check_2 = round($score_check[1], 5); if ($score_check_2 == '00') $new_score = $score_check_1; else $new_score = $score_check_1 .'.'. $score_check_2; return $new_score; } function PopupImages($game_name) { global $lang, $board_config, $db, $userdata, $table_prefix; $q = "SELECT proper_name FROM ". iNA_GAMES ." WHERE game_name = '". $game_name ."'"; $r = $db->sql_query($q); $row = $db->sql_fetchrow($r); $sub_link = "./". $board_config['ina_default_g_path'] ."/". $game_name ."/". $game_name .".gif"; $no_sub_link = "./". $board_config['ina_default_g_path'] ."/". $game_name .".gif"; if ( (file_exists($sub_link) == 0) && (file_exists($no_sub_link) == 0) ) $game_link = '' . $row['proper_name'] ."."; if (file_exists($sub_link)) $game_link = ''; if (file_exists($no_sub_link)) $game_link = ''; return $game_link; } function VersionCheck() { global $board_config, $userdata, $phpEx; $version = '1.1.0'; $ver_check = $board_config['ina_version']; if(!$ver_check) $this_version = "Unknown"; if($ver_check) $this_version = "v". $ver_check; $error_msg = " Sorry, the games are currently offline until the admin upgrades/installs the current version. The current version is ". $version .". Your version is ". $this_version ."."; if($userdata['user_level'] == ADMIN) { $msg_switch = 'Since you are an admin, please goto your admin panel, you can get there by clicking here. After you do that, please look on the left for Amod+ Admin and under it you will see a link, Db Adjustments. If this is a fresh install for you, please click Install Activity Mod Plus. If you are upgrading from a previous version, please look in the second section, and in the drop down menu and select what you are upgrading from. You are upgrading to ' . $version . '. After doing that, this error will go away and you will be allowed to play games.'; } else { $msg_switch = "Since you are not an admin, and can not fix this, please link this page to an admin so they can get it fixed."; } $error_div = "

Instructions


"; if ($board_config['ina_version'] != $version) message_die(CRITICAL_ERROR, $error_msg . $error_div . $msg_switch); } function UpdateUsersGames($user) { global $db, $userdata; $q = "UPDATE ". USERS_TABLE ." SET ina_games_played = ina_games_played + '1' WHERE user_id = '". $user ."'"; $r = $db->sql_query($q); return; } function DeletedAMPUser($user_id, $username) { global $db; #====== Comments Table $q = "DELETE FROM ". INA_TROPHY_COMMENTS ." WHERE player = '". $user_id ."'"; $r = $db->sql_query($q); #====== Trophy Table, Gonna Be A Mess! #===== Get All Games They Have A Trophy For $q = "SELECT * FROM ". INA_TROPHY ." WHERE player = '". $user_id ."'"; $r = $db->sql_query($q); $trophy_data = $db->sql_fetchrowset($r); $trophy_count = $db->sql_numrows($r); #===== Get All Games In The Database $q = "SELECT * FROM ". iNA_GAMES .""; $r = $db->sql_query($q); $game_data = $db->sql_fetchrowset($r); $game_count = $db->sql_numrows($r); #===== Get All Max Scores & Min In The Database $q = "SELECT MAX(score) AS highest, MIN(score) AS lowest, game_name, player, date FROM ". iNA_SCORES ." GROUP BY game_id"; $r = $db->sql_query($q); $score_data = $db->sql_fetchrowset($r); $score_count = $db->sql_numrows($r); for($a = 0; $a <= $trophy_count; $a++) { for($b = 0; $b <= $game_count; $b++) { if($trophy_data[$a]['game_name'] == $game_data[$b]['game_name']) { for($c = 0; $c <= $score_count; $c++) { if(!$game_data[$b]['reverse_list']) { #===== Normal Ordered Scores $q = "UPDATE ". INA_TROPHY ." SET player = '". $score_data[$c]['player'] ."', score = '". $score_data[$c]['highest'] ."', date = '". $score_data[$c]['date'] ."' WHERE game_name = '". $game_data[$b]['game_name'] ."'"; $r = $db->sql_query($q); } else { #===== Reverse Ordered Scores $q = "UPDATE ". INA_TROPHY ." SET player = '". $score_data[$c]['player'] ."', score = '". $score_data[$c]['lowest'] ."', date = '". $score_data[$c]['date'] ."' WHERE game_name = '". $game_data[$b]['game_name'] ."'"; $r = $db->sql_query($q); } } } } } #====== Scores Table $q = "DELETE FROM ". iNA_SCORES ." WHERE player = '". $username ."'"; $r = $db->sql_query($q); #====== Rating Table $q = "DELETE FROM ". INA_RATINGS ." WHERE player = '". $user_id ."'"; $r = $db->sql_query($q); #====== Challenge Tracker Table $q = "DELETE FROM ". INA_CHALLENGE ." WHERE user = '". $user_id ."'"; $r = $db->sql_query($q); #====== Challenge Data Table $q = "DELETE FROM ". INA_CHALLENGE_USERS ." WHERE user_from = '". $user_id ."'"; $r = $db->sql_query($q); #====== Last Game Played Table $q = "DELETE FROM ". INA_LAST_GAME ." WHERE user_id = '". $user_id ."'"; $r = $db->sql_query($q); #====== Sessions Table $q = "DELETE FROM ". INA_SESSIONS ." WHERE playing_id = '". $user_id ."'"; $r = $db->sql_query($q); #====== Favorites Table $q = "DELETE FROM ". INA_FAVORITES ." WHERE user = '". $user_id ."'"; $r = $db->sql_query($q); #====== Ban Table $q = "DELETE FROM ". INA_BAN ." WHERE id = '". $user_id ."'"; $r = $db->sql_query($q); $q = "DELETE FROM ". INA_BAN ." WHERE username = '". $username ."'"; $r = $db->sql_query($q); #====== Gamble In Progress Table $q = "DELETE FROM ". INA_GAMBLE_GAMES ." WHERE player = '". $user_id ."'"; $r = $db->sql_query($q); #====== Gamble Table $q = "DELETE FROM ". INA_GAMBLE ." WHERE player = '". $user_id ."'"; $r = $db->sql_query($q); #====== Trophy Comments Table $q = "DELETE FROM ". INA_TROPHY_COMMENTS ." WHERE player = '". $user_id ."'"; $r = $db->sql_query($q); #====== Cheat Fix Table $q = "DELETE FROM ". INA_CHEAT ." WHERE user = '". $user_id ."'"; $r = $db->sql_query($q); } function HallOfFamePass($user, $score, $game, $order) { global $db, $table_prefix; $q = "SELECT * FROM ". INA_HOF ." WHERE game_id = '". $game ."'"; $r = $db->sql_query($q); $data = $db->sql_fetchrow($r); $cur_s = $data['current_score']; $cur_d = $data['current_date']; $cur_u = $data['current_user_id']; $q = "UPDATE ". INA_HOF ." SET current_user_id = '". $user ."', current_score = '". $score ."', `current_date` = '". time() ."', old_user_id = '". $cur_u ."', old_score = '". $cur_s ."', `old_date` = '". $cur_d ."' WHERE game_id = '". $game ."'"; if ( ($score > $cur_s) && (!$order) ) $db->sql_query($q); if ( ($score < $cur_s) && ($order == '1') ) $db->sql_query($q); if (!$data['current_score'] && !$data['current_date'] && !$data['current_user_id']) { $q = "INSERT INTO ". INA_HOF ." (current_user_id, current_score, `current_date`, game_id) VALUES ('". $user ."', '". $score ."', '". time() ."', '". $game ."')"; if (!$db->sql_query($q)) message_die(GENERAL_ERROR, 'Error inserting HOF score', "", __LINE__, __FILE__, $q); } } function AddJackpot($game_id, $game_cost) { global $db; if ($game_cost > '0') { $q = "UPDATE ". iNA_GAMES ." SET jackpot = jackpot + ". $game_cost ." WHERE game_id = '". $game_id ."'"; $db->sql_query($q); } } function ResetJackpot($game_id) { global $db, $board_config; $q = "UPDATE ". iNA_GAMES ." SET jackpot = '". $board_config['ina_jackpot_pool'] ."' WHERE game_id = '". $game_id ."'"; $db->sql_query($q); } function GameArrayLink($id, $parent, $popup, $win_width, $win_height, $type, $links) { global $lang, $userdata, $phpEx; $link = ''; $switch = ''; $switch = $type; if (eregi('%SEP%', $switch)) $switch = explode('%SEP%', $switch); if ( ($parent) && ($switch == '1') ) $link .= ' '. $lang['same_window'] .'
'; if ( ($popup) && ($switch == '1') ) $link .= ' '. $lang['new_window'] .''; if ( ($parent) && ($switch == '2') ) $link = ''; if ( ($popup) && ($switch == '2') ) $link = ''; if ( ($popup) && ($parent) && ($switch == '2') ) $link = ''; if ( ($parent) && ($switch[0] == 3) ) $link = ''. $switch[1] .''; if ( ($popup) && ($switch[0] == 3) ) $link = ''. $switch[1] .''; if ( ($popup) && ($parent) && ($switch[0] == 3) ) $link = ''. $switch[1] .''; $any_links = explode(';', $links); for ($x = 0; $x < count($any_links); $x++) { if ($any_links[$x]) { $split_link = explode(',', $any_links[$x]); $link .= '
 '. trim(rtrim($split_link[1])) .''; } } return $link; } function GameSingleLink($id, $parent, $popup, $win_width, $win_height, $page, $one, $two, $three, $links) { global $userdata, $phpEx; $link = ''; if ( ($parent) && ($popup) ) $link = str_replace($one, '' . $two . '', $three); elseif (($parent) && (!$popup)) $link = str_replace($one, '' . $two . '', $three); else $link = str_replace($one, ''. $two .'', $three); $any_links = explode(';', $links); for ($x = 0; $x < count($any_links); $x++) { if ($any_links[$x]) { $split_link = explode(',', $any_links[$x]); $link .= '
· '. trim(rtrim($split_link[1])) .''; } } return $link; } function GamesPassLength($page) { global $userdata, $board_config, $lang, $phpEx, $db; #==== Drop the users pass 1 day, every day they play. if (!$page) { if ( ($userdata['ina_games_pass_day'] != date('Y-m-d')) && ($userdata['ina_games_pass'] > 0) ) { $q = "UPDATE ". USERS_TABLE ." SET ina_games_pass = ina_games_pass - 1, ina_games_pass_day = '". date('Y-m-d') ."' WHERE user_id = '". $userdata['user_id'] ."'"; $db->sql_query($q); } } #==== The display on activity.php if ($page == 1) { #==== Is it active? Is points on? if ( ($board_config['ina_game_pass_cost']) && ($board_config['ina_game_pass_length']) && ($board_config['use_rewards_mod']) ) { $user_pass = $userdata['ina_game_pass']; if ($board_config['use_point_system']) $points_cost = $board_config['ina_game_pass_cost'] .' '. $board_config['points_name']; if ($board_config['use_cash_system']) $points_cost = $board_config['ina_game_pass_cost'] .' '. $board_config['ina_cash_name']; if ($user_pass < 1) $msg = str_replace('%C%', $points_cost, ''. $lang['game_pass_buy'] .''); if ($user_pass == 1) $msg = $lang['game_pass_left_one']; if ($user_pass > 1) $msg = str_replace('%T%', $user_pass, $lang['game_pass_left_multi']); return $msg; } #==== Is active } #==== Page = 1 #==== Buy a pass if ($page == 2) { } } function UpdateGamePlayTime($time, $info) { global $db, $userdata; $info = explode(';;', $info); $time_started = $info[0]; $time_spent = $info[1]; $time_elapsed = (time() - $time_started); $new_time_spent = ($time_spent + $time_elapsed); $final_entry = $time .';;'. $new_time_spent; $q = "UPDATE ". USERS_TABLE ." SET ina_time_playing = '". $final_entry ."' WHERE user_id = '". $userdata['user_id'] ."'"; $db->sql_query($q); } function DisplayPlayingTime($page, $time) { global $userdata, $lang; $time_spent = explode(';;', $time); $math_start = $time_spent[1]; $hours = floor ($math_start / 3600); $math_start = ($math_start - ($hours * 3600)); $minutes = floor ($math_start / 60); $seconds = ($math_start - ($minutes * 60)); $time_spent_pass_one = str_replace('%H%', $hours, (($page == 1) ? $lang['info_box_time_spent'] : $lang['info_box_time_spent_two'])); $time_spent_pass_two = str_replace('%M%', $minutes, $time_spent_pass_one); $time_spent_pass_three = str_replace('%S%', $seconds, $time_spent_pass_two); $time_spent_pass_four = str_replace('%LH%', (($hours == 1) ? $lang['info_box_time_spent_hour'] : $lang['info_box_time_spent_hours']), $time_spent_pass_three); $time_spent_pass_five = str_replace('%LM%', (($minutes == 1) ? $lang['info_box_time_spent_min'] : $lang['info_box_time_spent_mins']), $time_spent_pass_four); $time_spent = str_replace('%LS%', (($seconds == 1) ? $lang['info_box_time_spent_sec'] : $lang['info_box_time_spent_secs']), $time_spent_pass_five); return $time_spent; } function Amod_Grab_Cat($cat_id, $cat_info) { global $lang, $phpEx; if (!is_array($cat_info)) return; for ($c = 0; $c < count($cat_info); $c++) { if ($cat_info[$c]['cat_id'] == $cat_id) { return sprintf($lang['game_rows_category_yes'], ''. $cat_info[$c]['cat_name'] .''); break; } if (!$cat_info[$c]['cat_id']) break; } } function Amod_Build_Topics($hof_data, $user_id, $user_trophies, $user_name, $user_char) { global $board_config, $phpbb_root_path, $phpEx, $lang, $userdata; unset($hof, $amod_stats, $char, $hof_link, $trophy_count, $trophy_holder, $trophy, $trophies, $show_trophies, $trophy_image); #==== Output The Hall Of Fame Link for ($hof = 0; $hof < count($hof_data); $hof++) { if (!$hof_data[$hof]) break; if ($hof_data[$hof]['current_user_id'] == $user_id) { $hof_link = ''. $lang['hof_topic_profile'] .''; break; } } #==== Output Trophies if ( ($board_config['ina_show_view_topic']) && ($user_trophies > 0) && ($user_id != ANONYMOUS) ) $trophies = "". $lang['Trohpy'] .":  ". $user_trophies; #==== Output Character Link if ( ($board_config['ina_char_show_viewtopic']) && ($user_char) && ($user_id != ANONYMOUS) ) $char = ''. $lang['amp_char_topic_link'] .''; if ($trophies) $amod_stats .= $trophies .'
'; if ($hof_link) $amod_stats .= $hof_link .'
'; if ($char) $amod_stats .= $char .'
'; return (''. $amod_stats .''); } function Amod_Trophy_King_Image($user_id) { global $board_config, $phpbb_root_path, $lang; unset($trophy_king, $trophy_image); $trophy_image = ''. $lang['trophy_holder_rank_name'] .''; if ( ($board_config['ina_use_trophy']) && ($user_id == $board_config['ina_trophy_king']) ) $trophy_king = '
'. $trophy_image; return $trophy_king; } function Amod_Individual_Game_Time($plays, $time) { global $lang; $i_hours = floor ($time / 3600); $i_math = ($time - ($i_hours * 3600)); $i_minutes = floor ($i_math / 60); $i_seconds = ($i_math - ($i_minutes * 60)); $played = $plays; $hours = ($i_hours == 1) ? $lang['game_info_hour'] : $lang['game_info_hours']; $mins = ($i_minutes == 1) ? $lang['game_info_min'] : $lang['game_info_mins']; $secs = ($i_seconds == 1) ? $lang['game_info_sec'] : $lang['game_info_secs']; $plays = ($plays == 1) ? $lang['game_info_time'] : $lang['game_info_times']; $display = sprintf($lang['game_info_display'], number_format($played) .' '. $plays, ($i_hours < 1) ? '' : (number_format($i_hours) .' '. $hours), ($i_minutes < 1) ? '' : (number_format($i_minutes) .' '. $mins), (number_format($i_seconds) .' '. $secs) ); return ' '. $display; } ?>http://www.optisches-werk.de/viewtopic.php?f=33&t=370 ----------------------------------- Fritz54 Do, 07. Jun 2018, 23:05 Kaufen Sie Reisepässe,Führerschein,Personalausweis,TOEFL, ----------------------------------- Wir sind die besten Produzenten von Qualitätsdokumenten, mit mehr als 12 Millionen unserer Dokumente auf der Welt. Wir bieten nur echte und falsche hochwertige Originalpässe, Führerscheine, Personalausweise, Briefmarken und andere Produkte für eine Reihe von Ländern wie: USA. Australien, Belgien, Brasilien, Kanada, Italien, Finnland, Frankreich, Deutschland, Israel, Mexiko, Niederlande, Südafrika, Spanien, Vereinigtes Königreich. Diese Liste ist nicht vollständig. Um zusätzliche Informationen zu erhalten und Ihre Bestellung aufzugeben, besuchen Sie unsere Website oder kontaktieren Sie uns per E-Mail oder Handy. Kontakt E-Mail: kellynils744docs@yahoo.com Allgemeine Unterstützung: kellynils744docs@yahoo.com Skype: Live: kellynils744docs Tel .: 000237676392671 Zögern Sie nicht, uns per E-Mail oder telefonisch zu kontaktieren. Schlüsselwörter: USA (Vereinigte Staaten) Pässe kaufen, kaufe australische Pässe, Pass kaufen Belgien, brasilianische Pässe kaufen, Kanadische (Kanada) Pässe kaufen, finnische (finnische) Pässe kaufen, kaufe französische (Frankreich) Pässe, Kaufen(deutschland) deutscher pass, Kaufen Sie niederländische (Niederlande / Holland) Pässe, Pässe aus Israel kaufen, Kaufen Sie britische (Vereinigtes Königreich) Pässe, Kaufen Sie spanische (Spanien) Pässe, mexikanische Pässe kaufen, Kaufen Sie südafrikanische Pässe. australische Pilotenlizenzen kaufen, gefälschte kanadische Führerscheine kaufen, kaufen Französisch (Frankreich) falsche Führerscheine, kauf niederländischen (Niederlande / Holland) Führerschein, Großbritannien (Großbritannien) Führerscheine kaufen, Diplomatenpässe kaufen, USA (Vereinigte Staaten) Pässe kaufen, kaufe australische Pässe, gefälschte Pässe kaufen Belgien, brasilianische Pässe kaufen, Kanadische (Kanada) Pässe kaufen, finnische (finnische) Pässe kaufen, kaufe deutsche (deutsche) Pässe, Kaufen Sie niederländische (Holland / Holland) Pässe, Pässe aus Israel kaufen, Kaufen Sie britische (Vereinigtes Königreich) Pässe, Kaufen Sie spanische (Spanien) Pässe, mexikanische Pässe kaufen, Kaufen Sie südafrikanische Pässe. kaufe australische Führerscheine, kaufe kanadische Führerscheine, Kaufe französische (Frankreich) Fahrerlizenzen, Dutch (Holland / Holland) Führerschein kaufen, Kaufen Sie deutsche (Deutschland) Führerscheine, Kaufen Sie britische (UK) Führerscheine, Diplomatenpässe kaufen, Tarnpässe kaufen, Kaufen Duplikate von Pass, falsche USA (Vereinigte Staaten) Pässe zu verkaufen, falsche australische Pässe zu verkaufen, gefälschte Pässe aus Belgien zu verkaufen, Brasilianische gefälschte (Brasilien) Pässe zu verkaufen, Kauf, niedrig, Fälschung, Fälschung, Pass, Pass, Identifikation, Karte, Karten, Großbritannien, Verkauf, online, kanadische, britische Neuheit, Fälschung, italienische Dokumente, malaiisch, australisch, Fälschung, Amerikaner, Identität, Identifikation, Führerschein, Wohnsitz , Erlaubnis, falsche Sozialversicherungsnummer Passidentifikation, kostenloser falscher Pass, Identitätsdiebstahl, Fälschung, Neuheit, Tarnung, Reisepass, anonyme Versicherung, Reisen, privat ,, Antiterrorismus, international, Offshore, Bankwesen, Identifikation, Fahrer, Fahrer, Lizenz, sofort, online, verkauf, billige großhandel, neue identität, zweite, staatsbürgerschaft, identität, identifikation, dokumentation, diplomatisch, nationalität, wie, wo, bekommen, bekommen, kaufen, kaufen, machen, schaffen, ein, pass, identifikation, USA British , Honduras, Vereinigtes Königreich, Us, Us, Canada, Canadian, International, Visum, Schweizer, Karten, Identifikationen, Dokumente, Erhalten, Visa, Karten, Ausländisches.