Picture html resize.

[Joshie]

Your phpBB Version: 2.0.
phpBB Type: phpBB / IMPortal
MODs: No
Your knowledge: Beginner
Board URL: [url]http://[/url]

PHP Version:
MySQL Version:


What was done before the problem appeared?
I don't know


What was done to try to solve the problem?
I don't know



De.scription and Message

I am wondering if there is any way I can get a mod for picture html resize. When member upload an avater that it automatically resize an avatar.

And if there is one, then how can I add a mod?

[Frost]

You can pick a mod that does this from [url=http]HERE[/url]

Then you would just follow the mod installation instructions.

If you need further help, post here and I will try and help you.

[Joshie]

You can pick a mod that does this from [url=http]HERE[/url]

Then you would just follow the mod installation instructions.

If you need further help, post here and I will try and help you.

I don't know how to install it.<img> I looked in for how to install and it really confuses me, and I don't even know which right file to download for it.

[Joshie]

Alright, got this going until I get to 2nd step.

ALTER TABLE phpbb_users ADD `user_avatar_img` LONGBLOB AFTER `user_avatar` [Error]
Duplicate column name 'user_avatar_img'ALTER TABLE phpbb_users ADD `user_avatar_mime` VARCHAR( 25 ) NOT NULL AFTER `user_avatar_img` [Error]
Duplicate column name 'user_avatar_mime'INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_auto_resize_remote_avatar', '1') [Error]
Duplicate entry 'nivisec_auto_resize_remote_avatar' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_blank_avatar_image', 'nivisec/spacer.gif') [Error]
Duplicate entry 'nivisec_blank_avatar_image' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_too_big_avatar_image', 'nivisec/toobig.png') [Error]
Duplicate entry 'nivisec_too_big_avatar_image' for key 1



<?PHP

/***************************************************************************
* sql_install.php
* -------------------
* copyright: (C) 2004 Billy Sauls
* email: <a>support@nivisec.com</a>
*
* $Id: $
***************************************************************************/
/***************************************************************************
*
* This program is free software; you can redistribute it and/or modify
* it under the terms of the GNU General Public License as published by
* the Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
*
***************************************************************************/

define('IN_PHPBB', true);
$phpbb_root_path = './';

include($phpbb_root_path."extension.inc");
include_once($phpbb_root_path."common.$phpEx");

$error_text = '<span>[Error]</span><br>';
$good_text = '<span>[Passed]</span><br>';

$sql = array();
$sql[] = "ALTER TABLE ".USERS_TABLE." ADD `user_avatar_img` LONGBLOB AFTER `user_avatar`";
$sql[] = "ALTER TABLE ".USERS_TABLE." ADD `user_avatar_mime` VARCHAR( 25 ) NOT NULL AFTER `user_avatar_img`";
$sql[] = "INSERT INTO ".CONFIG_TABLE." ( `config_name` , `config_value` ) VALUES ('nivisec_auto_resize_remote_avatar', '1')";
$sql[] = "INSERT INTO ".CONFIG_TABLE." ( `config_name` , `config_value` ) VALUES ('nivisec_blank_avatar_image', 'nivisec/spacer.gif')";
$sql[] = "INSERT INTO ".CONFIG_TABLE." ( `config_name` , `config_value` ) VALUES ('nivisec_too_big_avatar_image', 'nivisec/toobig.png')";

foreach($sql as $command)
{
echo trim($command);
if ($db->sql_query($command) === false)
{
echo ' '.$error_text;
$error = $db->sql_error();
echo $error['message'];
}
else echo ' '.$good_text;
}

[Joshie]

http://www.killyourboredom.com <--- site.
http://www.killyourboredom.com/sql_install.php <--- error.

[Frost]

Well, to begin with you need to look into each of the listed mods and select the best one that suits what you need. IntegraMOD has this feature built in but I don't know which mod it is.

After reviewing a couple, I would think this one would be good '"Avatar Database Storage and Resize"

To install the mods:

1. Download the mod

2. Unzip the mod

3. Read all "readme" and "install" text files

