viPortfolio 1.2.6 Beta Release

[TeddyBare69]

======= =======
viPortfolio Version 1.2.6
======= =======

This is our first hack. And not our last. :D We have spent a lot of time polishing it for stability and interface. Thanks for the patience and support so far.
We have installed and tested in vBulletin 2.2.6. For those with older versions, please post your results.

Credits:
VisibleImpact.com (http://www.visibleimpact.com) Administrative Director and author: TeddyBare69
VisibleImpact.com
(http://www.visibleimpact.com) Owner and Designer: sengerdw
Courages testers at vBulletin.org (https://vborg.vbsupport.ru/editpost.php?s=&action=editpost&postid=278860)
hellsatan, stangpower, Christy, Sketch, NTLDR, Apok2002, Martin64


Description:
For those that need a separate interface in the user control panel to upload files - download this.

Features:
[list=1]
New profile navigation bar to view a portfolio/upload gallery
New profile navigation bar for members to change their portfolio/upload gallery
Admin and moderators may change descriptions and delete file configuration options maintained in admin control panel.
86 different file types support via either thumbnail or default icon view.
ImageMagick not needed!
Display who uses their portfolio in the members list.
Support for vbHacker from Chen located at vbHacker 1.0.1 (https://vborg.vbsupport.ru/showthread.php?s=&threadid=36378) is included in the install.
[/list=1]
Demo links:
[list=1]
Members list (http://www.visibleimpact.com/forums/memberlist.php?what=topposters&perpage=15)
Public Profile (http://www.visibleimpact.com/forums/member.php?action=getinfo&userid=1)
Public Portfolio (http://www.visibleimpact.com/forums/portfolio.php?userid=1 )
[/list=1]
Installation Instructions:

Extract the viPortfolio-1.2.6.zip file which will create a viPortfolio
subdirectory. Upload the directory to your root Web server directory where your forum code is located. From a Web browser run: http://{yourserver}/viPortfolio/install.php and follow the steps.

.: Remove the viPortfolio subdirectory after installation :.

We would appreciate any feedback regarding this hack. Interface, changes for future versions and so on. We will offer support for this hack - we will not be responsible for errors - as always, BACK UP YOUR data base.

We have spent a lot of time on this and all we ask is that our copyright notice remain in tact at the bottom of portfolio pages. Thanks!

Along with viPortfolio we are making use of a new install.php version 1.2.6. The install.php has not had the amount of testing that viPortfolio has. With that said we are looking for your assistance in notifying VisibleImpact.com (mailto:support@visibleimpact.com) of any error messages or difficulties you may have with the install.

*** Updated installer ****
I have totaly rewritten the installer to take out all the flash and make it a simple step by step install. Atleast I hope that is what it is :D It is definately worth trying.

viPortfolio v1.2.6 developed by: VisibleImpact.com
(http://www.visibleimpact.com)

[Chris M]

Whoa!

Way cool!:)

Ive seen this on your site before...

Satan

[Dean C]

whoa... goes to install right away...

[TeddyBare69]

Part of the reason this wasn't uploaded earlier was because I was writting an install wizard. Currently this wizard is able to install the viPortfolio files, templates, and create the database tables alog with prepopulating the with data.
What the installer doesn't do is modify your existing files and templates to add links from your board into the portofolio. I have included directions at the end of the install on how to add those hacks into your existing files.

[afterlab]

I like the idea for the hack, but I will wait until this hack comes out of it's beta state.

[xware]

The demo can't be reach..

[Chris M]

I gave up installing it :(

It became to difficult to follow...:cry:

Satan

[TeddyBare69]

Were did you end at? What part was hard to follow?

[Chris M]

I stopped when I tried to make the Modifications to the "memberlist.php" file...

I got loads of errors...I wasnt sure what files needed uploading where, so I just stopped...

I dont think it made any changes to the Database...

Satan

[TeddyBare69]

When you unzip the viPortfolio-1.0.0.zip file you should have gotten multiple files all under a subdirector called viPortfolio. If move the directory viPortfolio into the same directory that you have the member.php file than you will have everything were it is needed.

Let me know if this helps?

[Chris M]

Well I did that to start with...

But I got loads of parse errors, that werent parse errors if you understand...

init functions and all sorts were wrong...

Satan

[TeddyBare69]

I am creating directions on how to manualy install the viPortfolio. I don't know that this will make it simplier but it will make it easier to know what changes are made.

[DrkFusion]

WoW nice hack man, been waiting for long time :)
Thanks

Drk

[Chris M]

Yes please...

I am not fond of Automated scripts...Maybe it is my inefficiency with them and chmodding directories etc which caused the errors...

Satan

[stangpower]

No go :(

I would like to see this work.

[TeddyBare69]

stanqpower, how was it a nogo? What kinds of errors did you get?

[TeddyBare69]

Here is manual directions for viPortfolio install. I am not very good at the technical documentation. With these directions I am assuming that you are somewhat experienced with vbulletin and installing hacks.

Let me know of any questions or if I didn't put enough details in these instructions.

I hope this helps.

[Chris M]

Thanks...

I'll install very soon:)

Satan

[Warrior]

Originally posted by hellsatan
I am not fond of Automated scripts...
Satan

The great thing about the installer is that, when finished - it allows you to edit your templates/PHP and save the changes with in the install program. The only true automation is the database tables being created for you with an option to delete them as well.

Once the script is finalized, this will be a great interface authored by TeddyBare69. One that he could translate for other hacks we come up with... or other hacks vB owners would like to have "beautified." Taking the simple text instructions into the new millenium. :p

But we did find that some prefer to do all the work, and I do to. But... others will not install a hack if they have to do the integration. So this installer is an attempted to satisfy both forum owners.

Unfortunatly due to it's complexity... the installer's BETA state may take time to finish. But most can install with the simple text instructions. We knew some where waiting patiently for this... :smoke:

[stangpower]

:)

[stangpower]

:)

Screen shot 2.

You would save me $100 if you could get this working :)

Ian

[Christy]

I too got the same errors that Stangpower posted :/

[Chris M]

Those are the errors I got:)

Satan

[TeddyBare69]

stangpower, hellsatan, christy, anybody else with databases that don't like the ';'

I am not completely positive this will fix your first screen shot of errors though. I am looking into how those errors could be created. You are more than willing to try with this fix.

If I could find out what version database you are running? I have seen this error on visibleimpacts website as well and haven't figured out why it works on my test server but not on the production server.

Here is the fix. I am uploading a new file and giving fixit instructions.

This is an easy fix.

1. in your viPortfolio directory you have install.php
2. open that file and find line 1338
You should see this with or without line numbers depending on your editor:
1335 if ($onvservers==1 and substr($val, 0, 5)=="ALTER") {
1336 $DB_site->reporterror=0;
1337 }
1338 echo " .";
1339 $DB_site->query($val);
1340 if ( $DB_site->errno != 0 ) {
1341 echo "<P>Error #[".$DB_site->errno."]<BR>Message: [".$DB_site->errdesc."]<BR>SQL: [".$val."]<p>";
1342 return;
1343 }

3. Between lines 1338 and 1339 insert the following line.

$val[strpos( $val, ";" )] = " ";

4. Now your code will look like:
1335 if ($onvservers==1 and substr($val, 0, 5)=="ALTER") {
1336 $DB_site->reporterror=0;
1337 }
1338 echo " .";
1339 $val[strpos( $val, ";" )] = " ";
1340 $DB_site->query($val);
1341 if ( $DB_site->errno != 0 ) {
1342 echo "<P>Error #[".$DB_site->errno."]<BR>Message: [".$DB_site->errdesc."]<BR>SQL: [".$val."]<p>";
1343 return;
1344 }

If you don't feel comfortable making that change, I have attached the modifed install.php file here.

[Chris M]

Cheers...

I will try that out at a more decent time of the day:)

Satan

[TeddyBare69]

In my rush to get my first fix out I didn't completely test all the functionality. Instead of the fix being a one liner it is a two liner. Since I had the portfolio already installed it skipped part of the process. :)

Instead of inserting just the line:
$val[strpos( $val, ";" )] = " ";

You will need to insert both of the below lines in the same location:
if ( $ending = strpos( $val, ";" ) > 0 )
$val[strpos( $val, ";" )] = " ";


As with before i have attached a new install.php file with the modifications included.

So far the mysql_fetch_array errors you were getting also fixed with this change. If you could give the installer a try with these changes included and let me know the results I would greatly appreciate it.

Sorry for the confusion before.

[Sketch]

get this out of beta and I NEED it :)

Aaron

[Sketch]

I went ahead and installed this manually. Boy that was alot of work. Modded it a bit for my own purposes. I'm using 2.2.25 not 2.2.6 and the footer should be templated instead of hardcoded. Also I made the "portfolio" a link in the cp instead of a header option. I'll tweak this a bit more, but overall nice job.

BTW, you REALLY need to work on the explanations in the paperclip and profile HTML files.....they had me lost for awhile.

Sketch

[TeddyBare69]

Thank you for the comments and suggestions. My hopes were that the installer would work and the documentation wouldn't be needed.
I am hopeing you thought it was a lot of work to put the code in because it is a lot of code :) not because the directions took you in circles :'(

If you are ok with it, I would like to see your mods you made and possibly add them in as an installation option.

[stangpower]

Tried tne installer again, it did not work. Caused a parse error in my member list php file.

Sorry but I will let the others test it on their boards before I try again :D

Ian
http://www.stangpower.com

[TeddyBare69]

The installer was an extra that was supposed to make life easier. I guess I missed the mark on that one. The real magic is in the portfolio. That is were I am most interested in hearing peoples views. If the manual install worked for you than great! If not than that is my priority. To get the manual directions up to speed.

Are you having troubles getting your manual updates working or is it just the installer? Please tell me your users will have a portfolio to use. :)

[Christy]

Well I got it installed manually and everything looks fine. I went to upload a pic for my profile and got the error posted below

[Christy]

Well I added a tmp directory and that fixed that error, but now i get this error

Fatal error: Call to undefined function: imagecreatefromjpeg() in c:\inetpub\wwwroot\forum\viPortfolio.php on line 610

[TeddyBare69]

GD is required for this to work. I should have put that in the release :cry:

You can double check that it actual is compiled in by running phpinfo

http://{your site}/admin/index.php?action=phpinfo

You should be able to find the following
gd

GD Support
enabled

GD Version
1.6.2 or higher

JPG Support
enabled

PNG Support
enabled

[Christy]

well I got the php_gd.dll and put it in the extensions directory and uncommented it out of php.ini and then my php pages dont load so gonna have to figure something out.

[TeddyBare69]

I wish I could help :), I know nothing about the windows side of php. Let me know when you convert to your favorite flavor of unix and I will be ther for ya. :)

Somebody on this board should have and idea though?

[Christy]

Ok, got that installed

everything uploads fine, but this is the result

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

Everything is X'ed out.

Also I cannot delete any existing images, when I go to edit and select the Delete current file and update, it seems like it all go's through, but then i go to that page again and it is still there.

[TeddyBare69]

I went back and tried it on my system also and I am having the same difficulties. I should have this fixed pretty fast. Thanks.

By the way, really awesome looking design on your website.

I will be working on that error message also.

[TeddyBare69]

We have a fix for the deletion not working.

It turns out to be a fairly simple fix. :)


We will be editing two templates:
First template is viPortfolio_edit_editbit.

The very first line of the template looks like this:
<input type="hidden" name="portfolioids [$count]" value="$image[portfolioid ]" />

and it should look like this:
<input type="hidden" name="viPortfolioids [$count]" value="$image[viPortfolioid ]" />

This template is fixed, go ahead and save.

Now for template two: viPortfolio_edit_attachment

Open the template up and look on what should be line 11

[Before]
<input type="hidden" name="portfolioids [$count]" value="$image[portfolioid ]" />

[After]
<input type="hidden" name="viPortfolioids [$count]" value="$image[viPortfolioid ]" />


Christy,
Now that GD is working better for you, can you try and upload more pictures and see if that fixes your missing images problem?

[Christy]

Ok, Delete is now working :)

Everything uploads fine but still red X, ive used jpg and gif
http://www.force137.com/forum/viportfolio.php?userid=1

I noticed that when you click on the thumb, the popup window is the same size as the pic so thats working, just not displaying the images

[TeddyBare69]

Couple things I remembered while I was looking for the delete fix. Keep in mind this first one was meant as a feature. :rolleyes:

the delete functionality really doesn't do a delete. I am going to make that a configurable option on admin control panel and include a purge in the next release. For now each uploaded file has an uploaded date and an expired date. When you delete an attachment the expired date gets set and it doesn't show. This allows for easy recovery of accidents.

While fixing other bugs, I found that the thumbnails being shown were not actual thumbnails but the same size image as the original with the width and height paramater in html changing there size. This has been fixed in the next release. I have only been able to test this on my server with PHP ver 4.1.2 and MySql 4.0.1-alpha-max and GD 2.0.1. I know that this version of PHP uses different GD functionality for creating and resizing images. I have had difficulty in the past with getting the previous version so there will be an option available to disable the next functionality and stay with the old.

Lastly, I am creating a thinner simplier install wizard. I am hoping this will be ready for the next release but no promises.

more updates coming... :smoke:

[Christy]

Ok, I will uninstall and Standby for a future release..thanks

Also, I have PHP 4.1.1 and the php_gd that came with it

[NTLDR]

Hi,

I've managed to install this hack, but with just one problem, I also get the broken images as described above and the error template (invalid upload one) when I try and view the image/txt file.

I have all the GD stuff enabled that was pointed out above, any ideas?

Other then that great hack, congrats.

[TeddyBare69]

I appreciate the congrats but I won't accept it until sombody tells me they have had success!

I have part of the icon fix. The non graphic file uploads. The problem is that a path is not set correctly in the icons table. The next release comes with the ability for administrators to modify the icons assigned to each file type. For this version I have attached an sql file that will update the icons table to correct the path.

partialy good news on the graphic upload broken thumbnail problem. I had been looking at my server for over an hour trying to figure out how to recreate the problem so I could fix it. I am able to recreate the problem, I just don't know why yet. I went to NTLDRs site and grabbed the parameters that his link was passing and tried them on my working installation. With NTLDRs parameters my installation gives the same errors.

All this means is I am almost at a fix. :cheeky:

[TeddyBare69]

======= =======
viPortfolio Version 1.0.4
======= =======

We have a lot of updates here. Along with a couple additions. View below to see what has changed since 1.0.0. Thanks goes out to everybody that has been helping test this product. It has been greatly appreciated. The manual directions have been included in the zip file.

Note for existing users:
Delete the existing viPortfolio directory if you haven't already. Extract the viPortfolio-1.0.4.zip file in the same location. Pull up the http://{yoursite}/viPortfolio/install.php file in your favorite browser. When you run thru the install the first option will be to uninstall the existing version. This is highly recommended. :) Once you have completed the uninstall than go back to http://{yoursite}/viPortfolio/install.php and run thru the install again.

From what I have seen so far the installer works with the viPortfolio specific templates, icons, and database tables. You can then go back and install the manual edits. This will save you alot of time if you choose to take advantage of it.

Changes:
[list=1]
Delete functionality fixed
Added ability to choose whether to archive or delete records added
Added bmp functionality
Thumbnail creation fixed
Admin control options fixed
Added manual install directions/Added to the directions from 1.0.0
Install script - Removed any code that modifies existing templates or php files.
[/list=1]

Credits:
VisibleImpact.com (http://www.visibleimpact.com) Administrative Director and author: TeddyBare69
VisibleImpact.com (http://www.visibleimpact.com) Owner and Designer: sengerdw

Description:
For those that need a separate interface in the user control panel to upload files - download this.

Features:
[list=1]
New profile navigation bar to view a portfolio/upload gallery
New profile navigation bar for members to change their portfolio/upload gallery
Admin and moderators may change descriptions and delete file configuration options maintained in admin control panel.
86 different file types support via either thumbnail or default icon view.
ImageMagick not needed!
Display who uses their portfolio in the members list.
[/list=1]
Demo links:
[list=1]
Members list (http://www.visibleimpact.com/forums/memberlist.php?what=topposters&perpage=15)
Public Profile (http://www.visibleimpact.com/forums/member.php?action=getinfo&userid=1)
Public Portfolio (http://www.visibleimpact.com/forums/portfolio.php?userid=1 )
[/list=1]
Installation Instructions:

Extract the viPortfolio-1.0.4.tgz file which will create a viPortfolio
subdirectory. Upload the directory to your root Web server directory where your forum code is located. From a Web browser run: http://{yourserver}/viPortfolio/forums/install.php and follow the steps.

.: Remove the viPortfolio subdirectory after installation :.

We would appreciate any feedback regarding this hack. Interface, changes for future versions and so on. We will offer support for this hack - we will not be responsible for errors - as always, BACK UP YOUR data base.

We have spent a lot of time on this and all we ask is that our copyright notice remain in tact at the bottom of portfolio pages. Thanks!

Along with viPortfolio we are making use of the viInstaller version 1.0.0. The viInstaller has not had the amount of testing that viPortfolio has. With that said we are looking for your assistance in notifying VisibleImpact.com (mailto:support@visibleimpact.com) of any error messages or difficulties you may have with the viInstaller.

viInstaller known issues:
[list=1]
Editor inoperable
workaround: Use your favorite editor when asked to edit a file or template
Uninstall option may not completely uninstall app
workaround: Don't uninstall :)
[/list=1]

viPortfolio v1.0.4 developed by: VisibleImpact.com (http://www.visibleimpact.com)

[Christy]

Ill install it after work and let ya know :)

[Kars10]

Nothing works at all. First ive tried your install.php.
Nothing happend, than i removed all and do it manuelly, and nothing happend at all....
Problems-Problems-Problems.
I dont see the Admin-settings. I see the Link to the settings in Admin-CP but the seetings self dont show.
in my settings table, the settings where build.
Ive make all youre manual says but one error is hunting the next...Believe me this is not my first hack ive installs...

[TeddyBare69]

Hello Minifreunde,

Sorry to hear you are not having fun with this hack. :speechless:

If you could define "nothing" with more detail I can fix it. ;)

Version of PHP, MySQL, WebServer, vBulletin would help. Also screen shots of any error messages you are getting. A link to the website you installed to would be the most help.

This is not my first program I have written but it is my first hack I have written for vBulletin. I appreciate you taking your time to help work out the bugs on this hack. ;)

[Kars10]

Ok. The first problem is, that i didn?t see the "portfolio-link" on user-options, second problem is, i didn?t see the settings in admin cp. The portfolio.php is shown (so i think) correctly...
i have add all tables inside the zip-file. i have all templates in all styles ive offered. So what can the problem be??
Is there modification on php-files needet?? in youre readme i can?t see anything...
I ve want to install on 2.2.5 with Linux / PHP v4.1.1 and My Sql v3.23.51
Please help me... :confused:

[Christy]

ok, php 4.2.2 installed and so i know i h ave the latest gd, heres my error

Warning: imagecreatetruecolor(): requires GD 2.0 or later in c:\inetpub\wwwroot\forum\viPortfolio.php on line 628

Failed to create destination image.

seems to just get that error with jpg files, i uploaded a gif and txt fine but still shows x'ed out on pics

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

[TeddyBare69]

Minifreunde,
In the install directions there is a reference to two other files. the viPortfolio.profile.directions.html and viPortfolio.paperc.directions.html. The only option with those is to manual install them. You have to edit both php files and templates. You can start with http://{yoursite}/viPortfolio.php?userid=1 to see if things are working.

[TeddyBare69]

In the last couple hours I have read more about GD and graphics than I ever wanted to know :)

Hopefully this will fix it.

This fix only updates the viPortfolio.php file. I am attaching a zip file with just that php file in it. If you could extract this one over the previous one and verify that you now have version 1.0.5.

There are some errors in this version. I haven't not pinpointed the exact cause yet. I get error messages saying: Cannot allocate palotte or Cannot allocate colors. Then a try a different image of the same type and it works fine.

I still have not found out why people are not see the thumbnail images instead seeing a broken link. I am still hopeing the thumbnail creation and the broken links are related.

For those a little hesitant that I even have it running on my server ;) My test server is Portfolio Test Server (http://63.196.104.166/dev1/viPortfolio.php?userid=1&action=view) This url will not be valid for very long. I randomly get a new ip address and even more frequently install and uninstall the portfolio. I will leave this available for the next few days though.

[TeddyBare69]

Here is the real version 1.0.5

[Kars10]

Hello Teddy!
Ok if checked youre instruction, and now i see the upload.
The Admin-CP Settings are currently hidden?? I don´t know what can the Problem be.
When i tried to upload a file, this is the result!

[Kars10]

Heres a Screenshot from Phpmyadmin. You see the Pic is saved there...

[Kars10]

And here is the result when i click on the link directly after the upload-options. My Filesize is about 9 k i think....

[Kars10]

Here is my admin-cp....you see, the options?? :confused:

[TeddyBare69]

This is great. I can help fix almost every one of thse problems. ;)

1. Control Panel Settings. Since the settings are already in the table that means you must have ran install_settings.sql. Great. I added additional manual steps to complete the settings update.
Brief directions: Settings won't show until there is a value greater than 0 in the displayorder field. populate that field with a value (I picked max(displayorder) and you are done.
Long directoins:
1. Execute the following query
SELECT MAX(DISPLAYORDER) FROM SETTINGGROUP;
2. Add 1 to the number that is shown and replace the words <i>{highnumber}</i> with the displayed number + 1:
UPDATE SETTINGGROUP SET displayorder=<i>{highnumber}</i> WHERE title LIKE 'viPortfolio%';


What you see after you have uploaded your image is the major issue everybody but me has been getting. That has been part of the reason it hasn't been fixed. I am having an extremely difficult time recreating the problem. Right now there is no fix.

the error message is incorrect. Every time I fix it it somehow gets overwritten by the time I upload to the server. I have gremlins here ;) So here is the fix, I am going to make sure it will also be fixed in the next release.

