Reviewers Recommend
Gift Of Anal 4, TheGift Of Anal 4, The - review by Captain Jack
Starring: Angela White, Luna Star, Kira Noir, Anna Claire Clouds, Ravyn Alexa. Read review
All Forums > Gay DVD Talk > Gay DVD Talk Forum Page 15 > Gay porn mavens ... database help please ...
AuthorPost
GaySatyr
Senior Member


Half dirty ol' man; half horny ol' goat!
1684 Posts
10/00
Posted - Apr 14 2003 : 5:13PM
I'm attempting to "clean up" some of the studio and title anomalies in the database. I've already re-arranged a few obvious groupings like some of the Falcon studio titles (International Collection, Jocks, Mustang, etc), High Octane, Kristen Bjorn & Sarava, Lucas Kazan (LKP) versus Lucas Entertainment (Michael Lucas), Huge Video (Matt Sterling titles), etc.

As you peruse the database, if you find errors or anomalies, please post them here. (Hopefully, this will prevent multiple suggestions for the same corrections.)

I'll use this thread as a work-in-progress fixit list.

~ GaySatyr

joeblow69
Member

946 Posts
2/00
Posted - Apr 14 2003 : 7:05PM
I've noticed that ever since TLA was added to the database, a number of the reviews got messed up and are pointing to the wrong versions. Is this something you can fix too?

i.e. My reviews of the Fallen Angel films are all attached to the general releases, not the hardcored edits, like they should be.

GaySatyr
Senior Member

Half dirty ol' man; half horny ol' goat!
1684 Posts
10/00
Posted - Apr 14 2003 : 10:16PM
I'll see what I can do. ~ GS
joeblow69
Member

946 Posts
2/00
Posted - Apr 19 2003 : 6:30PM
I found a little anomaly in the database:

Inevitable Love is showing up as a Titan video, but I think it's put out by ATKOL Video.

DONE! ~ GS

Edited by - GaySatyr on 4/20/2003 4:26:29 AM

joeblow69
Member

946 Posts
2/00
Posted - Apr 19 2003 : 6:33PM
Oops, just found another one:

Bottoms Up is both a gay and straight title, but both videos show up in the same search.

And another:

Man Hunt is listed as a Pacific Sun release, but is actually from Renegade.

One more:
White Trash also has a straight porn with the same name that is showing up in the same search.

DONE! ~ GS

Edited by - GaySatyr on 4/21/2003 12:26:49 PM

 
Janitor
Retired

Porno movies, sexy videos, xxx. Adult DVD Talk at your service.
6409 Posts
11/99
Posted - Apr 21 2003 : 11:26AM
jb - the review stuff has to be fixed directly in the database. if you can please email me a list of the review skus and the movie skus they should be attached to, i can get it done quicker.

thanks, guys!

GaySatyr
Senior Member

Half dirty ol' man; half horny ol' goat!
1684 Posts
10/00
Posted - Apr 21 2003 : 12:36PM
Joe & Steph -

The problem here is that the reviews were often attached to the wrong title in the first place - at the point the reviews were written. Review copies were often unedited "director's cut" versions whereas the versions on sale by most online vendors were the edited "general release" copies.

I don't know if this is possible; however, if it is, it would solve the problem:

As almost all of the reviews in question identify the version (usually the "director's cut") for which they are written and also point out the differences, it would be really great if the reviews could be attached to BOTH the "director's cut" and the "general release" versions of DVDs.

Is this possible? Or is the table providing the link between title SKU and review SKU restricted to a 1-to-1 relationship? This is a question that Drew will probably have to address.

~ GaySatyr

Janitor
Retired

Porno movies, sexy videos, xxx. Adult DVD Talk at your service.
6409 Posts
11/99
Posted - Apr 23 2003 : 12:53PM
GS - it's a 1-1 relationship.
malkira
Member

323 Posts
6/02
Posted - Apr 23 2003 : 1:45PM
Probably a dumb question, but how does one access the database?
Janitor
Retired

Porno movies, sexy videos, xxx. Adult DVD Talk at your service.
6409 Posts
11/99
Posted - Apr 23 2003 : 2:12PM
malkira - not sure exactly what you're asking - the reviews and the price search are housed in the database. so you can access it by price searching a title in the top left search box, or thru advanced search. or by searching/browsing reviews. it's basically just a big movie database with prices for the various stores, reviews if they exist for each title, and product info (studio, category, performers.)

gaysatyr has access to our database manager because he is a kind soul who's helped sort out the mess, adding titles, fixing studios, etc.

malkira
Member

323 Posts
6/02
Posted - Apr 23 2003 : 5:06PM
Thanks, Steph. I knew it was a dumb question.

Janitor
Retired

Porno movies, sexy videos, xxx. Adult DVD Talk at your service.
6409 Posts
11/99
Posted - Apr 23 2003 : 6:25PM
malkira - no problem - not everyone is familiar with how databases interact with websites - you'd be surprised at how many executives at tech companies don't understand database-driven websites.
malkira
Member

323 Posts
6/02
Posted - Apr 24 2003 : 4:52PM
Thanks, Steph. I was wondering if there was some sort of gay IAFD or something. I just started really getting into watching gay porn a couple of years ago (been watching bisex porn for years), and I'm still learning which companies and which stars to look for and to avoid. This site has been enormously helpful.

Edited by - malkira on 4/24/2003 4:53:42 PM

joeblow69
Member

946 Posts
2/00
Posted - Apr 26 2003 : 12:00PM
I found another little error in the database this morning. 2 new movies showed up as new releases, and are availalbe only at Gamelink.com: Monster Bang 2: Stick it in and Monster Bang 1: Resort to Anything.

But, both these movies are available thru Adult VideoUniverse, but without the Monster Bang prefix. They're just called Stick it in and Resort to Anything.

So it looks like these 2 movies are in the database twice, but with slightly different names?

I think I've fixed it for all 3 Monster Bang videos ~ GS

Btw, did anyone notice the nice prices AdultVideoUniverse has on most Raging Stallion flicks? Most hover around the $32 dollar range! I just picked up Nexus and Sex Pack 10...


Edited by - GaySatyr on 4/26/2003 12:31:07 PM

GaySatyr
Senior Member

Half dirty ol' man; half horny ol' goat!
1684 Posts
10/00
Posted - Apr 26 2003 : 1:07PM
 
dano
Member

104 Posts
8/02
Posted - Apr 26 2003 : 5:43PM
Very nice. We need some more reviews of Falcon videos. I guess I should bump up my review of Sauna Paradiso.
joeblow69
Member

946 Posts
2/00
Posted - May 28 2003 : 10:31PM
Just found another one.

Looks like there are 2 different movies called Hot Male Mechanics, one by Bacchus, and the other by LA Video.

All Forums > Gay DVD Talk > Gay DVD Talk Forum Page 15Gay porn mavens ... database help please ...

Previous topic: Military Dance
Next topic: News from Private Man . . .



Jump To: