[nineteeneleven]

Originally Posted by jpwanabe Getting this error when trying to add a test donor manually. SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'username' cannot be null

You can only add vaild steamids

in the event you are adding a valid steamid, make sure ur API key is set

[jpwanabe]

My api key is set and I am using a steam2 id to test with. Should I be doing steam3?

Edit:
So I tried to donate just with paypal. it says "Unable verify player with Steam"

The api key is right. Is there any other files I need to edit other then \includes\config.php?

Edit2: Also the install guide is a bit confusing for a fresh install. It tells me to import install.sql twice. Do I import it into sourcebans too?

[jpwanabe]

Making a new post because I found the problem. I had every thing working right. I just can't use the person I wanted to use to test with for some reason. It can't verify their account. Anyone else I try works. Strange.

This is the guy btw.

http://steamrep.com/profiles/76561198071291064

Also how do I make it so the donate page doesn't always have a 5 already in it? And also shows the cost per month of the tier?

[John_Stamos]

So will this change a players perms without an admin having to do it?
I'm trying to make my server as automatic as possible.

[jpwanabe]

Originally Posted by John_Stamos So will this change a players perms without an admin having to do it? I'm trying to make my server as automatic as possible.

Yes it will, if you set it up right. I have another question. What file should I edit to make it so the sourcebans admin that is inserted has the words vip- infront of it? I've tried messing with line 377 in the ipn.php but that didn't work.

[nineteeneleven]

Originally Posted by jpwanabe My api key is set and I am using a steam2 id to test with. Should I be doing steam3? Edit: So I tried to donate just with paypal. it says "Unable verify player with Steam" The api key is right. Is there any other files I need to edit other then \includes\config.php? Edit2: Also the install guide is a bit confusing for a fresh install. It tells me to import install.sql twice. Do I import it into sourcebans too?

No you need to make a new database, and import it only once to the new database. I updated the manual.

Originally Posted by jpwanabe Making a new post because I found the problem. I had every thing working right. I just can't use the person I wanted to use to test with for some reason. It can't verify their account. Anyone else I try works. Strange. This is the guy btw. http://steamrep.com/profiles/76561198071291064 Also how do I make it so the donate page doesn't always have a 5 already in it? And also shows the cost per month of the tier?

https://forums.alliedmods.net/showpo...&postcount=408

Originally Posted by John_Stamos So will this change a players perms without an admin having to do it? I'm trying to make my server as automatic as possible.

The system is 100% automated. once they donate perks are added, when their time is up they are automatically removed.

Originally Posted by jpwanabe Yes it will, if you set it up right. I have another question. What file should I edit to make it so the sourcebans admin that is inserted has the words vip- infront of it? I've tried messing with line 377 in the ipn.php but that didn't work.

If you talking about the custom chat colors option, Donations Control will assign the players tag in game to the name of the group they are in inside soucebans.

[jpwanabe]

thanks for answering all my questions. The last question I meant the admin name in sourcebans. I would like all the VIPs in one section. And luckily be since it starts with a V it would be at the end. Its just a way to easier find my actual mods and admins on the admin page.

[nineteeneleven]

Originally Posted by jpwanabe thanks for answering all my questions. The last question I meant the admin name in sourcebans. I would like all the VIPs in one section. And luckily be since it starts with a V it would be at the end. Its just a way to easier find my actual mods and admins on the admin page.

includes/SourceBansClass.php line 118
make it this

PHP Code:

$vals = array(':username' =>'VIP-' . $username, ':steam_id' => $steam_id, ':sb_pw' => '1fcc1a43dfb4a474abb925f54e65f426e932b59e', ':group' => $group['name']); 


[jpwanabe]

Thanks!

[jpwanabe]

Last question. I swear. I use chat color manager for my vips. But this uses it's own database for CC. How can I edit the remove_expired.php so that when it runs, it will check the database cccm for the correct steamid to remove?

This is what I use for my key donation removing.

<?php
include('db.class.php');
include('db2.class.php');
$db = new Database(*****','****','sourcebans');
$db2 = new databaseRemote('****','****','cccm');

$db->query("SELECT * FROM donations WHERE expire < NOW()");
$data = $db->resultset();
foreach ($data as $key => $value) {
    $db->query('DELETE FROM donations WHERE steam_id = ?')
		->bind(1,$value['steam_id'])
		->execute();
	$db->query('DELETE FROM sb_admins WHERE authid = ?')
		->bind(1,$value['steam_id'])
		->execute();
	
	$db2->query('DELETE FROM cccm_users WHERE auth = ?')
		->bind(1,$value['steam_id'])
		->execute();

	echo "removed - " . $value['steam_id'] . "\n";

}
echo "DONE!";