open the viPortfolio.php file. On the 6th line you will see
$message="
You have exceeded the 75k file upload limit. If you are
having difficulties optimizing your files, we have multiple
people ready with helpful suggestions.
Thank you.
";

replace everything from line 6 thru line 11 with the following line:

$message = $msg;

This will get you more accurate error message.

[Kars10]

[i]1. Control Panel Settings. Since the settings are already in the table that means you must have ran install_settings.sql. Great. I added additional manual steps to complete the settings update.
Brief directions: Settings won't show until there is a value greater than 0 in the displayorder field. populate that field with a value (I picked max(displayorder) and you are done.
Long directoins:
1. Execute the following query
SELECT MAX(DISPLAYORDER) FROM SETTINGGROUP;
2. Add 1 to the number that is shown and replace the words <i>{highnumber}</i> with the displayed number + 1:
UPDATE SETTINGGROUP SET displayorder=<i>{highnumber}</i> WHERE title LIKE 'viPortfolio%';[/B]

I have alright done this. But it dosen?t help me. Ive see the Link in the CP, and when i click i get the result from the last Screenshot...
I Promise i did all you explain... :ermm:

[TeddyBare69]

Originally posted by Minifreunde


I have alright done this. But it dosen?t help me. Ive see the Link in the CP, and when i click i get the result from the last Screenshot...
I Promise i did all you explain... :ermm:

Never once thought you were trying to pull a fast one on me :o All this time you are thinking you are going to get a 50% discount on the cost of the software :nervous: Little did you know it was free :classic:

I believed you sooooo much that I went back and double checked what I wrote and then reread what the installer was doing and you are absolutely correct.

I missed a third step. Thanks for being persistant! :)

UPDATE setting SET settinggroupid = <i>{highnumber}</i> WHERE settinggroupid = 65534

Sorry about the frustration and I will try and keep my simple mistakes at a minimum so we can actually get this working. :rambo:

[Kars10]

Hi Teddy!!
Ok, now i got the options!! This point is going to you!! Great...
but look at my Screen-Shot :knockedout:

[Kars10]

here i get no options to choice between...
Hope i dont confuse you. :cry:

[NTLDR]

After trying to update to the latest vesion and manually editing the DB I have got this hack to work almost properly, the replace donsen't seem to work for me, nor do JPEG images, I get the following error with 1.0.5:

Warning: Color index out of range in ./viPortfolio.php on line 725
Setting pixel for color1

Other than that it seems to be working fine.

[Kars10]

Now if i want to upload something...i get a #!@j?! Parse Error!!
Oh man, this is wierd!! Please have a look at the Screen-Shot! :(

[TeddyBare69]

Couple more fixes.

NTLDR, ALL
I believe I have fixed the color allocating problem.
There are a couple other fixes also so I am uploading a new version 1.0.7.
This version has the color fix, better PHP version checking support and control panel fixes.

Minifreunde,
take a look at the permissions and owner of http://{forum basedirectory}/tmp . This directory needs to be set with write access of your webserver userid. For me that user is nobody, in production it is web. You would be safe setting the permissions to 777 in unix or granting permissions to all in windows.

Looking at the screen shot of your settings, looks like multiple installs. You can clean out the settings for viPortfolio with the following SQL.
DELETE setting
FROM setting s, settinggroup g
WHERE s.settinggroupid = g.settinggroupid
AND g.title like 'viPortfolio%';

then you will need to reinsert the settings by executing the sql in viPortfolio/database/insert_settings.sql.

then execute the following sql
SELECT settinggroupid, displayorder
FROM settinggroup
WHERE title like 'viPortfolio%';

ensure that the displayorder is not 0 and use the number in settinggroupid column as highnumber for the following sql.

UPDATE setting
SET settinggroupid = <i>{highnumber}</i>
WHERE settinggroupid = 65534

This will be fixed in the next version.

[Kars10]

Hello Teddy, this was the result of the first query... :o

[Christy]

Well, im stumped. I just uninstalled then reinstalled with latest vesion and am still getting the x's for the pics

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

I should be doing everything write, only thing I dont do is add the links for the users as im waiting till i know it works.

I install tables, install templates, upload viportfolio.php and this time i also upped gdthumb.php even though im not sure what it was for.

[NTLDR]

Originally posted by TeddyBare69
I believe I have fixed the color allocating problem.

This seems to be far worse for me I get:

Warning: Color index out of range in /.../viPortfolio.php on line 633

Warning: Color index out of range in /.../viPortfolio.php on line 634

Warning: Color index out of range in /.../viPortfolio.php on line 635

Warning: Color index out of range in /.../viPortfolio.php on line 636

In a constant loop now when I try to upload a JPEG Image :( However the image does seem to have uploaded, but I just get a black 100*100 square as the thumbnail for it.

Uploading to replace a file doesn't work either still.

[TeddyBare69]

for Minifreunde,
don't you have mysql 4 or newer?

select *
from settinggroup
where title like 'viPortfolio%';

delete
from setting
where settinggroupid = {number from above}

sorry about the mix up. the mysql manual said the previous sql was compatible with mysql 4.0.2 and above.

NTLDR,
Have you tried other images?

can you either upload your graphic to this site or log onto my test board and upload the image there.
Test site (http://63.199.224.251/dev1/)
username guest
password guest

Christy,
If you could try and login and upload your image here also. I haven't tried fixing the missing image problem directly because I can't recreate it here.

[Christy]

Ok I logged into your site and was able to upload them both fine. I just used your installer logo as a gif and jpg

Not sure whats up with mine, I also tried using php_gd2.dll and get the same results, heers an image of my phpinfo

[TeddyBare69]

The gdthumb.php was a php file I was using to testing the thumbnail functionality. I have modified it a little bit more to make it a useful testing tool for you also.

I have attached the gdthumb.php file below. If you could copy this to you viPortfolio/ directory and run it with http://{yoursite}/viPortfolio/gdthumb.php it will try and convert the installerlogo.jpg file to a thumbnail and save it to a file with a link to be able to view the new file.

This will verify if it is my code or something to do with GD or PHP.

[Christy]

Ok, ran it and it outputted this

Creating blank thumbnail image
starting resampling

using greater than 2.0 gd

Writting thumbnail to ./th0.jpg

and the link went to a thumbnail of your logo, so it worked

[NTLDR]

Originally posted by TeddyBare69
NTLDR,
Have you tried other images?

GIF images work fine, I get the thumbnail and the link to the picture works, its just JPEGs, the one I use is your installer logo.

[TeddyBare69]

so I guess I got some work in front of me :) There has to be something I missed in the manual directions that my installer is doing? ;'(

My plans are to get the installer working figure out what was missed in the manual directions. I have an idea what it might be but I don't think I will have an update until tomorrow morning.

If anybody needs me I will be in coding land :)

[Christy]

well, seems it was my fault. I have been doing it manually and must have missed something. I just did it with the installer and everything works perfectly :)

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

[TeddyBare69]

I just went out and looked at it :) That is great!

[TeddyBare69]

The timing on this probably isn't the best but I found out what the problem with the icons not showing up. It turns out that I got the directions out of order. You have to run the install_mimes.sql before the install_icons.sql. The icons file sets the mime types with the default icons. Without the mime types, nothing happens.

So now I believe the outstanding issues are still allocating colors? NTLDR, are you still having this issue?

Minifreunde,
were are we at with your install?

[Kars10]

@ Teddy, ok Christy got it with the installer working. If i want to clean my DB from all ViPortfolio and run the install again, what must i exactly do. I dont want to miss a table or produce a major error.
@ Christy, witch version of viPortfolio did you use?? Some help from you? :confused:

[TeddyBare69]

Minifreunde,
I know I have made a couple mistakes already but I can still help if you want? :disappointed:

I have taken out the parts of the install.php that didn't work. I believe she would have run the install.php script in your viPortfolio/ directory. While walking thru the install , on the third screen, it will ask you if you want to uninstall. There will be red box with a button that says "UNINSTALL viPortfolio Application". Click on that button and the next screen will show you a list of things that are being deleted. Go to the next screen and everything is gone. Now rerun the install.php script and again and go thru the steps to install.

You also have choice B :) If you rerun the install_icons.sql file this will update your mime table and you will see icons in your portfolio.

Version 1.0.7 is the latest and greatest. I have updated the first post in this thread with the new version if you still need to download it.

[Kars10]

@ Teddy, i want youre help. I ask christy because he got it working.
Ok i download youre latest version and test it!! :)

[Kars10]

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

[Christy]

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

[NTLDR]

Originally posted by TeddyBare69
So now I believe the outstanding issues are still allocating colors? NTLDR, are you still having this issue?

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

[Kars10]

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??

[Brad]

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

[Christy]

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/showthread.php?postid=280699#post280699

[TeddyBare69]

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. :(

[TeddyBare69]

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

:fingers crossed:

[Kars10]

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.
* Minifreunde loves this Hack!! :)

[TeddyBare69]

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. :)

[Kars10]

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. ;)

[TeddyBare69]

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.

[TeddyBare69]

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.

[Warrior]

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?

