Retro Uprising
RU Games Discussions for just Retro Uprising games.
Donation Goal
Goal amount: 5000 USD, Received: 489 USD (10%)
Donate Now
When we reach the current donation goal all software on Retro Uprising will be replaced with a new superior method for playing games online that will support all browsers, play many more games and consoles and fix errors in existing games. This will be a massive site upgrade. The largest in our history. Please help us reach our goal as soon as possible.

Retro Uprising relies on donations from users like you! List of Donors

Register to enable more features such as high score recording.


Go Back   Retro Uprising > Video Games > RU Games

Reply
 
Thread Tools Search this Thread Display Modes
Old 04-08-2012, 07:09 PM   #1 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Every Single NES/FDS Game

I started working on a list a for a while now, which is stored in a database, and generated out with PHP. It's still not finished, but i thought to upload it, to see what you guys think.

Every game has the following info: title, aka, description, 2 screenshots (title screen, in-game), year (release), type (genre) and 2 buttons, one to mark as mastered and the other one to mark if it's on ru or not.

The list also features a powerful search, where you need to input the 'where' part from a mysql query.

At the moment there are 1302 games, from which 937 are on the site.

I hope, that the list can help in organizing the nes games and add more in a clean way, without adding duplicates or cheap sprite hacks.
The list is also useful for finding new games to play, or searching for games without knowing it's title.

server2go.zip

---------- Post added at 06:09 PM ---------- Previous post was at 04:40 PM ----------

html version, which is only 17,5mb
My SignatureDisplay Signature Reply With Quote
Old 04-08-2012, 07:50 PM   #2 (permalink)
stevencassidy13's Avatar
Regular Poster
11,092 posts
stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!
View Stats
Level: 60
Points: 66,551, Level: 60 Points: 66,551, Level: 60 Points: 66,551, Level: 60
Level up: 62%
Level up: 62%, 3,899 Points needed Level up: 62% Level up: 62%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

Cool good work. You realise you got a bunch of games that are recent listed?
My SignatureDisplay Signature Reply With Quote
kong on Bronies:

"Of the 75% that are straight I would bet at least 10% would rather have a cheeseburger than a girlfriend."
Old 04-08-2012, 08:27 PM   #3 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

Quote:
Originally Posted by stevencassidy13 View Post
Cool good work. You realise you got a bunch of games that are recent listed?
what do you mean, by that?
My SignatureDisplay Signature Reply With Quote
Old 04-08-2012, 08:52 PM   #4 (permalink)
stevencassidy13's Avatar
Regular Poster
11,092 posts
stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!
View Stats
Level: 60
Points: 66,551, Level: 60 Points: 66,551, Level: 60 Points: 66,551, Level: 60
Level up: 62%
Level up: 62%, 3,899 Points needed Level up: 62% Level up: 62%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

There are some games that are homebrew that are as new as 2012 listed.
My SignatureDisplay Signature Reply With Quote
kong on Bronies:

"Of the 75% that are straight I would bet at least 10% would rather have a cheeseburger than a girlfriend."
Old 04-08-2012, 09:43 PM   #5 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

Quote:
Originally Posted by stevencassidy13 View Post
There are some games that are homebrew that are as new as 2012 listed.
yes, i know, that's the point, to add all of them...
Try using commas, the sentences will make more sense to anyone who reads it
My SignatureDisplay Signature Reply With Quote
Old 04-08-2012, 09:52 PM   #6 (permalink)
stevencassidy13's Avatar
Regular Poster
11,092 posts
stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!stevencassidy13 has earned the ear of the admin. Watch yourself!
View Stats
Level: 60
Points: 66,551, Level: 60 Points: 66,551, Level: 60 Points: 66,551, Level: 60
Level up: 62%
Level up: 62%, 3,899 Points needed Level up: 62% Level up: 62%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

Oh ok, I'm just not sure if they qaulify for R.U. or not.
My SignatureDisplay Signature Reply With Quote
kong on Bronies:

"Of the 75% that are straight I would bet at least 10% would rather have a cheeseburger than a girlfriend."
Old 04-09-2012, 12:34 AM   #7 (permalink)
CrispyChicken's Avatar
Extra Chrispy
6,725 posts
CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!CrispyChicken has earned the ear of the admin. Watch yourself!
View Stats
Level: 43
Points: 31,106, Level: 43 Points: 31,106, Level: 43 Points: 31,106, Level: 43
Level up: 4%
Level up: 4%, 1,344 Points needed Level up: 4% Level up: 4%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

Quote:
Originally Posted by Incubator View Post
Try using commas, the sentences will make more sense to anyone who reads it
How would that help in that sentence at all? lol
My SignatureDisplay Signature Reply With Quote

"My mind is my weapon. My brother has his sword, King Robert has his warhammer and I have my mind... and a mind needs books as a sword needs a whetstone if it is to keep its edge. That’s why I read so much, Jon Snow."

