[Phaiz]

Originally Posted by snelvuur Ok, in light of above things.. since its really close near finishing i would like to ask if someone can finish up the project so that others can use it too. I wont code so how can i help? i'll offer 100 dollars if it gets finished. Perhaps more are willing to do that too and someone can step up to do the last bits. We all have busy lives, why not get a few beers in return.

Hell I'll throw in $30 on top of that if someone finishes it AND supports it afterwards.

[Phaiz]

I've been trying this out on my test server. I'll post results and bugs below.

I am able to:

Ban in game
Silence in game
See bans and silences in the web panel
Unsilence players in game from the web panel

I am NOT able to:

Remove silences in game (Failed to remove block from DB)
*Unban from web panel - shows as unbanned but it is not removed in game
See blocked players on the dashboard - banned players who try to reconnect are not shown

*Unbanning from the web panel SEEMS to reflect that in the database, however for some reason it isn't letting the server know that the player is unbanned. Could this be an issue on my end? Does this still use "sourcebans" in databases.cfg ? Also I deleted the ban from sb_bans and it still will not update.

[neploho]

[sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'where clause')
[sb_bans.smx] Failed to insert the ban into the database: Cannot add or update a child row: a foreign key constraint fails (`sourcebans`.`sb_bans`, CONSTRAINT `ban_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE SET NULL)
[sourcebans.smx] Failed to query database. (Cannot add or update a child row: a foreign key constraint fails (`sourcebans`.`sb_actions`, CONSTRAINT `action_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE))

Any help?

[Phaiz]

Originally Posted by neploho [sourcebans.smx] Failed to query database. (Unknown column 'ip' in 'where clause') [sb_bans.smx] Failed to insert the ban into the database: Cannot add or update a child row: a foreign key constraint fails (`sourcebans`.`sb_bans`, CONSTRAINT `ban_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE SET NULL) [sourcebans.smx] Failed to query database. (Cannot add or update a child row: a foreign key constraint fails (`sourcebans`.`sb_actions`, CONSTRAINT `action_server` FOREIGN KEY (`server_id`) REFERENCES `sb_servers` (`id`) ON DELETE CASCADE)) Any help?

https://github.com/GameConnect/SourceBans/issues/40

[Oo Alias oO]

Problem with this is that there's also no pull requests being accepted. I'm trying to work on doing a V3, getting there but slow progress I'm afraid.

[Phaiz]

Originally Posted by Oo Alias oO Problem with this is that there's also no pull requests being accepted. I'm trying to work on doing a V3, getting there but slow progress I'm afraid.

Well 2.0 is dead aside from what current users are willing to share

[Oo Alias oO]

Originally Posted by Phaiz Well 2.0 is dead aside from what current users are willing to share

Yeah.

To be honest there's a lot that could be improved. The whole plugin connecting with the database directly isn't ideal in my eyes. Having the plugin send requests via a simple API would be much better.

The one I'm working on:

- Bootstrap 3 template (done)
- Installer (done)
- Steam Login (done)
- User/Server permissions (done)
- Group Commands (done)
- Admins (done)
- Admin Groups (edit/add/delete) (done)
- Server Groups (edit/add/delete) (done)
- Comms
- Bans
- Servers (WIP)
- Appeals (Bans/Comms)
- API for plugin
- Plugin; adaptation of SB2 plugin

It's on GitHub, but just putting out updates as I go...

[Phaiz]

Originally Posted by Oo Alias oO Yeah. To be honest there's a lot that could be improved. The whole plugin connecting with the database directly isn't ideal in my eyes. Having the plugin send requests via a simple API would be much better. The one I'm working on: - Bootstrap 3 template (done) - Installer (done) - Steam Login (done) - User/Server permissions (done) - Group Commands (done) - Admins (done) - Admin Groups (edit/add/delete) (done) - Server Groups (edit/add/delete) (done) - Comms - Bans - Servers (WIP) - Appeals (Bans/Comms) - API for plugin - Plugin; adaptation of SB2 plugin It's on GitHub, but just putting out updates as I go...

Are you finishing 2.0 or..?

[Oo Alias oO]

Originally Posted by Phaiz Are you finishing 2.0 or..?

Nah, I honestly tried to update it with the existing code but without knowing Yii, and from what I saw the code was horrendous it was proving to be too difficult.

Started again on Laravel 5. Cut out all of the jQuery going on and I'm going at a quick pace since it's all just table relationships and forms really.

[Phaiz]

Originally Posted by Oo Alias oO Nah, I honestly tried to update it with the existing code but without knowing Yii, and from what I saw the code was horrendous it was proving to be too difficult. Started again on Laravel 5. Cut out all of the jQuery going on and I'm going at a quick pace since it's all just table relationships and forms really.

So you are redoing it? Sorry just trying to figure out if i should be excited or not