hello
Any1 know how set a player GM account?
Printable View
hello
Any1 know how set a player GM account?
how to fix this?: ImageShack® - Online Photo and Video Hosting please
use USP_NICKNAME_UPDATE :thumbup1:Quote:
Originally Posted by BoUrnE
how do I start tournaments only two people?
Uhmm how do i fix this error?
TITLE: Connect to Server
------------------------------
------------------------------
ADDITIONAL INFORMATION:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)
Whats weird is the pangya server works perfectly fine, i just cant connect to it through mssql2008
This actually happened to me once, but I don't think your case is the same. Are you sure sqlservr.exe is running? I remember needing to turn it off once, then I forgot to turn it back on.Quote:
Originally Posted by G0dzilla2000
Of course, I'm 99% sure that isn't the problem. A quick google search of that error code will help you, though.
Hey Guys can someone help me solve this problem
http://img3.fotos-hochladen.net/uplo...lgjs2bnkcr.jpg
I can log in i see the server but i cant see any channels would be great if someone can help me pls.
No one got a clue?
read the logs, it can helps you
here's a quick guide to installing the server onto your system just incase you guys need some references.
1. Install SQL 2005: it's pretty easy and you don't need advanced stuff so don't bother with this too much.
2. Install the DBs: i use monk's DBs so its a fixed DB sort of but it still lacks the missing stored procedures.
3. Go to the other thread where you'll see the missing procedures all compiled (credits go to those who made it you know who you are ^^) and Execute it to their respective databases.
4. Configure the ODBC's if you don't know how this is done look at some of the old Tutorials on this forum.
5. install client and update to 582.03
6. Download fasa2008's ProjectG.exe to be able to connect to your server.
If i'm missing some "BASIC" and i do mean BASIC stuff feel free to add what ever you like. as far as i'm concerned i already did this 3-4 times i lost count already and I've been able to connect to my server successfully.
** if you cant see channels you're probably missing some stored procedures
** If your Equips don't save then re-run EQUIP_SAVE_S4 in the DB and it should be fine.. atleast that's what i Did.
Don't ask me about shops or adding GMs or admins. Some other person might be able to create it someday but not now i guess.
I will not answer any Log in related questions since it's pretty easy to set up. i will not answer item related questions since i might make a mistake explaining how to hex it.
That's it i hope you learned something pretty easy.
you can't :/ Start with 4 accounts and make the room private and start the game. then quit the 3 others clients if you want to play aloneQuote:
Originally Posted by Liphe_xD
Can someone help me with this error ?
http://img577.imageshack.us/img577/4855/erro1d.png
What change do you exist when the value of ISCASH, TYPE, and IS_SALABLE is changed?Quote:
Originally Posted by jhonzinbr123
uwaaaa~~~ That's Cool guy I have waiting for this
already moved all in: USP_NICKNAME_UPDATE .. and still the same problem ..Quote:
Originally Posted by o800920
what should I change here ?????? help please:?:
bourne user query
USE [Pangya_S4_TH]
GO
/****** Object: StoredProcedure [dbo].[USP_NICKNAME_UPDATE] Script Date: 11/29/2010 18:42:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[USP_NICKNAME_UPDATE]
@x int,
@y varchar(20)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
select 0
END