[FilterScript] MySQL E-Mail system!
#1

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

Reply
#2

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

Haha cool. I might use this
Reply
#4

Please report if you find any bugs!
Reply
#5

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
Reply
#6

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.
Reply
#7

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

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.
Reply
#9

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

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

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

Cool.
I like it. : )
Reply
#13

Good work Man!
Reply
#14

Fantastic Work
Reply
#15

Stable version 1.0 released!
Reply
#16

Woot! it's cool nice share
Reply
#17

nice nice
Reply
#18

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

i like it, looks great
Reply
#20

Great work and very useful.
Reply


Forum Jump:


Users browsing this thread: 4 Guest(s)