Thread Count In Specific Forum For Each User

[Blaizze]

Found one problem with it..

If I have a username with an '... example: Lot's Car

This is what occurs when trying to load the thread page, it doesn't load:

Invalid SQL:
SELECT COUNT(*) AS count FROM thread AS thread WHERE thread.postusername = 'Lot's Car' AND thread.forumid IN (122, 87, 68, 67, 101, 69, 77, 84, 80, 153, 149, 150, 104, 82, 128, 102, 123, 85, 70, 158);

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Car' AND thread.forumid IN (122, 87, 68, 67, 101, 69, 77, 84, 80, 153, 149,' at line 1
Error Number : 1064
Date : Monday, May 28th 2007 @ 11:01:37 AM

Is this fixable at all? :/

Try This:

You must first be a registered member to view any code.

[Blaizze]

Now the thread / post will display but with this error on top of the page...

Parse error: parse error, unexpected '\"' in /var/www/vhosts/************/*******/*******/includes/class_postbit.php(296) : eval()'d code on line 148

[Blaizze]

.......................

[Nick R]

Use;

You must first be a registered member to view any code.

[Blaizze]

Originally Posted by Nick R

Use;

You must first be a registered member to view any code.

Fatal error: Call to a member function on a non-object in /var/www/vhosts/****************/httpdocs/**********/includes/class_postbit.php(296) : eval()'d code on line 162

:/..

I don't understand why this isnt working

It's when there is a " ' " in the username... none of the above have worked so far...

Thanks for helping out, but still having troubles..

[Nick R]

whoops;

You must first be a registered member to view any code.

[Blaizze]

Works good... thanks Nick

[Nick R]

Enjoy it. ;)

[magmagiq1]

Hmmm, its work, but that doesnt display all of threads. Some guy have 3 start threads, but dosplay 0.

help please