[Martin64]

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:

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Debugging Level', 'ploglevel', 1, 'Logging Level for changing the amount of debug information the portfolio displays', '', 1 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Total File Upload Limit', 'ptotalimages', 9, 'The number of files each user is allowed to upload', '', 2 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Total Files Shown per Row', 'pimagesperrow', 3, 'The amount of files horizontaly displayed', '', 3 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Maximum Image Size', 'pmaximagesize', 75, 'The maximum kilo bytes allowed for each upload', '', 4 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Allowed Image Mime Types', 'pimagetypes', 'doc txt gif jpg jpeg png bmp', 'The supported file types for this forum', '', 5 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Thumbnail Width', 'pthumbwidth', 100, 'The width of the thumbnails that are created from original images', '', 6 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Thumbnail Height', 'pthumbheight', 100, 'The height of the thumbnails that are created from original images', '', 7 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Max Length of Descriptive Text', 'ptextlength', 100, 'The maximum allowed characters for each file description', '', 8 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'The point that a long sentence gets split', 'plinewrap', 30, 'The maximum width of each line before a line is seperated and placed on the next line', '', 9 );
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL, 65534 , 'Choice between deleting files permanently or archiveing', 'pdeleteimages', 'delete', 'If you want to permenantly delete archive files on user requests choose yes, if you would like files to be archived and still remain in the database choose no.', 'yesno', 10 );

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

[Kars10]

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:

[Martin64]

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

REPLACE this:

<script language="javascript">
function popUp(URL, WIDTH, HEIGHT) {
day = new Date()
id = day.getTime();
eval("page" + id + " = window.open(URL, \"" + id + "\", 'toolbar=0,scrollbars=0,location=0,statusbar=0,men ubar=0,resizable=1,width= " + (WIDTH+20) + ",height=" + HEIGHT + "');");
};

</script>

with this:

<script language="javascript">
function popUp(URL, WIDTH, HEIGHT) {
day = new Date();
id = day.getTime();
eval("page" + id + " = window.open(URL, \"" + id + "\", 'toolbar=0,scrollbars=1,location=0,statusbar=0,men ubar=0,resizable=1,width= " + (WIDTH+40) + ",height=" + (HEIGHT+30) + "');");
};

</script>

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

[Martin64]

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:

cols="20"

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

cols=100"

in both templates.

Search for:

cols="40"

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

cols="100"

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:

<smallfont>$image[filename] $image[text]</smallfont>

REPLACE with:

<center><smallfont>$image[text]</smallfont></center>

[Kars10]

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:

<script language="javascript">
function popUp(URL, WIDTH, HEIGHT) {
day = new Date()
id = day.getTime();
eval("page" + id + " = window.open(URL, \"" + id + "\", 'toolbar=0,scrollbars=0,location=0,statusbar=0,men ubar=0,resizable=1,width= " + (WIDTH+20) + ",height=" + HEIGHT + "');");
};

</script>

[TeddyBare69]

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! :)

[Martin64]

Originally posted by Minifreunde
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:

<script language="javascript">
function popUp(URL, WIDTH, HEIGHT) {
day = new Date()
id = day.getTime();
eval("page" + id + " = window.open(URL, \"" + id + "\", 'toolbar=0,scrollbars=0,location=0,statusbar=0,men ubar=0,resizable=1,width= " + (WIDTH+20) + ",height=" + HEIGHT + "');");
};

</script>


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).

For the text wrapping functionality. I have a setting in the admin control panel to change the length of the text

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

[TeddyBare69]

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.

[Martin64]

Ah right, I see it now. Thanks :)

[Martin64]

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:

<a href="viPortfolio.php?&userid=$userinfo[userid]&action=view"><img src="images/paperclip.gif" alt="View $post[username]'s portfolio" border="0">

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 :)

[TeddyBare69]

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. :)

[TeddyBare69]

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! :)

[Kars10]

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.

[Kars10]

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

[Apok2002]

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.
SELECT MAX(DISPLAYORDER) FROM SETTINGGROUP;
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?

[Apok2002]

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?

[TeddyBare69]

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

[Apok2002]

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.

[Apok2002]

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

Cleaning up old mime types

Inserting default mime types

Configuring default icons

Copying icon files

Warning: mkdir() failed (Permission denied) in /home/apok/public_html/forums/viPortfolio/install.php on line 626

../images/15
animation.gif to ../images/15/animation.gif
Warning: Unable to create '../images/15/animation.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

generic.gif to ../images/15/generic.gif
Warning: Unable to create '../images/15/generic.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

pic.gif to ../images/15/pic.gif
Warning: Unable to create '../images/15/pic.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

text.gif to ../images/15/text.gif
Warning: Unable to create '../images/15/text.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

zip.gif to ../images/15/zip.gif
Warning: Unable to create '../images/15/zip.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631


Warning: mkdir() failed (Permission denied) in /home/apok/public_html/forums/viPortfolio/install.php on line 626

../images/75
animation.gif to ../images/75/animation.gif
Warning: Unable to create '../images/75/animation.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

generic.gif to ../images/75/generic.gif
Warning: Unable to create '../images/75/generic.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

pic.gif to ../images/75/pic.gif
Warning: Unable to create '../images/75/pic.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

text.gif to ../images/75/text.gif
Warning: Unable to create '../images/75/text.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

zip.gif to ../images/75/zip.gif
Warning: Unable to create '../images/75/zip.gif': No such file or directory in /home/apok/public_html/forums/viPortfolio/install.php on line 631

../images/attach
attach.gif to ../images/attach/attach.gif
Warning: Unable to create '../images/attach/attach.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

bmp.gif to ../images/attach/bmp.gif
Warning: Unable to create '../images/attach/bmp.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

gif.gif to ../images/attach/gif.gif
Warning: Unable to create '../images/attach/gif.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

jpeg.gif to ../images/attach/jpeg.gif
Warning: Unable to create '../images/attach/jpeg.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

jpg.gif to ../images/attach/jpg.gif
Warning: Unable to create '../images/attach/jpg.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

png.gif to ../images/attach/png.gif
Warning: Unable to create '../images/attach/png.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

txt.gif to ../images/attach/txt.gif
Warning: Unable to create '../images/attach/txt.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

zip.gif to ../images/attach/zip.gif
Warning: Unable to create '../images/attach/zip.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

blank.jpg to ../images/blank.jpg
Warning: Unable to create '../images/blank.jpg': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

paperclip.gif to ../images/paperclip.gif
Warning: Unable to create '../images/paperclip.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

space.gif to ../images/space.gif
Warning: Unable to create '../images/space.gif': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

[Apok2002]

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

Removing viPortfolio applications
viPortfolio.php
Copying application code

viPortfolio.php to ../viPortfolio.php
Warning: Unable to create '../viPortfolio.php': Permission denied in /home/apok/public_html/forums/viPortfolio/install.php on line 631

copy complete

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.

[Apok2002]

Also, when doing the manual install of the paperclip addon, in the memberlist.php, where it says to find:
$userinfo[pmlink] = " "; })
This is not found.

This is what is here instead:

if ($userinfo[receivepm]) {
eval("\$userinfo[pmlink] = \"".gettemplate("postbit_sendpm")."\";");
} else {
$userinfo[pmlink] = "&nbsp;";
}

Where in the above code does the following go?

// Add a paperclip to the left of the username in the memberlist.
$attachcount=$DB_site->query_first("SELECT COUNT(*) AS count
FROM viPortfolio
WHERE userid = '".$userinfo['userid']."'
AND enddate is NULL
");
if ( $attachcount['count'] > 0 ) {
if ( $attachcount['count'] > 1 )
$alt="Member ".$userinfo['username']." has ".$attachcount['count']." attachments in there portfolio.";
else
$alt="Member ".$userinfo['username']." has ".$attachcount['count']." attachment in there portfolio.";
$attachment = "<A HREF='$appname.php?s=$session[sessionhash]&userid=".$userinfo['userid']."&action=view'>";
$attachment .= "<IMG BORDER=0 SRC='https://vborg.vbsupport.ru/vbimages/paperclip.gif' ALT='".$alt."' TITLE='".$alt."'></A>";
} else {
$attachment = '';
}
// Add a paperclip to the left of the username in the memberlist.


--------------------------------------
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: Next, click on the tab called memberlist above the text box on your right.
Go to line number 52 and look for:
(Three page down keys) colspan="6"
Replace the number 7 with a number 6


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. :(

[TeddyBare69]

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.

[Apok2002]

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:

Database error in vBulletin 2.2.6:

Invalid SQL:
select viPortfolioid, filename, file, text,
cthumb, content_type, thumb, iconpath, largeicon, supported,
i.title, iconpath, width, height, ext
FROM viPortfolio p, mime m
LEFT JOIN icons i ON m.iconid = i.iconid
where p.mimeid = m.mimeid
and p.enddate is NULL
and m.enddate is NULL
and i.enddate is NULL
limit 1 ORDER BY p.viPortfolioid
mysql error: You have an error in your SQL syntax near 'ORDER BY p.viPortfolioid ' at line 11

mysql error number: 1064

Date: Tuesday 13th of August 2002 02:15:10 AM
Script: http://www.ez-company.net/forums/forums/viPortfolio.php
Referer:


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.

[TeddyBare69]

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

that would work better

[TeddyBare69]

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

[TeddyBare69]

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. :)

[Kars10]

Well APOK, if you read the last Posts, you will find exactly the problems you tell us here and the answers....;)

[Martin64]

Originally posted by Apok2002
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?

It is "settinggroup", not "SETTINGGROUP". Lowercase :)

Try this instead:

SELECT MAX(DISPLAYORDER) FROM settinggroup LIMIT 0, 30

[TeddyBare69]

Very important, in version 1.1.0 DO NOT RUN the upgrade......

Do an install instead. There is a bug that will delete all of you forum settings. If I am too late on this for anybody tell me and I will do everything I can to help you fix your settings.

PLEASE do a backup before ANY and ALL hack installs

[TeddyBare69]

Sorry if I scared anybody. I got it fixed now. I had found the bug prior to uploading it and had fixed it, so I thought :rolleyes:

This time I made sure :nervous:

In the process I fixed the installation of the settings so now when you install or upgrade it will have the settings setup correctly. One note though. Currently if you upgrade, any changes to the settings will be deleted. Any changes made to the templates will also be deleted. I am trying to figure out a good way to know if there are any modifications done before I start updating. Its harder than it sounds :(

I will do my best not to post anymore messages like the previous. Again, thanks for your support! :classic:

[Apok2002]

Well, I used the upgrade before your last 2 posts. Is the correction in that download? Or did you re-upload the files AFTER you had already submitted the 1.10?

Also, I think I will have to just do a complete uninstall, then install manually.

[TeddyBare69]

Hey Apok2002,

If you give me a couple hours, I have some more really good fixes for the installer. I just need a little more time for testing.

I have two questions for you. Since you went thru the upgrade.
1. Please tell me you either backed up prior or are installing on a test forum that means nothiing to you :fingerscrossed:

2. Have you gone into the admin control panel and seen if you have your settings for your forum?

Let me know were you are at? :(


I have been fixing most all of the bugs that you and others have reports. I have to fix the permission bug next. and then the major ones will be gone.

Just know I appreciate your help. I hope this isn't too frustrating for you all.

[Apok2002]

I have a backup from several days ago. :( But on a side note, I don't see any forum setting changes now....even after the update. What kind of settings are you referring to that were supposed to be affected?

Also, there are NO settings in the Admin CP for viPortal. My AdminCP Forum settings area seems to be fine. Nothing changed, nothing broken.

[Warrior]

I just want to add a few things here :ermm: :

The viPortfolio is good to go. It is an outstanding addition for your members to display images and other files. And after v1.1.0 the portfolio pages now load many times faster because the thumbnails went from HTML resize to a 3k crop. And still with no ImageMagick required.

This IS A BETA forum. :tired: Please do not install on an active board unless you totally understand the risks and have backed your board up right before.

We have been running viPortfolio on our site for a few weeks and have ironed out any serious bugs. The biggest thing right now is this installer. And because this hack requires db tables to be created, PHP and template edits, it has taken some time to finish...

Thanks for all your installs and help thus far. We would like to hear from anyone who has set up a test board of < 2.2.6 versions so we can measure the earlier compatibility.

[Apok2002]

OK...I'll work with it more tomorrow or the next day or so. But on a side note...I know this is merely a portfolio...and it's a great one btw...perhaps the best I've seen! But what about somehow incorporating it as a gallery as well...so that all those who have a portfolio, can be listed in a public gallery..say using their first pic as their thumbnail for their particular gallery.

I know there are other galleries out there...but I think this has the potential to top them all. Esp since it can display so many different media types and it IS a quick loader of images/media.

Any plans for this type of integration?

[Warrior]

Having a page for random uploads from the db is a good idea. We will need these ideas for our second version.

Because this is v1.x.x, more is sure to come once we get this installer polished off and the first version is out the door. TeddyBare69 is integrating a version control system to help with future upgrading.

A gallery would be great. A random table mixture of all the the users uploads with the descriptions. A group portfolio - perhaps even by usergroups. We'll take notes once this one leaves the BETA forum and graduates to the Full Release Forum. Which should be soon due to the good feedback so far...

[Warrior]

The installer will now use Chen's vbHacker as an install option to make it really easy. If you do not have this - you can get it here:

vbHacker (https://vborg.vbsupport.ru/showthread.php?threadid=36378) :banana:

[TeddyBare69]

You heard it right here first! As an added convience to our fellow hackers/hackettes we have added support for Chens illustrious vbHacker. This is a pretty impressive hack all in itself. So now, if you have had troubles in the past getting the Paperclip or Profile hack to work, this might be your ticket in. :D I am still working on the permissions problem or atleast determining there is a permission problem and handling it appropriately. I wanted to get this out as quickly as possible though.

[TeddyBare69]

I have finaly fixed the permissions problems when copying files. Now either the install.php file can fix the permissions for you or it will pause the install and tell you what permissions it needs changed. I hope this helps.

[Apok2002]

I tried to run the install program (I deleted all previous tables and files) to get this set up again. While trying to install tables, it said:

Creating tables...

The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1064

Error description: You have an error in your SQL syntax near '; ' at line 1

Here is the full sql query:


No full sql query was given.

[TeddyBare69]

Looks like my gremlins attacked me again :angry:

I have uploaded a new version that should fix that problem for good. I took my arc welder out and made sure that piece of code would stay in there this time! :eek:


The vbHacker addition is the last part of the install. I have included that for the purposes of modifying the existing templates and source code files. With all the SQL code and templates that I had it was easier to only have part of the install be handled by vbHacker.

The error you got with the ';' problem. Have you seen that error before? I am trying to figure out what causes the error. I have the same problem on my production server but not on my test server. I want to make my test server have the same requirement since most people are setup that way.

[Apok2002]

lol Bear...ok, I'll try it again. And no, I've NEVER had a ";" issue before...and I have about 20 hacks or so installed that work just fine that hav never receieved that error.

[TeddyBare69]

somebody has had to have seen it before. I seem to have the error coming up on everybodies database but mine!

[TeddyBare69]

Apok2002,
I was just going over the past posts and noticed that I never responded to your idea. To expand this portfolio into a gallery. That would be cool. Could have different groups by the file type/file owner/update date/etc... I also would like to incorporate a software package called CVS. Concurrent Versioning System. This would allow for multiple versions of the same document with maximizing the storage by only storing the diferences between the old file and the new file.

Just an endless list of wants....:D

I think I will get this out of Beta first though. How did you install go? :fingerscrossed:

[Warrior]

We need at least one Beta installer on here with a successful install. The download is updated and in our latest bug-free environment - unless someone comes up with one.

Please note: the installer has change to a much easier interface since 1.1.x.

Thanks for everyone who has helped us get this past Beta - I know there are a lot of forum owners that could use this hack.

BTW, we never posted the user cp screen shot. Here it is:

[Apok2002]

Creating tables...




The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1064

Error description: You have an error in your SQL syntax near '; ' at line 1

Here is the full sql query:


Using the installer, I got the same error. What is the 'work around' other than using manual install?

[TeddyBare69]

ok now this is starting to bother me!

I posted this issue on the hackers help forum. So far there hasn't been any conclusive thoughts but I did have a comment form Dark_Wizard, he also says that his database had a problem with these same files also and did this same fix and it worked for him.

I got my fingers crossed on this one. Sounds like it could finaly work for ya.

I am sending you the updated viPortfolio/database/ files. Take the attached zip file and extract the contents into the viPortfolio/database/ directory on your server. this will overwrite all the files in that directory.

Now you can go ahead and rerun the install.

These fixes will also be in version 1.2.3 and above.

[Apok2002]

Did that...and got the EXACT same message. No change.

[Apok2002]

Should any of the files be a certain CHMOD that may not be when I upload them?

[Dark_Wizard]

Originally posted by Apok2002
Did that...and got the EXACT same message. No change.

It wouldn't create the tables? What version of PHP and MySQL are you using?

[Apok2002]

PHP 4.2.1

Mysql 3.23.45

And yes...it would not get past stage 1 of install...tables could not be created.

[TeddyBare69]

Apok2002,
This was definately not in the plans. Did you not read the plans before we started this beta testing. The errors can last more than three days. Your time is up.

I am going to go and fix the error reporting in the install script. Unless I see something that shouts out error there won't be any fixes in the version I send up. It will hopefully just give more exact information about the problem it is having. taht will be posted within the next hour.

For any body else. If you are recieveing the same error you are more than welcome to run this new install and see if you get the same reponses as everybody else. I would really love to find this bug and (Politicaly Correct of course) squash its guts out!

Be back in a bit

[Apok2002]

When running:

select settinggroupid, title from settinggroup where title like 'viPortfolio%';

I get 2 usergroups, #'s 45 and 46. So I'm assuming it's safe to use "47" as the high number?

[Apok2002]

yayyyy! Admin settings finally showed up. But...They are listed 2x. I'm assuming this may have to do somethingw/ my above post. How do I remove one of those entries for viPortfolio Settings in the admin cp?

[TeddyBare69]

So you found two entries in the settinggroup table called 'viPortfolio Settings'. One of those settinggroupids you used to assign to the settings in the setting table.

I am going to pick 46 for this example. That would make 45 an extra row.

delete from settinggroup where settinggroupid = 45

This will get rid of the extra row.

This presents me with a question though. How are you getting the settings in the table but not able to create other tables? Is there a permission problem or something that you have on your database? I am guessing you have already validated that. How are you getting the settings into the database. executing something like below:

\. install_settings.sql

from a mysql prompt or

mysqladmin install_settings.sql

from a command prompt?

Either way, I have attached the new install file with the addtional debug messages in it. We should now exactly what, were, why, and who to shoot after you run this.

Thanks

[Apok2002]

I'm using myphpadmin. I will open install_settings.sql in a web browser/text editor, then copy/paste into myphpadmin.

Perhaps that is the cause? It's the only way I know how to.

[TeddyBare69]

Apok,
Did the new install give the same errors? I seen one or two places in the install program that were possible bug hideouts until I crushed them. :D I am hoping all you get is a bunch of debuggin messages and a have a nice day message :D

Inquiring minds want to know .

[Apok2002]

Getting closer. I only got this error:

Notice [1024] Could not copy file /home/apok/public_html/forums/viPortfolio/viIcons/blank.jpg to /home/apok/public_html/forums/images/viIcons/blank.jpg

Warning message on line 712 of file /home/apok/public_html/forums/viPortfolio/install.php , PHP 4.2.1 (Linux)


viIcons/blank.jpg to /home/apok/public_html/forums/images/viIcons/blank.jpg


I then went to the Control Panel...and the box w/ the link for Edit Portfolio is all black (can't see the link). And when you click it, you get a page not found error.

You get this error when you try to edit your portfolio via your profile:

Parse error: parse error, unexpected $ in /home/apok/public_html/forums/member.php on line 1490

There weren't any other errors that were displayed during the install. And I installed the Paperclip and Profile hack via vbhack

[TeddyBare69]

I have some workarounds for you. These fixes are here but in the full download. If you were to get the 1.2.3 version those errors would be gone.

first workaround: :D
edit member.php

go to the very bottom of the file you should see this:
// parse this next line with eval:
$sendtoname=$destuserinfo[username];
eval("standardredirect(\"".gettemplate("redirect_sentemail")."\",\"usercp.php?s=$session[sessionhash]\");");
}
?>

You are supposed to have another } above the ?>. Insert the } on the line before the ?> so that you have:

// parse this next line with eval:
$sendtoname=$destuserinfo[username];
eval("standardredirect(\"".gettemplate("redirect_sentemail")."\",\"usercp.php?s=$session[sessionhash]\");");
}
}
?>

About your link in the control panel being black.

