back up MYSQL

to back up your databases, you can do the following...

mysqldump -u [username] -p[root_password] [database_name] > dumpfilename.sql

for example I have a database with the following informations...

root username: James
root password: Aves
Database Name: aeisjean

and I want to save the copy as aeisjean.sql

you will do this...

mysqldump -u James -pAves aeisjean > aeisjean.sql

---------

to restore just type
mysql -u [username] -p[root_password] [database_name] < dumpfilename.sql

Note: You can save your backup in your PC... By default, the backup will be on the root folder in your server...

NEW UPDATES SOON

soon
i will post useful scripts
in php, javascript, vbscript etc..
i will also put in my blog some tutorials in
mysql
both windows and linux server...

Source Code for Bato Bato Pik (no ASCII Graphics)

here is the link for bato bato pik source code..,

I didn't include the ASCII graphics, its up to you if you want to add or if you want to modify the program...

Bato Bato Pik

simple thank you or 30 pesos load is enough :P

Bato Bato Pik

well someone in the chat box requested for something like jack en poy..,
I tried to create one and I came up with this
Turbo C Bato Bato Pik
I added a little ascii graphics for design purposes :P

First you will select what you want to use

Then the computer will randomly choose what to use against you...
You will see the result as you press enter

Do you like it..? A little modification and imagination can improve this program...
I can't include the source code but I can give you a hint...
It is just a series of IF's
for the graphics, I used a function(if it receive 1 it will print stone)

I uploaded the .exe file for you to try...
(sorry no source code)

Download it here
Bato Bato Pik by James Angelo Aves

TC Triangle Asterisk

by request:
create a program that will generate this output:
***
**_
*__

and

***
_**
__*

here is is



here is the complete code

#include

#include

int a,b,c;

main()

{

clrscr();

printf("\nProblem # 1\n\n");

for(a=1;a<=3;a++) { for(c=3;c>=a;c--)

printf("*");

for(b=1;b=a;c--)

printf("*");

printf("\n");

}



//my signature...



printf("\n");

printf("\n");

printf("############################\n");

printf("#                          #\n");

printf("#    James Angelo Aves     #\n");

printf("# james_03_aves@yahoo.com  #\n");

printf("#                          #\n");

printf("############################\n");

getch();

}

Number To Word

Here is a simple C Program that converts Numbers to Word.
The program can convert numbers up to 999,999,999.
I created this using a function, thus making the program shorter.


Try it, download the .exe here

http://www.4shared.com/file/127905394/8024ed53/Number_to_Word.html

YEHEY

My PHP Accreditation site is working again...
Kindly visit it, click the link on the right side of the blog...

NEWS!!!

My PHP Accreditation site has been reported as an attack site by Google.
Well this is not true and my website is very safe.
I think SOMEONE inserted something in that website, and this is the proof...


And I know who might have done this...
To you, if you cannot do something good, just don't do anything...

And to all, do you know that even our project when I was in college was sabotage...?
Even my PHP chat box, that SOMEONE tried to insert a script that was the same as the script inserted in our college project...
That is why when you visit my PHP chat box, you will see my post
"James Aves: Please don't post any annoying script because it will not work here."

And to you, don't be jealous of what I can do, or what anybody can do.,
If you think you can't do such a thing, just seek for help,
and don't do stupid things...

Note: You can still visit my PHP Accreditation, I have already fixed it...
If "Reported attack site" appears on your browser, just click ignore this warning, or better if you will use Internet Explorer...
But for your own safety, I will just remove the link until the Google finish reviewing the website...

TC Guessing Game

Someone send a message to me in friendster asking me on how to defend a guessing game created using Turbo C. After giving her some advice, I decided to try to make something like her program using turbo c.

This is my own Turbo C Guessing Game

I added a clue, example "The number is between 9 and 127", take note the clue is also in random.
The mystery number is also in random and you are only allowed to guess 6 times.
Try the program, download the .exe here

WARNING: Simple yet very addictive.

Guessing Game

PHP Accreditation Data Table

Hello...
Do you want to create a program using PHP that acts like data sheet?
When I was in College, our professor told us to research about the different areas in Accreditation System. And so, we asked for some data in the library and in the accreditation office, we also conducted an interview with different colleges in our university.

While I was doing the research, I thought, why not put all the accreditation data of all the colleges in all of the areas in the internet so that research would be easy.

Now it is possible, introducing to you the Accrediting Agency of Chartered Colleges and Universities in the Philippines (AACCUP).


For example you will select BSIT

You can view the data in every areas of concern, for example area 1

I also included search (by sub area) and also I added security so that the only one who can add and edit data in an area are the accreditors.



