|
Page 1 of 1
|
FedericoBiccheddu 
Joined: December 2007
Posts: 55
Location:  Italia
|
 Field In The Profile: Auto Delete Record On DB
Hello all, like from object, I wanted to ask if it were possible and if you could help me to create a field in the profile that generated a link to just deviantART, since I manage situated of graphic (an hour in transfer dominion). For hour the one which I have made it has been this:
- Created the table in the DB in ip_user with the name of user_deviantart with following query:
ALTER TABLE `ip_users` ADD `user_deviantart` VARCHAR( 60 ) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL AFTER `user_website` ;
- I have modified following pages PHP:
- lang_main.php
- usercp_viewprofile.php
- usercp_register.php
- Here the modifications that I have made usercp_register.php:
- To the line 283:
$strip_var_list = array('email' => 'email', 'email_confirm' => 'email_confirm', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'skype' => 'skype', 'website' => 'website', 'deviantart' => 'deviantart', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests', 'phone' => 'phone', 'confirm_code' => 'confirm_code');
- To the Line 473:
$deviantart = stripslashes($deviantart);
- To the Line 949:
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("'", "''", $email) ."', user_upi2db_which_system = $upi2db_which_system, user_upi2db_new_word = $upi2db_new_word, user_upi2db_edit_word = $upi2db_edit_word, user_upi2db_unread_color = $upi2db_unread_color, user_icq = '" . str_replace("'", "''", $icq) . "', user_website = '" . str_replace("'", "''", $website) . "', user_deviantart = '" . str_replace("'", "''", $deviantart) . "', user_occ = '" . str_replace("'", "''", $occupation) . "', user_from = '" . str_replace("'", "''", $location) . "', user_from_flag = '$user_flag', user_interests = '" . str_replace("'", "''", $interests) . "', user_phone = '" . str_replace("'", "''", $phone) . "', user_selfdes = '" . str_replace("'", "''", $selfdes) . "', user_profile_view_popup = $profile_view_popup, user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting', user_viewemail = $viewemail, user_aim = '" . str_replace("'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("'", "''", $yim) . "', user_msnm = '" . str_replace("'", "''", $msn) . "', user_skype = '" . str_replace("'", "''", $skype) . "', user_attachsig = $attachsig, user_setbm = $setbm, user_allowsmile = $allowsmilies, user_showavatars = $showavatars, user_showsignatures = $showsignatures, user_allowswearywords = $allowswearywords, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_mass_email = $allowmassemail, user_allow_pm_in = $allowpmin, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_time_mode = $time_mode, user_dst_time_lag = $dst_time_lag, user_dateformat = '" . str_replace("'", "''", $user_dateformat) . "', user_posts_per_page = '" . str_replace("'", "''", $user_posts_per_page) . "', user_topics_per_page = '" . str_replace("'", "''", $user_topics_per_page) . "', user_hot_threshold = '" . str_replace("'", "''", $user_hot_threshold) . "', user_lang = '" . str_replace("'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '$user_actkey'" . $avatar_sql . ", user_gender = '$gender'
- To the Line 1133:
VALUES ('" . str_replace("'", "''", $user_registered_ip) . "', '" . str_replace("'", "''", $user_registered_hostname) . "', $user_id, '" . str_replace("'", "''", $username) . "', " . time() . ", '" . str_replace("'", "''", $new_password) . "', '" . str_replace("'", "''", $email) . "', '" . str_replace("'", "''", $icq) . "', '" . str_replace("'", "''", $website) . "', '" . str_replace("'", "''", $deviantart) . "', '" . str_replace("'", "''", $occupation) . "', '" . str_replace("'", "''", $location) . "', '$user_flag', '" . str_replace("'", "''", $interests) . "', '" . str_replace("'", "''", $phone) . "', '" . str_replace("'", "''", $selfdes) . "', $profile_view_popup, '" . str_replace("'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, $upi2db_which_system, $upi2db_new_word, $upi2db_edit_word, $upi2db_unread_color, '" . str_replace("'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("'", "''", $yim) . "', '" . str_replace("'", "''", $msn) . "', '" . str_replace("'", "''", $skype) . "', $attachsig, $allowsmilies, $showavatars, $showsignatures, $allowswearywords, $allowhtml, $allowbbcode, $allowmassemail, $allowpmin, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, $time_mode, $dst_time_lag, '" . str_replace("'", "''", $user_dateformat) . "', '" . str_replace("'", "''", $user_posts_per_page) . "', '" . str_replace("'", "''", $user_topics_per_page) . "', '" . str_replace("'", "''", $user_hot_threshold) . "', '" . str_replace("'", "''", $user_lang) . "', $user_style, '$gender', 0, 1, '$birthday', '$next_birthday_greeting', ";
- To the Line 1303:
'DEVIANTART' => $deviantart,
- To the Line 1431:
$deviantart = stripslashes($deviantart);
- To the Line 1462:
$deviantart = $userdata['user_deviantart'];
- To the Line 1554:
display_avatar_generator($mode, $avatar_filename, $avatar_image, $avatar_text, $user_id, $email, $current_email, $email_confirm, $coppa, $username, $new_password, $cur_password, $password_confirm, $icq, $aim, $msn, $deviantart, $yim, $skype, $website, $location, $user_flag, $occupation, $interests, $phone, $selfdes, $signature, $viewemail, $notifypm, $popup_pm, $notifyreply, $attachsig, $setbm, $allowhtml, $allowbbcode, $allowsmilies, $showavatars, $showsignatures, $allowswearywords, $allowmassemail, $allowpmin, $allowviewonline, $user_style, $user_lang, $user_timezone, $time_mode, $dst_time_lag, $user_dateformat, $profile_view_popup, $userdata['session_id'], $birthday, $gender, $upi2db_which_system, $upi2db_new_word, $upi2db_edit_word, $upi2db_unread_color);
- To the Line 1913:
$s_hidden_fields .= '<input type="hidden" name=deviantart" value"' . $deviantart . '" />';
- To the Line 2325:
'DEVIANTART' => $deviantart,
- Here the modifications that I have made usercp_viewprofile.php:
- To the Line 256:
$deviantart_img = ( $profiledata['user_deviantart'] ) ? '<a href="' . $profiledata['user_deviantart'] . ''.deviantart.com/'" target="_blank"><img src="' . $images['icon_deviantart'] . '" alt="' . $lang['Visit_deviation'] . '" title="' . $lang['Visit_deviation'] . '" /></a>' : ' ';
- To the Line 257:
$deviantart = ( $profiledata['user_deviantart'] ) ? '<a href="' . $profiledata['user_deviantart'] . ''.deviantart.com/'" target="_blank">''</a>' : ' ';
- I have modified the having followed rows of the template ones:
- mg_themes.cfg
- I have added:
$images['icon_deviantart'] = $current_template_images . $current_lang . 'icon_deviantart.' . $buttons_extension . $img_fade . $extra_padding;
- profilevoiew_body.tpl
- I have added:
<tr>
<td class="row2" valign="top"><b><span class="genmed">{L_DEVIANTART}</span></b></td>
<td class="row1"><span class="genmed">{DEVIANTART}</span></td>
</tr>
- profileadd_body.tpl
- I have added:
<tr>
<td class="row1"><span class="gen">{L_DEVIANTART}:</span></td>
<td class="row2"><input type="text" class="post" style="width: 200px" name="website" size="25" maxlength="255" value="{DEVIANTART}" />.deviantart.com</td>
</tr>
I have made all this for hour, but I have the following errors:
- but I do not understand why I writing in the field text the rows in the DB do not record me, although I directly modify them from and I come them I visualize to you in the modification of the profile then! You can say to me that rows I must control? for hour I have watched but I have not found nothing, and it does not come visualized not even when I go to see a profile although it is written in the DB!
you ask you aid, and I ask excuse the Italian support, but here, being to us more people even succeeds to help, knowing your engagements me
____________ Host Server: Linux (Aruba)
IP Version: 1.3.1.54 Modded
IP WebSite: MakingART (Web 2.0)
Last edited by FedericoBiccheddu on Thu 26 Jun, 2008 12:18; edited 1 time in total |
#1 Mon 21 Apr, 2008 20:56 |
|
Sponsors

|
Icy Phoenix is an open source project, you can show your appreciation and support future development by donating to the project.
|
| |
FedericoBiccheddu 
Joined: December 2007
Posts: 55
Location:  Italia
|
 Re: [MOD REQUEST] Create A Field In The Profile For DeviantA
nobody can help me?
____________ Host Server: Linux (Aruba)
IP Version: 1.3.1.54 Modded
IP WebSite: MakingART (Web 2.0)
|
#2 Sun 27 Apr, 2008 11:01 |
|
FedericoBiccheddu 
Joined: December 2007
Posts: 55
Location:  Italia
|
 Re: [MOD REQUEST] Create A Field In The Profile For DeviantA
Hello to all, I have found the MOD for phpbb2 I have integrated and it nearly perfectly, I have only a problem:
when I go to change avatar cancels me also the record from the table of the field.
The code creed enters in contrast with the page includes/usercp_avatar.php.
I have controlled in the page includes/usercp_avatar.php but modifying the values that I had to add pe the MOD is changed nothing, to what could be connected? you can dirmi that quesry they come executed when modification l' avatar?
Infinite thanks
The mod for PHPbb2 is: DeviantART profile mod
____________ Host Server: Linux (Aruba)
IP Version: 1.3.1.54 Modded
IP WebSite: MakingART (Web 2.0)
|
#3 Mon 23 Jun, 2008 22:45 |
|
Mighty Gorgon 
Luca Libralato
Joined: August 2006
Posts: 7192
Location:  Borgo San Michele
|
 Re: Field In The Profile: Auto Delete Record On DB
I have answered to this @ the Italian support site...
____________ Luca
SEARCH is the quickest way to get support.
Icy Phoenix ColorizeIt - CustomIcy - HON
|
#4 Wed 02 Jul, 2008 12:19 |
|
|
Page 1 of 1
|
Was this topic useful?
Was this topic useful?
| Link this topic |
| URL |
|
| BBCode |
|
| HTML |
|
You cannot post new topics You cannot reply to topics You cannot edit your posts You cannot delete your posts You cannot vote in polls You cannot attach files You can download files You cannot post calendar events
|
|
|
|