VGCollect Forum

VGCollect Site Stuff => Video Game Database Discussion => Topic started by: leonefamily on June 10, 2021, 10:02:50 pm

Title: LeoneFamily's VGC Database Work
Post by: leonefamily on June 10, 2021, 10:02:50 pm
I'm following
expanding
I'm taking inspiration from

I'm stealing dhaabi's format / idea to make a thread about my work in the VGC database to boast myself to improve the website to let others know about what parts of VGC's DB (talk about abbreviations!) could be considered as "under construction" to kind of make regular users aware that these sections are kind of a mess and to be more careful about the listings they create since a lot of them will be corrected for consistency and anti-redundance purposes. I think it's also a good way to let the admins know about what I'm generally up to, and it serves as a way to show what I'm generally going for when I make edits. No admin has asked me to do this thread, I'm just doing it on my own.

- Canadian & [CA][MX] releases. I consider myself an expert on the subject at this point. There is no real end to this project due to the insane amount of items it includes. I just post canadian releases as I add them in my collection.

- Xbox / Xbox 360 Demo. Started cleaning up that section in late 2019 but have took a break from this project for a while. But still have the whole project in my backlog and it will be complete at some point. Some info here: https://vgcollect.com/forum/index.php/topic,10473

- 3DO Hardware & Accessories. I am currently doing a lot of work and research on the 3DO hardware and accessories, and I even have a close contact with the founder of archive3do.com, a true big time expert of the 3DO who gives me crucial information about it every day. My backlog has become an absolute treasure of 3do information and it's all just waiting to be all added/edited to VGC. To a lesser extent I also get help from a close facebook community of 3do fans with some members being people who have worked on the 3DO back in the day as well as ex game devs of some 3DO titles.

My mild knowledge of Korean also means that I know a thing or two about korean releases and I can write / read Korean Hangeul characters without any help. Naturally, I have no problem writing down the box text and titles of korean releases using the korean keyboard, but otherwise I don't consider my work in the korean releases to be a project in itself. I'm sure even dhaabi must have redacted more korean entries as I did at this point.

That's about it for now!
Title: Re: LeoneFamily's VGC Database Work
Post by: jason on June 11, 2021, 12:50:00 am
Thanks so much for the help!  8)
Title: Re: LeoneFamily's VGC Database Work
Post by: koemo1 on June 14, 2021, 08:37:32 am
Thank you so much man!
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on September 22, 2021, 07:49:13 pm
From now on I will publish notes intended for admins when I'm about to make edits that may look fishy. This will let me explain why the edits are being done in the hopes they will pass better.

I'm about to add the [UK] TLD to this item:

https://www.vgcollect.com/item/60071

Because I have found a "general" english release for mainland Europe and I'm about to upload it to the database.

Also, I'm unsure about the following item:

https://www.vgcollect.com/item/60324

Despite the back text being in English, you can see that there's the Netherlands flag on the back cover (and the text inside that box is in Dutch). There exist a english release for the UK, which looks like this (notice the UK flag):

https://www.ebay.ca/itm/203399365044

Should it be considered as the "general" english release or as the [NL] release? As usual with every edit I make and every item I add, I have a copy of this variant irl.
Title: Re: LeoneFamily's VGC Database Work
Post by: dhaabi on September 22, 2021, 10:30:45 pm
Also, I'm unsure about the following item:

https://www.vgcollect.com/item/60324

Despite the back text being in English, you can see that there's the Netherlands flag on the back cover (and the text inside that box is in Dutch). There exist a english release for the UK, which looks like this (notice the UK flag):

https://www.ebay.ca/itm/203399365044

I can confirm finding one copy for sale in Netherlands through marktplaats, three copies for sale in Belgium through 2dehands, and zero copies for sale through eBay UK. It seems likely that a TLD of [BE][NL] is correct.

Should it be considered as the "general" english release or as the [NL] release? As usual with every edit I make and every item I add, I have a copy of this variant irl.

However, entry 60324 is for the general Europe release. I've updated the back art. The [BE][NL] item will need a new entry, if that's the version you own.
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on September 23, 2021, 11:08:22 am
Well yeah technically I own the [BE][NL] but there's no Belgium flag on the artwork and the text remains in English, except in the box where the flag is, there's some dutch. That's why I would only call it [NL] and not [BE][NL]
Title: Re: LeoneFamily's VGC Database Work
Post by: tripredacus on September 23, 2021, 11:49:32 am
The people who design the covers use the flags to indicate which languages are in either the game or the manual. Our use of TLD is where the item is sold, not what flags are on the cover or what languages are in game or paperwork.
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on September 24, 2021, 09:17:26 pm
The people who design the covers use the flags to indicate which languages are in either the game or the manual. Our use of TLD is where the item is sold, not what flags are on the cover or what languages are in game or paperwork.
Yes, I'm aware of that. What I meant is: isn't using the [NL][BE] TLD redundant given that there is no french on the artwork like you would expect with a [BE] release? In my eyes this is just a [NL] release, it just happens that they sold it in Belgium as well. If we follow this logic, the vast majority of PS2 NTSC games would have a ridiculous [US][CA] TLD since lots of [US] releases were also sold in Canada. Some games did of course have a unique Canadian release which is why the [CA] TLD is common. Given that this game only has english and dutch on it I would just call it [NL] and I would only use [BE] for copies that have both Dutch, French and no "Attention" red label. Otherwise literally 99% of [NL] releases would by extension become [NL][BE].

