AlliedModders - SQL Feedback

AlliedModders (https://forums.alliedmods.net/index.php)

- Plugins (https://forums.alliedmods.net/forumdisplay.php?f=108)

- - SQL Feedback (https://forums.alliedmods.net/showthread.php?t=66760)

Re: SQL Feedback

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 :P).

[edit]

I also updated the php script in the second post.

Re: SQL Feedback

:up: Year, great work :up:

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

Code:

    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:wink:

Re: SQL Feedback

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

Re: SQL Feedback

Quote:

Originally Posted by bouncer (Post 1000000)

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

Quote:

Originally Posted by bouncer (Post 1000000)

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.

Quote:

Originally Posted by bouncer (Post 1000000)

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.

Re: SQL Feedback

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.

Re: SQL Feedback

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

Re: SQL Feedback

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

Re: SQL Feedback

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.

Re: SQL Feedback

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:

Code:

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`;