utstats import mutator not working

[McNamara]

the mutator for utstats auto import does not seem to be working.
i want to make a cronjob to auto import them but i am not sure how.
i have checked the rushpl forum topic but it seems very outdated so i won't try that, i have adminer running on my server, is there a way to make a cronjob work with adminer?
i guess i could enter some code below this? i want the job to run 2 times per hour for every day

[2399Skillz]

Automating the process is documented very well here.

It should have all the relevant information for getting cronjobs to work on your server.

If you have issues after reading that topic then I need to know a couple things.

Is the game and web site on the same server?
Do you have access to run cronjobs on the web server?
Can you manually run the import command on the web server and it import all the logs without any issues?

[McNamara]

Yes the game server and website are running on my vps.
Ubuntu 10.04 LTS LAMP amd64, i rent my own vps i should have access to do everything i want but unsure as i have not done this before.
I can update the stats on the utstats import page just fine, but the import mutator is not working, so this is why i want to use a cronjob.
the link you gave me well i find it hard to understand and i don't want to break things on my end.

[2399Skillz]

Then you should be able to login to the VPS via SSH, correct? If so, login to the web sites server account.

Navigate in the command prompt to the location of the utstats install directory, look for the import.php file. When you are there enter this command.

php import.php "yourpassword"

Change yourpassword with your password/key.

If it imports the logs then you are good to go. Navigate outside of the www directory to the users home directory. /home/webserveraccountname

Once you are there, create a new file using nano

nano utstatsimport

You'll be greeted with a new screen now. Copy this into a notepad on your Windows box.

#!/bin/bash
for file in `ls /your/path/ut-server/Logs/Unreal.ngLog*.log 2> /dev/null`; do
mv $file /your/utstats/main/path/logs > /dev/null
done
cd /your/utstats/main/path
php import.php "mypassword" > /dev/null

Things you need to change are

/your/path/ut-server/Logs/Unreal.ngLog*.log

This needs to be the absolute path to your ut servers logs.

/your/utstats/main/path/logs

This needs to be the absolute path to the logs directory on the utstats web server.

/your/utstats/main/path

This needs to be the directory with the import.php file from the utstats install.

"mypassword"

Needs to be your password/key.

Once that is done in the notepad, copy all of it then copy it to the terminal. Hit ctrl + x, then Y to save the document.

Type

chmod +x utstatsimport

Then create a new file called cron.sh by typing

nano cron.sh

paste this into it.

*/5 * * * * ./utstatsimport

Then type

crontab cron.sh

If you have any questions ask them. Actually, if you want just send me the login information via a PM and I'll login to your VPS and do it for ya.

[zavateandu]

UTSTATS_Trigger do the same job easier

[McNamara]

when i was talking about the utstats mutator its the same thing, it is the utstats trigger and its not working, skillz once i am home from work i'll give it a try and if i cant fix the problem i'll give you the info to do it. cheers!

[McNamara]

i fixed the problem, thanks for the help anyways! i would post how i fixed it but i have upgraded my irc and lost my chat logs.