AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   extract sql (https://forums.alliedmods.net/showthread.php?t=82343)

Iulyy 12-21-2008 16:07

extract sql
 
Quote:

new query[512]
admin_id = format(query, 511, "SELECT id FROM amx_amxadmins WHERE username = '%s'", admin_nick)
format(query, 511, "INSERT INTO `%s` (player_id,player_ip,player_nick,admin_ip,adm in_steamid,admin_nick,ban_type,ban_reason,ban _created,ban_length,server_name,server_ip,admin_id) VALUES('%s','%s','%s','%s','%s','%s','%s','%s ','%i','%s','%s','%s:%s','%s')", tbl_bans, player_steamid, player_ip, player_nick, admin_ip, admin_steamid, admin_nick, g_ban_type, g_ban_reason, ban_created, BanLength, server_name, g_ip, g_port, admin_id)
A part of this cod it's from amxbans and i'm not sure if admin_id it's corect.
In this script i want to extract admin id from the datebase and insert if a admin is banning a player.
I hope you understund what i want to say because my english is not to good.

griefhy 12-24-2008 08:54

Re: extract sql
 
if admin kick or ban someone,be recorded to the database, yes ???
so ,your problem is ??????

Iulyy 12-24-2008 13:21

Re: extract sql
 
Yes, the problem is i don't know ho to extract admin id from amx_amxadmins (database) to insert in to amx_bans.

Styles 12-24-2008 17:09

Re: extract sql
 
Show me the tables, I'll make you a query, please put them exactly how they are... and an example of one row each. I'm to lazy to go look up the structure.

Iulyy 12-24-2008 17:20

Re: extract sql
 
Quote:

CREATE TABLE `amx_amxadmins` (
`id` int(12) NOT NULL auto_increment,
`username` varchar(32) default NULL,
`password` varchar(32) default NULL,
`access` varchar(32) default NULL,
`flags` varchar(32) default NULL,
`steamid` varchar(32) default NULL,
`nickname` varchar(32) NOT NULL default '',
`forum_id` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=46 DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
Quote:

CREATE TABLE `amx_bans` (
`bid` int(11) NOT NULL auto_increment,
`player_ip` varchar(100) default NULL,
`player_id` varchar(50) NOT NULL default '0',
`player_nick` varchar(100) NOT NULL default 'Unknown',
`admin_ip` varchar(100) default NULL,
`admin_steamid` varchar(50) NOT NULL default '0',
`admin_nick` varchar(100) NOT NULL default 'Unknown',
`ban_type` varchar(10) NOT NULL default 'S',
`ban_reason` varchar(255) NOT NULL default '',
`ban_created` int(11) NOT NULL default '0',
`ban_length` varchar(100) NOT NULL default '',
`server_ip` varchar(100) NOT NULL default '',
`server_name` varchar(100) NOT NULL default 'Unknown',
`admin_id` varchar(50) NOT NULL default '0',
PRIMARY KEY (`bid`)
) ENGINE=MyISAM AUTO_INCREMENT=755 DEFAULT CHARSET=latin1 AUTO_INCREMENT=755 ;

Iulyy 01-10-2009 16:36

Re: extract sql
 
Somebody help me please i'm despered!!!

X0Left4dead0X 01-10-2009 16:44

Re: extract sql
 
Amxx scripting and maybe we can help you the sma of this sql database thing. Make sure you remove all your private sql info I.e
PHP Code:

sql_password="blahblah <<< this" 


Iulyy 01-11-2009 03:44

Re: extract sql
 
You can modify the original sma from amxbans and i think is the cmdBan.inl in folder amxbans.

X0Left4dead0X 01-11-2009 05:57

Re: extract sql
 
The admin_bansql.sma or what ever it is please or no help i mean yours...


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

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