Help with crons!!

[michaelbraden]

I am seriously needing some help. I am trying to get my Mobster of The hour Script working. I have located the script at /moth.php and I need the script to run. Here is everything on moth.php

 

<?
$result = mysql_query("SELECT id, hourlyattacks FROM grpgusers WHERE hourlyattacks > 0 DESC LIMIT 1");
$rows = mysql_num_rows($result);
if($rows == 1) {
$fetch = mysql_fetch_array($result);
send_event($fetch['id'], "You won mobster of the hour with ".$fetch['hourlyattacks']."");
$result = mysql_query("UPDATE grpgusers SET points = points + 10 WHERE id = '".$fetch['id']."'");
$reset = mysql_query("UPDATE grpgusers SET hourlyattacks = '0'");
}

?>

 

Anyhow I am using a cpanel for crons but I got no idea howthis works as I am completly new! Please help me out guys! I want the script to see how many 'hourlyattacks' there are, take the highest, reward points, and reset hourlyattacks and start over.... someone help please?

[Newbie]

UPDATED but not tested

 

<?php
include('dbcon.php');
$result = mysql_query("SELECT id, hourlyattacks FROM grpgusers WHERE hourlyattacks > 0 DESC LIMIT 1");
$fetch = mysql_fetch_array($result);
$usr = new User($fetch['id']);
$newpoints = $usr->points + 10;
Send_Event($usr->id, "You won mobster of the hour with ".$fetch['hourlyattacks']."");
$result = mysql_query("UPDATE grpgusers SET points = ".$newpoints." WHERE id = '".$usr->id."'");
$reset = mysql_query("UPDATE grpgusers SET hourlyattacks = '0'");
}

?>

Edited February 3, 2014 by Newbie

[Guest]

There is no connection to the database, everything is empty, try including the connection file at the top then run the queries.

[michaelbraden]

I get this error when trying to run this

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/silentm2/public_html/moth.php on line 9

 

<?php
include 'dbcon.php';

include 'classes.php';

include 'updates.php';

$result = mysql_query("SELECT id, hourlyattacks FROM grpgusers WHERE hourlyattacks > 0 DESC LIMIT 1");
$rows = mysql_num_rows($result);
if($rows == 1) {
$fetch = mysql_fetch_array($result);
$usr = new User($fetch['id']);
send_event($usr->id, "You won mobster of the hour with ".$fetch['hourlyattacks']."");
$result = mysql_query("UPDATE grpgusers SET points = points + 10 WHERE id = '".$usr->id."'");
$reset = mysql_query("UPDATE grpgusers SET hourlyattacks = '0'");
}

?>

 

<?php

include 'dbcon.php';

include 'classes.php';

include 'updates.php';

$result = mysql_query("SELECT id, hourlyattacks FROM grpgusers WHERE hourlyattacks > 0 DESC LIMIT 1");

$rows = mysql_num_rows($result);

if($rows == 1) {

$fetch = mysql_fetch_array($result);

$usr = new User($fetch['id']);

send_event($usr->id, "You won mobster of the hour with ".$fetch['hourlyattacks']."");

$result = mysql_query("UPDATE grpgusers SET points = points + 10 WHERE id = '".$usr->id."'");

$reset = mysql_query("UPDATE grpgusers SET hourlyattacks = '0'");

}

?>

[Newbie]

try

 

<?php
include('dbcon.php');
$result = mysql_query("SELECT * FROM grpgusers ORDER BY hourlyattacks  DESC LIMIT 1");
$fetch = mysql_fetch_array($result);
$usr = new User($fetch['id']);
$newpoints = $usr->points + 10;
Send_Event($usr->id, "You won mobster of the hour with ".$fetch['hourlyattacks']."");
$result = mysql_query("UPDATE grpgusers SET points = ".$newpoints." WHERE id = '".$usr->id."'");
$reset = mysql_query("UPDATE grpgusers SET hourlyattacks = '0'");
}

?>

[michaelbraden]

Wow you rock! Fixed thanks soo much buddy! Seriously!!!

- - - Updated - - -

If you know where I can come across help with gradient names? Or just extra dailies for GRPG That would be great!!

[Newbie]

np glad to help there is a bunch of free mods in the grpg freebies section.