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)
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)
Last edited by MAXTRAXv3; 27-01-07 at 10:00 AM.
havent tested those but they look like they do this: (again, im not sure... just used logics...)/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)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) ENDwell this means your password and user name is not right...
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
Last edited by MAXTRAXv3; 28-01-07 at 02:23 AM.
It is right =\
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...
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...
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 here
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)
Last edited by koruny; 31-01-07 at 10:39 AM.
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
Last edited by GavinX; 31-01-07 at 02:19 PM.
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
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
