[Release] v307 Server files & tools

[count0nz]

my main pc is down right now but i'll help where i can.. Great work all

[kewtrewt]

Use the freaking

CODE TAG

It's so damn hard to read a full page of logs. Or at least attach the log instead of pasting it.

[fazotron712]

How to use MSSQL in this server ?
cuz 307端能登陆帐号，选择角色！但是进游戏搞个什么不存在的游戏线路 - 神魔大陆 - Forsaken World - Mc网游单机下载 - Mcncc.com here gs starts...

[dragonnogard]

anyone having problems with the gshop editor? mine doesnt work so well

[fazotron712]

anyone having problems with the gshop editor? mine doesnt work so well

What exacly ? Don't forgent, that u must change *lua on client pck to set visibility and order of items.

[dragonnogard]

What exacly ? Don't forgent, that u must change *lua on client pck to set visibility and order of items.

when i open gshop with the editor and select any item then it shows a different items stats

[fazotron712]

when i open gshop with the editor and select any item then it shows a different items stats

I'll try at home when will be there =)

[dragonnogard]

seems the gshop editor is bugged

[count0nz]

i've noticed that too..

anyone have a edited gshop / elements files with higher rates ? and different items etc ?

thx

[dragonnogard]

Anyone have a working gshop editor for v307 server? The one in first post is bugged.

[fazotron712]

Anyone have a working gshop editor for v307 server? The one in first post is bugged.

I can write a gshop editor but in 7-14 fays - now I have no time for this. But items u can mail to ure char.

[count0nz]

I can write a gshop editor but in 7-14 fays - now I have no time for this. But items u can mail to ure char.

how do you email items to char? that sounds just what i need :)

no rush i can't code but i am working on some bash scripts.

[fazotron712]

sendmail.jsp - I took it from PW Sendmail and adaptated for FW server.

<%@page import="java.util.*"%>
<%@page import="protocol.*"%>
<%@page import="com.goldhuman.Common.Octets"%>

<%!
	byte[] hextoByteArray(String x)
  	{
    		if (x.length() < 2)
		{
      			return new byte[0];
		}
    		if (x.length() % 2 != 0)
		{
      			System.err.println("hextoByteArray error! hex size=" + Integer.toString(x.length()));
    		}
    		byte[] rb = new byte[x.length() / 2];
   		for (int i = 0; i < rb.length; ++i)
    		{
      			rb[i] = 0;

      			int n = x.charAt(i + i);
      			if ((n >= 48) && (n <= 57))
        			n -= 48;
      			else
				if ((n >= 97) && (n <= 102))
        				n = n - 97 + 10;
      					rb[i] = (byte)(rb[i] | n << 4 & 0xF0);

      					n = x.charAt(i + i + 1);
      					if ((n >= 48) && (n <= 57))
        					n -= 48;
      					else
					if ((n >= 97) && (n <= 102))
        					n = n - 97 + 10;
      				rb[i] = (byte)(rb[i] | n & 0xF);
    	}
    	return rb;
  }
%>

<%
	String message = "<br>";
	boolean allowed = false;

		allowed = true;
%>

<%
	if(allowed && request.getParameter("process") != null && request.getParameter("process").compareTo("mail") == 0)
	{
		if(request.getParameter("roleid") != "" && request.getParameter("title") != "" && request.getParameter("content") != "" && request.getParameter("coins") != "" && request.getParameter("itemid") != "" && request.getParameter("itemproctype") != "" && request.getParameter("itemstack") != "" && request.getParameter("itemmaxstack") != "" && request.getParameter("itemexpiredate") != "")
		{
			int roleid = Integer.parseInt(request.getParameter("roleid"));
			String title = request.getParameter("title");
			String content = request.getParameter("content");
			int coins = Integer.parseInt(request.getParameter("coins"));
            int itemid = Integer.parseInt(request.getParameter("itemid"));
            String itemhex = request.getParameter("itemhex");
            int itemproctype = Integer.parseInt(request.getParameter("itemproctype"));
            int itemstack = Integer.parseInt(request.getParameter("itemstack"));
            int itemmaxstack = Integer.parseInt(request.getParameter("itemmaxstack"));
            int itemexpiredate = Integer.parseInt(request.getParameter("itemexpiredate"));
            
			GRoleInventory gri = new GRoleInventory();
            
			if(itemid >= 0)
			{
                gri.id = itemid;
                gri.guid1 = 0;
                gri.guid2 = 0;
                gri.proctype = itemproctype;
                gri.pos = 0;
                gri.count = (short)itemstack;
                gri.max_count = (short)itemmaxstack;
                gri.expire_date = itemexpiredate;
                gri.data = new Octets(hextoByteArray(itemhex));
			}

			if(protocol.DeliveryDB.SysSendMail(roleid, title, content, gri, coins))
			{
				message = "<font color=\"#00cc00\"><b>Mail Send</b></font>";
			}
			else
			{
				message = "<font color=\"#ee0000\"><b>Sending Mail Failed</b></font>";
			}
		}
		else
		{
			message = "<font color=\"#ee0000\"><b>Enter Valid Values</b></font>";
		}
	}
