Error Setup Ijji's Site

**kitez** · 28-12-10

hello, when i try to setup ijji's website from this thread, i got this error message "warning:mssql_query()[function.mssql-query]:message:invalid object name 'Banneduser'. (severity 16) in C:\xampp\www\secure\functions.php on line 9". anyone knows why is that??

thank you for your help..

**MentaL**

**wesman2232** · 28-12-10

You need to add the table Banneduser.
All the files needed for the web SHOULD have been released with in the original thread you got it from.

**kitez** · 29-12-10

Originally Posted by wesman2232

You need to add the table Banneduser.
All the files needed for the web SHOULD have been released with in the original thread you got it from.

yes, there's the database and web file, but i only download the web file coz i already make gunz website and want to change it with this.

---------- Post added at 08:46 AM ---------- Previous post was at 08:30 AM ----------

btw, thank you i got an error like this too "Warning: mssql_query() [function.mssql-query]: message: Invalid column name 'Ranking'. (severity 16) in C:\xampp\www\secure\functions.php on line 9". i guess i have to make Ranking and BannedUser table, am i right??

---------- Post added at 09:34 AM ---------- Previous post was at 08:46 AM ----------

i can't alter table my Account Table,it says "Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '0'." and can't create "Ranking" table, is ther anyone knows why is that and sql syntax query for making Ranking Table??

**wesman2232** · 29-12-10

Originally Posted by kitez

i guess i have to make Ranking and BannedUser table, am i right??

---------- Post added at 09:34 AM ---------- Previous post was at 08:46 AM ----------

i can't alter table my Account Table,it says "Msg 102, Level 15, State 1, Line 2 Incorrect syntax near '0'." and can't create "Ranking" table, is ther anyone knows why is that and sql syntax query for making Ranking Table??

Correct, but only Banneduser is a table, Ranking is a column that needs to be created, but you already know that :)

You can manually edit the table in SMSE (Server Management Studio Express), right click the table Account and click Design. Then just add the column to the bottom where no data is and save.

**kitez** · 29-12-10

Originally Posted by wesman2232

Correct, but only Banneduser is a table, Ranking is a column that needs to be created, but you already know that :)

You can manually edit the table in SMSE (Server Management Studio Express), right click the table Account and click Design. Then just add the column to the bottom where no data is and save.

thank you,sorry i forgot to update it. yes, it's fixed with that way...

**wesman2232** · 30-12-10

Good, anything else? :)

**kitez** · 06-01-11

ehm..my individual ranking doesn't come out...do u know why??

**wesman2232** · 06-01-11

Any errors?
If not post the script for it here.

**kitez** · 07-01-11

Originally Posted by wesman2232

Any errors?
If not post the script for it here.

well, at the homepage there's nothing wrong about it.

Spoiler:

but, when i click "more" or want to see all of them, it doesn't show anything.

Spoiler:

i already click "1-20","20-40" and others,but still the same.

here is my mod_ranking.php

Spoiler:

Code:

<?
if ($_GET['expand'] == 1){
?>
				<tr>
					<td width="917" colspan="5" height="26" style="background-image: url('images/subbar.jpg'); background-repeat: no-repeat; background-position: center top">
					<p align="center">
					<a href="index.php?do=ranking&sub=individual&expand=1">
					<img border="0" src="images/subbar/individualranking.jpg" width="128" height="13"></a><a href="index.php?do=ranking&sub=clan&expand=1"><img border="0" src="images/subbar/clanranking.jpg" width="99" height="13"></a></td>
				</tr>

<? }

if($_GET['expand'] == 0){

switch($_GET['sub']){
    case "individual";
        ShowIndividualRanking();
    break;
    case "clan";
        ShowClanRanking();
    break;
}
}


if(!function_exists("ShowIndividualRanking")){
function ShowIndividualRanking(){
    $res = mssql_query("SELECT TOP 50 * FROM Character ORDER BY XP DESC");
    $count = 0;
    ?>


<head>
<meta http-equiv="Content-Language" content="es">
<link rel="stylesheet" type="text/css" href="images/style.css">
</head>

	<body bgcolor="#312F30">

					<div align="center">
						<table border="0" width="456" style="border-collapse: collapse">
							<tr>
								<td background="images/cont_up.jpg">&nbsp;</td>
							</tr>
							<tr>
								<td background="images/cont_bg.jpg">
								<div align="center">
									<table border="0" style="border-collapse: collapse" width="454" height="100%">
										<tr>
											<td width="4" rowspan="6">&nbsp;</td>
											<td width="436">
											<img border="0" src="images/inf/individualranking.jpg"></td>
											<td width="8">&nbsp;</td>
										</tr>
										<tr>
											<td width="434">
											&nbsp;</td>
											<td width="8">&nbsp;</td>
										</tr>
										<tr>
											<td width="434">
											<div align="center">
												<table border="0" width="421" style="border-collapse: collapse; background-image: url('images/rankinglist.jpg'); background-repeat: no-repeat; background-position: center top">
													<tr>
														<td>
														<table border="0" style="border-collapse: collapse" width="100%" height="100%">
															<tr>
																<td height="30">&nbsp;</td>
															</tr>
															<tr>
																<td style="background-image: url('images/rankinlist_bg.gif'); background-repeat: repeat; background-position: center top">
																<table border="0" style="border-collapse: collapse" width="417" height="100%">
                                                                <?
                                                                    while($r = mssql_fetch_assoc($res)){
                                                                    $count++;
                                                                    ?>
																	<tr>
																		<td width="45">
																		<p align="center">
																		<?=$count?></td>
																		<td width="88">
																		<p align="center">
																		<b>
																		<span class="guild_name">
																		<?=$r['Name']?></span></b>
																		</td>
																		<td width="33">
																		<p align="center">
																		<?=$r['Level']?></td>
																		<td width="127">
																		<p align="center">
																		<?=number_format($r['XP'],0,'','.');?></td>
																		<td width="114">
																		<p align="center">
																		<span style="font-size: 7pt">
																		<?=$r['KillCount']?>/<?=$r['DeathCount']?>
																		</span></td>
																	</tr> <?}?>
																</table>
																</td>
															</tr>
														</table>
														</td>
													</tr>
												</table>
											</div>
											</td>
											<td width="8">&nbsp;</td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											&nbsp;</center></td>
											<td width="8" height="24">&nbsp;</td>
										</tr>
									</table>
								</div>
								</td>
							</tr>
							<tr>
								<td background="images/cont_top.jpg" height="27">&nbsp;</td>
							</tr>
						</table>
					</div>
    <?
} }

