INI Config File For Wikidot Open Source

30 Aug 2008 00:16

Hello,

today I managed to create configuration file mechanism for Wikidot — based on INI file.

I posted two files — minimal one and one containing all possible options to the SVN repository:

Moreover I polished the PingBack mechanisms for Wikidot.

Comments: 7

SQL King

21 Aug 2008 10:00

Are you an SQL King?

I once met a person that used to write SQL queries more sophisticated than this:

select *
    from category
    where category_id IN
        (select cat1 as category_id
            from (select min(category_id) as cat1, max(category_id) as cat2, name, site_id, count(*)
                from category
                group by name, site_id
                having count(*) > 1
            ) as c1
        union    select cat2 as category_id
            from (select min(category_id) as cat1, max(category_id) as cat2, name, site_id, count(*)
                from category
                group by name, site_id
                having count(*) > 1
            ) as c2
        );

This one is to check duplicated categories in sites from Wikidot. It's not optimal, but it works. Of course the situation when there exist duplicated categories is a bug, but it seems a really rare one, because from the beginning of Wikidot, there are only 20 such categories, all of them being forum, so this probably means a small bug in create a forum thing as well.

Comments: 2

Badge

16 Aug 2008 16:30

Wonder why blog on Wikidot, not on Wordpress?

With Wikidot, you can give your badges a reflection:

(this one was created with Cooltext)

Welcome on Wikidot. Where dreams come true.

How to do this

Put somewhere on your wiki:

[[image http://piotr.gabryjeluk.pl/local--files/blog:side/badge.gif class="reflect"]]
[[embed]]
<script type="text/javascript" src="http://static.wikidot.com/common--misc/reflection.js"></script>
[[/embed]]

Comments: 1

More Juice

07 Aug 2008 14:12

Hi, today we've put more juice to Wikidot.

Here is automatic reflection generation:

Wonder how?

[[embed]]
<script type="text/javascript" src="http://static.wikidot.com/common--misc/reflection.js"></script>
[[/embed]]
[[div style="background: #444; padding: 20px; overflow: auto"]]
[[div style="margin: 0 auto; width: 400px"]]
[[image http://qn.lastlook.pl/~quake/wikidot-grass.png class="reflect rheight32 ropacity40"]]
[[/div]]
[[/div]]

We've also added many new video services to Wikidot (through [[embed]] tag) and more…

Comments: 3