Raised This Month: $ Target: $400
 0% 

SQL Scripting questions for plugin


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
[NEO]
New Member
Join Date: Feb 2009
Location: Chisinau
Old 02-11-2009 , 06:32   SQL Scripting questions for plugin
Reply With Quote #1

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.

Last edited by [NEO]; 02-11-2009 at 06:34.
[NEO] is offline
Send a message via ICQ to [NEO]
Old 02-14-2009, 01:20
[NEO]
This message has been deleted by [NEO].
Old 02-17-2009, 09:37
[NEO]
This message has been deleted by YamiKaitou. Reason: bump
Reply


Thread Tools
Display Modes

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 16:59.


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