Sunday, June 25, 2006

The World Cup 2006 is here...Forza Italia!

I am currently driving to my office, and I am thinking in Soccer ones again...But this time was not the kick on the knee I received on my last game with my friend at office...this time I am thinking on what I could do to make this World Cup 2006 unforgettable. What About a Soccer bracket for First and Second Phase (48+17 games)?

So that is how I created my company's bracket for Germany 2006. Here is how I presented it to my co-workers:

The time has come. 32 countries from all around the world will fight to be the new champion for the next 4 years. Will the host, Germany, keep the Cup at home? Will Brazil or Argentina make it again? Will the US team beat the odds to be in the top 3 of the world? Now you can make your picks and win cool cash prizes with our World Cup Bracket Contest. It's $10 per game and very easy to play.

You're one step closer to building your SFX Soccer fantasy squad using a very simple website I have completed last night. But there are a few things to note as you set out to craft a championship side and earn some cash.

Enter the contest by filling in the registration form and then, from the 8 groups of 4 teams, pick the winner country for the 48 games using the check boxes. Check both team boxes to indicate the game will be tide. We will probably create another game for the 2nd round, each game will disqualify one team

You (and your closest friends) can create as many brackets as you want, but 10$ is required per each bracket. Any money will be well kept by our Treasure advocated: Carlos, so please give him your 10 bucks per bracket to him. Do not worry, everybody knows where Carlos works lol. Once submitted, entries can be changed as many times as you want until the 9th of June. NO entries can be deleted -sorry I did not have more time to work on this project. All entries must be submitted by June 9th 2006 at 0:01 am EST.

Points are allocated as follows:
1 point for every correct pick on the first round (32 teams, and 48 games), a tide game will give you 1 point if you selected both check boxes from the bracket page. Winner takes it all. The prize will be presented the same day the last game of the first round ends.

Any problem or question you may have please send it at
I hope having time to give to this application, another couple of tweaks.

Here is a description on the parts and features I presented on my World Cup 2006 Bracket:

1) Here is a screen shots of this project:

2) Here are some features available for the players.

