[cinq's vbArticles v1.0 Hack] - The development process

[rake]

PHP Code:

// only get subcats
$cats = $DB_site->query("SELECT * FROM cats WHERE parent <> 0");
while($cat = $DB_site->fetch_array($cats))
{
  $cat_cache["$cat[parentid]"]["$cat[order]"] = $cat;
}

// only get parents
$parents = $DB_site->query("SELECT * FROM cats WHERE parent=0");
while($parent = $DB_site->fetch_array($parents))
{
     foreach($cat_cache as $pr)
     {
          foreach($pr as $order => $subcat)
          {

                 eval here
          }
       }

} 


Might be some errors in there, but you get the idea of how it should work. Just 2 queries.

[cinq]

With regards to the Similar Articles issue, this is what I have got now, but it is giving me a big headache :

PHP Code:

$similarlist = explode(" ", $title);
        $countsimiliar = sizeof($similarlist);

        for($j = 0; $j < $countsimiliar; $j++)
        {
            $nochars = strlen(''.$similarlist[$j].'');
            if($nochars > 4)
            {
                $similarquery2 .= "title LIKE '%".$similarlist[$j]."%' OR content LIKE '%".$similarlist[$j]."%' ";
                if ($j < $countsimiliar-1)
                {
                    $similarquery2 .= " AND ";
                }
                $markyes =1;
            }
        }

        if($markyes==1)
        {
            $similarquery = "SELECT * FROM " . TABLE_PREFIX . "articles_article WHERE ";
        }
        $similarquery = $similarquery.$similarquery2; 


It works fine if the last word in the title has more number of characters than the limit, which is set by $nochars>4 in this case.
But if not, an extra AND will be appended to the query.....

so for e.g, a title like "Review of the Nvidia Nforce Chip"
That would fail, since the last word Chip consists of only 4 characters.

how could I go about this ?

So close yet so far...
My head is spinning .....

[rake]

Here i am again to offer the solution..

remove this if entirely:
if ($j < $countsimiliar-1)

and add the and argument after each call condition.

then, just before
$similarquery = $similarquery.$similarquery2;

add

$similarquery2 = substr($similarquery2, 0, -4);

[cinq]

I really appreciate your help rake , really sorry I need to impose on you.
[high]* cinq worships rake
[/high]

I will try that code in post 34 soon.

[rake]

No problem. I'm glad i am able to help. Just post if you need more advice.

[cinq]

Originally Posted by rake

Here i am again to offer the solution..

remove this if entirely:
if ($j < $countsimiliar-1)

and add the and argument after each call condition.

then, just before
$similarquery = $similarquery.$similarquery2;

add

$similarquery2 = substr($similarquery2, 0, -4);

Problem Number One Implemented ! - (thanks to rake)
It works !

[rake]

I just realised this: that AND should actually be OR

[cinq]

Originally Posted by nathanaus

Maybe this isn't really appropriate (I'm new forgive me) but what would be nice to see in it:

1. Ability to give reputation points to an article author.

2. There is a hack here to gie award to posts, could something similar be done that if an article is well written there is an option for the admin to give an "award" with associated image that sticks to the article indicating that it won an award for "good article writing" or soemthing?

Hi nathan
I am sorry but I do not intend to make those 2 features you suggested default for this hack.

But in the future, they may come as add-ons to this hack.

As it is, I hope to wrap up the current feature set I have in mind and push it out for beta testing

[cinq]

Originally Posted by oly51

Right. I was referring to a thumbnail in the article proper. Say someone was writing a 'how-To' article. In the article, they put a text paragraph and in the next paragraph, they put a thumbnail that shows what the text in that paragraph is describing. The thumb would be on the left (or right) and the text would go to the side and under the thumb.

Sorry for not being clear.

I guess you mean adding images to the article content.
Actually, that's where I am trying to add a WYSIWYG editor to the add article page ( which should only be accessible to the admin for now because it should allow uploads of the image ).

However I have yet to find a suitable textarea replacement, as mentioned on the first few posts of this thread.
I have just found that SPAW actually accepts dynamic image libraries which can be put to use but then, I cannot seem to get it to work ( the includes ) on my localhost...

[cinq]

Originally Posted by rake

PHP Code:

// only get subcats
$cats = $DB_site->query("SELECT * FROM cats WHERE parent <> 0");
while($cat = $DB_site->fetch_array($cats))
{
  $cat_cache["$cat[parentid]"]["$cat[order]"] = $cat;
}

// only get parents
$parents = $DB_site->query("SELECT * FROM cats WHERE parent=0");
while($parent = $DB_site->fetch_array($parents))
{
     foreach($cat_cache as $pr)
     {
          foreach($pr as $order => $subcat)
          {

                 eval here
          }
       }

} 


Might be some errors in there, but you get the idea of how it should work. Just 2 queries.

Sorry rake, but I don't quite get your code ... ( noob here )

but your solution could potentially teach me how to deal with handling queries in nested while loops ( which I keep using now ..... )

could you take the time to explain this to me, please ?