The list made in one hour:
The "Home" link at the end of the top navigation bar can be removed as it is redundant with the comicbookdb.com logo linking to the same place.
Change the "NEW! Mobile ComicBookDB.com" link in the navigation bar to "Mobile Access."
Remove the "Blog" link in the navigation bar. It is not updated and should be fully replaced by the twitter page recently opened.
The following dynamic lists are created on each page generated. Reduce SQL queries by removing them or placing them within the front page with the Last 15 Issues, TPBs/HCs, Issue Reviews and Favorite Creators lists so that they are only generated upon user request.
- Code: Select all
Last 10 titles added
Last 10 creators added
Last 10 characters added
The SQL query required to list any of the following lists is immense and stalls the server:
Missing Entries>(Missing Covers/Large Cover Images/All Creators/Characters)>All
To search a specific attribute, such as title, the drop-down box must be opened and title selected. The box does not keep the chosen attribute selected so if I have three titles to search for I must open the drop-down box three times to select title.
SQL queries are multiplied by making the default search "Entire Site" the server must search through multiple rows instead of just one.
Links in the comic entry:
Place the "Add a batch of issues from this title to your collection" link directly under the top-left "My Collection" link in small font and renamed "Add a batch"
Place the "Add a batch of issues from this title to your wishlist" link directly under the top-left "My Wishlist" link in small font and renamed "Add a batch"
Place the "Add this title to your pull list" link directly under the top-left "My Pull List" link in small font and renamed "Add to Pull List"
OR BETTER YET: Instead of cluttering the top-left user pane with more words place small + symbols next to My Collection, My Wishlist and My Pull List each linking to adding batches of issues to collection, wishlist or pull list, respectively.
In the comic issue entry also move the two "Add this issue to your collection" and "Add this issue to your wishlist" links to the top-left user pane as + symbols.
Issue variations and Cover Gallery:
Right now the cover gallery limits to displaying four columns only. Reduce the padding between cells and squeeze in a fifth row.
The issue number does not stand out enough. Bold it and replace the '#' with 'Issue '
Cover variants are not specified or discernible from each other. Add the variant information included in the issue index next to the issue number. For example, instead of '#1' and '#1' print bold 'Issue 1' and 'Issue 1 (Peterson cover)'. This would move the issue number from its centered position for cover variants so it also has a down-side, but variants would be easier to discern.
Variant issues are, mostly, identical to each other in every aspect other than cover. For each variant cover a new entry is made. This is a big waste. Consider having only one entry per issue and the cover variant images stacked in a vertical column where the cover is shown now. Removing variant entries will be a large coding change, but would significantly reduce the database size.
Add a drop-down selection in the Problem Report specifically for adding continuity. This will help moderators wading through the heap of problems reported. I suggest an entry titled "This series is part of a continuity."
Add a paragraph in the Help>FAQ - Issues page for continuity.
Q: How do I add series continuity?
A: Click the "Report a problem regarding this title" link at the bottom of the series page and select "This series is part of a continuity" from the drop-down box. Required information is the linking series (Name/Year/Issue #).
Example: Issue #1 of this series is continued from (Phantom: Ghost Who Walks/1989/Issue #15).
- - - -
Change the current continuity notes format. It is confusing especially to new users.
It is currently:
Superman (1939) #423 continues to The Adventures of Superman (1987) #424
Superman (1939) #650 continues from The Adventures of Superman (1987) #649
Change it to one of the following with the current series being viewed in bold and all titles in the continuity listed, not just the immediately previous and following series:
Superman (1939) #1-423 > The Adventures of Superman (1987) #424-649 > Superman (1939) #650-ONGOING
Superman (1939) #1-423
The Adventures of Superman (1987) #424-649
Superman (1939) #650-ONGOING
Create a simple if/else php script that will not display the "Multiple Stories in this Issue" table unless there have been stories added. Place the "Add a story to this issue" link to the Toolbox pane.
Remove the "Suggest a podcast for this issue" link in the Toolbox pane and instead just create a forum thread for suggestions.
In the comic issue entry page there are multiple links that can be replaced with simple + gifs or by making the section title the link itself. This is especially important when skimming the entry because the sentence "Add/remove story arcs to this issue" is usually longer than the actual title of the story arc listed below it.
- Code: Select all
Add/remove story arcs to this issue
Add/remove characters to this issue
Add/remove groups to this issue
Add your review
In the comic issue entry page place the credits (writer, penciller, inker, etcetera...) into its own div/table matching the css style of the ratings div/table and remove the carriage returns between the entries. So instead of:
You will show:
The bold title is distinct enough to separate the entries and vertical space will be saved. Between the new credits table and the far-right ratings/toolbox column create another div/table and move into it the publisher, cover price, cover date and format. This will save vertical space, making a more squat entry to prevent too much scrolling down.
Most users realize that the "Search for '*' on eBay" link generates revenue, but it is too conspicuously placed in the middle of the page. Place it out of the way below the Reviews section. The ebay link is also automatically present in creators/publishers/story arcs and other entry pages where it does not belong.
Place the "Prev Issue" and "Next Issue" links above the ratings box in the top-right or in the new middle div. Previous left-aligned and Next right-aligned, both also twice as big as they are now.
- Code: Select all
The Other Comic-Related Media Movies and Video Games links are empty. Remove them or add an avenue for users to add entries. I suggest removal since imdb.com currently catalogs the same information.
It is possible to make use of bold, italicized text and links in issue notes, add an entry in the FAQ page with the codes for reference.
To combat spammers and rule breakers:
Add a link to report an issue as a rule breaker in the user profiles. The link should go to a form allowing an explanation. Once a report is filed it should be listed on the user profile with a thumbs up/down next to it so that other users can agree/disagree with the report. Moderators should the ability to rule and remove reports and to add warnings to accounts. Accounts with warnings have restrictions. Suggestions for restrictions include: can not edit titles, can not add new issues for specified amount of time.
A hastily put together example of the page layout I recommend. Not included are the Synopsis, Groups, Characters and Reviews sections shown as links. A second cover is included to show how a variant cover would stack vertically instead of creating its own issue entry. Click for the full version.