Search:

Type: Posts; User: makenoiz

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Thread: global $db;

    by makenoiz
    Replies
    1
    Views
    723

    v151 global $db;

    I am writing some custom code that requires communication with the db. In my functions I use: global $db; but I keep getting 'scolded' on programming forums for using globals.

    Is there a better...
  2. v151 Re: Protection from injection - mysql_real_escape_string

    Should I sanatize SELECT and DELETE statements as well using bindVars and placeholders?

    Also the problem that I was having above was that the now() should not have been in the bindVars...
  3. v151 Re: Protection from injection - mysql_real_escape_string

    Thanks for that... date coming in as 0000-00-00 00:00:00 but at least its writing to the table. Ill work on it a bit and report the fix if I find.

    Thanks
  4. v151 Re: Protection from injection - mysql_real_escape_string

    Thanks! Ill fix and get back with result.....
  5. v151 Re: Protection from injection - mysql_real_escape_string

    This is holding it up.... any idea why?


    $sql = $db->bindVars($sql, ':products_dateAdded',now(), 'date');

    Can I use now() in the statement?
  6. v151 Re: Protection from injection - mysql_real_escape_string

    Just tried with using the example in the developers documentation located at: http://www.zen-cart.com/wiki/index.php/Developers_-_Database#BindVars_Datatypes

    and it worked so it must be my code...
  7. v151 Re: Protection from injection - mysql_real_escape_string

    Hi Dr Byte,
    my data is coming from a data feed using simpleXMLElement. My data is coming in fine as I am echoing it and I can see its ok but my function is halting when it hits the $sql statements....
  8. v151 Re: Protection from injection - mysql_real_escape_string

    Thank you very much.
  9. v151 Protection from injection - mysql_real_escape_string

    ZC 1.5.1


    Im adding some data to a new table I created within zencart. Im tring to become better at protecting against injections and just need a quick look over ( Im still newish and solid...
  10. v151 Re: Add 2 different products (no attributes) to cart at one time via hardcode link

    Yes I try very hard to stay away from 'c'! Our upgrades right now take 2 days and BeyoneCompare is my very very best friend during those 2 days! But the boss is the boss .. ya know.. I dont think 'a'...
  11. v151 Re: Add 2 different products (no attributes) to cart at one time via hardcode link

    Im on a development server not accessible to the public... but they are basically 1 mit and 1 baseball both from the same category of 'baseball' which is a sub category of parent cat 'sports'. There...
  12. v151 Add 2 different products (no attributes) to cart at one time via hardcode link

    1.5.1.
    Lots and lots of customizations ;}

    I am doing some custom coding and coding a link such as this:

    mysite.com/index.php?main_page=products_new&action=buy_now&products_id=107230

    It...
  13. v151 Re: descriptions truncating on degree symbol while importing from csv

    Ok found the solution to the browser display problems. I have an override english.php file that still was using define('CHARSET', 'iso-8859-1'); so I changed to
    define('CHARSET', 'utf-8');
    ...
  14. v151 Re: descriptions truncating on degree symbol while importing from csv

    Ran the conversion program and all tables and db are now utf8 but if I add degree symbol directly into the database products_descriptions I get this: ° instead of this ° for the degree symbol.

    so...
  15. v151 Re: descriptions truncating on degree symbol while importing from csv

    Im going to update this thread as I proceed in the event it can help any one else.

    My config files do show UTF8 and my Lang shows UTF-8

    admin/includes/configure.php = define('DB_CHARSET',...
  16. v151 Re: descriptions truncating on degree symbol while importing from csv

    Thank you both for your relies. Greatly appreciated. I will look at the links
    lhungil sent . And torvista, I tried openoffice last year. its was soooo slow that I had to get rid of it. My patience...
  17. v151 descriptions truncating on degree symbol while importing from csv

    We are importing our products, not using an editor so text is going directly to db from a csv file. Our descriptions are getting truncated at the degree symbol. Is this a character set...
  18. Replies
    6
    Views
    679

    v151 Re: Hidden calls to other sites break SSL

    I have found the cluprit: / includes/templates/myTemplate/html_header.php
    <script type="text/javascript" src="https://info.template-help.com/files/ie6_warning/ie6_script_other.js"></script>

    Thier...
  19. Replies
    6
    Views
    679

    v151 Re: Hidden calls to other sites break SSL

    Nope - nothing. Ive searched the DB as well... ;( Im thinking its encoded but I have yet to find any encoded code. Thanks for the try though! I appreciate it.
  20. Replies
    6
    Views
    679

    v151 Hidden calls to other sites break SSL

    1.5.1
    We use theme407 template which I believe came from Template Monster ( previous developer ). I cant get the site completely secure because its making two hidden calls to...
  21. v151 Re: php.ini: are these extension calls necessary?

    Great thank you for the response. I had them install the extension any way... should be there..

    Thanks again.
  22. v151 php.ini: are these extension calls necessary?

    Ive been digging around doing some clean up and came across a php.ini file in home/myACctName ( not web directory)
    it has:
    extension=pdo.so
    extension=pdo_sqlite.so
    extension=sqlite.so...
  23. Re: Product in 2 cats, will coupon apply to both?

    Answered my own question with tests.
    1) No as long as products are active, then they show up in the linked cat
    2) Yes

    ...... ;)
  24. Product in 2 cats, will coupon apply to both?

    ZC 1.5.1

    Have products loaded into one top category, then dispersed into linked categories as follows.

    Top Cat: ACME Outdoor products
    item1: fishing pole
    item 2: tent
    item 3: backpack
    ...
  25. Replies
    1,684
    Views
    262,041

    v150 Re: Merging Files

    Great... will install tonite!
  26. Replies
    1,684
    Views
    262,041

    v150 Re: Merging Files

    zc 1.5.0
    We have an automation script that populates our store from a remote feed. It brings in 1 image per product from the remote server and puts them in a directoy ( we define which directory)....
  27. v151 Re: connection pooling? To many mySQL processes

    Sorry you are correct... depreciation of mysql_connect is irrelevant since Im using 5.3.16.

    What other ideas might you have for excessive mySQL connections? Someone suggested this to help with...
  28. v151 Re: connection pooling? To many mySQL processes

    Also mysql_connect is depreciated.
    http://php.net/manual/en/function.mysql-connect.php

    Is it inefficient? Could this be why Im having an excess of connections? Thanks for any help.
  29. v151 connection pooling? To many mySQL processes

    Zen Cart: 1.5.1 35K products. Auto updating of 1-20
    products every 10 hours via cron.
    PHP version 5.3.16
    MySQL version 5.1.62-cll ...
  30. Replies
    7,098
    Views
    1,855,923

    v138a Re: Clearing Bmz-Cache

    ZC 1..1

    I am looking to remove orphaned images or at least create a list. Can IH help with that? Dont want to install before Im sure.

    THanks
  31. Replies
    286
    Views
    44,600

    Re: Image Manager addon

    ZC 1.5.1

    Simply trying to removed unused (products no longer active) images from my server. Is this the correct Add - on. I use 1.5.1 I have 18K products and 100K images. Something is wrong and I...
  32. v151 registration sidebox / Newsletter sign up

    We are looking for a better way to handle newsletter sign up for guests that would create an account for them at the same time. Im thinking there is nothing out there so looking at a mini...
  33. Replies
    401
    Views
    162,842

    Re: MailChimp Newsletter Sidebox

    Hi I think the answer may be buried in this thread but I cant find it.... If using the sidebox for newsletter sign up, will a zencart profile be created if First and Last name Field inputs are...
  34. Replies
    6
    Views
    1,330

    v151 Re: admin/includes/functions/compatibility.php

    Thanks very much ;)
  35. Replies
    6
    Views
    1,330

    v151 Re: admin/includes/functions/compatibility.php

    Hi Yes, Ive unzipped the files, but never sure if a file is created through install process... I do see the root/includes/functions compat file so I assume its still part of the file system. ;) But...
  36. Replies
    6
    Views
    1,330

    v151 Re: admin/includes/functions/compatibility.php

    but the main compatibility file should still remain / root/includes/functions?

    Thanks!
  37. Replies
    6
    Views
    1,330

    v151 admin/includes/functions/compatibility.php

    Was admin/includes/functions/compatibility.php file removed in 1.5.1 (the file in admin not in root) . I have one hanging around and Im not sure if another add on has put it there or if its part of...
  38. Re: Add on domain store = no images. Config = ok

    So if anyone runs into this, this is the anti hotlinking code to use if you are using an add on domain (replace the domain names with yours! )


    ## dissallow hotlinking
    RewriteEngine on...
  39. Re: Add on domain store = no images. Config = ok

    Fresh install and same thing. I removed the following hotinking code from my htaccess and viola ! Images! I was hotlinking to myself ;) Keep in mind that this .htaccess file is located in the main...
  40. Re: Add on domain store = no images. Config = ok

    Will do thanks again.. Will post outcome.
  41. Re: Add on domain store = no images. Config = ok

    hmmm, that didnt do it. Now I get the new installation page.... Thanks for trying ~!
  42. Re: Add on domain store = no images. Config = ok

    I created the add on account, server created the add on directory. I manually edited the ZC config files to accommodate the the new directory. Would that not be the correct path for an add on...
  43. Re: Add on domain store = no images. Config = ok

    A correction


    define('DIR_WS_CATALOG', '/');
    define('DIR_WS_HTTPS_CATALOG', '/');

    not


    define('DIR_WS_CATALOG', '/myaddondir/');
  44. Add on domain store = no images. Config = ok

    1.5.1 New store, No products, No mods. Yes, I have read all the other posts that have been made but none solve my issue.

    I have created an add on domain called myaddondomain.com (theoretical) to...
  45. Re: if product_model LIKE "Abc_%" then use table shipping else UPS

    No that is the problem ;)

    THanks!
  46. v139h Re: UPS Shipping Module for Oversized Products when Shipping

    This is a great question. Id like to know if something has been put into place in 1.5.1 to handle this as well?

    Thanks
  47. if product_model LIKE "Abc_%" then use table shipping else UPS

    1.5.1 lightly modified.


    Need to apply table shipping module if products.product_model begins with ABC_ . If not Id like to apply our standard shipping method of UPS.

    Any pointers would be...
  48. v139h Re: contents of admin/includes/boxes = went where in 1.5.1

    Wow - just found it: http://www.zen-cart.com/content.php?309-upgrading-addons-for-compatibility-with-v15x
  49. v139h contents of admin/includes/boxes = went where in 1.5.1

    I notice in 1.5.1 admin/includes/boxes has been removed. I have a script whos developer is MIA and I need to deal with one of the files located in 1.3.9h /admin/includes/boxes.

    Where were the...
  50. Replies
    3
    Views
    679

    Re: Close php ?> missing from meta_tags.php

    Thanks.... just didnt want to crash my entire upgrade due to a small typo...

    thanks for the confirmation.
Results 1 to 50 of 284
Page 1 of 6 1 2 3 4
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR