Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?
- //----------------------------------------------------------Добавление (УНИФИЦИРОВАННОЕ)
- // $rupid - это номер записи владельца кабинета
- // $rtid - категория записи
- //
- // 1) добавляется запись в TRECORDS
- // 2) добавляется запсь в TGROUP, связ зап. владельца с записями типа $rtid
- //----------------------------------------------------------------------------------------
- include("minc.php");
- include("uniview.php");
- global $currdir;
- global $imgdir;
- global $hrefdir;
- //--------------------------------------------------------
- // Добавление записи для типа объекта
- //--------------------------------------------------------
- //--------------------авторизация
- $sql="select * from TINFO I, TATTR A where A.AID=I.AID and A.ACC=2 and RID='$rupid' order by A.AID";
- $result=mysql_query($sql);
- echo mysql_error();
- $au_ok=1;
- if (mysql_num_rows($result)!=0)
- {
- $row=mysql_fetch_array($result);
- $login_t=$row["TEXTF"];
- $row=mysql_fetch_array($result);
- $pass_t=$row["TEXTF"];
- if (($login!=$login_t) || ($pass!=$pass_t))
- {
- $au_ok=0;
- }
- //endif
- }
- //endif
- //--------------------------Авторизация прошла успешно
- if ($au_ok==1):
- print('<body onLoad="timer()">');
- $file=fopen("title.html","r");
- $data=fread($file,2000);
- print($data);
- $file=fopen("top.html","r");
- $data=fread($file,2000);
- print($data);
- //--------------------------------Непосредственно запись данных
- $today=date("Y-m-d");
- if ($rupid=='')
- $rupid=0;
- //endif
- //--------------------------------------------------------Создание текущей записи
- $sql = "INSERT INTO TRECORDS VALUES(NULL,'$rtid','$today',0,'$rupid')";
- $result=mysql_query($sql);
- echo mysql_error();
- $sql="SELECT MAX(RID) as RID1 FROM TRECORDS";
- $result=mysql_query($sql);
- $row=mysql_fetch_array($result);
- $rid1=$row["RID1"];
- //-------------------------------------------------------создание связи для тек. записи
- $sql = "SELECT GID FROM TGROUP where RID='$rupid' and GDID='$gdid'";
- $result=mysql_query($sql);
- if (mysql_num_rows($result)==0)
- {
- $sql = "INSERT INTO TGROUP VALUES(NULL,'$rupid','TEST','$gdid')";
- $result=mysql_query($sql);
- echo mysql_error();
- $sql="SELECT MAX(GID) as GID1 FROM TGROUP";
- $result=mysql_query($sql);
- $row=mysql_fetch_array($result);
- $gid1=$row["GID1"];
- }
- else
- {
- $row=mysql_fetch_array($result);
- $gid1=$row["GID"];
- }
- //endif
- //-----------------------------------------------------
- $sql = "UPDATE TRECORDS SET HAVEGR=1 WHERE RID='$rupid'";
- $result=mysql_query($sql);
- echo mysql_error();
- $sql="SELECT * FROM TLINK where RID='$rid1' and GID='$gid1'";
- $result=mysql_query($sql);
- if (mysql_num_rows($result)==0)
- {
- $sql = "INSERT INTO TLINK VALUES(NULL,'$rid1','$gid1',0)";
- $result=mysql_query($sql);
- echo mysql_error();
- }
- //endif
- //------------------------------создание связи с главн. записью
- //----------------------------------!!!!!!!!!!!!!!!!!!
- $rupid100=1;
- $rid100=$rid1;
- $sql="select G.GDID from TRECORDS R, TRECORDS R1, TRECTYPE RT, TRECTYPE RT1, TGROUPDES G ".
- "WHERE R.RID='$rupid100' and R1.RID='$rid100' ".
- " and R.RTID=RT.RTID and R1.RTID=RT1.RTID ".
- " and G.RTID=RT.RTID and G.RTID2=RT1.RTID ";
- $result=mysql_query($sql);
- echo mysql_error();
- $row=mysql_fetch_array($result);
- $gdid100=$row["GDID"];
- $sql = "SELECT GID FROM TGROUP where RID='$rupid100' and GDID='$gdid100'";
- $result=mysql_query($sql);
- //---------------------------------------
- if (mysql_num_rows($result)==0)
- {
- $sql = "INSERT INTO TGROUP VALUES(NULL,'$rupid100','TEST','$gdid100')";
- $result=mysql_query($sql);
- echo mysql_error();
- $sql="SELECT MAX(GID) as GID1 FROM TGROUP";
- $result=mysql_query($sql);
- $row=mysql_fetch_array($result);
- $gid100=$row["GID1"];
- }
- else
- {
- $row=mysql_fetch_array($result);
- $gid100=$row["GID"];
- }
- //endif
- //--------------------------------------------------
- $sql="SELECT * FROM TLINK where RID='$rid100' and GID='$gid100'";
- $result=mysql_query($sql);
- if ((mysql_num_rows($result)==0) && ($rid100!=1))
- {
- $sql = "INSERT INTO TLINK VALUES(NULL,'$rid100','$gid100',0)";
- $result=mysql_query($sql);
- echo mysql_error();
- }
- //endif
- //--------------------------------------------------Запись полей
- print('связь создана');
- for ($fld=0; $fld<$n_fld; $fld++)
- {
- if ($fld==0) $ins=$fld0;
- if ($fld==1) $ins=$fld1;
- if ($fld==2) $ins=$fld2;
- if ($fld==3) $ins=$fld3;
- if ($fld==4) $ins=$fld4;
- if ($fld==5) $ins=$fld5;
- if ($fld==6) $ins=$fld6;
- if ($fld==7) $ins=$fld7;
- if ($fld==8) $ins=$fld8;
- if ($fld==9) $ins=$fld9;
- if ($fld==0) $aid=$attr0;
- if ($fld==1) $aid=$attr1;
- if ($fld==2) $aid=$attr2;
- if ($fld==3) $aid=$attr3;
- if ($fld==4) $aid=$attr4;
- if ($fld==5) $aid=$attr5;
- if ($fld==6) $aid=$attr6;
- if ($fld==7) $aid=$attr7;
- if ($fld==8) $aid=$attr8;
- if ($fld==9) $aid=$attr9;
- if ($fld==0) $atp=$atp0;
- if ($fld==1) $atp=$atp1;
- if ($fld==2) $atp=$atp2;
- if ($fld==3) $atp=$atp3;
- if ($fld==4) $atp=$atp4;
- if ($fld==5) $atp=$atp5;
- if ($fld==6) $atp=$atp6;
- if ($fld==7) $atp=$atp7;
- if ($fld==8) $atp=$atp8;
- if ($fld==9) $atp=$atp9;
- if ($atp!=7)
- $ins=strip_tags($ins,"<b><i><h1><h2><h3><font><p><br><img><a><hr><div>");
- else
- {
- if ($htcode!='55')
- {
- $ins=strip_tags($ins,"<b><i><h1><h2><h3><font><p><br><img><a><hr><div>");
- $ins=str_replace(chr(13),'<br>',$ins);
- $ins=str_replace(' ','  ',$ins);
- }
- //endif
- }
- //endif
- //-------------------------Добавить записи в таблицу слов
- add_to_words($ins,$rid1);
- rid_explod($rid1,$rtid,$ins);
- $ins='<b>'.$ins.'</b>';
- if ($atp==1) $sql = "INSERT INTO TINFO VALUES(NULL,'$ins',0,0,1,'$rid1','$aid','$atp')";
- if ($atp==2) $sql = "INSERT INTO TINFO VALUES(NULL,'$ins',0,0,1,'$rid1','$aid','$atp')";
- if ($atp==3) $sql = "INSERT INTO TINFO VALUES(NULL,'',0,'$ins',3,'$rid1','$aid','$atp')";
- if ($atp==4) $sql = "INSERT INTO TINFO VALUES(NULL,'',$ins',0,2,'$rid1','$aid','$atp')";
- if ($atp==5) $sql = "INSERT INTO TINFO VALUES(NULL,'$ins',0,0,1,'$rid1','$aid','$atp')";
- if ($atp>10) $sql = "INSERT INTO TINFO VALUES(NULL,'$ins',0,0,1,'$rid1','$aid','$atp')";
- //---------------------------------
- if ($atp==6)
- {
- $tx='';
- if (($fldfile != "none") &&
- (!(eregi(".php",$fldfile_name)))&&
- (!(eregi(".pl",$fldfile_name)))&&
- (!(eregi(".cgi",$fldfile_name))) )
- {
- copy($fldfile,$currdir.$rid100.$fldfile_name);
- unlink($fldfile);
- }
- //endif
- $tx=$rid100.$fldfile_name;
- print($tx.'<br>');
- $sql = "INSERT INTO TINFO VALUES(NULL,'$tx',0,0,1,'$rid1','$aid','$atp')";
- }
- //endif
- //----------------------------------
- if ($atp==7)
- {
- if (($pictop != "") &&
- (!(eregi(".php",$pictop_name)))&&
- (!(eregi(".pl",$pictop_name)))&&
- (!(eregi(".cgi",$pictop_name))) )
- {
- copy($pictop,$currdir.$rid100.$pictop_name);
- unlink($pictop);
- $ins=$imgdir.$rid100.$pictop_name.'"><br>'.$ins;
- }
- //endif
- $sql = "INSERT INTO TINFO VALUES(NULL,' ',0,0,1,'$rid1','$aid','$atp')";
- $result=mysql_query($sql);
- echo mysql_error();
- $sql="SELECT MAX(IID) as IID1 FROM TINFO";
- $result=mysql_query($sql);
- $row=mysql_fetch_array($result);
- $iid1=$row["IID1"];
- $sql="INSERT INTO TTEXT VALUES(NULL,'$iid1','$ins')";
- }
- //endif
- $result=mysql_query($sql);
- echo mysql_error();
- print($ins.'<br>');
- }
- //endfor
- print('Данные успешно записаны.<br><br>');
- include("testsp.php");
- print('<script language="JavaScript">');
- $r_str="location.href='".$view_ref."?rid=".$rupid.
- "&login=".$login."&pass=".$pass."&auth_rid=".$auth_rid."' ;";
- print('function timer() { setTimeout("'.$r_str.'", 1);} </script>');
- print('</body>');
- endif;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement