Download mod ... SQL

[Michaa112]

Ok nu ben ik bezig met de download mod/

Nu kom ik dit tegen:

## 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"
##
########################


Maar ik snap niet hoe je dat doet.
Wie kan goed uitleggen hoe ik alles doe?

[Spikey]

Het principe is dat je de tekst kopieert en plakt in een "query-box" via phpMyAdmin en dan op "go/start" klikt, daarna wacht je op een bevestiging of het goed is gegaan, maar zo als het hierboven staat gaat dat niet lukken.

Voorbeeld:




Geef even een link naar de mod of plaats de gehele install.txt hier (als dit niet te groot is !!).

[Michaa112]

Hij is niet te groot denk ik.

Code: Selecteer alles

########################################################
## Mod title:		   DlMod
## mod version: 	   2.0.1
## phpBB- version:	   2.0.x
## Datum:		   01.01.2003/20:48
## Autor:   	   	   Hotschi
## Beschreibung:           This Mod generates a page for downloads.
##                         Every user get an account, on which the admin may credit him a sum of "traffic".
##			   The filesize of the downloads he made will be deducted from this account. If the user
##			   have not longer got "traffic", he will not be able to get the file.
##			   An additional function allows the admin to define a download as "free", so that everybody
##			   could get it.
##                         The mod is completely integrated in phpBB and the administration happens via ACP.
## Severity
## of the installation:    easy
## Needed time:		   about 15 minutes
## Modified files:	   includes/page_header.php
##			   includes/constants.php
##			   templates/subSilver/overall_header.tpl
##			   templates/subSilver/subSilver.cfg
##			   language/lang_german/lang_main.php
##			   language/lang_german/lang_admin.php
##			   viewonline.php
##			   admin/index.php
## Additional Files:       admin/admin_dl_files.php
##			   admin/admin_dl_traffic_all_users.php
##			   admin/admin_dl_traffic_single_user.php
##			   templates/subSilver/admin/dl_files_body.tpl
##			   templates/subSilver/admin/dl_files_edit_body.tpl
##			   templates/subSilver/admin/dl_traffic_all_users_body.tpl
##			   templates/subSilver/admin/dl_traffic_single_user_body.tpl
##			   templates/subSilver/downloads_body.tpl
##			   templates/subSilver/images/icon_mini_d.gif
##			   templates/subSilver/images/dl_green.gif
##			   templates/subSilver/images/dl_red.gif
##			   templates/subSilver/images/dl_yellow.gif
##			   templates/subSilver/images/dl_grey.gif
##			   downloads.php
##			   load.php
########################################################
##
## Contact:                Hotschi
## Homepage:		   http://phpBB.hotschi.de
## E- Mail:                webmaster@phpBB.hotschi.de
## ICQ-UIN:                125472412
##
########################################################
##
## The files icon_mini_d.gif
##	     dl_green.gif
##	     dl_red.gif
##	     dl_yellow.gif
##	     dl_grey.gif
## are taken from http://www.forumimages.com.
##
########################################################
##
## Comments are welcome!
##
########################################################



## Uploading Files
#########################
##
## Upload all files and directories into "phpBB2/".
##
########################



## 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"
##
########################



# Find in includes/page_header.php
#########################

	'L_USERGROUPS' => $lang['Usergroups'], 

########################



# After add:
########################

	'L_DOWNLOADS' => $lang['Downloads'], 

########################



# Find in includes/page_header.php
#########################

	'U_GROUP_CP' => append_sid('groupcp.'.$phpEx),

########################



# After add:
########################

	'U_DOWNLOADS' => append_sid('downloads.'.$phpEx),

########################



# Find in templates/SubSilver/overall_header.tpl
#########################

					<tr>
						<td height="25" align="center" valign="top" nowrap="nowrap"><span class="mainmenu">&<a href="{U_PROFILE}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_profile.gif" width="12" height="13" border="0" alt="{L_PROFILE}" hspace="3" />{L_PROFILE}</a>& &<a href="{U_PRIVATEMSGS}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_message.gif" width="12" height="13" border="0" alt="{PRIVATE_MESSAGE_INFO}" hspace="3" />{PRIVATE_MESSAGE_INFO}</a>& &<a href="{U_LOGIN_LOGOUT}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_login.gif" width="12" height="13" border="0" alt="{L_LOGIN_LOGOUT}" hspace="3" />{L_LOGIN_LOGOUT}</a>&</span></td>
					</tr>

########################



# After add:
########################

					<tr>
						<td height="25" align="center" valign="top" nowrap="nowrap"><span class="mainmenu">&<a href="{U_DOWNLOADS}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_d.gif" width="13" height="13" border="0" alt="{L_DOWNLOADS}" hspace="3" />{L_DOWNLOADS}</a>&</span></td>
					</tr>

########################



# Find in viewonline.php
#########################

				case PAGE_FAQ:
					$location = $lang['Viewing_FAQ'];
					$location_url = "faq.$phpEx";
					break;

########################



# After add:
########################

				case PAGE_DOWNLOADS:
					$location = $lang['downloads'];
					$location_url = "downloads.$phpEx";
					break;

########################



# Find in admin/index.php
#########################

						case PAGE_FAQ:
							$location = $lang['Viewing_FAQ'];
							$location_url = "index.$phpEx?pane=right";
							break;

