Author: admin

Malware – Remove Security Shield 2012

If Malwarebytes Anti-Malware is already installed on the infected computer.
In order for this to work, you must already have Malwarebytes Anti-Malware version 1.60 or later already installed on your infected PC.
Open the program folder for Malwarebytes Anti-Malware (normally C:\Program Files\Malwarebytes’ Anti-Malware or C:\Program Files (x86)\Malwarebytes’ Anti-Malware)
Once there, open the Chameleon folder
Next, double-click on iexplore.exe. This should result in a black DOS/command prompt window opening up.
Press any key to continue as it says in the window
Malwarebytes Chameleon will proceed to update Malwarebytes Anti-Malware, so ensure that you are connected to the internet if possible
Once the update completes and it says your database is updated, click on OK
Malwarebytes Chameleon will then terminate any threats running in memory, which may take a while, so please be patient
Upon completion, Malwarebytes Anti-Malware will open automatically and perform a Quick scan
Once the scan is complete, click on Show Results and remove any threats that are found by clicking Remove Selected
If prompted to restart your computer to complete the removal process, click Yes
After your computer restarts, open Malwarebytes Anti-Malware and perform one last Quick scan to verify that there are no remaining threats

Microsoft Excel – Merge Cells

Example:

The example may be easier to understand if you copy it to a blank worksheet.

Column (A) – First Name: Sara
Column (B) – Last Name: Davis
Column (A) – First Name: Brad
Column (B) – Last Name: Sutton

Formula Description (Result)

=A2&” “&B2 Combines the names above, separated by a space (Sara Davis)
=B3&”, “&A3 Combines the names above, separated by a comma (Sutton, Brad)
=CONCATENATE(A2,” “,B2) Combines the names above, separated by a space (Sara Davis)

Note The formula inserts a space between the first and last names by using a space enclosed within quotation marks. Use quotation marks to include any literal text — text that does not change — in the result.

iPhone Ringtones

https://gigaom.com/2008/08/07/free-custom-iphone-ringtones-using-only-itunes/

Free Custom iPhone Ringtones Using Only iTunes
Blog By Jenny Kortina

Create free ringtones for your iPhone using only iTunes and songs you already have on your computer (This method only works with songs that are DRM free. To create ringtones using DRM protected songs please use this method). This method has been tested and works with … Read More »

Create free ringtones for your iPhone using only iTunes and songs you already have on your computer (This method only works with songs that are DRM free. To create ringtones using DRM protected songs please use this method). This method has been tested and works with iTunes 7.7.1 and iPhone 2.0.1 firmware.

To create custom ringtones using only iTunes:

Right click on the song you are going to make into a ringer and select “Get Info.”
Go to the options tab and go down to the “Start Time” and “Stop Time” check boxes. Check both boxes and input the time you want your ringer to start/stop. The ringer has to be 30 seconds or less. Click OK when you’re done.
Right click on your newly “clipped” song and select “Convert Selection to AAC.” The song will be re-encoded using the start and stop times determined (If your menu item does not read “Convert Selection to AAC” and reads “Convert Slection to MP3″ (or some other format) please go to iTunes > Preferences > Advanced > Importing and change the “Import Using” drop down menu to “AAC Encoder”).

After the song is done encoding navigate to your iTunes Music folder, locate your song, and drag it to your desktop. After the song is on your desktop go back to iTunes and delete the clipped version from you iTunes library (It won’t delete it from your desktop, it will only remove it from iTunes).
Go back the song on your desktop and right click on your song and chose “Get info.” Go to the name and extension section and change the extension from .m4a to .m4r (or you can just change the extension right from your desktop)
After the extension is changed simply double click on the file to add it to your iTunes library under the ringtones section. Sync your phone with iTunes and you’re done!
Remember to go back into iTunes and uncheck your custom start and stop times for the original version of your song.

Microsoft Outlook 2016 – Gmail Not Working

There is a security issue with Gmail itself. Go to Gmail, click on your profile icon and “My Account”. In the center of the screen, click on “Your personal info”. Near the bottom, in light gray color, click on “Check your security settings”. Scroll down to “Allow less secure apps” and change the setting to “ON”.

WordPress – Gallery Template for Gallery Plugin Shows Extended Search Area Beneath Gallery

Use GoDaddy Control Panel, File Manager and Search (Control-F) the Gallery Templates (gallery-single-template.php) & (gallery-template.php) and remove the line: <?php get_sidebar(); ?>

Look in public_html, find wp-contents folder\themes\tempera

If the files don’t exist in the tempera folder, copy them from the public_html/wp-content/plugins/gallery-plugin/templates folder.

WordPress – Counterize Web Stats Date Is Incorrect

Counterize II stats for “Today” in the WordPress admin dashboard were reseting back to zero in the middle of the day!

This is because the php script is querying the database for those stats based on the web server’s timezone, which was UTC, in my case. I needed the script to query based on my timezone. It was a very easy fix:

Somewhere in the beginning of the counterize.php script, add the line:

date_default_timezone_set(‘America/Chicago’);

Of course, change the America/Chicago to your timezone.