Posted: 2008-11-03 22:12:58
the preview is really slow to load...
Official Forum
https://forum.antp.be/phpbb3/
Code: Select all
# --- SEARCH and TITLE ----------------
<div class='mainheader'>
<form name="mdb_search" action="$SEARCH_HREF">
<div class='searchbox'>
<input class='searchbox' type='text' name='search' value='$SEARCH_TEXT'/>
</div>
$HIDDEN_SEARCHINPUTS
<div class='searchbox'>
<a href='$CLEARSEARCH_HREF'><img src="$TEMPLATEDIR/images/search-right.gif" border="0" alt='$LANG[CLEARSEARCH]' title='$LANG[CLEARSEARCH]' /></a>
</div>
</form>
<h3><a href='$HTTPPATH'><span>$TITLE</span></a></h3>
</div>
Code: Select all
<?
require_once(dirname(__FILE__).'/mysql_db.inc');
$processMensual = new processMensual();
?>
<html>
<head> <title>Process Mensual For Movies</title>
</head>
<body>
<?php $processMensual->process(); ?>
</body>
</html>
<?php
class processMensual {
function processMensual()
{
//constructor
}
function process()
{
$this->_load_configuration();
//print $this->checkIfColumnExists();
if ($this->checkIfColumnExists())
{
//print "Column found.";
}
else
{
$this->createColumn();
$this->processMensualForMovies();
print "<br>Mensual processed for all movies.";
}
}
function _load_configuration() {
# Load the Main Configuration; Set the MySQL variables.
require_once(dirname(__FILE__)."/mdb_config.inc");
$this->template_path = dirname(__FILE__)."/templates/".$this->config['options']['template'];
$this->db = new mysql_db($this->config['mysql']['server'], $this->config['mysql']['username'], $this->config['mysql']['password']);
$this->mysql_table = "`".$this->config['mysql']['database']."`.`".$this->config['mysql']['table']."`";
# Load the Language and Template Configurations
//require_once(dirname(__FILE__)."/languages/".$this->config['options']['language'].".inc");
//require_once($this->template_path."/config.inc");
}
function checkIfColumnExists()
{
$query = "SHOW columns FROM $this->mysql_table ";
$result = $this->db->query($query);
while ( $row = $result->fetch_array() )
{
//print "<br>$row[0]";
if ($row[0]=='MENSUAL'){
print "<br>Columns Found ";
return true;
}
}
print "<br>Column not Found!";
return false;
}
function createColumn()
{
$lsSQL = "ALTER TABLE $this->mysql_table ADD MENSUAL VARCHAR(15)";
$updateresult = $this->db->query($lsSQL);
print "<br>Column MENSUAL created!";
}
function processMensualForMovies()
{
$query = "SELECT NUM, DATE_FORMAT(dateadd,'%M %Y') 'mensual' FROM $this->mysql_table";
$result = $this->db->query($query);
while ( $row = $result->fetch_assoc() )
{
$mensual='';
$y = $row[mensual];
if ($y = 'December 2007') {
$mensual="December 2007";
}
elseif ($y = 'December 2008') {
$mensual="December 2008";
}
elseif ( $y >= 'November 2007' ) {
$mensual="November 2007";
}
elseif ( $y >= 'Octuber 2007' ) {
$mensual="Octuber 2007";
}
elseif ( $y >= 'September 2007' ) {
$mensual="September 2007";
}
elseif ( $y >= 'August 2007' ) {
$mensual="August 2007";
}
elseif ( $y >= 'July 2007' ) {
$mensual="July 2007";
}
elseif ( $y >= 'June 2007' ) {
$mensual="June 2007";
}
elseif ( $y >= 'May 2007' ) {
$mensual="May 2007";
}
elseif ( $y >= 'May 2007' ) {
$mensual="May 2007";
}
elseif ( $y >= 'April 2007' ) {
$mensual="April 2007";
}
elseif ( $y >= 'March 2007' ) {
$mensual="March 2007";
}
elseif ( $y >= 'February 2007' ) {
$mensual="February 2007";
}
elseif ( $y >= 'January 2007' ) {
$mensual="January 2007";
}
elseif ($y >= 'December 2008') {
$mensual="December 2008";
}
elseif ( $y >= 'November 2008' ) {
$mensual="November 2008";
}
elseif ( $y >= 'Octuber 2008' ) {
$mensual="Octuber 2008";
}
elseif ( $y >= 'September 2008' ) {
$mensual="September 2008";
}
elseif ( $y >= 'August 2008' ) {
$mensual="August 2008";
}
elseif ( $y >= 'July 2008' ) {
$mensual="July 2008";
}
elseif ( $y >= 'June 2008' ) {
$mensual="June 2008";
}
elseif ( $y >= 'May 2008' ) {
$mensual="May 2008";
}
elseif ( $y >= 'May 2008' ) {
$mensual="May 2008";
}
elseif ( $y >= 'April 2008' ) {
$mensual="April 2008";
}
elseif ( $y >= 'March 2008' ) {
$mensual="March 2008";
}
elseif ( $y >= 'February 2008' ) {
$mensual="February 2008";
}
elseif ( $y >= 'January 2008' ) {
$mensual="January 2008";
}
else{
$mensual="Otro";
}
$lsSQL = "UPDATE $this->mysql_table SET MENSUAL='$mensual' WHERE NUM=$row[NUM]";
$updateresult = $this->db->query($lsSQL);
}
}
} //class
?>
Code: Select all
//----
$this->config['panels'][11]['dbfield'] = "MENSUAL";
$this->config['panels'][11]['display'] = TRUE;
$this->config['panels'][11]['minimum'] = 1;
//----
Code: Select all
<?
require_once(dirname(__FILE__).'/mysql_db.inc');
$processMensual = new processMensual();
//Creditos darkemi20
?>
<html>
<head> <title>Proceso Mensual Movies</title>
</head>
<body>
<?php $processMensual->process(); ?>
</body>
</html>
<?php
class processMensual {
function processMensual()
{
//constructor
}
function process()
{
$this->_load_configuration();
//print $this->checkIfColumnExists();
if ($this->checkIfColumnExists())
{
//print "Column found.";
}
else
{
$this->createColumn();
$this->processMensualForMovies();
print "<br>Mensual processed for all movies.";
}
}
function _load_configuration() {
# Load the Main Configuration; Set the MySQL variables.
require_once(dirname(__FILE__)."/mdb_config.inc");
$this->template_path = dirname(__FILE__)."/templates/".$this->config['options']['template'];
$this->db = new mysql_db($this->config['mysql']['server'], $this->config['mysql']['username'], $this->config['mysql']['password']);
$this->mysql_table = "`".$this->config['mysql']['database']."`.`".$this->config['mysql']['table']."`";
# Load the Language and Template Configurations
//require_once(dirname(__FILE__)."/languages/".$this->config['options']['language'].".inc");
//require_once($this->template_path."/config.inc");
}
function checkIfColumnExists()
{
$query = "SHOW columns FROM $this->mysql_table ";
$result = $this->db->query($query);
while ( $row = $result->fetch_array() )
{
//print "<br>$row[0]";
if ($row[0]=='MENSUAL'){
print "<br>Columns Found ";
return true;
}
}
print "<br>Column not Found!";
return false;
}
function createColumn()
{
$lsSQL = "ALTER TABLE $this->mysql_table ADD MENSUAL VARCHAR(15)";
$updateresult = $this->db->query($lsSQL);
print "<br>Column MENSUAL created!";
}
function processMensualForMovies()
{
$query = "SELECT NUM, dateadd FROM $this->mysql_table";
$result = $this->db->query($query);
while ( $row = $result->fetch_assoc() )
{
$array_fecha = explode('-',$row['dateadd']);
switch ($array_fecha[1])
{
case 1: $mensual = "01 Enero "; break;
case 2: $mensual = "02 Febrero "; break;
case 3: $mensual = "03 Marzo "; break;
case 4: $mensual = "04 Abril "; break;
case 5: $mensual = "05 Mayo "; break;
case 6: $mensual = "06 Junio "; break;
case 7: $mensual = "07 Julio "; break;
case 8: $mensual = "08 Agosto "; break;
case 9: $mensual = "09 Septiembre "; break;
case 10: $mensual = "10 Octubre "; break;
case 11: $mensual = "11 Noviembre "; break;
case 12: $mensual = "12 Diciembre "; break;
}
$mensual .= $array_fecha[0];
$lsSQL = "UPDATE $this->mysql_table SET MENSUAL='$mensual' WHERE NUM= {$row['NUM']}";
$this->db->query($lsSQL);
}
}
} //class
?>
Code: Select all
Ok... Lo que hace es... Por medio del campo de la base de datos MYSQL "DATEADD"
Ej. 2008-11-06
Año 2008
Mes 11 = Noviembre
Día 06 (NO importa el día, dado a que toma mes y año)
Saca las novedades... O peliculas agregadas por mes y año... Es muy util... Por eso lo hize...
Dejo una captura...
Code: Select all
Ok ... What you do is ... Through the field of database MYSQL "DateAdd"
Ex 2008-11-06
2008
November 11 Month =
Day 06 (no matter the day, since it takes months and years)
Get the news ... Or movies added each month and year ... It is very useful ... So what did ...
I let a catch ...
Code: Select all
<div class='actors'><b>$LANG[ACTORS]: </b>{ACTORS;3;, }<a href='$ACTOR[HREF]'>$ACTOR[NAME]</a>{/ACTORS}</div>
Code: Select all
<th>$LANG[ACTORS]</td>
<th>$LANG[ROLE]</td>
</tr>
{ACTORS}
<tr>
<td valign='top' class='actorname'><a href='$ACTOR[HREF]'>$ACTOR[NAME]</a></td>
<td valign='top' class='actorrole'>as $ACTOR[PARENTXT]</td>
</tr>
{/ACTORS}
Code: Select all
<th>$LANG[ACTORS]</td>
<th>$LANG[ROLE]</td>
</tr>
{ACTORS;10}
<tr>
<td valign='top' class='actorname'><a href='$ACTOR[HREF]'>$ACTOR[NAME]</a></td>
<td valign='top' class='actorrole'>as $ACTOR[PARENTXT]</td>
</tr>
{/ACTORS}