Jump to content

A4Tech

Inactive Member
 View Profile  See their activity

  • Posts

    50

  • Joined

  • Last visited

  • Feedback

    0%

 Content Type 

Forums

Store

Third Party - Providers Directory

Feature Plan

Release Notes

Docs

Events

Posts posted by A4Tech

    DB syserr

    in Community Support - Questions & Answers

    Posted

    how can i fix the below error ::

    Spoiler

    SYSERR: Dec 14 20:40:12.916344 :: ChildLoop: AsyncSQL: query failed: Column count doesn't match value count at row 1 (query: replace into mob_proto  (vnum, name, locale_name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, resist_claw, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4, sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive) values (101, "??", "Wild Do

     

    [HELP]Patcher / Login.PhP

    in Community Support - Questions & Answers

    Posted

    Hello , on my website when i try to log in it doesn't work ! but i can recover password and create an account ! 

    <div id="content">

	<div class="postui2 text-title">
		<h2>Warning</h2>
	</div>
	<div class="postui2 text-con">
		<div class="con-wrap"><center>
			Don't enter your Account Details on web sites outside of this one.<br/>
			<font size="5">www.worldwarmeitn2.com</font> is our one and only web site (domain)!</center>		</div>
		<div class="postui2 text-end">
		</div>
	</div>
</div>
<div id="content">
<img src="img/sb-mid.png" width="650" height="22" />
			<div class="postui2 text-title">
					<h2>
                    Account Informations</h2>
				
				</div>
				<div class="postui2 text-con">
				<div class="con-wrap">
