Search found 149 matches

by qspypl
Tue Apr 10, 2007 7:02 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

Re: phpBB tweaks for large forums

Hello, Couple hardcore queries any ideas? 209337 root localhost phpbb Query 3 Sending data SELECT user_id, username, user_password, user_active, user_level, user_login_tries, user_last_login_try^M\n\t\t\tFROM phpbb_users^M\n\t\t\tWHERE username = 'lordi1986' OMFG :X ... 16 sec.... 212121 root localh...
by qspypl
Tue Mar 27, 2007 9:57 pm
Forum: [2.0.x] MOD Writers Discussion
Topic: Security, when new .php file in phpbb
Replies: 1
Views: 231

Security, when new .php file in phpbb

Hello, My "mod" is SELECT sql query, which gets users with most posts. But i add a ranking.php file to my phpbb. Im curious it is safe? I mean i got this at start: define('IN_PHPBB', true); $phpbb_root_path = './'; include($phpbb_root_path . 'extension.inc'); include($phpbb_root_path . 'common.'.$ph...
by qspypl
Thu Mar 22, 2007 4:46 pm
Forum: phpBB Discussion
Topic: Prosilver style: first impressions
Replies: 798
Views: 111416

Re: Prosilver style: first impressions

This new style is very unreadable and varation about avatars etc. on right side is not needed.... being orginal by force its not target of phpbb i hope

summary?
hate it ;]
by qspypl
Wed Mar 21, 2007 2:50 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

Re: phpBB tweaks for large forums

i have already question in PW about it... when i find some time i will post hacks but with no support, im not mysql/php expert ;p

actually im ending last two one's
by qspypl
Tue Mar 20, 2007 3:40 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

Re: phpBB tweaks for large forums

Noone want help ;] as usual... but i done it after week by myself. I got now almost all Lanzer's tweak's. Speed gain over 500% overall. Only posting.php to go.... index.php, viewforum.php, viewtopic.php, smilies cachce, bbcode cache, memberlist.php, common.php and i may forgot some... all modified w...
by qspypl
Tue Mar 20, 2007 1:45 am
Forum: [2.0.x] MOD Requests
Topic: Little simple sub-forums change PLZ (!)
Replies: 1
Views: 249

Little simple sub-forums change PLZ (!)

Compatybile loss after splitting query, help viewforum.php find: $sql = "SELECT f.*, p.post_time, p.post_username, u.username, u.user_id, t.topic_id, t.topic_title, t.topic_last_post_id FROM ((( " . FORUMS_TABLE . " f LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id ) LEFT JOIN " ...
by qspypl
Thu Mar 08, 2007 10:56 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

nice news :) but till phpbb3 will be stable and fully "supported" we must help each other with Lanzer's work etc.. If we speaking accidently about it :P i must ask this: Lanzer Ideas Memberlist.php -- Instead of the select statement that selects all users info, an index of user_id is first built. Th...
by qspypl
Thu Mar 08, 2007 6:32 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

Lanzer i <3 U !!!! :D from 10 seconds with 650 users online i got from 1 to 2 seconds.... while surfing topics from 10 seconds to 0.2 to 2 seconds EverettB kissess too :* Someone should rewrite all Lanzer Genius pieces of code for newest phpbb for decent programmers who cant make it by yourself. I m...
by qspypl
Thu Mar 08, 2007 1:04 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

hello, I have problem with my phpbb. When forum got like 400-500 simulateously connections its get like 10 seconds to open a page. BUT, all i caused i think by one query which was grabing (select) p.post_id as u can see all queries got below 1 seconds to coplete, but this specific over 2 seconds... ...
by qspypl
Tue Feb 13, 2007 3:31 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

well good idea but its extremely needed on forum... users like it very much + it combining rank with group + it looks great etc... on kernel 2.6 its crazy: top - 16:25:23 up 11:40, 2 users, load average: 45.26, 48.07, 50.25 :O insane... something is wrong with this kernel im going back to 2.4 but wh...
by qspypl
Mon Feb 12, 2007 11:17 pm
Forum: 2.0.x Discussion
Topic: [2.0.x] Tweaks for large forums
Replies: 1240
Views: 621575

well... HELP :c im running dedicated for my phpbb: 3800 athlon 64 1 GB DDR ram connections to forum at once every day for about 400-500... this is killing the server i mean load average is 16 16 16 almost non stop between 15 p.m to 23 p.m ... Main page loads from 8 to 16 seconds... 14 up to 22 sql q...
by qspypl
Fri Dec 22, 2006 4:16 am
Forum: 2.0.x Support Forum
Topic: Moderators have automatically moderator image (rank)
Replies: 4
Views: 245

nope, that mod was here http://www.phpbb.com/phpBB/viewtopic.ph ... 43&start=0

but it is abandoned... my team in forums change a lot i have very big forum and i must now manually add people in groups special ranks -_-
by qspypl
Wed Dec 20, 2006 8:13 pm
Forum: 2.0.x Support Forum
Topic: Moderators have automatically moderator image (rank)
Replies: 4
Views: 245

Well it works if i make rank moderator as special rank, then edit profile user and give him moderator status. He have then moderator status + moderator image. Its ok... BUT the problem is i cannot assign this rank named "moderator" with moderator.gif image to moderators GROUP. Group is something lik...
by qspypl
Wed Dec 20, 2006 7:17 pm
Forum: 2.0.x Support Forum
Topic: Moderators have automatically moderator image (rank)
Replies: 4
Views: 245

Moderators have automatically moderator image (rank)

Hello, I have migrated from modified phpbb which was have modification that allows every users in MODERATOR group have same rank image. Now if i want add moderator i must put him into group and manually add him a moderator rank image. I want only like before add him into group moderators and rank im...

Go to advanced search