PHP - Query Problems With Inner Join

I am using two seperate queries to calculate a streak, but the queries must be grouped together to find the actual streak?

Query 1:

SELECT COUNT(matchID) as streak, clan1 FROM webs_cup_matches WHERE ladID='17' AND clan1='2630' AND score1 > score2 AND confirmscore='1' AND einspruch='0' GROUP BY clan1 ORDER BY streak DESC LIMIT 1
Query 2:
SELECT COUNT(matchID) as streak, clan2 FROM webs_cup_matches WHERE ladID='17' AND clan2='2630' AND score1 < score2 AND confirmscore='1' AND einspruch='0' GROUP BY clan2 ORDER BY streak DESC LIMIT 1

is it possible someone can join these queries together?

I was running this query and feel this is slowing down the server:

Code: [Select]
$agent_query=$this->db->query("
                       SELECT u.id,u.name,u.team_id,l.agent_id from users AS u,leads AS l WHERE u.id=l.agent_id AND u.team_id
                        IS NOT   NULL AND u.is_active='1'
ORDER BY u.name ASC
");
Is there a better way to write the above code.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=313679.0

It's been a while since I sat down to build some pages and teach myself php. So now that I've started back up, I'm at a loss for what I've done. I deleted a file, and have to rebuild from an old broken version:

I have a form that submits a query to the database, but the results pages is giving me this error:

Code: [Select]
Oops, my query failed. The query is:
SELECT COUNT 'descriptors'.* ,'plantae'.* FROM 'descriptors' LEFT JOIN 'plantae' ON ('descriptors'.'plant_id' = 'plantae'.'plant_name') WHERE 'leaf_shape' LIKE '%auriculate%' AND 'leaf_venation' LIKE '%%' AND 'leaf_margin' LIKE '%%'
The error is:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.* ,'plantae'.* FROM ' at line 2
But I'm not seeing what the syntax error is.

Here's the code:
Code: [Select]
<?php 
require ('connection.php');

$display = 2;
// it's intentionally only 2 for the moment

if (isset($_GET['np'])) {
   $num_pages = $_GET['np'];
} else { 
$data = "SELECT COUNT
                        'descriptors'.*
                        ,'plantae'.*
                    FROM
                        'descriptors'
                    LEFT JOIN
                        'plantae' ON ('descriptors'.'plant_id' = 'plantae'.'plant_name')
                    WHERE
                        'leaf_shape' LIKE '%$s1%'
                        AND 'leaf_venation' LIKE '%$s3%'
                        AND 'leaf_margin' LIKE '%$s4%'";
$result = mysql_query ($data);

if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

$row = mysql_fetch_array($result, MYSQL_NUM);

$num_records = $row[0];

if ($num_records > $display) {
   $num_pages = ceil ($num_records/$display);
} else {
$num_pages = 1;
}
}
if (isset($_GET['s'])) {
   $start = $_GET['s'];
} else {
    $start = 0;
}

if(isset($_POST[submitted])) {
// Now collect all info into $item variable
$shape = $_POST['s1'];
$color = $_POST['s2'];
$vein = $_POST['s3'];
$margin = $_POST['s4'];




// This will take all info from database where row tutorial is $item and collects it into $data variable 

$data = mysql_query("SELECT
                        'descriptors'.*
                        ,'plantae'.*
                    FROM
                        'descriptors'
                    LEFT JOIN
                        'plantae' ON ('descriptors'.'plant_id' = 'plantae'.'plant_name')
                    WHERE
                        'leaf_shape` LIKE '%$s1%'
                        AND 'leaf_venation' LIKE '%$s3%'
                        AND 'leaf_margin' LIKE '%$s4%'
                    ORDER BY 'plantae'.'scientific_name` ASC LIMIT $start, $display");



//chs added this in... 
echo '<table align="center" cellspacing="0" cellpading-"5">
<tr>
<td align="left"><b></b></td>
<td align="left"><b></b></td>
<td align="left"><b>Leaf margin</b></td>
<td align="left"><b>Leaf venation</b></td>
</tr>
';
//end something chs added in 

// This creates a loop which will repeat itself until there are no more rows to select from the database. We getting the field names and storing them in the $row variable. This makes it easier to echo each field.

while($row = mysql_fetch_array($data)){
echo '<tr>
<td align="left"> <a href="link.php">View plant</a> &nbsp; &nbsp;</td>
<td align="left"> <a href="link.php">unknown link</a>&nbsp; &nbsp;</td>
<td align="left">' . $row['scientific_name'] . '</td>
<td align="left">' . $row['common_name'] . '</td>
<td align="left">' . $row['leaf_shape'] . '</td>
</tr>';
}
echo '</table>';
// row 95
}
if ($num_pages > 1) {
echo '<br /><p>';
$current_page = ($start/$display) + 1;
// row 100
if ($current_page != 1) {
echo '<a href="leafsearch2a.php?s=' . ($start - $display) . '&np=;' . $num_pages . '">Previous</a> ';
}

for ($i = 1; $i <= $num_pages; $i++) {
if($i != $current_page) {
echo '<a href="leafsearch2a.php?s=' . (($display * ($i - 1))) . '$np=' . $num_pages . '">' . $i . '</a>';
} else {
echo $i . ' ';
}
}


if ($current_page != $num_pages) {
 echo '<a href="leafsearch2a.php?s=' . ($start + $display) . '$np=' . $num_pages . '"> Next</a>';
}
} 
//added curly
?>

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=342696.0

Is there a cleaner way to do this?

$query = "SELECT branches.Language FROM eua_users, branches WHERE eua_users.AssignedBranch = branches.country" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) ;

$row = mysql_fetch_object($result) ;

$usrlang = $row->Language ;

$query = "SELECT UserName, Email FROM eua_users WHERE UserName = '$user'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error());

$row = mysql_fetch_object($result) ;

$branchmail = $row->Email ;

$query = "SELECT $usrlang FROM autoreplies WHERE ReplyID = '0'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error()) ;

$row = mysql_fetch_object($result) ;

$message = $row->$usrlang ;

$query = "SELECT $usrlang FROM autoreplies WHERE ReplyID = '1'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error()) ;

$row = mysql_fetch_object($result) ;

$url = $row->$usrlang ;

$query = "SELECT $usrlang FROM autoreplies WHERE ReplyID = '2'" ;
include("dbconnectlocal.php") ;
$result = mysql_query($query) or die(mysql_error()) ;

$row = mysql_fetch_object($result) ;

$subject = $row->$usrlang ;

hi,

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=323935.0

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=308855.0

I have a query which pulls all the data i need and it works fine. But when there is more than one topic in a forum it displays the forum each time. Say there are 4 topics in a forum. The forum name is displayed 4 times. Heres the code:

$query = $db->query("SELECT
              f.forum_id, f.forum_name, f.forum_description, f.forum_topics, f.forum_posts,
              f.forum_last_poster, f.forum_last_post_time, f.forum_last_post,
              p.parent_id, p.parent_name,
              m.user_id, m.user_username, m.user_group,
              t.topic_id, t.topic_name,
              po.post_id, po.post_subject
          FROM ".DB_PREFIX."forums as f
          JOIN ".DB_PREFIX."parents as p
              ON f.parent_id = p.parent_id
          LEFT JOIN ".DB_PREFIX."members as m
              ON f.forum_last_poster = m.user_id
          LEFT JOIN ".DB_PREFIX."topics as t
              ON f.forum_id = t.forum_id
          LEFT JOIN ".DB_PREFIX."posts as po
              ON po.post_id = f.forum_last_post
          ORDER BY p.parent_id")
          or trigger_error("SQL", E_USER_ERROR);

while ($forum_info = mysql_fetch_object($query))
{

I am new to table joins but someone helped me set this up so it should work but it doesnt. Any ideas why?

Hi all,

Firstly here is my code
Code: [Select]
<?php 
if (isset($_POST['update']))
{
include('../config.php');
$name = $_POST['name'];
$email = $_POST['email'];
$id = $_POST['id'];

$uquery=mysql_query("UPDATE customers SET name='$name' AND email='$email' WHERE id='$id'");
if($uquery)
{
echo mysql_error();
}

else

{
echo mysql_error();
}
}
?>


<link href="../styles/clientbox.css" rel="stylesheet" type="text/css">
<link href="cancelform.css" rel="stylesheet" type="text/css" />
<link href="../styles/form_dark.css" rel="stylesheet" type="text/css" />
<body><br>
<h3>My Details</h3>
<div class="text">
Please keep your details updated below, for security reasons you cannot change your password.<br>
<?php 
$id = $_GET['id'];
include('../config.php');
$query=mysql_query("SELECT * FROM customers WHERE id='$id'");
while($row = mysql_fetch_assoc($query))
   {
$name = $row['name'];
$email = $row['email'];

}
?>
<form class="dark" action="" method="post">
  <ol>
    <li>
      <fieldset>
        <legend>My Details</legend>
        <ol>
          <li>
            <label for="name">Account Holder</label>
            <input type="text" id="name" name="name" value="<?php echo $name;?>" />
          </li>
          <li>
            <label for="email">Contact/Login Email Address</label>
            <input type="text" id="email" name="email" value="<?php echo $email;?>" />
            <input type="hidden" id="id" name="id" value="<?php echo $id;?>" />
          </li>
        </ol>
      </fieldset>
    </li>
  </ol>
  <p style="text-align:right;">
    <input type="reset" value="CANCEL" />
    <input type="submit" value="UPDATE" name="update" />
  </p>
</form>
Basically what is happening is that whatever you enter into the name box returns a 0 if its text or 1 if numbers are entered as opposed to storing the value inputed, if the email address is changed then nothing happens at all.

Can someone see if I have made a noob mistake somewhere? The name and email fields are both varchar(256) in my database

Thanks

Hi all,

I have a query that runs just fine from the command line in MySQL, but when I try to run the exact same query using PHP to query the same database I get an error.

The query is:

SELECT Street, City, ZipCode, providers.bWebpage, OpHours.Open, OpHours.Close, lat, lng, ( 3959 * acos( cos( radians('41.757787') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('-88.321416') ) + sin( radians('41.757787') ) * sin( radians( lat ) ) ) ) AS distance FROM Providers, OpHours WHERE providers.bName = OpHours.bName AND OpHours.Close > '17:00:00' HAVING distance < '10' ORDER BY distance LIMIT 0 , 30

Like I stated above, when I run this query from the MySQL command line it returns 12 rows, which is what it should.

But when I try executing the same query via PHP I get this error message:

Invalid query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''17:00:00' HAVING distance < '10' ORDER BY distance LIMIT 0 , 30' at line 1

The PHP code is thus:

$connection=mysql_connect ($server, $username, $password);
if (!$connection)
   {
      echo 'Connection error';
     die("Not connected : " . mysql_error());
   }

$db_selected = mysql_select_db($database, $connection);
if (!$db_selected)
   {
      echo 'Database selection error' . '\n';
      die ("Can\'t use db : " . mysql_error());
   }

 $query = sprintf("SELECT Street, City, ZipCode, providers.bWebpage, OpHours.Open, OpHours.Close,
 lat, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) )
AS distance FROM Providers, OpHours WHERE providers.bName = OpHours.bName %s HAVING distance < '%s' ORDER BY distance LIMIT 0 , 30",
  mysql_real_escape_string($center_lat),
  mysql_real_escape_string($center_lng),
  mysql_real_escape_string($center_lat),
  mysql_real_escape_string($hours),
  mysql_real_escape_string($radius));

$result = mysql_query($query);

if (!$result)
   {
      die("Invalid query: " . mysql_error());
   }

I've also checked the MySQL logs and they don't report any errors.  I'm running this on a Mac using Snow Leopard.  MySQL version is 5.1.37 and the PHP version is 5.2.11.  If it makes any difference both of these are from MAMP version 1.8.4.

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=321853.0

Hi,

i have the following problem. I use a script to enter data in a mysql database and for now i only have three variable...

Quote

<h2>Invoeren</h2>
<form action="insert.php" method="post" class="cmxform">
  <fieldset>
   <legend>Gegevens</legend>
      <table border="2">
      <tr>
         <td>1. </td>
         <td><label for="merk">merk:</label></td>
         <td><input id="merk" name="merk" /></td>
      </tr>
      <tr>
         <td>2. </td>
         <td><label for="cpu">cpu:</label></td>
         <td><select name="cpu" id="cpu" />
            <option value="">Maakt niet uit</option>
            <option value="amd">amd</option>
            <option value="intel">intel</option>
         </select></td>
      </tr>
      <tr>
         <td>3. </td>
         <td><label for="hdd">hdd:</label></td>
         <td><select name="hdd" id="hdd" />
            <option value="">Maakt niet uit</option>
            <option value="160GB">160GB</option>
            <option value="320GB">320GB</option>
            <option value="500GB">500GB</option>
         </select></td>
      </tr>
   </table>
    <input type="submit" value="Verstuur" />
</fieldset> 
</form>



Data goes in to the database correctly but now i use the following search script...

Quote


<h2>zoeken</h2>
<form action="search.php" method="post" class="cmxform">
  <fieldset>
      <legend>Gegevens</legend>
      <table border="2">
      <tr>
         <td>1. </td>
         <td><label for="merk">merk:</label></td>
         <td><input id="merk" name="merk" /></td>
      </tr>
      <tr>
         <td>2. </td>
         <td><label for="cpu">cpu:</label></td>
         <td><select name="cpu" id="cpu" />
            <option value="0">Maakt niet uit</option>
            <option value="amd">amd</option>
            <option value="intel">intel</option>
         </select></td>
      </tr>
      <tr>
         <td>3. </td>
         <td><label for="hdd">hdd:</label></td>
         <td><select name="hdd" id="hdd" />
            <option value="0">Maakt niet uit</option>
            <option value="160GB">160GB</option>
            <option value="320GB">320GB</option>
            <option value="500GB">500GB</option>
         </select></td>
      </tr>
   </table>
    <input type="submit" value="Verstuur" />
  </fieldset>
</form>



The values go correct to the search script because i checked this with an echo function. The search.php loks like this

Quote

<?php
    $con = mysql_connect("localhost","admin","t1tan1um");
    if (!$con)
    {
    die('Could not connect: ' . mysql_error());
    }

    mysql_select_db("model", $con);
   
   $qry = "SELECT * FROM eigenschappen WHERE 1=1";
      if (isset($_POST['merk']) && $_POST['merk'] != 0) {
      $qry .= " AND merk='" . mysql_real_escape_string($_POST['merk']). "'";
      }
      if (isset($_POST['cpu']) && $_POST['cpu'] != 0) {
      $qry .= " AND cpu='" . mysql_real_escape_string($_POST['cpu']). "'";
      }
      if (isset($_POST['hdd']) && $_POST['hdd'] != 0) {
      $qry .= " AND hdd='" . mysql_real_escape_string($_POST['hdd']). "'";
      }
                  
      $result = mysql_query($qry) or die(mysql_error()); // lelijke foutmelding, zelf mooier maken of $result door een if statement halen
      
      while($row = mysql_fetch_array($result))
      
      {
      echo $row['merk'] . " " . $row['cpu'] . " " . $row['hdd'];
      echo "<br />";
      }
?>



When i search for hdd wich is last in de search list the query only returns the records wich contain that value. When the condition has to be for example Intel cpu AND 500GB it returns everyting with 500GB but also every kind of CPU.

Anyone?

Hello guys,

I have an website where I have 5 category blocks in my index page to show last 3 posts in each category.
But I having problems showing the content in my "last added" block.
Sometimes works, and sometimes not. Dont know what is happening...

Look:
http://screensnapr.com/e/Zm4ssA.jpg

Only "Filmes" is showing, but not "Series"...

the movies block sometimes have this issue too... the code is almost the same as above, maybe is the same problem...

For each category that I want to show their posts, I have a file called newhome_x.php

In my templates/dirvideo/main.tpl file, I have this code:
Code: [Select]
<div id="page_content" class="clearfix">
{info} {newhome_final} {content}
</div>
In my templates/dirvideo/newhome.tpl file, I have this code:
Code: [Select]
<li style="margin-right: 45px;" onclick="window.location='{link}'">
<a title='{home_title}' href="{link}"><img src="[xfvalue_poster]" alt='{home_title}' /></a>
<h3 style="overflow:hidden"><a title='{home_title}' href="{link}">{home_title}</a></h3>
</li>
in my index.php I have this code:
require_once ENGINE_DIR . '/modules/newhome.php';
require_once ENGINE_DIR . '/modules/newhome_b.php';
require_once ENGINE_DIR . '/modules/newhome_c.php';
require_once ENGINE_DIR . '/modules/newhome_d.php';
require_once ENGINE_DIR . '/modules/newhome_e.php';

if (clean_url ( $_SERVER['HTTP_HOST'] ) != clean_url ( $config['http_home_url'] )) {

$replace_url = array ();
$replace_url[0] = clean_url ( $config['http_home_url'] );
$replace_url[1] = clean_url ( $_SERVER['HTTP_HOST'] );

} else
$replace_url = false;

if (!$is_logged && !in_array($_GET['do'], array('register', 'lostpassword'))) { include 'index.html'; die; }
$tpl->load_template ( 'main.tpl' );
$tpl->set ( '{lastusers}', $lastusers);
$tpl->set('{forumStyle}', require_once ROOT_DIR . '/engine/bullet_energy/modules/load_style.php');
require_once ENGINE_DIR . '/modules/3news.php';$source = '<div class="index_top1" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/movies.gif">
</span>
<ul class="clearfix">
{newhome}
</ul>
</div>
<div class="index_top2" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/serie.gif">
</span>
<ul class="clearfix">
{newhome_b}
</ul>
</div>
<div class="index_top3" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/music.gif">
</span>
<ul class="clearfix">
{newhome_c}
</ul>
</div>
<div class="index_top6" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/jogo.gif">
</span>
<ul class="clearfix">
{newhome_e}
</ul>
</div>
<div class="index_top4" style="width: 100%; padding-top: 10px; padding-bottom: 10px; " >
<span style="font-size: 24px; margin-left: 10px;"><img border="0" src="templates/dirvideo/images/programas.gif">
</span>
<ul class="clearfix">
{newhome_d}
</ul>
</div>';
if (!isset($_REQUEST["catalog"]) && !isset($_REQUEST["newsid"]) && !isset($_REQUEST["do"]) && !isset($_REQUEST["page"]) && !isset($_REQUEST["category"]) && !isset($_REQUEST["cat"]) && !isset($_REQUEST["action"]) && !isset($_REQUEST["id"]) && !isset($_REQUEST["name"]) && !isset($_REQUEST["news_name"]) && !isset($_REQUEST["seourl"]) && !isset($_REQUEST["findpost"]) && !isset($_REQUEST["subaction"])) { $tpl->set ( '{newhome_final}', $source);} else { $tpl->set ( '{newhome_final}', "");}

$tpl->set ( '{referer}', $referer_block );
$tpl->set ( '{calendar}', $tpl->result['calendar'] );
$tpl->set ( '{top_news}', $top_news );
$tpl->set ( '{last_news}', $last_news );
$tpl->set ( '{rand_news}', $rand_news );
$tpl->set ( '{archives}', $tpl->result['archive'] );
$tpl->set ( '{tags}', $tpl->result['tags_cloud'] );
$tpl->set ( '{vote}', $tpl->result['vote'] );
$tpl->set ( '{topnews}', $topnews );
$tpl->set ( '{login}', $tpl->result['login_panel'] );
$tpl->set ( '{info}',  $tpl->result['info'] );
$tpl->set ( '{speedbar}', $tpl->result['speedbar'] );
$tpl->set ( '{catlist}', $catlist );
$tpl->set ( '{moviepopular}', $tpl->result['moviepopular'] );$tpl->set ( '{newhome}', $tpl->result['newhome'] );$tpl->set ( '{newhome_b}', $tpl->result['newhome_b'] );$tpl->set ( '{newhome_c}', $tpl->result['newhome_c'] );$tpl->set ( '{newhome_d}', $tpl->result['newhome_d'] );$tpl->set ( '{newhome_e}', $tpl->result['newhome_e'] );

In my engine/modules folder I have the files:
newhome.php
newhome_b.php
newhome_c.php
newhome_d.php
newhome_e.php

This is the code of engine/modules/newhome_c.php file (Series block):
<?php
if (!isset($_REQUEST["catalog"]) && !isset($_REQUEST["newsid"]) && !isset($_REQUEST["do"]) && !isset($_REQUEST["page"]) && !isset($_REQUEST["category"]) && !isset($_REQUEST["cat"]) && !isset($_REQUEST["action"]) && !isset($_REQUEST["id"]) && !isset($_REQUEST["name"]) && !isset($_REQUEST["news_name"]) && !isset($_REQUEST["seourl"]) && !isset($_REQUEST["findpost"]) && !isset($_REQUEST["subaction"])) {
 
if( ! defined( 'DATALIFEENGINE' ) ) {
 
        die( "Hacking Attempt!" );
 
}
 
 
 
$is_change = false;
 
 
 
if ($config['allow_cache'] != "yes") { $config['allow_cache'] = "yes"; $is_change = true;}
 
 
 
$tpl->result['newhome_c'] = dle_cache("newhome_c", $config['skin']);
 
 
 
$tpl->load_template( 'newhome.tpl' );
 
 
 
if( strpos( $tpl->copy_template, "[xfvalue_" ) !== false ) { $xfound = true; $xfields = xfieldsload();}
 
        else $xfound = false;
 
 
 
        if ($tpl->result['newhome_c'] === false) {
 
 
 
$sql = $db->query( "SELECT id, title, date, alt_name, category,xfields,autor FROM " . PREFIX . "_post WHERE category like '%7%' ORDER BY date DESC LIMIT 3" );
 
while ($row = $db->get_row($sql))
 
{
 
$catchecks = explode(",",$row["category"]);
 
$catpass = false;
foreach ($catchecks as $catcheck) {
        if ($catcheck == "7")
                $catpass = true;
}
 
if ($catpass) {
 
$sql2 = $db->query( "SELECT alt_name FROM " . PREFIX . "_category WHERE id='$row[category]'" );
 
 
 
$row2 = $db->get_row($sql2);
 
 
 
 
 
 
 
if( $xfound ) {
 
                        $xfieldsdata = xfieldsdataload( $row['xfields'] );
 
 
 
                        foreach ( $xfields as $value ) {
 
                                $preg_safe_name = preg_quote( $value[0], "'" );
 
 
 
                                if( empty( $xfieldsdata[$value[0]] ) ) {
 
                                        $tpl->copy_template = preg_replace( "'\\[xfgiven_{$preg_safe_name}\\](.*?)\\[/xfgiven_{$preg_safe_name}\\]'is", "", $tpl->copy_template );
 
                                } else {
 
                                        $tpl->copy_template = preg_replace( "'\\[xfgiven_{$preg_safe_name}\\](.*?)\\[/xfgiven_{$preg_safe_name}\\]'is", "\\1", $tpl->copy_template );
 
                                }
 
 
 
                                $tpl->copy_template = str_replace( "[xfvalue_{$preg_safe_name}]", stripslashes( $xfieldsdata[$value[0]] ), $tpl->copy_template );
 
                        }
 
                }
 
 
 
if($config['seo_type']=='1')
 
{
 
 
 
$link= "$row[id]".'-'."$row[alt_name]".'.html';
 
 
 
}
 
else
 
{
 
 
 
$link="$row2[alt_name]".'/'."$row[id]".'-'."$row[alt_name]".'.html';
 
 
 
}
 
 
 
 
 
$tpl->set( '{home_title}',stripslashes($row['title']));
 
$tpl->set( '{home_author}', stripslashes($row['autor']));
 
$tpl->set( '{home_date}', $row['date']);
 
$tpl->set( '{link}',$link);
 
$tpl->compile('newhome_c');
 
 
}
}
 
create_cache ("newhome_c", $tpl->result['newhome_c'], $config['skin']);
 
$tpl->clear();
 
$db->free();
 
}
 
if ($is_change) $config['allow_cache'] = false;
 
}
 
?>

I think that is everything here :-)
Can please someone help me?