Web Hosting Talk







View Full Version : cron job question


Emjay
01-29-2002, 09:04 PM
Hi Im new in this forum:)
I hope this is the right section for this post.

I have searched for "cron job" in this forum but I couldnt find the exact info I was looking for.
I have never used cron job before, I heared that "cron" word first time yesterday:D.

so my problem is that, I have PostNuke and vBulletin board on same database and users have to register on both.
I found a sollution on this but I dont understand it, maybi u guys can help me.

How to use Postnuke & VB with one UserDB:
Upload a script that will regularly copy the contents of vbs Userdb to pn's userdb
something like this:


<?php
//connect to database
mysql_connect("localhost", "yourDB", "yourPW");
mysql_select_db("your db");
//empty pn userdb and fill it with fresh userdata
$query=mysql_query("delete from nuke_users");
$query=mysql_query("INSERT INTO nuke_users (uid,uname,email,url,user_sig,pass,user_icq) select userid,username,email,homepage,signature,password,icq from user");
$query=mysql_query("update nuke_users set umode='nested', theme='ExtraLite',timezone_offset='14.0'");

mysql_close();
?>

fill the table called "nuke_group_membership" so pn will recognize you as admin and the rest as regular users (you are in group 2, the rest is group 1)

change all urls in pn which have to do with registration to point to vb's reg-Page/usercp

Include vb's global.php and install Admin_online - people on your newssite will be shown as online reading news...


I do not know how to make the cron file and where to upload it.
I hope someone in here can explain step by step:)

Thanx in advance for any information

Emjay

Gurudev
01-29-2002, 09:14 PM
I posted detailed instructions a while ago, have you searched. There have also been several other posts regarding this.

Emjay
01-30-2002, 09:57 PM
Originally posted by Gurudev
I posted detailed instructions a while ago, have you searched. There have also been several other posts regarding this.
I have searched on this topic got more then 20 pages, I think I readed em al.

Emjay
02-03-2002, 11:34 AM
anyone please?

bert
02-04-2002, 08:22 PM
Emjay,

Some hosts offer a crontab utility on their CP. If your host doesn't then you can do this right from the shell.

> crontab -e

The command above will open cron in your default editor. Read the following for information on how to create the proper entry:
http://www.nerc-online.com/support/www/crontab.html

Hope this helps :)