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

[cinq]

Just an update, optimized several queries with some help here

Working on a report comment, edit comment, delete comment feature now.
Once done, will download FCK and give it a go.

I think I will then wrap things up with an installation script ( 40+ templates, many settings and phrases to create, plus 4 db tables creation ) , if FCK goes smoothly .... unlike spaw ...

[Torqued]

woo hoo! can't wait to see this hack!

[sabret00the]

Originally Posted by cinq

Problem 2 solved ! ( thanks Rake ! )

Code used :

PHP Code:

 # previous and next article links
    if($nextone = $DB_site->query_first("SELECT articles_articleid FROM " . TABLE_PREFIX . "articles_article WHERE articles_articleid > $artid AND categoryid = $categoryid ORDER BY articles_articleid ASC LIMIT 1"))
    {
        $nextone = $nextone['articles_articleid'];
        $nextarticle = 1;
    }

    if($previousone = $DB_site->query_first("SELECT articles_articleid FROM " . TABLE_PREFIX . "articles_article WHERE articles_articleid < $artid AND categoryid = $categoryid ORDER BY articles_articleid DESC LIMIT 1"))
    {
        $previousone = $previousone['articles_articleid'];
        $prearticle = 1;
    } 


Decided to put in

PHP Code:

AND categoryid = $categoryid 


to limit to previous or next articles in the same category.

you can do that in one query.

[sabret00the]

Originally Posted by nexialys

1- pagination is a 3 lines code... already have something inside vB for that.

wow, it is, i haven't ever rewritten the code i was giving along time ago for sorting pagenav but the code i have is 30 lines long :shock:

please share the knowledge

[cinq]

Originally Posted by sabret00the

you can do that in one query.

Would be nice if you could share how to ?

[cinq]

report comment, edit and delete comment done.
FCK's basic WSYIWYG integration works too, now working on the image upload handling in FCK.

[sabret00the]

something like this

PHP Code:

    if ($nextone)
    { // set the variables
            $nextone = $nextone['articles_articleid'];
            $nextarticle = 1;
        $articlenav_direction = ">";
        $articlenav_order = "ORDER BY articles_articleid ASC";
    }
    else if ($previousone)
    {
        $previousone = $previousone['articles_articleid'];
        $prearticle = 1;
        $articlenav_direction = "<";
        $articlenav_order = "ORDER BY articles_articleid DECS";
    }

    $articlenav = $DB_site->query_first("SELECT articles_articleid FROM " . TABLE_PREFIX . "articles_article WHERE articles_articleid $articlenav_direction $artid AND categoryid = $categoryid $articlenav_order LIMIT 1"); 


far from impressive really, both acheive the same thing as well, theris really no reason to switch since it don't perform the query unless asked to.

[cinq]

I don't think your code does what I need it to do.
I need to query 2 times first to know if there are next or previous articles available.

In your code, if($nextone) or if($previousone) has no value initially...

[cinq]

Hmm FCK's default resource browser is really confusing. I have stripped away code to simplify it but not exactly giving the full functionality I would hope for.

ie. when adding an article, a folder for that article for its images is automagically created and when browsing should be only able to see this created folder.
However it now sees all folders. There is no way to pass the folder path to FCK to tell it to dynamically only show that particular folder.

It just means that you will have to manually search for the folder ( i will provide an folder number for you to search for ), click on it, to show all the images, or upload images there as well.

If this sounds about good, I consider this hack done and I will move on to the installation script. Please let me know.

[sabret00the]

Originally Posted by cinq

I don't think your code does what I need it to do.
I need to query 2 times first to know if there are next or previous articles available.

In your code, if($nextone) or if($previousone) has no value initially...

the determination of the preview or next article before hand is impossible via my way you're right i apologise, however the $next and $preview comes from the url

i.e.

<a href="http://localhost/forums/article.php?a=104845&nextone">next one</a>

the code would work but not for what you need it for without getting creative in the most awesome ways imaginable :lol: joking.