Jump to content

jawproducts

Members
  • Content count

    199
  • Joined

  • Last visited

Everything posted by jawproducts

  1. jawproducts

    Help with category box

    Hi ! I am new at this so any help would be great! I recently installed a contribution that works by replacing categories.php so that each main category is split by a line and sub categorys are indented with small tree markers. I love it but if you look at the site www.jawproducts.com/catalog and on the left column, do you see how the text is far apart, i wanted to get the text/lines closer together, so that it is all seen on the screen (without customer having to scroll down).....I am so used to html where its cellpadding or spacing or br but with this code i cant figure it out! Any help would be so appreciated!!! Here is the code for my catalog/includes/boxes/categories.php <?php /* $Id: categories.php,v 1.23 2002/11/12 14:09:30 dgw_ Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2002 osCommerce Released under the GNU General Public License */ if ( (USE_CACHE == 'true') && !defined('SID')) { echo tep_cache_categories_box(); } else { function tep_show_category($counter) { global $foo, $categories_string, $id, $aa; for ($a=0; $a<$foo[$counter]['level']; $a++) { if ($a == $foo[$counter]['level']-1) { $categories_string .= "<font color='#006400'>|__</font>"; $categories_string .= " "; } $categories_string .= '<a href="'; if ($foo[$counter]['parent'] == 0) { $cPath_new = 'cPath=' . $counter; } else { $cPath_new = 'cPath=' . $foo[$counter]['path']; } $categories_string .= tep_href_link(FILENAME_DEFAULT, $cPath_new); $categories_string .= '">'; if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= '<b>'; } // display category name $categories_string .= $foo[$counter]['name']; if ( ($id) && (in_array($counter, $id)) ) { $categories_string .= '</b>'; } if (tep_has_category_subcategories($counter)) { $categories_string .= '->'; } $categories_string .= '</a>'; if (SHOW_COUNTS == 'true') { $products_in_category = tep_count_products_in_category($counter); if ($products_in_category > 0) { $categories_string .= ' (' . $products_in_category . ')'; } } $categories_string .= '<br>'; if ($foo[$counter]['next_id']) { tep_show_category($foo[$counter]['next_id']); } } ?> <!-- categories //--> <tr> <td> <?php $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => BOX_HEADING_CATEGORIES ); new infoBoxHeading($info_box_contents, true, false); $categories_string = ''; $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '0' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); while ($categories = tep_db_fetch_array($categories_query)) { $foo[$categories['categories_id']] = array( 'name' => $categories['categories_name'], 'parent' => $categories['parent_id'], 'level' => 0, 'path' => $categories['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $categories['categories_id']; } $prev_id = $categories['categories_id']; if (!isset($first_element)) { $first_element = $categories['categories_id']; } } //------------------------ if ($cPath) { $new_path = ''; $id = split('_', $cPath); reset($id); while (list($key, $value) = each($id)) { unset($prev_id); unset($first_id); $categories_query = tep_db_query("select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.parent_id = '" . $value . "' and c.categories_id = cd.categories_id and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"); $category_check = tep_db_num_rows($categories_query); if ($category_check > 0) { $new_path .= $value; while ($row = tep_db_fetch_array($categories_query)) { $foo[$row['categories_id']] = array( 'name' => $row['categories_name'], 'parent' => $row['parent_id'], 'level' => $key+1, 'path' => $new_path . '_' . $row['categories_id'], 'next_id' => false ); if (isset($prev_id)) { $foo[$prev_id]['next_id'] = $row['categories_id']; } $prev_id = $row['categories_id']; if (!isset($first_id)) { $first_id = $row['categories_id']; } $last_id = $row['categories_id']; } $foo[$last_id]['next_id'] = $foo[$value]['next_id']; $foo[$value]['next_id'] = $first_id; $new_path .= '_'; } else { break; } } } tep_show_category($first_element); $info_box_contents = array(); $info_box_contents[] = array('align' => 'left', 'text' => $categories_string ); new infoBox($info_box_contents); ?> </td> </tr> <?php } ?> <!-- categories_eof //-->
  2. I don't know what I did when this happened or how to fix it.... Does anyone know how to fix this? I think the last thing I did was the Product Short description contribution.....When i go to a category and click on a product in the listing to 'add to cart", i get this error......please help! 1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'pd.products_info limit 0, 20' at line 1 select p.products_image, pd.products_name, pd.products_info, p.products_id, p.manufacturers_id, p.products_price, p.products_master, p.products_master_status, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_listing_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '50' order by pd.products_name pd.products_info limit 0, 20
  3. jawproducts

    Meta Tag Controller Support

    wow you're the best!
  4. jawproducts

    Meta Tag Controller Support

    Cool, let us know if you figure out how to change that filename showing in the top left....i cant figure it out!
  5. jawproducts

    Meta Tag Controller Support

    I am noticing the same thing with my site, it keeps displaying the name of the file IN the web page, any fixes on this?
  6. jawproducts

    Model # in attributes

    Can someone help? I cannot find this help ANYWHERE! I just want my attributes section to have a column that says "model number" so that when customers check out, I will be able to just use the item number to type into quickbooks (so much easier because we have 1000s of items and enter the items by item number and its just a pain to have to keep looking up the item numbers). I installed the contribution for the "product model # in attributes" and followed the steps exactly but it just will not work. Can someone help? Does anyone know how to fix this?
  7. jawproducts

    Cart Information in Header

    I installed this contribution, and tested it, but everytime i EMPTY the shopping cart, it still says i have 2 items, even though im staring at the cart and there is NOTHING there! Does anyone know the problem w/ this contrib? thanks!!
  8. jawproducts

    Master Products - MS2

    also when i run the master.sql i keep getting an error code saying Duplicate key 16 or something
  9. jawproducts

    Master Products - MS2

    I had osc installed by an installer, I have no idea how to do all of the installing; also i did do the master.sql so i have no i dea why i keep getting errors. most of the errors look like this: Fatal error: Class messagestack: Cannot inherit from undefined class tableboxmessagestack in /home/jawpi/public_html/catalog/includes/classes/message_stack.php on line 20
  10. jawproducts

    Master Products - MS2

    Oh dear, i did what you said and im getting all errors now ahhh
  11. jawproducts

    Master Products - MS2

    Thanki you SO MUCH! Yes i am planning on adding a few contributions so Ive been manually doing it; What i mean is this though I copied all my files to my hard drive, and opened it on the LEFT SIDE of the compare/merge on the RIGHT SIDE i open the file from the Contribution. I use Beyond compare which makes RED any differences between the 2 files. I take any differences on the CONTRIBUTIONS SIDE and move it to the hard drive, but IN SOME i notice that there is a bunch of stuff in the HARD DRIVE SIDE that is NOT in the master products side , and when i move data from contribution side to the hard drive side, it sometimes OVERWRITES that extra data that is there, do u know what i mean? (and this is the first contribution i have done, so is this odd?) thanks you were VERY HELPFUL!
  12. jawproducts

    Master Products - MS2

    Can someone help me? (Again I am new to this). I am installing my first contribution (Master products) and I think all i hve to do is first BACKUP, and then compare all of the files in the master products, to the files in my file manager, correct? I am using "beyond compare" to do that. I know that I am supposed to take anything I see in the MASTER PRODUCTS files, and copy it over to the file manager files, but what about vice versa? When I look at the MASTER PRODUCT FILES and compare to the files in my file manager, I am noticing that sometimes there is data in MY FILE MANAGER already that is NOT in the MASTER PRODUCT FILES, do I have to KEEP THAT INFO or do I overwrite that info? I hope I don't sound like a moron! And i hope i am doing this right!
  13. jawproducts

    Attribute Sets Contribution

    Ok i figured that out, but now it is saying "access denied "??
  14. jawproducts

    Attribute Sets Contribution

    i followed all of the steps for the Attr Sets contribution, but when i go into my admin to see if it worked, i click on "attribute sets" in the panel and i just get a blank page. Can someone help? (did i do step 5 right? I just copied and pasted the database.txt file before the ?>) thanks!
  15. Hi! I hope I am not being too much of a pain, but if someone can just point me in the direction --> I am new to oscommerce and people keep telling me that I can add contributions (trying to add the Master products M2), but I can't figure out how to do it. Is there a tutorial on 'how to install contributions"? I have searched and searched and can't find a step by step on how to do it. I see that i download the contribution, extract, but then I have no idea, do i copy and paste it? I am so clueless. Thanks so much
  16. jawproducts

    Attribute Sets Contribution

    Thanks, its funny, I suddenly had a revelation lol and i said "IM SO STUPID!" lol i forgot that the sql file is inside that file i downloaded lol thanks!!!!!!!!!!!!!
  17. jawproducts

    Attribute Sets Contribution

    Can someone help? i am new to all of this but its fun learning! I did everything that it said in the attributes sets download, BUT im having trouble w/ one thing, i noticed the first step says "create two tables called xxxxxx and then says "use attributesets.spl file tocreate these tables. thats where i got lost. can someone walk me thru that? I mean, i go to myphpadmin and then how do i do i do that step? Im sorry if this is a stupid question, im new but trying to learn!
  18. jawproducts

    How do you install contributions?

    You are smart! Thank you, I won't bug you anymore! I printed what you said , thanks so much! i feel like such a dope! i am going to try to read up and learn thanks so much !!!!!!!!!!!!11 you have no idea how much you have helped me!
  19. jawproducts

    How do you install contributions?

    Oh and then she put "Once you do that, the tables are automatically created. "
  20. jawproducts

    How do you install contributions?

    Real fast though, do you understand how to use "my sql" and myphpadmin? here is what it says on one forum: says: to make the tables, just drop the sql file into your sql program. I use myphpadmin" Lol am i out of it, I dont even know what that means. i bought all the books for this oscommerce too and thers nothing in there about this, so weird! thanks for your help though!
  21. jawproducts

    How do you install contributions?

    Thanks hon!!!! im brand new to this so im so overwhelmed, I feel like ill NEVER LEARN IT Lol
  22. jawproducts

    How do you install contributions?

    oh thanks so much! i am getting a blank page still though wheni click on "product attribute sets" ....not sure what that means but ill try to figure it out. thanks!
  23. jawproducts

    How do you install contributions?

    Wow you guys are amazing thanks so much! I will do this as soon as i get a free minute (So busy lately!) but thanks you guys, I started to do the attributes sets one yesterday and i didnt get any errors yet when i clicked on the "product attributes" link in my catalog admin, it was blank so i have eto figure that out. Does anyone know what this means though, on the attribute sets contribution, the very last line in instructions says this, and i was good up until this last statement, and this statement is foreign language to me :-( it said: "for debugging the database functions, this is difficult to do w/ out a debugger, what i did was intentionally break the sql query which would stop the program and display the sql query. I would append or prepend variables to the sql query and by doing this you could verify the values being passed in, such as the $action variable" Is this something I have to do, i have no idea what this means? im sorry i am new to this!
  24. jawproducts

    How do you install contributions?

    I must be a complete moron; i cannot understand still how to do this. Do I download the contribution, then find the original file and over write it?
×