Higher than getche

Some notes on VB

2009-09-18T07:59:00.000-07:00

Why Visual Basic?

- programming for the windows user interface is extremely complicated!
- other GUI are no better.
- VB provides a convenient method for building stand-alone user interfaces.
- VB can interface with code written in C for efficiency.

What VB is not

- VB is not a powerful programming language that enables you to do anything you want.
- VB is not that elegant or fast.
- VB is not a replacement for C.
- VB is not anything like any other programming language you have ever used.

When you program in VB:

- You draw pictures of your user interface.
- You draw buttons, text boxes and other user interface items.
- You add little snippets of code to handle the user interface.
- You add initialization codes, usually as the last step.
- If you like, you can code more complex functions! (but many do not do so)

Java Script: No right click

2009-09-12T03:41:00.000-07:00

I used to use these scripts. But now, I believe in the official motto of the US state of Hampshire which is "Live free or die". I choose to live free - to share these scripts for the benefit of all IT and non-IT professionals (or aspirants) out there.

Oh, for those of you who don't know where to place this code, just place it in any area in between the and tags.

No Right Click javascript:


<script type="text/javascript">


var message="No Right Click";

function clickIE4(){
if (event.button==2){
alert(message);
return false;
}
}

function clickNS4(e){
if (document.layers||document.getElementById&&!document.all){
if (e.which==2||e.which==3){
alert(message);
return false;
}
}
}

if (document.layers){
document.captureEvents(Event.MOUSEDOWN);
document.onmousedown=clickNS4;
}
else if (document.all&&!document.getElementById){
document.onmousedown=clickIE4;
}

document.oncontextmenu=new Function("alert(message);return false")

</script>

'
Oh, and by the way you *could* change the text that would appear when the browser prompts the 'right clicker'. Just change:

var message="No Right Click";

with the message of your choice. Don't forget to encase your message within the " ".

Database: No AutoIncrement for Oracle (VB6)

2009-09-09T06:45:00.000-07:00

Since Oracle (PL/SQL) doesn't have an auto increment feature for their number(or integer) datatype, coder/users are faced with a question: How can their programs move/progress to a next transaction in the database, if there's no auto increment feature? Simple, by creating a function in the frontend(ui) side which would do the auto incrementing and pass the auto increment value to the database - upon each new transaction.

Here is a sample code, which is placed in the 'form_load' portion of a VB6 program:

oh and by the way make a DUMMY row in your table. Place 0 (zero) in your first row/column as the PK of the DUMMY row/entry and o (zero) or - (dash) in the rest of the columns of the first row (dummy row). This is done to avoid any errors that would indicate an invalid use of null.

Database: Oracle DB Connection (VB6)

2009-09-09T06:11:00.000-07:00

In our OJT (on-the-job training) in Davao Light, we learned and acquired a lot of knowledge, particularly an enhanced knowledge on the Visual Basic 6 language, and the introduction of the Oracle database (PL/SQL developer). In our junior years, we were exposed to two database applications, namely mySQL and MS Access. In this entry I will share a snippet of the connection 'code' we used in most of our codes and programs.

First of all, we are using the PL/SQL Developer version 6.0.5.926 (it's the counterpart of mySQL's query browser and admistrator in Oracle DB).

Second, I would like to repeat once again, that we are using VISUAL BASIC 6 here. And one should take note of the following references (references, is found in Project):

Microsoft DAO 3.51 Object Library (DAO350.dll)
Oracle Data Control (oradc.ocx)
oraOLEDB 1.0 Type LIbrary (oraOLEDB.dll)
Microsoft ACtiveX Data Objects 2.5 Library (msado25.tlb)

Oh, one last thing to point out: the following code is placed in a MODULE, not a FORM.

Here's the code:

Anti-Virus Do It Yourself: removing BRONTOK

2009-09-06T18:04:00.000-07:00

This guide is about removing the BRONTOK - trojan virus. It's quite easy, you just have to focus! This annoying virus, prevents users from accessing RegEdit, and folder options.

1. Restart your computer, and log in to 'safe mode'.
2. Go to command prompt, and type the following commands to ENABLE REGEDIT:

reg delete HKCU\software\microsoft\windows\currentversion\policies\system /v "DisableRegistryTools"

and run HKLM\software\microsoft\windows\currentversion\policies\system /v "DisableRegistryTools"

3. Once you have typed these commands, you will be able to access RegEdit.
4. Still in command prompt, type EXPLORER
5. Press (window) + R or simply go to start, and press RUN and type regedit.
6. Go to this path:

HKLM\Software\Microsoft\Windows\Currentversion\Run

