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 :(

FleaBag 07-30-2003 12:43 AM

After years of coming to this site I finally enter the Beta forum... To find this baby waiting for me!

Nice work. :D

cindyd 07-30-2003 06:30 PM

cinq: I would test this for you, but I would have to do it on a live board.

corsacrazy 07-30-2003 06:53 PM

if this is used for tutorials it wood be a gr8 addition to allow adding of images :D

cinq 07-30-2003 11:16 PM

Quote:

Today at 04:30 AM cindyd said this in Post #174
cinq: I would test this for you, but I would have to do it on a live board.
That would be great cindy, thank you in advance. :)
It should not affect whatever articles you currently have in place. But do a db backup anyways ( not neccessarily the whole db, just the vbArticles tables - cat and content ).

Do feedback to me if it works.
Btw has your old problem been nicked yet ?

cinq 07-30-2003 11:19 PM

Quote:

Today at 04:53 AM corsacrazy said this in Post #175
if this is used for tutorials it wood be a gr8 addition to allow adding of images :D
corsacrazy , personally i prefer to allow the user to have the versatility of linking their own images.
So at least you can control the layout of the article view.

The feature i am currently working on is allowing for vbcode for article input ( which i am getting someone to test above ), so a simple vb [img ] will allow linking of images which can either be stored in a directory on your server to your liking or from somewhere on the internet :)

cinq 07-30-2003 11:21 PM

Quote:

Yesterday at 10:43 AM FleaBag said this in Post #173
After years of coming to this site I finally enter the Beta forum... To find this baby waiting for me!

Nice work. :D


Thanks for the kind comments, FleaBag. :D
Do click the install button to be informed of any new updates to this hack.

Right now i am just taking things slow to add up on the features I had hoped to include, once done i will make it a Full release, of cos first ensuring no more known bugs are experienced.

Once again, thanks so much to all who have already installed and tried this hack and feedback your findings/bugreports and provided fixes , i really appreciate it :D

cindyd 07-31-2003 12:00 AM

Quote:

Today at 08:16 PM cinq said this in Post #176
That would be great cindy, thank you in advance. :)
It should not affect whatever articles you currently have in place. But do a db backup anyways ( not neccessarily the whole db, just the vbArticles tables - cat and content ).

Do feedback to me if it works.
Btw has your old problem been nicked yet ?

OK, I don't have anything to lose on this hack right now, since I have to do a lot of deletions, anyway.

I still cannot get past those errors I reported earlier.

I will do this either tonight or tomorrow for sure.

PurpleCow 07-31-2003 04:31 AM

cinq - I just installed this hacka nd ofcourse clicked on the installed button...!

However, i have a very minor problem...that when i load the page mydomain.com/articles.php , the main page has this list of categories and the next table with Recently Added Articles.

The Recently Added Articles section ( entire table ) is not aligned to the center of the actual width..rather its aligned to the left. Which template do i edit to align the same to center.

Thank you

cinq 07-31-2003 04:50 AM

Where's your site ?

PurpleCow 07-31-2003 05:48 AM

cinq - I have just PM-ed you the link to my forums under development.

Thanks

cindyd 07-31-2003 11:56 PM

cinq: I uploaded the files to test out the code and received this error:

Warning: main(vbCode.php): failed to open stream: No such file or directory in /home/glassmav/public_html/forum/articles.php on line 3

PHP Code:

<?  
require("./global.php");  
require_once "vbCode.php";----->this is line 3  
if (!isset($action) or $action=="") {  
  $action="main";


cinq 08-01-2003 12:02 AM

cindy, try this:


PHP Code:

<?  
require("./global.php");  
require_once "./vbCode.php";
if (!isset($action) or $action=="") {  
  $action="main";


cindyd 08-01-2003 01:04 AM

OK, I changed it and now this comes up:

Parse error: parse error in /home/glassmav/public_html/forum/articles.php on line 147

On line 147 is this:

?>

cinq 08-01-2003 06:11 AM

UPDATES
version 0.4 is out

- Now allows for basic VBCODE input in article submission and addition.
- Fixed all reported bugs up to post 183


Re-download the attached zip package and read the upgrade_readme.txt file carefully when upgrading from v0.3.

For fresh installation , pls read the install_readme.txt file contained in the zip package

Sorry for the slow updates, been extremely busy lately and having no access to my own comp doesnt help.
Thanks for being patient :)

cinq 08-01-2003 06:13 AM

FYI list of VBCodes allowed :

PHP Code:


[b][/b]
[
i][/i]
[
color=xx][/color]
[
size=xx][/size]
[
font=xx][/font]
[
u][/u]
[
url=xx]xx.com[/url]
[
url]xx.com[/url]
[
quote][/quote]
[
email=xx@xx.com]xx[/email]
[
img]https://vborg.vbsupport.ru/[/img] 

:D

TheComputerGuy 08-01-2003 02:03 PM

Just installed v0.4 Will let you know how it goes as far as people using it!

Thanks a lot!

cindyd 08-01-2003 03:36 PM

Hi Cinq: I upgraded to the new version and tried to edit/remove some duplicate articles and got this error:

Quote:

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

 $sql "SELECT * FROM vbArticles_content WHERE artid=$artid"


**Update: I have everything working now! Super!

cinq 08-01-2003 10:58 PM

Quote:

cindyd
**Update: I have everything working now! Super!
Thats fantastic :D

gmarik 08-02-2003 11:09 AM

Getting better and better ...

cindyd 08-02-2003 08:28 PM

I have a request for the Admin CP, could you make the
"content" box area larger? Being an old curmudgeon, I need a bigger area to see better.

While I am making requests, I would like to have some on the Forum Home Display template that would show recently added articles.

The Article section on my board is by paid membership and I want to "tease" the members......

Thanks

FastAttack 08-02-2003 10:53 PM

one more request can you make it so that certain mods can access this and add faq and articles to the system? because so far its only restricted to admins.. and I don't want to give my mods access to it.

dontpanic 08-03-2003 03:26 AM

Quote:

08-01-03 at 03:11 AM cinq said this in Post #184
UPDATES
version 0.4 is out

- Now allows for basic VBCODE input in article submission and addition.
- Fixed all reported bugs up to post 183

Hiya cing...what's really new over the v0.3 plus the changes we discussed? Any new Admin functionality I need to be aware of...just wondering 'cause I've already taken your great hack and hacked it even more to customize it. I've got the HTML editor integrated now in the submission page as well as a search function...of course, those were both commerical add-ons that I had to buy...but ah well, it works nicely.

Thanks again!
:chinese:

cinq 08-03-2003 04:19 AM

Other than the fixes for the bugs reported previously, no other changes.

Check the changelog, main changes are inclusion of the bug fixes and VBcode integration.

I just found a HTML editor thats free , may try to integrate that at a later date too ! :D

PixelFx 08-04-2003 08:05 PM

1st page 200 / 2003 is the best free html editor, it's great for editing templates with ultra edit ;)

http://www.ultraedit.com
http://www.evrsoft.com

cinq 08-04-2003 11:05 PM

Yep , i use those 2 utilities myself actually.
However i was refering to a WYSIWYG tool for inputting of articles.
:)

anyways the next version will not be too soon, totally bogged down by work ... argh

supreemball 08-07-2003 03:06 AM

awesome hack, cinq. i installed v0.4 with minimal trouble (except for the html issue in the content field which i fixed by reading the fixes in this thread).

my suggestions for the next release are a ratings system for each article (as well as a 'sort by top ratings' routine).. also get rid of the 'date' option when submitting articles and just autofill it in with php's date() routine (or whatever its called).

cinq 08-07-2003 04:07 AM

