<?php
 
    define('IN_FCMS', true);
 
    session_start();
 
    include 'class.Lite_user-agents.org.php';
 
    include 'class.MySQL_Connect.php';
 
    $sql = new MySql_Con();
 
    $rbt = new User_Agents_dot_org(); 
 
    $sql->GetMyConnection();
 
    $rbt->XML_enabled = false;
 
    if(!isset($_GET['type'])){$sype= ''; }else{ $sype=$_GET['type'];}
 
    // check if we are doing a single character search and display, set correct
 
if(!isset($_GET['alpha'])){ $alpha = false;}else{ $alpha = true;}
 
    // send of the display call to the class
 
    $rbt->Display_Agents('SQL',$sype, $alpha);
 
    $sql->CleanUpDB();
 
    ?>
 
    <h1>SQL List & filters examples</h1>
 
    <a rel="nofollow" href="light_example_list_sql.php">None</a> |
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=B">Browser</a> |
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=C">Link, bookmark, server checking</a> |
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=D">Downloading tool</a> |
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=P">Proxy server, web filtering</a> |
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=R">Robot, crawler, spider </a> |
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&type=S">Spam or bad bot</a>
 
    <strong><br>List By Alphabet</strong><br>
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=a">A</a>-
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=b">B</a>-
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=c">C</a>-
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=d">D</a>-
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=e">E</a>-
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=f">F</a>-
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=g">G</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=h">H</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=i">I</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=j">J</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=k">K</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=l">L</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=m">M</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=n">N</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=o">O</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=p">P</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=q">Q</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=r">R</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=s">S</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=t">T</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=u">U</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=v">V</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=w">W</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=x">X</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=z">Z</a>
 
    <br><strong>List By Number</strong><br>
 
       <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=1">1</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=2">2</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=3">3</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=4">4</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=5">5</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=6">6</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=7">7</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=8">8</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=9">9</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=0">0</a>
 
    <br><strong>List by Character</strong><br>
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=(">(</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=!">!</a> - 
 
    <a rel="nofollow" href="light_example_list_sql.php?display=SQL&alpha&type=*">*</a></p>
 
    </article>
 
    <?php
 
    echo '<h3><font color="red">'.sizeof($rbt->Nice_List).'</font> Results  </h3>';
 
foreach ($rbt->Nice_List as $i => $k){
 
    // print out each type.
 
    echo '['.$i.'] - '.$k['id'].' - '.$k['string'].' - '.$k['description'].' - '.$k['type'].' - '.$k['comment'].' - '.$k['link'].' - '.$k['link2'].'<br />';
 
    }
 
    ?>
 
 |