PHP - Quote - Creating A Chat With Moderation And Admin Options Php

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:

Seeking some input, please.

I use single-pages in my admin panel to update and maintain each corresponding page on the front end.
Code: [Select]
ADMIN = FRONT END
a_Home.php = Home.php
a_About.php = About.php
Etc...

The code is the same for each page, except I have to rename the TABLE everytime I make a new page:
Code: [Select]
<?php

include('../include/myConn.php'); //contains your mysql connection and table selection
include('../include/myCodeLib.php');
include('include/myCheckLogin.php');
include('include/myAdminNav.php');

include('ckfinder/ckfinder.php');
include('ckeditor/ckeditor.php');

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{

$myTitle = mysql_real_escape_string($_POST['myTitle']);
$myDesc = mysql_real_escape_string($_POST['myDesc']);
$myHeader = mysql_real_escape_string($_POST['myHeader']);
$mySubHeader = mysql_real_escape_string($_POST['mySubHeader']);
$myPageData = mysql_real_escape_string($_POST['myPageData']);

$sql = "
UPDATE myTestimonials
   SET
      myTitle = '$myTitle',
      myDesc = '$myDesc',
      myHeader = '$myHeader',
      mySubHeader = '$mySubHeader',
      myPageData = '$myPageData'
  ";
    
mysql_query($sql) && mysql_affected_rows()
    
?>

<script language="JavaScript">
alert("This page was updated!");
location.href = "a_Testimonials.php";
</script>

<?php
}


$query=mysql_query("SELECT * FROM myTestimonials") or die("Could not get data from db: ".mysql_error());
while($result=mysql_fetch_array($query))
{
  $myTitle=$result['myTitle'];
  $myDesc=$result['myDesc'];
  $myHeader=$result['myHeader'];
  $mySubHeader=$result['mySubHeader'];
  $myPageData=$result['myPageData'];
}
?>

<!DOCTYPE HTML>

<html>

<head>

<meta name="author" content="MontyTheWebmaster.com" />
<meta charset="ISO-8859-1" />

<title>Admin Area</title>

<?php echo spAdminLinks(); ?>

</head>

<body>

<div id="siteContainer">

<div id="topContainer">
<?php echo spAdminTopMenu(); ?>
</div>

<div id="topMenuContainer">
<div id="topMenu">
<?php echo spAdminMenu(); ?>
</div>
</div>

<div id="contentContainer">


<div id="mainContent">

<h1>Editing: Testimonials</h1>

<p>

         <form method="post" action="<?php echo $PHP_SELF;?>">
         <input type="hidden" name="POSTBACK" value="EDIT">
         
         
         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page Title:
         
         </div>
         
         <div style="float: left; width: 550px;">
         
         <textarea cols="80" rows="1" name="myTitle"><?php echo $myTitle; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>
         

         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page Description:
         
         </div>
         
         <div style="float: left; width: 550px;">
         
         <textarea cols="80" rows="1" name="myDesc"><?php echo $myDesc; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>
         
         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page Header:
         
         </div>
         
         <div style="float: left; width: 550px;">
                 
         <textarea cols="80" rows="1" name="myHeader"><?php echo $myHeader; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>

         <div style="float: left; width: 120px; margin-right: 30px;">
         
         Page SubHeader:
         
         </div>
         
         <div style="float: left; width: 550px;">
                 
         <textarea cols="80" rows="1" name="mySubHeader"><?php echo $mySubHeader; ?></textarea>
         
         </div>

         <div style="clear: both;"><br /></div>
         
         Page Content:<br />         
         
         <textarea cols="80" id="myPageData" name="myPageData"><?php echo $myPageData; ?></textarea>




            <script type="text/javascript">
             
             CKEDITOR.replace( 'myPageData',
      {
          filebrowserBrowseUrl : 'ckfinder/ckfinder.html',
          filebrowserImageBrowseUrl : 'ckfinder/ckfinder.html?Type=Images',
          filebrowserFlashBrowseUrl : 'ckfinder/ckfinder.html?Type=Flash',
          filebrowserUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Files',
          filebrowserImageUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Images',
          filebrowserFlashUploadUrl : 'ckfinder/core/connector/php/connector.php?command=QuickUpload&type=Flash'
      }
);

            </script>




       
         <br />
         
         <input type="submit" value="Submit" />

         </form>

</p>

</div>

<div style="clear: both;"></div>

</div>

<div id="footerContainer">

<?php echo spAdminFooter(); ?>

</div>

</div>

</body>

</html>

What I am curious about is how can I take this page and make it so I can add a new page, delete a page, etc. all from just one page like above?

And on the frontend, what would be the best way to display the data in a search engine friendly way (i.e. without QueryStrings like MyPage.php?id=2

Hello guys, hope all of you are doing good. I want to ask a quick question . I have developed this track and trace application (php script) through which users can trace their shipment by entering a bill of lading number in the track and trace interface on our website and then the information stored in our database is displayed to them. Currently, what I do to add new or change the status of existing bill of lading numbers is that first I have to log in to the cPanel of my website, then I need to log in to phpmyadmin and then I can add new bill of lading numbers or change the number of existing bill of lading numbers. This is a pretty long way and I don't want to give the cPanel password to other employees so that they can do the job of entering bill of lading numbers. So I was thinking that can an interface be created through which any employee can add new or change the status etc. of the bill of lading numbers stored in the database without actually logging in to phpmyadmin? The interface would obviously be connected to the database and any new bill of lading number entered through the interface should automatically be stored in the database. And on the other hand, the bill of lading numbers which are already stored in the database, they can also be edited through this interface. Please let me know if such an interface can be created. And if yes, is there any tutorial on how this can be done? Thanks.

How would I go about making a small feature for my moderators that allows them to select multiple threads while viewing a forum then take action? All I need is an idea of how I would do this. Wouldn't I use the explode() function?

Example: http://i490.photobucket.com/albums/rr267/brannenclass/ex.png

Hello, my friends and I are planning to make a photo gallery, where people can upload their images and everyone can view them. These images will be saved in database. The problem is, we have to moderate these images when uploaded, to prevent adult content or copyrighted images from being displayed.

We were thinking to make people send us these images by email, I mean through an email attachment, then we will review them, and if these images are OK, we will insert them manually into the database. We want as far as possible to not consume unnecessary spaces in the database, else the hosting will cancel our account even it offers unlimited space and bandwidth. We could make these images store in a folder, but the persons will have to give their names, that's why we think it would be better to make them fill some fields, attach the image and send us by email.

1/ Do you think this method is good? If you have another method, please give me...

2/ And also how do you insert images manually to database? I'm using PHPMyAdmin. I mean, to upload an image which is on my computer itself. I know there are some MySQL IDEs which do this, but do not know on PHPMyAdmin


Thank you