Page Menu
Home
c4science
Search
Configure Global Search
Log In
Files
F81477564
KB_del.php.wml
No One
Temporary
Actions
Download File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Subscribers
None
File Metadata
Details
File Info
Storage
Attached
Created
Fri, Sep 6, 06:49
Size
2 KB
Mime Type
text/x-php
Expires
Sun, Sep 8, 06:49 (2 d)
Engine
blob
Format
Raw Data
Handle
20580754
Attached To
R3600 invenio-infoscience
KB_del.php.wml
View Options
<?
/*********************************************************************
This file is part of the CERN Document Server Software (CDSware).
Copyright (C) 2002, 2003, 2004, 2005, 2006 CERN.
1211 Geneva 23 - Switzerland
<cds.support@cern.ch>
The CDSware is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
The CDSware is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with CDSware; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*********************************************************************/
//==========================================================================
// File: KB_del.php (flexElink WI)
// Description: Deletes an existing KB from the DB. It also deletes its
// corresponding DB table.
// POST parameters:
// name --> (required) Name (id) of the KB to be added
// Notes: If the KB is succesfully added to the DB it redirects the current
// browser to the KB display list
// Requires: DB, ERROR
// Author: Hector.Sanchez@cern.ch
//==========================================================================
include("localconf.inc.php");
include(DB);
include(ERROR);
if( (!isset($name)) or (trim($name)=="") )
{
errorpage("<b>KB name</b> hasn't been specified");
exit;
}
$name=strtoupper(trim($name));
$db=mysql_connect( $DB_HOST, $DB_USER, $DB_PASSWD )
or errormsg("Couldn't connect to mySQL") or exit;
mysql_selectdb( $DB_DB );
$qry="select kb_table from flxKBS where kb_name='$name'";
$qh=mysql_query($qry, $db);
list($table)=mysql_fetch_array($qh);
$qry="delete from flxKBS
where kb_name='$name'";
if(!mysql_query( $qry ))
{
errorpage("Impossible to delete KB:<br> ".mysql_error());
mysql_close( $db );
exit;
}
$qry="drop table $table";
if(!mysql_query( $qry ))
{
errorpage("KB entry deleted but not table:<br> ".mysql_error());
mysql_close( $db );
exit;
}
mysql_close( $db );
header("location: KB_display.php");
?>
Event Timeline
Log In to Comment