Advertisement:

Author Topic: How to skip steps on a smf converter?  (Read 2843 times)

Offline Ruben Rocha

  • Semi-Newbie
  • *
  • Posts: 42
How to skip steps on a smf converter?
« on: May 21, 2018, 11:19:51 AM »
I am having some issues on the last couple of steps for bans. Bans1 works bans two does not and I have bans 3 and 4 to try.
The problem is it takes two hours to go through boards,members,topics,posts before it gets there.
For testing how do I skip everything to get to the ban steps?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,559
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: How to skip steps on a smf converter?
« Reply #1 on: May 21, 2018, 01:55:19 PM »
You can edit the .sql file and take out the steps you don't want
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Ruben Rocha

  • Semi-Newbie
  • *
  • Posts: 42
Re: How to skip steps on a smf converter?
« Reply #2 on: May 22, 2018, 09:24:12 AM »
I was hoping for a flag not delete the lines.
Oh well.
Thanks

Offline GigaWatt

  • The Smiley Guy
  • Support Specialist
  • SMF Hero
  • *
  • Posts: 2,104
  • Gender: Male
    • Macedonian electronics forum
Re: How to skip steps on a smf converter?
« Reply #3 on: May 22, 2018, 07:45:02 PM »
Comments Within SQL Statements

Quote
Begin the comment with a slash and an asterisk (/*). Proceed with the text of the comment. This text can span multiple lines. End the comment with an asterisk and a slash (*/). The opening and terminating characters need not be separated from the text by a space or a line break.

Code: [Select]
SELECT last_name, salary + NVL(commission_pct, 0),
   job_id, e.department_id
/* Select all employees whose compensation is
greater than that of Pataballa.*/
  FROM employees e, departments d
       /*The DEPARTMENTS table is used to get the department name.*/
  WHERE e.department_id = d.department_id
    AND salary + NVL(commission_pct,0) >   /* Subquery:       */
   (SELECT salary + NVL(commission_pct,0)
                 /* total compensation is salar + commission_pct */
      FROM employees
      WHERE last_name = 'Pataballa');

SELECT last_name,                    -- select the name
    salary + NVL(commission_pct, 0),-- total compensation
    job_id,                         -- job
    e.department_id                 -- and department
  FROM employees e,                 -- of all employees
       departments d
  WHERE e.department_id = d.department_id
    AND salary + NVL(commission_pct, 0) >  -- whose compensation
                                           -- is greater than
      (SELECT salary + NVL(commission_pct,0)  -- the compensation
    FROM employees
    WHERE last_name = 'Pataballa')        -- of Pataballa.
;
"This is really a generic concept about human thinking - when faced with large tasks we're naturally inclined to try to break them down into a bunch of smaller tasks that together make up the whole."

"A 500 error loosely translates to the webserver saying, "WTF?"..."

Offline Ruben Rocha

  • Semi-Newbie
  • *
  • Posts: 42
Re: How to skip steps on a smf converter?
« Reply #4 on: May 24, 2018, 04:53:00 PM »
I know what comments are.
So I don't need to do anything with convert.php?
Just the sql file of the converter?

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 21,559
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: How to skip steps on a smf converter?
« Reply #5 on: May 24, 2018, 04:55:01 PM »
correct just the sql file
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Ruben Rocha

  • Semi-Newbie
  • *
  • Posts: 42
Re: How to skip steps on a smf converter?
« Reply #6 on: May 27, 2018, 03:11:20 PM »
Thank You.