vBPortfolio Lite

[King Kovifor]

vBPortfolio Lite is the "Lite" version of the still in-development full version. This version is completely free.

Features:
Template
Phrases with Custom Phrasegroup
Uses a repeat method for display all entries.
Pagination
Settings
ACP Backend:
Listing
Add
Edit*
Delete*
Reset
Version Check

* ACP backend currently does not work. Bugs have been found that hinder use of this feature, but the rest is stable.

Known Bugs:

There are two bugs that haven't been touched. There is one bug that is partially complete and needs some tweaking. The page navigation has been completely rewritten to include less code and better performance.

Patch Released
For an immediate fix for users with entries not showing up when they are added a patched portfolio.php has been uploaded. To install the patch version please overwrite the portfolio.php file on your server. Than in your vBPortfolio settings, please turn pagination OFF. (set this setting to no)

When installing, this will add 2 plugins and add a 1 entry into a mysql table, and add 1 table.

[Shazz]

Looks great! :)
________
3 Series (E21) (http://www.bmw-tech.org/wiki/BMW_3_Series_(E21))

[King Kovifor]

Edit/Delete Bug:

This bug does not call data from the database. We are working hard on fixing this.

Compatible with vB:

3.6 RC2+

3.5.4+ Version available later.

Hack Idea: Steve M
Code Idea: King Kovifor
Coding Help: Chroder, Chris M, various other coders.

Note:

That as of now, all vBPortfolio Lite installations have hard coded HTML. We have not tested and or figured out how to use a template for this section.

Future Lite Features:
ACP Required Feilds
Display Options (what to display and alternative method)
Bug Fixes

[y2krazy]

Could this also be used to post "projects" dealing with car parts and audio installations? I could see it being helpful that way too. :)

[Mythotical]

vBPortfolio can be used for anything your mind can think of. As you have the option in your settings for this hack, to call the portfolio whatever you want.

[Snake]

Awesome!

[Mythotical]

Indeed

[aLReeMi]

thanks

[King Kovifor]

Could this also be used to post "projects" dealing with car parts and audio installations? I could see it being helpful that way too. :)
You may also rename the file and all links will be changed within the file as it's an ACP setting.

[y2krazy]

I get this when trying to import the product on 3.6.0 Gold:

Database error in vBulletin 3.6.0:

Invalid SQL:
CREATE TABLE `portfolio` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`link` VARCHAR( 100 ) NOT NULL ,
`site` VARCHAR( 100 ) NOT NULL ,
`start` VARCHAR( 100 ) NOT NULL ,
`finish` VARCHAR( 100 ) NOT NULL ,
`screen1` VARCHAR( 1000 ) NOT NULL ,
`alt1` VARCHAR( 1000 ) NOT NULL ,
`screen2` VARCHAR( 1000 ) NOT NULL ,
`alt2` VARCHAR( 1000 ) NOT NULL ,
`description` VARCHAR( 10000 ) NOT NULL
) ENGINE = MYISAM ;;

MySQL Error : Too big column length for column 'screen1' (max = 255). Use BLOB instead
Error Number : 1074
Date : Saturday, August 12th 2006 @ 09:23:27 PM
Script : http://www.transitracing.com/admincp/plugin.php?do=productimport
Referrer : http://www.transitracing.com/admincp/plugin.php?do=productadd
IP Address : *****
Username : Thermo.
Classname : vb_database

[y2krazy]

Anyone able to help out with the fault in the SQL code?

[Mythotical]

y2krazy, check to make sure your server has php updated and mysql updated.

[y2krazy]

These are what my server is running:

PHP version 4.4.2
MySQL version 4.0.27-standard

Is this mod not compatible with these versions?

[King Kovifor]

If that's not working, run this query:

CREATE TABLE `portfolio` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`link` VARCHAR( 100 ) NOT NULL ,
`site` VARCHAR( 100 ) NOT NULL ,
`start` VARCHAR( 100 ) NOT NULL ,
`finish` VARCHAR( 100 ) NOT NULL ,
`screen1` VARCHAR( 255 ) NOT NULL ,
`alt1` VARCHAR( 255 ) NOT NULL ,
`screen2` VARCHAR( 255 ) NOT NULL ,
`alt2` VARCHAR( 255 ) NOT NULL ,
`description` VARCHAR( 10000 ) NOT NULL
) ENGINE = MYISAM ;;

Try running that (and hopefully the install code will be skipped.

Our Test vB has:

4.1.21-standard for MySQL and 4.4.2 for php. It works fine on these. It might be the mysql...

[y2krazy]

Well, that fixed it. Seems that this was the snag in the XML file:

) ENGINE = MYISAM ;");]]></installcode>

Simply remove that little piece and it should work fine.

Also, I wasn't aware of this, but is this mod just for the owner of the site it's used on to utilize, or is it editable on a per-user basis?

EDIT: That didn't fix the SQL. It never made the 'portfolio' table and when I tried to run that query in phpMyAdmin, this it what it gave me:

#1074 - Too big column length for column 'description' (max = 255). Use BLOB instead

[mac27]

OK but where do you find the portfolio at. I know it is there but where. :)

[King Kovifor]

Well, that fixed it. Seems that this was the snag in the XML file:

) ENGINE = MYISAM ;");]]></installcode>

Simply remove that little piece and it should work fine.

Also, I wasn't aware of this, but is this mod just for the owner of the site it's used on to utilize, or is it editable on a per-user basis?

EDIT: That didn't fix the SQL. It never made the 'portfolio' table and when I tried to run that query in phpMyAdmin, this it what it gave me:

#1074 - Too big column length for column 'description' (max = 255). Use BLOB instead

I was hoping that it didn't do that. You'll need to do this instead:

CREATE TABLE `portfolio` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`link` VARCHAR( 100 ) NOT NULL ,
`site` VARCHAR( 100 ) NOT NULL ,
`start` VARCHAR( 100 ) NOT NULL ,
`finish` VARCHAR( 100 ) NOT NULL ,
`screen1` VARCHAR( 255 ) NOT NULL ,
`alt1` VARCHAR( 255 ) NOT NULL ,
`screen2` VARCHAR( 255 ) NOT NULL ,
`alt2` VARCHAR( 255 ) NOT NULL ,
`description` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ;

Also note, that the table prefix is not in there. If you have vb_ as your table prefix change "portfolio" to "vb_portfolio" and it'll correctly integrate.

Yes, this mod is for the Owner only. Or at least anyone with access to the ACP.

OK but where do you find the portfolio at. I know it is there but where. :)

After you install the mod, and upload the files go to the following URL:

http://www.domain.tld/forum_directory/portfolio.php

That is if you didn't rename that.

[y2krazy]

Alright, I replaced the table with that last SQL and now I go to try and save an entry in the ACP and once I hit Save, it redirects and shows it as an entry; however, when I went to view it @ /portfolio.php nothing shows up. So, I checked back in the ACP and clicked [EDIT] and when I do, all the fields are blank and when I check phpMyAdmin, the data was entered into the database correclty as the first row.

What would explain nothing showing up in the ACP or on the /portfolio.php page?

[King Kovifor]

[EDIT] and [DELETE] are currently listed as bugs for the ACP. The queries are not running which is causing no data to show.

/portfolio.php should show all of them. Do you have it installed on a test board? If so, could you show me the query that selects from prefix_portfolio table? Any of them will that include that would be useful.

[y2krazy]

I am running on somewhat of a test board I guess - ie, it's not open to the public yet (forum is locked), but I haven't edited any files from the version you released so I have what you have.

[King Kovifor]

Crap, if you have everything we do, than I guess it's a bug. << I'll try to fix it soon.

y2krazy,

Thanks for the discovery of a bug in v1.0.0! The coders are now hard at work to fix this bug. A new version will be released ASAP!

From the coders:

The bug has to do with pagination. The PHP does not correctly use the LIMIT clause in mySQL. This has also given way to a second bug that will cause errors when Pagination is turned off. We thank you very much for the bug report and helping to improve this system.

[King Kovifor]

Just an update:

Pagination has been completely rewritten. Once I can get at least one bug down soon, I'll be able to release this version. I've added some code so that you can still delete an entry but the info won't be showed.

Another Update:

Thanks to help from SirAdrian I have squashed ALL bugs. The new version will be as bug free as possible. We will have fixed about 10 bugs. Maybe more in this new release. It should be out tonight.

[y2krazy]

When trying to Uninstall the Product, this is what I get in the ACP:

Database error in vBulletin 3.6.0:

Invalid SQL:
DROP TABLE `portfolio`;

MySQL Error : Unknown table 'portfolio'
Error Number : 1051
Date : Thursday, August 31st 2006 @ 07:06:54 AM
Script : http://www.goclubbing.net/admincp/plugin.php?do=productkill
Referrer : http://www.goclubbing.net/admincp/plugin.php?do=productdelete&productid=kk_sm_portfolio_lite&s=
IP Address : 68.90.246.39
Username : Thermo.
Classname : vb_database

[King Kovifor]

When trying to Uninstall the Product, this is what I get in the ACP:
Sorry your installing but thanks for that. More to look into.

[Mythotical]

That only happens when the installcode isn't properly added to the plugin causing it to not add the table upon install.

[King Kovifor]

