Get script mysql cubis weekly please :D
Printable View
Get script mysql cubis weekly please :D
learn english!
Sorry, Yes haha my english is bad :D
I will give you some hints:
1. Learn english
2. Learn php
3. Learn how crontab works
4. Make a shell script that use wget to retrieve the php page for your cubi script
5. Make a new line in crontab with the desired time to launch your shell script
That's all... You will need to find the rest by yourself!
I can say it betterQuote:
Originally Posted by Eistiger
lrnengrish
:rofl:
But yea, php, cron, not hard
Yours no know none?
Well to be nice, yeah Learn English, Learn PhP, Learn Cron, and then try it lol... Or beg me to do it for you lol your choice XD
what meaning of this? i can't understand it at all:?:Quote:
Originally Posted by matheusben
hrace you have one script of cubi ?, no matter cultivation.
Stop. Saying. To. Use. Wget. From. Cron.Quote:
Originally Posted by Romulan
php5-cli exists for a reason .-.
There is nothing wrong with using wget though :P
Although I spose one could argue it is the less efficient way of doing it...
zen.php
Crontab:PHP Code:<?php
$Host = "localhost" ; // localhost or your IP
$User = "root"; // Database user
$Password = "root"; // Database password
$Name = "dbo"; // Database name
$Amount = ; // how much zen you want to add *100
$Link = MySQL_Connect($Host, $User, $Password) or die ("<HTML><BODY><center><b>The server is momentarily down please try again after 5 minutes!</b></BODY></HTML>");
MySQL_Select_Db($Name, $Link) or die ("<HTML><BODY><center><b>The server is momentarily down please try again after 5 minutes!</b></BODY></HTML>");
$prepare_w = "SELECT ID FROM users ORDER BY ID ASC, ID ASC";
$execute_w = mysql_query($preparew);
$top_num =0;
while ($data = mysql_fetch_array($execute_w))
{
$top_num++;
$uweb = "call usecash ($data["ID"] , 1, 0, 1, 0, $Amount, 1, @error)";
$resu = mysql_query($uweb);
$QWE = mysql_fetch_array($resu);
}
echo "Updated $top_num Rows";
mysql_close($Link);
?>
nono /etc/crontab
add a line like this:
* * * * 6 root /usr/bin/wget http://localhost/zen.php -q > /dev/null
PHP Code:# Example of job definition:
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .---- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * command to be executed
#<----------------------------------------------Start--------------------------------------->
* * * * 6 root /usr/bin/wget http://localhost/zen.php -q > /dev/null
This scrip this not tested but i think it might work.
Yea but you still need to load the web page from somewhere (browser or something else) so thats why cron and wget are used for. Or maybe I'm wrong and the php page load itself without any interaction :blink:Quote:
Originally Posted by das7002
The webserver uses CGI (unless it's Apache which can handle it directly instead of over CGI) which runs the PHP script and instead of outputting to a console it gets sent by the HTTP server. Using php5-cli skips the HTTP server and instead runs it over the console, you can create fairly powerful scripts and programs using only PHP. PHP is not just a web development language even though that is what it was primarily created for.Quote:
Originally Posted by Romulan
PHP: Command line usage - Manual
You can even make GTK applications in PHP PHP-GTK
Not run
Do you used the script that Adriana gave to you? :mellow:
No no, i try more no caught.
could help ?
i'm Matheusben
You should try her script then... Because it works fine for me.
Config me ?
Day : Friday
Minute : 00:59
Hour : 12:00 (AM)
day of week : 7 ( MORE NO ALL DAY NEXT, YES ALL FRIDAY :D)
Cubis : 500
all i can say is: :)))))))))))))))))))))))))))))=)))))))))))))))))
Tutorial Please install that script please :S no understood crontab :s
* no understood english :s *Quote:
Originally Posted by matheusben
crontab = soft in linux -.-
see others topic after reply -.-
For the mods: Please, allow me to asnwer him in portuguese, cuz I'm getting nervous just reading the stupid english .-.
O Crontab serve pra automatizar o envio de cubis, se você usar o script da Adriana, vai funcionar. É só executá-lo em seu apache.
Para editar o crontab use crontab -e [enter].
Você deve direcionar o crontab para o script php. Caso esteja no jetty, direcione para /jetty/pasta/arquivo.phpPHP Code:# Exemplo da definição dos tempos:
# .---------------- minuto (0 - 59)
# | .------------- hora (0 - 23)
# | | .---------- dia do mês (1 - 31)
# | | | .------- mês (1 - 12) OR jan,fev,mar,abr ...
# | | | | .---- dia da semana (0 - 6) (Domingo = 0 ou 7) OU dom,seg,ter,qua,qui,sex(sex is not what you're thinking ¬¬),sab
# | | | | |
# * * * * * comando a ser executado
#<----------------------------------------------Abaixo está o comando--------------------------------------->
* * * * 6 root /usr/bin/wget http://localhost/zen.php -q > /dev/null
Entendeu agora?
That's fine, I see you're explaining crontab, and I think I can safely say anyone who's been here a while already knows about it anyway...
Matheusben said: "Tutorial Please install that script please :S no understood crontab :s"
...
I know
...
And you said: "anyone who's been here a while already knows about it anyway..."
'-'
renan7899 Mano desblock msn la.
Quote:
Originally Posted by Adriana
I checked your script... there are some things unnecessary, and there are some errors too. "mysql_query(preparew)"... It should be "mysql_query(prepare_w)" (With a underline).
I'll remake the script here:
PHP Code:<?php
error_reporting(0); //I don't like this crap reporting my server IP... the mysql errors is enough for the users.
$Host = "192.168.1.64"; // localhost or your IP
$User = "root"; // Database user
$Password = "renan"; // Database password
$Amount = "45000"; // how much zen you want to add *100
$Link = mysql_connect($Host, $User, $Password) or die ("<center><b>Database connection error.</b>");
$dbc = mysql_select_db("dbo", $Link) or die(mysql_error());
$prepare_w = mysql_query("SELECT * FROM users ORDER BY ID ASC") or die (mysql_error());
$top_num = 0;
$data = date("Y/m/d H:i:s");
$query_sn = "SELECT sn FROM usecashnow";
$sn = mysql_query($query_sn);
if(mysql_num_rows($sn) <= 0) { $sn = "-1"; }
while($array = mysql_fetch_array($prepare_w))
{
$id = $array["ID"];
$top_num++;
$uweb = mysql_query("INSERT INTO usecashnow (userid, zoneid, sn, aid, point, cash, status, creatime) VALUES ('$id', '1', '$sn', '1', '0', '$Amount', '1', '$data')") or die (mysql_error());
$sn--;
}
echo "Updated $top_num Rows";
mysql_close($Link);
?>
i made this now i dont use cubi ^^ but ty
There's an error...
http://i53.tinypic.com/15f40uv.jpg.
The php file was splitted in a lot of parts... why??