Old Forums (newoutriders.com )

[Lasarian]

I have just finished a complete backup of the database and all files for the old forums previously hosted at newoutriders.com and moved them to our current host at newoutriders.org.

http://newoutriders.org/oldforums/index.php

If you previously had a user account there it will still function; however registration has been disabled. This is for information and backup purposes. My intention is to attempt to merge some of the old forums into the new.

[Tundrra]

Excellent!

I was on there just the other day researching Viscount Kermit:p

[Lasarian]

I have been culling the directory tree from the old site. I have found and removed eleven complete installations of the PHPBB software to run those forums.

DAFUQ?

[Lasarian]

Hey Tun, you were just doing some MySQL training were you not?

Is there a shell command I can use to iterate a value in a field in an entire table. So, let's say I want to add 5,000 to each integer in the User ID field. so instead of the values being 1-5000, after the command they would be 5001-10,000.

How do I do that?

[Tundrra]

Yep still working at it:)

Try something like this maybe...

Code: Select all

UPDATE `databasename`.`tablename` SET fieldB = fieldB + 5000; 

[Lasarian]

sweet, thanks.

[Tundrra]

sweet, thanks.

Let me know if it works or not:)

[Talolan]

My SQL is too rusty to do them all at once, Tundrra's looks good to me. I'd end up doing them 1 at a time in a loop via php script, because I still remember php.