PHP SQRT函数代码示例

 /**
  * @param string $modelId Id of model
  * @param integer $targetId Current value of primary key
  */
 public static function updateRating($modelId, $targetId)
 {
     $likes = static::find()->where(['model_id' => $modelId, 'target_id' => $targetId, 'value' => self::VOTE_LIKE])->count();
     $dislikes = static::find()->where(['model_id' => $modelId, 'target_id' => $targetId, 'value' => self::VOTE_DISLIKE])->count();
     if ($likes + $dislikes !== 0) {
         // Рейтинг = Нижняя граница доверительного интервала Вильсона (Wilson) для параметра Бернулли
         // http://habrahabr.ru/company/darudar/blog/143188/
         $rating = (($likes + 1.9208) / ($likes + $dislikes) - 1.96 * SQRT($likes * $dislikes / ($likes + $dislikes) + 0.9604) / ($likes + $dislikes)) / (1 + 3.8416 / ($likes + $dislikes));
     } else {
         $rating = 0;
     }
     $rating = round($rating * 10, 2);
     $aggregateModel = AggregateRating::findOne(['model_id' => $modelId, 'target_id' => $targetId]);
     if (null === $aggregateModel) {
         $aggregateModel = new AggregateRating();
         $aggregateModel->model_id = $modelId;
         $aggregateModel->target_id = $targetId;
     }
     $aggregateModel->likes = $likes;
     $aggregateModel->dislikes = $dislikes;
     $aggregateModel->rating = $rating;
     $aggregateModel->save();
 }

function procDistanceTime2($coor, $thiscoor, $ref, $mode)
{
    $xdistance = ABS($thiscoor['x'] - $coor['x']);
    if ($xdistance > WORLD_MAX) {
        $xdistance = 2 * WORLD_MAX + 1 - $xdistance;
    }
    $ydistance = ABS($thiscoor['y'] - $coor['y']);
    if ($ydistance > WORLD_MAX) {
        $ydistance = 2 * WORLD_MAX + 1 - $ydistance;
    }
    $distance = SQRT(POW($xdistance, 2) + POW($ydistance, 2));
    if (!$mode) {
        if ($ref == 1) {
            $speed = 16;
        } else {
            if ($ref == 2) {
                $speed = 12;
            } else {
                if ($ref == 3) {
                    $speed = 24;
                } else {
                    if ($ref == 300) {
                        $speed = 5;
                    } else {
                        $speed = 1;
                    }
                }
            }
        }
    } else {
        $speed = $ref;
    }
    return round($distance / $speed * 3600 / INCREASE_SPEED);
}

 public function get_list($lat, $long, $page, $pagesize, $activity_type)
 {
     $where = array("status" => 0, "invite_time" => array("gt", time()));
     if ($activity_type !== false) {
         $sql = "SELECT i.*, u.* FROM " . C("DB_PREFIX") . "user as u INNER JOIN " . C("DB_PREFIX") . "invitation as i ON i.uid=u.uid WHERE i.status=0 AND i.activity_type=" . $activity_type . " AND i.invite_time>" . time() . " ORDER BY i.pigcms_id DESC, u.sex DESC";
         $where["activity_type"] = intval($activity_type);
     } else {
         $sql = "SELECT i.*, u.* FROM " . C("DB_PREFIX") . "user as u INNER JOIN " . C("DB_PREFIX") . "invitation as i ON i.uid=u.uid WHERE i.status=0 AND i.invite_time>" . time() . " ORDER BY i.pigcms_id DESC, u.sex DESC";
     }
     $start = ($page - 1) * $pagesize;
     $count = $this->where($where)->count();
     $sql .= " limit {$start}, {$pagesize}";
     $mode = new Model();
     $res = $mode->query($sql);
     $today = strtotime(date("Y-m-d")) + 86400;
     $tomorrow = $today + 86400;
     $lastday = $tomorrow + 86400;
     foreach ($res as &$v) {
         $v["_time"] = date("Y-m-d H:i", $v["invite_time"]);
         $v["juli"] = ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN(($lat * PI() / 180 - $v["lat"] * PI() / 180) / 2), 2) + COS($lat * PI() / 180) * COS($v["lat"] * PI() / 180) * POW(SIN(($long * PI() / 180 - $v["long"] * PI() / 180) / 2), 2))) * 1000);
         $v["juli"] = 1000 < $v["juli"] ? number_format($v["juli"] / 1000, 1) . "km" : ($v["juli"] < 100 ? "<100m" : $v["juli"] . "m");
         $v["invite_time"] = $v["invite_time"] < $today ? "今天 " . date("H:i", $v["invite_time"]) : ($v["invite_time"] < $tomorrow ? "明天  " . date("H:i", $v["invite_time"]) : ($v["invite_time"] < $lastday ? "后天  " . date("H:i", $v["invite_time"]) : date("m-d H:i", $v["invite_time"])));
         $v["birthday"] && ($v["age"] = date("Y") - date("Y", strtotime($v["birthday"])));
         $v["age"] = 100 < $v["age"] || $v["age"] < 0 ? "保密" : $v["age"] . "岁";
     }
     return array("data" => $res, "total" => $count);
 }

 public function procDistanceTime($coor, $thiscoor, $ref, $mode)
 {
     global $bid28, $bid14, $building;
     $xdistance = ABS($thiscoor['x'] - $coor['x']);
     if ($xdistance > WORLD_MAX) {
         $xdistance = 2 * WORLD_MAX + 1 - $xdistance;
     }
     $ydistance = ABS($thiscoor['y'] - $coor['y']);
     if ($ydistance > WORLD_MAX) {
         $ydistance = 2 * WORLD_MAX + 1 - $ydistance;
     }
     $distance = SQRT(POW($xdistance, 2) + POW($ydistance, 2));
     if (!$mode) {
         if ($ref == 1) {
             $speed = 16;
         } else {
             if ($ref == 2) {
                 $speed = 12;
             } else {
                 if ($ref == 3) {
                     $speed = 24;
                 } else {
                     if ($ref == 300) {
                         $speed = 5;
                     } else {
                         $speed = 1;
                     }
                 }
             }
         }
     } else {
         $speed = $ref;
         if ($building->getTypeLevel(14) != 0 && $distance >= TS_THRESHOLD) {
             $speed = $speed * ($bid14[$building->gettypeLevel(14)]['attri'] / 100);
         }
     }
     if ($speed != 0) {
         return round($distance / $speed * 3600 / INCREASE_SPEED);
     } else {
         return round($distance * 3600 / INCREASE_SPEED);
     }
 }

