Hi!
This thread I started for assistance in SQL scripting, but also it can be classified in some way as a plugin request. However, it can be moved if needed.
To understand the meaning of what I need, I'll write what its needed for.
I'm using big LAN, and through a plugin I restrict them access to servers, and open to players who have an account. All information about accounts, range of LAN IPs is stored in MySQL database.
Code:
Example:
LAN range: 10.10.0.0/24; MySQL DB table:
[Range] [Mask]
10.10.0.0 24
Account info also stored in MySQL DB: name, password, and many others...
I want to ban account in game, and it can be done by Making/Adding a menu in AMXMODMENU that does this.
I'm a web-programmer, with poor knowledge in pawn, but the algorithm of logics of operations is this (new menu has the same logic and structure as banmenu):
- NewMenu => (check all players by IP and listing ONLY players who are included in specified LAN range, retrieved from MySQL DB)
- select player =>
- select time of banning =>
- select reason =>
- ban player: by MODIFYING his Account info in MYSQL by executing a mysql query (UPDATE QUERY) on him (changing some values).
This menu I can create by myself, but any solutiions are welcome.
My question is AMXX MySQL scripting of this algorithm.
Any suggestions, ideas, solutions are welcome.