Delete files older then 7 day on windows

forfiles -p "D:\test" -s -m *.* -d 7 -c "cmd /c del @path"


save with extention .bat

How to fix yum error "Metadata file does not match checksum"

how to fix yum error "Metadata file does not match checksum"

$sudo yum clean metadata v

How to fix error yum "network is unreachable" or "couldn't connect to host" errors while running yum command

Fix error yum "network is unreachable" or "couldn't connect to host" errors while running yum command.

$ sudo vi /etc/yum.conf 



[main]

proxy=http://proxy.com:8000

How to fix yum error '404 errors' on CentOS 6

How to fix yum error '404 errors' on CentOS 6

 $ sudo yum clean metadata
 $ sudo yum clean all 

Error Connection status: unknown The dependency service or group failed to start on windows vista

go to start menu and type cmd in the search bar and open cmd with
administrator rights

1. Type "netsh winsock reset" and hit enter....if you get an error, ignore it
2. Type "netsh int ip reset" and hit enter....
3. Restart you computer

Searching Column Name From Table in Database

select table_name from information_schema.columns group by table_name


select table_name,column_name from information_schema.columns
where column_name like '%MGS_Groupcode%'

how to convert pdf file to word or excel

open this web  https://online2pdf.com/

and  then upload file pdf and convert file and finish.

nb: maximum file 50 Mb.

How to get all user accounts SQL Server

Get the list of all SQL User Accounts SQL Server:

SELECT name AS Login_Name, type_desc AS Account_Type
FROM sys.server_principals 
WHERE TYPE IN ('U', 'S', 'G')
and name not like '%##%'
ORDER BY name, type_desc


Get the list of all SQL User Accounts Database only

SELECT name
FROM sys.server_principals 
WHERE TYPE = 'S'
and name not like '%##%'

Get the list of all Windows User Accounts only
SELECT name
FROM sys.server_principals 
WHERE TYPE = 'U'

Get the list of all Windows Group User Accounts only
SELECT name
FROM sys.server_principals 
WHERE TYPE = 'G'

VLC is unable to open the MRL smb://

When I tried to open remote video files with VLC via a Samba share , but I got this error message:
Your input can't be opened:
VLC is unable to open the MRL 'smb://...'
It seems that this problem is related to credentials and can be fixed by entering the credentials for the Samba share in the VLC preferences

Tools > Preferences > Input / Codecs > Access Modules > SMB Input

insert user and password

user     :
password :
domain   :

good luck

Kernel panic - not syncing Attempted to kill init

Kernel panic  while installing Centos 6.2 / 6.3 / 6.5  x64 bit LiveCD / DVD.

The error like this :

Kernel panic - not syncing: Attempted to kill init!
Pid: 1, comm: init Not tainted 2.6.32-279.5.1.el6.x86_64 #1
Call Trace:
[<ffffffff814fd24a>] ? panic+0xa0/0x168
[<ffffffff81070bd2>] ? do_exit+0x862/0x870
[<ffffffff8117cba5>] ? fput+0x25/0x30
[<ffffffff81070c38>] ? do_group_exit+0x58/0xd0
[<ffffffff81070cc7>] ? sys_exit_group+0x17/0x20
[<ffffffff8100b0f2>] ? system_call_fastpath+0x16/0x1b


for solution :

please download iso Centos 6.5 full version here and then burning to DVD.

good luck.

How to Install VLC Player On Centos 6

Add Repository 

- First login with user “root”
- Next run the following commands


# cd /etc/yum.repos.d/

# wget http://pkgrepo.linuxtech.net/el6/release/linuxtech.repo



Check VLC version in Repo

# yum list *vlc*



Install VLC Player

- Run the command below to install vlc

# yum -y install vlc

membuat bilangan acak pada php

function yang digunakan  rand()

contoh ;

<?php
$bilangan = rand(2,18);
echo $bilangan;
?>