phpBB.nl

Code: Selecteer alles

INSERT INTO phpbb_wpm VALUES ('wpm_version', '1.0.9');
INSERT INTO phpbb_wpm VALUES ('active_wpm', '1');
INSERT INTO phpbb_wpm VALUES ('wpm_username', 'Anonymous');
INSERT INTO phpbb_wpm VALUES ('wpm_userid', '-1');
INSERT INTO phpbb_wpm VALUES ('wpm_subject', 'Welcome to [sitename]!');
INSERT INTO phpbb_wpm VALUES ('wpm_message', 'Hi, there [username]!
I hope you enjoy your stay here at [sitename]!
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!');

Code: Selecteer alles

Er schijnt een fout te zijn in uw SQL query. Mocht de MySQL server een error hebben terug gegeven, probeer dan of uw hiermee uw fout kunt oplossen.

ERROR: Quote niet afgesloten @ 46
STR: '
SQL: 
INSERT INTO phpbb_wpm VALUES ('wpm_message', 'Hi, there [username]!


SQL-query:

INSERT INTO phpbb_wpm VALUES ('wpm_message', 'Hi, there [username]!

MySQL retourneerde: Documentatie
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''Hi, there [username]!' at line 1

Code: Selecteer alles

DEBUG MODE

SQL Error : 1054 Unknown column 'name' in 'where clause'

UPDATE phpbb_wpm SET value = '0' WHERE name = 'active_wpm'

Line : 54
File : admin_wpm.php

Code: Selecteer alles

SQL-query:

-- phpMyAdmin SQL Dump
-- version 2.8.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: srv12.uniserver.nl
-- Generatie Tijd: 28 Jul 2006 om 11:28
-- Server versie: 4.1.10
-- PHP Versie: 4.4.2
-- 
-- 
CREATE DATABASE  DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;

MySQL retourneerde: Documentatie
#1007 - Can't create database '; database exists 

Code: Selecteer alles

#-----[ SQL ]------------------------------------------
#

ALTER TABLE phpbb_users ADD user_welpm tinyint(1) NOT NULL default '0';
UPDATE phpbb_users SET user_welpm=1;

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_welpm tinyint(1) NOT NULL default '0'; 
UPDATE phpbb_users SET user_welpm=1; 

Code: Selecteer alles

DEBUG MODE

SQL Error : 1054 Unknown column 'name' in 'where clause'

UPDATE phpbb_wpm SET value = '1' WHERE name = 'active_wpm'

Line : 54
File : admin_wpm.php

Code: Selecteer alles

Parse error: parse error, unexpected T_IF in -/forum/includes/usercp_register.php on line 37

Code: Selecteer alles

if ( !defined('IN_PHPBB') )

Code: Selecteer alles

<?php// This file modified for Welcome PM on First Login 1.0.3
/***************************************************************************
 *                            usercp_register.php
 *                            -------------------
 *   begin                : Saturday, Feb 13, 2001
 *   copyright            : (C) 2001 The phpBB Group
 *   email                : support@phpbb.com
 *
 *   $Id: usercp_register.php,v 1.20.2.76 2006/05/30 19:29:43 grahamje Exp $
 *
 *
 ***************************************************************************/

/***************************************************************************
 *
 *   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.
 *
 *
 ***************************************************************************/

/*

	This code has been modified from its original form by psoTFX @ phpbb.com
	Changes introduce the back-ported phpBB 2.2 visual confirmation code. 

	NOTE: Anyone using the modified code contained within this script MUST include
	a relevant message such as this in usercp_register.php ... failure to do so 
	will affect a breach of Section 2a of the GPL and our copyright

	png visual confirmation system : (c) phpBB Group, 2003 : All Rights Reserved

*/

if ( !defined('IN_PHPBB') )
{
	die("Hacking attempt");
	exit;
}

$unhtml_specialchars_match = array('#>#', '#<#', '#"#', '#&#');
$unhtml_specialchars_replace = array('>', '<', '"', '&');

// ---------------------------------------
// Load agreement template since user has not yet
// agreed to registration conditions/coppa
//
function show_coppa()
{
	global $userdata, $template, $lang, $phpbb_root_path, $phpEx;

	$template->set_filenames(array(
		'body' => 'agreement.tpl')
	);

	$template->assign_vars(array(
		'REGISTRATION' => $lang['Registration'],
		'AGREEMENT' => $lang['Reg_agreement'],
		"AGREE_OVER_13" => $lang['Agree_over_13'],
		"AGREE_UNDER_13" => $lang['Agree_under_13'],
		'DO_NOT_AGREE' => $lang['Agree_not'],

		"U_AGREE_OVER13" => append_sid("profile.$phpEx?mode=register&agreed=true"),
		"U_AGREE_UNDER13" => append_sid("profile.$phpEx?mode=register&agreed=true&coppa=true"))
	);

	$template->pparse('body');

}
//
// ---------------------------------------

Code: Selecteer alles

<?php//

Code: Selecteer alles

<?php //

Code: Selecteer alles

				wpm_send_pm($user_id, $wpm_subject, $wpm_message, 0);
				}
			}
			// END wpm mod
			//*/

/* Above line marks the end of disabling of the Original WPM Code. */
//
// Welcome PM on First Login - End Code Alteration
//------------------------------------------------------------------------------


#

/* Above line marks the end of disabling of the Original WPM Code. */
//
// Welcome PM on First Login - End Code Alteration
//

message = $message . '<br /><br />' . sprintf($lang['Click_return_index'],  '<a href="' . append_sid("index.$phpEx") . '">', '</a>');

			message_die(GENERAL_MESSAGE, $message);
		} // if mode == register
	}
} // End of submit


