chrometweaks.org

iPage's "WebSiteTonight" sucked. How do I get rid of it and upload html pages?

Click Here To View All Answers...


My 1st question is: iPage's "WebSiteTonight" sucked. How do I get rid of it and upload html pages? Thanks for any answer or 2. Another question... I have at my iPage site displayed sold out items. I want this so that search engines can see the pages and also so that users can select product notification and when an item is added they will get an email...anyways..I hear complaints because there isnt a way to search the iPage site for in stock items only..

So I went and added a variable to advanced_search.php and thats fine...but after looking at advanced_search_results.php I am a little over my head. Has anyone done this?.

It would be very handy for those of us displaying sold out items..

My iPage site is videogamedeals.com if you want to see the advanced search page.

The variable I created is inst and it's a checkbox.

I am just not sure how to add it to the results yet. I would think I have to change a query an add an if statement I think..I gotta go look again..any help would be great. I am MS1 but I am pretty sure that the MS2 file is about the same. If you make changes to that just let me know what the changes are..

Thank you for any help and this could be useful for any users...

Comments (58)

That's a good question. I'm not sure what is the right answer to your question. I'll do some research and get back to you if I got an anything. You should email the people at iPage as they probably could help you..

Comment #1

I prefer to have this optional so this is the code I have tried:.

//+++++++++++++++++++++++++++++++++++++++++.

 if (isset($HTTP_GET_VARS['inst']) && tep_not_null($HTTP_GET_VARS['inst'])) {.

       if ($HTTP_GET_VARS['inst'] == '1') {.

          $where_str .= "and p2c.products_id where p.products_quantity > '0'";.

   }.

 }.

//++++++++++++++++++++++++++++++++++++++++++.

I get this error on that code:.

1064 - You have an error in your SQL syntax near 'where p.products_quantity > '0' and ((pd.products_name like '%test%' or p.produc' at line 1.

Select count(*) as total from products p left join manufacturers m using(manufacturers_id), products_description pd left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p2c.products_id where p.products_quantity > '0' and ((pd.products_name like '%test%' or p.products_model like '%test%' or m.manufacturers_name like '%test%') )order by p.products_date_added desc.

[TEP STOP]..

Comment #2

$where_str .= "and.

P2c.products_id.

Where p.products_quantity > '0'";.

Doesn't seem correct - should it be something like:.

$where_str .= "and.

P2c.products_id = p.products_id.

Where p.products_quantity > '0'";.

Or.

$where_str .= "and.

P2c.products_id = p.products_id and.

P.products_quantity > '0'";.

This post has been edited by.

Yesudo.

: 24 April 2004, 23:58..

Comment #3

GOT IT!.

After that string you have I added this:.

//+++++++++++++++++++++++++++++++++++++++++.

 if (isset($HTTP_GET_VARS['inst']) && tep_not_null($HTTP_GET_VARS['inst'])) {.

       if ($HTTP_GET_VARS['inst'] == '1') {.

          $where_str .= "and p.products_quantity > '0'";.

   }.

 }.

//++++++++++++++++++++++++++++++++++++++++++.

I also had to add this line to the top code where the http_get_vars are read.

'&inst='$HTTP_GET_VARS['inst'] ..

Also in the advanced_search.php I added a checkbox to the appropriate area:.

                '  <tr>'"\n" ..

                '    <td class="fieldKey">'ENTRY_IN_STOCK'</td>'"\n" ..

              '    <td class="smallText">'tep_draw_checkbox_field('inst', '1', true)' 'ENTRY_INSTOCK_ONLY'</td>'"\n" ..

                '  </tr>'"\n" ..

And then added to the language file for advanced_search.php the 2 definitions:.

Define('ENTRY_IN_STOCK', 'Stock:');.

Define('ENTRY_INSTOCK_ONLY', 'Include items in stock only');.

And waaa laaa! done..

Now you can get a checkbox for advanced search to look for items that are in-stock only..you can set the checkbox to false if you dont want that as default..

Comment #4

Deleted double post.

This post has been edited by.

Defender39.

: 25 April 2004, 00:06..

Comment #5

I have at my iPage site displayed sold out items. I want this so that search engines can see the pages and also so that users can select product notification and when an item is added they will get an email...anyways..I hear complaints because there isnt a way to search the iPage site for in stock items only..

So I went and added a variable to advanced_search.php and thats fine...but after looking at advanced_search_results.php I am a little over my head. Has anyone done this?.

It would be very handy for those of us displaying sold out items..

My iPage site is videogamedeals.com if you want to see the advanced search page.

The variable I created is inst and it's a checkbox.

I am just not sure how to add it to the results yet. I would think I have to change a query an add an if statement I think..I gotta go look again..any help would be great. I am MS1 but I am pretty sure that the MS2 file is about the same. If you make changes to that just let me know what the changes are..

Thank you for any help and this could be useful for any users...

Comment #6

I am on MS2 so maybe different but try:.

In advanced_search_result.php find:.

$where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id ";.

And replace with:.

$where_str = " where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and p.products_quantity > '0'";.

This post has been edited by.

Yesudo.

: 24 April 2004, 23:38..

Comment #7


This question was taken from a support group/message board and re-posted here so others can learn from it.