FreenetIS

<?php

?>

Unless otherwise specified, all files in the Qcodo Development Framework

are under the following copyright and licensing policies:

The Qcodo Development Framework is distributed by QuasIdea Development, LLC

under the terms of the MIT License. More information can be found at

http://www.opensource.org/licenses/mit-license.php

Copyright (c) 2001 - 2007, QuasIdea Development, LLC

Permission is hereby granted, free of charge, to any person obtaining a copy of

this software and associated documentation files (the "Software"), to deal in

the Software without restriction, including without limitation the rights to

use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies

of the Software, and to permit persons to whom the Software is furnished to do

so, subject to the following conditions:

The above copyright notice and this permission notice shall be included in all

copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR

IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,

FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE

AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER

LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,

OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE

SOFTWARE.

<?xml version="1.0" encoding="UTF-8"?>

<phpProjectOptions>

<projectOption name="org.eclipse.php.core.contextRoot">

</projectOption>

<projectOption name="org.eclipse.php.core.defaultEncoding">

</projectOption>

<includepath>

</includepath>

</phpProjectOptions>

<?xml version="1.0" encoding="UTF-8"?>

<projectDescription>

<name>freenetis</name>

<comment></comment>

<projects>

</projects>

<buildSpec>

<buildCommand>

<name>org.eclipse.php.core.PhpIncrementalProjectBuilder</name>

<arguments>

</arguments>

</buildCommand>

<buildCommand>

<name>org.eclipse.wst.validation.validationbuilder</name>

<arguments>

</arguments>

</buildCommand>

</buildSpec>

<natures>

<nature>org.eclipse.php.core.PHPNature</nature>

</natures>

</projectDescription>

#!/usr/local/bin/php

<?php

/**

* This is a *nix/Mac-based PHP CLI (Command Line Interface) script

* to perform the Qcodo Update Utility.

*

* Remember: You may need to update the top line to have it point

* to the php binary on your server.

*

* Typical usage would be:

* ./qcodo_updater.cli [SETTINGS...]

*/

// Specify we are Non-Windows

$blnWindows = false;

// Include the rest of the OS-agnostic script

require('qcodo_updater.inc.php');

?>

<?php

/**

* This is a Windows-based PHP CLI (Command Line Interface) script

* to perform the Qcodo Update Utility.

*

* Remember: Windows CLI must be executed by the php.exe executable (usually

* installed at c:\php\php.exe).

*

* Typical usage would be:

* c:\php\php.exe qcodo_updater.phpexe [SETTINGS...]

*/

// Specify we are Windows

$blnWindows = true;

// Include the rest of the OS-agnostic script

require('qcodo_updater.inc.php');

?>

<?php

/* This includes library file is used by the qcodo_downloader.cli and qcodo_downloader.phpexe scripts

* to perform the Qcodo Update Utility's File Downloading functionality.

*/

// Call the CLI prepend.inc.php

require('cli_prepend.inc.php');

// Finally, load the QUpdateUtility class itself

require(__QCODO_CORE__ . '/framework/QUpdateUtility.class.php');

// Ensure that there are parameters

if ($_SERVER['argc'] != 5)

QUpdateUtility::PrintDownloaderInstructions();

$strVersion = trim(strtolower($_SERVER['argv'][1]));

if (($strVersion == 'stable') || ($strVersion == 'development'))

QUpdateUtility::Error('Invalid Version format: ' . $strVersion);

$objUpdateUtility = new QUpdateUtility($strVersion);

$objUpdateUtility->RunDownloader($_SERVER['argv'][2], $_SERVER['argv'][3], $_SERVER['argv'][4]);

?>

<?php

// First, let's make sure that path_to_prepend.txt exists

$strPathToPrependTextFile = dirname(__FILE__) . '/path_to_prepend.txt';

if (!is_file($strPathToPrependTextFile))

exit("No path_to_prepend.txt file was found.\r\nPlease be sure to specify the absolute path to prepend.inc.php in the ./path_to_prepend.txt file!\r\n");

// Next, use the absolute path found in path_to_prepend.txt

$strPathToPrepend = trim(file_get_contents($strPathToPrependTextFile));

if (!is_dir($strPathToPrepend))

exit("The text value found in the ./path_to_prepend.txt file does not appear to be a valid directory.\r\nPlease be sre to specify the correct absolute path to prepend.inc.php in the ./path_to_prepend.txt file!\r\n");

// If it exists, require() it -- otherwise, report the error

if (file_exists($strPathToPrepend . '/prepend.inc.php'))

require($strPathToPrepend . '/prepend.inc.php');

else

exit("The prepend.inc.php file was not found at $strPathToPrepend.\r\nPlease be sre to specify the correct absolute path to prepend.inc.php in the ./path_to_prepend.txt file!\r\n");

// Finally, verify that __DEVTOOLS_CLI__ is configured correctly

