Can you recommend a script

Tradding card repository

[Acternaweb]

I am not sure if this is the right thread, but hopefully someone can help me out. I am an avid collector if tradding cards and sports stuff. I want to be able to display it both online and be able to keep track of what I have. I am not selling any of my stuff. I have found several catalog scripts that seem to work but all have commerce involved. It is more of a pain to shut it off. Does anyone have a recommendation for a script. Or a source that I could use as a template?

Thanks

[bcolflesh]

Check this:

sourceforge.net/projects/mysportsdb/

[Acternaweb]

SWEET! that could do the trick. I uploaded it, but got the following error message:

Warning: Host 'h69-10-138-98.n-01.net' is not allowed to connect to this MySQL server in /home/httpd/vhosts/site/httpdocs/cards/cfg.php on line 25

Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/site/httpdocs/cards/cfg.php on line 27

Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/vhosts/site/httpdocs/cards/index.php on line 18

Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/site/httpdocs/cards/index.php on line 20

My host as a control panel where I access mysql but not sure how to set it up. Any advice?

[edited by: jatar_k at 6:39 pm (utc) on Dec. 12, 2003]
[edit reason] generalized [/edit]

[bcolflesh]

I've never used it, but I'm sure you'll have to edit the config file to include your MySQL username and password and other specific server info.

[Acternaweb]

I did that, but stil get

Warning: Access denied for user: 'apache@localhost' (Using password: NO) in /home/httpd/vhosts/site/httpdocs/cards/index.php on line 18

Warning: Supplied argument is not a valid MySQL-Link resource in /home/httpd/vhosts/site/httpdocs/cards/index.php on line 20

However, in config that is neither my username or password. I don't see either anywhere in the script. UGH

[edited by: jatar_k at 6:40 pm (utc) on Dec. 12, 2003]
[edit reason] generalized [/edit]

[Timotheos]

Hi Acternaweb,

Just a hint but I think you'll want to exclude your url info in these posts.

Have you set up the mySQL database? Usually scripts like these come with a text file with a .sql extension that help set up the database.

[Acternaweb]

Ahh I take it someone could get my site that way?

I found a doc called mysportsdb.sql and my site has a mysql gui interface but the text in the doesn't match the "wizard"

I can create the database but the issues is the username and password.

[Timotheos]

I found a doc called mysportsdb.sql and my site has a mysql gui interface but the text in the doesn't match the "wizard"

I'm not sure what you mean by the text doesn't match the "wizard". I use the oh so popular phpMyAdmin. Is this what you're using?

Mysportsdb.sql is the file you want. It has a bunch of sql queries which will build the tables for your database to work with the script. In phpMyAdmin once you create the database theirs a tab that says "SQL". In there is a place you can load that sql file, run it and whalla you've got a database.

PhpMyAdmin also has a section to administer priviledges which is where you would set up the users and what they can do.

[Acternaweb]

THanks I figured out how to "upload" the file but do not see how to configure permission.. I added myself as a user but was not allowed to add apache and No

The host uses phpadmin which is how I uploaed the file. Appreciate your help, this is more of a learning than the dumb course I took