search

pellcorp / opendb

Open Media Lending Database
38 stars 24 forks source link

add new item: "System:" field does not grow with additional systems added #60

Closed s3lm closed 10 years ago

s3lm commented 10 years ago

Hi. Within "System Attribute Types Admin Tool", "GAMESYSTEM Attribute Type Lookups" I added some systems to show when adding new games (PS VITA, PS4, etc). Now, when I want to add new games, the "System:" field with all the system icons is too small to show all systems. It does not "grow" with new systems being added with time. Any idea maybe to change a line in item_input.php so the field grows with new systems being added?

pellcorp commented 10 years ago

Can you provide me the GAME SQL file and related icons so I can reproduce. It's probably actually just a css problem.

s3lm commented 10 years ago

Hi, thanks for the fast reply.

I wanted to post in the forums, but somehow this wouldn't work. So I decided to open a ticket :)

It's really probably a CSS thing, or maybe in the html file. Here's a screenshot. Currently, I can't select the Neo-Geo CD bulletin.

Actually, where is that GAME SQL file? Sorry, is it a file or do I have to dump part of my database?

Greetz, Niklas

Am Donnerstag, 5. Juni 2014, 15:31:20 schrieb Jason Pell:

Can you provide me the GAME SQL file and related icons so I can reproduce. It's probably actually just a css problem.

Reply to this email directly or view it on GitHub: https://github.com/pellcorp/opendb/issues/60#issuecomment-45283530

pellcorp commented 10 years ago

The forums on source forge have been disabled. The source forge project is no longer active. All development and support is now via github. A ticket is exactly the right place to report bugs, ask questions, suggest improvements.

If you look at the different labels that are available, this is essentially a all in one bug reporting, question asking, feature request, etc part of github. Very useful and I much prefer it to sourceforge.

The labels are:

  bug
  duplicate
  enhancement
  invalid
  question
  wontfix

On Fri, Jun 6, 2014 at 10:22 PM, s3lm notifications@github.com wrote:

Hi, thanks for the fast reply.

I wanted to post in the forums, but somehow this wouldn't work. So I decided to open a ticket :)

It's really probably a CSS thing, or maybe in the html file. Here's a screenshot. Currently, I can't select the Neo-Geo CD bulletin.

Actually, where is that GAME SQL file? Sorry, is it a file or do I have to dump part of my database?

Greetz, Niklas

Am Donnerstag, 5. Juni 2014, 15:31:20 schrieb Jason Pell:

Can you provide me the GAME SQL file and related icons so I can reproduce. It's probably actually just a css problem.

Reply to this email directly or view it on GitHub: https://github.com/pellcorp/opendb/issues/60#issuecomment-45283530

— Reply to this email directly or view it on GitHub https://github.com/pellcorp/opendb/issues/60#issuecomment-45330683.

pellcorp commented 10 years ago

In the System Item Types Admin there is a SQL link against each item type, that will generate SQL of the selected item type.

Also the image did not show up can you post a link to an image from http://picpaste.com/ or something

pellcorp commented 10 years ago

Can you test it out on the demo site. Login with user 'test', password 'test'

http://opendb.iamvegan.net/demo1.5/item_input.php?owner_id=test&s_status_type=&item_id=&instance_no=&parent_item_id=&parent_instance_no=&s_item_type=GAME&op=new

Here is what it looks like for me:

http://picpaste.com/game.png

pellcorp commented 10 years ago

Also be sure to mention your browser / os combo

If its windows 8, you are out of luck as I don't use windows at all, and certainly not windows 8. I am happy to try and fix issues on chrome or firefox, but other browsers are a challenge.

s3lm commented 10 years ago

ok, lets see.. Firefox 29.0, Kubuntu 14.04 LTS Opera 12.16 same problem.

http://mehve.de/opdb/Screenshot.png http://mehve.de/opdb/C64.gif http://mehve.de/opdb/neogeocd.jpg http://mehve.de/opdb/NGPC-Logo.gif http://mehve.de/opdb/PS_Vita_logo.png http://mehve.de/opdb/Sega_CD_Logo.jpg

Hope this helps, thanks a lot, opendb rules them all, since years, a decade?.. here is the game.sql

#########################################################

OpenDb 1.5.0.7 'GAME' Item Type

#########################################################

#

Item Type

# INSERT INTO s_item_type ( s_item_type, description, image ) VALUES ( 'GAME', 'Console / PC Game', 'joystick.gif' );

#

Attributes (non-core)

# INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'IMAGEURL', 'Item Image URL', 'Image', 'url', '50', '*', 'IMAGE', NULL, NULL, 'hidden',NULL, NULL, NULL, NULL, NULL, 'N', 'Y', 'N', 'N', 'IMAGE', NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'SERIES', 'Series Name', 'Series Name', 'text', NULL, NULL, NULL, NULL, NULL, 'display','%display%', NULL, NULL, NULL, NULL, 'Y', 'N', 'N', 'Y', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'VOLUME', 'Volume/Series Number', 'Volume/Series #', 'text', '3', NULL, NULL, NULL, NULL, 'display','%display%', NULL, NULL, NULL, NULL, 'N', 'N', 'N', 'Y', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAME_PLOT', 'Description of game', 'Description', 'textarea', '50', '5', NULL, NULL, NULL, '%value%',NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAMEPBLSHR', 'Publisher', 'Publisher', 'text', '50', NULL, NULL, NULL, NULL, 'display','%value%', NULL, NULL, NULL, NULL, 'Y', 'N', 'N', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAMESYSTEM', 'Game System', 'System', 'radio_grid', '%img% %display%', 'VERTICAL', NULL, NULL, NULL, 'display','%img% %display%', NULL, NULL, NULL, NULL, 'Y', 'N', 'Y', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAMEGENRE', 'Game Genre', 'Genre', 'checkbox_grid', '%display%', 'VERTICAL', NULL, NULL, NULL, 'category','%display%', NULL, NULL, NULL, NULL, 'Y', 'N', 'Y', 'N', 'CATEGORY', NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAMEREGION', 'Game Region', 'Region', 'single_select', '%display%', NULL, NULL, NULL, NULL, 'display','%display%', NULL, NULL, NULL, NULL, 'Y', 'N', 'Y', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAMEPBDATE', 'Date Published', 'Published', 'filtered', '10', '10', '0-9/', '%field% (DD/MM/YYYY)', NULL, '%value%',NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'NO_PLAYERS', 'Number Players', 'Players', 'number', '3', NULL, NULL, NULL, NULL, 'display','%value%', NULL, NULL, NULL, NULL, 'Y', 'N', 'N', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'CONTROLLER', 'Special Controller', 'Special Controller', 'text', '50', NULL, NULL, NULL, NULL, '%value%',NULL, NULL, NULL, NULL, NULL, 'N', 'N', 'N', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'GAMERATING', 'ESRB Video and Computer Game Rating', 'Rating', 'radio_grid', '%img% %display%', 'VERTICAL', NULL, NULL, NULL, 'display','%img% %display%', NULL, NULL, NULL, NULL, 'Y', 'N', 'Y', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'FEATURES', 'Game Extra Features Details', 'Features', 'textarea', '50', '5', NULL, NULL, NULL, 'list','ticks', NULL, NULL, NULL, NULL, 'N', 'N', 'N', 'N', NULL, NULL); INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, input_type_arg1, input_type_arg2, input_type_arg3, input_type_arg4, input_type_arg5, display_type, display_type_arg1, display_type_arg2, display_type_arg3, display_type_arg4, display_type_arg5, listing_link_ind, file_attribute_ind, lookup_attribute_ind, multi_attribute_ind, s_field_type, site_type ) VALUES ( 'COMMENTS', 'Extra Comments', 'Comments', 'textarea', '50', '5', NULL, NULL, NULL, 'display','%value%', NULL, NULL, NULL, NULL, 'N', 'N', 'N', 'N', NULL, NULL);

#

Item Attribute Relationships

# INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'AMAZDEASIN', 0, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'AMAZONASIN', 0, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'AMAZUKASIN', 0, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'MOBYGAMEID', 0, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'MGPLTFRMID', 0, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'S_TITLE', 1, NULL, 'N', 'Y', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'IMAGEURL', 2, NULL, 'N', 'N', 'N', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'SERIES', 6, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'VOLUME', 7, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAME_PLOT', 10, NULL, 'N', 'N', 'Y', 'Y' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAMEPBLSHR', 20, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAMESYSTEM', 30, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAMEGENRE', 40, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAMEREGION', 45, NULL, 'N', 'N', 'N', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAMEPBDATE', 47, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'NO_PLAYERS', 50, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'CONTROLLER', 60, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'GAMERATING', 65, NULL, 'N', 'N', 'Y', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'FEATURES', 70, NULL, 'N', 'N', 'N', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'COMMENTS', 70, NULL, 'N', 'N', 'N', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'S_STATUS', 253, NULL, 'N', 'N', 'N', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'S_STATCMNT', 254, NULL, 'N', 'N', 'N', 'N' ); INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, instance_attribute_ind, compulsory_ind, printable_ind, rss_ind ) VALUES ( 'GAME', 'S_DURATION', 255, NULL, 'N', 'N', 'N', 'N' );

#

Attribute Type Lookup (GAMESYSTEM)

# INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 1, 'PS1', 'Playstation', 'ps1.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 2, 'PS2', 'Playstation 2', 'ps2.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 3, 'PS3', 'Playstation 3', 'ps3.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 4, 'PSP', 'Playstation Portable', 'psp.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 4, 'PSVITA', 'PlayStation Vita', 'PS_Vita_logo.png', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 5, 'GAMEGEAR', 'Game Gear', 'gamegear.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 6, 'MASTER', 'Master System', 'mastersystem.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 7, 'GENESIS', 'Genesis', 'genesis.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 8, 'SATURN', 'Saturn', 'saturn.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 9, 'DREAMCAST', 'Dreamcast', 'dreamcast.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 10, 'GAMEBOY', 'Gameboy', 'gameboy.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 11, 'GAMEBOYCOLOR', 'Gameboy Color', 'gameboycolor.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 12, 'GAMEBOYADVANCE', 'Gameboy ADVANCE', 'gba.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 13, 'DS', 'DS', 'ds.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 14, 'NES', 'Nintendo Entertainment System', 'nes.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 15, 'SNES', 'Super Nintendo Entertainment System', 'snes.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 16, 'N64', 'Nintendo 64', 'n64.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 17, 'GAMECUBE', 'Game Cube', 'gamecube.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 18, 'WII', 'Wii', 'wii.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 19, 'XBOX', 'Xbox', 'xbox.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 20, 'XBOX360', 'Xbox 360', 'xbox360.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 21, 'TURBOGRAFX', 'TurboGrafx-16', 'turbografx.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 22, 'ATARI', 'Atari', 'atari.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 23, 'NEOGEO', 'NeoGeo', 'neogeo.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 24, 'MACCDROM', 'Macintosh', 'apple.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 25, 'DOS', 'DOS', 'dos.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 26, 'PCCDROM', 'Windows', 'windows.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 27, 'LINUX', 'Linux', 'linux.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 28, 'AMIGA', 'Amiga', 'Amiga.png', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 29, 'NEOGEOPOCKET', 'Neo Geo Pocket', 'NGPC-Logo.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 30, 'SEGACD', 'SEGA CD', 'Sega_CD_Logo.jpg', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 31, 'C64', 'C64', 'C64.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMESYSTEM', 32, 'NEOGEOCD', 'Neo-Geo CD', 'neogeocd.jpg', 'N' );

#

Attribute Type Lookup (GAMEGENRE)

# INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Action', '', '', 'Y' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Adventure', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Compilation', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Exploration', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Fantasy', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Fighting', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'FlightSimulation', 'Flight Simulation', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Futuristic', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Horror', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'MMO', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'MusicSimulation', 'Music Simulation', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Mystery', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Platform', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Puzzle', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Race', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'RPG', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Shooting', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Sports', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Stealth', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Strange', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Strategy', '', '', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEGENRE', NULL, 'Survival', '', '', 'N' );

#

Attribute Type Lookup (GAMEREGION)

# INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'AU', 'Australia', 'australia.png', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'CA', 'Canada', 'canada.png', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'EU_DE', 'Germany', 'german.gif', 'Y' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'EU_FR', 'France', 'french.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'EU_UK', 'England', 'english.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'JP', 'Japan', 'japanese.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMEREGION', 0, 'US', 'United States', 'usa.gif', 'N' );

#

Attribute Type Lookup (GAMERATING)

# INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 0, 'EC', 'Early Childhood', 'game/game_ec.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 1, 'K-A', 'Kids to Adults', 'game/game_ka.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 1, 'USK0', 'Ohne Altersbeschränkung', 'rating/USK0.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 2, 'E', 'Everyone', 'game/game_e.gif', 'Y' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 2, 'USK6', 'Ab 6 Jahren', 'rating/USK6.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 3, 'E10', 'Everyone 10+', 'game/game_e10.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 3, 'USK12', 'Ab 12 Jahren', 'rating/USK12.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 4, 'T', 'Teen', 'game/game_t.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 4, 'USK16', 'Ab 16 Jahren', 'rating/USK16.gif', 'Y' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 5, 'M', 'Mature', 'game/game_m.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 5, 'USK18', 'Nicht geeignet unter 18 Jahren', 'rating/USK18.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 6, 'AO', 'Adults Only', 'game/game_ao.gif', 'N' ); INSERT INTO s_attribute_type_lookup ( s_attribute_type, order_no, value, display, img, checked_ind ) VALUES ( 'GAMERATING', 7, 'RP', 'Rating Pending', 'game/game_rp.gif', 'N' );

pellcorp commented 10 years ago

This issue has been dealt with in issue #61. For some reason issue #60 was blocked. Anyway latest code in github has a fix. The height of the images was at fault.