MyCafe – Is it finished?
I’ve been rolling out several features behind the scenes that many of you most likely haven’t noticed just yet. But here they are:
Voting has it’s own table.
User networks have their own table.
This has caused a TON of changes behind the scenes with the code. I’ve had to change the profile pages almost completely along with the voting on each poem and pencushion page. Yeah, that’s only four pages, but it was a lot of code to work around.
Of course, that wasn’t all the trouble I had to go through to push these changes. I have a semi-new laptop which I got at an excellent price (gotta love duel core!). Stupid me, I didn’t have the MySQL database on my laptop. And with the database being as huge as it is… I couldn’t download it during the day because my ISP has a bandwidth cap except between 1am and 6am. So trying to stay up that late and actually remember downloading the database once I got there was a feat I had to conquer.
I ended up not bothering with installing MySQL on here, instead I opted for using XAMPP (which is a totally awesome lite server you can put on just about anything) on my 2gb memory stick I’ve had for several years now (you can get them for ~$10, mine was $65 when I bought it… oh how technology changes!).
I haven’t been coding as much as I’d like to lately, so trying to remember some things weren’t easy. Plus, stupid mistakes are my forté. I’ll think I have something finished and WAM! Stupid mistake which may take me a few hours to find–error logs be damned.
Hopefully everything is working fine. The members section should be faster now. But I don’t guarantee anything. The code was using less database selections and more code to make up for it. Now I am using more database and less code. So let’s see how this works out.
If you run into any problems or have some ideas, feel free to leave them below!
EDIT: Forgot to mention what the change on the MyCafe actually was. The MyPoems Comments actually works now, the Cafe voted now uses the new database table, and cafe commented now includes your new network friends as opposed to your old ones.
The page seems to load in the exact same time as before with the added MyPoems Comments. With the old table, MyPoems Comments was taking up to 3 minutes to query–lots of resources used. That’s why it was “out of order” until I could move some of the tables and recode some of the pages.
BloodyWrists
August 22, 2010 @ 2:25 pm
You said if you had ideas to put them here. Well here is a small one:
When viewing poems on here, even your own, you have to keep going back to your profile and go to your poem page or whatever just to get to another poem by that person. why not have like a “next” and “previous” button on the poems to view more by that author? Its such a hassle just to view more poems by that person after you read one and decide you want to read more from them. Especially when they have ALOT of poems!
Please?
Gary R. Hess
August 22, 2010 @ 3:24 pm
Thanks, this should be easy to implement. I have a few things to do tomorrow, but if I have time I’ll start working on it
Gary R. Hess
August 23, 2010 @ 11:04 am
@BloodyWrists I hope what I added is what you wanted.
MeAgain
August 24, 2010 @ 10:40 am
My “my poems comments” has the comments from your poems.
Thought i’d say because you’d have no way to know.
Gary R. Hess
August 24, 2010 @ 1:45 pm
Thanks! Yep, that is definitely something I couldn’t see. haha. I simply forgot to change the username to a variable instead of my name
Thanks! It’s fixed now.
BloodyWrists
August 24, 2010 @ 7:51 pm
YES it is, thank you! much easier now=)
MeAgain
August 25, 2010 @ 7:13 am
Sweet, good man.
meagain
August 28, 2010 @ 7:38 am
Oh, just a thought.
The little thingies you click on – on the “submit poem” page – to get bold or italic type, don’t work.
(If that makes any sense?)
A few different fonts would be peachy too, but feel free to ignore my blatant cheek.
ScarletSorrows
September 6, 2010 @ 4:52 pm
uh i donno why but my account wont alow me to add pplz to my network and it wont reconize my flikr account…and id be nice to have someone u could talk to on here that can help with stuff like that…that can be easy to acess when nessasary…
google
September 7, 2010 @ 9:19 am
Hi Gary
I would like to thank you for this robust poetry site.
It is unique in the way it catalogues all the poet’s poems in one place, easy to access, among other things.
One feature I would love to see is a way to backup all my poems into one document for archival reasons. Periodically I copy and paste them into a word document myself but it takes over an hour. If this is in the cards I would happy to discuss it.
Scott
BloodyWrists
September 11, 2010 @ 1:18 pm
Something’s up with the network; it won’t allow you to add or delete users to or from our network… Can you fix that by any chance?
Gary R. Hess
September 11, 2010 @ 7:49 pm
@meagain – I’ll work on it sometime this coming week hopefully. If I can’t get it done by then, it’ll be a while. I’m going away for two weeks.
@ScarletSorrows This should be fixed. I worked on it all day today. If you are still having problems let me know. You can also contact me easily using the ‘mail’ on PoemofQuotes.com/members/ or through the Contact form. I simply ask that if you do contact me through the members section, please leave enough space in your inbox to receive messages so I can reply.
@google This is something I would like to add in the future but I won’t be able to for a long time. This feature will require additional resources and I’m not able to do that currently.
@BloodyWrists Should be fixed now.