[wups]

MySQL E-Mail system v1.0

I present you a MySQL E-Mail system i made.
Don't ask in this thread if you don't know how to use mysql! There are millions of guides for this. However, this filterscript creates the table by itself.

What is it meant for?
Players of your server can e-mail each other even if one of them is offline!
You can delete a message or reply to a message.

Installing

First, download the .pwn file below.
Second - place it in the filterscripts directory.
Then open it with PAWNO and change these defines:

pawn Код:

// You must configure these!
#define SQL_IP                        "YOUR IP HERE"
#define SQL_USER                      "YOUR USER HERE"
#define SQL_PASSWORD                  "YOUR PASS HERE"
#define SQL_DB                        "YOUR DB HERE"

And compile.
Finally, open server.cfg and add Email to the end of filterscripts. Example:

pawn Код:

filterscripts base anims Email

And of course start the server!
P.S. You must use a mysql plugin. Works fine with G-sTyLeZzZ

Credits

mktime - DracoBlue
sscanf - ******
RyDeR` - replaceChar function.
wups - Email system

Change Log

Код:

v1.0 
- Added line seperator.
- Fixed SQL Injection bugs.
- Removed @EMAIL_NAME.com (now you just have to input the players name).
- Some small fixes.
v0.9 
- Some minor bug fixes.
v0.8
- Initial release.

Screens

OTHER PICTURES: http://imageshack.us/g/705/samp171tt.png/

Last notes

The command for the system is /email
If you have any suggestions/complains - post them here. I'll try to help you.
Also, trading a cookie to a video!

Download

Pastebin v1.0
Pastebin v0.9

[Fool]

First, wow, nice Work good job. i sure will be using this for some reason, now back to reading this topic.

[Flyfishes]

Haha cool. I might use this

[wups]

Please report if you find any bugs!

[Cody09]

what can I do with this System? Write a email, and someone else ingame can read it? or can I ingame send a real email to me or s.th

[wups]

The reciever can read the message no mater if you are on or off. Also, messages don't disappear after server restart.
The system is only in game. Of course you can make a php version.

[Scenario]

Do the messages store inside of the MySQL database for some sort of logging?

[wups]

Quote:

Originally Posted by RealCop228 Do the messages store inside of the MySQL database for some sort of logging?

I didn't quite catch that.

If you are asking if the messages have any sorting functions - yes, you can sort by the `MK` row.

[666]

This is kind of nice, might use this for I dont know what :P

[DeathOnaStick]

Pretty good idea! Not too complicated, but an awesome idea anyway! Never thought about storing messages in a mysql database. Good work!

[wups]

Ok, so I updated it with a couple of bug fixes.

[Raimis_R]

Cool.
I like it. : )

[AlternativeDC]

Good work Man!

[BASITJALIL]

Fantastic Work

[wups]

Stable version 1.0 released!

[royal_king]

Woot! it's cool nice share

[xX60CentXx]

nice nice

[[MM]18240[FMB]]

Hello, could you possible make this save to file instead of MySql for small servers, and the MySql'ly challenged?

[Zempist]

i like it, looks great

[xDaidal0S]

Great work and very useful.