Ravens PHP Scripts: Forums
 

 

Search found 16 matches
Author Message
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sat Jun 26, 2010 8:16 am   Subject: re: Optimize this Code!
hi, sorry about that

this line:


$mcontent=$db->sql_fetchrow($result)

Should be:
$mcontent=$db->sql_fetchrow($result);

Just a ; at the end.

Sorry about that.
i have received ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 20, 2010 8:57 am   Subject: re: Optimize this Code!
thanks for your help.
i have added the above lines only in viewtopic.php and get this error
Parse error: syntax error, unexpected T_STRING in /home/******/public_html/*********/modules/Forums/vi ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sat Jun 19, 2010 7:36 pm   Subject: Re: Optimize this Code!
I'm not 100% positive, but you may want to index both topic_id and user_id.

This should help significantly.
i have indexed topic_id and user_id and still same problem Sad
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sat Jun 19, 2010 6:18 pm   Subject: re: Optimize this Code!
Hello all,
Sorry for the delayed reply
As far as indexing is this what you are referring to??
http://img64.imageshack.us/img64/7844/nukwbbthanksbigger.jpg
I have created this index but i am still ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Mon Jun 14, 2010 8:15 am   Subject: Re: Optimize this Code!
Make sure that the t.topic_id field is indexed. Without it, the OR has to do a full table scan.thank you for your reply Raven,
Sorry for such a dumb question but how do I check if t.topic_ID is ind ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 13, 2010 10:03 pm   Subject: re: Optimize this Code!
You may need to "browse" your tables and find a topic_id number that really exists. Then a user_id that really exists. Then combine them to move on. Or try the two sets of conditions that are separ ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 13, 2010 4:19 pm   Subject: Optimize this Code!
SELECT p.topic_id, t.topic_id
FROM nuke_bbthanks p, nuke_bbtopics t
WHERE (p.topic_id = 28935
AND p.user_id = 2)
OR (t.topic_id =28935
AND t.topic_poster = 2)
MySQL returned an ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 13, 2010 4:12 pm   Subject: re: Optimize this Code!
once again thank you for your reply
i did this SELECT p.topic_id, t.topic_id
FROM nuke_bbthanks p, nuke_bbtopics t
WHERE p.topic_id = 28935
AND p.user_id = 2
OR t.topic_id =28935
AND t.topic_pos ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 13, 2010 3:40 pm   Subject: Optimize this Code!
Showing rows 0 - 29 (28,257 total, Query took 0.0005 sec)

thats the size of nuke_bbthanks
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 13, 2010 3:32 pm   Subject: re: Optimize this Code!
I can't "teach" PHPmyadmin here. Basically, if you open it up and open up a SQL window (it's on one of the tabs within) you could paste the query from the code you posted. Then substitute for the va ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sun Jun 13, 2010 12:45 pm   Subject: Re: Optimize this Code!
I'd open up PHYmyadmin and copy the queries there (especially the ones associated with viewtopic.php). You'd need to modify the queries a bit to get them to run in PHPmyadmin since you wouldn't have ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sat Jun 12, 2010 5:37 pm   Subject: re: Optimize this Code!
Hi,

Really, this should not be causing your forums to load slowly. I could imagine if the mysql server was slow, this would increase the time to run these extra queries, but really, all you are doi ...
 Topic: Optimize this Code!
nuke_q7

Replies: 25
Views: 76437

PostForum: BBtoNuke Mods   Posted: Sat Jun 12, 2010 12:09 pm   Subject: Optimize this Code!
Hello all,
Could someone look at this code and tell me how it can be improved

##############################################################
## MOD Title: Thanks mod and PhiliWeb Hide BBCode ...
 Topic: File upload 2.4
nuke_q7

Replies: 33
Views: 36262

PostForum: v2.4 RN Issues   Posted: Sun Feb 14, 2010 3:12 pm   Subject: re: File upload 2.4
Would someone be kind enough to show me how to implement this for other images within the forum posts?
For example for all the image links from imageshack amd places like that.
Thx
 Topic: NXP Online
nuke_q7

Replies: 12
Views: 14290

PostForum: Blocks   Posted: Sat Jan 16, 2010 11:30 am   Subject: NXP Online
Palbin,
Thank you for all the fixes!
Block installed without a problem!
It seems like the iplookup table is out of date.
Could you show us how to update the nuke_nxp_online_iplookup table?
 Topic: Lust factors update
nuke_q7

Replies: 48
Views: 77783

PostForum: v2.3 RN Feedback/Suggestions   Posted: Sun Jan 03, 2010 11:08 am   Subject: re: Lust factors update

Forums

Within the forums module integration of a report mod.
Move to PHPBB3 and stop support for PHPBB2 with way LESS integration ... just have a users bridge and that's it. Use the native PHPBB ...
 

 Jump to:   

Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©