AdamPD

+Clients
  • Content count

    8
  • Joined

  • Last visited


About AdamPD

  • Rank
    IPB Newbie

Profile Information

  • Gender Male

AdamPD's Activity

  1. AdamPD added a post in a topic: Removing /_/ from FURLS and trailing index from forum URL?   

    The trailing index is really the larger issue at hand. It breaks the return to board after registration (which goes to /boards/index.php and 404s) and the community link in the AdminCP.
  2. AdamPD added a post in a topic: Removing /_/ from FURLS and trailing index from forum URL?   

    Setup IPboard in /boards/ and placed IPcontent's index.php in the root. Turned FURLS on and placed respective .htaccess in their directories.
     
    I'm curious about 2 things:
     
    1) How can I remove the /_/ from article URLs?
     
    2) How do I remove the trailing index, now that my forum root only works as http://www.site.com/boards/index
     
    Thanks!
  3. AdamPD added a post in a topic: Merging IP 3.3 boards (IPB 3.3 -> IPB 3.3)   

    I'm running into some issues trying to do this.
     
    None of the avatars carried over.
     
    There are lots of user accounts not imported because they don't have names (these look like twitter/fb registrations). We have a fair amount of twitter/fb accounts. How are these handled?
     
    The profile field conversion throws a "driver error" fit.
     
    Can anyone throw me some suggestions? I figured this would be smooth sailing because it was IPB to IPB...
  4. AdamPD added a post in a topic: [RESOLVED] SQL query to remove string from posts?   

    [quote name='Mark H' timestamp='1343095605' post='2290263']
    Not sure what you mean by "Citation?". But that user is correct. Manually running queries on any table is a very bad idea, unless you know exactly what you're doing.

    And even if you do know exactly what you're doing......always, always, get a backup of the database prior to doing so. ;)

    You know how Murphy works. Have a backup, you'll never need it. Fail to have a backup, and ......


    I asked for citation because I wasn't sure if the "running a query is never a good idea" statement was backed by a valid reason I shouldn't, or just unsupported fear of performing any action on the database.

    I tweaked PrinceOfAbyss' syntax a bit since I don't use prefixes:



    I ran the query a couple different ways on content_cache_posts (image links appeared wrapped in lightbox span and as plain text lURLs). Images and references were completely purged after that, but dropped the cached posts anyway from AdminCP as per Michael's suggestion.

    Many thanks to both PrinceOfAbyss and Michael on this one.

    And yes, I ran mysqldump beforehand (and have two weeks of nightly off-site backups). Bring it on, Murphy. :P
    UPDATE posts SET post=REPLACE(post, '[img=http://link.to/image.jpg]', '');
  5. AdamPD added a post in a topic: [RESOLVED] SQL query to remove string from posts?   

    [quote name='Lucy Heartfilia' timestamp='1343062412' post='2290133']
    No..besides running a query on the posts table is never a good idea.


    Citation?

    [quote name='PrinceOfAbyss' timestamp='1343063308' post='2290137']



    THANK YOU. That's what I was looking for. About to try it.
    UPDATE ibf_posts SET post=REPLACE(post, '[img=http://link.to/image.jpg]', ' ');
  6. AdamPD added a post in a topic: [RESOLVED] SQL query to remove string from posts?   

    I have a problem user that has been attaching an objectionable image to every one of his posts.

    He's managed to rack up about 300 posts with attached image. Rather than manually editing every one of his posts, or deleting them outright, is there a sql query I can run to remove
    [img=http://link.to/image.jpg] from all posts on the forum?

About Me