Since the amount of goals on the first 48 games is a tie breaker, there is necessary to provide the total of goals accumulated (#1).

Also, this section will show the last player who score a goal and its country flag. All this information was real-time without my data entry needed thanks for an XML parser I put in place on the home page.

#3, will indicate all the player who have or have not played for the bracket. Off course nobody was late since all my friends at office where constantly monitoring any new change on this website :-)

"Percy, it is necessary a section for Real time news feed so we could keep informed about last minute news about injured players and such.." That is why I created feature #4, a real time news feed from world known news sources as, Reuters,etc. The next screen shot is the pop-up detail of the news ones you click on each news link.

Feature #5. It will display detailed information about the game of the day, and also games to be played next. This feature will include a brief description of the stadium in which the next game will be played as well as the teams for the battle.

Feature #6. It is the bracket matrix itself. On top the 48 games real time entered as soon as the game finishes, on the left the name of all the players, on the grid 4 colors: RED and Green for winners and losers, pink and apple green for bets on future matches winners and losers.
Finally, on the right side the total points per player and the leader on the bracket indicated with a soccer balls, off course.

Then feature #7, which displays the games been played at the moment and the current score (real time and using XML), then this score will automatically update my bracket.

Finally #8 displays random images of the games currently in curse by automatically determine how many images are available for the teams in play, and calculating a "path" + random number + ".jpg"

Feature #9. Players recorded at registration a personal slogan, mine was "FORZA ITALIA" for example, then I used this slogans to randomly be displayed on the front page.

This is my database tables and fields. Total I created 4 tables: Users, UsersPronostics, Games, and teams.

Here is a close up of the most important of all tables: Games.

Here are the registration page, and the login page. On the registration page the total number of goals was hidden automatically when Date()>="06/08/2006" since it was a tie breaker as well. The nobody would edit its profile on the future. This field was added after the application was completed so was easy at that point add this field on the user profile and not a the user bracket table.

Here is a screen shot of the bracket(Quiniela in Spanish)itself. Yes I know, you will probably think, Why include ties as a result? by decision is was necessary to avoid many ties on first place..and at the end it really work as a tie breaker.

Now I am working on the second stage for the next 17 games. So far unfortunately USA has been disqualified but many other good teams as Spain, Argentina, Brazil and Italy still on the good fight.. FORZA ITALIA!!

Thanks for visiting my Blog.
Percy Dyer

Tuesday, June 06, 2006

DHL. Reports-Builder Administrator Tool.

My name is Percy Dyer, and today I will code a 'Report center'. This page shows a list of all the reports DHL has requested. Eventually a procedure will run cleaning the server from files older than a month

View aggregate job report Option: It is the Suppression list general report.

Request a New Report Option. Post a new report, based on a job name and base on the client status on the suppression list table.

After a Report has been posted, a Schedule task that runs every 5 minutes from Monday to Saturday will process the report.

The user will be able to check the current status every minute.

When the report is completed you will see a ‘Completed’ status in addition to the file size

The user should click on the red link size, to download the file into Excel format.

DHL Suppression List. This tool has three options:
Main Option: It is used to change the status of a company which could be: Active, Do not mail, Bad address, Insufficient Address; To accomplish this task, this page tracks a company using its account, source code, Company Name or Job Name.
Here is a screen-shot:

Here is the result base on a keyword indicated in the search textbox

Here is its data base structure:

This tool saves the new part of the address (Address, Address2, Suite, City, State, Zip) into the suppression list table, while the old address would be save into the TownOldAddress. There are two more tables where DHL Suppression list application save its data, they are ‘FatherAddress’ which contains the following fields: ID, InsertionDate, and FamilyAddress, which contains the following fields: ID, FatherAddressFK, SuppressionFK, InsertionDate.

Here it is a Table structure of these four tables:

Net Mailed tool: The Net Mailed values per Job Name is a variable used internally by DHL. BFW is in charged of totalizing the quantities mailed and insert them into the ‘JobInfo’ Table.
Here is a screen shot:

Thanks for visiting my Blog.
Percy Dyer

Monday, June 05, 2006

Restaurant Menu | ASP/SQL Project

Create a 'Restaurant Menu' application using ASP/SQL Query/Paypal to record Restaurant Menus.

First I will create a PAYPAL account, so I could receive Donation to just help cover some of the expenses (server/hosting fees, Internet fees, etc.).

Here's How:
1. Go to
2. Sign up for an account, if you don't have one yet. Just follow the instructions and you'll have an account up and ready in no time.
3. Once your PayPal account is active, log in.
4. Go to the 'Merchant Tools' section. Look for the 'Accepting Website Payments' section. You will then find a link called 'Donations.' Click on that link.
5. Provide the necessary information to set up your donation button. Just add the optional information to facilitate the donation process (donation name/service, donation ID/number, donation amount, currency, etc.).
6. You can also add more options, such as providing customized 'thank you' pages, cancellation pages, etc.
7. Once you're ready, click on 'Create Button Now'.
8. Copy the HTML code and paste it on your blog template.
9. Encourage your readers to use your donation button (or 'tip jar') to send donations.

What is it?
PayPal Donations lets you collect donations from a button on your website, or even using a link in an email! A low cost way for you to accept credit card and bank account donations, PayPal Donations can be fully integrated with your website in a few easy steps.

What are the benefits?
Save time and money collecting donations with PayPal:

Easy to implement - no CGI scripting necessary
No up-front costs - you'll have the same low fee schedule used when you receive other PayPal payments
Collect with ease - PayPal maintains detailed transaction records on our website
Freedom for your donors - donors can choose the amount of their secure donation, or you can set a fixed amount


Customize Your Buyer's Experience (optional)
Successful Payment URL - this is where your customers will go after they complete their payment.

Cancel Payment URL - This is where your customers will go if they cancel their payment. (e.g.

Add a button to your website
Copy the code below just like you would normal text.
Paste the HTML code onto your website
Go to Your Website: In your files, go to the HTML code for the web page where you want the payment button to appear. You can do this by using a text editor or your HTML editor.
Paste the HTML code above into your website's HTML code next to the item you wish to sell. Now view your web page and you should see the payment button for buyers to click and pay!

Thanks for visiting my Blog.
Percy Dyer

Saturday, June 03, 2006


My name is Percy Dyer, and for quite some time I have been reading, researching, and applying SEO techniques to improve the rank of some of our clients mainly in Google. Clients as,,,etc.

How Google does the Ranking? Basically, during the month, Google sends out robots (spiders) to crawl the web and archive every website it finds. These archived websites will be presented in the next update of the Google index (database). The update process is initiated every 30 days or so, although on some occasions there have been more than 30 days between updates.

So basically my project will consist on Appling SEO theory to display my website: on number 1, for a keyword like 'Motion Test'. Here are some screenshots of my final Design version:

I will post my results as soon as Google Spiders visit my page to compare results and implement more SEO rules. I will check my ranking using:

Jun 3th, 2005 1:16am.
Commentary:"It is 1:16am and I could not sleep, so had this SEO idea"
Initial Position: Not displayed within 1000 positions.
SEO Action:

  • Metatags/Keywords creation for each page
  • Modify File Names and Include 'Title' and 'Alt' tags to reflect new keywords
  • Create PDF White pages files for each page to increase SE relevance:
    available online by clicking on the following image
  • Keyword Density
Keyword Density is important since search engines use this information to categorize a site's theme, and to determine which terms this site is relevant to -- the perfect keyword density will help archive higher search engine positions. For the keyword 'motion test' has a Keyword Denticy of 0.87%, where 12% would be the perfect. After SEO Keyword Dencity is:
motion test=13.25%, and range of motion=10.60%

First Google spiders visit to my site
Commentary: Not listed on first 50
Google Ranking after SEO: 235

Google spiders visit to my site on July 11th, 2006
Commentary: I forgot about this project for the last 6 months after strong SEO maintenance I did....
Google Ranking after SEO: #3 !!

Some important links:Link Popularity; Meta Tag Generator; Domain Typos; Keyword Typos Keyword Density; Keyword Optimizer; Google Keywords; Overture Keywords; PageRank Search; PageRank Lookup; Future PageRank; Site Link Analyzer; Meta Analyzer.

Thanks for visiting,
Percy Dyer