Jump to content
Araştır
  • Diğer seçenekler ...
Sonuçları bul ...
Sonuçları bul ...
KO Developers Platformuna Hoşgeldin!
Serverus

Seven panel irk jop degistirme sorunu

Önerilen Mesajlar

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

İletiyi paylaş


Link to post
Sitelerde Paylaş
$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'].' :
'.$lang['job'].' :
'.$lang['guvenlikkodu'].' : imgcode.php
'.$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

İletiyi paylaş


Link to post
Sitelerde Paylaş
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.

 

İletiyi paylaş


Link to post
Sitelerde Paylaş
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.

İletiyi paylaş


Link to post
Sitelerde Paylaş

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

İletiyi paylaş


Link to post
Sitelerde Paylaş

×
×
  • Yeni Oluştur...