Ripping, tearing to shreds.

So now that I have installed and working on http://pb.. I’ve been looking at the code and decided I don’t really like the way things currently are.

So, for starters I have made a few changes:

  • I don’t really agree with how “public” currently is, so I’ve removed the Recent posts section on the side.
  • There used to be a feedback form on the side too. I’ve removed that since anyone who’d want to give me feedback knows where to find me.
  • We all know how annoying spammers are and for that reason I have added a CAPTCHA to using and its wonderful API.
  • Having looked at the code… I’m considering just making my own instead of modifying .com’s source.

I know, I know. You’re all probably saying: “but it is a , all people need it for is to paste things in” which is true and from that perspective the .com script does it justice but I’m still not satisfied.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Comments 0

Good news.

I’ve fixed the statements we were told to use in the file.

For anyone who encounters this problem, here’s the solution.

The problem:

The statements in the file that come with ’s source aren’t following the correct syntax and as such, we encounter this error when we try to run the provided statements.

:
  1. #1064 – You have an error in your syntax; check the manual that corresponds to your MySQL server version
  2. FOR the RIGHT syntax TO USE near ‘KEY `expires`’ at line 16

The solution:

Not sure how it previously eluded me…but the fix was quite obvious.

:
  1. CREATE TABLE `` (
  2. `pid` int( 11 ) NOT NULL AUTO_INCREMENT ,
  3. `poster` varchar( 16 ) DEFAULT NULL ,
  4. `posted` datetime DEFAULT NULL ,
  5. `code` text,
  6. `parent_pid` int( 11 ) DEFAULT ’0′,
  7. `format` varchar( 16 ) DEFAULT NULL ,
  8. `codefmt` mediumtext,
  9. `codecss` text,
  10. `domain` varchar( 255 ) DEFAULT ,
  11. `expires` DATETIME,
  12. `expiry_flag` ENUM( ‘d’, ‘m’, ‘f’ ) NOT NULL DEFAULT ‘m’,
  13. PRIMARY KEY ( `pid` ) ,
  14. KEY `domain` ( `domain` ) ,
  15. KEY `parent_id` ( `parent_pid` ) ,
  16. KEY `expires` ( `expires` )
  17. );
  18.  
  19. CREATE TABLE recent
  20. (
  21. domain varchar(255),
  22. pid int NOT NULL,
  23. seq_no int NOT NULL,
  24.  
  25. PRIMARY KEY(domain,seq_no)
  26. );

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Comments 3

Not good news.

Well, I lied. I haven’t installed/ a yet but I have tried and…failed.

I keep running into this error when trying to create the appropriate tables in my database.

:
  1. #1064 – You have an error in your syntax; check the manual that corresponds to your MySQL server version
  2. FOR the RIGHT syntax TO USE near ‘KEY `expires`’ at line 16

So for now, I am sticking with the flat-file DB . Well at least we have something to work with for the time being.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Comments 0

So now we have a pastebin.

So I’ve been a busy busy person and installed a for . But one must be wondering why on earth I would have a WHOLE category dedicated to, what may seem to some, a short discussion of (s) and to that I answer thus:

Although there are…, what? 3 different scripts out there now? Maybe 4? I’m not really satisfied with what features they offer out of the box and so I’ll probably be working on or hacking at the script(s) to get them just how I like them.

Stay tuned for more… ;)

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Comments 0

It may be too late…

If you are reading this, it’s probably too late.

I’ve finally done it, I’ve finished working on my.. Which should be one of our defining features that encourage our users to interact with and get to know each other. The main emphasis for this move would be, of course, community.

I have a blog now – …there goes my free time. Or whatever little I had anyway. Although I do have this blog, I do not promise anything. I cannot promise that I will make frequent posts or post anything at all. But what I can promise is that if you do subscribe to my thoughts then I assure you, whatever I do end up writing and posting on this blog will be a worthwhile read. So read on. ;)

For those of you who know me, you probably know I love writing and though I stated to myself that I would keep this introductory blog post short…I highly doubt I am capable of doing that. We’ll see. If you’ve spoken to me lately, you’re probably aware of the frustrations I have with the way things are going and as such will probably be able to guess what my first (few) blog posts will be about — I just hope people care and listen; that it is not too late.

I do warn you, though, that from this point on, this blog will contain my uncensored thoughts and so some of its contents may offend you. And I don’t really care if it does as it is your choice whether or not you would like to subscribe to my ramblings and unsanity.

Perhaps this might just be a door to what people seem to think is a cryptic mind. Or perhaps, …not.

See? I told you so.

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...

Comments 1

 
 
 

RSS: Posts / Comments