Script Batch file – Setup IP

@echo off
echo Choose:
echo [A] Set Static IP
echo [B] Set DHCP
echo.
:choice
SET /P C=[A,B]?
for %%? in (A) do if /I “%C%”==”%%?” goto A
for %%? in (B) do if /I “%C%”==”%%?” goto B
goto choice
:A
@echo off
echo “Please enter Static IP Address Information”
echo “Static IP Address:”
set /p IP_Addr=

echo “Default Gateway:”
set /p D_Gate=

echo “Subnet Mask:”
set /p Sub_Mask=

echo “Setting Static IP Information”
netsh interface ip set address “LAN” static %IP_Addr% %Sub_Mask% %D_Gate% 1
netsh int ip show config
pause
goto end

:B
@ECHO OFF
ECHO Resetting IP Address and Subnet Mask For DHCP
netsh int ip set address name = “Local Area Connection” source = dhcp

ipconfig /renew

ECHO Here are the new settings for %computername%:
netsh int ip show config

pause
goto end
:end

Script END!

Sumber : lupa ngopy …..

Hapus karakter dari kiri (excel)

= LEFT (E2,LEN(E2)-2)
Hapus karater 2 hurup dari kiri

Note : settingan system dan regional Di control panel berpengaruh dengan format penulisan formula , seperti , (koma) dan ;(Titik koma)

Change font size in Printer LQ 300

Tekan tombol paper out , 3 detik, kemudian tekan tombol font , pilih font yang diinginkan, tekan paper out lagi untuk menyimpan settingan.

Error import mysql from PHPmyadmin

Error:

Fatal error: Maximum execution time of 300 seconds exceeded in E:\xampp\phpMyAdmin\libraries\import\sql.php on line 134

Solusi:

edit file config.default.php di folder phpmyadmin/libraries

cari baris $cfg[‘ExecTimeLimit’] = 300; rubah nilainya menjadi 0;