function gen_score($sid)
{
  global $ore_price;
  global $organics_price;
  global $goods_price;
  global $energy_price;
  global $upgrade_cost;
  global $upgrade_factor;
  global $dev_genesis_price;
  global $dev_beacon_price;
  global $dev_emerwarp_price;
  global $dev_warpedit_price;
  global $dev_minedeflector_price;
  global $dev_escapepod_price;
  global $dev_fuelscoop_price;
  global $dev_lssd_price;
  global $fighter_price;
  global $torpedo_price;
  global $armour_price;
  global $colonist_price;
  global $base_ore;
  global $base_goods;
  global $base_organics;
  global $base_credits;
  global $db, $dbtables;

  $calc_hull = "ROUND(pow($upgrade_factor,hull))";
  $calc_engines = "ROUND(pow($upgrade_factor,engines))";
  $calc_power = "ROUND(pow($upgrade_factor,power))";
  $calc_computer = "ROUND(pow($upgrade_factor,computer))";
  $calc_sensors = "ROUND(pow($upgrade_factor,sensors))";
  $calc_beams = "ROUND(pow($upgrade_factor,beams))";
  $calc_torp_launchers = "ROUND(pow($upgrade_factor,torp_launchers))";
  $calc_shields = "ROUND(pow($upgrade_factor,shields))";
  $calc_armour = "ROUND(pow($upgrade_factor,armour))";
  $calc_cloak = "ROUND(pow($upgrade_factor,cloak))";
  $calc_levels = "($calc_hull+$calc_engines+$calc_power+$calc_computer+$calc_sensors+$calc_beams+$calc_torp_launchers+$calc_shields+$calc_armour+$calc_cloak)*$upgrade_cost";

  $calc_torps = "torps*$torpedo_price";
  $calc_armour_pts = "armour_pts*$armour_price";
  $calc_ship_ore = "ship_ore*$ore_price";
  $calc_ship_organics = "ship_organics*$organics_price";
  $calc_ship_goods = "ship_goods*$goods_price";
  $calc_ship_energy = "ship_energy*$energy_price";
  $calc_ship_colonists = "ship_colonists*$colonist_price";
  $calc_ship_fighters = "ship_fighters*$fighter_price";
  $calc_equip = "$calc_torps+$calc_armour_pts+$calc_ship_ore+$calc_ship_organics+$calc_ship_goods+$calc_ship_energy+$calc_ship_colonists+$calc_ship_fighters";

  $calc_dev_warpedit = "dev_warpedit*$dev_warpedit_price";
  $calc_dev_genesis = "dev_genesis*$dev_genesis_price";
  $calc_dev_beacon = "dev_beacon*$dev_beacon_price";
  $calc_dev_emerwarp = "dev_emerwarp*$dev_emerwarp_price";
  $calc_dev_escapepod = "IF(dev_escapepod='Y', $dev_escapepod_price, 0)";
  $calc_dev_fuelscoop = "IF(dev_fuelscoop='Y', $dev_fuelscoop_price, 0)";
  $calc_dev_lssd = "IF(dev_lssd='Y', $dev_lssd_price, 0)";
  $calc_dev_minedeflector = "dev_minedeflector*$dev_minedeflector_price";
  $calc_dev = "$calc_dev_warpedit+$calc_dev_genesis+$calc_dev_beacon+$calc_dev_emerwarp+$calc_dev_escapepod+$calc_dev_fuelscoop+$calc_dev_minedeflector+$calc_dev_lssd";
  $calc_planet_goods = "SUM($dbtables[planets].organics)+SUM($dbtables[planets].ore)+SUM($dbtables[planets].goods)+SUM($dbtables[planets].energy)";
   //$calc_planet_goods = "SUM($dbtables[planets].organics)*$organics_price+SUM($dbtables[planets].ore)*$ore_price+SUM($dbtables[planets].goods)*$goods_price+SUM($dbtables[planets].energy)*$energy_price";
  $calc_planet_colonists = "SUM($dbtables[planets].colonists)*$colonist_price";
$calc_planet_defence = "SUM($dbtables[planets].fighters)*$fighter_price+SUM(IF($dbtables[planets].base='Y', $base_credits+$base_ore*$ore_price+$base_organics*$organics_price+$base_goods*$goods_price, 0))+SUM($dbtables[planets].torps)*$torpedo_price";
  $calc_planet_credits = "SUM($dbtables[planets].credits)";
  $res = $db->Execute("SELECT $dbtables[players].credits+$calc_planet_goods+$calc_planet_colonists+$calc_planet_defence+$calc_planet_credits AS score FROM $dbtables[players] LEFT JOIN $dbtables[planets] ON $dbtables[planets].owner=player_id WHERE player_id=$sid");
  $row = $res->fields;
  $score = $row[score];
  // New ship code - neatly calcs for every ship owned! Furangee tech is half price
  $res = $db->Execute("SELECT SUM($calc_levels+$calc_equip+$calc_dev) AS score FROM $dbtables[ships] WHERE player_id=$sid AND ship_destroyed='N' AND fur_tech='Y'");
  $row = $res->fields;
  $score += ($row[score]);
  $res = $db->Execute("SELECT SUM($calc_levels+$calc_equip+$calc_dev) AS score FROM $dbtables[ships] WHERE player_id=$sid AND ship_destroyed='N' AND fur_tech='N'");
  $row = $res->fields;
  $score += $row[score];  
  
  $res = $db->Execute("SELECT balance, loan FROM $dbtables[ibank_accounts] where player_id = $sid");
  if($res)
  {
     $row = $res->fields;
     $score += ($row[balance] - $row[loan]);
  }
  if ($score < 1000) {
	$score = 1000;
  }
  $score = ROUND(SQRT($score));
  $db->Execute("UPDATE $dbtables[players] SET score=$score WHERE player_id=$sid");

  return $score;
}

 public function getArea()
 {
     // Calculate and return the area:
     return SQRT($this->_perimeter / 2 * ($this->_perimeter / 2 - $this->_sides[0]) * ($this->_perimeter / 2 - $this->_sides[1]) * ($this->_perimeter / 2 - $this->_sides[2]));
 }