Old 07-13-2012, 03:31 PM   #8 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

After all that time, the list is pretty much complete.
There's a total of 1869 games, from what 1039 are on the site, excluding duplicates and very similar hacks.

The goal of the list was to discover rare gems, and put them in a list with previews to easily recognize/view them. It's true that there are lots of games that are unworthy of tryout, but in the same time i discovered many great games.

The list is pretty unique, there shouldn't be too many duplicate inside the list, let me know if you fnd any game that or listed twice under different releases...

Download (27 MB)
I recommend using chrome, because it opens it 10x faster.
My SignatureDisplay Signature Reply With Quote
Old 07-13-2012, 08:21 PM   #9 (permalink)
fungusman's Avatar
Donor
597 posts
fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!
View Stats
Level: 22
Points: 6,528, Level: 22 Points: 6,528, Level: 22 Points: 6,528, Level: 22
Level up: 10%
Level up: 10%, 722 Points needed Level up: 10% Level up: 10%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
 

   
Re: Every Single NES/FDS Game

Probably a better idea to release the .sql file. Chances are if you know how to launch that stuff you have your own server/servers anyway.

export the db
Code:
mysqldump -u"username" -p"password" databaseName > dbcopy.sql
then import
Code:
mysql -u"username" -p"password" databaseName < dbcopy.sql
Also, use XAMPP instead ; )

Last edited by fungusman; 07-13-2012 at 08:26 PM..
My SignatureDisplay Signature Reply With Quote
Old 07-14-2012, 01:26 AM   #10 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

Quote:
Originally Posted by fungusman View Post
Probably a better idea to release the .sql file. Chances are if you know how to launch that stuff you have your own server/servers anyway.

export the db
Code:
mysqldump -u"username" -p"password" databaseName > dbcopy.sql
then import
Code:
mysql -u"username" -p"password" databaseName < dbcopy.sql
Alright, here are the php files and the sql database:
Download Source

Quote:
Also, use XAMPP instead ; )
What do you mean? I am using XAMPP :P

Also, let me know if some one knows a good site where are lots of details about most of these games, so i can make a script to grab all the data and inject it into the list.

Last edited by Incubator; 07-14-2012 at 01:29 AM..
My SignatureDisplay Signature Reply With Quote
Old 07-14-2012, 05:26 PM   #11 (permalink)
fungusman's Avatar
Donor
597 posts
fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!
View Stats
Level: 22
Points: 6,528, Level: 22 Points: 6,528, Level: 22 Points: 6,528, Level: 22
Level up: 10%
Level up: 10%, 722 Points needed Level up: 10% Level up: 10%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
 

   
Re: Every Single NES/FDS Game

nice.

Do you want me to throw this on some webspace for you ?
My SignatureDisplay Signature Reply With Quote
Old 07-14-2012, 07:13 PM   #12 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

Quote:
Originally Posted by fungusman View Post
nice.

Do you want me to throw this on some webspace for you ?
You can put it up if you want, but it wasn't meant for that, as there's a textfield on the index page where everyone's able to inject mysql code, therefore anyone can do what they want with the database.
And it might also be slow...
My SignatureDisplay Signature Reply With Quote
Old 07-14-2012, 07:40 PM   #13 (permalink)
fungusman's Avatar
Donor
597 posts
fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!
View Stats
Level: 22
Points: 6,528, Level: 22 Points: 6,528, Level: 22 Points: 6,528, Level: 22
Level up: 10%
Level up: 10%, 722 Points needed Level up: 10% Level up: 10%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
 

   
Re: Every Single NES/FDS Game

lol
Code:
mysql_real_eascape_string($text);
Theres also these things called passwords, pretty cool at keeping people out of places you don't want them in

Also, no website is hack proof believe me. That's a badge you must earn.

Last edited by fungusman; 07-14-2012 at 07:45 PM..
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 03:26 AM   #14 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

Quote:
Originally Posted by fungusman View Post
lol
Code:
mysql_real_eascape_string($text);
Theres also these things called passwords, pretty cool at keeping people out of places you don't want them in

Also, no website is hack proof believe me. That's a badge you must earn.
:P mysql_real_escape_string() is not the solution, as it was planned to be able to add mysql code inside it, for advanced searching, i didn't want to spend time on making it safe for publishing, i wanted to make it fast and advanced, so i just made it possible to insert mysql code in it. Also, passwords wouldn't be the real solution, because people can do things by mistake as well.

The best solution would be to secure the search and create registration.login, where everyone would have a copy of the list, and could add remove, edit what they want without messing up the original, but for that i don't have the time now.

But you can also upload only the html version.

Last edited by Incubator; 07-15-2012 at 03:38 AM..
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 05:15 AM   #15 (permalink)
fungusman's Avatar
Donor
597 posts
fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!
View Stats
Level: 22
Points: 6,528, Level: 22 Points: 6,528, Level: 22 Points: 6,528, Level: 22
Level up: 10%
Level up: 10%, 722 Points needed Level up: 10% Level up: 10%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
 

   
Re: Every Single NES/FDS Game

