All posts by spidey

Webhosting Shared Server

Installing Application In Shared Server

Leave a comment
  • Database hostname. Open phpMyAdmin in cPanel and the hostname is listed at the top, eg. localhost
  • Database port number. Open phpMyAdmin in cPanel and the port number is listed at the top, eg. localhost: 3306
  • Database name, user name and password. Open MySQL Databases in cPanel, create or search for the database. Create or search for User and add the User to the database. Select the privileges.
  • Configure CoreFTP ftp.webemprise.com, spidey, password, port 21 from cPanel FTP Accounts
  • Putty and PuttyGen. Generate public and private keys pair. Place public key in the .ssh folder in the root directory. In File Manager, go to Settings to display hidden files. Or go to cPanel Security, SSH Access
Thermal Printer

Black Stripe Across Receipt

Leave a comment
  • Date: 28-Aug-21
  • Customer: Haris Zafry
  • Shopee order 2108203UD8QYQN
  • Product LMP201

There were 2 black stripes across the top of the printed receipt. The app was Kyte. It was probably due to the faulty font size change of the firmware.

Solution: Asked customer to download and install PrintToolLite with patch LMP 201(650,150,128)_YC1.06_210729.bin. The printer was updated with the patch which solved the problem.

Banking

How to retrieve bank receipt

Leave a comment

Maybank

After transferring money, you forgot to save the receipt. Here’s how to retrieve it.

Go to My Accounts and click on the account where the money was transferred from.

Scroll down, see the button “Transaction History” on the lower left.

Click on the drop-down menu, select M2U Transaction

Find the online transaction done, and click on the arrow-in-a-box on the right. The receipt will appear.

CIMB

Log in and from home dashboard, see the menu on the left.

Click on “Pay & Transfer” -> click on the transaction reference number of interest. The transaction details come up… click the 3-dots on the top right hand corner… print PDF

Spreadsheet

Change the case in excel

Leave a comment

In cell B2, type =PROPER(A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.

Windows

Delete Multiple Files of A Specific FIle Type

Leave a comment

Situation: In my photos/images folders are numerous RAW files ( *.CR2 ) which are very large and it is increasingly unlikely that I will ever use them since I have their HD JPEG versions too.

Problem: How to mass delete the RAW files.

Solution: Use a run command to delete the specific type of files.

Press Windows+R to open “Run” box. Type “cmd” and then click “OK” to open a regular Command Prompt. Type “cmd” and then press Ctrl+Shift+Enter to open an administratorCommand Prompt.

Change directory to where the folder is: example cd Photos/2017 then type command del *.cr2

Change directory back one level cd .. or change directory to root cd \

Social Media

Get A Vanity Name For Facebook Page

Leave a comment
  • UPDATE: 9-Aug-2019
  • You can select the name and make changes anytime.
  • Go to Pages, create a Page
  • Continue…. choose User Name. Choose carefully as this will become the Vanity Name for your FB Page
  • Go to www.facebook.com/username
  • This brings up a drop down menu, select the page you want to create the username for.
  • If your page has the needed 25 fans it will bring up a box .
  • Enter your desired username and click on “check availablilty”
  • If it’s available, you will be shown some final terms – if you are happy with your choice click “confirm” or select “cancel” to try another one.
  • Now you can send out your new Facebook URL – www.facebook.com/YourBusinessNameRemember – this won’t work for a Page that doesn’t have 25 likes or more.
Wordpress

Modify CSS in WordPress

Leave a comment

2. /*
You can add your own CSS here.

Click the help icon above to learn more.
*/

/*applying the position fixed on the masterhead */
#masthead {
top: 0;
width: 100%;
height: 80px
}

/*positioning the main-navigation */
#masthead .main-navigation {
text-align: right;

top: -60px;
right: 250px;
padding: 0;
width: auto;
}

.site-title {
position: relative;
top: -60px;
left: 0px;
}
.site-description {
font: 300 italic 24px “Source Sans Pro”, Helvetica, sans-serif;
margin: 0;
position: relative;
top: -60px;
left: 5px;
}

/*adjusting default margins and paddings*/
#masthead .site-header-cart .cart-contents{
top: 40px;
right: 10%;
padding:0em 0;

}
#masthead .main-navigation ul.menu>li>a, .main-navigation ul.nav-menu>li>a {
position: relative;
top: -35px;
right: 30px;

padding: 1em 1em;
}
#masthead .site-branding{
margin-bottom: 1em;
}

/*positioning the cart-menu */
#masthead .site-header-cart {
width: 14% !important;

top: -60px;
right: 0%;
padding: 0;
}

/*removing the site search*/
#masthead .site-search{
display:none;
}

3. /* This removes the site footer from homepage frontpage */

.home .site-footer {
display: none;
}

4. Have a fullscreen Storefront website

.site-branding .site-title a {
color: #0f0f0f;
font-weight: normal;
font-size: 35px;
}

.site-branding .site-description {
color: #1d1e1e;
font-size: 15px;
}

/* This sets the background image of the page. Just replace the page id and the url of the background image */

.page-id-26620 {
background-image: url(“http://www.webkedai.com/wp-content/uploads/2017/07/cover-left2.jpg”);
background-size: cover;
background-repeat:no-repeat;
}

/* This makes the header transparent so that the background image shows through */

.site-header {
background-color: transparent;
}

/* This removes the bottom border */

.hentry {
border-bottom: 0px solid rgba(0, 0, 0, 0);
}

/* This sets the border of the shortcodes ultimate button */

.sfbutton {
border-color: white !important;
}

/* This removes the site footer from homepage frontpage */

.home .site-footer {
display: none;
}

/*
.page-id-26620 #site-footer {
display: none;
}

*/

#masthead.site-header {
background-color: #C1975B;
}