vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Scheduled Tasks - Logging (https://vborg.vbsupport.ru/showthread.php?t=281580)

Mko 04-15-2012 01:10 PM
Scheduled Tasks - Logging
 
I've created my own Scheduled Task coded in MySQLi. Although, I'm stumped as to how to make this Scheduled Task Log its actions.

Core Code:
PHP Code:
<?php
error_reporting(E_ALL & ~E_NOTICE & ~8192);
$link = mysqli_init();
mysqli_real_connect($link, 'localhost', 'root', '', 'vbulletin');

$time = time();
// select all banned users who are due to have their ban lifted
$bannedusers = mysqli_query($link, "SELECT * FROM table WHERE time <> 0 AND time < " .$time. "") or print(mysqli_error($link));

$logging = mysqli_fetch_array($bannedusers);

// do we have some results?
if (mysqli_num_rows($bannedusers))
{
    // delete ban records
    mysqli_query($link, "UPDATE table SET time = 0 WHERE timetime <> 0 AND time < " .$time. "") or print(mysqli_error($link));

    // log the cron action
    log_cron_action(implode(', ', $logging['id']), $nextitem, 1);
}

mysqli_free_result($bannedusers);
?>
However, when I execute this Task, I get this error message:
Warning: implode() [function.implode]: Invalid arguments passed in [path]/includes/cron/mycode.php on line 19

Can anyone help me so I can properly Log these actions?

Thanks,
Mark

kh99 04-15-2012 03:18 PM
The second implode() parameter needs to be an array. If you want to log the entire $logging array, probably you just want to pass it $logging (without the [$id]).

Mko 04-15-2012 03:39 PM
Quote:
Originally Posted by kh99 (Post 2320360)
The second implode() parameter needs to be an array. If you want to log the entire $logging array, probably you just want to pass it $logging (without the [$id]).
Without the ['id'] leads to the whole row being logged. Is there any way to just make it log the ID?

kh99 04-15-2012 05:12 PM
I think you can either provide a string to log, like

Code:
log_cron_action("Id is " . $logging['id'], $nextitem);

or else you can use a phrase (which has to be named task_varname_log, where varname is the actual varname of your task), and you can pass either one parameter to the phrase, or an array of parameters. So you could call it like this:

Code:
log_cron_action('', $logging['id'], $nextitem);

and then make a phrase something like "Id is {1}".

(FYI I got this by looking at the code, but I haven't actually tried it).

Mko 04-15-2012 05:32 PM
Works, thanks for your help!


All times are GMT. The time now is 01:07 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01071 seconds
  • Memory Usage 1,728KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (1)bbcode_php_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete