| 314 | | //no errors, so continue.. |
|---|
| 315 | | if (!$this->inputError) { |
|---|
| 316 | | //check to see this post exists |
|---|
| 317 | | $sql = db_query("SELECT id from entries where shortsubject = '".$id."' AND user_id='".$this->id."';"); |
|---|
| 318 | | $sqlNum = db_num_rows($sql); |
|---|
| 319 | | //yes?, we can delete it then.. |
|---|
| 320 | | if ($sqlNum == 1) { |
|---|
| 321 | | $sql = db_query("DELETE FROM entries WHERE shortsubject = '{$id}' AND user_id = '".$this->id."';"); |
|---|
| 322 | | if (!$sql) { |
|---|
| 323 | | error(2,"Entry deletion failed - ".db_error()); |
|---|
| 324 | | } |
|---|
| 325 | | else { |
|---|
| 326 | | $this->inputError = _("Entry deleted."); |
|---|
| 327 | | $this->updateForm($id); |
|---|
| 328 | | } |
|---|
| 329 | | } |
|---|
| 330 | | //cant update non-existant entrys |
|---|
| 331 | | else { |
|---|
| 332 | | error(2,_("Cannot delete entry, as it does not exist.".db_error())); |
|---|
| 333 | | } |
|---|
| 334 | | } |
|---|
| 335 | | //redisplay entry form if there are errors |
|---|
| 336 | | else { |
|---|
| 337 | | $this->updateForm($id); |
|---|
| | 314 | //check to see this post exists |
|---|
| | 315 | $sql = db_query("SELECT id from entries where shortsubject = '".$id."' AND user_id='".$this->id."';"); |
|---|
| | 316 | $sqlNum = db_num_rows($sql); |
|---|
| | 317 | //yes?, we can delete it then.. |
|---|
| | 318 | if ($sqlNum == 1) { |
|---|
| | 319 | db_query("DELETE FROM entries WHERE shortsubject = '{$id}' AND user_id = '".$this->id."';"); |
|---|
| | 320 | echo "<p>"._("Entry deleted.")."</p>"; |
|---|
| | 321 | } |
|---|
| | 322 | //can't delete non-existant entrys |
|---|
| | 323 | else { |
|---|
| | 324 | error(2,_("Cannot delete entry, as it does not exist.".db_error())); |
|---|