Web Development

Windows based Web Development
IIS – ASP.NET – Visual Studio – C#


Adding a new WordPress site to an Existing Installation

2017/07/12
By
Modified: 2017/06/25

Task You already have a working WordPress (WP) site.  Now, you need to add one more site with a new MySQL database.  This document describes how to add one more database and install a new WP site on the same server. Download Download latest WordPress ZIP package (3.X) and unzip it to your future site location. Open IIS Admin Create a new virtual directory pointing to that location Side Notes – Change root password You need to know existing root user password. Login into MySQL Command Line Client. Select database: use mysql; Reset user password: update user set password=PASSWORD(“NewPassword”) where User=’root'; Allpy new password: flush privileges;   Create a New Database…

Read more »

What it Takes to Run Your Own Web Site (ever in progress)

2017/07/08
By
Modified: 2017/06/25
New-Web-Area

Joy of Web Publishing Very early on I noticed that Web content is a very special type of content, and Web development is a very special type of development.  Everything you say and everything you design is immediately available not just to millions, but to an entire Earth population with electricity and Internet.  And that is amazing.   And that is a true lure of running a Web site. Your thoughts and ideas are buried deep inside your head, but with Internet these ideas can find their customer, and your thoughts can find their reader.  Your site is your creation.  It is another dimension of you. Answer Fundamental Questions What is your Angle?…

Read more »

Set up bbPress as WP Plugin: Convert from bbPress standalone

2017/07/04
By
Modified: 2017/06/25

We went live with new bbPress plugin on January 28, 2013.   bbPress as a plugin for WordPress I started preparing for series of upgrades to the latest WP version (3.5), and Theme and all the plugings.  It was immediately obvious that among other things, I would have to look into migrating from integrated bbPress to a bbPress as a WP plugin. So far my experience was pretty intense.  I will try to log my progress here as I am moving forward preparing a production roll-out on my test site. Migrate your bbPress data from “bb_” tables into your “wp_” database I was able to migrate all the content from old…

Read more »

SQL DB2: Concatenate TEXT from multiple records

2017/06/30
By
Modified: 2017/06/25
Concatenation Road in Winter

    Scenario   Here is a recipe on how to concatenate a field from multiple records into one field. There are two pre-conditions for this method to work: First. Your source file needs to have an equivalent of a line number field.  This should be a numeric field indicating the sequence in which to concatenate the records.  This field doesn’t not need to be  consecutive. Second. The difference between lowest and highest line numbers should be a reasonably low number.  In this example the max difference is 11, and it means that at the very maximum we would need to concatenate 11 text fields together.   Step One Generate a driver file with MIN…

Read more »

Properly Validate TextArea Length (IE vs. Firefox)

2017/06/26
By
Modified: 2017/06/25
Properly Validate TextArea Length (IE vs. Firefox)

Let’s consider this example, where HTML page has a TEXTAREA and an INBOX.  When user types inside TextArea, Inbox should show the length of TextArea string. <script type="text/javascript"> function TTLength(objTT){ var tt= document.getElementById('TXT1'); tt.value = objTT.value.length; } </script> <textarea onKeyDown="TTLength(this);" onKeyUp="TTLength(this);" rows="10"> This Text Area Contains a string With Newline Characters </textarea>  <input type="text" id="TXT1" value="TT Length"/> Let’s see how this page behaves in IE8 and in Firefox 3.6.11. IE8 Firefox As you can see that IE and FF return two different values for the length of an identical  string in TextArea and that could be a serious problem, if you are trying to validate the string length before updating the…

Read more »

Grow TextArea Height Along with User Input

2017/06/14
By
Modified: 2017/04/30
TextArea---Allow-to-Grow

There are situations, when you do not want to have scroll bars inside a TextArea. Main reason not to have scroll bars inside TextArea is to make your pages more mobile-friendly.  For example on iPhone Safari scroll bar inside TextArea will not even show up.  Another reason not to have scroll bars is to improve page readability.   When you have lots of TextArea(s) on a page,  it is much faster to review the information without scrolling inside each individual TextArea. Here is a solution that would allow you to set TextArea height exactly to the amount of information in it and grow its height as needed with user input. Your can use…

Read more »

MySQL Upgrade on Windows – Easy and Painlessly

2017/06/06
By
Modified: 2017/04/30

How to update MySQL Server on Windows Machine   Preliminary notes: These steps work for MySQL Server that is running as a service on Windows machine. These steps were tested, when MySQL data directory is located on a different drive from MySQL  installation directory.   Determine your current MySQL version.  Run MySQL command shell: ..\YourMySQLFolder\bin\mysql.exe -u root   You should see something like this: Server version: 5.5.8 MySQL Community Server (GPL)   Rename MySQL installation directory   Download a *.zip file from Oracle (not *.msi).   GA stands for “Generally Available”.   Select x32 or x64 package from: http://dev.mysql.com/downloads/mysql/   Stop MySQL Service   Create empty MySQL install directory and unzip content of…

Read more »

Control WordPress 3.X.X Admin Bar Options for Subscribers

2017/06/01
By
Modified: 2017/04/30
WP-331-Admin-Bar-Removed

WordPress admin bar contains many interesting and convenient links for admins and editors. But it is totally useless, redundant and confusing for regular users. Here is how to hide it for subscribers while viewing the site. Open your theme functions.php file and add these  lines at the very end: if(current_user_can('subscriber')) add_filter( 'show_admin_bar', '__return_false' );   To hide Admin bar while users are in Control Panel, you need to add these lines at the end of your theme style.css file: #wpadminbar { display: none; visibility: hidden; }     The final questions to answer: -01- Can we do all these changes one file and -02- How to remove an ugly empty space at the top of…

Read more »

Histiry of This Site – DomainWebCenter.com

2017/05/30
By
Modified: 2017/06/25
Site History - SunWebCenter

Welcome! This is not a typical article for reading. This is a log of important events in site development and growth.   2016 Jul 06 WED Amazon Windows 2012 server with FastCGI was killing visitors slowly.  You can click on the link and go read your emails.  Response was horrible despite all our attempts to rescue it.  Finally, today we moved from Amazon server to Synology DS1515+. The move consisted of three steps: (01) Change A-record at Domain hosting provider to point to a new IP address; (02) Copy entire site from Amazon to Synology using remote connection; (03) Backup and restore MySQL database using phpMyAdmin. Now our QA would have…

Read more »