Pagina 1 van 1
Download mod ... SQL
Geplaatst: 12 mei 2003, 15:18
door 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?
Geplaatst: 12 mei 2003, 15:33
door 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 !!).
Geplaatst: 12 mei 2003, 15:36
door 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
Geplaatst: 12 mei 2003, 20:38
door 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