Printable View
Ehmm, sorry can't help you. I aint got this problem. Maiby thats the reason why nobody awnsers you because its a rare bug. But i can only speak for myself and that doesn't seem to help... sorry 'bout that. Maiby you can post some picks and i do got 1 tip, turn off msn messenger, msn and gunz got major collisions.Quote:
Originally Posted by Saranir
can you plz post clan proc's plz!
Ok so i deleted it, so can i reinstal it and create server?
dose any one know what this error
Code:[01/22/07 21:09:36] Release Date : Dec 19 2005
[01/22/07 21:09:38] DBMS connected
[01/22/07 21:09:38] Command registeration completed
MServer::Create - m_RealCPNet.Create(nPort)==false
edit post dont matter sorted my issue
ermm the julygunz.exe crashs when loading the sound O_o
I only got the procs titels, and what they need to do. But they are not written. Still need them?Quote:
can you plz post clan proc's plz!
I guess so :)Quote:
Ok so i deleted it, so can i reinstal it and create server?
Hmmm, never seen that one beforeQuote:
dose any one know what this error
I know someone who had this problem. He was talking about getting newer files, so i think he was talking about update1.mrs and other sound.mrsQuote:
ermm the julygunz.exe crashs when loading the sound O_o
But i don't use julygunz, i once tried to get it to work and after 5 minutes i changed back to the first matchserver because i can handle that one.
oh right -.-
ive got a question
Do you know how i can fix negative bounty.. i mean if i buy a quest item then my bounty goes negative.
there isnt a way for fix the negative bounty even =/ just wait...
I still trying to run july matchserver... but i think we need new procs for it
ok thanks anyways
Nothing is detecting my SQL Server, Im not on a router, and my firewall is disabled, any ideas?
nvm, we fix the problem nowQuote:
Originally Posted by PericulanT
No we didnt, what are you smoking?
xD riiiiiight. Well, nothing is detecting your sql database? Explain because i can't do anything with this. :)
How do I change the exp rate?
-====
SQL Problem Fixed, downloaded that dll thing you posted.
Great guides btw.
How to install:
Go to Procedures and Right Click there and select New Query, there u paste this code and click at Execute.
Can somebody give me a pic were Procedures is casue i cant find it
Edit:Nvm found it
In formula.xmlQuote:
Originally Posted by PericulanT
how do i do that i will be able to creat clan ?
Please someone can give me models (*.mrs) of NPC ( i have only goblin and pamploa in my gunz) .Qwest mode don't work without it if I not mistake.
plz look for them in this post or in other posts
I logged in to Gunz, I got the black screen after select.
I got this error from MSSQL.
um..um..
you got the error before you logged in or after?
After. Anyway, I just fixed it. -_-" I forgot to configure the ODBC to set the default database... I already created an admin account but now theres more trouble -_-" I have to keep Alt-Tabbing.. Once I press Log in, they say cannot access server then I need to Alt-Tab and Alt-Tab back to make the cannot access server. This applies to everything I do. Equip Items, Select Character, Select Channel, Doing admin commands...
lol, wait for it to load, for you its seems to take a bit of time ALT+TAB dose nothink, lol xD
btw mine dose this 2 it says i cant log in then i wait for a sec or 3
then i get loged in(i only pree login once)
havent tested those but they look like they do this: (again, im not sure... just used logics...)Quote:
/gtgod
/gtspn
/gtclear
/gtreload
/gtsc
/gtfin
/gtweaknpcs
/gtgod = ?
/gtspn = respawn
/gtclear = clear chat
/gtreload = reload or restart all rounds (go back to 0/30 or everybody 0/0 kill/death)
/gtsc = ?
/gtfin = finish game
/gtweaknpcs = make the npc's in quest weak and easy to kill xD (lol)
Hm..i got a problem in my server :P
when i try to login the server it says me the info is incorrect , i did everything like in the detailed guides. i think it's about ports , i tried to open port 6000 , but when i check it if it successed it says it dint =\
what should i do ?
I got a problem,that when i enter to my server and select my character and then all the screen become black and i cant see anything O.o.
change spinsertchar to this and it will work(i had same problem)Quote:
Originally Posted by frammm
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
well this means your password and user name is not right...Quote:
Originally Posted by qwqw
i found some more admin commands 2, lol xD
Code:/gtfin
/gtweaknpcs
/gtlspn
/gtclear
/gtreload
/gtspn
/go
/admin_reset_all_hacking_block
/admin_reload_hash
/changepassword
/admin_switch_laddergame
/admin_halt
It is right =\Quote:
Originally Posted by MAXTRAXv3
i think it's about my ports . i tried to open port 6000 but when i check it , it says i dint open it. how to fix it ??? :schmoll:
I was testing my quest mode when the MatchServer lost connection with GunzDB -_- I was thinking why the gobs didn't spawn even though its 1 minute... I alt-tabbed and checked it. It lost connection with it.. Then I alt-tabbed back and gobs spawned. I think Alt-Tab's faster or Window mode because it does everything slowly...Quote:
Originally Posted by MAXTRAXv3
How can I extract update1.mrs and update2.mrs from Jgunz? They dont extract with the normal MRS unpacker.
/go isnt an admin command...
um.. i know that but it was under that so what ever...
Hi. Ive just been trying to make a server, and when i chose my char. i get to a black screen and it stays there for hours.... Any ideas
(Note:I have tryed what matrix said upthere. but i get an error, 1 cause most things u need to press space. and im not sure bout next 1
Heres the error
Msg 8101, Level 16, State 1, Procedure spInsertChar, Line 19
An explicit value for the identity column in table 'Character' can only be specified when a column list is used and IDENTITY_INSERT is ON.)
Any ideas?
I got a question..
Revolver01x2=meshname
Thats dual revolvers..so if i added mesh name=shotgun03(or w/e)x2, would that make me have dual shotguns? Because I want to figure out how to make dual shotguns :]
show us your spInsertChar Procedure...Quote:
Originally Posted by koruny
hi i need help i followed all the info on this thread but none would solve my prob ><
this is my site
www.riseofdead.com/register.php
look at it and ull see whats wrong. itll take a while.
heres info if u can help me
my info
sql user: SA
pass:ps2jak2
database name: GunzDB
Server Name(in mysql express) : SERVER/SQLEXPRESS
please help ><
this is what i put in
</style>
</head>
<body>
<div align="center">
<?php
$srvip = "24.239.170.174";
$srvport = "6000";
$mssql_user = "sa";
$mssql_pass = "ps2jak2";
$mssql_database = "GunZDB";
$mssql_host = "\SQLEXPRESS";
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass);
mssql_select_db($mssql_database);
?>
<FORM METHOD=POST ACTION="<?php echo $_SERVER['PHP_SELF']; ?>?act=register">
<table cellspacing=0 border=0>
<tr>
Ok hereQuote:
Originally Posted by MAXTRAXv3
set ANSI_NULLS ON
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,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,null)
END
Ive looked through the post and tryed like 5 of them. ures at the top of the page doesnt work for me. get the error i said before, most of them have the error.. I tryed ures matrix at the top, first i got a bunch of errors, then put the spaces in and had ure same error that i got before.
So any ideas?
(Weird, the null at the end looks like nul l but when i look in edit its got no space lol)
if you got any charr on your sever you cant put im in...i dont know why that is it just is oh and if that dose not work delete all acounts then
still dontwork
magician911
this should fix yours and if that pass and username is real Change it but i will write the reg page for it too connect just one thing i can't do. without your server name and name of pc i can't write it 100% working :P
</style>
</head>
<body>
<div align="center">
<?php
$srvip = "127.0.0.1"; (If Local)
$srvport = "6000";
$mssql_user = "sa";
$mssql_pass = "ps2jak2";
$mssql_database = "GunZDB";
$mssql_host = "PC NAME\SERVER NAME"; (might be SERVER\SERVER NAME)
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass);
mssql_select_db($mssql_database);
?>
<FORM METHOD=POST ACTION="<?php echo $_SERVER['PHP_SELF']; ?>?act=register">
<table cellspacing=0 border=0>
<tr>
should work -.-
But i can hack your DB :P
CHANGE YOUR PASS neva give out your pass -.- when u post u should put ****** or a fake pass...wich it could b
i AM GavinX
Like i said do not put your password i could hack (or anyone eles) everything with this username and password :P
CHANGE IT
:P:P:P
Sorry about that just wanted to show him how much of a noob he just was -,-
/gtweaknpcs = spawns npc sets :) aka Ga2 ect i think its disabled or something though
it not in the gunz.exe we use
Okay,
When i edit either man.mrs or woman.mrs or both,
I complile em & put em into "\Model" and when i launch Gunz.exe, the game closes when it gets to "Loading Mesh".
Anyone help??
lol i knew som1 was gunna do that but er i really dont care but thx for help testing ATM
STILL DOESNT WORK
Computer Full Name: SERVER
MSSQL Server Host: SERVER/SQLEXPRESS
WTF IS WRONG HELP
Right. Fixed my old prob
Prob was i was using
Mode="Test"
not
;Mode="Test"
And i know i need to use Mode="Test" for quest to work but....... if theres a solotion to that(Tryed the launcher) pls post but, for now im working with my server
PS:U should add how to fix the agent error if ure still getting it
I used hamachi, easy and simple and ive never used it before.. lol
with what program or editor i can edit *.elu and *.ani file formats for client???
en quest
help :
Then you need to Install this procedure:
Code:
CREATE PROCEDURE [dbo].[spSelectCharQuestItemInfoByCID]@nCID INTASBEGIN-- SET NOCOUNT ON added to prevent extra result sets from-- interfering with SELECT statements.SET NOCOUNT ON; SELECT QuestItemInfo FROM Character Where CID = @nCID END
How to install:
Go to Procedures and Right Click there and select New Query, there u paste this code and click at Execute.
Go to your match server folder,
- <Part 2.1: Working out the bugs, Editing config.ini; Credits to: emisand>
help. already estoi creating my server. who puende to make an image/screen of to Procedures and by nolo encounter, I hope burns can help thanks.
um...just click New Query or Query then put the code in....
thank you very much by the aid that served to me as much, for quest, but now which I am proving the Server I have another problem: first when salio in level 50 but that creates a personage if it had modified I, but when it kills it another one level 50 or commits suicide puts level 1 or 10 publish a personage of level 99 and when I kill level 1 level 90 it put level 1 and when a personage of level 50 kills to another one of level 50 they give 10 him of experience but in quest they give him as 16000 good the truth is a great problem I hope that somebody can help me with much patience in this thanks :schmoll: :schmoll: :schmoll: :schmoll: :smiley-go
lol, you can set the lvl you start with but you cant set the exp(thats your problem btw) becuse you dont have the exp for that lvl so when you die once you will go to the lvl of exp you have gained...
but level 50 I kill to another one level 50 and was put level 10, I do not understand much so if I pretend obstinate pardon, which I understand that it is I must modify experiecia of the server well? :schmoll:
well you can still get exp in quest mode, and die and still be the same lvl
thats what happed
Added To Download Center :)
umm...how to make a .bak File?? O_O....
Help me Please!....when the users try to connect in mi server....My MathServer say this : [02/05/07 14:47:58] Invalid ZItemChecksum(13317901) , UserID(holoca) ..............and the users cant enter....=(...sorry for my inglish...i From Chile xD.....but need help...please!
[Necesito ayuda por favor....al iniciar mi server...cuando intentan entrar en el ...me sal este error en el MatchServer: [02/05/07 14:47:58] Invalid ZItemChecksum(13317901) , UserID(holoca)
AYUDA PORFAVOR!]
Take zitem.xml from your server, unpack system.mrs , put zitem.xml from ur server there , pack it back - enjoyQuote:
Originally Posted by Holoca
when i kill my friend in my Private server he low her lvl =/..he down lvl.....this happen whit Administer Account and Normal User Account....i need help whit this please!! (sorry for my inglish, again, i from Chile xD)
http://img54.imageshack.us/img54/3307/gunz074ob8.jpghttp://img230.imageshack.us/img230/1439/gunz077tu2.jpghttp://img247.imageshack.us/img247/2179/gunz078sk4.jpghttp://img247.imageshack.us/img247/5877/gunz079ay0.jpg
This HAppen in ALL Maps
A bit of problem here, the Gunz User Account Register page won't work for me.. and also...
How do I change the amount of experience someone gains by killing someone?
its in fromla.xml where your match sever files are....
i know nothink about web pagers...xD
I don't it, what do I change?Code:<?xml version="1.0" encoding="UTF-8"?>
<XML id="formula">
<FORMULA_TABLE id="NeedExpLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1.1</LM>
<LM lower="31" upper="40">1.2</LM>
<LM lower="41" upper="45">1.4</LM>
<LM lower="46" upper="50">1.6</LM>
<LM lower="51" upper="55">1.8</LM>
<LM lower="56" upper="60">2</LM>
<LM lower="61" upper="65">4</LM>
<LM lower="66" upper="70">8</LM>
<LM lower="71" upper="75">12</LM>
<LM lower="76" upper="80">16</LM>
<LM lower="81" upper="85">20</LM>
<LM lower="86" upper="90">20</LM>
<LM lower="91" upper="95">40</LM>
<LM lower="96" upper="99">40</LM>
</FORMULA_TABLE>
<FORMULA_TABLE id="GettingExpLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1</LM>
<LM lower="31" upper="40">1</LM>
<LM lower="41" upper="45">1.1</LM>
<LM lower="46" upper="50">1.1</LM>
<LM lower="51" upper="55">1.1</LM>
<LM lower="56" upper="60">1.1</LM>
<LM lower="61" upper="65">1.1</LM>
<LM lower="66" upper="70">1.1</LM>
<LM lower="71" upper="75">1.1</LM>
<LM lower="76" upper="80">1.1</LM>
<LM lower="81" upper="85">1.2</LM>
<LM lower="86" upper="90">1.2</LM>
<LM lower="91" upper="95">1.2</LM>
<LM lower="96" upper="99">1.2</LM>
</FORMULA_TABLE>
<FORMULA_TABLE id="GettingBountyLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1.1</LM>
<LM lower="31" upper="40">1.1</LM>
<LM lower="41" upper="45">1.2</LM>
<LM lower="46" upper="50">1.2</LM>
<LM lower="51" upper="55">1.2</LM>
<LM lower="56" upper="60">1.2</LM>
<LM lower="61" upper="65">1.2</LM>
<LM lower="66" upper="70">1.2</LM>
<LM lower="71" upper="75">1.2</LM>
<LM lower="76" upper="80">1.2</LM>
<LM lower="81" upper="85">1.2</LM>
<LM lower="86" upper="90">1.2</LM>
<LM lower="91" upper="95">1.2</LM>
<LM lower="96" upper="99">1.2</LM>
</FORMULA_TABLE>
</XML>
<FORMULA_TABLE id="GettingExpLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1</LM>
<LM lower="31" upper="40">1</LM>
<LM lower="41" upper="45">1.1</LM>
<LM lower="46" upper="50">1.1</LM>
<LM lower="51" upper="55">1.1</LM>
<LM lower="56" upper="60">1.1</LM>
<LM lower="61" upper="65">1.1</LM>
<LM lower="66" upper="70">1.1</LM>
<LM lower="71" upper="75">1.1</LM>
<LM lower="76" upper="80">1.1</LM>
<LM lower="81" upper="85">1.2</LM>
<LM lower="86" upper="90">1.2</LM>
<LM lower="91" upper="95">1.2</LM>
<LM lower="96" upper="99">1.2</LM>
</FORMULA_TABLE>
<FORMULA_TABLE id="GettingBountyLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1.1</LM>
<LM lower="31" upper="40">1.1</LM>
<LM lower="41" upper="45">1.2</LM>
<LM lower="46" upper="50">1.2</LM>
<LM lower="51" upper="55">1.2</LM>
<LM lower="56" upper="60">1.2</LM>
<LM lower="61" upper="65">1.2</LM>
<LM lower="66" upper="70">1.2</LM>
<LM lower="71" upper="75">1.2</LM>
<LM lower="76" upper="80">1.2</LM>
<LM lower="81" upper="85">1.2</LM>
<LM lower="86" upper="90">1.2</LM>
<LM lower="91" upper="95">1.2</LM>
<LM lower="96" upper="99">1.2</LM>
</FORMULA_TABLE>
</XML>
That. Never change NeedEXPLM.
@Holoca: Edit in the required amount of exp in as well, as you start off with 0 exp
@Slyzer: Bolded numbers
Code:<FORMULA_TABLE id="GettingExpLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1</LM>
<LM lower="31" upper="40">1</LM>
<LM lower="41" upper="45">1.1</LM>
<LM lower="46" upper="50">1.1</LM>
<LM lower="51" upper="55">1.1</LM>
<LM lower="56" upper="60">1.1</LM>
<LM lower="61" upper="65">1.1</LM>
<LM lower="66" upper="70">1.1</LM>
<LM lower="71" upper="75">1.1</LM>
<LM lower="76" upper="80">1.1</LM>
<LM lower="81" upper="85">1.2</LM>
<LM lower="86" upper="90">1.2</LM>
<LM lower="91" upper="95">1.2</LM>
<LM lower="96" upper="99">1.2</LM>
</FORMULA_TABLE>
<FORMULA_TABLE id="GettingBountyLM">
<LM lower="1" upper="20">1</LM>
<LM lower="21" upper="30">1.1</LM>
<LM lower="31" upper="40">1.1</LM>
<LM lower="41" upper="45">1.2</LM>
<LM lower="46" upper="50">1.2</LM>
<LM lower="51" upper="55">1.2</LM>
<LM lower="56" upper="60">1.2</LM>
<LM lower="61" upper="65">1.2</LM>
<LM lower="66" upper="70">1.2</LM>
<LM lower="71" upper="75">1.2</LM>
<LM lower="76" upper="80">1.2</LM>
<LM lower="81" upper="85">1.2</LM>
<LM lower="86" upper="90">1.2</LM>
<LM lower="91" upper="95">1.2</LM>
<LM lower="96" upper="99">1.2</LM>
</FORMULA_TABLE>
</XML>
I don't know how to change my server IP to like example: privateserver.sytes.net using No.IP.
So, 15x exp would be like 15000 for everything?Quote:
Originally Posted by Vitto
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?
insert in the \system\channelrule.xml in the client and the server :SniperHeaQuote:
Originally Posted by NIRVANAdylan
what do u mean by wamp icon? i dun see anything..
Alright, thanks to some help from a few friends, I got nomsg E-1 off. Now, I still get a black lobby. Any clue why my lobby is STILL black?
Edit:
Quote:
Originally Posted by spInsertChar
Quote:
Originally Posted by dbo.Character
where can i download the gunz client? the other tut = download dead
k nvm anything above i got it all set... but the the wamp server.. where the link to where i go to let ppl see the registration page.... www.??? i got it online..but where do i see the registration =[
[QUOTE].1.5 How to change login background?
A.
<Change background; Credits to: Irwirkk for the whole tutorial>
1
got problem wif quest mode, i got gobin doll, and when i go equip i get client crashed, when i go shop brownse the quest item, my client crashes again
I got many errors for WAMP.
Moved to the Gunz section since this isn't really a release more than a guide or FAQ.
look the png files in my default are corrupted their all zeros and i used ur guide too but i think i got it wrong could u please show it in little more detail sorry im just not to good with comps:(Like put files i have to make in interface and stuff
Registrtion doesn`t work for me i delete in php.ini line mssql but this doesnt`t help
this error Fatal error: Call to undefined function: mssql_connect() in c:\apache\www\gunzon\index.php on line 47
Open you php.ini file
and delete ; in ;extension=php_mssql.dll
Sorry with my English :(
Problem done! for others noobs (but am not noob !!!!! )
delete this ; in windows/php.ini and in php/php.ini !!!!!!!!!!!!
1st i delete only in windows/php.ini
Ok i know that i should read sticky about default.mrs i do that i unpack my default.mrs change color of loading bar.Than pack and mouse is gone.Than i put back my orginal.Unpack it edit image again do the thing and for last thing i type in ren default defualt.zip and it changes that file into default.zip but its not a zip file.And I open it rename it to default again and pack it and same thing happens mouse is gone.Oh and all png files are 0
My WAMP can't connect to SQL Server.