how do i fix this error?
http://img693.imageshack.us/img693/8044/83869872.png
Printable View
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).
1. i follow the step of "How to fix my web error guide" By Nolife_x.Quote:
Originally Posted by Zewa
2. yes.
3. no there are too many error in B-2-O website.
Then after i register on the register page it doesn't workCode: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
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
don't need to see it. hes missing the column "Slot" in probably CashShop.dboQuote:
Originally Posted by Zewa
yea I was thinking same xDQuote:
Originally Posted by wesman2232
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?
he all ready fixed it.Quote:
Originally Posted by fuxpro321
yes i already fix it but how about the player count it still Undefined.
i recommend you to use appserv!
ok will try this appserv later.
BTW my webserver is Abyss web server.
same problem :(...need help guyz
make sure you have this in mod_index.php :
PHP Code:<?
$res = mssql_query("SELECT * FROM ServerStatus WHERE Opened = '1'");
$servercount = 0;
while($srv = mssql_fetch_assoc($res)){
$servercount = $servercount + $srv['CurrPlayer'];
}
?>
Thanks wesman2232 i will try this.
The function for this problem is at the very top of mod_index.php, its the one I posted and the little bit of it below it.
In all it should be :
I still don't see why they use pics from RZ.PHP Code:<?
$res = mssql_query("SELECT * FROM ServerStatus WHERE Opened = '1'");
$servercount = 0;
while($srv = mssql_fetch_assoc($res)){
$servercount = $servercount + $srv['CurrPlayer'];
}
?><body onload="FP_preloadImgs(/*url*/'images/ele/playbutton_hover.jpg')" bgcolor="#323232">
<table border="0" style="border-collapse: collapse" width="100%" height="100%" id="table2">
<tr>
<td align="center" background="http://forum.ragezone.com/images/mn_info.jpg" height="76" style="background-image: url(''); background-repeat: no-repeat; background-position: center top">
<div align="center">
<object classid="clsid:D27CDB6E-AE6D-11CF-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,40,0" name="obj2" width="417" height="76" border="0" id="obj2">
<param name="movie" value="http://forum.ragezone.com/images/srv_data.swf">
<param name="quality" value="High">
<param name="wmode" value="transparent"><param name="BGCOLOR" value="#E2E2E2" />
<embed src="http://forum.ragezone.com/images/srv_data.swf" width="417" height="76" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" name="obj2" quality="High" wmode="transparent" bgcolor="#E2E2E2"></object>
</div></td>
</tr>
thank again wesman2232 more power to help and release.
god bless you!
:P may I asked if I fixed your problem? If not I will keep helping ;)Quote:
Originally Posted by landon38
the problem isn't solve But thanks
anyway i ask a question and you answer it. and that's enough for me.
ok if it is not solved, you should tell me ;)
First, make sure your DB information is correct (user, pass, host)
Check if your have your server in serverstatus.dbo
if so then lastly check if "opened" is set to 0. if it is set it to 1