PHPfrance

la communauté d'entraide francophone dédiée au PHP

une erreur ?

9 messages   •   Page 1 sur 1
   Outils de sujet
cloclo02
Petit nouveau ! | 6 Messages

20 avr. 2008, 04:00

Il y à une erreur T_STRING dans cette parti de mon code, mais avant tout fonctionnait à merveille !
mysql_query('INSERT INTO '.$forumid_prefix."groups (gtitle, guser_title, gread_board, gpost_replies, gpost_topics, gpost_polls, gedit_posts, gdelete_posts, gdelete_topics, gset_title, gsearch, gsearchusers, geditsubjectsinterval, gpostflood, gsearchflood) VALUES('Administrators', 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Moderators', 'Moderator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Guest', NULL, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Members', NULL, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30)") or die(mysql_error());
Merci à vous de m'aider !

[Note : ce message a été posté de manière anonyme avant d'être réattribué à son auteur]
Petit nouveau ! | 6 Messages

20 avr. 2008, 04:13

Voici le code de la page au complet :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Activer votre forum !</title>
<link rel="stylesheet" type="text/css" href="style/Oxygen.css" />
</head>
<body>
<?php
include("vars.php");
mysql_connect($db_host, $db_username, $db_password) or die(mysql_error());
mysql_select_db($db_name) or die(mysql_error());

if($_GET['ForumID'] && $_GET['Code'])
{
        $forumid = strtolower($_GET['ForumID']);
        $code = $_GET['Code'];
} else {
        echo "<div id=\"puninstall\" style=\"margin: auto 10% auto 10%\">
        <div class=\"pun\">
        <div class=\"block\">
                <h2><span>E R R O R</span></h2>
                <div class=\"box\">
                        <div class=\"inbox\">
                                <p align=\"center\">Sorry. This is an <b>invalid</b> PunBB Forums activation link.<br /><br />
                                <a href=$base_url/signup.php>Click Here</a> to go back to home page!<br />
                                </p>
                        </div>
                </div>
        </div>
        </div>
        </div>";
        include("copyright.php"); echo $style1;
  echo "</body>
        </html>";
        exit();
}

$query1 = "SELECT * FROM new_forums WHERE forumid = '$forumid' AND code = '$code'";
$result = mysql_query($query1) or die(mysql_error());

if(mysql_num_rows($result) != "1")
{
        echo "<div id=\"puninstall\" style=\"margin: auto 10% auto 10%\">
        <div class=\"pun\">
        <div class=\"block\">
                <h2><span>E R R O R</span></h2>
                <div class=\"box\">
                        <div class=\"inbox\">
                                <p align=\"center\">Sorry. ForumID <b>$forumid</b> and Code <b>$code</b> is incorrect <br /> OR <br /> this forum is already activated!<br /><br />
                                <a href=$base_url/signup.php>Click Here</a> to go back to home page!<br />
                                </p>
                        </div>
                </div>
        </div>
        </div>
        </div>";
        include("copyright.php"); echo $style1;
  echo "</body>
        </html>";
        exit();
}

$data = mysql_fetch_array($result);
$data_admin_username = $data['admin_username'];
$data_admin_password = $data['admin_password'];
$data_admin_email = $data['admin_email'];

$badid = array('forums',
               'forum',
               'admin',
               'cache',
               'img',
               'include',
               'lang',
               'plugins',
               'style');

if(in_array($forumid, $badid))
{
        echo "<div id=\"puninstall\" style=\"margin: auto 10% auto 10%\">
        <div class=\"pun\">
        <div class=\"block\">
                <h2><span>E R R O R</span></h2>
                <div class=\"box\">
                        <div class=\"inbox\">
                                <p align=\"center\">Sorry. <b>$forumid</b> is an invalid ForumID. Please signup again!<br /><br />
                                <a href=$base_url/signup.php>Click Here</a> to go back to home page!<br />
                                </p>
                        </div>
                </div>
        </div>
        </div>
        </div>";
        include("copyright.php"); echo $style1;
  echo "</body>
        </html>";
        $query = "DELETE FROM new_forums WHERE forumid = '$forumid' AND code = '$code'";
        mysql_query($query);
        exit();
}

$query2 = "INSERT INTO punbb_forums VALUES('$forumid', '$data_admin_email')";
mysql_query($query2);

$query3 = "DELETE FROM new_forums WHERE forumid = '$forumid' AND code = '$code'";
mysql_query($query3);

$forumid_prefix = $forumid . "_punbb_";

/* Create all tables */
$sql = 'CREATE TABLE '.$forumid_prefix."bans (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        username VARCHAR(200),
                                        ip VARCHAR(255),
                                        email VARCHAR(50),
                                        message VARCHAR(255),
                                        expire INT(10) UNSIGNED,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."categories (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        cat_name VARCHAR(80) NOT NULL DEFAULT 'New Category',
                                        disp_position INT(10) NOT NULL DEFAULT 0,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."censoring (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        search_for VARCHAR(60) NOT NULL DEFAULT '',
                                        replace_with VARCHAR(60) NOT NULL DEFAULT '',
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."config (
                                        conf_name VARCHAR(255) NOT NULL DEFAULT '',
                                        conf_value TEXT,
                                        PRIMARY KEY (conf_name)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."forum_perms (
                                        group_id INT(10) NOT NULL DEFAULT 0,
                                        forum_id INT(10) NOT NULL DEFAULT 0,
                                        read_forum TINYINT(1) NOT NULL DEFAULT 1,
                                        post_replies TINYINT(1) NOT NULL DEFAULT 1,
                                        post_topics TINYINT(1) NOT NULL DEFAULT 1,
                                        PRIMARY KEY (group_id, forum_id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."forums (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        forum_name VARCHAR(80) NOT NULL DEFAULT 'New forum',
                                        forum_desc TEXT,
                                        redirect_url VARCHAR(100),
                                        moderators TEXT,
                                        num_topics MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
                                        num_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
                                        last_post INT(10) UNSIGNED,
                                        last_post_id INT(10) UNSIGNED,
                                        last_poster VARCHAR(200),
                                        sort_by TINYINT(1) NOT NULL DEFAULT 0,
                                        disp_position INT(10) NOT NULL DEFAULT 0,
                                        cat_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."groups (
                                        g_id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        g_title VARCHAR(50) NOT NULL DEFAULT '',
                                        g_user_title VARCHAR(50),
                                        g_read_board TINYINT(1) NOT NULL DEFAULT 1,
                                        g_post_replies TINYINT(1) NOT NULL DEFAULT 1,
                                        g_post_topics TINYINT(1) NOT NULL DEFAULT 1,
                                        g_post_polls TINYINT(1) NOT NULL DEFAULT 1,
                                        g_edit_posts TINYINT(1) NOT NULL DEFAULT 1,
                                        g_delete_posts TINYINT(1) NOT NULL DEFAULT 1,
                                        g_delete_topics TINYINT(1) NOT NULL DEFAULT 1,
                                        g_set_title TINYINT(1) NOT NULL DEFAULT 1,
                                        g_search TINYINT(1) NOT NULL DEFAULT 1,
                                        g_search_users TINYINT(1) NOT NULL DEFAULT 1,
                                        g_edit_subjects_interval SMALLINT(6) NOT NULL DEFAULT 300,
                                        g_post_flood SMALLINT(6) NOT NULL DEFAULT 30,
                                        g_search_flood SMALLINT(6) NOT NULL DEFAULT 30,
                                        PRIMARY KEY (g_id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."online (
                                        user_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
                                        ident VARCHAR(200) NOT NULL DEFAULT '',
                                        logged INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        idle TINYINT(1) NOT NULL DEFAULT 0
                                        ) TYPE=HEAP;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."posts (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        poster VARCHAR(200) NOT NULL DEFAULT '',
                                        poster_id INT(10) UNSIGNED NOT NULL DEFAULT 1,
                                        poster_ip VARCHAR(15),
                                        poster_email VARCHAR(50),
                                        message TEXT NOT NULL DEFAULT '',
                                        hide_smilies TINYINT(1) NOT NULL DEFAULT 0,
                                        posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        edited INT(10) UNSIGNED,
                                        edited_by VARCHAR(200),
                                        topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."ranks (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        rank VARCHAR(50) NOT NULL DEFAULT '',
                                        min_posts MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."reports (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        reported_by INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        created INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        message TEXT NOT NULL DEFAULT '',
                                        zapped INT(10) UNSIGNED,
                                        zapped_by INT(10) UNSIGNED,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."search_cache (
                                        id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        ident VARCHAR(200) NOT NULL DEFAULT '',
                                        search_data TEXT NOT NULL DEFAULT '',
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."search_matches (
                                        post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        word_id MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
                                        subject_match TINYINT(1) NOT NULL DEFAULT 0
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."search_words (
                                        id MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        word VARCHAR(20) BINARY NOT NULL DEFAULT '',
                                        PRIMARY KEY (word),
                                        KEY ".$forumid_prefix."search_words_id_idx (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."subscriptions (
                                        user_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        topic_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        PRIMARY KEY (user_id, topic_id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."topics (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        poster VARCHAR(200) NOT NULL DEFAULT '',
                                        subject VARCHAR(255) NOT NULL DEFAULT '',
                                        posted INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        last_post INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        last_post_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        last_poster VARCHAR(200),
                                        num_views MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
                                        num_replies MEDIUMINT(8) UNSIGNED NOT NULL DEFAULT 0,
                                        closed TINYINT(1) NOT NULL DEFAULT 0,
                                        sticky TINYINT(1) NOT NULL DEFAULT 0,
                                        moved_to INT(10) UNSIGNED,
                                        forum_id INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."users (
                                        id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
                                        group_id INT(10) UNSIGNED NOT NULL DEFAULT 4,
                                        username VARCHAR(200) NOT NULL DEFAULT '',
                                        password VARCHAR(40) NOT NULL DEFAULT '',
                                        email VARCHAR(50) NOT NULL DEFAULT '',
                                        title VARCHAR(50),
                                        realname VARCHAR(40),
                                        url VARCHAR(100),
                                        jabber VARCHAR(75),
                                        icq VARCHAR(12),
                                        msn VARCHAR(50),
                                        aim VARCHAR(30),
                                        yahoo VARCHAR(30),
                                        location VARCHAR(30),
                                        use_avatar TINYINT(1) NOT NULL DEFAULT 0,
                                        signature TEXT,
                                        disp_topics TINYINT(3) UNSIGNED,
                                        disp_posts TINYINT(3) UNSIGNED,
                                        email_setting TINYINT(1) NOT NULL DEFAULT 1,
                                        save_pass TINYINT(1) NOT NULL DEFAULT 1,
                                        notify_with_post TINYINT(1) NOT NULL DEFAULT 0,
                                        show_smilies TINYINT(1) NOT NULL DEFAULT 1,
                                        show_img TINYINT(1) NOT NULL DEFAULT 1,
                                        show_img_sig TINYINT(1) NOT NULL DEFAULT 1,
                                        show_avatars TINYINT(1) NOT NULL DEFAULT 1,
                                        show_sig TINYINT(1) NOT NULL DEFAULT 1,
                                        timezone FLOAT NOT NULL DEFAULT 0,
                                        language VARCHAR(25) NOT NULL DEFAULT 'English',
                                        style VARCHAR(25) NOT NULL DEFAULT 'Oxygen',
                                        num_posts INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        last_post INT(10) UNSIGNED,
                                        registered INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        registration_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
                                        last_visit INT(10) UNSIGNED NOT NULL DEFAULT 0,
                                        admin_note VARCHAR(30),
                                        activate_string VARCHAR(50),
                                        activate_key VARCHAR(8),
                                        PRIMARY KEY (id)
                                        ) TYPE=MyISAM;";
                                        mysql_query($sql) or die(mysql_error);

$sql = 'CREATE TABLE '.$forumid_prefix."page (id INT(10) NOT NULL auto_increment, 
title VARCHAR(75) NOT NULL, 
content TEXT NOT NULL, PRIMARY KEY (id) ENGINE=MyISAM;"; 
mysql_query($sql) or die(mysql_error_page_plugin);
										
$queries = 'ALTER TABLE '.$forumid_prefix.'online ADD INDEX '.$forumd_prefix.'online_user_id_idx(user_id)';
$queries = 'ALTER TABLE '.$forumid_prefix.'posts ADD INDEX '.$forumd_prefix.'posts_topic_id_idx(topic_id)';
$queries = 'ALTER TABLE '.$forumid_prefix.'posts ADD INDEX '.$forumd_prefix.'posts_multi_idx(poster_id, topic_id)';
$queries = 'ALTER TABLE '.$forumid_prefix.'reports ADD INDEX '.$forumd_prefix.'reports_zapped_idx(zapped)';
$queries = 'ALTER TABLE '.$forumid_prefix.'search_matches ADD INDEX '.$forumd_prefix.'search_matches_word_id_idx(word_id)';
$queries = 'ALTER TABLE '.$forumid_prefix.'search_matches ADD INDEX '.$forumd_prefix.'search_matches_post_id_idx(post_id)';
$queries = 'ALTER TABLE '.$forumid_prefix.'topics ADD INDEX '.$forumd_prefix.'topics_forum_id_idx(forum_id)';
$queries = 'ALTER TABLE '.$forumid_prefix.'topics ADD INDEX '.$forumd_prefix.'topics_moved_to_idx(moved_to)';
$queries = 'ALTER TABLE '.$forumid_prefix.'users ADD INDEX '.$forumd_prefix.'users_registered_idx(registered)';
$queries = 'ALTER TABLE '.$forumid_prefix.'search_cache ADD INDEX '.$forumd_prefix.'search_cache_ident_idx(ident(8))';
$queries = 'ALTER TABLE '.$forumid_prefix.'users ADD INDEX '.$forumd_prefix.'users_username_idx(username(8))';

@reset($queries);
while(list(, $sql) = @each($queries))
{
        mysql_query($sql) or die(mysql_error);
}

$now = time();

/* Insert the four preset groups */
mysql_query('INSERT INTO '.$forumid_prefix."groups (gtitle, guser_title, gread_board, gpost_replies, gpost_topics, gpost_polls, gedit_posts, gdelete_posts, gdelete_topics, gset_title, gsearch, gsearchusers, geditsubjectsinterval, gpostflood, gsearchflood) VALUES('Administrators', 'Administrator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Moderators', 'Moderator', 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 0, 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Guest', NULL, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."groups (g_title, g_user_title, g_read_board, g_post_replies, g_post_topics, g_post_polls, g_edit_posts, g_delete_posts, g_delete_topics, g_set_title, g_search, g_search_users, g_edit_subjects_interval, g_post_flood, g_search_flood) VALUES('Members', NULL, 1, 1, 1, 1, 1, 1, 1, 0, 1, 1, 300, 60, 30)") or die(mysql_error());

/* Insert guest and first admin user */
mysql_query('INSERT INTO '.$forumid_prefix."users (group_id, username, password, email) VALUES(3, 'Guest', 'Guest', 'Guest')") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."users (group_id, username, password, email, num_posts, last_post, registered, registration_ip, last_visit) VALUES(1, '$data_admin_username', '".md5($data_admin_password)."', '".$data_admin_email."', 1, '".$now."', '".$now."', '127.0.0.1', '".$now."')") or die(mysql_error());

/* Insert config data */
$config = array(
                'o_cur_version'           => "'1.2.17'",
                'o_board_title'           => "'Mon forum PunBB'",
                'o_board_desc'            => "'Malheureusement personne ne peut vous dire ce que PunBB est - vous devez le voir par vous-même.'",
                'o_server_timezone'       => "'0'",
                'o_time_format'           => "'H:i:s'",
                'o_date_format'           => "'d-m-Y'",
                'o_timeout_visit'         => "'600'",
                'o_timeout_online'        => "'300'",
                'o_redirect_delay'        => "'1'",
                'o_show_version'          => "'0'",
                'o_show_user_info'        => "'1'",
                'o_show_post_count'       => "'1'",
                'o_smilies'               => "'1'",
                'o_smilies_sig'           => "'1'",
                'o_make_links'            => "'1'",
                'o_default_lang'          => "'French'",
                'o_default_style'         => "'Oxygen'",
                'o_default_user_group'    => "'4'",
                'o_topic_review'          => "'15'",
                'o_disp_topics_default'   => "'30'",
                'o_disp_posts_default'    => "'25'",
                'o_indent_num_spaces'     => "'4'",
                'o_quickpost'             => "'1'",
                'o_users_online'          => "'1'",
                'o_censoring'             => "'0'",
                'o_ranks'                 => "'1'",
                'o_show_dot'              => "'0'",
                'o_quickjump'             => "'1'",
                'o_gzip'                  => "'1'",
                'o_additional_navlinks'   => "''",
                'o_report_method'         => "'0'",
                'o_regs_report'           => "'0'",
                'o_mailing_list'          => "'$data_admin_email'",
                'o_avatars'               => "'1'",
                'o_avatars_dir'           => "'$forumid/avatars'",
                'o_avatars_width'         => "'60'",
                'o_avatars_height'        => "'60'",
                'o_avatars_size'          => "'10240'",
                'o_search_all_forums'     => "'1'",
                'o_base_url'              => "'$base_url'",
                'o_admin_email'           => "'$data_admin_email'",
                'o_webmaster_email'       => "'$data_admin_email'",
                'o_subscriptions'         => "'1'",
                'o_smtp_host'             => "NULL",
                'o_smtp_user'             => "NULL",
                'o_smtp_pass'             => "NULL",
                'o_regs_allow'            => "'1'",
                'o_regs_verify'           => "'0'",
                'o_announcement'          => "'0'",
                'o_announcement_message'  => "'Entrez votre annonce ici.'",
                'o_rules'                 => "'0'",
                'o_rules_message'         => "'Entrez vos règles ici.'",
                'o_maintenance'           => "'0'",
                'o_maintenance_message'   => "'Les forums sont temporairement fermé pour maintenance. Veuillez réessayer dans quelques minutes.<br />\\n<br />\\n/Administrator'",
                'p_mod_edit_users'        => "'1'",
                'p_mod_rename_users'      => "'0'",
                'p_mod_change_passwords'  => "'0'",
                'p_mod_ban_users'         => "'0'",
                'p_message_bbcode'        => "'1'",
                'p_message_img_tag'       => "'1'",
                'p_message_all_caps'      => "'1'",
                'p_subject_all_caps'      => "'1'",
                'p_sig_all_caps'          => "'1'",
                'p_sig_bbcode'            => "'1'",
                'p_sig_img_tag'           => "'0'",
                'p_sig_length'            => "'400'",
                'p_sig_lines'             => "'4'",
                'p_allow_banned_email'    => "'1'",
                'p_allow_dupe_email'      => "'0'",
                'p_force_guest_email'     => "'1'"
        );

while (list($conf_name, $conf_value) = @each($config))
{
        mysql_query('INSERT INTO '.$forumid_prefix."config (conf_name, conf_value) VALUES('$conf_name', $conf_value)") or die(mysql_error());
}

/* Insert some other default data */
mysql_query('INSERT INTO '.$forumid_prefix."categories (cat_name, disp_position) VALUES('Test category', 1)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."forums (forum_name, forum_desc, num_topics, num_posts, last_post, last_post_id, last_poster, disp_position, cat_id) VALUES('Test forum', 'This is just a test forum', 1, 1, ".$now.", 1, '".$data_admin_username."', 1, 1)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."topics (poster, subject, posted, last_post, last_post_id, last_poster, forum_id) VALUES('".$data_admin_username."', 'Test post', ".$now.", ".$now.", 1, '".$data_admin_username."', 1)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."posts (poster, poster_id, poster_ip, message, posted, topic_id) VALUES('".$data_admin_username."', 2, '127.0.0.1', 'If you are looking at this (which I guess you are), the install of PunBB appears to have worked! Now log in and head over to the administration control panel to configure your forum.', ".$now.', 1)') or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."ranks (rank, min_posts) VALUES('New member', 0)") or die(mysql_error());
mysql_query('INSERT INTO '.$forumid_prefix."ranks (rank, min_posts) VALUES('Member', 10)") or die(mysql_error());

/* Close the mysql connection */
mysql_close();

/* Database Type Info */
$db_type = "mysql";

/* Config Data */
$config = '<?php'."\n\n"."/* PunBB 1.x auto-generated config file, DO NOT EDIT THIS FILE */\n\n"."include('vars.php');\n".'$db_type = \''.$db_type."';\n".'$db_prefix = \''.$forumid_prefix."';\n".'$p_connect = false;'."\n\n".'$cookie_name = '."'punbb_cookie';\n".'$cookie_domain = '."'';\n".'$cookie_path = '."'/';\n".'$cookie_secure = 0;'."\n".'$cookie_seed = \''.substr(md5(time()), -8)."';\n\ndefine('PUN', 1);\n\n?>";

/* Create main ForumID Folder */
mkdir($forumid, 0777);

/* Create index.php redirecting file */
$re = fopen($forumid . "/index.php", 'wb');
fwrite($re, '<?php header("Location: ../?id='.$forumid.'"); ?>');
fclose($re);

/* Create config file for ForumID */
$config_loc = "$forumid/" . $forumid . "_config.php";
$config_file = fopen("$config_loc", 'wb');
fwrite($config_file, $config);
fclose($config_file);

/* Create separate cache folder */
mkdir("$forumid/cache", 0777);

/* Create .htaccess file inside of separate cache folder to protech cache */
$ht = fopen($forumid . "/cache/.htaccess", 'wb');
fwrite($ht, '<Limit GET POST PUT>
Order Allow,Deny
Deny from All
</Limit>');
fclose($ht);

/* Create index.html file inside of separate cache folder */
$in = fopen($forumid . "/cache/index.html", 'wb');
fwrite($in, '<html><head><title>.</title></head><body>.</body></html>');
fclose($in);

/* Create separate avatars folder */
mkdir("$forumid/avatars", 0777);

/* If everything went well, set a success message */
$done .= "votre forum <b>$forumid</b> est bien activer !<br /><br />
          l'Adresse de votre forum est : <a href=$base_url/?id=$forumid>$base_url/?id=$forumid</a><br />
		  <br>Veuillez noté que le forum de support est : <a href=http://support.tonpunbb.fr.nf/>http://support.tonpunbb.fr.nf/</a>";
?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Activé votre forum !</title>
<link rel="stylesheet" type="text/css" href="style/Oxygen.css" />
</head>
<body>
<!-- Print Out congratulation messages! -->
<?php
if($done)
{
        echo "<div id=\"puninstall\" style=\"margin: auto 10% auto 10%\">
        <div class=\"pun\">
        <div class=\"block\">
                <h2><span>Félicitation - Votre Forum est Activé</span></h2>
                <div class=\"box\">
                        <div class=\"inbox\">
                                <p align=\"center\">$done
                                </p>
                        </div>
                </div>
        </div>
        </div>
        </div>";
}
?>
<?php include("copyright.php"); echo $style1; ?>
</body>
</html>
Ou sont mes erreur ?

[Note : ce message a été posté de manière anonyme avant d'être réattribué à son auteur]
Mammouth du PHP | 19672 Messages

20 avr. 2008, 08:08

Cloclo02, si tu nous affichais aussi le libellé du message d'erreur, ça faciliterait un peu les réponses.

Là, on dirait que tu bidouilles les codes de PunBB, ok, mais tu as modifié quoi juste avant d'avoir cette erreur ?

Et je te signale que les lignes 500 à 506 sont strictement inutiles puisque déjà existantes aux lignes 1 à 8 sans la faute d'orthographe (Activer au lieu de Activé).
Codez en pensant que celui qui maintiendra votre code est un psychopathe qui connait votre adresse :axe:
Petit nouveau ! | 6 Messages

20 avr. 2008, 09:46

Oui c'est vrai je suis en train de tout bidouiller les code de PunBB.

J'ai seulement rajouter le code qui est entre les ligne 355 et 358.
Soit 
$sql = 'CREATE TABLE '.$forumid_prefix."page (id INT(10) NOT NULL auto_increment, 
title VARCHAR(75) NOT NULL, 
content TEXT NOT NULL, PRIMARY KEY (id) ENGINE=MyISAM;"; 
mysql_query($sql) or die(mysql_error_page_plugin);
Et depuis ça ne fonctionne plus ='(

Tout ce fait correctement, mais ça ne réussit pas à créer la table que j'ai rajouté après avoir bidouiller d'autre fonction. Voici le message : mysql_error_page_plugin
C'est seulement ça qui ne fonctionne pas. Mais tout ce fait de la même façon et ceci est fait de la même façon que tout le reste. DOnc je ne comprend pas pourquoi ça ne fonctionne pas !
Le fichier Activate.php qui cause problème : http://tonpunbb.fr.nf/activate.zip

Merci
Avatar du membre
Modérateur PHPfrance
Modérateur PHPfrance | 10684 Messages

20 avr. 2008, 10:23

Et c'est quoi ton mysql_error_page_plugin ?
- c'est une fonction à lquelle tu as oublié d'ajouter les parenthèses ?
- c'est une chaine que tu n'as pas délimité par des apostrophes ou des guillemets ?
- c'est une constante que tu as oublié de déclarer ? (et qui est du coup interprétée comme une chaine)

Dans tous les cas, cela montre bien que le die() est utilisé, donc que ta requête SQL a échoué, donc qu'il y a une erreur dedans. A vue de nez, il y a déjà au moins un problème d'équilibre des parenthèses.... :)
Ce n'est pas en améliorant la bougie que l'on a inventé l'ampoule...
Petit nouveau ! | 6 Messages

20 avr. 2008, 23:22

Toute les requête sont comme celle-ci et fonctionne ! Donc je ne voit pas l'erreur !
quelqu'un peux trouver l'erreur s.v.p. ? Car ça met tout mon truc hors-service ! Soit plus de 250 Forum !
Avatar du membre
Modérateur PHPfrance
Modérateur PHPfrance | 10684 Messages

21 avr. 2008, 08:17

Curieusement, j'aurais plutôt tendance à faire confiance à php, et si toutes les autres requêtes fonctionnent sauf celle-ci, j'aurais tendance à dire que toutes tes autres requêtes ne sont pas comme celle-ci.

Si tu lis ma réponse précédente et que tu cherches un peu, tu verras que ta requête SQL est erronnée et ne peut pas fonctionner. Elle génère donc une erreur SQL.
Le mysql_query() renvoi donc une erreur et la fonction die() est exécutée. Cette fonction fait appel à un "truc" (constante, fonction, variable ? à toi de le déterminer et de corriger en conséquence) qui visiblement n'existe pas ou est mal déclaré et qui est du coup interprété comme une chaine de caractère, et qui t'affiche "mysql_error_page_plugin" en toutes lettres avant d'interrompre l'exécution.

Une fois ces deux erreurs corrigées, ton script devrait effectivement ressembler aux autres requêtes :roll:
Ce n'est pas en améliorant la bougie que l'on a inventé l'ampoule...
Petit nouveau ! | 6 Messages

22 avr. 2008, 02:14

Le seul problème c'est que je ne sais pas corriger des requête ! Je galère avec le MySql. Pourrait tu le corriger à ma place s.v.p.
Avatar du membre
Modérateur PHPfrance
Modérateur PHPfrance | 10684 Messages

22 avr. 2008, 08:28

Je pourrais, mais je doute que les corriger pour toi ne t'apprenne à corriger les requêtes ;)

Je t'ai indiqué le problème, ta requête comporte 4 parenthèses ouvrantes et seulement 3 fermantes. Elle ne devrait pas être trop compliquée à corriger celle là :)

Et en cadeau bonus un p'tit lien vers la doc et la syntaxe de create table :
http://dev.mysql.com/doc/refman/5.0/fr/ ... table.html

Quant au "mysql_error_page_plugin" n'ayant pas la moindre idée s'il s'agit d'une fonction, d'une constante ou d'une chaine, ça sera à toi de la rectifier dès que tu auras trouver ce que c'est, compris à quoi ca sert, et comment l'utiliser :)
Ce n'est pas en améliorant la bougie que l'on a inventé l'ampoule...
   Répondre
9 messages   •   Page 1 sur 1
   Outils de sujet