Error Setup Ijji's Site

Results 1 to 12 of 12
  1. #1
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Error Setup Ijji's Site

    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..


  2. #2
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: [Help]Error Setup Ijji's Site

    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.

  3. #3
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Re: [Help]Error Setup Ijji's Site

    Quote Originally Posted by wesman2232 View Post
    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??
    Last edited by kitez; 29-12-10 at 04:15 AM.

  4. #4
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: [Help]Error Setup Ijji's Site

    Quote Originally Posted by kitez View Post
    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.

  5. #5
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Re: [Help]Error Setup Ijji's Site

    Quote Originally Posted by wesman2232 View Post
    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...

  6. #6
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: Error Setup Ijji's Site

    Good, anything else? :)

  7. #7
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Re: Error Setup Ijji's Site

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

  8. #8
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: Error Setup Ijji's Site

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

  9. #9
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Re: Error Setup Ijji's Site

    Quote Originally Posted by wesman2232 View Post
    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.....

  10. #10
    DRGunZ 2 Creator wesman2232 is offline
    MemberRank
    Jan 2007 Join Date
    Erie, PALocation
    4,872Posts

    Re: Error Setup Ijji's Site

    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 :)

  11. #11
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Re: Error Setup Ijji's Site

    Quote Originally Posted by wesman2232 View Post
    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...

  12. #12
    Account Upgraded | Title Enabled! kitez is offline
    MemberRank
    Aug 2010 Join Date
    549Posts

    Re: Error Setup Ijji's Site

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



Advertisement