vBPortfolio v2.0l (Lite Version) will start being developed in about 1-2 weeks. This will be a complete rewrite with (as of now) about 40 features that you can use to your advantage. vBPortfolio v2.0f (Full Version) will be the first released in that department.

[taxick]

When trying to Uninstall the Product, this is what I get in the ACP:

I get same error - PLZ fix this..

[King Kovifor]

The query is as follows:

DROP TABLE `" . TABLE_PREFIX . "portfolio`"

Now the vBulletin must not be picking up the TABLE_PREFIX variable.

This should all be fixed within vBP2.0l & vBP2.0f

[egtrix]

Hello nice work, I face a problem where entries don't show and even can't be deleted, can you help please?

[King Kovifor]

Hello nice work, I face a problem where entries don't show and even can't be deleted, can you help please?

What's your error?

[egtrix]

I add entries but they don't show in the portfolio page, and even when I edit these enteries from the admincp, the name of the entry is there but the other feilds show as empty ones although that I filled and saved them earlier.
Also when trying to delete an entry, no errors show but nothing happens, the entries are not deleted.

[King Kovifor]

A new version is ready, but not with the phrases so here's a patch. THis should fix all problems.

[thincom2000]

I get this when trying to import the product on 3.6.0 Gold:


Database error in vBulletin 3.6.0:

Invalid SQL:
CREATE TABLE `portfolio` (
`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`link` VARCHAR( 100 ) NOT NULL ,
`site` VARCHAR( 100 ) NOT NULL ,
`start` VARCHAR( 100 ) NOT NULL ,
`finish` VARCHAR( 100 ) NOT NULL ,
`screen1` VARCHAR( 1000 ) NOT NULL ,
`alt1` VARCHAR( 1000 ) NOT NULL ,
`screen2` VARCHAR( 1000 ) NOT NULL ,
`alt2` VARCHAR( 1000 ) NOT NULL ,
`description` VARCHAR( 10000 ) NOT NULL
) ENGINE = MYISAM ;;

MySQL Error : Too big column length for column 'screen1' (max = 255). Use BLOB instead
Error Number : 1074
Date : Saturday, August 12th 2006 @ 09:23:27 PM
Script : http://www.transitracing.com/admincp...=productimport
Referrer : http://www.transitracing.com/admincp...?do=productadd
IP Address : *****
Username : Thermo.
Classname : vb_database

I don't think this was touched on, but the reason this happened is because VARCHARs larger than 255 are not supported unless your server runs MySQL 5. Once everyone starts running 5, we can stop using BLOBs. I prefer LONGTEXT myself, since for some reason I can never use any string functions like explode() or str_replace() on a BLOB stored in a string, the string just gets set equal to ''

Also, I got excited when it sunk in that I upgraded to PHP 5, but then also realized I wouldn't be able to write hacks with any of the new functions if I expected to post them here and have the code work for most people.

But I also had an XML error that made no sense why it wasn't creating my database. I just deleted most of the file and started over, since after 2 days I couldn't find the syntax error. vBulletin wasn't reporting it during Product Installation, and it remained hidden even after using $db->show_errors();

This error had just reminded me of all that. Sorry, guys.

[King Kovifor]

It's ok... We told them what to do.... i think (i hope!)

[Killer_Charge]

I have uploaded the files to my forum, and added the fix, but i still get an error with the pagenation on
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT * FROM portfolio LIMIT ,;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Error Number : 1064
Date : Thursday, October 4th 2007 @ 09:43:20 AM
Script : http://www.erixx.co.uk/forums/projects.php
Referrer :
IP Address : 62.171.194.9
Username : Administrator
Classname : vb_database
if i turn the pagenation on, it has no error, but no entrys show
please help :D

[King Kovifor]

You have to turn it off. It was fixed in an unreleased version... I probably should finish that...

[Killer_Charge]

it is turned off and gives that error :(

[King Kovifor]

Um. I think there is a fix earlier in the thread. I will find one for you in a bit. I currently have some homework to do.

[Killer_Charge]

ok thanks

[King Kovifor]

ok thanks

It seems that I never provided a fix. How many entries do you plan on having?

[Killer_Charge]

dont worry mate, it was my fault hahaha
i had projects.php and portfolio.php
projects was the old one, and basicly i mixed it all up :(

works great!
one thing tho, when i display entries, it adds the link to the finnish date
Oct.7, link=http://www....

any fix for this or is it intended?
cheers

[King Kovifor]

Screenshot?

[Goomzee]

it will work fine with 3.6.9?

[Mr_Devlin]

I read all posts in here but I'm not able to find out for what this Hack can be used for or what this hack does. Is anyone able to explain it's main functions, features or benefits? Why should I install this? Is there a demo available?