Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

fatmcgav

Archived
  • Posts

    171
  • Joined

  • Last visited

Everything posted by fatmcgav

  1. Yeh, i would usually do it that way, but this is for a client, so i want to elimiate any code editing on their part if they want to add new pages. I'm pretty sure the problems still with the query, somewhere... not sure where yet though. This is the code that i added to the page: // Extra Pages ADDED BEGIN $page_query = tep_db_query("SELECT c.pages_id, c.pages_title, cd.sort_order, cd.status from " . TABLE_PAGES_DESCRIPTION . " c, " . TABLE_PAGES . " cd WHERE cd.status = 1 and cd.sort_order >0 and cd.page_type >0 ORDER BY sort_order, pages_title"); $rows = 0; while ($page = tep_db_fetch_array($page_query)) { $rows++; if($page['pages_title'] != 'Contact Us'){ }else{ $link = FILENAME_CONTACT_US; } echo '<li><a href="' . tep_href_link($link) . '">' . $page['pages_title'] . '</a></li>'; } // Extra Pages ADDED END Now it must be something in there thats causing the problem. Could it be someting to do with '$rows++;'??? Cheers anyways Fatmcgav
  2. Yeh, i just managed to get it working by comparing it to the cat desc sql query, so the code now looks like this: $page_query = tep_db_query("SELECT c.pages_id, c.pages_title, cd.sort_order, cd.status from " . TABLE_PAGES_DESCRIPTION . " c, " . TABLE_PAGES . " cd WHERE cd.status = 1 and cd.sort_order >0 and cd.page_type >0 ORDER BY sort_order, pages_title"); which solves the mysql error, and displays the pages, but not correctly. It appears to be duplicating all the pages and all the names - so even though i've only got 6 pages in my db, it's showing 20 or so links, many of which link to the same page. If ure not sure what i mean, have a look here Any ideas on how to solve this prob? Once i get this fixed, i'll be sure to upload it for others to use, cus this has taken me ages to fix :) Cheers Fatmcgav
  3. Uh, the only other thing i could suggest is goin through all your code changes, to make sure that theyre correct, you havent missed a line or anything. As i said, i'm still a relative Oscom newb, so i'm grasping at straws here :) Cheers Fatmcgav
  4. Hey there, I've only just started using Oscom and PWA, so i dont consider myself an expert, but anyhow, here goes: This sounds like a problem with session data being stored in files which i read about in another post. Check in your config.php files in /includes/ and /admin/ to see if you have Sessions Storage set to files or mysql. the code you're looking for is: define('STORE_SESSIONS', '[insert]'); // leave empty ' ' for default handler or set to 'mysql' Ensure that this is set to 'mysql', and then let us know. Cheers Fatmcgav
  5. Somebody must know how to sort this..........
  6. Right, i've just got back round to tryin to sort this problem. From the looks of it, the DB query is incorrect. The query it's using is this: $page_query = tep_db_query("SELECT pages_id, pages_title, sort_order, status FROM " . TABLE_PAGES_DESCRIPTION . " WHERE status = 1 and sort_order >0 ORDER BY sort_order, pages_title"); The problem is, that the field 'sort_order' and 'status' are stored in a different table, TABLE_PAGES. So how can i go about editing the SQL query so that it works??? Cheers Fatmcgav
  7. Ah, i think i've found the problem. It looks like the user account is not correct, or atleast the details in the db arent, and thats wat's causin the error. I just created another account, and that worked fine, no error displayed. Very strange though. Thanks anyways. Fatmcgav
  8. Found me another problem :):) When i try to update an address in my address book, it now ask's me to select a Country from the pull-down list. Now i have no pull-down list, so i duno why it should be askin. I've tried commenting out the country check in form_check.js, and i've changed DEFAULT COUNTRY to 23 (UK). Any ideas ppl. Cheers Fatmcgav
  9. The only difference in the code between the two files, is that i've removed a few </tr> and </td> tags which seems to be out of place. Tis a strange error, had it on a diff contrib a while back, think it was somet about array_merge not being valid in php4.x or similar, also had a fix for it, but i cant find it now :) Any ideas ppl? Cheers Fatmcgav
  10. Hey, I'm not if this is a SPPC problem or not, but it appears on the customers page, so i'll post here and see wat u guys say. Ok, when i go onto customers.php in admin panel, it displays the following error: Any Ideas? Cheers Fatmcgav
  11. Hey, i cant see v4.1??? Any chance of someone emailing it to me at fatmcgav(at)gmail(dot)com. Cheers Fatmgav
  12. All sorted. For some reason or another, the 'Default Country define' didn't get added to english.php :S :S Also, i noticed a typo in the install manual, Against the actual filename of Just thought i'd let you know. :) Cheers Fatmcgav
  13. Do i add this to every file that use CS Selector? As regards the County's, yes theyre in my db. Cheers Fatmcgav
  14. As far as i know, it's set as def. I've managed to sort it in create_account.php by changing this code: // +Country-State Selector } if ($HTTP_POST_VARS['action'] == 'refresh') {$state = '';} if (!isset($country)){$country = 222;} // -Country-State Selector However, i cant see a similar line in address_book_details.php to change. Any ideas what i need to do there? Cheers Fatmcgav
  15. Hey there, I tried editing the code, and it dosent want to work for me. It displays the Country name correctly, but dosent display the area drop-downs. I've cleared all other countries out of my db, apart from the United Kingdom, and i put this line of code in create_account.php: <td class="main"><?php echo tep_draw_hidden_field('country',$country) . 'United Kingdom '; ?> Any ideas on why it's not working??? Cheers Fatmcgav
  16. Any chance of getting a screenshot to see what this looks like? Is it fully cross-browser supported? Edit: Just dloaded, and noticed there's a ss in the file :doh: :D Cheers Fatmcgav
  17. Correct me if i'm wrong, but whatever payment method they choose, dont you need to know where to post the item ;) ;). Thats why they enter their name and address on your site, and then if they choose Paypal as the payment method, dont they get forwarded straight onto the ppal site and enter their card details there, rather than on your site? Does ppal actually use their address, other than to verify the card details? Just tested it, and with ppal, you get to the payment method screen, and it then forwards you onto the ppal site, where they enter card details. Hope this helps. Fatmcgav
  18. Just ignore me Sarah, i thought u meant to got PWA workin with Autologin :blush: :blush: Anyhow, i'm lookin at the code now to see if it's possible to incorporate [urlhttp://www.oscommerce.com/community/contributions,2028/category,all/search,Country+State]this contrib[/url] into the code. I'll let you all know if i get anywhere. Also, back to my first question - has anyone managed to get PWA workin with Auto-login??? Cheers Fatmcgav
  19. Any chance u could post the code changes you made to login_pwa and login_acc? Also, i think i might have a fix for the county problem u mentioned, but i havent had a chance to test it yet. Give me 10mins or so and i'll let you know. Cheers Fatmcgav
  20. Hey there, I was just wondering if anybodys got this contrib installed with Auto Login. I need to add this code snippet below the password field: <?php // HMCS: Begin Autologon ********************************************************** if(ALLOW_AUTOLOGON != 'false') { ?> <tr> <td> </td> <td align="left" class="smalltext"><?php echo tep_draw_checkbox_field('remember_me','on', (($password == '') ? false : true)) . ' ' . ENTRY_REMEMBER_ME; ?></td> </tr> <?php } // HMCS: End Autologon ********************************************************** ?> Any ideas? Cheers Fatmcgav
  21. Hmm, thats strange - i've added ure code change already, and it was still givin me the error. This is what my code looks like around '_parsejpg($file)'. function _parsejpg($file) { //Extract info from a JPEG file $a=GetImageSize($file); if(!$a) { print('Missing or incorrect image file: '.$file); $file=DIR_S_CATALOG.DIR_WS_IMAGES.DEFAULT_IMAGE; } Any ideas? Cheers Fatmcgav
  22. Fantastic contrib, works a treat. If anybody wants to see it in action, it's here. One thing i do have to say though, the install doc is a bit ... patchy :D Anyhow, i got it workin fine, but i think i've also found a bug :) If you enable //Show or not the new products (0 = no, 1 = yes) define('SHOW_NEW_PRODUCTS',0); in pdf_config.php, then it gives you the following error when trying to create a catalog. I'm not even sure what the SHOW_NEW_PRODUCTS feature does, but it would be nice to have a lk ;). On another note, i want to know if it's possible to modify the actual layout of the pdf contents. Say, if i wanted to add a page background, or move the content around? Any ideas on how i'd go about doin this, assuming it's possible :D Cheers Fatmcgav
×
×
  • Create New...