<?php
require_once 'DataAccess.php';
require_once 'includes/functions.php';
$name = $_POST['name'];
//user info
$id = 1;
$userName = "******";
$email = "*****@*****.**";
$description = $_POST['description'];
$stars = $_POST['stars'];
$latitude = $_POST['latitude'];
$longitude = $_POST['longitude'];
$now = getCurrentDateTime();
$sql = "INSERT INTO problems VALUES (null,'{$name}', '{$id}', '{$userName}', '{$email}','{$description}',null, 'fn','{$now}', 0, '{$now}', 'Active','{$stars}','{$latitude}','{$longitude}')";
$data = new DataAccess('photo');
$result = $data->executeQuery($sql);
$pid = mysql_insert_id();
if (!$result) {
echo mysql_error();
return;
}
$data->dispose();
return $pid;
function unlikeItem($userID, $itemID)
{
$data = new DataAccess('photo');
$sql = "SELECT like_count FROM items WHERE item_id={$itemID}";
$resultset = $data->getResultSet($sql);
$row = $data->getRow($resultset);
$newitemtotal = $row['like_count'] - 1;
$sql = "SELECT like_count FROM users WHERE fbid='{$userID}'";
$resultset = $data->getResultSet($sql);
$row = $data->getRow($resultset);
$newusertotal = $row['like_count'] - 1;
$newtime = getCurrentDateTime();
$sql = "UPDATE items SET like_count={$newitemtotal} WHERE item_id={$itemID}";
$data->executeQuery($sql);
$sql = "UPDATE users SET like_count={$newusertotal} WHERE fbid='{$userID}'";
$data->executeQuery($sql);
$sql = "DELETE FROM users_likes WHERE fbid='{$userID}' AND item_id={$itemID}";
$data->executeQuery($sql);
$data->dispose();
}
