text:
<?php

require_once dirname(__FILE__) . '/../lib/Config.php';

$adminpassword = isset($_POST['adminpassword']) ? $_POST['adminpassword'] : "admin";

$INSTALL = array();
$SAMPLEDATA = array();

$INSTALL[] = "CREATE TABLE comp_group (
    comp_id int(11) DEFAULT '0' NOT NULL,
    group_id int(11) DEFAULT '0' NOT NULL,
    KEY lab_id (group_id))";

$SAMPLEDATA[] = "INSERT INTO comp_group VALUES (1,1)";

$INSTALL[] = "CREATE TABLE computers__ID (
    sequence BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    PRIMARY KEY (sequence))";

$INSTALL[] = "CREATE TABLE computers (
    ID BIGINT UNSIGNED NOT NULL,
    name varchar(200),
    type varchar(100),
    flags_server tinyint(4) DEFAULT '0' NOT NULL,
    flags_surplus tinyint(4) DEFAULT '0' NOT NULL,
    os varchar(100),
    osver varchar(20),
    processor varchar(30),
    processor_speed varchar(30),
    location varchar(200) DEFAULT '' NOT NULL,
    serial varchar(200) DEFAULT '' NOT NULL,
    otherserial varchar(200) DEFAULT '' NOT NULL,
    ramtype varchar(200) DEFAULT '' NOT NULL,
    ram varchar(6) DEFAULT '' NOT NULL,
    network varchar(200) DEFAULT '' NOT NULL,
    ip varchar(20),
    mac varchar(30),
    hdspace varchar(6),
    contact varchar(90),
    contact_num varchar(90),
    comments text NOT NULL,
    date_mod datetime,
    PRIMARY KEY (ID),
    KEY location (location),
    KEY flags (flags_server))";

$SAMPLEDATA[] = "INSERT INTO computers
        (ID, name, type, os, osver, processor, processor_speed,
        location, ramtype, ram,
        network, ip, mac, hdspace)
        VALUES (1,'Ants','iMac DV','Mac OS','9.0.4','PowerPC G3',
        '400','Library Back Room','SDRAM DIMMs (<10ns)','192',
        'Generic 100Mbps Card','DHCP','00 50 E4','13')";
$SAMPLEDATA[] = "INSERT INTO computers__ID (sequence) VALUES (1)";

$INSTALL[] = "CREATE TABLE devices ( name char(200))";

$INSTALL[] = "CREATE TABLE event_log (
    ID int(11) NOT NULL auto_increment,
    item int(11) DEFAULT '0' NOT NULL,
    itemtype varchar(10) DEFAULT '' NOT NULL,
    date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    service varchar(20),
    level tinyint(4) DEFAULT '0' NOT NULL,
    message text NOT NULL,
    PRIMARY KEY (ID),
    KEY comp (item),
    KEY date (date))";

$INSTALL[] = "CREATE TABLE followups (
    ID int(11) NOT NULL auto_increment,
    tracking int(11),
    date datetime,
    author varchar(200),
    contents text,
    minspent int(11) NOT NULL default 0,
    public tinyint NOT NULL default 1,
    PRIMARY KEY (ID))";

$INSTALL[] = "CREATE TABLE groups (
    ID int(11) NOT NULL auto_increment,
    name varchar(200) DEFAULT '' NOT NULL,
    PRIMARY KEY (ID),
    KEY ID (ID),
    UNIQUE ID_2 (ID))";

$SAMPLEDATA[] = "INSERT INTO groups VALUES (1,'test')";

$INSTALL[] = "CREATE TABLE inst_software (
    ID int(11) NOT NULL auto_increment,
    cID int(11) DEFAULT '0' NOT NULL,
    sID int(11) DEFAULT '0' NOT NULL,
    lID int(11) NOT NULL default '0',
    gID int(11),
    lCnt int(11) NOT NULL DEFAULT '1',
    PRIMARY KEY (ID),
    KEY cID (cID),
    KEY sID (sID),
    KEY lID (lID))";

$INSTALL[] = "CREATE TABLE lookups(
        id varchar(50) NOT NULL,
        name varchar(50) NOT NULL,
        description varchar(255),
        PRIMARY KEY(id))";

$INSTALL[] = "INSERT INTO lookups VALUES
        ('locations', '"._('Location')."', '"._('Locations : Use this to edit where equipment can be stored')."'),
        ('type', '"._('Type')."', '"._('Computer Types :These list the types of computers you can have (i.e. Dell, HP, IBM RS/6000, etc.)')."'),
        ('os', '"._('OS')."', '"._('Operating Systems : This is a list of Operating Systems your computers can run.')."'),
        ('ram', '"._('RAM Type')."', '"._('RAM Types : This is the types of RAM your systems can have (i.e. Unbuffered DIMMS, SDRAM DIMMS, ECC DIMMS, etc)')."'),
        ('processor', '"._('Processor')."', '"._('Processor Types : This is a list of valid processors, i.e. Intel Pentium, Pentium II, DEC Alpha, EverSlow WinChip, etc.')."'),
        ('iface', '"._('Network Interface')."', '"._('Network Interfaces')."'),
        ('network', '"._('Network Card Type/Brand')."', '"._('Network Card Brands/Types : This is a list of some possible network cards and their speed.')."')";

$INSTALL[] = "CREATE TABLE lookup_data(
        lookup varchar(50) NOT NULL,
        value varchar(255) NOT NULL,
        INDEX(lookup))";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','10Mbps Ethernet (UTP)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','100Mbps Ethernet (UTP)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','100Base FL')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','100Mbps FDDI')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','Frame Relay')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','ISDN')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','T1/E1 +')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('iface','Serial Link')";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('locations','Library Back Room')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('locations','Room 34')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('locations','MAOS Lab')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('locations','Office')";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','3Com (100Mbps)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','3Com (10Mbps)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','Intel (100Mbps)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','Intel (10Mbps)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','Generic 100Mbps Card')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','Generic 10Mbps Card')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','None')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','AMD 10Mbps')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','Realtek 10Mbps')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('network','Realtek 100Mbps')";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Linux (Debian)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Linux (RedHat)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Linux (Caldera)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','DOS')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','FreeBSD')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Linux (Other)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Windows')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Other')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Mac OS')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','IRIX')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Solaris')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('os','Max OS X')";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','Intel Pentium')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','Intel Pentium II')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','AMD K6-1')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','AMD K6-2')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','AMD K6-3')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','PowerPC G3')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','Intel Pentium III')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','AMD Athlon')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','68k (Motorola)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','486 SX')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','486 DX')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','486 DX2/4')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','Intel Itanium')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','PowerPC G4')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','RS3000')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','RS10k')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','Alpha EV6.7')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','PowerPC 603ev')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','PowerPC 603')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','PowerPC 601')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','68040')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('processor','68040')";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','36pin SIMMS')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','72pin SIMMS (Fast Page)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','72pin SIMMS (EDO)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','Unbuffered DIMMs')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','DIMMs w/EEPROM')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','SDRAM DIMMs (<10ns)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','ECC DIMMs')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','Other')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('ram','iMac DIMMS')";

$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Generic PC')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Macintosh PPC (other)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Macintosh 68K (68030)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Macintosh 68K (68040)')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Other')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','IBM RS/6000')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Indy')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Octane')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','O2')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Onyx 2')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','iMac')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','iMac DV')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Blue and White G3')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','G4')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Homebrew')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Cisco Catalyst 2900 XL')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Cisco 2600')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','3Com AccessBuilder')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','3Com LinkBuilder Hub')";
$SAMPLEDATA[] = "INSERT INTO lookup_data VALUES ('type','Cisco 400-series Fast Hub')";

$INSTALL[] = "CREATE TABLE networking__ID (
	sequence BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (sequence))";

$INSTALL[] = "CREATE TABLE networking (
	ID BIGINT UNSIGNED NOT NULL,
	name varchar(30) DEFAULT '' NOT NULL,
	type varchar(30) DEFAULT '' NOT NULL,
	ram varchar(10),
	ip varchar(20) DEFAULT '' NOT NULL,
	mac varchar(30),
	location varchar(40) DEFAULT '' NOT NULL,
	serial varchar(50),
	otherserial varchar(50),
	contact varchar(30) DEFAULT '' NOT NULL,
	contact_num varchar(30) DEFAULT '' NOT NULL,
	datemod datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
	comments text NOT NULL,
	PRIMARY KEY (ID))";

$INSTALL[] = "CREATE TABLE networking_ports (
	ID int(11) NOT NULL auto_increment,
	device_on int(11) DEFAULT '0' NOT NULL,
	device_type varchar(200) DEFAULT '' NOT NULL,
	iface char(40) DEFAULT '' NOT NULL,
	ifaddr char(30) DEFAULT '' NOT NULL,
	ifmac char(30) DEFAULT '0' NOT NULL,
	logical_number int(11) DEFAULT '0' NOT NULL,
	name char(30) DEFAULT '' NOT NULL,
	PRIMARY KEY (ID))";

$SAMPLEDATA[] = "INSERT INTO networking_ports
	(device_on, device_type, iface, ifaddr, ifmac, logical_number, name)
	VALUES (1,1,'100Mbps Ethernet (UTP)','DHCP','00 50 E4',1,'Port 1')";

$INSTALL[] = "CREATE TABLE networking_wire (
	ID int(11) NOT NULL auto_increment,
	end1 int(11) DEFAULT '0' NOT NULL,
	end2 int(11) DEFAULT '0' NOT NULL,
	PRIMARY KEY (ID))";

$INSTALL[] = "CREATE TABLE prefs (
	user varchar(80) DEFAULT '' NOT NULL,
	type enum('no','yes') DEFAULT 'no' NOT NULL,
	os enum('no','yes') DEFAULT 'no' NOT NULL,
	osver enum('no','yes') DEFAULT 'no' NOT NULL,
	processor enum('no','yes') DEFAULT 'no' NOT NULL,
	processor_speed enum('no','yes') DEFAULT 'no' NOT NULL,
	location enum('no','yes') DEFAULT 'no' NOT NULL,
	serial enum('no','yes') DEFAULT 'no' NOT NULL,
	otherserial enum('no','yes') DEFAULT 'no' NOT NULL,
	ramtype enum('no','yes') DEFAULT 'no' NOT NULL,
	ram enum('no','yes') DEFAULT 'no' NOT NULL,
	network enum('no','yes') DEFAULT 'no' NOT NULL,
	ip enum('no','yes') DEFAULT 'no' NOT NULL,
	mac enum('no','yes') DEFAULT 'no' NOT NULL,
	hdspace enum('no','yes') DEFAULT 'no' NOT NULL,
	contact enum('no','yes') DEFAULT 'no' NOT NULL,
	contact_num enum('no','yes') DEFAULT 'no' NOT NULL,
	comments enum('no','yes') DEFAULT 'no' NOT NULL,
	date_mod enum('no','yes') DEFAULT 'no' NOT NULL,
	advanced_tracking enum('no','yes') DEFAULT 'no' NOT NULL,
	tracking_order enum('no','yes') DEFAULT 'no' NOT NULL,
	PRIMARY KEY (user))";

$SAMPLEDATA[] = "INSERT INTO prefs
		(user, type, advanced_tracking)
		VALUES ('Admin','yes','yes')";

