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: 76437 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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: 76437 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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 ![]() |
![]() |
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