mysql_escape_string escapes sql injection.
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 08:51 AM   #16 (permalink)
Kong's Avatar
Donor
Administrator
12,326 posts
Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!
View Stats
Level: 64
Points: 133,715, Level: 64 Points: 133,715, Level: 64 Points: 133,715, Level: 64
Level up: 18%
Level up: 18%, 16,735 Points needed Level up: 18% Level up: 18%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

mysql_escape_string will secure the code but it will also break it.

Example, to search for Mario you wouldn't type mario, you would type
SELECT * FROM games WHERE title LIKE "%Mario%"

If you escaped that then it wouldn't search for anything.
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 02:30 PM   #17 (permalink)
fungusman's Avatar
Donor
597 posts
fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!
View Stats
Level: 22
Points: 6,528, Level: 22 Points: 6,528, Level: 22 Points: 6,528, Level: 22
Level up: 10%
Level up: 10%, 722 Points needed Level up: 10% Level up: 10%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
 

   
Re: Every Single NES/FDS Game



Code:
$text = mysql_real_escape_string($_POST["mario"]);
$sql = "SELECT * FROM games WHERE title LIKE '%".$text."%'";
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 02:55 PM   #18 (permalink)
Kong's Avatar
Donor
Administrator
12,326 posts
Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!
View Stats
Level: 64
Points: 133,715, Level: 64 Points: 133,715, Level: 64 Points: 133,715, Level: 64
Level up: 18%
Level up: 18%, 16,735 Points needed Level up: 18% Level up: 18%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

He designed it for personal use and it to take any sql.

Example the search could also be
UPDATE gamelist SET beat = 1
or
SELECT * FROM gamelist WHERE beat = 1

It is fixable, just you can't slap mysql_real_escape_string on it and be done is the only point.
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 03:11 PM   #19 (permalink)
fungusman's Avatar
Donor
597 posts
fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!fungusman has earned the ear of the admin. Watch yourself!
View Stats
Level: 22
Points: 6,528, Level: 22 Points: 6,528, Level: 22 Points: 6,528, Level: 22
Level up: 10%
Level up: 10%, 722 Points needed Level up: 10% Level up: 10%
Activity: 3%
Activity: 3% Activity: 3% Activity: 3%
 

   
Re: Every Single NES/FDS Game

Ah ok, so he has a field somewhere that takes raw sql queries gotcha.
My SignatureDisplay Signature Reply With Quote
Old 07-15-2012, 05:04 PM   #20 (permalink)
Kong's Avatar
Donor
Administrator
12,326 posts
Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!Kong has earned the ear of the admin. Watch yourself!
View Stats
Level: 64
Points: 133,715, Level: 64 Points: 133,715, Level: 64 Points: 133,715, Level: 64
Level up: 18%
Level up: 18%, 16,735 Points needed Level up: 18% Level up: 18%
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 

   
Re: Every Single NES/FDS Game

Right. Because he wanted to do more than just search and was planning on being the only user.
My SignatureDisplay Signature Reply With Quote
Old 07-16-2012, 08:55 AM   #21 (permalink)
Incubator's Avatar
Donor
440 posts
Incubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their headIncubator has a faint yellow circle forming above their head
View Stats
Level: 34
Points: 17,969, Level: 34 Points: 17,969, Level: 34 Points: 17,969, Level: 34
Level up: 29%
Level up: 29%, 781 Points needed Level up: 29% Level up: 29%
Activity: 27%
Activity: 27% Activity: 27% Activity: 27%
 

   
Re: Every Single NES/FDS Game

^ that's all true
but you can find the table data in the sql file and use the search bar by putting in for ex.

title LIKE '%Mario%'
(which would find all games with mario)

released > 1990
(which would find all games released from 1991)

on_ru = 0
(games that aren't on ru)

this is what you have to insert to make basic searches, only the part after the WHERE, as it is written before the textfield

I designed this way, because i wanted to create a very powerful search function as fast as possible while ignoring security, so this seemed a good solution.
I know this isn't a normal solution for public usage, but if requests come up, i will take my time to make it safe for public usage

Last edited by Incubator; 07-16-2012 at 09:00 AM..
My SignatureDisplay Signature Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nes Game Title NostalgicNinja83 Name That Game 12 03-17-2012 05:34 PM
Another nes/famicom game Incubator Name That Game 8 09-01-2011 06:14 PM
game uploaded twice under wrong name (NES) Incubator RU Games 0 04-29-2011 01:51 PM
Can't remember nes game Incubator Name That Game 4 04-27-2011 07:15 PM
Help with an NES game name? BigChunk76 Chat 8 07-08-2007 03:34 PM


All times are GMT -5. The time now is 11:41 PM.

vBulletin® ©2000 - 2017, Jelsoft Enterprises Ltd. » vBadvanced CMPS