$INSTALL[] = "CREATE TABLE software (
	ID int(11) NOT NULL auto_increment,
	name varchar(200),
	platform varchar(200),
	install_package varchar(255),
	class enum('Operating System',
			'Application',
			'CAL',
			'Application Bundle',
			'Server')
		default 'Application',
	comments text,
	PRIMARY KEY (ID)
)";

$SAMPLEDATA[] = "INSERT INTO software
	(name, platform, class,
	 comments)
	VALUES
	('Test Software','FreeBSD','Application',
	 'This one is in the Back Room')";
$SAMPLEDATA[] = "INSERT INTO software
	(name, platform, class,
	 comments)
	VALUES
	('Windows 95','Mac OS','Operating System',
	 'This one is in the Back Room')";
$SAMPLEDATA[] = "INSERT INTO software
	(name, platform, class,
	 comments)
	VALUES
	('BlackWidowExplorer','DOS', 'Application',
	 'Comment Here')";

$INSTALL[] = "CREATE TABLE templ_inst_software (
	ID int(11) NOT NULL auto_increment,
	cID int(11) DEFAULT '0' NOT NULL,
	sID int(11) DEFAULT '0' NOT NULL,
	PRIMARY KEY (ID),
	KEY cID (cID),
	KEY sID (sID))";

$SAMPLEDATA[] = "INSERT INTO templ_inst_software VALUES (1,2,3)";
$SAMPLEDATA[] = "INSERT INTO templ_inst_software VALUES (2,2,2)";

$INSTALL[] = "CREATE TABLE templates (
	ID int(11) NOT NULL auto_increment,
	templname varchar(200),
	name varchar(200),
	type varchar(200),
	flags_server tinyint(4) DEFAULT '0' NOT NULL,
	os varchar(200),
	osver varchar(20),
	processor varchar(200),
	processor_speed varchar(100),
	location varchar(200),
	serial varchar(200),
	otherserial varchar(200),
	ramtype varchar(200),
	ram varchar(20),
	network varchar(200),
	ip varchar(20),
	mac varchar(40),
	hdspace varchar(10),
	contact varchar(200),
	contact_num varchar(200),
	comments text,
	iface varchar(100),
	flags_surplus TINYINT(4) default NULL,
	PRIMARY KEY (ID))";

$INSTALL[] = "INSERT INTO templates
	(templname)
	VALUES
	('Blank Template')";
$SAMPLEDATA[] = "INSERT INTO templates
	(templname, type, flags_server, os, osver, processor,
	 processor_speed, location, ramtype, ram, network,
	 ip,hdspace,iface)
	VALUES
	('Mac G3 All-in-One','Macintosh PPC (other)',1,'Mac OS','8.1','486 DX',
	'266','MAOS Lab','SDRAM DIMMs (<10ns)','96','Generic 100Mbps Card',
	'205.155.38','3','100Mbps Ethernet (UTP)')";
$SAMPLEDATA[] = "INSERT INTO templates
	(templname, type, os, osver, processor, processor_speed, location,
	 ramtype, ram, network, mac, hdspace,
	 iface)
	VALUES
	('iMac','iMac','Mac OS','8.6','PowerPC G3','333','Library Back Room',
	 'iMac DIMMS','32','Generic 100Mbps Card','00 50 E4','6',
	 '100Mbps Ethernet (UTP)')";
$SAMPLEDATA[] = "INSERT INTO templates
	(templname, type, os, osver, processor, processor_speed,
	 location, ramtype, ram, network,
	 hdspace, iface)
	VALUES
	('iMac DV','iMac DV','Mac OS','9.0.4','PowerPC G3','400',
	 'Library Back Room','SDRAM DIMMs (<10ns)','64','Generic 100Mbps Card',
	 '13','100Mbps Ethernet (UTP)')";

$INSTALL[] = "CREATE TABLE tracking__ID (
	sequence BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
	PRIMARY KEY (sequence))";

$INSTALL[] = "CREATE TABLE tracking_status (
	status		VARCHAR(255) NOT NULL,
	closed		TINYINT UNSIGNED NOT NULL DEFAULT 0,
	PRIMARY KEY (status))"; // TYPE=InnoDB

$INSTALL[] = "INSERT INTO tracking_status (status, closed) VALUES
		('new', 0),
		('old', 1),
		('wait', 0),
		('assigned', 0),
		('active', 0),
		('complete', 1),
		('duplicate', 1)";

$INSTALL[] = "CREATE TABLE tracking (
	ID BIGINT UNSIGNED NOT NULL,
	date datetime,
	closedate datetime,
	status		VARCHAR(255) NOT NULL DEFAULT 'new',
	author varchar(200),
	assign varchar(200),
	computer int(11),
	contents text,
	priority tinyint(4) DEFAULT '1' NOT NULL,
	is_group enum('no','yes') DEFAULT 'no' NOT NULL,
	uemail varchar(100),
	emailupdates varchar(4),
	other_emails TEXT,
	INDEX (status),
	device varchar (200),
	FOREIGN KEY (status) REFERENCES tracking_status (status),
	PRIMARY KEY (ID))"; // TYPE=InnoDB";

$INSTALL[] = "CREATE TABLE users (
	name char(255) DEFAULT '' NOT NULL,
	password char(255),
	fullname char(200),
	email char(100),
	location char(200),
	phone char(100),
	type enum('post-only',
		  'normal',
		  'tech',
		  'admin') DEFAULT 'post-only' NOT NULL,
	comments text,
	PRIMARY KEY(name),
	KEY (type))";

$INSTALL[] = "INSERT INTO users
	(name, password, fullname, email,
	 location, phone, type)
	VALUES
	('Admin',md5('$adminpassword'),'Administrator Guy','root@localhost',
	 'Admin Place (in front of the computer)','Use e-mail','admin')";
$INSTALL[] = "INSERT INTO users
	(name, password, fullname, type)
	VALUES
	('Guest',md5('guest'),'Guest User','post-only')";
$SAMPLEDATA[] = "INSERT INTO users
	(name, password, fullname, email, type)
	VALUES
	('Normal',md5('normal'),'Normal User','user@localhost','normal')";
$INSTALL[] = "INSERT INTO users
	(name, password, fullname, email, type)
	VALUES
	('Tech',md5('tech'),'Technician User','tech@localhost','tech')";
$INSTALL[] = "INSERT INTO users
	(name, password, fullname, type)
	VALUES
	('IRMConnect',md5('irmconnect'),'Special account','post-only')";

$INSTALL[] = "CREATE TABLE config (
	variable	VARCHAR(255) NOT NULL,
	value		TEXT NOT NULL,
	PRIMARY KEY (variable))";

$DBVER = '1.5.8';
$INSTALL[] = "INSERT INTO config (variable, value) VALUES ('dbver', '$DBVER')";
unset($DBVER);

$INSTALL[] = "CREATE TABLE software_bundles (
	bID int(11) unsigned DEFAULT '0' NOT NULL,
	sID int(11) unsigned DEFAULT '0' NOT NULL,
	KEY sID_ndx (sID),
	KEY bID_ndx (bID),
	PRIMARY KEY (sID,bID))";

$INSTALL[] = "CREATE TABLE software_licenses (
	sID int(11) NOT NULL,
	licensekey varchar(200),
	entitlement int(11) DEFAULT '0' NOT NULL,
	ID int(11) NOT NULL auto_increment,
	oem_sticker enum ('Yes', 'No') DEFAULT 'No' NOT NULL,
	PRIMARY KEY (ID),
	KEY sID_ndx (sID),
	KEY ID_ndx (ID))";

$INSTALL[] = "CREATE TABLE kbarticles (
	ID int(11) NOT NULL auto_increment,
	categoryID int(11) NOT NULL default '0',
	question text NOT NULL,
	answer text NOT NULL,
	faq enum('yes','no') NOT NULL default 'no',
	PRIMARY KEY (ID),
	KEY ID (ID))";

$INSTALL[] = "CREATE TABLE kbcategories (
	ID int(11) NOT NULL auto_increment,
	parentID int(11) NOT NULL default '0',
	name text NOT NULL,
	PRIMARY KEY (ID),
	KEY ID (ID))";

$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(1, 0, 'IRM')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(2, 1, 'Computers')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(3, 1, 'Networking')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(4, 1, 'Software')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(5, 1, 'Tracking')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(6, 1, 'Reports')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(7, 1, 'Request Help')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(8, 1, 'Setup')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(9, 1, 'Preferences')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(10, 1, 'Knowledge Base')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(11, 1, 'FAQ')";
$SAMPLEDATA[] = "INSERT INTO kbcategories
	(ID, parentID, name)
	VALUES
	(12, 1, 'Logout')";

$INSTALL[] = "CREATE TABLE fasttracktemplates (
	ID INT NOT NULL auto_increment,
	name char(100),
	priority int(11),
	request text,
	response text,
	PRIMARY KEY (ID))";

$SAMPLEDATA[] = "INSERT INTO fasttracktemplates
	(name, priority)
	VALUES
	('Default',3)";
$SAMPLEDATA[] = "INSERT INTO fasttracktemplates
	(name, priority, request,
	 response)
	VALUES ('Reset Password',3, 'User forgot password',
	 'Reset password on the system')";
$SAMPLEDATA[] = "INSERT INTO fasttracktemplates
	(name, priority,
	 request,
	 response)
	VALUES
	('Floppy Disk in Drive',3,
	 'Computer will not boot, it says something about NTLDR not found',
	 'There was a floppy disk in the drive, once user removed it and rebooted system it started up just fine.')";

$INSTALL[] = "CREATE TABLE files(
	ID int(11) NOT NULL auto_increment,
	filename varchar(200),
	device varchar(100),
	deviceid varchar(100),
	PRIMARY KEY (ID))";

redpajama_set_name: RedPajamaGithub


text:
School Reopenings
ICE Compared to Slave Traders during Heated CNN Debate
BY James Kosur	August 3, 2018
ICE officials are no different than slave traders. That was the idea shared by CNN political commentator Angela Rye during a heated debate that occurred on Thursday night.
Speaking on Cuomo Prime Time, Rye told former Trump campaign spokesperson Jason Miller that she didn't view Trump as her President and then argued with Miller during a back-and-forth.
Miller told Rye it was crucial that the United States maintain strong immigration policies while criticizing Rye of demanding "open borders," a claim Rye denied.
Miller: "Clearly you don't want to enforce the border laws because that's what I've said."
Rye: "No, what I don't want to enforce is your president's nonsense. You guys know that this policy is ass-backward. Plain and simple. You guys know this policy is inhumane, plain and simple. Like, if you just take yourselves out of it for just a moment, take off the lenses of bigotry for just a moment and imagine —"
Miller: "Okay, so now we're getting into the name-calling?"
Rye: "Um, yes, we are. I'm calling this process, this procedure is absolutely based on bigotry and fearmongering. If you don't understand that your president announced his campaign by talking about … building a wall," replied Rye.
"My president? He's our president, Angela. He's the president of the United States," Miller cut off Rye to comment.
"Not mine. I will never claim a bigot, ever," added Rye.
She then continued to attack Trump's "zero tolerance" policy which has separated thousands of accompanied children from their parents while sending those kids sometimes thousands of miles away to detainment centers throughout the United States.
"I wish I could tell you from where in Africa my ancestors came from, at least part of them, but I wouldn't know because the same bigots who are sending people back away from their children are the ones who brought my ancestors here on slave ships. Congratulations," Rye proclaimed.
Here's the full CNN Debate:
Follow Us On: Facebook and Twitter