4. BackUp ALL related files! This includes ANY file(s) you will be touching in any way. (Including your database)

5. Open the install file and follow the directions.

Examples]OPEN[/b] - This is telling you to open the file and get it ready to edit. I would suggest using a more advanced text editor. Notepad will most likely just cause your problems (I use HTML-Kit and Notepad+)

FIND - This is telling you to find a specific part of the file. This will always work in conjunction with "BEFORE, ADD and AFTER, ADD and REPLACE WITH". So what I do is copy (CTRL+C) what it tells me to find, then in the editor do a "Find" (CTRL+F). This will take you straight to the text the mod is asking you to find. Note - In some cases you will not be able to "find" the text and there can be many reasons for this. Such as:

1. The file has been edited before, and the original code is no longer there.

2. Some editors exclude certain code from their find feature

3. The code might have been changed, depending on your version of phpbb and what the mod was designed for.

4. Almost all theme files are different. The mods are always made to be installed on an ordinary version of phpbb with the default theme called "subSilver"

So in the case that you cannot find the required text, you can try to shorten the text you are looking for. If it asked you to find

Code: Select all

$template->pparse("body");

And you could not find it, try changing it to something shorter, but keep important words or phrases, like so

Code: Select all

$template->pparse

Then manually look at the code and see if it matches.

Ok, back on topic]BEFORE, ADD[/b] - This is telling you to add this text BEFORE the text that you have found. This means to add the text on the next line up from the text it asked you to find. Be sure to maintain the structure of the file and use common sense.

AFTER, ADD - This is telling you to add this text AFTER the text that you have found. This means to add the text on the next line down from the text it asked you to find. Be sure to maintain the structure of the file and use common sense.

REPLACE WITH - This is telling you to replace the code it told you to find, with the new code. A good practice to get into would be to keep the highlight that you get when you find the original text, then just paste(CTRL+V) the new code in it's place. Note - This method would not work unless you found the entire piece of code that it asked you to, to begin with of course.

SAVE & CLOSE ALL FILES - This is just telling you to save and close the files (mainly for easymod) When I do mods or file edits, I save and upload each file as I get done with it because my ftp program is still in the folder I got the file from and it just makes it easier.

Then once you have done the entire install you should go visit your board to see the results. I would not suggest looking at your board until you are finished because you will most likely get errors until all of the edits are done and the mod is complete.

In the same sense, I also suggest disabling your board while you do the mod, but the simple truth of it is, the absolute best practice here would be to try the mod install on a demo board or even on your local machine first.

I can tell you right now, even the most experienced users and even developers miss something or mess something up at some point. So if you do not succeed on your first attempt, don't give up, try it again.

Hope this helps you some, and in worst case scenario you could always invite someone to install the mod for you. Although I highly suggest you learn it yourself!

[Frost]

Ok, apparently it took me so long to write that, you had time to post more lol

And what file is that?!
Who is the author?

The sql file is not even correct

Code: Select all

ALTER TABLE phpbb_users ADD `user_avatar_img` LONGBLOB AFTER `user_avatar` [Error]Duplicate column name 'user_avatar_img'ALTER TABLE phpbb_users ADD `user_avatar_mime` VARCHAR( 25 ) NOT NULL AFTER `user_avatar_img` [Error]Duplicate column name 'user_avatar_mime'INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_auto_resize_remote_avatar', '1') [Error]Duplicate entry 'nivisec_auto_resize_remote_avatar' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_blank_avatar_image', 'nivisec/spacer.gif') [Error]Duplicate entry 'nivisec_blank_avatar_image' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_too_big_avatar_image', 'nivisec/toobig.png') [Error]Duplicate entry 'nivisec_too_big_avatar_image' for key 1

