ITVault Solutions http://www.itvault.com/ This is a development forum for osCommerce Integration. en Sun, 05 Sep 2010 10:32:00 GMT vBulletin 60 http://www.itvault.com/images/misc/rss.png ITVault Solutions http://www.itvault.com/ Very simple numbered draw http://www.itvault.com/threads/59-Very-simple-numbered-draw?goto=newpost Tue, 31 Aug 2010 16:27:40 GMT In our site, we'd just need to configure a place where to sell numbers for a draw.

The only requirement is that stock of number of articles (concrete number in the draw) goes from 1 to 0 as soon as payment is confirmed, so none can buy repeated numbers.

Ofcourse we need to keep record of the user who bought every number, rather in a public way than private.

Would it be possible through your solution with osCommerce ?? ]]> Request Your osCommerce Integration Here pcasfer http://www.itvault.com/threads/59-Very-simple-numbered-draw <![CDATA[Bug when username contains ' apostrophe character]]> http://www.itvault.com/threads/58-Bug-when-username-contains-apostrophe-character?goto=newpost Thu, 26 Aug 2010 10:11:09 GMT We have a user whose username looks like this: re'M'ington

He gets the following error on accessing the shop:

Code:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'M'ington', 'm', 're'M'ington', 'sdfsdf@sdfsdf.com', '0', '1')' at line 1

insert into osc_customers (customers_id, customers_username, customers_gender, customers_firstname, customers_email_address, customers_default_address_id, customers_newsletter) VALUES ('800', 're'M'ington', 'm', 're'M'ington', 'sdfsdf@sdfsdf.com', '0', '1')

[TEP STOP]
Obviously something to do with the ' ' in his username. Any ideas for a fix?

thanks,

Alex ]]> Please Report Any Bugs or Problems in the Shop alexm http://www.itvault.com/threads/58-Bug-when-username-contains-apostrophe-character Possible show your site running this script http://www.itvault.com/threads/57-Possible-show-your-site-running-this-script?goto=newpost Thu, 26 Aug 2010 08:06:00 GMT Would you add an area for those who purchased the software from you to show our sites running it? Just curious. Would you add an area for those who purchased the software from you to show our sites running it? Just curious. ]]> ITVault Testimonials / Feedback DamienDarwick http://www.itvault.com/threads/57-Possible-show-your-site-running-this-script Possible https problem http://www.itvault.com/threads/56-Possible-https-problem?goto=newpost Thu, 26 Aug 2010 07:49:05 GMT I have a SSL for my site where I can use the https format in my urls, but it does not seem to be working. I edited both configure files to put the... I have a SSL for my site where I can use the https format in my urls, but it does not seem to be working. I edited both configure files to put the https url in them, but it does not go into https at all. Do you have a solution for this or know why it maybe doing this? ]]> General Discussion DamienDarwick http://www.itvault.com/threads/56-Possible-https-problem Pre-sales question http://www.itvault.com/threads/55-Pre-sales-question?goto=newpost Wed, 25 Aug 2010 18:20:29 GMT Hi, - Does this install like a vB 4.x product? - Is the shop running on this site what it is like, including my account / Cart Content /... Hi,

- Does this install like a vB 4.x product?
- Is the shop running on this site what it is like, including my account / Cart Content / Checkout?
- Can the code add users to a certain group when they have ordered & paid?
- Can I test drive (the back end) somehow?
- Is there any support / documentation for importing shop content and / or orders? I have a proprietary code with a few hundred shop items and a few thousand customers and orders?
- Can I install this on an active vB site, hide the shop (from regular users) until it is configured and ready?

Thanks in advance ]]> General Discussion janaf http://www.itvault.com/threads/55-Pre-sales-question Adding payment modules http://www.itvault.com/threads/54-Adding-payment-modules?goto=newpost Sat, 21 Aug 2010 21:22:29 GMT Just tried adding the moneybookers payment module.

Its a simple upload only addon, and i've tried 3-4 times and no joy.

do i need to change a few lines of code? ]]> Please Report Any Bugs or Problems in the Shop AndrewR32 http://www.itvault.com/threads/54-Adding-payment-modules Request http://www.itvault.com/threads/53-Request?goto=newpost Fri, 13 Aug 2010 08:19:18 GMT Im looking to get this addon, but cant see how or where to buy/download. website is www.midnightclub.ie Cheers Andrew Im looking to get this addon, but cant see how or where to buy/download.

website is www.midnightclub.ie

Cheers
Andrew ]]> General Discussion AndrewR32 http://www.itvault.com/threads/53-Request Footer copyright problem you should know about http://www.itvault.com/threads/52-Footer-copyright-problem-you-should-know-about?goto=newpost Tue, 10 Aug 2010 15:28:59 GMT If you delete the banner in your cart admin are it deletes the entire thing including the footer links for your site. I personally am not going to... If you delete the banner in your cart admin are it deletes the entire thing including the footer links for your site. I personally am not going to use the banner system that is built in and probably quite a bit of others will not use it either. I had to add your link manually into my footer so that your link was still there since I have not purchased any brand free option. Here is what I had to do to add the same info that you had for the links...

open packages/shop/includes/footer.php

FIND:

Code:
?>
<?php
  if ($banner = tep_banner_exists('dynamic', '468x50')) {
?>
And change to:

Code:
?>
<br>
<table border="0" width="100%" cellspacing="0" cellpadding="0">
  <tr>
    <td align="center" class="smallText"><a href="http://www.itvault.com"> vB Osc Shopping Cart Pro v1.0.6 </a> Copyright &copy; 2010 ITVault Solutions (<a href="http://www.oscommerce.com">osCommerce 2.2</a> Integrated)</td>
  </tr>
</table>
<?php
  if ($banner = tep_banner_exists('dynamic', '468x50')) {
?>
That adds the footer links back into the script. you guys might want to set this where it cannot be removed just by deleting the banner. ]]> General Discussion DamienDarwick http://www.itvault.com/threads/52-Footer-copyright-problem-you-should-know-about Possible time limit on purchase? http://www.itvault.com/threads/51-Possible-time-limit-on-purchase?goto=newpost Tue, 10 Aug 2010 00:20:14 GMT I was wondering if there is or a way to make it where members can purchase an item and then there is a time limit on the item like one year where... I was wondering if there is or a way to make it where members can purchase an item and then there is a time limit on the item like one year where then their support license will expire and it will prompt them to purchase support for another year. Kinda like vBulletin used to be, I would also like to know if its possible to have people have to put in the site URL when they purchase the product. I'll be selling skins for various scripts. ]]> Requests DamienDarwick http://www.itvault.com/threads/51-Possible-time-limit-on-purchase