­ì©«¥Ñ dicky12489 ©ó 2006-1-29 21:31 µoªí¡C 
¦³µLutf-8 ge
discuz_plugin_images_admin.txt+discuz_plugin_virtualimage.txt

$imagesquery = $db->query("SELECT u.* , m.username,i.imagename,i.endurance as da ... [/quote]


­ü . . ·PÁ Alan888 ¤jªº¦^ÂÐ . .

¥i¬O £á ·ÓµÛ±zªº¤èªk§ï¤F¥H«á !

¤@¼Ë¥X²{¦p¤Uªº°T®§ . . .


[code]

Discuz! info: MySQL Query Error

User: TonTon
Time: 2006-1-31 1:00pm
Script: /discuz/plugin.php

SQL: SELECT u.* , m.username,i.imagename,i.endurance as dates FROM cdb_images_user u ,cdb_images_data i LEFT JOIN cdb_members m ON m.uid = u.imagefrom WHERE u.userid = '1' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata
Error: Unknown column 'u.imagefrom' in 'on clause'
Errno.: 1054

Similar error report has beed dispatched to administrator before.

­ì©«¥Ñ DarkCircle ©ó 2006-1-31 13:04 µoªí¡C 

­ü . . ·PÁ Alan888 ¤jªº¦^ÂÐ . .
¥i¬O £á ·ÓµÛ±zªº¤èªk§ï¤F¥H«á !
¤@¼Ë¥X²{¦p¤Uªº°T®§ . . .
Discuz! info: MySQL Query Error
User: TonTon
Time: 2006-1-31 1:00pm
Script:  ...

ALTER TABLE `cdb_images_user` ADD INDEX ( `userid` );

DROP TABLE IF EXISTS `cdb_images_user`;
CREATE TABLE `cdb_images_user` (
  `userid` mediumint(8) NOT NULL default '0',
  `imagefrom` mediumint(8) NOT NULL default '0',
  `classid` varchar(10) NOT NULL default '',
  `picid` varchar(10) NOT NULL default '',
  `suitable` char(2) NOT NULL default '',
  `endurance` varchar(10) NOT NULL default '',
  `holdnum` char(3) NOT NULL default '1',
  `dafaultuse` char(1) NOT NULL default '0',
  `buydata` int(10) NOT NULL default '0',
  `lastuse` int(10) NOT NULL default '0',
  KEY `userid` (`userid`)
) TYPE=MyISAM;

<?
//**************************************************//
//           t.o.m.  µêÀÀ§Î¹³ for Discuz!           //
//--------------------------------------------------//
//                 Åwªï¨Ó«H¥æ¬y                     //
//            [email]theoldmemory@vip.sina.com[/email]             //
//--------------------------------------------------//
//               ·½½X¶}©ñ,­Ó¤H§K¶O                  //
//**************************************************//

if(!defined("IMAGES_INDEX")) {
        die("Access Denied");
}

/******************* Åã¥Ü­º­¶ **********************/
$gender = $imagesuser[gender];
if ($gender == 1){
        $usergender = "«Ó­ô";
        $userequip = '0-0-0-0-0-0-0-0-init-init-0-init-0-init-init-0-0-0-init-0-0-0-0-0-0-0';  //¨k©Êªºªì©l­È
        $sex = "m";
        $upid = "init";
}elseif($gender == 2){
        $usergender = "¬ü¤k";
        $userequip = '0-0-0-0-0-0-0-0-initf-initf-0-initf-0-initf-initf-0-0-0-initf-0-0-0-0-0-0-0'; //¤k©Êªºªì©l­È
        $sex = "f";
        $upid = "initf";
}else{
        $sex = 'no';
}

$userequip = images_load($imagesuser,1);

//-----------------Åã¥Ü¨ØÀ¹ª««~
$break = 1;
$imagesquery = $db->query("SELECT u.* , m.username, i.imagename, i.endurance as dates FROM ($tablepre"."images_user u ,$tablepre"."images_data i) LEFT JOIN $tablepre"."members m ON m.uid = u.imagefrom WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '1' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");
while ($userimages = $db->fetch_array($imagesquery)){
        $tempi = $userimages[classid];
        $cookiearray[$tempi] = $userimages[picid];
        $temptime = time();
        $images_weardate = $userimages[endurance]+$userimages[lastuse]-$temptime;
        $images_weardate = ceil($images_weardate/86400);
if($setting[beold]==0){
        $userimages[weardate] = "¨S¦³­­´Á";
}else{
        $userimages[weardate] = "$images_weardate ¤Ñ";
}
        if ($userimages[imagefrom]==0){
                $imagesfrom = "­Ó¤HÁʶR";
        }else{
                $imagesfrom = "$userimages[username] ÃØ°e";
        }

        if($userimages[suitable] == 'm'){
                $userimages[suit] = "«Ó­ô";
        }elseif($userimages[suitable] == 'f'){
                $userimages[suit] = "¬ü¤k";
        }else{
                $userimages[suit] = "³q¥Î";
        }

        $userimages[endurance] = $userimages[dates];
        $buydate =  gmdate("Y-m-d",$userimages[buydata]+($timeoffset * 3600));
        $buytime =  gmdate("H:i:s",$userimages[buydata]+($timeoffset * 3600));

        $putoffurl = "plugin.php?identifier=virtualimage&module=virtualimage&index=operation&action=putoff&classid=".$userimages[classid]."&id=".$userimages[picid];
        $userimages[pic] = "<IMG style='FILTER: alpha(opacity=299.177); CURSOR: hand' src={$image_url}$userimages[classid]/".$userimages[picid]."x.gif height=84 border=0 alt='ÂIÀ»¹«¼Ð¥ªÁä²æ¤U&#13;&#10;ÁʶR¤é´Á¡R$buydate &#13;&#10;ÁʶR®É¶¡¡R$buytime &#13;&#10;¨Ó¡@¡@¦Û¡R$imagesfrom' onclick=javascript:makesure('²æ¤U','$putoffurl')>";

        $userimages[tr] = $break;
        $break++;
        $putonlist[] = $userimages;
}

//---------------------Åã¥Ü¥¼¨ØÀ¹ª««~
$imagesquery = $db->query("SELECT u.* , m.username, i.imagename, i.endurance as dates FROM ($tablepre"."images_user u ,$tablepre"."images_data i) LEFT JOIN $tablepre"."members m ON m.uid = u.imagefrom WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");
$break = 1;
while ($imagesdata=$db->fetch_array($imagesquery)){
        if ($imagesdata[imagefrom]==0){
                $imagesfrom = "­Ó¤HÁʶR";
        }else{
                $imagesfrom = "$imagesdata[username]ÃØ°e";
        }

        $images_weardate = ceil($imagesdata[endurance]/86400);
        $imagesdata[weardate] = $images_weardate;

        $imagesdata[endurance] = $imagesdata[dates];

        $buydate =  gmdate("Y-m-d",$imagesdata[buydata]+($timeoffset * 3600));
        $buytime =  gmdate("H:i:s",$imagesdata[buydata]+($timeoffset * 3600));
        $imagesdata[pic] = "<img style=\"FILTER: alpha(opacity=299.177); CURSOR: hand\" alt=\"ÂIÀ»¹«¼Ð¥ªÁä¸Õ¬ï&#13;&#10;ÁʶR¤é´Á¡R$buydate&#13;&#10;ÁʶR®É¶¡¡R$buytime&#13;&#10;¨Ó¡@¡@¦Û¡R$imagesfrom\" src = ".$image_url.$imagesdata[classid]."/".$imagesdata[picid]."x.gif height=84 border=0 onClick=\"javascript:CHECK('$imagesdata[classid]','$imagesdata[picid]','$imagesdata[suitable]','$sex')\">";

        if($imagesdata[suitable] == 'm'){
                $imagesdata[suit] = "«Ó­ô";
        }elseif($imagesdata[suitable] == 'f'){
                $imagesdata[suit] = "¬ü¤k";
        }else{
                $imagesdata[suit] = "¥þ³¡";
        }

        $imagesdata[sendurl] = "plugin.php?identifier=virtualimage&module=virtualimage&index=operation&action=send&classid=$imagesdata[classid]&id=$imagesdata[picid]";
        $imagesdata[delurl] ="plugin.php?identifier=virtualimage&module=virtualimage&index=operation&action=delimages&classid=$imagesdata[classid]&id=$imagesdata[picid]";

        $imagesdata[tr] = $break;
        $break++;
        $putofflist[] = $imagesdata;;
}
//------------------------------------------
$userbutton = "<IMG height=20 src={$image_url}main_right_24.gif width=55 border=0 title=«O¦s²{¦bªº§Î¹³ style=\"CURSOR: hand\" onclick=\"location.href='plugin.php?identifier=virtualimage&module=virtualimage&index=operation&action=saveimages'\">";
//--------------------------------------------------------

include template('images_index');

?>

Discuz! info: MySQL Query Error

User: TonTon
Time: 2006-1-31 2:27pm
Script: /discuz/plugin.php

SQL: SELECT u.* , m.username,i.imagename,i.endurance as dates FROM cdb_images_user u ,cdb_images_data i LEFT JOIN cdb_members m ON m.uid = u.imagefrom WHERE u.userid = '1' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata
Error: Unknown column 'u.imagefrom' in 'on clause'
Errno.: 1054

Similar error report has beed dispatched to administrator before.

­ì©«¥Ñ DarkCircle ©ó 2006-1-31 14:30 µoªí¡C&nbsp;
­ü . .
¿ù»~°T®§¦ü¥G¬O¤@¼Ëªº ~
Discuz! info: MySQL Query Error
User: TonTon
Time: 2006-1-31 2:27pm
Script: /discuz/plugin.php
SQL: SELECT u.* , m.username,i.imagename,i.endur ...

$imagesquery = $db->query("SELECT u.* , m.username,i.imagename,i.endurance as dates FROM $tablepre"."images_user u ,$tablepre"."images_data i LEFT JOIN $tablepre"."members m ON m.uid = u.imagefrom WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

$imagesquery = $db->query("SELECT u.*, m.username,i.imagename, i.endurance as dates FROM ($tablepre"."images_user u, $tablepre"."images_data i) LEFT JOIN $tablepre"."members m ON (m.uid = u.imagefrom) WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

Discuz! info: MySQL Query Error

User: TonTon
Time: 2006-1-31 3:07pm
Script: /discuz/plugin.php

SQL: SELECT u.* , m.username,i.imagename,i.endurance as dates,i.cost FROM cdb_images_user u ,cdb_images_data i LEFT JOIN cdb_members m ON m.uid = u.imagefrom WHERE u.userid = '1' AND u.dafaultuse = '3' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata
Error: Unknown column 'u.imagefrom' in 'on clause'
Errno.: 1054

Similar error report has beed dispatched to administrator before.

­ì©«¥Ñ DarkCircle ©ó 2006-1-31 14:59 µoªí¡C
>"<
¯u¬OÁV¿| . .
¤@¼ËÁÙ¬O¿ù»~ªº . .
Ãø¹D§Ú¦w¸Ë¹Lµ{¦³¿ù¶Ü ?
À³¸Ó»¡²{¦b¬O §Úªº¦çÂd¤w¸g§¹¦¨¤F !
¦ý¬O­n ¯}¦çÁM ®É·|Åܦ¨³o¼Ë !
Discuz! info: MySQL Query Error
Use ...

$imagesquery = $db->query("SELECT u.* , m.username,i.imagename,i.endurance as dates FROM $tablepre"."images_user u ,$tablepre"."images_data i LEFT JOIN $tablepre"."members m ON m.uid = u.imagefrom WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '1' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

$imagesquery = $db->query("SELECT u.*, m.username,i.imagename, i.endurance as dates FROM ($tablepre"."images_user u, $tablepre"."images_data i) LEFT JOIN $tablepre"."members m ON (m.uid = u.imagefrom) WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '1' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

$imagesquery = $db->query("SELECT u.* , m.username,i.imagename,i.endurance as dates FROM $tablepre"."images_user u ,$tablepre"."images_data i LEFT JOIN $tablepre"."members m ON m.uid = u.imagefrom WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

$imagesquery = $db->query("SELECT u.*, m.username,i.imagename, i.endurance as dates FROM ($tablepre"."images_user u, $tablepre"."images_data i) LEFT JOIN $tablepre"."members m ON (m.uid = u.imagefrom) WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '0' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

$imagesquery = $db->query("SELECT u.* , m.username,i.imagename,i.endurance as dates,i.cost FROM $tablepre"."images_user u ,$tablepre"."images_data i LEFT JOIN $tablepre"."members m ON m.uid = u.imagefrom WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '3' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

$imagesquery = $db->query("SELECT u.*, m.username,i.imagename,i.endurance as dates,i.cost FROM ($tablepre"."images_user u ,$tablepre"."images_data i) LEFT JOIN $tablepre"."members m ON (m.uid = u.imagefrom) WHERE u.userid = '$imagesuser[uid]' AND u.dafaultuse = '3' AND i.sort=u.classid AND i.graphic=CONCAT(u.picid,'.gif') ORDER BY u.buydata");

­ì©«¥Ñ DarkCircle ©ó 2006-1-31 15:23 µoªí¡C&nbsp;
·PÁ alan888 ¤jªº¨ó§U . .
¤w¸g§¹¾ã¦w¸Ë¦¨¥\¤F !
·Ó±zªº­×§ï £á
¬O¥u¦³¤p§Ì·|³o¼Ë ? ÁÙ¬O¤@¯ë¸Ë¦n´N­nª`·N³o¨Ç©O ?
¦]¬°¹ê¦b¤£À´ sql »yªk . .
ÁÂÁÂÀ°¦£¸Ñ¨M°ÝÃD

­ì©«¥Ñ alan888 ©ó 2005-12-12 22:57 µoªí¡C
§@¡@¡@ªÌ: T.O.M.
AL8 v1ª©: alan888
§Þ³N¤ä´©: http://www.alan888.com/Discuz/index.php
ºt¡@¡@¥Ü: [url]http://www.alan888.com/Discuz4/plugin.php?identifier=virtualimage&module=virtua ...

­ì©«¥Ñ »¨ ©ó 2005-12-12 23:00 µoªí¡C&nbsp;
¹Ï¤ù¾ã¦X
http://rapidshare.de/files/8215652/images.rar.html