redpajama_set_name: RedPajamaCommonCrawl


Union Pacific Corp., Burlington Northern Santa Fe Corp., Norfolk Southern Corp., and CSX Corp. have agreed to establish interoperability standards for Positive Train Control, which is a long-sought collision avoidance technology that can stop a train before an accident occurs. PTC is designed to keep a train within authorized limits on a track and under its maximum speed limit.
The Association of American Railroads announced the agreement Oct. 8-9 and recently defended the rail industry's safety commitment. "Your article 'Feds: Technology could have prevented train crash,' mistakenly left the impression that the freight rail industry has been slow or reluctant to implement positive train control technology. This is far from the truth," AAR President/CEO Ed Hamberger wrote in a Sept. 23 letter to the Modesto Bee. "The rail industry took the initiative to develop PTC and has invested millions of dollars in research and testing. There are more than 140,000 miles of rail track in the U.S., and passenger and freight trains share close to 25,000 of that same rail. For a nationwide PTC system to work, both freight and passenger trains must be equipped with collision avoidance systems that communicate with one another. That is not the case today. We look forward to working with the passenger rails and commuter agencies, as well as the Federal Railroad Administration, to implement a standardized anti-collision system. Enhancing the safety of both the freight and passenger rail systems in the United States with PTC is a goal we all share."
Rail safety has been a hot issue in California since the Chatsworth crash on Sept. 12 that killed a Metroliner engineer and 24 others.
"Our joint development of interoperable standards for a PTC system . . . is a significant hurdle that we have overcome and brings us much closer to a safe technology solution. Interoperability is one of our key challenges, since freight and passenger trains share tracks and must be able to exchange and use information in order for PTC to function appropriately," Dennis Duffy, Union Pacific's executive vice president-Operations, said Oct. 8. "We look forward to working with elected officials and regulators on another key challenge -– the need for additional radio spectrum -– so that we have sufficient communication, especially in metro areas such as Los Angeles and Chicago." CSX officially joined the other three railroads the following day.


text:
Q: Reusability with Styled-Components in React I need to use my custom spinner in other components. So I made a reusable spinner?
How do I copy its styles and customize other styles? I want to change just the stroke or the color of the loading. Pls check my code here
Spinner.js
import styled from 'styled-components'

const StyledSpinner = styled.svg`
  animation: rotate 1s linear infinite;
  width: 50px;
  height: 30px;

  & .path {
    stroke: #000000;
    stroke-linecap: round;
    animation: dash 1.5s ease-in-out infinite;
  }

  @keyframes rotate {
    100% {
      transform: rotate(360deg);
    }
  }
  @keyframes dash {
    0% {
      stroke-dasharray: 1, 150;
      stroke-dashoffset: 0;
    }
    50% {
      stroke-dasharray: 90, 150;
      stroke-dashoffset: -35;
    }
    100% {
      stroke-dasharray: 90, 150;
      stroke-dashoffset: -124;
    }
  }
`

const Spinner = () => (
  <StyledSpinner viewBox="0 0 50 50">
    <circle className="path" cx="25" cy="25" r="20" fill="none" strokeWidth="4" />
  </StyledSpinner>
)

export default Spinner

NewComponent.js
import CustomSpinner from '../Spinner'

const Spinner = styled(CustomSpinner)`
   & .path {
     stroke: #fff;
  }
`

A: You can add custom style inside the Spiner.js component and then export that. In NewComponent.js you export custom spiner style and put it same way like in Spiner.js
Spinner.js
import styled from 'styled-components';

export const StyledSpinner = styled.svg`
 animation: rotate 1s linear infinite;
 width: 50px;
 height: 30px;

 & .path {
  stroke: ${({ colorValue }) => colorValue}; // color props
  stroke-linecap: round;
  animation: dash 1.5s ease-in-out infinite;
 }

 @keyframes rotate {
   100% {
     transform: rotate(360deg);
   }
 }
 @keyframes dash {
   0% {
     stroke-dasharray: 1, 150;
     stroke-dashoffset: 0;
   }
   50% {
     stroke-dasharray: 90, 150;
     stroke-dashoffset: -35;
   }
   100% {
     stroke-dasharray: 90, 150;
     stroke-dashoffset: -124;
   }
 }
`;

const Spinner = ({ colorValue }) => (
  <StyledSpinner viewBox="0 0 50 50" colorValue={colorValue}>
    <circle
     className="path"
     cx="25"
     cy="25"
     r="20"
     fill="none"
     strokeWidth="4"
   />
 </StyledSpinner>
);

export default Spinner;

NewComponent.js
import Spinner from '../Spinner';

const CustomSpiners = () => (
  <Spinner colorValue="white" />
  <Spinner colorValue="red" />
);

export default CustomSpiner

redpajama_set_name: RedPajamaStackExchange


Let these funny Up Quotes from my large collection of funny quotes about life add a little humor to your day.
I have faith. I just need proof to back it up.
One cannot have everything the way he would like it.
anyway; he ought to make up his mind to get even.
because I know that I'm the sap.
you might wind up someplace else.
is something you dreamt up after being drunk all night.
There's no use being a damned fool about it.
if your best friends end up elsewhere.
all his limbs but the push-button finger.
who sat on his chair in the sky.
until we woke up bye and bye.
to which everyone can subscribe, and which mean very little.
pulling ourselves up by our bootstraps.
Thank you for visiting: Funny Up Quotes - Funny Quotes about Up.


text:
News: Satellite images 'show Atlantis'
Maxim Baldry Cast in Amazon's Lord of the Rings Series
Atlantis Online > Forum > Science Fiction & Fantasy > Lord of the Rings > Maxim Baldry Cast in Amazon's Lord of the Rings Series
Author Topic: Maxim Baldry Cast in Amazon's Lord of the Rings Series (Read 120 times)
One Ring to Rule Them All
JAKE ABBATETUESDAY, OCTOBER 15, 2019
Amazon continues to keep mum on what they have planned for their upcoming Lord of the Rings series. Regardless, the casting process is still ongoing. According to Collider, the show has just scored the third addition to its cast in the form of English actor Maxim Baldry.
ADVERTISEMENTSCROLL TO CONTINUE READING
Showrunners JD Payne and Patrick McKay began casting for the series over the summer. Baldry will join the previously-announced Markella Kavenagh and Will Poulter on the show. And just like with Kavenagh and Poulter, this latest revelation didn't share any pertinent details about Baldry's character. Regardless, his role is apparently "significant."
Baldry recently garnered some recognition for playing Viktor Goraya on HBO's six-part miniseries Years and Years, which premiered in May. Before that, he appeared on several episodes of the British soap opera Hollyoaks and had a recurring role on HBO's Rome. Baldry also recently wrote, directed, and starred in his own short film, Melodie Saviour.
RELATED: Amazon's Lord of the Rings Series Will Film In New Zealand
Once casting is completed, the series will begin production in New Zealand, which has been a stand-in for Middle-Earth since Peter Jackson kicked off the original Lord of the Rings film trilogy in 2001. Of course, this new project is taking on a shape that's very different from Jackson's movies. Rumors continue to persist about when the show might take place. However, fans keep pointing to a message posted by the series' official Twitter account that reads, "Welcome to the Second Age." Since this refers to the time period when the Rings of Power were created, many have speculated that the show picks up before The Fellowship of the Ring.
Payne and McKay are working with consultant (and Game of Thrones veteran) Bryan Cogman to develop the series. Jurassic World: Fallen Kingdom director is helming several episodes. No release date is set.
Do you have any theories about who Maxim Baldry might be playing on The Lord of the Rings? Tell us what you think in the comment section below!
Recommended Reading: The Hobbit (Graphic Novel)
TAGS: AMAZON, LORD OF THE RINGS, MAXIM BALDRY, THE LORD OF THE RINGS
Read more at https://www.superherohype.com/tv/469493-maxim-baldry-cast-in-amazons-lord-of-the-rings-series#J16qJ04UxCYZG8M3.99


Act Now to Keep Pipelines Off Ukok!
The proposed pipeline threatens a UNESCO World Heritage Site, national parks, and sacred lands.
The Telengit people and Russian environmental organizations are calling on the international community for help to stop construction of this gas pipeline on the sacred Ukok Plateau.


text:
Kuhpayeh Rural District () is a rural district (dehestan) in the Central District of Bardaskan County, Razavi Khorasan Province, Iran. At the 2006 census, its population was 5,829, in 1,876 families.  The rural district has 16 villages.

References

Rural Districts of Razavi Khorasan Province
Bardaskan County
Rural Districts of Bardaskan County
Bardaskan

redpajama_set_name: RedPajamaWikipedia


text:
Q: Create Xamarin.UITest for Android Checkbox I have an app that uses the Android CheckBox control.
How do I create a UITest that detects whether the CheckBox is checked?

A: Sample Code
bool IsCheckBoxChecked(string textBoxContentDescription)
{
    return (bool)app.Query(x => x.Marked(textBoxContentDescription).Invoke("isChecked"))?.FirstOrDefault();
}

Sample App
Here is a sample app that I've put together to demostrate how to do this:
https://github.com/brminnick/AndroidCheckBoxSampleApp
Explaination
To interact with an Android CheckBox from a UITest, you must use the Invoke method to access the methods in the native Java Android API. In our Invoke statements, we can take advantage of performClick() to toggle the CheckBox, setChecked(boolean checked) to set the value of the CheckBox, and isChecked() to return a bool that is true when the CheckBox is checked and false when it is unchecked.
In the UITest project, I created a ToggleCheckBox method to toggle an individual CheckBox, a IsCheckBoxChecked method to return the CheckBox current status, and a SetCheckBox method to set the CheckBox status.
All tests were validated via Xamarin Test Cloud. The test report is viewable here.


