What?
A quick article on how to set a password using the database tools for super users.

Why?
It happens to us all, especially me. I like to use different passwords for every site but this came up as a client had lost their super user password.

How?
This method is reliant on having access to the database of your Joomla website.


What?
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:
copyraw
$db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true')
  1.  $db->query('SELECT * FROM #__myTable WHERE condition1=true or condition2=true') 


Method #1 - chain:
Category: Joomla :: Article: 569

Applies to: What?
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.


Applies to: What?
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.


Applies to: What?
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.


What?
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.


Applies to
  • 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".

What?
This is a quick note on one reason you may get the above error in a Joomla CMS environment.

copyraw
Call to a member function mark() on a non-object in /public_html/index.php
  1.  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.
Category: Joomla :: Article: 536

What?
I'm writing a Joomla 2.5.x component for logging time and projects and need a dropdown to have selectable options restricted to the logged-in user. This is specified in the XML file of the custom Joomla component and needs some SQL dependent on some dynamic variables.

Why?
In Joomla, the XML type of "sql" is extremely limited. The component I'm making has to ensure user's can only see their own projects and not everyone's:
copyraw
SELECT * FROM #__projects ORDER BY name

-- yields all projects irrespective of which user is logged in
  1.  SELECT * FROM #__projects ORDER BY name 
  2.   
  3.  -- yields all projects irrespective of which user is logged in 
What I want:
copyraw
SELECT * FROM #__projects WHERE user_id=<logged_in_user> ORDER BY name
  1.  SELECT * FROM #__projects WHERE user_id=<logged_in_user> ORDER BY name 

Please Note: This article focuses on a front-end form dropdown. If you would like to see how to do modals for the admin panel, see my article Joomla article modal with clear button for Joomla article selection.

How?
Category: Joomla :: Article: 530

What?
I'm making a custom component for Joomla CMS 2.5.x which is restricted to registered users only. On installation, and by default, the menu item returns a 500 - Server Error because the parameters haven't been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything.

How?

Applies to:
  • Joomla! CMS 2.5.x

Joomla Filter: Validation OnSave
  • INT Forces the value to be an Integer

  • UINT Forces the value to be an absolute number (-4.2 becomes 4.2)

  • FLOAT Forces the value to be a floating point value

  • BOOL Forces the value to be true or false

  • WORD Strips anything that is not letters (including numbers)

  • ALNUM Forces the value to be alphanumeric (Letters and numbers only. No special characters)

  • CMD Forces the value to be alphanumeric plus the following three special characters _ (underscore) . (dot) - (dash)

  • BASE64 Forces the value to be a base64 encoded the string. Note it does not encode the string, it simply strips characters that may not exist in a base 64 encoded string.

  • STRING Removes HTML

  • HTML Allows basic HTML

  • ARRAY Forces value to be an array

  • PATH Forces value to be a file path

  • USERNAME Forces value to only contain characters allowed in the selection of a Joomla username

  • UNSET Completely remove any input

  • RAW Allow any content

  • URL Forces content to be a URL

  • TEL Forces content to be a properly formatted US phone number

Credit where Credit is Due:


Feel free to copy, redistribute and share this information. All that we ask is that you attribute credit and possibly even a link back to this website as it really helps in our search engine rankings.

Disclaimer: Please note that the information provided on this website is intended for informational purposes only and does not represent a warranty. The opinions expressed are those of the author only. We recommend testing any solutions in a development environment before implementing them in production. The articles are based on our good faith efforts and were current at the time of writing, reflecting our practical experience in a commercial setting.

Thank you for visiting and, as always, we hope this website was of some use to you!

Kind Regards,

Joel Lipman
www.joellipman.com

RSS Feed

Related Articles

Joes Revolver Map

Joes Word Cloud

find   license   script   form   website   used   field   first   version   work   need   create   creator   server   database   uploaded   report   code   order   would   using   following   user   joomla   file   date   list   note   function   parameter   zoho   value   files   added   mysql   table   name   windows   google   deluge   source   system   display   time   case   error   page   where   data   client   JoelLipman.Com

Accreditation

Badge - Certified Zoho Creator Associate
Badge - Certified Zoho Creator Associate

Donate & Support

If you like my content, and would like to support this sharing site, feel free to donate using a method below:

Paypal:
Donate to Joel Lipman via PayPal

Bitcoin:
Donate to Joel Lipman with Bitcoin bc1qf6elrdxc968h0k673l2djc9wrpazhqtxw8qqp4

Ethereum:
Donate to Joel Lipman with Ethereum 0xb038962F3809b425D661EF5D22294Cf45E02FebF
© 2024 Joel Lipman .com. All Rights Reserved.