function invtcdf($p, $ndf, $dec = 4)
{
    $half_pi = M_PI / 2;
    $eps = 1.0E-12;
    $origp = $p;
    if ($p > 0.5) {
        $p = 1 - $p;
    }
    $p = $p * 2;
    if ($ndf < 1 || $p > 1 || $p <= 0) {
        echo "error in params";
        return false;
    }
    if (abs($ndf - 2) < $eps) {
        //special case ndf=2
        $fn_val = round(SQRT(2 / ($p * (2 - $p)) - 2), $dec);
        if ($origp < 0.5) {
            return -1 * $fn_val;
        } else {
            return $fn_val;
        }
    } else {
        if (abs($ndf - 4) < $eps) {
            //special case ndf=4
            $v = 4 / sqrt($p * (2 - $p)) * cos(1 / 3 * acos(sqrt($p * (2 - $p))));
            $fn_val = round(sqrt($v - 4), $dec);
            if ($origp < 0.5) {
                return -1 * $fn_val;
            } else {
                return $fn_val;
            }
        } else {
            if ($ndf < 1 + $eps) {
                //special case ndf=1
                $prob = $p * $half_pi;
                $fn_val = round(cos($prob) / sin($prob), $dec);
                if ($origp < 0.5) {
                    return -1 * $fn_val;
                } else {
                    return $fn_val;
                }
            } else {
                $a = 1 / ($ndf - 0.5);
                $b = 48 / pow($a, 2);
                $c = ((20700 * $a / $b - 98) * $a - 16) * $a + 96.36;
                $d = ((94.5 / ($b + $c) - 3) / $b + 1) * sqrt($a * $half_pi) * $ndf;
                $x = $d * $p;
                $y = pow($x, 2 / $ndf);
                if ($y > 0.05 + $a) {
                    $x = invnormalcdf($origp, $dec + 10);
                    $y = pow($x, 2);
                    if ($ndf < 5) {
                        $c = $c + 0.3 * ($ndf - 4.5) * ($x + 0.6);
                    }
                    $c = (((0.05 * $d * $x - 5) * $x - 7) * $x - 2) * $x + $b + $c;
                    $y = (((((0.4 * $y + 6.3) * $y + 36) * $y + 94.5) / $c - $y - 3) / $b + 1) * $x;
                    $y = $a * pow($y, 2);
                    if ($y > 0.002) {
                        $y = exp($y) - 1;
                    } else {
                        $y = 0.5 * pow($y, 2) + $y;
                    }
                } else {
                    $y = ((1 / ((($ndf + 6) / ($ndf * $y) - 0.089 * $d - 0.822) * ($ndf + 2) * 3) + 0.5 / ($ndf + 4)) * $y - 1) * ($ndf + 1) / ($ndf + 2) + 1 / $y;
                }
            }
        }
    }
    if ($dec > 3) {
        $fn_val = invtrefine(sqrt($ndf * $y), 1 - $p / 2, $ndf, $dec);
        //echo "orig: ".sqrt($ndf*$y).", refined: $fn_val <br/>";
    } else {
        $fn_val = round(sqrt($ndf * $y), $dec);
    }
    if ($origp < 0.5) {
        return -1 * $fn_val;
    } else {
        return $fn_val;
    }
}

 /**
  * @param $entity
  * @param $targetId
  */
 public static function updateRating($entity, $targetId)
 {
     $positive = static::find()->where(['entity' => $entity, 'target_id' => $targetId, 'value' => self::VOTE_POSITIVE])->count();
     $negative = static::find()->where(['entity' => $entity, 'target_id' => $targetId, 'value' => self::VOTE_NEGATIVE])->count();
     if ($positive + $negative !== 0) {
         $rating = (($positive + 1.9208) / ($positive + $negative) - 1.96 * SQRT($positive * $negative / ($positive + $negative) + 0.9604) / ($positive + $negative)) / (1 + 3.8416 / ($positive + $negative));
     } else {
         $rating = 0;
     }
     $rating = round($rating * 10, 2);
     $aggregateModel = VoteAggregate::findOne(['entity' => $entity, 'target_id' => $targetId]);
     if ($aggregateModel == null) {
         $aggregateModel = new VoteAggregate();
         $aggregateModel->entity = $entity;
         $aggregateModel->target_id = $targetId;
     }
     $aggregateModel->positive = $positive;
     $aggregateModel->negative = $negative;
     $aggregateModel->rating = $rating;
     $aggregateModel->save();
 }

