Homeslice - Just Like a Boss

-- MYSQL Cookbook. Make databases and tables, create a user, set his password -- the password shown here " PutYourFavePasswordHere " should be changed to your -- preferred password, before running these scripts. -- Instructions: -- SSH into your MYsql server or open a dos prompt on your server -- use this command to logon to mysql as the root user:   mysql -u root -p -- Copy & paste these scriptlets into the window, or save them to a file, and use -- this command to run them:  source afile.sql; -- that's all. -- -- MAKE A DATABASE FOR MAGENTO CE EDITION DROP database magento_ce; CREATE DATABASE magento_ce; USE magento_ce; GRANT ALL ON magento_ce.* TO magentosql@localhost IDENTIFIED BY ' PutYourFavePasswordHere '; FLUSH PRIVILEGES; -- ADD AN ISAM TABLE FOR STORE LOCATIONS   CREATE TABLE IF NOT EXISTS `location` ( `id` int(10) NOT NULL AUTO_INCREMENT, `lat` varchar(256) NOT NULL, `lan` varchar(256) NOT NULL, `name` varchar(128) NOT NULL, PRIMARY KEY (`id`) ) EN...

--------------------- Feb 15, 2015 ------------------------------- My Building Permit: Some have asked what I've been doing in retirement. Well, I applied for a building permit for a new house. It was going to be 100 ft tall and 400 ft wide, With 12 gun turrets at various heights, and windows All over the place and a loud outside entertainment sound system. It would have parking for 200 cars, and I was going to paint it Snot green with pink trim. The City Council told me “Forget it...AIN'T GONNA HAPPEN!” So, I sent in the application again, but this time I called it a "Mosque." Work starts on Monday. And here is the best part, it's going to be tax exempt! I love this country. It’s the government that scares the shit out of me. -------------------- Feb 23, 2015 -------------------------------- We had a guy walking his Magellanic penguin down the side walk in town.   When the police chief saw him, he told him not to walk the penguin there, but take i...

