Codezwiz >> Forums >> General PHP Nuke Help >> Remove points from SQL when page is viewed.

Hi all,

I'm just after some help with phpnuke's SQL database. What I'm trying to do is remove 1000 points from the user that is logged in when they visit a php page. The problem being is I need someones help with the code to Update the table.

Thanks in advance

Nath

do want to do this for everyone or just one person?

For anyone who visits the page... They loose there points.

Hmm.. I am gonna need a link to that page to even begin to understand the problem.

Ok all I need is a sql command that updates the users points and takes 1000 off them. So if they view the page it will cost them 1000 points. Its too complicated if I show you.. as it works with a dedicated server and a VB program.

Its a simple command I just dont know how to talk to a SQL server.

Here is a few short tutorials that may help you understand how to communicate with you db. [ Register or login to view links on this board. ]

I see what your trying to accomplish. Lets call it a penalty.

I need to do some research in where user points are contained and I will try to come up with something.

Like so....

UPDATE nuke_users SET user='2' WHERE points='-1000'

Something like that...

Originally posted by ADF-Sniper @ Fri Dec 08, 2006 6:56 am:

Like so....

UPDATE nuke_users SET user='2' WHERE points='-1000'

Something like that...

Actually on the page, you wanted to be the penalty you would add.

Assuming this is a page on the site.

UPDATE ".$prefix."_users SET points = '$points-1000' WHERE username = '$username'

Thanks for your reply

Im at work atm so its a bit hard to play if you know what I mean.. but as soon as I get home... 8 Hours from now ill let you know how it goes.

I run a dedicated game server and for a map to change they will need to spend 1000 points. Thats what im working on at the moment

Regards
Nath

Spent a few hours on this and have no luck at all

<html>
<head>
<title>Map Request</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link rel="stylesheet" href="/styles.css" type="text/css">
<meta name="description" content="PHP Support Ticket System">
<meta name="abstract" content="Support Ticket System">
<meta name="keywords" content="Support Ticket System,PHP,Support Ticket,Custom PHP Scripts,Suppport,Tickett,Support system">
<meta http-equiv="Content-Language" content="EN">
<meta name="author" content="Cross Walk Central">
<meta name="distribution" content="Global">
<meta name="copyright" content="©Cross Walk Central">
<meta name="robots" content="FOLLOW,INDEX">
</head>
<?php
/************************************************************************/
/* */
/* Copyright (c) 2001-2002 by CrossWalkCentral */
/* http://www.crosswalkcentral.net */
/* */
/* CrossWalkCentral */
/* You Web Hosting Community! */
/* */
/* Let us customize this script for you. */
/* */
/* Please let us know what you think of the Support Ticket System */
/* at http://www.crosswalkcentral.net/modules.php?name=Forum */
/*                         */
/* This program is free software.             */
/*                         */
/* DOWNLOAD SUPPORT TICKET SYSTEM PRO FOR 20USD AT       */
/*       HTTP://WWW.CROSSWALKCENTRAL.NET       */
/*                         */
/************************************************************************/

if (!eregi("modules.php", $PHP_SELF)) {
die ("You can't access this file directly...");
}

include("header.php");
include("config.php");
      //CUSTOM ACCESS BY POINTS - MJ HUFFORD - [ Register or login to view links on this board. ]
global $userinfo;
customized_access_points($userinfo['points'], 1000); //WHERE 1000 = MIN POINTS TO ACCESS MODULE

// Some definitions
global $user, $db, $cookie, $prefix, $anonymous, $dbi, $user_prefix, $points ,$username, $stop, $module_name, $redirect, $mode, $t, $f, $admin, $userinfo, $nukeurl, $startdate;

$db->sql_query("UPDATE ".$prefix."_users SET points = '$points-1000' WHERE username = '$username'");

$content = "";
getusrinfo($user);
cookiedecode( $user );
$ip = getenv( "REMOTE_ADDR" );
$username = $cookie[1];
if ( !isset( $username ) )
{
$username = "$ip";
$guest = 1;
}

?>

<h3 align="center"><b><font face="Garamond">Map Request</font></b></h3>
<FORM ACTION = "modules.php??op=modload&name=mapreq&file=supportsys" METHOD = "POST">
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td width="30%">Email Address:</td>
<td width="74%">
<input type="text" name="custemail" maxlength="55" size ="46">
</td>
</tr>
<tr>
<td width="30%">First Name:</td>
<td width="74%">
<input type="text" name="custfname" size="46" maxlength="55">
</td>
</tr>
<tr>
<td width="30%">Last Name:</td>
<td width="74%">
<input type="text" name="custlname" size="46" maxlength="55">
</td>
</tr>
<tr>

<td width="30%">Map:</td>
<td width="74%">
<div align="left">
<select name="custcatergory" size="1">
<option>Bridge</option>
<option>Pipeline</option>
<option>Dusk</option>
<option>Insurgent Camp</option>
</select>
</div>
</td>
</tr>
<tr>
<td width="30%">Reason for map change?:</td>
<td width="74%">
<textarea name="custpdes" cols="50%" rows="6"></textarea>
</td>
</tr>
<tr>
<td width="30%"></td>
<td width="74%">
<input type="submit" name="Submit" value="Submit">
</td>
</tr>
</table>
<p> </p></form>
<?php
include ('footer.php');
?>
</body>
</html>