public function create()
{
$q = "INSERT INTO item_info_type (";
$q .= "item_info_type_name";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->ItemInfoTypeName) . "')";
$this->Id = parent::insertQuery($q);
}
public function create()
{
$q = "INSERT INTO setting (";
$q .= "setting_name, ";
$q .= "setting_value";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->SettingName) . "', ";
$q .= "'" . addslashes($this->SettingValue) . "')";
$this->Id = parent::insertQuery($q);
}
public function create()
{
$q = "INSERT INTO technology_info (";
$q .= "technology_id, ";
$q .= "technology_info_name, ";
$q .= "technology_info_description, ";
$q .= "technology_info_button_image_url, ";
$q .= "technology_info_template, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->TechnologyId) . "', ";
$q .= "'" . addslashes($this->TechnologyInfoName) . "', ";
$q .= "'" . addslashes($this->TechnologyInfoDescription) . "', ";
$q .= "'" . addslashes($this->TechnologyInfoButtonImageUrl) . "', ";
$q .= "'" . addslashes($this->TechnologyInfoTemplate) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->TechnologyId);
}
public function create()
{
$q = "INSERT INTO sound (";
$q .= "category_id, ";
$q .= "overview_text";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->CategoryId) . "', ";
$q .= "'" . addslashes($this->OverviewText) . "')";
$this->Id = parent::insertQuery($q);
}
public function create()
{
$q = "INSERT INTO item_video (";
$q .= "item_id, ";
$q .= "item_video_title, ";
$q .= "item_video_url, ";
$q .= "item_video_placeholder_image_url, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->ItemId) . "', ";
$q .= "'" . addslashes($this->ItemVideoTitle) . "', ";
$q .= "'" . addslashes($this->ItemVideoUrl) . "', ";
$q .= "'" . addslashes($this->ItemVideoPlaceholderImageUrl) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->ItemId);
}
public function create()
{
$q = "INSERT INTO item_presentation_image (";
$q .= "item_presentation_id, ";
$q .= "item_presentation_image_url, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->ItemPresentationId) . "', ";
$q .= "'" . addslashes($this->ItemPresentationImageUrl) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->ItemPresentationId);
}
public function create()
{
$q = "INSERT INTO light_test (";
$q .= "light_id, ";
$q .= "dark_text, ";
$q .= "light_text, ";
$q .= "image_file_dark, ";
$q .= "image_file_light, ";
$q .= "background_image_file, ";
$q .= "rgba_value, ";
$q .= "rgba_value_right, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->LightId) . "', ";
$q .= "'" . addslashes($this->DarkText) . "', ";
$q .= "'" . addslashes($this->LightText) . "', ";
$q .= "'" . addslashes($this->ImageFileDark) . "', ";
$q .= "'" . addslashes($this->ImageFileLight) . "', ";
$q .= "'" . addslashes($this->BackgroundImageFile) . "', ";
$q .= "'" . addslashes($this->RgbaValue) . "', ";
$q .= "'" . addslashes($this->RgbaValueRight) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->LightId);
}
public function create()
{
$q = "INSERT INTO technology (";
$q .= "category_id, ";
$q .= "technology_name, ";
$q .= "technology_button_image_url, ";
$q .= "technology_button_active_image_url, ";
$q .= "link_url, ";
$q .= "technology_headline, ";
$q .= "is_active, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->CategoryId) . "', ";
$q .= "'" . addslashes($this->TechnologyName) . "', ";
$q .= "'" . addslashes($this->TechnologyButtonImageUrl) . "', ";
$q .= "'" . addslashes($this->TechnologyButtonActiveImageUrl) . "', ";
$q .= "'" . addslashes($this->LinkUrl) . "', ";
$q .= "'" . addslashes($this->TechnologyHeadline) . "', ";
$q .= "'" . addslashes($this->IsActive) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder();
}
public function create()
{
$q = "INSERT INTO sound_image (";
$q .= "sound_id, ";
$q .= "image_file, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->SoundId) . "', ";
$q .= "'" . addslashes($this->ImageFile) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->SoundId);
}
public function create()
{
$q = "INSERT INTO item_presentation (";
$q .= "item_id, ";
$q .= "item_presentation_name, ";
$q .= "item_presentation_thumbnail_url";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->ItemId) . "', ";
$q .= "'" . addslashes($this->ItemPresentationName) . "', ";
$q .= "'" . addslashes($this->ItemPresentationThumbnailUrl) . "')";
$this->Id = parent::insertQuery($q);
}
public function create()
{
$q = "INSERT INTO item (";
$q .= "category_id, ";
$q .= "item_name, ";
$q .= "background_color, ";
$q .= "contact_email, ";
$q .= "gallery_description, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->CategoryId) . "', ";
$q .= "'" . addslashes($this->ItemName) . "', ";
$q .= "'" . addslashes($this->BackgroundColor) . "', ";
$q .= "'" . addslashes($this->ContactEmail) . "', ";
$q .= "'" . addslashes($this->GalleryDescription) . "', ";
$q .= "'9990')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->CategoryId);
}
public function create()
{
$q = "INSERT INTO technology_info_image (";
$q .= "technology_info_id, ";
$q .= "technology_info_image_url, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->TechnologyInfoId) . "', ";
$q .= "'" . addslashes($this->TechnologyInfoImageUrl) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
}
public function create()
{
$q = "INSERT INTO item_image_highlight (";
$q .= "item_image_id, ";
$q .= "hotspot_left, ";
$q .= "hotspot_top, ";
$q .= "item_image_highlight_info";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->ItemImageId) . "', ";
$q .= "'" . addslashes($this->HotspotLeft) . "', ";
$q .= "'" . addslashes($this->HotspotTop) . "', ";
$q .= "'" . addslashes($this->ItemImageHighlightInfo) . "')";
$this->Id = parent::insertQuery($q);
}
public function create()
{
$q = "INSERT INTO sound_test (";
$q .= "sound_id, ";
$q .= "sound_test_description, ";
$q .= "sound_url1, ";
$q .= "sound_url2, ";
$q .= "sound_url3, ";
$q .= "image_url1, ";
$q .= "image_url2, ";
$q .= "image_url3, ";
$q .= "text1, ";
$q .= "text2, ";
$q .= "text3, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->SoundId) . "', ";
$q .= "'" . addslashes($this->SoundTestDescription) . "', ";
$q .= "'" . addslashes($this->SoundUrl1) . "', ";
$q .= "'" . addslashes($this->SoundUrl2) . "', ";
$q .= "'" . addslashes($this->SoundUrl3) . "', ";
$q .= "'" . addslashes($this->ImageUrl1) . "', ";
$q .= "'" . addslashes($this->ImageUrl2) . "', ";
$q .= "'" . addslashes($this->ImageUrl3) . "', ";
$q .= "'" . addslashes($this->Text1) . "', ";
$q .= "'" . addslashes($this->Text2) . "', ";
$q .= "'" . addslashes($this->Text3) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder($this->SoundId);
}
public function create()
{
$q = "INSERT INTO category (";
$q .= "category_name, ";
$q .= "title_heading, ";
$q .= "subtitle_heading, ";
$q .= "background_color, ";
$q .= "category_description, ";
$q .= "category_image_url, ";
$q .= "contact_email, ";
$q .= "link_url, ";
$q .= "is_active, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->CategoryName) . "', ";
$q .= "'" . addslashes($this->TitleHeading) . "', ";
$q .= "'" . addslashes($this->SubtitleHeading) . "', ";
$q .= "'" . addslashes($this->BackgroundColor) . "', ";
$q .= "'" . addslashes($this->CategoryDescription) . "', ";
$q .= "'" . addslashes($this->CategoryImageUrl) . "', ";
$q .= "'" . addslashes($this->ContactEmail) . "', ";
$q .= "'" . addslashes($this->LinkUrl) . "', ";
$q .= "'" . addslashes($this->IsActive) . "', ";
$q .= "'9990')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder();
}
public function create()
{
$q = "INSERT INTO patent (";
$q .= "category_id, ";
$q .= "patent_name, ";
$q .= "patent_image_url, ";
$q .= "patent_abstract, ";
$q .= "patent_probable_assignee, ";
$q .= "patent_assignees_std, ";
$q .= "patent_assignees, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->CategoryId) . "', ";
$q .= "'" . addslashes($this->PatentName) . "', ";
$q .= "'" . addslashes($this->PatentImageUrl) . "', ";
$q .= "'" . addslashes($this->PatentAbstract) . "', ";
$q .= "'" . addslashes($this->PatentProbableAssignee) . "', ";
$q .= "'" . addslashes($this->PatentAssigneesStd) . "', ";
$q .= "'" . addslashes($this->PatentAssignees) . "', ";
$q .= "'" . addslashes($this->SortOrder) . "')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder();
}
public function create()
{
$q = "INSERT INTO homepage_image (";
$q .= "homepage_image_url, ";
$q .= "is_active, ";
$q .= "sort_order";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->HomepageImageUrl) . "', ";
$q .= "'" . addslashes($this->IsActive) . "', ";
$q .= "'9990')";
$this->Id = parent::insertQuery($q);
$this->resetSortOrder();
}
public function create()
{
$q = "INSERT INTO system_user (";
$q .= "first_name, ";
$q .= "last_name, ";
$q .= "username, ";
$q .= "password, ";
$q .= "email_address, ";
$q .= "date_created, ";
$q .= "is_active, ";
$q .= "is_admin";
$q .= ") VALUES (";
$q .= "'" . addslashes($this->FirstName) . "', ";
$q .= "'" . addslashes($this->LastName) . "', ";
$q .= "'" . addslashes($this->Username) . "', ";
$q .= "'" . addslashes($this->Password) . "', ";
$q .= "'" . addslashes($this->EmailAddress) . "', ";
$q .= "'" . addslashes($this->DateCreated) . "', ";
$q .= "'" . addslashes($this->IsActive) . "', ";
$q .= "'" . addslashes($this->IsAdmin) . "')";
$this->Id = parent::insertQuery($q);
}
