pragmaMx Support Forum

Hi,
ich nutze das TopMusic Modul und würde nun gerne wissen, ob mir jemand die Eingabe eines Albums umändern kann?!
Und zwar würde ich gerne die Eingabe für ein neues Album mit Timestamp haben, wenn man das Erscheinungsdatum eingibt.
Also so, dass das eingegebene Datum als Timestamp in der SQL Datenbank hinterlegt wird.

Hier mal n ausschnitt aus dem Quellcode:

case "addAlbum":
require_once("modules/topMusic/admin/lib/com/sergids/topmusic/model/GenreAdminDAO.php");
require_once("modules/topMusic/admin/lib/com/sergids/topmusic/model/ArtistAdminDAO.php");
require_once("modules/topMusic/admin/lib/com/sergids/topmusic/model/AlbumAdminDAO.php");
    require_once("modules/topMusic/admin/lib/com/sergids/topmusic/view/GenericAdminView.php");
    $genreDAO=new GenreAdminDAO($db,$prefix);
$artistDAO=new ArtistAdminDAO($db,$prefix);
    $albumDAO=new AlbumAdminDAO($db,$prefix);
    $genreList=$genreDAO->getGenreList($currentlang);
    $artistList=$artistDAO->getSelectList();
    $albumList=$albumDAO->getSelectList();
    $albumFields=$albumDAO->getCustomFields();
    if($_POST["artist"])
    $artist=$_POST["artist"];
    elseif($_GET["idartist"])
    $artist=$_GET["idartist"];
    if($_POST['submit']!=""){
require_once("modules/topMusic/admin/lib/com/sergids/topmusic/model/AlbumAdminO.php");
require_once("modules/topMusic/admin/lib/com/sergids/topmusic/model/AlbumAdminDAO.php");
$albumO=new AlbumAdminO();

if($_FILES["frontcover_file"]["size"]>0){
$directory="modules/"._TOPMUSIC_MODULENAME."/photos/albums/";
if(move_uploaded_file($_FILES["frontcover_file"]["tmp_name"],($directory.$_FILES["frontcover_file"]["name"]))){
chmod($directory.$_FILES["frontcover_file"]["name"],0755);
    $albumO->setFrontcover_file($_FILES["frontcover_file"]["name"]);
}else{
$message.="Impossible to upload frontcover album file. Check permissions<br>";
}
}
if($_FILES["backcover_file"]["size"]>0){
$directory="modules/"._TOPMUSIC_MODULENAME."/photos/albums/";
if(move_uploaded_file($_FILES["backcover_file"]["tmp_name"],($directory.$_FILES["backcover_file"]["name"]))){
chmod($directory.$_FILES["backcover_file"]["name"],0755);
    $albumO->setBackcover_file($_FILES["backcover_file"]["name"]);
}else{
$message.="Impossible to upload backcover album file. Check permissions<br>";
}
}
$albumO->setGenreid($_POST['genre']);
$albumO->setTitle($_POST['title']);
$albumO->setYeardate($_POST['yeardate']);
$albumO->setComments($_POST['comments']);
$albumO->setFrontcover_url($_POST['frontcover_url']);
$albumO->setBackcover_url($_POST['backcover_url']);
$albumO->setIdartist($artist);
$albumO->setAmazonid($_POST['amazonid']);
$albumO->setCount($_POST['views']);
$albumO->setAvgvotes($_POST['avgvotes']);
$albumDAO->insertAlbum(&$albumO,$currentlang);
$albumDAO->updateCustomFields($albumO->getId(),$_POST);
$error=$db->sql_error();
if($error['message']==""){
if($_POST["related"]!="" && $_POST["related"]!="..."){
if(!$albumDAO->insertRelated($albumO->getId(),$_POST["related"]))
$message="Error inerting related album<br>";
}
$message.="Album added successfully";
}else
$message.="Error inserting album: ".$error['message'];
}
    OpenTable();
echo "<center><B>"._TOPMUSIC_ADDALBUM."</B></center>";
CloseTable();
echo "<br>";
    include("modules/topMusic/admin/newAlbum.php");
    break;


Und hier aus dem Formular:

<tr>
<td><?=_TOPMUSIC_DATE?>:</td><td><input type="text" name="yeardate" value="TT.MM.JJJJ"></td>
</tr>
<tr>
<td colspan="2">&nbsp;</td>
</tr>



So sieht bisher die SQL Tabelle für yeardate aus:

Feld	Typ	Attribute	Null	Standard	Extra
yeardate	varchar(45)	Ja	NULL