Abills NMS - История изменений

Sirmax в 13:52, 28 сентября 2012

2012-09-28T13:52:52Z

2011-02-19T13:50:42Z

Шейпинг

← Предыдущая		Версия 13:50, 19 февраля 2011
Строка 324:		Строка 324:
	DROP VIEW IF EXISTS view_active_users;		DROP VIEW IF EXISTS view_active_users;
	CREATE VIEW		CREATE VIEW
		+	view_active_users
−	view_active_customers
	AS		AS
	SELECT		SELECT

2011-02-19T13:49:52Z

Шейпинг

← Предыдущая		Версия 13:49, 19 февраля 2011
Строка 327:		Строка 327:
	AS		AS
	SELECT		SELECT
−	users.uid AS uid	+	users.uid AS uid,
	users.id AS user,		users.id AS user,
	INET_NTOA(dhcphosts_hosts.ip) as ip,		INET_NTOA(dhcphosts_hosts.ip) as ip,

2011-02-19T13:49:32Z

Шейпинг

← Предыдущая		Версия 13:49, 19 февраля 2011
Строка 327:		Строка 327:
	AS		AS
	SELECT		SELECT
		+	users.uid AS uid
	users.id AS user,		users.id AS user,
	INET_NTOA(dhcphosts_hosts.ip) as ip,		INET_NTOA(dhcphosts_hosts.ip) as ip,

2011-02-17T08:17:58Z

Шейпинг

← Предыдущая		Версия 08:17, 17 февраля 2011
Строка 321:		Строка 321:

	=Шейпинг=		=Шейпинг=
−
	<PRE>		<PRE>
		+	DROP VIEW IF EXISTS view_active_users;
		+	CREATE VIEW
		+	view_active_customers
		+	AS
	SELECT		SELECT
	users.id AS user,		users.id AS user,

2011-02-16T09:12:13Z

Шейпинг

← Предыдущая		Версия 09:12, 16 февраля 2011
Строка 324:		Строка 324:
	<PRE>		<PRE>
	SELECT		SELECT
−	~~dhcphosts_networks~~.id AS ~~network~~,	+	users.id AS user,
	INET_NTOA(dhcphosts_hosts.ip) as ip,		INET_NTOA(dhcphosts_hosts.ip) as ip,
−	dhcphosts_networks_vlans.vlan AS vlan,	+	dhcphosts_networks_vlans.vlan AS vlan
−	dhcphosts_hosts.mac AS mac,
−	dhcphosts_hosts.ports AS port,
−	INET_NTOA(dhcphosts_hosts.nas) AS switch
	FROM		FROM
	((		((

2011-02-16T09:01:19Z

Шейпинг

← Предыдущая		Версия 09:01, 16 февраля 2011
Строка 329:		Строка 329:
	dhcphosts_hosts.mac AS mac,		dhcphosts_hosts.mac AS mac,
	dhcphosts_hosts.ports AS port,		dhcphosts_hosts.ports AS port,
−	INET_NTOA(dhcphosts_hosts.nas) AS switch,	+	INET_NTOA(dhcphosts_hosts.nas) AS switch
	FROM		FROM
	((		((

2011-02-16T09:00:44Z

Шейпинг

← Предыдущая		Версия 09:00, 16 февраля 2011
Строка 321:		Строка 321:

	=Шейпинг=		=Шейпинг=
		+
		+	<PRE>
		+	SELECT
		+	dhcphosts_networks.id AS network,
		+	INET_NTOA(dhcphosts_hosts.ip) as ip,
		+	dhcphosts_networks_vlans.vlan AS vlan,
		+	dhcphosts_hosts.mac AS mac,
		+	dhcphosts_hosts.ports AS port,
		+	INET_NTOA(dhcphosts_hosts.nas) AS switch,
		+	FROM
		+	((
		+	dhcphosts_networks
		+	JOIN
		+	dhcphosts_hosts
		+	ON
		+	dhcphosts_networks.id=dhcphosts_hosts.network
		+	)
		+	JOIN
		+	dhcphosts_networks_vlans
		+	ON
		+	dhcphosts_networks_vlans.id=dhcphosts_networks.id )
		+	JOIN
		+	users
		+	ON
		+	users.uid=dhcphosts_hosts.uid
		+	JOIN
		+	bills
		+	ON
		+	users.bill_id = bills.id
		+	WHERE
		+	bills.deposit > 0 ;
		+	</PRE>

2011-02-16T09:00:16Z

Вычисление броадкаста

2010-10-23T14:40:36Z

Вычисление броадкаста

← Предыдущая		Версия 14:40, 23 октября 2010
Строка 295:		Строка 295:
	dhcphosts_hosts.ports AS port,		dhcphosts_hosts.ports AS port,
	INET_NTOA(dhcphosts_hosts.nas) AS switch,		INET_NTOA(dhcphosts_hosts.nas) AS switch,
−	CONCAT("pool { range ",INET_NTOA(dhcphosts_hosts.ip+65536+65536),"; allow members of \"match_vlan__",dhcphosts_networks_vlans.vlan,"__port__",dhcphosts_hosts.ports,"__MAC__",dhcphosts_hosts.mac,"__switch__",INET_NTOA(dhcphosts_hosts.nas),"\"; default-lease-time ~~600~~; max-lease-time ~~1200~~; }") AS pool	+	CONCAT("pool { range ",INET_NTOA(dhcphosts_hosts.ip+65536+65536),"; allow members of \"match_vlan__",dhcphosts_networks_vlans.vlan,"__port__",dhcphosts_hosts.ports,"__MAC__",dhcphosts_hosts.mac,"__switch__",INET_NTOA(dhcphosts_hosts.nas),"\"; default-lease-time 30; max-lease-time 30; }") AS pool
	FROM		FROM
	((		((