Hi Teddy. I did what you said. I removed the old installation with your Uninstall-Script. And than i installed your last version of viportfolio.
But the installation gets a error on step 5 (look at the Screenshot)
and ends totaly on step 6 with your inwindow. Is this correct.
I did nothing else. I want to let you this know, and now i wait for you instructions.... :D

Yeah, I got that same warning. I just clicked on the "Click here to finish your install" and it was fine. Had no problems

Yeah, this is the only problem I have with this hack.

Question: what exactly must after this prozess be done to compled the installation? Because i looked in my AdminCP and there still no viPortfolio-Settings.
So please Teddy @ Post 81, what must i do after this??

same, i see no options in the admincp after install (done by hand) with the newest zip

Read this post and bout 2 more posts down, this will tell you what you need to do to get it to work. The installer didnt seem to do this. I had to do this manually.

https://vborg.vbsupport.ru/showthrea...699#post280699

Man, guys goes for a cup of coffee and the whole place turns upside down :paranoid:


The error message that was in your screen shot that people are getting on the install unfortunately is extremely generic. There are some simple manual steps to get thru the control panel install though.

1. execute '
select * from settinggroup;
'

2. look at the output to make sure there is a 'viPortfolio Settings'. If there is, remember the displayorder and the settinggroupid. If there is not than execute the following:
insert into setting ( title ) values ( 'viPortfolio Settings' );
then start again from step one.

3. execute
select settinggroupid, title from setting order by settinggroupid, title;

You will see over 500 rows scroll by, you are only concerned with the last 10. If the settinggroupid is = 65354 then do the following update
update setting
set settinggroupid = {the settinggroupid from above}
where settinggroupid = 65354;
4. If your last 10 records do not say either 65354 or the settinggroupid you remebered from before than your settings have not been installed. You have to execute the SQL from within the file viPortfolio/database/install_settings.sql. Only run this once as it will add multiple entries. If you had to run install_settings.sql than return to step 3 otherwise go to step 5

5. Once you are sure that you have 10 settings, the first one should be 'Allowed Image Mime Types' than move on to the final steps

6. execute "select max(displayorder) from settinggroup" and remember the results.

7 execute "update settinggroup set displayorder={above displayorder plus one} where title like 'viPortfolio%'


You have completed the control panel options section.
I hope these instructions aren't too bad. :) Any helpfull critisizm on my manual direction giving would be helpfull also. As we have noticed, the instructions were half of the bugs. :(

Is everybody up and running? Is there any outstanding issues other than fixing the installer?

:fingers crossed:

Hello Teddy!!
Everything works like a charm!!
I did what you said...and now all works fine.
This is one of the greatest issues i ever saw here on VB.org, and i want let you know that when this hack is in the Full Release Section i will nominate for the "Hack of the Month".
Thanks anyway for your great support, and if i can help let me know.
[high]* Minifreunde loves this Hack!! :)[/high]

Thanks for the good words. I will happily accept them this time since you have something that works.

Be on the lookout for many more. :)

Hello Teddy!
Me again. I need help. Please-Please-Please!!!!
Can you please tell me the steps to integrate the viportfolio.php in my "Whos online" ??
Mean, User X edit his portfolio or User x watch the portfolio...
This is very important for me. ;)

Minifreunde,
sorry it took me so long.

I am not positive of what you are asking for but I think it is this:

To change the location column in the whosonline page to say if a user is editting or viewing a portfolio.

If that is what you are looking for here are the directions.
To add Portfolio activity to whosonline location status.

1. search for "n show" (should be line 40)
insert the following code on the line directly above this line.

case 'viewportfolio':
$userinfo[where] = "Viewing ".$userinfo['portfolioinfo'];
break;
case 'editportfolio':
$userinfo[where] = "Editing ".$userinfo['portfolioinfo'];
break;

