MySQL pingback code help needed

[Joshua T]

I am not very good with MySQL server side scripts. So any help would be awesome! My database info is as follows:

 <?php
define('DB_HOST', 'pingback.db.5645640.hostedresource.com');
define('DB_USER', 'pingback');
define('DB_PASSWORD', 'Wind**p1');
define('DB_DATABASE', 'pingback');
?>

This is how my sql is setup:
http://i52.tinypic.com/2lsv19t.jpg

And under ultrapoints is were the points are stored. I don't know if that will help you with the code or not.

Now below is that code I am suppose to use to have my site listen for payment wall to send a pinkback or callback to my site.

Where // Give credits to user I am suppose to make my own code with the database connect thing using the info above... Please help!!

 <?php
 
define('SECRET', '1b229e***d5f8c***ab5a0ac****');
define('CREDIT_TYPE_CHARGEBACK', 2);
 
$ipsWhitelist = array(
'174.36.92.186',
'174.36.96.66',
'174.36.92.187',
'174.36.92.192',
'174.37.14.28'
);
 
$userId = isset($_GET['uid']) ? $_GET['uid'] : null;
$credits = isset($_GET['currency']) ? $_GET['currency'] : null;
$type = isset($_GET['type']) ? $_GET['type'] : null;
$refId = isset($_GET['ref']) ? $_GET['ref'] : null;
$signature = isset($_GET['sig']) ? $_GET['sig'] : null;
 
$result = false;
 
if (!empty($userId) && !empty($credits) && isset($type) && !empty($refId) && !empty($signature)) {
 
$signatureParams = array(
'uid' => $userId,
'currency' => $credits,
'type' => $type,
'ref' => $refId
);
 
$signatureCalculated = generateSignature($signatureParams, SECRET);
 
// check if IP is in whitelist and if signature matches
if (in_array($_SERVER['REMOTE_ADDR'], $ipsWhitelist) && ($signature == $signatureCalculated)) {
 
$result = true;
 
if ($type == CREDIT_TYPE_CHARGEBACK) {
 
// Deduct credits from user
// This is optional, but we recommend this type of crediting to be implemented as well
// Note that currency amount sent for chargeback is negative, e.g. -5, so be caferul about the sign
// Don’t deduct negative number, otherwise user will get credits instead of losing them
 
}
else {
 
// Give credits to user
 
}
}
}
 
if ($result) {
echo 'It works';
}
 
function generateSignature($params, $secret) {
$str = '';
 
foreach ($params as $k=>$v) {
$str .= "$k=$v";
}
$str .= $secret;
 
return md5($str);
}
?>

[code green]

code help needed

Is not really a question and from the code posted I can't work out what you are trying to do.
So please define the problem and ask a specific question.