we have some php files we show in the page with the wrapper, loading the position in the articles, but that has the bad side of encasing all the content in the wrapper, which includes a thickbox that instead of opening in the entire page it opens inside the wrapper only.
Anyway, that's why i was so exited about using jumi, it worked like it said, except now that page got all messed up,the modules, which is the header and the top, and the main content became all slim, well the page looks weird, here
I am aware it could be the script, i guess:
Code: Select all
<html>
<head>
<style type="text/css">
body {
background-color: 222222;
margin-left: 30px; /*background-image: url(file:///C|/Users/cvera/Desktop/sitio/fondo_galeria.jpg);*/
}
body div {
width: 150px;
height: 150px;
float: left;
clear: none;
}
#paginar {
clear: both;
text-align: center;
font-family: Arial, Helvetica, sans-serif;
font-size: 9px;
font-style: normal;
font-weight: bold;
color: #0C0;
text-decoration: none;
}
body div {
margin-top: 5px;
margin-right: 8px;
margin-bottom: 2px;
margin-left: 8px;
}
</style>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="thickbox.js"></script>
<link rel="stylesheet" href="thickbox.css" type="text/css" />
</head>
<body>
<?php
$errmsg = "";
if (! @mysql_connect("localhost","user","pass"))
{
$errmsg = "Cannot connect to database";
}
@mysql_select_db("user");
// Con esto tenemos el total de img en nuestra tabla 'autos'
$contador_img_sql = "SELECT count(*)
FROM vtiger_products T0
INNER JOIN vtiger_crmentity T1 ON T1.crmid = T0.productid
INNER JOIN vtiger_productcf T2 ON T2.productid = T0.productid
INNER JOIN vtiger_seattachmentsrel T3 ON T1.crmid = T3.crmid
INNER JOIN vtiger_attachments T4 ON T4.attachmentsid = T3.attachmentsid
WHERE T0.productcategory='Tiras Flexibles 150' AND T2.cf_607=1";//"select count(*) from vtiger_products WHERE productcategory='Tiras Flexibles 150'" ;
$contador_img_result = mysql_query($contador_img_sql) ;
$total_img = mysql_result($contador_img_result, 0, 0) ;
// configuración de la clase
include('class.kpaginate.php') ; // incluimos la clase
$kp1 = new kpaginate ; // instanciamos la clase
$kp1->setTotalItems($total_img) ; // OJO!, aquà ponemos el total de img que conseguimos anteriormente
$kp1->setItemsPerPage(5) ; // n = cuantos img queremos mostrar por página
$limit = $kp1->getLimit() ; // IMPORTANTE: Este metodo retorna un array con 2 valores, el primero es el lÃmite inferior y el segundo el lÃmite superior que debemos colocar en nuestra consulta, veamos...
// utilizando el resultado de la clase
$img_sql = "SELECT T0.product_no, T0.productname, T0.productcode, T0.productcategory, T1.description, T4.name, T4.path, T4.type, T4.attachmentsid
FROM vtiger_products T0
INNER JOIN vtiger_crmentity T1 ON T1.crmid = T0.productid
INNER JOIN vtiger_productcf T2 ON T2.productid = T0.productid
INNER JOIN vtiger_seattachmentsrel T3 ON T1.crmid = T3.crmid
INNER JOIN vtiger_attachments T4 ON T4.attachmentsid = T3.attachmentsid
WHERE T0.productcategory='Tiras Flexibles 150' AND T2.cf_607=1 ORDER BY product_no limit " . $limit[0] . ', ' . $limit[1] ;
$img_result = mysql_query($img_sql) ;
$i=0;
$img_sql2 = "SELECT T0.productid, T0.product_no, T0.productname, T0.productcode, T0.productcategory, T1.description, T4.path, T4.attachmentsid, T4.name
FROM vtiger_products T0
INNER JOIN vtiger_crmentity T1 ON T1.crmid = T0.productid
INNER JOIN vtiger_senotesrel T2 ON T2.crmid = T0.productid
INNER JOIN vtiger_seattachmentsrel T3 ON T2.notesid = T3.crmid
INNER JOIN vtiger_attachments T4 ON T4.attachmentsid = T3.attachmentsid
INNER JOIN vtiger_productcf T5 ON T5.productid = T0.productid
WHERE T0.productcategory='Tiras Flexibles 150' AND T5.cf_607=1 ORDER BY product_no limit " . $limit[0] . ', ' . $limit[1] ;
$img_result2 = mysql_query($img_sql2) ;
$i=0;
while($img = mysql_fetch_object($img_result)){
/*echo $img->T0.productname echo mysql_result($img_result,$i,"T0.productname");echo'<br>' ; */// suponiendo que en la tabla 'autos' tenemos el campo 'marca'
?><div><a style="text-decoration:overline; text-align:center; font-family:Arial, Helvetica, sans-serif; font-size:12px; color:#85C226; text-decoration:none"target="_new" href="http://leds-on.mx/crm/<?php echo mysql_result($img_result2,$i,"T4.path"); ?><?php echo mysql_result($img_result2,$i,"T4.attachmentsid"); ?>_<?php echo mysql_result($img_result2,$i,"T4.name"); ?>" class="thickbox">
<img src="../crm/<?php echo mysql_result($img_result,$i,"path"); ?><?php echo mysql_result($img_result,$i,"attachmentsid"); ?>_<?php echo mysql_result($img_result,$i,"name"); ?>"width="150"><p><?php echo mysql_result($img_result,$i,"T0.productname"); ?></p><p></p><p></p>
</a></div>
<?php
$i++;}
// Al final imprimimos la paginación, ya saben, los numeritos...?>
<div id="paginar"><?php echo"<p>"; $kp1->paginate() ;?></div>
</body>
</html>I was seriously not expecting what just happened, i feel a little ashamed to ask because i understand it might have nothing to do with jumi, but i seriously don't know if it does or not
