collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 363
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Blocks speak! Do you have an interest in getting more blocks - or even making your own? The Blocks Board is for you!

Author Topic: Total Noob question  (Read 5488 times)

0 Members and 1 Guest are viewing this topic.

Offline OnlyMe69

  • Newbie
  • Posts: 2
  • SMF Version: 2.0.9
Total Noob question
« on: June 15, 2016, 08:30:02 AM »
Hi there, I'm new to all this SMF/SP stuff, I inherited a badly maintained forum, we moved the photo directory about and then a guy gave me some DB code that he said would change the links to embedded photos in existing posts  from old pointers to new, running the code just bombs and being no DBA I'm scratching my head a bit, could anyone have a look at the code below and point me in the right direction please?  I believe it's failing at the first hurdle and not populating the array highlighted in red..

many thanks in advance Paul.

Code: [Select]
global $scripturl;
// Grab the first set of members to verify.
$request = mysql_query("SELECT id_msg,body FROM {$db_prefix}messages
            WHERE id_msg >= " . $_REQUEST['start']. "  and id_msg <= " .($_REQUEST['start']+ $increment) . " and body like '%[smg id=%' ORDER BY id_msg ASC");
Code: [Select]

while ($row = mysql_fetch_assoc($request))
{
      $body = $row['body'];
preg_match_all('/\[smg id = (\d*)\]/i', $body, $matches, PREG_PATTERN_ORDER);

// print_r($matches);
if (!empty($matches))
{
foreach($matches[1] as $matchfound)
{

                       $matchfound = (int) $matchfound;

if (!empty($matchfound))
{
                       $result2 = mysql_query("SELECT thumbfilename FROM {$db_prefix}gallery_pic WHERE id_picture = $matchfound");
                        $picRow = mysql_fetch_assoc($result2);

                        $imgurl = $modSettings['gallery_url'] . $picRow['thumbfilename'];

                      //  die("[url={$scripturl}?action=gallery;sa=view;id=$matchfound][img=$imgurl][/url]");
                        if (!empty($picRow['thumbfilename']))
                        {
                            $body = str_replace("[smg id = $matchfound]","[url={$scripturl}?action=gallery;sa=view;id=$matchfound][img]{$imgurl}[/img][/url]",$body);
                            mysql_query("UPDATE {$db_prefix}messages set body = '$body' WHERE id_msg = " . $row['id_msg']);
                        }
                       }

                    }

                }

}
mysql_free_result($request);


                     

Offline emanuele

  • Developer
  • *
  • Posts: 293
Re: Total Noob question
« Reply #1 on: June 15, 2016, 09:05:36 AM »
hmm...
It may be a "noob question", but it requires some more thoughts and info.

Let's see first if I got it right.
You had an SMF board, that was using AEVA.
You decided not to use AEVA any more and moved all the images to an external gallery script (which one?).
Now you are trying to convert the AEVA BBCode to img tags pointing to the new script.

Does sound about right?

Offline OnlyMe69

  • Newbie
  • Posts: 2
  • SMF Version: 2.0.9
Re: Total Noob question
« Reply #2 on: June 15, 2016, 09:24:04 AM »
Hi Emanuele, something called SMFGallery Pro was purchased to move away from Aeva which was causing server load problems, the gallery migrated successfully, its just the embedded code "[smg id=XXX]" that I need to swap out now for the new picture locations, i exported the SQL table for the smf_messages and had a look in it, the hooks seem right in the code below relating to what it's looking for and what to change it to, but im wondering if the DB syntax is wrong as when I run the full script it doesn't do anything... Does that make a bit more sense ? :)
« Last Edit: June 15, 2016, 09:26:27 AM by OnlyMe69 »

Offline emanuele

  • Developer
  • *
  • Posts: 293
Re: Total Noob question
« Reply #3 on: June 15, 2016, 10:06:45 AM »
http://www.smfhacks.com/index.php?topic=8871.0

If you paid for the gallery, as far as I can see you should have access to a converter as well, why not ask the creator of the gallery? ;)

ETA: I'm not proposing this to "send you away", but because if you have support from the creator of the gallery it's much easier for him to run an existing and working converter than for me to guess how to convert things that I don't know.
« Last Edit: June 15, 2016, 10:37:04 AM by ♦ Ninja ZX-10RR ♦ »

Offline ♦ Ninja ZX-10RR ♦

  • Spammer Hammer
  • Support
  • *
  • Posts: 1193
  • Gender: Male
  • Sniper Legends
    • Virtual Interactive Games Entertainment™
  • SMF Version: 2.0.13
  • SP Version: 2.3.6
  • Elkarte Version: 1.0.6
Re: Total Noob question
« Reply #4 on: June 15, 2016, 10:37:32 AM »
@emanuele you forgot a vital "not" there, I exceptionally added it for you not to create a big misunderstanding :P
Have you tried SimplePortal Documentation before asking? ;)
F.A.Q.  English Support  |  Blocks Support
Fancy Feature idea ?!  |  Blocks Requests
Themes & Graphics

? My job! ?No PMs for support unless it's a paid request. Thank you! :)#OpIsis