I want to know if I can make it so the database will have three areas: albums, artists, and sounds...
i want it so that only specific people can add links, and so that regular visitors can only search the database, to listen to or view one of the results...
i want it so that only i (admin) and particular people with usernames and passwords can add to it... and only i can delete...

if anyone can edit it for this purpose,,, i would greatly appreciate it...

------------------
=-.Thanx.-=

Jack shepler

Romans 1:16

Are you asking for help in doing it yourself or are you wanting to hire someone to do it? My rates are $75 per database and I will work with you to get it the way you want it. Or, you can work on it yourself and come to the forum when you have a problem and we'll see if we can work it out.


------------------
JPD

well, i was hoping you could just tell me how to make it so that only me and the right people can edit...

can it be configured that way already???

i was hoping i could already do that...

Sure. You can set permissions however you want to. You can determine which users can view, add, modify or delete records and which ones can give or take away those permissions (which would be the "admin.") You can set it up so that users don't have to log in to view the records or you can set it up so they do have to.

I would suggest that you download the DBMan archive and install it on your server. There is a sample database in the archive and you can play around with the functions, change permissions, add, delete, modify records -- whatever you want. All for free.



------------------
JPD

i think the variables are kinda hard to set up at first look, but i have downloaded it and i will try it out...

thanx for your help...
i may still ask some questions.

would you consider www.freakcentral.com a site that can use it for free???

By the way: i like this discussion thingy... where can i get this???

------------------
=-.Thanx.-=

Jack shepler

Romans 1:16

It's not me that makes the determination of whether a site can use it for free or not, since I don't have any real financial stake in the company. (I do custom work on a freelance basis and I volunteer my time at the forum.)

I would think, though, if you make money from the database, you should pay for the script. If you don't make money from the database, payment is optional, but you must keep the Gossamer Threads logo with the database. (It's only fair, I think. )

I have the beginnings of a tutorial set up on my site that might help you. You can go to http://www.jpdeni.com/dbman/tutorial.html and at least get enough info to get you started.

Be sure to read everything that came with the archive. Look at the comment lines -- any line that starts with a # is a comment. They'll help you a lot.

The forum uses the Ultimate Bulletin Board as its script. I think the cost is around $150 for the full version. (The don't cut people any slack for being non-profit. )

Their site is at http://www.UltimateBB.com.

------------------
JPD

your thing helped out a lot!!!

here's the thingy i made with that generator:

%db_def = (
'Category' => [0, 'alpha', 0, 255, 1, '', '' ],
'URL' => [1, 'alpha', 20, 50, 1, 'http://', '^http://' ],
'Title' => [2, 'alpha', 20, 50, 1, '', '' ],
'Artist' => [3, 'alpha', 20, 50, 1, '', '' ],
'Artist-URL' => [4, 'alpha', 20, 50, 1, 'http://www.freakcentral.com/artists/--/index.html', '^http://' ],
'Album' => [5, 'alpha', 20, 50, 1, '', '' ],
'Album-URL' => [6, 'alpha', 20, 50, 1, 'http://www.freakcentral.com/artists/--/--.html', '^http://' ],
'Date' => [7, 'date', 20, 50, 1, '&get_date', '' ],
'Popular' => [8, 'alpha', 20, 50, 0, '', '' ],
'ID' => [9, 'numer', 20, 50, 1, '', '' ]
);

do you see anything wrong with it???

Glad it was a help. I am rewriting it and extending it so it will be better, but these things take time.

Your configuration looks pretty good. I was wondering about your default value for two fields--

'http://www.freakcentral.com/artists/--/index.html'

and

'http://www.freakcentral.com/artists/--/--.html'

I'm assuming that you will be adding values into the spaces where the "--" are.

What you could do instead is, in your Artist-Url field, just put the directory name and in the Album-Url, just put the name of the file -- at least you can if you will eventually be creating your own display. (Don't worry. We'll work you through it. )

If you use your own display, you can have the part that doesn't change--

'http://www.freakcentral.com/artists/'

within the display file and you won't have to repeat it twice within every record.

Otherwise, it looks fine. You're doing well.

------------------
JPD

You'll need three forms, one for each database. You'll probably want to just have a keyword search for each one.

Could you explain a little more of what you want to do?


------------------
JPD

for an example: see www.musicforce.com - they have the keyword thing. type in: artists and term = dc talk

that will show you kinda what i want to do.



------------------
=-.Thanx.-=

Jack shepler

Romans 1:16

If you have three databases, you're talking about setting up a relational database, which is not something for the fainthearted to try. Or those who are new to DBMan and to Perl.

However, I will work with you on it as I can, one step at a time. But this isn't something for which I can just type out a few lines of code. This is a major process.

Just warning you.


------------------
JPD

okay... now i need to know this:
i want to make 3 db's...
artist
song
album

i want to make a search where you choose artist, song, or album ... so it would search only in that database...

how can i make 3 db's, and make it so that the search will tell the script which to go to?

------------------
=-.Thanx.-=

Jack shepler

Romans 1:16

i just want to have three databases that that search depending oin which you checked...

i was hoping i could have it forward if it were the only one searched for (keyword), but if that's too hard...

also, just have regular search results, but have them different for each search (more html.pl 's)

also, im not new to perl... i have made my own perl progs... but, im new to this one prog...

------------------
=-.Thanx.-=

Jack shepler

Romans 1:16

I think this will give you what you're asking for, then. I thought you wanted your database set up just like the other one.

In your search form, just use


------------------
JPD

about this code:

<input type="radio" name="db" value="artist">artist
<input type="radio" name="db" value="album">album
<input type="radio" name="db" value="song">song
<INPUT TYPE="TEXT" NAME="keyword" SIZE=15 MAXLENGTH=255>
<INPUT TYPE="SUBMIT" NAME="view_records" VALUE="Go">

...

Do i need to make a field called keyword... and if so, can i make the script automatically go to the one result??

Thanx for your time and patience.

what files do i need to make copies of to make the db's... ex: artist.db , song.db ...

are there other files i need to copy?

------------------
=-.Thanx.-=

Jack shepler

Romans 1:16

Yes, you need to make a field called "keyword." It is in the code I gave you.

When you enter a search term in the "keyword" field, the database will search the database defined by the radio buttons and will return all the records in the database with the value entered into the field.

I may be missing something in your questions, though.

For your each database, you will need a .db file, a .cfg file, a .count file and an html.pl file. Use the same .pass file for all of your databases.

Oh, you might want to make one of the radio fields selected by default, or you'll get errors if someone doesn't select one.


------------------
JPD

kewl...
so far so good... except: do i need to have the thing i had that says:
'Category': (pulldown: artist, album, song) in it anymore???? it doesn't seem to be needed with more than one database...

i can figure that it probably doesn't... but i figured i would check... im talking about the add part... on the first one, i have that 'category'

Not if you've got three databases. I don't see why you would need that.

If you delete the field, though, be sure that you either manually edit the database to remove the field or start over with a blank database.


------------------
JPD

go here for what i have so far (i onlt got to the artists for now... the rest is not done yet...)
i only have one record, but hey... it looks good so far.

http://www.freakcentral.com/cgi-bin/db/db.cgi?db=artist&uid=&view_records=1&ID=*

Very nice.

You may need to do a little work on your html.pl file, because the page didn't show up when I used Netscape. You probably have a </table> tag missing or something. Netscape isn't very forgiving about that sort of thing.

But it's looking good!


------------------
JPD