PSA 0.20

[Boss]

Pawn Supporting Application
PSA is an external application, extending Pawn's functionality. It communicates with Pawn through text files, allowing PSA to perform a variety of actions normally unavaliable in Pawn. You can think of PSA as a plugin, only external.

Currently it allows to make a fully-functional IRC echo and SQL data storage.


Download
Download the latest PSA at http://famp.ru/files/PSA.rar
The archive includes:
1) readme.txt - Help file.
2) psa.exe - PSA executable.
3) psa.cfg - PSA configuration.
4) echo.pwn - Blank script.
5) MySQL.dll - MySQL library.

Installation
1. Put the appropriate functions in your script. You can either take them from psa.pwn, base your script on psa.pwn or use psa.pwn as a filterscript.
Here are the key Pawn functions:
* PPSAtimer() // PSA timer for reading things from files.
* SetTimer("PSAtimer",100,1) // PSA timer activation.
* SendToIRC(str[]) // PSA function for sending things to IRC.
* PerformSQLquery(str[]) // PSA function for performing queries (which do not return values).
* PerformSQLquerySelect(qid[], str[]) // PSA function for performing "select" queries.
* OnQueryResult(qid[], str[]) // PSA event which gets called when "select" query returned a value. qid is the one you specified for PerformSQLquerySelect.
2. Put psa.exe, psa.cfg and MySql.Data.dll in your server's root dir (where your vcmp-svr.exe is).
3. Edit psa.cfg with your IRC/SQL settings.
4. Launch psa.exe.

Known issues
1. Requires .NET Framework 3.0 on the server machine to run.
2. As a consequence of the above, works with Windows server only.
3. IRC's quit message (if you close psa.exe) is "connection reset by peer".

Feedback
If you have questions/suggestions, post them here.

Version History
=== 0.20 === 24.04.10
Features:
1) Performing SQL queries.
2) Required framework version is now 3.0 (instead of 3.5).
Fixes:
1) Fixed high CPU usage.

=== 0.10 === 09.02.10
Features:
1) Sending messages to IRC.
2) Receiving messages from IRC.

[Aaron]

Nice work

[chn batista]

nice work

[TheRevenge]

Nice work

[-TriX-]

Nicee 

[Boss]

Moved to Pawn's showroom.

No suggestions yet?

[Only a Dude]

nice i like it

[donttoucht]

meh... .NET... Linux version would be appreciated.

[Boss]

Here's the executable compiled with Mono compiler: http://tdhclan.ru/files/PSAmono.exe

If I got it correctly, you should be able to run it once you install Mono runtime on your Linux machine. You can get Mono here: http://mono-project.com

I have no means of testing it apparently, so try it out and tell whether it works.

[donttoucht]

Here's the executable compiled with Mono compiler: http://tdhclan.ru/files/PSAmono.exe

If I got it correctly, you should be able to run it once you install Mono runtime on your Linux machine. You can get Mono here: http://mono-project.com

I have no means of testing it apparently, so try it out and tell whether it works.

Sorry for the delay, but i should've looked into the actual code before requesting linux version. Honestly, i had some good laugh looking at it, yea, i understand that this might be the most obvious way to have IRC echo, but jesus, 100 miliseconds timer with 1024+256(!!) cells strings along with string operations & fileoperations which is the SLOWEST thing possible. And you base thing needed to be fast on this? What if i'd count huge ass scripts developed without understanding basics along with this echo running at the same time, result will be clearly no good.

Don't look at me, like i'm some fag, only complaining about everything, but this is what happens when people don't know low level programming. Even what you call "mid-level" is all mighty for you. While a simple string.split is 1 method in your .NET, it's quite big operation with many tricks and ways to perform it for example in C++ at the same time. I don't even talk about ASM, which gives you HUGE amount of power which you could never dream about in some C#. It's like everyone knows that passing pointer to function is faster than passing normal variable, no copy made this way. Lower level makes you understand what you are doing, after that you couldn't write such unreliable code.

[Boss]

I'm not the "theoretical programming" guy (even though I planned to become one at some point), hunting every ms of perfomance. I do things and I make sure they work. PSA's echo works and it doesn't produce any visible lag even when processing multiple strings. Mission complete.

You are free to code your echo in one of those "allmighty" low-level languages too.

[Boss]

PSA 0.20 released.

New features:
1) Performing SQL queries.
2) Required framework version is now 3.0 (instead of 3.5).

Fixes:
1) Fixed high CPU usage.

[thijn]

Nice work, Although still hate that it has to be this way

[Only a Dude]

wth, it doesn't do /ns identify in irc lol..

[tato]

Pawn Supporting Application
PSA is an external application, extending Pawn's functionality. It communicates with Pawn through text files, allowing PSA to perform a variety of actions normally unavaliable in Pawn. You can think of PSA as a plugin, only external.

Currently it allows to make a fully-functional IRC echo and SQL data storage.


Download
Download the latest PSA at http://famp.ru/files/PSA.rar
The archive includes:
1) readme.txt - Help file.
2) psa.exe - PSA executable.
3) psa.cfg - PSA configuration.
4) echo.pwn - Blank script.
5) MySQL.dll - MySQL library.

Installation
1. Put the appropriate functions in your script. You can either take them from psa.pwn, base your script on psa.pwn or use psa.pwn as a filterscript.
Here are the key Pawn functions:
* PPSAtimer() // PSA timer for reading things from files.
* SetTimer("PSAtimer",100,1) // PSA timer activation.
* SendToIRC(str[]) // PSA function for sending things to IRC.
* PerformSQLquery(str[]) // PSA function for performing queries (which do not return values).
* PerformSQLquerySelect(qid[], str[]) // PSA function for performing "select" queries.
* OnQueryResult(qid[], str[]) // PSA event which gets called when "select" query returned a value. qid is the one you specified for PerformSQLquerySelect.
2. Put psa.exe, psa.cfg and MySql.Data.dll in your server's root dir (where your vcmp-svr.exe is).
3. Edit psa.cfg with your IRC/SQL settings.
4. Launch psa.exe.

Known issues
1. Requires .NET Framework 3.0 on the server machine to run.
2. As a consequence of the above, works with Windows server only.
3. IRC's quit message (if you close psa.exe) is "connection reset by peer".

Feedback
If you have questions/suggestions, post them here.

Version History
=== 0.20 === 24.04.10
Features:
1) Performing SQL queries.
2) Required framework version is now 3.0 (instead of 3.5).
Fixes:
1) Fixed high CPU usage.

=== 0.10 === 09.02.10
Features:
1) Sending messages to IRC.
2) Receiving messages from IRC.

i have a question how to be admin in the mirc like when i put !say in the server will say admin tato say .....