Milovana.com

Because I am a kind of an archivist and love the Cock Hero movies I thought I need some kind of an overview of all the scenes out there.
So I was busy and present you today the Cock Hero Database or CHDb.

It's a 4 MB big Excelfile and I would like to present you the features (warning big pictures inside):

Spoiler: show

1. Scenes:
As you can see there are the basic information about every scene like author, song, from which movie the scene comes from, the Code for the randomiser etc. Also there are tags for different categories like the stroking pace or "Teens", "Dancing", "Blowjob", etc. so you see whats going on in the scene. Ah and of course a screenshot.



2. Movies:
The second tab gives you an overview of the different movies which can be found on milovana. The screenshot is old, there is every movie except CH Galaxy which might follow soon.

There are two ways to use the tags and other data to find easily the scenes you want for your CH-Movie.
1. Sorting:

Spoiler: show

Okay, let's say we are looking for a big challenge, scenes with superfast stroking pace without any brakes.
When you have a small screen you have to scroll to the right to see what I am doing.
At first we click in the field "Superfast". Than we go the "Sort and filter" (maybe it's called differnt in english) and sort from A - Z



Now we see at the left that scenes are missing. These scenes aren't tagged as superfast and they were sort after the superfast scenes.



The same procedure but this time with the field "Breaks".



2 more scenes are missing now. Because they had no breaks they went down. We now have the following order:
first: scenes WITH breakes and WITH superfast speed.
second: scenes WITH breakes and WITHOUT superfast speed.
third: scenes WITHOUT breakes and WITH superfast speed.
fourth: scenes WITHOUT breakes and WITHOUT superfast speed.

The third is the combination we were looking for!


So we scroll down till the scenes without breaks appear. You see there are 43 (45 lines - 2 from the header) scenes with breaks.


Now we can select with the strg-key or the shift-key the scenes we wanna watch. And copy and paste it into the Randomiser or Editor. I made a mistake the scene 3-8 shouldn't be in the editor.


You can sort the hole list with every tag there is.
You want only long scenes? Sort by length.
Only Hardcorescenes? No problem.
All the scenes from In the Crack? You got it, right?

2. Filter:

Spoiler: show

Okay, same scenario as above. We are looking for superfast scenes without any breaks.
1. Clicking on the small triangle under "Superfast"
2. Select the wanted items. We want superfast scenes so we select the 'x' and deselect the field (empty).
3. Hit OK


What happend?
1. You can see that Excel is hiding some rows.
2. It hides every row without an 'x' at superfast.
3.The trianglesymbol has changed, an indicator for an active filter.
Next step, kick out any scene with breaks inside.
4,5,6: Same procedure as above but now we select (empty) and deselect 'x'


I zoomed out a bit to show you the result.
Every scene shown to you now contains superfast stroking pace an no pauses at all.

These two methods cannot be combined! Otherwise the screenshots ends up in big mess.

At first I thought it would be cool to do it with google docs so everyone can add new scenes but there is no support for the screenshots or many other features excel provides. When you know a site were I could upload this file and everyone is able to download and replace it with a newer version contact me.
I don't know how long I will create updates and when it's public anyone can help keep the file up to date when the interest exists at all.
It was a lot of work to create this thing. I found almost every song and a few actors but there are still many names missing. When you want to contribute your knowledge feel free to share the informations you got. When my tags doesn't match your taste or you disagree with some decisions I made you can change the file as you like it on your computer. If you do so please tell me what you are changing or send me your file. I am really curious where the imperfection is

I am not a good writer and more than ever in english but I hope you could understand anything. If not feel free to ask!

Download:
The Excelfile in .xslx format: http://ifile.it/weqm9fy (4.3 MB v2.1)

Changelog:

Spoiler: show

• v2.1 Updatet all the codes for the randomizer, added a lot of videos, tagged a lot of videos, still missing videos and a lot of missing screenshots and difficulties
• v1.2.1 minor update, added some names and sites, started to implement "Stroker Ace"
• v1.2 filters are now working
• v1.1 added codes for movies to match randomiser 1.3, few actors added
• v1.0 There it is.

As a bonus:
Only the Screenshots from the scenes in 1280x720. The filenames matches the randomisercodes so people without excel can create CH-Movies with the help of the screenshots:



http://ifile.it/dna0utp (10 MB v2.1)



Greetings and thanks for all the great movies
plissk3n

WOW!
Great job and thanks for all of the effort you put into this!

Thanks

I've updated the excel and the screenshots.
All codes are up to date and I added a few more actors I've found in the last day.

First off, incredible work! This must have taken forever to put together.

Second,about the filter/sort:

You have a couple options:
1)Right Click Picture > Size and Properties...>Properties Tab>Select "Move and Size with Cells"

