|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
This script I use to update my MySQL database. I'm using PHP 4.3.10.
I'm getting the following error: Parse error: parse error in C:\Apache\Apache2\htdocs\bpm_db_install.php on line 56 Bold markerket in the script...... Script: ================================================== ========== <?php /************************************************** ************************* * bpm_db_install.php * ---------------------- * * copyright : ©2003, 2004 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 bpm mod v 1.0.3b'; 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 bpm mod</th></tr><tr><td><span class="genmed"><ul type="circle">'; $sql = array(); $sql[] = "INSERT INTO " . CONFIG_TABLE . " (config_name, config_value) VALUES ("birthday_bpm", "0")"; $sql[] = "ALTER TABLE " . USERS_TABLE . " ADD user_birthday INT DEFAULT "999999" not null"; $sql[] = "ALTER TABLE " . USERS_TABLE . " ADD user_next_birthday_greeting INT DEFAULT "0" not null"; $sql[] = "CREATE TABLE " . WPM_INST . " (name varchar(255) NOT NULL default '', value text NOT NULL) TYPE=MyISAM"; $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('bpm_version', '1.0.3b')"; $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('active_bpm', '1')"; $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('active_bpmmail', '0')"; $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('bpm_username', 'Anonymous')"; $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('bpm_userid', '-1')"; $sql[] = "INSERT INTO " . WPM_INST . " VALUES ('bpm_subject', 'Happy birthday')"; INSERT INTO phpbb_wpm VALUES ('bpm_message', 'Happy birthday [username]! You are now [age] years old :lol: If you have any questions about the site, please ask. If it goes about this mod please visit: http://www.vitrax.vze.com thnx you!'); 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"> </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.vze.com" 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); ?> |
|
#2
|
|||
|
|||
|
Looks like you're missing a $sql[]= here:
PHP Code:
Also, please use php tags on your code in the future (with the small php icon in the upper right of the window). Makes it much more readable. |
![]() |
| Viewing: Dev Articles Community Forums > Programming > PHP Development > Also a Parse error - help needed plz |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|