Sunzuke

most of the faults are in the grammar but there are spelling mistakes, too. np

change 4705#¿ëÀǺ¸ÁÖ_È«# in your idnum2itemresnametable.txt and add the wished .bmp in \data\texture\À¯ÀúÀÎÅÍÆäÀ̽º\item\ (don't forget the sprites, but I think this display is just the missing bmp image)

http://www.youtube.com/watch?annotation_id=annotation_171105&feature=iv&src_vid=f06EBENhV84&v=3LTOOEjRtUo http://rathena.org/board/topic/84621-rathena-rev17526-compiled/ http://rathena.org/board/topic/84746-tutorial-how-to-create-ragnarok-offline-2013-client-tutorial/ http://rathena.org/wiki/Getting_Started

dass man sich bei der schrift überhaupt noch über artikel aufregt xD nur so nebenbei, ich ahne ja sowieso schon chaos, aber, falls die script vom Posted 03 October 2013 - 04:26 PM zzt. überhaupt noch relevant ist: statt for(set .@i,1; .@i <= .@nb; set .@i,.@i+1) mes "Acc ID: "+.@account_id$[.@i]+" Anzahl v4p "+.@anzahlid$[.@i]; sollte es heissen for(set .@i,0; .@i < .@nb; set .@i,.@i+1) mes "Acc ID: "+.@account_id$[.@i]+" Anzahl v4p "+.@anzahlid$[.@i]; da arrays mit dem index 0, nicht 1, beginnen

$sql_ip = "".$_SERVER['SERVER_ADDR'].""; $sql_user = "ragnarok"; $sql_pass = "ragnarok"; $sql_db = array( 'ragnarok' ); //Warning: Be sure not to use POST variables inside the query because of SQL Injection $itemid = 4363; $string = "WHERE `nameid` LIKE '".$itemid."' OR `card0` LIKE '".$itemid."' OR `card1` LIKE '".$itemid."' OR `card2` LIKE '".$itemid."' OR `card3` LIKE '".$itemid."'"; $sql = mysql_connect($sql_ip, $sql_user, $sql_pass); if(!$sql) die("Failed to connect to $sql_ip SQL Server.<br>"); $query = mysql_query("SHOW DATABASES"); $dbss = array(); $db = array(); while($row = mysql_fetch_array($query)) $dbss[] = "".$row[0].""; foreach($sql_db as $dbs) { if(!in_array($dbs, $dbss)) die("Database $dbs has not been found on the server.<br>"); $query = mysql_query("SHOW TABLES FROM `$dbs`"); while($row = mysql_fetch_array($query)) $db[$row[0]] = $dbs; } heres the script for the amount of items ingame $amt = 0; $query = mysql_query("SELECT * FROM ".$db['inventory'].".`inventory` ".$string.""); while ($row = mysql_fetch_object($query)) {$amt += $row->amount;} $query = mysql_query("SELECT * FROM ".$db['cart_inventory'].".`cart_inventory` ".$string.""); while ($row = mysql_fetch_object($query)) {$amt += $row->amount;} $query = mysql_query("SELECT * FROM ".$db['storage'].".`storage` ".$string.""); while ($row = mysql_fetch_object($query)) {$amt += $row->amount;} echo "Item ID ".$itemid." exists ".$amt." times!"; heres the script for the amount of player owning the item (not counting the storage) $ItemOwner = array(); $query = mysql_query("SELECT * FROM ".$db['cart_inventory'].".`cart_inventory` ".$string.""); while ($row = mysql_fetch_object($query)) { if(!in_array($row->char_id, $ItemOwner)) $ItemOwner[] = $row->char_id; } $query = mysql_query("SELECT * FROM ".$db['inventory'].".`inventory` ".$string.""); while ($row = mysql_fetch_object($query)) { if(!in_array($row->char_id, $ItemOwner)) $ItemOwner[] = $row->char_id; } echo "".count($ItemOwner)." Player own Item ID: ".$itemid."";

bei mir funktionieren beide links nicht

You could use a variable to save the infos... but..: "$" - A global permanent variable. They are stored in database table `mapreg`. http://svn.code.sf.net/p/rathena/svn/trunk/doc/script_commands.txt They use sql too - - - - I don't think rAthena supports asort(), arsort(), krsort() or ksort() You could ask in the src section if someone would add it for you then you could do it like this: set $rank[<charid>],<value>; and then use arsort() and pick the first 10 entires

// Display some mob info next to their name? (add as needed) // (does not works on guardian or Emperium) // 1: Display mob HP (Hp/MaxHp format) // 2: Display mob HP (Percent of full life format) // 4: Display mob's level show_mob_info: 2 http://svn.code.sf.net/p/rathena/svn/trunk/conf/battle/monster.conf

maybe they set a cookie when you are banned and then check if the cookie exists as you said ips change too often to check for them

