doc_sql.inc

来自「FIREFLY 是一个多用户专业帮助桌面系统」· INC 代码 · 共 50 行

<?
###############################################################
#
#     FONCTION SQL DU MODULE DOC 
#
###############################################################

################################ SQL LINK DELETE
function SQL_DELETE_LINK($dbproc, $from_table, $from_id, $to_table, $to_id, $user_id)
{
  /* on verifie la coh閞ence des param鑤res */
  if ($from_table.$from_id.$to_table.$to_id!="") 
    {
     	/* init transaction */
	SQL_BEGIN($dbproc);

	$query="DELETE FROM links 
                WHERE (from_table='$from_table'
                AND from_id='$from_id'
                AND to_table='$to_table'
                AND to_id='$to_id') 
		OR 
		(from_table='$to_table'
                AND from_id='$to_id'
                AND to_table='$from_table'
                AND to_id='$from_id')";
        
	$result=SQL_QUERY($query,$dbproc);


	/*fin transaction */
	if ($result)
	  {
	    SQL_COMMIT($dbproc);
	    return 0;
	  }
	else
	  {
	    SQL_ROLLBACK($dbproc);
	    return -1;
	  }
    }
}
################################# SQL LINK INSERT
function SQL_INSERT_LINK($dbproc, $from_table, $from_id, $to_table, $to_id, $user_id)
{
  /* on verifie la coh閞ence des param鑤res */
  if ($from_table.$from_id.$to_table.$to_id!="") 
    {
      /* on verifie que le lien n'existe pas d閖