Gamer

$products_new['products_description'] . does not exist in the products_new.php file.

Not to worry, compared files and got it sorted.

HI RDB, If I have v2.0 installed, can I simply over write the respective ot_insurance.php files with the new 2.0.1 version, or are there changes in the readme file to make manually too? Thanks

Thanks for the reply. I have changed the settings as described above with the latest spiders.txt contrib. Now I find the same thing as AllThingsTrendy is, with the bots stopping only on cookie_usage.php page and nothing else.

Everyone, sorry to labour the point about settings...but I am battling to consolidate all the info from 24 pages that refer to cookies, sessions, spiders etc. Can someone list the optimal settings that one should have regarding all this type of stuff? Thank you.

This is easy. Around line 248 of /admin/whos_online.php replace this line: document.write(' - Last Refresh: ' + (Stamp.getMonth() + 1) +"/"+Stamp.getDate()+ "/"+Stamp.getYear() + ' '); with this line: document.write(' - Last Refresh: ' +Stamp.getDate()+ "/"+ (Stamp.getMonth() + 1) +"/"+Stamp.getYear() + ' '); and your date will be in DD/MM/YYYY format.

Is there a reason why some of the IP's have a comma (,) after them and in the clickable IP Lookup URL?

Anyone?

Hi all, This is a popular contribution and I was wondering if some clever person/s could add the ability to update/change the available date (products expected date) in the Quick Updates along with the already updateable features such as name, price etc. Thanks a ton http://www.oscommerce.com/community/contributions,122

thanks guys. Got it sorted. My store is heavily modified over the last 2 or 3 years, so it looks like I missed one or two of those additions.

joma, I seem to have a problem with the changes your contrib makes to admin/categories.php. If I try to take a product and choose COPY TO, then the next option is to say whether you want to duplicate or link the new copied product, if I choose the DUPLICATE, I get the following error: 1136 - Column count doesn't match value count at row 1 If I choose to link to a different category there is no error, but if I duplicate to the same category, the error occurs. Any idea's?????

What I did was the following: Instead of trying to go and add short descriptions for all of my 500 odd products, I changed the 'short_desc' field to VARCHAR(200) from TEXT and then ran the following statement in phpmyadmin. update products, products_description set products.short_desc = products_description.products_description where products.products_id = products_description.products_id This statement copied the contents of the full product description in our new short description field, limiting it to 200 characters in total though. This would leave some words cut off in the middle of the word, so I added something like: '... <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products['products_id']) . '">' . TEXT_MORE . '</a>' and defined TEXT_MORE in the language file so that the short description now looks something like this: Now for every new product you add to your store, you can simply just add a short description when adding the product and this has saved you from trying to add a short description to every product. Enjoy and thanks a ton to Joma!!!!!!

not to worry about my last question. Got it sorted. thanks.

joma, thanks mate. I am currently working on using your contribution. Instead of going to try to enter new short descriptions for 500 odd products, I just wish to copy from my products_description field in the short_desc field. Anybody know the SQL command to update field short_desc (in table 'products') from field products_description (in table 'products_description'). I know the command: UPDATE table_name set field1 = field2 would make field1 equal to field2 in the same table, but do not know how to update from outside tables....can someone help me with this?

Pleasure, I just wish someone would help me with my original post that started this thread :'(