No realms means /gameserver/line.exe hasn't fully loaded or isn't connecting properly I'm pretty sure.Quote:
I Got everything Working ,, but i log in , i have no realms there why is that
First, download OpenOffice to correctly view and edit .slk.
To fix going to jail, in /gameserver/slk/LMelimit.slk change all values in "Max Daily Coin Gain" column to 4000000000, all values in column "Max Daily EXP Gain" to 922337203685478, and all values in "Daily Maximum Deity Limit" to 4000000000.
Quick, amusing note on editing .slks, it is possible to crash the client with some server side changes. Increasing maximum boost level above 10 without client mods for example. So make sure to test changes before pushing them to players. :p
To unstuck quickly you can put this command into a .sh or .bat, depending on where you want to run it from:
mysql -u (username) -p(password) -e 'UPDATE 'shengui'.'basetab_sg' SET 'MapID'=2,'PosX'=150,'PosY'=150 WHERE 'MapID'=(put jail's map id here, i forget what it is);'
You'll need to add a host location to that statement if you're not running from the linux box. Should never get sent to jail once you modify the money, exp, deity per day limits.
TextPad is much much better for editing the .s script files than notepad. Many things can be changed there. Things that I've done successfully so far with the scripts include removing and increasing daily limits, realm requirements, deity requirements, etc for all instances, making deity items give different values of deity and usable more times per day, changing pack rates and creating new packs. Many many customization options here.
As far as getting items to show up in marketplace, haven't figured that out yet. Also haven't really messed with it much beyond an initial test.
Still haven't found an option to make the server use mssql account data instead of password 123. Did create a basic statement that should (assuming I've got the format correct for password encryption) insert account data properly however. It isn't ready for public use, no check for duplicate account names (Why is name column not unique by default?) but for testing locally it's fine.
--note for @ID, if you don't have at least one account created in dbo.account and dbo.users set @ID to =0 instead of allowing it to calculate the next ID.
DECLARE @ID INT;
DECLARE @ACCOUNTNAME CHAR(16) = 'insertaccountname';
DECLARE @PASSWORD CHAR(16) = 'insertpassword';
--unsure of values for usertype, guessing 0 is user, 1+ are gms
DECLARE @USERTYPE INT = insertaccountpermissionlevel;
DECLARE @HASHME NVARCHAR(4000);
DECLARE @DATE DATETIME = GETDATE();
SELECT @ID = MAX(id) FROM dbo.account;
SELECT @ID = @ID + 1;
SELECT @HASHME = @ACCOUNTNAME+@PASSWORD;
SELECT @HASHME = HASHBYTES('MD5', @HASHME);
INSERT INTO dbo.account (id,name,passwd,creatime,usertype) VALUES (@ID,@ACCOUNTNAME,CONVERT(binary(16),@HASHME),@DAT E,@USERTYPE);
INSERT INTO dbo.users (id,prompt,answer,name,idnumber,email,passwd2) VALUES (@ID,0,0,@ACCOUNTNAME,@ID,'[Only registered and activated users can see links. Click Here To Register...]',CONVER T(binary(16),@HASHME));
Feedback on whether that's entering the password in the proper format or not would be useful. An account name of "testing" with the password "password" outputs a passwd value of 0x59460574B564A13AD1A2A816A5918E08.
