Projects

Listed below are my featured personal projects.

Project Internet

Project Internet is composed of documents, resources and system development concepts that I authored/co-authored/assist in propaganda/brazenly plagiarized involving the Internet in general or its science or its study. It is my hope that this endeavor will ultimately benefit the Internet community as I am only in the pursuit of the advancement of the Internet's best interest. Yeah, right.

Create A Hibernate Link On Windows Desktop

Assumptions:

  1. You're running 32-bit Windows; most notably tested has been Windows XP.
  2. Hibernation is turned on and is properly working in your Windows setup. Check the Control Panel Power Options applet for more information.

Steps:

  1. Right-click on an empty space on your Windows desktop and select New|Shortcut from the resulting pop-up context menu.
  2. In the location of the item, type in
    %windir%\system32\rundll32.exe powrprof.dll,SetSuspendState 1

    Click next.

  3. Type "Hibernate" or whatever you prefer as the title for the shortcut. Click Finish.

The directive works as well in programs.

Database References

I intend to post my database realizations in this section. This will be/is like a knowledge-base of some sorts of all database-related material.

Cursor Types Comparison Table

Attribute/Property Cursor
Enumeration Constant adOpenUnspecified adOpenForwardOnly adOpenKeyset adOpenDynamic adOpenStatic
Value -1 0 1 2 3
Description Cursor type not specified. Default, a forward scrolling only, static cursor where changes made by other users are not visible. A keyset cursor allows you to see dynamic changes to a specific group of records but you cannot see new records added by other users. A dynamic cursor with both forward and backward scrolling where additions, deletions, insertions, and updates made by other users are visible. A static cursor allowing forward and backward scrolling of a fixed, unchangeable set of records.
Theoretical Opening Speed Dependent on provider's default setting Faster Slow Slower Fast
Observable Opening Speed (based on a populated 90-column, 1000-row table) Data Pending Data Pending Data Pending Data Pending Data Pending
Updateable Recordset Yes Yes Yes Yes No
Theoretical Update Speed Dependent on provider's default setting Faster Slow Slower Fast
Theoretical Closing and Releasing Speed Dependent on provider's default setting Faster Slow Slower Fast
Observable Memory Consumption (parameters to be configured) Data Pending Data Pending Data Pending Data Pending Data Pending




Find anything wrong with the information posted here? Shoot me a feedback!

Rotate Abyss Web Server Logs By Month

Here's how to automatically rotate Abyss web server logs by month in 32-bit Windows.

Assumptions:

  1. The Abyss web server log file is in C:\Program Files\Abyss Web Server\log\access.log.
  2. Windows has a yyyy/mm/dd date format from its Date and Time Control Panel applet.
  3. Windows has a fully functioning Task Scheduler (all related services are running).

Steps:

  1. Create a batch file with the following contents.

    for /f "tokens=1-3 delims=/ " %%a in ("%DATE%") do (
set yyyy=%%a
set mm=%%b
set dd=%%c)

rem the order of %%a, %%b and %%c are system dependent! (control-panel, date/time settings)

echo %dd%
echo %mm%
echo %yyyy%

if not exist "ac%yyyy%%mm%.log" (
net stop AbyssWebServer
rem (move the log file in another folder, example: access.22.11.2005.log)
ren "access.log" "ac%yyyy%%mm%.log"
rem (Abyss start and create a new log file)
net start AbyssWebServer
)
pause
  2. Create a multiple time scheduled task (or make it run daily) to run the above batch file.
  3. Test the damn thing and smile to the world around you to make it a little better.
  4. For more insights, set your scopes to http://www.aprelium.com/forum/viewtopic.php?p=71723#71723