Ravens PHP Scripts: Forums
| Forum Index • Forum FAQ • Search • Memberlist • Usergroups • Profile • Log in to check your private messages • Log in |
| Search found 16 matches |
| Ravens PHP Scripts And Web Hosting Forum Index |
| Author | Message |
|---|---|
| Topic: Optimize this Code! | |
| nuke_q7 Replies: 25 Views: 76505 
|
 Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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  |
|
| Topic: Optimize this Code! | |
| nuke_q7 Replies: 25 Views: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 76505
|
Forum: 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: 36307
|
Forum: 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: 14297
|
Forum: 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: 77839
|
Forum: 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 ... |
|
| Ravens PHP Scripts And Web Hosting Forum Index |
Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
![[Valid RSS]](https://www.ravenphpscripts.com/images/valid-rss.png "Validate my RSS feed"){kind=small}
