1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [#3017] including a php file during a plan registration ?

[#3017] including a php file during a plan registration ?

12 years 5 months ago #183246 by krileon
Replied by krileon on topic Re: including a php file during a plan registration ?

Any idea to correct this ?

I've fixed the script and confirmed it will no longer duplicate. REPLACE wasn't working as it should have and wrote an IF case for INSERT INTO or UPDATE for all REPLACE queries. The script is also commented if you'd like to review and understand the changes.

Do you mind if I quote you or mention this forum post ?

Use whatever you like as it's a public forum, but please understand my opinion is that of my own and not of Joomlapolis. :)

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
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 CST to 4:00 PM CST. 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.

Please Log in to join the conversation.

12 years 5 months ago #183448 by activha
Replied by activha on topic Re: including a php file during a plan registration ?
Thanks a lot Kyle for all your help :-)

Please Log in to join the conversation.

12 years 3 months ago #188563 by activha
Replied by activha on topic Re: including a php file during a plan registration ?
Hi Kyle,
We have a problem with the script mentioned, it is not correctly posting accented characters

For instance whenever I try to update the DB with a person called Agnès FI the DB fields are Agnès FI

Could you tell me what needs to be changed in order to correctly post accented characters ?

Thanks in advance

Please Log in to join the conversation.

12 years 3 months ago #188576 by krileon
Replied by krileon on topic Re: including a php file during a plan registration ?
No idea, I don't have the original script. You'll need to review its source and determine what needs changed. It's likely the escaping, but you may also want to ensure your database collation is set to UTF8 as Joomla/CB are UTF8.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
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 CST to 4:00 PM CST. 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.

Please Log in to join the conversation.

12 years 3 months ago #188633 by activha
Replied by activha on topic Re: [#3017] including a php file during a plan registration ?
Yes all is set to UTF 8
The script is the one you attached and corrected a few posts above. I joined it again

I was wondering whether the data posted by CB could be wrongly encoded, which could explain the problem with accented characters

Could you check ?


File Attachment:

File Name: cb_update_...ptv2.zip
File Size:2 KB
Attachments:

Please Log in to join the conversation.

12 years 3 months ago #188647 by krileon
Replied by krileon on topic Re: [#3017] including a php file during a plan registration ?
No idea, don't see anything wrong. At any rate added a function to force mysql encoding to UTF8, which might do the trick. It's also possible the characters could be getting messed up on Joomla/CBs end before the script gets them, but I can't say for sure.

Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
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 CST to 4:00 PM CST. 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.
Attachments:

Please Log in to join the conversation.

Moderators: beat, nant, krileon
  1. Forums
  3. Support and Presales
  5. Professional Members Support
  7. [#3017] including a php file during a plan registration ?
Time to create page: 0.247 seconds

Facebook Twitter LinkedIn

    You are here:  
  1. Home
  2. Forums
  3. Support and Presales
  4. Professional Members Support
  5. [#3017] including a php file during a plan registration ?

Search

Login / Logout

User Menu