PHP Help with this code please!

Ok, so i have code that (in a phpfusion page) update a users sql field called user_points with the points i specify them to have… and its this..

$result = dbquery('update '.$db_prefix.'users set user_points=user_points+25 where user_id='.$userdata['user_id'].' limit 1;');
?>```

What i'm wondering is... if theres a way to only allow each phpfusion user to hit this code once... for example, they complete a challenge... make it to this page, it tells them their points are updated and they are. is there a way to stop them from refreshing the page and having it update they're points multiple times, a kind of block by the username in phpfusion????

thank you to anyone that helps me.

make another sql field that is a boolean declaring whether or not they have completed it. first select it from the table, then if its == true, then dont insert the points, otherwise, insert the points, and update the boolean making it true.

could not of said it better. Let us know how it works out.

(and I hope you're not running an HBH-a-like)

but a boolean would be simple… if it werent for multiple challenges… there will be a bunch of challenges is the problem… so what do you suggest now??

and its not a hbh-a-like … its its own identity… because technically i would call this a hackthissite-a-like or vice versa, so whats to say one website cant be similar to another? thats what makes websites better is pure competition… i plan not to challenge this site anyway, moreso teach my friends general web hacking. i'm just doing this to have fun! :)

ok… nevermind, i'll do a boolean for each challenge… but i'm wondering, whats the php syntax to check if a booleans true, and then output code if it is?

Umm..isn't it just an if-then statement?

Ponguile wrote: Umm..isn't it just an if-then statement?

well… if the boolean is true {} else {} so yes… but idk how to declare if a boolean is true… like the php code to determine if a given table rows boolean is true for a given user in phpfusion…

www.w3schools.com