|
|
Posted by Jerry Stuckle on 05/29/06 22:03
scuniverse@gmail.com wrote:
> Here is part of the code, it's a little long though
>
> <?php
> //Timer
> function getmicrotime()
> {
> list($usec, $sec) = explode(" ", microtime());
> return((float)$usec + (float)$sec);
> }
> $time_start = getmicrotime();
>
> function totaltime($time_start)
> {
> $time_end = getmicrotime();
> return(round(($time_end - $time_start), 6));
> }
>
> //Code
> include_once("../inc/config.php");
> error_reporting (E_ERROR);
>
> dbConnect("sessions");
> $sqlUID = "SELECT ID, Race, Min, Gaz, Size FROM user";
> $UsersID = mysql_query($sqlUID) or die("Query failed");
>
> $i = 1;
> while ($UserID = mysql_fetch_array($UsersID)) {
> $UrsID = $UserID['ID'];
>
> // Terran
> if ($UserID['Race'] == 'Terran') {
> $sqlOBu = "SELECT * FROM units WHERE ID = '$UrsID'";
> $UserOnB = mysql_query($sqlOBu) or die("Query B failed");
> $UserONBU = mysql_fetch_array($UserOnB);
>
> $sqlBU = "SELECT * FROM build WHERE ID = '$UrsID'";
> $UserB = mysql_query($sqlBU) or die("Query B failed");
> $UserBU = mysql_fetch_array($UserB);
>
> //units build on the barracks
> $FACB = $UserONBU[4] + $UserONBU[6] + $UserONBU[8] +
> $UserONBU[10];
> //units build on the factory
> $FACF = $UserONBU[12] + $UserONBU[14] + $UserONBU[16];
> //Buildings built by the SCV
> $FACSCV = $UserBU[2] + $UserBU[4] + $UserBU[6] + $UserBU[8] +
> $UserBU[10] + $UserBU[12] + $UserBU[14] + $UserBU[16] + $UserBU[18] +
> $UserBU[20];
>
> //SCV per tick
> $SCVPT = $UserBU[1] * 5;
> //Total SCV built this tick
> $SCVTA = $UserONBU[2] - $SCVPT;
> //same as for SCV only for the rest of the units
> $MarPT = $UserBU[9] * 4.2 * ($UserONBU[6] / $FACB);
> $MarTA = $UserONBU[6] - $MarPT;
> $FirPT = $UserBU[9] * 4.2 * ($UserONBU[8] / $FACB);
> $FirTA = $UserONBU[8] - $FirPT;
> $GhoPT = $UserBU[9] * 2 * ($UserONBU[10] / $FACB);
> $GhoTA = $UserONBU[10] - $GhoPT;
> $VulPT = $UserBU[17] * 3.3 * ($UserONBU[12] / $FACF);
> $VulTA = $UserONBU[12] - $VulPT;
> $GolPT = $UserBU[17] * 2.5 * ($UserONBU[14] / $FACF);
> $GolTA = $UserONBU[14] - $GolPT;
> $TanPT = $UserBU[17] * 2 * ($UserONBU[16] / $FACF);
> $TanTA = $UserONBU[16] - $TanPT;
>
>
> //Total SCVs and remaining SCVs to be built
> if ($SCVTA < 0 or $SCVTA == 0) {
> $SCVTAD = $UserONBU[2] + $UserONBU[1];
> $SCVOB = 0;
> } else {
> $SCVTAD = $SCVPT + $UserONBU[1];
> $SCVOB = $SCVTA;
> }
> if ($MarTA < 0 or $MarTA == 0) {
> $MarTAD = $UserONBU[6] + $UserONBU[5];
> $MarOB = 0;
> } else {
> $MarTAD = $MarPT + $UserONBU[5];
> $MarOB = $MarTA;
> }
> if ($FirTA < 0 or $FirTA == 0) {
> $FirTAD = $UserONBU[8] + $UserONBU[7];
> $FirOB = 0;
> } else {
> $FirTAD = $FirPT + $UserONBU[7];
> $FirOB = $FirTA;
> }
> if ($GhoTA < 0 or $GhoTA == 0) {
> $GhoTAD = $UserONBU[10] + $UserONBU[9];
> $GhoOB = 0;
> } else {
> $GhoTAD = $GhoPT + $UserONBU[9];
> $GhoOB = $GhoTA;
> }
> if ($MedTA < 0 or $MedTA == 0) {
> $MedTAD = $UserONBU[3] + $UserONBU[4];
> $MedOB = 0;
> } else {
> $MedTAD = $MedPT + $UserONBU[3];
> $MedOB = $MedTA;
> }
> if ($VulTA < 0 or $VulTA == 0) {
> $VulTAD = $UserONBU[11] + $UserONBU[12];
> $VulOB = 0;
> } else {
> $VulTAD = $VulPT + $UserONBU[11];
> $VulOB = $VulTA;
> }
> if ($GolTA < 0 or $GolTA == 0) {
> $GolTAD = $UserONBU[13] + $UserONBU[14];
> $GolOB = 0;
> } else {
> $GolTAD = $GolPT + $UserONBU[13];
> $GolOB = $GolTA;
> }
> if ($TanTA < 0 or $TanTA == 0) {
> $TanTAD = $UserONBU[15] + $UserONBU[16];
> $TanOB = 0;
> } else {
> $TanTAD = $TanPT + $UserONBU[15];
> $TanOB = $TanTA;
> }
>
>
> //Total strenght
> $Nstrenght = ($UserID['Size'] / 2) + ($UserBU[1] * 2 +
> $UserBU[3] + $UserBU[5] + $UserBU[7] + $UserBU[9] + $UserBU[11] +
> $UserBU[13] + $UserBU[15]) + $UserBU[17] + $UserBU[19] + ($UserONBU[1]
> * 2 + $UserONBU[3] + $UserONBU[5] + $UserONBU[7] + $UserONBU[9] +
> $UserONBU[11] + $UserONBU[13] + $UserONBU[15]);
>
> //calcul of the SCV and command center effect on minerals and
> gaz gathering
> $LCC = log10(($UserBU[1] / $UserID['Size']) * 10 + 1);
> $LSC = log(($UserONBU[1] / $UserID['Size']) + 1, 2);
> $Fac = $LCC * $LSC * $UserID['Size'] * 100;
>
> $NMin = (int)($Fac + $UserID[1]);
> $NGz = (int)(($Fac / 3) + $UserID[2]);
>
> //Automatic increase of land... for now.
> $NSize = ($UserID['Size'] * 0.01 + 1) + $UserID['Size'];
>
> $UpdateOB = mysql_query("UPDATE units SET
> SCVEd='$SCVTAD',SCVIng='$SCVOB',MarEd='$MarTAD',MarIng='$MarOB',FireEd='$FirTAD',FireIng='$FirOB'
> ,GhostEd='$GhoTAD',GhostIng='$GhoOB',MedEd='$MedTAD',MedIng='$MedOB',VulEd='$VulTAD',VulIng='$VulOB',GolEd='$GolTAD',GolIng='$GolOB'
> ,TankEd='$TanTAD',TankIng='$TanOB' WHERE ID='$UrsID'") or
> die(mysql_error());
>
> $UpdateBU = mysql_query("UPDATE build SET
> CCB='$CCoTAD',CCOB='$CCoOB',SDB='$DepTAD',SDOB='$DepOB',RefB='$RefTAD',RefOB='$RefOB',BarrB='$BarTAD',BarrOB='$BarOB'
> ,FacB='$FacTAD',FacOB='$FacOB',EBB='$BayTAD',EBOB='$BayOB',AcaB='$AcaTAD',AcaOB='$AcaOB',ArmB='$ArmTAD',ArmOB='$ArmOB',SFB='$SciTAD',SFOB='$SciOB'
> ,BunkB='$BunTAD',BunkOB='$BunOB' WHERE ID='$UrsID'") or
> die(mysql_error());
>
> $UpdateMG = mysql_query("UPDATE user SET
> Min='$NMin',Gaz='$NGz',NW='$Nstrenght',Size='$NSize' WHERE
> ID='$UrsID'") or die(showError('3', mysql_error()));
> }
>
>
>
> I've cut a part on the code but its basically the same thing only for
> the building where here its just for the units and there's 2 more
> cases afterwards for 2 other races, the division by zero errors I get
> them after "//SCV per tick" and every time I divide something by
> $FACB, this variable is usually not 0, its 0 now cause I'm still
> testing this, that said I could put a condition there cause there's
> no point to do that part when $FACB = 0 or $FACF =0.
>
> Is it possible that the server slows down the speed of the script for
> some reason ? seems to me that there's a link between the error
> messages and the time it takes to run the script, and this only happens
> with the web cron service and not when I request the url with a browser.
>
Well, among other things, when you get an error, it takes time to process the
error, log it and attempt to recover from it.
Division by zero is a hardware detected problem. So the error processing starts
at the very lowest level and has to percolate up the chain the the PHP error
recovery routines (which eventually handle it).
The bottom line is - you should never get run-time errors.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|