Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Neiseina su table

Parašė Rasmitas· 2011 Sau. 30 15:01:44
#1


kodas:


echo "<center><b><span style='color:gray'> ";
echo "<table width='100%'><tr><td width='10%'>";
 
openside("Lankomumas");
 
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,6");
echo "<table cellpadding='0' cellspacing='0' width='100%'>";
if (dbrows($result) != 0) {
	while ($data = dbarray($result)) {
		$lastseen = time() - $data['user_lastvisit'];
		$iW=sprintf("%2d",floor($lastseen/604800));
		$iD=sprintf("%2d",floor($lastseen/(60*60*24)));
		$iH=sprintf("%02d",floor((($lastseen%604800)%86400)/3600));
		$iM=sprintf("%02d",floor(((($lastseen%604800)%86400)%3600)/60));
		$iS=sprintf("%02d",floor((((($lastseen%604800)%86400)%3600)%60)));
		if ($lastseen < 60){
			$lastseen= "<span style='color:orange'>ONLINE</span>";
		} elseif ($lastseen < 360){
			$lastseen= "5min";
		} elseif ($iW > 0){
			if ($iW == 1) { $text = "sav."; } else { $text = "sav."; }
			$lastseen = $iW." ".$text;
		} elseif ($iD > 0){
			if ($iD == 1) { $text = "d."; } else { $text = $locale['lsup006']; }
			$lastseen = $iD." ".$text;
		} else {
			$lastseen = $iH.":".$iM.":".$iS;
		}
		echo "<tr>\n<td class='' align='left'> <img src='".THEME."images/bullet.gif' alt=''>\n";
		echo "<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='".$data['user_name']."' class='side'>\n";
		echo trimlink($data['user_name'], 15)."</a></td><td class='side-small' align='right'>".$lastseen."</td>\n</tr>\n";
	}
}
echo "</table>";
closeside();
 
echo "</td><td width='33%'>";
openside("Narių statistika:");
$data = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));
echo "<span class='small'>°</span> Naujokas: <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' title='".$data['user_name']."'>".trimlink($data['user_name'], 12)."</a><br />\n";$tag1= date('d');
$tag1= date('d');
$monat1= date('m');
$jahr1= date('Y');
$hanfang = mktime(0,0,0,$monat1,$tag1,$jahr1);
$hende = mktime(23,59,59,$monat1,$tag1,$jahr1);
$ganfang = mktime(0,0,0,$monat1,$tag1-1,$jahr1);
$gende = mktime(23,59,59,$monat1,$tag1-1,$jahr1);
echo "° Naujų narių vakar: ".dbcount("(user_id)", "users", "user_joined >='".$ganfang."' AND user_joined <='".$gende."'")."<br>";
echo "° Naujų narių šiandien: ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'")."<br>";
echo "° Iš viso narių: ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))."<br />\n";
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=103");
$num_rows = mysql_num_rows($result);
echo "° Darbuotojų: 13 <br>\n";
echo "° Užbanintų narių: 9<br>\n";
closeside();
echo "</td><td width='33%'>";
openside("MusuApdaila.LT");
 
 
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
echo "° Naujienų ir akcijų: [".dbresult($result, 0)."]<br>";
echo "° Vartotojų grupių: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(article_id) FROM ".$db_prefix."articles");
echo "° Straipsnių: [".dbresult($result, 0)."]<br>";
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
echo "° Nuotraukų: [286]<br>";
$result = dbquery("SELECT count(weblink_id) FROM ".$db_prefix."weblinks");
echo "° Paslaugų: [24]<br>";
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox");
echo "° Klausimų: [".dbresult($result, 0)."]<br>";
 
 
closeside();
echo "</tr></table>";
 





ACIU
Redagavo Rasmitas· 2011 Sau. 30 15:01:10

Parašė T-Boy· 2011 Sau. 30 16:01:34
#2
Aš prisijungiau dabar į tavo tą puslapį ir man net nerodo to tarpo. Nežinau, tu čia jau gal sutvarkei. :)

Parašė Rasmitas· 2011 Sau. 30 16:01:55
#3
Pagridiniam puslape ok, bet useik i koki foruma ...

Parašė avice· 2011 Vas. 5 17:02:40
#4
koks webo url?
10+10=19

Parašė Rasmitas· 2011 Vas. 5 17:02:43
#5
http://www.musuapdaila.lt

Parašė avice· 2011 Vas. 5 17:02:32
#6
tvarkyk ta lentele kurioja yra sudetos paneles rasyk width ne procentais o px
bandyk sitaip gal:

echo "<center><b><span style='color:gray'> ";
 
echo "<table width='100%'><tr><td width='170'>";
 
 
 
openside("Lankomumas");
 
 
 
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_lastvisit>'0' AND user_status='0' ORDER BY user_lastvisit DESC LIMIT 0,6");
 