Be amaze, visit my AACCUP that was created by myself, click the link on the right side of my blog.

Based on my experience, after I created this project, I learned a lot about PHP, adding, editing, deleting or manipulating database (MYSQL).

The buttons and wallpapers, including the background image was also my creation with the aid of tutorials.

BSIT Wallpaper

This is a BSIT wallpaper created by Mac Froilan Sison...


To see more of Mac Froilan's works visit our friendster...

http://profiles.friendster.com/29588327

USB Background

Want to add background images to your USB..?

Here are the steps:

1. Put any image you want in your USB (example aeisjean.bmp)
2. Copy the following codes in notepad.

[{BE098140-A513-11D0-A3A4-00C04FD706EC}]
IconArea_Image=aeisjean.bmp
IconArea_Text=0x00ffffff

3. Save it as Desktop.ini
4. If you want to change the background image, just edit the this line
IconArea_Image=aeisjean.bmp
5. I recommend you to select a bigger image so that the background image will not tiled..

May I see your USB background image? Here is mine...

The Price is Wrong :P

Yesterday, my mother told me that she needs 2 pcs 1x1 picture. So she went to a photographer shop and she was surprised when the photographer said it will cost her 60 pesos for 6 pcs 1x1.

Finding it very expensive, she went home and tell me what happened.

I said, "I will take your picture and I will edit it, we will print it in a nearby computer shop. Printing of 1x1 picture will only cost us P2.50 per piece.."

and this is what happened...

BEFORE

AFTER



Using your IT skills will help you save money, maybe it will also give you additional income :P

Change USB Icon

Do you want to change the icon of your USB? Here are the steps:

1. Search for any icon you want, for example sonic.ico. Save it to your USB drive.
2. Open notepad, type the following

[autorun]
icon=sonic.ico

and save it as autorun.inf

3. Remove your USB, the next time you insert your USB to a computer it should look like this.

Villaver Ad

This is the Villaver I. House advertisment I made using Flash.



This advertisement is free. Want to have your own free advertisement? Just email me, attached the files you wanted to see in the ad. Thank You.

PHP Chat Box

This is my new work, online PHP chat box using text file. Yes, text file can also be used as a database. If you want to propose a project, why not try this.


See my online PHP chat box, visit the link on the right side of my blog. Thank you...

VB Karera

No, it is not the illegal video karera, this is my VB program, VB karera, a simple horse racing program.

The winning horse will be shown after the race.


This program is not created for gambling purposes. Try the program, download it here.

VB Karera

Turbo C Screensaver

This is a simple graphic that can be used like a screen saver I made using Turbo C. Random sizes of circles appear in random places and in random colors. Yes, you can make circle or any shapes using turbo c, you can even create a text with different fonts. See the screen shot
Click to enlarge


Try it for yourself, run my program, download it here
Turbo C Screensaver

For those who noticed, yes if you are making a graphics in DOS, you cannot just press print screen to create a screen shots, I used a software to make that screen shot.

BSIT Board

Welcome To BSIT Bulletin Board.
A project created by BSIT batch 2009.
We use PHP and MySQL.


Our bulletin should be online, but I don't know what happen, our account was suspended. I will create the bulletin again and I will post the link soon.

Interactive CvSU Map

How many of you in Cavite State University Main Campus knows where is the Coffee Microplantation Lab is? The CvSU main campus is a very large university, and without the aid of a map, it is so hard to explore the university. We already solve that problem.
Introducing iCvSU, the Interactive Cavite State University Map.


There are 3 areas here, the Navigation, Explorer and Magnifier. In Navigation are, use the arrow keys to control the map, or click the build in arrow in the application. Enjoy exploring Cavite State University.

Each building in the map including the grasses, rivers and trees, as well as the road was made using Photoshop.

This program is our group project created using Flash. See the site, click the link in the right side of my blog. Click Interactive CvSU Map.

Lotto Fans

Don't know what numbers to pick in 6/42, 6/45 or 6/49 lotto draw?
Well here is the answer, introducing PCSO Lucky Number Generator.
I created this using Visual Basic, animation (including some buttons) using flash.


I created the welcome form using flash that I embedded in VB, the Enter button is also made of Flash.



You can select if it is 6/42, 6/45 or 6/49 lotto draw. For example I choose 6/45.

If you will click the Show Lucky Numbers button, random numbers will appear from 1 to 45, take note, there are NO two numbers that are the same here.

Why not try your luck? Download the application here, no need to install.
PCSO Lucky Number Generator

Don't forget my share if you win :P

VB Randomize

