- This topic is empty.
-
AuthorPosts
-
January 14, 2013 at 11:18 am #121039__Participant
>>… display status (show,hide,starred,buried,etc.)
> Not quite sure what I would do with this. Perhaps be able to delete comments?
yeah, or for moderation (hide without deleting), or for featuring/downvoting comments.
>>If you wanted to “version” comments …
> Not sure I’m understanding why I would need a separate field just for edits?
Not exactly what I meant: just a “version number.”
For example, user *X* leaves a comment, then later edits it. The “edited” comment would actually be an entirely new record in the DB, with the same id (I was thinking a good Primary Key would be userID+publishTime), but a different version number. That way, you’d preserve the original comment in case you ever needed it, and it would still be easy to retrieve only the latest version:
`SELECT `*fields*
` FROM comment`
` WHERE userID=`*userID*
` AND publishTime=`*timestamp*
` ORDER BY version DESC`
` GROUP BY publishTime`
January 14, 2013 at 1:15 pm #121049chrisburtonParticipant@traq Thanks for the explanation and your help. I’ll have to do a bit of research on how to write this all up and retrieve content from the DB.
January 14, 2013 at 1:40 pm #121051TheDocMemberCan’t wait for you to get this all set up. Clearly the blog post of your life ;)
January 14, 2013 at 1:49 pm #121052chrisburtonParticipant@TheDoc Haha. Thanks, Gray. It’s definitely going to be my first post for sure.
January 15, 2013 at 9:24 pm #121120__Participant> I solved the Opauth issue myself. I only had to add my consumer key and secret into the config file and not into any other files like I was doing.
What exactly did you do differently? I still can’t get it to authorize.
January 15, 2013 at 11:07 pm #121128chrisburtonParticipantHey @traq. I’m on my iPhone writing this as I’m not home at the moment.
Basically I was taking my consumer and access keys/secrets, inputting them into the twitteroauth.php file in the Vendor folder. I might have placed into another file as well which was causing it to fail. The only thing you need to do to get it working is to place your Consumer key and secret into opauth-config (or whatever the filename is) inside the Example folder. It should then validate.
January 16, 2013 at 12:18 am #121131__Participanthmm… that’s where I have them (in `./example/opauth.conf.php`, in `$config`).
January 16, 2013 at 12:25 am #121132chrisburtonParticipantJanuary 16, 2013 at 12:27 am #121133__Participantactually, nevermind. I was using the TwitterStrategy.php file you’d sent me, which had your key and secret. Once I deleted that it worked fine.
I’m testing my **twitter_user** class now with the live API. I’ll post with the results in your other thread.
…thanks!
January 16, 2013 at 12:29 am #121134chrisburtonParticipant@traq Awesome, thanks.
-
AuthorPosts
- The forum ‘Back End’ is closed to new topics and replies.