Time to think seriously about database(s).. While I havent done too much with migrating to a fully database driven site I have setup a non-forum database for one section of the site. I have been pondering the idea of switching over from a files/folders (hard coded) setup to a database driven setup for a while but haven't taken the plunge yet, mainly due to the old saying "if it ain't broke, don't fix it", well for the most part the hard coding is working out but no I am having to move pages, and even though the site is getting no real human interaction, I would like to get to a final format that wont trip up google, etc...
for an example:
is the current format of the links to the motherboards.
due to miguided information or new information for currently "unknown" boards the pages are getting shuffled around.
What I was thinking of as a new method of pages is like similar to forums:
(where n would be the id number from the database) so that when a page move the link would remain the same.
idea in my head for the site database:
= Auto Incremented
- (page has a thumnail that can be clicked for a larger view)
= Varchar(50) -> (haven't encoutered any that are that long but some do have dashes in them)
= Varchare(50) -> (haven't encoutered any that are that long but some do have dashes in them)
- Ultimately it would be cool to have this setup as a sub-table that has (but part of that problem is some of the chipset series names cover 30 different chipsets):
Chipset Name (for instance Intel Bearlake Chipset)
North Bridge -
South Bridge -
- AMD uses MT/s, Intel uses mainly MHz/GHz (but IIRC there are some w/DMI that uses MT/s)
- Number & Types of Slots/Sockets | RAM Speed | Maximum (most of the newer boards list x for 32-b and x for 64-bit, whereas older boards list just one maximum)
- Type of audio (integrated HD audio, external only, etc) | brand of CODEC
[b]Video[b] - Type of video (like the audio there are diffent setups) [For some odd reason I have been listing with the video specs as an example PCI Express x16 Graphic Cards, but in reality if your techie enough to look for technical specs your gonna figure it out by the expansion slot list]
- A breakdown of the expansion slots on the board
[b]Part Number(s) - Various formats (some 5421-0679, D9999-8888, 666666-222)
- For instance if a front panel pinout is availible, or a pic of the codename, etc. (would be super cool to have it expandable if more then one extra image was availbie), this is listed as text link to the image, but the description text changes based on what the type of image is.
Models Found in
- a breakdown by sytem series/models
Compaq - Models
Compaq/HP - Models
HP - Models
- A breakdown of what is availible for manuals, maintenance guides, or parts info (Quick Reference Guides)
Retail Boad info
This is an MSI/Microstar MS-7612 motherboard.
Retail Link Here
Retal Link2 Here (if availible)
- effects the branding of the BIOS branding in the caution message. "The bios program has been altered to an HP specific version. It is not recommended to flash back to the original. If anyone does this successfully please notify us by <a href="">email</a>." Would be super cool to have is setup so that I could plug in Compaq, HP, or Compaq/HP and have the a/an accoringly instead of having to put in a Compaq, an HP, or an HP or Compaq.
- This is information that replaces the caution message if somebody has flashed the BIOS back to the retail version.
- This is for extra information that has been found like if there is a known discrepency like if HP lists the board as being from x manufacturer but the information points to another, etc.
- Link to a thread in the forum to discuss the board (for filling in the blanks essentially).
Most all the current formating, etc has been previosly discussed in this thread.. No I am not asking for you to do this for me, just brainstorming and hoping for guidance as I have never tackled a project like this..