Subversion Repositories ALCASAR

<?php
define ("CONF_FILE", "/usr/local/etc/alcasar.conf");

$ouvre=fopen(CONF_FILE,"r");
if($ouvre){
        while(!feof ($ouvre))
        {
                $tampon = fgets($ouvre, 4096);
                if(strpos($tampon,"=")!=false)
                {
                        $tmp = explode("=",$tampon);
                        $conf[$tmp[0]] = $tmp[1];
                }
                
        } 
} else {
        exit("Erreur d'ouverture du fichier".CONF_FILE);
}
fclose($ouvre);
$organisme = trim($conf["ORGANISM"]);

?>
<?
# Choice of language
$Language = 'en';
if(isset($_SERVER['HTTP_ACCEPT_LANGUAGE'])){
  $Langue = explode(",",$_SERVER['HTTP_ACCEPT_LANGUAGE']);
  $Language = strtolower(substr(chop($Langue[0]),0,2)); }
  
if($Language == 'fr'){
        $l_title = "Page d'auto enregistrement";
        $l_num_exist = "Compte actif";
        $l_num_flood = "Numéro bloqué: nombre d'essai dépassé.";

        $l_num_num = "Numero de téléphone";
        $l_num_raison = "Etat de votre numéro";
        $l_num_expiration = "Expiration du bloquage";

        $l_tuto_1 = "Bienvenue sur la page d'auto enregistrement.";
        $l_tuto_2 = "Le portail auquel vous essayez de vous connectez offre la possibilité de s'inscrire automatiquement, en envoyant votre mot de passe par SMS au numéro (prix d'un SMS, non surtaxé):";
    $l_tuto_3 = "Votre SMS ne doit contenir qu'un seul mot.";
        $l_tuto_4 = "A la suite de votre inscription, vous pourrez retrouver votre numéro de téléphone dans le tableau ci-dessous, avec l'état et la date d'expiration de validité ou bloquage de ce dernier.";    
        $l_tuto_5 = "Le champ de recherche ci-dessous vous permet de rechercher votre numéro suivant les 5 derniers chiffres.";        

        $l_tab_first = "premier";
        $l_tab_last = "dernier";
        $l_tab_next = "suivant";
        $l_tab_prev = "précédent";
        $l_tab_search = "Recherche :";
        $l_tab_pmenu = "Affiche la page _PAGE_ sur _PAGES_";
        $l_tab_info = "Montrer _MENU_ résultat par page";
        $l_tab_infoempty = "Aucun résultat";
        
} elseif($Language == 'en'){
        $l_title = "Autoregistration";
        $l_num_exist = "Account enables";
        $l_num_flood = "Phone number banned: Number of trial exceeded.";

        $l_num_num = "Phone number";
        $l_num_raison = "Status of your phone number";
        $l_num_expiration = "Expiration";

        $l_tuto_1 = "Welcome";
        $l_tuto_2 = "You can have an acces to the Internet if you send a password via SMS to this phone number (no surcharge) :";
    $l_tuto_3 = "Just send 1 word in your SMS.";
        $l_tuto_4 = "If your registration is a success or a failure, you can find the raison in the table bellow.";
        $l_tuto_5 = "You can search your phone number according to the 5 last digits in your phone number.";    
        
        $l_tab_first = "first";
        $l_tab_last = "last";
        $l_tab_next = "next";
        $l_tab_prev = "previous";
        $l_tab_search = "Search :";
        $l_tab_pmenu = "Showing _PAGE_ to _PAGE_ of _PAGE_ entries :";
        $l_tab_info = "Show _MENU_ entries";
        $l_tab_infoempty = "No matching records found";
        
} else {

        $l_title = "Autoregistration";
        $l_num_exist = "Account enables";
        $l_num_flood = "Phone number banned: Number of trial exceeded.";

        $l_num_num = "Phone number";
        $l_num_raison = "Status of your phone number";
        $l_num_expiration = "Expiration";

        $l_tuto_1 = "Welcome";
        $l_tuto_2 = "You can have an acces to the Internet if you send a password via SMS to this phone number (no surcharge) :";
    $l_tuto_3 = "Just send 1 word in your SMS.";
        $l_tuto_4 = "If your registration is a success or a failure, you can find the raison in the table bellow.";
        $l_tuto_5 = "You can search your phone number according to the 5 last digits in your phone number.";    
        
        $l_tab_first = "first";
        $l_tab_last = "last";
        $l_tab_next = "next";
        $l_tab_prev = "previous";
        $l_tab_search = "Search :";
        $l_tab_pmenu = "Showing _PAGE_ to _PAGE_ of _PAGE_ entries :";
        $l_tab_info = "Show _MENU_ entries";
        $l_tab_infoempty = "No matching records found";
}
?>
<!DOCTYPE HTML>
<HTML><!-- written by Rexy -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Auto enregistrement</title>
<link rel="stylesheet" href="/css/style_intercept.css">
<style type=text/css"></style>
<!-- DataTables CSS -->
<link rel="stylesheet" type="text/css" href="../css/jquery.dataTables.css">
<!-- jQuery -->
<script type="text/javascript" charset="utf8" src="../js/jquery.js"></script>
<!-- DataTables -->
<script type="text/javascript" charset="utf8" src="../js/jquery.dataTables.js"></script>
<script type="text/javascript">
$(document).ready( function () {
    $('#table_id').DataTable({
                "language": {
                        "paginate": {
                        "sFirst": "<?php echo $l_tab_dirst; ?>",
                        "sLast": "<?php echo $l_tab_last; ?>",
                        "sPrevious": "<?php echo $l_tab_prev; ?>",
                        "sNext": "<?php echo $l_tab_next; ?>"
                        },
            "lengthMenu": "<?php echo $l_tab_info; ?>",
            "zeroRecords": "<?php echo $l_tab_infoempty; ?>",
            "info": "<?php echo $l_tab_pmenu; ?>",
            "infoEmpty": "<?php echo $l_tab_infoempty; ?>",
                        "sSearch": "<?php echo $l_tab_search; ?>"
        }
        });
} );
</script>
</head>
<body>

<center>


<div id="logon">
<h1><?php echo "$organisme" ?></h1>
<h2><?php echo "$l_title" ?></h2>
<div>
<table id="boite-info">
        <tr>
                <td rowspan="6" width="30%"><img id="logo-organ" src="/images/organisme.png"></td>
        </tr>
        <tr>
                <td><?php echo "$l_tuto_1" ?></td>
        </tr>
        <tr>
                <td><?php echo "$l_tuto_2" ?></td>
        </tr>

        <tr>
                <td align="center">
                        <h3>    
                        <?php   
                                $current_num = exec("sudo /usr/local/bin/alcasar-sms.sh --numero_alcasar");
                                echo "$current_num";  
                        ?>
                        </h3>
                </td>
        </tr>

        <tr>
                <td><?php echo "$l_tuto_3" ?></td>
        </tr>
        <tr>
                <td><?php echo "$l_tuto_4" ?></td>
        </tr>
        <tr>
                <td colspan="2"><?php echo "$l_tuto_5" ?></td>
        </tr>
</table>
</div>
<?php

require('/etc/freeradius-web/config.php');

if (is_file("./pass/sql/drivers/$config[sql_type]/functions.php"))
        include_once("./pass/sql/drivers/$config[sql_type]/functions.php");
else{
        echo "<b>Could not include SQL library</b>\n";
        exit();
}


$con = mysqli_connect("$config[sql_server]","$config[sql_username]","$config[sql_password]","gammu");

if(mysqli_connect_errno())
{
        echo "Fail to connect to $config[sql_type]" . mysqli_connect_error();
}

$result = mysqli_query($con, "SELECT * 
                                FROM `SMS_ban_perm` 
                                ORDER BY date_add DESC;");
?>

<table id="table_id" class="display">
    <thead>
        <tr>
            <th><b><?php echo $l_num_num; ?></b></th>
                        <th><b><?php echo $l_num_raison; ?></b></th>
                        <th><b><?php echo $l_num_expiration; ?></b></th>
        </tr>
    </thead>
    <tbody>
<?php 
while($row = mysqli_fetch_array($result))
{
        $start = substr($row['SenderNumber'], 0, 3);
        $end = substr($row['SenderNumber'], -5);
        echo "  
                <tr>
                <td>".$start."****".$end."</td>";
        
        if($row['Perm']=='0')
        {
                echo "<td>$l_num_exist</td>";
        }
        if($row['Perm']=='1')
        {
                echo "<td>$l_num_flood</td>";
        }
        echo "  <td>" . $row['Expiration']. "</td>
                </tr>";
}
?>
    </tbody>
</table>

<?php mysqli_close($con); ?>
<br />
</div>
</center>
</body>
</html>