SQL Server

Quote:

---

Originally Posted by limpamesa

Try this script at Query Analizer because default value for GPCode should be PTP-RUD001 or you have conn. failed error mesage.

update AllGameUser
Set GPCode='PTP-RUD001'

---

this is just for displaying Play time message when ppl logged in

ok thx u guys with all ur helps but still not working I enter any type of letter in the username box and it says Wrong Password, nothing Wrong Account Again! when I enter a password it says conn. fail ive tryed all ur guys advice nothing so far it says 1 user is online for like 2 seconds then 0

heres Log File

18:43:49 >**** Starting Service **** - ( 0 / 0 )
18:46:56 >**** Starting Service **** - ( 0 / 0 )
19:3:42 >**** Starting Service **** - ( 0 / 0 )
19:5:29 >**** Starting Service **** - ( 0 / 0 )

also when I remove sql.dll and I use odbc everything is conn fail but server recv messages.. with sql.dll only I get Wrong Account Again, Wrong Password... and Users 1... maybe help

found this on my c:
014527|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
014527|SiegeMoneyTax lpszTt=0
015255|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
015255|SiegeMoneyTax lpszTt=0
021950|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
021950|SiegeMoneyTax lpszTt=0
022053|Admin's DB Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SELECT userid, Passwd, GameCode, GPCode, RegistDay, DisuseDay, UsePeriod, Credit, SelectChk, EventChk, BlockChk, inuse, DelChk, ServerName, EditDay, RNo, SNo, Channel, BNum FROM AGameUser WHERE userid = 'Admin'
024522|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
024522|SiegeMoneyTax lpszTt=0
024745|Admin's DB Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SELECT userid, Passwd, GameCode, GPCode, RegistDay, DisuseDay, UsePeriod, Credit, SelectChk, EventChk, BlockChk, inuse, DelChk, ServerName, EditDay, RNo, SNo, Channel, BNum FROM AGameUser WHERE userid = 'Admin'
032819|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
032819|SiegeMoneyTax lpszTt=0
033020|SiegeMoneyTax lpszClanMarkNum [0] lpszTt [0] lpszTax [0]
033020|SiegeMoneyTax lpszTt=0
033514|Admin's DB Error [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. SELECT userid, Passwd, GameCode, GPCode, RegistDay, DisuseDay, UsePeriod, Credit, SelectChk, EventChk, BlockChk, inuse, DelChk, ServerName, EditDay, RNo, SNo, Channel, BNum FROM AGameUser WHERE userid = 'Admin'

And that is supposed to be....? Thats like posting raw hash without context.

Quote:

---

Originally Posted by shagpub

this is just for displaying Play time message when ppl logged in

---

Yes and for setup time I have used it:

update AllGameUser
Set DisuseDay = '12/31/2017 23:59:59'

But for news accounts is nice change defauld value in database table for DisuseDay field. If I dont put any value in GPCode and DisuseDay field I have error like Conect fail.
So for everyone who is going to use the sql.dll I recomend to run this 2 scripts and set default value in AllGameUser for this.

sik im not sure what it is after every failur a new number file just pops up on my c drive 20070147 and it contains these contacts now for Admin's thats my login name im trying to use Admin obiously sql is being blocked or mislead by the server file sql.dll so is their I have to edit inside sql.dll ? if so can u tell me how