3 Support questions or comments

• 
  Jun 8, 2017
  Simon6 Purchased

  Hello again. Is there a built-in way to make mySQL queries, or do I need to build my own functions for that?
  
  Thanks
• 
  Jun 8, 2017
  VincentM Author

  Hello,
  
  There is no buit-in way to make MySQL queries.
  To prevent SQL injections all sql queries uses PDO statements.
  Example with getting firstname and lastname from the connected user, $_SESSION['user_id'] :
  $dataBase = database__driverPDO();
  $sql = $dataBase->prepare('SELECT firstname, lastname
  FROM pr__user
  WHERE id = :id';
  $sql->execute(array('id' => decrypt($_SESSION['user_id'], $config['KeySessionID'])));
  $user = $sql->fetch();
  $sql->closeCursor();
  
  Then to display firstname / lastname:
  echo $user['firstname'];
  echo $user['lastname'];
  
  You will find examples of SELECT with LEFT JOIN, UPDATE and INSERT sql queries with PDO statements in the phpRegister script pages.
  
  Regards,
  Vincent.
• 
  Jun 12, 2017
  Simon6 Purchased

  Perfect, that's exactly what I was looking for - thanks a lot!
  
  Simon

• 
  Jun 4, 2017
  Simon6 Purchased

  That's great.
  
  I've been playing around with the script and I really like it - it is really easy to use - thanks again.
  
  I have another question though.
  
  I have a strange problem - when I go to https://www.mysite.com/account/details/ everything works ok. When I click on 'User Support' I am taken to the ticket page no problem. However, now when I click back to 'Details' the page goes to http://www.mysite.com/account/details/ (HTTP instead of HTTPS) and I get a few errors in console:
  
  Access to Font at 'https://www.mysite.com/include/fonts/font-awesome-4.7.0/fonts/fontawesome-webfont.woff2?v=4.7.0' from origin 'http://www.mysite.com' has been blocked by CORS policy: No 'Access-Control-Allow-Origin' header is present on the requested resource. Origin 'http://www.mysite.com' is therefore not allowed access.
  
  Do you know why this might be happening?
  
  Sorry for all the questions!
• 
  Jun 4, 2017
  VincentM Author

  That's strange, the links are generated with the global variable $config['URL'].
  Links of Details from Account part are displayed from the function show__accountTop() in the file account_display.inc.php.
  <a href="'.$config['URL'].'/account/details">'.LANG_Global_Details.'</a>
  
  Can you edit this function to show the result of this variable:
  
  Add at the end show__accountTop() :
  echo $config['URL'].'/account/details';
• 
  Jun 4, 2017
  Simon6 Purchased

  Thanks. I have added that line and the correct address is being outputted (with HTTPS) - the URL within the link is correct - however for some reason when I click on the link I am taken to the HTTP page.
  
  I see it doesn't happen on your demo so must be something I have done wrong - I'll have a look through the code and let you know if I figure it out.
• 
  Jun 4, 2017
  Simon6 Purchased

  I use CloudFlare and it looks like CloudFlare is giving a 301 redirect for that page. I'm not sure why but I'm sure I'll figure it out. Thanks again.

• 
  Jun 4, 2017
  Simon6 Purchased

  Hello,
  
  I am having trouble getting this setup - when I create the test-email.php file I get this error:
  
  Notice: Use of undefined constant _PATHROOT - assumed '_PATHROOT' in /home/xxxxxxx/public_html/include/php/emails/email_global_send.php on line 9
  
• View 4 more replies
• 
  Jun 4, 2017
  VincentM Author

  Hello,
  
  You must define the constant _PATHROOT. This constant define how many subdirectories before the root directory, for example _PATHROOT = '../'; for the file index.php in the directory contact.
  If you put your file test-email.php on root directory, then _PATHROOT = '';
  
  About emails, if you want to check the layout, you can modify the file index.php which is in the directory include/php/emails/displaytest/
  https://demo.phpregister.com/demo-website/include/php/emails/displaytest/
  
  Regards,
  Vincent.
• 
  Jun 4, 2017
  Simon6 Purchased

  Thanks a lot for your fast response. Is the _PATHROOT info in the documentation somewhere? - I couldn't find anything about it. Thanks.
  
  That makes sense now though, thanks a lot.
  
  Thanks for the email template info too.
• 
  Jun 4, 2017
  Simon6 Purchased

  Also. Do you have any plans to add Twitter oauth to the login choices? That would be great for my project if possible. Thanks
• 
  Jun 4, 2017
  VincentM Author

  With pleasure,
  Yes, _PAHTROOT is mentioned on the documentation here https://phpregister.com/notice/php-js-css-files-structure/#filesPHP
  
  I will update it to be more specific.
• 
  Jun 4, 2017
  VincentM Author

  Twitter OAuth has not been added because people having a twitter account have generally a facebook account as well.
  I have found a good example of Twiiter OAuth here:
  https://stackoverflow.com/questions/6550337/twitter-oauth-php-need-good-basic-example-to-get-started (zoomi reply)
  Twitter should be added and will be available on next release.
  
• 
  Jun 4, 2017
  Simon6 Purchased

  Thanks a lot.
  
  This script looks really great - thanks for creating it.
  
  Just back to the _PATHROOT query. When I installed phpRegsiter I followed the configuration steps as setout in the documentation, including copying and pasting the code for email-test.php - did I miss something along the way not to know that I had to add the _PATHROOT constant to the file as well? I've gone back over the instructions and by following them step by step we aren't told about _PATHROOT.
  
  No problem as I now understand it - but might be worth updating the instructions for future users.
  
  Thanks again.
• 
  Jun 4, 2017
  VincentM Author

  Thank you I appreciate your comments.
  
  I have updated the documentation on the creation of the test-email.php file.
  https://phpregister.com/notice/oauth-script-configuration/#config_smtp.inc.php
  
  And also about the email options:
  https://phpregister.com/notice/php-js-css-files-structure/#Sendemail