Search options (Page 300 of 307)

Nah, since he wants 2 moderator usergroups, not 1.

No, there is no way to make another group of mods
(Well, that's not true, I modded the code so I have a group of "Forum Mods" in addition to the Moderators)
And the admin forum is simple enough: turn off all rights in the forum for everyone (since only admins will see it)

http://punbb.org/forums/viewtopic.php?id=3753

There was another thread where Rickard said it might be done for 1.3, but I can't find it

The mod I made happened to be changing the name of my index page, and simply changing the name in the file didn't work. For anyone who also has this, the fix is to add a / before the filename

Bah, just some plain SQL in the homepage that gets the info you need works: that's what I do

Oww, shoot, figured it out, one of my mods seems to have given some... un-necessary powers to guests :-/
nvm me then

http://dev.mysql.com/doc/mysql/en/news-4-1-8.html

You mean this?

Ah, yes, it works after upgrading it

But here's a bug:

Additional tables None detected

I have several extra tables in my database

Another bug: Above the first query is a Go back link, below it and above the Queries Done is a Go back link and below the Queries Done is a Go back link.

And finally:

SELECT * FROM #__online where user_id="</div>"

Even though that's a fake example (user_id is numerical) the HTML in it messes up the view of the page slightly

Some ideas for the SQL query thing:
- If you run a select and it returns no data, return a "No data found" message.
- Center the returned values

A bug:

SELECT * FROM #__online;
update #__online set user_id=user_id;

This returns the select and then, at the bottom, gives the queries that have been run (both).

update #__online set user_id=user_id;
SELECT * FROM #__online;

This only returns the select, it doesn't list the queries done.

And something that should be clarified:

SELECT * FROM #__online where user_id = 3

entered works fine

SELECT * FROM #__online where user_id = 3
SELECT * FROM #__online where user_id = 3

gives SQL Error

SELECT * FROM #__online where user_id = 3;SELECT * FROM #__online where user_id = 3;

Executes both queries.

You should mention that if you want to run multiple queries you need to add a ; to the end of each query