FreenetIS

<input></input>

</values>

</method>

</controller>

<controller name="languages">

<method name="index" autogenerate="on">

<attribute name="from" default_value="ip_address" />

</attributes>

<values>

<input>

<param value="" />

<param value="" />

</input>

<input>

<param value="" />

<attribute name="message_id" default_value="" />

</attributes>

<values>

<input>

<param value="" />

<param value="" />

</input>

</values>

</method>

</input>

</values>

</method>

<method name="show_whitelisted_members" autogenerate="on">

<attributes>

<attribute name="limit_results" default_value="100" />

<model name="address_point">

<method name="count_all_address_points" autogenerate="on">

<attributes>

<attribute name="filter_sql" default_value="" />

</attributes>

<values>

<input>

<param value="" />

</input>

</values>

</method>

<method name="count_all_items_by_address_point_id" autogenerate="off">

<input></input>

</values>

</method>

</model>

<model name="messages_ip_addresses">

<method name="get_redirections_of_ip_address" autogenerate="off">

</attributes>

<values>

</values>

<helper name="cookie">

<method name="set" autogenerate="on">

<attributes>

public function get_ip_addresses_of_debtors($debtor_boundary)

{

return $this->db->query("

FROM ip_addresses ip

JOIN subnets s ON s.id = ip.subnet_id

JOIN ifaces i ON i.id = ip.iface_id

* @return unknown_type

*/

public function get_all_messages($limit_from = 0, $limit_results = 20,

{

// order by check

if (!$this->has_column($order_by))

LIMIT $limit_from, $limit_results

");

}

}

);

protected $belongs_to = array('address_point','user');

const TYPE_APPLICANT = 1;

const TYPE_HONORARY = 3;

const TYPE_SYMPATHIZING = 4;

// query

return $this->db->query("

SELECT id, id AS member_id, registration, name, street, street_number,

GROUP_CONCAT(a_comment SEPARATOR ', \n\n') AS a_comment,

a_comments_thread_id, type, entrance_date, leaving_date

FROM

m.id, m.registration, m.name,

s.street, ap.street_number, t.town, t.quarter,

m.variable_symbol, a.id AS aid,

CONCAT(u.surname,' ',u.name,' (',SUBSTRING(c.datetime,1,10),'):\n',c.text) AS a_comment,

a.comments_thread_id AS a_comments_thread_id,

m.type, m.entrance_date, m.leaving_date

FROM

(

SELECT m.id,

m.address_point_id,

IF(m.registration = 1, ?, ?) AS registration,

IFNULL(t.translated_term, e.value) AS type,

// query

return $this->db->query("

SELECT id, id AS member_id, registration, name, street, street_number,

GROUP_CONCAT(a_comment SEPARATOR ', \n\n') AS a_comment,

a_comments_thread_id, type, entrance_date, leaving_date

FROM

m.id, m.registration, m.name,

s.street, ap.street_number, t.town, t.quarter,

m.variable_symbol, a.id AS aid,

CONCAT(u.surname,' ',u.name,' (',SUBSTRING(c.datetime,1,10),'):\n',c.text) AS a_comment,

a.comments_thread_id AS a_comments_thread_id,

m.type, m.entrance_date, m.leaving_date

SELECT m.id

FROM

(

IF(m.registration = 1, ?, ?) AS registration,

IFNULL(t.translated_term, e.value) AS type,

IF(mi.id IS NOT NULL, ?, ?) AS membership_interrupt,

m.organization_identifier, m.address_point_id,

m.comment, m.entrance_date, m.leaving_date

FROM members m

LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id

WHERE mf.activation_date <= CURDATE() AND mf.deactivation_date >= CURDATE()

) mi ON mi.member_id = m.id

) AS m

LEFT JOIN address_points ap ON m.address_point_id = ap.id

LEFT JOIN streets s ON ap.street_id = s.id

url_lang::lang('texts.Yes'),

url_lang::lang('texts.No'),

url_lang::lang('texts.nonei'),

))->current()->total;

}

}

if ($this->acl_check_delete('Devices_Controller', 'subnet'))

{

$m = url_lang::lang('texts.Do you want to delete this subnet');

->table('a')

->type('number');

$filter_form->add('variable_symbol')

->callback('json/variable_symbol');

if (strtolower($order_by_direction) != 'desc')

$order_by_direction = 'asc';

// load members

$model_members = new Member_Model();

$total_members = $model_members->count_all_members($filter_form->as_sql());

);

}

if ($this->acl_check_view(get_class($this), 'members'))