7. On the right side delete the entries which contain 'Brontok' and 'Tok-' words.
8. Then, for you to be able to enable FOLDER OPTIONS, go to this path:

HKCU\Software\Microsoft\Windows\Currentversion\Policies\Explorer\ 'NoFolderOption'

9. Delete this entry and restart your computer.
10. Search all *.exe files in all drives (search in hidden files also), these exe files look like folder icons, but they're not. Be careful, only delete those exe files that pretend to be folder files.

Anti-Virus Do It Yourself: removing NUS virus

2009-09-06T17:52:00.000-07:00

This is a guide on how to delete certain malicious virus / trojans from your USB thumb drives.
These are some of the buggers I've cornered:
- autorun.inf
- autorun.INF1
- myeclass.vbs
- myeclass.vbs.bat
- myeclass.bat

these are variants of the 'n u d e usep scandal'

to remove these malicious files follow the following steps:

1. open command prompt application (or type CMD in RUN)

2. press CD.. until you see "E:\" only. (E:\ - or any other letter depending on what drive letter your USB thumb drive is assigned to)

3. type "dir /s ___.___" where as the blanks are one of the five suspicious files above.

4. autorun.inf files SHOULD be seen in familiar folders, such as installers or microsoft folders, otherwise, do the following substeps:

a. type "del ___.___ /f /s /q /a" where as the blanks should be filled with any of the following file or name listed above, bear in mind the 'autorun.inf' condition stated in step 4.
b. repeat step 3, if the file is no longer found, your pc is safe.

5. repeat all steps, in other local drives and removable usb thumb drives.

BE CAREFUL, not to delete system autorun.inf files.

C: DOUBLE and WHILE: Quadratic Formula

2009-09-05T23:47:00.000-07:00

For this entry I would be sharing a program that would utilize the QUADRATIC formula.

DOUBLE and a simple WHILE statement is present in this program.

This program also passes values to an existing function (outside main)

I hope these codes would help any student or aspiring programmer. I believe that C is the most basic of all programming languages - you can't learn other languages unless you understand the logic and flow of C.

#include <stdio.h>
#include <math.h>

quadratic(double x, double y, double z)
{
double first, second;
first = (-y+sqrt((y*y)-4*x*z))/(2*x);
second = (-y-sqrt((y*y)-4*x*z))/(2*x);
printf( "%f %f\n", first, second );
getche();
return 0;
}

main()
{
double a, b, c;

while( 1 ) //this while loop states that this loop would always run while the operation is true.
{
printf("Input value a:\n");
scanf( "%f", &a );
if(a>0) printf("input values b and c");
scanf( "\n%f", &b );
scanf( "\n%f", &c );

quadratic( a, b, c );
}
}

C: DEFINE and FLOAT: Volume calculator

2009-09-05T23:40:00.000-07:00

For this entry I would be sharing a Volume calculator (for graduated cylinders and the like). This program utilizes the 'FLOAT' datatype and DEFINE.

This program also passes values to an existing function (outside main)

I hope these codes would help any student or aspiring programmer. I believe that C is the most basic of all programming languages - you can't learn other languages unless you understand the logic and flow of C.

#include <stdio.h>

#define PI 3.14159 //define as it name implies defines a variable's value. the difference between //defining a variable and declaring it, is that when you define a variable - the variable's value
//is declared for the entire program (global) and is not exclusive to one function only.

getcylvol (float a, float b)
{
float vol;
vol=(PI*(a*a))*b;
printf("\nThe volume of your cylinder is: %f",vol);
getche();
}

main()
{
float radius, height;

printf("Input radius and height of cylinder:\n");
scanf( "%f \n%f", &radius, &height);
if(radius==00||height==00)
getche();
else
getcylvol(radius,height);

}

C: SWITCH and PASSING VALUES: Celsius to Fahrenheit converter

2009-09-05T23:24:00.000-07:00

For this entry I would be sharing a Celsius to Fahrenheit converter. This program utilizes the following statements: IF, SWITCH and CASE.

This program also passes values to an existing function (outside main)

I hope these codes would help any student or aspiring programmer. I believe that C is the most basic of all programming languages - you can't learn other languages unless you understand the logic and flow of C.

#include <stdio.h>

convert(int a, float b)
{
float far, cel;

switch(a)
{
case 1:
far=(9*b/5)+32;
printf( "%f degrees Celcius is equivalent to %f degrees Fahrenheit",b,far);
break;
case 2:
cel=5*(b-32)/9;
printf( "%f degrees Fahrenheit is equivalent to %f degrees Celsius",b,cel);
break;
default:
printf("invalid input!");
}
getche();

}