But if you agree with dhaabi I'll go ahead and create it as [NL][BE] and will keep this in mind for when I upload more european releases.
Title: Re: LeoneFamily's VGC Database Work
Post by: fazerco on September 25, 2021, 01:14:57 pm
The people who design the covers use the flags to indicate which languages are in either the game or the manual. Our use of TLD is where the item is sold, not what flags are on the cover or what languages are in game or paperwork.

Slight mistake there. When flags are on the cover, they are usually sold in those countrys. And you can choose out of more languages in the game.
Title: Re: LeoneFamily's VGC Database Work
Post by: tripredacus on September 27, 2021, 09:40:55 am
On the [US][CA] example, it is not a valid comparison. US is to NA as UK is to EU. US releases never get their TLD on an entry into NA category, same as UK. UK can sometimes but only because EU categories are way more complicated than NA. NL isn't the same there.

As for whether our entry needs [BE] in it, the answer is no. Using just [NL] is fine and would be just the minimum requirement.

Regarding Fazerco comment, it depends. Sometimes yes and sometimes no. Since sometimes no is valid then we cannot use a blanket statement such as "flags mean the game was sold there" because it is sometimes wrong. So we disregard the flags having any connection to where it is sold, but can use then to help identify it. Such as, we know many games that have the flag for France but do not have the government required Attention text indicate that the item is not sold in France but instead sold in a French speaking country such as Belgium or Switzerland.
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on October 19, 2021, 02:10:49 pm
Would like to point attention to the following items:

https://www.vgcollect.com/item/207702
https://www.vgcollect.com/item/95299

Item 207702 I have created myself. It has exactly the same text, barcode, item number, e.t.c. than the other. I called it "early box design" because it seems to follow the box style of the very first japanese model (SCPH-1000) while the other design looks more like the later revision boxes. If "early box design" is not a good name, go ahead and change it. I'm sure dhaabi must know something about it? (given he's our PlayStation connaisseur god)  8)
Title: Re: LeoneFamily's VGC Database Work
Post by: dhaabi on October 19, 2021, 03:09:43 pm
Well, you're certainly giving me way more credit than I deserve regarding my knowledge of PlayStation, I think. As far as I can tell, the packaging information between color box designs and sepia box designs are (almost always) the exact same, but there may be instances of that not being so. I'll try to gather some concrete information relating to when the designs changed or if there actually is anything different aside from the box design. At the very least, I'm sure that the item numbers found on the back of the memory cards are different, as memory card item numbers changed frequently as additional print runs debuted.