1INSERT INTO` should be `INSERT INTO`

[Joshie]

Ok, apparently it took me so long to write that, you had time to post more lol

And what file is that?!
Who is the author?

The sql file is not even correct

Code: Select all

ALTER TABLE phpbb_users ADD `user_avatar_img` LONGBLOB AFTER `user_avatar` [Error]Duplicate column name 'user_avatar_img'ALTER TABLE phpbb_users ADD `user_avatar_mime` VARCHAR( 25 ) NOT NULL AFTER `user_avatar_img` [Error]Duplicate column name 'user_avatar_mime'INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_auto_resize_remote_avatar', '1') [Error]Duplicate entry 'nivisec_auto_resize_remote_avatar' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_blank_avatar_image', 'nivisec/spacer.gif') [Error]Duplicate entry 'nivisec_blank_avatar_image' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_too_big_avatar_image', 'nivisec/toobig.png') [Error]Duplicate entry 'nivisec_too_big_avatar_image' for key 1

1INSERT INTO` should be `INSERT INTO`

Hey.

Author]http://phpbbhacks.com/download/3306[/url]

Thats what I tried to use, but appearently. It don't work.<img>

[Joshie]

Anyone, help?

[Frost]

Other than actually installing the file for you, I would just have to tell you to throw that mod in the garbage and try another one.

If you want, you can pick the next one and show me which one you picked, then I'll tell you to send me certain files that need the edits, I'll edit them and send them back, or just give someone access to your site.

Other than that, I don't know how else to help you <img>

[Joshie]

Is there another file for this? Because I would absolutely to have this kind of mod, soon as possible.

Do you know any other file? That'll work.

[Joshie]

http://www.killyourboredom.com/sql_install.php

<img>

It still does it, I change it to INSERT instead of 1INSERT.

[zenrei]

Ok, apparently it took me so long to write that, you had time to post more lol

And what file is that?!
Who is the author?

The sql file is not even correct

Code: Select all

ALTER TABLE phpbb_users ADD `user_avatar_img` LONGBLOB AFTER `user_avatar` [Error]Duplicate column name 'user_avatar_img'ALTER TABLE phpbb_users ADD `user_avatar_mime` VARCHAR( 25 ) NOT NULL AFTER `user_avatar_img` [Error]Duplicate column name 'user_avatar_mime'INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_auto_resize_remote_avatar', '1') [Error]Duplicate entry 'nivisec_auto_resize_remote_avatar' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_blank_avatar_image', 'nivisec/spacer.gif') [Error]Duplicate entry 'nivisec_blank_avatar_image' for key 1INSERT INTO phpbb_config ( `config_name` , `config_value` ) VALUES ('nivisec_too_big_avatar_image', 'nivisec/toobig.png') [Error]Duplicate entry 'nivisec_too_big_avatar_image' for key 1

1INSERT INTO` should be `INSERT INTO`

Hey.

Author]http://phpbbhacks.com/download/3306[/url]

Thats what I tried to use, but appearently. It don't work.<img>

joshie, this mod doesn't work with integramod, i've tried it before.

[Joshie]

<img>

That's major sucks. I really like to have this kind of mod for my site, so it can be easier for members to upload the avatar instead of asking me bunch of questions about how to resize a image.

[Frost]

You could do a sticky or announcement, or even a Force To Read topic explaining how to resize the image.

If it were me, and I had that many users who didn't know how to do it, I would put a link right there in the profile area that said "Need help resizing Images?" and apon clicking, it would open a small pop-up box similar to the smileys, that explained how to do it

[Joshie]

You could do a sticky or announcement, or even a Force To Read topic explaining how to resize the image.

If it were me, and I had that many users who didn't know how to do it, I would put a link right there in the profile area that said "Need help resizing Images?" and apon clicking, it would open a small pop-up box similar to the smileys, that explained how to do it

And how can I do that? In the file of profile, and the code, etc.

[Frost]

Let me build up some code, give me a couple of days

[Joshie]

I'd love it is if there are any available to make this work. For resizing an image when they upload an image.

[nGAGE]

Shouldn't it be possible to just pic some of the code that is responsible for creating thumbs on attachments?
That DOES resize the images to a thumbnail size and avatars are rarely much bigger!

Don't know if I have time to look into this.

[Frost]

I realize it has been more than a couple of days, and I apologize, I haven't forgot about you, just been really busy.