It is that lovely month of the year when red roses and milk chocolates are on everyone's mind. Some are thinking jewelry but I am thinking gold! I just recently read that coffee shops in large cities are serving gold lattes–lattes made with milk and turmeric. Although the spice turmeric has been around for cent uries it has become "the new gold" in America and it is popping up everywhere-from scientific journals to popular media. Personally, I was surprised about this new popularity of the spice since I grew up seeing my family use turmeric in their cooking. It is used in recipes all over India for color, flavor and healthful properties. In addition to cooking with it, I remember my mom pickling the fresh turmeric in lemon juice to take the pungency out, it was a great way to ensure it was fresh. The other vivid memory I have is of the hot turmeric milk that we had to drink every time we caught a cold. This made me forget the miserable feeling of a cold but instead the delicious tasting turmeric milk. Ironically, I followed in my mom's footsteps and gave the same turmeric milk to my daughters when they became sick, which they didn't like at first but now they make their own. I am very excited to share the recipe for this turmeric milk which I believe is "the golden latte" instead of spending $4-$5 on one at your local coffee shop!
Now let's talk about why turmeric is getting so popular. Being a dietitian and nutritionist I dive deep into scientific properties of foods and the more I read about turmeric the more I am convinced it is something worth elaborating on.
Turmeric comes from the plant Curcuma Longa which is a member of ginger family. The only difference between ginger and turmeric is that turmeric is yellow and ginger is a cream color. It is the yellow color which makes it healthy! Turmeric contains three phytochemicals namely Curcuminoids, Curcumin and Demethoxycurcumin. It is the curcumin that gives turmeric the distinctive yellow color and is the healthiest component.
Researchers have been studying Phytochemicals from vegetables, fruits, spices and herbs and have found them to be safe and effective for treating inflammation. The early studies have also shown promising but inconclusive effects of curcumin as an antioxidant, antidiabetic and reducing cholesterol. A few other health conditions that Curcumin seems to have promising positive and protective effects on are Arthritis, heart disease and cancer.
The best way to increase consumption would be to start purchasing ground turmeric (this is available in grocery stores and online) which is a yellow powder. Then mix it in a spice blend or marinades to use on chicken, seafood and meats. Turmeric makes soups and gravies come alive with a spicy yellow color! For using fresh turmeric, just peel the root and chop or grate it like ginger and sprinkle on foods. For those who like warm milk, I have shared the perfect way for you to create "the golden latte" below (I drink milk only this way whether I have cold or not) which is the most delicious way to enjoy milk and Curcumin.
I wish all of you a loving and healthy February!
Mix all the ingredients and heat in a sauce pan on medium heat.
Lower the heat after the first boil and simmer for 5-7 minutes till turmeric is completely mixed.
Remove from heat and serve in a cup. Use honey or sugar to sweeten it if needed!


text:
Holiday Bowl 2016
Minnesota players end boycott, will play in the Holiday Bowl
The players announced early today that they will, in fact, be traveling to San Diego to play Washington State.
By Michael Preston@RM_Preston Dec 17, 2016, 9:46am PST
Share All sharing options for: Minnesota players end boycott, will play in the Holiday Bowl
Photo by Steven Branscombe/Getty Images
For much of this week, players on the Minnesota Golden Gophers football team had boycotted all team activities over the expulsion and suspension of 10 players for their alleged involvement in a September gang rape of a woman off-campus. The team intended to continue this boycott until the players punishments were lifted, putting their appearance in the Holiday Bowl in serious jeopardy.
This morning, they announced they were ending their boycott and will, in fact, be playing in the Holiday Bowl against Washington State.
Prosecutors declined to file charges in the September case, but the university's Equal Opportunity and Affirmative Action committee found that it was "more than likely" that the alleged victim had been sexually assaulted in the case. That report resulted in the punishment levied against the players earlier this week.
There had been a 12 p.m. CT deadline for the school or team to make a decision on the bowl game today. If they had decided to forego traveling to San Diego, the Holiday Bowl would've likely gone to the Northern Illinois Huskies as the Cougs opponent, as they are the highest APR team remaining at 5-7.
The Holiday Bowl is scheduled for 4:00 p.m. PT on Dec. 27th on ESPN.


text:
Q&A with AEG's Jim King about the new All Points East festival in Victoria Park
by James Hanley
October 31st 2017	at 12:01AM
LCD Soundsystem and Bjork have joined The xx as headliners of AEG Presents' new All Points East festival in Victoria Park next year.
Lorde, Beck, Yeah Yeah Yeahs, Father John Misty, Phoenix, Flying Lotus 3D, Glass Animals, Sampha, Richie Hawtin and Dixon have also been confirmed for the line-up, which has been put together by AEG's Goldenvoice division, the team behind events such as British Summer Time Hyde Park.
AEG, which confirmed last week that it had secured an exclusive five-year contract to run events at the site, will launch the East London festival from May 25 to June 3 next year. Run over two weekends, the first will feature a three-day festival and the second will comprise three standalone headline shows including The National.
The 10-day All Points East event will also feature a four-day "community-focused" midweek event, featuring a mix of free and ticketed entertainment including comedy, sports screenings, educational activities, wellbeing sessions, food and drink and outdoor cinema.
Here, Music Week speaks to AEG Presents EVP, live music, Jim King, to find out how it all came about...
How was the concept devised?
We've always wanted to be able to undertake more events in Victoria Park. It's an amazing park - one of the best in the country - in a very exciting developing area of London and when the tender came up we were obviously very keen to go for it. We thought we had a really good proposal that Tower Hamlets local authority would respond favourably to and we think we presented a very strong plan. It's essentially six headliners - one weekend is a three-day festival format where there's a narrative running through those three days - a very eclectic bill across five stages. People can buy a day pass all the way up to a three-day pass. The second weekend is three headline concerts essentially. The first one of those is The National and they have a slightly narrower booking strategy because the support bill around those is very much about musically supporting the headline artist. It's an incredible bill if you're a National fan or a War On Drugs fan with that bill that's been put in place around that.
How similar is the format to BST Hyde Park?
We're very happy with the format of BST. We weren't really looking to copy that in any way but there are some considerable operational benefits that that format offers. In the context of Victoria Park, we felt it offered a number of very positive impacts for the local community. Where, historically, the events that have taken there place had run across two different periods of the year - the beginning of the summer and then the middle of the summer - that increased the impact for park users and the community quite considerably because there's two load-ins and two load-outs. The format of running the events back to back - two consecutive weekends - halves that straight away so we thought that that would play very well and would be received very positively. We like to have a positive impact on the local community for those who are not potentially that interested in the music events and the midweek offering helps create a platform where park users get their park back and we can then overlay a programme of content and events that we feel may appeal to those people.
BST has set a high bar in terms of production values, will it be a challenge to match that?
We don't look at it like that. When we started doing BST, we've always been of the belief that being outdoors or being in a greenfield environment is not an excuse for poor service and that was the ethos that we took into Hyde Park. It's definitely the ethos we take everywhere and that's not just in London but us as a business globally. Coachella and Desert Trip and Panorama [all in the US], amongst many other events that AEG Presents and Goldenvoice operate, are all about delivering amazing live experiences for artists and fans. We look to obviously set a very high benchmark in delivery but that's not just a one-off, that's what we try and do everywhere so a lot of high levels of customer experience in BST is prevalent across all of our business and it's something which we'll take into Victoria Park as well.
What will the capacity be?
It's still the same as it has been previously, so the park itself will be licensed for up to 40,000 people a day.
Did Glastonbury taking 2018 off play any part in your decision to launch this event now?
No, it's just that's really in the gift of the local authority so they were the ones who put the contract up for tender. We were just responding to their schedule and their timetable.
Why did you choose those particular headliners?
We aim to attract a particular headline artist if you like and a particular type of fan - one that's perhaps a more credible and independently-minded fan. Across those artists, I think that represents the direction that we want to take Victoria Park to over the next five years.
How did you come up with the All Points East name?
We liked the reference point of its location but at the same time we are looking to run a world class event where people from all around Europe will come to London to enjoy this so we're very proud of winning the contract and we're very proud of where the event is taking place, we're delighted to be operating in that area of London but we're looking to deliver an event that has world class appeal.
Finally, what is your take on the camping festivals vs city festivals debate?
I think the two formats co-exist very well and that will continue for some time. I don't subscribe to either one owning the particular format or the word festival, I think they both stand on their own merits and complement each other particularly well so I'm a fan of both. We like working on both and as a company we deliver both formats - but each has their place.
Festivals,
victoria park,
AEG Presents,
'You'd think we were mad to start it!': Cuffe & Taylor on Lytham Festival's 10th anniversary
AEG ups Jim King to CEO of European festivals division
'I'd love to take the credit, but it was their idea!' AEG's Jim King on Sigur Ros' Liminal Soundbath
Hit the spot: Why setlists are the new playlists


GSGRC Members Only – "Dedicated to our breed …Showdog, Hunter, Athlete and Companion"
Welcome to the GSGRC Members Only area. This section of the website was set up to allow on-line renewal. All information posted in this area is just for registered members. Although, the Golden Retriever is primarily a Hunting Retriever, the GSGRC members and their dogs participate in many other activities such as Conformation, Obedience, Agility, Tracking, Breeding, Educational Services as well as Field and Hunting events.


You identified the attendees of an open source event as an interesting target group for your business and decided to become a sponsor. Sounds like a win-win situation. Now let's quickly scroll through the checklist to make sure your commitment will be a success.
1. Think "marketing", not "sales"
Remember, sponsoring is an instrument of marketing. First thing you won't ask is "Do we make leads there?" because you know it's not a trade fair. Of course you will be visible as a sponsor. Your main objective would be a positive image of your company. Everyone organizing the event wants to make it great. Therefore your brand will be connected to positive feelings. It's your job to use that positive image in further marketing activities.
Open source communities have a culture of collaboration, transparency, and respect. For maximum impact your organization should become part of the community by embracing its culture. Show respect for what others are giving and have already contributed. Follow the community's announcements and discussions, become involved. If the community sees you are there and behave like a community member, you are a community member. Being a community member gives you credibility, and that is the currency of modern marketing.
The organizers you are dealing with know quite well that you give money for a reason. Constantly emphasizing that your company expects something "in return" for the sponsorship shows that you are not appreciating what you already received: free software, documentation, tutorials... or at least an event for reasonable entry fees that attracts a lot of the peers. Be wise and put your commitment in first place, not your expectations.
Open source event organizers know their target groups because they are long-term community members – as freelancers, employees or CXOs. And they usually donate their own worktime to organize the event. They typically do not get provisions for acquiring sponsor money (the money benefits the event 100 %), they are no professional fundraisers. Yet they are highly respected professionals in their everyday's jobs. They belong to your peer group. Don't cause them extra work by bargaining your benefits or by demanding to produce a lot of logo print spaces. Show that you are aware of their dedication and their workload – and value it. There's no better impact for you than having the peer group think positively of your brand.
Giving your money is one way of supporting the event. To make everyone involved love you as a sponsor, give more than that. Promote the event in every outbound communication (your newsletter, through your social media account...) and ask how else you can support. You might offer to write a press release or convince other companies to sponsor. You might offer storage space and shipping, if needed. You might procude a promotional video. Be creative. Be supportive.
How much would you appreciate a conference where you mainly learn how cool the sponsors are and how great their products and services are? And would you believe that? As a sponsor you should be grateful for organizers avoiding that impression. Too much sponsor focus can diminish the attendees' positive experience and therefore fail in achieving the image benefits at all. Instead, find a way to entertain the event. Organize free ice-cream for everyone. Put up a branded soccer table or bean bags on your dedicated "sponsor table" area.* Create a positive experience in itself.
Whatever goals you have defined for your company or organization – hiring talents, presenting your brand as one the of "big players", selling your products/services or finding fulfilment partners – the above rules can help you perform in any respect. Summarize your learning in the old public relations wisdom: "Do good and talk about it (yourself)."
*) Thanks for the inspiration: DigitalOcean booked an ice-cream truck for DrupalCon Amsterdam. undpaul assembled the soccer table at DrupalCamp Schwerin.


