Follow us on Twitter!
You cannot teach a man anything; you can only help him find it within himself. - Galileo
Friday, April 18, 2014
Navigation
Home
HellBoundHackers Main:
HellBoundHackers Find:
HellBoundHackers Information:
Learn
Communicate
Submit
Shop
Challenges
HellBoundHackers Exploit:
HellBoundHackers Programming:
HellBoundHackers Think:
HellBoundHackers Track:
HellBoundHackers Patch:
HellBoundHackers Other:
HellBoundHackers Need Help?
Other
Members Online
Total Online: 27
Guests Online: 26
Members Online: 1

Registered Members: 82826
Newest Member: Jakob
Latest Articles
View Thread

HellBound Hackers | Computer General | Webmasters Lounge

Page 2 of 2 < 1 2
Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 18-07-07 23:30
Don't like the look of this:

$visits = mysql_result(mysql_query("SELECT visits FROM site"), 0);
$new = $visits + 1;
$add = mysql_query("UPDATE site SET visits = $new");


And I've only just opened index.php

Not only that, but its fairly query intensive, every page load is many queries, some executed twice! (See one above and source of $site['visits'])

Also, you might want to rethink how func common works

Infact, you might want to completely rethink search.php




Edited by on 18-07-07 23:39
Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 18-07-07 23:43
I wish people didn't use SQL all the time. Accessing your database server is a very expensive process (with regard to time, CPU and RAM). Things like memcached are much quicker, and a memcache extension exists for PHP to access the daemon. Of course on shared hosting it's very rare that something like this is offered, I've certainly never seen it.

Edit: I would try to help specifically with your code but as you're aren't too receptive to code edits I don't really even want to look at the code.




Edited by on 18-07-07 23:44
Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 18-07-07 23:44
That shouldn't stop someone from implementing their own caching functionality...


Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 18-07-07 23:45
Very true of course.


Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 19-07-07 15:43
I know search.php sucks as it only finds exact matches and i didn't use fulltext or LIKE 'blah blah' I considered soundex and similar_text, but they were no help. Im not sure how i could improve function common very much though...

As to repeated queries, on search.php i know there are a few, but when i made the new loop for each word, it couldn't access the old queries...Other pages, the most I remember counting is 18, and I am sure that is not nearly what HBH goes through on every page load...

As to "poor reception to code edits." For the last time this is not true. I know optimizations can occur, but I am not refusing help. If I could speak to you all those posts they would be in the most calm voice. I hope you don't think that's what I'm doing anymore.




Edited by on 19-07-07 16:12
Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 19-07-07 15:58
18 queries? For a lightweight PHP blogging system!


Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 19-07-07 16:11
mozzer wrote:
18 queries? For a lightweight PHP blogging system!


I completely agree, and with a quick restructure of core.php, 8 are eliminated. I've uploaded the new zip and rar with the altered core.php.


Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 19-07-07 17:35
10 queries is still alot... I expect there must be a way to limit all the queries which happen everytime into one query....


Author

RE: Open-Source Blog


Member

Your avatar

Posts:
Location:
Joined: 01.01.70
Rank:
Guest
Posted on 20-07-07 16:57
Version 1.1.1 is out with theme integration added.

http://bloggy.the. . .




Edited by on 20-07-07 16:57
Page 2 of 2 < 1 2