<?php


/***************************************************************************


 *                               wpm_db_update.php


 *                            ----------------------


 *


 *             copyright   : ©2003, 2005 Duvelske  (duvelske@planet.nl)


 *


 ***************************************************************************/





/***************************************************************************


 *


 *   This program 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.


 *


 ***************************************************************************/





define('IN_PHPBB', true);


$phpbb_root_path = './';


include($phpbb_root_path . 'extension.inc');


include($phpbb_root_path . 'common.'.$phpEx);


define('WPM_INST', $table_prefix.'wpm');





//


// Start session management


//


$userdata = session_pagestart($user_ip, PAGE_INDEX);


init_userprefs($userdata);


//


// End session management


//








if( !$userdata['session_logged_in'] )


{


   $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';


   header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));


   exit;


}





if( $userdata['user_level'] != ADMIN )


{


   message_die(GENERAL_MESSAGE, 'You are not authorised to view this page');


}








$page_title = 'Updating the database for the WPM mod v 1.0.10';


include($phpbb_root_path . 'includes/page_header.'.$phpEx);





echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';


echo '<tr><th>Updating the database for the WPM mod</th></tr><tr><td><span class="genmed"><ul type="circle">';








$sql = array();


   $sql[] = "DROP TABLE " . WPM_INST. "";


   $sql[] = "CREATE TABLE " . WPM_INST . " (name varchar(255) NOT NULL default '', value text NOT NULL) TYPE=MyISAM";


   $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('wpm_version', '1.0.10')";


   $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('active_wpm', '1')";


   $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('wpm_username', 'Anonymous')";


   $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('wpm_userid', '-1')";


   $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('wpm_subject', 'Welcome to [sitename]!')";


   $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('wpm_message', 'Hi, there [username]!')";





for( $i = 0; $i < count($sql); $i++ )


{


   if( !$result = $db->sql_query ($sql[$i]) )


   {


      $error = $db->sql_error();





      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';


   }


   else


   {


      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />';


   }


}








echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';





echo '<tr><th>End</th></tr><tr><td><span class="genmed">Instalation is ready. Delete the file now!<br />If you have encounterd some errors, please visit <a href="http://www.vitrax.org" target="_top">Vitrax support forums</a> and ask someone for help.</span></td></tr>';


echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>';





include($phpbb_root_path . 'includes/page_tail.'.$phpEx);


?>

DROP TABLE prefix_wpm;


CREATE TABLE prefix_wpm (name varchar(255) NOT NULL default '', value text NOT NULL) TYPE=MyISAM;


INSERT INTO prefix_wpm VALUES ('wpm_version', '1.0.10');


INSERT INTO prefix_wpm VALUES ('active_wpm', '1');


INSERT INTO prefix_wpm VALUES ('wpm_username', 'Anonymous');


INSERT INTO prefix_wpm VALUES ('wpm_userid', '-1');


INSERT INTO prefix_wpm VALUES ('wpm_subject', 'Welcome to [sitename]!');


INSERT INTO prefix_wpm VALUES ('wpm_message', 'Hi, there [username]!');