I am going to have to look into that a little further. Can you get the link that menu choice points to? I think if you float over the link you should be able to see were it points to. If you have to type it I don't need the ?s=1235098274350943 stuff. mine points to http://{mysite}/dev1/admin/options.php?t=0#settinggroup36

that is after I took out the session information, ?s= stuff

[TeddyBare69]

We need to give a Humungous thank you to Dark_Wizard. He took one look at my code and new I should be applying at burgerking come monday. :D

Thanks for the eagles eyes Dark_Wizard, that was a great catch on figuring out what was wrong!

[Apok2002]

Uninstalling, and will do a clean install of the latest version. :) We're gonna get this damnit! lol

If it gives probs w/ the usercp again, I'll post it. It was definately the usercpnav template. Also, the black box appeared again in the member profile where Posts were. You couldn't see how many posts there were. I'll make a screen shot if it happens again.

*crosses fingers*....

[Apok2002]

ack! It went back to the first error above:

Creating tables...




The script reported errors in the installation of the tables. Only continue if you are sure that they are not serious.

The errors were:

Error number: 1064

Error description: You have an error in your SQL syntax near '; ' at line 1

Here is the full sql query:



It's the semicolon error again. I can use the install.php update that you posted earlier..but I was under the impression that it was included in this .zip file. I'll wait for your response before I proceed.

[Apok2002]

Installed 1.2.5 fine...but....when I try to access anyone's profile...I get this error:

Parse error: parse error, unexpected $ in /home/apok/public_html/forums/member.php on line 1490

I also get that above error, for the 1st 4 options in the the User CP.

The Edit Portfolio link returns w/ a Page not Found error. This is the url it tries to go to:

http://www.ez-company.net/forums/viPortfolio.php?action=edit

(aslo, the black box appears again, I'll post a screen shot)

The black box aslo appears in the Member list where the Posts column appears.

And the columns are incorrect in the member list (screen shot coming).

Also, the viPortfolio.php file was never installed, I manually uploaded it.

EDIT
After I uploaded the viPortfolio.php file, I was able to edit the Portfolio via the darkened link in the UserCP. This was the ONLY change however. All of the other mentioned bugs are still there.

[Apok2002]

Here is the memberlist. See how the catagories are all misaligned? Also, the last column is blackened...how do I fix?

memberlist.JPG removed...

Below is the UserCP. The first 4 options don't work (they give you the error mentioned above). Also, the last column is darkened. I have 3 themes to select from on my site...however, since I can't access the Options, I can't select a different theme to see what they look like.

usercp.JPG removed....

EDIT

I removed the pics since I changed servers. If you want them back up Teddy so you can reference what I'm talking about I can upload them and link them to the new server, np.

[Apok2002]

Making some progress though. Earlier I had thought that all the options in the UserCP didn't work. I was wrong. The last 4 do work. Including Edit Portfolio (the darkened box).

Here is a ss of it. How do we get rid of all the Q's?

portfolio.JPG removed... (see above post)


EDIT

Also just noticed, that the viPortfolio Settings in the AdminCP do not show. The link for them is there...but when you click on it...it takes you down the page where they SHOULD be...but there is nothing there except the catagory name "viPortfolio Settings" followed by the Save Changes and Reset buttons.

[TeddyBare69]

I am looking into these issues. I should have some fixes as early as monday.

[Dean C]

whoa this still has errors :(... can't wait for the stable version

[TeddyBare69]

To all you testers patiently waiting for me, I THANK YOU. I had some events going on that were definately not planned.

On the bright side, I have fixed what I believe to be all the bugs in the add on hacks. These bugs were caused only if you use vbhacker to install the additional features. Just to ensure no confusion, these bugs were due to my hack files not vbhacker. I believe in taking credit for good and bad. Below I have placed all the fixes for 3 out of the four addons. I didn't find any mistakes in the whosonline hack. If anybody else does please let me know.

Apok2002, Thanks for the screen shots! They helped a lot.

I am going to fix the hack files for any new installs. If you are not comfortable editing files and templates than you can also restore the files by copying the .bak file over the modified files and reverting back to original in the templates window. I will have the fixed hack files updated shortly and included with version 1.2.6.

Again thanks for your patience :D

To fix the color of the Edit Portfolio box in the user control panel menu
edit usercp.php
---- After the following line:
$cpnav[7]="{secondaltcolor}";
---- Add this line
$cpnav[8]="{secondaltcolor}";


To fix the memberlist table
edit memberlist template
---- Replace these lines
<td bgcolor="{tableheadbgcolor}" align="center"><td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}">
Attach</smallfont></td>
<smallfont color="{tableheadtextcolor}"><b>User Name</b></smallfont></td>
---- With these lines
<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}">Attach</smallfont></td>
<td bgcolor="{tableheadbgcolor}" align="center"><smallfont color="{tableheadtextcolor}"><b>User Name</b></smallfont></td>
edit memberlistbit template
---- Before the following line:
<td bgcolor="{firstaltcolor}" align="left"><normalfont><a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$userinfo[useri
d]">$userinfo[username]</a></normalfont></td>
---- Add this line
<td bgcolor="{firstaltcolor}" align="left">$attachment</td>
edit member.php file
---- Before the following line

$frmjmpsel['usercp'] = "selected";
---- Add the following lines
$profilefieldname="field$profilefield[profilefieldid]";
$profilefield[value]=$userinfo[$profilefieldname];
eval("\$customfields .= \"".gettemplate("getinfo_customfields")."\";");
}
---- Replace the following line
$attachment .= "<IMG BORDER=0 SRC='{imagesfolder}/paperclip.gif' ALT='".$alt."' TITLE='".$alt."'></A>";
---- with this line
$attachment .= "<IMG BORDER=0 SRC='{imagesfolder}/viIcons/paperclip.gif' ALT='".$alt."' TITLE='".$alt."'></A>";

To fix the whosonline paperclip addon
-- If your whosonline menu does not extend the full length of the table.
edit online.php file
---- Replace this line
$onlinecolspan = 3;
---- With this line
$onlinecolspan = 4;

-- If your paperclip image does not show, instead you see text.
---- Replace this line
$userinfo['portfolio'] .= "<IMG BORDER=0 SRC=\"{imagesfolder}/viIcons/paperclip.gif\" ALT=\"".$alt."\" TITLE=\"".$alt."\" /></A>";
---- With this line
$userinfo['portfolio'] .= "<IMG BORDER=0 SRC=\"{imagesfolder}/paperclip.gif\" ALT=\"".$alt."\" TITLE=\"".$alt."\" /></A>";

[TeddyBare69]

Mist,
If you have a test server you could use to help test this hack it would make it to final release faster. :D The more people reporting errors the faster it moves out of Beta.

If any of you that have successfully installed this hack have any features you would like to see added? Is anybody using this in production yet? I know most of the bugs have been with the installer so it wouldn't surprise me if somebody other than visibleimpact.com is using this live with there customers?

[TeddyBare69]

I have the fixed hack files in version 1.2.6 now.

I have also fixed the install.php file. The settings problem along with copying the viPortfolio.php file and admin hacks to the correct location has been fixed.

Let me know if I missed anything. :D

[Dean C]

ok i may try this soon :D... im a lil busy with other projects right now :D

[Apok2002]

Teddy, what about all the "Q"'s that appeared in the Portfolio main page on every field?

Also, for ease on the eyes...can you edit your post above that shows the code, and use the php tags? :) Makes it much easier for everyone to see IMO. Not that big of a deal really, but it does make a difference. Perhaps in the future postings. hehe

$profilefieldname="field$profilefield[profilefieldid]";
$profilefield[value]=$userinfo[$profilefieldname];
eval("\$customfields .= \"".gettemplate("getinfo_customfields")."\";");
}


as opposed to:

$profilefieldname="field$profilefield[profilefieldid]";
$profilefield[value]=$userinfo[$profilefieldname];
eval("\$customfields .= \"".gettemplate("getinfo_customfields")."\";");
}

[Apok2002]

Yikes! Just found out, that when you uninstall, it will uninstall the settinggroup, but not the settings. I have over 100 settingid's I have to uninstall manually now in myphpadmin. Apparently, they keep being added when I install viPortfolio...but they never uninstall automatically w/ the uninstall query.

Anyone know of any quick ways to mass delete these? I have entries from 220-337! The only way I know how is to manually delete them one at a time. :(

[TeddyBare69]

yeah I got your deletes here.

to verify what you are deleteing first:
select settinggroupid, title from setting where settinggroupid > 219 and settinggroupid < 338
select settinggroupid, title from settinggroup where title like 'viPortfolio%'

To delete those same records:
delete from setting where settinggroupid > 219 and settinggroupid < 338
delete from settinggroup where title like 'viPortfolio%'

[Apok2002]

Thanks for the help....but I just don't understand the above. :( I'm a mysql (myphpadmin) n00b.

Do I copy/paste that into my query box? like so:
select settinggroupid, title from setting where settinggroupid > 219 and settinggroupid < 338
select settinggroupid, title from settinggroup where title like 'viPortfolio%'

When I do that, I get the following:

Error
SQL-query:

select settinggroupid, title from setting where settinggroupid > 219 and settinggroupid < 338
select settinggroupid, title from settinggroup where title like 'viPortfolio%'
MySQL said: You have an error in your SQL syntax near 'select settinggroupid, title from settinggroup where title like 'viPortfolio%'' at line 2


If I input one line at a time, nothing seems to happen. It just goes back to the main page.

[NTLDR]

You need to do each one sperately and make sure that you put a semi-colon (;) at the end of the line for each one

[Apok2002]

Thanks NTLDR...but I put in:

select settinggroupid, title from setting where settinggroupid > 219 and settinggroupid < 338;

And I got back:

Error
SQL-query:

select settinggroupid, title from setting where settinggroupid > 219 and settinggroupid < 338;
MySQL said:

[Apok2002]

Select didn't work for me for some reason....but delete did. I'm going to install tonight version 1.2.6. /crosses fingers. :)

[Apok2002]

While opening the install.php...I am given only these options:
To Hack the templates
needed to run viPortfolio 1.2.6 on your backup database

Skip to (viPortfolio Hacks ) >>

To INSTALL the templates, database tables, icons,
and settings needed to run viPortfolio 1.2.6 into your backup database

Continue the install (viPortfolio Tables) >>




I cannot INSTALL it. If I click the "install" option I get a page that just displays the credits. There are no further options.

