profileview problem
-----
| Author | Message | |
|---|---|---|
|
assiejack |
||
| Sun Jan 14, 2007 4:19 pm Post subject: profileview problem | ||
|
Ok i now have a problem and not sure where to post as looked all over the net and got no where so thought you may be able to help.
I am using the valut mod now all is working as it should so im not asking for mod help as such,, all i want is for the vault stats to show where they are meant to in the profile_view_body.tpl I have added the code as directed in the install but it does not show on my profile. Edit in install Code: ##############################################################
## MOD Title: Vault ## MOD Author: Dr DLP < > ( Malicious Rabbit ) http://www.lapin-malin.com ## MOD Description: A vault system for your forum ## ## MOD Version: 1.0.0 ## ## Installation Level: Easy ## Installation Time: 20 minutes ( 1 minute with easymod ) ## ## Files To Edit: ## common.php ## viewtopic.php ## admin/admin_users.php ## includes/page_header.php ## includes/usercp_viewprofile.php ## language/lang_english/lang_admin.php ## templates/subSilver/overall_header.tpl ## templates/subSilver/profile_view_body.tpl ## templates/subSilver/viewtopic_body.tpl ## ## Included Files: ## vault.php ## vault_db_update.php ( only needed for installation ) ## admin/admin_vault_exchange.php ## admin/admin_vault_general.php ## admin/admin_vault_users.php ## cache/config_vault.php ## cache/config_vault_def.php ## includes/functions_vault.php ## language/lang_english/lang_vault.php ## templates/subSilver/vault_body.tpl ## templates/subSilver/vault_exchange_body.tpl ## templates/subSilver/vault_list_body.tpl ## templates/subSilver/vault_preferences_body.tpl ## templates/subSilver/admin/config_vault_exchange_body.tpl ## templates/subSilver/admin/config_vault_exchange_add_body.tpl ## templates/subSilver/admin/config_vault_general_body.tpl ## templates/subSilver/admin/config_vault_users_body.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: ## ## Thanks to Ptirhiik for having learned me how to make such mods , and thanks to Zarath for his great mods too . ## This mod is based on the Zarath's mod : Bank Mod . ## ## Don't forget you have to first install a point system . ## ## /!\ You have to make a CHMOD 666 on the file cache/config_vault.php /!\ ## ( Cache system made by Ptrihiik ) ## ############################################################## ## MOD History: ## ## Version 1.0.0 ( 26/02/04 ) ## Fix the view into profile and topics ## Add the ability to have points at the opening of the account ## ## Version 0.9.0 ( 21/02/04 ) ## Fix the bug that allows to buy shares for free ## Fix the bug of the small value share never increasing ## Add the user informations into profile and topics ## ## Version 0.5.0 ( 12/01/04 ) ## First public release ## ############################################################## ## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD ############################################################ # #--------------[ SQL ]------------- # # Upload , run then delete the file vault_db_update.php - Don't forget you have to first modify your files ! # Or run the following SQL requests : # INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_enable', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_name', 'Vault'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_use', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_time', '86400'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('stock_last_change', '0'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_display_profile', '1'); INSERT INTO phpbb_config (config_name, config_value) VALUES ('vault_display_topics', '0'); CREATE TABLE phpbb_vault_blacklist ( user_id int(8) NOT NULL default '0', user_due int(8) NOT NULL default '0', PRIMARY KEY (user_id) ) TYPE=MyISAM; CREATE TABLE phpbb_vault_exchange ( stock_id int(8) NOT NULL default '0', stock_name varchar(40) NOT NULL default '', stock_desc varchar(255) NOT NULL default '', stock_price int(8) NOT NULL default '0', stock_previous_price int(8) NOT NULL default '0', stock_best_price int(8) NOT NULL default '0', stock_worst_price int(8) NOT NULL default '0', PRIMARY KEY (stock_id) ) TYPE=MyISAM; INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (1, 'Vault_action_name_1', 'Vault_action_desc_1', 100, 100, 100, 100); INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (2, 'Vault_action_name_2', 'Vault_action_desc_2', 200, 200, 200, 200); INSERT INTO phpbb_vault_exchange (stock_id, stock_name, stock_desc, stock_price, stock_previous_price, stock_best_price, stock_worst_price) VALUES (3, 'Vault_action_name_3', 'Vault_action_desc_3', 300, 300, 300, 300); CREATE TABLE phpbb_vault_exchange_users ( stock_id mediumint(8) NOT NULL default '0', user_id mediumint(8) NOT NULL default '0', stock_amount mediumint(8) NOT NULL default '0', KEY stock_id (stock_id), KEY user_id (user_id) ) TYPE=MyISAM; CREATE TABLE phpbb_vault_general ( config_name varchar(255) NOT NULL default '', config_value int(15) NOT NULL default '0', PRIMARY KEY (config_name) ) TYPE=MyISAM; INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('vault_loan_enable', 1); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('interests_rate', 4); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('interests_time', 86400); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_interests', 15); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_interests_time', 864000); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_max_sum', 5000); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('loan_requirements', 0); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('stock_max_change', 10); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('stock_min_change', 0); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('base_amount', 10); INSERT INTO phpbb_vault_general (config_name, config_value) VALUES ('num_items', 30); CREATE TABLE phpbb_vault_users ( owner_id int(8) NOT NULL default '0', account_id int(8) NOT NULL default '0', account_sum int(8) NOT NULL default '0', account_time int(11) NOT NULL default '0', loan_sum int(8) NOT NULL default '0', loan_time int(11) NOT NULL default '0', account_protect tinyint(1) NOT NULL default '0', loan_protect tinyint(1) NOT NULL default '0', newsletter tinyint(1) NOT NULL default '0', PRIMARY KEY (owner_id) ) TYPE=MyISAM; # #--------------[ COPY ]------------- # copy root/vault.php to vault.php copy root/vault_db_update.php to vault_db_update.php copy root/admin/admin_vault_exchange.php to admin/admin_vault_exchange.php copy root/admin/admin_vault_general.php to admin/admin_vault_general.php copy root/admin/admin_vault_users.php to admin/admin_vault_users.php copy root/cache/vault_config.php to cache/vault_config.php copy root/cache/vault_config_def.tpl to cache/vault_config_def.tpl copy root/includes/functions_vault.php to includes/functions_vault.php copy root/language/lang_english/lang_vault.php to language/lang_english/lang_vault.php copy root/templates/subSilver/vault_body.tpl to templates/subSilver/vault_body.tpl copy root/templates/subSilver/vault_exchange_body.tpl to templates/subSilver/vault_exchange_body.tpl copy root/templates/subSilver/vault_list_body.tpl to templates/subSilver/vault_list_body.tpl copy root/templates/subSilver/vault_preferences_body.tpl to templates/subSilver/vault_preferences_body.tpl copy root/templates/subSilver/admin/config_vault_exchange_body.tpl to templates/subSilver/admin/config_vault_exchange_body.tpl copy root/templates/subSilver/admin/config_vault_exchange_add_body.tpl to templates/subSilver/admin/config_vault_exchange_add_body.tpl copy root/templates/subSilver/admin/config_vault_general_body.tpl to templates/subSilver/admin/config_vault_general_body.tpl copy root/templates/subSilver/admin/config_vault_users_body.tpl to templates/subSilver/admin/config_vault_users_body.tpl # #-----[ OPEN ]------------------------------------------ # common.php # #-----[ FIND ]------------------------------------------ # ?> # #-----[ BEFORE, ADD ]------------------------------------------ # include_once($phpbb_root_path . 'includes/functions_vault.'.$phpEx); # #-----[ OPEN ]------------------------------------------ # viewtopic.php # #-----[ FIND ]------------------------------------------ # $search = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>'; # #-----[ AFTER, ADD ]------------------------------------------ # if ( $board_config['vault_display_topics'] ) { $sql = " SELECT * FROM " . VAULT_USERS_TABLE . " WHERE owner_id = $poster_id "; if( !($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql); } $shares = $db->sql_fetchrow($result); $share = '<br />'.$lang['Vault_on_account'].(( $shares['account_protect'] && $userdata['user_level'] != ADMIN ) ? $lang['Vault_confidential'] : intval($shares['account_sum']).' '.$board_config['points_name']); $share .= '<br />'.$lang['Vault_loan_account'].(( $shares['loan_protect'] && $userdata['user_level'] != ADMIN ) ? $lang['Vault_confidential'] : intval($shares['loan_sum']).' '.$board_config['points_name']); } # #-----[ FIND ]------------------------------------------ # 'SEARCH' => $search, # #-----[ AFTER, ADD ]------------------------------------------ # 'POSTER_VAULT' => $share, # #-----[ OPEN ]------------------------------------------ # admin/admin_users.php # #-----[ FIND ]------------------------------------------ # $sql = "SELECT privmsgs_id # #-----[ BEFORE, ADD ]------------------------------------------ # $sql = "DELETE FROM " . VAULT_USERS_TABLE . " WHERE owner_id = $user_id"; if( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not delete user from vault table', '', __LINE__, __FILE__, $sql); } $sql = "DELETE FROM " . VAULT_EXCHANGE_USERS_TABLE . " WHERE user_id = $user_id"; if( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not delete user from user exchange table', '', __LINE__, __FILE__, $sql); } $sql = "DELETE FROM " . VAULT_BLACKLIST_TABLE . " WHERE user_id = $user_id"; if( !$db->sql_query($sql) ) { message_die(GENERAL_ERROR, 'Could not delete user from vault blacklist table', '', __LINE__, __FILE__, $sql); } # #-----[ OPEN ]------------------------------------------ # includes/page_header.php # #-----[ FIND ]------------------------------------------ # 'U_MEMBERLIST' => append_sid('memberlist.'.$phpEx), # #-----[ AFTER, ADD ]------------------------------------------ # 'U_VAULT' => append_sid('vault.'.$phpEx), 'L_VAULT' => $board_config['vault_name'], # #-----[ OPEN ]------------------------------------------ # includes/usercp_viewprofile.php # #-----[ FIND ]------------------------------------------ # $search = '<a href="' . $temp_url . '">' . $lang['Search_user_posts'] . '</a>'; # #-----[ AFTER, ADD ]------------------------------------------ # if ( $board_config['vault_display_profile'] ) { $template->assign_block_vars('display_shares',array()); $sql = " SELECT e.* , eu .* FROM " . VAULT_EXCHANGE_TABLE . " e LEFT JOIN " . VAULT_EXCHANGE_USERS_TABLE . " eu ON ( eu.user_id = " . $profiledata['user_id'] . " AND e.stock_id = eu.stock_id ) "; if( !($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql); } $shares = $db->sql_fetchrowset($result); for ( $i = 0 ; $i < count($shares) ; $i ++ ) { $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2']; $template->assign_block_vars('display_shares.shares' , array( 'SHARE_ROW' => $row_class, 'SHARE_NAME' => vault_get_lang($shares[$i]['stock_name']), 'SHARE_SUM' => intval($shares[$i]['stock_amount']), )); } $sql = " SELECT * FROM " . VAULT_USERS_TABLE . " WHERE owner_id = " . $profiledata['user_id']; if( !($result = $db->sql_query($sql))) { message_die(GENERAL_ERROR, 'Could not obtain accounts information', "", __LINE__, __FILE__, $sql); } $accounts = $db->sql_fetchrow($result); $on_account = ( $accounts['account_protect'] && $userdata['user_level'] != ADMIN && $accounts['owner_id'] != $userdata['user_id'] ) ? $lang['Vault_confidential'] : intval($accounts['account_sum']).' '.$board_config['points_name']; $loan = ( $accounts['loan_protect'] && $userdata['user_level'] != ADMIN && $accounts['owner_id'] != $userdata['user_id'] ) ? $lang['Vault_confidential'] : intval($accounts['loan_sum']).' '.$board_config['points_name']; } # #-----[ FIND ]------------------------------------------ # 'SEARCH' => $search, # #-----[ AFTER, ADD ]------------------------------------------ # 'L_ON_ACCOUNT' => $lang['Vault_on_account'], 'L_LOAN' => $lang['Vault_loan_account'], 'ON_ACCOUNT' => $on_account, 'LOAN' => $loan, # #-----[ OPEN ]------------------------------------------ # templates/subSilver/overall_header.tpl # #-----[ FIND ]------------------------------------------ # <td align="center" valign="top" nowrap="nowrap"> # #-----[ IN-LINE FIND ]------------------------------------------ # L_USERGROUPS}</a> # #-----[ IN-LINE AFTER, ADD ]------------------------------------------ # <a href="{U_VAULT}" class="mainmenu"><img src="templates/subSilver/images/icon_mini_members.gif" width="12" height="13" border="0" alt="{L_VAULT}" hspace="3" />{L_VAULT}</a> # #-----[ OPEN ]------------------------------------------ # templates/subSilver/profile_view_body.tpl # #-----[ FIND ]------------------------------------------ # <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td align="right"><span class="nav"><br />{JUMPBOX}</span></td> # #-----[ BEFORE, ADD ]------------------------------------------ # <!-- BEGIN display_shares --> <br clear="all" /> <table width="100%" border="1" cellspacing="1" cellpadding="1" class="forumline" align="center"> <tr> <th align="center" colspan="2">{L_ON_ACCOUNT}{ON_ACCOUNT}</th> </tr> <!-- BEGIN shares --> <tr> <td align="center" class="{display_shares.shares.SHARE_ROW}" width="65%" ><span class="gen">{display_shares.shares.SHARE_NAME}</span></td> <td align="center" class="{display_shares.shares.SHARE_ROW}"><span class="gen">{display_shares.shares.SHARE_SUM}</span></td> </tr> <!-- END shares --> <tr> <th align="center" colspan="2">{L_LOAN}{LOAN}</th> </tr> </table> <!-- END display_shares --> # #-----[ OPEN ]------------------------------------------ # templates/subSilver/viewtopic_body.tpl # #-----[ FIND ]------------------------------------------ # <td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"> # #-----[ IN-LINE FIND ]------------------------------------------ # {postrow.POSTER_FROM} # #-----[ IN-LINE AFTER, ADD ]------------------------------------------ # {postrow.POSTER_VAULT} # #-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ # # EoM pvb.tpl Code: <table width="100%" cellspacing="2" cellpadding="2" border="0" align="center"> <tr> <td align="left"><span class="nav"><a href="{U_INDEX}" class="nav">{L_INDEX}</a></span></td> </tr> </table> <table class="forumline" width="100%" cellspacing="0" cellpadding="3" align="center"> <thead> <caption><table border="0" cellspacing="0" cellpadding="0" width="100%" class="forumheader"> <tr> <td align="left" valign="bottom" width="25"><img src="templates/cs_red/images/hdr_left.gif" width="25" height="27" alt="" /></td> <td align="center" class="forumheader-mid">{L_VIEWING_PROFILE}</td> <td align="right" valign="bottom" width="25"><img src="templates/cs_red/images/hdr_right.gif" width="25" height="27" alt="" /></td> </tr></table></caption> </thead> <tbody> <tr> <th width="40%">{L_AVATAR}</th> <th width="60%">{L_ABOUT_USER}</th> </tr> <tr> <td class="row1" height="6" valign="top" align="center">{AVATAR_IMG}<br /><span class="postdetails">{POSTER_RANK}<br />{POSTER_EFFECT_TITLE}<br />{RANK_IMAGE}</span></td> <td class="row1" rowspan="3" valign="top"><table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_JOINED}: </span></td> <td width="100%"><b><span class="gen">{JOINED}</span></b></td> </tr> <tr> <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_TOTAL_POSTS}: </span></td> <td valign="top"><b><span class="gen">{POSTS}</span></b><br /><span class="genmed">[{POST_PERCENT_STATS} / {POST_DAY_STATS}]</span> <br /><span class="genmed"><a href="{U_SEARCH_USER}" class="genmed">{L_SEARCH_USER_POSTS}</a></span></td> </tr> <tr> <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_LOCATION}: </span></td> <td><b><span class="gen">{LOCATION}</span></b></td> </tr> <tr> <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_WEBSITE}: </span></td> <td><span class="gen"><b>{WWW}</b></span></td> </tr> <tr> <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_OCCUPATION}: </span></td> <td><b><span class="gen">{OCCUPATION}</span></b></td> </tr> <tr> <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_INTERESTS}: </span></td> <td> <b><span class="gen">{INTERESTS}</span></b></td> </tr>{CASH} <tr> <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_JOBS}:</span></td> <td class="row1" valign="middle"><span class="gen">{JOBS}</span></td></tr> <tr> <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_BANK}:</span></td> <td> <span class="gen">{BANK_GOLD} {L_POINTS_NAME}<br /><a href="{RABBITOSHI_LINK}" >{L_RABBITOSHI_POSTS}</a><br /></span></td> </tr> <tr> <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_AUCTIONS}:</span></td> <td> <b><span class="gen">{AUCTIONS_WON} {L_WON} {AUCTIONS_UNPAID}</span></b></td> </tr> <tr> <td valign="top" align="right" nowrap="nowrap"><span class="gen">{INVENTORYLINK}</span></td> <td> <span class="gen">{INVENTORYPICS}</span></td> </tr> </table> </td> </tr> <tr> <td class="th">{L_CONTACT} {USERNAME}</td> </tr> <tr> <td class="row1" valign="top"><table width="100%" border="0" cellspacing="1" cellpadding="3"> <tr> <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_EMAIL_ADDRESS}:</span></td> <td valign="middle" width="100%"><b><span class="gen">{EMAIL_IMG}</span></b></td> </tr> <tr> <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_PM}:</span></td> <td valign="middle"><b><span class="gen">{PM_IMG}</span></b></td> </tr> <tr> <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_MESSENGER}:</span></td> <td valign="middle"><span class="gen">{MSN}</span></td> </tr> <tr> <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_YAHOO}:</span></td> <td valign="middle"><span class="gen">{YIM}</span></td> </tr> <tr> <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_AIM}:</span></td> <td valign="middle"><span class="gen">{AIM}</span></td> </tr> <tr> <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_ICQ_NUMBER}:</span></td> <td valign="middle">{ICQ}</td> </tr> </table> </td> </tr> </tbody> </table> <!-- BEGIN display_shares --> <br clear="all" /> <table width="100%" border="1" cellspacing="1" cellpadding="1" class="forumline" align="center"> <tr> <th align="center" colspan="2">{L_ON_ACCOUNT}{ON_ACCOUNT}</th> </tr> <!-- BEGIN shares --> <tr> <td align="center" class="{display_shares.shares.SHARE_ROW}" width="65%" ><span class="gen">{display_shares.shares.SHARE_NAME}</span></td> <td align="center" class="{display_shares.shares.SHARE_ROW}"><span class="gen">{display_shares.shares.SHARE_SUM}</span></td> </tr> <!-- END shares --> <tr> <th align="center" colspan="2">{L_LOAN}{LOAN}</th> </tr> </table> <!-- END display_shares --> <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <td align="right"><span class="nav"><br />{JUMPBOX}</span></td> </tr> </table> |
||
|
Thoul |
||
| Mon Jan 15, 2007 2:50 pm Post subject: re: profileview problem | ||
|
The code looks okay, but I see some stuff that looks like it adds an on/off switch for this in the admin panel. Check for that and make sure it's on.
|
||
|
assiejack |
||
| Mon Jan 15, 2007 4:15 pm Post subject: re: profileview problem | ||
|
yes all are switched on as in to show in profile and to show in posts?
if i double click my profile_view_body.tpl it shows up??? [/img]
|
||
|
Thoul |
||
| Mon Jan 15, 2007 6:19 pm Post subject: re: profileview problem | ||
|
Yeah, the problem isn't in the .tpl file, it's an issue of the template code not being triggered in usercp_viewprofile.php. The code itself seems fine, which is why I recommended checking that setting.
Try reuploading usercp_viewprofile.php and the language files. You should at least be seeing something there. |
||
|
assiejack |
||
| Mon Jan 15, 2007 6:37 pm Post subject: re: profileview problem | ||
|
Thank you very much there was some code missing form the includes/usercp_viewprofile.php
Thankyou |
||
Page 1 of 1
[/img]