AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   SQL Scripting questions for plugin (https://forums.alliedmods.net/showthread.php?t=85469)

[NEO] 02-11-2009 06:32

SQL Scripting questions for plugin
 
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):
  1. NewMenu => (check all players by IP and listing ONLY players who are included in specified LAN range, retrieved from MySQL DB)
  2. select player =>
  3. select time of banning =>
  4. select reason =>
  5. 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.


All times are GMT -4. The time now is 16:59.

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