Gossamer Forum: Products: Gossamer Links: Discussions: Is there an easy way to add more fields to glinks 3.0.4?

Jan 3, 2006, 2:00 PM

aph

Novice (42 posts)

Jan 3, 2006, 2:00 PM

Post #1 of 14

Shortcut

Is there an easy way to add more fields to glinks 3.0.4?

I seem to remember that there was a somewhat easy way to add extra fields to the database in links 2.0 sql with the admin panel, but now in 3.x I can't find it anywhere. I need to add a couple more fields so that more information can be attained from the user.

Also Imlooking for an uploader to incorporate into glinks 3.0.4 that will allow people to upload files to my server into a directory that will work with glinks 3.0.4 (preferably inexpensive), Im really poor after my recent auto accident (my fault), totaled car with only liability, so I spent my life savings buying a used car, not that it's anyone elses problem nor why IM writing it down here.

Jan 3, 2006, 3:02 PM

brewt

Staff (4101 posts)

Jan 3, 2006, 3:02 PM

Post #2 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

You can do this in the admin => Database => select table and select Properties and Go (on the left) => Add Column (at the bottom)

Adrian

Jan 3, 2006, 3:50 PM

aph

Novice (42 posts)

Jan 3, 2006, 3:50 PM

Post #3 of 14

Shortcut

Re: [brewt] Is there an easy way to add more fields to glinks 3.0.4? In reply to

There is no table selection, just category, links, users, and reviews, and no table properties in the Tools section of the database page nor the repair box. I think that was the way it was done in 2.x, did they drop it from 3.0.4?

Edited, it's under database, link, or user, or review or category, properties that allow you to do this.

Last edited by:

aph: Jan 3, 2006, 4:22 PM

Jan 3, 2006, 4:19 PM

aph

Novice (42 posts)

Jan 3, 2006, 4:19 PM

Post #4 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Okay, now I've created a field of file upload, but how do I get it to show up as a text box with the browse button when they are adding the uploaded file? the column name is Downloads, Im not sure what template this would go into either, I would think add something template.

Last edited by:

aph: Jan 3, 2006, 4:21 PM

Jan 4, 2006, 12:31 AM

Andy

Veteran / Moderator (18441 posts)

Jan 4, 2006, 12:31 AM

Post #5 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Hi,

Something like this in include_form.html should do the trick;

Code:
<div class="row clear"> 
  <label for="Downloads" class="name">Downloads:</label> 
  <div class="value"> 
     <input type="file" name="Downloads" class="text"> 
  </div> 
</div>

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 4, 2006, 3:30 AM

aph

Novice (42 posts)

Jan 4, 2006, 3:30 AM

Post #6 of 14

Shortcut

Re: [Andy] Is there an easy way to add more fields to glinks 3.0.4? In reply to

In Reply To:

Hi,

Something like this in include_form.html should do the trick;

Code:
 <div class="row clear">  
  <label for="Downloads" class="name">Downloads:</label>  
  <div class="value">  
     <input type="file" name="Downloads" class="text">  
  </div>  
</div>

Hope that helps.

Cheers

Thanks, that puts a form to upload a program, but it never arrives like it doeswhen I do it from the admin panel. In the admin panel, it works fine and the file goes into the downloads directory, when I try it from the add.cgi form it I assume uploads but then just disappears and doesnt go into the downloads directory.

Jan 4, 2006, 4:25 AM

Andy

Veteran / Moderator (18441 posts)

Jan 4, 2006, 4:25 AM

Post #7 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Does your <form> part look like this in add.cgi?

<form action="<%db_cgi_url%>/add.cgi" enctype="multipart/form-data" method="POST">

The important part is enctype="multipart/form-data", as this tells the browser to upload the file, rather than just sending the value. It definatly works, as I use it all the time =)

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 4, 2006, 5:41 AM

aph

Novice (42 posts)

Jan 4, 2006, 5:41 AM

Post #8 of 14

Shortcut

Re: [Andy] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Yes it looks just like that.

Last edited by:

aph: Jan 4, 2006, 6:27 AM

Jan 4, 2006, 5:48 AM

Andy

Veteran / Moderator (18441 posts)

Jan 4, 2006, 5:48 AM

Post #9 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Sorry, that made no sense to me Tongue

Cheers

Andy (mod)
andy@ultranerds.co.uk

Jan 4, 2006, 9:11 AM

aph

Novice (42 posts)

Jan 4, 2006, 9:11 AM

Post #10 of 14

Shortcut

Re: [Andy] Is there an easy way to add more fields to glinks 3.0.4? In reply to

when a user uploads a file, how does the server know where to put it, and what linking coule I AUTOMATICALLY PUT IN MY TEMPLATES SO THAT people can click to download directly?

Jan 5, 2006, 9:48 PM

aph

Novice (42 posts)

Jan 5, 2006, 9:48 PM

Post #11 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Any clues to this one, is the file held in the database and if so what would the field have to be, like a blob or something?

Jan 6, 2006, 8:11 AM

webmaster33

Veteran (2312 posts)

Jan 6, 2006, 8:11 AM

Post #12 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

<a href="<%db_cgi_url%>/jump.cgi?ID=<%ID%>&view=MyUploadColumn">

Also check this thread:
http://www.gossamer-threads.com/...i?post=154513#154513

Best regards,
Webmaster33

Paid Support from Webmaster33. Expert in Perl programming & Gossamer Threads applications. (click here for prices)
Webmaster33's products (upd.2004.09.26) | Private message | Contact me | Was my post helpful? Donate my help...

Jan 10, 2006, 12:08 AM

aph

Novice (42 posts)

Jan 10, 2006, 12:08 AM

Post #13 of 14

Shortcut

Re: [webmaster33] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Thanks when I put that in there I get:

http://www.mydomain.com/jump.cgi?ID=15&view=Downloads;d=1 That takes them to a page that says ERROR oops unknown file request.

In my detailed template I put
<a href="<%db_cgi_url%>/jump.cgi?ID=<%ID%>&view=Downloads">
because the column in my links database is named Downloads for files.

I'll go read the thread you suggested, maybe it will knock some sence into me.

By the way in add.cgi it states:

<form action="<%db_cgi_url%>/add.cgi" enctype="multipart/form-data" method="POST"> So I believe it's correct there. BUt after adding the form to the include_form template it shows up on the addd a link page, and it seems to take long enough for the file size IM uploading but when I look in the directory that I specified for it to go into, theres nothing in there. So i'ts like the glinks is just dumping the file and not storing it.

Last edited by:

aph: Jan 10, 2006, 12:14 AM

Jan 10, 2006, 12:17 AM

Andy

Veteran / Moderator (18441 posts)

Jan 10, 2006, 12:17 AM

Post #14 of 14

Shortcut

Re: [aph] Is there an easy way to add more fields to glinks 3.0.4? In reply to

Hi,

You have & and ; used as a seperator ;)

http://www.mydomain.com/jump.cgi?ID=15&view=Downloads;d=1

Try this;

Code:
<a href="<%db_cgi_url%>/jump.cgi?ID=<%ID%>;view=Downloads">

Cheers

Andy (mod)
andy@ultranerds.co.uk