how do i fix this error?
how do i fix this error?
Last edited by landon38; 20-08-10 at 10:40 PM.
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.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
Last edited by landon38; 22-08-10 at 04:57 PM. Reason: adding error info
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
Last edited by Zewa; 22-08-10 at 05:24 PM.
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
Last edited by Zewa; 23-08-10 at 08:28 AM.
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
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
Last edited by landon38; 23-08-10 at 01:05 PM. Reason: adding info for dbo.ServerStatus.
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.
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>
Last edited by wesman2232; 29-08-10 at 03:12 AM.
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 ;)
Reply With Quote
