[nineteeneleven]

Originally Posted by nineteeneleven I'm doing the rewrite on this now. Fixing the resolution of Steam ids. Adding an option for 2 tiers of donors. Stripping Nfo support Fixing time stamps Adding proper admin login system Changing over to mysqli PayPal sandbox support Add support if sourcebans database and donor database are on different servers If you guys want anything else now is the time to ask

Originally Posted by StayOx and SteamID on format: steamcommunity.com/id/<username> or <number> is not recognized and the error invalid SteamID is shown.

maybe you skipped over that?

[StayOx]

the only thing I did not understand was:

PHP Code:

//GET THIS INFORMATION FROM YOUR sb_admins_servers_groups TABLE
//match the admin_id column with a donor from your aid column in your
//sb_admins table, use that information. This information handles
//which server donors will have privledges.
$group_id = "0";
$srv_group_id = "0";
$server_id = "0"; 


it is essential for Donor Control work?

[nineteeneleven]

Yes if you don't enter that information it will not add the donor to sourcebans

[StayOx]

Originally Posted by nineteeneleven Yes if you don't enter that information it will not add the donor to sourcebans

I'm very confused on this part of the setup, do not know what the $ group_id, srv_group_id, server_id I should add to config.php

my sb_admins_servers_groups TABLE




EDIT:

this informations

PHP Code:

$group_id = "0";
$srv_group_id = "0";
$server_id = "0"; 


are in which group?
group: "All Servers" (here table sb_groups) or "Donor" (here table sb_srvgroups)


note: I'm using Soucebans 1.4.10

[nineteeneleven]

You need to find the 'aid' of a donor in your sb_admins table and match it to the admin_id in the groups table.

[StayOx]

Originally Posted by nineteeneleven You need to find the 'aid' of a donor in your sb_admins table and match it to the admin_id in the groups table.

I do not own any donor yet, because I'm setting up to start using the "Donor Control"

to give privileges to users to my VIP I created a "Server Admin Group" named "Donor" and added flags "ao"

And my servers are divided into 4 "Servers Group"

All Servers
Counter-Strike
Left 4 Dead 2
Team Fortress 2

I imagine the Donor Control works as follows:

the user visits the webpage to make a donation then pay using paypal and the script automatically sends a query to the database of SourceBans adding SteamID and User Name to group "Donor"

this is correct?


I really can not understand the part below the setting

PHP Code:

//GET THIS INFORMATION FROM YOUR sb_admins_servers_groups TABLE
//match the admin_id column with a donor from your aid column in your
//sb_admins table, use that information. This information handles
//which server donors will have privledges.
$group_id = "0";
$srv_group_id = "0";
$server_id = "0"; 


which table I find the information for?

PHP Code:

$group_id = "0";         - table name and column where I find this information?
$srv_group_id = "0";   - table name and column where I find this information?
$server_id = "0";        - table name and column where I find this information? 


and may be of any admin? because we still do not own donors.

[Dr_Knuckles]

Make someone a donor temporarily and look them up in the list there and use their info.

[StayOx]

Originally Posted by Dr_Knuckles Make someone a donor temporarily and look them up in the list there and use their info.

ok thanks for tip, I add a donor via "Manual Entry" and the result is:




AND




and now where in I add this info here?

PHP Code:

$group_id = "0";
$srv_group_id = "0";
$server_id = "0"; 


[nineteeneleven]

put this script in the root directory of you donations folder, and run it. enter your test donors steam id in the box. it will return the values you need.

PHP Code:


<?php
define('NineteenEleven', TRUE);
require_once 'includes/config.php';

if (isset($_POST['steamid_user'])) {
  $steamid = $_POST['steamid_user'];
  $mysqli = new mysqli(DB_HOST,DB_USER,DB_PASS,$SB_DB_NAME);
 

  $result = $mysqli->query("SELECT aid FROM sb_admins WHERE `authid` ='".$steamid."';")or die($mysqli->error);

if($result){
  $row = $result->fetch_array(MYSQLI_ASSOC);
  $aid = $row['aid'];
}

unset($result);
 $result = $mysqli->query("SELECT * FROM sb_admins_servers_groups WHERE `admin_id` ='".$aid."';")or die($mysqli->error);

if ($result->num_rows >= 1) {
    $row = $result->fetch_array(MYSQLI_ASSOC);
      $group_id2 = $row['group_id'];
      $srv_group_id2 = $row['srv_group_id'];
      $server_id2 = $row['server_id'];
  }

  echo "group_id: {$group_id2} <br />";
  echo "srv_group_id: {$srv_group_id2} <br />";
  echo "server_id: {$server_id2} <br />";
}else{

  print("<!DOCTYPE html>");
  print("<html>");
  print("<body>");
  print("<center>");
  print("<input type=\"submit\" form=\"donate_form\" />");
  print("<form action=\"setup.php\" method=\"POST\" id=\"donate_form\">");
  print("<label for=\"paypaloption1\">Steam ID:<br /></label><input type=\"text\" id=\"paypaloption1\" name=\"steamid_user\" required=\"true\" id=\"id-box\" placeholder=\"SteamID of donor\" required=\"true\" size=\"30\"></p>");
  print("<div id='infobox'>");
  print("</div>");
  print("</form>");
  print("</center>");
  print("</body>");
  print("</html>");
}
?>

[StayOx]

lol the gods do not want me to use your Donor Control

Sorry we were unable to get your Steam ID.
Either you entered an invalid Steam ID, or the Steam community is down.
Please check and make sure you entered a valid Steam ID and try again.
Click here to go back

and tables

cache
donors
player_tracker

should be in a database named "donations" correct?

EDIT:

Ok steam online again:

I m use the script and the result is this after adding this a User via "Manual Entry"

group_id: 0
srv_group_id: 0
server_id: 0

I go check the page "Donor List" and sourcebans Group and the user was added correctly.


Now I m try check the information of my steamid and the result is:

group_id: 1
srv_group_id: 7
server_id: -1