Player status Undefined

how do i fix this error?

http://img693.imageshack.us/img693/8044/83869872.png

Bump......

bump for the last time.....

did you edit some thing?
did you connect db?
every thing else working?

Yeh. If one does not work. All the other codes must be configured wrong. Make sure it is set up to your standards. (GunzDB name, PC Name(Host), and Password, and IP).

Quote:

---

Originally Posted by Zewa

did you edit some thing?
did you connect db?
every thing else working?

---

1. i follow the step of "How to fix my web error guide" By Nolife_x.
2. yes.
3. no there are too many error in B-2-O website.

Code:

---

Warning: mssql_query(): message: Invalid column name 'Slot'. (severity 16) in C:\Program Files\Abyss Web Server\htdocs\gunzweb\modules\mod_itemshop.php on line 29

Warning: mssql_query(): Query failed in C:\Program Files\Abyss Web Server\htdocs\gunzweb\modules\mod_itemshop.php on line 29

Fatal error: Call to undefined function: mssql_error() in C:\Program Files\Abyss Web Server\htdocs\gunzweb\modules\mod_itemshop.php on line 29

---

Then after i register on the register page it doesn't work
I think i will change it in to a ODBC type

Change it to tha one on tha bottom. All tha way.

post line 29 from "mod_itemshop.php"
let me see it

for Player status I could help better if I would see the code

Quote:

---

Originally Posted by Zewa

post line 29 from "mod_itemshop.php"
let me see it

for Player status I could help better if I would see the code

---

don't need to see it. hes missing the column "Slot" in probably CashShop.dbo

Quote:

---

Originally Posted by wesman2232

don't need to see it. hes missing the column "Slot" in probably CashShop.dbo

---

yea I was thinking same xD
I think X-Weaver DB has it so
use X-Weaver DB

ok i already fix the CashShop.
But the Player Count is dead.
Still Undefined.
Any one help please!
And How do i change the type of the register page into a ODBC

hmm take screenshot of dbo.ServerStatus

http://img191.imageshack.us/img191/7259/36910617.png

Code:

---

USE [GunzDB]
GO
/****** Object:  Table [dbo].[ServerStatus]    Script Date: 09/23/2010 19:18:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[ServerStatus](
        [ServerID] [int] NOT NULL,
        [CurrPlayer] [smallint] NULL,
        [MaxPlayer] [smallint] NULL,
        [Time] [datetime] NULL,
        [IP] [varchar](32) NULL,
        [Port] [int] NULL,
        [ServerName] [varchar](64) NULL,
        [Opened] [tinyint] NULL,
        [Type] [int] NULL,
 CONSTRAINT [ServerStatus_PK] PRIMARY KEY CLUSTERED
(
        [ServerID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

---

hmm in Server.ini IP is same like in dbo.ServerStatus?

hes missing the column "Slot" in probably CashShop.dbo

HAVE You checked that first?