Assuming 1 is required, the following 337 results were found.
-
Security Checklistshttps://www.joellipman.com/articles/cms/joomla/security-checklists.html
the gist of http://docs.joomla.org/Security_Checkli … omla_Setup is as follows: Security Checklist 4 - Joomla Setup 1. Install official versions of Joomla 2. Change the default administrator username 3. Protect directories and files 4. Adjust file and...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: *
-
> Module Manager > Banner... What I do is I don't select a client but instead just select a category. Set it to only display 1 banner at a time. If you want other categories to display, consider setting categories as vertical, horizontal and square...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
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: $query ->where($db->quoteName('condition1') . ' = '. $db->quote('true'),'OR')...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
lost their super user password. How? This method is reliant on having access to the database of your Joomla website. Method #1: Quickest way I know This is based on if you have another user account (registered or administrator, any) with a password...
- Type: Article
- Author: Joel Lipman
- Category: Joomla
- Language: en-GB
-
// redirects to something like: https://lh3.googleusercontent.com/=w320 Methods of getting the File ID #1 Right-click on the file and select "Get Shareable Link". If link sharing is already on, it will display a link such as:...
- Type: Article
- Author: Joel Lipman
- Category: Google
- Language: en-GB
-
have to select a color or expression first, then define which border (top, right, bottom, left) the settings apply to... Mad. 1. Type your expressions/specify color first: 2. Specify which border of the cell this applies to:
- Type: Article
- Author: Joel Lipman
- Category: SQL Server Reporting Services
- Language: en-GB
-
Installer? http:///userdisp.aspx=ID=1 Paying attention to the URL this will show you the domain and username of this accountname in Active Directory. I know the AD domain and username, show me the person!...
- Type: Article
- Author: Joel Lipman
- Category: SharePoint
- Language: *
-
given comma delimited string into a database table: Given: "Title,Forenames,Surname" Return: ID Value ------ ---------------- 1 Title 2 Forenames 3 Surname Note the below example omits the ID column and just leaves VALUE. Why? Do we need a reason? How?...
- Type: Article
- Author: Joel Lipman
- Category: Databases
- Language: *
-
has been displayed). Basically what I used to do is something similar to the following: SELECT counter_field_value FROM table1 WHERE column1='this_article' Add 1 to counter_field_value UPDATE table1 SET counter_field_value= WHERE column1='this_article'...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
Strip HTML in MySQLhttps://www.joellipman.com/articles/else/database/mysql/strip-html-in-mysql.html
complaining about the delimiter, create the function by running the following: SET GLOBAL log_bin_trust_function_creators=1; DROP FUNCTION IF EXISTS fnStripTags; DELIMITER | CREATE FUNCTION fnStripTags( Dirty varchar(4000) ) RETURNS varchar(4000)...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: en-GB
-
SELECT columnID, columnFullName, CASE WHEN columnFirstName LIKE @ThisSearch THEN 20 WHEN columnFullName LIKE @ThisSearch THEN 10 WHEN columnLastName LIKE @ThisSearch THEN 10 WHEN columnFullName LIKE @ThisSearch THEN 1 END as relevance FROM myTable WHERE...
- Type: Article
- Author: Joel Lipman
- Category: MySQL
- Language: *
-
I shrink the browser, I get a heading like this: I want this to happen: The code of this is the addedn overflow:hidden;height:1%;: A long heading that wraps over several lines Source(s): Stack Overflow - make div's height expand with its content
- Type: Article
- Author: Joel Lipman
- Category: Cascading Stylesheets
- Language: *
-
trim(substr($this_date, 0, strpos($this_date, " ")))); $this_time=trim(substr($this_date, strpos($this_date, " ")+1)); $formatted_datetime=implode("/", array_reverse($this_date_array))." ".$this_time; Replace the variable names and the SQL column and...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
date format or daylight savings time. $today=date("Y-m-d"); $yesterday = date('Y-m-d', mktime(0, 0, 0, date("m") , date("d") - 1, date("Y")));
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: en-GB
-
a cup of tea the solution was glaringly obvious, just do a primary school mathematics table and it all makes sense (see my 10 mod table below). This article is a quick note (so I never spend as long again) in PHP on how to determine when looping through...
- Type: Article
- Author: Joel Lipman
- Category: Personal Home Page
- Language: *
-
some text you have copied off the web and into an MS Excel document. How? Open up a new workbook. Get into VBA (Press Alt+F11) Insert a new module (Insert > Module) Copy and Paste the Excel user defined function below Sub ExtractHL() Dim HL As Hyperlink...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB
-
long numbers into exponential notations (which are incorrectly rounded anyway). My Data: Account ID,Name,Phone,Record ID 1457102000000135533,Joel,00441234567890,1457102000000165989 1457102000000135566,Stanley,01709123456,1457102000000167543...
- Type: Article
- Author: Joel Lipman
- Category: Excel
- Language: en-GB