[bl4nk]

Updated to Version 1.1.0

Check the first post for the changelog. A working SQLite version is still to come (sorry for taking so long, I lost interest in this plugin a while back ).

[edit]

I also updated the php script in the second post.

[HSFighter]

Year, great work

Any chance to add ServerIP and Game-Folder-Name (e.g. cstrike, dods e.t.c) loging?

    new String:GameType[32];
    GetGameFolderName(GameType, sizeof(GameType));

    new String:ServerIP[32];
    cvar_ServerIP = FindConVar("ip");
    GetConVarString(cvar_ServerIP, ServerIP, sizeof(ServerIP));

This will be useful.
I add this plugin to the next Sourcemod Webadmin relase in dezember

[bouncer]

eh bl4nk so is "default" the right name for the database? if so, any idea why it wont work for me? all my ports are open, and i have sourcebans working so it proves that it should work for this as well.

and if possible could you rename the table from default to something else? thanks.

EDIT: for php i get error

Parse error: syntax error, unexpected T_VARIABLE in /home/brother6/public_html/feedback.php on line 3

www.brotherhoodofgamers.com/feedback.php

[bl4nk]

Originally Posted by bouncer eh bl4nk so is "default" the right name for the database? if so, any idea why it wont work for me? all my ports are open, and i have sourcebans working so it proves that it should work for this as well.

The plugin uses the settings under the "default" configuration section in your databases.cfg file.

Originally Posted by bouncer and if possible could you rename the table from default to something else? thanks.

The table is named 'feedback', not 'default' - that's the entry in the databases.cfg, as mentioned above.

Originally Posted by bouncer or php i get error Parse error: syntax error, unexpected T_VARIABLE in /home/brother6/public_html/feedback.php on line 3 www.brotherhoodofgamers.com/feedback.php

I updated the php file to fix that and a few other things. Download it again and make sure to configure the first few lines to point to the proper MySQL database.

[bouncer]

still same issue.

[bouncer]

what happened to the original php that used to work? that one showed fine, except u put duplicate code in the php file, original one i noticed.

[bl4nk]

Odd, it seems the last change I made didn't stick. I updated it again, and used the exact code here (using dummy information I input to test out utf8 handling and such):

http://www.joe.to/sqlfeedback.php

[bouncer]

ok works now, and what about clearing out old feedbacks feature?
something should be implemented so that the database doesnt get too big.

[bl4nk]

What do you mean? MySQL is optimized for space; you could have hundreds of thousands of entries and it wouldn't take up much space.

[bl4nk]

Updated to Version 1.2.0

Changelog:

• Added logging of the server ip and port, and the game's name.

Updating from V1.1.0 or earlier:
If you don't have a previous installation, ignore this section.

Run the following code on your MySQL database with the "feedback" table on it:

ALTER TABLE `feedback`
ADD `serverip` varchar(16) NOT NULL AFTER `map`,
ADD `serverport` varchar(6) NOT NULL AFTER `serverip`,
ADD `game` varchar(32) NOT NULL AFTER `serverip`;