Auto Restart MySQL When It Crashes Ubuntu 18.04

Good Day, long enough not blogging on this site. This is my problem when I’m moving some websites into my cloud servers. Sometimes when my traffic going very high MySQL server crashes and I need to run it manually or reboot my server. This is really bad for SEO because my servers uptime will changed.

I am googling about this problem to find solution for resolve this issue and finally I found one is working for me.  Here is the steps you need to follow :

Read More »Auto Restart MySQL When It Crashes Ubuntu 18.04

PHP: How To Create Copyright Watermark On Your Images

This is happen 3 days ago when my friend asking for converting him .htaccess into lighttpd rewrite rules format. After conversion done he wanted to share this script to everyone. If you’re professional Fotographer or just blogger, you may wanted to copyright all your photos/images. Even we know, sometimes people like to share for having fun…. but some people need a copyright to protected his original works before someone copy it. If you’re doing this manually it will take a long time and of course you will bored before this done. In short time we can make a simple watermark to protected our images.

Requirements:

  1. Apache with mod_rewrite / lighttpd (just convert rewrite rules, it should work)
  2. PHP with GD library (check in your phpconfig or asking your webhosting)

Step one.

Prepare one images that you should used as watermark.Â? This images should be in .PNG format, you can created one using photoshop software to make transparant effect.

Step two.

Make new or open your .htaccess files and write down this code inside it:

RewriteEngine On
RewriteRule ^(.+)\.jpg$ wrapper.php?image=$1\.jpg [L]
RewriteRule ^(.+)\.gif$ wrapper.php?image=$1\.gif [L]
RewriteRule ^(.+)\.png$ wrapper.php?image=$1\.png [L]
RewriteRule ^(.+)\.bmp$ wrapper.php?image=$1\.bmp [L]

For Lighttpd users try to using this conversion, if you meet any problem just following your path and symbol :

url.rewrite-once = (
“^\(.*).jpg” => “/wrapper.php?image=$1.jpg”,
“^\(.*).gif” => “/wrapper.php?image=$1.gif”,
“^\(.*).png” => “/wrapper.php?image=$1.png”,
“^\(.*).bmp” => “/wrapper.php?image=$1.bmp”
)

Step three.

Create wrapper.php files and put code below inside it:

<?php
$watermark = “watermark.png”;
$image = $_GET[“image”];

if (empty($image)) die();

if (!file_exists($image)) {
header(“404 Not Found”);
echo “File Not Found.”; die();
}
Read More »PHP: How To Create Copyright Watermark On Your Images

How To: Created 2 Way SMS Gateway With NowSMS and PHP

I believe this topic is good for application developers. In this short article we will learn how to created SMS gateway and applied it on worldwide-web using PHP script. What is SMS? SMS stands for short message service. It’s the text communication service component of phone or mobile communication systems, using standardized communications protocols that allow the exchange of short text messages between fixed line or mobile phone devices… more details about SMS please read in wikipedia. I already written about how to build SMS gateway on my “Bahasa Indonesia” blog, but many people give negative comment on that article… Read More »How To: Created 2 Way SMS Gateway With NowSMS and PHP

My Simple Strategy to Win Forex Daily

Hi everyone, finally….. In this article I want to share my strategy how to win forex daily 🙂 First please note this strategy not always will make you profit 100% but in my case 8:2 i’m profit. You can not blame or bomb me *LOL* when this strategy make you loss to much.. this strategy works fine with me and maybe for other but not guarantee as is. First before you open daily position on market you have to read some news and prediction here are some great source you may take a look before: 1. https://webservices.realtimeforex.com/webservice/daily-market-comment This site provide… Read More »My Simple Strategy to Win Forex Daily

8 Step to Remove W32/Sality.AE

Sality is an computer virus which will infected any files with extension .exe .com and .scr , sality will using your default share folder to spreading in your network area beside that sality using old autorun.inf technique also to spreading. Your application will become a little bigger in size around 60kb-80kb after sality infected it. No need to hide this virus was created in China /Taiwan it have some website list to update himself with new varian some of them pedmeo222nb.info, pzrk.ru, technican.w.interia.pl, www.kjwre9fqwieluoi.info and many more. Blocking this site list using hosts file might help you in short condition… Read More »8 Step to Remove W32/Sality.AE

Created custom preloader for your flash gaming website

I know many webmaster looking the way how to do this 😀 Last week ago I try to searching about how to make custom preloader just like games.co.id used javascript. Many of result are false and didn’t give solution, sometimes it’s not working in IE or Firefox or even not working in both *lol* until I found one at least working almost same and I decided to share the code. When we’re using custom preloader it might can take mostly visitor attention because they eyes focused on that area. We can fill preloader with anything we want, ex: ads, info,… Read More »Created custom preloader for your flash gaming website

Forex:Learn how to open best position

As I promised here is the guide on how to open best position in forex to gain maximum profit. Used Parabolic SAR indicator and Bollinger Bands Indicator only. Take a Look on this hourly chart I give explanation: With Parabolic SAR indicator you can reading the chart will going UP or DOWN in Major Trends. Is that simple? not really.. as it sometimes (rare) can break and changed direction when there is really news can affect on that pair. With Bollinger Bands indicator you can read when charts will going up HIGHER or going down LOWER you see the blue… Read More »Forex:Learn how to open best position

How to:Configure/Setup Your VPN(server side) on Windows Server 2003 R2

Hello everyone, in this short article we will learn how to configure VPN on server side. In this sample I will give quick tutorial (based on real experiment) how to configure/setup VPN server on Windows server 2003 R2 and also the business behind it how to make money from your VPN.

First before we start please read the requirements:

  1. Computer with Microsoft windows server 2003 R2 operating system
  2. 2 LAN card, 1 is OK
  3. Static public IP

OK, if you meet all the requirements let’s start to configure it.

1. Start -> Run -> type “services.msc

Select Routing and Remote Access from the services list, See it’s Properties switch start-up to Automatic then start this service.

ist-vpn-1

2. Start -> Settings -> Control Panel -> Administrative Tools -> Routing and Remote Access.

3. Right click on the computer then select the option Configure and Enable Remote and Routing Access.

Read More »How to:Configure/Setup Your VPN(server side) on Windows Server 2003 R2

PHP:Catching keyword from search engine

Good day everyone, In this article we will learn how to catch information from “HTTP_REFERER” function such as, referer info, keyword info, etc. From some search engine using PHP snippet. This script might usefully when you want to analyze your keyword and referer statistic. Last night I was searching in WP plugin for this script but I didn’t found one really good.

So let’s created it our self, First, You need this PHP class save it as searchkeys.class.php

<?php

class search_keywords
{
var $referer;

var $search_engine;

var $keys;

var $sep;

function search_keywords()
{
$this->referer = ”;
$this->sep = ”;

if ($_SERVER[‘HTTP_REFERER’] OR $_ENV[‘HTTP_REFERER’])
{
$this->referer = urldecode(($_SERVER[‘HTTP_REFERER’] ? $_SERVER[‘HTTP_REFERER’] : $_ENV[‘HTTP_REFERER’]));
$this->sep = (eregi(‘(\?q=|\?qt=|\?p=)’, $this->referer)) ? ‘\?’ : ‘\&’;
}
}

function get_keys()
{
if (!empty($this->referer))
{
if (eregi(‘www\.google’, $this->referer))
{
// Google
preg_match(“#{$this->sep}q=(.*?)\&#si”, $this->referer, $this->keys);
$this->search_engine = ‘Google’;
}
else if (eregi(‘(yahoo\.com|search\.yahoo)’, $this->referer))
{
// Yahoo
preg_match(“#{$this->sep}p=(.*?)\&#si”, $this->referer, $this->keys);
$this->search_engine = ‘Yahoo’;
}
else if (eregi(‘search\.msn’, $this->referer))
{
Read More »PHP:Catching keyword from search engine

Forex Strategy:Wait and See Daily Chart.

Confused on how to open position daily, buy or sell? Let me tell you my another strategy to win forex daily. This strategy has been tested (real) by myself and the result is as you know, it’s profitable 🙂 I named this strategy is “wait and see” in short time frame chart you mostly can not predicted price movement it’s sometimes goes slowly but in short time it can be wild by jumping or down 50-100 point. You loss? Learn and don’t loss again! First before you start, look on daily forex recommendation read the prediction, mostly this prediction accurate… Read More »Forex Strategy:Wait and See Daily Chart.