<?PHP
  if(isset($_GET['do']) && $_GET['do']=="aktivieren" && isset($_GET['hash']) && !empty($_GET['hash'])) {
    if(strlen($_GET['hash'])==32 && $_GET['hash']!=1 && checkAnum($_GET['hash'])) {
      $cmdHash = "SELECT id,web_aktiviert FROM account.account WHERE web_aktiviert='".$_GET['hash']."' AND web_aktiviert!='1' LIMIT 1;";
      $qryHash = mysql_query($cmdHash,$sqlServ);
      
      if(mysql_num_rows($qryHash)) {
      
        $getData = mysql_fetch_object($qryHash);
        $userUpdate = "UPDATE account.account SET web_aktiviert='1',status='OK' WHERE id='".$getData->id."' LIMIT 1;";
        $updateQry = mysql_query($userUpdate,$sqlServ);
        
        if($updateQry) {
          echo'<p class="meldung">Ihr Account wurde erfolgreich aktiviert. Sie k&ouml;nnen sich nun einloggen.</p>';
          echo'<meta http-equiv="refresh" content="1; URL=index.php?s=login"> ';
        }
        else {
          echo'<p class="meldung">Query fehlgeschlagen. Bitte einen Admin kontaktieren!</p>';
        }
        
      }
      else {
        echo'<p class="meldung">Es wurde kein passender Eintrag gefunden. Aktivierung fehlgeschlagen.</p>';
      }
      
    }
    else {
      echo'<p class="meldung">Kein valider Hash!</p>';
    }
  }

  if(!empty($_SESSION['user_id'])) 
  {
	      $cmdStats = "SELECT SUM( player.playtime ) AS ges_spielzeit, COUNT( * ) AS ges_chars, player_index.empire
    FROM player.player
    INNER JOIN player.player_index ON player_index.id = player.account_id
    WHERE player.account_id = '".$_SESSION['user_id']."'
    LIMIT 1";
    
    $qryStats = mysql_query($cmdStats,$sqlServ);
    $getStats = mysql_fetch_object($qryStats);
	    if(!empty($getStats->empire)) {
      $reich = '<img src="img/reiche/'.$getStats->empire.'.png" title="Reich" alt="Reich"/>';
    }
    else {
      $reich='kein Reich ausgew&auml;hlt';
    }
    
	?>
    
     <div id="fuibar">			
<div class="fuibarui fui-title">
<p></p>
</div>
<div class="fuibarui fui-con">
<div class="fui-wrap">
<?php    
    echo'<table width="580px">
	<tr>
	<td width="50%">
	<table>
      <tr>
        <td align="right" width="150"><b>Account ID:</b></th>
        <td><b>'.$_SESSION['user_name'].'</b></td>
      </tr>
	  <tr>
        <td align="right" width="150"><b>Coins:</b></th>
        <td>'.$_SESSION['user_coins'].'</td>
      </tr>
	  <tr>
        <td align="right" width="150"><b>Points:</b></th>
        <td>'.$_SESSION['user_points'].'</td>
      </tr>
      <tr>
        <td align="right"><b>Kingdom:</b></th>
        <td>'.$reich.'</td>
      </tr>
      <tr>
        <td align="right"><b>Characters:</b></th>
        <td>'.$getStats->ges_chars.'</td>
      </tr>
      <tr>
        <td align="right"><b>OnLine Time:</b></th>
        <td>'.$getStats->ges_spielzeit.' Minutes</td>
      </tr>';
    $sqlAcc = "SELECT account.social_id AS loeschcode, safebox.password AS lagerpw
    FROM account.account 
    LEFT JOIN player.safebox 
    ON account.id=safebox.account_id 
    WHERE account.id='".$_SESSION['userid']."'";

    $qryAcc = mysql_query($sqlAcc) or die(mysql_error());
    $getAcc = mysql_fetch_object($qryAcc);
    
    if(empty($getAcc->lagerpw)) $getAcc->lagerpw = '000000';
      
      echo'<tr>
        <td align="right"><b>Char Delete Code:</b></th>
        <td>'.$getAcc->loeschcode.'</td>
      </tr>
    </table>
	</td>
	<td><font color="yellow">Remember: <br/><b>Your account is Your Responsibility</b></font><br/>You should <u><b>not share</b></u> your account <br/>with noone! Staff will never ask for <br/>your password! Staff members <br/>have [GM], [GA] or [A] in front <br/>of their names, <font color="yellow"><b>not |GM| or similar</b></font><br/><br/>Note: 100 Points = 100 Coins!</td></tr></table>';
   ?>
</div>
</div> 
<div class="fuibarui fui-end">
</div></div>

    
    

<?php
  }
  else 
  {
  ?>
<center><h2>Login</h2>

<form action="index.php?s=login" method="POST">
  <table width="60%">
    <tr>
      <th class="topLine">Account ID:</th>
      <td class="tdunkel"><input type="text" name="userid" maxlength="16" size="20"/></td>
    </tr>
    <tr>
      <th class="topLine">Password:</th>
      <td class="thell"><input type="password" name="userpass" maxlength="16" size="20"/></td>
    </tr>
    <tr>
      <td class="topLine" style="text-align:center;" colspan="2"><input type="submit" name="submit" value="login"/></td>
    </tr>
  </table>
  <p><a href="index.php?s=register">New ? Register!</a> &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; <a href="index.php?s=lostpw">Forgot Password ?</a></p>
</form></center>
  <?PHP
  }
  ?>
  
				</div>

  </div> 
				<div class="postui2 text-end">
           
                
                  
    </div></div>

    And about the patch i tried to use the official patch and actually it did work but i get an error related to *crclist* , i created the newcrclist using the tool and also i did their Lzpack but i still get this error Capture.JPG.6046b27d5da786c836bf3e4e65386d64.JPG

    [HELP]Anti_Exp

    in Community Support - Questions & Answers

    Posted

    9 hours ago, tierrilopes said:

    Because that is not any exp blocker at all.

    If you want to block exp, make a ring like that sure, but having it to change the value of a quest_flag, for example:

    BLOCK_EXP 1    to turn it on

    BLOCK_EXP 0   to turn it off

     

    And then in your source, at CASE_EXP:

    You check if the player has a quest_flag of BLOCK_EXP = 1, if the player does, then you do a return at the begining so that it ignores all the exp processing.

    Thats the only way to really block exp gain, the one you added was used before source appeared and it was already crap, because if the exp you gain is higher then your exp required to level up, you will level up first and then it will remove you the exp.

    @tierrilopes is it possible to tell me how can i exactly add the block_exp and the case_exp in my source ? because i am not expert in those things and thank you in advance.

    [HELP]Anti_Exp

    in Community Support - Questions & Answers

    Posted

    i tried to add the anti_exp ring ... however the quest is working fine but once i activated it then try to kill a mob ... i suddenly gain like 20/30 levels ... why ?

     

    Quote 
    
-- Anti-Exp Ring by Shogun for WoM (c) 2013
quest exp_curse begin
	state start begin
		when 70210.use begin
			pc.setqf("lastexp",pc.get_exp())
			syschat("You are under the curse of the goddess. You will gain no experience.")
			set_state(use)
		end
	end
	
	state use begin
		when 70210.use begin
			syschat("You lifted the curse of the goddess. You gain experience again.")
			set_state(start)
		end
		
		when login begin
			syschat("You are currently under the curse of the goddess and gain no experience.")
		end
		
		when kill or party_kill begin
			local current = pc.get_exp()
			local doll = pc.count_item(70210)
			if doll == 0 then
				syschat("The curse of the Goddess has lifted. You will gain Experience again.")
				set_state(start)
			end
			if current < pc.getqf("lastexp") then
				pc.setqf("lastexp",current)
			end
			if not npc.is_pc() then
				local dif = pc.get_exp()-pc.getqf("lastexp")
				pc.give_exp2(-dif)
			end
		end
	end
end

     

×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.