If I go to install the hacks...no viPortfolio hacks appear in the vbhacker box.

[TeddyBare69]

Apok2002,
If you would be willing to give me access to your database I could help you out. With all the failed installs I can imagine your database is going to be looking different than what mine does.
This installer was a mistake. the Portfolio itself works great. We tested that very well before we brought it into the beta area. The installer didn't get the same testing as you well know.

Let me know if you are able to give me access into your database. I will go in and clean out any previous install traces and start fresh. If you are still interested in working with this hack that is. Just send me an email offline and let me know.

[Apok2002]

Before we do that...I really think I almost have it. I'm not using the install.php file any more. I used the manual install. All is looking good now: member list is almost 100% there, usercp is correct, admin cp settings are there and working. I can upload just fine...but...nothing displayes after uploading. The tmp folder is in the forums root dir...and I still see the Q's.

Here is the screenshot. In the admin cp viPortfolio Settings, I changed the # of files to 3 instead of 9, just for ease of working with.

Removed photo

As far as the memberlist goes...look at the left column.

Removed photo

Then the WHO'S ONLINE seems to be working w/ exception of the far right column at the top box...

Removed photo

Any ideas about these?

*edit* Removed photos to clean up this thread. The issues on the photos appear to be resolved anyway.

[TeddyBare69]

Apok2002,
I have already seen some of these problems. Here is either a fix or good place to look for each issue.

1. Thumbnails not showing.
When we had this problem before it was because the instructions were out of order. The install_icons.sql has to be loaded before the install_mime.sql. If you wanted to start over with just these two execute the following commands seperately in your sql command window.

These instructions will clear these tables. There is only viPortfolio data there created in the install so you won't loose anything because you will reload it further down.

drop table icons;
delete from table mime;

Copy the contents of the following files and paste into sql command window. This has to be done in this order because the icons file requires the mime contents already exists. It will not give an error but it will not work later if the order is not correct.

install_mime.sql
install_icons.sql

This should fix the thumbnails not working.

2. Showing Q's in the viPortfolio.
I have never seen this? Are the Q's text or maybe a link to a missing graphic? Could you attach the html file to a message here so I could look at it? Just do a [File] [Save as] in your browser and save to a file. Then attach the file to a message you post on this thread.

3. Fixing the far left member list column.
You need to edit your memberlist template.
Close to the bottom of the template you will see the following, You will probably see "User Name" instead of "Attach". You will need to change the words "User Name" to "Attach" only for the first occurance though. You will want the second line to still say "User Name"

<td bgcolor="#005628" colspan="7"><normalfont color="#FFCC00"><b>$bbtitle Members List</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#006633" align="center"><smallfont color="#FFCC00">Attach</smallfont></td>

<td bgcolor="#006633" align="center"> <smallfont color="#FFCC00"><b>User Name</b></smallfont></td>
<td bgcolor="#006633" align="center"><smallfont color="#FFCC00"><b>Email</b></smallfont></td>
<td bgcolor="#006633" align="center"><smallfont color="#FFCC00"><b>Homepage</b></smallfont></td>
<td bgcolor="#006633" align="center" nowrap><smallfont color="#FFCC00"><b>Find Posts</b></smallfont></td>


4. Extending the whosonline title bar.
You will need to edit online.php file.
search for
onlinecolspan = 3;
and change it to
onlinecolspan = 4;

[Apok2002]

kewl, thanks for the help, they seem like easy fixes w/ exception of the Q's (which are NOT links, they are text btw).

Here is the url for it:

www.ez-company.net/forums/viPortfolio.php

This is weird though...I'm at work...and on my work computer, I do not see the "Q's."

Be sure to use the Tech2 theme when you go (which should be default).

If you don't wanna create an account, use name: llama, pw: llama.

[TeddyBare69]

I checked out your page, really cool site by the way :D Almost tempted to join in on the chess game :D

I didn't see any Q's though. I did notice that the portfolio view doesn't show the members name of the portfolio you are viewing? Not exactly sure why that is but it might give you problems uploading if you don't see the users name in the portfolio you are trying to edit.

Does anybody else on this list have that same problem?

[Apok2002]

hehe We are going to start having Chess tournaments too. :) Something I've been planning on for a while. I had a fellow hack the php-Nuke version of HumpaChess to integrate it into vb. It's vb's first integrated Chess system. :) We are pretty proud of it. hehe

We are primarily a multi-game, multip-player online community, but we also second as a philosphy/debate board.

As far as the member's name of the portfolio, I don't know why it does that either. I access viPortfolio thru the usercp options, so I have no clue as to why it wouldn't display my name. It didn't do that on earlier versions when I manually installed, so I don't know wuttup.

I'll have time later 2nite to work on it a bit more.

[Apok2002]

Well, the deletion of the sql, and re-querying of the mimes, THEN icons was completed just fine...

However, nothing still shows up, and I would imagine it's due to the fact that no member name is showing up in the portfolio page. Still don't know why that is though.

Here are some hints though to help...

When I go to edit my Portfolio...the link DOES say

EZ Company > User Control Panel For Apokalupsis > Edit Portfolio

This is the url when I am on the edit page.

http://www.ez-company.net/forums/viPortfolio.php?action=edit

It's notshowing in the above url, but this is what is between the php?= and the &action=edit:

2839a5b0ee3f089f1b4463f763626e3e&

So it knows to update or edit MY portfolio. And when I upload and save, it says "Thank you for updating your portfolio Apokalupsis". But when you go to VIEW it, right after it thanks you...it gives a blank user name.

EZ Company > View Portfolio

And this, I imagine, is why nothing shows up. So something is going on in the VIEW area....not the edit.

This is the url it gives when viewing:

http://www.ez-company.net/forums/viPortfolio.php?s=&userid=&action=view

There are no #'s in the above url.

[Apok2002]

The Q's will appear on my home computer, but not at the work computer. Weird. I viewed the source, there are Q's in almost every field in the table. Can you take a look?

[Apok2002]

The profile page shows a darkened area to the far right, like the other pages did (before your fixes). Which file do I edit to fix that?

[TeddyBare69]

If you are talking about the menu bar at the top in user control panel.

open file usercp.php
At the bottom of the file you will see:

$cpnav[4]="#DFDFDF";
$cpnav[5]="#DFDFDF";
$cpnav[6]="#DFDFDF";
$cpnav[7]="#DFDFDF";
eval("\$cpnav = \"".gettemplate("usercpnav")."\";");

Add a line prior to the eval command to look like this:

$cpnav[4]="#DFDFDF";
$cpnav[5]="#DFDFDF";
$cpnav[6]="#DFDFDF";
$cpnav[7]="#DFDFDF";
$cpnav[8]="#DFDFDF";
eval("\$cpnav = \"".gettemplate("usercpnav")."\";");


all the "#DFDFDF" should be { secondaltcolor } without the extra spaces to match your styles. the board keeps expanding it for me :)

There is a couple other places that you have to set cpnav[8] depending on what screen you are on. If this is not what you were looking for let me know.

[Apok2002]

no, not that. It's when you view someone's PROFILE.

*edit*

Uninstalled completely so I can attempt another fresh install soon. Unless you wanna give it a go?

[TeddyBare69]

That would actually be best. After you do the uninstall check to make sure all the tables and settings are deleted before you do a reinstall. If you want me to check in and take a quick look to make sure everything is gone, I would be more than happy to ablige

[TeddyBare69]

Apoko2002,
You have been too quiet. I have a bad feeling that you don't have good news to share with the group :(

It seems like a lot of people want this hack? :) I would love to finish it. I just need to know what the problems are or I won't be able to fix them. This has worked on my server for almost 3 months now with only one real error. I made the database field that holds the full image into a type that only holds 65k :( The side effect is the image gets uploaded and chopped at 65k. A thumbnail cannot be created due to the fact that he image isn't valid anymore. The full image will still show if you click on the invalid thumbnail link. You can fix the problem with the following sql string.


alter table viPortfolio change column file file LONGBLOB;

[Apok2002]

To be honest, my main interest was that of a gallery. Your Portfolio was an alternative to that gallery. I've been looking into galleries the fast few months...and just a couple days ago, the one I liked finished up their security updates, so I installed that one on my boards.

I like the idea of a personal portfolio w/ many different media types...but on my board, public galleries do better (in as far as appeasing the masses). If you come up w/ an innovative gallery w/ this Portfolio, I'd be interested. But I can't justify having both a gallery and the viPortfolio, there just wouldn't be much point it in. :(

It's a good hack...but for gaming and general interest sites such as EZCO...galleries are more popular.

[TeddyBare69]

You really put a lot of effort in helping with the testing and I truely appreciate it :D
Don't go to far though. I think you might be more interested in version 2.0 :D I have a few things layed out that might make you change your mind? I don't want to put to much into version 2 with still having issues on this so I am going to hold it down for now. :(

If you see a version 2.0 of viPortfolio, poke your head in and check it out.

For everybody else, whats the verdict? how do when know when it is time to go full release?

[Martin64]

Hmm...why aren't I in the list of "Courage users at vbulletin.org"? :)

Anyway, my suggestion would be a page that display links to all users that are having pictures in their portfolios? It's kind of nerve-wrecking to go through the member list for 3000 members. :)

Another option would be to be able to sort by attachments (like you sort by "join date") in the memberlist. I guess I could do this myself, but it would be nice to have this as an option for the hack. :p

[bommelchen]

Hello @all,
i have install the last release of this hack and somethink works fine.

I have some Errors please help. The *.gif Thumbnails shows as a red X. *.jpg,txt,zip works fine :) but the popups of *.jpg's show the red X too.

in the version 1.0.4 the *.gif thumbnails will create but display false and the popup ist working and display false too.

The Portfolie from each user shows the same Thumbnails !! is this correct ?

any idears?

Greeting bommelchen

[TeddyBare69]

