nope itwould be
15
15.1
15.1
15.2
15.2
15.2
15.2
15.2
15.2
Printable View
nope itwould be
15
15.1
15.1
15.2
15.2
15.2
15.2
15.2
15.2
Alright, thanks. :)
I don't get it, I tried the 15 before every number and the thing only gave me like 600 exp. So I tried the thing above that gave me like 40704 something... I tested it with a friend of mine, and we killed eachother like 10 times, then he had to do something so he left room. I checked my lv and I was 80... I don't get it anymore.Code:</FORMULA_TABLE>
<FORMULA_TABLE id="GettingExpLM">
<LM lower="1" upper="20">15000</LM>
<LM lower="21" upper="30">15000</LM>
<LM lower="31" upper="40">15000</LM>
<LM lower="41" upper="45">15000.1</LM>
<LM lower="46" upper="50">15000.1</LM>
<LM lower="51" upper="55">15000.1</LM>
<LM lower="56" upper="60">15000.1</LM>
<LM lower="61" upper="65">15000.1</LM>
<LM lower="66" upper="70">15000.1</LM>
<LM lower="71" upper="75">15000.1</LM>
<LM lower="76" upper="80">15000.1</LM>
<LM lower="81" upper="85">15000.2</LM>
<LM lower="86" upper="90">15000.2</LM>
<LM lower="91" upper="95">15000.2</LM>
<LM lower="96" upper="99">15000.2</LM>
</FORMULA_TABLE>
<FORMULA_TABLE id="GettingBountyLM">
<LM lower="1" upper="20">150</LM>
<LM lower="21" upper="30">150.1</LM>
<LM lower="31" upper="40">150.1</LM>
<LM lower="41" upper="45">150.2</LM>
<LM lower="46" upper="50">150.2</LM>
<LM lower="51" upper="55">150.2</LM>
<LM lower="56" upper="60">150.2</LM>
<LM lower="61" upper="65">150.2</LM>
<LM lower="66" upper="70">150.2</LM>
<LM lower="71" upper="75">150.2</LM>
<LM lower="76" upper="80">150.2</LM>
<LM lower="81" upper="85">150.2</LM>
<LM lower="86" upper="90">150.2</LM>
<LM lower="91" upper="95">150.2</LM>
<LM lower="96" upper="99">150.2</LM>
</FORMULA_TABLE>
</XML>
Does anyone of you know Legacy Gamers? I want the exp to be somehow like that, so that it's fast, but not TOO fast...
Quote:
Originally Posted by Slyzer
Putting in 15 makes it 15x the normal experience. So you're leveling up 15x as fast. That's why you got so much experience.Code:</FORMULA_TABLE>
<FORMULA_TABLE id="GettingExpLM">
<LM lower="1" upper="20">[b]15/b]</LM>
<LM lower="21" upper="30">15</LM>
<LM lower="31" upper="40">15</LM>
<LM lower="41" upper="45">15.1</LM>
<LM lower="46" upper="50">15.1</LM>
<LM lower="51" upper="55">15.1</LM>
<LM lower="56" upper="60">15.1</LM>
<LM lower="61" upper="65">15.1</LM>
<LM lower="66" upper="70">15.1</LM>
<LM lower="71" upper="75">15.1</LM>
<LM lower="76" upper="80">15.1</LM>
<LM lower="81" upper="85">15.2</LM>
<LM lower="86" upper="90">15.2</LM>
<LM lower="91" upper="95">15.2</LM>
<LM lower="96" upper="99">15.2</LM>
</FORMULA_TABLE>
<FORMULA_TABLE id="GettingBountyLM">
<LM lower="1" upper="20">15</LM>
<LM lower="21" upper="30">15.1</LM>
<LM lower="31" upper="40">15.1</LM>
<LM lower="41" upper="45">15.2</LM>
<LM lower="46" upper="50">15.2</LM>
<LM lower="51" upper="55">15.2</LM>
<LM lower="56" upper="60">15.2</LM>
<LM lower="61" upper="65">15.2</LM>
<LM lower="66" upper="70">15.2</LM>
<LM lower="71" upper="75">15.2</LM>
<LM lower="76" upper="80">15.2</LM>
<LM lower="81" upper="85">15.2</LM>
<LM lower="86" upper="90">15.2</LM>
<LM lower="91" upper="95">15.2</LM>
<LM lower="96" upper="99">15.2</LM>
</FORMULA_TABLE>
</XML>
[quote=Vitto;1980797]@Holoca: Edit in the required amount of exp in as well, as you start off with 0 exp
Where i can modify that? >.<!
I may be an idiot, but I can't seem to get the black lobby fix to work.
before
afterCode:USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spInsertChar] Script Date: 02/26/2007 19:16:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SET NOCOUNT ON;
DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROM Character
WHERE AID = @nAID
DECLARE @cid INT
SELECT @cid=COUNT(*)
FROM Character
INSERT INTO Character
VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100000,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0)
END
and I get this error after hitting Execute/!Code:setANSI_NULLSON
setQUOTED_IDENTIFIERON
GO
ALTERPROCEDURE [dbo].[spInsertChar]
@nAID INT,
@nCharIndex INT,
@szName nvarchar(32),
@nSex INT,
@nHair INT,
@nFace INT,
@nCostume INT
AS
BEGIN
SETNOCOUNTON;
DECLARE @cnt INT
SELECT @cnt=COUNT(*)
FROMCharacter
WHERE AID = @nAID DECLARE @cid INT
SELECT @cid=COUNT(*)
FROMCharacter
INSERTINTOCharacter
VALUES(@nAID,@szName,@cnt,50,@nSex,@nCostume,@nFace,@nHair,NULL,0,100,0,0,0,0,0,0,0,0,0,0,0,0,@cnt,100,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,null)
END
Am I doing something wrong or is it just being gay?Quote:
Originally Posted by Error
I'm running MSSQL 2005 SP2, and I copy pasta'd Maxtrax's fix right over mine.
Here's my spInsertChar. Just need to tweak the BP, XP, etc.Code:set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <RepublicOfAstra>
-- Description: <spInsertChar Procedure>
-- =============================================
ALTER PROCEDURE [dbo].[spInsertChar]
(
@AID tinyint,
@Charnum tinyint,
@Name varchar(50),
@Sex tinyint,
@Hair tinyint,
@Face tinyint,
@Costume tinyint
)
AS
INSERT INTO Character(AID, CharNum, Name, [Level], Sex, Hair, Face, Costume, XP, BP, HP, AP, FR, CR, ER, WR, KillCount, DeathCount, PlayTime, CIID, FriendCID, CLID)
VALUES (@AID, @CharNum, @Name,99 ,@Sex, @Hair, @Face, @costume, 999999,9999999999999999,
0,100,1,1,1,1, NULL, NULL, NULL, NULL, NULL, 0);
Alright, it works, but I have to take out CIID and FriendCID (and their respective Values). It gives me errors on those. Anything I need to add to a different file?Quote:
Originally Posted by RepublicOfAstra
Honestly, I'm not sure. My DB is a lot different from the ones posted at Ragezone, since my team made our DB long before anyone else did. But I think you just need to use my spInsertChar and it should be good. I guess the values that were giving you errors were just for columns I have that the others don't.Quote:
Originally Posted by TNT_Xplosiv
Well, the problem with that is, I get nomsg (E-1) whenever I try to create a new character with the 2 sequences and values taken out. I'm not a pro at SQL but I'm pretty sure that shouldn't be happening.Quote:
Originally Posted by RepublicOfAstra
I thought you said that it works once you remove those 2?
Well, if it's still fucking up on you, just remove the stuff or replace the stuff in the proc I posted with the names of the columns in your Character table, or add the stuff in the proc into your Character table.
I'll try that tomorrow and hope it works.Quote:
Originally Posted by RepublicOfAstra
i got 3 problems i hope u all help me
1:
i cant access server idk why
2:
i have creat acc in SQL Server Management Studio Express
and its dont work
3:
reg page i got problem with that ican creat web but i got many warnings
and i dont know where i must type in SQL Server Management Studio Express
e_mail
can sum1 post the files to fix the corrupted files of the default.mrs plz?
I got a problem with maps.
One time i could play all my custom maps, But now for some reason they don't appear in the Map drop-down list it just shows the ordinary maps.
Anyone help?