| wizzard | 2006-09-20 18:52:00 |
 Posts: 31 Topics participated: 10 Topics started: 6 First post: 2006-09-05 15:01:00 Last post: 2006-11-22 10:40:00 |
ok here's the deal a user managed to get 300 times in the leechers list zo i deleted his account and banned the ip problem is he is still in the leechers list as n/a but messed up my lechers counting i cant flush his torrents because i deleted him (stupid should do that first but it hapend ) how te get it of my list ?? can you flush a torrent ?? edit ok i do have to trust my cleanup more :) jobs done great source this is :) |
 |
N/A in peer list
| DRRRR | 2006-09-20 18:56:00 |
 Posts: 510 Topics participated: 277 Topics started: 5 First post: 2006-03-13 22:18:00 Last post: 2006-10-25 20:54:00 |
DELETE FROM peers WHERE userid=[his userid] |
|
| wizzard | 2006-09-20 19:02:00 |
|
Posts: 31 Topics participated: 10 Topics started: 6 First post: 2006-09-05 15:01:00 Last post: 2006-11-22 10:40:00 |
does not work i deleted him ?? no more id ?? cleanup has remover about 200 times but stil 100 times n/a in the leechers list :( |
|
| DRRRR | 2006-09-20 19:05:00 |
|
Posts: 510 Topics participated: 277 Topics started: 5 First post: 2006-03-13 22:18:00 Last post: 2006-10-25 20:54:00 |
figure at least something yourself :/ SQL DELETE FROM peers p LEFT JOIN users u ON p.userid = u.id WHERE u.id IS NULL Something like that. |
|
Similar threads
| Topic | Posts | Last post |
|---|---|---|
| i can't see the peer list :( | 1 | 2007-12-25 08:09:00 |
| Peer list | 7 | 2007-07-04 10:28:00 |
| Not seeing the peer list | 4 | 2007-11-30 07:29:00 |
| Peer List | 2 | 2006-10-23 16:57:00 |
| Fake Peer-list | 11 | 2007-11-16 07:11:00 |
Statistics
| Today's active topics · | |
|---|---|
| User(s) active in the past 30 minutes | |
| 59 Guests, 9 Members LiquidAtoR, rocky, mesh, GunnersBr, RayDaX, DeMaper, Txie, abcd*, bbrian017 opisy gg , teledyski , Kina domowe , limo Airport , limo service Airport chicago alveo Obrazki zabawki edukacyjne Montaż Urządzeń Klimatyzacyjnych Gry | |
| Often viewed topics | |
| · Preliminary XSS... · RSS feed passke... · Invite With Bonus · Browse.php · new Message · Torrent Inline ... · torrent uppload... · Save PMs to temp! · Similar torrent... · Work with mod_r... · Nice signup usi... · Stats on index · browse.php · action script · hash fails???:S · Ratio Master · User/ID · Warned users (o... · Question about ... · Rating using ajax | |
| Forthcoming Calendar Events within the next 5 days | |
| There are no forthcoming calendar events | |