Jump to content

Jayhawk

Members
  • Content count

    10
  • Joined

  • Last visited

  1. Jayhawk

    [contribution] Print Order Receipt

    I fixed it. I changed it to this: <?php $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' order by osh.date_added"); while ($statuses = tep_db_fetch_array($statuses_query)) { echo ' <tr>' . "\n" . ' <td class="main" valign="top" width="70">' . tep_date_short($statuses['date_added']) . '</td>' . "\n" . ' <td class="main" valign="top" width="70">' . $statuses['orders_status_name'] . '</td>' . "\n" . ' <td class="main" valign="top">' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n" . ' </tr>' . "\n"; } ?>
  2. Jayhawk

    [contribution] Print Order Receipt

    I tried this and it did not work. My code actually has a "1" instead of "0" after the = sign. Any other solutions? Here is what it looks like. Error Message 1054 - Unknown column 'os.public_flag' in 'where clause' select os.orders_status_name, osh.date_added, osh.comments from orders_status os, orders_status_history osh where osh.orders_id = '325' and osh.orders_status_id = os.orders_status_id and os.language_id = '1' and os.public_flag = '1' order by os.date_added [TEP STOP] Code in file <?php $statuses_query = tep_db_query("select os.orders_status_name, osh.date_added, osh.comments from " . TABLE_ORDERS_STATUS . " os, " . TABLE_ORDERS_STATUS_HISTORY . " osh where osh.orders_id = '" . (int)$HTTP_GET_VARS['order_id'] . "' and osh.orders_status_id = os.orders_status_id and os.language_id = '" . (int)$languages_id . "' and os.public_flag = '1' order by os.date_added"); while ($statuses = tep_db_fetch_array($statuses_query)) { echo ' <tr>' . "\n" . ' <td class="main" valign="top" width="70">' . tep_date_short($statuses['date_added']) . '</td>' . "\n" . ' <td class="main" valign="top" width="70">' . $statuses['orders_status_name'] . '</td>' . "\n" . ' <td class="main" valign="top">' . (empty($statuses['comments']) ? ' ' : nl2br(tep_output_string_protected($statuses['comments']))) . '</td>' . "\n" . ' </tr>' . "\n"; } ?>
  3. Jayhawk

    [contribution] Simple Template System (sts)

    I currently have TinyMCE wysiwyg installed. Does this STS work with that or is it one or the other? Thanks
  4. Jayhawk

    [Contribution] SEO-G

    So how much would it cost or who could help me put this into my store? I have tried 5 times with no luck. Screen is just blank now. Not sure where to go from here. After step 10, I get lost. Admin screen still works at this point. Nothing else is visible. Ron
  5. I am about ready to give up. I have tried for a 4th time and all I get is a blank screen after following every step. I am at a loss as what to do. the site is located at www.jayhawkoptics.com/catalog before I edit anything this url brings upp the gg9 template just fine. After perfroming each step, I get a blank screen. Any suggestions? Thanks
  6. Hi there, I installed the gg9 template. I then tried putting the latest version of ultimate seo. I get a blank screen. Tried this 3 times and it will not work. Followed each step and no dice. STEP #1 - Upload the class and update files Is there a step I am missing for the update files part? I add them to the folder and then what? any help would be appreciated. Thanks
×