dpbBryan

What l2j server are you using and what is your JRE version? I had the same problem when I was trying to use the latest JRE's with old L2j distrobutions.

I pretty much gave you what you need, have you ever worked with PHP/MySQL or anything related to web development before?

Eh, just stick with eclipse. I personally have tried both ( for python/java ) and eclipse just feels better.

I did of peaking around a bit more and I opened the bitmap in notepad and noticed the following text: DDS | I downloaded nvidia's DDS plugin for photoshop, renamed it from crest_bsdjfasdf.bmp to crest.dds and it opens ok, except theres some extra information with it it seems: My assumption is that it's converted to a dds file via the client and then that byte information is sent via a packet to the server, and the client knows how to read it from there. Maybe perhaps I can just run a batch that converts DDS to bitmap every time a new one is loaded, or something.

This is what your code should look like: <?php $mysql_connect = ( "ip_of_server", "mysql_user", "mysql_password" ); $mysql_select = mysql_select_db( "name_of_l2j_db" ); $player_query = mysql_query( "SELECT char_name FROM characters WHERE online = 1" ); $player_count = mysql_num_rows( $player_query ); echo $player_count; $mysql_connect.close(); ?>

DeVeLoPeR L2JServer L2JFree Npc Creator Can't configure a server right T_T

connect to your mysql database, then: SELECT char_name (or whatever properties you need) FROM characters WHERE online = 1; Then count em.

My idea is that I convert the uploaded bitmaps to .png or .jpg via a graphics library via PHP and make some kind of web management system. However when I try to manually open the bitmap file, I can't do it. I've come across the function that saves the crests to the drive: public boolean savePledgeCrest(int newId, byte[] data) { File crestFile = new File(Config.DATAPACK_ROOT, "data/crests/Crest_" + newId + ".bmp"); try { FileOutputStream out = new FileOutputStream(crestFile); out.write(data); out.close(); _cachePledge.put(newId, data); return true; } catch (IOException e) { _log.log(Level.INFO,"Error saving pledge crest" + crestFile + ":", e); return false; } } Which I trace into RequestSetPledgeCrest.java, but there it doesn't really shed anymore light on the situation. The file itself seems to be stored in a byte array which is read from readB();, but I can't venture any further into this function. I'm using l2aCis interlude. Anybody have any extra information on this?

It means a resource was loaded that isn't actually used. Unless your server is running slow, I wouldn't worry about it.

I guess it's not actually needed, though I know it can really hurt the performance in some cases: "1) Since you are not using an explicit primary key, the mysqld node will end up randomly connecting to whatever ndbd node it happens to choose, from which the transaction is re-routed to the right data nodes. This unnecessary adds (doubles!) network latency. 2) When inserting, fetching the unique autoincrement value acts like a global lock for all inserts. You can parallelize all you want, but it doesn't get any faster. (There is ndb_autoincrement_prefetch_sz to prefetch a number of keys in a batch, but still, always always use primary key.)" Though since it's only a fetch during the load of the server, I guess it's not a big deal.

Oh sorry I read your post wrong. However regardless, if you're a programmer you should have no problem studying the code yourself. Nobody is going to explain the code to you here. I'll tell you this though, The main() function is in GameServer.java

Dude, there's one right in front of you on this very forum.

I think maybe you can check the player packets, I'm not sure otherwise.

I can't help but notice the IRC channel is empty :C Also, I switched from the l2j nightlies to this svn, however I noticed when trying to manually edit sql data: CREATE TABLE `spawnlist` ( `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0', `locx` mediumint(6) NOT NULL DEFAULT '0', `locy` mediumint(6) NOT NULL DEFAULT '0', `locz` mediumint(6) NOT NULL DEFAULT '0', `heading` mediumint(6) NOT NULL DEFAULT '0', `respawn_delay` mediumint(5) NOT NULL DEFAULT '0', `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0' ); The spawnlist table has no key fields. Is this intentional or was it something that was over-looked:

Are you using Eclipse? If so, right click on L2ZoneType and select Open Call Hierarchy You can see all the other zones that use this Check these for examples

Java is based entirely on object oriented programming. You have an object L2ZoneType, which you extend via your new zone class to get the properties such as what happens when people die. You say you've been looking for 2 years, but this can implemented in under 2 hours and fully working probably. The only way you learn by watching other people do things if you already have basic knowledge of what's going on. Don't pretend to be something you're not. Pick up a java book and/or read online tutorials. Once you get the basics you'll be able to make your zone you want it no time.

That's true, and it really shows when people who don't know what they're doing run servers. However, it sounds like you just want to depend on everybody else's knowledge to do what you want and that's not fair to be people who have done all the work for it. My thinking is that if you've tried implementing something and it's not working, then you should ask for help. Analysing what other people do won't help you as much as you think. You should have knowledge of Java and/or other programming languages first. As TrySkell said he's explained it multiple times, and also I just told you what object you need.

I think learning Java ought to be your first step. If you don't know Java, how to plan to be able to do anything with your server? There is a generic L2ZoneType, you create a class that extends that and you can define the behavior of your zone there.

This belongs in client modification I think.

These questions have been answered a thousand times

That's ok, you can see this as a learning experience :P Just read some tutorials about how to connect to MySQL databases from PHP and make some small test programs. This'll also help you in the future to figure out problems such as this.

No, but I think you should take a step back and maybe look at the basics. PHP has built-in functions for communicating with MySQL, so if you're have troubles understanding this problem I think you need to do a bit more homework ^^

Sure, assuming you have the user and password correct as well.

Then replace localhost with the IP of the machine the MySQL server is running on.

http://php.net/manual/en/function.mysql-connect.php If the MySQL server is running from the same machine as the PHP script is running from, localhost is fine, or 127.0.0.1