[FilterScript] MySQL E-Mail system! - SA-MP Forums

wups · 16/12/2010, 12:31 PM

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

// 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 Code:

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 - Y_Less
RyDeR` - replaceChar function.
wups - Email system
Change Log

Code:

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 · 16/12/2010, 12:42 PM

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

Flyfishes · 16/12/2010, 12:52 PM

Haha cool. I might use this

wups · 16/12/2010, 01:04 PM

Please report if you find any bugs!

Cody09 · 16/12/2010, 01:39 PM

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 · 16/12/2010, 01:46 PM

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.

RealCop228 · 16/12/2010, 01:48 PM

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

wups · 16/12/2010, 01:50 PM

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 · 16/12/2010, 02:09 PM

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

DeathOnaStick · 16/12/2010, 02:17 PM

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

16/12/2010, 12:31 PM	#1
wups High-roller Join Date: Apr 2010 Location: Lithuania Posts: 1,352 Reputation: 131	MySQL E-Mail system! 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 Code: // 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 Code: 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 - Y_Less RyDeR` - replaceChar function. wups - Email system Change Log Code: 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 __________________ My Releases: Code: [Includes] Simple,Fast Anti-Money Hack with FS support Server Sided Weapons OnPlayerShootPlayer v8 OnPlayerVehicleDamage GetPlayerDialogID [FilterScripts] Mechanical Gear System v2 Default Map Icons MySQL E-Mail system [GameModes] Escape from Area 51 Last edited by wups; 30/07/2011 at 01:08 PM.

16/12/2010, 12:42 PM	#2
Fool Gangsta Join Date: Jul 2010 Location: Morocco, Africa Posts: 607 Reputation: 107	Re: MySQL E-Mail system! First, wow, nice Work good job. i sure will be using this for some reason, now back to reading this topic. __________________ ok.

16/12/2010, 12:52 PM	#3
Flyfishes Huge Clucker Join Date: Jul 2010 Location: Stockholm, Sweden Posts: 368 Reputation: 4	Re: MySQL E-Mail system! Haha cool. I might use this __________________ www.soundcloud.com/magnusburton

16/12/2010, 01:39 PM	#5
Cody09 Little Clucker Join Date: Jul 2010 Posts: 41 Reputation: 0	AW: MySQL E-Mail system! 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 __________________ Sorry for my bad english, speak german^^

16/12/2010, 01:46 PM	#6
wups High-roller Join Date: Apr 2010 Location: Lithuania Posts: 1,352 Reputation: 131	Re: MySQL E-Mail system! 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. __________________ My Releases: Code: [Includes] Simple,Fast Anti-Money Hack with FS support Server Sided Weapons OnPlayerShootPlayer v8 OnPlayerVehicleDamage GetPlayerDialogID [FilterScripts] Mechanical Gear System v2 Default Map Icons MySQL E-Mail system [GameModes] Escape from Area 51

16/12/2010, 01:48 PM	#7
RealCop228 Godfather Join Date: Feb 2010 Location: Ohio, US Posts: 7,237 Reputation: 533	Re: MySQL E-Mail system! Do the messages store inside of the MySQL database for some sort of logging? __________________ I think everyone, including myself, should give this a read!

16/12/2010, 02:09 PM	#9
666 Big Clucker Join Date: Aug 2010 Posts: 72 Reputation: 25	Re: MySQL E-Mail system! This is kind of nice, might use this for I dont know what :P __________________ MUST SEE: Prison Exterior Simple and polite Restourant Int. Best xmas map for RP servers! (Location: Los Santos)

16/12/2010, 02:17 PM	#10
DeathOnaStick High-roller Join Date: May 2009 Location: 127.0.0.1 Posts: 1,078 Reputation: 23	Re: MySQL E-Mail system! Pretty good idea! Not too complicated, but an awesome idea anyway! Never thought about storing messages in a mysql database. Good work! __________________ If this helps you, please thank me by giving me reputation points

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
[Plugin] PWN Mail Exploder 0.3	Romanius	Релизы/Releases	30	30/03/2013 02:22 PM
[FilterScript] [FS][MAIL] Newsletter system 0.1	Striker_Moe	Filterscripts	10	07/08/2010 08:49 AM
e-mail plugin	denis1999	Help Archive	3	05/03/2010 05:26 AM
[HELP] mail	roleplay501	Help Archive	5	02/06/2009 02:34 PM