function ogdbRadius($zip, $km, $sort = 'asc')
{
    $fileData = explode("\n", ogdbGetData());
    foreach ($fileData as $fileRow) {
        $fileRow = explode("\t", $fileRow);
        //var_dump($fileRow);
        $dataStructure = ogdbDataStructure($fileRow);
        //var_dump($dataStructure);
        if (isset($fileRow[$dataStructure['zip_pos']]) && isset($fileRow[$dataStructure['lon_pos']]) && isset($fileRow[$dataStructure['lat_pos']])) {
            if (substr_count($fileRow[$dataStructure['zip_pos']], $zip) == 1) {
                $origin_lon = $fileRow[$dataStructure['lon_pos']];
                $origin_lat = $fileRow[$dataStructure['lat_pos']];
                $id = $fileRow[0];
            }
        }
        unset($dataStructure, $fileRow);
    }
    $lambda = $origin_lon * pi() / 180;
    $phi = $origin_lat * pi() / 180;
    // Umwandlung der Kurgelkoordinaten ins kartesische Koordinatensystem
    $geoKoordX = OGDB_EARTH_RADIUS * cos($phi) * cos($lambda);
    $geoKoordY = OGDB_EARTH_RADIUS * cos($phi) * sin($lambda);
    $geoKoordZ = OGDB_EARTH_RADIUS * sin($phi);
    $data = array();
    if (isset($origin_lon) && isset($origin_lat) && isset($id)) {
        foreach ($fileData as $fileRow) {
            $fileRow = explode("\t", $fileRow);
            $dataStructure = ogdbDataStructure($fileRow);
            if (isset($fileRow[$dataStructure['zip_pos']]) && isset($fileRow[$dataStructure['lon_pos']]) && isset($fileRow[$dataStructure['lat_pos']])) {
                $distance = 2 * OGDB_EARTH_RADIUS * asin(SQRT(pow($geoKoordX - OGDB_EARTH_RADIUS * cos($fileRow[$dataStructure['lat_pos']] * pi() / 180) * cos($fileRow[$dataStructure['lon_pos']] * pi() / 180), 2) + pow($geoKoordY - OGDB_EARTH_RADIUS * cos($fileRow[$dataStructure['lat_pos']] * pi() / 180) * sin($fileRow[$dataStructure['lon_pos']] * pi() / 180), 2) + pow($geoKoordZ - OGDB_EARTH_RADIUS * sin($fileRow[$dataStructure['lat_pos']] * pi() / 180), 2)) / (2 * OGDB_EARTH_RADIUS));
                // var_dump($distance);
                // die;
                //var_dump($fileRow[3] . '<b> '. round($distance, 2) .'</b>');
                //die;
                if ($distance < $km and $fileRow[3] != '') {
                    $data[($distance + 0.01) * 1000] = array('loc_id' => $fileRow[0], 'name' => $fileRow[3], 'zip' => $fileRow[$dataStructure['zip_pos']], 'distance' => $distance, 'adresse' => $fileRow[16], 'lat_pos' => $fileRow[4], 'lon_pos' => $fileRow[5], 'url' => $fileRow[12]);
                }
                //var_dump($data);
                unset($distance);
            }
            unset($dataStructure, $fileRow);
        }
    }
    switch ($sort) {
        case 'asc':
            ksort($data);
            break;
        case 'desc':
            krsort($data);
            break;
    }
    return $data;
}

 public function generate_score($user_id)
 {
     $sql_manager = new manage_table();
     global $db_prefix;
     global $db;
     global $upgrade_factor;
     global $upgrade_cost;
     global $torpedo_price;
     global $armor_price;
     global $fighter_price;
     global $ore_price;
     global $organics_price;
     global $goods_price;
     global $energy_price;
     global $colonist_price;
     global $dev_genesis_price;
     global $dev_beacon_price;
     global $dev_emerwarp_price;
     global $dev_warpedit_price;
     global $dev_minedeflector_price;
     global $dev_escapepod_price;
     global $dev_fuelscoop_price;
     global $dev_lssd_price;
     global $base_ore;
     global $base_goods;
     global $base_organics;
     global $base_credits;
     $calc_hull = "ROUND(pow({$upgrade_factor},hull))";
     $calc_engines = "ROUND(pow({$upgrade_factor},engines))";
     $calc_power = "ROUND(pow({$upgrade_factor},power))";
     $calc_computer = "ROUND(pow({$upgrade_factor},computer))";
     $calc_sensors = "ROUND(pow({$upgrade_factor},sensors))";
     $calc_beams = "ROUND(pow({$upgrade_factor},beams))";
     $calc_torp_launchers = "ROUND(pow({$upgrade_factor},torp_launchers))";
     $calc_shields = "ROUND(pow({$upgrade_factor},shields))";
     $calc_armor = "ROUND(pow({$upgrade_factor},armor))";
     $calc_cloak = "ROUND(pow({$upgrade_factor},cloak))";
     $calc_levels = "({$calc_hull} + {$calc_engines} + {$calc_power} + {$calc_computer} + {$calc_sensors} + {$calc_beams} + {$calc_torp_launchers} + {$calc_shields} + {$calc_armor} + {$calc_cloak}) * {$upgrade_cost}";
     $calc_torps = "" . $db_prefix . "ships.torps * {$torpedo_price}";
     $calc_armor_pts = "armor_pts * {$armor_price}";
     $calc_ship_ore = "ship_ore * {$ore_price}";
     $calc_ship_organics = "ship_organics * {$organics_price}";
     $calc_ship_goods = "ship_goods * {$goods_price}";
     $calc_ship_energy = "ship_energy * {$energy_price}";
     $calc_ship_colonists = "ship_colonists * {$colonist_price}";
     $calc_ship_fighters = "ship_fighters * {$fighter_price}";
     $calc_equip = "{$calc_torps} + {$calc_armor_pts} + {$calc_ship_ore} + {$calc_ship_organics} + {$calc_ship_goods} + {$calc_ship_energy} + {$calc_ship_colonists} + {$calc_ship_fighters}";
     $calc_dev_warpedit = "dev_warpedit * {$dev_warpedit_price}";
     $calc_dev_genesis = "dev_genesis * {$dev_genesis_price}";
     $calc_dev_beacon = "dev_beacon * {$dev_beacon_price}";
     $calc_dev_emerwarp = "dev_emerwarp * {$dev_emerwarp_price}";
     $calc_dev_escapepod = "if (dev_escapepod='Y', {$dev_escapepod_price}, 0)";
     $calc_dev_fuelscoop = "if (dev_fuelscoop='Y', {$dev_fuelscoop_price}, 0)";
     $calc_dev_lssd = "if (dev_lssd='Y', {$dev_lssd_price}, 0)";
     $calc_dev_minedeflector = "dev_minedeflector * {$dev_minedeflector_price}";
     $calc_dev = "{$calc_dev_warpedit} + {$calc_dev_genesis} + {$calc_dev_beacon} + {$calc_dev_emerwarp} + {$calc_dev_escapepod} + {$calc_dev_fuelscoop} + {$calc_dev_minedeflector} + {$calc_dev_lssd}";
     $calc_planet_goods = "SUM(" . $db_prefix . "planets.organics) * {$organics_price} + SUM(" . $db_prefix . "planets.ore) * {$ore_price} + SUM(" . $db_prefix . "planets.goods) * {$goods_price} + SUM(" . $db_prefix . "planets.energy) * {$energy_price}";
     $calc_planet_colonists = "SUM(" . $db_prefix . "planets.colonists) * {$colonist_price}";
     $calc_planet_defence = "SUM(" . $db_prefix . "planets.fighters) * {$fighter_price} + if (" . $db_prefix . "planets.base='Y', {$base_credits} + SUM(" . $db_prefix . "planets.torps) * {$torpedo_price}, 0)";
     $calc_planet_credits = "SUM(" . $db_prefix . "planets.credits)";
     $result_planet = $this->connect->query("SELECT if(COUNT(*)>0, " . $calc_planet_goods . " + " . $calc_planet_colonists . " + " . $calc_planet_defence . " + " . $calc_planet_credits . ", 0) as planet_score FROM " . $db_prefix . "planets WHERE owner=" . $user_id . "");
     $result_planet = $result_planet->fetch();
     $planet_score = $result_planet['planet_score'];
     $result_player = $this->connect->query("SELECT if(COUNT(*)>0, " . $calc_levels . " + " . $calc_equip . " + " . $calc_dev . " + " . $db_prefix . "ships.credits, 0) AS ship_score FROM " . $db_prefix . "ships LEFT JOIN " . $db_prefix . "planets ON " . $db_prefix . "planets.owner=ship_id WHERE ship_id=" . $user_id . " AND ship_destroyed='N'");
     $result_player = $result_player->fetch();
     $ship_score = $result_player['ship_score'];
     $result_bank = $this->connect->query("SELECT (balance - loan) as bank_score FROM " . $db_prefix . "ibank_accounts WHERE ship_id=" . $user_id . "");
     $result_bank = $result_bank->fetch();
     $bank_score = $result_bank['bank_score'];
     $score = $ship_score + $planet_score + $bank_score;
     if ($score < 0) {
         $score = 0;
     }
     $score = (int) ROUND(SQRT($score));
     $updated_stats = array('score' => $score);
     $sql_manager->updatePlayer($user_id, "ships", $updated_stats);
     return $score;
 }