if (!is_file(__DEVTOOLS_CLI__ . '/' . basename(__FILE__)))

exit("The __DEVTOOLS_CLI__ configuration constant in configuration.inc.php does not appear to be set correctly.\r\n");

$objStat1 = stat(__DEVTOOLS_CLI__ . '/' . basename(__FILE__));

$objStat2 = stat(__FILE__);

if ($objStat1['ino'] != $objStat2['ino'])

exit("The __DEVTOOLS_CLI__ configuration constant in configuration.inc.php does not appear to be set correctly [INode Mismatch].\r\n");

// Finally, turn off output buffering

ob_end_flush();

?>

<?php

/* This includes library file is used by the codegen.cli and codegen.phpexe scripts

* to simply fire up and run the QCodeGen object, itself.

*/

// Call the CLI prepend.inc.php

require('cli_prepend.inc.php');

// Include the QCodeGen class library

require(__QCODO__. '/codegen/QCodeGen.class.php');

function PrintInstructions() {

global $strCommandName;

print('Qcodo Code Generator (Command Line Interface) - ' . QCODO_VERSION . '

Copyright (c) 2001 - 2007, QuasIdea Development, LLC

This program is free software with ABSOLUTELY NO WARRANTY; you may

redistribute it under the terms of The MIT License.

Usage: ' . $strCommandName . ' CODEGEN_SETTINGS

Where CODEGEN_SETTINGS is the absolute filepath of the codegen_settings.xml

file, containing the code generator settings.

For more information, please go to www.qcodo.com

');

exit();

}

if ($_SERVER['argc'] != 2)

PrintInstructions();

/////////////////////

// Run Code Gen

QCodeGen::Run($_SERVER['argv'][1]);

/////////////////////

if ($strErrors = QCodeGen::$RootErrors) {

printf("The following ROOT ERRORS were reported:\r\n%s\r\n\r\n", $strErrors);

} else {

printf("CodeGen settings (as evaluted from %s):\r\n%s\r\n\r\n", $_SERVER['argv'][1], QCodeGen::GetSettingsXml());

}

foreach (QCodeGen::$CodeGenArray as $objCodeGen) {

printf("%s\r\n---------------------------------------------------------------------\r\n", $objCodeGen->GetTitle());

printf("%s\r\n", $objCodeGen->GetReportLabel());

printf("%s\r\n", $objCodeGen->GenerateAll());

if ($strErrors = $objCodeGen->Errors)

printf("The following errors were reported:\r\n%s\r\n", $strErrors);

print("\r\n");

}

foreach (QCodeGen::GenerateAggregate() as $strMessage) {

printf("%s\r\n\r\n", $strMessage);

}

?>

<?php

/* This includes library file is used by the qcodo_updater.cli and qcodo_updater.phpexe scripts

* to perform the Qcodo Update Utility functionality.

*/

// Call the CLI prepend.inc.php

require('cli_prepend.inc.php');

// Finally, load the QUpdateUtility class itself

require(__QCODO_CORE__ . '/framework/QUpdateUtility.class.php');

// Ensure that there are parameters

if ($_SERVER['argc'] < 2)

QUpdateUtility::PrintUpdaterInstructions();

// Setup Parameter Defaults

$strInteractionType = QUpdateUtility::Interactive;

$blnQuietMode = false;

for ($intIndex = 1; $intIndex < $_SERVER['argc']; $intIndex++) {

$strArgument = strtolower($_SERVER['argv'][$intIndex]);

if ($strArgument == '--quiet') {

if ($intIndex == $_SERVER['argc'] - 1)

QUpdateUtility::Error('No Qcodo Version was specified');

$blnQuietMode = true;

} else if (substr($strArgument, 0, strlen('--interaction')) == '--interaction') {

$strArgument = substr($strArgument, strlen('--interaction='));

switch ($strArgument) {

case QUpdateUtility::Interactive:

$strInteractionType = QUpdateUtility::Interactive;

break;

case QUpdateUtility::Rename:

$strInteractionType = QUpdateUtility::Rename;

break;

case QUpdateUtility::Force:

$strInteractionType = QUpdateUtility::Force;

break;

case QUpdateUtility::ReportOnly:

$strInteractionType = QUpdateUtility::ReportOnly;

break;

default:

QUpdateUtility::Error('Invalid Interaction Mode: ' . $strArgument);

break;

}

if ($intIndex == $_SERVER['argc'] - 1)

QUpdateUtility::Error('No Qcodo Version was specified');

} else if ($strArgument == '--help') {

QUpdateUtility::PrintUpdaterInstructions(true);

} else {

if (($intIndex != ($_SERVER['argc'] - 1)) ||

(substr($strArgument, 0, 1) == '-'))

QUpdateUtility::Error('Invalid Option/Argument: ' . $strArgument);

}

}

if ($strInteractionType != QUpdateUtility::ReportOnly)

printf("Qcodo Update Utility - Performing '%s' Update...\r\n", $strInteractionType);

$strVersion = $_SERVER['argv'][$_SERVER['argc'] - 1];

$objUpdateUtility = new QUpdateUtility($strVersion);

$objUpdateUtility->RunUpdater($strInteractionType, $blnQuietMode);

?>

/home/qcodo/wwwroot/includes

#!/usr/local/bin/php

<?php

/**

* This is a *nix/Mac-based PHP CLI (Command Line Interface) script

* to perform Qcodo Update Utility's File Downloading.

*

* Remember: You may need to update the top line to have it point

* to the php binary on your server.

*

* Typical usage would be:

* ./qcodo_downloader.cli [SETTINGS...]

*/

// Specify we are Non-Windows

$blnWindows = false;

// Include the rest of the OS-agnostic script

require('qcodo_downloader.inc.php');

?>

This directory contains command-line-based drivers for Qcodo's development

tools:

* codegen.cli - for Unix/Linux/Mac OS X command lines

* codegen.phpexe - for Windows command line

Both use the QCodeGen and related Qcodo codegen libraries to do the bulk

of the work. They simply instantiate a QCodeGen object, execute various

public methods on it to do the code generation, and create a text-based

report of its activities, outputting it to STDOUT.

* (future tools tba)

Feel free to alter the settings, inputs and/or outputs of any of the drivers

as you wish.

PATH_TO_PREPEND.TXT

VERY IMPORTANT: Before running ANY command line tools, you need to be sure

to update the path_to_prepend.txt file with the absolute path to the

prepend.inc.php file in your includes directory.

OTHER IMPORTANT NOTES

For the .cli version, you may need to update the top line of the file to

match the path of the PHP bin executable on your system, too.

For the .phpexe version, you need to remember to run it as a PARAMETER to

the php.exe executable (usually installed in c:\php\php.exe).

CUSTOM COMMAND LINE TOOLS

Feel free to implement your own command line tools here, as well.

#!/usr/local/bin/php

<?php

/**

* This is a *nix/Mac-based PHP CLI (Command Line Interface) script

* which is a wrapper around the CodeGen object.

*

* Remember: You may need to update the top line to have it point

* to the php binary on your server.

*

* Typical usage would be:

* ./codegen.cli [SETTINGS...]

*/

// Running as a Non-Windows Command Name

$strCommandName = './codegen.cli';

// Include the rest of the OS-agnostic script

require('codegen.inc.php');

?>

<?php

/**

* This is a Windows-based PHP CLI (Command Line Interface) script

* to perform Qcodo Update Utility's File Downloading.

*

* Remember: Windows CLI must be executed by the php.exe executable (usually

* installed at c:\php\php.exe).

*

* Typical usage would be:

* c:\php\php.exe qcodo_downloader.phpexe [SETTINGS...]

*/

// Specify we are Windows

$blnWindows = true;

// Include the rest of the OS-agnostic script

require('qcodo_downloader.inc.php');

?>

<?php

/**

* This is a Windows-based PHP CLI (Command Line Interface) script

* which is a wrapper around the CodeGen object.

*

* Remember: Windows CLI must be executed by the php.exe executable (usually

* installed at c:\php\php.exe).

*

* Typical usage would be:

* c:\php\php.exe codegen.phpexe [SETTINGS...]

*/

// Running as a Windows Command Name

$strCommandName = 'c:\\php\\php.exe codegen.phpexe';

// Include the rest of the OS-agnostic script

require('codegen.inc.php');

?>

-- phpMyAdmin SQL Dump

-- version 2.9.1.1

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: May 18, 2007 at 11:53 AM

-- Server version: 5.0.27

-- PHP Version: 5.2.0

--

-- Database: `freenetis`

--

-- --------------------------------------------------------

--

-- Table structure for table `access_mod`

--

CREATE TABLE `access_mod` (

`ID` int(11) NOT NULL default '0',

`ID_device` int(11) default NULL,

`ID_user_admin` int(11) default NULL,

`timestamp_start` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

`timestamp_end` timestamp NOT NULL default '0000-00-00 00:00:00',

`type` varchar(254) collate utf8_czech_ci default NULL,

`reason` varchar(254) collate utf8_czech_ci default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`),

KEY `user_access_mod` (`ID_user_admin`),

KEY `device_access_mod` (`ID_device`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Dumping data for table `access_mod`

--

-- --------------------------------------------------------

--

-- Table structure for table `contact`

--

CREATE TABLE `contact` (

`ID_user` int(11) default NULL,

`ID` int(11) NOT NULL auto_increment,

`type` varchar(40) collate utf8_czech_ci default NULL,

`value` varchar(255) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`),

KEY `user_contact` (`ID_user`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `contact`

--

-- --------------------------------------------------------

--

-- Table structure for table `credit_mod`

--

CREATE TABLE `credit_mod` (

`ID` int(11) NOT NULL auto_increment,

`ID_member` int(11) default NULL,

`ID_user_admin` int(11) default NULL,

`amount` double default NULL,

`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

`reason` varchar(254) collate utf8_czech_ci default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`),

KEY `user_credit_mod` (`ID_user_admin`),

KEY `member_credit_mod` (`ID_member`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `credit_mod`

--

-- --------------------------------------------------------

--

-- Table structure for table `device`

--

CREATE TABLE `device` (

`ID` int(11) NOT NULL auto_increment,

`ID_user` int(11) default NULL,

`name` varchar(254) character set latin1 default NULL,

`type` varchar(254) character set latin1 default NULL,

`PPPoE_logging_in` tinyint(4) default NULL,

`login` varchar(254) character set latin1 default NULL,

`password` varchar(254) character set latin1 default NULL,

`GPS` varchar(100) character set latin1 default NULL,

`location_address` varchar(254) character set latin1 default NULL,

`location_details` varchar(254) character set latin1 default NULL,

`comment` varchar(254) character set latin1 default NULL,

PRIMARY KEY (`ID`),

KEY `ID_user` (`ID_user`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `device`

--

-- --------------------------------------------------------

--

-- Table structure for table `iface`

--

CREATE TABLE `iface` (

`ID` int(11) NOT NULL auto_increment,

`ID_device` int(11) default NULL,

`ID_segment` int(11) default NULL,

`MAC` varchar(15) collate utf8_czech_ci default NULL,

`name` varchar(254) collate utf8_czech_ci default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`),

KEY `device_iface` (`ID_device`),

KEY `segment_iface` (`ID_segment`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `iface`

--

-- --------------------------------------------------------

--

-- Table structure for table `ip_address`

--

CREATE TABLE `ip_address` (

`ID_iface` int(11) default NULL,

`ID_VLAN_iface` int(11) default NULL,

`ID_subnet` int(11) default NULL,

`IP_address` int(11) default NULL,

`ID` int(11) NOT NULL auto_increment,

PRIMARY KEY (`ID`),

KEY `iface_address` (`ID_iface`),

KEY `VLAN_iface_address` (`ID_VLAN_iface`),

KEY `subnet_address` (`ID_subnet`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `ip_address`

--

-- --------------------------------------------------------

--

-- Table structure for table `member`

--

CREATE TABLE `member` (

`ID` int(11) NOT NULL auto_increment,

`street_number` varchar(50) character set latin1 default NULL,

`street` varchar(250) character set latin1 default NULL,

`town` varchar(250) character set latin1 default NULL,

`ZIP_code` varchar(10) character set latin1 default NULL,

`type` tinyint(4) default NULL,

`login` varchar(40) character set latin1 default NULL,

`password` varchar(40) character set latin1 default NULL,

`qos_ceil` varchar(20) character set latin1 default NULL,

`qos_rate` varchar(20) character set latin1 default NULL,

`entrance_fee` double default NULL,

`debt_payment_rate` double default NULL,

`entrance_fee_left` double default NULL,

`must_pay_regular_fee` tinyint(4) default NULL,

`current_credit` float default NULL,

`entrance_date` date default NULL,

`comment` varchar(250) character set latin1 default NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=2 ;

--

-- Dumping data for table `member`

--

-- --------------------------------------------------------

--

-- Table structure for table `payment`

--

CREATE TABLE `payment` (

`ID` int(11) NOT NULL auto_increment,

`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

`text` varchar(254) collate utf8_czech_ci default NULL,

`name` varchar(254) collate utf8_czech_ci default NULL,

`type` varchar(254) collate utf8_czech_ci default NULL,

`variable_symbol` bigint(20) default NULL,

`constant_symbol` int(11) default NULL,

`specific_symbol` int(11) default NULL,

`amount` double default NULL,

`fee` double default NULL,

`ID_payer` int(11) default NULL,

`unassigned_amount` double default NULL,

PRIMARY KEY (`ID`),

KEY `user_payment` (`ID_payer`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `payment`

--

-- --------------------------------------------------------

--

-- Table structure for table `payment_assignment`

--

CREATE TABLE `payment_assignment` (

`ID_member` int(11) default NULL,

`ID_payment` int(11) default NULL,

`amount` double default NULL,

`type` varchar(20) collate utf8_czech_ci default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

`ID` int(11) NOT NULL auto_increment,

PRIMARY KEY (`ID`),

KEY `member_payment` (`ID_member`),

KEY `payment_assignment` (`ID_payment`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `payment_assignment`

--

-- --------------------------------------------------------

--

-- Table structure for table `port`

--

CREATE TABLE `port` (

`ID` int(11) NOT NULL auto_increment,

`ID_device` int(11) default NULL,

`ID_segment` int(11) default NULL,

`name` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`),

KEY `device_port` (`ID_device`),

KEY `segment_port` (`ID_segment`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `port`

--

-- --------------------------------------------------------

--

-- Table structure for table `port_belongs_to_vlan`

--

CREATE TABLE `port_belongs_to_vlan` (

`ID_port` int(11) default NULL,

`ID_VLAN` int(11) default NULL,

`ID` int(11) NOT NULL auto_increment,

PRIMARY KEY (`ID`),

KEY `VLAN_on_port` (`ID_VLAN`),

KEY `port_belongs` (`ID_port`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `port_belongs_to_vlan`

--

-- --------------------------------------------------------

--

-- Table structure for table `segment`

--

CREATE TABLE `segment` (

`ID` int(11) NOT NULL auto_increment,

`name` varchar(254) collate utf8_czech_ci default NULL,

`technology` varchar(254) collate utf8_czech_ci default NULL,

`bitrate` int(11) default NULL,

`duplex` tinyint(4) default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `segment`

--

-- --------------------------------------------------------

--

-- Table structure for table `subnet`

--

CREATE TABLE `subnet` (

`ID` int(11) NOT NULL auto_increment,

`ID_OSPF_area` int(11) default NULL,

`name` varchar(254) collate utf8_czech_ci default NULL,

`network_address` int(11) default NULL,

`netmask` int(11) default NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `subnet`

--

-- --------------------------------------------------------

--

-- Table structure for table `user`

--

CREATE TABLE `user` (

`ID_member` int(11) default NULL,

`ID` int(11) NOT NULL default '0',

`name` varchar(30) character set latin1 default NULL,

`middle_name` varchar(30) character set latin1 default NULL,

`surname` varchar(60) character set latin1 default NULL,

`pre_title` varchar(40) character set latin1 default NULL,

`post_title` varchar(30) character set latin1 default NULL,

`birthday` date default NULL,

`phone` varchar(40) character set latin1 default NULL,

`email` varchar(60) character set latin1 default NULL,

`login` varchar(50) character set latin1 default NULL,

`password` varchar(50) character set latin1 default NULL,

`web_messages_types` int(11) default NULL,

`email_messages_types` int(11) default NULL,

`comment` varchar(250) character set latin1 default NULL,

PRIMARY KEY (`ID`),

KEY `member_user` (`ID_member`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--

-- Dumping data for table `user`

--

-- --------------------------------------------------------

--

-- Table structure for table `vlan`

--

CREATE TABLE `vlan` (

`ID` int(11) NOT NULL auto_increment,

`name` varchar(254) collate utf8_czech_ci default NULL,

`tag_802_1q` int(11) default NULL,

`comment` varchar(254) collate utf8_czech_ci default NULL,

PRIMARY KEY (`ID`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `vlan`

--

-- --------------------------------------------------------

--

-- Table structure for table `vlan_iface`

--

CREATE TABLE `vlan_iface` (

`ID` int(11) NOT NULL auto_increment,

`ID_VLAN` int(11) default NULL,

`ID_iface` int(11) default NULL,

PRIMARY KEY (`ID`),

KEY `VLAN_on_iface` (`ID_VLAN`),

KEY `iface_belongs_to_VLAN` (`ID_iface`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `vlan_iface`

--

--

-- Constraints for dumped tables

--

--

-- Constraints for table `access_mod`

--

ALTER TABLE `access_mod`

ADD CONSTRAINT `device_access_mod` FOREIGN KEY (`ID_device`) REFERENCES `device` (`ID`),

ADD CONSTRAINT `user_access_mod` FOREIGN KEY (`ID_user_admin`) REFERENCES `user` (`ID`);

--

-- Constraints for table `contact`

--

ALTER TABLE `contact`

ADD CONSTRAINT `user_contact` FOREIGN KEY (`ID_user`) REFERENCES `user` (`ID`);

--

-- Constraints for table `credit_mod`

--

ALTER TABLE `credit_mod`

ADD CONSTRAINT `member_credit_mod` FOREIGN KEY (`ID_member`) REFERENCES `member` (`ID`),

ADD CONSTRAINT `user_credit_mod` FOREIGN KEY (`ID_user_admin`) REFERENCES `user` (`ID`);

--

-- Constraints for table `device`

--

ALTER TABLE `device`

ADD CONSTRAINT `user_device` FOREIGN KEY (`ID_user`) REFERENCES `user` (`ID`);

--

-- Constraints for table `iface`

--

ALTER TABLE `iface`

ADD CONSTRAINT `segment_iface` FOREIGN KEY (`ID_segment`) REFERENCES `segment` (`ID`),

ADD CONSTRAINT `device_iface` FOREIGN KEY (`ID_device`) REFERENCES `device` (`ID`);

--

-- Constraints for table `ip_address`

--

ALTER TABLE `ip_address`

ADD CONSTRAINT `subnet_address` FOREIGN KEY (`ID_subnet`) REFERENCES `subnet` (`ID`),

ADD CONSTRAINT `iface_address` FOREIGN KEY (`ID_iface`) REFERENCES `iface` (`ID`),

ADD CONSTRAINT `VLAN_iface_address` FOREIGN KEY (`ID_VLAN_iface`) REFERENCES `vlan_iface` (`ID`);

--

-- Constraints for table `payment`

--

ALTER TABLE `payment`

ADD CONSTRAINT `user_payment` FOREIGN KEY (`ID_payer`) REFERENCES `user` (`ID`);

--

-- Constraints for table `payment_assignment`

--

ALTER TABLE `payment_assignment`

ADD CONSTRAINT `payment_assignment` FOREIGN KEY (`ID_payment`) REFERENCES `member` (`ID`),

ADD CONSTRAINT `member_payment` FOREIGN KEY (`ID_member`) REFERENCES `member` (`ID`);

--

-- Constraints for table `port`

--

ALTER TABLE `port`

ADD CONSTRAINT `segment_port` FOREIGN KEY (`ID_segment`) REFERENCES `segment` (`ID`),

ADD CONSTRAINT `device_port` FOREIGN KEY (`ID_device`) REFERENCES `port` (`ID`);

--

-- Constraints for table `port_belongs_to_vlan`

--

ALTER TABLE `port_belongs_to_vlan`

ADD CONSTRAINT `port_belongs` FOREIGN KEY (`ID_port`) REFERENCES `port` (`ID`),

ADD CONSTRAINT `VLAN_on_port` FOREIGN KEY (`ID_VLAN`) REFERENCES `vlan` (`ID`);

--

-- Constraints for table `user`

--

ALTER TABLE `user`

ADD CONSTRAINT `member_user` FOREIGN KEY (`ID_member`) REFERENCES `member` (`ID`);

--

-- Constraints for table `vlan_iface`

--

ALTER TABLE `vlan_iface`

ADD CONSTRAINT `iface_belongs_to_VLAN` FOREIGN KEY (`ID_iface`) REFERENCES `iface` (`ID`),

ADD CONSTRAINT `VLAN_on_iface` FOREIGN KEY (`ID_VLAN`) REFERENCES `vlan` (`ID`);

The various assets directory are for assets and helpers for the various

QControls, including images, javascript files and popups.

Of course, these files can technically be anywhere in the docroot,

but the current directory location of /assets/* is meant to serve

as a centrally-available assets location for these QControl helpers.

If you want to move them (either individually or entirely),

be sure to update your configuration.inc.php to reflect the new

location(s) of the assets.

In short, feel free to add/modify as you wish.

And also, any additional QControl classes that you create or download which

may have their own assets should have their assets installed in one of these

subdirectories. And any additional other js, css, etc. assets for your

application could be placed here, as well.

Finally, note that within EACH asset type (e.g. css, images, js and php),

files in the _core subdirectory are intended to be part of Qcodo Core,

and rules concerning the upgrading/modification for these files follows

the same rules for Qcodo Core files everywhere else.

<?php

function CastToInt($strNumber) {

settype($strNumber, "int");

return $strNumber;

}

if ((!array_key_exists("intTimestamp", $_GET)) || (!$_GET["intTimestamp"])) {

$intTimestamp = time();

} else

$intTimestamp = $_GET["intTimestamp"];

$intSelectedMonth = CastToInt(date("n", $intTimestamp));

$intSelectedDay = CastToInt(date("j", $intTimestamp));

$intSelectedYear = CastToInt(date("Y", $intTimestamp));

$intTimestamp = mktime(0,0,0, $intSelectedMonth, $intSelectedDay, $intSelectedYear);

$dttToday = mktime(0,0,0, date("n"), date("j"), date("Y"));

$intMonthStartsOn = CastToInt(date("w", mktime(0,0,0, $intSelectedMonth, 1, $intSelectedYear)));

$intMonthDays = CastToInt(date("t", $intTimestamp));

$intPreviousMonthDays = CastToInt(date("t", mktime(0,0,0, $intSelectedMonth - 1, 1, $intSelectedYear)));

$strQueryArgs = sprintf("&strFormId=%s&strId=%s", $_GET["strFormId"], $_GET["strId"]);

$strChangeCommand = sprintf('window.opener.document.forms["%s"].elements["%s"].value = "%s"; ',

$_GET["strFormId"],

$_GET["strId"],

date("M j Y", $intTimestamp));

$strChangeCommand .= sprintf('window.opener.document.forms["%s"].elements["%s_intTimestamp"].value = "%s"; ',

$_GET["strFormId"],

$_GET["strId"],

$intTimestamp);

$strChangeCommand .= sprintf('if (window.opener.document.forms["%s"].elements["%s"].onchange) window.opener.document.forms["%s"].elements["%s"].onchange();',

$_GET["strFormId"],

$_GET["strId"],

$_GET["strFormId"],

$_GET["strId"]);

?>

<html>

<head>

<title>Calendar</title>

<script type="text/javascript">

function selectDate(intTimestamp) {

document.location = "calendar.php?intTimestamp=" + intTimestamp + "<?php print($strQueryArgs); ?>";

}

function cancel() {

window.close();

}

function done() {

<?php print($strChangeCommand); ?>

window.close();

}

</script>

<style>

.main {

font-family: verdana, arial, helvetica, sans-serif;

font-size: 9px;

text-align: center;

color: #004d5d

}

A {

text-decoration: none;

}

.dropdown {

background-color: #e5e5e5;

font-family: arial, helvetica, sans-serif;

font-size: 8pt;

}

.button {

font-family: verdana, arial, helvetica, sans-serif;

font-size: 7.5pt;

font-weight: bold;

color: #ffffff;

background-color: #004d5d;

text-align: center;

vertical-align: middle;

height: 18px;

border: thin solid #223344;

}

.offMonth {

color: #999999;

background-color: #f0f0f0;

}

.onMonth {

color: #005599;

background-color: #e0f0f0;

}

.onMonthWeekend {

color: #80aabb;

background-color: #ffffff;

}

.selected {

color: #ffffff;

background-color: #ee0000;

}

.today {

color: #ffffff;

background-color: #80aabb;

}

</style>

</head>

<body><form method="get" name="myForm"><center>

<select name="dttMonth" class="dropdown" onchange="selectDate(document.myForm.dttMonth.options[document.myForm.dttMonth.selectedIndex].value)">

<?php

for ($intMonth = 1; $intMonth <= 12; $intMonth++) {

$intTimestampLabel = mktime(0,0,0, $intMonth, 1, $intSelectedYear);

$strLabel = date("F", $intTimestampLabel);

$strSelected = ($intMonth == $intSelectedMonth) ? "selected" : "";

printf('<option value="%s" %s>%s</option>', $intTimestampLabel, $strSelected, $strLabel);

}

?>

</select> &nbsp;

<select name="dttYear" class="dropdown" onchange="selectDate(document.myForm.dttYear.options[document.myForm.dttYear.selectedIndex].value)">

<?php

for ($intYear = 1970; $intYear <= 2010; $intYear++) {

$intTimestampLabel = mktime(0,0,0, $intSelectedMonth, 1, $intYear);

$strLabel = date("Y", $intTimestampLabel);

$strSelected = ($intYear == $intSelectedYear) ? 'selected="selected"' : '';

printf('<option value="%s" %s>%s</option>', $intTimestampLabel, $strSelected, $strLabel);

}

?>

</select>

<table cellspacing="2" cellpadding="2" border="0" class="main">

<tr>

<td>Su</td>

<td>Mo</td>

<td>Tu</td>

<td>We</td>

<td>Th</td>

<td>Fr</td>

<td>Sa</td>

</tr>

<?php

$intDaysBack = ($intMonthStartsOn == 0) ? 7 : $intMonthStartsOn;

$intIndex = 1 - $intDaysBack;

$intRowCount = 0;

while ($intRowCount < 6) {

print('<tr>');

for ($intDayOfWeek = 0; $intDayOfWeek <= 6; $intDayOfWeek++) {

if ($intIndex < 1) {

$intLabel = $intPreviousMonthDays + $intIndex;

$intTimestampLabel = mktime(0,0,0, $intSelectedMonth - 1, $intLabel, $intSelectedYear);

$strCssclass = "offMonth";

} else if ($intIndex > $intMonthDays) {

$intLabel = $intIndex - $intMonthDays;

$intTimestampLabel = mktime(0,0,0, $intSelectedMonth + 1, $intLabel, $intSelectedYear);

$strCssclass = "offMonth";

} else {

$intLabel = $intIndex;

$intTimestampLabel = mktime(0,0,0, $intSelectedMonth, $intLabel, $intSelectedYear);

$strCssclass = "onMonth";

if ((date("w", $intTimestampLabel) == 0) || (date("w", $intTimestampLabel) == 6))

$strCssclass = "onMonthWeekend";

else

$strCssclass = "onMonth";

}

if ($intTimestampLabel == $intTimestamp)

$strCssclass = "selected";

else if ($intTimestampLabel == $dttToday)

$strCssclass = "today";

printf('<td class="%s"><a class="%s" href="#" onclick="selectDate(%s)">%s</a></td>', $strCssclass, $strCssclass, $intTimestampLabel, $intLabel);

$intIndex++;

}

print('</tr>');

$intRowCount++;

}

?>

<tr>

<td colspan="7">Selected Day: <?php print(date("n/j/Y", $intTimestamp)); ?><br />&nbsp;</td>

</tr>

</table>

<input type="button" class="button" name="Done" value="DONE" onclick="done()" /> &nbsp;

<input type="button" class="button" name="Cancel" value="CANCEL" onclick="cancel()" />

</center></form></body></html>

<?php

//printf("Month Starts On: %s<br>Month Days: %s<br>Prev Month Days: %s", $intMonthStartsOn, $intMonthDays, $intPreviousMonthDays);

?>

<?php print(str_replace("&lt/script&gt", "</script>", $_POST["strHtml"])); ?>

<?php $_CONTROL->lblMessage->Render(); ?>

<p><?php $_CONTROL->flcFileAsset->Render(); ?></p>

<?php $_CONTROL->lblError->Render(); ?>

<p>

<?php $_CONTROL->btnUpload->Render(); ?>

<?php $_CONTROL->btnCancel->Render(); ?>

<img src="<?php _p(__IMAGE_ASSETS__) ?>/spacer.png" width="150" height="1" alt=""/><?php $_CONTROL->objSpinner->Render(); ?>

</p>

<?php

if ($_CONTROL->File) {

if ($strUrl = $_CONTROL->GetWebUrl()) print('<a href="' . $strUrl . '" target="_blank">');

$_CONTROL->imgFileIcon->Render();

if ($strUrl) print ('</a>');

print('<br/>');

if ($_CONTROL->Enabled)

$_CONTROL->btnDelete->Render();

} else {

if ($strUrl = $_CONTROL->GetWebUrl()) print('<a href="' . $strUrl . '" target="_blank">');

$_CONTROL->imgFileIcon->Render();

if ($strUrl) print ('</a>');

print('<br/>');

if ($_CONTROL->Enabled)

$_CONTROL->btnUpload->Render();

}

?>

<?php if ($_CONTROL->Enabled) $_CONTROL->dlgFileAsset->Render(); ?>

<?php

require('../../../includes/prepend.inc.php');

$intDatabaseIndex = $_POST['intDatabaseIndex'];

$strProfileData = $_POST['strProfileData'];

$strReferrer = $_POST['strReferrer'];

$objProfileArray = unserialize(base64_decode($strProfileData));

$objProfileArray = QType::Cast($objProfileArray, QType::ArrayType);

if ((count($objProfileArray) % 2) != 0)

throw new Exception('Database Profiling data appears to have been corrupted.');

?>

<html>

<head>

<title>Qcodo Development Framework - Database Profiling Tool</title>

<style>

body { font-family: 'Arial' 'Helvetica' 'sans-serif'; font-size: 14px; }

a:link, a:visited { text-decoration: none; }

a:hover { text-decoration: underline; }

pre { font-family: 'Lucida Console' 'Courier New' 'Courier' 'monospaced'; font-size: 11px; line-height: 13px; }

.page { padding: 10px; }

.headingLeft {

background-color: #446644;

color: #ffffff;

padding: 10px 0px 10px 10px;

font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif';

font-size: 18px;

font-weight: bold;

width: 70%;

vertical-align: middle;

}

.headingLeftSmall { font-size: 10px; }

.headingRight {

background-color: #446644;

color: #ffffff;

padding: 0px 10px 10px 10px;

font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif';

font-size: 10px;

width: 30%;

vertical-align: middle;

text-align: right;

}

.title { font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif'; font-size: 19px; font-style: italic; color: #330055; }

.code { background-color: #f4eeff; padding: 1px 10px 1px 10px; }

.function { font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif'; font-size: 12px; font-weight: bold; }

.function_details { font-family: 'Verdana' 'Arial' 'Helvetica' 'sans-serif'; font-size: 10px; color: #777777; }

</style>

<script type="text/javascript">

function Toggle(spanId) {

var obj = document.getElementById(spanId);

if (obj) {

if (obj.style.display == "block") {

// Make INVISIBLE

obj.style.display = "none";

} else {

// Make VISIBLE

obj.style.display = "block";

}

}

}

function ShowAll() {

for (var intIndex = 1; intIndex < <?php _p(count($objProfileArray)); ?>; intIndex = intIndex + 2) {

var obj = document.getElementById('query' + intIndex);

obj.style.display = "block";

}

}

function HideAll() {

for (var intIndex = 1; intIndex < <?php _p(count($objProfileArray)); ?>; intIndex = intIndex + 2) {

var obj = document.getElementById('query' + intIndex);

obj.style.display = "none";

}

}

</script>

</head>

<body topmargin="0" leftmargin="0" marginheight="0" marginwidth="0">

<table border="0" cellspacing="0" width="100%">

<tr>

<td nowrap="nowrap" class="headingLeft"><span class="headingLeftSmall">Qcodo Development Framework <?= QCODO_VERSION ?><br /></span>Database Profiling Tool</div></td>

<td nowrap="nowrap" class="headingRight">

<b>Database Index:</b> <?php _p($intDatabaseIndex); ?>;&nbsp;&nbsp;<b>Database Type:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Adapter); ?><br />

<b>Database Server:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Server); ?>;&nbsp;&nbsp;<b>Database Name:</b> <?php _p(QApplication::$Database[$intDatabaseIndex]->Database); ?><br />

<b>Profile Generated From:</b> <?php _p($strReferrer); ?>

</td>

</tr>

</table><br />

<div class="page">