text:
Q: Calculating radials of a shape I'm traing to identify road-sign shapes using radials.
I have the center point of the shape and I must find 7 radials to identify the figure.
To find 7 radials I must find points at 0º, 30º, 60º and 90º, like in the following image (image a):
https://lh4.googleusercontent.com/-sFsGXGD9VGI/TqxRjwIoSPI/AAAAAAAAAD0/yUOhN7RNUhU/s445/radiais.png
The problem is, I don't know how to find a point that is on 30º from my center.
Look, on my first implamentation I was calculating 5 radials (0º, 45º and 90º), like image b:
To find the points at 0º I did:
//fix the y coordinate and increment x coord
for(x = center.x to width)
    pixel(x, center.y)

To find the points at 90º I did:
//fix the x coordinate and increment y coord
for(y = center.y to height)
    pixel(center.x, y)

To find the points at 45º I did:
//increment x and y coord in the same number
for(x = center.x, y = center.y to width, height)
    pixel(x, y)

So, I want to know how to access points at 30º and 60º.
ps.: sorry, a cannot post images yet! no reputation.

A: You can use the polar coordinate system. Here's a pseudocode:
theta = 30 * pi / 180                      // 30, 60, whatever
for r = 0 to length_of_line
    x = center.x + r * cos(theta)
    y = center.y + r * sin(theta)
    pixel(x, y)

This way you can draw radials with inclination of 12, 16, 94.7362, ... degree


text:
AUNTY LENA'S & ADARE COURT HOUSE
Aunty Lena's
Adare Court House
Aunty Lena's &
The Geraldines of Kildare developed Adare in mediaeval times and the present village was largely an early 19th century creation by the Dunravens. The building of the Gothic style Adare manor began in 1831.
In 1756 John Wesley preached to the people of Adare from under an ash tree near the Franciscan Friary and the tree was still there until about 1860. Today a stone marks the site where this tree stood and the Methodists hold a Field Meeting here in June each year. In the early 19th century, the Earl of Dunraven, laid the plans for the existing streets and townhouses of Adare. These lands and dwellings were rented to tenants under various agreements, some of which still exist today.
Adare in Irish is pronounced 'Áth Dara' which translates as "ford of oak", as previously mentioned Adare is renowned as one of the prettiest villages in Ireland and it certainly lives up to this herald, the Irish Government even agree having given Adare the designation 'Heritage Town'. Situated on the river Maigue, a tributary of the river Shannon, Adare is steeped in history dating back to the 12th Century.
Adare originated as a settlement on the eastern side of the crossing point over the River Maigue some 16km from the Viking forged City of Limerick. Historically a market town, in the Middle Ages, Adare was a major settlement with three monasteries and a castle.
Adare's three Monasteries:
The Adare Friary formerly known as the "Black Abbey" is an Augustinian Friary which was founded in 1316 by friars invited to Adare by the 1st Earl of Kildare, John Fitzthomas Fitzgerald. They set up home here building a beautiful abbey which due to extensive care and restoration still retains many of its original features; they also owned some land and cottages in and around the village and a fishing weir on the River Maigue. However after the reign of Henry VIII and his Tudor Suppression of Irish Monasteries, by the end of the 16th Century the Augustinians had fled to Limerick City. In 1807 the friary was given to the local Church of Ireland congregation for use as their parish church, St. Nicholas Church of Ireland. It also now houses St. Nicolas National School which was built in the abbey's refectory. It has been extensively restored by the Dunraven family throughout the 19th Century.
The Franciscan Abbey in Adare was founded in 1464 by Thomas Fitz-Maurice, the 7th Earl of Kildare taking two years to complete. It is currently a ruin and is located inside the Adare Manor Golf Club.
The Trinitarian Order established their only monastery in Ireland in Adare in 1230. The Abbey was restored in 1811 by the first Earl of Dunraven as the Catholic Parish church.
Desmond Castle
A fortress type structure is said to have first been built by the O'Donovans, who were rulers of the region into the late 12th century, and afterwards to have passed to the Kildare branch of the FitzGerald dynasty, who may be responsible for the majority of the remains of the present fortress. Desmond Castle, as it is popularly known, stands on the north bank of the River Maigue.
The castle was fortified with an ancient ring-fort, around the early part of the 13th century. There is a large square tower, close to the main road and bridge over the River Maigue. It is surrounded by a strong battlemented rampart with semicircular bastions. A gate to the south has a drawbridge. It became a strategic fortress during the following turbulent years. It was the property of the Earls of Kildare for nearly 300 years until the rebellion in 1536, when it was forfeited and granted to the Earls of Desmond who gave the castle its present name.
An extensive renovation has been in progress on the castle since 1996 but there is limited access granted to visitors via organised tours, not all areas are accessible due to the works but beautiful views of the castle can always be seen from the bridge.
A detached six-bay, two-storey courthouse built in 1863, with cut stone external limestone staircase to north elevation. Pitched slate roof with cut limestone copings and brackets to gables and cut limestone chimneystacks and eaves course. Rubble limestone walls with cut limestone plinth and flush dressed quoins. Square-headed openings with dressed limestone block-and-start flush surrounds and timber sliding sash windows, bipartite arched one-over-one pane to first floor and one-over-one pane to ground floor. Those to ground floor with relieving arches over. Square-headed opening to north elevation with replacement window and dressed stone surround. Pointed arch openings to front (east) elevation and north elevation with dressed limestone surrounds, cut limestone steps, timber battened doors and overlights. Cut stone staircase to north with cut limestone banister wall having cut copings. Cut limestone curved boundary wall to north with cut stone copings and square-headed openings with timber battened doors.
William Fogerty was the architect of this courthouse, which was financed by the Earl of Dunraven. The symmetrical façade gives the appearance of a pair of houses, each with three bays and a central door. The domestic element is further underlined as it was built to accommodate a caretaker on the ground floor. The unadorned limestone construction adds a certain austerity to the façade which gives the building a civic dimension. The fine stonework adds artistic interest and is indicative of the quality of craftsmanship used in the construction. The external staircase is another notable feature as this is where the public entered the first floor court. The building and its associated boundary walls make a notable addition to the town of Adare and additional significance can be attributed to this courthouse due to its close links with local history, having been financed by the Earl of Dunraven.
Mon – Thurs 9am – 11.30pm
Fri – Sat 9am – 12.30am
Sun 10am – 11pm
Aunty Lena's Bar, Main Street, Adare, County Limerick
Tel: +353 (0)61 396114
Email: info@auntylenas.com
Website by Little Big Dog Photo and video credit to www.photoandvideoproduction.ie/


text:
Q: How to connect MS ACCESS DB with my asp.net website I am trying to connect my MS Access Db with my asp.net website. When I run my code(on localhost only) it does not show any error or exception but it just wait for server to response.
I am following code :
 string connection = "Provider =Microsoft.ACE.OLEDB.12.0; datasource=I:/Adittya/test.accdb";

        string query = "select * from test";
        OleDbConnection con = new OleDbConnection(connection);
        OleDbCommand cmd = new OleDbCommand();
        cmd.CommandText = query;
        cmd.CommandType = CommandType.Text;
        OleDbDataReader dr = cmd.ExecuteReader();
        DataTable dt = new DataTable();
        dt.Load(dr);

        testGrid.DataSource = dt;
        testGrid.DataBind();

One more thing my DB is in my pen-drive whose location is static.
Do I have problem with my code or we cannot connect to DB present in pen-drive.

A: There is a problem in your code, You have not set the connection to the command object and also not open the connection.Below code is working for me. Try this
    string connection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\\Test1.accdb";

    string query = "select * from [Table]";
    OleDbConnection con = new OleDbConnection(connection);
    OleDbCommand cmd = new OleDbCommand();
    cmd.CommandText = query;
    cmd.CommandType = CommandType.Text;
    cmd.Connection = con;
    con.Open();
    OleDbDataReader dr = cmd.ExecuteReader();
    DataTable dt = new DataTable();
    dt.Load(dr);
    con.Close();
    testGrid.DataSource = dt;
    testGrid.DataBind();

or Try this solution Using SqlDataSource
Example:I have created a test Acess database and I used Sql datasource it is working fine. Try this solution
<connectionStrings>
    <add name="ConnectionString" connectionString="Provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\Test1.accdb"
        providerName="System.Data.OleDb" />
  </connectionStrings>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$     ConnectionStrings:ConnectionString %>" ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand="SELECT * FROM [Table]"></asp:SqlDataSource>
 <asp:GridView ID="GridView1" DataSourceID="SqlDataSource1" runat="server"></asp:GridView>

It is working fine for me.

A: try your data source as
datasource=I:\\Adittya\\test.accdb

A: use this
"Provider=Microsoft.Jet.OLEDB.4.0; " +
     "Data Source=" + Server.MapPath("Database/TestDB.mdb"))


fact induced that come back running treatment options are essential. This equates to explore taking a short time off have the desired effect these all makes all your family members counterintuitive.
you have big event having to operate all of our necks also much injury happen all of which are painful for more information regarding say the least.
Having a chair all of which has incorrect translations casters or perhaps some top that need to just do not law at all can also be the reason for lower backache. You are continuously getting to learn more about push-pull your chair to understand more about can get going to be the casters functioning Canada Goose Jacket, and this tends to be that exactly on which decrease back injury comes about You have a multi functional misshapen to learn more about sit with your high heel sandals throughout the the floor to can get an all in one traction force that is always that unhealthy arch to learn more about say going to be the least.
It has been even with everywhere in the lot of office environments Fake Chanel Bags that so that you have chairs functioning in the right way and giving staff going to be the necessary support Coach Outlet Online,about whether or not mounts office productivity practically no less than one signs hundred % Fatigue is this also lowered drastically all of these equates for additional details on an uplifted workforce. Obtaining going to be the potential to explore work for more information about your colleague with don�t you think becoming throughout the discomfort not only can they improve the workplace morale instantaneously.
chair brakes Give your against your skin a multi functional break and schedule an appointment with that all going to be the castors are functioning in the correct way.
zhangshaojie1020 Nowadays apart from the brand names explained previously mentioned, these day there are coach factory outlet store online higher than a hundred or so brand names regarding hiphop garments traces around the globe where are usually both well-known independently region or perhaps coach outlet store those who produced any identify around the world. From your leading hiphop trend garments series could be the brand name akademiks. Akademiks will be U . s . model of hiphop garments series well-known on the list of supporters with the coach online outlet hiphop tradition. The particular tag has been mostly created from the bros Donwan Harrell and also Emmet Harrell, in addition to one more band of lovers. One of many information in which produced akademiks popular is really because Louis Vuitton Outlet Online regarding the models. Donwan Harrell, one of many Harrell bros in which created the particular akademiks, can be can be one of many past top developers with Nike. When you are likely to use Louis Vuitton Purses the denim jeans in 2010, listed below are 3 crucial acquisitions to produce while respecting your thing persona. In case you are a classic, you ought to Michael Kors Handbags Michael Kors Outlet Handbags On Sale outfit the deep blue denims using a great clean white-colored top (or perhaps product in case you are any smooth or even a cozy), obtain a great coach outlet couple of loafers or perhaps ballerina pushes and also choose actually great colorful bag.
Louis Vuitton Outlet, buckskin components, shoes or boots, suitcases and also head wear.
Louis Vuitton Outlet got on the enterprise inside the 1970s and further proven the particular brand name because the position mark it really is nowadays. chenjiansu1029.
1106#@%@!...qifeng The particular instructing regarding research will be whole lot distinctive from any subject matter. That the particular Coach Outlet Store Online particular person instructing research has to be competent, whether or not he could be instructing the niche real world or perhaps on the web. This individual can educate the particular pupils in the quick and easy approach. Yet this individual Louis Vuitton Outlet Store needs to be furthermore mindful never to overlook the primary subject areas and also items in which must be included. This kind of on the web research tutoring is vital from your scholar's viewpoint due to the fact this individual provides the possibility to accessibility the particular international program although he could be looking for any guitar tutor. They can encounter Michael Kors Outlet Online a fantastic useful resource regarding research project aid. 1106#@%@!...qifeng.


