SMF Support > Converting to SMF

How to skip steps on a smf converter?

(1/2) > >>

Ruben Rocha:
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?

vbgamer45:
You can edit the .sql file and take out the steps you don't want

Ruben Rocha:
I was hoping for a flag not delete the lines.
Oh well.
Thanks

GigaWatt:
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.
--- End quote ---


--- Code: ---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.
;
--- End code ---

Ruben Rocha:
I know what comments are.
So I don't need to do anything with convert.php?
Just the sql file of the converter?

Navigation

[0] Message Index

[#] Next page

Go to full version