Connect to Joomla database in standalone scripthttp://mail.joellipman.com/articles/cms/joomla/connect-to-joomla-database-in-standalone-script.html

17 August 2012 .DS.'import.php' ); //DB Connection $Config = new JConfig(); $db_driver = $Config->dbtype; // Database driver name $db_host = $Config->host; // Database host name $db_user = $Config->user; // User for database authentication $db_pass =...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted my webhost, and the problem is the number of MYSQL database queries. It goes up to about 200,000 in the first few minutes of use and then...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Connection Strings for SQL Serverhttp://mail.joellipman.com/articles/microsoft/sql-server/connection-strings-for-sql-server.html

05 January 2011 Logging=false; SevenObjects MySqlClient Type: .NET Framework Class Library Usage: Manufacturer: SevenObjects Standard Host=myServerAddress;UserName=myUsername;Password=myPassword;Database=myDataBase; dotConnect for MySQL (former MyDirect.NET and Core...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server
• Language: *

Country Lookup by IP address CSVhttp://mail.joellipman.com/articles/database/mysql/country-lookup-by-ip-address.html

17 March 2013 Uncomment the drop statement if running for the second time. Modify the PHP file to use database login credentials, $db_host = "localhost"; // Database host name $db_user = "my_database_user"; // User for database authentication $db_pass =...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: *

Client Services: Website Development Agreementhttp://mail.joellipman.com/static-items/client-services-website-development-agreement.html

15 November 2013 website. A support agreement is drawn up with regards to maintenance, upgrades and repairs (for how long?). [Optional] Web Hosting: A separate agreement will need to be made if JoelLipman.Com is to host the production and development websites after...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Accessing Apimo WebService APIhttp://mail.joellipman.com/articles/automation/api-misc/accessing-apimo-webservice-api.html

29 March 2016 so I don't have to spend so much time on it again. Note that the below examples, demonstrate a script on a Non-SSL-Enabled host. How? Previously, I would have used cURL but for some reason, I couldn't get the configuration right. After several days... I...

• Type: Article
• Author: Joel Lipman
• Category: API Miscellaneous
• Language: *

Zoho: Email Deliverability / SPF / DKIM / DMARC / Toolkithttp://mail.joellipman.com/articles/crm/zoho/zoho-email-deliverability-spf-dkim-dmarc-toolkit.html

04 May 2023 itself will depend on your mail server or the domain registrar's website to manage your DNS: Create a TXT record Specify the Host as 1522905495316._domainkey.mycompany.com // Important: if hosted by GoDaddy, Ionos, FastHosts, and similar domain...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

List last modified files using FTP Command-linehttp://mail.joellipman.com/articles/web-development/ftp/list-last-modified-files-using-ftp-command-line.html

20 November 2012 I don't have a clue. Here's what I've got so far: Open a command-prompt (Start > Run > Type COMMAND > OK) Type ftp my_ftp_host (where "my_ftp_host" is the hostname or IP of the server holding my site) Enter login credentials Type dir (lists files &...

• Type: Article
• Author: Joel Lipman
• Category: File Transfer Protocol
• Language: *

Community Builder in Joomla Vulnerabilityhttp://mail.joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 Malware Detected! Warning: Visiting this site may harm your computer! The website at.....ru appears to host malware - software that can hurt your computer or otherwise operate without your consent. Just viisting a site that hosts malware can infect...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

Developer's Checklist: Taking over a projecthttp://mail.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 via file upload). It included it's own timesheet / session management / invoicing system. The website was held on a virtual host running PHP and MySQL. There was no documentation, logs, notes, and any code comments were in Hungarian (later found out it...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Joes Network Transmission Detector (JTD)http://mail.joellipman.com/component/content/article/joes-network-transmission-detector-jtd.html?catid=40

29 September 2011 desktop background: In Development Read data packets without causing network traffic (tried tcpdump, pcap) IP and resolved host names on double-click without causing network traffic (tried netstat. NTS: try this again with dll calling) Program used to...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

Access MySQL databases using Oracle SQL Developerhttp://mail.joellipman.com/articles/database/mysql/access-mysql-databases-using-oracle-sql-developer.html

01 February 2013 connection (or click on the plus sign in the connections tab), select the mySQL tab and complete the login details and host location... Done! Additional I wouldn't recommend using Oracle SQL Developer. You have to use mostly SQL to create tables and...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Autohotkey Count Number of Files/Folders in a Directoryhttp://mail.joellipman.com/articles/automation/autohotkey/autohotkey-count-number-of-files-folders-in-a-directory.html

04 June 2013 0, 1 count++ -- note for future use: ; if A_LoopFileAttrib contains H,R,S ; continue This works fine at home on your local host on a local drive. Try using this over a networked drive and more time will be spent counting the files then the actual...

• Type: Article
• Author: Joel Lipman
• Category: AutoHotkey
• Language: en-GB

Copy a Wordpress Site for Developmenthttp://mail.joellipman.com/articles/cms/wordpress/copy-a-wordpress-site-for-development.html

08 March 2015 just for myself to quickly modify a Wordpress configuration file. // ** MySQL settings - You can get this info from your web host ** // /** The name of the database for WordPress */ define('DB_NAME', 'my_database_name'); /** MySQL database username */...

• Type: Article
• Author: Joel Lipman
• Category: Wordpress
• Language: en-GB

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 response will advise that it is running zet at https://127.0.0.1:5000 along with the instructions “please enable the host (https://127.0.0.1:5000) in a new tab and authorize the connection by clicking Advanced -> Proceed to 127.0.0.1 (unsafe)”. This...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho CRM: Schedule a Meeting using Delugehttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-schedule-a-meeting-using-deluge.html

02 March 2022 // // all day meeting m_ScheduleMeeting.put("All_day",false); // // meeting owner/host ID (can see any record related to this meeting) m_ScheduleMeeting.put("Owner",123456789012345678); // // related to what (in this example, a lead record but can be...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Amazon Kindle: Send PDFs to your Kindlehttp://mail.joellipman.com/amazon/kindle/amazon-kindle-send-pdfs-to-your-kindle.html

29 June 2022 and Privacy Settings. Click on the Devices heading to show the Device Summary Under Device Summary, you will be shown a host of information related to your device, which includes the email address associated to your Kindle. Copy and save the email at...

• Type: Article
• Author: Joel Lipman
• Category: Kindle
• Language: *

ZohoCRM & ZohoWriter: Generate Rich-Text / HTML Email Signatures in CRMhttp://mail.joellipman.com/articles/crm/zoho/zohocrm-zohowriter-generate-rich-email-signatures-in-crm.html

05 December 2023 bottom of the email message. How? So there are a few issues with displaying images which would have other solutions, such as hosting the images on a web-server, or converting to a base64 or an SVG. ZohoCRM signatures seem to be unable to handle a lot of...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Analytics: Create a Monitoring System with Imageshttp://mail.joellipman.com/articles/crm/zoho/zoho-analytics-create-a-monitoring-system-with-images.html

25 July 2024 Have all the images you want to use ready for uploading into the system stored on your device. A URL (as in an image hosted on another website) can be used so you might skip the first section here where I demonstrate how to upload photos to be hosted by...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *