FreenetIS

<?php

$upgrade_sql[400] = array(

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'en_fee' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'en_fee_left' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'entrance_date' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'leaving_date' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'debit' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 38 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 51 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 56 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'must_pay' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'currentcredit' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'membership_interrupts' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `axo_map`.`acl_id` = 58 AND `axo_map`.`section_value` = 'Members_Controller' AND `axo_map`.`value` = 'registration' LIMIT 1;",

"DELETE FROM `axo` WHERE `axo`.`id` = 110 LIMIT 1;",

"INSERT INTO `axo_map` (`acl_id` ,`section_value` ,`value`) VALUES

('58', 'Users_Controller', 'additional_contacts'),

('58', 'Users_Controller', 'users'),

('58', 'Users_Controller', 'name'),

('58', 'Users_Controller', 'surname'),

('58', 'Users_Controller', 'comment'),

('58', 'Users_Controller', 'email');",

"UPDATE `acl` SET `note` = 'Certifikovani technici mohou prohlizet, pridavat a editovat jen nektere polozky u clenu a uzivatelu' WHERE `acl`.`id` = 58 LIMIT 1;",

"UPDATE `acl` SET `note` = 'Certifikovani technici maji pravo videt a pridavat datum vstupu, login, telefon a heslo.' WHERE `acl`.`id` = 59 LIMIT 1;",

"INSERT INTO `acl` (`id`, `section_value`, `allow`, `enabled`, `return_value`, `note`, `updated_date`) VALUES

(67, 'user', 1, 1, '', 'Certifikovani technici mohou nektere polozky u clena pouze videt.', 1248160179);",

"INSERT INTO `aco_map` (`acl_id` ,`section_value` ,`value`) VALUES ('67', 'freenetis', 'view_all');",

"DELETE FROM `aco_map` WHERE `aco_map`.`acl_id` = 59 AND `aco_map`.`section_value` = 'freenetis' AND `aco_map`.`value` = 'delete_all' LIMIT 1;",

"DELETE FROM `aco_map` WHERE `aco_map`.`acl_id` = 59 AND `aco_map`.`section_value` = 'freenetis' AND `aco_map`.`value` = 'edit_all' LIMIT 1;",

"DELETE FROM `axo_map` WHERE `acl_id` = 59;",

"INSERT INTO `axo_map` (`acl_id`, `section_value`, `value`) VALUES

(59, 'Members_Controller', 'entrance_date'),

(59, 'Users_Controller', 'login'),

(59, 'Users_Controller', 'member'),

(59, 'Users_Controller', 'password'),

(59, 'Users_Controller', 'phone'),

(67, 'Members_Controller', 'currentcredit'),

(67, 'Members_Controller', 'debit'),

(67, 'Members_Controller', 'en_fee'),

(67, 'Members_Controller', 'en_fee_left'),

(67, 'Members_Controller', 'leaving_date'),

(67, 'Members_Controller', 'membership_interrupts'),

(67, 'Members_Controller', 'registration'),

(67, 'Users_Controller', 'work');"

);

?>

<h2>

<?php echo url_lang::lang('texts.VoIP').' '.$voip->name ?>

</h2>

<br />

<?php

$links[] = html::anchor(url_lang::base().'users/show/'.$voip->user_id, url_lang::lang('texts.Back to the user'));

$links[] = html::anchor(url_lang::base().'voip/edit/'.$voip->user_id, url_lang::lang('texts.Edit'));

echo implode (' | ', $links);?>

<br />

<br />

<table class="extended" style="float:left; width:360px;">

<tr>

<th colspan="2"><?php echo url_lang::lang('texts.Login information') ?></th>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.usename') ?></th>

<td><?php echo $voip->name ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.password') ?></th>

<td><?php echo '<b>********</b>'.' &nbsp;&nbsp;&nbsp;&nbsp; '.html::anchor(url_lang::base().'voip/change_passord/'.$voip->user_id, url_lang::lang('texts.Change')); ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.Display name') ?></th>

<td><?php echo $voip->callerid ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.Domain') ?></th>

<td><?php echo 'sip.slfree.net' ?></td>

</tr>

</table>

<table class="extended" cellspacing="0" style="float:left; margin-left:10px; width:360px;">

<tr>

<th colspan="2"><?php echo url_lang::lang('texts.Link status') ?></th>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.Status') ?></th>

<td><?php echo $link_status; ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.IP address') ?></th>

<td><?php echo $voip->ipaddr ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.Port') ?></th>

<td><?php echo $voip->port ?></td>

</tr>

<tr>

<th><?php echo url_lang::lang('texts.Registration expires') ?></th>

<td><?php echo $voip->regseconds ?></td>

</tr>

</table>

<h2><?php echo $headline ?></h2>

<?php echo $message ? '<div class="message">'.$message.'</div>' : '' ?>

<br />

<?php echo $grid ?>