2. edit online.php source file.
search for the word "Showthread". Don't forget the uppercase S ( should be line 354 )
on the next line you will see:
switch($filename) {

directly below that line insert the following code ( should be line 356 )

case 'viPortfolio.php':
if(strstr($token1,'user'))
{
$userinfo['activity'] = 'viewportfolio';
$userinfo['portfolioinfo'] = "<a href='viPortfolio.php?action=view&".$token1."'> Portfolio</a>";
}
else if ( strstr( $token1, 'edit' ) )
{
$userinfo['activity'] = 'editportfolio';
$userinfo['portfolioinfo'] = "<a href='viPortfolio.php?action=view&".$token2."'> Portfolio</a>";
}
else if ( strstr( $token2, 'user') )
{
$blowup = explode( '=', $token2 );
$userinfo['activity'] = 'viewportfolio';
$userinfo['portfolioinfo'] = "<a href='viPortfolio.php?action=view&userid=".$blowup[1]."'> Portfolio</a>"; }
break;

3. now edit viPortfolio.php
search for the word "urllocation"
the first occurance of this word, the line will look like below
$urllocation ="viPortfolio.php?viPortfolioid=".$image[viPortfolioid];

replace that line with the following line:
$urllocation ="viPortfolio.php?user=".$userid."&viPortfolioid=" .$image[viPortfolioid];

go three lines down and replace that line with:
$urllocation ="viPortfolio.php?user=".$userid."&viPortfolioid=" .$image[viPortfolioid];

4. still editting viPortfolio.php
search for "View". remembering the uppercase V
four lines below that insert the following

$DB_site->query("UPDATE user SET lastactivity='".time()."',lastvisit='".time()."' WHERE userid='$bbuserinfo[userid]'");

5. still edittnig viPortfolio.php
search for "Edit". remembering the uppercase E
two lines below that insert the following
$DB_site->query("UPDATE user SET lastactivity='".time()."',lastvisit='".time()."' WHERE userid='$bbuserinfo[userid]'");

you are done.

If you want a paperclip in the user line for the whos online window:

To add paperclip icon to whosonline listing

1. edit template whosonlinebit .
Insert the following code on the second line of the whosonline template.
<td bgcolor="#F1F1F1">$userinfo[portfolio]</td>

2. still editing template whosonline .
Search for "User". On the line above first occurance of "User" insert the following code.

<td bgcolor="#006633"><smallfont color="#FFCC00"><b>Portfolio</b></smallfont></td>

3. edit online.php source file.
search for the word: "onlinebit_ip"
the second occurance of this word you will see:
eval("\$onlinebit_ip = \"".gettemplate("whosonlinebit_ip")."\";");
}

Insert the following code on the line directly below the "}"

// Add a paperclip to the left of the username.
global $DB_site;
$count=$DB_site->query_first("
SELECT COUNT(*) AS 'count'
FROM viPortfolio
WHERE userid = ".$bbuserinfo['userid']."
AND enddate is NULL
");
if ( $count > 0 ) {
if ( $count > 1 )
$alt="Member ".$userinfo['username']." has ".$count['count']." portfolio attachments.";
else
$alt="Member ".$userinfo['username']." has ".$count['count']." portfolio attachment.";

$userinfo['portfolio'] = "<A HREF='portfolio.php?s=$session[sessionhash]&userid=".$userinfo['userid']."&action=view'>";
$userinfo['portfolio'] .= "<IMG BORDER=0 SRC='https://vborg.vbsupport.ru/greentek/paperclip.gif' ALT='".$alt."' TITLE='".$alt."'/></A>";
} else {
$userinfo['portfolio'] = 'N/A';
}
// Add a paperclip to the left of the username.

you are done.

Nice install Christy ;)

http://www.force137.com/forum/viPortfolio.php?userid=1

Minifreunde, do you have a screen shot example of your end-result of the BETA install?

Installed this one and it's sweet! But I must say, it wasn't easy. First, I tried the install file, but all it did was to create the tables and that was it. It gave me a ton of errors so after giving that a few tries I decided to do it manually, and that worked at once. Some clearer instructions for manual installations would help, really. :) But great work you guys.

One question though:

Why 65534? :p This number should afaik equal the settinggroup ID (in my case 33) or it won't work, at least it didn't for me.

I recommend having a look at bottom settinggroup through the Admin CP and assign that group instead (Options -> vBulletin Options).

Another thing...how about adding some <smallfont > to the viPortfolio.php file? :) I did that and to do so, just edit the lines below this of viPortfolio.php:

// version of software installing

Hello Guys!!
In my Case the installation wasen?t easy too. But after my third or fourth installation all becoms Routine... ;)

@ Sengerdw, heres a Screenshot. I got four Styles in my Forum. This is my "Softgreen-Style. Hope you like it!

@ Teddy, much thanx to you. Youre online-thing works great for me!! :classic:

Right, I have a few more suggestions for you. :)
In the template "viPortfolio_view"

REPLACE this:

with this:

This will create scrollbars if needed, and also, all images will be visible without having to resize the popup. :cool:

Finally, (yes, I promise to shut up after this :p), if you want your text to be a bit wider before it breaks to a new row than it originally is, search for this:

