| @@ 462-473 (lines=12) @@ | ||
| 459 | * @param int $smallworld_msg_id |
|
| 460 | * @return true |
|
| 461 | */ |
|
| 462 | public function deleteWallMsg($id, $smallworld_msg_id) |
|
| 463 | { |
|
| 464 | global $xoopsDB; |
|
| 465 | $query = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_messages') . " WHERE msg_id = '" . $smallworld_msg_id . "'"; |
|
| 466 | $result = $xoopsDB->queryF($query); |
|
| 467 | $query2 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_comments') . " WHERE msg_id_fk = '" . $smallworld_msg_id . "'"; |
|
| 468 | $result2 = $xoopsDB->queryF($query2); |
|
| 469 | //delete votes |
|
| 470 | $query3 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_vote') . " WHERE msg_id = '" . $smallworld_msg_id . "'"; |
|
| 471 | $result3 = $xoopsDB->queryF($query3); |
|
| 472 | return true; |
|
| 473 | } |
|
| 474 | ||
| 475 | /** |
|
| 476 | * deleteWallComment function |
|
| @@ 465-476 (lines=12) @@ | ||
| 462 | * @param int $smallworld_msg_id |
|
| 463 | * @return true |
|
| 464 | */ |
|
| 465 | public function deleteWallMsg($id, $smallworld_msg_id) |
|
| 466 | { |
|
| 467 | global $xoopsDB; |
|
| 468 | $query = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_messages') . " WHERE msg_id = '" . $smallworld_msg_id . "'"; |
|
| 469 | $result = $xoopsDB->queryF($query); |
|
| 470 | $query2 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_comments') . " WHERE msg_id_fk = '" . $smallworld_msg_id . "'"; |
|
| 471 | $result2 = $xoopsDB->queryF($query2); |
|
| 472 | //delete votes |
|
| 473 | $query3 = 'DELETE FROM ' . $xoopsDB->prefix('smallworld_vote') . " WHERE msg_id = '" . $smallworld_msg_id . "'"; |
|
| 474 | $result3 = $xoopsDB->queryF($query3); |
|
| 475 | return true; |
|
| 476 | } |
|
| 477 | ||
| 478 | /** |
|
| 479 | * deleteWallComment function |
|