Latest topics code is fetching replies too

[AwesomeStyle]

Thanks for the code, it works perfectly.
It seems that the problem was in the posts_row; when I changed it to topics_row it worked.
Also, you don't need to specify all tables in the SELECT statement. I used * (all tables).

[ViolaF]

I used * (all tables).

so more server load

[AwesomeStyle]

I used * (all tables).

so more server load

Oh, thanks for the notice

[ViolaF]

no prob'. here you can see, which columns are unneeded loaded, if * is in use
https://wiki.phpbb.com/Table.phpbb_topics

[AwesomeStyle]

When I want to put the code in a class, I get this error:

Code: Select all

Fatal error: Cannot redeclare deregister_globals() (previously declared in C:\xampp\htdocs\includes\startup.php:47) in C:\xampp\htdocs\includes\startup.php on line 114

Current code:
http://pastebin.com/raw.php?i=4V5s00ZP

[ViolaF]

just remove the doubled function (not the global, but the xtra)

[ViolaF]

what is startup.php and why you use [size=130]*[/size] again to fetch topic columns data from table?
ok, your choice. also you can use http://php.net/manual/en/function.function-exists.php

Code: Select all

if (!function_exists('deregister_globals')) {
$your_doubled_deregister_globals_whatever_function;
} 

i think you should over-thought some intentions of the code and clean it a bit.

[Paul]

When I want to put the code in a class, I get this error:

Code: Select all

Fatal error: Cannot redeclare deregister_globals() (previously declared in C:\xampp\htdocs\includes\startup.php:47) in C:\xampp\htdocs\includes\startup.php on line 114

Current code:
http://pastebin.com/raw.php?i=4V5s00ZP

You include common.php twice.

[AwesomeStyle]

When I comment out the code in the main() function in my class that is including common.php twice, I get this error:
Call to a member function sql_in_set() on a non-object

It is important to me that I have the portal class in another PHP file so I can include the code in any external phpBB script and call/use the class I want.

[Paul]

you need to add global $db; if you want to use the global $db variable.

[AwesomeStyle]

Thanks for the answer, I got working everything that I wanted thanks to a great support