best way to MANAGE games collection?

[Ratso]

GameDex does.

PM'd!

[elkatas]

So, without further ado, here are short instructions for installation:

0. Download Gamedex.zip from here (sorry, couldn't get better place)
1. Expand the zip. Zip should contain SQL.txt and folder named "backlog".
2. First we are going to create database for Gamedex to use. Open SQL.txt.
3a. If you are using front-end to access MySQL, just create new database, and use SQL.txts code to create tables and insert few entries into tables. After you have finished creating tables, you should now have six tables.
3b. If you are using Telnet to access MySQL, input following commands inside MySQL client:

01. CREATE DATABASE xxxx; (This creates database)
02. USE DATABASE xxxx; (switches into created database)
03. Paste everything from SQL.txt into client. Text is already formatted in way that most telnet programs understand.
04. SHOW TABLES; (Shows how many tables you have in current database. If everything went right, you should now have six tables).

4. Database is ready for use.
5. Move "backlog" folder's contents into folder where you want Gamedex to be accessed on the server.
6. After this is done, open connect_database.php from includes/ subfolder by using text editor (notepad, pico, etc.).
7. You should see following two rows:

$RES_DB_Connection = mysql_connect("localhost", "root", "salasana") or die("Blarga");
mysql_select_db("game", $RES_DB_Connection) or die("Blarga");

8. Change "root" with username that you are using to access MySQL. Change "salasana" with your MySQL password.
9. Change mysql_select_db's "game" with name of DB where Gamedex's tables are located.
10. That's it. Everything should work now.

If you don't understand something on the list, please tell me and I will explain it in more detail.

SOME THINGS YOU BETTER KNOW ABOUT THIS APPLICATION:

- Unfortunately, I couldn't find my final beta version of GameDex, which means you are using beta version that is missing PDF-reporting.
- Furthermore, in some places application doesn't say anything at all if you succeeded in your task. One good example is creation of new account.
- Account creation doesn't have email verification on place. This means anyone can come and create account to your GameDex.
- Account removal is missing.
- Core is completely unoptimized. It is secure, but has some primitive solutions (this is really old application).
- MySQL queries are also completely unoptimized.

[thebuddahman]

http://i203.photobucket.com/albums/aa23/elkatas/listgames.jpg

LOL @ 'Wind Wanker'!!

I use Excel for my N64 games but I do feel like I too need something to allow me to keep track of everything I've got. Easily spirals out of control and I sometimes discover stuff I forgot about.

[charlesr]

You need to change "localhost" to the name of your database server too (unless running it locally).

I tried using this but it wouldn't let me login after creating an account.

[elkatas]

Hmh, do following.... open default.php. Find row error_reporting(0); and put comment marks on the front of it, disabling it:

// error_reporting(0);

Then try creating account again.

[elkatas]

Great news... pal of mine promised to host GameDex for public betatesting. Application can be accessed here:

http://zirkonium.net/backlog/

[charlesr]

Hmh, do following.... open default.php. Find row error_reporting(0); and put comment marks on the front of it, disabling it:

// error_reporting(0);

Then try creating account again.

Sorry, I've already removed the version I spent my morning installing and hosting for you, after you said the GameDex project was cancelled and you were never posting at NTSC-uk again.

However I see that it's not been cancelled and you are still posting.

[John Beaulieu]

input verification is broken and password not complex enough error is stopping me from trying this out

[elkatas]

input verification is broken and password not complex enough error is stopping me from trying this out

Input verification isn't broken, but it is now evident that font / background is way too hard to read correctly. I will change the font soon enough. And yes, program requires that password is 8 characters long, has both numbers and big / small letters. I will change this too.

[charlesr]

Ah, think that's what I was doing wrong. Too simple a password.

[John Beaulieu]

My enigma machine is in my other pants (which are at the cleaners) so my password was also too simplistic .....

[elkatas]

New address, few bugfixes:

http://zirkonium.net/backlog/