Back to School Sale! Kevin and the Triple Creature Feature is 99 cents.
The third book in the series is 99 cents this week. Click here to pick it up.
Also my new book Baseball and Aliens is now available for pre-order. Pick it up here.
If you pre-order the book I want to give you some free stuff. Click here for your free stuff!
This entry was posted in Announcements on August 16, 2014 by mctiller.


Dan McAllister was elected San Diego County's Treasurer-Tax Collector in November 2002 and re-elected to his fourth term in June 2014 by an overwhelming 99% of the vote. Not only is he responsible for the collection of more than $5.5 billion in property taxes each year, but his office also manages the Investment Pool which reached an all-time high of $8.8 billion in April 2014, ensuring that funds are wisely invested and safeguarded for entities such as the school districts and cities in the County.
Dan also serves as a member of the San Diego County Employees Retirement Association, which manages more than $10 billion of investments. Prior to his election as San Diego County Treasurer-Tax Collector, Dan was a successful financial consultant and investment broker.


text:
「I need to…… get to the throne……」
CV: Konomi Kohara
Nobeta
A little witch on a journey to learn her past
The little witch has come to the castle after all. She barely remembers anything, was she always alone? None of this matter, now. Nobeta understand that she must enter the castle and reach the throne despite the crafted souls and challenges ahead of her. It's the only way to find out the truth and the answer to her past.
「Your body… your vessel, will you give it to me?」
CV: Omaru Polka
Ribbon-loving soul doll
Once a lady of noble born before her decease. Her father - the former hero, was accused as heretic due to questioning The Church's legitimacy. Before long, her family was raided, and the house burnt down. While on the escape, Tania covered her burnt wound with her favorite ribbon, until she fell at the hand of The Church. The Church declared that her family was banished while in fact, they became subject for experiment of The Church's soul essence study.
「Do you… want to play with me?」
CV: Shirakami Fubuki
Doll-hugging Soul Doll
Once a demi-human before her decease. As a demi-human who knew human only by their exquisite crafts, Monica always longed to learn human society and culture until her tribe was destroyed by the human, after The Church deemed them heretic. Though she survived the assault, she became a "merchandise" and endured great cruelty for years before The Church bought her as soul essence material.
「Will I be needed again if I become doll?」
CV: Shirogane Noel
Soul Doll of The Throne
A human hero before her decease. Vanessa was orphaned at a very young age when her parents were slaughtered by de-human. For her who had nothing left to lose, Vanessa zealously sought her purpose in others, thus she became a hero of The Church after passing the "trial".
During her hay day, she was a glorious hero who led a legion that defeated countless demi-human. When The Church replaced heroes with more powerful crafted soul doll, Vanessa once again lost her "purpose" and was never reported to be seen after since…


Wir haben das Produkt "Space Hulk (PC) [English Version] Steam Gift" derzeit leider nicht mehr auf Lager, weshalb es nicht bestellt werden kann. Schau am besten später noch einmal vorbei.
Sie erwerben hiermit die Vollversion des Spieles "Space Hulk – [English Version]"(STEAM digital Download)! Der Versand erfolgt ausschließlich per Email.
The legendary Space Hulk returns to Windows PC and Mac in this epic turn based strategy game. Set in the Warhammer 40,000 universe, an intriguing story of legendary battles and heroic actions unfolds. Play as a small squad of fearless Space Marine Terminators who attempt to reclaim their honor by mounting an assault on a derelict space hulk infested by hordes of vicious tyranid Genestealers.
Take control of the Adeptus Astartes of the Blood Angel chapter and guide them towards glory, while battling fierce Xenos and uncovering ancient relics in the infested confines of the massive Space Hulk named "Sin of Damnation".
The first Space Hulk computer game in 17 years! Available on multiple platforms.
Set in the hugely popular Warhammer 40,000 universe! Official license of the legendary boardgame from Games Workshop.
Turn-based tactical strategy game! Based on the popular and iconic board game mechanics.
Fearsome Genestealers with challenging AI! Meet unforgiving hordes of Genestealers!
Thematic 3D environment! Experience the dark labyrinth of a Space Hulk as never before..
Single player campaign based on the "Sin of Damnation" space hulk! Take on the Sin of Damnation campaign, which includes 3 brand new prequel missions and the 12 missions from the classic board game.
Multiplayer head-to-head recreating the board game experience against a friend! Get in the hot seat and battle it out with a friend.
Cross platform multiplayer between Windows PC, Mac and iOS! Play asynchronous against friends and foes on multiple platforms.


text:
The New Movement to Transform American Prosecution and End Mass Incarceration
NEW YORK TIMES BESTSELLER * A renowned journalist and legal commentator exposes the unchecked power of the prosecutor as a driving force in America's mass incarceration crisis--and charts a way out.
"An important, thoughtful, and thorough examination of criminal justice in America that speaks directly to how we reduce mass incarceration."--Bryan Stevenson, author of Just Mercy
"This harrowing, often enraging book is a hopeful one, as well, profiling innovative new approaches and the frontline advocates who champion them."--Matthew Desmond, author of Evicted
The American criminal justice system is supposed to be a contest between two equal adversaries, the prosecution and the defense, with judges ensuring a fair fight. That image of the law does not match the reality in the courtroom, however. Much of the time, it is prosecutors more than judges who control the outcome of a case, from choosing the charge to setting bail to determining the plea bargain. They often decide who goes free and who goes to prison, even who lives and who dies. In Charged, Emily Bazelon reveals how this kind of unchecked power is the underreported cause of enormous injustice--and the missing piece in the mass incarceration puzzle.
Charged follows the story of two young people caught up in the criminal justice system: Kevin, a twenty-year-old in Brooklyn who picked up his friend's gun as the cops burst in and was charged with a serious violent felony, and Noura, a teenage girl in Memphis indicted for the murder of her mother. Bazelon tracks both cases--from arrest and charging to trial and sentencing--and, with her trademark blend of deeply reported narrative, legal analysis, and investigative journalism, illustrates just how criminal prosecutions can go wrong and, more important, why they don't have to.
Bazelon also details the second chances they prosecutors can extend, if they choose, to Kevin and Noura and so many others. She follows a wave of reform-minded D.A.s who have been elected in some of our biggest cities, as well as in rural areas in every region of the country, put in office to do nothing less than reinvent how their job is done. If they succeed, they can point the country toward a different and profoundly better future.
"Bazelon, cogent and clear-eyed as ever, lays out a welcome double-barreled argument: A prosecutorial shift toward mercy and fairness is crucial to healing our busted criminal justice system, and it's already happening."--Sarah Koenig, host of Serial
Publisher: New York : Random House, [2019]
Branch Call Number: 345.7305 BAZELON
Characteristics: xxxi, 409 pages : illustrations ; 25 cm
Read more reviews of Charged at iDreamBooks.com
Prosecution — United States — Decision Making.
Prosecutorial Misconduct — United States.
Public Prosecutors — United States.
Sentences (Criminal Procedure) — United States.
Imprisonment — United States.
Criminal Justice, Administration of — Corrupt Practices — United States.


