6,026

(18 replies, posted in Feature requests)

Would it be possible to make a basic search without the indexation tables, as you can do with other forums like phpBB?

PunBB's search feature is based on phpBB's tongue
And changing the search function to be the way you want it would be less efficent I believe, even if it does save DB space

6,027

(4 replies, posted in PunBB 1.2 bug reports)

https://bugzilla.redhat.com/bugzilla/sh … ?id=158729

> So must be something wrong with my apache, its self compiled

That's likely your problem.  The Fedora httpd package is patched to use the
system pcre library - otherwise another bundled copy of pcre gets linked in.

And no, it's not PunBB's fault. The function exists. It's not PunBB's job to check that the libraries linked to Apache and PHP are valid (although Rickard should probably put in some sort of check to make sure that preg expressions are supported)

6,028

(22 replies, posted in PunBB 1.2 troubleshooting)

You can NOT add $_GET variables to a file on the local filesystem tongue
Use the URL to extern.php

6,029

(4 replies, posted in PunBB 1.2 bug reports)

http://bugs.php.net/bug.php?id=31501&edit=2
In other words, it would appear you're not using the PCRE library bundled with PHP

6,030

(13 replies, posted in Programming)

Oh, I thought you wanted all the highscores
Did you say you added a column is_topscore to rows on arcade_ranking? Then just change my query to

select username, count(*) as total_scores from arcade_ranking inner join users on (users.id = arcade_ranking.rank_player) where arcade_ranking.is_topscore = 1 group by arcade_ranking.rank_player order by total_scores desc LIMIT 3

6,031

(22 replies, posted in PunBB 1.2 troubleshooting)

elbekko wrote:
$action="active";
$show=10;

include($_SERVER['DOCUMENT_ROOT'].'/forum/extern.php');

won't work wink What you could do is this:

$action="active";
$show=10;

include($_SERVER['DOCUMENT_ROOT'].'/forum/extern.php?action='.$action.'&show='.$show);

Now, for your problem, it's best to put them all in the same foder, else PunBB won't handle it too well wink

That won't work at all tongue
As I've said many times before, you can NOT add $_GET variables to a file on the local filesystem

It looks like you have support for MySQL via DBX. You need to load the MySQL or MySQLi extension for PHP

I think it's how your MySQL tables are set up
Talk to the person who runs the server

6,034

(22 replies, posted in PunBB 1.2 troubleshooting)

The index.php is from the CMS, not PunBB?
And extern.php is in the same folder as a properly working config.php?
And you do realize your variables won't do anything, right?

Nope, the documentation is right (assuming you have allow_url_fopen)
Give me the page where you're including it now and getting an error?

That's an HTML file, not a PHP file
You need to save it as .php or tell your server to parse HTML as PHP
But in general, you can only call with parameters in $_GET via URL (as you're doing) if you have allow_url_fopen. If you don't, you can't include the extern.php vars that way (the server would look for a file called extern.php?action=new&show=3)

6,037

(13 replies, posted in Programming)

ah, OK

select username, count(*) as total_scores from arcade_ranking inner join users on (users.id = arcade_ranking.rank_player) group by arcade_ranking.rank_player order by total_scores desc LIMIT 3

Well, there's nothing in the code that would make it behave differently: try removing the @ in front of it and see if you get an error

Ah, k
Yeah, talk to the administrator

Nevermind, I think I found the issue:
http://bohumin.php5.cz/viewtopic.php?id=1

<meta http-equiv="Content-Type" content="text/html; charset=cp-1250" />

The fix: http://punbb.org/forums/viewtopic.php?pid=59543#p59543
You might also talk with the person who runs your server: they might have changed the way MySQL is set up

What is the URL?

6,042

(13 replies, posted in Programming)

That's different from what you said originally and is different from what I said tongue
Anyways, just answer this: Would those 30/20/10 highscores be from ONE game, or ALL the games combined?
And if it's for one game, do you want this to only return for one game or do you want it to be ordered by the game ID first and then by the number of highscores?

6,043

(13 replies, posted in Programming)

ango: Because max returns the max from the returned results.
I'm not even sure what you're asking for though
Do you just want to grab the number of entries in the highscore table per user and sort by that?

6,044

(3 replies, posted in Feature requests)

Ah, I see, I didn't realize that date() didn't have a way to use different langauge settings

6,045

(3 replies, posted in Feature requests)

You can do that in Admin Options, can't you?

6,046

(2 replies, posted in PunBB 1.2 bug reports)

The code there should be removed
That's a working XSS affecting IE

Dr_UF0_51: You should have reported the bug directly to the email shown in the Bug reports description (I'm deliberately not saying the name of it tongue)
I've sent it now, so don't worry

Use forward slashes as opposed to backslashes
I believe you have to escape backslashes (so c:\php\ext\ would become c:\\php\\ext\\) otherwise

6,048

(71 replies, posted in News)

What makes you assume he kept his copy of PunBB somewhere? tongue

6,049

(71 replies, posted in News)

Strofanto wrote:
Smartys wrote:

What are you talking about? tongue
Download a copy of PunBB, look in the extras folder, there's a 12_to_1211_update.php file. Upload it to your forum directory, run it, delete it tongue

You lazy tongue

As opposed to what? PunBB is already set up to work without editing the file

6,050

(11 replies, posted in Feature requests)

pere wrote:

Thanks Smartys and elbekko. Then I will test punBB.

Might I run into other problems setting this to 0.0.0.0? Are there things like spam-filters that can stop multiple posts from the same IP? Would making it return a hash or encrypted IP be better?

I am always a bit sceptical to making such changes to the source, since it might make upgrading a lot more difficult. If we make such a change, and integrate it as a user-selectable option, could it be submitted to your CVS?

I seriously doubt Rickard would add the option for users to choose to hide their IP, simply because it makes tracking down and dealing with abusive people much more difficult)
And the only thing changing that would affect is registration (currently it's set to only allow one registration per hour, but you can change that in register.php or by using a mod that makes it a config option).