sanoma

спасибо большое, исправил проблему....

Здравствуйте.... у меня проблема с одним таском... я пытаюсь вытащить с 3х таиблов результаты а потом их умножыть и прибавить друг другу... но у меня проблема с sql-ом, никак не смог исправить... он не работает после включения нечего не вводит в базу данных.... error log. [/color][color=#282828] Date: Tue, 12 Jun 2012 00:16:30 +0000 Error: 1064 - 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 'WHERE member_id=' at line 1 IP Address: 95.104.65.208 - /forum/admin/index.php?adsess=36d479aee4f1d42b99f4b929e5db260b&app=core&module=system&section=taskmanager&do=task_run_now&task_id=51&tab=members ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: UPDATE kate_pfields_content SET bounty= WHERE member_id= .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications/members/tasks/bounty.php | [db_main_mysql].update | 129 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/core/modules_admin/system/taskmanager.php | [task_item].runTask | 325 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/applications/core/modules_admin/system/taskmanager.php | [admin_core_system_taskmanager].taskManagerRunTask | 97 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [admin_core_system_taskmanager].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' вот скрип <?php if ( ! defined( 'IN_IPB' ) ) { print "<h1>Incorrect access</h1>You cannot access this file directly. If you have recently upgraded, make sure you upgraded all the relevant files."; exit(); } /** * * @class task_item * @brief Task to update the profile views from the temporary table * */ class task_item { /** * Object that stores the parent task manager class * * @var $class */ protected $class; /** * Array that stores the task data * * @var $task */ protected $task = array(); /** * Registry Object Shortcuts * * @var $registry * @var $DB * @var $lang */ protected $registry; protected $DB; protected $lang; /** * Constructor * * @param object $registry Registry object * @param object $class Task manager class object * @param array $task Array with the task data * @return @e void */ public function __construct( ipsRegistry $registry, $class, $task ) { /* Make registry objects */ $this->registry = $registry; $this->DB = $this->registry->DB(); $this->lang = $this->registry->getClass('class_localization'); $this->class = $class; $this->task = $task; } /** * Run this task * * @return @e void */ public function runTask() { $this->registry->getClass('class_localization')->loadLanguageFile( array( 'public_global' ), 'core' ); /* $this->DB->build( array( 'select' => 'posts, COUNT(*) as posts', 'eco_points, COUNT(*) as eco_points', 'from' => 'members', 'pfields_content', 'group' => 'member_id' ) ); */ // And finally, a complex build query showing all available parameters $this->DB->build( array( 'select' => 't.*', 'from' => array( 'members' => 't' ), 'group' => 't.member_id', 'add_join' => array( array( 'select' => 'm.*', 'from' => array( 'pfields_content' => 'm' ), 'where' => 'm.member_id=t.member_id', 'type' => 'left', ), array( 'select' => 'o.*', 'from' => array( 'profile_portal' => 'o' ), 'where' => 'o.pp_member_id=m.member_id', 'type' => 'left', ), ) ) ); //$z = $this->DB->execute(); //while( $this->DB->fetch( $z ) ) // { $sanoma = $o['time_spent'] + 80 * $m['eco_points'] / 4 + $t['posts'] * 100; //---------------------------------------- // Update... //----------------------------------------- $this->DB->update( 'pfields_content', "bounty=" .$sanoma, "member_id=" .$t['member_id'], FALSE, TRUE ); // $this->DB->update( 'pfields_content', 'bounty='. $sanoma, 'member_id=1', true, true ); // } //----------------------------------------- // Delete from table //----------------------------------------- //$this->DB->delete( 'bounty' ); //----------------------------------------- // Log to log table - modify but dont delete //----------------------------------------- $this->class->appendTaskLog( $this->task, $this->lang->words['task_bounty'] ); //----------------------------------------- // Unlock Task: DO NOT MODIFY! //----------------------------------------- $this->class->unlockTask( $this->task ); } } спасибо заранее...

исправил эту проблему но щяс появилась новая >.< когда я добавляю в скин <div class="smallfont"> <if='$r['category'] == 1'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>,</if> </div> он все выводит дважды с новой записью с базы.. ну на скрине будет понятнее чем моё обьяснение... http://img839.imageshack.us/img839/6089/ffffa.png оба награждённых в одной категории... вот что в скине.. <table width="100%" border="0" cellspacing="0" cellpadding="00"> <tr> <td><div align="center" style="padding:6px;" class="tcat">AniBox's Award System</div></td> </tr> </table> <table class="tborder" cellpadding="6" cellspacing="0" border="0" width="100%" align="center"> <tr> <td class="tcat" colspan="5"> <a rel="nofollow" href="http://anibox.ge/index.php?autocom=awards" name="award_cat4">AniBox-ის ჯილდოები</a> <div class="smallfont">ეს ჯილდოები ენიჭებათ მომხმარებლებს რომელიც დაეხმარნენ ჩვენს საიტს.</div> </td> </tr> <tr> <td class="thead" style="white-space:nowrap;">იკონკა</td> <td class="thead" style="white-space:nowrap;">სურათი</td> <td class="thead" width="35%" style="white-space:nowrap;">სათაური / აღწერა</td> <td class="thead" width="100%">მომხმარებლები რომლებმაც მიიღეს ეს ჯილდო</td> <td class="thead" align="center" style="white-space:nowrap;">ჯილდოს მოთხოვნა</td> </tr> <tr> <td class="alt1" align="center"> <img src="http://anibox.ge/style_images/awards/donators.gif" border="0" alt="" /> </td> <td class="alt1" align="center"> <a name="award14"></a> <img src="http://anibox.ge/style_images/awards/donators.gif" alt="Donators" border="0" /> </td> <td class="alt1"><strong>Donators</strong> <div class="smallfont">საიტის დონატორებს მათ ვინც 5 ლარზე მეტი ჩარიცხა, თქვენი თანხა მიდის საიტის განვითარებაზე.</div> </td> <td class="alt1" align="left"> <strong>მომხმარებლები რომლებმაც მიიღეს ეს ჯილდო:</strong><br /> <div class="smallfont"> <if='$r['category'] == 1'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>,</if> </div> </td> <td class="alt1" align="center"> <a rel="nofollow" href="http://anibox.ge/index.php?act=members">ჯილდოს მოთხოვნა</a> </td> </tr><tr> <td class="alt2" align="center"> <img src="http://anibox.ge/style_images/awards/helper.gif" border="0" alt="" /> </td> <td class="alt2" align="center"> <a name="award15"></a> <img src="http://anibox.ge/style_images/awards/helper.gif" alt="Helper Award" border="0" /> </td> <td class="alt2"><strong>Helper Award</strong> <div class="smallfont">დამხმარეს ჯილდო, იმ მომხმარებლებს ვინც ეხმარება ახალ დარეგისტრირებულ წევრებს, და ჩვენს საიტს განვითარებაში. [ვერ მოითხოვთ]</div> </td> <td class="alt2" align="left"> <strong>Members who received this award:</strong><br /> <div class="smallfont"> <if='$r['category'] == 2'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>, </if> </div> </td> <td class="alt2" align="center"> </td> </tr><tr> <td class="alt1" align="center"> <img src="http://anibox.ge/style_images/awards/coder.gif" border="0" alt="" /> </td> <td class="alt1" align="center"> <a name="award17"></a> <img src="http://anibox.ge/style_images/awards/coder.gif" alt="Coder Award" border="0" /> </td> <td class="alt1"><strong>Coder Award</strong> <div class="smallfont">ეს ჯილდო იმ მომხმარებლებისთვისაა ვინც ჩვენ პროგრამირებაში გვეხმარება, და საიტის შეცდომების შესახებ გვეუბნება.[ვერ მოითხოვთ]</div> </td> <td class="alt1" align="left"> <strong>Members who received this award:</strong><br /> <div class="smallfont"> <if='$r['category'] == 3'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>, </if> </div> </td> <td class="alt1" align="center"> </td> </tr><tr> <td class="alt2" align="center"> <img src="http://anibox.ge/style_images/awards/club.gif" border="0" alt="" /> </td> <td class="alt2" align="center"> <a name="award25"></a> <img src="http://anibox.ge/style_images/awards/club.gif" alt="Club Owner Award" border="0" /> </td> <td class="alt2"><strong>Club Owner Award</strong> <div class="smallfont">მომხმარებლებისთვის რომლებმაც შექმნეს კლუბი რომელიც პოპულარულია და ყოველდღიურად ნახლდება.</div> </td> <td class="alt2" align="left"> <strong>Members who received this award:</strong><br /> <div class="smallfont"> <if='$r['category'] == 4'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>, </if> </div></td> <td class="alt2" align="center"> <a rel="nofollow" href="http://anibox.ge/index.php?act=members">ჯილდოს მოთხოვნა</a> </td> </tr><tr> <td class="alt1" align="center"> <img src="http://anibox.ge/style_images/awards/games.gif" border="0" alt="" /> </td> <td class="alt1" align="center"> <a name="award7"></a> <img src="http://anibox.ge/style_images/awards/games.gif" alt="ISO/Games Award" border="0" /> </td> <td class="alt1"><strong>ISO/Games Award</strong> <div class="smallfont">ეს ჯილდო იმ მომხმარებლებისთვის არი რომელიც ერკვევიან თამაშებში წერენ კარგ თამაშების განხილვას, და აძლევენ მომხმარებლებს როკომენდაციებს.</div> </td> <td class="alt1" align="left"> <strong>Members who received this award:</strong><br /> <div class="smallfont"> <if='$r['category'] == 5'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>, </if> </div> </td> <td class="alt1" align="center"> <a rel="nofollow" href="http://anibox.ge/index.php?act=members">ჯილდოს მოთხოვნა</a> </td> </tr><tr> <td class="alt2" align="center"> <img src="http://anibox.ge/style_images/awards/refferal.gif" border="0" alt="" /> </td> <td class="alt2" align="center"> <a name="award16"></a> <img src="http://anibox.ge/style_images/awards/refferal.gif" alt="Referral Award" border="0" /> </td> <td class="alt2"><strong>Referral Award</strong> <div class="smallfont">მომხმარებლებისთვის რომლებმაც ადამიანი დაპატიჟეს საიტზე.</div> </td> <td class="alt2" align="left"> <strong>Members who received this award:</strong><br /> <div class="smallfont"> <if='$r['category'] == 6'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>, </if> </div> </td> <td class="alt2" align="center"> <a rel="nofollow" href="http://anibox.ge/index.php?act=members">ჯილდოს მოთხოვნა</a> </td> </tr><tr> <td class="alt1" align="center"> <img src="http://anibox.ge/style_images/awards/guard.gif" border="0" alt="" /> </td> <td class="alt1" align="center"> <a name="award43"></a> <img src="http://anibox.ge/style_images/awards/guard.gif" alt="AniBox's Guardian Award" border="0" /> </td> <td class="alt1"><strong>AniBox's Guardian Award</strong> <div class="smallfont">მომხმარებლებისთვის რომლებიც გვერდში დაუდგნენ საიტს გასაჭირში და ბოლომდე ცდილობდნენ დახმარებას.[ვერ მოითხოვთ]</div> </td> <td class="alt1" align="left"> <strong>Members who received this award:</strong><br /> <div class="smallfont"> <if='$r['category'] == 7'> <a href="{$this->ipsclass->base_url}showuser={$r['id']}&tab=awards" title="Awarded : {$r['datetime']}">{$r['members_display_name']}</a>, </if> </div></td> <td class="alt1" align="center"> </td> </tr> <tr> <td class="page" colspan="5"> <img src="clear.gif" width="16" height="4" alt="" /> </td> </tr>

я понял о чём вы говорили.. после фетч ров я добавил принт сделал такую вещь.. { $r['datetime'] = $this->ipsclass->get_date($r['datetime'],'LONG'); $r['members_display_name'] = $r['members_display_name']; $r['award_name'] = $r['award_name']; $r['category'] = $r['category']; $r['award_reason'] = $r['award_reason']; //$r['datetime'] = $this->ipsclass->do_number_format($r['datetime']); //$this->ipsclass->print->add_output(print_r($r, true)); $this->ipsclass->print->add_output($r); //midi gateste okey $this->output .= $this->ipsclass->compiled_templates['skin_awards']->main($r); } оно соединилось с скином.. как убрать это ? ArrayArray http://img824.imageshack.us/img824/7560/array.png мои знание не слишком велики в php так что извините за нубизм =(

спасибо.. эту проклятую базу я написал но теперь проблема с награжденьями... я хотел написать для него страницу ну так сказать кампанент.. index.php?autocom=awards function main() { /* $this->ipsclass->DB->build_query( array( 'select' => 'a.*', 'from' => array( 'awards' => 'a' ), 'add_join' => array ( 0 => array( 'select' => 'm.members_display_name', 'from' => array( 'members' => 'm' ), 'where' => 'a.username=m.id', 'type' => 'left' ) ) ) ); */ $query_array = array( 'select' => 'a.*', 'from' => array( 'awards' => 'a' ), 'add_join' => array( 0 => array( 'type' => 'left', 'select' => 'm.members_display_name', 'from' => array( 'members' => 'm' ), 'where' => "a.username=m.id", ), ), 'order' => 'a.datetime DESC', ); //$this->ipsclass->DB->exec_query(); // $this->ipsclass->DB->get_num_rows(); // $r = $this->ipsclass->DB->fetch_row(); // while($r = $this->ipsclass->DB->fetch_row()) $this->ipsclass->DB->build_query( $query_array ); $this->res = $this->ipsclass->DB->exec_query(); $this->total = $this->ipsclass->DB->get_num_rows( $this->res ); while( $r = $this->ipsclass->DB->fetch_row() ) $r['datetime'] = $this->ipsclass->get_date($r['datetime'],'LONG'); $r['members_display_name'] = $r['members_display_name']; $r['award_name'] = $r['award_name']; $r['category'] = $r['category']; $r['award_reason'] = $r['award_reason']; $r['datetime'] = $this->ipsclass->do_number_format($r['datetime']); $this->output .= $this->ipsclass->compiled_templates['skin_awards']->main($r); } } но нечего не выдается на странице >.< и вот она.. http://img842.imageshack.us/img842/9729/invision.png в скин файле изменения которые я внёс.. http://img830.imageshack.us/img830/4811/invision2.png спасибо за помощь заранее...

Здрасте.. значит так я пишу для IPB 2.3.x модификацыю Anime Базы.. вот такую вещицу.. http://img716.imageshack.us/img716/7765/db1.png http://img810.imageshack.us/img810/4743/db2.png так как я некогда не писал комапонентов для IPB мне это писать трудновато.. кроме как добавлял свои доработки в них.. чуточку я понимаю в кодинге.. так что есть добровольцы которые мне в этом помогут ? спасибо заранее.. пардон за мои ошыбки долго уже на русском не писал )) так и первоя проблема которая возникла у меня.. function main() { $this->ipsclass->DB->build_query( array( 'select' => 'id, title, image, status, rating, added_by', 'from' => 'abdb', 'limit' => array( 0, 10 ) ) ); $this->ipsclass->DB->simple_exec(); $this->ipsclass->DB->get_num_rows(); $tmp = $this->ipsclass->DB->fetch_row(); $abdb['title'] = $tmp['title']; $abdb['image'] = $tmp['image']; $abdb['status'] = $tmp['status']; $abdb['id'] = $this->ipsclass->do_number_format($tmp['id']); $this->output .= $this->ipsclass->compiled_templates[ 'skin_abdb']->template_main($abdb); } } я написал это.. потом конечно же создал в скине нужный кантент... с базы то отоброжается запись.. но только одна.. http://img37.imageshack.us/img37/1371/18674209.png http://img411.imageshack.us/img411/5687/27490291.png

Мне пишет ето я ни как немогу сделать mySQL query error: SELECT * FROM ibf_cache_store WHERE cs_key IN ( 'chatting','birthdays','calendar','rss_calendar','rss_export','components','banfilters','settings','group_cache','systemvars','skin_id_cache','forum_cache','moderators','stats','languages' ) SQL error: Table 'magick_forum.ibf_cache_store' doesn't exist SQL error code: Date: Tuesday 24th of January 2006 03:07:59 PM и че ме делать