Simple Machines Community Forum

SMF Support => Converting to SMF => Topic started by: Ruben Rocha on May 21, 2018, 11:19:51 AM

Title: How to skip steps on a smf converter?
Post by: Ruben Rocha 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?
Title: Re: How to skip steps on a smf converter?
Post by: vbgamer45 on May 21, 2018, 01:55:19 PM
You can edit the .sql file and take out the steps you don't want
Title: Re: How to skip steps on a smf converter?
Post by: Ruben Rocha on May 22, 2018, 09:24:12 AM
I was hoping for a flag not delete the lines.
Oh well.
Thanks
Title: Re: How to skip steps on a smf converter?
Post by: GigaWatt on May 22, 2018, 07:45:02 PM
Comments Within SQL Statements (https://docs.oracle.com/cd/B13789_01/server.101/b10759/sql_elements006.htm)

QuoteBegin 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.

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.
;
Title: Re: How to skip steps on a smf converter?
Post by: Ruben Rocha 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?
Title: Re: How to skip steps on a smf converter?
Post by: vbgamer45 on May 24, 2018, 04:55:01 PM
correct just the sql file
Title: Re: How to skip steps on a smf converter?
Post by: Ruben Rocha on May 27, 2018, 03:11:20 PM
Thank You.