Jump to content

abdllatif

Members
  • Content count

    25
  • Joined

  • Last visited

About abdllatif

  • Birthday 02/20/1963

Profile Information

  1. has not set their status

  2. abdllatif

    [Contribution] Mindsparx admin

    I have found my sollution, it had to go into the file catalog/admin/includes/header.php I added this one: ************************************************************************************** <?php require_once(DIR_WS_BOXES . 'm1_fua.adminbox.php');?> </div> ************************************************************************************** I put it just before the beginning of the stylesheet because it made the stylesheet fall appart, when i put it in any other place. It came out on top and doesn't interfere with anything else, best of it it works...............!!
  3. abdllatif

    [Contribution] Mindsparx admin

    Follow Up Autoresponder problem I have been using your Mindsparx admin template for some time now, and am very happy with it, thank you very much for this contribution. Today I found one problem, I am interested in the program follow up autoresponder from magneticone.com. The installation seems very easy, but..................... My first problem occured when I was asked to put the following code in admin/includes/column_left.php insert before the last symbol "?>": **************************************************************** require_once(DIR_WS_BOXES . 'm1_fua.adminbox.php'); **************************************************************** Since there is no column_left.php anymore, I don't know where to put the code. I have tried to put it in catalog/admin/includes/header.php I think it belongs there, but I cannot figure it out. Also followed the following info found in the forum. I assume this has to go into the new file wich is placed in the admin/includes/boxes (from the follow up autoresponder contrib) But this file hardly has any information in it. It only says: ************************************* <?php @Zend; 4147; /* ************************************* When you install a new contribution and it needs a new box in the old column left it means that you need to create a complete new dropdown for it, there is a great guide written by Richard Cranium in the contribution page on how to do this, but I can explain quickly on what you need to do. If there is a new box in the admin/boxes/ folder that needs to go in to your store you need to strip down the <td><tr> tags and comment out some code and then add some, like the example below, (before and after), it looks difficult, but its pretty simple ones you know how to do this. Before: <!-- reports //--> <tr> <td><?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_BOXES, 'link' => tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('selected_box')) . 'selected_box=infobox')); if ($selected_box == 'infobox') { $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_INFOBOX_CONFIGURATION, 'gID=1', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_HEADING_BOXES . '</a>'); } $box = new box; echo $box->menuBox($heading, $contents);?> </td> </tr><!-- reports_eof //--> After: <!-- reports //--> <?php $heading = array(); $contents = array(); $heading[] = array('text' => BOX_HEADING_BOXES, 'link' => tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('selected_box')) . 'selected_box=infobox')); // if ($selected_box == 'infobox') { // Add your links here start $contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_INFOBOX_CONFIGURATION, 'gID=1', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_HEADING_BOXES . '</a>'); // } // Add your old links here end // $box = new box; // echo $box->menuBox($heading, $contents); foreach($contents as $value) { echo $value['text'];}?> <!-- reports_eof //--> **************************************** Also this sollution didn't work for me **************************************** I have that contribution installed , but i didnt create a new drop for it, i just placed a link to it in my admin/boxes/tools.php file '<a href="' . tep_href_link(FILENAME_INFOBOX_CONFIGURATION, 'gID=1', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_HEADING_BOXES . '</a>'. I have tried a lot, but no sollution yet, anyone???
  4. abdllatif

    Specials valid from

    The date picker (calendar.js) works again, no idea why it din't work in the first place, must have been sommething with IE. So that one is solved. Only the save changes problem remains, I find it strange that my save changes problem was not there before the install of this component. Therfore I would thing it has to be solved easily, but where?
  5. abdllatif

    Specials valid from

    I have installed this contribution version: (http://addons.oscommerce.com/info/2520) specials_valid_from_1.0.4 I am using oscommerce rc2. There are two problems, one, the date picker doesn't show up in IE8, it does in Google-Chrome and in Firefox But in the compatebility mode date picker does show up in IE8 The other problem, it still doesn't save any changes made to a special, it will put the expire date on 000000 and therefor doesn't show up anymore. I have to manualy remove and ad the special product again. I tried the fix profided by frimipiso as below. **************************************** #Search in admin/specials.php for the following code // maybe the special product must be deactivated or actived (depending on wether the valid from/expires dates had been changed) if ($result == 1) { $new_specials_id = tep_db_insert_id(); tep_db_query("update " . TABLE_SPECIALS . " set status = '0' where (now() < valid_from_date) and specials_id = '" . (int)$new_specials_id . "'"); tep_db_query("update " . TABLE_SPECIALS . " set status = '0' where ((expires_date < now()) and expires_date > 0) and specials_id = '" . (int)$new_specials_id . "'"); tep_db_query("update " . TABLE_SPECIALS . " set status = '1' where (now() >= valid_from_date and now() < expires_date) and specials_id = '" . (int)$new_specials_id . "'"); } #and replace with the following code // maybe the special product must be deactivated or actived (depending on wether the valid from/expires dates had been changed) if ($result == 1) { $dbg->add_message('update done'); $new_specials_id = tep_db_insert_id(); tep_db_query("update " . TABLE_SPECIALS . " set status = '0' where (now() < valid_from_date) and specials_id = '" . (int)$specials_id . "'"); tep_db_query("update " . TABLE_SPECIALS . " set status = '0' where ((expires_date < now()) and expires_date > 0) and specials_id = '" . (int)$specials_id . "'"); tep_db_query("update " . TABLE_SPECIALS . " set status = '1' where (now() >= valid_from_date and now() < expires_date) and specials_id = '" . (int)$specials_id . "'"); } ****************************************** The code shows twice in the catalog/admin/specials.php not only one time. I changed the top one, the bottom one, and both of them, but all changes do give a failure in php at point of updating the date. Cannot redeclare tep_set_specials_status() (previously declared in....................catalog/admin/includes/functions/general.php:722) in /home/users/.../.../catalog/admin/specials.php on line 129 ****************************************** Tried another fix I found to change in catalog/admin/includes/functions/general.php (this is around line 129 as the problem above) But both of them don't solve my problem ************************************************************************* Change the below code: //// // Sets the status of a product on special function tep_set_specials_status($specials_id, $status) { if ($status == '1') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '1', expires_date = NULL, date_status_change = NULL where specials_id = '" . (int)$specials_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '0', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"); } else { return -1; } } INTO: //// // Sets the status of a product on special function tep_set_specials_status($specials_id, $status) { // if ($status == '1') { // return tep_db_query("update " . TABLE_SPECIALS . " set status = '1', expires_date = NULL, date_status_change = NULL where specials_id = '" . (int)$specials_id . "'"); if ($status == '1') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '1', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_SPECIALS . " set status = '0', date_status_change = now() where specials_id = '" . (int)$specials_id . "'"); } else { return -1; } } ******************************************************* Any one any help??? Thank you!! Harold
  6. abdllatif

    Products Attributes Sort v1.0

    I was wrong with the above posts, I finally got it fixed. I had to change code in de file catalog/includes/classes/pad_base.php This is the file qtpro 4.51b uses to sort. I changed the code: $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'" . " order by pa.options_values_price, pa.products_attributes_id"); ********************************************************************* into ********************************************************************* $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix, pa.products_attributes_id from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'" . " order by (pov.products_options_values_name+0)"); So realy the last part is changed. Came from the idea I found on another attribute sort contribution http://addons.oscommerce.com/info/2673 CONTRIBUTION ADDON BY BEN NEVIS he changed it on another file, in a little different way. Only sommetimes 7½ or 8½ comes before 7 or 8 not allways, but nevertheless, I am happy with the above sollution.
  7. abdllatif

    Products Attributes Sort v1.0

    Sorting still doesn't work in the options (select menu) the actual info page has the sorting nice and tidy. I found this fix in the contribution area of product attributes sort v 1.0 "$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name");" ... in the product_info.php file and replace it with ... "$products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' group by patrib.attribute_sort order by patrib.attribute_sort");" ... now your options will use the same ordering as your attributes ... enjoy ************************************************************************************************* But the php in product_info.php is nothing like that, after later updates on this contribution, the php now looks like this, anyone any help to fix the sorting with this part of php below?? ************************************************************************************************* $products_attributes_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) {
  8. abdllatif

    Products Attributes Sort v1.0

    I am working this contribution now quite wel. The thing I do is I clone one product, and keep that product only as a cloning product. Since the order is reversed, if I use it to clone one other product the order get reversed again, and therefore is in the right order :)
  9. abdllatif

    Products Attributes Sort v1.0

    Hi Spooks, thanks for replying, I didn't see that contri, but the thing is the sorting is actually realy good with the contribution I use now. Only the function cloning doesn't do the job wel. It is nice to do a clone for al the attributes on another product, so you don't have to go through all the clicking again. But only than the sorting is in reverse order. I think the contri you pointed out would be nice if I didn't manage to merge QTpro with products attributes sort. Thanks.
  10. abdllatif

    Products Attributes Sort v1.0

    I have installed this contribution, and had some difficulties with merge it into QT Pro v4.51b but after, it worked fine. Found the fix to insert it into QT Pro (Product Attrib Sort for QT Pro v4 by Nicholas Rivera) The only thing it doesn't do wel, is CLONING the attributes to another product. The cloning is fine, also al the attributes are there for the new product. Also nr 1 is nr 1 nr 2 is nr 2 etc etc. But on the frontside the order in wich the attributes should apear are reversed. So first size 6 than size 5 4 etc etc. Anyone seen this before? Scot???? Thanks Harold.
  11. I have installed this contribution (Product Attributes sort) and had some difficulties with merge it into QT Pro v4.51b but after, it worked fine. Found the fix to insert it into QT Pro (Product Attrib Sort for QT Pro v4 by Nicholas Rivera) The only thing it doesn't do wel, is CLONING the attributes to another product. The cloning is fine, also al the attributes are there for the new product. Also nr 1 is nr 1 nr 2 is nr 2 etc etc. But on the frontside the order in wich the attributes should apear are reversed. So first size 6 than size 5 4 etc etc. Anyone seen this before? Scot???? Thanks Harold. Sorry moved this to the right place, but cannot delete this post anymore. http://forums.oscommerce.com/index.php?sho...p;#entry1404619
  12. abdllatif

    Newsletter products, HTML email

    The problem has been solved, you don't put the image files in the same folder as the template, since the admin section is most of the time htacces protected! If you put the imagefiles of your new template in the folder .../catalog/images there is no prolem at all. Nice contribution, thank you.................!!
  13. abdllatif

    Newsletter products, HTML email

    htacces protects the newsletter from being read by my customers, due to the fact that my admin section is pasword protected with a htacces. This means that my customers won't see any newsletter until they have the right pasword!! Probably because the template is in the admin section............... Anyone ideas to solve this??? Thanks
  14. abdllatif

    [Contribution] Auction Module

    Noticed this: Limor01 at this page wrote: it has SQL injection risks. you need to make sure you clean the data from the URL before you insert it into your database as a query. $mfo_auction_query = mysql_fetch_object(tep_db_query('select auctions_starting_price, expires_date, overbid_amount from ' . TABLE_AUCTIONS_PRODUCTS . ' where products_id = ' . $_GET['products_id'] . ' and status')); In the downloaded package you will find this slightly different in the file catalog/includes/modules/auction_bids.php $mfo_auction_query = mysql_fetch_object(tep_db_query("select auctions_starting_price, expires_date, overbid_amount from " . TABLE_AUCTIONS_PRODUCTS . " where products_id = '" . $product_info['products_id']. "' and status = '1' ")); Which one should we use?
  15. abdllatif

    [Contribution] Auction Module

    Changed the code as Juerg Shumacher did before, (this was only a slight change) so now the email function when a higher bid has been made works fine. Remains the question on the admin site, en the timestamp.
×