Site Feedback

Discussion in 'Pipeline' started by cmdrmonkey, Jan 24, 2011.

Page 30 of 37
  1. #581 Ichiban, Jan 19, 2012
    Nothing..as such. It's backend work that you won't see. I am trying to get rid of those stupid '\' that are all over the place but the server isn't playing ball and is telling me that an SQL statement I'm using isn't valid...very annoying. I spend all day picking through shit bugs in code so it annoys me that I am now spending time, at home, doing the same. I may take a break for the night and carry on in the morning.

    As it stands now though, the backslash issue is only confined to posts brought over from the old forum
     
  2. #582 Grim, Jan 19, 2012
    What is the code you are trying to use? Lets us have a look, should be able to help.

    Also is it SQL or MySQL?
     
  3. #583 Ichiban, Jan 19, 2012
    The SQL i want to run is this:

    UPDATE smf_messages
    SET body=replace(body, '\', '');

    Server is running MySQL 5.0.92 I think...

    phpmyAdmin tells me that it's not valid. But I'm not a SQL or PHP coder so I'm having to wing it. Any advice would be great.
     
  4. #584 khaid, Jan 19, 2012
    do you guys say SQL like sequel?
     
  5. #585 chairmansteve, Jan 19, 2012
    That shit ain't valid, Jack.

    Try this one to handle single quotes:
    UPDATE smf_messages SET body = replace(body, '\\\'', '\'');

    And this one for double quotes:
    UPDATE smf_messages SET body = replace(body, '\\\"', '\"');
     
  6. #586 knowname, Jan 19, 2012
    I'm reading smf as smurf
     
  7. #587 supersonic, Jan 19, 2012
    Nobody saw this.
     
  8. #588 Fusion, Jan 20, 2012
    Very glad the new posts button is back. Such a useful feature that one.
     
  9. #589 knowname, Jan 20, 2012
    I don't know if this was the fix or what but I can now get it to remember my login... I just have to go to the new messages list first THAN it signs me in. A bit of a bother... but at least I don't have to sign in! lol
     
  10. #590 Ichiban, Jan 20, 2012
    Great stuff. Thanks to the Chairmans SQL advice the annoying backslash issue is fixed..i think...at least all the old posts seem to be missing them...find any, let me know.

    Going to crack on with other things now.

    EDIT: You may see things like the font size go a bit odd now and then. Don't worry, it's just me messing with things.

    EDIT: Recent Topics can now be found on the board index in the information center. It will show the last 5 updated topics on the board.
     
  11. #591 Phisix, Jan 20, 2012
    Is 5 the most it can show?
     
  12. #592 Ichiban, Jan 20, 2012
    It can show however many I tell it to show. It depends on how cluttered we want the board index to look. I want to keep things to a minimum.
     
  13. #593 Phisix, Jan 20, 2012
    Surely 10 would not look that bad? If not that is fine as the unread posts thing shows all unread posts.
     
  14. #594 cmdrmonkey, Jan 20, 2012
    Leave it at five. Ten would look cluttered.
     
  15. #595 knowname, Jan 20, 2012
    I liked how we had a button to show all on the other forums. I don't mind, I just log in and go through all the forums sections I need to. going thread by thread is ok, but going post by post was just impossible.
     
  16. #596 supersonic, Jan 21, 2012
    The most crucial issue I've encountered with the new forum is that my avatars won't display at the correct resolution?? This is a goddamn disaster.
     
  17. #597 supersonic, Jan 22, 2012
    The new URL dropped us to #9 for a google search of "PVCF3". But today we are up to #8. I wonder how long it will take to get back to our #1 spot.
     
  18. #598 Ichiban, Jan 22, 2012
    It shouldn't take long. The old site and old database still live on the server albeit it's obviously a ghost town...I'll remove it and it should jump up to #1 in no time at all.
     
  19. #599 supersonic, Jan 22, 2012
    Can you check this out when you get a chance... my small avatar is really bugging me since I have 2 dozen for 98x98.

    http://www.vbulletin.org/forum/showthread.php?t=250255
     
  20. #600 Ichiban, Jan 22, 2012
    We aren't using VBULLETIN since the licensing was rediculously expensive...if we get more users I may switch the forum over, again, to that since it has lots of nice features.

    I'll look into the avatar issue tho...
     
Page 30 of 37