Printable View
OK im making the querys right now got them all setup but when I click accountdb and click tables their nothing their to create a username but I click account_db tables and all the username files are their do I use account_db and then change my ODBC to account_db just need help thx :)
Expand AccountDB, go to the table beginning with the letter for your account name (Or AllGameUsers) right click open table, create.
Alternatively could also setup one of the registration scripts.
the thing is when I expand the table colum its empty theirs no user data files their at all
only account_db shows them
ok I fix it I restarted sql server and accountdb tables show up now but when I delete Null and put in username and other information I exit out of the file save it and reopen it and its Null again O_o help
Ok I did what u said to sik right open and created a new on it saved :) but I get this error at login also I get another error when no id is enter so I know its working just dont understand why it isnt letting me login with my id
this is with id
ImageShack - Hosting :: untitledtb9.jpg
without id
ImageShack - Hosting :: untitled1sv5.jpg
Try a reg script from the RFT thread
umm I downloaded but no clue how to set it up to my server... I just discovered something else when I click controlluser in server files it only shows one account that I made in MakeAccUser now my other account I created in the database when I search it in control user it says that its invalid?
heres my hotuk just incase
*MODE SERVER
*SERVER_CODE 0
*SERVER_NAME Server1
*SERVER_AUTOPLAY
*GAME_SERVER Alpha 127.0.0.1 127.0.0.1 127.0.0.1
//*CLAN_SERVER 127.0.0.1 80 127.0.0.1 80
*MAX_USERS 20
*SERVER_RECORD_MEM
*CHECK_POTION_COUNT 10000
*ENABLE_PARTYITEM
*PERMIT_EXP 1000
*ENABLE_SERVER_EXP 1000
*PERMIT_MONEY 1000
*EVENT_EXPUP 2000 (mean 100X EXP since i set 5X EXP by default)
*PK_FIELD 16
*EVENT_MORIFSHELTOM
*EVENT_POTION 5
*EVENT_BLESSCASTLE
*EVENT_CHILD
*EVENT_SUMMER_CHICKEN
*EVENT_NINEFOX
*EVENT_BITMASK 32
*EVENT_BLESSCASTLE 20
*EVENT_SIEGE_TIME 7
//Tax rate (lv * tax = price to enter)
*BELATRA_TAX 10
*BELATRA_TEXT_ERROR "Bellatra Text Error"
//Round 1,2,3
*BELATRA_MONSTER "SOD_Crypt" 40 "SOD_Buma" 40 "SOD_Armored Beetle" 40 "SOD_Skeleton Ranger" 40 "SOD_Vega Demir" 40
*BELATRA_MONSTER "SOD_Cyclops Knight" 40 "SOD_Greven" 40 "SOD_Titan" 40 "SOD_Avelisk-S" 40 "SOD_HellSing" 40
*BELATRA_MONSTER "SOD_Skeleton Knight" 40 "SOD_Mummy" 40 "SOD_Slaughter" 40 "SOD_Skeleton Ranger" 40 "SOD_Cursed Web" 40
//Round 4,5,6
*BELATRA_MONSTER "SOD_Muffin" 40 "SOD_Solid Snail" 40 "SOD_Dark Knight" 40 "SOD_BeEvil" 40 "SOD_Slayon" 30
*BELATRA_MONSTER "SOD_Figon" 40 "SOD_Illusion Knight" 40 "SOD_Slaughter" 40 "SOD_Mummy" 40 "SOD_Unseen" 30
*BELATRA_MONSTER "SOD_Heavy Goblin" 40 "SOD_Stone Golem" 40 "SOD_Doom Guard" 40 "SOD_Witch" 40 "SOD_Doom Lord" 30
//Round 7,8
*BELATRA_MONSTER "SOD_Sliver" 40 "SOD_Dusk" 40 "SOD_Hulk" 40 "SOD_Dawlin" 40 "SOD_Morgonyte" 20
*BELATRA_MONSTER "SOD_DeadZone" 40 "SOD_Avelin Queen" 40 "SOD_Chain Golem" 40 "SOD_Sadness" 40 "SOD_Shadow Phalanx" 20
*BACKUP_FOLDER_NAME "c:\databasebackup"
*BACKUP_PATH "c:\databasebackup"
//*DEBUG_ID Username1 Username2 Username3
//*DEBUG_IP 127.0.0.1 127.0.0.1 127.0.0.1 127.0.0.1
//*ADMINISTRATOR_IP 127.0.0.1
//*ADMIN_IP 127.0.0.1
*ADMIN_NAME "InsaneKilla"
*ADMIN_COMMAND "Hello1"
*ADMIN_COMMAND "Hello2"
*ADMIN_COMMAND "Hello3"
ok I got the 1855 working I changed all versions in idata, reg, and hotuk to 1855 I press connect no username in their it says Wrong Account Again, I type in the username I created and it takes a little while then conn. failed.. so I tryed everything I read in these forums I made odbc removed sql now when I did this it says conn failed right away without username or anything.. I replace sql and no username it say Wrong Account Again, I put username in Conn. Failed
ok so I figured out its a connection between my server and sql server because I ran server without sql server open and it did the same thing it does Wrong Account and unable when I enter id... so is their something I can do to check my connection between sql and my server im using named pipes cause tcp/ip dont work
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'
it's the client you are useing.
client version 10554
client used to connect to servers = 1845 1846 1847 1849 1855
Can you explain why should be PTP-RUD001?Quote:
Originally Posted by limpamesa
Because this is de dafault value in sql.dll.
this is just for displaying Play time message when ppl logged inQuote:
Originally Posted by limpamesa
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.
Yes and for setup time I have used it:Quote:
Originally Posted by shagpub
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