vb.org Archive - v3 Articles 1.0.1

Page 19 of 26

« First

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - v3 Articles 1.0.1 - [vB 3.0.1] (https://vborg.vbsupport.ru/showthread.php?t=65934)

Qwest

12-07-2004 04:14 PM

Quote:

Originally Posted by Zorobz

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost

                                                                          INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)

                                                                          WHERE articlepost.postid=17

mysql error: Unknown table 'articlepost'



mysql error number: 1051

getting error when trying to edit a comment... any ideas pleasE?

same error here

TCB	12-07-2004 06:46 PM

Of course John doesn't owe us anything, but it's a real shame that he hasn't at least updated the script for 3.0.3 usage

Paul M

12-07-2004 10:03 PM

Quote:

Originally Posted by Zorobz

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost

                                                                          INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)

                                                                          WHERE articlepost.postid=17

mysql error: Unknown table 'articlepost'



mysql error number: 1051

getting error when trying to edit a comment... any ideas pleasE?

Quote:

Originally Posted by Qwest

same error here

It's an error in the script. Find the following code in the article.php (line 680 ish)

PHP Code:


		
			
    // get comment

    $comment = $DB_site->query_first("SELECT articlepost.*, article.categoryid FROM " . TABLE_PREFIX . "articlepost

                                      INNER JOIN " . TABLE_PREFIX . "article AS article ON (article.articleid = articlepost.articleid)

                                      WHERE articlepost.postid=$id");

and replace it with this ;

PHP Code:


		
			
    // get comment

    $comment = $DB_site->query_first("SELECT articlepost.*, article.categoryid FROM " . TABLE_PREFIX . "articlepost as articlepost

                                      INNER JOIN " . TABLE_PREFIX . "article AS article ON (article.articleid = articlepost.articleid)

                                      WHERE articlepost.postid=$id");

deathemperor

12-08-2004 03:52 AM

Quote:

Originally Posted by KTBleeding

Awesome!

One problem though. I can't find this at all:

Code:

FIND IN article_display:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR (($article['articleuserid'] != $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOTHART))">

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

This is the closest one to it I could find:

Code:

<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR ($permissions['articlepermissions'] & CANEDOTHART)

Is that the one you're talking about?

PS: Thanks for updating us with a more secure script.

oh sorry, that was my bad (find and replace is opposite) since you know I was very furious knowing John could do such a careless job like this. attachment updated.

PHP Code:


		
			
FIND IN article_display:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR ($permissions['articlepermissions'] & CANEDOTHART)">

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@



REPLACE WITH:

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR (($article['articleuserid'] != $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOTHART))">

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

@TCB: No, John didn't even make it work correctly with vb3 not to mention vb3.0.3

KTBleeding

12-08-2004 01:05 PM

There we go. All fixed.
Once again, thanks for these updates. :)

Guy G

12-08-2004 02:55 PM

ok this is annoying... nothing is working well.
can anyone be kind enough and upload a correct article.php and other files that needed editing? it would be alot botter i must say...

Code:

Parse error: parse error, unexpected $ in public_html/forum/article.php on line 1300

thats the last line in there.... no $ there as well

lanc3lot

12-08-2004 03:07 PM

Has anyone find a way, that u can make the whole script can upload more than one image per time?
Like vb does, with multiple upload boxes:(

KTBleeding

12-09-2004 12:15 AM

Quote:

Originally Posted by lanc3lot

Has anyone find a way, that u can make the whole script can upload more than one image per time?
Like vb does, with multiple upload boxes:(

The script does this by default.

deathemperor

12-09-2004 04:12 AM

Quote:

Originally Posted by Zorobz

ok this is annoying... nothing is working well.
can anyone be kind enough and upload a correct article.php and other files that needed editing? it would be alot botter i must say...

Vb.org doesn't allow people to upload php source file that is edited and it's wise to know what others are telling you what to do instead of doing it thoughtlessly.

PAINTBALLM

12-09-2004 10:44 AM

I have this installed and running the way I want it at http://www.pbmessage.com for the "reviews" link. Is there any way of indexing all articles in search engines. Currently, the link is not search engine friendly.

Guy G

12-09-2004 10:49 AM

Quote:

Originally Posted by deathemperor

Vb.org doesn't allow people to upload php source file that is edited and it's wise to know what others are telling you what to do instead of doing it thoughtlessly.

ok good 2 know
:ermm:

EDIT:
k i have done everything that neesd to be done.
and i have this problem...

Parse error: parse error, unexpected $ in /public_html/forum/article.php on line 1299

thats the last line at the file... no '$' of course...
this worked before, than i made the required edits for the "Edit Comment" query and it doest work now. any solutios?

lanc3lot

12-09-2004 11:52 AM

Quote:

Originally Posted by KTBleeding

The script does this by default.

What does that mean? that u cant change it?

If u change the vb rule, it is not changed in Articles hack...It use another php, thats why...

deathemperor

12-09-2004 01:14 PM

Quote:

Originally Posted by Zorobz

I don't really know what your error is, if you please you can give me a pm with the source file so I can take a look

Paul M

12-09-2004 04:52 PM

Quote:

Originally Posted by Zorobz

It usually means you have extra spaces and/or line feeds at the end of the file ( after the final ?> ) - remove these and use a proper text editor next time, not dreamweaver or stuff like that.

Guy G

12-09-2004 05:23 PM

using notepad.
but thx. ill try it.

EDIT: that didnt fix it. if u want and check it out... www.ex-zone.com/article.php.txt .
id appriciate it.

EDIT:
i even ran a Syntax Check on the file with DzSoft PHP Editor which resulted:
Parse error: parse error, unexpected $end in article.php on line 1298

PAINTBALLM

12-09-2004 06:13 PM

Quote:

Originally Posted by PAINTBALLM

please dont ignore this post

deathemperor

12-10-2004 04:33 AM

Quote:

Originally Posted by Zorobz

you said you did all the fix but actually you didn't, you missed this post:

https://vborg.vbsupport.ru/showpost....&postcount=696

try it at see how, I still don't understand what your prob could be. >_<

in case it still doesn't work, try the fresh article.php file from here and redo the all fixs

Guy G

12-10-2004 06:21 AM

Quote:

Originally Posted by deathemperor

still same error. just diffrent line since i added more lines...
always the last line saying "parse error, unexpected $".
frustrated :S

Paul M

12-10-2004 08:05 PM

Quote:

Originally Posted by Zorobz

still same error. just diffrent line since i added more lines...
always the last line saying "parse error, unexpected $".
frustrated :S

Your error is lines 473 to 476 ;

PHP Code:


		
			
    if ($_REQUEST['submitrating'] == 1)

    {

if ($_REQUEST['submitrating'] == 1)

    {

Delete the last two of these lines - they are a repeat of the first two - causing to have an unclosed IF statement.

Guy G

12-11-2004 12:42 AM

Quote:

Originally Posted by Paul M

Your error is lines 473 to 476 ;

PHP Code:


		
			
    if ($_REQUEST['submitrating'] == 1)

    {

if ($_REQUEST['submitrating'] == 1)

    {

Delete the last two of these lines - they are a repeat of the first two - causing to have an unclosed IF statement.

whaaaa love ya! :banana: :banana:

i appriciate it m8!

Guy G

12-11-2004 01:19 PM

i wanna get the Articles and comments to list in the Quick stats at the admin cp.
for example:

Code:

New Posts Today 56 New Threads Today 32 Unique Members Today 12

add a line under that to add

Code:

New Articles Today xx New Comments Today xx Articls awating Approvel XX

Also, has anyone managed to fix the article count?
i made a test article, and i cant delete it in the usual way... so i went and deleted it through PhpMyAdmin, but it still shows under the category i made it although when i press its not even there...

And another thing is... if i post GIF animations on articles they dont 'animate', they are frozen... only when pressing it they show up.

buggy system...

pingme

12-14-2004 03:00 AM

I am getting following error :(

Code:

Database error in vBulletin 3.0.3:



Invalid SQL: SELECT * FROM vb3_article 



WHERE categoryid=1 AND (articleuserid=1 OR open IN (0,1)) ORDER BY dateline DESC LIMIT 0, 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 2



mysql error number: 1064

Please help, I need article system on my site :(

dookie

12-14-2004 02:08 PM

I get the same error.
Doesn´t work in 3.0.3. *uninstall*

Guy G

12-14-2004 02:43 PM

im running it on vb 3.0.3.

there is one really annoying bug....
on the articles it shows wrong count on them if i had test articles.
if i did a test article\comment and than deleted it from the database it will still show that there is a nigger count of articles. same for comments.
annoying indeed, anyone managed 2 fix it?

pingme

12-14-2004 04:12 PM

Quote:

Originally Posted by dookie

I get the same error.
Doesn?t work in 3.0.3. *uninstall*

I found few people using it on this thread. dont know how they are not facing any issues :rolleyes:

Paul M

12-14-2004 06:05 PM

Quote:

Originally Posted by dookie

I get the same error.
Doesn?t work in 3.0.3. *uninstall*

Yes it does.

dookie

12-15-2004 07:15 AM

I forgot to save the vbulletin options. Works. :)

TRStealth

12-16-2004 04:05 AM

Hi,

I'm trying to get the 'Featured Article' thing to show up on the index page, but I'm having trouble.

I got the featured_article template to show, but the actual featured article won't.

I've added the following to the index.php page:

PHP Code:


		
			
$globaltemplates = array(

    'FORUMHOME',

    'forumhome_event',

    'forumhome_forumbit_level1_nopost',

    'forumhome_forumbit_level1_post',

    'forumhome_forumbit_level2_nopost',

    'forumhome_forumbit_level2_post',

    'forumhome_lastpostby',

    'forumhome_loggedinuser',

    'forumhome_moderator',

    'forumhome_pmloggedin',

    'forumhome_subforumbit_nopost',

    'forumhome_subforumbit_post',

    'forumhome_subforumseparator_nopost',

    'forumhome_subforumseparator_post',

    'article_featured'

);

then

PHP Code:


		
			
require_once('./includes/functions_articles.php');

And finally

PHP Code:


		
			
// ### Start Articles



        $featuredarticle = unserialize($datastore['featuredarticle']);

        if ($featuredarticle['id'])

        {

            $feature = $DB_site->query_first("SELECT article.*, articlepost.*, articlecategory.options AS options 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=$featuredarticle[id]");

        }

        if (!empty($feature['title']))

        {

        

            // do html

            if ($feature['options'] & 256)

            {

                $dohtml = 1;

            }

            

            if ($feature['options'] & 512)

            {

                $dosmilies = 1;

            }

            

            // get an attachment, if there's one with a thumnail

            $attachment = $DB_site->query_first("SELECT attachmentid FROM " . TABLE_PREFIX . "articleattachment WHERE articleid=$featuredarticle[id] AND thumbnail_dateline>1 ORDER BY RAND() LIMIT 0,1");

            if (!empty($attachment['attachmentid']))

            {

                $GLOBALS['isattachment'] = true;

            }            

            

            require_once('./includes/functions_bbcodeparse.php');

            $feature['postbody'] = truncate_text($feature['postbody'], $vboptions['featuredlength'], 1);

            $feature['postbody'] = parse_bbcode2($feature['postbody'], $dohtml, 0, $dosmilies, 1);

    

            eval('$articlecontent .= "' . fetch_template('article_featured') . '";');

        }

        

// ### End Articles





// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

eval('$articlecontent .= "' . fetch_template('article_featured') . '";');

eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('FORUMHOME') . '");');

However, this only displays the template, like I said. It doesn't show the featured article.

Paul M

12-16-2004 10:29 AM

Have you added $articlecontent in to your forumhome template ?

deathemperor

12-16-2004 10:35 AM

Quote:

Originally Posted by dookie

I forgot to save the vbulletin options. Works. :)

and someone still want to say that this has something like a very BIGGY issue.

they should have known that John asked them to save the V3article options 1st before it CAN work...

SamirDarji

12-16-2004 10:58 AM

Quote:

Originally Posted by deathemperor

and someone still want to say that this has something like a very BIGGY issue.

they should have known that John asked them to save the V3article options 1st before it CAN work...

It happenned to me too. It's just not something you expect to do, so it's easy to overlook. But there are still other issues with this hack. :(

riedel

12-16-2004 05:41 PM

I'm getting following error :S

Code:

 Database error in vBulletin 3.0.3:



Invalid SQL: SELECT * FROM article 

                                                                 WHERE categoryid=2 AND (articleuserid=1 OR open IN (0,1)) ORDER BY dateline DESC LIMIT 0, 

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 2



mysql error number: 1064

Ineed help!!!!!

pingme

12-16-2004 07:18 PM

I am getting the same error but it seems no one is willing to help :(

sirstone

12-16-2004 07:49 PM

Works that with 3.0.3?

TRStealth

12-16-2004 08:30 PM

Quote:

Originally Posted by Paul M

Have you added $articlecontent in to your forumhome template ?

Yeah, and when I do, it just shows the featured_article template, but not the text.

j_86	12-17-2004 05:21 PM

https://vborg.vbsupport.ru/showthrea...t=geek+article[I][U]

TRStealth

12-17-2004 06:19 PM

That's not at all what I want/need.

j_86	12-17-2004 06:35 PM

It was meant for all those viewing the thread, otherwise i'd have quoted your post to show that I am replying to you.

TRStealth

12-18-2004 12:27 AM

ok, can anyone tell me how to fix the problem with thumbnails not showing then?

j_86	12-18-2004 02:15 PM

Take a look through the thread and find the fix.

All times are GMT. The time now is 01:11 PM.

Page 19 of 26

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03176 seconds Memory Usage 1,896KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_code_printable (8)bbcode_php_printable (20)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: