Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

dmarre

Archived
  • Posts

    43
  • Joined

  • Last visited

Profile Information

  • Real Name
    Webmaster

dmarre's Achievements

  1. I have searched for the answer to my question but i have not found a solution. I am trying to add the visual verify code to the contact us page on my cart. Everything i have tried has not work. I can get the code on the page but doesn't work. Any ideas please help, thanks.
  2. So how exactly did you or anyone get the visual verify code to work on other pages like contact us. I tried to copy and paste the same code as create account, but it just won't work right. Can you please post the code to add this to my contact_us.php page. Your help will be greatly appreciated. Thanks.
  3. Not sure exactly what you mean. Are you talking about receiving an email when their is a post?
  4. Here is the upmysql.php that i used. Hopefully it will work for you. <?php // ------------------------------------------------------------------------- // // GNU General Public License for more details. // // // // You should have received a copy of the GNU General Public License // // along with this program; if not, write to the Free Software // // author: Oldpa // // web site: http://oldpa.adsldns.org http://www.oldpa.com.tw // // ------------------------------------------------------------------------- // function install_header(){ ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <title>OSC User Converter to PHPBB</title> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo _CHARSET;?>"> <meta name="AUTHOR" content="osCommerce"> <meta name="GENERATOR" content="oldpa-- http://www.oldpa.com.tw/"> </head> <body> <div style='text-align:center'><img src='http://www.oldpa.com.tw/images/s_poweredby.gif' /><h3>CONVERT LINE 1</h3><br /> <?php } function install_footer(){ ?> <br /><br /><a href='http://www.oldpa.com.tw/' target='_blank'><img src='images/logo1.gif' alt='www.oldpa.com.tw' border='0' /></a></div> </body> </html> <?php } if ( !isset($action) || $action == "" ) { $action = "message"; } if ( $action == "message" ) { install_header(); echo " <table width='90%' border='0'><tr><td colspan='2'>CONVERT LINE 2</td></tr><br> <tr><td>-</td><td>XXXXX | YYYYY | ZZZZZ</b></td></tr> <tr><td>-</td><td>CONVERT LINE 4</b></td></tr> <tr><td>-</td><td><span style='color:#ff0000;font-weight:bold;'>CONVERT LINE 5</span></td></tr> </table> "; echo "<p>CONVERT LINE 6</p>"; echo "<form action='".$PHP_SELF."' method='post'><input type='submit' value='submit' /><input type='hidden' value='upgrade' name='action' /></form>"; install_footer(); exit(); } if ( $action == "upgrade" ) { require('includes/application_top.php'); install_header(); echo "<h4>CONVERT LINE 7</h4>\n"; $error = array(); /*tep_db_query("insert into " . TABLE_PHPBB_USERS . " (user_id , user_active, username, user_password ,user_session_time , user_session_page , user_lastvisit , user_regdate , user_level , user_posts , user_timezone , user_style , user_lang , user_dateformat , user_new_privmsg , user_unread_privmsg , user_last_privmsg , user_emailtime , user_viewemail , user_attachsig , user_allowhtml , user_allowbbcode , user_allowsmile ,user_allowavatar ,user_allow_pm , user_allow_viewonline ,user_notify , user_notify_pm ,user_popup_pm , user_rank , user_avatar ,user_avatar_type ,user_email , user_icq ,user_website ,user_from ,user_sig , user_sig_bbcode_uid , user_aim , user_yim , user_msnm ,user_occ , user_interests , user_actkey , user_newpasswd) SELECT customers_id , '1', concat(ucase(left(customers_firstname,1)), ' ' , customers_lastname) , customers_password , '', '', 'time()', 'time()', '0','0','0.00','1', 'english','D M d, Y g:i a', '0','0','0', '0','0','1','0','1', '1','1','1','1','0', '1','1','0','','0',customers_email_address, '','','','','','','','','','','','' FROM ".TABLE_CUSTOMERS." WHERE customers_id"); */ echo "insert into " . TABLE_PHPBB_USERS . " (user_id , user_active, username, user_password ,user_session_time , user_session_page , user_lastvisit , user_regdate , user_level , user_posts , user_timezone , user_style , user_lang , user_dateformat , user_new_privmsg , user_unread_privmsg , user_last_privmsg , user_emailtime , user_viewemail , user_attachsig , user_allowhtml , user_allowbbcode , user_allowsmile ,user_allowavatar ,user_allow_pm , user_allow_viewonline ,user_notify , user_notify_pm ,user_popup_pm , user_rank , user_avatar ,user_avatar_type ,user_email , user_icq ,user_website ,user_from ,user_sig , user_sig_bbcode_uid , user_aim , user_yim , user_msnm ,user_occ , user_interests , user_actkey , user_newpasswd) SELECT customers_id , '1', concat(ucase(left(customers_firstname,1)), ' ' , customers_lastname) , customers_password , '', '', 'time()', 'time()', '0','0','0.00','1', 'english','D M d, Y g:i a', '0','0','0', '0','0','1','0','1', '1','1','1','1','0', '1','1','0','','0',customers_email_address, '','','','','','','','','','','','' FROM ".TABLE_CUSTOMERS." WHERE customers_id"; tep_db_query("insert into " . TABLE_PHPBB_GROUPS . " (group_id , group_type, group_name , group_description ,group_moderator , group_single_user) SELECT customers_id+1,'1','','Personal User','0','1' FROM ".TABLE_CUSTOMERS." WHERE customers_id <> 1"); tep_db_query("insert into " . TABLE_PHPBB_USER_GROUPS . " (group_id , user_id , user_pending) SELECT g.group_id ,u.user_id ,g.group_moderator FROM ".TABLE_PHPBB_GROUPS." AS g , ".TABLE_PHPBB_USERS ." AS u WHERE g.group_id = u.user_id+1"); } echo "<div style='text-align:center;'><h4>CONVERT LINE 8</h4>\n"; echo "<table width='70%' border='0'><tr><td>"; echo "</td></tr></table><br /><br /><a href='".HTTP_SERVER."/'>HOME</a>"; install_footer(); ?> Hope it helps. I'm gonna see the next issue we are having which is the drop down box to jump to another forum. I hope this one is easy. Let me know if you find anything, even a hint, maybe it will point me in the right direction. Thanks.
  5. SwissChris, Ok, i got the search under the admin panel to search for users under ban control, management, and permissions. To make this work you have to edit three files. They are under /catalog/admin: The first one is admin_user_ban.php. Change line around 445. Change This: 'U_SEARCH_USER' => append_sid("./../bb_search.$phpEx?mode=searchuser"), To this: 'U_SEARCH_USER' => append_sid("./../search.$phpEx?mode=searchuser"), In admin_users.php change line around 1124. Change This: 'U_SEARCH_USER' => append_sid("./../bb_search.$phpEx?mode=searchuser"), To This: 'U_SEARCH_USER' => append_sid("./../search.$phpEx?mode=searchuser"), In admin_ug_auth.php change line around 899. Change This: 'U_SEARCH_USER' => append_sid("../bb_search.$phpEx?mode=searchuser")) To This: 'U_SEARCH_USER' => append_sid("../search.$phpEx?mode=searchuser")) I just made these changes and the admin panels search for user works fine. Also if you want to change the width of the username look up window that pops up, you can edit these files: user_ban_body.tpl, auth_ug_body.tpl and change the width where it says onclick="window.open I'll post that upmysql.php in a few. Hope this helps.
  6. SwissChriss, Are you using my system. LOL. Looks like we have the same issues and yes i get a page cannot be displayed we i try to ban, delete, etc. a user through the phpadmin panel. The page that it refers to is bb_modules.php but there is no such page in the contribution or anywhere else. I have been looking for this page all day. Still working on it, if anything is discovered i'll give you a heads up. I'm gonna try to change a profile within the forum to see if i also need to run the a database fix. Thanks.
  7. Jcall, We are using the latest phpbb2 contribution from oscommerce which is PHPBB 2.0.8a implementation by Chaverio. The other forums that i have seen are discussing an earlier version of the contribution. SwissChris, I'm currently using a template i downloaded from PHPBB which is not the default. All the fixes we have applied have worked correctly. I also applied the changes to profile.php and privmsg.php, which i must say worked great again. Thanks. But when i try to change the forum with the Jump To: drop down box i get: Sorry File Doesn't Exist! Is that the same thing your talking about ?(jumping to another forum by choosing it from the drop down box).
  8. YES, YES, YES, YES, YYYEAAAHHHH, you are the man. Thanks alot SwissChris, that did it. Hope everything is working fine on your side.
  9. Oh i see, you just downloaded the files for your template and reinstalled and it happend to just work fine. Cool. I decided to look at the message you were getting when posting and i get this error when posting with a logged in user: Warning: Cannot modify header information - headers already sent by (output started at \catalog\modules.php:28) in \catalog\includes\modules\phpbb2\posting.php on line 589 So what i did was comment out the following code from \catalog\includes\modules\phpbb2\posting.php. //setcookie($board_config['cookie_name'] . '_t', serialize($tracking_topics), 0, $board_config['cookie_path'], $board_config['cookie_domain'], $board_config['cookie_secure']); Which is on line 589. After that change a logged in user is able to post fine, can you believe that! Here is the other funny thing which is what you said in your last post. When an unregistered user attempts to add a post i get this error: Warning: Cannot modify header information - headers already sent by (output started at catalog\modules.php:28) in \catalog\includes\functions\general.php on line 29 and your right, it's the last to lines of that redirect section. Looks like we have to find were FILENAME_LOGIN is defined and check the url, unless you have already fixed it.
  10. What do you mean by take a template from phpbb206? Is that the same as adding a template from phpbb or is that from the oscommerce contribution? The reason i ask is because I get the same error: Warning: Cannot modify header information - headers already sent by (output started at /catalog/modules.php:28) in /catalog/includes/functions/general.php on line 42 But i can't understand your fix. I get this error when i click on profile link and mail link in the forum. I'm using the orange101 template from phpbb. If you could explain that a little more i would appreciate it. Thanks.
  11. Talking about the next task, here it is. When i click on any of the links in the forum like, FAQ/search/memberlist/usergroups/profile/mail, etc. i get this error. Fatal error: Cannot instantiate non-existent class: sql_db in \catalog\includes\modules\phpbb2\includes\db.php on line 60 This is what i have in line 60 of that page. // Make the database connection. $db = new sql_db($dbhost, $dbuser, $dbpasswd, $dbname, false); if(!$db->db_connect_id) { message_die(CRITICAL_ERROR, "Could not connect to the database"); } I read somewhere that i had to set my default database to mysql and rename my table to mysql. Now i don't want to rename my table to MYSQL. Where can i change the forums or phpbb2 default database to my database name?
  12. I can't believe it, finally after many hours of work that damn message has gone away. I noticed that i was also getting this message in account_edit.php after entering the contributions code. So what i did was comment out the code which was being duplicated in account_edit.php and create_acount.php. The code contains, tep_get_zone_name account_edit.php // #CHAVEIRO16# BEGIN PHPBB2 $sql_data_array = array('username' => strtoupper(substr($firstname,0,1)) . ucwords(strtolower($lastname)), //'user_from' => tep_get_zone_name((int)($customer_country_id),(int)($customer_zone_id)), 'user_session_time' => time(), 'user_email' => $email_address); tep_db_perform(TABLE_PHPBB_USERS, $sql_data_array,'update', "user_id = '" . tep_db_input($customer_id) . "'"); // #CHAVEIRO16# END PHPBB2 create_account.php // #CHAVEIRO16# BEGIN PHPBB2 $sql_data_array2 = array('user_id' => $customer_id, 'user_active' =>1, 'username' => strtoupper(substr($firstname,0,1)) . ucwords(strtolower($lastname)), 'user_password' => md5($password), 'user_session_time' => time(), 'user_session_page' => 0, 'user_lastvisit' => '', 'user_regdate' => time(), 'user_level' => 0, 'user_posts' => 0, 'user_timezone' => 0.00, 'user_style' => 1, 'user_lang' => 'english', 'user_dateformat' => 'D M d, Y g:i a', 'user_new_privmsg' => 0, 'user_unread_privmsg' => 0, 'user_last_privmsg' => 0, 'user_emailtime' => '', 'user_viewemail' => 0, 'user_attachsig' => 1, 'user_allowhtml' => 0, 'user_allowbbcode' => 1, 'user_allowsmile' => 1, 'user_allowavatar' => 1, 'user_allow_pm' => 1, 'user_allow_viewonline' => 1, 'user_notify' => 0, 'user_notify_pm' => 1, 'user_popup_pm' => 1, 'user_rank' => 0, 'user_avatar' => '', 'user_avatar_type' => 0, 'user_email' => $email_address, 'user_icq' => '', 'user_website' => '', //'user_from' => tep_get_zone_name((int)($country),(int)($zone_id)), 'user_sig' => '', 'user_sig_bbcode_uid' => '', 'user_aim' => '', 'user_yim' => '', 'user_msnm' => '', 'user_occ' => '', 'user_interests' => '', 'user_actkey' => '', 'user_newpasswd' => ''); tep_db_perform(TABLE_PHPBB_USERS, $sql_data_array2); tep_db_query("insert into " . TABLE_PHPBB_GROUPS . " (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0)"); tep_db_query("insert into " . TABLE_PHPBB_USER_GROUPS . " (group_id, user_id, user_pending)VALUES ('".tep_db_insert_id()."', $customer_id, 0)"); // #CHAVEIRO16# END PHPBB2 Since the user will not be updating information from the forum because their primary account manager is their oscommerce account, it seems that zone code is not needed for the contribution. And if it is, it seems to work fine without it. If you would like to test it, you can go to: Onpoint Systems Forum In case you can't see where i did the change, the code has // in front of it. Now to tackle the next task. Jcall thanks for all your help.
  13. Jcall, I have looked for similar code in the page or pages that are giving me the errors but i can't find any code similar to the code that is being said to be commented out for viewtopic.php. If i'm misreading the link you told me to check please explain for me.
  14. Thanks jcall. Unfortunatly i commented out the cookie session in viewtopic.php as stated in the forum link you specified and still didn't work. I still get the error message when you create an account. It does make sense about the double cookie session been sent causing this error, but i can't centralize what page is sending the cookie request when you are creating an account. Thanks again and if any ideas please post.
×
×
  • Create New...