$today) { execute_query("UPDATE `voting_points` SET `date` = '".$today."', `date_points` = 0 WHERE `id` = ".$_SESSION["user_id"]." LIMIT 1"); $_SESSION["date"] = $today; $_SESSION["date_points"] = 0; } else { $_SESSION["date"] = $row["date"]; $_SESSION["date_points"] = $row["date_points"]; } } else { execute_query("INSERT INTO `voting_points` (`id`) VALUES (".$_SESSION["user_id"].")"); $_SESSION["points"] = 0; $_SESSION["date"] = date("Ymd"); $_SESSION["date_points"] = 0; } // Table voting $get_voting = execute_query("SELECT `sites`, `time` FROM `voting` WHERE `user_ip` LIKE '".$_SERVER["REMOTE_ADDR"]."' LIMIT 1"); if(mysql_num_rows($get_voting)) { $row = mysql_fetch_assoc($get_voting); $_SESSION["time"] = $row["time"]; if((time() - $row["time"]) > $ip_voting_period) { execute_query("UPDATE `voting` SET `sites` = 0 WHERE `user_ip` LIKE '".$_SERVER["REMOTE_ADDR"]."' LIMIT 1"); $_SESSION["sites"] = 0; } else $_SESSION["sites"] = $row["sites"]; } else { execute_query("INSERT INTO `voting` (`user_ip`) VALUES ('".$_SERVER["REMOTE_ADDR"]."')"); $_SESSION["sites"] = 0; $_SESSION["time"] = 0; } } function sec_to_dhms($sec, $show_days = false) { global $language; $days = intval($sec / 86400); $hours = intval(($sec / 3600) % 24); $minutes = intval(($sec / 60) % 60); $seconds = intval($sec % 60); return $days." ".$language["days"].", ".$hours." ".$language["hours"].", ".$minutes." ".$language["minutes_and"]." ".$seconds." ".$language["seconds"].""; } function vote($site) { global $max_acc_points_per_day, $open_vote_site, $tab_sites, $use_online_check; if(isset($tab_sites[$site])) { if($use_online_check) $fp = @fsockopen($tab_sites[$site][0], 80, $errno, $errstr, 3); else $fp = True; if(!($site & $_SESSION["sites"]) && ($_SESSION["date_points"] < $max_acc_points_per_day) && $fp) { echo ""; if($use_online_check) fclose($fp); switchConnection("realmd", $_SESSION["realm"]); execute_query("UPDATE `voting` SET `sites`=(`sites` | ".$site."), `time`='".time()."' WHERE `user_ip` LIKE '".$_SERVER["REMOTE_ADDR"]."' LIMIT 1"); $_SESSION["sites"] += $site; $_SESSION["time"] = time(); execute_query("UPDATE `voting_points` SET `points`=(`points` + ".$tab_sites[$site][3]."), `date_points`=(`date_points` + ".$tab_sites[$site][3].") WHERE `id` = ".$_SESSION["user_id"]." LIMIT 1"); $_SESSION["points"] += $tab_sites[$site][3]; $_SESSION["date_points"] += $tab_sites[$site][3]; } } } function show_sites() { global $max_acc_points_per_day, $language, $tab_sites, $use_online_check; echo ""; if($use_online_check) echo ""; echo ""; foreach($tab_sites as $key => $value) { echo ""; if($use_online_check) { echo ""; } echo ""; } echo "

",$language["chose_site"],"
",$language["voting_sites"],"	",$language["voted"],"	",$language["status"],"	",$language["points_1"],"	",$language["choose"],"
	"; if($_SESSION["date_points"] >= $max_acc_points_per_day) $disabled = " disabled=\"disabled\""; else $disabled = ""; if($_SESSION["sites"] & $key) { echo "",$language["yes"],""; $disabled = " disabled=\"disabled\""; } else echo "",$language["no"],""; echo "	"; $fp = @fsockopen($value[0], 80, $errno, $errstr, 3); if($fp) { echo "",$language["online"],""; fclose($fp); } else { echo "",$language["offline"],""; $disabled = " disabled=\"disabled\""; } echo "	",$value[3],"

"; } function show_chars_menu() { switchConnection("characters", $_SESSION["realm"]); $results = execute_query("SELECT `guid`, `name` FROM `characters` WHERE `account` = ".$_SESSION["user_id"]); while($row = mysql_fetch_assoc($results)) echo "",$row["name"],""; } function add_char_to_session($guid) { switchConnection("characters", $_SESSION["realm"]); $_SESSION["char_name"] = mysql_result(execute_query("SELECT `name` FROM `characters` WHERE `account` = ".$_SESSION["user_id"]." AND `guid` = ".$guid." LIMIT 1"), 0); } function show_rewards() { global $langs, $language, $reward_texts, $set_lang, $tab_rewards; echo " "; foreach($tab_rewards as $key => $value) { if($value[2] > $_SESSION["points"]) $disabled = " disabled=\"disabled\""; else $disabled = ""; echo ""; } echo "

",$language["available_rewards"],"
"; if($value[0] && $value[3] >= 0) echo $value[1]," x ",$reward_texts[$langs[$set_lang][2]][$key],""; else echo $reward_texts[$langs[$set_lang][2]][$key]; echo "	",$value[2]," ",$language["points_2"],"

"; } function chose_reward($reward) { global $langs, $language, $mangos_rev, $realms, $remote_access, $reward_texts, $set_lang, $tab_rewards; if(!isset($tab_rewards[$reward])) return ""; if($_SESSION["points"] < $tab_rewards[$reward][2]) return ""; // Connect and select if ( !$connection = mysql_connect($host,$user,$password) ) die("Could not connect: ".mysql_error()); if ( !mysql_select_db($database,$connection) ) die("Error in selecting the database:".mysql_error()); // initial query $sql = "SELECT `guid` FROM `characters` WHERE `account` = $user_id "; $result = mysql_query($sql); // bind $data = mysql_fetch_assoc($result); $guid = $data['guid']; // Insert query $query = "INSERT INTO mail_external (id,receiver,subject,message,money,item,item_count) VALUES ((NULL), $guid, `Vote Reward`, `Thank you for supporting WoW Revived!`, `(NULL)`, `37829`, `10`"; $result = mysql_query($query); if ( !$result ) echo die("Error in selecting the database:".mysql_error()); } ?>