Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Beda
Parašė Child· 2008 Gru. 17 16:12:21
#1
Tai va idieginejau VIP sistema i savo svetaine ir susiduriau su tokia beda online_users_panel'eje . Kai idejau nauja raso tokias klaidas
Unknown column 'vip_time' in 'where clause'VIP narių:
Nesuprantu kas negerai :|
Parašė Žmogus· 2008 Gru. 17 16:12:03
#2
Blogai įdiegiai
Parašė Child· 2008 Gru. 17 16:12:59
#3
Bet tai sukeiciau failus ir vsio , ir nuo tada pradejo sita nesamone rodyt, gal tiksliau galit padet?
Parašė WantedBoy· 2008 Gru. 17 17:12:58
#4
Stulpelis vip_time neatpažystamas.
Parašė Child· 2008 Gru. 17 17:12:54
#5
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
if (!defined("IN_FUSION")) { header("Location:../../index.php"); exit; }
if ($settings['maintenance'] != "1") {
$cond = ($userdata['user_level'] != 0 ? "'".$userdata['user_id']."'" : "'0' AND online_ip='".USER_IP."'");
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user=".$cond."");
if (dbrows($result) != 0) {
$result = dbquery("UPDATE ".$db_prefix."online SET online_lastactive='".time()."' WHERE online_user=".$cond."");
} else {
$name = ($userdata['user_level'] != 0 ? $userdata['user_id'] : "0");
$result = dbquery("INSERT INTO ".$db_prefix."online VALUES('$name', '".USER_IP."', '".time()."')");
}
$result = dbquery("DELETE FROM ".$db_prefix."online WHERE online_lastactive<".(time()-60)."");
openside($locale['010']);
$result = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user='0'");
echo $locale['011'].dbrows($result)."<br>\n";
$result = dbquery(
"SELECT ton.*, user_id,user_name FROM ".$db_prefix."online ton
LEFT JOIN ".$db_prefix."users tu ON ton.online_user=tu.user_id
WHERE online_user!='0'"
);
$result_members = dbquery("SELECT * FROM ".$db_prefix."online WHERE online_user<>'0'");
$members = dbrows($result_members);
if ($members != 0)
{
$i = 1;
echo $locale['012'];
$laikas=time();//del vip
while($om = dbarray($result_members))
{
$result_member = dbquery("SELECT * FROM ".$db_prefix."users WHERE `user_id`='".$om[online_user]."'");
$data = dbarray($result_member);
if($data[user_level]==103){
echo "<a style='color:#F75013;' href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a>";
}
else if($data[user_level]==102){
echo "<a style='color:#B5DE21;' href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a>";
}
//del vip
else if ($data[vip_time]>$laikas)
{
echo "<a style='color:#330099;' title='VIP NARYS' href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a>";
}
//--
else {
echo "<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a>";
}
if ($i != $members) echo ", ";
$i++;
}
echo "<br>\n";
} else {
echo $locale['013']."<br>\n";
}
echo "<br>".$locale['014'].dbcount("(user_id)", "users", "user_status<='1'")."<br>\n";
echo "VIP narių: ".dbcount("(user_id)", "users", "user_status<='1' AND vip_time>".$laikas)."<br>\n"; //vip is viso
if ($settings['admin_activation'] == "1") echo $locale['015'].dbcount("(user_id)", "users", "user_status='2'")."<br>\n";
$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 $locale['016']."<a href='".BASEDIR."profile.php?lookup=".$data['user_id']."' class='side'>".$data['user_name']."</a>\n";
closeside();
}
?>
ko cia neatpazint?
Parašė -· 2008 Gru. 17 17:12:24
#6
man irgi tas pats toj panelei ,o tau ejo padaryt uzklausa ?
Parašė Child· 2008 Gru. 17 17:12:12
#7
nu dar nedariau jokios uzklausos , nes tik pradejau instaliuot moda
Parašė -· 2008 Gru. 17 18:12:25
#8
zmones padekit del paneles B)
Parašė Žmogus· 2008 Gru. 17 18:12:15
#9
standby.lt parašytą:
Už papildomą mokestį galime įdiegti
Parašė Child· 2008 Gru. 17 19:12:22
#10
manau geriau pasitelksiu zmoniu pagalba
Parašė MAnjack· 2008 Gru. 17 20:12:38
#11
Jiem irgi reikia mokėt :D
Parašė Child· 2008 Gru. 17 21:12:15
#12
Bet gal kas nors kaledu proga pades;)
Parašė Child· 2008 Gru. 18 20:12:16
#13
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 '' at line 1VIP narių:
Dabar tokia pieva meta, gal kas zinot kaip pataisyt?
Redagavo Child· 2008 Gru. 18 20:12:12