Have you encountered a problem when it comes to randomization of numbers in Visual Basic?
For example you created a VB program that display 10 randomize numbers (1-10). When you run your program you thought it is working well. Example


However, the problem is when you run the program again, the program always output the same 10 random numbers as shown above. Every time you run your program, the random values are all the same. To solve this problem, try adding the code "Randomize" just after the form load. You only need to do this once. This way, each time you run your program, new random numbers are being generated. I hope it helps you in your VB programming...

Don't Trust Anyone

Don't trust anyone, especially when it comes to your memory card, usb drives, hard disk or any storage device. Even though you already reformat your storage devices or a virus deleted all your files or you intentionally deleted a file, there are still ways to recover all of that. Me too, I can recover some of your deleted files. So if you know that you have something private in your storage drive, even though you deleted it already, don't give it away to anybody, unless you trusted him/her a lot...

TC++ V 3.0

Can't find Turbo C installer?
Download it here, no password required.
Turbo C installer

Fibonacci

This is the famous fibonacci program. You will enter the number of sequence and then output the total.


Fibonacci sequencegoes like this...
To know the next number in the fibonacci, you will just add the last two numbers...
ex.
1 + 1 = 2
that's why it is 1 1 2
same goes in 3 + 5 = 8
that's why it is 1 1 2 3 5 8

see the program run, download the .exe here
Fibonacci

A CvSU Banner

Here i created a flash banner for CvSU. I created this when I just starting to learn Flash animations. I'm not that good when it comes to flash, but I think this is not bad...

TaskManager / Folder Options

Have you encountered a virus in your PC, even though you were able to delete it there are still some errors?
When you click Task Manager or press Ctrl Alt Del, a pop up message appears saying "Task Manager was disabled by Administrator", or when you click on your folder and then Tools there is no Folder Options?
To solve that problems, here are the one click solutions.
Download it here, password is jamesaves
Restore
Save it, it will be very useful.

CvSU Cursors

Are you a student of Cavite State University? Are you a fan or alumni or instructor or someone who is working in this university? Well, download the CvSU cursors created by me.
These are the cursors created from CvSU logo and from Laya Diwa bronze statue..

Download it here, remember password is jamesaves:
CvSU Cursor

I hope you like it...

Tweak Your USB

I know most of you have a USB drive, 1Gig, 2Gig or maybe 24Gig...
Wow that's pretty cool... However, when you open your USB drive it looks like this.


But look at my USB, i added some background images and if you will notice, the folders are different. Treat your USB's like a friend because they will help you a lot.


if you will ask what is the background image, it is my YuLing from a game called PerfectWorld.

From this To THIS

See my Girlfriend's Picture, here she is...


Then I edit the picture to this


Here is my brother


Then I edit it to this


Am I a professional graphic artist or a professional image editor?
No I'm not...

A Resume?

Guess what is this...
A scanned document? Well it can be...
A Microsoft word document, a resume..? Probably but it is not...
This is an example of an HTML, here you will see there is a background. This was my assignment when i was in College, we should create an HTML that will show information about us. So i decided to create something like a resume. Sounds cool isn't it?

Visual C++ Cursors

In the Microsoft Visual Studio 6.0 package, there is Microsoft Visual C++.
You can create cursors using visual c++, here are the examples.

If you are good, you can also create a image cursor, isnt it great to create your own personal cursor?

Turbo C Games

When your professor ask you to make a project using Turbo c, let say a game, what is the first thing that come up to your mind?
Usually its either a guessing game where you will choose what number or letter will appear, or a board game like XOX.
Why not try something else..?
I have a project, a game using Turbo C when i was in my 2nd year in college. During that time the game O2 Jam was very popular, so i thought of a game like O2 Jam.

Introducing O2 James


Here you can choose of a level, the higher the level, the faster the letter will drop.

And this is the loading screen.


And here is the game, the letters will drop and you should hit from the keyboard the correct letter, you will see how many letters you hit correctly and how many miss.

Take note, the drawing of the stick figure there is not moving, hehehe. But every letter you hit corresponds to a sound. I'm just in my 2nd year here so the letters are not yet in random but I hope you like it.

You can download the EXE file here
O2 James
I assure you, there are no viruses. Click and run, sorry but the source code is only for me :P..

About My Blog

The purpose of this blog is to show something useful, knowledgeable, latest and beautiful for the students or anyone who is in the field of information technology.

I will be posting some of my works from as simple as a turbo c program and as advance as php programming. I will also be posting websites that you can visit. Remember, I am not a computer genius or something, I just want to show you some of my projects and creation for reference.

added info
aeisjean is a name from the combination of my gf's name and my name...

This blog is created for references only, you cannot download some of the programs or applications in this blog.