[RDD] Crude Traffic Scheduler for Rivendell

drew Roberts zotzbro at gmail.com
Fri Jan 9 18:26:13 EST 2015


Announcing the Crude Traffic Scheduler for Rivendell.

Assumptions for now:

Your rivendell mysql server is on the same machine with a web server. Put
the following 3 files in the rivtraf directory under your web root
directory. On my ubuntu 14.04, this is

/var/www/html/rivtraf

and in the web server it is

http://host/rivtraf

The files are:

index.html
rivgentraf1.php
rivgentraf2.php

Files follow as inline text:

index.html
====== starts at line below =======
<HTML>
<HEAD>
<TITLE>Crude Traffic Scheduler for Rivendell</TITLE>
</HEAD>
<BODY>
<H1>Crude Traffic Scheduler for Rivendell</H1>
<H2>Brought to you by drew Roberts<BR>In association with Bahamian Or
Nuttin</P></H2>
<A HREF="rivgentraf1.php">Traffic generator 1.</A>
<P>
<A HREF="rivgentraf2.php">Traffic generator 2.</A>
<P>
Traffic generator 1 schedules a fixed number of spots<BR>
per hour (mytph) and you must be running more traffic<BR>
carts per day then you have traffic events per hour<BR>
for this scheduler to work correctly.
<P>
Traffic generator 2 schedules a fixed number of breaks<BR>
per hour and a fixed number of spots per break and you<BR>
must be running more traffic carts per day than you<BR>
have traffic events per break for this scheduler to<BR>
work correctly.
<P>
Either scheduler will randomly schedule carts in the<BR>
TRAFFIC group.
<P>
<A HREF="http://www.bahamianornuttin.com">Bahamian Or Nuttin.</A><BR>
<A HREF="http://zotzbro.blogspot.com">drew's blog.</A>
</BODY>
</HTML>
====== ends at line above =======

rivgentraf1.php
====== starts at line below =======
<?php

// rivgentraf.php


?>
<a href="index.html">Back To Start</a>
<HR>
<P>
<?php

// edit servername, username, password, and dbname to match    */
// your local mysql needs for the rivendell database        */
$servername = "localhost";
$username = "rduser";
$password = "letmein";
$dbname = "Rivendell";
// echo "Now on to main traffic generation.<P>";

// things should be open by now */

// Assumptions                    */
// first hour to schedule is 0    myhour        */
// first break to schedule is 1    mybreak        */
// 42 traffic per hour        mytph        */
// 24 hours per day        hpd        */
// traffic carts to schedule per day > mytph    */


// if you need more traffic spots per hour    */
// change mytph to suit your needs.        */

$myhour = 0;
$mybreak = 0;
$mytph = 4;
$hpd = 24;

// hopefully you will not need to edit anything below this.    */


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


while($myhour < $hpd)
{

    $sql = "SELECT NUMBER AS FOO, TITLE FROM CART WHERE
GROUP_NAME='TRAFFIC' ORDER BY RAND() LIMIT $mytph";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output data of each row
        $myrow = 1;
        while($row = $result->fetch_assoc()) {
        $mytitle = substr($row["TITLE"],0,50);
        printf ("%02d:%02d:%02d %06d 30 %' -50s",
$myhour,$mybreak,$myrow,$row["FOO"],$mytitle);
        echo "<BR>";

        $myrow++;
        }
    } else {
        echo "0 results";
    }


    // echo "<P>";
    $myhour++;

}
$conn->close();
?>
====== ends at line above =======

rivgentraf2.php
====== starts at line below =======
<?php

// rivgentraf.php


?>
<a href="index.html">Back To Start</a>
<HR>
<P>
<?php

// edit servername, username, password, and dbname to match    */
// your local mysql needs for the rivendell database        */
$servername = "localhost";
$username = "rduser";
$password = "letmein";
$dbname = "Rivendell";
// echo "Now on to main traffic generation.<P>";

// things should be open by now */

// Assumptions                    */
// first hour to schedule is 0    myhour        */
// first break to schedule is 1    mybreak        */
// 2 traffic per break        mytpb        */
// 2 breaks per hour        mybph        */
// 24 hours per day        hpd        */

// if you need more traffic spots per break or more breaks    */
// per hour, change mytpb and mybph to suit your needs.        */

$myhour = 0;
$mybreak = 1;
$mytpb = 2;
$mybph = 2;
$hpd = 24;

// hopefully you will not need to edit anything below this.    */


// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}


while($myhour < $hpd)
{

    while($mybreak <= $mybph)
    {



    $sql = "SELECT NUMBER AS FOO, TITLE FROM CART WHERE
GROUP_NAME='TRAFFIC' ORDER BY RAND() LIMIT $mytpb";
    $result = $conn->query($sql);

    if ($result->num_rows > 0) {
        // output data of each row
        $myrow = 1;
        while($row = $result->fetch_assoc()) {
            // echo "id: " . $row["NUMBER"]. " - Name: " . <BR>";. " " .
$row["ARTIST"]. "<br>";
        $mytitle = substr($row["TITLE"],0,50);
        printf ("%02d:%02d:%02d %06d 30 %' -50s",
$myhour,$mybreak,$myrow,$row["FOO"],$mytitle);
        echo "<BR>";
        // echo "Mybreak = $mybreak - Myhour = $myhour  - Myrow is $myrow";
        $myrow++;
        }
    } else {
        echo "0 results";
    }

    // echo "<P>";
    // echo "Mybreak = $mybreak - Myhour = $myhour  - row is $row";
    // echo "<P>";
    $mybreak++;
    }
    $mybreak = 1;




    // echo "<P>";
    $myhour++;

}
$conn->close();
?>
====== ends at line above =======

all the best,

drew
-- 
http://nakedghosts.blogspot.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://caspian.paravelsystems.com/pipermail/rivendell-dev/attachments/20150109/18334c86/attachment.html>


More information about the Rivendell-dev mailing list