[PHP+MySQL] Problem z plikiem i "}"

[Dawidsu]

Mam problem. Korzystałem z kreatora plików php http://archiwum.phpbb2.pl/db_generator.php

Wpisałem mu zapytanie SQL:

delete from phpbb_users where user_posts=0 and user_active=0 and user_id!=-1 and from_unixtime(user_regdate) < now() - interval '2' day;

Skrypt wypluł taki kod pliku:

<?php
/***************************************************************************
*                               db_update.php
*                            -------------------
*
*   copyright            : Š2003 Freakin' Booty;-P & Antony Bailey
*   project              : http://sourceforge.net/projects/dbgenerator
*   Website              : http://freakingbooty.no-ip.com/ & http://www.rapiddr3am.net
*
***************************************************************************/

/***************************************************************************
*
*   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);

//
// 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 access this page');
}


$page_title = 'Updating the database';
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</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "delete from " . $table_prefix . "users where user_posts=0 and user_active=0 and user_id!=-1 and from_unixtime(user_regdate) < now() - interval '2' day";

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">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbsupport.co.uk" target="_phpbbsupport">phpBBSupport.co.uk</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);

?>

Niestety, po wgraniu go na serwer wyskakuje błąd:

Parse error: syntax error, unexpected '}' in (...).php on line 66

Wiem, że teoretycznie powinienem usunąć "}", ale patrzyłem na ogólną budowę pliku i wszystko wygląda w porządku. Zwracam się do was, byście spojrzeli na plik i wyjaśnili czemu coś takiego może się pojawiać.

 

P.S. Serwer mam na ovh.org

[gnysek]

nie kumam po co zapytanie jest w tablicy, skoro jest tylko jedno...

ja bym to poprawił tak:

 

<?php
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);


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, 'Nie masz prawa dostępu do tej strony');
}


$page_title = 'Aktualizacja bazy danych';
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</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = "DELETE FROM " . $table_prefix . "USERS WHERE user_posts=0 AND user_active=0 AND user_id!=-1 AND from_unixtime(user_regdate) < now() - interval '2' day";

if( !$result = $db->sql_query($sql) )
    {
    $error = $db->sql_error($result);
    echo '<li>' . $sql . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
    }
    else
    {
        echo '<li>' . $sql . '<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">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbsupport.co.uk" target="_phpbbsupport">phpBBSupport.co.uk</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);

?>