if ( $error )
{
	//
	// If an error occured we need to stripslashes on returned data
	//
	$username = stripslashes($username);
	$email = stripslashes($email);
	$cur_password = '';
	$new_password = '';
	$password_confirm = '';

	$icq = stripslashes($icq);
	$aim = str_replace('+', ' ', stripslashes($aim));
	$msn = stripslashes($msn);
	$yim = stripslashes($yim);

	$website = stripslashes($website);
	$location = stripslashes($location);
	$occupation = stripslashes($occupation);
	$interests = stripslashes($interests);
	$signature = stripslashes($signature);
	$signature = ($signature_bbcode_uid != '') ? preg_replace("/:(([a-z0-9]+:)?)$signature_bbcode_uid(=|\])/si", '\\3', $signature) : $signature;

	$user_lang = stripslashes($user_lang);
	$user_dateformat = stripslashes($user_dateformat);

}
else if ( $mode == 'editprofile' && !isset($HTTP_POST_VARS['avatargallery']) && !isset($HTTP_POST_VARS['submitavatar']) && !isset($HTTP_POST_VARS['cancelavatar']) )
{
	$user_id = $userdata['user_id'];
	$username = $userdata['username'];
	$email = $userdata['user_email'];
	$cur_password = '';
	$new_password = '';
	$password_confirm = '';

	$icq = $userdata['user_icq'];
	$aim = str_replace('+', ' ', $userdata['user_aim']);
	$msn = $userdata['user_msnm'];
	$yim = $userdata['user_yim'];

	$website = $userdata['user_website'];
	$location = $userdata['user_from'];
	$occupation = $userdata['user_occ'];
	$interests = $userdata['user_interests'];
	$signature_bbcode_uid = $userdata['user_sig_bbcode_uid'];
	$signature = ($signature_bbcode_uid != '') ? preg_replace("/:(([a-z0-9]+:)?)$signature_bbcode_uid(=|\])/si", '\\3', $userdata['user_sig']) : $userdata['user_sig'];

	$viewemail = $userdata['user_viewemail'];
	$notifypm = $userdata['user_notify_pm'];
	$popup_pm = $userdata['user_popup_pm'];
	$notifyreply = $userdata['user_notify'];
	$attachsig = $userdata['user_attachsig'];
	$allowhtml = $userdata['user_allowhtml'];
	$allowbbcode = $userdata['user_allowbbcode'];
	$allowsmilies = $userdata['user_allowsmile'];
	$allowviewonline = $userdata['user_allow_viewonline'];

	$user_avatar = ( $userdata['user_allowavatar'] ) ? $userdata['user_avatar'] : '';
	$user_avatar_type = ( $userdata['user_allowavatar'] ) ? $userdata['user_avatar_type'] : USER_AVATAR_NONE;

	$user_style = $userdata['user_style'];
	$user_lang = $userdata['user_lang'];
	$user_timezone = $userdata['user_timezone'];
	$user_dateformat = $userdata['user_dateformat'];
}