fernandopiedra

Forum Replies Created

Viewing 1 replies (of 1 total)

  • Hi.

    There’s a problem with the dates when the data is inserted on database. The problem is quite simple to solve. go to the plugin’s folder and open the file ec_db.class.php. Go to line 227 (function addEvent) and change all lines BEFORE $sql = INSERT INTO `$this->mainTable… for this lines:

    $postID = is_null($postID) ? “NULL” : “‘$postID'”;
    $location = is_null($location) ? “NULL” : “‘$location'”;
    $description = is_null($description) ? “NULL” : “‘$description'”;
    $startDate = is_null($startDate) ? “NULL” : “$startDate”;
    if($startDate!=”NULL”)
    $arrFecha = explode(“-“,$startDate);
    $startDate=”‘”.$arrFecha[2].”-“.$arrFecha[1].”-“.$arrFecha[0].”‘”;
    $endDate = is_null($endDate) ? “NULL” : “$endDate”;
    if($endDate!=”NULL”)
    $arrFecha = explode(“-“,$endDate);
    $endDate=”‘”.$arrFecha[2].”-“.$arrFecha[1].”-“.$arrFecha[0].”‘”;

    $linkout = is_null($linkout) ? “NULL” : “‘$linkout'”;
    $startTime = is_null($startTime) ? “NULL” : “‘$startTime'”;
    $accessLevel = is_null($accessLevel) ? “NULL” : “‘$accessLevel'”;
    $endTime = is_null($endTime) ? “NULL” : “‘$endTime'”;

    The fix consists in changing the date format (dd-mm-yyyy) for a valid MySQL format (yyyy-mm-dd) using php function explode and arranging the parameters according to MySQL.

    That’s it! Now the plugin is working perfect

Viewing 1 replies (of 1 total)