WORKING Thread -- please stop in.

[Clarity]

Sooo close on bpCash... The horror.

I have 4982 lines of;
WHERE userid=5;UPDATE user SET ucash=1000
WHERE userid=6;UPDATE user SET ucash=0
WHERE userid=7;UPDATE user SET ucash=4500
WHERE userid=8;UPDATE user SET ucash=2433
WHERE userid=9;UPDATE user SET ucash=1000
WHERE userid=10;UPDATE user SET ucash=300

That needs to be turned into;
UPDATE user SET ucash=1000 WHERE userid=5;
UPDATE user SET ucash=0 WHERE userid=6;
UPDATE user SET ucash=4500 WHERE userid=7;
UPDATE user SET ucash=2433 WHERE userid=8;
UPDATE user SET ucash=1000 WHERE userid=9;
UPDATE user SET ucash=300 WHERE userid=10;

And then I *think* that can be run on the live server to stick all the right data in.

YOU WILL NOT BEAT ME, MYSQL!

 

[Clarity]

sed 's/\(.*;\)\(.*\)/\2 \1/' broken.sql > fixed.sql <-- My spear and magic helmet.

Magic helmet?

MAGIC HELMET!

I hate this stuff...

 

[bucknut11]

update user set ucash=10000000000 where userid=242;


I can't really think of a nice way to do a script, since everyone has differing values. That sucks

 

[Clarity]

That sed command above did the trick. I've got the format I need now.

Now the question is, will that syntax properly modify the live database?

I'm about to find out.

 

[Clarity]

Oh man, it worked.

I'd feel really satisfied, except momentarily conquering my mySQL demons means my geek quotient just increased.

vBookie has been reopened.

 

[jwinslow]

aww, that spam revenge thread earned me a lot of vcash. Oh well, I'll just have to start thieving soon...

--another freaking sweet feature, it tells you how many seconds are remaining before you can post again (since you can't post twice within 30 seconds)

 

[Clarity]

Okay, another wrong fixed. All users who got 500 cash when they registered instead of 1000, have now been awarded their missing bpCash.

 

[osugrad21]

Is the split thread option coming back...I might have withdrawal issues if not.

Then again, It may have been discussed and I missed it

 

[Clarity]

Is the split thread option coming back...I might have withdrawal issues if not.

Then again, It may have been discussed and I missed it

I *think* it's just renamed. Meaning, you could select certain posts out of a thread, and 'MOVE' them to another location.

 

[jwinslow]

The ability to checkmark the threads you want to merge is extremely sweet... I'm pretty sure that wasn't a feature before (you had to type in the other URL)

 

[osugrad21]

I *think* it's just renamed. Meaning, you could select certain posts out of a thread, and 'MOVE' them to another location.

Nice...lemme go try

 

[lvbuckeye]

Oh man, it worked.

I'd feel really satisfied, except momentarily conquering my mySQL demons means my geek quotient just increased.

vBookie has been reopened.

wow... nice work, Clarity...

"with my spear and magic helmet" ???
*sings fortisimo* "Kill the wabbit, kill the wabbit, kill the wabbit!" :p

 

[osugrad21]

I figured it out...then split some mess from a thread...which I was a participant in, and then damn deleted the thread accidentally. Oh well, get the bugs out now before recruiting hits :)

Anyway, for mods and admins, check the box and use the mod options at the bottom of the page...split is now "move posts"

 

[3yardsandacloud]

 

[lvbuckeye]

LMAO! classic...