root/ip/trunk/privmsg.php
Download diff| 144 | 153 | ||
|---|---|---|---|
381 | 381 | ||
382 | if ($sent_info = $db->sql_fetchrow($result)) | 382 | if ($sent_info = $db->sql_fetchrow($result)) |
383 | { | 383 | { |
384 | if ($config['max_sentbox_privmsgs'] && $sent_info['sent_items'] >= $config['max_sentbox_privmsgs']) | 384 | if ($config['max_sentbox_privmsgs'] && ($sent_info['sent_items'] >= $config['max_sentbox_privmsgs'])) |
385 | { | 385 | { |
386 | $sql = "SELECT privmsgs_id FROM " . PRIVMSGS_TABLE . " | 386 | $sql = "SELECT privmsgs_id FROM " . PRIVMSGS_TABLE . " |
387 | WHERE privmsgs_type = " . PRIVMSGS_SENT_MAIL . " | 387 | WHERE privmsgs_type = " . PRIVMSGS_SENT_MAIL . " |
... | ... | ||
391 | $old_privmsgs_id = $db->sql_fetchrow($result); | 391 | $old_privmsgs_id = $db->sql_fetchrow($result); |
392 | $old_privmsgs_id = $old_privmsgs_id['privmsgs_id']; | 392 | $old_privmsgs_id = $old_privmsgs_id['privmsgs_id']; |
393 | 393 | ||
394 | $sql = "DELETE FROM " . PRIVMSGS_TABLE . " | 394 | if (!empty($old_privmsgs_id)) |
395 | WHERE privmsgs_id = $old_privmsgs_id"; | 395 | { |
396 | $result = $db->sql_query($sql); | 396 | $sql = "DELETE FROM " . PRIVMSGS_TABLE . " |
397 | WHERE privmsgs_id = " . $old_privmsgs_id; | ||
398 | $result = $db->sql_query($sql); | ||
399 | } | ||
397 | } | 400 | } |
398 | } | 401 | } |
399 | 402 |