Seven panel irk jop degistirme sorunu

[Serverus 7]

Seven panel irk jop degistirme sorunu
merhaba arkadaslar seven panelden irk jop degistirme yapiyorum jop degistirmede hic bir sey olmuyor char ayni irk degistirmede irkini degistiriyor ama char görünmüyor desteyinizi bekliyorum elinde bide banka sifirlama kodu olan varsa panele eklicem

[MOMENTUM 334]

Merhabalar, ırk ve job değiştirme php dosyalarını atarsan bir bakalım

[Serverus 7]

$sevendbo->doquery("SELECT ClassStatus,ClassCash FROM _PUSSETTINGS");

			$ClassStatus = $sevendbo->result(1);

			$ClassCash = $sevendbo->result(2);

				if($ClassStatus == 0):

					echo ''.$lang['kullanimdisi'].'';

				else:

					$sevendbo->doquery("select StrCharID1, StrCharID2, StrCharID3, bNation from ACCOUNT_CHAR where StrAccountID = '".$_SESSION['SeveNUser']."'");

					$char1 = $sevendbo->result(1);

					$char2 = $sevendbo->result(2);

					$char3 = $sevendbo->result(3);

					$bNation = $sevendbo->result(4);

						if(!$char1 and !$char2 and !$char3):

							$sevendbo->uyari(''.$lang['karakterinyok'].'');

							$sevendbo->yonlendir(''.$base_url.'usercp/pus',0);

						else:

							echo ''.$lang['jobchange'].'';

							echo '

'.$lang['karakter'].'	:	'; if($char1 ''): echo ''.trim($char1).''; else: endif; if($char2 ''): echo ''.trim($char2).''; else: endif; if($char3 ''): echo ''.trim($char3).''; else: endif; echo'
'.$lang['job'].'	:	'; if($bNation == 1): echo 'Karus Warrior Karus Rogue Karus Magician Karus Kadin Priest Karus Erkek Priest'; elseif($bNation == 2): echo 'Human Barbar Warrior Human Ince Warrior Human Kadin Warrior Human Erkek Rogue Human Kadin Rogue Human Erkek Mage Human Kadin Mage Human Erkek Priest Human Kadin Priest'; endif; echo'
'.$lang['guvenlikkodu'].'	:
'.$lang['guvenlikkodu2'].'	:

';
$sevendbo->doquery("SELECT CashPoint FROM TB_USER WHERE StrAccountId = '$username'");
$cashiniz = $sevendbo->result(1);
echo ''.$lang['jobbakiye1'].' '.$ClassCash.', '.$lang['jobbakiye2'].' '.$cashiniz.'';

if(isset($_POST['submit'])):
$sevendbo->doquery("SELECT durum,inventory FROM _BASLANGIC_ITEMLERI");
$durum_b = $sevendbo->result('durum');
$inventory = $sevendbo->result('inventory');
if($durum_b == 1)
{
$sevendbo->doquery("select Warrior, Rogue, Mage, Priest from _BASLANGIC_ITEMLERI");
$Warrior = trim($sevendbo->result('Warrior'));
$Rogue = trim($sevendbo->result('Rogue'));
$Mage = trim($sevendbo->result('Mage'));
$Priest = trim($sevendbo->result('Priest'));
}
$char = $sevendbo->SQLSecurity($_POST['karakter']);
$job = $sevendbo->SQLSecurity($_POST['job']);
$gkod = $sevendbo->SQLSecurity($_POST['gkod']);
if($char == 1):
$char = $char1;
elseif($char == 2):
$char = $char2;
elseif($char == 3):
$char = $char3;
endif;

$sevendbo->doquery("select Nation from USERDATA where StrUserID = '".$char."'");
$nation = $sevendbo->result(1);