Could you point out which html bits you faced errors with ?
I had assumed i had included all fixes prior to that 0.4 release into the download.

Yes, a ratings system is planned but not so soon.
kars10 is working on that, have yet to hear from him.

As for the date function, yes, i intend to make it a timestamp instead of having to manually fill in the date. Should make sorting easier too.

Holidazed 08-07-2003 05:32 PM

cinq, this is simply awesome. It installed flawlessly.

Some suggestions I would have are already on your todo list (like sub-categories).

Other suggestions I have are as follows.

1. Don't ask for the date, just take it from the system date.

2. Make the "Content" field look more like the posting field in vBulletin.

3.In addition to allowing for vbCode, also have the vbcode buttons above the "Content" box (like on vBulletin.org).

4. An option in the ACP to allow/disallow vbCode and HTML and have the suggestion #3 above show or don't show based on this setting.

5. Have a "Posted By" field show up when displaying an article and have it put in the username of the person who posted it. Even show the "Posted By" when listing articles. This is useful for when the article author is not the same as the person of posted it.

6. An ACP option to choose who is allowed to post/edit/view articles in each category. This is good if you want users to just post articles to a particular category and then you move them to the appropriate spot later. It is also good if you have a series of articles that you want to be available only to your moderators or admins.

7. An option in the ACP to change the Display Order when viewing the list of articles/categories without having to edit each individual article/category. The same way that the forum listing allows you to change the display order without having to edit each individual forum.

8. And lastly (probably not), Add a "Search" feature or tie the articles into the existing vBulletin search routine.

I want to replace my existing FAQ section (which is currently housed in a forum so it can be searched) with this one because it has so much potential.

Overall, good work tho.

Holidazed 08-07-2003 07:11 PM

I just noticed that when an article is posted, the font is very small. If anybody else is having this problem, just do the following.

Edit the "vbArticles_articleview" template.

Look for:

PHP Code:

<smallfont>$content</smallfont

and replace it with:

PHP Code:

$content 

That's it. If you want to add a font tag to it, you can. this way your users can just type in the article and it will display int he font of your choice. Something like this:

PHP Code:

<font face="Arial" size="3">$content</font


Holidazed 08-07-2003 07:48 PM

For those of you who cannot leave well enuf alone, here is something I changed. I wanted the "Recently Added Articles" section to be listed at the top. Here is how you do that.

Edit the "vbArticles_main" template and look for
PHP Code:

<table cellpadding="4" cellspacing="1" border="0"  width="100%">
<
tr id="cat">
    <
td align="left" background="https://vborg.vbsupport.ru/images/catbg_ukc.gif" bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan="2"><normalfont color="#000000"><b>$top5catname</b></normalfont></td>
</
tr>
<
tr align="center">
          <
td bgcolor="#1D6AA0" align="left"><smallfont color="#EEEEFF"><b>Title</b></smallfont></td><td width="50" bgcolor="#1D6AA0" align="center"><smallfont color="#EEEEFF"><b>Views</b></smallfont></td>

</
tr>
$top5listbit
</table

Remove it. Now look for
PHP Code:

<table cellpadding="0" cellspacing="0" border="0" bgcolor="#0A293E"  width="95%" align="center"><tr><td

Just below that, add
PHP Code:

<table cellpadding="4" cellspacing="1" border="0"  width="100%"><tr id="cat"><td align="left" bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan="2"><normalfont color="#000000"><b>$top5catname</b></normalfont></td></tr><tr align="center"><td bgcolor="#1D6AA0" align="left"><smallfont color="#EEEEFF"><b>Title</b></smallfont></td><td width="50" bgcolor="#1D6AA0" align="center"><smallfont color="#EEEEFF"><b>Views</b></smallfont></td></tr>$top5listbit</table



All times are GMT. The time now is 12:56 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.04461 seconds
  • Memory Usage 1,886KB
  • 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
  • (11)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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