vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=5)
-   -   vbArticles v0.4 -- For your repository of Articles/Tutorials/FAQs etc. (https://vborg.vbsupport.ru/showthread.php?t=54331)

cindyd 07-25-2003 12:04 AM

OK, I got it fixed.

cindyd 07-25-2003 02:25 AM

OK, I went to edit an article and got this error message:
Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/forum/admin/vbArticlesadmin.php on line 234
I already did the changes the dontpanic had listed on page previous pages.

if ($action=="editarticle") {
$sql = "SELECT * FROM vbArticles_content WHERE artid=$artid";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$artid=$myrow["artid"];
$title=$myrow["title"];
$byline=$myrow["byline"]; ----> this is line 234
$author=$myrow["author"];
$date=$myrow["date"];
$content=$myrow["content"];

cindyd 07-25-2003 01:56 PM

Does anyone know how to fix the above error?

cindyd 07-27-2003 10:58 PM

I really like the idea behind this hack, but I cannot edit or delete anything.

Also, I would like to make this area of my forums accessible to paid members only, how would that be accomplished?

Is this hack still being worked on?

If so, could a link be added in the vew article area, there is no way to get back to the Article home page as it is right now.

cinq 07-28-2003 01:24 AM

cindy, i visited your site and can access the articles section alright.

You have no link in view article to get back to the Main Articles Home page is because you editted your templates to take it out.
Please check the viewarticle template again.
It should have navi at the top just below your vb header.

Also do you mean in your admincp , you are unable to delete and edit articles ? This shouldnt be the case if you installed correctly.

Finally, for your paid members, did you place them in a special usergroup? If so, you can allow viewing access only to them by simple change of code in articles.php ( pretty much similiar to the code changes highlighted previously in this thread )

cindyd 07-28-2003 03:06 AM

Quote:

Yesterday at 10:24 PM cinq said this in Post #165

You have no link in view article to get back to the Main Articles Home page is because you editted your templates to take it out.
Please check the viewarticle template again.
It should have navi at the top just below your vb header.
OK, I will recheck that.....I see what I deleted and I would like to put the links at the bottom of the page, like in the Links hack. I guess I can figure that out from the Links hack.

Quote:

Also do you mean in your admincp , you are unable to delete and edit articles ? This shouldnt be the case if you installed correctly.
Yes, see my error message a couple of posts above. You must have seen all the duplicate articles when you went to the site, I can't edit or delete in the Amin CP.

Quote:

Finally, for your paid members, did you place them in a special usergroup? If so, you can allow viewing access only to them by simple change of code in articles.php ( pretty much similiar to the code changes highlighted previously in this thread ) [/B]
Yes, I found that earlier tonight, thanks.

So all I need is to get the editing and deleting fixed and I'll be very happy!

Here is the error from when I try to edit or delete:
OK, I went to edit an article and got this error message:

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/forum/admin/vbArticlesadmin.php on line 234




I already did the changes the dontpanic had listed on page previous pages.

if ($action=="editarticle") {
$sql = "SELECT * FROM vbArticles_content WHERE artid=$artid";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$artid=$myrow["artid"];
$title=$myrow["title"];
$byline=$myrow["byline"]; ----> this is line 234
$author=$myrow["author"];
$date=$myrow["date"];
$content=$myrow["content"];

cinq 07-28-2003 04:07 AM

Quote:

Today at 01:06 PM cindyd said this in Post #166
PHP Code:


if ($action=="editarticle") {
$sql "SELECT * FROM vbArticles_content WHERE artid=$artid";
$result mysql_query($sql);
$myrow mysql_fetch_array($result);
$artid=$myrow["artid"];
$title=$myrow["title"];
$byline=$myrow["byline"]; ----> this is line 234
$author
=$myrow["author"];
$date=$myrow["date"];
$content=$myrow["content"]; 


Doesnt look like any error there in line 234. Hmm,deletion never had any problems, while an editting problem/s got nicked previously.
Any others facing the same problem ?
Jus went thru the code, seems in order ( then again, i might be missing something , pretty new to this too )

cindyd 07-28-2003 06:19 PM

Cinq: I have gone over the installation again and that error remains. When I delete an article, I am told in the CP that it has been successful, but it really doesn't delete anything.

When I try to edit I get that error message and all the input boxes are blank.

Solice 07-29-2003 01:59 AM

First off, thank you for making this wonderful hack cinq... i was wondering though... is there a way to setup permissions for posting articles? so that I could have some categories for users to post in and others for staff...

cinq 07-29-2003 06:49 AM

Solice, that's currently not planned and may not be too.
Do not have much free time on my hands right now :(


All times are GMT. The time now is 09:25 AM.

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.02230 seconds
  • Memory Usage 1,755KB
  • 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
  • (1)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
  • (2)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