Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: UseGoogle klausimai

Parašė Use Google· 2010 Kov. 29 13:03:56
#1

Sveiki. Kad neterst forumo (nes ir taip jau priterses esu) padariau savo klausimu tema.

Taigi, 1 klausimas: Kas per erroras?
Notice: Constant DB_BANAI already defined in /home/modai/domains/NesakysiuSavoSaito.lt/public_html/fusion7/infusions/ban_time_panel/ban_time_panel.php  on line 3




ban_time_panel.php
<?php
if (!defined("IN_FUSION")) { die("Access Denied"); }
define("DB_BANAI", DB_PREFIX."banai");
$result = dbquery("SELECT * FROM ".DB_USERS." tn LEFT JOIN ".DB_BANAI." tu ON tn.user_id=tu.ban_id
WHERE ban_time < ".time()."");
while($data = dbarray($result)){
$query=dbquery("UPDATE ".DB_USERS." SET user_status='0' WHERE user_id='".$data['user_id']."'");
$query=dbquery("DELETE FROM ".DB_BANAI." WHERE ban_time < ".time()."");
}

?>



Redagavo Use Google· 2010 Kov. 29 13:03:19

Parašė Use Google· 2010 Kov. 29 13:03:58
#2

Na? Padesit kas? Reikia labai

Parašė fLap· 2010 Kov. 29 13:03:06
#3

Jau egzistuoja DB_BANAI. :)

Parašė Use Google· 2010 Kov. 29 13:03:16
#4

O kaip panaikinti sita errora? Nes man ji rodo news.php, kad ir istrinu ta lentele, vistiek tuos errorus rodo.

Parašė Žmogus· 2010 Kov. 29 14:03:05
#5

Kokia versija fusiono?

Parašė Use Google· 2010 Kov. 29 14:03:17
#6

Fusion'o versija septinta.

Parašė Žmogus· 2010 Kov. 29 14:03:02
#7

<?php
if (!defined("IN_FUSION")) { die("Access Denied"); }
//define("DB_BANAI", DB_PREFIX."banai");
$result = dbquery("SELECT * FROM ".DB_PREFIX."banai" tn LEFT JOIN ".DB_PREFIX."banai" tu ON tn.user_id=tu.ban_id
WHERE ban_time < ".time()."");
while($data = dbarray($result)){
$query=dbquery("UPDATE ".DB_USERS." SET user_status='0' WHERE user_id='".$data['user_id']."'");
$query=dbquery("DELETE FROM ".DB_PREFIX."banai" WHERE ban_time < ".time()."");
}

?>





Gal veiks

Parašė Use Google· 2010 Kov. 29 14:03:27
#8

Parse error: syntax error, unexpected T_STRING in /home/modai/domains/modai.us.lt/public_html/fusion7/infusions/ban_time_panel/ban_time_panel.php  on line 4



Parašė Žmogus· 2010 Kov. 29 14:03:42
#9

Oj mano klaida :D

<?php
if (!defined("IN_FUSION")) { die("Access Denied"); }
//define("DB_BANAI", DB_PREFIX."banai");
$result = dbquery("SELECT * FROM ".DB_PREFIX."banai tn LEFT JOIN ".DB_PREFIX."banai tu ON tn.user_id=tu.ban_id
WHERE ban_time < ".time()."");
while($data = dbarray($result)){
$query=dbquery("UPDATE ".DB_USERS." SET user_status='0' WHERE user_id='".$data['user_id']."'");
$query=dbquery("DELETE FROM ".DB_PREFIX."banai WHERE ban_time < ".time()."");
}

?>




Parašė Use Google· 2010 Kov. 29 14:03:55
#10

Dabar rodo:
Column 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguousColumn 'ban_time' in where clause is ambiguous



:D

Parašė Use Google· 2010 Kov. 29 14:03:21
#11

Na? Niekas nepades? :?

Parašė Use Google· 2010 Kov. 29 14:03:11
#12

Na? Niekas nepades? :?

Parašė edis2· 2010 Kov. 29 15:03:35
#13

Taigi v7 yra DB_BLACKLIST

Parašė Use Google· 2010 Kov. 29 22:03:03
#14

Na, gal dabar kas pades?