########################



# After add:
########################

						case PAGE_DOWNLOADS:
							$location = $lang['downloads'];
							$location_url = "downloads.$phpEx?pane=right";
							break;

########################



# Find in admin/index.php
#########################

					case PAGE_FAQ:
						$location = $lang['Viewing_FAQ'];
						$location_url = "index.$phpEx?pane=right";
						break;

########################



# After add:
########################

					case PAGE_FAQ:
						$location = $lang['downloads'];
						$location_url = "downloads.$phpEx?pane=right";
						break;

########################

//HIER BEN IK

# Find in includes/constants.php
#########################

define('PAGE_GROUPCP', -11);

########################



# After add:
########################

define('PAGE_DOWNLOADS', -12);

########################



# Find in includes/constants.php
#########################

define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

########################



# After add:
########################

define('DOWNLOADS_TABLE',  $table_prefix.'downloads');

########################



# Find in templates/subSilver/subSilver.cfg
#########################

$images['voting_graphic'][4] = "$current_template_images/voting_bar.gif";

########################



# After add:
########################

$images['Dl_grey'] = "$current_template_images/dl_grey.gif";
$images['Dl_red'] = "$current_template_images/dl_red.gif";
$images['Dl_green'] = "$current_template_images/dl_green.gif";
$images['Dl_yellow'] = "$current_template_images/dl_yellow.gif";

########################



# Add somewhere in language/lang_english/lang_main.php:
########################

//
// Anfang: DlMod
//
$lang['Dl_klicks'] = "Clicks";
$lang['Downloads'] = "Downloads";
$lang['Dl_download'] = "Download";
$lang['Traffic'] = "Traffic";
$lang['Dl_file_size'] = "Size";
$lang['Dl_file_name'] = "File";
$lang['Dl_file_description'] = "Description";
$lang['Dl_account'] = "Account";
$lang['Dl_free'] = "Free Download";
$lang['Dl_detail'] = "Details";
$lang['Dl_info'] = "Info";
$lang['Dl_i'] = "i";
$lang['Dl_name'] = "Name";
$lang['Dl_not_availible'] = "not availible";
$lang['Dl_green_explain'] = "Download! No deductions from user account.";
$lang['Dl_red_explain'] = "Not enough traffic.";
$lang['Dl_yellow_explain'] = "Download! Traffic will be deducted from user account.";
$lang['Dl_grey_explain'] = "Download! External source. No deductions from user account.";
//
// Ende: DlMod
//

########################



# Füge ein in language/lang_english/lang_admin.php:
########################

//
// Begin: DlMod
//
$lang['Traffic_single_user_admin_explain'] = "Here you can modify the Traffic for a single user.";
$lang['Traffic_all_users_admin_explain'] = "Here you can modify the Traffic for all users.";
$lang['Single_user_traffic_title'] = "Traffic for single user";
$lang['All_users_traffic_title'] = "Traffic for all users";
$lang['Dl_files_title'] = "Files";
$lang['Dl_files_explain'] = "Upload the file with your FTP- Client into the Download- directory and specify the path here.";
$lang['Dl_files_url'] = "URL";
$lang['Dl_files_url_explain'] = "According to the Download- directory.";
$lang['Download_updated'] = "The informations were updated";
$lang['Download_added'] = "The Download is added";
$lang['Download_removed'] = "The Download is deleted";
$lang['Click_return_downloadadmin'] = "Click %shere%s to return to the Downloads- administration.";
$lang['Click_return_user_traffic_admin'] = "Click %shere%s to modify the Traffic of another user.";
$lang['Must_select_download'] = "Choose a Download.";
$lang['Dl_function'] = "Funktion";
$lang['Add_new_download'] = "Add new Download";
$lang['Dl_add'] = "Add";
$lang['Dl_set'] = "Set";
$lang['Traffic_now'] = "At present on account";
$lang['Dl_is_free'] = "free";
$lang['Dl_yes'] = "Yes";
$lang['Dl_no'] = "No";
$lang['DL_free_explain'] = "Activate this funktion if the Download should be able for everybody. The accounts will not be used.";
$lang['Dl_order'] = "Sort";
$lang['Dl_up'] = "up";
$lang['Dl_down'] = "down";
$lang['Dl_extern'] = "Extern";
$lang['Dl_extern_explain'] = "Activate this funktion for remote files (http://www.example.com/media.mp3). Funktion 'Free' becomes irrelevant.";
//
// End: DlMod
//

########################

Ik heb verder alles gedaan.
Alleen dat sql snap ik niet

[Spikey]

Maak eerst een backup van de DB met phpMyAdmin, structuur en data.

Plak onderstaande code in de query-box van phpMyAdmin en wacht op de bevestiging of alles goed is gegaan:

Code: Selecteer alles

DROP TABLE IF EXISTS `phpbb_downloads`;
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 '0' NOT NULL , 
free TINYINT( 1 ) DEFAULT '0' NOT NULL ,
extern TINYINT( 1 ) DEFAULT '0' NOT NULL , 
long_desc TEXT NOT NULL , 
sort INT( 11 ) DEFAULT '0' NOT NULL , 
PRIMARY KEY ( `id` ) 
); 



ALTER TABLE phpbb_users
ADD user_traffic int(255) DEFAULT '0' NOT NULL