%>

<html>

<head>
	<link rel="shortcut icon" href="../../include/fav.ico">
	<link rel="stylesheet" type="text/css" href="../../include/style.css">
</head>

<body>

<form action="sendmail.jsp?process=mail" method="post">

<table align="center" width="480" cellpadding="2" cellspacing="0" style="border: 1px solid #cccccc;">
	<tr>
		<th height="1" colspan="2" style="padding: 5;">
			<b>SEND MAIL 2</b>
		</th>
	</tr>
	<tr bgcolor="#f0f0f0">
		<td colspan="2" align="center" height="1">
			<% out.print(message); %>
		</td>
	</tr>
	<tr>
		<td height="1">
			Role ID:
		</td>
		<td height="1">
			<input type="text" name="roleid" value="-1" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
	<tr>
		<td height="1">
			Title:
		</td>
		<td height="1">
			<input type="text" name="title" value="PW Staff" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
	<tr>
		<td height="1" valign="top">
			Message:
		</td>
		<td height="1">
			<textarea name="content" rows="5" style="width: 100%; text-align: left;"></textarea>
		</td>
	</tr>
	<tr>
		<td height="1">
			Coins:
		</td>
		<td height="1">
			<input type="text" name="coins" value="0" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
    <tr>
		<td height="1">
			<br />
		</td>
		<td height="1">
			<br />
		</td>
	</tr>
	<tr>
		<td height="1">
			Item ID:
		</td>
		<td height="1">
			<input type="text" name="itemid" value="0" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
	<tr>
		<td height="1">
			Item Hex:
		</td>
		<td height="1">
			<input type="text" name="itemhex" value="" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
    <tr>
		<td height="1">
			Item Proctype:
		</td>
		<td height="1">
			<input type="text" name="itemproctype" value="0" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
    <tr>
		<td height="1">
			Item Stack:
		</td>
		<td height="1">
			<input type="text" name="itemstack" value="0" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
    <tr>
		<td height="1">
			Item Max Stack:
		</td>
		<td height="1">
			<input type="text" name="itemmaxstack" value="0" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
    <tr>
		<td height="1">
			Item Expire Date:
		</td>
		<td height="1">
			<input type="text" name="itemexpiredate" value="0" style="width: 100%; text-align: left;"></input>
		</td>
	</tr>
	<tr bgcolor="#f0f0f0">
		<td colspan="2" align="center" height="1">
			<input type="image" src="../../include/btn_submit.jpg" style="border: 0;"></input>
		</td>
	</tr>
</table>

</form>

</body>

</html>

put in running tomcat ROOT
equip I get from my DB


And who can tell me how to fix GS or else for command Create Creature works properly ?
Whene I create creature it looks like a board =) Who can tell me what to do ? Thanx.

by logs maybe here is problem ?
GM_CMD:cmd_type=9,roleid=8202,number=10,vis_id=7,mob_id=16033

[count0nz]

nice work fazotron712: Care to share an example... i keep geting sendmail error.. useing Role ID on char. from GM's view ID etc.

thx...

[fazotron712]

nice work fazotron712: Care to share an example... i keep geting sendmail error.. useing Role ID on char. from GM's view ID etc.

thx...

what error ? show.