phpBB.nl

Code: Selecteer alles

## Protecting directory
#########################
##
## Protect "media/" by .htaccess.
## Otherwise the mod would not make any sense...
##
########################



## Creating table
#########################
##
## Name:	"phpbb_downloads"
## Fields:	"id" int(11) auto_increment, primary key
##		"description" varchar(255)
##		"file_name" varchar(255)
##		"klicks" int(11), Standard "0"
##		"free" tinyint(1), Standard "0"
##		"extern" tinyint(1), Standard "0"
##		"long_desc" text
##		"sort" int(11), Standard "0"
##
########################



## Modifying table "phpbb_users"
#########################
##
## New column:	"user_traffic" int(255) Standard: "0"
##
########################

Code: Selecteer alles

General Error 
  
Could not query users

DEBUG MODE

SQL Error : 1146 Table 'x-planet_nl_1.phpbb_downloads' doesn't exist

SELECT * FROM phpbb_downloads ORDER by sort

Line : 75
File : /data/members/paid/x/-/x-planet.nl/htdocs/www/phpBB2/downloads.php 
 

Code: Selecteer alles

CREATE TABLE phpbb_downloads(
id int(11) NOT NULL auto_increment,
description varchar(255) NOT NULL ,
file_name varchar(255) NOT NULL ,
klicks int(11) default NULL ,
free tinyint(1) default NULL ,
extern tinyint(1) default NULL ,
long_desc text NOT NULL ,
sort int(11) default NULL ,
PRIMARY KEY (id) 
) TYPE = MyISAM;

ALTER TABLE phpbb_users ADD user_traffic int(255) default NULL;