Update mysql with select clause as the updated value
You are missing a from clause: UPDATE t_topics SET topic_title = (SELECT t_posts.post_subject FROM t_posts WHERE t_posts.post_id = t_topics.topic_first_post_id ) WHERE topic_id = 2; ...
How to enable/modify phpbb url to work just like html?
Just wish to share this.. Looks like there is no way to do this using htaccess.. It was confirmed by KevC - Support Team Member Phpbb https://www.phpbb.com/community/viewtopic.php?f=466&t=2319241...
External login using Google for PHPBB 3.1
I figured out how to do this: Create a "Login with Google" button for example and link it to: http://www.example.com/forum/loginoauth.php?mode=login&login=external&oauth_service=google Here is my loginoauth.php file: <?php // phpBB inclusion protection define('IN_PHPBB', true); $phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './'; $phpEx = substr(strrchr(__FILE__, '.'), 1); require($phpbb_root_path . 'common.' . $phpEx); //...
Arabic Alphanumeric with spaces only regex
You can check if your Regex flavour supports this \p{Arabic} or \p{InArabic} try: $regex = '[\p{Arabic}\d-\[\]_+ ]+' ...
Varnish / nginx, some url's redirecting to :8080 in phpbb?
I also ran into this issue some time ago. I found the answer to this at: http://serverfault.com/questions/227742/prevent-port-change-on-redirect-in-nginx You can turn of the port forwarding for redirects in nginx by setting port_in_redirect off; ...
force https on login
Apache If you are admin Redirect Request to SSL But I think you aren't: Apache Redirect HTTP to HTTPS using mod_rewrite .htaccess RewriteEngine On RewriteCond %{HTTPS} off RewriteRule (.*) https://%{HTTP_HOST}%{REQUEST_URI} ...