Raised This Month: $ Target: $400
 0% 

[REQ] Simple player registration plugin with SQL


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
rumbeto
Member
Join Date: Feb 2007
Old 07-26-2009 , 17:06   [REQ] Simple player registration plugin with SQL
Reply With Quote #1

Hello everyone, I wondered if someone could make e register plugin. What I want is this - a player writes in console amx_register <password> and it registers the nickname he is currently playing with in admin database. The admin database is the one that is used when using admin_sql.amxx. So the plugin reads the necessary info from sql.cfg and writes the following data in the admin table:

name: Current name.
password: form amx_register command
access: z
flags: ab

I have already made a simple php form, so players can register from my website, but I want them to be able to do it in game, it is so much more comfortable.

Thanks in advance to everybody who tries to help.

Last edited by rumbeto; 07-28-2009 at 17:46.
rumbeto is offline
rumbeto
Member
Join Date: Feb 2007
Old 07-28-2009 , 09:27   Re: [REQ] Simple register plugin with SQL
Reply With Quote #2

Anyone?
rumbeto is offline
devil001
Member
Join Date: Feb 2008
Old 07-28-2009 , 14:28   Re: [REQ] Simple register plugin with SQL
Reply With Quote #3

database structure? should be easy todo, but I need more details
__________________
Host Mist - Helping People Say Hello World
Shared | VPS | Dedicated Hosting
Backup-Spot
Secure,Fast and Reliable Offsite Backups
devil001 is offline
rumbeto
Member
Join Date: Feb 2007
Old 07-28-2009 , 16:20   Re: [REQ] Simple register plugin with SQL
Reply With Quote #4

The database structure is the following:
[IMG]http://img23.**************/img23/5477/amxadminsql.jpg[/IMG]
This is viewed from phpmyadmin. The collation is not important.
It is the one that is created by admin_sql.amxx when you use sql to save your admins. I want the database credentials to be read from ../configs/sql.cfg.

When a player wants to register the nick he is currently playing with, he opens his console and writes amx_register <password> as the password length should not be less than 6. And then writes it in the admin table.

It would be nice if the plugin could escape mysql special characters.

If you need more information, I'll provide it.

Thanks for helping.
rumbeto is offline
DaxProxy
Senior Member
Join Date: Sep 2007
Old 07-28-2009 , 18:19   Re: [REQ] Simple player registration plugin with SQL
Reply With Quote #5

Yes, i would like that too

I would realease super-plugin after someone would make me sql register template...

SQLx would be so (cute).
DaxProxy is offline
devil001
Member
Join Date: Feb 2008
Old 07-29-2009 , 03:47   Re: [REQ] Simple player registration plugin with SQL
Reply With Quote #6

The only problem I see with transfering their password is that we cant encrypt it to be secure. You would have to store plain passwords which is abit insecure.
__________________
Host Mist - Helping People Say Hello World
Shared | VPS | Dedicated Hosting
Backup-Spot
Secure,Fast and Reliable Offsite Backups
devil001 is offline
rumbeto
Member
Join Date: Feb 2007
Old 07-29-2009 , 10:20   Re: [REQ] Simple player registration plugin with SQL
Reply With Quote #7

If we encrypt passwords, there should be developed a plugin that repeats the whole process of handling admins and player flags, loading player privileges as well as adminslots and so on. So it won't be simple as the topic title says.
rumbeto is offline
devil001
Member
Join Date: Feb 2008
Old 07-29-2009 , 16:25   Re: [REQ] Simple player registration plugin with SQL
Reply With Quote #8

well I can provide you a simple script that does the basic functions. Anything advanced like encryption etc. you will have to add that yourself.
__________________
Host Mist - Helping People Say Hello World
Shared | VPS | Dedicated Hosting
Backup-Spot
Secure,Fast and Reliable Offsite Backups
devil001 is offline
rumbeto
Member
Join Date: Feb 2007
Old 07-29-2009 , 17:43   Re: [REQ] Simple player registration plugin with SQL
Reply With Quote #9

That would be so kind of you. But if anyone wants to go and to make it more advnaced, he is welcome. I' d like that too. I supposed if I wanted something more complex, nobody would do it. So if you think you can do it, do it.
rumbeto is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:38.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode