cdr_options.php

<?php

if ($id_exist >= 1) $req = "SELECT * FROM " . M_CDR . " WHERE `id_user`=" . $user_data['user_id'];
else $req = "SELECT * FROM " . M_CDR . " WHERE `id_user` = 0";

$req1 = $db->sql_query($req);
$tc = $db->sql_fetch_row($req1);

$Txt = (isset($pub_taille0)) ? $pub_taille0 : "";
$TS = (isset($pub_T_Small)) ? $pub_T_Small : "";
$CS = (isset($pub_C_Small)) ? $pub_C_Small : "";
$TM = (isset($pub_t_med)) ? $pub_t_med : "";
$CM = (isset($pub_C_med)) ? $pub_C_med : "";
$TB = (isset($pub_t_big)) ? $pub_t_big : "";
$CB = (isset($pub_C_big)) ? $pub_C_big : "";
$tr1 = (isset($pub_tri1)) ? $pub_tri1 : "";
$tr2 = (isset($pub_tri2)) ? $pub_tri2 : "";
$gal = (isset($pub_gal)) ? $pub_gal : "";
$retention = (isset($pub_retention)) ? $pub_retention : "";

if (isset($pub_add) == 1) {
    if ($user_data['user_id'] == $tc['id_user']) {
        $db->sql_query("UPDATE " . M_CDR
            . " SET taille='$Txt', small='$TS', small_color='$CS', medium='$TM', medium_color='$CM', big='$TB', big_color='$CB', tri1='$tr1', tri2='$tr2', galaxy='$gal', retention='$retention'"
            . " WHERE id_user=" . $user_data['user_id']);
    } else {
        $reg = "INSERT INTO " . M_CDR . " (`id_user`,`taille`,`small`,`small_color`,`medium`,`medium_color`,`big`,`big_color`,`tri1`,`tri2`,`galaxy`, `retention`) VALUES (" . $user_data['user_id'] . ",'5000','10000','FFFF00','20000','FFA500','50000','FF0000','total','desc','0','2')";
        $req = $db->sql_query($reg);
    }
    $req = "SELECT * FROM " . M_CDR . " WHERE `id_user` =" . $user_data['user_id'];
    $req1 = $db->sql_query($req);
    $tc = $db->sql_fetch_row($req1);
}
?>

<br />

<form action="index.php?action=cdr&subaction=option" name="form1" method="POST">
    <input type="hidden" name="add" value="1" />
    <table class="og-table og-little-table">
        <thead>
            <tr>
                <th><?php echo $user_data['user_name']; ?></th>
            </tr>
        </thead>
    </table>

    <table class="og-table og-small-table">
        <thead>
            <tr>
                <th colspan="2">Xtense</th>
            <tr>
        </thead>
        <tbody>
            <td class="tdstat">
                <?php echo $lang['tcdt']; ?>
            </td>
            <td class="tdvalue">
                <input style="text-align:center" type="text" name="taille0" size="10" maxlength="10" value="<?php echo $tc['taille']; ?>" />
            </td>
        </tbody>
        <thead>
            <tr>
                <th colspan="2">
                    <?php echo $lang['colorcdr']; ?>
                </th>
            <tr>
        </thead>
        <tbody>
            <td class="tdstat">
                <?php echo $lang['more_than']; ?><input style="text-align:center" type="text" size="10" name="T_Small" value="<?php echo $tc['small']; ?>" />
            </td>
            <td class="tdvalue" style="align='center';background-color:#<?php echo $tc['small_color']; ?>">
                <input style="text-align:center" size="10" type="text" name="C_Small" maxlength="6" value="<?php echo $tc['small_color']; ?>" />
            </td>
            </tr>
            <tr>
                <td class="tdstat">
                    <?php echo $lang['more_than']; ?> <input style="text-align:center" type="text" size="10" name="t_med" value="<?php echo $tc['medium']; ?>" />
                </td>
                <td class="tdvalue" style="align='center';background-color:#<?php echo $tc['medium_color']; ?>">
                    <input style="text-align:center" size="10" type="text" name="C_med" maxlength="6" value="<?php echo $tc['medium_color']; ?>" />
                </td>
            </tr>
            <tr>
                <td class="tdstat">
                    <?php echo $lang['more_than']; ?> <input style="text-align:center" type="text" size="10" name="t_big" value="<?php echo $tc['big']; ?>" />
                </td>
                <td class="tdvalue" style="align='center';background-color:#<?php echo $tc['big_color']; ?>">
                    <input style="text-align:center" size="10" type="text" name="C_big" maxlength="6" value="<?php echo $tc['big_color']; ?>" />
                </td>
            </tr>
        </tbody>
        <thead>
            <th colspan="2">
                <?php echo $lang['tri']; ?>
            </th>
        </thead>
        <tbody>
            <tr>
                <td class="tdstat">
                    <select name="tri1">
                        <option value="coord" <?php echo ($tc['tri1'] == "coord" ? " selected" : ""); ?>><?php echo $lang['coord']; ?></option>
                        <option value="total" <?php echo ($tc['tri1'] == "total" ? " selected" : ""); ?>><?php echo $lang['total']; ?></option>
                        <option value="metal" <?php echo ($tc['tri1'] == "metal" ? " selected" : ""); ?>><?php echo $lang['metal']; ?></option>
                        <option value="cristal" <?php echo ($tc['tri1'] == "cristal" ? " selected" : ""); ?>><?php echo $lang['crystal']; ?></option>
                        <option value="date" <?php echo ($tc['tri1'] == "date" ? " selected" : ""); ?>><?php echo $lang['date']; ?></option>
                    </select>
                </td>
                <td class="tdvalue">
                    <select name="tri2">
                        <option value="asc" <?php echo ($tc['tri2'] == "asc" ? " selected" : ""); ?>><?php echo $lang['ascending']; ?></option>
                        <option value="desc" <?php echo ($tc['tri2'] == "desc" ? " selected" : ""); ?>><?php echo $lang['descending']; ?></option>
                    </select>
                </td>
            </tr>
            <tr>
                <td class="tdstat">
                    <?php echo $lang['galaxy']; ?>
                </td>
                <td class="tdvalue">
                    <input style="text-align:center" type="text" name="gal" size="10" maxlength="10" value="<?php echo $tc['galaxy']; ?>" />
                </td>
            </tr>
        </tbody>
        <thead>
            <tr>
                <th colspan="2">
                    <?php echo $lang['retention']; ?>
                </th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td class="tdstat">
                    <?php echo $lang['retention_days']; ?>
                </td>
                <td class="tdvalue">
                    <input style="text-align:center" type="text" name="retention" size="10" maxlength="10" value="<?php echo $tc['retention']; ?>" />
                </td>
</tr>
<tr>
                    <td colspan="2">
                        <input class="og-button" name="add_taille"  type="submit" value="<?php echo $lang['update']; ?>">
                    </td>
                </tr>
        <tbody>
    </table>
</form>