Joomla WHERE clause with OR
- Category: Joomla
- Hits: 13476
A quick article on how to use the where clause in a joomla database query.
Why?
In response to a member, I use the old form where I can include the whole SQL statement:
$db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')
Method #1 - chain:
ReCaptcha alternative: Integrate PlayThru in JComments 3.0 for Joomla 3.2
- Category: Joomla
- Hits: 231692
- Joomla CMS v3.2.3 (Joomla.org)
- jComments v3.0.0 (JoomlaTune.com)
- PlayThru v1.1.8 (AreYouAHuman.com)
This article is a follow on from my article JComments 2.3 with PlayThru (Joomla 2.5.x) but this is for a later version of the components using the alternative called PlayThru by AreYouAHuman.Com.
Why?
The kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments. Google's ReCaptcha is overrun by click farms and is unable to authenticate engaging visitors.
How?
So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha.
ReCaptcha alternative: Integrate PlayThru in JComments 2.3 for Joomla 2.5
- Category: Joomla
- Hits: 153002
- Joomla CMS v2.5.11 (Joomla.org)
- jComments v2.3.0 (JoomlaTune.com)
- PlayThru v1.1.8 (AreYouAHuman.com)
This article is a follow-up of my article JComments 2.3.0 with Google ReCaptcha (Joomla 2.5.x) but instead of using ReCaptcha, we're going to use an alternative called PlayThru by AreYouAHuman.Com.
Why?
The kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments.
How?
So I have come up with what I consider a pretty stable solution. I adapted it from various legacy solutions when using Google's ReCaptcha.
JComments 2.3.0 with ReCaptcha in Joomla 2.5.x
- Category: Joomla
- Hits: 186566
- Joomla CMS v2.5.11 (Joomla.org)
- jComments v2.3.0 (JoomlaTune.com)
Posting this as it was rather rewarding to achieve and I hope will be of some use to others in the same boat. This article details how to replace jComments built-in kCaptcha with Google's ReCaptcha. Note that I have an article on how to do this with a ReCaptcha alternative called PlayThru by AreYouAHuman.com
Why?
The kCaptcha used by the jComments extension is easily automated and no longer blocks spam comments.
How?
So the main bulk came from the JoomlaTune website but as it was a forum post that may get moved/deleted, I've copied most of it and put it here with my minor revisions/adjustments to get it actually working.
Export Joomla Users script
- Category: Joomla
- Hits: 15891
Somebody said I could pay to get an export list of my Joomla users. I said Joomla is a FREE OpenSource system, why?
Why?
I want to move a client's list of Joomla users to a new system which allows the passwords to be in MD5. All I want is a quick bit of code to get all the users out of a Joomla CMS.
How?
I could just type a query on the database and get the same result, but this script was more fun. Simply create a text file with the following code and upload it to the root of your Joomla website. Access the page from a browser and you should get all your users listed... For security reasons, delete the file after you have used it.
IT IS A SERIOUSLY BAD IDEA TO LEAVE THIS FILE ON YOUR WEBSITE FOR ANYONE TO ACCESS!!! DELETE IT AFTER USE.
Registered Users Cannot Login - Super Users Can
- Category: Joomla
- Hits: 32714
- Joomla CMS v2.5.14
What?
This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered" users would not be able to login, despite their status in the admin panel saying "enabled" and "activated" (not blocked).
If I used a test account, none of the Joomla groups, not even "Administrators" could login. However set the same test account to a "Super User" and they would be able to login. Was the problem authentication? Restricted access to a component? A load of blab on ACL managers?
How?
In our case, the website had recently been migrated from Joomla 1.5.x to 2.5.x. I asked to examine the database and a quick scan in the assets table revealed 3 assets had the parent_id = 0. Only one asset can have that and that is "root".
ReCaptcha disappears from Joomla 2.5 Registration
- Category: Joomla
- Hits: 29330
This is an extract from a forum which solved our problem for why the ReCaptcha part disappears from the user registration form. We have Joomla 2.5.16 installed and no new updates for a plugin that comes with Joomla 2.5 install.
How?
Source: Joomla! • View topic - Cannot get recaptcha to display on registration form...
There are two solutions I have found that fix the problem:
Call to a member function mark() on a non-object in Joomla CMS
- Category: Joomla
- Hits: 28908
This is a quick note on one reason you may get the above error in a Joomla CMS environment.
Call to a member function mark() on a non-object in /public_html/index.php
How?
Not really a solution here because this is indicating that the system can't find the core framework files. Yes the bad news is you have lost your site. The good news is that it's only the core files and component files. Here are some tips when restoring the site to return it to as it was.