-
Posts
555 -
Joined
-
Last visited
-
Days Won
7 -
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Everything posted by wongerlt
-
Help Connecting website to db
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
so create new mysql account. CREATE USER 'USER1'@'%' IDENTIFIED BY 'PASSWORD1'; and grant privileges for this user: GRANT ALL ON *.* TO 'USER1'@'%'; '%' - this mean for all ip address allow connect. you can change it example to your website ip for security. -
Help Connecting website to db
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
mysql and website on same pc? -
Help Add pages to droplist.
wongerlt replied to sotid's question in Request Server Development Help [L2J]
try this maybe it will work: else if (_command.startsWith("DropListNpc")) { private static void showItemsPage(Player activeChar, int page) { final L2Object object = activeChar.getTarget(); int MaxItemsPerPage = 10; int MaxPages = _itemssize / maxItemsPerPage; if (_itemssize > MaxItemsPerPage * MaxPages) MaxPages++; if (page > MaxPages) page = MaxPages; int ItemsStart = MaxItemsPerPage * page; int ItemsEnd = _itemssize(); if (ItemsEnd - ItemsStart > MaxItemsPerPage) ItemsEnd = ItemsStart + MaxItemsPerPage; if (object instanceof L2NpcInstance) { NpcHtmlMessage html = new NpcHtmlMessage(0); StringBuilder html1 = new StringBuilder("<html>"); html1.append("<title>Npc Name: " + object.getName() + "</title>"); html1.append("<body>"); html1.append("<br>"); html1.append("<table cellspacing=2 cellpadding=1 width=\"280\">"); if (((L2NpcInstance) object).getTemplate().getDropData() != null) { int myPage = 1; int i = 0; int shown = 0; boolean hasMore = false; for (L2DropCategory cat : ((L2NpcInstance) object).getTemplate().getDropData()) { if (shown == MaxItemsPerPage) { hasMore = true; break; } for (L2DropData drop : cat.getAllDrops()) { final L2Item item = ItemTable.getInstance().getTemplate(drop.getItemId()); if (item == null) continue; if (myPage != page) { i++; if (i == MaxItemsPerPage) { myPage++; i = 0; } continue; } if (shown == MaxItemsPerPage) { hasMore = true; break; } int mind = 0, maxd = 0; String smind = null, smaxd = null; String name = item.getName(); if (cat.isSweep()) { mind = (int) (Config.RATE_DROP_SPOIL * drop.getMinDrop()); maxd = (int) (Config.RATE_DROP_SPOIL * drop.getMaxDrop()); } else if (drop.getItemId() == 57) { mind = 300 * drop.getMinDrop(); maxd = 300 * drop.getMaxDrop(); } else { mind = (int) (Config.RATE_DROP_ITEMS * drop.getMinDrop()); maxd = (int) (Config.RATE_DROP_ITEMS * drop.getMaxDrop()); } if (mind > 999999) { DecimalFormat df = new DecimalFormat("###.#"); smind = df.format(((double) (mind)) / 1000000) + " KK"; smaxd = df.format(((double) (maxd)) / 1000000) + " KK"; } else if (mind > 999) { smind = ((mind / 1000)) + " K"; smaxd = ((maxd / 1000)) + " K"; } else { smind = Integer.toString(mind); smaxd = Integer.toString(maxd); } if (name.startsWith("Common Item - ")) { name = "(CI)" + name.substring(14); } if (name.length() >= 34) { name = name.substring(0, 30) + "..."; } html1.append("<tr>"); html1.append("<td valign=top align=center height=38 width=40><img src=\"" + getIcon(item.getItemId()) + "\" height=32 width=32></td>"); html1.append("<td>"); html1.append("<table cellpadding=0 cellspacing=1 width=237>"); html1.append("<tr>"); html1.append("<td>" + (drop.getChance() >= 10000 ? (double) drop.getChance() / 10000 : drop.getChance() < 10000 ? (double) drop.getChance() / 10000 : "N/A") + "% is " + (drop.isQuestDrop() ? "<font color=\"00b3b3\">[Quest]</font>" : (cat.isSweep() ? "<font color=\"009900\">[Spoil]</font> " : "[Drop]")) + "</td>"); html1.append("</tr>"); html1.append("<tr>"); html1.append("<td>Name: <font color=fff600>" + name + "</font> " + (maxd == 1 ? "[1]" : "[" + smind + " - " + smaxd + "]") + "</td>"); html1.append("</tr>"); html1.append("</table>"); html1.append("</td>"); shown++; } } } for (int x = 0; x < MaxPages; x++) { int pagenr = x + 1; if (page == x) { pages += "<td>Page " + pagenr + "</td>"; } else { pages += "<td>something " + something() + " " + x + "\">Page " + pagenr + "</a></td>"; } } } html1.append("</tr></table>"); html1.append("</body>"); html1.append("</html>"); html.setHtml(html1.toString()); activeChar.sendPacket(html); html1 = null; html = null; } } -
try this member.addItem("Party", itemId , (int) count, player, true);
-
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
you have router? if yes then pm me ur skype i will help u. -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
why u write l2virus .ddns .net? you redirect l2virus.ddns.net to your external ip?? -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
to check server is working for others you can here: https://www.infobyip.com/tcpportchecker.php write external your ip and port 2106 or 7777 -
LF any1 help for this
wongerlt replied to StarLineageServer's topic in Coding Discussions & Requests
it can be wrong image url or something else. send to pm url and i tell u what wrong -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
you can login if change ip to 127.0.0.1 in l2.ini and other l2.ini with external ip for others -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
if server are on your pc you cant login with external ip, only others can login but not you. -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
ServerAddr =l2virus.ddns.net change to ServerAddr =127.0.0.1 -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
wtf why u try add l2virus.ddns.net?? show l2.ini from client -
Help Problem making the server public
wongerlt replied to Guarder's question in Request Server Development Help [L2J]
delete your lines from hosts file. to ExternalHostname write ur external ip. and connect to server with ur local ip (127.0.0.1) if your server are on same network. external ip is for public not for you. -
LF Mana Potions Auto
wongerlt replied to audriuziz's question in Request Server Development Help [L2J]
just tell me where u stuck -
Discussion VPS for hosting server
wongerlt replied to alcohol's topic in Server Development Discussion [L2J]
Same situation just lost 50$. -
LF Mana Potions Auto
wongerlt replied to audriuziz's question in Request Server Development Help [L2J]
yes it working on l2jfrozen, im tested it on l2jfrozen. -
LF any1 help for this
wongerlt replied to StarLineageServer's topic in Coding Discussions & Requests
give me url and i tell u what here wrong. -
Help Auto Vote Reward ->Network
wongerlt replied to sotid's question in Request Server Development Help [L2J]
this line: votes = Integer.valueOf(inputLine.split(">")[2].replace("</b", "")); change to: votes = Integer.valueOf(inputLine.split(">")[2].replace("</b", "").replaceAll(",","")); -
Help Auto Vote Reward ->Network
wongerlt replied to sotid's question in Request Server Development Help [L2J]
and uncomment this lines // e.printStackTrace(); remove slashes from start. and try again. -
Help Auto Vote Reward ->Network
wongerlt replied to sotid's question in Request Server Development Help [L2J]
what url vote? -
Help Problem with announcement.
wongerlt replied to sotid's question in Request Server Development Help [L2J]
then u can make like this: 2033 1 [Hopzone] Current Votes: $s1 0 79 CC E5 FF 8 0 3 1 0 [Hopzone] Current Votes: $s1 server 100% all will see :D -
Help Problem with announcement.
wongerlt replied to sotid's question in Request Server Development Help [L2J]
hmm i think not possible, but what point to flood on down? :D very nervous while you chating and server messages start going to bottom tab. -
Help Problem with announcement.
wongerlt replied to sotid's question in Request Server Development Help [L2J]
2033 1 [Hopzone] Current Votes: $s1 0 79 CC E5 FF 0 0 0 0 0 none change to 2 2033 1 [Hopzone] Current Votes: $s1 2 79 CC E5 FF 0 0 0 0 0 none -
Help Problem with announcement.
wongerlt replied to sotid's question in Request Server Development Help [L2J]
You can make it with systemmsg.dat and choose any color you want in rgb example: SystemMessage sm = new SystemMessage(2033); // 2033 - id from systemmsg-e.dat sm.addString(Integer.toString(hopzone_votes)); Broadcast.toAllOnlinePlayers(sm); // example 2033, add this line to systemmsg-e.dat // 2033 1 [Hopzone] Current Votes: $s1 0 79 CC E5 FF 0 0 0 0 0 none // R = 79, G = CC , B = E5 , aplha = FF with this shit u can save and server bandwidth. :D -
Help acis stuck character
wongerlt replied to alcohol's question in Request Server Development Help [L2J]
maybe somewhere infinite loop, try debug with l2phx on what packet it stuck.