function gen_score($sid)
{
    global $db;
    global $upgrade_factor;
    global $upgrade_cost;
    global $torpedo_price;
    global $armor_price;
    global $fighter_price;
    global $ore_price;
    global $organics_price;
    global $goods_price;
    global $energy_price;
    global $colonist_price;
    global $dev_genesis_price;
    global $dev_beacon_price;
    global $dev_emerwarp_price;
    global $dev_warpedit_price;
    global $dev_minedeflector_price;
    global $dev_escapepod_price;
    global $dev_fuelscoop_price;
    global $dev_lssd_price;
    global $base_ore;
    global $base_goods;
    global $base_organics;
    global $base_credits;
    $calc_hull = "ROUND(pow({$upgrade_factor},hull))";
    $calc_engines = "ROUND(pow({$upgrade_factor},engines))";
    $calc_power = "ROUND(pow({$upgrade_factor},power))";
    $calc_computer = "ROUND(pow({$upgrade_factor},computer))";
    $calc_sensors = "ROUND(pow({$upgrade_factor},sensors))";
    $calc_beams = "ROUND(pow({$upgrade_factor},beams))";
    $calc_torp_launchers = "ROUND(pow({$upgrade_factor},torp_launchers))";
    $calc_shields = "ROUND(pow({$upgrade_factor},shields))";
    $calc_armor = "ROUND(pow({$upgrade_factor},armor))";
    $calc_cloak = "ROUND(pow({$upgrade_factor},cloak))";
    $calc_levels = "({$calc_hull} + {$calc_engines} + {$calc_power} + {$calc_computer} + {$calc_sensors} + {$calc_beams} + {$calc_torp_launchers} + {$calc_shields} + {$calc_armor} + {$calc_cloak}) * {$upgrade_cost}";
    $calc_torps = "{$db->prefix}ships.torps * {$torpedo_price}";
    $calc_armor_pts = "armor_pts * {$armor_price}";
    $calc_ship_ore = "ship_ore * {$ore_price}";
    $calc_ship_organics = "ship_organics * {$organics_price}";
    $calc_ship_goods = "ship_goods * {$goods_price}";
    $calc_ship_energy = "ship_energy * {$energy_price}";
    $calc_ship_colonists = "ship_colonists * {$colonist_price}";
    $calc_ship_fighters = "ship_fighters * {$fighter_price}";
    $calc_equip = "{$calc_torps} + {$calc_armor_pts} + {$calc_ship_ore} + {$calc_ship_organics} + {$calc_ship_goods} + {$calc_ship_energy} + {$calc_ship_colonists} + {$calc_ship_fighters}";
    $calc_dev_warpedit = "dev_warpedit * {$dev_warpedit_price}";
    $calc_dev_genesis = "dev_genesis * {$dev_genesis_price}";
    $calc_dev_beacon = "dev_beacon * {$dev_beacon_price}";
    $calc_dev_emerwarp = "dev_emerwarp * {$dev_emerwarp_price}";
    $calc_dev_escapepod = "if (dev_escapepod='Y', {$dev_escapepod_price}, 0)";
    $calc_dev_fuelscoop = "if (dev_fuelscoop='Y', {$dev_fuelscoop_price}, 0)";
    $calc_dev_lssd = "if (dev_lssd='Y', {$dev_lssd_price}, 0)";
    $calc_dev_minedeflector = "dev_minedeflector * {$dev_minedeflector_price}";
    $calc_dev = "{$calc_dev_warpedit} + {$calc_dev_genesis} + {$calc_dev_beacon} + {$calc_dev_emerwarp} + {$calc_dev_escapepod} + {$calc_dev_fuelscoop} + {$calc_dev_minedeflector} + {$calc_dev_lssd}";
    $calc_planet_goods = "SUM({$db->prefix}planets.organics) * {$organics_price} + SUM({$db->prefix}planets.ore) * {$ore_price} + SUM({$db->prefix}planets.goods) * {$goods_price} + SUM({$db->prefix}planets.energy) * {$energy_price}";
    $calc_planet_colonists = "SUM({$db->prefix}planets.colonists) * {$colonist_price}";
    $calc_planet_defence = "SUM({$db->prefix}planets.fighters) * {$fighter_price} + if ({$db->prefix}planets.base='Y', {$base_credits} + SUM({$db->prefix}planets.torps) * {$torpedo_price}, 0)";
    $calc_planet_credits = "SUM({$db->prefix}planets.credits)";
    $res = $db->Execute("SELECT if(COUNT(*)>0, {$calc_planet_goods} + {$calc_planet_colonists} + {$calc_planet_defence} + {$calc_planet_credits}, 0) as planet_score FROM {$db->prefix}planets WHERE owner=?", array($sid));
    db_op_result($db, $res, __LINE__, __FILE__);
    $planet_score = $res->fields['planet_score'];
    $res = $db->Execute("SELECT if(COUNT(*)>0, {$calc_levels} + {$calc_equip} + {$calc_dev} + {$db->prefix}ships.credits, 0) AS ship_score FROM {$db->prefix}ships LEFT JOIN {$db->prefix}planets ON {$db->prefix}planets.owner=ship_id WHERE ship_id=? AND ship_destroyed='N'", array($sid));
    db_op_result($db, $res, __LINE__, __FILE__);
    $ship_score = $res->fields['ship_score'];
    $res = $db->Execute("SELECT (balance - loan) as bank_score FROM {$db->prefix}ibank_accounts WHERE ship_id = ?;", array($sid));
    db_op_result($db, $res, __LINE__, __FILE__);
    $bank_score = $res->fields['bank_score'];
    $score = $ship_score + $planet_score + $bank_score;
    if ($score < 0) {
        $score = 0;
    }
    $score = (int) ROUND(SQRT($score));
    $resa = $db->Execute("UPDATE {$db->prefix}ships SET score=? WHERE ship_id=?", array($score, $sid));
    db_op_result($db, $resa, __LINE__, __FILE__);
    return $score;
}

 private function procDistanceTime($coor, $thiscoor, $ref, $mode)
 {
     global $bid14, $database, $generator;
     $resarray = $database->getResourceLevel($generator->getBaseID($coor['x'], $coor['y']));
     $xdistance = ABS($thiscoor['x'] - $coor['x']);
     if ($xdistance > WORLD_MAX) {
         $xdistance = 2 * WORLD_MAX + 1 - $xdistance;
     }
     $ydistance = ABS($thiscoor['y'] - $coor['y']);
     if ($ydistance > WORLD_MAX) {
         $ydistance = 2 * WORLD_MAX + 1 - $ydistance;
     }
     $distance = SQRT(POW($xdistance, 2) + POW($ydistance, 2));
     if (!$mode) {
         if ($ref == 1) {
             $speed = 16;
         } else {
             if ($ref == 2) {
                 $speed = 12;
             } else {
                 if ($ref == 3) {
                     $speed = 24;
                 } else {
                     if ($ref == 300) {
                         $speed = 5;
                     } else {
                         $speed = 1;
                     }
                 }
             }
         }
     } else {
         $speed = $ref;
         for ($i = 19; $i <= 40; $i++) {
             if ($resarray['f' . $i . 't'] == 14) {
                 $ts_level = $resarray['f' . $i];
                 $ts_attri = $bid14[$ts_level]['attri'];
             }
         }
         if ($ts_attri > 0) {
             $speed = $distance <= TS_THRESHOLD ? $speed : $speed * ((TS_THRESHOLD + ($distance - TS_THRESHOLD) * $ts_attri / 100) / $distance);
         }
     }
     return round($distance / $speed * 3600 / INCREASE_SPEED);
 }

 public function getArea()
 {
     $p = $this->perimeter / 2;
     return SQRT($p * ($p - $this->sides[0]) * ($p - $this->sides[1]) * ($p - $this->sides[2]));
 }

