Banking System for Activity Points

OscarX · Dec 30th 2008

Hello everyone, im currently working on a Banking System for the Activity Points system. I have the event listener and the actual form already.

The only problem im having trouble with is that whenever I try to submit the form, no points are put into the field "banked" in the wcf1_user table.
Anyone have any idea on how I can make a working event listener and submission for such a script.

Im thinking something like this:

PHP

$oldactivityPoints = $activityPoints-$banked;
$newactivityPoints = $activityPoints+$banked;




	/**
	 * Deposit the Rupees
	 */
	public function update($username, $banked = TIME_NOW) {
		$sql = "UPDATE	wcf".WCF_N."_user SET	banked = '".escapeString($banked)."',
 WHERE userID = ".$this->userID;
		WCF::getDB()->sendQuery($sql);
	}

Display More

This is from an old script I had, how can I convert this into the new coding that WBB3 uses?

PHP

$db_connect->query("UPDATE db_users SET usermoney='$newmoney' WHERE userid = '$user_id'");
		$db_connect->query("UPDATE db_users SET userbankmoney='$newbank' WHERE userid = '$user_id'");
		$db_connect->query("UPDATE db_users SET bankinserttime='$time' WHERE userid = '$user_id'");

Thank you for your time!

Ponjimon · Dec 31st 2008

Hello OscarX,

did SQL report an error? It might be helpful

greets doenervich

OscarX · Jan 6th 2009

No errors were ever reported. When i send the form the page just reloads and nothing gets saved.

Troublegum · Jan 6th 2009

I think it is unlikely someone can help you unless you provide more detailed information (e.g. the code).

OscarX · Jan 7th 2009

Thats the whole problem, I don't know where to start with the coding part of it. I just drew up a few ideas as you can see in the first post.
Anyone know a code I can use to save a form with a substraction and addition factor in there?

Something like:

PHP

$bankedpoints = $activityPoints-$query;
$withdrawedpoints = $activityPoints+$query;

thank you!

Troublegum · Jan 7th 2009

You should have a look at the file wcf/lib/form/AbstracForm.class.php. This class provides a default implementation for the Form interface.
You can define your own form (you should also take a look at some of our (less complex) forms like EmailChangeForm for example.

PHP

<?php
require_once(WCF_DIR.'lib/form/AbstractForm.class.php');







class MyOwnForm extends AbstractForm {
	public $newmoney = 0;
	public $templateName = 'myownform';





	/**
	 * @see Form::readFormParameters()
	 */
	public function readFormParameters() {
		parent::readFormParameters();

		// use intval for Integer values (or perhaps you would like to use floatval for float values ?)
		if (isset($_POST['newmoney'])) $this->newmoney = intval($_POST['password']);
	}




	/**
	 * @see Form::validate()
	 */
	public function validate() {
		parent::validate();


		// Validate YOUR form input like this:
		if (empty($this->newmoney)) {
			throw new UserInputException('newmoney');
		}

		// or perhaps you would like to accept only positive values for the newmoney variable?
		// like this:
		if ($this->newmoney <= 0) {
			throw new UserInputException('newmoney');
		}

		//
		// ....


	}





	/**
	 * @see Form::save()
	 */
	public function save() {
		parent::save();

		// store data in database
		$sql = "UPDATE	wcf".WCF_N."_user SET usermoney = '".$this->newmoney."'
			WHERE	userID = ".WCF::getUser()->userID;
		WCF::getDB()->sendQuery($sql);
	}



	/**
	 * @see Page::show()
	 */
	public function show() {
		// make sure only registered users can see the form
		if (!WCF::getUser()->userID) {
			require_once(WCF_DIR.'lib/system/exception/PermissionDeniedException.class.php');
			throw new PermissionDeniedException();
		}

		parent::show();
	}

	/**
	 * @see Page::assignVariables()
	 */
	public function assignVariables() {
		parent::assignVariables();

		WCF::getTPL()->assign(array(
			'newmoney' => $this->newmoney,
		));
	}	
}
?>

Display More

You can increment/decrement values in your database like this:

SQL

UPDATE table SET field = field + 35;
UPDATE table SET field = field - 20;

Share