{

// csv export of members

->label(url_lang::lang('texts.Balance'))

->callback('callback::balance_field');

// action fields

if ($this->acl_check_view(get_class($this), 'members'))

{

$order_by_direction = 'asc', $page_word = null, $page = 1)

{

// access rights

Controller::error(ACCESS);

if (is_numeric($this->input->get('record_per_page')))

$order_by = 'id';

if (strtolower($order_by_direction) != 'desc')

// model

$message_model = new Message_Model();

public function add()

{

// access rights

Controller::error(ACCESS);

// self cancel

*/

public function edit($message_id = null)

{

if (!isset($message_id))

Controller::warning(PARAMETER);

*/

public function activate($message_id = NULL)

{

// param check

if (!$message_id || !is_numeric($message_id))

{

Controller::warning(PARAMETER);

}

// preparation

$message = new Message_Model($message_id);

if (!$message || !$message->id)

{

Controller::error(RECORD);

}

$user_id = $this->session->get('user_id');

{

// choose which message to update

switch($message->type)

{

case Message_Model::$interrupted_membership_message:

break;

case Message_Model::$debtor_message:

$debtor_boundary = $this->settings->get('debtor_boundary');

if ($debtor_boundary == "")

{

$this->session->set_flash('message', url_lang::lang(

));

url::redirect(url_lang::base().'messages/show_all');

}

break;

case Message_Model::$payment_notice_message:

// boundary credit status

$payment_notice_boundary = $this->settings->get('payment_notice_boundary');

if ($payment_notice_boundary == "")

{

$this->session->set_flash('message', url_lang::lang(

));

url::redirect(url_lang::base().'messages/show_all');

}

$debtor_boundary = $this->settings->get('debtor_boundary');

if ($debtor_boundary == "")

{

$this->session->set_flash('message', url_lang::lang(

));

url::redirect(url_lang::base().'messages/show_all');

}

break;

default:

Controller::warning(PARAMETER);

}

$this->session->set_flash('message', url_lang::lang(

'texts.Redirection "%s" for %d IP addresses have been activated.',

array

);

url::redirect(url_lang::base().'messages/show_all');

}

catch (Exception $e)

{

$message_model->transaction_rollback();

));

url::redirect(url_lang::base().'messages/show_all');

}

}

}

function settings()

{

// access control

Controller::error(ACCESS);

// creating of new forge

$this->form = new Forge(url_lang::base()."redirect/settings", '', 'POST', array('id' => 'article_form'));

$messages = $message_model->find_all();

foreach($messages as $message)

{

// IP address can be manually redirected only to user message, interrupted membership message, debtor message, payment notice message

if ($message->type == Message_Model::$user_message ||

$message->type == Message_Model::$interrupted_membership_message ||

* @param $from Tells where return after setting this redirection

* @return unknown_type

*/

{

$where = array();

if (is_numeric($ip_address_id))

$array['ip_address_id'] = $ip_address_id;

* @param $message_id

* @return unknown_type

*/

{

// access rights

if (!$this->acl_check_delete('Messages_Controller', 'member'))

Controller::error(ACCESS);

$db = new Database();

$ip_model = new Ip_address_Model();

$ips = $ip_model->get_ip_addresses_of_member($member_id);

// access rights

if (!$this->acl_check_edit('Messages_Controller', 'member'))

Controller::error(ACCESS);

$whitelist_array[Ip_address_Model::$no_whitelist] = url_lang::lang('texts.No whitelist');

$whitelist_array[Ip_address_Model::$permanent_whitelist] = url_lang::lang('texts.Permanent whitelist');

$whitelist_array[Ip_address_Model::$temporary_whitelist] = url_lang::lang('texts.Temporary whitelist');

}

}

/**

* Shows members with at least one whitelisted IP address.

// no redirection found - perhaps visiting this page by mistake?

{

{

}

}

// message after redirection

$message_query = "SELECT * FROM messages WHERE ID = 2";

$message_result = mysql_query($message_query, $link) or die(mysql_error());

$message = mysql_fetch_array($message_result);

$content = $message['text'];

// logo redirection url

$logo_query = "SELECT name, value FROM config WHERE name = 'redirection_logo_url'";

$logo_result = mysql_query($logo_query, $link) or die(mysql_error());

if (isset($_GET['ip_address']))

{

$ip_address = $_GET['ip_address'];

}

// otherwise it is real redirection, we have to use ip address of remote visitor

else

{

$ip_address = $_SERVER['REMOTE_ADDR'];

}

// check validity of ip address

if (!preg_match ("/^((25[0-5])|(2[0-4][0-9])|(1[0-9][0-9])|([1-9][0-9])|[0-9])\.((25[0-5])|(2[0-4][0-9])|(1[0-9][0-9])|([1-9][0-9])|[0-9])\.((25[0-5])|(2[0-4][0-9])|(1[0-9][0-9])|([1-9][0-9])|[0-9])\.((25[0-5])|(2[0-4][0-9])|(1[0-9][0-9])|([1-9][0-9])|[0-9])$/", $ip_address))

SELECT ms.id, ms.text, ms.self_cancel, ip.ip_address, ip.whitelisted, s.name AS subnet_name,

mm.name AS member_name, mm.id AS member_id,

mm.variable_symbol, a.balance, mip.comment

JOIN subnets s ON s.id = ip.subnet_id

JOIN ifaces i ON i.id = ip.iface_id

JOIN devices d ON d.id = i.device_id

JOIN users u ON u.id = d.user_id

JOIN members mm ON mm.id = u.member_id

LEFT JOIN accounts a ON a.member_id = mm.id AND mm.id <> 1

WHERE ip.ip_address = '$ip_address'

ORDER BY ms.self_cancel DESC, mip.datetime ASC

LIMIT 1";

$message_result = mysql_query($message_query, $link) or die(mysql_error());

$message = mysql_fetch_array($message_result);

if ($message && count($message) > 0)

{

$content = $message['text'];

}

else

{

}

// text in left contact panel,

// it asssumed that after installation, there is always contact message with ID 1

}

$logo = $logo_array['value'];

// self cancelable messages have additional anchor for self canceling placed in footer

$sct_query = "SELECT name, value FROM config WHERE name = 'self_cancel_text'";

$sct_result = mysql_query($sct_query, $link) or die(mysql_error());

$sct_array = mysql_fetch_array($sct_result);

}

$sct = $sct_array['value'];

if ($message['self_cancel'] > 0)

$footer = '<a href="cancel.php">'.$sct.'</a>';

else

$footer = '';