| '.$x.' |
'.$name.' |
'.number_format($rank).' |
'.number_format($points).' |
'.number_format($villages).' |
');
}
return $display;
}
function village_k($x, $y="y"){
if($y == "y" && strpos($x, "|") !== false){
$ex = explode("|", $x);
$x = $ex[0];
$y = $ex[1];
}
$k = "K";
if($y<100){
$k .= "";
} else {
$k .= $y[0];
}
if($x<100){
$k .= "0";
} else {
$k .= $x[0];
}
return $k;
}
function check_claim($x, $y, $tribe_id){
$fam_tribe_id = $tribe_id.",";
$query = mysql_query("SELECT * FROM links_".$this->current_world." WHERE creator_tribe_id='".$tribe_id."'");
while($row = mysql_fetch_array($query)){
$fam_tribe_id .= $row['tribe_id'].",";
}
$query = mysql_query("SELECT * FROM links_".$this->current_world." WHERE tribe_id='".$tribe_id."'");
while($row = mysql_fetch_array($query)){
$fam_tribe_id .= $row['creator_tribe_id'].",";
}
$family_ids = explode(",", $fam_tribe_id);
foreach($family_ids as $family_id) {
$query = "SELECT * FROM claimer_".$this->current_world." WHERE tribe='".$family_id."' AND x='".$x."' AND y='".$y."' AND deleted='no' AND expired='no'";
$query = mysql_query($query);
$this->check_query($query, $db_name, "select", "6");
/* while($row = mysql_fetch_array($query)){
$stored_x = $row['x'];
$stored_y = $row['y'];
$expired = $row['expired'];
if($stored_x == $x && $stored_y == $y && $expired == "no"){
$claimed = "yes";
}
} */
if(mysql_num_rows($query) > 0){
$claimed = "yes";
}
}
if($claimed != "yes"){
$claimed = "no";
}
return $claimed;
}
function report_show($tribe){
//
}
function report_add($tribe, $coord, $in_village, $out_village){
$coords = explode("|", $coord);
$x = $coords[0];
$y = $coords[1];
$in_village = explode(",", $in_village);
$out_village = explode(",", $out_village);
}
function report_search($term, $type="player"){
//$type = player
//$type = tribe
//$type = coord
}
function report_exists($coord){
$coords = explode("|", $coord);
$x = $coords[0];
$y = $coords[1];
}
function bbcode($input){
preg_match_all('/\d{1,3}\|\d{1,3}/', $input, $matches);
//preg_match_all('/\d\d\d\|\d\d\d/', $input, $matches);
return $matches[0];
}
function distance($coord1, $coord2){
$coord1 = explode("|", $coord1);
$x1 = $coord1[0];
$y1 = $coord1[1];
$coord2 = explode("|", $coord2);
$x2 = $coord2[0];
$y2 = $coord2[1];
$x = pow($x2 - $x1,2);
$y = pow($y2 - $y1,2);
$distance = sqrt($x + $y);
return $distance;
}
function time($time){
$hr = floor($time/3600);
$time = $time - ($hr*3600);
$min = floor($time/60);
$time = $time - ($min*60);
$sec = floor($time);
$time = $this->add_zero($hr).":".$this->add_zero($min).":".$this->add_zero($sec);
return $time;
}
function unit($unit, $coord1, $coord2){
$distance = $this->distance($coord1, $coord2);
$trav_time = $this->unit[str_replace('en', '', $this->current_world)][$unit] * $distance * 60;
$time = $this->time(round($trav_time));
return $time;
}
function add_zero($var){
if($var < 10){
$var = "0".$var;
}
return $var;
}
function unit_price($unit, $amount){
$wood = $amount * $this->unit[$unit]['wood'];
$clay = $amount * $this->unit[$unit]['clay'];
$iron = $amount * $this->unit[$unit]['iron'];
$total = $wood.":".$clay.":".$iron;
return $total;
}
function world_show($org_address){
$world_pre = "en";
$world_num = 1;
$world_list = "";
$num_worlds = 37;
while($world_num <= $num_worlds){
$address= $org_address;
$world = $world_pre."".$world_num;
$address = $address."/".$world."/index.php";
$world_list .= 'World '.$world.'';
$world_num++;
}
return $world_list;
}
function tribe_link($admin, $action, $tribe_id_org, $add_info=""){
$action = strtolower($action);
$display = "";
$request = "";
$style= "a";
$tribe_id = $tribe_id_org;
if($action == "show"){
//Show Current Tribe Links
$query = mysql_query("SELECT * FROM links_".$this->current_world." WHERE creator_tribe_id='".$tribe_id_org."'");
$this->check_query($query, "links_".$this->current_world, "select", "7");
while($row = mysql_fetch_array($query)){
unset($link_id, $status, $start_time, $creator_id, $creator_name, $tribe_id);
$link_id = $row['id'];
$status = $row['status'];
$start_time = $row['start_time'];
$creator_id = $row['creator_id'];
$creator_name = $row['creator_name'];
$tribe_id = $row['tribe_id'];
if(strtolower($status) != "deleted"){
$query2 = mysql_query("SELECT * FROM tribes_".$this->current_world." WHERE id='".$tribe_id."' LIMIT 1");
$this->check_query($query, "tribes_".$this->current_world, "select", "8");
while($row2 = mysql_fetch_array($query2)){
$tribe_name = $row2['tag'];
}
$days = floor((time()-$start_time)/86400);
if($style == "a"){ $style = "b"; } else { $style = "a"; }
if(strtolower($status) == "linked"){ $color = "green"; }
if(strtolower($status) == "denied"){ $color = "red"; }
if(strtolower($status) == "pending"){
$color = "orange";
if($admin == "yes"){
$request .= '| '.$status.' | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' | Remove Request |
';
} else {
$request .= '| '.$status.' | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' |
';
}
} else {
if($admin == "yes"){
$display .= '| '.$status.' | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' | Delete Link |
';
} else {
$display .= '| '.$status.' | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' |
';
}
}
unset($days);
unset($start_time);
}
}
$query = mysql_query("SELECT * FROM links_".$this->current_world." WHERE tribe_id='".$tribe_id_org."'");
$this->check_query($query, "links_".$this->current_world, "select", "9");
while($row = mysql_fetch_array($query)){
unset($link_id, $status, $start_time, $creator_id, $creator_name, $tribe_id);
$link_id = $row['id'];
$status = $row['status'];
$start_time = $row['start_time'];
$creator_id = $row['creator_id'];
$creator_name = $row['creator_name'];
$tribe_id = $row['creator_tribe_id'];
if(strtolower($status) != "deleted"){
$query2 = mysql_query("SELECT * FROM tribes_".$this->current_world." WHERE id='".$tribe_id."' LIMIT 1");
$this->check_query($query, "tribes_".$this->current_world, "select", "10");
while($row2 = mysql_fetch_array($query2)){
$tribe_name = $row2['tag'];
}
$days = floor((time()-$start_time)/86400);
if($style == "a"){ $style = "b"; } else { $style = "a"; }
if(strtolower($status) == "linked"){ $color = "green"; }
if(strtolower($status) == "denied"){ $color = "red"; }
if(strtolower($status) == "pending"){
$color = "orange";
if($admin == "yes"){
$request .= '| Accept Request -- Deny Request | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' |
';
} else {
$request .= '| Pending | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' |
';
}
} else {
if($admin == "yes"){
$display .= '| '.$status.' | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' | Delete Link |
';
} else {
$display .= '| '.$status.' | '.$tribe_name.' | '.date("d/n/Y",$start_time).' | '.$days.' | '.$creator_name.' |
';
}
}
}
}
return $display.":::::request:::::".$request;
}
if($action == "add" && $admin == "yes"){
//Add a tribe link
list($creator_id, $creator_name, $tribe_id_add) = explode(',', trim($add_info));
$status = "Pending";
$start_time = time();
$query = mysql_query("INSERT INTO links_".$this->current_world." (status,start_time,creator_id,creator_name,creator_tribe_id,tribe_id) values('$status','$start_time','$creator_id','$creator_name','$tribe_id','$tribe_id_add')");
$this->check_query($query, "links_".$this->current_world, "insert");
$query = mysql_query("SELECT * FROM tribes_".$this->current_world." WHERE id='".$tribe_id_add."' LIMIT 1");
$this->check_query($query, "tribes_".$this->current_world, "select", "11");
while($row = mysql_fetch_array($query)){
$tribe_name = $row['tag'];
}
$display = "A request has been sent to ".$tribe_name."
";
return $display;
}
}
function growth($username){
$username = mysql_real_escape_string($username);
}
function safe($var){
$var = urldecode($var);
$var = addslashes($var);
mysql_real_escape_string();
stripslashes();
strip_tags();
return $var;
}
function duke_vote($user_id, $tribe_id, $vote){
$vote = mysql_real_escape_string(trim(strtolower($vote)));
$query = mysql_query("SELECT * FROM vote_".$this->current_world." WHERE tribe_id='".$tribe_id."' AND id='".$user_id."'");
$this->check_query($query, "vote_".$this->current_world, "select", "12");
if(mysql_num_rows($query) > 0){
$result = "You already voted";
//already voted
} else {
$query = mysql_query("INSERT INTO vote_".$this->current_world." SET tribe_id='".$tribe_id."', id='".$user_id."', vote='".$vote."'");
$this->check_query($query, "vote_".$this->current_world, "insert");
$result = "Your vote on ".$vote." has been counted.
Please click here to go to the home page.";
}
return $result;
}
function number_members($tribe_id){
$query = mysql_query("SELECT members FROM tribes_".$this->current_world." WHERE id='".$tribe_id."'");
$this->check_query($query, "tribes_".$this->current_world, "select", "13");
while($row = mysql_fetch_array($query)){
$members = $row['members'];
}
return $members;
}
function check_duke($tribe_id){
$query = mysql_query("SELECT * FROM vote_".$this->current_world." WHERE tribe_id='".$tribe_id."'");
$this->check_query($query, "vote_".$this->current_world, "select", "14");
$x = 0;
$vote = array();
while($row = mysql_fetch_array($query)){
$vote[$x] = strtolower(trim($row['vote']));
$x++;
}
$array = $this->most_used($vote, "array");
$player = $array['word'];
$num_times = $array['count'];
$query = mysql_query("SELECT * FROM tribes_".$this->current_world." WHERE id='".$tribe_id."'");
$this->check_query($query, "tribes_".$this->current_world, "select", "15");
while($row = mysql_fetch_array($query)){
$members = $row['members'];
$tag = $row['tag'];
}
if(($members*0.3) <= $num_times){
$query = mysql_query("SELECT * FROM players_".$this->current_world." WHERE name='".$player."'");
$this->check_query($query, "players_".$this->current_world, "select", "16");
while($row = mysql_fetch_array($query)){
$player_id = $row['id'];
}
$query = mysql_query("SELECT * FROM info_".$this->current_world." WHERE tribe_id='".$tribe_id."'");
$this->check_query($query, "info_".$this->current_world, "select", "17");
while($row = mysql_fetch_array($query)){
$done = "done";
}
if($done == "done"){
$query = mysql_query("UPDATE info_".$this->current_world." SET admin_ids='".$player_id."'");
$this->check_query($query, "info_".$this->current_world, "update");
} else {
$query = mysql_query("INSERT INTO info_".$this->current_world." SET tribe_id='".$tribe_id."', expire_length='10:00:00:00', admin_ids=',".$player_id.",', tribe_chan='".$this->tribe_chan($tag)."'");
$this->check_query($query, "info_".$this->current_world, "update");
}
$query = mysql_query("DELETE FROM vote_".$this->current_world." WHERE tribe_id='".$tribe_id."'");
$this->check_query($query, "vote_".$this->current_world, "delete");
} elseif(count($vote) == $members){
//EVERYONE HAS VOTED AND NO ONE HAD OVER 30% OF THE VOTES
}
}
function array_depth($array) {
$max_depth = 1;
foreach ($array as $value) {
if (is_array($value)) {
$depth = array_depth($value) + 1;
if ($depth > $max_depth) {
$max_depth = $depth;
}
}
}
return $max_depth;
}
function most_used($array, $result="array"){
if(is_array($array)){
$count = Array();
$most = null;
foreach($array as $word) {
$count[$word]['count']++;
$count[$word]['word'] = $word;
}
sort($count);
$most = end($count);
if($result == "array" || $result == "both"){
$return = $most;
}
if($result == "number"){
$return = $most['count'];
}
if($result == "word"){
$return = $most['word'];
}
if($result != "both" && $result != "array" && $result != "number" && $result != "word"){
$return = $most;
}
} else {
$this->error("Not Array");
$return = "Error";
}
return $return;
}
function tribe_chan($input){
$output = str_replace(" ", "_", $input);
return $output;
}
function expire_time_conv($d, $h, $m, $s){
$total = $d * 24;
$total = ($total + $h) * 60;
$total = ($total + $m) * 60;
$total = $total + $s;
//$length = "864000";
$length = $total;
return $length;
}
function setWorld(){
$this->current_world = $_GET['world'];
}
function admin_access($tribe_id, $do="show", $user_id="", $type=""){
if($do == "show"){
//Show Admins
$query = mysql_query("SELECT * FROM info_".$this->current_world." WHERE tribe_id='".$tribe_id."'");
$this->check_query($query, "info_".$this->current_world, "select");
while($row = mysql_fetch_array($query)){
$admin_ids = explode(",", $row['admin_ids']);
}
if(is_array($admin_ids)){
foreach($admin_ids as $admin_id){
$results .= "| ".$this->get_username($admin_id)." |
";
}
}
}
if($do == "delete"){
//Delete Admin
}
if($do == "add"){
//Add Admin
}
return $results;
}
function get_username($user_id){
$query = mysql_query("SELECT * FROM players_".$this->current_world." WHERE id='".$user_id."'");
$this->check_query($query, "players_".$this->current_world, "select");
while($row = mysql_fetch_array($query)){
$name = $row['name'];
}
return $name;
}
function get_userid($username){
$query = mysql_query("SELECT * FROM players_".$this->current_world." WHERE name='".$username."'");
$this->check_query($query, "players_".$this->current_world, "select");
while($row = mysql_fetch_array($query)){
$id = $row['id'];
}
return $id;
}
function access_list($tribe_id){
//for($x=0;$x<10;$x++){ echo ' |
';
$query = mysql_query("SELECT * FROM info_".$this->current_world." WHERE tribe_id='".$tribe_id."'");
$this->check_query($query, "info_".$this->current_world, "select");
while($row = mysql_fetch_array($query)){
$admin_ids = explode(",", $row['admin_ids']);
}
$query = "SELECT * FROM players_".$this->current_world." WHERE ally='".$tribe_id."' ORDER BY rank";
$query = mysql_query($query);
while($row = mysql_fetch_array($query)){
$name = $row['name'];
$player_id = $row['id'];
if(in_array($player_id, $admin_ids)){
$checked = 'checked="checked"';
}
$display .= (' |
');
unset($name, $player_id, $checked);
}
return $display;
}
}
$claimer = new Claimer();
?>