AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   Saving data to SQL (https://forums.alliedmods.net/showthread.php?t=127704)

ESTCOBS 05-23-2010 22:04

Saving data to SQL
 
Hi :]
This is the code for a making screenshots of players.
Could some one add code to saving to SQL : admin-nick;nick;ip;steamid;date ?
I want to in my MySQL DB at table amx_screenshots saved the admin nick, player [which is taken snapshots] nick, player ip, player steamid, date

Code:

#include <amxmodx>
#include <amxmisc>

#define VERSION                "0.9"

new g_Hostname, g_DelaySS, g_DelayBan, g_SnapShot, g_UnbanURL

public plugin_init()
{
        register_plugin("ScreenShots", VERSION, "ESTcobs")
       
        register_dictionary("admincmd.txt")
        register_dictionary("screenshots.txt")

        g_Hostname = get_cvar_pointer("hostname")
        g_DelaySS = register_cvar("ss_delay", "1.5")
        g_DelayBan = register_cvar("ss_bandelay", "15.0")
        g_SnapShot = register_cvar("ss_number", "3")
        g_UnbanURL = register_cvar("ss_website", "www.ESTcobs.pl")
       
        register_concmd("mbs_ss", "zrobSS", ADMIN_KICK, "<name lub #userid> - ")
        register_concmd("mbs_ssban", "zrobSSban", ADMIN_BAN, "<nick lub #userid> - ")
}

public zrobSS(id,level,cid)
{
        if(!cmd_access(id, level, cid, 1))
                return PLUGIN_HANDLED
       
        new target[32]
        read_argv(1, target, 31)
        new player = cmd_target(id, target, CMDTARGET_OBEY_IMMUNITY)

        if(!player)
                return PLUGIN_HANDLED

        new Param[2]
        Param[0] = id
        Param[1] = player

        set_task(Float:get_pcvar_float(g_DelaySS), "SS_Task", 0, Param,2, "a", get_pcvar_num(g_SnapShot))

        return PLUGIN_HANDLED
}

public zrobSSban(id,level,cid)
{
        if(!cmd_access(id, level, cid, 1))
                return PLUGIN_HANDLED
       
        new target[32]
        read_argv(1, target, 31)
        new player = cmd_target(id, target, CMDTARGET_OBEY_IMMUNITY)

        if(!player)
                return PLUGIN_HANDLED

        new Param[2]
        Param[0] = id
        Param[1] = player

        set_task(Float:get_pcvar_float(g_DelaySS), "SS_Task", 0, Param,2, "a", get_pcvar_num(g_SnapShot))
        set_task(Float:get_pcvar_float(g_DelayBan), "BanSS_Task", 0, Param,2)

        return PLUGIN_HANDLED
}

public SS_Task(Param[2])
{
        new player = Param[1]
        new id = Param[0]
        new name[32], timer[32], hostname[64], name2[32], ip[32], authid2[32], site[64]

        get_user_name(id, name, 31)
        get_user_name(player, name2, 31)
        get_user_authid(player, authid2, 31)
        get_user_ip(player, ip, 31, 1)

        get_time("%d/%m/%Y - %H:%M:%S", timer, 63)
        get_pcvar_string(g_Hostname, hostname, charsmax(hostname))
        get_pcvar_string(g_UnbanURL, site, charsmax(site))

        client_print(player, print_chat, "%L", LANG_PLAYER, "SS_MSG1", name)
        client_print(player, print_chat, "%L", LANG_PLAYER, "SS_MSG2", timer, hostname)
        client_print(player, print_chat ,"%L", LANG_PLAYER, "SS_MSG3", name2, ip, authid2)
        client_print(player, print_chat ,"%L", LANG_PLAYER, "SS_MSG4", site)

        set_hudmessage(150, 0, 255, -1.0, 0.1, 0, 0.25, 1.0, 0.0, 0.0, 4)
        show_hudmessage(player, "%L", player, "SS_MSG_HUD", timer, hostname, name2, ip, authid2, site)

        client_cmd(player,"snapshot")

        return PLUGIN_HANDLED
}

public BanSS_Task(Param[])
{
        new id = Param[0]
        new player = Param[1]
        new userid2 = get_user_userid(player)

        client_cmd(id, "amx_ban 0 #%d ^"HERE REASON^"", userid2)
       
        return PLUGIN_HANDLED
}

Thanks a lot for help :]

Brreaker 05-24-2010 06:58

Re: Saving data to SQL
 
Wiki is your friend!
http://wiki.alliedmods.net/Advanced_...X)#SQL_Support

ESTCOBS 05-24-2010 10:03

Re: Saving data to SQL
 
huh, could you give me a working code ?
my attempts ends in compilation errors :/


All times are GMT -4. The time now is 05:15.

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