Jump to content


  • Content count

  • Joined

  • Last visited

Everything posted by Druide

  1. Anti Robot Registration Validation 1.0 + images Created on version: tep_snapshot-20030508 2.2 MS2 CVS Transformed from phpBB2 hack to OsCommerce by Robert Hellemans (Druide) Screenshot is included in ZIP file Description: This will add a Random-graphical-text Validation field in Registration form to protect your osC Shopping Cart from being flooded of robotic-member-registration (like many free webhost signup form...) ADMIN INCLUDED: goto ADMIN to activate/disable this contribution, also you can adjust the amount of validation images ( I would suggest to keep it at 5 ) NOTE: i have included the CVS versions (the lines that tell you this at the top of a osC file) of all files that has to be changed (just to make it easier for the osC CORE) :) Maybe this is a nice contribution to include in the official 2.2 MS2 release ;)
  2. Version Control & Bookmark MODULE for Contributions 0.1 What is this ? This contribution will HELP you in almost ANY WAY possible to keep all your added contributions in a nice order. There is a link included to the contributionpage, a possible link to this forum (like watch this topic), 4 diffent ways to set the status of a module: - active - inactive - bookmark - not set It's up to you to keep it up to date and with all this information you are ready for ANY new version of osC :) The field 'Comments for configuration' is a longtext field (for mysql geeks) so capable to hold lots of information how to install or extra changes you made to a contribution while installing. I made this so you won't have too much trouble when you are upgrading your osC version :) You can search in the fields 'name' & 'osC ID' for when your database is getting HUGH and it will when you are used to functionality of this contribution. here some screenshots : main screen add / update screen preview screen NOTE: this is STILL in BETA please test it all the way you can and give some comments, and please help me out what i need to put into the [How does this work ?] link I will post the link here when i am ready uploading it to the contributions
  3. http://www.oscommerce.com/community/contributions,1055 Let me know if you like the new version :) or if you find a bug or so too ofcourse...
  4. good to see that one of my old mods is still alive and kicking, Y'all keep UP the good work! Peace OUT ! Druide
  5. Version 0.1.2 by webmaster@ruddlesmills.com CHANGELOG - changed file admin/installed_contributions.php - changed file admin/includes/language/english/installed_contributions.php - fixed links at page number results - added 'Select Category' for display per category - added with INSERT/UPDATE option: SELECT or add new 'Category' - added with INSERT/UPDATE option: SELECT or add new 'Release Target' - improved the links - fixed the link from the RESET button at INSERT/UPDATE page - added a sub title to HEADER_TITLE & more... older thread with old screenshots (will be updated soon) is here I would like some FEEDBACK from the people who installed this Contribution... Do you like it ? Easy to use ? Functional ? I would like .... ? etc... The door is open ;)
  6. http://www.oscommerce.com/community/contributions,2367 World Zones 1.0 Based on contribution www.oscommerce.com/community/contributions,920 25 May 2004 - Zones Intenational Default / Zonesworld Version 2 All credits are by all people who contributed on this & previous version. ADDED IN THIS VERSION: #################### * Added the choise to select the worldzones by weight or by price (note the data in modules/shipping/worldzones.php is set for option price, adjust at your needs.) * renamed the shipping class to 'worldzones' to prevent errors with other shipping modules, this is the reason why i added this contribution as a 'new' one. (no offence to other authors) I just build a new site www.sierrasglassworks.com (live store, orders will be billed) for my wife and needed this calculation by 'price' option because we are gonna sell hand crafted beads, and i'm sure there are other people who will be VERY happy with this contribution.
  7. MOD: Search Results with Highlight v1.0 By: Robert Hellemans NOTE: this mod is Case Sensitive !!! PREVIEW at LIVE store: http://www.ruddlesmills.com/advanced_searc...s=Case&x=30&y=7 LIVE STORE !!!: http://www.ruddlesmills.com no fake orders, you will be billed ! Difficulty: EASY INSTALL Time: Less then 1 minute Files to change: 1 catalog/includes/modules/product_listing.php Admin: to set a different background color for the searchresults, look at ADMIN > configuration > My Store > Search Result Highlight Color you can set to colorname like: yellow or this way: #FFFF00 What does it do ?: This little but effective MOD will Highlight the keywords that you have given in the search query. I made it so that it only checks the fields: products_name & products_model which should be more then enough because not many people have their descriptions listed in product_listing.php Let's start to have some fun !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! insert into your database: INSERT INTO configuration VALUES ('', 'Search Result Highlight Color', 'SEARCH_RESULT_BACKGROUND_COLOR', 'yellow', 'This will be the background color from the matching keywords in searchresults<br>This is Case Sensitive !', 1, 7000, NULL, '2003-03-18 11:05:37', NULL, NULL); find in catalog/includes/modules/product_listing.php case 'PRODUCT_LIST_MODEL': $lc_text = ' ' . $listing_values['products_model'] . ' '; break; case 'PRODUCT_LIST_NAME': if ($HTTP_GET_VARS['manufacturers_id']) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing_values['products_id'], 'NONSSL') . '">' . $listing_values['products_name'] . '</a>'; } else { $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . $listing_values['products_name'] . '</a> '; } break; REPLACE WITH: case 'PRODUCT_LIST_MODEL': $fldname = $listing_values['products_model']; if ($HTTP_GET_VARS['keywords'] != "" ) { $string_to_split = $HTTP_GET_VARS['keywords']; $tok = split(" ", $string_to_split); $size = sizeof($tok); for ($i = 0; $i < $size; $i++) $fldname = str_replace($tok[$i], '<span style="background-color: ' . SEARCH_RESULT_BACKGROUND_COLOR . '">' . $tok[$i] . '</span>', $fldname); } $lc_text = ' ' . $fldname . ' '; break; case 'PRODUCT_LIST_NAME': if ($HTTP_GET_VARS['manufacturers_id']) { $lc_text = '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'] . '&products_id=' . $listing_values['products_id'], 'NONSSL') . '">' . $listing_values['products_name'] . '</a>'; } else { $fldname = $listing_values['products_name']; if ($HTTP_GET_VARS['keywords'] != "" ) { $string_to_split = $HTTP_GET_VARS['keywords']; $tok = split(" ", $string_to_split); $size = sizeof($tok); for ($i = 0; $i < $size; $i++) $fldname = str_replace($tok[$i], '<span style="background-color: ' . SEARCH_RESULT_BACKGROUND_COLOR . '">' . $tok[$i] . '</span>', $fldname); } $lc_text = ' <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, ($cPath ? 'cPath=' . $cPath . '&' : '') . 'products_id=' . $listing_values['products_id']) . '">' . $fldname . '</a> '; } break; i couldn't make it easier for you all, sorry for that ;) Let me know if you liked it !
  8. Druide

    New UPS XML Shipping Module available

    you need to find the define for TABLE_PACKAGING define('TABLE_PACKAGING', 'packaging'); the 'packaging' needs to be whatever is used in this contribution i dunno just browsing around since a few months and hope to help out a bit good luck Melissa, i am going to dissapear again for a while......lol
  9. Original thread was started at Tips & Tricks Forum, but i decided to throw this into the contribution area for further development (?) Setting upload image destination in categories.php, Admin change This code allows one to do three things: 1. Change the filename of an image at time of upload. 2. Put the image in a subdirectory of images/ 3. Change the product or category image location in the database without uploading a new image. If the image name is blank and none is uploaded, then it will erase the image. In admin/categories.php, around lines 80-2, change from if ($categories_image = new upload('categories_image', DIR_FS_CATALOG_IMAGES)) { tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($categories_image->filename) . "' where categories_id = '" . (int)$categories_id . "'"); } to $categories_image = new upload('categories_image'); $categories_image_name = ''; if (isset($HTTP_POST_VARS['image_destination']) && tep_not_null($HTTP_POST_VARS['image_destination'])) { $categories_image->set_destination(dirname(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['image_destination'])); $categories_image_name = $HTTP_POST_VARS['image_destination']; } else { $categories_image->set_destination(DIR_FS_CATALOG_IMAGES); } if ($categories_image->parse()) { if (isset($HTTP_POST_VARS['image_destination']) && tep_not_null($HTTP_POST_VARS['image_destination'])) { $categories_image->set_filename(basename(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['image_destination'])); } if ($categories_image->save()) { $categories_image_name = $categories_image->filename; } } if (isset($HTTP_POST_VARS['image_destination']) && tep_not_null($HTTP_POST_VARS['image_destination'])) { $categories_image_name = $HTTP_POST_VARS['image_destination']; } tep_db_query("update " . TABLE_CATEGORIES . " set categories_image = '" . tep_db_input($categories_image_name) . "' where categories_id = '" . (int)$categories_id . "'"); Around lines 224-6, change from if (isset($HTTP_POST_VARS['products_image']) && tep_not_null($HTTP_POST_VARS['products_image']) && ($HTTP_POST_VARS['products_image'] != 'none')) { $sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']); } to $sql_data_array['products_image'] = tep_db_prepare_input($HTTP_POST_VARS['products_image']); Around lines 315-20, change from $products_image->set_destination(DIR_FS_CATALOG_IMAGES); if ($products_image->parse() && $products_image->save()) { $products_image_name = $products_image->filename; } else { $products_image_name = (isset($HTTP_POST_VARS['products_previous_image']) ? $HTTP_POST_VARS['products_previous_image'] : ''); } to (this BLOCK has been changed by Robert Hellemans) if (isset($HTTP_POST_VARS['image_destination'])) { // BOF ftpmkdir by robert hellemans // split the 'new' directory and file from eachother $image_destination_dir = explode("/" , $HTTP_POST_VARS['image_destination']); // check if the 'new' catalog image directory exists if (is_dir(DIR_FS_CATALOG_IMAGES . $image_destination_dir[0])) { // uncomment the next line if you want to debug // $messageStack->add(DIR_WS_IMAGES . $image_destination_dir[0] . " already exists", 'caution'); } else { include(DIR_WS_INCLUDES . 'ftpmkdir.php'); FtpMkdir(DIR_FTP_MKDIR, $image_destination_dir[0]); if (!is_writeable(DIR_FS_CATALOG_IMAGES . $image_destination_dir[0])) $messageStack->add(DIR_WS_IMAGES . $image_destination_all[0] . " is NOT writable", 'error'); if (is_writeable(DIR_FS_CATALOG_IMAGES . $image_destination_dir[0])) $messageStack->add("Success: Directory " . DIR_WS_IMAGES . $image_destination_all[0] . " is created & CHMOD 777", 'success'); } // EOF ftpmkdir $products_image->set_destination(dirname(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['image_destination'])); $products_image->set_filename(basename(DIR_FS_CATALOG_IMAGES . $HTTP_POST_VARS['image_destination'])); } else { $products_image->set_destination(DIR_FS_CATALOG_IMAGES); } if ($products_image->parse() && $products_image->save()) { $products_image_name = $products_image->filename; } else { $products_image_name = ''; } if (isset($HTTP_POST_VARS['image_destination'])) { $products_image_name = $HTTP_POST_VARS['image_destination']; } About the above block: What does it do ? Well this little ADDON creates for you a new directory ON_THE_FLY and then uploads the image into it. So you Dont need to create a new directory with your FTP client and then change it to CHMOD 777, and you know why ? This little tool does it ALL for you Cool or not, i think its AWESOME I had an idea again and started to work on it and VOILA i made it work, this can be used also for those error 'not writable directories' messages that you get after you do a clean OSC installation (for experts ONLY ) Around lines 562-5, change from <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image') . '<br>' . tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . $pInfo->products_image . tep_draw_hidden_field('products_previous_image', $pInfo->products_image); ?></td> </tr> to <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_file_field('products_image'); ?></td> </tr> <tr> <td class="main"><?php echo TEXT_PRODUCTS_IMAGE_DESTINATION; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('image_destination', $pInfo->products_image); ?></td> </tr> Around line 887, change from $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image')); to $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image')); $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE_DESTINATION . '<br>' . tep_draw_input_field('image_destination')); Around line 905, change from $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image')); to $contents[] = array('text' => '<br>' . TEXT_EDIT_CATEGORIES_IMAGE . '<br>' . tep_draw_file_field('categories_image')); $contents[] = array('text' => '<br>' . TEXT_CATEGORIES_IMAGE_DESTINATION . '<br>' . tep_draw_input_field('image_destination', $cInfo->categories_image)); In admin/includes/languages/english/categories.php (or whatever language), add something like define('TEXT_CATEGORIES_IMAGE_DESTINATION', 'File location in the images directory: '); define('TEXT_PRODUCTS_IMAGE_DESTINATION', 'File location in the images directory: '); add in admin/includes/configure.php // BOF define your ftp connection define('FTP_SERVER', '12.34.567.890'); // FTP server IP, same info as you use to upload by a FTP client define('FTP_SERVER_USERNAME', 'login'); // same login info as you use to upload by a FTP client define('FTP_SERVER_PASSWORD', 'password'); // same password as you use to upload by a FTP client define('DIR_FTP_MKDIR', '/httpdocs/catalog/images'); // login by your FTP client to see the path you need // EOF define your ftp connection create a new file and call it: ftpmkdir.php put this code block into the file and save it, then upload it to your admin/includes/ftpmkdir.php <?php /* Created by Robert Hellemans with information from php dot net NOTE: ONLY use this if your admin directory is protected from outside !!! ftpmkdir.php 12 Dec 2003 Robert Hellemans webmaster at RuddlesMills dot com Feel FREE to use this file but leave my information in it Thank you */ // create directory through FTP connection function FtpMkdir($path, $newDir) { $connection = ftp_connect(FTP_SERVER); // connection $result = ftp_login($connection, FTP_SERVER_USERNAME, FTP_SERVER_PASSWORD); // login to ftp server // check if connection was made if ((!$connection) || (!$result)) { return false; exit(); } else { ftp_chdir($connection, $path); // go to destination dir if(ftp_mkdir($connection,$newDir)) { // create directory ftp_site($connection, "CHMOD 777 $path/$newDir") or die("FTP SITE CMD failed."); return $newDir; } else { return false; } ftp_close($conn_id); // close connection } } ?> The person who started this as a TIP & TRICK is Matt (iiinetworks) Thank you Matt, i gave it a little swing to let other people work some more on this to make it even better then it is already
  10. Good to see that one of my 'old' projects is still alive... Thank you 'users' That's all it worked perfect before MS2 and i haven't bothered to look into the code since, i am still waiting on MS3 (like many others) i have lots of new contributions in my queue for MS3 but dont rewrite my code before it's official (stable)
  11. Druide

    [Contribution] Admin Notes

    PLEASE UPLOAD THE SCREENSHOTS & contribution seperate :) so people can download/review the new version, just an idea and btw thanks for the notification to me in this contribution much appreciated !!!
  12. Druide

    Recommended Contributions?

    there is no such a thing like a recommended list, it all just depends how you plan to use OSC for your products, and since everyone has different products to sell they have a different taste for contributions. The bad thing is there are lots of people who just dont want to share their own made contributions, thats a pitty but we can live with it....lol We just start to write it ourselfs which will become pretty easy if you keep on adding contributions ;) Just ALWAYS remember to backup all files that has to be changed BEFORE you even start to add a contribution
  13. First of all thanks P & G for this HUGE release for MS1 It's time for some BUG TRACKING Trying to install this and while adding spg_alter_table.sql i noticed that this file was not correct ALTER TABLE customers_basket ADD attributes_cost DECIMAL(15,4) NOT NULL AFTER final_price, ADD attributes_weight DECIMAL(15,4) NOT NULL AFTER final_cost; okay i am smart enough to figure this one out i thought but i haven't got the field final_cost so where to put this one ? i added this ALTER TABLE customers_basket ADD attributes_cost DECIMAL(15,4) NOT NULL AFTER final_price; that works fine, should the next one be ALTER TABLE customers_basket ADD attributes_weight DECIMAL(15,4) NOT NULL AFTER final_price; also a little typo in same file ALTER TABLE `countries` ADD `status` TINYINT(1) NOT NULL; this should be ALTER TABLE countries ADD status` TINYINT(1) NOT NULL; to be continued... BTW installing this on tep_snapshot-20030329.zip
  14. Druide

    How Did You Hear About Us - Support

    change it to: insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('', '0', now()) good luck Sabrina
  15. Druide

    Setting Up Paypal??

    be smart and install the Paypal IPN contribution. where ? in the contribution area.... ;)
  16. Druide

    Paypal IPN Problem

    use the official thread for questions about paypal IPN
  17. Druide

    PGP email CC info?

    I see you have absolutely no clue how to program in PHP/MySQL. You just WANT to have things done your way without doing something for it. My opinion is you are just one of those 'users' who will never be happy. If you want something specific then go look at those other shopping carts where you have to pay for (BIG BUCK$) and then ask those developers how much it costs to have your wishes translated in code. This is an OPEN SOURCE project, first read/search and learn about a project before you complain about it. This is a GREAT community that is willing to help if an answer is available. My 2 cents... Oh yeah... Patience is a Virtue.... :)
  18. PayPal_Shopping_Cart_IPN_v2.6a (addon ONLY) Official thread for the main contribution: http://forums.oscommerce.com/index.php?showtopic=95326&st=0 I released this as a new contribution so Gregory's works stays clean and ordered. No Offence to Gregory !!! He will add this maybe in a future version (option) I do advise people to TEST this addon first on a test / development site and NOT immediatly on a HIGH PRODUCTION site. I don't take ANY risk for damages !!! Written by Robert Hellemans for my new live site Example: see screenshots (note not everything you see in the screenshots is in this addon) All credits still go to Gregory Baboolal for all his effort in PayPal IPN (send him a paypal donation :wink:) because we make & sell glasswork beads and those are all unique so the stock quantity is almost always 1 or 2 pcs. And this amazing Paypal IPN contribution only updated the stock when you (the store owner) have accepted/confirmed the payment at paypal.com which is great for high volume e-shops but for us it was not correct. Clients where able to buy the same single item which has only 1 pcs in stock if you (the store owner) did not update your paypal payments soon enough. Now this little addon/change makes it possible to put ordered items in an 'on hold / reserved' status in the products table only when a payment is made with paypal !!! When the client places an order and does the payment at paypal then when the first paypal IPN is send to your store with the status 'Pending' the stock quantity of all ordered products in that order will get inserted in the table products.products_on_hold and the store will not show the 'add to cart' button in product_info.php if the products_quantity is 1 pcs and the products_on_hold is 1 pcs. It will display the text 'On Hold / Reserved' (see screenshots) When you (the store owner) have accepted/confirmed the payment at paypal.com then the ordered products_quantity & products.products_on_hold from that order will be updated. Now the order is final and the ordered quantity is not anymore in on hold status. NOTE: if your store uses other pages with a 'buy now' or 'add to cart' button then there will be updates needed in those files. see the changes in (and use your coding skills or use the contribution forum): product_info.php includes/modules/product_listing.php TODO: - update the review pages in catalog root - make a CRON job or so for orders made but not payed or no IPN returned from paypal - delete order option when the PayPal payment is not completed or other then Pending / Completed - add products.products_on_hold to admin/catagories.php etc...
  19. Druide

    [Contribution]Paypal IPN - Devosc

    :( sorry my brain was messed up, i was thinking of an option in a different module (Global Quantity Module). If you can do some PHP coding i am sure you can fit it in.... I am VERY sorry, i should do like i normally do , first verify my answer before i hit the Add Reply button.
  20. Druide

    [Contribution]Paypal IPN - Devosc

    why dont you turn off the usage of GV in paypal for the moment and send your customers an email about it. Safe is always the best way
  21. Druide

    i dont no why i bother

    First you start by counting to 10 take a deep breath and start over with the documentation, or maybe you ask the wrong questions, try to reformated them that always will help and the best answer is ALWAYS the SEARCH function. You should try it because ALL answers are answered many many many times before you came across this forum. No offence but Patience is STILL a virtue, if you lose your temper on this forum then you'll have a bad name and trust me not many people are then willing to help you anymore. WE remember names here !
  22. Druide

    Paypal IPN admin errors

    good news there is a new version, i dare you !!!! LOL
  23. it has NOTHING todo with PayPal IPN but only your setting in Table Rate !!! wrong question search for table rate
  24. This is a contribution in development, when a customer pays by bank or credit card this 'addon' does NOT funtion properly i noticed 2day because it substracts the stock ONLY when a IPN Pending or Completed is received. DO NOT install on a production site, your stock will not update correctly, sorry for that...
  25. Druide

    [Contribution]Paypal IPN - Devosc

    look for the addon i wrote http://www.oscommerce.com/community/contributions,2416 which does exactly what you want BUT there are still some issues to figure out, i would not suggest to use it on a production site but just to test it. It's a contribution in development, when a customer pays by bank or credit card this 'addon' does NOT funtion properly i noticed 2day because it substracts the stock ONLY when a IPN Pending or Completed is received. I dunno when i can work on this more because i will be out of town most of the next 2 weeks, also my bithday in between where is the time that i need ? I guess something has to be put 'on hold' like the PayPal_Shopping_Cart_IPN_v2.6a (addon only) i wrote