phpBB Sverige

Kod: Markera allt

Could not insert data into users table

DEBUG MODE

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_regip, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (221, 'matte', 1168867384, '202cb962ac59075b964b07152d234b70', 'mr_beer@hotmail.com', 'c2446232', '', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 1, 'D M d, Y g:i a', 'english', 3, 0, 1, 0, '1b5798dc')

Line : 637
File : usercp_register.php

Kod: Markera allt

630				else				
631				{				
632					$sql .= "1, '')";			
633				}				
634								
635				if ( !($result = $db->sql_query($sql, BEGIN_TRANSACTION)) )				
636				{				
637					message_die(GENERAL_ERROR, 'Could not insert data into users table', '', __LINE__, __FILE__, $sql);			
638				}				
639								
640				$sql = "INSERT INTO " . GROUPS_TABLE . " (group_name, group_description, group_single_user, group_moderator)				
641					VALUES ('', 'Personal User', 1, 0)";			
642				if ( !($result = $db->sql_query($sql)) )				
643				{				
644					message_die(GENERAL_ERROR, 'Could not insert data into groups table', '', __LINE__, __FILE__, $sql);			
645				}				
646								
647				$group_id = $db->sql_nextid();				
648								
649				$sql = "INSERT INTO " . USER_GROUP_TABLE . " (user_id, group_id, user_pending)				

Kod: Markera allt

<?php 
/*************************************************************************** 
*                               db_update.php 
*                            ------------------- 
* 
*   copyright            : ©2003 Freakin' Booty ;-P & Antony Bailey 
* 
***************************************************************************/ 

