[RELEASE] BOI Server Files + Server Tools + GM tools

Page 43 of 71

07/28/2012 20:57 bbantisoft#631

Quote:

Originally Posted by sambaba

I just figured out how to modify every instance to be solo and all of them into only 1 realm. If anyone interested, I will post it later tomorrow =)

yes please :D

07/28/2012 21:11 DGND#632

hey guys.. small question.
I have tried to add some money to the character via the MySQL but no luck. So now i want to add some coin bags in the marketplace. My question is now do you edit the .slk files ? I tried to open them with excel but no luck. It opens as read only .

Thanks

07/28/2012 21:25 LeRaz0r#633

Edit ShopCommodity.Slk, save new copy, paste the new copy over the existing file. Or you could just make it easier for yourself and set permissions to write as well. :/

07/28/2012 21:29 demonlordace#634

ahhh this password shit is killing me

07/28/2012 21:38 xXSuperflyXx#635

found this in mssql in programmability system stored procedures
sys.sp_addlogin

USE [PassportBOI]
GO
/****** Object: StoredProcedure [sys].[sp_addlogin] Script Date: 07/28/2012 20:27:01 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [sys].[sp_addlogin]
@loginame sysname
,@passwd sysname = Null
,@defdb sysname = 'master' -- UNDONE: DEFAULT CONFIGURABLE???
,@deflanguage sysname = Null
,@sid varbinary(16) = Null
,@encryptopt varchar(20) = Null
AS
-- SETUP RUNTIME OPTIONS / DECLARE VARIABLES --
set nocount on
declare @exec_stmt nvarchar(4000)
declare @hextext varchar(256)
declare @ret int

-- DISALLOW USER TRANSACTION --
set implicit_transactions off
IF (@@trancount > 0)
begin
raiserror(15002,-1,-1,'sys.sp_addlogin')
return (1)
end

-- VALIDATE LOGIN NAME:
execute @ret = sys.sp_validname @loginame
if (@ret <> 0)
return (1)

set @exec_stmt = 'create login ' + quotename(@loginame)

if @passwd is null
select @passwd = ''

if (@encryptopt is null)
set @exec_stmt = @exec_stmt + ' with password = ' + quotename(@passwd, '''')
else
begin
declare @passwdbin varbinary(256)
set @passwdbin = convert(varbinary(256), @passwd)
execute sys.sp_hexadecimal @passwdbin, @hextext OUT
set @exec_stmt = @exec_stmt + ' with password = ' + @hextext

if (@encryptopt = 'skip_encryption_old')
set @exec_stmt = @exec_stmt + ' hashed '
else if (@encryptopt = 'skip_encryption')
set @exec_stmt = @exec_stmt + ' hashed '
else
begin
raiserror(15600,-1,-1,'sys.sp_addlogin')
return 1
end
end

if (@defdb is not null)
set @exec_stmt = @exec_stmt + ', default_database = ' + quotename(@defdb)

if (@deflanguage is not null)
set @exec_stmt = @exec_stmt + ', default_language = ' + quotename(@deflanguage)

if (@sid is not null)
begin
execute sys.sp_hexadecimal @sid, @hextext OUT
set @exec_stmt = @exec_stmt + ', sid = ' + @hextext
end

exec (@exec_stmt)

if @@error <> 0
return (1)

-- RETURN SUCCESS --
return (0) -- sp_addlogin

07/28/2012 21:46 demonlordace#636

that isnt what ur thinking it is all dbs have them just about
for system procs

07/28/2012 21:51 xXSuperflyXx#637

okies

07/28/2012 22:57 Hackheaven#638

The save server is not working it seems i revert to lvl 1 after i get d/c from the server after 15mins

If you logout and edit your coins in the mysql table or lvl it will go back to 1/0 when you lvl up or use an item

You cant go back to char screen after login and you cant exit the game unless you d/c

07/28/2012 23:15 cpenner#639

I still cannot get LeagueData to load into ManagerServerR.exe and therefore am stuck at the character creation screen. I have been fiddling with the config files for quite sometime, and for whatever reason nothing seems to be working. If somebody who has a running server could just Skype me and take a peek at my configs, I would be very grateful.. If not, I will also post them here. Please just let me know if I have my LINUX and WINDOWS IPs in the correct spot.

WINDOWS: 192.168.15.86
LINUX: 192.168.15.116

WINDOWS CONFIGS
----------------------------
auagent.conf