TS 4.3 remove upload gb from all how?

[Edvis]

Hello i have a problem :) one of my staff person is dude :D and he gives for all users 4 GB upload. Now I want remove this GB's from users, but how ? I think that : If is funkcion in staff panel "uploadadd" maybe is posible configured this .php and this mod remove upload gb's from all users? what do you think? is posible do this?

P.S Very sorry for may bad bad bad english :)

[Krypto]

In phpMyAdmin just run this sql query which will remove 4GB from every member account

UPDATE users SET 'uploaded' = 'uploaded' - '4294967296'

[Edvis]

It's doesn't work i get this error "1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''downloaded' = 'downloaded' - '4294967296'' at line 1"

Who can help me please? :(

[Krypto]

Tested

UPDATE users SET uploaded = uploaded - 4294967296

[Edvis]

I want remove not giv! help me what you do, now i give all tb ! help me, how ican remove gb from users!?

[Krypto]

What I posted does remove 4GB from every members account

UPDATE users SET uploaded = uploaded - 4294967296

Notice the minus sign!

[Edvis]

this code give users gb :

1 Doniukas 16,777,216.00 TB 27.88 TB/s 1.12 GB 1.96 KB/s 15,305,039,242.36 08-07-2008
2 Albiokas 16,777,216.00 TB 23.18 TB/s 164.45 MB 0.23 KB/s 106,978,775,645.46 08-05-2008
3 marijus45 16,777,216.00 TB 25.66 TB/s 3.40 GB 5.46 KB/s 5,046,524,969.58 08-06-2008
4 WiPaS 16,777,216.00 TB 19.68 TB/s 0.00 KB 0.00 KB/s Inf. 08-04-2008
5 PumaX 16,777,216.00 TB 25.56 TB/s 640.22 MB 1.00 KB/s 27,478,303,823.51 08-06-2008

Help me, how i can remove this tb's ? :(

[Krypto]

That code removed 4GB from every members account which is what you initially asked for 4GB.

If you wanting to remove TB then just change the amount 1TB = 1099511627776.

If your wanting just to remove from those specific accounts use something like

UPDATE users SET uploaded = uploaded - 1099511627776 WHERE username = "Doniukas"

Note the above code will REMOVE 1 TB from Doniukas account, all you have to do is change the username to whatever you want and change the amount to remove.

[Edvis]

Now working for all i remove tb's, but yesterday this code gives all users 16.000.000.00TB uploaded TB :D thanks for help, now all it's okey :)

But now i have new problem, how i can set for all users "announce_read" "Yes" from SQL Query? who can give code? :)

[Krypto]

Use this

UPDATE users SET announce_read="yes" WHERE announce_read="no"