This fixes the filter problems, but sorting still does not work.
(For the Excel inexperienced, the pictures stay in their correct place if you hide rows but not if you reorder the row)

2) You can put the picture in a comment. This will solve all of the problems with both the filter and sort, but you will not be able to see the picture without hovering your mouse over the cell or clicking on it.

So, couple partial fixes, but both have their own problem.

Thanks for your help!
I've tried the option "Move and Size with Cells" but then sorting AND the filters didn't work
The current option of the pics is "Move with Cells" and the sorting does work (for me). To put the images into comments istn't an option for me because the quick overview is lost.

But while I was trying around I realised what is leading to the malfunction.

When I am filtering for example for '2' in the Girls column the first scene is row 7 with the correct image and the second row 29 with a wrong one.
When I drag'n'drop the first image out of the way underneath the correct one appears the image of row 6 underneath that from 5, 4 and 3. (First two rows are captions)
Same with the row 29. Every image from the rows 7-29 are located in the same field.
When I rightclick the correct image before I filter and select "In the foreground" the image will be at the top of the stack and be visible.
So I rearanged the order of the pictures. Picture from row 3 (1. picture) lowest layer und then ascending to the last row which is the top layer. When filtering the pictures are stacking but the top picture in each case is the wanted one.
What doesn't work is to use the sort combined with the filter function. But at least the filters are working

Thanks nullset for the help and initiation.
The new version is updatet in the first post along with an explanation to use them.

Damn!
CH11, Flux 3, Stroker Ace and this über thing tease with over 20GB from Onepiecefan and me without the time to add it to the CHDb. If anyone wants to add anything from the new ones feel free to do it.
I will get the time at the earliest in one or two weeks.

Also I appreciate critic very high. The feedback so far was not really much so I really wonder if anyone else find this thing helpfull or use it.

Cheers plissk3n

//also I would be very gladfull about some ideas how to categorise the difficulty of the scenes. So far 90% are tagged as "hard" 7% as medium and about 2% as easy. One or two as "Very Hard".
Maybe count the beats in the tease and divide it by the length?
I think a differentiated rating with about 10 steps or so would help to create teases regarding the difficulty of the scenes.

update?

Update, Please

Hey,
thanks for the interest but certainly I've got some other things to do and I didn't find the time.

I know that there are a lot of new (and absolutly awesome) clips out there but when I look in my schedule, I don't see an update soon

When someone knows a site where you can upload a file and a lot of people are able to update them this would be perfect. Like Dropbox but with more privacy.
Here is the latest file I've got on my Disk, there are only minor updates with a few more actor names and sites. Also I've started to implement the "Stroker Ace" video but it's not finished.

CHDb v1.2.1: see first post

If anybode wants to contribute here are a few things to keep in mind:

Spoiler: show

When adding screenshots it's important that the pic of the first scene of the video is also the first one added. The pic from the last scene (of all scenes in the file) the last one added. This is important for the filtering function to work. While resizing the pics the "alt" key will help you to snap the pic into the field corners, the ratio is 16:9

Every "time" field is formatted like: hh:mm:ss so if your scene is 4:25 long you have to enter: 00:04:25.

The column "superfast" is sometimes called in the videos doubletime. Sometimes the beat goes crazy to as fast as you can this falls also in this column. The "standart" speed in all videos is "fast".

When you don't know a song go to http://www.midomi.com/, enable scripts if you block them and the play the scene while recording. Found every song for me and it's fast.

Greetings

WOW!
Some major update here:

1. Updatet all randomiser Codes!
2. Added: Stroker Ace, Flux 3-6, CH 11-15, Pornstar Edition Gracie Glam, Hard Beats, QT, CHHC 2 (just tagged the scenes, the screenshots are missing
3. added the difficulties based on the difficulty database from Bill McNeal
4. New "favorite"-column, just write an x in it to mark it as your favorite

Still much work to do but many more scenes are now covered and every scene has again the correct code. If someone wants to help, I would be really glad about some good screenshots which I could implement. If somebody wants to do it please contact me.

Downloads of the xml and the screenshots are in my first post.

What do you think? What could I do better?
Cheers plissk3n

The last update, there are many hours of work in that file but it isn't finished yet.
If you want you can complete it but be warned ;)

CHDb v2.2:
http://www.mediafire.com/view/?u60ebms6l54zjea

Just thought I'd chime in: thanks for your work!

I'm getting a message saying "no such file"

reload PLEASE