if($job == 1 and $nation == 1): // Karus Warrior
$nclass = "106";
$race = "1";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Warrior."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Warrior}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 2 and $nation == 1): // Karus Rogue
$nclass = "108";
$race = "2";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Rogue."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Rogue}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 3 and $nation == 1): // Karus Mage
$nclass = "110";
$race = "3";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Mage."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Mage}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 4 and $nation == 1): // Karus Kadin Priest
$nclass = "112";
$race = "4";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Priest."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Priest}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 5 and $nation == 1): // Karus Erkek Priest
$nclass = "112";
$race = "2";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Priest."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Priest}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 1 and $nation == 2): // Human Barbar Warrior
$nclass = "206";
$race = "11";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Warrior."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Warrior}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 2 and $nation == 2): // Human Ince Warrior
$nclass = "206";
$race = "12";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Warrior."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Warrior}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 3 and $nation == 2): // Human Kadin Warrior
$nclass = "206";
$race = "13";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Warrior."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Warrior}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 4 and $nation == 2): // Human Erkek Rogue
$nclass = "208";
$race = "12";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Rogue."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Rogue}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 5 and $nation == 2): // Human Kadin Rogue
$nclass = "208";
$race = "13";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Rogue."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Rogue}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 6 and $nation == 2): // Human Erkek Mage
$nclass = "210";
$race = "12";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Mage."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Mage}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 7 and $nation == 2): // Human Kadin Mage
$nclass = "210";
$race = "13";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Mage."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Mage}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 8 and $nation == 2): // Human Erkek Priest
$nclass = "212";
$race = "12";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Priest."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Priest}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
elseif($job == 9 and $nation == 2): // Human Kadin Priest
$nclass = "212";
$race = "13";
if($durum_b == 1 and $inventory == 0)
{
$stritem = ", StrItem = (SELECT StrItem FROM USERDATA WHERE StrUserID = '".$Priest."')";
}elseif($durum_b == 1 and $inventory == 1){
// ITEMLERI BUL
$ww=1;
while($ww

$sevendbo->doquery("
SELECT

cast(cast(substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 4,
1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 3, 1)+substring(cast(substring(strItem, {$ww},4) as
varbinary(4)), 2, 1)+substring(cast(substring(strItem, {$ww},4) as varbinary(4)), 1, 1) as varbinary(4)) as int(4)) as ItemId

FROM USERDATA WHERE STRUSERID = '{$Priest}';
");
$ItemNO = $sevendbo->result(1);

$canisi = "EXEC INSERTITEM '{$username}',{$ItemNO},1;";
$cani = str_replace("EXEC INSERTITEM '{$username}',0,1;","",$canisi);
$sevendbo->doquery($cani);
$ww=$ww+8;
endwhile;
}else{}
endif;
$sevendbo->doquery("SELECT CashPoint FROM TB_USER WHERE StrAccountId = '$username'");
$cashim = $sevendbo->result(1);
if($cashim $sevendbo->uyari(''.$lang['yetersizbakiye'].'');
$sevendbo->yonlendir(''.$base_url.'usercp/pus/job',0);
elseif($gkod $_SESSION["security_code"]):
$sevendbo->uyari(''.$lang['gyanlis'].'');
$sevendbo->yonlendir(''.$base_url.'usercp/pus/job',0);
else:
$sevendbo->doquery("select count(*) from CURRENTUSER where StrCharID = '".$char."'");
$oyundami = $sevendbo->result(1);
$sevendbo->doquery("select count(*) as clanda_mi from knights_user where struserid = '{$char}'");
$clanda_mi = $sevendbo->result('clanda_mi');
if($oyundami > 0):
$sevendbo->uyari(''.$lang['oyundancik'].'');
$sevendbo->yonlendir(''.$base_url.'usercp/pus/job',0);
elseif($clanda_mi > 0):
$sevendbo->uyari('Lütfen Clandan Çıkınız!');
$sevendbo->yonlendir(''.$base_url.'usercp/pus/job',0);
else:
$sevendbo->doquery("UPDATE USERDATA set Race = '$race', Class = '$nclass' {$stritem} where StrUserID = '$char'");
$sevendbo->doquery("update tb_user set CashPoint = CashPoint - '$ClassCash' where StrAccountID = '".$_SESSION['SeveNUser']."'");
$sevendbo->uyari(''.$lang['islembasarili'].'');
$sevendbo->yonlendir(''.$base_url.'usercp/pus/job',0);
endif;
endif;
else:

endif;
endif;
endif;
?>
-- mesaja ek olarak --
Sorun databasede dicem cok databaseden kodunu aldim cözemedim demekki php ile kaynakli

[snmaster 18]

hiç bir hata vermiyor mu?

Alıntı

_BASLANGIC_ITEMLERI

tablosu olmayabilir dbde yada

 

Alıntı

INSERTITEM

proseduru olmayabilir.

[Serverus 7]

arkadaslar biriniz su php kodunu düzgün bir şekilde verebilirmisiniz kafayı yicem sonunda panelde degistirdim ayni sorun

[Forathdor 57]

Alıntı

arkadaslar biriniz su php kodunu düzgün bir şekilde verebilirmisiniz kafayı yicem sonunda panelde degistirdim ayni sorun

 

Kardeşim prosedürlerin eksik arkadaş demiş zaten eksik prosedürlerin bazılarını muhtemelen

NATION_CHANGE
USER_NAME_CHANGE

prosedürleri eksik istediğin kadar php değiştir farketmez önce prosedürleri dbne ekle bende yok fakat forumda paylaşılan dblerden alabilirsin.

 

[snmaster 18]

Alıntı

arkadaslar biriniz su php kodunu düzgün bir şekilde verebilirmisiniz kafayı yicem sonunda panelde degistirdim ayni sorun

Üslubun çok yanlış biz yardım etmeye çalışıyoruz sen düzgün php kodu istiyorsun:). O kod zaten indirdiğin şekildeyse düzgündür.Hata hakkında hiç bir bilgi vermiyorsun sorduğum sorulara cevap yok neyse sen php kodlarını değiştir belki çözersin.

[Serverus 7]

ben konuda zaten söyledim jop degistiriyorum degistirmiyor hatada vermiyor ırk degistiriyorum char görünmüyor neden anlamadım anlamıyorum üslubum gayet iyi saolun yardiminiz icin