ICT Bhutan, E-Learning, Information Technology Blog, Web Design, Linux, PHP, Wordpress, Visual Studio .NET, Windows, SQL Server, ASP.NET, C#

Like wordpress you can also change the Site URL of bbpress. Steps: 1. Login to phpMyAdmin. 2. Click the link to your Databases. A list of your databases will appear. Choose the one that is your bbPress database. All the tables in your database will appear on the screen. 3. From the list, look for [...]

On the Settings > General screen in a single site installation of WordPress, there are two fields named “WordPress address (URL)” and “Site address (URL)”. These are also known as the “Home” and “Site URL” settings. They are important settings, since they controls where WordPress thinks your site is located. They control the display of [...]

Your server is venerable to attacks, and you have to time and again monitor. After monitoring you have to block the attackers IP’s. Use Fail2ban package, which would ease you a bit. To install Fail2ban you need to add extra 3rd party repositories – Extra Package for Enterprise Linux (EPEL). After that you can use [...]

Add Dag RPM Repository for yum because that has many useful packages. wget http://dag.wieers.com/rpm/packages/RPM-GPG-KEY.dag.txt rpm – -import RPM-GPG-KEY.dag.txt rm -f RPM-GPG-KEY.dag.txt vim /etc/yum.repos.d/dag.repo # create new file like below [dag] name=Dag RPM Repository for Red Hat Enterprise Linux baseurl=http://apt.sw.be/redhat/el5/en/$basearch/dag/ gpgcheck=1 enabled=0 When you use DAG repository, Input yum command like below. yum – -enablerepo=dag install [...]

Set DHCP ( Dynamic Host Configuration Protocol ) Server in Linux Box. Lets first install DHCP package in 1. yum -y install dhcp Now that you have installed the dhcp package in your linux box, lets start configuring it. 2. cp /usr/share/doc/dhcp*/dhcpd.conf.sample /etc/dhcpd.conf 3. vim /etc/dhcpd.conf #line 4: specify your network and subnet subnet 192.168.0.0 [...]

Audit Clearance System – Royal Audit Authority Security Clearance Service – Royal Bhutan Police Planning and Monitoring System – Gross National Happiness Commission Asset Declaration System – Anti-Corruption Commission Forestry Information Database System – Department of Forest and Services Forestry e-Services – Department of Forest and Services Civil Service Information System – Royal Civil Service [...]

It is easy to query if the default value of the field is NULL, while in certain case when the field is empty. In such case execute the query like below. SELECT * FROM tblUser WHERE (LastName IS NULL) OR (RTRIM(LastName ) = ”) Happy SQLing

In some cases you need to locate if there are duplicate record in a table and you are stuck how to go about, then here’s how you can find it. SELECT cellno, COUNT(cellno) AS NumOccurrences FROM tblClientCellNumber GROUP BY cellno HAVING (COUNT(cellno) > 1)

Download latest version of bbPress from bbpress.org. Unzip it rename it and upload in the root directory of the HTTP Directory, normally it is the directory where you put your website files and so on. After that follow the step, and it will ask you the database name, so make sure that you create one [...]

Every time I worked on PHP, I always used include, then later on I wanted to know the difference between include, include_once, require, and require_once. After googling I came to know the difference. include: Includes and evaluates the specified file, throwing a warning if the file can’t be found. include_once: Same as include, but if [...]