if(!function_exists("ShowClanRanking")){
function ShowClanRanking(){
    $res = mssql_query("SELECT TOP 50 * FROM Clan ORDER BY Ranking DESC");
    ?>
<body bgcolor="#312F30">

					<div align="center">
						<table border="0" width="456" style="border-collapse: collapse">
							<tr>
								<td background="images/cont_up.jpg">&nbsp;</td>
							</tr>
							<tr>
								<td background="images/cont_bg.jpg">
								<div align="center">
									<table border="0" style="border-collapse: collapse" width="454" height="100%">
										<tr>
											<td width="4" rowspan="6">&nbsp;</td>
											<td width="436">
											<img border="0" src="images/inf/clanraking.jpg" width="413" height="17"></td>
											<td width="8">&nbsp;</td>
										</tr>
										<tr>
											<td width="434">
											&nbsp;</td>
											<td width="8">&nbsp;</td>
										</tr>
										<tr>
											<td width="434">
											<div align="center">
												<table border="0" width="421" style="border-collapse: collapse; background-image: url('images/clanranking_list.jpg'); background-repeat: no-repeat; background-position: center top">
													<tr>
														<td>
														<table border="0" style="border-collapse: collapse" width="100%" height="100%">
															<tr>
																<td height="30">&nbsp;</td>
															</tr>
															<tr>
																<td style="background-image: url('images/clanranking_list_bg.gif'); background-repeat: repeat; background-position: center top">
																<table border="0" style="border-collapse: collapse" width="417" height="100%">
                                                                    <? while($r = mssql_fetch_assoc($res)){   ?>

                                                                    <tr>
																		<td width="45">
																		<p align="center">
																		<?=$r['Ranking']?></td>
																		<td width="90">
																		<p align="center">
																		<b><?=$r['Name']?></b></td>
																		<td width="76">
																		<p align="center">
																		<? $res2 = mssql_query("SELECT * FROM Character WHERE CID = '".$r['MasterCID']."'");
                                                                            $c = mssql_fetch_assoc($res2);
                                                                            echo $c['Name'];
                                                                        ?></td>
																		<td width="71">
																		<p align="center">
																		<?=$r['Wins']?>/<?=$r['Losses']?></td>
																		<td width="40">
																		<p align="center">
																		<img border="0"  width="30" height="30" src="http:(//******/gunz/?=$r['EmblemUrl']?>"</td>
																		<td width="83">
																		<p align="center">
																		<?=$r['TotalPoint']?></td>
																	</tr>  <?}?>
																</table>
																</td>
															</tr>
														</table>
														</td>
													</tr>
												</table>
											</div>
											</td>
											<td width="8">&nbsp;</td>
										</tr>
										<tr>
											<td width="434" height="24">
											<center>
											&nbsp;</center></td>
											<td width="8" height="24">&nbsp;</td>
										</tr>
									</table>
								</div>
								</td>
							</tr>
							<tr>
								<td background="images/cont_top.jpg" height="27">&nbsp;</td>
							</tr>
						</table>
					</div>
    <?
} }





?>

thank you for your help.....

**wesman2232** · 07-01-11

umm I'm not exactly sure, but I think it has to do with the first part of the script in the expand=1 part.

try this :

Code:

index.php?do=ranking&sub=individual&expand=0

I'll download the web myself in a bit and look at it :)

**kitez** · 10-01-11

Originally Posted by wesman2232

umm I'm not exactly sure, but I think it has to do with the first part of the script in the expand=1 part.

try this :

Code:

index.php?do=ranking&sub=individual&expand=0

I'll download the web myself in a bit and look at it :)

okay,i'll try that,thank you so much for your help...

**kitez** · 18-01-11

hemm...i've tried it, but still error. still doesn't show anything....

Error Setup Ijji's Site

Thread Tools

Search Thread

Error Setup Ijji's Site

Re: [Help]Error Setup Ijji's Site

Re: [Help]Error Setup Ijji's Site

Re: [Help]Error Setup Ijji's Site

Re: [Help]Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Re: Error Setup Ijji's Site

Advertisement