... of each word in your database column by order of most used first (replace 'mydbprefix_content' with the name of your database table AND `introtext` with the name of your column):
SELECT SUM(`total_count`) ...
... the following:
/* Specify a blank prefix which is fully transparent */
ul.breadcrumb a span:before {
opacity:0;
content: '';
transition: all 1s ease;
transition-property: width, opacity;
}
/* ...
... respective database tables are prefixed with "v25_" and "v34_". So an example MySQL statement will be:
`v25_db`.`v25_tablename`
-- with the database name and table prefix of database you are READING ...
... Added Joomla! Admin Option: Sort Words By (shuffle, alphabet, frequency)
- Added Joomla! Admin Option: Sort Words Order (ascending, descending)
- Prefixed language file references with JWC to avoid conflicts ...
Applies to:
TravelPort Universal API
PHP 4 or 5
cURL
What?
An article on how to resolve errors and setup a standard ping request using the TravelPort Universal API. This is to be achieved using ...
... match the term (eg. for "about" do SELECT * FROM #__menu WHERE alias LIKE '%about%' where #_ is the table prefix)
Instead of deleting, I change the existing menu item alias from "about-us" to "about-us2" ...
What?
A quick article on how to create a middleware script which accepts the values from a submitted HTML form and sends it to a server on another domain for processing. This applies to Linux Apache ...
... database table (where #_ is the prefix to your joomla tables)
Find the column password and the row of your known user and Copy the text there
Find the row of your forgotten user and Paste the text ...
... will display all the files to be renamed
Return to the notepad (rename.bat) and take out the remark "REM" prefix so your code becomes:@ECHO OFF
SETLOCAL ENABLEDELAYEDEXPANSION
FOR /f "tokens=*" %%a IN ...
... was not the same as our staging one which this package gets as its source):
-- here we are pretending the lookup tables are prefixed with "lookup_"
SELECT
x.[sequenceID],
x.[student_reference],
...
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 ...
...
Open the #__assets tablewhere #_ is the Database Tables Prefix value found by logging into your Joomla admin panel Browse to Site > Global Configuration > Server > Database Settings : Database Tables ...
... to the Joomla 1.5.x website
Browse the table "jos_components" (or "#__components" where "#_" is the site table prefix. default is "jos").
Open the row where name="User Manager"
Set the value under params ...
... ValueToConvert = ValueToConvert + " ";
// tranformation exceptions: words to be lowercased
// note the prefixed spaces so as not to lowercase words ...
... trust these more than my all-in-one GUI applications.
How?
Note: we're using the code in a DOS Batch program so our variables have to be prefixed with a double-percent rather than just the one:
-- ...
... "10" comes before "8" and it does but just to check, let me pad the 8 with the prefixing zero:
Annoyingly "10" still comes before "08" so maybe I'm barking up the wrong tree. If I padded ...
... when this is better but I'm just trying to add a link to our Sharepoint 2007 portal.
How?
Add a link with the prefix File:// and complete the rest of the path as per usual. Sharepoint will correct ...
... need to add "COLLATE Latin1_General_CS_AS" after the column this affects.
More collations can be found by going to MSDN's SQL Server Collation Name page.
Limitations
Trailing spaces or prefixing ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.