vb.org Archive
Page 73 of 104 « First 23637172 73 747583 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.


All times are GMT. The time now is 10:44 AM.
Page 73 of 104 « First 23637172 73 747583 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02078 seconds
  • Memory Usage 1,763KB
  • 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
  • (5)bbcode_code_printable
  • (3)bbcode_php_printable
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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