PHP - Php & Mysql Waiting List

Haven't done much in PHP for a while, and as a refresher and a bit of a challenge to myself I have decided to write up a simple game of sorts.

Basically in the game I have townships, every play has their own town. And I want these towns to have events every 3-10 hours, and have these events have results such as births/deaths/fires/flooding/etc.

At the moment I'm looking at this kind of setup:
A database table with the city information.. city_id, city_owner_id, city_name, etc. I figure I can make another field such as city_nextevent and fill it with a timestamp plus a random number of seconds. then when the user views their city if city_nextevent is older than current time then run the event function and set the next event time.

In my head this idea seems to work well, until I realised that if the user doesn't log on for 20+ hours the events will not stack, they will only get the one event when they next view their town when several events should have passed. I realise I could use a cronjob to check all events across all towns, but is there a better way of doing it.

I had also though about adding several fields to the database containing say the next five event times, then updating each field after time had passed. Which gives more events if the user has been offline for 20+ hours. So if the play was offline for say a week, their town would pretty much dry up until they returned.

Basically, I want their town to run while they're offline. But was trying to avoid using a cronjob.

Anyone have any thoughts on how this could be done?

Hi all,

    I have a tool currently in place that pulls information from one server and displays it. Currently in the setup, whenever the status of a chat has "Waiting". It's grouped with all other's as $num_waiting. The problem I am having is do to the server it pulls the information from, 1 session would equal 11 if there are 11 reps answering chats. The issue with divising by the number of active agents is on occasion the server reports more or less than the number of agents which in turn generates responses like 3.3333 and so on.  And no the number with that status has never actually equaled to a single instance.

As such you can see my dilemma here, I need to find a way of taking all sessions with that status and most likely cross-referencing another attribute such as $customername to prevent the doubles and finally provide only a single instance for each of these sessions. I am including the bulk of the current code below. Any help is much appreciated.

Code: [Select]
<?php
$num_waiting = 0;

foreach($loginParams as $login){
    $soapclient = new soapclient("https://secure.logmeinrescue.com/API/API.asmx?WSDL");
    $loginResult = $soapclient->login($login);
    if($login[sEmail] == "lmitnifron@telenetwork.com"){
      }
     
    $hierparams = array(""=>"");
    $hierarchyResult = $soapclient->getHierarchy($hierparams);
    $hierarchy = $hierarchyResult->aHierarchy;
    $nodes = $hierarchy->HIERARCHY;
    $numberofnodes = count($nodes);
    $eNodeRef = "NODE";
    echo "<table border =\"5\" cellspacing = \"5\">";
    $totalsessioncount = 0;
    $numberoftechs = 0;
    for ($iNodes = 0; $iNodes < $numberofnodes; $iNodes += 1)
    {
      if($nodes[$iNodes]->eStatus == "Online" && $nodes[$iNodes]->eType == "Technician"){
             if($nodes[$iNodes]->iParentID == 000000  || $nodes[$iNodes]->iParentID == 00000000){
                print_r("<tr>");
                $techname = $nodes[$iNodes]->sName;
                $emailaddress = findaddress($techname);
                echo '<td><a href="xmpp:' . $emailaddress . '?message&subject=chat">' . $techname .'</a><br /></td>';     
                $iNodeID = $nodes[$iNodes]->iNodeID;
                $sessionparams = array(
                  'iNodeID' => $iNodeID,
                  'eNodeRef' => $eNodeRef
                  );
                $sessionresult = $soapclient->getSession($sessionparams);
                $session = $sessionresult->aSessions;
                $sessionnodes = $session->SESSION;
                $numberofsessionnodes = count($sessionnodes);
                $totalsessioncount = $totalsessioncount + $numberofsessionnodes;
                $numberoftechs = $numberoftechs + 1;
            
                if($numberofsessionnodes >= 2)
                {
                  for ($isessionNodes = 0; $isessionNodes < $numberofsessionnodes; $isessionNodes += 1)
                   { 
                    $session_status = $sessionnodes[$isessionNodes]->sStatus;         
                    $session_customername = $sessionnodes[$isessionNodes]->sCustomField0;
                    $isdouble = check_doubles($session_customername);
                    if(!$isdouble && ($session_status != "Waiting"))
                    {
                      if(isset($session_status)){postsessioninfo($session_status, $session_customername);}
                    }else{
                  $num_waiting++;
               }               
                  }
                }
                
                unset($session_customername);
                unset($session_starttime);
                print_r("</td>");
          }
       }
    }
   
   
   
    print_r("</table>");
    
    $soapclient->logout();
    clear_table();
}
$session_que = $num_waiting;
    echo "Sessions Waiting -- " . $session_que . "<br><br>";
?>

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hello all.
I have a php script which will insert csv data into database using PDO.
But it's slow even with just few thousands records.

So how can I prevent client from waiting for it when they want to upload data?

I tried INSERT DELAYED but it's not working...

Thank you.

Hello;

I know there is a way but I just can't get it out of my head.

I have my code that i want to show to the user and then i have code i want to execute but not show anything to user. I no am not making my self clear which i am sorry for so ill give you an example.

<?
show_my_site(true);
// Now i have code which will never output anything but the webbrowser will always wait for it to complete
my_function_that_takes_time(true, 'Very Long');
?>
So what i want is some code to tell the browser thats it! You have everything. I cant use die; or exit; because i want to execute the code.

Thank-you
Paul

Hey guys.

I'll be doing a frontend for some router testing scripts and I'll need to launch some shell scripts in php. The user will be allowed to check some checkboxes - choose which tests to run and run them using a button. I want to show them some kind of "Testing in progress" string and then show them the result when it's done. What do you think is the best solution ?

I was thinking the shell script should create the whole output in some sensible form and then I would just parse it. Should I use a database for storing the error strings, or do you think they should be a part of the script ?

Also, I would like to do it with AJAX (I never did it before and I could use some experience). So I need some advice on this. I want the form to disappear after the button was pressed, replace it with the "testing in progress" string (or maybe a temporary popup window would be better) and then if the script is done, display the result. I guess I need to use the Code: [Select]
shell_exec command.
What would you suggest ?

btw I guess there is no way to run a script on a different server than one which runs the webpage, is there ?