User:KingOfZeal/Projects/

This is all the projects I'm working on, their status, and, if applicable, any other information on the projects.

= The Ship Database = The Ship Database was originally made for the flag I was in, Caper's Capers, as a way to keep track of where our ships were in the flag, without having to keep a spreadsheet or posts on forums updated.

Basic Information
The Ship Database is written in PHP, with a mySQL database backend. Since the original creation of the script, I have since modified the script in such as way as to accept entries from multiple flags. When logged into the script, you are restricted to the ships in the flag you are logged in as.

Extended Information
The Ship Database offers a convenient way for medium- to large-sized flags to keep track of ships, as well as Captains and other officers to keep track of their personal fleet. The interface is simple, and it can be a very helpful tool. Many island-controlling flags have a separate fleet crew: a single crew that houses hundreds of war ships. Most of the time, it is the same as the founding crew. With the database, the crew (and flag, by extension) can organize and determine their fleet. Every ship entered into the database, in addition to having places for ship type (class), the crew owning the ship, vessel name and owner's name, can also carry short notes.

In addition to displaying the default summary page and a full vessel list for a specific crew, there is a statistics page, where a person can see the total number of ships of each class for each crew. The is also a filter-style search page, to help find those odd ships. The vessel name is parsed off for adjective (or first word) and fish name (or the remaining part of the name, for custom renames), so you can find, for example, all "Adaptable" ships in your flag. You can also combine filters: You can filter by adjective/first word, fish name/phrase, crew, owner and/or ship class.

Currently, the database is released only to those we know and trust, for security purposes, though a demo account is set up for those who are interested. Those who are interested should contact Yamorg on Midnight, or KingOfZeal on the forums. A changelog on the script can be found at http://pirates.signet-studios.com/shipscript-changelog.txt. I have added in some basic security measures which need testing. Once the testing is complete, I will release it to the general public. For more information, contact me. See also: This post on the main Puzzle Pirates Forums.

Extra Information
When a flag is created for the database, it is assigned a random 16-character hexadecimal password (total combinations: 18,446,744,073,709,551,615). This may be expanded to 0-9/a-z, which would be 7,958,661,109,946,400,884,391,936, or roughly 8 Septillion combinations. This ensures that each flag's information is reasonably secure. The database is also backed up on a regular basis, in case of system failure or other unforeseen problem.

Each flag has a unique set of passwords for both the Ship and the Shop Database.

= The Shop Database = The Shop Database was originally made for the flag I was in, Caper's Capers, as a way to keep track of where our shops were in the flag, without having to keep a spreadsheet updated.

Basic Information
The Shop Database is written in PHP, with a mySQL database backend. Like the Ship Database, I have since modified the script in such as way as to accept entries from multiple flags. When logged into the script, you are restricted to the shops in the flag you are logged in as.

Without a doubt, of the scripts I have written to date, this is my favorite, both in layout and in features. While the backbone of the script was based off the Ship database, many features were dropped, such as the admin function. However, in writing this, I did manage to learn many new things about PHP/mySQL. This was also the first script I wrote entirely using a developers server on my computer: Instead of uploading a revised file every time a small error is made, I instead host a local server on my computer, with PHP and a copy of the mySQL database I use, so it's easier to fix mistakes, and ensures the final (published) script is working perfectly. This also allows me to use test data in the database, that won't exist in the final database.

Extended Information
Currently the shop database can only be used on Midnight. I have no plans on making multi-ocean support, though that may change in the future.

Screenshots
All images are external links.

Image 1 Image 2 Image 3 Image 4 Image 5 Image 6 Image 7

=Fish Museum=

It has been requested, thanks to this thread on the forums, that I start to put together a fish museum, in much the same way Cnossos is home to the Hall of Black.

Information
After completing the fish chart I sought after in the aforementioned thread, it was mentioned that I start up a museum of sorts that contain every possible fish color possible.

The original reason I made the fish chart was to orginize the many fish I happen to obtain through sinking blockades. I am ever searching for the last of my injuries, the peg leg, and as such attend (and at times, even organize) sinking blockades in an attempt to get it. However, it seems all I end up with are fish. I don't use fish as bludgeons (I prefer my hook), and as such I'm gathering a rather large collection. At last count, my personal collection numbered 94 fish, with about 78 of them being unique out of a possible 256.

When I started putting the image together, I used This chart as a reference on where to put the colors. After compiling the image, I felt it was a little lacking (lots of empty space), and thus decided to go around the ocean, visiting all the shipyard (both Shoppes and Stalls), looking for fish. On going around the ocean doing this, and visiting a few hearties who were crazy enough to let me in their house, I had obtained all the possible colors but 32. It was at this point I made the post on the forums requesting the fish, which lead to the discussion of this project.

Requirements
There are 256 total possible color combinations of fish. The bodies and fins can be of any known color except yellow and violet, which keeps in line the possible color combinations for regular bludgeons, meaning there are 16 colors to choose from for either position.

Assuming a trunk can hold no more than 20 fish, I need 13 trunks. Since only one trunk may be placed in a single scene, I also need 13 scenes. While I personally think that having the entire collection on an appropriately named ship would be fun, it would be restrictive to those who want to see it. That, and no one ship has that many scenes. I have also discussed the possibility of using a single building, such as a palace, but even a palace doesn't have that many rooms.

Because of this restriction, I am open to ideas on where to place the trunks. I would prefer to have them all in the same place, ideally a publicly accessible building of some sort, as opposed to thrown all across an island's map (like, for example, all the Bazaars on an island). You can contact me by this Talk page, PMing me on the forums (KingOfZeal), or contacting me in-game on the Midnight Ocean (Yamorg).

Also, if you have any fish that you would like to donate, let me know. I'll be glad to take them.

Needed Fish
The following is a link to an image that shows all the fish I currently have in my collection. If you have fish you would like to donate toward this project, please contact me as mentioned above.

fish collection.PNG

Fish Chart
If you want to see what all the fish look like, the following is a link to the chart I compiled, showing all the possible color combinations of fish.

fishies.PNG

From my experience, there are 3 sets of colored fins that are difficult to differentiate: While gold is not difficult to determine when you have something to compare it to, if you don't, many times it will be mistaken for orange. A grey finned fish will have a rather dark left tail fin, as well as a thicker outline on the right tail tin. When put side-by-side, the back fin will also appear grey. This one is the most difficult: the best way to identify these is by the tail fin: Navy will have a darker left tail fin, and a more vibrant right side. A purple tail fin will have both sides look closer in color.
 * Red/Orange/Gold
 * White/Grey
 * Purple/Navy

= Teamspeak Server = Currently, I host a public Teamspeak server dedicated to Puzzle Pirates. The server is set up with an individual channel for each ocean, and each channel allows for subchannels as well, for those who want a private channel. It is encouraged that all nicks are appropriate to a public venue and any subchannels that are created are destroyed when finished. The server address is 209.59.137.154:8767.

About Teamspeak
Teamspeak is a free Voice over IP (VoIP) program, with emphasis on gaming chat. The client is available for download at http://www.goteamspeak.com.

The current server version is 2.0.23.2 BETA. All actions occurring on the server (logons, logoffs, channel chat messages) are logged and reviewed on a regular basis. Note: Private person-to-person messages are not recorded.

Policies and Guidelines
If you have any questions about the server or its policies, post it on the forums found at http://signet-studios.com/phpBB2/index.php. Registration and email verification is required to post. For most violations, one warning is given to the user, and any further violations may result in a ban, at my discretion.