Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2008, 09:27 PM
PhilMcKrackon PhilMcKrackon is offline
 
Join Date: Apr 2008
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default CronJob / Execute PHP file question?

I have a very simple php file I have created that dumps some table data to a file on my server. Can some one point me to some instructions on what needs to be added to the PHP file and what I should do in the scheduled tasks section of VBulletin to run the file automatically? I just need a nudge in the right direction...

If I direct my browser to the PHP page the script runs correctly and the dump file is created, but I am unsure on what to do to get VB to execute it automatically for me.

Thanks,

Code:
<?php
$host = "localhost";
$mysql_user = "????";
$mysql_password = "?????";
$sdatabase = "????";
$slink = mysql_connect("$host", "$mysql_user", "$mysql_password") or die('Database Connection Failed. Wait a moment.');
mysql_select_db ("$sdatabase", $slink);
$file = fopen("linkimages.pvc", "w");
fwrite($file,"/cmp=90 \n");
fwrite($file,"/bts=1200 \n");
fwrite($file,"/cdo=IvFxjSUmbcorg \n");
fwrite($file,"/irp=15 \n");
fwrite($file,"/ift=JPEG \n");
$urls = mysql_query("SELECT linkid,linkurl FROM adv_links ORDER by linkid ASC");
while ($urlrow = mysql_fetch_array($urls)) {
fwrite($file,"| URL=");
fwrite($file, $urlrow[1]);
fwrite($file, " | "); 
fwrite($file,"ifn=");
fwrite($file, $urlrow[0]);
fwrite($file,"_t.jpg |\n");
}
fclose($file); 
?>
Reply With Quote
  #2  
Old 04-25-2008, 11:07 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

This is the basic form I use for my cron jobs:

PHP Code:
<?php

// ########### SET PHP ENVIRONMENT ##################
error_reporting(E_ALL & ~E_NOTICE);

if (!
is_object($vbulletin->db))
{
    exit;
}

// ########################################################################
// ######################### START MAIN SCRIPT ############################
// ########################################################################

all your php goes here.  Use standard vbulletin calls for your queries.  ie:
$mysquery $vbulletin->db->query_read("
    SELECT this, that
    FROM " 
TABLE_PREFIX "table
    WHERE whatever
"
);



?>
Reply With Quote
  #3  
Old 04-26-2008, 05:53 PM
PhilMcKrackon PhilMcKrackon is offline
 
Join Date: Apr 2008
Posts: 47
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thanks for the reply, I still had a fit trying to get this to run inside of VB but I was able to get it to run by setting up a cronjob inside the web cpanel. The syntax was php -q /home/name/forums/.../filename.php as the GET statement is disabled on my server.

I had to add the path to php.exe on my server wich happened to be #!/usr/lib/php

Now it executes perfectly.

Thanks for the help.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 01:58 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04276 seconds
  • Memory Usage 2,185KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_code
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete