|
#1
|
|||
|
|||
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 :) |
#2
|
|||
|
|||
In phpMyAdmin just run this sql query which will remove 4GB from every member account
Code:
UPDATE users SET 'uploaded' = 'uploaded' - '4294967296' Last edited by Krypto; 13th August 2008 at 22:49. |
#3
|
|||
|
|||
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? :( |
#4
|
|||
|
|||
Tested
Code:
UPDATE users SET uploaded = uploaded - 4294967296 |
#5
|
|||
|
|||
I want remove not giv! help me what you do, now i give all tb ! help me, how ican remove gb from users!?
|
#6
|
|||
|
|||
What I posted does remove 4GB from every members account
Code:
UPDATE users SET uploaded = uploaded - 4294967296 |
#7
|
|||
|
|||
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 ? :( |
#8
|
|||
|
|||
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" |
#9
|
|||
|
|||
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? :) Last edited by Edvis; 14th August 2008 at 13:45. |
#10
|
|||
|
|||
Use this
Code:
UPDATE users SET announce_read="yes" WHERE announce_read="no" |
Tags |
43 , gb , remove , upload |
Thread Tools | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Remove notice | lovebeer | Torrent Trader | 2 | 29th August 2012 14:52 |
How to remove ? | franky2008 | TBDev | 0 | 11th February 2010 15:31 |
remove EDK link "upload" | wMan | BT.Manager (phpMyBitTorrent) | 1 | 9th September 2009 00:09 |
How to remove!! | Buu | Community Cafe | 8 | 12th March 2009 15:52 |
remove torrent upload? | therealest | Torrent Strike | 0 | 7th February 2009 00:33 |