[Help] Проблем с Sky Event Ranking

hristaka299

Member
Joined
Feb 16, 2012
Messages
73
Reaction score
3
Не ми запаметява в датабейс точките от евента(Пише 0 точки в таблицата на скай евент линс) (:|(:|.С версията на Дарк сам бета 22 за версия 97д99и.Единственото което се опитах да направя беше да пратя заявка с този скрипт:

alter table Character add BanPost int not null default 0
alter table Character add GrandResets int not null default 0
alter table Character add SkyEventWins int not null default 0

Бц ранка също го запаметява не както трябва в таблицата клас на всичко пише нула което е дарк лизард.
Благодаря Ви Предварително ! !

П.С-След подаване на заявка ми изкарва това в сял лога:

Server: Msg 2705, Level 16, State 4, Line 1
Column names in each table must be unique. Column name 'BanPost' in table 'Character' is specified more than once.
 
Last edited:
Грешката идва някъде от теб. Нямам такива проблеми ползвам ги около месец.

За BC и DS Class се вади от таблицата Character.

ПП: Не трябва да добавяш никакви кодове в query analyzer-a. В базата данни която сложиш си ги има. Тези query-та са за тези който са били с по старата "БЕТА 19" мисля че беше
 
Last edited:
За бц и дц добре ама защо за скай евента ги пише на всичките 0 точки..
П.П За скай евента не работише и преди да пробвам това със заявката ..Също съм с sql server 2000 ?
 
Last edited:
И не разбираш ли каква грешка ти вади пробвай с :

alter table Character add SkyEventWins int not null default 0

И това ще стане само ако нямаш тая колонка иначе пак ще изпише същата грешка .
Както вече ти казаха колонките са добавени в последния update на базата данни .
 
Да има си я колоната и е вкарана само незнам защо запаметява 0 навсякъде :Д
 
Момчета вкарах всички ранк листи в патя :Д.Имам само 1 проблем с админ панела на дамян съм ама едит акаунт не работи.Пиша ацц и не го намира.
Eто го и editacc.php

<? require("config.php"); ?>
<table width="393" border="0" align="center">
<tr>
<td width="394">&nbsp;</td>
</tr>
<tr>
<td><div align="center">
<?php if (isset($_POST["account_search_edit"]))
{
$account_edit = stripslashes($_POST['account_search_edit']);
$account_edit = str_replace("'","",$account_edit);
$account_edit = str_replace(";","",$account_edit);
$warehouse="Select pw from warehouse where accountid='$account_edit'";
$warehousepw = mssql_query($warehouse);
$whpw = mssql_fetch_row($warehousepw);

if($md5==1){
$get_account = mssql_query("Select memb___id,memb__pwd2,sno__numb,memb_name,bloc_code,mail_addr,fpas_ques,fpas_answ from MEMB_INFO where memb___id='$account_edit'");}
elseif($md5==0){
$get_account = mssql_query("Select memb___id,memb__pwd,sno__numb,memb_name,bloc_code,mail_addr,fpas_ques,fpas_answ from MEMB_INFO where memb___id='$account_edit'");}
$get_account_done = mssql_fetch_row($get_account);

if($get_account_done[3] == 1){$mode = "<option value='1'>Blocked</option><option value='0'>Normal</option>"; }
elseif($get_account_done[3] == 0){$mode = "<option value='0'>Normal</option><option value='1'>Blocked</option>"; }
echo ('<table width="283" border="0" cellspacing="2" cellpadding="2" class=tborder>
<tr><td class=alt1> <center><font color=green style="font-size; 10pt; font-weight: 400"> Акаунт </font></center></td></tr>
<tr><td class=thead>
<table width="283" border="0" cellspacing="0" cellpadding="0">
<tr>
<th scope="row"><form action="" method="post" name="edit_account_form" id="edit_account_form">
<table width="280" border="0" cellspacing="4" cellpadding="0">
<tr>
<td scope="row"><div align="right" class="text_administrator">Акаунт</div></td>
<td width="138" scope="row" class="text_administrator">'.$get_account_done[0].'</td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Парола</div></td>
<td width="138" scope="row"><span class="text_administrator">'.$get_account_done[1].'</span></td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Нова Парола </div></td>
<td width="138" scope="row"><input name="new_pwd" type="text" id="new_pwd" value="'.$get_account_done[1].'" maxlength="10" size="15" class=input></td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Парола на сандъка</div></td>
<td width="138" scope="row"><input name="whpw" type="text" id="whpw" value="'.$whpw[0].'" maxlength="4" size="15" class=input></td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Персонален ID код </div></td>
<td scope="row"><input name="idcode" type="text" id="idcode" value="'.$get_account_done[2].'" size="10" maxlength="7" class=input></td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Статус</div></td>
<td width="138" scope="row"><select name="mode" size="1" id="mode" class=select>'.$mode.'</select>
</td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">И-мейл адрес </div></td>
<td scope="row"><input name="email" type="text" id="email" value="'.$get_account_done[4].'" size="17" maxlength="50" class=input></td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Таен въпрос </div></td>
<td scope="row"><input name="squestion" type="text" id="squestion" value="'.$get_account_done[5].'" size="10" maxlength="10" class=input></td>
</tr>
<tr>
<td scope="row"><div align="right" class="text_administrator">Таен отговор </div></td>
<td scope="row"><input name="sanswer" type="text" id="sanswer" value="'.$get_account_done[6].'" size="10" maxlength="10" class=input></td>
</tr>


<tr>
<td scope="row"><div align="right" class="text_administrator"></div></td>
<td width="138" scope="row"><input name="account" type="hidden" id="account" value="'.$get_account_done[0].'">
<input name="edit_account_done" type="hidden" id="edit_account_done" value"edit_character_done"></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="4">
<tr>
<td width="111" scope="row"><div align="right">
<input name="Edit Account" type="submit" class="button" id="Edit Account" value="Запиши промените">
</div></td>
<td width="77" scope="row"><div align="left">
<input type="reset" name="Reset" value="Ресет" class="button">
</div></td>
</tr>
</table></table></table>
</form>
'); }
if (isset($_POST["edit_account_done"])){edit_account($_POST['account'],$_POST['new_pwd'],$_POST['whpw'],$_POST['idcode'],$_POST['mode'],$_POST['email'],$_POST['squestion'],$_POST['sanswer']);}
?>
</div></td>
</tr>
<tr>
<td>&nbsp;</td>
</tr>
</table>
<table width="393" border="0" align="center" cellpadding="1" cellspacing="2" class=tborder>
<tr><td class=alt1>
<center>
<font color=green style='font-size: 10pt; font-weight: 400'> Настройки на акаунт</font></td></center></tr>
<tr><td class=thead>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="center">
<table width="402" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="402"><table width="220" border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td><form action="" method="post" name="search_account" id="search_account">
<table width="220" border="0" cellspacing="4" cellpadding="0">
<tr>
<td colspan="2"><span class="normal_text">Акаунт: </span>
<input name="account_search_admin" type="text" class=input id="account_search_admin" size="17" maxlength="10"></td>
</tr>
<tr>
<td width="80" valign="middle"><span class="normal_text">Написал съм:</span></td>
<td width="122"><p>
<label>
<input type="radio" class=input name="search_type" value="1" checked>
<span class="normal_text">Цялото име</span></label>
<label>
<input type="radio" class=input name="search_type" value="0" >
<span class="normal_text">Част от името</span></label>



<br>
</p></td>
</tr>
</table>
<table width="200" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><input type="submit" name="Submit" class="button" value="Търси Акаунта"></td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table>
</div></td>
</tr>
</table>
<table width="200" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td scope="row"><div align="center"></div>
<div align="center">
<? if (isset($_POST["account_search_admin"]))
{
include("includes/search_account.php");}
?>
</div></td>
</tr>
</table>

</div></td>
</tr>
</table>

Това е search_account.php

<?PHP
if (eregi("includes/search_acc_admin.php", $_SERVER['SCRIPT_NAME'])) { die ("Access Denied"); }
require('config.php');

$search = stripslashes($_POST['account_search_admin']);
$search_type = stripslashes($_POST['search_type']);
$search_type = clean_var($search_type);

$search = str_replace("'","",$search);
$search = str_replace(";","",$search);



if($md5==1){
$search_exact = "SELECT memb___id,memb__pwd2,bloc_code,country,gender from MEMB_INFO where memb___id='$search'";}
elseif($md5==0){
$search_exact = "SELECT memb___id,memb__pwd,bloc_code,country,gender from MEMB_INFO where memb___id='$search'";}
if($md5==1){
$search_partial = "SELECT memb___id,memb__pwd2,bloc_code,country,gender from MEMB_INFO where memb___id like '%$search%'";}
elseif($md5==0){
$search_partial = "SELECT memb___id,memb__pwd,bloc_code,country,gender from MEMB_INFO where memb___id like '%$search%'";}

if($_POST['search_type']==1){
$result = mssql_query($search_exact);}
if($_POST['search_type']==0){
$result = mssql_query($search_partial);}


echo '<TABLE width=400 border=0 cellPadding=0 cellSpacing=0 >
<br><span class=normal_text><center>Резултат от търсенето</center></span>
<br></br>
<table class="sort-table" id="table-1" height=30 border="0" cellpadding="0" cellspacing="0">
<thead><tr>
<td>ID</td>
<td>Акаунт</td>
<td>Парола</td>
<td>WH pass</td>
<td>Инфо</td>
<td>Статус</td>
<td>Промяна</td>
</tr></thead>
';
for($i=0;$i < mssql_num_rows($result);++$i)
{
$row = mssql_fetch_row($result);
$status_check="Select ConnectStat from MEMB_STAT where memb___id='$row[0]'";
$status_reults = mssql_query($status_check);
$status = mssql_fetch_row($status_reults);
$warehouse="Select pw from warehouse where accountid='$row[0]'";
$warehousepw = mssql_query($warehouse);

$whpw = mssql_fetch_row($warehousepw);

if($status[0] == 0){ $status[0] ='<img src=../images/Offline.gif width=12 height=12>';
}
if($status[0] == 1){ $status[0] ='<img src=../images/Online.gif width=12 height=12 >';
}
if($row[2] == 0){ $row[2] ='Нормален';
}
if($row[2] == 1){ $row[2] ="<table><tr><td bgcolor='yellow'><font color='darkred' size='1'>Баннат</font></td></tr></table>";
}
if($row[4] == 'male'){$row[4] = "<img src='images/male.gif'>";}
elseif($row[4] == 'female'){$row[4] = "<img src='images/female.gif'>";}
elseif($row[4] == NULL){$row[4] = "<table><tr><td bgcolor='FF0000'><font color='#FFFFFF' size='1'>Error #113</font></td></tr></table>";}
if($row[3] == NULL){$row[3] = "<table><tr><td bgcolor='FF0000'><font color='#FFFFFF' size='1'>Error #112</font></td></tr></table>";}
if($row[1] == NuLL){$row[1] = "<table><tr><td bgcolor='FF0000'><font color='#FFFFFF' size='1'>Error #111</font></td></tr></table>";}
$rank = $i+1;

$account_table_edit = "<table width='40' border='0' cellpadding='0' cellspacing='0'>
<tr>
<td width='85'><form action='' method='post' name='account_edit' id='account_edit'>
<input name='Edit' type='submit' id='Edit' value='ДА' class='button'>
<input name='account_search_edit' type='hidden' id='account_search_edit' value=$row[0]>
</form></td>
</tr>
</table>
";

echo "<tbody><tr>
<td align=left>$rank</td>
<td align=left>$row[0]</td>
<td align=left>$row[1]</td>
<td align=left>$whpw[0]</td>
<td align=left>$row[2]</td>


<td align=left><center>$status[0]</center></td>
<td align=left>$account_table_edit</td>
</tr></tbody>";
}
?>
</table>

Ако сте имали такъв проблем помогнете.Отново ви благодаря !
 
Last edited: