Forward URL

< head >
< META HTTP-EQUIV="Refresh" CONTENT="0; URL=http://elearning.frisianflag.co.id">
< title ID=titletext>Under Construction ..< /title>
< / head >

Cron PHP script sheduller

## 1. Create php file ##

// your code to run via cron
// Updates stock
< ? php

$dbhost="localhost";// YOUR HOST NAME USUALLY LOCALHOST
$dbuser="root"; // YOUR DATA BASE USER NAME USUALLY ROOT
$dbpass="pass"; // YOUR DATA BASE PASSWORD
$dbname="";// YOUR DATA BASE NAME

mysql_connect($dbhost, $dbuser, $dbpass) or die("CANNOT CONNECT TO DB-HOST");
mysql_select_db($dbname) or die("DATABASE NAME PROBLEM");

$sql = "UPDATE accountinfo a set TAG = (SELECT b.location FROM ocsweb.frisianipmapping b , ocsweb.hardware c where b.IPmapping =c.IPADDR and a.hardware_Id=c.id)";
mysql_query($sql) or die("SQL ERROR:

---

".$sql);


?>


## 2. SETTING ENVIRONMENT ##

- click mycomputer >> properties >> environmen, then add the variable of 'PATH' with ";C:\xampp\php\"

## 3. CREATE BATCH FILE ##

@echo off
echo schedulle_running
php update.location.php

## 4. SETTING CRON SCHEDULE ##

start >> control panel >> schedule, choose the batch file

Function get URL in Excel

Create in macro like function below:

Function GetURL(rng As Range) As String
On Error Resume Next
GetURL = rng.Hyperlinks(1).Address
End Function

then open excel, type in a cell "=GetURL(A1)" for link/url you will capture


after that, you can correction the URL using macro below.

For URL = 6 To 329
AddressName = Cells(URL, 23).value
Range("W" & URL).Select

Selection.Copy
Range("L" & URL).Select
ActiveSheet.Paste
Application.CutCopyMode = False
AddressURL = Cells(URL, 27).value

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=AddressURL, _
TextToDisplay:=AddressName
Next

Cannot shift objects off sheet

If you find problem when insert column appears: "Cannot shift objects off sheet"
please click button CTRL+End, then delete the column.

Optimasi Windows XP

Optimasi Windows XP
- Defragmentasi
- Program Start-Up
- Paging File
- Virtual Memory 2000 - 4000 MB
- Desktop Icon
- Scan System
- Unistall Software yang tidak digunakan
- Setting ke Best Performance
- Cek msconfig.exe (Win XP) atau msconfig (XP)
- Service.msc
- Clean Windows Temporary / Browser Temporary
- Registry Recovery

Driver OPTION ICON 7.2 download

Berikut ini adalah kumpulan driver OPTION ICON 7.2 USB Windows dan Mac. driver Option_Icon_7.2_download

It is not safe to rely on the system's timezone

It is not safe to rely on the system's timezone settings. You are *required* to use the date.timezone setting or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Asia/Krasnoyarsk' for '7.0/no DST' instead in C:\xampp\htdocs\bookstore\administrator\components\com_virtuemart\classes\ps_main.php on line 880

Answer :
Check php.ini then find
[Date]
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
;date.timezone =
;php_value date.timezone Asia/Krasnoyarsk

date.timezone = "Asia/Krasnoyarsk"