SA-MP Forums Archive
MySQL example script - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Filterscripts (https://sampforum.blast.hk/forumdisplay.php?fid=17)
+--- Thread: MySQL example script (/showthread.php?tid=133316)


MySQL example script - Calgon - 11.03.2010

I was messing around with MySQL for a bit, and I realized there was no basic login/registration scripts (correct me if I'm wrong), so I decided to release this script - I was going to work on it and make a whole new GM, however I changed my mind, so I'm going to release it here. It may not exactly be great code, but hey, it's still code.

http://files.uploadffs.com/d/6/0d566b94/MySQL.pwn
http://pastebin.com/8J46Xiy4 (pastebin PWN)

It has a locations system included, as an example of how to load things etc. It's not exactly finished, but it's a good base IMO.

MYSQL DUMP (ignore the useless tables or delete them):

http://pastebin.com/fnNGeFqQ

There's an incomplete tutorial provided as well.

THIS USES STRICKENKID'S MYSQL PLUGIN! http://forum.sa-mp.com/index.php?topic=148182.0

I highly advise against using this - use another script, this uses inefficient methods that I learned when I first picked up MySQL in PAWN.

Re: MySQL example script - Mr L - 11.03.2010

not bad good job

Re: MySQL example script - Calgon - 11.03.2010

Quote:
Originally Posted by Kinto
not bad good job
Thanks sir.

Re: MySQL example script - armyoftwo - 11.03.2010

I know that i will use it! But i don\'t know when and why..
Thanks!

Re: MySQL example script - Calgon - 11.03.2010

Quote:
Originally Posted by armyoftwo
\'
Why are you escaping a string? D:

Re: MySQL example script - Norn - 11.03.2010

Very nice work, might use this as a base.

Re: MySQL example script - armyoftwo - 11.03.2010

Quote:
Originally Posted by FreddoX [BINMAN
]
Quote:
Originally Posted by armyoftwo
\\\'
Why are you escaping a string? D:
I have some laptop prob\'s.. you know.

Re: MySQL example script - Calgon - 11.03.2010

Quote:
Originally Posted by Norn [BINMAN
]
Very nice work, might use this as a base.
Awesome + Thanks.

Quote:
Originally Posted by armyoftwo
Quote:
Originally Posted by FreddoX [BINMAN
]
Quote:
Originally Posted by armyoftwo
\\\'
Why are you escaping a string? D:
I have some laptop prob\'s.. you know.
I see, I intended it as a nerdy joke...

Re: MySQL example script - Kix - 11.03.2010

I don't have that much MySQL knowledge, so this should boost my MySQL knowledge. Good Stuff.

Re: MySQL example script - Deat_Itself - 12.03.2010

Nice work!