AlliedModders Donor
Join Date: Oct 2015
Location: Honduras
01-30-2019
, 11:35
Re: OciXCrom's Rank System [XP|Levels|Ranks]
#1
Spoiler
Quote:
Originally Posted by
lithuanianjack
i did something wrong. I changed these lines but nothing changes. I think i forgot something.
PHP Code:
formatex ( szquery , charsmax ( szquery ), "insert into %s (`player`,`xp`,`level`,`next xp`,`rank`,`next rank`) values ('%s','0','1','0','n/a','n/a');" , g_esettings [ sql_table ], getsecurename ( szplayer ))
PHP Code:
formatex ( szquery , charsmax ( szquery ), "select xp from %s where player = '%s';" , g_esettings [ sql_table ], getsecurename ( szplayer ))
PHP Code:
iquery2 = sql_preparequery ( isqlconnection , "select * from %s where player = `%s`;" , g_esettings [ sql_table ], getsecurename ( szplayer ))
PHP Code:
formatex ( szquery , charsmax ( szquery ), "update `%s` set `xp`='%i' where `player`='%s';" , g_esettings [ sql_table ], ixp , getsecurename ( szplayer ))
PHP Code:
ormatex ( szquery , charsmax ( szquery ), "insert into %s (`player`,`xp`,`level`,`next xp`,`rank`,`next rank`) values ('%s','%i','1','0','n/a','n/a');" , g_esettings [ sql_table ], getsecurename ( szplayer ), ixp )
PHP Code:
new handle : iquery = sql_preparequery ( isqlconnection , "select * from %s where player = '%s';" , g_esettings [ sql_table ], getsecurename ( szplayer ))
just changed
szplayer to
getsecurename(szplayer)
added this:
PHP Code:
#define secure_name_len 31 * 2 + 1 // twice as long as name (31 * 2 + zero terminator) in case all 31 characters are insecure
and this:
PHP Code:
getsecurename (const name [])
{
new securename [ secure_name_len ];
copy ( securename , charsmax ( securename ), name );
replace_all ( securename , charsmax ( securename ), "\", " \\ ");
replace_all(securename, charsmax(securename), " ` ", "\`");
replace_all(securename, charsmax(securename), "'", "\'");
return securename;
}
Can you tell me what is the error that causes you and at what time?