in the following templates: viPortfolio_add_attachment, viPortfolio_edit_attachment. REPLACE with:

in both templates.

Search for:

in the following templates: viPortfolio_edit_editbit, viPortfolio_edit_newbit. REPLACE with:

in both templates.

Additionally, if you want to center the text and skip the image filename (I see no use of showing that), open the template viPortfolio_view_textbit and search for this:

REPLACE with:

Hello Martin64!!
I test your code but i get an Errormessage with it.
Look, heres the Orginal-Code from Viportfolio_view.
With this code all works. :paranoid:

I do apologize for the install problems. That was an attempt to make the install a little easier. :ermm: It kind of backfired on me though :dead:

I am in the process of making a better installer that can be used to install other hacks also. This will go thru the standard beta testing just like a normal hack would. :cool:

For the text wrapping functionality. I have a setting in the admin control panel to change the length of the text. I didn't put the ability to change the width of the box that the text is in though. If that is something people would want to have more control over it would be a simple addition.

About the pop up window size. In my testing just setting the window to the size of the graphic created a window that was too small in some browsers but not others. I don't remember which browers did what. With the settings that are in there the popup will always show the whole image. With the filesize maximum set to only 75k there shouldn't be an image bigger than 1024x768 so the popup window will always fit inside a screen.

The use of the 65354 number in the settings. The install program inserts the settings into the table with that value preset. Then inserts a row into the settinggroup table. The id that is given to the settinggroup is used to replace all settings with 65354 assigned to them. Without knowing what the largest setting identifier before inserting the settings I choose to use the highest number possible and then replace it later.

Thanks Martin64 for the suggestions. I think I will take the filename out of the next release. Here is an option, if the user doesn't put a description for the file they upload than the program will use the filename, otherwise only insert the text that they put for the file. Anymore suggestions are more than welcome! :)

Very strange, that must work. It's the exact same as you're using now, except that it adds a scrollbar and makes the popup window a bit bigger.

TeddyBare69: I see, thanks for the explanations. I don't see the option for text wrapping in the Admin CP though. About the popup window: personally, I rather have a window that is a bit bigger than one that's too small, but that's just me. I uploaded a few rather small images (less than 1024x768) and they didn't fit (IE 6.0).

Yeah, but that doesn't have anything to do with text wrapping. :p

Martin64,
Do you have the following option:

The point that a long sentence gets split
The maximum width of each line before a line is seperated and placed on the next line

In the application I look at the length of the text that is input and put in cariage returns. The default setting is every 30 characters. You can change that in the viPortfolio settings in the admin control panel. Just click on the vBulletin Options and the click on viPortfolio Settings.

Ah right, I see it now. Thanks :)

I have made a little add-on for those who are interested. :)

If you want a paperclip with a link to that user's portfolio to show up in your postbit below each user's username/avatar etc. then add the following code wherever it suits:

Check the screenshot provided to get a clue on what I mean. I believe this will encourage more members to add pics to the portfolio's without adding an extra query per post. I thought it was shame members didn't use this hack simply because they hadn't noticed it, but now they certainly will :)

Martin64,
I like that idea. putting the paperclip in the middle of all the action would be a better way of getting peoples attention and making it more visible to other guests. When I put the paperclip hack on the members list I added in the ALT text for the link. This requires a database query which I haven't fully determined how big a hit that causes with mass amounts of users.

I am going to try and do some extra database testing to make sure that I have the correct database setup. I will let you know what changes I find. :)

I have a question for more experienced hack installers. What is the proper procedure to move from Beta to Release status?

To recap, Any issues found so far with the viPortfolio have been resolved. The installer that comes with viPortfolio still have multiple outstanding issues and the manual directions still have a few outstanding issues.

If I were to update the manual install directions and drop the install option would viPortfolio be ready for Release status? I am not total sure what the proper protocal is and I haven't been able to find anything in writting about it.

Here is a request for somebody that might feel up to the challenge. In order to do it right the first time I am going to need some (alot) of help getting the manual directions written better :) Any voulenteers willing to take my chicken scratch and make a real document out of it? If not that is cool, it is something I need to learn anyway.

Again, thank you too all for helping test this hack and going thru the pains of dealing with the installer. This made a big difference for me and I wanted to make sure you all know that! :)

Hello Teddy!
If you want i can write a text-install with you.
I think the manual install of this is a way to bring this in the release-section.
Not anyone is there good to handel with the errors the installer produces. When you put it with the installer in Full-Releases you will get an endless supportthread.
My Meaning is: give the text-install with it, or think about a VBhacker-file of the install. Where any install-step is watchable.

