[phpwiki-checkins] CVS: phpwiki/lib mysql.php,1.3,1.4

[Arno H. <aho...@us...>]

Update of /cvsroot/phpwiki/phpwiki/lib
In directory slayer.i.sourceforge.net:/tmp/cvs-serv19048

Modified Files:
	mysql.php 
Log Message:
added function RemovePage()

Index: mysql.php
===================================================================
RCS file: /cvsroot/phpwiki/phpwiki/lib/mysql.php,v
retrieving revision 1.3
retrieving revision 1.4
diff -C2 -r1.3 -r1.4
*** mysql.php	2000/10/20 11:42:52	1.3
--- mysql.php	2000/11/08 15:40:56	1.4
***************
*** 146,149 ****
--- 146,174 ----
  
  
+    function RemovePage($dbi, $pagename) {
+       global $WikiPageStore, $ArchivePageStore;
+ 
+       $pagename = addslashes($pagename);
+       $msg = gettext ("Cannot delete '%s' from table '%s'");
+       $msg .= "<br>\n";
+       $msg .= gettext ("MySQL error: %s");
+ 
+       if (!mysql_query("delete from $WikiPageStore where pagename='$pagename'", $dbi['dbc']))
+          ExitWiki(sprintf($msg, $pagename, $WikiPageStore, mysql_error()));
+ 
+       if (!mysql_query("delete from $ArchivePageStore where pagename='$pagename'", $dbi['dbc']))
+          ExitWiki(sprintf($msg, $pagename, $ArchivePageStore, mysql_error()));
+ 
+       if (!mysql_query("delete from wikilinks where frompage='$pagename'", $dbi['dbc']))
+          ExitWiki(sprintf($msg, $pagename, 'wikilinks', mysql_error()));
+ 
+       if (!mysql_query("delete from hitcount where pagename='$pagename'", $dbi['dbc']))
+          ExitWiki(sprintf($msg, $pagename, 'hitcount', mysql_error()));
+ 
+       if (!mysql_query("delete from wikiscore where pagename='$pagename'", $dbi['dbc']))
+          ExitWiki(sprintf($msg, $pagename, 'wikiscore', mysql_error()));
+    }
+ 
+ 
     function IncreaseHitCount($dbi, $pagename)
     {