XoopsModules25x /
smallworld
| @@ 56-85 (lines=30) @@ | ||
| 53 | * @param int $userid |
|
| 54 | * @return string |
|
| 55 | */ |
|
| 56 | public function deleteAccount($userid) |
|
| 57 | { |
|
| 58 | global $xoopsDB, $xoopsUser; |
|
| 59 | $user = new \XoopsUser($userid); |
|
| 60 | $username = $user->uname(); |
|
| 61 | $sql01 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_admin') . " WHERE userid = '" . $userid . "'"; |
|
| 62 | $sql02 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_comments') . " WHERE uid_fk = '" . $userid . "'"; |
|
| 63 | $sql03 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_followers') . " WHERE me = '" . $userid . "' OR you = '" . $userid . "'"; |
|
| 64 | $sql04 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_friends') . " WHERE me = '" . $userid . "' OR you = '" . $userid . "'"; |
|
| 65 | $sql05 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_images') . " WHERE userid = '" . $userid . "'"; |
|
| 66 | $sql06 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_messages') . " WHERE uid_fk = '" . $userid . "'"; |
|
| 67 | $sql07 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_user') . " WHERE userid = '" . $userid . "'"; |
|
| 68 | $sql08 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_vote') . " WHERE user_id = '" . $userid . "'"; |
|
| 69 | $sql09 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_complaints') . " WHERE owner = '" . $userid . "' OR byuser_id = '" . $userid . "'"; |
|
| 70 | $sql10 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_settings') . " WHERE userid = '" . $userid . "'"; |
|
| 71 | ||
| 72 | $result01 = $xoopsDB->queryF($sql01); |
|
| 73 | $result02 = $xoopsDB->queryF($sql02); |
|
| 74 | $result03 = $xoopsDB->queryF($sql03); |
|
| 75 | $result04 = $xoopsDB->queryF($sql04); |
|
| 76 | $result05 = $xoopsDB->queryF($sql05); |
|
| 77 | $result06 = $xoopsDB->queryF($sql06); |
|
| 78 | $result07 = $xoopsDB->queryF($sql07); |
|
| 79 | $result08 = $xoopsDB->queryF($sql08); |
|
| 80 | $result09 = $xoopsDB->queryF($sql09); |
|
| 81 | $result10 = $xoopsDB->queryF($sql10); |
|
| 82 | // Remove picture dir |
|
| 83 | $dirname = XOOPS_ROOT_PATH . '/uploads/albums_smallworld' . '/' . $userid . '/'; |
|
| 84 | $this->smallworld_remDir($userid, $dirname, $empty = false); |
|
| 85 | } |
|
| 86 | ||
| 87 | /** |
|
| 88 | * smallworld_remDir function |
|
| @@ 518-548 (lines=31) @@ | ||
| 515 | * @param int $userid |
|
| 516 | * @return string |
|
| 517 | */ |
|
| 518 | public function deleteAccount($userid) |
|
| 519 | { |
|
| 520 | global $xoopsDB, $xoopsUser; |
|
| 521 | $user = new \XoopsUser($userid); |
|
| 522 | $username = $user->uname(); |
|
| 523 | $sql01 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_admin') . " WHERE userid = '" . $userid . "'"; |
|
| 524 | $sql02 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_comments') . " WHERE uid_fk = '" . $userid . "'"; |
|
| 525 | $sql03 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_followers') . " WHERE me = '" . $userid . "' OR you = '" . $userid . "'"; |
|
| 526 | $sql04 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_friends') . " WHERE me = '" . $userid . "' OR you = '" . $userid . "'"; |
|
| 527 | $sql05 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_images') . " WHERE userid = '" . $userid . "'"; |
|
| 528 | $sql06 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_messages') . " WHERE uid_fk = '" . $userid . "'"; |
|
| 529 | $sql07 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_user') . " WHERE userid = '" . $userid . "'"; |
|
| 530 | $sql08 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_vote') . " WHERE user_id = '" . $userid . "'"; |
|
| 531 | $sql09 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_complaints') . " WHERE owner = '" . $userid . "' OR byuser_id = '" . $userid . "'"; |
|
| 532 | $sql10 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_settings') . " WHERE userid = '" . $userid . "'"; |
|
| 533 | ||
| 534 | $result01 = $xoopsDB->queryF($sql01); |
|
| 535 | $result02 = $xoopsDB->queryF($sql02); |
|
| 536 | $result03 = $xoopsDB->queryF($sql03); |
|
| 537 | $result04 = $xoopsDB->queryF($sql04); |
|
| 538 | $result05 = $xoopsDB->queryF($sql05); |
|
| 539 | $result06 = $xoopsDB->queryF($sql06); |
|
| 540 | $result07 = $xoopsDB->queryF($sql07); |
|
| 541 | $result08 = $xoopsDB->queryF($sql08); |
|
| 542 | $result09 = $xoopsDB->queryF($sql09); |
|
| 543 | $result10 = $xoopsDB->queryF($sql10); |
|
| 544 | // Remove picture dir |
|
| 545 | $dirname = XOOPS_ROOT_PATH . '/uploads/albums_smallworld' . '/' . $userid . '/'; |
|
| 546 | $this->smallworld_remDir($userid, $dirname, $empty = false); |
|
| 547 | echo $username . _AM_SMALLWORLD_ADMIN_USERDELETEDALERT; |
|
| 548 | } |
|
| 549 | ||
| 550 | /** |
|
| 551 | * SmallworldDeleteDirectory function |
|