main()
{
float temperature;
int choice;

printf("What conversion do you desire?\n 1-Celsius to Fahrenheit\n -or-\n 2-Fahrenheit to Celsius\n");
scanf( "%d", &choice);
printf("Input the temperature you would like to convert:\n");
scanf("%f",&temperature);
if(choice==1 || choice==2)
convert(choice, temperature);

}

C: If-Else argument: leap / common year indicator

2009-09-05T23:09:00.000-07:00

When we were in first year, we were taught the programming language/syntax named 'C'. We used the Dev-C++ IDE to construct, compile and run our little creations.

For this entry I would be sharing some examples of the IF and ELSE arguments.

I hope these codes would help any student or aspiring programmer. I believe that C is the most basic of all programming languages - you can't learn other languages unless you understand the logic and flow of C.

// leap year/common year indicator

#include <stdio.h>
int main()
{
int leapyear, year;

printf("Input your desired year : \n");
scanf("%d",&year);
if ((year%100)==0)
leapyear=((year%4)==0);
else
leapyear=((year%4)==0);
if(leapyear)
printf("%d is a leap year\n",year);
else
printf("%d is a common year\n",year);

getche ();
}

Slight config for PhP and Apache (for Drupal CMS)

2009-09-05T19:03:00.000-07:00

I would be discussing on how to alter certain configuration files of PHP and Apache, so that Drupal CMS would run smoothly without any errors.

I would also assume that you have installed MySQL, Apache 2.2.x, PhP 5.2.5. And of course the Drupal CMS in your localhost.

It would be advisable that you're only using drupal for this matter - to avoid any conflicts in the root folder - or if you insist on using other CMS, be organized about it and cluster these different CMS in different corresponding folders - to avoid any conflicts.

Without further ado, let's begin.

PHP-Side:

1. You should have installed all extensions (e.g. mbstring, mysql, mysqli.. Etc..)offered in PHP v.5.2.5.

2. Enable the following extensions in the php.ini file located in the php folder by deleting the ; character located in front of the word ‘extension’:

mbstring.dll
gd2.dll
mysql.dll
mysqli.dll

3. Save the php.ini file. and copy the php.ini file to the C:\WINDOWS directory.

Apache-side:

1. Go to your Apache folder, and locate the conf folder, click it.

2. Open the httpd.conf file

3. Press ctrl+f and look for the index.html text.

4. Type index.php beside the index.html text.

5. Save the httpd.conf file.

6. Go back to your conf folder, if you see a file named httpd.conf.BAK open it using wordpad.

7. Do the same procedure done earlier in the httpd.conf file.

8. Save the httpd.conf.BAK file.

9. You can now go directly to your Drupal site, without having to view the parent directory list.

Installing drupal 6.x

2009-09-05T14:32:00.000-07:00

Drupal is one of my favorite CMS (content management systems), let me start off by indicating the softwares that I would be using for drupal, which are the following:

1. Apache 2.2.x
2. MySQL 5.x
3. PhP 5.2.5

Slide 2

•

If you don't have or don't know where to get those software, google it. Remember, whether you're an I.T. person or not, GOOGLE - will always be your friend. :) I would assume that you have properly configured Apache, MySQL and PhP, and would only cover the installation of Drupal.

I would also like to point out that my guide would only cover the basic installation of drupal, and that I won't cover any other technical aspects regarding uploading your drupal sites online or the like.

DOWNLOADING and SETTING UP DRUPAL

1. Navigate to www.drupal.org.

2. Click on the 'Download Drupal 6.x' link.

3. Once the download has finished, go to your desktop (or wherever default download folder is) and click on 'drupal-6.x.tar.gz' and select the 'drupal-6.x' folder;

4. Extract the 'drupal-6.x folder to the 'htdocs' folder located in your Apache folder;

5. Go to your 'htdocs' folder and rename the 'drupal-6.x' folder to 'drupal' (to simplify things);

6. Go to your web browser, and type 'http://localhost:8080/drupal';

7. Click on the link 'Install Drupal in English';

8. An error message like the one below would appear;

9. Go to '..drupal\sites' folder and duplicate the php file named 'default.settings.php', afterwhich rename the duplicate file to 'settings.php'.

Slide 4

10. Go back to your web browser and press the link 'try again';

11. Create a new schema in your 'MySQL administrator', name it 'drupal';

12. Fill out the corresponding fields: Database name – with the new schema named 'drupal'; and provide your own database username and password – in this example, I used 'root' for both password and username

13. Place the desired name of your website on the textbox located below the label Site name, and input your site’s email address on the following textbox.

14. Scroll down, and input your default administrator username, admin, your email-address, and your password

.

15. Scroll down again, and click on save.

16. Ignore the error displayed, and click on the your new site link to navigate to the front page of your website

.

Enjoy.