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&#371;: ".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