AJAX meets extern.php: Active topics etc. (Page 2 of 2)

FxPatrice wrote:

Thanks ... It work with FF now, but I have problem with accentuated characters

Directly from extern.php I have no problem (http://forum.windows.free.fr/forum/exte … length=100) :

* panne d'enregistrement depuis la mise en veille
* récupérer tous les pilotes de son ordi
* photo
* FREE ADSL : retour à la normale le 17 mars en zone non dégroupée
* windows xp
* Freebox Haute Définition chez Free avant la rentrée 2006
* Problème synchronisation profil
* Mots chinois
* installation du SP2 impossible
* FAT 32 ou NTFS?

But with AJAX Active public topics it looks like :

* panne d'enregistrement depuis la mise en veille
* r?cup?rer tous les pilotes de son ordi
* photo
* FREE ADSL : retour ? la normale le 17 mars en zone non d?group?e
* windows xp
* Freebox Haute D?finition chez Free avant la rentr?e 2006
* Probl?me synchronisation profil
* Mots chinois
* installation du SP2 impossible
* FAT 32 ou NTFS?

I have "?" instead of "é" ... probably the same thing with other accentuated characters, I don't have  made other tests.

Can you help me ?

Thanks

That's because javascript have problems handling it without any specific headers (in this case, utf-8).

To fix, do the following:
1. Open extern.php, and find on line 245:

        $result = $db->query('SELECT t.id, t.subject FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.moved_to IS NULL'.$forum_sql.' ORDER BY '.$order_by.' DESC LIMIT '.$show) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

Below add:

        if(isset($_GET['utf-8'])) @header("Content-type: text/html; charset=utf-8"); // Needed for accented characters w. JS/Ajax

2. Open ./include/js/ajax_extern.js, and fine on line 25:

var extern_query = 'extern.php?action=active&show=10&length=100&rnd='+rnd;

Replace with:

var extern_query = 'extern.php?action=active&show=10&length=100&utf-8=1&rnd='+rnd;

3. Save, upload and enjoy accented characters that looks correct

Pekz0r wrote:

I would like to see who made tha latest post too

I want a table like this:
Topic 1    <time> by <nick>
Topic 2    <time> by <nick>
Topic 3    <time> by <nick>

For example: 
test topic         19:30:45 by pekz0r

I gues it shouldn't be too hard to fix, i'm giving it a try myself

The best would probably be to edit the extern.php and not this script

I need too

[category] Topic1 by <nick>      <time>
[category] Topic2 by <nick>      <time>
[category] Topic3 by <nick>      <time>

ex.

[Test forum] Test post by FruitCake  [20:36:35]