Makeing a SQL file

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

Can someone show me how to make this into a SQL file

Code:

<?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><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] . ' +++ Error: ' . $error['message'] . '</li> ';
}
else
{
 echo '<li>' . $sql[$i] . ' +++ Successfull</li> ';
}
}

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

echo '<tr><th>End</th></tr><tr><td>Instalation is ready. Delete the file now! 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.</td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></td></table>';

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

thanks

jackel · Worker Joined: Jan 15, 2009 Posts: 145 Location: Iowa, USA

is anyone able please?

Thanks

evaders99 · Posted: Wed Mar 25, 2009 9:11 pm

Haven't tested this, but should be simple enough

Code:

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]!');