Kyle (Krileon)Community Builder Team MemberBefore posting on forums:
Read FAQ thoroughly
+
Read our Documentation
+
Search the forumsCB links:
Documentation
-
Templates
-
CBSubs
-
Hosting
-
Forge
-
Incubator
-
GroupJive
--If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please
send me a private message
with your thread and will reply when possible!
--Please note I am available Monday - Friday from 8:00 AM EST to 4:00 PM EST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.

We cosponsored the Moset Tree "Plugin" and we not only use if for publishing/unpublishing but also for registrering the price on the listing (because we sort after price, so the highest paid ads are on top).

I am trying to apply membernumber to our users/members. So when they subscribe they get a member number. The code I used is below. what I would really like is a way to automate the process. Use the SQL feature to save the last membernumber and then use it to assign a new member with a new number by adding one and then saving it again in a last membernumber table. this process works when i run SQL in phpMyAdmin but not with CBsubs. Can someone help?

Code:

UPDATE '#_comprofiler'
SET
'cb_membernumber'=1
WHERE 'user_id'=[user_id]

As you can see at this time I am only trying to add a number to a singe user who subscribed.

I am trying to apply membernumber to our users/members. So when they subscribe they get a member number. The code I used is below. what I would really like is a way to automate the process. Use the SQL feature to save the last membernumber and then use it to assign a new member with a new number by adding one and then saving it again in a last membernumber table. this process works when i run SQL in phpMyAdmin but not with CBsubs. Can someone help?

Code:

UPDATE '#_comprofiler'
SET
'cb_membernumber'=1
WHERE 'user_id'=[user_id]

As you can see at this time I am only trying to add a number to a singe user who subscribed.

Forgot to mention that I tried to use the CB Fields, but it doesn't work. All it does is enter the what I put in to the value box, even when I select the Field=Field+Value option.

I am not sure why CB is so restrictive. I have been trying for months to find a way to automate our membership number generation but no luck. It is disappointing at the least that no one has a solution for me. Can't believe we can't accomplish this even which such costs involved in getting this product.