/*************************************************************************** 
* 
*   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[] = "ALTER TABLE " . $table_prefix . "users ADD user_inactive_emls TINYINT( 1 ) NOT NULL"; 
$sql[] = "ALTER TABLE " . $table_prefix . "users ADD user_inactive_last_eml INT( 11 ) NOT NULL"; 
$sql[] = "INSERT INTO " . $table_prefix . "config (config_name, config_value) VALUES ('removed_users', '0')";

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>'; 

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

?>

Kod: Markera allt

############################################################## 
## MOD Title: Inactive Users
## MOD Author: Sko22 < sko22@quellicheilpc.it > (N/A) http://www.quellicheilpc.it/
## MOD Description: Checks how many users who have never been activated, or 
## have 0 messages it makes you choose whether to contact them or to delete them
## MOD Version: 1.1.8 
##
## Installation Level: Easy 
## Installation Time: 5 Minutes 
## Files To Edit: 
##			language/lang_english/lang_admin.php
##			admin/admin_users.php
## Included Files: 
##			admin/admin_users_inactive.php
##			templates/subSilver/admin/user_inactive_body.tpl
##			language/lang_english/email/user_inactive_contact.tpl
##			language/lang_english/email/user_inactive_delete.tpl
############################################################## 
## For Security Purposes, Please Check: http://www.phpbb.com/mods/ for the 
## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 
## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 
## in our MOD-Database, located at: http://www.phpbb.com/mods/ 
##############################################################
## Author Notes: 
## I have tested this MOD whit phpBB 2.0.10 and MySQL Database 3.23.56
## This MOD work only if in "Enable account activation" you have selected "User" or "Admin".
##
## Future versions can be found at http://www.quellicheilpc.it
## I've set up a support forum for my mods at http://www.quellicheilpc.it/forum
##
## This MOD is released under the GPL License. 
## Intellectual Property is retained by the MOD Author(s) listed above 
## Copyright:      ©2003 Inactive Users 1.1.8 - Sko22
############################################################## 
## MOD History: 
##
##   2005-03-13 - Version 1.1.8
##	- Added a tracer for removed users
##   2004-08-08 - Version 1.1.7
##	- Added links to select checkboxs in just one click
##   2004-06-13 - Version 1.1.6
##	- Added a minipanel to show user whit zero messages
##	- Added user last login in the panel (Tanks to wanted)
##   2004-06-10 - Version 1.1.5
##	- Added Users whit zero messages
##   2004-02-27 - Version 1.1.4
##	- Added colors past days
##   2003-10-21 - Version 1.1.3
##	- Added edit profile users
##   2003-10-21 - Version 1.1.2
##	- Fixed bug with activation link (Tanks to rocco)
##	- Fixed bug with installer
##	- Fixed bug whith delete users
##   2003-09-19 - Version 1.1.1
##	- Added email link to see user email, fixed bugs with  Mozilla 1.0.1 on Linux (Tanks to Adam Paquet)
##   2003-09-18 - Version 1.1.0
##	- Added Activate button and the Last Email Sent Date in the panel
##   2003-09-16 - Version 1.0.0
##	- Initial Release
############################################################## 
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 
############################################################## 

#
#-----[ COPY ]------------------------------------------
#

copy admin_users_inactive.php to admin/admin_users_inactive.php
copy user_inactive_body.tpl to templates/subSilver/admin/user_inactive_body.tpl
copy user_inactive_contact.tpl to language/lang_english/email/user_inactive_contact.tpl
copy user_inactive_delete.tpl to language/lang_english/email/user_inactive_delete.tpl

# 
#-----[ SQL ]------------------------------------------ 
# 
#   If you don't know how to execute sql queries, then copy
#   mysql_install.php into your phpbb directory and run it.
#   (assuming you use mysql)
#   After process delete it.
#
#   If you don't use mysql, you'll have to edit these queries accordingly
# 
#   If you have a different table prefix then change this command accordingly. 
#   I have used the default table prefix! 
# 

ALTER TABLE phpbb_users ADD user_inactive_emls TINYINT( 1 ) NOT NULL ;
ALTER TABLE phpbb_users ADD user_inactive_last_eml INT( 11 ) NOT NULL ;
INSERT INTO phpbb_config (config_name, config_value) VALUES ('removed_users', '0') ;

# 
#-----[ OPEN ]------------------------------------------ 
#

admin/admin_users.php

# 
#-----[ FIND ]------------------------------------------ 
# 

//
// Begin program
//

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

// 
// Set username
// 
if( isset( $HTTP_GET_VARS['username'] ) )
{
	$HTTP_POST_VARS['username'] = $HTTP_GET_VARS['username'];
}

# 
#-----[ OPEN ]------------------------------------------ 
#

language/lang_english/lang_admin.php

# 
#-----[ FIND ]------------------------------------------ 
# 

//
// That's all Folks!
// -------------------------------------------------

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
#

//Beginning Inactive Users

$lang['Users_Inactive'] = 'Inactive Users';
$lang['Users_Inactive_Explain'] = 'If in "Enable account activation" you have selected "User" or "Admin", in this list you will have the Users who have never been activated.<br /><br />By clicking on "Contact" you will send a contact e-mail to all the selected Users.<br />By clicking on "Activate" you will activate all the selected Users.<br />By clicking on "Delete" you will send an e-mail and delete all the selected Users.';
$lang['UI_Check_None'] = '"Enable account activation" is on <b>None</b>.';
$lang['UI_Check_User'] = '"Enable account activation" is on <b>User</b>';
$lang['UI_Check_Admin'] = '"Enable account activation" is on <b>Admin</b>.';
$lang['UI_Check_Recom'] = '%sChange it%s.';
$lang['UI_Removed_Users'] = 'Removed Users';
$lang['UI_User'] = 'User';
$lang['UI_Registration_Date'] = 'Registration Date';
$lang['UI_Last_Visit'] = 'Last Visit';
$lang['UI_Active'] = 'Active';
$lang['UI_Email_Sents'] = 'Email Sents';
$lang['UI_Last_Email_Sents'] = 'Last Email';
$lang['UI_CheckColor'] = 'Check';
$lang['UI_CheckAll'] = 'Check All';
$lang['UI_UncheckAll'] = 'Uncheck All';
$lang['UI_InvertChecked'] = 'Invert Checked';
$lang['UI_Contact_Users'] = 'Contact';
$lang['UI_Delete_Users'] = 'Delete';
$lang['UI_Activate_Users'] = 'Activate';
$lang['UI_select_user_first'] = 'You must to select a User before';
$lang['UI_return'] = 'Click %sHere%s to return to the Inactive Users';
$lang['UI_Deleted_Users'] = 'The Users has been removed';
$lang['UI_Activated_Users'] = 'The Users has been actived';
$lang['UI_Alert_Days'] = "days";
$lang['UI_with_zero_messages'] = "with zero messages";
$lang['UI_Alert_Every'] = "Every";
$lang['UI_Alert_UpTo'] = "Up to";
$lang['UI_Alert_Over'] = "Over";

//End Inactive Users

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM