[nineteeneleven]

Originally Posted by 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!";

Im not sure what cccm is or how it works.l and usually dont provide support for 3rd party scripts.

[jpwanabe]

Cccm is chat color manager. It let's you set your chat color in the fly from in the server. Is an addition to the chat color plugin that you link in the first post. I would link or but I'm on my phone

[captaindeterprimary]

Possibly add a plugin to remind them when they are nearing the end if their paid time.

[jpwanabe]

Originally Posted by vman315 Possibly add a plugin to remind them when they are nearing the end if their paid time.

Yea. I don't have a mail server set up on my box.

[nineteeneleven]

Originally Posted by jpwanabe Yea. I don't have a mail server set up on my box.

If its linux type 'which sendmail' in terminal if thats there u can use the mail functions u probably have to configre exim4 to allow mail to external servers. 'dpkg-reconfigure exim4'

[jpwanabe]

Originally Posted by nineteeneleven If its linux type 'which sendmail' in terminal if thats there u can use the mail functions u probably have to configre exim4 to allow mail to external servers. 'dpkg-reconfigure exim4'

Windows server 2008. I have 0 experience with linix.

[Advokat]

Just to note, this conflicts with Cloudflare, at least on current versions of Chrome and Firefox. You're able to workaround most issues with either page rules or excluding specific scripts with the data-cfasync="false" tag but it may catch a few of you off-guard.

Edit: Just noticed that a forward slash was able to get through and break the admin cfg on our servers. The name of the person was along the lines of "..113r/ L..." (replacing the ellipses with the rest of their name). Just a heads up.

[Phaiz]

I've been having issues trying to execute the remove_expired.php

phaiz***bans/scripts$ php remove_expired.php
PHP Warning:  require_once(../includes/config.php): failed to open stream: No such file or directory in /***/bans/scripts/remove_expired.php on line 5
PHP Fatal error:  require_once(): Failed opening required '../includes/config.php' (include_path='.:/usr/share/php:/usr/share/pear') in /***/bans/scripts/remove_expired.php on line 5

[nineteeneleven]

Originally Posted by Phaiz I've been having issues trying to execute the remove_expired.php phaiz***bans/scripts$ php remove_expired.php PHP Warning: require_once(../includes/config.php): failed to open stream: No such file or directory in /***/bans/scripts/remove_expired.php on line 5 PHP Fatal error: require_once(): Failed opening required '../includes/config.php' (include_path='.:/usr/share/php:/usr/share/pear') in /***/bans/scripts/remove_expired.php on line 5

Doew it happen if u visit the script in your browser?

[Phaiz]

Originally Posted by nineteeneleven Doew it happen if u visit the script in your browser?

If i try to go to the script in my browser I just see a blank page.