AlliedModders

AlliedModders (https://forums.alliedmods.net/index.php)
-   Scripting Help (https://forums.alliedmods.net/forumdisplay.php?f=11)
-   -   [Help] Need add save/load data to SQL (https://forums.alliedmods.net/showthread.php?t=168688)

newcomer 10-02-2011 15:15

[Help] Need add save/load data to SQL
 
2 Attachment(s)
Here's plugin working, but it only save/load in a text file. Please help me convert it to save/load in SQL (any SQL)

PHP Code:

#define VERSION    "2.0"

#include <amxmodx>
#include <amxmisc>
#include <cstrike>

new bank[33]
new 
configfile[200]
new 
authid[33][32]
new 
pcvar

public plugin_init()
{
    
register_plugin("Simple CS Bank",VERSION,"GHW_Chronic")
    
pcvar register_cvar("bank_save","1")

    new 
configsdir[200]
    
get_configsdir(configsdir,199)
    
format(configfile,199,"%s/cs_bank.ini",configsdir)

    
register_dictionary("GHW_CS_Bank.txt")
}

public 
client_putinserver(id)
{
    if(!
is_user_bot(id)) set_task(5.0,"client_authorized2",id)
}

public 
client_authorized2(id)
{
    
bank[id] = 0
    
if(get_pcvar_num(pcvar))
        
set_task(10.0,"read_file2",id)
    
set_task(0.1,"cpt",id,"",0,"b")
}

public 
client_disconnect(id)
{
    if(!
is_user_bot(id) && get_pcvar_num(pcvar))
        
save_money(id)
}

public 
cpt(id)
{
    if(
is_user_alive(id))
    {
        if(
cs_get_user_money(id)>10000)
        {
            
bank[id]+= cs_get_user_money(id) - 10000
            cs_set_user_money
(id,10000)
        }
        if(
cs_get_user_money(id)<10000)
        {
            if(
bank[id] < 10000 cs_get_user_money(id))
            {
                
cs_set_user_money(id,cs_get_user_money(id)+bank[id])
                
bank[id]=0
            
}
            else
            {
                
bank[id]-=  10000 cs_get_user_money(id)
                
cs_set_user_money(id,10000)
            }
        }
        
set_hudmessage(025500.70.8706.00.10.10.2next_hudchannel(id) )
        
show_hudmessage(id,"%L",id,"MSG_BANK",bank[id])
    }
}

public 
read_file2(id)
{
    if(
is_user_connected(id) && file_exists(configfile))
    {
        
get_user_authid(id,authid[id],31)
        new 
read[32]
        new 
filepointer fopen(configfile,"r")
        while(
fgets(filepointer,read,31))
        {
            
replace(read,31,"^n","")
            if(
equali(read,authid[id]))
            {
                
fgets(filepointer,read,31)
                if(
cs_get_user_money(id)<10000)
                {
                    if(
cs_get_user_money(id) + str_to_num(read)<=10000)
                    {
                        
cs_set_user_money(id,cs_get_user_money(id) + str_to_num(read))
                    }
                    if(
cs_get_user_money(id) + str_to_num(read)>10000)
                    {
                        
bank[id] += (str_to_num(read) + cs_get_user_money(id)) - 10000
                        cs_set_user_money
(id,10000)
                    }
                }
                else
                {
                    
bank[id] += str_to_num(read)
                }
                break;
                
            }
        }
        
fclose(filepointer)
    }
}

public 
save_money(id)
{
    new 
string[32]
    
format(string,31,"%d",bank[id])
    new 
iline
    
new filepointer fopen(configfile,"r")
    if(
filepointer)
    {
        new 
read[32]
        while(
fgets(filepointer,read,31))
        {
            
replace(read,31,"^n","")
            
server_print("%d. %s",i,read)
            if(
equali(read,authid[id]))
            {
                
line=1
                
break;
            }
            
i++
        }
    }
    
fclose(filepointer)
    if(!
linewrite_file(configfile,authid[id],i)
    
write_file(configfile,string,i+1)



newcomer 10-17-2011 00:11

Re: [Help] Need add save/load data to SQL
 
bump*
Please help me !

mottzi 10-17-2011 10:46

Re: [Help] Need add save/load data to SQL
 
no, you wont get any help, since there is a clear tutorial about that.


All times are GMT -4. The time now is 19:42.

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