@ Post 104,
thanks Martin64 for sharing the Postbit-Code with us.
Great Idea!! :)

Well, I've been trying like a mad man for the past few days to install this one. It's just kickin' my arse. The auto-install isn't working for me, so I'm trying the manual install.

However...the following sql query exec is not working.
When I run that thru myphpadmin, this is what I get:

Error
SQL-query :

SELECT MAX(DISPLAYORDER) FROM SETTINGGROUP LIMIT 0, 30

MySQL said:


Table 'apok_vbp.SETTINGGROUP' doesn't exist

I've tried the exec w/ and w/o the ";" at the end of SETTINGGROUP, no change. Also, I've installed the tables correctly...still nothing.

I have other issues...but I figure this is stumper and may has well tackle them one at a time. Can anyone help?

OK, as I understand it, the above is for adding settings to the admincp. So even w/o the above, it should still work right? So while the above is getting worked on, I thought I'd also get help about the next issue.

Whenever I upload while in the Portfolio page...

1) It IMMEDIATELY takes me to my profile settings afterwards. How do I get it to simply take me back to the Portfolio where it should?

Hey Apok,
I was thinking that before too about what url should the user be taken to after an upload is finished. Back to the Portfolio?, Back to the Edit Portfolio? or the Profile? I wonder if it would just be easiest to addit as a setting that can be chanaged in the Admin Control Panel?

What do you guys think? It would be an easy thing to do.

Also Apok, sorry about all the frustration. You can be happy about the new version and that nobody else will have to go thru what you did :D I just wish I had gotten it in time to help you. The new version was inspired by th vbQuiz hack installer. That one was so simple and did an aweful lot of work. Just didn't show it. If you still have more energy left, give this install a try. If you have files that are already uploaded and you don't want to loose them than only do an upgrade. The uninstall will remove all traces of viPortfolio.

Check out the version 1.1.0 though, it is worth it. :D

Yes, the user should definately be taken back to the Porfolio. Users just updated their pics/docs, etc...they'll want to see it immediately how the rest of the community will see it. They'll want to verify it was done correctly.

Im also upgrading right now...I'll let ya know how it goes.

well...here is a list of all the errors that I got in the Install for 1.10 during the upgrade.

I went ahead and clicked "continue" and I got the following:

It's all jacked up now. None of it works. The url that WAS working for 1.07 now generates mysql errors.

I'll just uninstall again, and go thru the manual install in a couple days. I need a break from this one. It's like teasing me...SO close...but never quite there.

Also, when doing the manual install of the paperclip addon, in the memberlist.php, where it says to find:
This is not found.

This is what is here instead:

Where in the above code does the following go?

--------------------------------------
When it says to click on the memberlist tab, first of all, it's by default on memberlistbit template, not memberlist....and above memberlistbit (default template set), it shows the following error:
Warning: Missing argument 7 for makechoosercode() in /home/apok/public_html/forums/admin/adminfunctions.php on line

I decided to try to do that one manually, but found the same problems as I did in 1.07.

It says: I think you are meaning to say "Replace the number 6 with a number 7", no?

-------------------------------------------

Also...still, there are no admin cp settings appearing. :(

no, it is not that bad. all you have to do is copy the viIcons directory into your forumroot/images directory and copy the prog\viPortfolio.php file your forumroot/ directory. You had some kind of permission error possibly from doing it manualy before. It is fixable quite easily.

viPortfolio.php was moved there, and the icons were already in place.

and when I go to http://www.ez-company.net/forums/viPortfolio.php I get the following error:

Now before the install, it was kinda weird too...it would take me to my UserCP (not portfolio). But there were no errors. I can see the Portfolio now...but I have to go thru my Profile to do it.

And there is still no admin cp settings, nor paperclip due to the issues in the posts above.

The error above is because you don't have a userid in the url. If you had http://www.ez-company.net/forums/for...=1&action=view

that would work better

that last part is supposed to be viPortfolio.php?userid=1&action=view

Yeah, the manual instructions have a lot to be desired!!!! That is by far my favorite thing to do. Minifreunde offered to help me and then the next night I got inspired from a different hack that I was installing and the new installer was born.

There is another problem with the hack directions. It tells you to click on a tab for memberlist.php and the tab doesn't even exist :D The directions were written for the previous editor. I didn't have time to include that so the directions need to be polished a little bit :paranoid:

I was just happy to get something that worked better than the previous one. I had to come tell people about the changes.

I will update the manual directions tonight and have them available sometime tomorrow morning. :)