Hey.. setting all mobs to lvl 50 seems a bit hard to do manually I wrote you a php script to which does it for you http://www.file-upload.net/download-8139132/mobdb.rar.html it contains a default renewal mob db with max monster lvl 50 too here's the code found in the rar file: <?php $index = str_replace('\\', '/', realpath(dirname(__FILE__))); $LV = 50; $original_mob = "ID,Sprite_Name,kROName,iROName,LV,HP,SP,EXP,JEXP,Range1,ATK1,ATK2,DEF,MDEF,STR,AGI,VIT,INT,DEX,LUK,Range2,Range3,Scale,Race,Element,Mode,Speed,aDelay,aMotion,dMotion,MEXP,MVP1id,MVP1per,MVP2id,MVP2per,MVP3id,MVP3per,Drop1id,Drop1per,Drop2id,Drop2per,Drop3id,Drop3per,Drop4id,Drop4per,Drop5id,Drop5per,Drop6id,Drop6per,Drop7id,Drop7per,Drop8id,Drop8per,Drop9id,Drop9per,DropCardid,DropCardper"; $original_mob = explode(',', $original_mob); $mob_db = file("".$index."/mob_db.txt"); foreach($mob_db as $mob) { $mob2 = explode(',', $mob); if(substr($mob, 0, 2) != "//" && count($mob2) == count($original_mob)) { for($i = 0; $i < count($mob2); $i++) $mobs[$original_mob[$i]] = $mob2[$i]; $end = 0; foreach($original_mob as $key) { if(strpos(nl2br($mobs[$key]), '<br />') !== false) { $mobs[$key] = "".str_replace('<br />', '', nl2br($mobs[$key])).""; $end = 1; } if(empty($$key)) { echo "".$mobs[$key].""; } else { if($$key < $mobs[$key]) { echo "".$$key.""; } else { echo "".$mobs[$key].""; } } if($end == 1) { echo "<br>"; $end = 0; } else { echo ","; } } } else { echo "$mob<br>"; } } ?>

This line is kinda awkward } else if ( getmapguildusers( getcharid(0) ) == getcharid(0) ) { why should the amount of users on the map match the guild id o.O? there is just one given value too although it's 2 in the doc getmapguildusers("<map name>",<guild id>) ... I think it should work like this: invek,144,175,5 script WoE Prize 734,{ if ( agitcheck() ) { mes "A war is currently in progress"; mes "If your guild owned a castle ask your guild master to see me to claim the reward"; close; } while(.castlename$[set(.@a,.@a+1)]!="") if ( getcastledata( .castlename$[.@a],1 ) == getcharid(2) ) { if ( $castle_claimed[.@a] ) { mes "your guild already received the reward"; close; } else { mes "receiving the reward for "+ .castlename$[.@a]; getitem 12035,1; // some mathematics ... set $castle_claimed[.@a],1; close; } } mes "Your guild failed to take reward"; mes "if your guild owned a castle your can claim the reward from me"; close; OnAgitEnd: deletearray $castle_claimed[0], 128; // everytime woe ends the variable resets end; OnInit: setarray .castlename$[1], "aldeg_cas01", "aldeg_cas02", "aldeg_cas03", "aldeg_cas04", "aldeg_cas05", "gefg_cas01", "gefg_cas02", "gefg_cas03", "gefg_cas04", "gefg_cas05", "payg_cas01", "payg_cas02", "payg_cas03", "payg_cas04", "payg_cas05", "prtg_cas01", "prtg_cas02", "prtg_cas03", "prtg_cas04", "prtg_cas05", "arug_cas01", "arug_cas02", "arug_cas03", "arug_cas04", "arug_cas05"; waitingroom "WOE Prize Giver",0; end; } I think this script is buggy when you have two castles, too. it will only give you the reward for one btw: nice music taste <3

I don't know how to get the monstres position besides patskies script but you could use the players position OnNPCKillEvent: if(killedrid == <monster id>) { attachrid(killerrid); if(getmapxy(@mapname$,@mapx,@mapy,0,"""+strcharinfo(0)+"")!=0) end; set @mapx,@mapx+rand(-15,15); if(@mapx < 0) set @mapx,0; set @mapy,@mapy+rand(-15,15); if(@mapy < 0) set @mapy,0; makeitem "<item name>",<amount>,""+@mapname$+"",@mapx,@mapy; } end; (not tested)

du hast halt alle drops auf 0 gesetzt / deaktiviert. ich hab mirn kurzes php script geschrieben um zu gucken ob die kommata richtig gesetzt sind: das resultat war:

<script> function reload(target, site) { var ajaxRequest; try { ajaxRequest = new XMLHttpRequest(); } catch (e) { try { ajaxRequest = new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { ajaxRequest = new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { alert("Your browser broke!"); return false; } } } ajaxRequest.onreadystatechange = function() { if(ajaxRequest.readyState == 4) { var ajaxDisplay = document.getElementById(""+target+""); ajaxDisplay.innerHTML = ajaxRequest.responseText; } } ajaxRequest.open("GET", "/"+site+"/", true); ajaxRequest.send(null); } </script>

I think it's because your timezone is before the servers timezone so your edit makes the root think the file is edited in the future you may fix this problem by running the command: touch /root/Destop/trunk/src/*