Photo gallery

Tell us how to make this service better.

Moderators: chossmonkey, Dom, granite_grrl

Photo gallery

Postby lukelovesclimbin » Sun May 22, 2005 9:39 pm

Fred your my hero but i think that this site would be 100 times better if we could upload pictures. like RC.com
only a Suggestion though the site is still kick ass
Climb on
Luke
lukelovesclimbin
 
Posts: 86
Joined: Wed Apr 27, 2005 4:12 pm
Location: At the wall

Postby Fred » Mon May 23, 2005 3:28 pm

I'm leaving that up to x-img.com
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby lukelovesclimbin » Mon May 23, 2005 8:38 pm

sp theres 1 comming?
climb on
Luke
lukelovesclimbin
 
Posts: 86
Joined: Wed Apr 27, 2005 4:12 pm
Location: At the wall

Postby dcentral » Tue May 24, 2005 6:54 pm

He means http://www.x-img.com.

But seriously there are enough places to post photos. We don't really need another.
User avatar
dcentral
 
Posts: 653
Joined: Wed Oct 27, 2004 10:00 pm
Location: Victoria, BC

Postby Fred » Wed Aug 02, 2006 11:14 am

I'm looking at adding a photo gallery on this website but I'm unsure about the following modifications that need to be done to the SQL database (see code below). How easy is this? I've surfed around before using my webhost SQL admin tools but never done anything.

#
#-----[ SQL ]------------------------------------------
#
CREATE TABLE phpbb_album (
pic_id int(11) UNSIGNED NOT NULL auto_increment,
pic_filename varchar(255) NOT NULL,
pic_thumbnail varchar(255),
pic_title varchar(255) NOT NULL,
pic_desc text,
pic_user_id mediumint( 8 ) NOT NULL,
pic_username varchar(32),
pic_user_ip char( 8 ) NOT NULL DEFAULT '0',
pic_time int(11) UNSIGNED NOT NULL,
pic_cat_id mediumint( 8 ) UNSIGNED NOT NULL DEFAULT '1',
pic_view_count int(11) UNSIGNED NOT NULL DEFAULT '0',
pic_lock tinyint(3) NOT NULL DEFAULT '0',
pic_approval tinyint(3) NOT NULL DEFAULT '1',
PRIMARY KEY (pic_id),
KEY pic_cat_id (pic_cat_id),
KEY pic_user_id (pic_user_id),
KEY pic_time (pic_time));

CREATE TABLE phpbb_album_rate (
rate_pic_id int(11) UNSIGNED NOT NULL,
rate_user_id mediumint( 8 ) NOT NULL,
rate_user_ip char( 8 ) NOT NULL,
rate_point tinyint(3) UNSIGNED NOT NULL,
KEY rate_pic_id (rate_pic_id),
KEY rate_user_id (rate_user_id),
KEY rate_user_ip (rate_user_ip),
KEY rate_point (rate_point));

CREATE TABLE phpbb_album_comment (
comment_id int(11) UNSIGNED NOT NULL auto_increment,
comment_pic_id int(11) UNSIGNED NOT NULL,
comment_user_id mediumint( 8 ) NOT NULL,
comment_username varchar(32),
comment_user_ip char( 8 ) NOT NULL,
comment_time int(11) UNSIGNED NOT NULL,
comment_text TEXT,
comment_edit_time int(11) UNSIGNED,
comment_edit_count smallint(5) UNSIGNED NOT NULL DEFAULT '0',
comment_edit_user_id mediumint( 8 ),
PRIMARY KEY(comment_id),
KEY comment_pic_id (comment_pic_id),
KEY comment_user_id (comment_user_id),
KEY comment_user_ip (comment_user_ip),
KEY comment_time (comment_time));

