Hello! Playing With Sharp Objects is using DISQUS, a powerful comment system, to manage its comments. Learn more.
Community Page
- www.shokk.com/blog/ Jump to website »
-
Subscribe -
Community
-
Top Commenters
-
Popular Threads
-
Recent Comments
- I didn't know that the iPhone had World of Warcraft character tracking app. Gotta' check this out. Thanks
- haha Wolverine is the man! Your son lucked out on that catch for sure :)
- I agree, I find Microsoft to definitely being going downhill in their applications lately.
- I have so many aps of my phone I think its time to upgrade to a bigger one. I think that was their marketing plan all along. Give us small iPhones so we can fill it with aps then come out with...
- Simon, you hit the nail on the head. Whatever they can do to make more money is ultimately what will win out. They know they stole a lot of business from their competitors by rewarding <a...
7 months ago
Can't create index. Mysql says: Table 'user763_blog.items' doesn't exist
In install.php line 135 I had to change it to
if(!fof_do_query("ALTER TABLE `$FOF_ITEM_TABLE` ADD INDEX `feed_id_idx` ( `feed_id` )", 1) && mysql_errno() != 1061)
similar for line 140
the items table name is hard coded in those lines instead of taking the value from config.php
7 months ago
Good catch! I'll get this in for the next release, which will include multi-user support. Coming soon...
7 months ago
$sql = "select aging from feeds where id='$id'";
$sql = "delete from items where `feed_id`=$id and `star`!=1 and `read`=1 and to_days(CURDATE()) - to_days(`timestamp`) > $keep_days";
I'm using the 9 November tarball
7 months ago
Thank you very much for bringing this to my attention. It was replete with hard coded 'feeds' and 'items' thanks to my sloppy coding practice. I've replaced it in a number of spots, but likely it's not the only place where it's hard coded. I'll try to go through it this weekend, but I won't be able to get a tarball out yet since I'm still breaking MonkeyChow to get the multiuser support in. We're half-way through heart surgery so it's too laet to turn back. =-)
7 months ago
7 months ago
There will be database changes with this newer version, so I will be sure to put a warning in the next post about that. I'll need some extra testing time in here before I risk everyone else's database.
More coming soon.
5 months ago
First and foremost, I'm just now starting to pick up on the more advanced features of mySQL - I have until now gotten away with not using things like JOINs but I need to quickly learn how this can help my system. Being able to do these things in one atomic query rather than a bunch of different queries aided by some PHP will make things faster and more efficient, since mySQL is designed to do all that data sifting for us.
There are also a number of places in the code that reference things like items.id and feeds.id that should really be items.item_id and feeds.feed_id to help me use those higher level functions. This means that I must now go back through all the code and replace instances of "id" with the correct one so that column names match when I try to do a JOIN - that is lot of code to go through while not breaking anything.
Some of this recoding is due to my lack of functions for handing these individual tasks, which makes it easier for me when I'm coding the first time since I have to plan less, but harder when I have to go back into the code, which means more wasted time in the long run. So, there needs to be some smarter coding on my part.
Once this new version is ready, I'll release it as 1.0 with as much of the code cleaned up as possible and the start of modular style templates so that people can make their feed reader unique for their community.