[v3 Articles] Printable Articles

[ChurchMedia]

"Printable Articles" by ChurchMedia
Add-on Hack for v3 Articles (https://vborg.vbsupport.ru/showthread.php?t=65934)

Adds a "Printable Version" link to v3 Articles.

1 new file upload
1 new template
1 template change

Customize the print template as you like. Hopefully I don't have any unnecessary code in the php file. Let me know if there is :).

[Kevorkian]

"Printable Articles" by ChurchMedia
Add-on Hack for v3 Articles (https://vborg.vbsupport.ru/showthread.php?t=65934)

Adds a "Printable Version" link to v3 Articles.

1 new file upload
1 new template
1 template change

Customize the print template as you like. Hopefully I don't have any unnecessary code in the php file. Let me know if there is :).
good hack! ^___^
* Kevorkian click install

[Holidazed]

Very nice. Thank you

[colicab-d]

* colicab-d clicks install

thnk you :D

[Giveit2u43]

great hack :)

[Acido]

Excellent !
Thanx ;)

[Henry-RS]

Thanks a lot!

Very useful.

[kira]

Very helpful, thank you! :)

[TTG]

Useful addition .. clicked install https://vborg.vbsupport.ru/external/2005/01/2.gif

[Blam Forumz]

* Blam Forumz clicks install

woot :D

[gfxhavenowner]

Excellent hack.

[Bolas]

Woooooooaaaa!!! :-)

* Bolas clicks install

[bendigo-tech]

This is a nice hack. Simple to install and seems to work nicely however, all the HTML within the article is shown in the printable version which makes things look VERY messy!

Is there a way to fix this??

Thanks :)

[inverted]

ok, i'm getting a database error when i click "Printable Version". i don't see how this hack could have made a database error since it doesn't seem to even change the database, but i can view the articles fine, just when i click for the printable version i get:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions FROM article AS article
INNER JOIN articlepost AS articlepost ON(articlepost.postid = article.firstpostid)
INNER JOIN articlecategory AS articlecategory ON(articlecategory.categoryid = article.categoryid)
WHERE article.articleid = 1 AND articlepost.type=1

can anyone with more database/php knowledge help me out?

thanks, any help is greatly appreciated.

- inverted :ermm:

[ChurchMedia]

My bad. I didn't have the prefix variable in there. It should work now -- Re-download and let me know if you have any more problems.

[inverted]

still the same error.

[bendigo-tech]

all the HTML within the article is shown in the printable version which makes things look VERY messy!
Anybody have a fix for this yet? How can we make it parse the HTML??

[inverted]

my install still gives a database error when i try to view the printable version. that fix didn't change anything ChurchMedia.... got any other ideas?

[ChurchMedia]

I'm sorry -- I'm really ill right now. I'm not sure what the problem could be with the hack. It's working fine on most people's boards. Have they upgraded the articles hack recently? That could make my hack obsolete. If anyone else would like to try to figure this out it's okay with me.

Thanks.

[inverted]

i'd appreciate your help getting this fixed whenever you are not ill, just please PM me or something, any help would be appreciated, otherwise i'm gunna have to uninstall this.

[inverted]

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions FROM vb3_article AS article
INNER JOIN articlepost AS articlepost ON(articlepost.postid = article.firstpostid)
INNER JOIN articlecategory AS articlecategory ON(articlecategory.categoryid = article.categoryid)
WHERE article.articleid = 1 AND articlepost.type=1

mysql error: Table 'invertedwebcom.articlepost' doesn't exist

mysql error number: 1146

[inverted]

does anyoen have some help for me here? this printable version mod is giving more trouble than it's worth since i keep getting a databse error.

[RsX]

ive got this database error as well. any ideas?

[Guy G]

for all the ppl with the error.
use this query instead the one on the file:

$article = $DB_site->query_first("SELECT article.*, articlepost.*, articlecategory.options AS categoryoptions FROM " . TABLE_PREFIX . "article AS article INNER JOIN " . TABLE_PREFIX . "articlepost AS articlepost ON(articlepost.postid = article.firstpostid) INNER JOIN " . TABLE_PREFIX . "articlecategory AS articlecategory ON(articlecategory.categoryid = article.categoryid) WHERE article.articleid = $a AND articlepost.type=1");

By Paul M who helped me....

[inverted]

thanks zorobz... i had to uninstall this mod for a while since there was (is) pretty much no support... thanks a lot for your help! it's a great feature to have. thankfully it works now!

[ChurchMedia]

Thanks, zorobz. I just got out of the hospital and couldn't help (health junk is why I can't offer support on my hacks). I've updated the zip file.