text:
Justia Regulation Tracker Department Of Transportation Federal Aviation Administration Amendment of Class E Airspace; Dayton, TN, Establishment of Class E Airspace; Cleveland, TN, and Revocation of Class E Airspace; Bradley Memorial Hospital, Cleveland, TN, 52424-52425 [2013-20499]
Amendment of Class E Airspace; Dayton, TN, Establishment of Class E Airspace; Cleveland, TN, and Revocation of Class E Airspace; Bradley Memorial Hospital, Cleveland, TN, 52424-52425 [2013-20499]
Download as PDF 52424 Federal Register / Vol. 78, No. 164 / Friday, August 23, 2013 / Rules and Regulations DEPARTMENT OF TRANSPORTATION Federal Aviation Administration 14 CFR Part 71 [Docket No. FAA–2013–0073; Airspace Docket No. 13–ASO–2] Amendment of Class E Airspace; Dayton, TN, Establishment of Class E Airspace; Cleveland, TN, and Revocation of Class E Airspace; Bradley Memorial Hospital, Cleveland, TN Federal Aviation Administration (FAA), DOT. ACTION: Final rule. AGENCY: This action amends Class E Airspace at Dayton, TN, as the Hardwick Non-Directional Beacon (NDB) has been decommissioned and new Standard Instrument Approach Procedures (SIAPs) have been developed at Mark Anton Airport. Also, Hardwick Field Airport has closed; therefore, the controlled airspace area is removed. This action also establishes Class E Airspace at Cleveland Regional Jetport, Cleveland, TN, to accommodate area navigation (RNAV) global positioning system (GPS) SIAPs at the airport. Information regarding Bradley Memorial Hospital is added to the Cleveland, TN, airspace description and removed from both the Dayton, TN, regulatory text as well as its listing as Bradley Memorial Hospital, Cleveland, TN, to correct an erroneous reference. DATES: Effective 0901 UTC, October 17, 2013. The Director of the Federal Register approves this incorporation by reference action under title 1, Code of Federal Regulations, part 51, subject to the annual revision of FAA Order 7400.9 and publication of conforming amendments. SUMMARY: John Fornito, Operations Support Group, Eastern Service Center, Federal Aviation Administration, P.O. Box 20636, Atlanta, Georgia 30320; telephone (404) 305–6364. SUPPLEMENTARY INFORMATION: FOR FURTHER INFORMATION CONTACT: emcdonald on DSK67QTVN1PROD with RULES History On May 1, 2013, the FAA published in the Federal Register a notice of proposed rulemaking (NPRM) to amend Class E airspace at Mark Anton Airport, Dayton, TN, establish Class E airspace at Cleveland Regional Jetport, Cleveland, TN, and remove designation of Class E airspace at Bradley Memorial Hospital, Cleveland, TN, (78 FR 25403). Interested parties were invited to participate in this rulemaking effort by submitting VerDate Mar<15>2010 16:22 Aug 22, 2013 Jkt 229001 written comments on the proposal to the FAA. No comments were received. Class E airspace designations are published in paragraph 6005 of FAA Order 7400.9W dated August 8, 2012, and effective September 15, 2012, which is incorporated by reference in 14 CFR 71.1. The Class E airspace designations listed in this document will be published subsequently in the Order. The Rule This amendment to Title 14, Code of Federal Regulations (14 CFR) part 71 amends Class E airspace extending upward from 700 feet above the surface within a 9.8-mile radius of Mark Anton Airport, Dayton, TN, to accommodate new standard instrument approach procedures due to the decommissioning of the Hardwick NDB and cancellation of the NDB approach. Additionally, this action establishes Class E airspace 700 feet above the surface within a 7.4 mile radius at Cleveland Regional Jetport, with a segment extending from the 7.4mile radius to 12-miles southwest of the Jetport, to accommodate RNAV (GPS) standard instrument approach procedures for instrument flight rules (IFR) operations. Also, Hardwick Field Airport has closed, and controlled airspace removed. Information regarding Bradley Memorial Hospital is added to the Cleveland, TN, airspace description and removed from the Dayton, TN, regulatory text as well as its listing as Bradley Memorial Hospital, Cleveland, TN, to correct an erroneous reference. This action enhances the safety and airspace management of IFR operations in the Dayton, TN, and Cleveland, TN, airspace areas. The FAA has determined that this regulation only involves an established body of technical regulations for which frequent and routine amendments are necessary to keep them operationally current, is non-controversial and unlikely to result in adverse or negative comments. It, therefore, (1) Is not a ''significant regulatory action'' under Executive Order 12866; (2) is not a ''significant rule'' under DOT Regulatory Policies and Procedures (44 FR 11034; February 26, 1979); and (3) does not warrant preparation of a Regulatory Evaluation as the anticipated impact is so minimal. Since this is a routine matter that only affects air traffic procedures and air navigation, it is certified that this rule, when promulgated, does not have a significant economic impact on a substantial number of small entities under the criteria of the Regulatory Flexibility Act. The FAA's authority to issue rules regarding aviation safety is found in Title 49 of the United States Code. PO 00000 Frm 00036 Fmt 4700 Sfmt 4700 Subtitle I, Section 106 describes the authority of the FAA Administrator. Subtitle VII, Aviation Programs, describes in more detail the scope of the agency's authority. This rulemaking is promulgated under the authority described in Subtitle VII, Part A, Subpart I, Section 40103. Under that section, the FAA is charged with prescribing regulations to assign the use of airspace necessary to ensure the safety of aircraft and the efficient use of airspace. This regulation is within the scope of that authority as it amends controlled airspace in the Dayton, and Cleveland, TN, airspace areas. Environmental Review The FAA has determined that this action qualifies for categorical exclusion under the National Environmental Policy Act in accordance with FAA Order 1050.1E, ''Environmental Impacts: Policies and Procedures,'' paragraph 311a. This airspace action is not expected to cause any potentially significant environmental impacts, and no extraordinary circumstances exist that warrant preparation of an environmental assessment. Lists of Subjects in 14 CFR Part 71 Airspace, Incorporation by reference, Navigation (Air). Adoption of the Amendment In consideration of the foregoing, the Federal Aviation Administration amends 14 CFR Part 71 as follows: PART 71—DESIGNATION OF CLASS A, B, C, D, AND E AIRSPACE AREAS; AIR TRAFFIC SERVICE ROUTES; AND REPORTING POINTS 1. The authority citation for Part 71 continues to read as follows: ■ Authority: 49 U.S.C. 106(g); 40103, 40113, 40120; E.O. 10854, 24 FR 9565, 3 CFR, 1959– 1963 Comp., p. 389. § 71.1 [Amended] 2. The incorporation by reference in 14 CFR 71.1 of Federal Aviation Administration Order 7400.9W, Airspace Designations and Reporting Points, dated August 8, 2012, effective September 15, 2012, is amended as follows: ■ Paragraph 6005 Class E Airspace Areas Extending Upward from 700 feet or More Above the Surface of the Earth. * * * * * ASO TN E5 Dayton, TN [Amended] Mark Anton Airport, TN (Lat. 35°29′10″ N., long. 84°55′52″ W.) Bledsoe County Hospital, Pikeville, TN, Point in Space Coordinates (Lat. 35°37′34″ N., long. 85°10′38″ W.) E:\FR\FM\23AUR1.SGM 23AUR1 Federal Register / Vol. 78, No. 164 / Friday, August 23, 2013 / Rules and Regulations That airspace extending upward from 700 feet above the surface within a 9.8-mile radius of the Mark Anton Airport, and that airspace within a 6-mile radius of the Point in Space Coordinates (lat. 35°37′34″ N., long 85°10′38″ W.) serving Bledsoe County Hospital, Pikeville, TN. * * * * * ASO TN E5 Cleveland, TN [New] Cleveland Regional Jetport, TN (Lat. 35°12′41″ N., long. 84°47′59″ W.) Bradley Memorial Hospital, TN, Point in Space Coordinates (Lat. 35°10′52″ N., long. 84°52′56″ W.) That airspace extending upward from 700 feet above the surface within a 7.4-mile radius of Cleveland Regional Jetport, and within 2-miles each side of the 209° bearing from the airport, extending from the 7.4-mile radius to 12-miles southwest of the airport, and within a 6-mile radius of the Point in Space Coordinates (lat. 35°10′52″ N., long.84°52′56″ W.) serving Bradley Memorial Hospital. * * * * * ASO TN E5 Bradley Memorial Hospital, Cleveland, TN [ Removed] Issued in College Park, Georgia, on August 16, 2013. Kip B. Johns, Manager, Operations Support Group, Eastern Service Center, Air Traffic Organization. [FR Doc. 2013–20499 Filed 8–22–13; 8:45 am] BILLING CODE 4910–13–P DEPARTMENT OF TRANSPORTATION Federal Aviation Administration 14 CFR Part 71 [Docket No. FAA–2013–0002; Airspace Docket No. 12–ASO–46] Establishment of Class E Airspace; Umatilla, FL Federal Aviation Administration (FAA), DOT. ACTION: Final rule. AGENCY: This action establishes Class E Airspace at Umatilla, FL, to accommodate the Area Navigation (RNAV) Global Positioning System (GPS) Standard Instrument Approach Procedures at Umatilla Municipal Airport. This action enhances the safety and airspace management of Instrument Flight Rules (IFR) operations within the National Airspace System. DATES: Effective 0901 UTC, December 12, 2013. The Director of the Federal Register approves this incorporation by reference action under title 1, Code of Federal Regulations, part 51, subject to the annual revision of FAA Order 7400.9 and publication of conforming amendments. emcdonald on DSK67QTVN1PROD with RULES SUMMARY: VerDate Mar<15>2010 16:22 Aug 22, 2013 Jkt 229001 John Fornito, Operations Support Group, Eastern Service Center, Federal Aviation Administration, P.O. Box 20636, Atlanta, Georgia 30320; telephone (404) 305–6364. SUPPLEMENTARY INFORMATION: FOR FURTHER INFORMATION CONTACT: History On June 4, 2013, the FAA published in the Federal Register a notice of proposed rulemaking (NPRM) to establish Class E airspace at Umatilla, FL (78 FR 33265) Docket No. FAA– 2013–0002. Interested parties were invited to participate in this rulemaking effort by submitting written comments on the proposal to the FAA. No comments were received. Class E airspace designations are published in paragraph 6005 of FAA Order 7400.9W dated August 8, 2012, and effective September 15, 2012, which is incorporated by reference in 14 CFR 71.1. The Class E airspace designations listed in this document will be published subsequently in the Order. The Rule This amendment to Title 14, Code of Federal Regulations (14 CFR) part 71 establishes Class E airspace extending upward from 700 feet above the surface within a 6.7-mile radius of the airport at Umatilla, FL, providing the controlled airspace required to accommodate the new RNAV (GPS) Standard Instrument Approach Procedures developed for Umatilla Municipal Airport. This action is necessary for the safety and management of IFR operations at the airport. The FAA has determined that this regulation only involves an established body of technical regulations for which frequent and routine amendments are necessary to keep them operationally current, is non-controversial and unlikely to result in adverse or negative comments. It, therefore, (1) Is not a ''significant regulatory action'' under Executive Order 12866; (2) is not a ''significant rule'' under DOT Regulatory Policies and Procedures (44 FR 11034; February 26, 1979); and (3) does not warrant preparation of a Regulatory Evaluation as the anticipated impact is so minimal. Since this is a routine matter that only affects air traffic procedures and air navigation, it is certified that this rule, when promulgated, does not have a significant economic impact on a substantial number of small entities under the criteria of the Regulatory Flexibility Act. The FAA's authority to issue rules regarding aviation safety is found in Title 49 of the United States Code. Subtitle I, Section 106 describes the PO 00000 Frm 00037 Fmt 4700 Sfmt 4700 52425 authority of the FAA Administrator. Subtitle VII, Aviation Programs, describes in more detail the scope of the agency's authority. This rulemaking is promulgated under the authority described in Subtitle VII, Part A, Subpart I, Section 40103. Under that section, the FAA is charged with prescribing regulations to assign the use of airspace necessary to ensure the safety of aircraft and the efficient use of airspace. This regulation is within the scope of that authority as it establishes controlled airspace at Umatilla Municipal Airport, Umatilla, FL. Environmental Review The FAA has determined that this action qualifies for categorical exclusion under the National Environmental Policy Act in accordance with FAA Order 1050.1E, ''Environmental Impacts: Policies and Procedures,'' paragraph 311a. This airspace action is not expected to cause any potentially significant environmental impacts, and no extraordinary circumstances exist that warrant preparation of an environmental assessment. Lists of Subjects in 14 CFR Part 71 Airspace, Incorporation by reference, Navigation (Air). Adoption of the Amendment In consideration of the foregoing, the Federal Aviation Administration amends 14 CFR Part 71 as follows: PART 71—DESIGNATION OF CLASS A, B, C, D AND E AIRSPACE AREAS; AIR TRAFFIC SERVICE ROUTES; AND REPORTING POINTS 1. The authority citation for Part 71 continues to read as follows: ■ Authority: 49 U.S.C. 106(g); 40103, 40113, 40120; E.O. 10854, 24 FR 9565, 3 CFR, 1959– 1963 Comp., p. 389. § 71.1 [Amended] 2. The incorporation by reference in 14 CFR 71.1 of Federal Aviation Administration Order 7400.9W, Airspace Designations and Reporting Points, dated August 8, 2012, effective September 15, 2012, is amended as follows: ■ Paragraph 6005 Class E Airspace Areas Extending Upward from 700 feet or More Above the Surface of the Earth * * * * * ASO FL E5 Umatilla, FL [New] Umatilla Municipal Airport, FL (Lat. 28°55′27″ N., long. 82°39′07″ W.) That airspace extending upward from 700 feet above the surface within a 6.7-mile radius of Umatilla Municipal Airport. E:\FR\FM\23AUR1.SGM 23AUR1
[Federal Register Volume 78, Number 164 (Friday, August 23, 2013)]
[Rules and Regulations]
14 CFR Part 71
[Docket No. FAA-2013-0073; Airspace Docket No. 13-ASO-2]
Amendment of Class E Airspace; Dayton, TN, Establishment of Class
E Airspace; Cleveland, TN, and Revocation of Class E Airspace; Bradley
Memorial Hospital, Cleveland, TN
AGENCY: Federal Aviation Administration (FAA), DOT.
ACTION: Final rule.
SUMMARY: This action amends Class E Airspace at Dayton, TN, as the
Hardwick Non-Directional Beacon (NDB) has been decommissioned and new
Standard Instrument Approach Procedures (SIAPs) have been developed at
Mark Anton Airport. Also, Hardwick Field Airport has closed; therefore,
the controlled airspace area is removed. This action also establishes
Class E Airspace at Cleveland Regional Jetport, Cleveland, TN, to
accommodate area navigation (RNAV) global positioning system (GPS)
SIAPs at the airport. Information regarding Bradley Memorial Hospital
is added to the Cleveland, TN, airspace description and removed from
both the Dayton, TN, regulatory text as well as its listing as Bradley
Memorial Hospital, Cleveland, TN, to correct an erroneous reference.
DATES: Effective 0901 UTC, October 17, 2013. The Director of the
Federal Register approves this incorporation by reference action under
title 1, Code of Federal Regulations, part 51, subject to the annual
revision of FAA Order 7400.9 and publication of conforming amendments.
FOR FURTHER INFORMATION CONTACT: John Fornito, Operations Support
Group, Eastern Service Center, Federal Aviation Administration, P.O.
Box 20636, Atlanta, Georgia 30320; telephone (404) 305-6364.
On May 1, 2013, the FAA published in the Federal Register a notice
of proposed rulemaking (NPRM) to amend Class E airspace at Mark Anton
Airport, Dayton, TN, establish Class E airspace at Cleveland Regional
Jetport, Cleveland, TN, and remove designation of Class E airspace at
Bradley Memorial Hospital, Cleveland, TN, (78 FR 25403). Interested
parties were invited to participate in this rulemaking effort by
submitting written comments on the proposal to the FAA. No comments
were received.
Class E airspace designations are published in paragraph 6005 of
FAA Order 7400.9W dated August 8, 2012, and effective September 15,
2012, which is incorporated by reference in 14 CFR 71.1. The Class E
airspace designations listed in this document will be published
subsequently in the Order.
The Rule
This amendment to Title 14, Code of Federal Regulations (14 CFR)
part 71 amends Class E airspace extending upward from 700 feet above
the surface within a 9.8-mile radius of Mark Anton Airport, Dayton, TN,
to accommodate new standard instrument approach procedures due to the
decommissioning of the Hardwick NDB and cancellation of the NDB
approach. Additionally, this action establishes Class E airspace 700
feet above the surface within a 7.4 mile radius at Cleveland Regional
Jetport, with a segment extending from the 7.4-mile radius to 12-miles
southwest of the Jetport, to accommodate RNAV (GPS) standard instrument
approach procedures for instrument flight rules (IFR) operations. Also,
Hardwick Field Airport has closed, and controlled airspace removed.
Information regarding Bradley Memorial Hospital is added to the
Cleveland, TN, airspace description and removed from the Dayton, TN,
regulatory text as well as its listing as Bradley Memorial Hospital,
Cleveland, TN, to correct an erroneous reference. This action enhances
the safety and airspace management of IFR operations in the Dayton, TN,
and Cleveland, TN, airspace areas.
The FAA has determined that this regulation only involves an
established body of technical regulations for which frequent and
routine amendments are necessary to keep them operationally current, is
non-controversial and unlikely to result in adverse or negative
comments. It, therefore, (1) Is not a ``significant regulatory action''
under Executive Order 12866; (2) is not a ``significant rule'' under
DOT Regulatory Policies and Procedures (44 FR 11034; February 26,
1979); and (3) does not warrant preparation of a Regulatory Evaluation
as the anticipated impact is so minimal. Since this is a routine matter
that only affects air traffic procedures and air navigation, it is
certified that this rule, when promulgated, does not have a significant
economic impact on a substantial number of small entities under the
criteria of the Regulatory Flexibility Act.
The FAA's authority to issue rules regarding aviation safety is
found in Title 49 of the United States Code. Subtitle I, Section 106
describes the authority of the FAA Administrator. Subtitle VII,
Aviation Programs, describes in more detail the scope of the agency's
authority. This rulemaking is promulgated under the authority described
in Subtitle VII, Part A, Subpart I, Section 40103. Under that section,
the FAA is charged with prescribing regulations to assign the use of
airspace necessary to ensure the safety of aircraft and the efficient
use of airspace. This regulation is within the scope of that authority
as it amends controlled airspace in the Dayton, and Cleveland, TN,
airspace areas.
The FAA has determined that this action qualifies for categorical
exclusion under the National Environmental Policy Act in accordance
with FAA Order 1050.1E, ``Environmental Impacts: Policies and
Procedures,'' paragraph 311a. This airspace action is not expected to
cause any potentially significant environmental impacts, and no
extraordinary circumstances exist that warrant preparation of an
environmental assessment.
Lists of Subjects in 14 CFR Part 71
Airspace, Incorporation by reference, Navigation (Air).
Adoption of the Amendment
In consideration of the foregoing, the Federal Aviation
Administration amends 14 CFR Part 71 as follows:
PART 71--DESIGNATION OF CLASS A, B, C, D, AND E AIRSPACE AREAS; AIR
TRAFFIC SERVICE ROUTES; AND REPORTING POINTS
1. The authority citation for Part 71 continues to read as follows:
Authority:  49 U.S.C. 106(g); 40103, 40113, 40120; E.O. 10854,
24 FR 9565, 3 CFR, 1959-1963 Comp., p. 389.
Sec.  71.1  [Amended]
2. The incorporation by reference in 14 CFR 71.1 of Federal Aviation
Administration Order 7400.9W, Airspace Designations and Reporting
Points, dated August 8, 2012, effective September 15, 2012, is amended
Paragraph 6005 Class E Airspace Areas Extending Upward from 700
feet or More Above the Surface of the Earth.
ASO TN E5 Dayton, TN [Amended]
Mark Anton Airport, TN
(Lat. 35[deg]29'10'' N., long. 84[deg]55'52'' W.)
Bledsoe County Hospital, Pikeville, TN, Point in Space Coordinates
That airspace extending upward from 700 feet above the surface
within a 9.8-mile radius of the Mark Anton Airport, and that
airspace within a 6-mile radius of the Point in Space Coordinates
(lat. 35[deg]37'34'' N., long 85[deg]10'38'' W.) serving Bledsoe
County Hospital, Pikeville, TN.
ASO TN E5 Cleveland, TN [New]
Cleveland Regional Jetport, TN
Bradley Memorial Hospital, TN, Point in Space Coordinates
within a 7.4-mile radius of Cleveland Regional Jetport, and within
2-miles each side of the 209[deg] bearing from the airport,
extending from the 7.4-mile radius to 12-miles southwest of the
airport, and within a 6-mile radius of the Point in Space
Coordinates (lat. 35[deg]10'52'' N., long.84[deg]52'56'' W.) serving
Bradley Memorial Hospital.
ASO TN E5 Bradley Memorial Hospital, Cleveland, TN [ Removed]
Issued in College Park, Georgia, on August 16, 2013.
Kip B. Johns,
Manager, Operations Support Group, Eastern Service Center, Air Traffic
Organization.


text:
The Crucifixion and the Shroud's Global Directory
Welcome to our Global Directory! Here you can find listings of Speakers, Museums, Organizations, and Centers from all over the world that work or speak on topics relating to the Crucifixion and the Shroud. Please feel free to browse through the listings.
If you would like to add a listing, please create an account below, once your listing is approved, it will go live! There is no cost to be part of this listing.
Chris Knabenshue
speaker@crucifixionshroud.com
http://crucifixionshroud.com
18034 Ventura Blvd. #484, Encino, CA, United States
Chris as been doing research on the Shroud of Turin since his first year in Catholic seminary studies in 2000. In 2001, Chris put together a small presentation on the forensics of the crucifixion and the Shroud of Turin for a seventh and eighth grade class at his home parish in South Bend, Indiana. Seeing that the topic was of great interest, he expanded this presentation and began offering it to different parishes, organizations, and other groups. He has currently traveled to six different states presenting on the Shroud of Turin. He was also asked by Dr. Gilbert Lavoie, a good friend and the catalyst for his interest in the Shroud, to deliver the talk of Fr. Walter Abbott at the 2001 Dallas International Conference of the Shroud of Turin. Through this humbling experience, Chris has made many connections with the researchers and scientists directly involved in Shroud research. He is currently the president of the Shroud of Turin Society of Northern Indiana which commits itself to educating the public on the Shroud of Turin as a means of a tool of evangelization. Using his background in Theology and Philosophy, he has written a chapter in Dr. Bart Saucelo's Revised Second Edition of Resurrection Documented: A Window to the Supernatural, which discusses the Shroud within the context of the miracle of the Resurrection. In the summer of 2005 he launched The Crucifixion and the Shroud website (www.crucifixionshroud.com) in an attempt to bring the science, the history, and the meaning of both the Crucifixion of Jesus and the Shroud of Turin in a powerful and visual way to the level of the lay person.
Scope & Content of Presentation:
Chris's main presentation "The Crucifixion and the Shroud" is a dramatic presentation on the forensics of the Crucifixion and the much disputed Shroud of Turin using all five senses of the body. The first section of the presentation draws on Chris's past experience in acting and dramatically takes the participant through the process of crucifixion. It utilizes many pictures, props, and replicas of First Century crucifixion instruments as well as something to taste and smell. The second part of the presentation is on the Shroud of Turin. This is mostly an overview of the science and history of the Shroud, brought down to the level of the lay person. This section also uses several images to illustrate what is being said. In between the Crucifixion and the Shroud sections, a brief meditation slide show is presented to highlight the spiritual nature of the subject. Before and after the presentation, questions are welcomed, and visitors are allowed to browse and view the hands-on exhibit. Which features, above other things, plants from Israel that are believed to have been used for the crown of thorns, and an actual relic (piece of) the Shroud. Both of these items were generously donated to the exhibit. The presentation itself lasts one hour. More information on this presentation, including pictures of the exhibit, can be found at www.crucifixionshroud.com.
All of the equipment for this presentation is already owned, although, depending on location of the presentation, it is very helpful that the host have: a large screen, LCD Projector, and Sound equipment. Long tables for the exhibit are needed for any presentation.
Area of Country available for speaking:
Chris will travel anywhere, given adequate time for planning and scheduling. Depending on the location of the presentation, the exhibit might have to be limited due to traveling limitations.
Honorarium:
No fee is ever required. Where there is burdensome travel or lodging, those needs are expected to be met. Gift donations are accepted to help alleviate year-round expenses and improvements.


text:
Tamás Waliczky (* 1959 in Budapest) ist ein ungarischer Medienkünstler und Hochschullehrer.

Leben
Tamás Waliczky brachte sich Malen und Zeichnen autodidaktisch bei. Ab 1980 wurde er als Zeichentrick-Animator und Grafiker in Ungarn tätig, ebenso entdeckte er die Computer-Animation als künstlerisches Medium. 1989 wurde er für die Computergrafik Gramophone mit dem Prix Ars Electronica ausgezeichnet. 1993 bis 1997 war er Artist-in-Residence beim ZKM Karlsruhe, danach war er Gast-Professor an der HBK Saar. 2003 bis 2005 war er Professor für Computeranimation an der Hochschule Mainz, danach ordentlicher Professor an der HBK Saar für neue digitale Medien bis 2010. Ab da wurde er bis 2020 als Professor an der School of Creative Media in Hongkong tätig.

Weblinks
 Website

Einzelnachweise

Medienkünstler (Ungarn)
Hochschullehrer (HBK Saar, Saarbrücken)
Hochschullehrer (FH Mainz)
Ungar
Geboren 1959
Mann