echo "<table cellpadding='0' cellspacing='0' width='100%'>";
 
if (dbrows($result) != 0) {
 
	while ($data = dbarray($result)) {
 
		$lastseen = time() - $data['user_lastvisit'];
 
		$iW=sprintf("%2d",floor($lastseen/604800));
 
		$iD=sprintf("%2d",floor($lastseen/(60*60*24)));
 
		$iH=sprintf("%02d",floor((($lastseen%604800)%86400)/3600));
 
		$iM=sprintf("%02d",floor(((($lastseen%604800)%86400)%3600)/60));
 
		$iS=sprintf("%02d",floor((((($lastseen%604800)%86400)%3600)%60)));
 
		if ($lastseen < 60){
 
			$lastseen= "<span style='color:orange'>ONLINE</span>";
 
		} elseif ($lastseen < 360){
 
			$lastseen= "5min";
 
		} elseif ($iW > 0){
 
			if ($iW == 1) { $text = "sav."; } else { $text = "sav."; }
 
			$lastseen = $iW." ".$text;
 
		} elseif ($iD > 0){
 
			if ($iD == 1) { $text = "d."; } else { $text = $locale['lsup006']; }
 
			$lastseen = $iD." ".$text;
 
		} else {
 
			$lastseen = $iH.":".$iM.":".$iS;
 
		}
 
		echo "<tr>\n<td class='' align='left'> <img src='".THEME."images/bullet.gif' alt=''>\n";
 
		echo "<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' title='".$data['user_name']."' class='side'>\n";
 
		echo trimlink($data['user_name'], 15)."</a></td><td class='side-small' align='right'>".$lastseen."</td>\n</tr>\n";
 
	}
 
}
 
echo "</table>";
 
closeside();
 
 
 
echo "</td><td width='170'>";
 
openside("Narių statistika:");
 
$data = dbarray(dbquery("SELECT user_id,user_name FROM ".$db_prefix."users WHERE user_status='0' ORDER BY user_joined DESC LIMIT 0,1"));
 
echo "<span class='small'>°</span> Naujokas: <a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side' title='".$data['user_name']."'>".trimlink($data['user_name'], 12)."</a><br />\n";$tag1= date('d');
 
$tag1= date('d');
 
$monat1= date('m');
 
$jahr1= date('Y');
 
$hanfang = mktime(0,0,0,$monat1,$tag1,$jahr1);
 
$hende = mktime(23,59,59,$monat1,$tag1,$jahr1);
 
$ganfang = mktime(0,0,0,$monat1,$tag1-1,$jahr1);
 
$gende = mktime(23,59,59,$monat1,$tag1-1,$jahr1);
 
echo "° Naujų narių vakar: ".dbcount("(user_id)", "users", "user_joined >='".$ganfang."' AND user_joined <='".$gende."'")."<br>";
 
echo "° Naujų narių šiandien: ".dbcount("(user_id)", "users", "user_joined >='".$hanfang."' AND user_joined <='".$hende."'")."<br>";
 
echo "° Iš viso narių: ".number_format(dbcount("(user_id)", "users", "user_status<='1'"))."<br />\n";
 
$result = mysql_query("SELECT user_level FROM ".$db_prefix."users where user_level=103");
 
$num_rows = mysql_num_rows($result);
 
echo "° Darbuotojų: 13 <br>\n";
 
echo "° Užbanintų narių: 9<br>\n";
 
closeside();
 
echo "</td><td width='170'>";
 
openside("MusuApdaila.LT");
 
 
 
 
 
$result = dbquery("SELECT count(news_id) FROM ".$db_prefix."news");
 
echo "° Naujienų ir akcijų: [".dbresult($result, 0)."]<br>";
 
echo "° Vartotojų grupių: [".dbresult($result, 0)."]<br>";
 
$result = dbquery("SELECT count(article_id) FROM ".$db_prefix."articles");
 
echo "° Straipsnių: [".dbresult($result, 0)."]<br>";
 
$result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads");
 
echo "° Nuotraukų: [286]<br>";
 
$result = dbquery("SELECT count(weblink_id) FROM ".$db_prefix."weblinks");
 
echo "° Paslaugų: [24]<br>";
 
$result = dbquery("SELECT count(shout_id) FROM ".$db_prefix."shoutbox");
 
echo "° Klausimų: [".dbresult($result, 0)."]<br>";
 
 
 
 
 
closeside();
 
echo "</tr></table>";

Kai ijungi foruma vienos puses paneles dingta taip ir isiplecia visa panele kai buna 100% width
Redagavo avice· 2011 Vas. 5 20:02:27

Parašė Rasmitas· 2011 Vas. 6 19:02:10
#7
Na va, aciu, padejo!