Re: [SWCollect] CURIOUS Guide
Hugh, Very nice, and remarkably fast. Sorting and searching both worked great. I did find one glitch, though: If I: 1. Search on a keyword2. Then hit my browser's back button from the results page3. Then click the scroll bar on the left side (in the previous page) ...Instead of scrolling down it takes me back to the same search results, and I get the following PHP error at the top of the page: Warning: mysql_data_seek(): Offset 25 is invalid for MySQL result index 7 (or the query data is unbuffered) in /home/gotcha/cgi-bin/PHP/datalist.php on line 648 Other than that, looks great! Adventure International list is still in-progress. Going is slow because some platform and release date info is hard to track down, and there are a HUGE number of package variants. For the time being I'm going to confine myself to adventure only, since I don't have a complete list of their arcade titles. - Original Message - From: Hugh Falk To: [EMAIL PROTECTED] Sent: Thursday, April 22, 2004 12:06 AM Subject: [SWCollect] CURIOUS Guide After weeks of frustration and experimentation, I finally have a DB solution for the CUROIUS Guide up and running. You can get to it from my site (http://www.classicgaming.com/gotcha/) through the menu, but here is a direct link to the DB page: http://dynamic3.gamespy.com/~gotcha/PHP/curious_view.php. There are some nice features like sorting, filtering and a printable view, but there is still some more functionality I want to add (like alphabetical tabs). For now I think it is very usable. Id really appreciate some feedback specifically if it works since so many people had problems with the last version. Keep in mind that this is only the beginning. There are likely many errors and obviously there are many many games/box variations still to add. Thanks, Hugh
Re: [SWCollect] CURIOUS Guide
Wow, very nice, Hugh! On a first glance I found one problem: When I click on one of the sublinks (year, title, etc.) I get a 404. Like here, http://dynamic3.gamespy.com/~gotcha/PHP/1082653752 Marco Hugh Falk schrieb: After weeks of frustration and experimentation, I finally have a DB solution for the CUROIUS Guide up and running. You can get to it from my site (http://www.classicgaming.com/gotcha/) through the menu, but here is a direct link to the DB page: http://dynamic3.gamespy.com/~gotcha/PHP/curious_view.php. There are some nice features like sorting, filtering and a printable view, but there is still some more functionality I want to add (like alphabetical tabs). For now I think it is very usable. Id really appreciate some feedback specifically if it works since so many people had problems with the last version. Keep in mind that this is only the beginning. There are likely many errors and obviously there are many many games/box variations still to add. Thanks, Hugh -- This message was sent to you because you are currently subscribed to the swcollect mailing list. To unsubscribe, send mail to [EMAIL PROTECTED] with a subject of 'unsubscribe swcollect' Archives are available at: http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: [SWCollect] CURIOUS Guide
Very nice. A few things: - Searching works well (but what does the icon w/the X-ed out glasses do)? I saw no visible results. - All the links (year, publisher, title) all lead to the same destination for a given title. - The scrollbar down the left gives erratic results - Not sure if everyone knows that the percent sign is the wildcard for database like queries. Perhaps imply it at the end (or both ends) if not specified? Other than that, I dig it. Now for that dynamic feedback model to adjust the rarity ratings... How much work (in hours) did it take to get to this point? On Apr 22, 2004, at 1:06 AM, Hugh Falk wrote: x-tad-biggerAfter weeks of frustration and experimentation, I finally have a DB solution for the CUROIUS Guide up and running. You can get to it from my site (/x-tad-biggerx-tad-biggerhttp://www.classicgaming.com/gotcha//x-tad-biggerx-tad-bigger) through the menu, but here is a direct link to the DB page: /x-tad-biggerx-tad-biggerhttp://dynamic3.gamespy.com/~gotcha/PHP/curious_view.php/x-tad-biggerx-tad-bigger./x-tad-bigger x-tad-bigger /x-tad-bigger x-tad-biggerThere are some nice features like sorting, filtering and a printable view, but there is still some more functionality I want to add (like alphabetical tabs). For now I think it is very usable./x-tad-bigger x-tad-bigger/x-tad-bigger x-tad-biggerId really appreciate some feedbackspecifically if it works since so many people had problems with the last version./x-tad-bigger x-tad-bigger/x-tad-bigger x-tad-biggerKeep in mind that this is only the beginning. There are likely many errors and obviously there are many many games/box variations still to add./x-tad-bigger x-tad-bigger/x-tad-bigger x-tad-biggerThanks,/x-tad-bigger x-tad-biggerHugh/x-tad-bigger x-tad-bigger/x-tad-bigger
Re: [SWCollect] CURIOUS Guide
Thanks for the feedback, Dan... - Searching works well (but what does the icon w/the X-ed out glasses do)? I saw no visible results. [HF] There is actually hover-help for the buttons. Just mouse over it. That button clears any filters you have applied. - All the links (year, publisher, title) all lead to the same destination for a given title. [HF] It may seem that way when you mouse over the links, but clicking those links won't take you anywhere. Instead, it selects that row and puts the game in the Detail View at the bottom. If you can't see it, scroll down. It's useful for extra long titles, publishers, etc. Let me know if it isn't working for you please. - The scrollbar down the left gives erratic results [HF] Actually, just hit the up or down arrow (at the ends of the scroll bar) to move one page at a time (25 games per page). Click on the bar itself to go to that location in the entire list. Seems to be working right. - Not sure if everyone knows that the percent sign is the wildcard for database like queries. Perhaps imply it at the end (or both ends) if not specified? [HF] Very good point. I should at least put instructions. Other than that, I dig it. Now for that dynamic feedback model to adjust the rarity ratings... How much work (in hours) did it take to get to this point? [HF] Probably about 12 hours of actual workand about 2 weeks of waiting on gamespy (my host) to make changes or answer questions. Also, I originally tried to use MS SQL with ASP instead of MySQL with PHP and had to scrap and start over. Now that I know what I'm doing and am set up on Gamespy, I could do the whole thing in an hour or so. It helps that I'm using a PHP generation utility as the basis for my web page. It does a lot of the PHP work for me. Hugh -Original Message- From: Dan Chisarick [EMAIL PROTECTED] Sent: Apr 22, 2004 6:35 PM To: [EMAIL PROTECTED] Subject: Re: [SWCollect] CURIOUS Guide Very nice. A few things: - Searching works well (but what does the icon w/the X-ed out glasses do)? I saw no visible results. - All the links (year, publisher, title) all lead to the same destination for a given title. - The scrollbar down the left gives erratic results - Not sure if everyone knows that the percent sign is the wildcard for database like queries. Perhaps imply it at the end (or both ends) if not specified? Other than that, I dig it. Now for that dynamic feedback model to adjust the rarity ratings... How much work (in hours) did it take to get to this point? On Apr 22, 2004, at 1:06 AM, Hugh Falk wrote: After weeks of frustration and experimentation, I finally have a DB solution for the CUROIUS Guide up and running. You can get to it from my site (http://www.classicgaming.com/gotcha/) through the menu, but here is a direct link to the DB page: http://dynamic3.gamespy.com/~gotcha/PHP/curious_view.php. There are some nice features like sorting, filtering and a printable view, but there is still some more functionality I want to add (like alphabetical tabs). For now I think it is very usable. I?d really appreciate some feedback?specifically if it works since so many people had problems with the last version. Keep in mind that this is only the beginning. There are likely many errors and obviously there are many many games/box variations still to add. Thanks, Hugh -- This message was sent to you because you are currently subscribed to the swcollect mailing list. To unsubscribe, send mail to [EMAIL PROTECTED] with a subject of 'unsubscribe swcollect' Archives are available at: http://www.mail-archive.com/[EMAIL PROTECTED]/
Re: [SWCollect] CURIOUS Guide
- I don't get hover-over help. Tried with IE, Mozilla and Safari for OS X. - Links lead to the same destination: You said what I meant. I just worded it badly. - Hmmm, scrollbar seems happy now. Either browser glitch or PEBKAC On Apr 22, 2004, at 9:44 PM, [EMAIL PROTECTED] wrote: Thanks for the feedback, Dan... - Searching works well (but what does the icon w/the X-ed out glasses do)? I saw no visible results. [HF] There is actually hover-help for the buttons. Just mouse over it. That button clears any filters you have applied. - All the links (year, publisher, title) all lead to the same destination for a given title. [HF] It may seem that way when you mouse over the links, but clicking those links won't take you anywhere. Instead, it selects that row and puts the game in the Detail View at the bottom. If you can't see it, scroll down. It's useful for extra long titles, publishers, etc. Let me know if it isn't working for you please. - The scrollbar down the left gives erratic results [HF] Actually, just hit the up or down arrow (at the ends of the scroll bar) to move one page at a time (25 games per page). Click on the bar itself to go to that location in the entire list. Seems to be working right. - Not sure if everyone knows that the percent sign is the wildcard for database like queries. Perhaps imply it at the end (or both ends) if not specified? [HF] Very good point. I should at least put instructions. Other than that, I dig it. Now for that dynamic feedback model to adjust the rarity ratings... How much work (in hours) did it take to get to this point? [HF] Probably about 12 hours of actual workand about 2 weeks of waiting on gamespy (my host) to make changes or answer questions. Also, I originally tried to use MS SQL with ASP instead of MySQL with PHP and had to scrap and start over. Now that I know what I'm doing and am set up on Gamespy, I could do the whole thing in an hour or so. It helps that I'm using a PHP generation utility as the basis for my web page. It does a lot of the PHP work for me. Hugh -Original Message- From: Dan Chisarick [EMAIL PROTECTED] Sent: Apr 22, 2004 6:35 PM To: [EMAIL PROTECTED] Subject: Re: [SWCollect] CURIOUS Guide Very nice. A few things: - Searching works well (but what does the icon w/the X-ed out glasses do)? I saw no visible results. - All the links (year, publisher, title) all lead to the same destination for a given title. - The scrollbar down the left gives erratic results - Not sure if everyone knows that the percent sign is the wildcard for database like queries. Perhaps imply it at the end (or both ends) if not specified? Other than that, I dig it. Now for that dynamic feedback model to adjust the rarity ratings... How much work (in hours) did it take to get to this point? On Apr 22, 2004, at 1:06 AM, Hugh Falk wrote: After weeks of frustration and experimentation, I finally have a DB solution for the CUROIUS Guide up and running. You can get to it from my site (http://www.classicgaming.com/gotcha/) through the menu, but here is a direct link to the DB page: http://dynamic3.gamespy.com/~gotcha/PHP/curious_view.php. There are some nice features like sorting, filtering and a printable view, but there is still some more functionality I want to add (like alphabetical tabs). For now I think it is very usable. I?d really appreciate some feedback?specifically if it works since so many people had problems with the last version. Keep in mind that this is only the beginning. There are likely many errors and obviously there are many many games/box variations still to add. Thanks, Hugh -- This message was sent to you because you are currently subscribed to the swcollect mailing list. To unsubscribe, send mail to [EMAIL PROTECTED] with a subject of 'unsubscribe swcollect' Archives are available at: http://www.mail-archive.com/[EMAIL PROTECTED]/ -- This message was sent to you because you are currently subscribed to the swcollect mailing list. To unsubscribe, send mail to [EMAIL PROTECTED] with a subject of 'unsubscribe swcollect' Archives are available at: http://www.mail-archive.com/[EMAIL PROTECTED]/