User_
|
Last Activity: 11/20/2010 04:00
Mentions
| 01/07/2022 |
| 14:24 - nager2013 mentioned User_ in post Automatic Coins Only For Players Online. DECLARE User_no varchar(36)
DECLARE kur SCROLL cursor FOR select user_no from Account.dbo.USER_PROFILE where login_flag <> 0
OPEN kur FETCH NEXT FROM kur INTO User_no
WHILE @@FETCH_STATUS ... |
| 04/25/2020 |
| 21:27 - PyrexiaStudios mentioned User_ in post Automatic coins for players online. Received a solution.
Thanks. |
| 10/28/2017 |
| 07:31 - [DEV]AlphaOMEGA mentioned User_ in post Dragon knight server files + database ...IP)?
SP_GET_PCBANG_INFO_R? ??.
1.4 2006-01-04 ??? 1. ???? ???? ??? ??
1.5 2006-01-11 ??? 1. ?? ????(-4) : ???? (RollBack, Return ??)
1.6 2007.02.05 CHOI JI HWAN 1. modify User_pwd parameter.
before : varchar(20)
after : varchar(64)
1.7 2007.02.14 CHOI JI HWAN 1. ????? ip ?? ?? ??.
2. ???? MD5 ???
User_pwd : VARCHAR(20) -> VARCHAR(64)
1.8 2007.... |
| 08/08/2017 |
| 01:58 - guesswho-.- mentioned User_ in post Someone know how this Table work! How i can Active he for work IP_BAN on A9 if you wanna use that table then you gotta edit SP_LOGIN_EN (if thats what you use for logging in)
its as easy as this:
select * from C_IP_BAN where static_ip = User_ip_addr
if @@ROWCOUNT > 0
BEGIN
SET @sp_rtn = -1
RETURN
END
as a sidenote, I see that the SP checks the IP address using dbo.FN_ExistBanIP User_ip_addr) so perhaps you don... |
| 06/02/2016 |
| 14:45 - ... ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[BuyItem] Login_id nvarchar(50)
AS
BEGIN
DECLARE
@i as integer,
Counter as integer,
user_id as INTEGER,
row as integer,
--
item_id as integer,
stack as integer,
PRICE as integer,
item_name as nvarchar(50),
User_point as integer
--
Set us... |
| 04/24/2016 |
| 22:21 - guesswho-.- mentioned User_ in post Automatic Coins Only For Players Online. eh, I'll make a quick one for you coz I'm bored anyways
DECLARE User_no varchar(36)
DECLARE kur SCROLL cursor FOR select user_no from Account.dbo.USER_PROFILE where login_flag <> 0
OPEN kur FETCH NEXT FROM kur INTO User_no
WHILE @@FETCH_STATUS... |
| 04/14/2016 |
| 08:51 - ...IP)?
SP_GET_PCBANG_INFO_R? ??.
1.4 2006-01-04 ??? 1. ???? ???? ??? ??
1.5 2006-01-11 ??? 1. ?? ????(-4) : ???? (RollBack, Return ??)
1.6 2007.02.05 CHOI JI HWAN 1. modify User_pwd parameter.
before : varchar(20)
after : varchar(64)
1.7 2007.02.14 CHOI JI HWAN 1. ????? ip ?? ?? ??.
2. ???? MD5 ???
User_pwd : VARCHAR(20) -> VARCHAR(64)
1.8 2007.... |