Other first-party PlayStation accessories such as RGB Cable SCPH-1050 have two (https://vgcollect.com/item/38932) different (https://vgcollect.com/item/206475) designs as well. I've even encountered a third-party Hori accessory with sepia (https://vgcollect.com/item/207090) and colored (https://vgcollect.com/item/207089) boxes also. Sometimes there are notable differences between items like these, such as Mouse Set SCPH-1030, where the sepia box item was made in Japan (https://vgcollect.com/item/206209) while the color box item was made in Malayasia (https://vgcollect.com/item/206208).

I did change the entry name, though. "Early box design" isn't an ideal descriptor as that would require someone to know what the physical characteristics of later box designs are too.
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on October 19, 2021, 04:22:32 pm
Well, you're certainly giving me way more credit than I deserve regarding my knowledge of PlayStation, I think.

It's my way to thank you for your amazing contributions to the database over the years but especially in recent times  ;)


I did change the entry name, though. "Early box design" isn't an ideal descriptor as that would require someone to know what the physical characteristics of later box designs are too.


Oh yes! Sepia is a perfect way to describe it, I totally agree!
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on May 28, 2022, 03:31:23 pm
(https://i.imgur.com/9GIDtam.jpg)
(https://i.imgur.com/yMWMt3K.jpg)

This is the SNES-2-3DO (Black/Gold variant). It can be purchased here:

https://controlleradapter.com/products/snes23do

I'm going to add it to the database, but I'm unsure about a few details. These accessories are made by one guy with his 3D printer, so obviously it's going to go in the Unofficial Release category. But I'm wondering, could the shipping box it comes in be considered as the actual "item box"? On one end, it's just a shipping box, but yet there's the ControllerAdapter logo on it. And also, there's a sticker of the ControllerAdapter logo inside (as well as candy). Should I consider this as the item box when I create the item in the database or should I disregard this and just consider this item as a loose artisanal accessory? Also, we have to keep in mind that there are different color variations but that difference is not indicated on the box itself, only on the shipping slip.
Title: Re: LeoneFamily's VGC Database Work
Post by: dhaabi on May 28, 2022, 06:15:38 pm
This is the SNES-2-3DO (Black/Gold variant). It can be purchased here:

https://controlleradapter.com/products/snes23do

I'm going to add it to the database, but I'm unsure about a few details. These accessories are made by one guy with his 3D printer, so obviously it's going to go in the Unofficial Release category. But I'm wondering, could the shipping box it comes in be considered as the actual "item box"? On one end, it's just a shipping box, but yet there's the ControllerAdapter logo on it. And also, there's a sticker of the ControllerAdapter logo inside (as well as candy). Should I consider this as the item box when I create the item in the database or should I disregard this and just consider this item as a loose artisanal accessory? Also, we have to keep in mind that there are different color variations but that difference is not indicated on the box itself, only on the shipping slip.

Unless the outer shipping packaging is unique to SNES-2-3DO specifically, then I don't see any reason for any of the entry art slots to feature it.

Regarding the bundled sticker and candy, individual entries may be submitted for each in the swag categories if you're wanting them to be a part of your collection. Or, alternatively, you may just detail in the SNES-2-3DO entry that they were included inside the shipping packaging but not the actual item packaging.
Title: Re: LeoneFamily's VGC Database Work
Post by: tripredacus on May 31, 2022, 10:37:41 am
In a case where an item's box is known, it should be put as the front art. The only way it wouldn't was if the outer box is generic (say this guy sells many things and uses this one box size for multiple things) and the thing inside the box has some other packaging (such as a plastic bag) then the plastic bag is considered the container. Then an image of the item in its original bag can be the front art.

It is rare for this situation to occur. It is usually third-party or bootleg items, notably those generic controllers you can find on Ebay or Alibaba or wherever.
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on May 31, 2022, 01:23:16 pm
Thanks both for your replies. Controller Adapter is actually that guy's registered company name. Therefore, I will list it under Controller Adapter SNES-2-3DO (Black/Gold). Since the controller adapter logo is on that "shipping box" I'll count it as the actual item's box.

There's 4 different color variants for this item. Should I add them all separately? I spoke with the guy who builds these accessories and he told me that all the color variants share the same shipping box, the only way to tell the variant without opening the box is to look at the shipping label where the color is indicated.
Title: Re: LeoneFamily's VGC Database Work
Post by: tripredacus on June 01, 2022, 10:09:38 am
You can add them if you want.
A note however. the colors should only be capitalised if those words appear on the box or some included thing like the paperwork. If there is no text on the physical item regarding the colors, you can still use them but should be in lowercase.
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on January 08, 2024, 12:35:10 am
V-Rally Championship Edition (PAL) on the PS1. I have my hands on two copies where everything is the same except the font is slightly different. The left copy has a bolder font than the one on the right. Item #87097 is what would be considered the "Bold" font while we don't have anything in the DB for the "Light" font. Would this be worth making 2 entries named (Bold font) and (Light font) or is the difference too light to separate them?


(https://i.imgur.com/3kp7JG3.jpg)
Title: Re: LeoneFamily's VGC Database Work
Post by: dhaabi on January 08, 2024, 09:29:43 am
V-Rally Championship Edition (PAL) on the PS1. I have my hands on two copies where everything is the same except the font is slightly different. The left copy has a bolder font than the one on the right. Item #87097 is what would be considered the "Bold" font while we don't have anything in the DB for the "Light" font. Would this be worth making 2 entries named (Bold font) and (Light font) or is the difference too light to separate them?

The variation is substantial enough to create a new entry. However, I'd recommend submitting scans of the items and relaying any spine number or jewel case differences for others to see too. It doesn't hurt to have a second or third pair of eyes, because small details easily could have been missed. Also, were these items purchased sealed? If so, do their contents vary?

After searching through eBay, about 50 unique listings for the items at hand appear, but only one (https://www.ebay.co.uk/itm/372658546545) relates to the emboldened text variant. Unfortunately, though, the listing features little image information. I had the same luck with Wallapop where about 10 listings appear, but they're all for the thin text variant.
Title: Re: LeoneFamily's VGC Database Work
Post by: tripredacus on January 08, 2024, 10:19:23 am
I can't tell that difference, but I do come across some that have and some that don't have a barcode on the back cover.
https://www.ebay.co.uk/itm/115938583883
https://www.ebay.co.uk/itm/296109265405
https://www.ebay.co.uk/itm/134710012934
Title: Re: LeoneFamily's VGC Database Work
Post by: leonefamily on January 10, 2024, 10:27:30 pm
If there was any other way to distinguish them I would have done it this way. But anyways, just to be safe, I just did a full detailed examination again and I can still confirm that every text is the exact same everywhere. The disc is the exact same too and they have the same manual. The bold/thin font doesn't just apply to the front art, it's also different on the side spine, back art, and even on the back text of the manual.