Stupid tricks that you can do using PHP in the Magento CE backend: 1) Search the Product Catalog function getProductIdsBySearch ( $searchstring , $storeId = '' ) { $ids = array (); // Code to Search Product by $searchstring and get Product IDs $product_collection = Mage :: getResourceModel ( 'catalog/product_collection' ) -> addAttributeToSelect ( '*' ) -> addAttributeToFilter ( 'name' , array ( 'like' => '%' . $searchstring . '%' )) -> load (); foreach ( $product_collection as $product ) { $ids [] = $product -> getId (); } //return array of product ids return $ids ; } Magento 1.7+ Source: StackOverflow 2) Find an image in a product 3) Automatic Color Swatches for Products with different colors, each being their own product Search the product catalog for items with the exact same name, find the image called ...

How to Configure The Avocent DSR 4020 The Avocent DSR 4020 is a legacy/old skool keyboard video, mouse (KVM) server with a network management interface, and a DB9 serial port based management interface.  Unfortunately, the remote console feature requires Java JRE 1.6. (6u45)  It has 16 ports.  The bank of RJ45 jacks on the back are NOT network jacks, instead you need to use DSIQ dongles to connect them to video and USB ports on your servers.   You can also get DSIQ dongles with PS/2 connectors.  Both network and serial interfaces can be used to configure the KVM.  The serial interface is a closely guarded secret.  If you bought a used KVM from ebay, you can use Serial to reset and wipe out the password.  The Avocent manuals do not explain this port.  We will explain how to use it.  If you need assistance with your Avocent, call us, we can help .  Consider hiring a real IT pro to properly install your KVM. Check out our low IT...

while installing MS CRM 2011 or 2013 you get this stupid message and all activtiy grinds to a halt: "The instance name must be the same as computer name" it happened because you took a virtual machine template and cloned it, and renamed it, and then started to use it immediately without any consideration of the SQL server within. You have to rename the MSSQL server. use these commands one by one: in the master database to query the binds  SELECT @@Servername to drop the invalid name  Sp_dropserver 'OLD_SERVERNAME' to add the correct machine name  Sp_addserver 'ACTUAL_MACHINE_NAME',local  These command are case sensitive, so be careful.  Finally, restart the MSSQL services, and close and reopen the MSSQL studio. This KB tidbit applies to MSSQL 2008 R2 Enterprise, Windows Server 2008, MS CRM 2011

Historic Java Releases - why are they trying to force Java 8 onto us? Download JRE 1.6 https://www.oracle.com/java/technologies/javase-java-archive-javase6-downloads.html Download java SE 8 http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html http://www.oracle.com/technetwork/java/javase/downloads/index.html http://www.oracle.com/technetwork/java/javase/archive-139210.html http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase7-521261.html http://www.oracle.com/technetwork/java/javase/downloads/java-archive-downloads-javase7-521261.html#jre-7u60-oth-JPR The Very Last Java 7 - 7U80 http://www.oracle.com/technetwork/java/javase/downloads/jre7-downloads-1880261.html How to Install Java Silently http://www.itsupportguides.com/configmgr-sccm/install-sun-java-update-silently/ ---------------------------- INSTALL.BAT ------------------------------------------- @echo off cls echo ----------------------------...

Download Full Versions of Adobe Flash and Download Archived Versions I am just as irritated as you are that I have to keep on finding new versions of Adobe Flash for my auto-install scripts. Damn Adobe keeps on publishing buggy versions of Flash that have to be replaced every month or so. We just need complete stand-alone installation packages to support automated desktop setup scripts, and you need a full and complete adobe flash installer package. So Here they are: everything from version 14 to version 18... go get it! August 30, 2019 https://helpx.adobe.com/flash-player/kb/installation-problems-flash-player-windows.html July 20, 2019 ------------------------------------------------------------------------------ Download debug versions https://www.adobe.com/support/flashplayer/debug_downloads.html Download Archived Versions and Developer Versions https://helpx.adobe.com/flash-player/kb/archived-flash-player-versions.html December 21, 2014 - Old Links to Download F...

Introduction: My organization had over 700 fields in the Lead Object, had to pare it down to 662 so that the Rollup 16 database schema updater could create a view called FilteredLead.  First task is to delete enough fields in the Lead object and/or the Account object so that the FilteredLead view would have less than 1024 fields. And then next task is to copy the MSSQL database from production machine to another dev machine running CRM2011. Installing Rollups is a neccessary and dreaded evil that is necessary to obtain bug fixes and new features in CRM 2011 http://support.microsoft.com/kb/2555051 Steps: Build a new CRM 2011 Server that has Windows 2008 R2 Enterprise x64 with SP1, IIS 7.0, Microsoft SQL Server 2008 R2 Enterprise, every Visual Studio Runtime from 2005 to 2013, Dot net framework 4.5, IE9.0, not IE 10 or 11, because they break the CRM Installer Splash Screen. Configure the SQL Report Server.  Install SSL Certs. Lastly, install CRM2011, {server, email route...

How to Install Exchange 2010 on Windows Server 2008 R2 SP1 Using Windows Server 2008 R2 X64 - with SP1 joined to a Domain Roles: Application Server, DNS Server, File Services, Web Server (IIS) Features: RSAT, Telnet Client, Windows TIFF Filter, .Netframework 3.5.1 In Server Manager, Add Roles for Application Server plus IIS, Plus Dot net 3.5 Install Dot net framework 4.5.1 install ALL Visual Studio VC-REDISTS from 2005 to 2013 x 64 and x86 Do not install SMTP Service! Turn on TCP Sharing To enable the Net.TCP Port Sharing Service using MMC http://msdn.microsoft.com/en-us/library/ms733925%28v=vs.110%29.aspx Install 2007 Office System Filter pack from http://go.microsoft.com/fwlink/?LinkID=123380 Using Exchange 2010 install media, choose to install everything but U.C. Licensing Steps: Install Service Packs: SP1, SP2 etc... Install SSL Certificates in IIS

Install every single Visual Studio Redist package (VC Redist) silently and install Dot Net Framework 4.5.1 silently, install IE11 prerequisites, and then finally install IE11. Download all components from Microsoft.com, and save to a folder.  But, first disable UAC! Open a MSDOS command prompt AKA cmd.exe, then run these commands from a batch job. color 4f vcredist_2005SP1_x86.exe /Q vcredist_2005SP1_x64.exe /Q vcredist_2008SP1A_x86.exe /q vcredist_2008SP1A_x64.exe /q vcredist_2010SP1_x86.exe /passive /norestart vcredist_2010SP1_x64.exe /passive /norestart vcredist_2012U4_x86.exe /install /passive /norestart vcredist_2012U4_x64.exe /install /passive /norestart vcredist_2013_x86.exe /install /passive /norestart vcredist_2013_x64.exe /install /passive /norestart NDP451-KB2858728-x86-x64-AllOS-ENU.exe /norestart /passive  Windows6.1-KB2533623-x64.msu /quiet /norestart Windows6.1-KB2670838-x64.msu /quiet /norestart Windows6.1-KB2729094-v2-x64.msu /quiet /norestar...

@echo off REM Create VBS that will get day of week in same directory as batch echo wscript.echo WeekdayName(Weekday(Date))>>DayOfWeek.vbs REM Cycle through output to get day of week i.e monday,tuesday etc for /f "delims=" %%a in ('cscript /nologo DayOfWeek.vbs') do @set dow=%%a REM delete vbs del DayOfWeek.vbs REM Used for testing outputs days name echo %dow% REM Case of the days name is important must have a capital letter at start REM Check days name and assign value depending IF %dow%==Monday set downum=0 IF %dow%==Tuesday set downum=1 IF %dow%==Wednesday set downum=2 IF %dow%==Thursday set downum=3 IF %dow%==Friday set downum=4 IF %dow%==Saturday set downum=5 IF %dow%==Sunday set downum=6 REM print the days number 0-mon,1-tue ... 6-sun echo %downum% REM set a file name using day of week number set myfile=%downum%.bak echo %myfile% pause

Windows XP Time Sync Note: Set the W32Time Parameters HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\w32Time\Parameters NtpServer:  pool.ntp.org,0x1