Store add-on - remove warning points - help needed!

[X-Fan]

G'day all,

I tried modifying a few existing hacks to create an add-on for Lesane's store wherein a user could pay to have a warning point removed (from g-force2k2's Warning Hack), but I've hit a snag wherein the check to see if a user has any points and giving them an error screen if they don't isn't working.

Here's the code:


$warns = $DB_site->query_first("SELECT warninglvl FROM user WHERE userid='$bbuserinfo[userid]'");
if ($warns <= 0) {
eval("standarderror(\"".gettemplate('store_removewarn_error')."\");");
}


Any idea why that's not working?

Also, here's the code I've got for removing the point. Not sure if it works or not as I haven't got that far, but comments would be appreciated, thanks!


if ($cost>$points) {
eval("standarderror(\"".gettemplate('store_error')."\");");
} else {
$DB_site->query("UPDATE user SET warninglvl=warninglvl-1,storep=storep-$cost WHERE userid='$bbuserinfo[userid]'");
$changestorenow = $DB_site->query("UPDATE store SET sold=sold+1 WHERE action='removewarn'");
$moneycheck = $DB_site->query_first("SELECT storep FROM user WHERE userid=$bbuserinfo[userid]");
$money = $moneycheck[storep];
eval("dooutput(\"".gettemplate("store_removewarn_done")."\");");
}
}

[N9ne]

$warns = $DB_site->query_first("SELECT warninglvl FROM user WHERE userid=$bbuserinfo[userid]");

$warns1 = $DB_site->fetch_array($warns);

if ($warns1['warninglvl'] < 1 or empty($warns1['warninglvl'])) {

eval("standarderror(\"".gettemplate('store_removewarn_error')."\");");

}

[X-Fan]

Thanks N9ne, it came up with the warn_error template, but I got this error at the top of the page:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in db_mysql.php on line 149

[N9ne]

What's line 149?

[X-Fan]

$this->record = mysql_fetch_array($this->query_id);

[Dean C]

N9ne why are fetching the array again. Query first does all the hard work for you ;)

Try this:


$warns = $DB_site->query_first("SELECT warninglvl FROM user WHERE userid=$bbuserinfo[userid]");

if ($warns['warninglvl'] < 1 or empty($warns1['warninglvl'])) {

eval("standarderror(\"".gettemplate('store_removewarn_error')."\");");

}

[X-Fan]

Cool, that did it, thanks guys! :)

I'll write this up and post it in the Beta hacks forum, with thanks to you both, of course!

[Dean C]

Your Welcome :)