function SetFullProfile($Name, $Id_NTO)
{
$mysql = new MySQL();
if ($mysql->InsertString($this->NameBase, "NameTypeObject", array("name" => $Name, "Type" => "FP"))) {
$Id_NTOFP = $mysql->GetIdInsert();
if ($mysql->InsertString($this->NameBase, "FullProfile", array("Id_NTO" => $Id_NTO, "Id_NTOFP" => $Id_NTOFP))) {
conprint("SetFullProfile : " . $Name, "1");
return $Id_NTOFP;
} else {
conprint("SetFullProfile: " . $Name, "0");
return false;
}
} else {
conprint("SetFullProfile: " . $Name, "0");
}
}
function SetSVG($val, $Name)
{
$mysql = new MySQL();
$nameFile = "svg/" . date('YmdHis') . rand(100, 1000) . '.svg';
if ($mysql->InsertString($this->NameBase, "Maps", array("name" => $Name, "data" => $nameFile, "Type" => "svg"))) {
file_put_contents($nameFile, $val, FILE_APPEND);
conprint("SetSVG: " . $Name, "1");
return true;
}
}
function SetObjectSmallData($array, $Id_OBJ)
{
$mysql = new MySQL();
foreach ($array["params"] as $key => $value) {
if ($mysql->InsertString($this->NameBase, "SmallProfileData", array("text" => $value["text"], "Id_SP" => $value["id"], "Id_OBJ" => $Id_OBJ))) {
conprint("SetObjectSmallData Id_SP=" . $value["Id_SP"], "1");
} else {
conprint("SetObjectSmallData Id_SP=" . $value["Id_SP"], "0");
return false;
}
}
return true;
}
function SetFullProfileData($table_name, $array)
{
$mysql = new MySQL();
foreach ($array as $key => $value) {
if ($mysql->InsertString($this->NameBase, $table_name, array("name" => $value["name"], "Id_OBJ" => $value["Id_OBJ"], "info" => $value["info"], "fotoURL" => $value["fotoURL"]))) {
conprint("SetFullProfileData С ИМЕНЕМ=" . $value["name"] . " В ТАБЛИЦЕ =" . $table_name, "1");
} else {
conprint("SetFullProfileData С ИМЕНЕМ=" . $value["name"] . " В ТАБЛИЦЕ =" . $table_name, "0");
return false;
}
}
return true;
}
function SetUSER($login, $password)
{
$mysql = new MySQL();
$err = array();
if (!preg_match("/^[a-zA-Z0-9@.]+\$/", $login)) {
$err[] = "Логин может состоять только из букв английского алфавита и цифр";
}
if (strlen($login) < 3 or strlen($login) > 30) {
$err[] = "Логин должен быть не меньше 3-х символов и не больше 30";
}
if ($this->FindLogin($login)) {
$err[] = "Пользователь с таким логином уже существует";
}
if (count($err) == 0) {
$password = md5(md5(trim($password)));
if ($mysql->InsertString($this->NameBase, "User", array("login" => $login, "password" => $password))) {
conprint("SetUSER: "******"1");
if ($mysql->CreateBaseData($login)) {
if ($mysql->CreateTable($login, "FullProfile", "id int(11) auto_increment primary key,Id_NTO int(11),Id_NTOFP int(11)")) {
if ($mysql->CreateTable($login, "Link", "id int(11) auto_increment primary key,Id_OBJ int(11),Id_MAP int(11),Id_MAPOBJ varchar(256)")) {
if ($mysql->CreateTable($login, "Maps", "id int(11) auto_increment primary key,name varchar(256),Type ENUM('svg','googlemaps'),data text")) {
if ($mysql->CreateTable($login, "NameTypeObject", "id int(11) auto_increment primary key,name varchar(256),Type ENUM('GL','FP')")) {
if ($mysql->CreateTable($login, "Objects", "id int(11) auto_increment primary key,name varchar(256),Id_NTO int(11),Id_OBJ int(11)")) {
if ($mysql->CreateTable($login, "SmallProfile", "id int(11) auto_increment primary key,name varchar(256),Id_NTO int(11),Type ENUM('Текст','Изображение')")) {
if ($mysql->CreateTable($login, "SmallProfileData", "id int(11) auto_increment primary key,text varchar(256),Id_SP int(11),Id_OBJ int(11)")) {
if ($mysql->CreateView($login, "FullData", "AS select `NameTypeObject`.`id` AS `id`,`NameTypeObject`.`name` AS `name`,`FullProfile`.`Id_NTO` AS `Id_NTO`,`FullProfile`.`id` AS `Id_FP` from (`NameTypeObject` join `FullProfile`) where (`NameTypeObject`.`id` = `FullProfile`.`Id_NTOFP`)")) {
if ($mysql->CreateView($login, "SmallData", " AS select `SmallProfileData`.`id` AS `id`,`SmallProfileData`.`text` AS `text`,`SmallProfileData`.`Id_SP` AS `Id_SP`,`SmallProfileData`.`Id_OBJ` AS `Id_OBJ`,`SmallProfile`.`name` AS `name`,`SmallProfile`.`Type` AS `Type` from (`SmallProfileData` join `SmallProfile`) where (`SmallProfileData`.`Id_SP` = `SmallProfile`.`id`)")) {
if ($mysql->CreateView($login, "LinkOBJ", " AS select `Link`.`id` AS `id`,`Link`.`Id_MAP` AS `Id_MAP`,`Link`.`Id_OBJ` AS `Id_OBJ`,`Link`.`Id_MAPOBJ` AS `Id_MAPOBJ`,`Objects`.`Id_NTO` AS `Id_NTO`,`Objects`.`name` AS `nameOBJ` from (`Link` join `Objects`) where (`Link`.`Id_OBJ` = `Objects`.`id`)")) {
return true;
}
}
}
}
}
}
}
}
}
}
}
} else {
conprint("SetLINK: ", "0");
return false;
}
}
}
function SetLink($Id_MAP, $array)
{
$mysql = new MySQL();
foreach ($array as $key => $value) {
if ($value['id'] == 'null') {
if ($mysql->InsertString($this->NameBase, "Link", array("Id_MAP" => $value["Id_MAP"], "Id_OBJ" => $value["Id_OBJ"], "Id_MAPOBJ" => $value["Id_MAPOBJ"]))) {
conprint("SetLINK: ", "1");
} else {
conprint("SetLINK: ", "0");
return false;
}
} else {
if (!$this->PutLink($value['id'], $value['Id_OBJ'])) {
return false;
}
}
}
return true;
}
function SetFullProfile()
{
if (!empty($this->Name) && !empty($this->Id_NTO) && !empty($this->Type)) {
$mysql = new MySQL();
if ($mysql->InsertString("DataBase", "FullProfile", array("name" => $this->Name, "Id_NTO" => $this->Id_NTO, "type" => $this->Type, "name_table" => $this->Name . "_" . $this->Id_NTO))) {
conprint("СSetFullProfile : " . $this->Name, "1");
$mysql = new MySQL();
if ($mysql->CreateTable("DataBase", $this->Name . "_" . $this->Id_NTO, "id int(6) NOT NULL auto_increment, name varchar(256),Id_OBJ int(6),info varchar(256),fotoURL varchar(256), PRIMARY KEY (id)")) {
conprint("SetFullProfile: " . $this->Name, "1");
} else {
conprint("SetFullProfile: " . $this->Name, "0");
return false;
}
return true;
} else {
conprint("SetFullProfile : " . $this->Name, "0");
return false;
}
} else {
conprint("SetFullProfile Name или Id_NTO или Type не задано", "0");
return false;
}
}
