Change the next due date or the next invoice date for a client in WHMCS

There’s a time when you need to change the due date for multiple products. You can easily do that for one product. It is difficult to do that for multiple products. You have to change it one at a time and the WHMCS is not very user friendly doing that. You have to navigate through 4 clicks for every product. That’s very time consuming. You should be able to change the due date for a client or set of products for that client within the client’s profile dashboard. Until then, the fastest way to do that is through phpMyAdmin or by running a SQL command.

Navigate to the tblhosting table in your phpMyAdmin. You normally find phpMyAdmin in the cPanel Databases section.

The command is simple when you need to change the due date for every product for a particular client. You first need to find out the unique client id. You can easily find it by heading over to the clients page. Next run the SQL command to update the nextduedate record for that client:

UPDATE `tblhosting` SET `nextduedate` = '2018-03-01' WHERE `tblhosting`.`userid` = 2;

To change the next invoice date, which sometimes can get out of sync with next due date, change the nextduedate in the command line to the nextinvoicedate like the following example:

UPDATE `tblhosting` SET `nextinvoicedate` = '2018-03-01' WHERE `tblhosting`.`userid` = 2;

And that’s it. Every product for client with id of 2 is due at new date.

You can tweak the same command to change prices based on set of products but not all of them. For example, you want to change the due date, or the price for one product for one client. First find the id of the product. You can do that by navigating to Setp>Product/Services>Product/Services and click edit on the product you want the price changed. Look at the number at the end of the url, that’s the id for that product: …/admin/configproducts.php?action=edit&id=19. Once you have the id of the product and the client, the SQL command looks like this:

UPDATE `tblhosting` SET `nextduedate` = '2018-03-03' WHERE `tblhosting`.`userid` = 2 AND `tblhosting`.`packageid` = 19;

As you can see it’s fairly simple to change records of products for a client.

Google Drive. Keep everything. Share anything.

 

Access everywhere.

Google Drive is everywhere you are—on the web, in your home, at the office and on the go. So wherever you are, your stuff is just…there. Ready to go, ready to share. Get started with 5 GB free.

 

Google Drive is available for:

  • PC and Mac
  • iPhone and iPad (coming soon)
  • Android devices

 

Google +1 Button has a flaw

I was playing around with Google’s new +1 Button and while reading the documents about the API one thing interested me is the <link> attribute. According to the documentation you can tell the API to use the current URI or the main URL of the website. Then I was thinking, what if you mask the URL, let’s say use the google.com URL on your site? You guessed right, your site will show that it has been +1 around 4,000 times as of today.

Google +1 Button
Google +1 Button

Here’s the code for this,

<!– Place this tag in your head or just before your close body tag –><link rel=”canonical” href=”http://www.google.com”><script type=”text/javascript” src=”http://apis.google.com/js/plusone.js”></script><!– Place this tag where you want the +1 button to render –><g:plusone></g:plusone>

Here’s a live view of the code:

Note: When clicking it, you are still giving a +1 to Google.com, you’re only spoofing your site to look like it’s popular.

 

 

How to remotely uninstall software?

There’s a lot of times when you just want to uninstall a piece of software without interrupting the end user, but unfortunately there isn’t an easy, out of the box way to do it.

To uninstall software on a local machine without any user interaction, you would do something like this:
msiexec.exe /norestart /qn /x {2902F983-B4C1-44BA-B85D-5C6D52E2C441}

The last part, after /x is the GUID of installed software. To find out the guid on remote software, download this script from here and run this command:
cscript /B SwInventory.vbs RemotePC > RemotePC.txt

Open RemotePC.txt and look for GUID.

Next you need PsExec from SysInternals. This tool will allow you to run commands on the remote computer.

Once you find out the GUID of the software that you need to uninstall, you can make a batch file with msiexec.exe command on it. Like:
msiexec.exe /norestart /qn /x {2902F983-B4C1-44BA-B85D-5C6D52E2C441} and name it uninstall.bat

If you need to uninstall more than one software, just create new lines with new GUIDs, example:
msiexec.exe /norestart /qn /x {2902F983-B4C1-44BA-B85D-5C6D52E2C441}
msiexec.exe /norestart /qn /x {18455581-E099-4BA8-BC6B-F34B2F06600C}

Next you run PsExec tool and copy and run the batch file to the remote with command:
psexec remotepc -c uninstall.bat

You will need to run cmd as an administrator in order to be able to execute remote commands.

If the software uninstalled successfully, you will get error code 0, if not, it will say something like “this action is only valid for products that are currently installed.”

This will be useful when you need to uninstall same software from multiple computers. An antivirus product is a good example if you are upgrading to another one.

Windows Small Business Server (SBS) 2008 transition / migration to Server Standard 2008 R2

(First appeared here)

This is an action plan from Microsoft tech support.  I’m going to be testing this in my Lab over the next week or so.  I’ll post any significant notes or corrections that I find.

1.       Run ADprep on SBS 2008 with the Windows 2008 R2 disk.

·         Insert the media for Windows Server 2008 R2 into the Small Business Server 2008 server.

·         Browse to the following folder:

·         <DVD drive >:SourcesAdprep> Adprep /forestprep

·         Press C, and then press ENTER. Wait for the process to complete.

·         <DVD drive >:SourcesAdprep>Adprep /domainPrep

·         when this step completes, you should receive a message: “Adprep successfully update the domain-wide Information” Continue reading “Windows Small Business Server (SBS) 2008 transition / migration to Server Standard 2008 R2”

After system repair, Windows Activation Wizard won’t run

http://social.technet.microsoft.com/Forums/en/itproxpsp/thread/b991ce21-db5b-46eb-8c9b-f8d4aa14a35a?prof=required

HERE’S THE FIX…

Download Internet Explorer 8 and Hotfix KB946501, burn them to disc

Hotfix KB946501 http://support.microsoft.com/default.aspx/kb/946501
Internet Explorer 8 http://www.microsoft.com/windows/internet-explorer/default.aspx

Start your PC and repeatedly hit F8 to get the safe mode menu.

Choose safe mode with command prompt only (if you are unable to enter safe mode otherwise)

When the command prompt appears type “explorer”

Should load the Windows GUI behind the cmd window

Install the KB946501 hotfix from your disc (may not need if you’re not multicore)

Install IE8

Reboot normally in to Windows, you should be able to activate as usual.

Apparently the activation Window is dependant upon IE.

Hope this works, let me know.

Nexus S will sell at Best Buy after December 16

After December 16, Nexus S will be sold unlocked and carrier-independent initially through Best Buy stores in the U.S. and after December 20 at Carphone Warehouse stores in the UK.

Connectivity

  • Quad-band GSM: 850, 900, 1800, 1900
  • Tri-band HSPA: 900, 2100, 1700
  • HSPA type: HSDPA (7.2Mbps) HSUPA (5.76Mbps)

Why is Samsung shooting itself on the foot by not satisfying its users with prompt updates? Froyo fever.

image

Few months ago I broke the screen on my Nexus One and was forced to buy a new phone. Froyo or Android 2.2 came just before I bought my Vibrant.

I used to a have a Blackjack back in the day, and was happy with Samsung, battety life was good, reception was never a problem, so I figured, nothing could go wrong.

Well, I found out Samsung sucks at updating android devices. You may say why does it matter, very few folks care what froyo brings? True, but very influential people! Chances are that if you know what froyo offers, you are a go to guy for technical questions at work, home or wherever. In other words, you are free salesman for Samsung. And now you’re pissed off and will never recommend another Samsung phone in your life.

How many people people believe AOL was killed this way, by ignoring the needs of techie folks?

New malware redirects all major search engine results to Gala search

If you are being redirected to galasearch every time you search for something it may be because this shitworm planted few manual hosts on the hosts file.

First thing it does is hide the host file, so by going to C:WINDOWSSYSTEM32DRIVERSETC you will not see hosts at all. To show hosts, click on Tools from any open folder, and then go to Folder Options, switch to View tab and check “show hiden files and folders” and also uncheck “hide extension…” and ” hide protected operating system files”. Continue reading “New malware redirects all major search engine results to Gala search”

Apple hard drive failure, teaches an important lesson

Recently we have had a slew of MacBooks come into the shop all having the same issue with hard drive failure. After taking their macs to the apple store, where they are told the drive has failed and there is nothing they can do.  The customers then approached Charm City Networks for their data recovery needs. After inspecting the hard drives and not hearing any physical issues with the drives, we were able to mount the drives on a local windows file system and access them. After copying a few files over during the recovery process, a few errors would pop up showing read/write errors not allowing all the files on the drive to be recovered. Luckily we were able to copy over most of the users documents and media, but any remnants of the old OS were irrecoverable.

After the two more macs came in with the same symptoms, and several phone calls with similar concerns,  we started to notice a pattern. Researching the commonality of the issue  we turned up a few things.

According to Apple found on

http://www.apple.com/support/macbook/hd/repairextension/

“Apple has determined that a very small percentage of hard drives that were used in MacBook systems, sold between approximately May 2006 and December 2007, may fail under certain conditions. ”

After scouring through the forums a bit more, we found that many other models (other than the model listed by Apple)  had  the same issue, many of which have the identical hard drive installed.

Apple in the case of the 13-inch black and white MacBook models listed in the recall, will replace the hard drive free of charge. However will not recover or back up your data in any form. This in turn will leave the user stranded, since Apple is keeping the old hard drives after replacement,  killing the chances of recovery.

In  any case, the Lesson learned here is always back up your data! If  your mac or pc is acting slow or files start showing up as corrupt, we recommend backing up your data immediately. Whether it be an external hard drive,  thumb drive, or online backup service such as Carbonite  or Nordic Backup.

Can you afford to lose all your financial records, music, email, contacts, or your even those wedding photos? A small investment can save you from a huge nightmare and make the transition to a replacement or new PC or Mac a piece of cake.

-Jon