Jump to content
Sign in to follow this  
Iggy

CCGV - PHP5.3 - mySQL 5

Recommended Posts

Hi there,

 

For you regulars on the board, what are you using for Credit Class & Gift Vouchers at this point?

 

I see the debate continues between the free for all Credit Class & Gift Voucher

http://addons.oscommerce.com/info/282

 

and CCGV(trad)

http://addons.oscommerce.com/info/4135

 

 

I'm building my store on PHP 5.3 and just gave trad (May 2007 release) a whirl. It "works" but will require more fussing than I'd like to put into it. Is anyone working on a CCGV that's PHP5.3 compliant?

 

At any rate, if your priority was using 5.3/mySQL 5 which contributions would you start with?

 

URLs and release dates please and thanks!

Iggy


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

Hmmm, perhaps Burt's is the new hotness? I suppose I'll give it a whirl.

 

Are these the current big 3 then in CC/GV technology?

 

Burt's Gift Voucher (GV) and Discount Coupons (DC) for RC1, RC2, RC2a

http://addons.oscommerce.com/info/5743

 

Credit Class & Gift Voucher

http://addons.oscommerce.com/info/282

 

and Vger's CCGV(trad)

http://addons.oscommerce.com/info/4135

 

Anything else I should be looking at?


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

And Burt's the current King of the Credit Class hill! Nicely done Burt and thanks for your work! Installed easy and worked the first time without having to try and track down why some things were passed correctly or not. I kind of love that :lol: :thumbsup:


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

Now... who has recommendations on a Gift Voucher contribution for the same spec? Or do I keep talking to myself?

Edited by Iggy

Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

OK. Back to CCGV(trad) because I just can't let it go.

 

Currently it's semi-functional; can add or delete(make inactive) coupons.

 

The weirdness comes into play when inserting the coupon into the database from preview (where it passes everything in correctly).

 

On insertion it throws this error

Warning: mysql_insert_id() expects parameter 1 to be resource, null given in /www/EosC_3.0ccgv/catalog/admin/includes/functions/database.php on line 117

 

And writes everything to the coupons and coupons_description tables correctly but fails to display the coupon name viewing it from coupons_admin.php

 

This is line 117 in functions/database.php

function tep_db_insert_id($link = 'db_link') {

global $$link;

 

return mysql_insert_id($$link);

}

 

and reviewing MS2 this is the function previously - and which makes everything work as expected when swapped into the current running store

 

function tep_db_insert_id() {

return mysql_insert_id();

}

 

So I am prepared to be schooled if there's a teacher in the house :D

 

Thanks for any clarification or input you can provide.

Iggy

Edited by Iggy

Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

It's not easy being impatient and dumb at the same time I tell you what :rolleyes:

 

Part of the problem - line146 of coupon_admin.php in CCGV(trad)

$insert_id = tep_db_insert_id($query);

 

Golly if this edit doesn't get it working

$insert_id = tep_db_insert_id();

 

I suppose that makes sense (??) given the new function? Still not really understanding why it's throwing the error and failing to relate the 2 tables with ($query) but beggars can't be choosers :P


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

I'll be darned...

 

Sub-Total: $84.98

Flat Rate (Best Way): $5.00

Total: $89.98

Discount Coupons:DoIt: -$42.50

 

Shouldn't that be 42.49? Sigh...


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

GV functionality for my system is something that I

have started work on, but other things tend to take

priority over it.

 

If only there were 40 hours in a day !

 

Well, I'm looking forward to it! - GV not 40 hours a day :lol:

 

On this side of the world we're barely getting 8 hours of sunshine so it kind of feels like 40 hours a day...


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

I'll be darned...

 

Sub-Total: $84.98

Flat Rate (Best Way): $5.00

Total: $89.98

Discount Coupons:DoIt: -$42.50

 

Shouldn't that be 42.49? Sigh...

 

Only happens when the coupon is restricted to a category or product. Wasn't this problem addressed back in 2005? Well, the board will provide I'm sure :P


Everything's funny but nothing's a joke...

Share this post


Link to post
Share on other sites

I am also very interested in a decent Gift Voucher system!

 

Any news on how it is progressing? Also, do I go ahead and install version 5.21 that I have just downloaded, or would it be better to wait for the new GV functionality and load the new version?

Share this post


Link to post
Share on other sites

It's not easy being impatient and dumb at the same time I tell you what :rolleyes:

 

Part of the problem - line146 of coupon_admin.php in CCGV(trad)

$insert_id = tep_db_insert_id($query);

 

Golly if this edit doesn't get it working

$insert_id = tep_db_insert_id();

 

I suppose that makes sense (??) given the new function? Still not really understanding why it's throwing the error and failing to relate the 2 tables with ($query) but beggars can't be choosers :P

 

this amendment seem to have this same problem i had

 

thanks

valerif

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×