https://www.icyphoenix.com/viewtopic.php?f=35&t=3217&p=22252#p22252
-----------------------------------
mih bonatto
Sat 15 Dec, 2007 22:44

Re: Debug Admin_prune_users.php
-----------------------------------
[quote user="novice programmer" post="22250"][b]mih bonatto[/b], try this:

[code syntax=php]   if(!($result = $db->sql_query('SELECT user_id , username, user_level FROM ' . USERS_TABLE . ' WHERE user_id<>"' . ANONYMOUS . '"' . $sql[$n] . ' AND user_regdate<"' . (time()-(86400 * $days [$n])) . '" ORDER BY username LIMIT 800')))'
    {
        message_die(GENERAL_ERROR, 'Error obtaining userdata'.$sql[$n], '', __LINE__, __FILE__, $sql[$n]);
    }[/code]

It could be a mis-understanding of the sql system...[/quote]

Thanks for your attention... I've tried your new code, but have another error: 
[code linenumbers=false]Error obtaining userdataS

DEBUG MODE

SQL Error : 1064 Você tem um erro de sintaxe no seu SQL próximo a '"-1"S AND user_regdate<"1177018799" ORDER BY username LIMIT 800' na linha 1

S

Line : 124
File : admin_prune_users.php[/code]

And I can't delete this item, 'cause there is no other prune users in the IP system, correctly? I'm getting insane with this bug (and yes, i've posted this in Bug Tracker already).

Thanks anyway =*

PS: there is an image about my IP, when I delete $sql [$n] from line 122.


