Jump to content

bjfreeman

Members
  • Content count

    15
  • Joined

  • Last visited

Profile Information

  1. bjfreeman

    Custom Product Builder

    check the colums in your table and make sure the insert matches the number of columns and the postion.
  2. bjfreeman

    Custom Product Builder

    What I was proposing is a way that what ever anyone wanted to do, they could write the code and hook into the builder. I was not specifically addressing the the requirement but a general overview. Nor was I specifically putting the responsibility on you, Mike. From the responses it looks like I did not communicate sufficiently to get the concept accross. once I have it running on my machine I will share the code and you can decide it you want it part of the builder. :D
  3. bjfreeman

    Custom Product Builder

    add columns in the right postion to insert into products_attributes values (NULL, '110', '28', '192', '0', '+', '', '', '', '')
  4. bjfreeman

    Custom Product Builder

    That is a good enough description. this way others can write the services that would used by the builder for the type of buider they want. the PHP file would have the init, add, delete, update, retrieve methods. Just have to add the hook into the builder code to read the table. this leave the basic builder code unchanged. Then the person using the website can add which ever of the services want to offer. The enterprise software I work with operates this way. Thought could bring it to here.
  5. bjfreeman

    Custom Product Builder

    From a design point of view a table that allows selection Services(like inscriptions) or calendars. would allow for a and unending expansion for the builders. in this scenario an PHP file name, the name of the service, and service friendly name would be entered. you could then select, in the builder, the service, like inscription
  6. bjfreeman

    Custom Product Builder

    ok found the line of code line 67 $this->sql_query .= " limit " . max($offset, 0) . ", " . $this->number_of_rows_per_page; that comes out as limit -0, should not be -0 and $this->number_of_rows_per_page does not have a value so we have a comma hanging out in space. any idea why?
  7. bjfreeman

    Custom Product Builder

    I have had the same problem. No need to to more, I am sure he will find it now.
  8. bjfreeman

    Custom Product Builder

    you posted under my messages, Hopefully mike will see you message and answer.
  9. bjfreeman

    Custom Product Builder

    fixed: while (false!== ($file = readdir($handle))) { if ($file!= "." && $file!= ".." &&!is_dir($file)) { $namearr = split('\.',$file); if (($namearr[count($namearr)-1] == 'gif') || ($namearr[count($namearr)-1] == 'jpg') || ($namearr[count($namearr)-1] == 'png')) { $the_files_array[] = array( 'text' => $file, 'id' => $file); natsort($the_files_array); } } } with while (false!== ($file = readdir($handle))) { if ($file!= "." && $file!= ".." &&!is_dir($file)) { $namearr = split('\.',$file); if (($namearr[count($namearr)-1] == 'gif') || ($namearr[count($namearr)-1] == 'jpg') || ($namearr[count($namearr)-1] == 'png')) { $the_files_array[] = array( 'text' => $file, 'id' => $file); } } } natsort($the_files_array);
  10. bjfreeman

    Custom Product Builder

    clicked on Dependencies Warning: Division by zero in /admin/includes/classes/split_page_results.php on line 33 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 '-0,' at line 1 select p.products_id, p.products_status, p.products_model, pd.products_name, pc.categories_id, c.parent_id from products p, products_description pd, products_to_categories pc, categories c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = pc.products_id and c.categories_id = pc.categories_id and (pc.categories_id = '8') order by pc.categories_id, pd.products_name limit -0, [TEP STOP]
  11. bjfreeman

    Custom Product Builder

    Should clarify I have 5000 + products on a shared server. osCommerce 2.2-MS2 PHP PHP Version 5.2.6 (Zend: 2.2.0) MSQL MySQL 5.0.45 Linux 2.6.22.10 I believe will be solved by indexing. will let you know
  12. bjfreeman

    Custom Product Builder

    Time out error Fatal error: Maximum execution time of 30 seconds exceeded in /admin/builder_options.php on line 767
  13. bjfreeman

    Custom Product Builder

    if you want to validate some query you can use this http://www.oscommerce.com/community/contributions,5423 you may have to put in dummy vars for things like (int)$HTTP_GET_VARS['products_id']
  14. bjfreeman

    usps

    The easiest way is to have a orgin zipcode in the center of the us. that way you have an average. the other is not as accurate, but make the customer happy, is to use a orging zipcode on the other side from where the customer is. this requires a look up table with the first 3 numbers of a zipcode and the corresponding full zipcode that is the furthest away.
×