function ogdbRadius($zip, $km, $sort = 'asc')
{
    ini_set('precision', 49);
    // http://de2.php.net/manual/de/function.pi.php
    $fileData = explode("\n", ogdbGetData());
    foreach ($fileData as $fileRow) {
        $fileRow = explode("\t", $fileRow);
        $dataStructure = ogdbDataStructure($fileRow);
        if (isset($fileRow[$dataStructure['zip_pos']]) && isset($fileRow[$dataStructure['lon_pos']]) && isset($fileRow[$dataStructure['lat_pos']])) {
            if (substr_count($fileRow[$dataStructure['zip_pos']], $zip) == 1) {
                $origin_lon = $fileRow[$dataStructure['lon_pos']];
                $origin_lat = $fileRow[$dataStructure['lat_pos']];
                $id = $fileRow[0];
            }
        }
        unset($dataStructure, $fileRow);
    }
    $lambda = $origin_lon * pi() / 180;
    $phi = $origin_lat * pi() / 180;
    // Umwandlung der Kurgelkoordinaten ins kartesische Koordinatensystem
    $geoKoordX = OGDB_EARTH_RADIUS * cos($phi) * cos($lambda);
    $geoKoordY = OGDB_EARTH_RADIUS * cos($phi) * sin($lambda);
    $geoKoordZ = OGDB_EARTH_RADIUS * sin($phi);
    $data = array();
    if (isset($origin_lon) && isset($origin_lat) && isset($id)) {
        foreach ($fileData as $fileRow) {
            $fileRow = explode("\t", $fileRow);
            $dataStructure = ogdbDataStructure($fileRow);
            if (isset($fileRow[$dataStructure['zip_pos']]) && isset($fileRow[$dataStructure['lon_pos']]) && isset($fileRow[$dataStructure['lat_pos']])) {
                $distance = 2 * OGDB_EARTH_RADIUS * asin(SQRT(pow($geoKoordX - OGDB_EARTH_RADIUS * cos($fileRow[$dataStructure['lat_pos']] * pi() / 180) * cos($fileRow[$dataStructure['lon_pos']] * pi() / 180), 2) + pow($geoKoordY - OGDB_EARTH_RADIUS * cos($fileRow[$dataStructure['lat_pos']] * pi() / 180) * sin($fileRow[$dataStructure['lon_pos']] * pi() / 180), 2) + pow($geoKoordZ - OGDB_EARTH_RADIUS * sin($fileRow[$dataStructure['lat_pos']] * pi() / 180), 2)) / (2 * OGDB_EARTH_RADIUS));
                if ($distance < $km && $id != $fileRow[0]) {
                    $data[$distance] = array('loc_id' => $fileRow[0], 'name' => $fileRow[3], 'zip' => $fileRow[$dataStructure['zip_pos']], 'distance' => $distance);
                }
                unset($distance);
            }
            unset($dataStructure, $fileRow);
        }
    }
    switch ($sort) {
        case 'asc':
            ksort($data);
            break;
        case 'desc':
            krsort($data);
            break;
    }
    return $data;
}

 public function wap_get_store_list_by_catid($cat_id, $area_id, $order, $lat, $long, $cat_url)
 {
     $stores = D('Store_category')->field('store_id')->where("cat_id='{$cat_id}'")->select();
     foreach ($stores as $s) {
         $store_ids[] = $s['store_id'];
     }
     $store_ids && ($where['store_id'] = array('in', $store_ids));
     if ($cat_url == 'dianying' && empty($store_ids)) {
         return false;
     }
     // 		$where['have_meal'] = 1;
     $where['status'] = 1;
     $area_id && ($where['area_id'] = $area_id);
     $count = D('Merchant_store')->where($where)->count();
     //排序
     switch ($order) {
         case 'distance':
             $order = "ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN(({$lat} * PI() / 180- `lat` * PI()/180)/2),2)+COS({$lat} *PI()/180)*COS(`lat`*PI()/180)*POW(SIN(({$long} *PI()/180- `long`*PI()/180)/2),2)))*1000) ASC";
             //'`g`.`price` ASC,`g`.`group_id` DESC';
             break;
             // 			case 'priceDesc':
             // 				$order = '`g`.`price` DESC,`g`.`group_id` DESC';
             // 				break;
             // 			case 'solds':
             // 				$order = '`g`.`sale_count` DESC,`g`.`group_id` DESC';
             // 				break;
             // 			case 'rating':
             // 				$order = '`g`.`score_mean` DESC,`g`.`group_id` DESC';
             // 				break;
             // 			case 'start':
             // 				$order = '`g`.`last_time` DESC,`g`.`group_id` DESC';
             // 				break;
         // 			case 'priceDesc':
         // 				$order = '`g`.`price` DESC,`g`.`group_id` DESC';
         // 				break;
         // 			case 'solds':
         // 				$order = '`g`.`sale_count` DESC,`g`.`group_id` DESC';
         // 				break;
         // 			case 'rating':
         // 				$order = '`g`.`score_mean` DESC,`g`.`group_id` DESC';
         // 				break;
         // 			case 'start':
         // 				$order = '`g`.`last_time` DESC,`g`.`group_id` DESC';
         // 				break;
         default:
             $order = '`store_id` DESC';
     }
     import('@.ORG.wap_group_page');
     $p = new Page($count, C('config.group_page_row'), C('config.group_page_val'));
     $list = D('Merchant_store')->field(true)->where($where)->order($order)->limit($p->firstRow . ',' . $p->listRows)->select();
     // 		echo D('Merchant_store')->_sql();
     $return['pagebar'] = $p->show();
     if ($list) {
         $store_image_class = new store_image();
         foreach ($list as &$v) {
             $images = $store_image_class->get_allImage_by_path($v['pic_info']);
             $v['image'] = $images ? array_shift($images) : '';
             $v['juli'] = ROUND(6378.138 * 2 * ASIN(SQRT(POW(SIN(($lat * PI() / 180 - $v['lat'] * PI() / 180) / 2), 2) + COS($lat * PI() / 180) * COS($v['lat'] * PI() / 180) * POW(SIN(($long * PI() / 180 - $v['long'] * PI() / 180) / 2), 2))) * 1000);
             $v['juli'] = $v['juli'] > 1000 ? number_format($v['juli'] / 1000, 1) . 'km' : ($v['juli'] < 100 ? '<100m' : $v['juli'] . 'm');
         }
     }
     $return['store_list'] = $list;
     return $return;
 }