RF Generation Message Board

Well, to say all us of on staff have not been looking forward to this day would be a lie. After many months of preparation, and hundreds of hours of programming, the fruits of our labor have finally paid off. See, our site was originally operating a file-based database, and fortunately or unfortunately, however you look at it, our traffic got a little bit too big for that form of database, and as such, a search for a new database system began. It was quickly decided upon that the popular open source database known as mySQL would be the best route to take, so back in May we decided to do a switch. The first thing that was to go was our old forum, YaBB. We love YaBB, but it places a lot of load on the server, and is file based. As such, we tested and subsequently launched SMF in July. SMF is essentially the mySQL and PHP version of YaBB, so I hope most of you didn't hate it that much. In fact, since it is my labor of love, I hope you all enjoy it's functionality as much as I do.

Well, today marks another major milestone in the progression, see, today is the first day that all of our databases run in the mySQL system. Collections, Games, Hardware, forums, they all run through the mySQL server. Hopefully, when the mySQL server is running, this system will allow for reliability that we simply did not see earlier.

What does this mean for you guys? Well, first, you all can use the new submission scripts for hardware and games. These scripts allow you pretty much the same functionality that the staff gets, only your submissions are reviewed. I'm sure you all will enjoy the fact that you know can submit additions and extra media, rather than making a post. So yeah, please do that. One other thing, the hardware system is final apparently. You now can add hardware entries to your collection.

There will be bugs, and these bugs will be quashed throughout the week. Updated anything currently does not work, and we will be fixing that in the near future. We are also aware of an issue where page credits for games sometimes did not transfer correctly. If you see any bugs, please let Eddie (St0rmTK421) or I know. We'd appreciate it, as we really would like to get any and all bugs quashed as quick as possible.

This is a major milestone, and we hope you enjoy the occasion as much as we do. As always though stay tuned, there is more to follow when you keep it tuned to channel three.

*claps* :banana: :banana: :banana: :banana: :freakboy: :freakboy: :freakboy: :king: :king: :party: :party:

Good job dudes.

Awesome work guys.

Only bugs i have noticed thus far have to do with adding hardware to your collection.

If you do a more broad search and get more than 1 page of results the page is blank when you try to go to page 2.

Also it defaults the display alphabetically, if you try to change it to display by system or something else the page is also blank.


So glad that the changes have been implemented. Thanks for all your hardwork Dave and Eddie

Awesome work guys, hats off to you for your hard work, this site just keeps getting better all the time!
:king:  :beer:

Great work fellas!

Awesome job Dave & Eddie!!  Must feel good to finally get the product of your labor out in the open ;)

Great work guys!!!!!

Great job guys!  There is still a problem, though.  When I click on Add Games it goes to this screen:
Hey, shaggy, you have 0 new message(s).

If this is your first time using the RF Generation collection software, please take a few moments to read through the FAQ.


 
 
 
My Collection Edit Collection Add Games Manage Folders My Profile Search Collection All Collections FAQ Logout 
 
 
 
Please use the Search Page to add games.
Back
 

I found something else.  I assume now all the blanks are now 0's because I noticed this while searching my collection.  I didn't know if this was supposed to happen.  All in the drop down menu it says I have 421 NES games but when I choose it I have 407 NES games which is the correct number.  I don't know this is only for NES games or all systems with this discrepancy.

Do you have any NES games on your wish list or for sale list?

For me it says I have 407 NES games but if you add what I have listed in my collection and what I have listed in my orphans folder you get 407.

Yea, I have games in my Wishlist and games in my Orphan folder which adds to 421.  So these is something else that needs to be fixed back to the way it was.

The add games page is causing problems, so please use the main search in the meantime.

The problem with the number of games for each console has been fixed.

As for the numbers, if you didn't have anything entered for any of the fields, they were set to a default of zero.  I'll see if I can find a way to switch it back, but it seems unlikely since reuploading the files seems to place a heavy load on our SQL server.  I can remove the default value for the tables and allow blank spaces to be entered again, but for the ones that are already there you probably will have to set them by hand.  Note that only blank values were set to zero, anyone who filled out their fields when adding games should still have those values correct.

I'm not sure if this falls into the same category or not but the "All Collections" page is showing a discrepancy. When the hardware database went up i added Xbox 360 hardware listing to my list making 740, then removed it a few minutes later. the "All Collections" page still shows 740 but when you click my name and go into it, it shows the proper 739.  :P

I'm getting nothing when I click My Collection or Search all collections...

So far all of the problems found have been adressed by others.  Only question I have is about missing games.  It's great that we now have the ability to submit the titles ourselves, but how will users be notified when the various systems/games have been added?  Will the member be required to do a day to day check to see if it's been added?  Will there be a thread listing all titles that have recently been added?  A PM to each person saying their entry has been added?

Right now there is nothing that will tell you how many submissions you made are yet to be reviewed, and it will not show you approved or rejected submissions yet. It wouldn't be too difficult to write a log to see your submissions or approved submissions; the most difficult part of that would be keeping the log from being too large. I'll look into that once our games database goes back online, which is why when you look at your collection or search collections you see nothing.

after we add a game to the submit info link could some one send a PM to tel us its added

Well, the thing about sending a PM everytime a submission is approved is that we often approve lots of submissions at once. So, I don't want to spam anyone's PM box with 60 PMs all at once. In addition, some people have it set so that they recieve an email when they are PMed.

Right now, I am working on a submissions log of sorts. It will show you all your submissions that still need to be approved, and it'll also show you all your approved submissions. Expect that in the next week or so.

I don't know if this has been found or brought up yet but when adding games to your collection all of the Hardware that has been submitted for system also shows up.  I don't know if it is likewise while adding hardware to you collection that the software shows up.  On another note I didn't know you could add hardware!  Good job guys!

Did you have the dropdown labeled "Type" at "Software"?  That should be the default when you click "Add Games" but when you click "Advanced Search" it defaults to --All types-- which will show hardware and sofware (games).

Yes, what bum-man said.  The searches all work depending on what you have the type set for.  The defaults can be easily changed if they are not set properly, I really wasn't thinking about the defaults when I was changing it.  Was more worried about getting it working in the first place :)

I'm positive I did.  I had it on Software.  It was the first thing I checked but I will try again to see if I was wrong.

just noticed that that xbox 360 hardware problem where the removed listing for the hardware still adds to my total is still showing up, 791 games listed, but the "all collections" page says 792 and the "all folders" under my profile says 792 as well. :P

When a game is removed, all the collections that have that game need to be modified as well.  Whoever did the deleting forgot to do this.  Do you remember which entry was deleted?

Sorry, what i meant was after i removed the listing for the xbox 360 hardware out of my collection, that's when the problem started. at that time i had 739 games and the 360 made 740. i removed the xbox 360 hardware listing about 10 minutes later, some of the numbers showed 739 as they should others showed 740 still. It shows up sporatically from time to time not sure what causes it. Sorry for the confusion :P