Cristián Lávaque

Hi Edward. No, nothing firmer yet.

Got ya. Yeah, it doesn’t make sense…

I’m emailing Jason to notify him of this problem. Is the login info you submitted before still valid? He will probably need it.

Well, MySQL is not super efficient when it comes to complex queries either… I think doing the two quick queries and then working with the results in PHP may be faster. You get the complete list of users, get the list of users with last_activity time and then add it to the other.

You could have the user_id as the keys of the users array. Then when you loop the results fo the last_activity query, just do something like [hilite code]$users[$user_id]['last_activity'] = $last_activity_time;[/hilite]

Okay. :)

Well, I’m not very experienced with MySQL…

Are you trying to get a list of all the user IDs and their last_activity time if they have one? I don’t know if a single query could return that.

The problem with usermeta is that -from what I’ve seen- if the user doesn’t have that field, it’s not just empty, it doesn’t even exist for the user. No row is created with that user_key for that user if it was never stored.

What I’d do is two queries: one for the [hilite mono]`users.ID`[/hilite] list and another for the [hilite mono]`usermeta`.`user_id`[/hilite] with a [hilite mono]last_activity[/hilite]. Then work with the results in PHP.

I hope that helps. :)

Hi Dean.

Are you talking about a link in BuddyPress? I guess you’d have to find if there’s a setting for it or edit the template where it is.

No problem. :)

Hi Malin.

In my form I have set accept=”paypal” (only paypal) and if I only put one form an o page it looks great. If I put more than one form there they ask for billing adress and card information. This should only appear if I accept cards, which I don’t.

This is because of the JavaScript problem that happens with more than one pro-form in the page. The other payment options in the pro-form are enabled/disabled by the JS.

Thanks.

Are both for the same transaction? I ask because I noticed the RTN log entry with the error is missing the item number, but the IPN log has it and the entry looks okay. The item number should not be missing.

Are you using the s2Member shortcodes? Could you quote the shortcode you’re using?

Could you send me the link to the page where you’re using the shortcode, please? s2Member® » Private Contact Form

Thanks!

Hi Derek,

Could you try this?

Create this folder/file: /wp-content/mu-plugins/s2hacks.php

[hilite pre_code]

Hi Brian.

1. Is it possible?
2. If Yes, is it difficult?

If WP E-Commerce is a WP plugin, then you may be able to restrict access to it using s2Member’s URI restriction. [hilite path]Dashboard -› s2Member® -› Restriction Options -› URI Access Restrictions[/hilite]

Or do you mean selling s2Member access through WP E-Commerce? If so, then no, unless you create a customization/hack to achieve it.

3. Is there any way to track purchases and downloads of free materials (i.e., whitepapers, etc) for those who are logged in?

The tracking of what you sell with WP E-Commerce may be a question for them. Or you can try tracking services like Google Analytics or scripts like Prosper202, but this is not something I can help with.

Bonus: I know there’s been chatter about greater integration with ecommerce on the next major upgrade, so when is that expected???

Sometime this Summer is the last estimate Jason gave and that I have. This integration may help in the case of you wanting to sell s2Member access through another system like WP E-Commerce.

Where do I put this? I dont see a mu_plugin dir

/wp-content/mu-plugins/s2hacks.php

If you don’t have the folder or file, just create it. :)

2) Thats fine I will create my own, however. I need to know a few things, where does the Token
thats in the email creation link (http://screencast.com/t/mVmlvr83Mb) stored? Like I after
successfull checkout. I want the user to be taken to the signup page immediatly. Not wait for
and email. This will cause us plently of support headaches, as i have experince in my market.

The short link is created in this file: s2member\includes\classes\utils-urls.inc.php. The link isn’t stored anywhere, it’s just sent to the user. You could hack the file to save a copy of the link somewhere.

You can use other URL shortening services, too. [hilite path]Dashboard -› s2Member® -› General Options -› URL Shortening Service[/hilite]

Also, how does it verify that it was a successfull payment, so that the use can create an account
I do not see any custom DB tables that would store this info. Can you please advise how this
process works so i can code the solutions I need here

When the person is taken from ClickBank to your site’s [hilite mono]s2member_pro_clickbank_return[/hilite] URL, s2Member reviews the data ClickBank includes there and s2Member, after confirming the payment was done, sets a cookie in the user’s browser that will let him register (even when registrations are closed) and give him the access he just paid for.

There are rare exceptions when s2 can’t confirm the payment right away because of a delay in ClickBank, so the user won’t be able to register with a regular link to the registration page, but the special registration link in the Confirmation Email will still be sent as soon as possible and that link includes authentication that will let him register and give the paid access to the new account too.

The successful payment is not stored in the database either, only in the logs if you have those enabled. If the registration link is being sent in the confirmation email, then the payment was successful in s2Member’s eyes, and you could go with that.

4&5) These are both recurring.

I see. s2Member currently only works with a single subscription. If the user started a new subscription, then s2Member would replace the previous one with the new one.

Now say the user buys the First Recurring product. He will be sent to
an upsell where we will offer another recurring upgrade. The way it is now. This will make the user
go through the clickbank checkout proccess twice, and create 2 subscriptions. Which is fine
however I was talking to a former clickbank employee about the upsell process. All they do is
store the payment data for that session internally, and then when the user clicks the upsell button
it simply rebills the user and then it goes to the thank you page. I dont know all the variables yet
but this would be cool if s2 would keep this in mind on a future release.

Yes, this, and several things related to the previous points mentioned, are being improved in or considered for the new s2Member being developed. :)

No problem. :)