TS 4.3 remove upload gb from all how?
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 :) |
In phpMyAdmin just run this sql query which will remove 4GB from every member account
Code:
UPDATE users SET 'uploaded' = 'uploaded' - '4294967296' |
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? :( |
Tested
Code:
UPDATE users SET uploaded = uploaded - 4294967296 |
I want remove not giv! help me what you do, now i give all tb ! help me, how ican remove gb from users!?
|
What I posted does remove 4GB from every members account
Code:
UPDATE users SET uploaded = uploaded - 4294967296 |
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 ? :( |
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 Code:
UPDATE users SET uploaded = uploaded - 1099511627776 WHERE username = "Doniukas" |
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? :) |
Use this
Code:
UPDATE users SET announce_read="yes" WHERE announce_read="no" |
All times are GMT +2. The time now is 20:57. |
Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.