CREATE TABLE phpbb_album_cat (
cat_id mediumint( 8 ) UNSIGNED NOT NULL auto_increment,
cat_title varchar(255) NOT NULL,
cat_desc text,
cat_order mediumint( 8 ) NOT NULL,
cat_view_level tinyint(3) NOT NULL DEFAULT '-1',
cat_upload_level tinyint(3) NOT NULL DEFAULT '0',
cat_rate_level tinyint(3) NOT NULL DEFAULT '0',
cat_comment_level tinyint(3) NOT NULL DEFAULT '0',
cat_edit_level tinyint(3) NOT NULL DEFAULT '0',
cat_delete_level tinyint(3) NOT NULL DEFAULT '2',
cat_view_groups varchar(255),
cat_upload_groups varchar(255),
cat_rate_groups varchar(255),
cat_comment_groups varchar(255),
cat_edit_groups varchar(255),
cat_delete_groups varchar(255),
cat_moderator_groups varchar(255),
cat_approval tinyint(3) NOT NULL DEFAULT '0',
PRIMARY KEY (cat_id),
KEY cat_order (cat_order));

CREATE TABLE phpbb_album_config (
config_name varchar(255) NOT NULL,
config_value varchar(255) NOT NULL,
PRIMARY KEY (config_name));

INSERT INTO phpbb_album_config VALUES ('max_pics', '1024');
INSERT INTO phpbb_album_config VALUES ('user_pics_limit', '50');
INSERT INTO phpbb_album_config VALUES ('mod_pics_limit', '250');
INSERT INTO phpbb_album_config VALUES ('max_file_size', '128000');
INSERT INTO phpbb_album_config VALUES ('max_width', '800');
INSERT INTO phpbb_album_config VALUES ('max_height', '600');
INSERT INTO phpbb_album_config VALUES ('rows_per_page', '3');
INSERT INTO phpbb_album_config VALUES ('cols_per_page', '4');
INSERT INTO phpbb_album_config VALUES ('fullpic_popup', '1');
INSERT INTO phpbb_album_config VALUES ('thumbnail_quality', '50');
INSERT INTO phpbb_album_config VALUES ('thumbnail_size', '125');
INSERT INTO phpbb_album_config VALUES ('thumbnail_cache', '1');
INSERT INTO phpbb_album_config VALUES ('sort_method', 'pic_time');
INSERT INTO phpbb_album_config VALUES ('sort_order', 'DESC');
INSERT INTO phpbb_album_config VALUES ('jpg_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('png_allowed', '1');
INSERT INTO phpbb_album_config VALUES ('gif_allowed', '0');
INSERT INTO phpbb_album_config VALUES ('desc_length', '512');
INSERT INTO phpbb_album_config VALUES ('hotlink_prevent', '0');
INSERT INTO phpbb_album_config VALUES ('hotlink_allowed', 'smartor.is-root.com');
INSERT INTO phpbb_album_config VALUES ('personal_gallery', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_private', '0');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_limit', '10');
INSERT INTO phpbb_album_config VALUES ('personal_gallery_view', '-1');
INSERT INTO phpbb_album_config VALUES ('rate', '1');
INSERT INTO phpbb_album_config VALUES ('rate_scale', '10');
INSERT INTO phpbb_album_config VALUES ('comment', '1');
INSERT INTO phpbb_album_config VALUES ('gd_version', '2');
INSERT INTO phpbb_album_config VALUES ('album_version', '.0.54');
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby thicks » Wed Aug 02, 2006 1:38 pm

If you have found a place in your webhost SQL admin tool to execute SQL code, then you should just be able to cut and past all of the code bellow into that tool and voila. I dont think it should matter but there is the chance that your SQL tool will only let you execute one command at a time, which would be all the seperate paragraphes starting with 'CREATE TABLE' and ending with the ' ; ' and also all of the "INSERT INTO" lines end in a ; so they are each considered a seperate command.

but you should really just be able to do it all at once. if you have trouble try doing each section seperately but I doubt it will be a problem.

Thicks( needs a new avatar. )
When I was a kid I used to pray every night for a new bicycle. Then I realised that the Lord doesn't work that way, so I stole one and asked Him to forgive me. -- Emo Philips
thicks
 
Posts: 201
Joined: Tue Apr 12, 2005 10:13 am
Location: moncton

Postby thicks » Wed Aug 02, 2006 1:40 pm

We were talking about the prunning stuff and how we have loads of space currently, but will this image upload MOD make a big difference size-wise?
T
When I was a kid I used to pray every night for a new bicycle. Then I realised that the Lord doesn't work that way, so I stole one and asked Him to forgive me. -- Emo Philips
thicks
 
Posts: 201
Joined: Tue Apr 12, 2005 10:13 am
Location: moncton

Postby Fred » Wed Aug 02, 2006 11:57 pm

there is oodles of space at the moment. My three websites combined amount to 235MB and my limit is 26.3Gigs. We are at less than 1% for both space and bandwidth.


I think my service provider uses phpMyAdmin2.8.0.3 interface to access the database. Does that make sense? You do realise Thicks that by showing interest in this thread you have just signed up for some work when I get back to Fredericton. Lets just make certain not to tweak the forum after breathing the resin fumes of the climbing holds we will be making when I get back.
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby Pierre » Thu Aug 03, 2006 8:16 am

Fred wrote:I think my service provider uses phpMyAdmin2.8.0.3 interface to access the database. Does that make sense?


phpMyAdmin is a great tool - and it's very easy to run SQL query/queries on the database and it makes perfect sense that your web host is using this tool.

It's just as thicks suggested.

I think a gallery for users would be a great feature for this site... keep up the good work.

Pierre
Pierre
 
Posts: 179
Joined: Tue Mar 22, 2005 2:26 pm
Location: Moncton

Postby thicks » Thu Aug 03, 2006 9:24 am

Fred wrote:I think my service provider uses phpMyAdmin2.8.0.3 interface to access the database. Does that make sense? You do realise Thicks that by showing interest in this thread you have just signed up for some work when I get back to Fredericton. Lets just make certain not to tweak the forum after breathing the resin fumes of the climbing holds we will be making when I get back.


You dong scare me with your work stuff Fred, but holds first, databases second, that is all I ask.
Enjoy the weekend...
Thicks
When I was a kid I used to pray every night for a new bicycle. Then I realised that the Lord doesn't work that way, so I stole one and asked Him to forgive me. -- Emo Philips
thicks
 
Posts: 201
Joined: Tue Apr 12, 2005 10:13 am
Location: moncton

Postby Fred » Thu Aug 10, 2006 11:44 pm

I think I have a photo gallery up and running. However, there are a few minor touch-up that need to be done. Mainly linking to buttons/images. The SubRed template causes problems. Would have been much easier with the default color scheme. Must go dodo for now. I'll try to fix it as soon as possible.
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby Fred » Fri Aug 11, 2006 4:33 pm

I would have thought someone would have tried this thing out by now. :)

Can someone take it for a test run to see if it works. The only bug I have found so far is the "Upload" button image is not showing up but the link still works.
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby mathieu » Fri Aug 11, 2006 5:30 pm

Ok i've put a photo in there, weird thing I see is that the "Pic description" field only appears when you want to rate or comment on the pic, it never appears any other time.
mathieu
 
Posts: 412
Joined: Wed Oct 20, 2004 12:56 am
Location: Alberta

Postby Fred » Fri Aug 11, 2006 9:51 pm

float your mouse pointer over the thumbnail
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby Fred » Fri Aug 11, 2006 10:24 pm

Ok... I've got the button now. Let me know if you guys spot anymore bugs. Enjoy.
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB

Postby Fred » Sun Aug 13, 2006 7:51 pm

It was brought to my attention today that I failed to point out that the gallery is accessed VIA a link at the top of this page called "ALBUM". Here is the link as well.

http://www.climbeasterncanada.com/album.php
I want to go to hell... there's probably lots of rock to climb there.
User avatar
Fred
Site Admin
 
Posts: 3140
Joined: Wed Oct 20, 2004 12:30 am
Location: Fredericton, NB


Return to Suggestions Box / Site News

Who is online

Users browsing this forum: No registered users and 2 guests

cron