Search found 47 matches

by g3ckoman
Sat May 09, 2009 11:20 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Stop people from ripping styles?
Replies: 15
Views: 813

Re: Stop people from ripping styles?

You'd have to have some sort of elite style to be targeting by someone wanting to rip it and if it was THAT good you should think about releasing a version of it to the public :) I spent 5 years in professional design and corperate imaging and i've never had to protect a design. <3
by g3ckoman
Wed Apr 29, 2009 12:53 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

Now... Instead of using this, $member_result = $db->sql_query($sql); while ($leaders = $db->sql_fetchrow($members_result)) { $template->assign_block_vars('group_row.leader_row', array( 'USERNAME' => $leaders['username'], 'USER_ID' => $leaders['user_id']) ); } I'd like to use this. $member_result = $...
by g3ckoman
Wed Apr 29, 2009 12:08 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

What a rookie mistake.

My bad. Thanks mate!
by g3ckoman
Wed Apr 29, 2009 12:03 pm
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

Once I get this working the wrong way, i'll try the join. I have now added template handling. I am getting [phpBB Debug] PHP Notice: in file /includes/session.php on line 2094: strtr() [function.strtr]: The second argument is not an array [phpBB Debug] PHP Notice: in file /includes/session.php on li...
by g3ckoman
Wed Apr 29, 2009 11:55 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

Simple. Just use the "where group_id IN" clause that you used at first, and eliminate both of those outer loops -- both the "foreach" and the first "while". The only things you were missing in your first try was the "where" clause joining the two tables that you have in your last query now and an "...
by g3ckoman
Wed Apr 29, 2009 10:56 am
Forum: [3.0.x] MOD Requests
Topic: Photo/Picture Custom Profile Field
Replies: 15
Views: 963

Re: Photo/Picture Custom Profile Field

I haven't looked at this yet, but it's something I did do for 2.x (photos as well as avatars in profile).

Once i've looked, i'll start a dev topic and link you to it as i work on it.
by g3ckoman
Wed Apr 29, 2009 10:48 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

RMcGirr83 wrote:Running a sql query inside a while loop is a bad idea, IMHO. Just my .02.
I wouldn't even know where to start to get it working any other way.
Your suggestions are welcome ofcourse.
by g3ckoman
Wed Apr 29, 2009 10:32 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

Hi and Thanks, yes now I've got it working I am currently tidying up little snags like that.

I'll post a completed example once I am finished. Add some templates and then we have a BETA mod ;)
by g3ckoman
Wed Apr 29, 2009 10:20 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

Greetings, One idea would be to not use $result again in another loop, while still inside a loop using $result. As doing so sets $result to be the value it was assigned last, thus messing up the outer 'while'. Hi, doesn't seem to causing an issue believe it or not, however you are right and I'll ch...
by g3ckoman
Wed Apr 29, 2009 9:37 am
Forum: [3.0.x] MOD Writers Discussion
Topic: SQL Query issues!
Replies: 35
Views: 793

Re: SQL Query issues!

Any ideas, anyone?
by g3ckoman
Wed Apr 29, 2009 9:34 am
Forum: [3.0.x] MOD Writers Discussion
Topic: phpBB CMS Mod
Replies: 52
Views: 22335

Re: phpBB CMS Mod

I.e. creating your whole custom page in the RTE, using php and refering in that, to a template I.D. (instead of a template name) and then being able to create that template again using the RTE afterwards (or before). Eliminating the need for FTP :twisted:

lol
by g3ckoman
Wed Apr 29, 2009 9:31 am
Forum: [3.0.x] MOD Writers Discussion
Topic: How to change time color?
Replies: 24
Views: 703

Re: How to change time color (Globally)?

Fairly simple to format the date and time, however the date and time are formated as a single string, by a board (or user) default date/time format. You'd need to change this format to a static format for this to work, without hours of programming. To edit both date/time today. 1. Open ./language/en...
by g3ckoman
Wed Apr 29, 2009 8:58 am
Forum: [3.0.x] MOD Writers Discussion
Topic: How to change time color?
Replies: 24
Views: 703

Re: How to change time color (Globally)?

Hehe, this may as well be moved to Mod requests! lol. I'm about to look for you and give you your step by step, but I need to know what page you want to chance the time colour on. If you mean all time colours, this is a major haul and for not much of a change! It doesn't have to be everywhere on th...
by g3ckoman
Wed Apr 29, 2009 8:56 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Displaying topic
Replies: 10
Views: 227

Re: Displaying topic

try echo '<td background="images/registerbg.gif"><font color="#000000"><a href="forum/viewtopic.php?f=' . $row['forum_id'].'&t=' . $row['topic_id'].'">' . $row['topic_title'].'</a></td>'; i've also correct your bloody formatting. HTML formatted with " 's and PHP formatted with ' 's when HTML is in y...
by g3ckoman
Wed Apr 29, 2009 8:53 am
Forum: [3.0.x] MOD Writers Discussion
Topic: Building a browser game
Replies: 5
Views: 470

Re: Building a browser game

I am not sure exactly what kind of game you are thinking to implement with PHP/phpBB. http/php isn't exactly a nice backend to use for a game because you have to keep track of crap like sessions between page loads and if the page should refresh you'll need ajax crap on top of that, etc. If I would ...

Go to advanced search