I am not sure if I understood all the problems you are experiencing. :(

Lets try:
1. gif thumbnails do not show.
2. popups on jpg do not show.
3. all users show the same thumbnails.

None of the above is supposed to happen :D

You mention version 1.0.4? If that is the version you are on you need to upgrade. version 1.2.6 is our latest version. If you can give a screen shot of what you are seeing that could possible help also. A url so I can go see the site live would be even better.

[TeddyBare69]

Martin64,
My bad, I have fixed your bug :D

I have thought of creating a sort link in memberslist that would sort the users by how many attachments they have posted. I think that might cover both of your requests? Let me know and I can put that out. Should be pretty simple, hopefully :D

[bommelchen]

Ok as attachment is my Screenshot.
All Users Portfolio shows the same Thumbnails with the latest Version. In an older Version there are different this is OK !

Hope you can help !

Bommelchen

[Martin64]

Originally posted by TeddyBare69
Martin64,
My bad, I have fixed your bug :D

I have thought of creating a sort link in memberslist that would sort the users by how many attachments they have posted. I think that might cover both of your requests? Let me know and I can put that out. Should be pretty simple, hopefully :D

Sounds excellent, I'll be waiting for that addition :)

[malken00]

I got pretty far on the install of this script. I really like it, and this is my second attempt at installing it.

I was running Version 2.2.6 of VB, with PHP 4.1.1 and php_gd.dll enabled for all scripts. Server is Win2k Server.

Here is a screen shot.

https://vborg.vbsupport.ru/external/2002/10/1.jpg

Where I ran into problems was:

#1. Uploading a file created a problem


CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are

And that was it.

However, it DID upload the file, created the thumbnail, and everything seemed to work fine on the portfolio page.

#2. I did not test it very far, as the site is extremely active, and I didn't want to keep it down for long. I restored from a backup I made before I started. What I did notice is that when I clicked on the portfolio for my username, or any username, it showed the image that -I- uploaded, under everyones portfolio. Not sure if it is something I missed or not.

Either way, hope this helps a bit. :)

[Xyphen]

The demo doesn't work...

[LangTuDaTinh]

just install it but when i tried to upload picture, it won't show up

downloaded the latest script from this thread

please help, no error message.

checked install script, mine was run before icons

where did they store these files?

blackbox of thumbnails pix appeared.

all users have the same pictures

please help

[tomjinx1]

Ok... I know it's been a while for this hack but I have a few questions.

I tried to manually install this hack. I was able to install it up until I get to executing the query. So I went and ran the uninstall sql files to drop the tables and templates. Then I ran the install.php. Everything went in fine doing this except when I go into the VBulletin Options under the Admin cp and go to viPortfolio options, all the options are listed twice. Are these listed in the mysql database? How can I get rid of one set of these options?

My second question is this. When someone uploads an image, it shows a black thumbnail instead of a thumbnail of the image. When you click on the black thumbnail, the image opens in a new window like it's supposed to do. How do I fix the thumbnail problem?

[tomjinx1]

got the first part fixed for the double entries in the Admin CP...

The black thumbs seems to only happen when a picture size isn't the standard 1:3 ratio... if it's 640x480, then it usually shows. If it's something wierd such as 640x700 then I get the black thumb. It also seems like I get the black thumbnails when a image doesn't upload all the way. which brings me to my new second problem....

It's not uploading correctly. I am getting alot of 1/4 and 1/2 images...

Any ideas?

[Logikos]

Okay Works on my test board Ver 2.3.0. Works good. When i try and install it on my board heres what happens. I upload the whole dir... then i got to the path the install.php is and i get this..



To Hack the templates
needed to run viPortfolio 1.2.6 on your visualartist_tv database

Skip to (viPortfolio Hacks ) >>

To INSTALL the templates, database tables, icons,
and settings needed to run viPortfolio 1.2.6 into your visualartist_tv database

Continue the install (viPortfolio Tables) >>


When i try and continue it never says Creating tables, or tables created. i just get the logo and the footer :( Hope there still is support for this amzing hack

-Nem

[Logikos]

Okay Works on my test board Ver 2.3.0. Works good. When i try and install it on my board heres what happens. I upload the whole dir... then i got to the path the install.php is and i get this..



To Hack the templates
needed to run viPortfolio 1.2.6 on your visualartist_tv database

Skip to (viPortfolio Hacks ) >>

To INSTALL the templates, database tables, icons,
and settings needed to run viPortfolio 1.2.6 into your visualartist_tv database

Continue the install (viPortfolio Tables) >>


When i try and continue it never says Creating tables, or tables created. i just get the logo and the footer :( Hope there still is support for this amzing hack

-Nem

[sabret00the]

i actually really wanna install this now

[sabret00the]

just installed this twice, first manually then with the installer, both times it never installed the settingsgroup, can anyone tell what's up with this?

[Logikos]

The guy hasnt been on for months and months i would suggest using Oaks Gall hack

[sabret00the]

thanks i'll check it out

[sabret00the]

figured out what was wrong with it, the querys are wrong but if someone wanted to take over where this guy left off i'd be grateful

[Logikos]

But what i dont understand is why it was working perfectly fine for my test board. Well could be because i might be using a diffrent version of MYsql. Im not sure. :(

[Koutaru]

Does anyone have a working version of this hack? I would really love to see it in action :)

[Brad]

Ill look into finishing this pending authors perrmission.

[Koutaru]

XD The last time the hack's author posted was 08-31-02 :confused: :cry:

[sabret00the]

i think when he updated the files he messed up the installation query's

[Logikos]

Well i hope he comes back on soon. That Oaks Hack seems really big to install :\

[sabret00the]

from what i saw it seems a total different thing, where as this is a personal porfolio for each use the oaks gallery seems to be another gallery hack full stop

[xpguy]

i cant see what the hack looks like or get it to work can anyone help me plz?

[Logikos]

What I did notice is that when I clicked on the portfolio for my username, or any username, it showed the image that -I- uploaded, under everyones portfolio. Not sure if it is something I missed or not.

I ahve installed this Perfectly except i have the same problem as quoted above. Anyone that would like to see it in action go to

http://www.extremeracingforums.com and click on any member and you will notice that everyone has the same images when someone uploads them. :-\

[cinq]

Would sure love to see this being worked on again ... has so much potential :)

[Koutaru]

It'd be great if someone could take over -- The author doesn't look like he's coming back for awhile :(

[Logikos]

I email him :\

[TomokiG]

Today at 06:22 AM []\[]emesis said this in Post #215 (https://vborg.vbsupport.ru/showthread.php?postid=387759#post387759)
I ahve installed this Perfectly except i have the same problem as quoted above. Anyone that would like to see it in action go to

http://www.extremeracingforums.com and click on any member and you will notice that everyone has the same images when someone uploads them. :-\

For myself I fixed that bug... find in "viPortfolio.php" following code:

$query = "
select viPortfolioid, filename, file, text,
cthumb, content_type, thumb, iconpath, largeicon, supported,
i.title, iconpath, width, height, ext
FROM viPortfolio p, mime m
LEFT JOIN icons i ON m.iconid = i.iconid
where p.mimeid = m.mimeid
and p.enddate is NULL
and m.enddate is NULL
and i.enddate is NULL
";
$query .= " ORDER BY p.viPortfolioid ";
if ( $userid < 1 )
$query .= " limit ".$_totalimages;
else
$query .= " and p.userid = ".$userid;


... and replace it with this one:
$query = "
select viPortfolioid, filename, file, text,
cthumb, content_type, thumb, iconpath, largeicon, supported,
i.title, iconpath, width, height, ext
FROM viPortfolio p, mime m
LEFT JOIN icons i ON m.iconid = i.iconid
where p.mimeid = m.mimeid
and p.enddate is NULL
and m.enddate is NULL
and i.enddate is NULL
";
/* TomokiG */
if ( $userid > 0)
$query .= " and p.userid = ".$userid;
/* ENDE */
$query .= " ORDER BY p.viPortfolioid ";
if ( $userid < 1 )
$query .= " limit ".$_totalimages;
// else
// $query .= " and p.userid = ".$userid;


I hope I could help... *g*

?TomokiG?

[Logikos]

I have done what you said and still not working :(

[TeddyBare69]

03-27-03 at 09:01 PM Anime-loo said this in Post #209 (https://vborg.vbsupport.ru/showthread.php?postid=374350#post374350)
Ill look into finishing this pending authors perrmission.

Yes it has been a while since my last login. I have gone thru enough adventures in the past few months to fill a life time. Unfortunately I am left without a dedicated internet connection. I also do not own my own computer anymore and I don't have a place of my own to live.

With all the said and done with I really wish I could tell you all that I am back and ready to continue were I left off. Unfortunately the best I can offer is asking for and giving permission to individuals who would like to attempt fixing the outstanding errors. All I ask is that the credit for this gallery stays with VisibleImpact.com. I will do my best to jump in as often as possible but since I have extremely limited access to a computer and even less to the internet I don't want anybody to get there hopes up.

I just want to thank everybody for comments and interest in this hack. I am extremely happy to be part of a project that sparked such a great interest. I will make my best attempt to give as much help as I can to the people helping to fix this project but as I said earlier, no promises.

[Logikos]

Damm TeddyBare69 I am really sorry to hear that wish i could help. Hope ecerything works out to the best they can. And this is a great hack so far :) i have modded the hell out of it :p. Hope to see you soon man.

[winky6]

:ogre:

Never mind

[Koutaru]

:) Thanks for starting the hack TeddyBare

[sabret00the]

sorry to hear that teddybare thanks for starting what will be a wonderful hack

[Koutaru]

If someone does take on this hack, I would be interested in a comment section where users can comment on a particular Portfolio image

[GaleForce]

Not sure if this has been said or not, but links don't work :(

[duboisi]

are their any working screenshots for this? I'd love to see what it looks like.

K.

[sabret00the]

goto nemesis's site, he's got it installed www.thenemesis.net

[insanctus]

Hmm I can not find anything showin what this hack does... Guess I download and try it lmao.

[insanctus]

Hmm I can not find anything showin what this hack does... Guess I download and try it lmao.

[insanctus]

Ok what is the newest of this lmao I have installed the one on the first page but see a few up dates along the post.... Yet the first one has a higher beta number :(

[insanctus]

Ok one last thing.... Any one have an idea how I can add a thing to postbits so if the user has 1 or more things in there portfolio that is shows an icon ?

[Koutaru]

Please do not post multiple times, you can just edit your post

And this hack is a beta and is unstable as you can see from all the other pages in this thread

[insanctus]

Sorry about that.... It has been an off day..

But I have this working on my board the only bug I have seen so far is that the jpg pic thumbs do not show.

And I want to add in a hack to where the if the user has 1 or more images uploaded it shows a image for a link to their portfolio in the post bits.

[gmarik]

Is anybody still working on this hack or is it on it's own?

[vB-Host.com]

has anyone gotten this to install on 2.9 ?

[gmarik]

It's ok on my 2.3
Contact me PM.

[lancepoint]

going through this whole post.. i dunno what to do now. does anyone have a working version and the files needed?