Search found 239 matches

by Ciao121
Mon Mar 14, 2011 2:38 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Fist topic post text
Replies: 0
Views: 123

Fist topic post text

Hi,
I need to store the first topic post's text in a variable in viewtopic.php (just the text without smilies, bbcodes, etc... but this is another question).

Is there a quick way to do this?
by Ciao121
Tue Nov 30, 2010 2:41 pm
Forum: [3.0.x] Support Forum
Topic: Where is this query form
Replies: 2
Views: 276

Re: Where is this query form

Found an http call like this:
"GET /viewtopic.php?p=5192068%20and%205=6%20union%20select%20concat(0x5E252421,ifnull(`user_id`,0x4E554C4C),char(9),ifnull(`user_email`,0x4E554C4C),char(9),0x2A5B7D2F)%20from%20`phpbb`.`phpbb_users`%20limit%20255769,1%20%20-- HTTP/1.1"

What is this "user" trying to do???
by Ciao121
Tue Nov 30, 2010 2:33 pm
Forum: [3.0.x] Support Forum
Topic: Where is this query form
Replies: 2
Views: 276

Where is this query form

Hi,
today I have an high load on my server and I saw many queries like this one:
"SELECT forum_id FROM phpbb_posts where post_id=5192068 and 5=6 union select concat....."
Seems a strange query to me (what does it means "5=6"?)... :shock:
by Ciao121
Sun Oct 10, 2010 5:18 pm
Forum: [3.0.x] Support Forum
Topic: Global survey and sticky permissions
Replies: 1
Views: 126

Global survey and sticky permissions

Hi,
I cannot find a way to make a single user capable of creating surveys and sticky topics in all forums. I can make those permissions forum by forum but how can I make it for all areas?

Thank you!
by Ciao121
Tue Oct 05, 2010 9:44 pm
Forum: [3.0.x] MODs in Development
Topic: [Beta] Sphinx search for phpBB 1.0.beta2
Replies: 294
Views: 89429

Re: [Beta] Sphinx search for phpBB 1.0.beta2

Help please...
It seems to me that searches from inside phpbb only searches the delta index.
Searching from the command line, with the same conf file, return results from bot main and delta indexes.

Any idea??? :cry:
by Ciao121
Sun Sep 05, 2010 12:05 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Where is this query from?
Replies: 9
Views: 212

Re: Where is this query from?

Mysql. Had problem using MyISAM. Tried to switch to InnoDB but problem was still here.
by Ciao121
Sat Sep 04, 2010 5:52 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Where is this query from?
Replies: 9
Views: 212

Re: Where is this query from?

The long time needed seems to be due the "AND p.post_approved = 1" part of the query. It seems to me this filter should only be present in the query if topic is in a forum requiring messages to be approved. I don't have any forum requiring it (maybe I made a little confusion with permissions). So, t...
by Ciao121
Fri Sep 03, 2010 11:39 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Where is this query from?
Replies: 9
Views: 212

Re: Where is this query from?

It's taking long long time to execute on my db. up to 300/400 seconds sometimes :(
by Ciao121
Fri Sep 03, 2010 11:32 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Where is this query from?
Replies: 9
Views: 212

Re: Where is this query from?

Someone moved my question here.. so maybe the query is from a mod?
by Ciao121
Fri Sep 03, 2010 11:28 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Where is this query from?
Replies: 9
Views: 212

Where is this query from?

Hi need to understand which page/script is originating the following query:

Code: Select all

Query SELECT p.post_id FROM phpbb_posts p WHERE p.topic_id = 94097 AND p.post_approved = 1 ORDER BY p.post_time DESC LIMIT 21581, 15
THank for your help.
by Ciao121
Tue Apr 20, 2010 11:30 am
Forum: [3.0.x] Styles Support & Discussion
Topic: Custom Page with custom style
Replies: 18
Views: 1419

Re: Custom Page with custom style

Brf wrote:When you call $user->setup() on that page, pass the style number as the second parameter:

Code: Select all

$user->setup('',4);
That solved my problem. Thank you :)
by Ciao121
Tue Apr 20, 2010 10:26 am
Forum: [3.0.x] Styles Support & Discussion
Topic: Custom Page with custom style
Replies: 18
Views: 1419

Re: Custom Page with custom style

Sorry, I forgot the link:
http://www.phpbb.com/kb/article/add-a-n ... -to-phpbb/

My Board uses prosilver style as default one.
I want my custom page (only the custom page) to use a different style.
by Ciao121
Tue Apr 20, 2010 8:50 am
Forum: [3.0.x] Styles Support & Discussion
Topic: Custom Page with custom style
Replies: 18
Views: 1419

Custom Page with custom style

Hi all,
I made a custom page using this tutorial.
But it uses the board default style. How can I specify to use a different style?

Thank you :)
by Ciao121
Fri Apr 16, 2010 4:10 pm
Forum: [3.0.x] MOD Database Releases
Topic: phpBB Statistics
Replies: 294
Views: 66164

Re: phpBB Statistics

fine! ;)
by Ciao121
Fri Apr 16, 2010 2:21 pm
Forum: [3.0.x] Support Forum
Topic: Convert phpbb_posts to Innodb
Replies: 5
Views: 856

Re: Convert phpbb_posts to Innodb

Thanks :)

Go to advanced search