Search found 62 matches

by AwesomeStyle
Mon Dec 02, 2013 7:37 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

ViolaF wrote:
AwesomeStyle wrote:I used * (all tables).
so more server load ;)
Oh, thanks for the notice :)
by AwesomeStyle
Mon Dec 02, 2013 7:19 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

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).
by AwesomeStyle
Mon Dec 02, 2013 6:29 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

ViolaF wrote:its always better, when a last-x-file works completely standalone ;)
What is a last-x-file?
by AwesomeStyle
Mon Dec 02, 2013 4:50 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

ViolaF wrote:takes a time, bcs. the code is a bit crappy and must be re-written.
it goes normally more simple, so be a bit patient ;)

where is $forum_id_where defined?
$forum_id_where is not defined, I guess that it is defined in the incuded phpBB files?
by AwesomeStyle
Mon Dec 02, 2013 4:35 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

T0ny wrote:Where are you creating the $posts_row array?
It is created in the included PHP code.

ViolaF wrote:give me some minutes, i check it...
Current code: http://pastebin.com/raw.php?i=WqSr9Xiq
by AwesomeStyle
Mon Dec 02, 2013 4:03 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

but the $posts_row['post_text'] code won't work. what dont work? please Xplain.. The code for returning the first post TEXT (content) is returning an empty string. Other functions that use topic table (phpbb_topics) are working (topic title, author, etc.). I need a code that will fetch last 5 topic...
by AwesomeStyle
Mon Dec 02, 2013 8:03 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Re: Latest topics code is fetching replies too

I got it working, here is the current code: $announcement_topics = 'SELECT * FROM ' . TOPICS_TABLE . ' JOIN ' . POSTS_TABLE . ' ON ' . TOPICS_TABLE . '.topic_first_post_id = ' . POSTS_TABLE . '.post_id ' . $forum_id_where . ' WHERE ' . TOPICS_TABLE . '.topic_approved = 1 AND ' . $db->sql_in_set("" ....
by AwesomeStyle
Sun Dec 01, 2013 9:39 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: Latest topics code is fetching replies too
Replies: 25
Views: 2690

Latest topics code is fetching replies too

Hi! The following code also returns replies due to posts table being included in the MySQL query. I need the posts table included because I need the topic text. $announcement_topics = array(); $announcement_forums = array(2); $announcement_topics = 'SELECT * FROM ' . TOPICS_TABLE . ', ' . POSTS_TABL...
by AwesomeStyle
Sun Oct 20, 2013 6:50 am
Forum: [3.0.x] Styles Support & Discussion
Topic: Can someone tell me from what imageset is this picture?
Replies: 2
Views: 97

Can someone tell me from what imageset is this picture?

Can someone tell me the name of the style that is using these? All images are in GIF and in 30x30.

Image - forum_read.gif
Image - forum_topic_read_locked.gif
Image - sticky_read.gif

Thanks!
by AwesomeStyle
Sat Oct 05, 2013 7:18 am
Forum: [3.0.x] Styles Support & Discussion
Topic: How to make a 'flat' logo like new Google logo?
Replies: 2
Views: 324

How to make a 'flat' logo like new Google logo?

Hello,

How can I make a flat logo like the new Google logo?
Image

Thanks :)
by AwesomeStyle
Fri Oct 04, 2013 9:03 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Is this a phpBB 3.0.12 bug?
Replies: 6
Views: 281

Re: Is this a phpBB 3.0.12 bug?

pit-PL wrote:The second link has been visited.
Oh, stupid me... Thanks.
by AwesomeStyle
Fri Oct 04, 2013 8:17 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Is this a phpBB 3.0.12 bug?
Replies: 6
Views: 281

Re: Is this a phpBB 3.0.12 bug?

pit-PL wrote:Just remove font-size: 1em;
I know, but is the object height lower then normal on purpose?
EDIT: What about the link colour scheme bug?
by AwesomeStyle
Fri Oct 04, 2013 8:05 pm
Forum: [3.0.x] Styles Support & Discussion
Topic: Is this a phpBB 3.0.12 bug?
Replies: 6
Views: 281

Re: Is this a phpBB 3.0.12 bug?

Well, take a look at the arrow in the select menu. And the size is different.

Go to advanced search