camenomat0
-
Posts
1,095 -
Credits
0 -
Joined
-
Last visited
-
Days Won
20 -
Feedback
0%
Content Type
Articles
Profiles
Forums
Store
Posts posted by camenomat0
-
-
59 minutes ago, Evie Frye said:
I made you a quick code, is up to you how to use it e.t.c
package com.l2evie.gameserver; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; import java.sql.SQLException; import com.l2evie.L2DatabaseFactory; import com.l2evie.gameserver.model.actor.instance.L2PcInstance; /** * @author Evie Frye */ public class Color { private static Color _instance = null; public static Color getInstance() { if (_instance == null) { _instance = new Color(); } return _instance; } /** * @param objectId * @return */ public void setColor(final L2PcInstance activeChar) { Integer[] holder = null; try(Connection con = L2DatabaseFactory.getInstance().getConnection()) { ResultSet result = con.prepareStatement("SELECT hexName, hexTitle FROM character_color_table WHERE objectId = " + activeChar.getObjectId()).executeQuery(); if (result.next()) { holder = new Integer[]{(Integer.parseInt(result.getString("hexName"))), Integer.parseInt(result.getString("hexTitle"))}; } } catch(SQLException e) { return; } if (holder !=null) { activeChar.getAppearance().setNameColor(holder[0]); activeChar.getAppearance().setTitleColor(holder[1]); activeChar.broadcastUserInfo(); } } /** * * @param objectId */ public void storeColor(final L2PcInstance activeChar) { try(Connection con = L2DatabaseFactory.getInstance().getConnection()) { PreparedStatement statement = con.prepareStatement("INSERT INTO character_color(objectId, hexName, hexTitle) values(?,?,?) ON DUPLICATE KEY UPDATE hexColor=?"); statement.setInt(1, activeChar.getObjectId()); statement.setInt(2, activeChar.getAppearance().getNameColor()); statement.setInt(3, activeChar.getAppearance().getNameColor()); statement.execute(); } catch(SQLException e) { } } }And the SQL:
/* MySQL Data Transfer Source Host: localhost Source Database: l2jgs Target Host: localhost Target Database: l2jgs Date: 4/3/2018 9:18:52 PM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for character_color -- ---------------------------- DROP TABLE IF EXISTS `character_color`; CREATE TABLE `character_color` ( `objectId` int(10) NOT NULL, `hexName` text NOT NULL, `hexTitle` text NOT NULL, PRIMARY KEY (`objectId`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;Consider those should load once upon server start and server shutdown to avoid connection everytime a player login and logout but nowadays with so fast queries and store procedures nobody cares.
To use the code just go on EnterWorld and write
Color.getInstance().setColor(activeChar);and to store go in L2PcInstance, find cleanMe method and somewhere inside write:
Color.getInstance().storeColor(this);best!
-
how many on?
-
not enough competition,most areas look empty,mc rate is like 5x in some classes... plus adena bug in 2k18? Buy A weapon 10kk adena from gm shop and sell it 13.5 ? ;D nice..
also pvp kill don't drop pvp medals,inside or outside of pvp zones...anchor ,fear, stun 100% for like 40 secs.. why open servers like that? ;DD
-
it's up,but still 20-30 online .. sad.
-
why is down for long time? :(
-
why talk that bad for the legend Evie ? :(
-
10 hours ago, L2Insane said:
200+ Online at prime time,
there is no way to be 200 on while olympiad games barely start,still no update and lots of bugs and unbalance game exist around.
-
1
-
-
5 hours ago, EmoTioN said:
I get that codes. how fix it?
not sure,but maybe someone try to use phx in ur server,wich probably won't work since you got that on gs
-
On 11/3/2018 at 10:29 PM, lineage2vikings said:
Balanced Skills And Mid Rate Style PvP(
this line is epic,lmao.
On 11/3/2018 at 10:29 PM, lineage2vikings said:This server is a totally recoded server that changes the way you know l2 so far!!
no comment on this
nothing special, good luck tho..
-
stop reading features from the site when i saw this :
Free Weapons, Armors, Jewelry and Consumables
and then..
Adena Drop Reworked for better Economy
-
11 minutes ago, Evie Frye said:
unique .menu about to be top feature.
99% balance? 99% skills? lmao.
-
1
-
-
3 hours ago, L2DragonWind said:
Guys anyone knows updated interlude system for Windows 10, because i find only crappy ones.
where did you search? found clean systems in just 2-3 mins of searchin..
-
44 minutes ago, L2J NexuS said:
Cause you said, "They will miss something".
oki,was just talking in general,ofc each srvr miss a lot..
44 minutes ago, L2J NexuS said:Making a perfect code doesn't mean you are perfect
as for it,
@Evie Frye can't make a perfect code,but his codes make a perfect Evie Frye
-
stucksubs + customs, good luck for them inexperienced testerz arguing for the balance in order to gain a GM position
-
1
-
1
-
-
1 hour ago, L2J NexuS said:
First of all there isn't such thing as perfect.
why u quoted me on this???? sorry if i get it wrong,didn't get why u quoted m ;P, didn't anywhere tell that can b perfect
34 minutes ago, Evie Frye said:Afcourse there is, i can make you a perfect code. Perfect enough that you'll rub your eyes in a part that they will disappear :O
Top coder,great all around skillz,only legend who can code cookies, his cookies > all servers
-
10 minutes ago, Evie Frye said:
There is a protocol here my little beloved legendary follower. If you want create a server and you don't have knowledge at least spend a big budget. Free and successful doesn't fit together in 2018
yeap saying the same thing.
-
6 minutes ago, 'Baggos' said:
Nice features.. GL with your server buddy.. If I have time, I will try it!
so nice that drop pk rate is x20, lmao.
-
9 minutes ago, Evie Frye said:
No offense speaking out of experience you just got the shared CT2.3 pride sources and you want the patch to create another pride server.
I'm having clients in maxcheaters since 2012 and the 100% of those who want pride server are 21-24 years old who just want //gmspeed 3
but if you tell them, they will respond like "No, i don't want copy it exactly just make a decent and nice server". So if you'are about to make a server
at least find a decent ammount of money (100-150-200) and buy a H5 at least or a classic one.
Also use a normal font. Its not readable.
like then it could be successfull.
wannabe adms are forever wannabes, no matter what,always they'll miss smth and always will be far from a making a good server.
if there is no effort,time,and maybe hiring a dev (if adms can't fix some things) then no chances of a good server,agree tho on finding some good files instead of outdated shared packs
-
1 hour ago, 'Hater said:
You are another retarded kid lf pride patch to use with the shared sources and open another shitty server gtfo pleb go find a job
epic
-
1 hour ago, L2DragonWind said:
I found huge problem lol, some antivirus found core.dll virus.... that why people can't join to server :(
very huge problem,lmao.
that should be the last thing to care about but whatever..
-
search at configs..
-
45 minutes ago, 'Baggos' said:
Yea! Remove C6 and keep C4.
newer things doesn't always work better,it's not a lucky fact that in c4 every server was full of playas, plus since there were no 3d class resists it's gameplay always looked more 'balanced' than c6 where mages equal to nothing in pvp servers,and when admins try to fix it they mess up.
-
5 minutes ago, L2Insane said:
Thank you,server is up & growing every day! join us now http://l2insane.net
server needs lot to improve, sps 100% mc rate,all classes need rework, 2nd classes damage more than 3d classes (ph.. plainswalker..) , and also dances consume like 800 mp instead of 60 :D (tested bd to try in olys) . and fix your animations,lot playas with half armors invisible. had some fun tho...
-
2
-
-
32 minutes ago, L2DragonWind said:
Please teach me how to promote server, i thinking about that. (youtube video)
Old days people join to check server now they to lazy. :D
try to make the server well known, post it in every possible site/forum (without ofc spamming it) and add some preview images (from your zones/npcs,custom items etc.) way before opening (like 2weeks or more)
create a forum for the srvr and inform playas about updates/changelogs,add sections for clans to join,create a community wich will discuss daily on server issues,updates or cpclan recruitments.
Ask playas or friendz for help,testing the whole gameplay in detail (like every buff stat,or skills working etc.)
Do beta tests so playas who try it can have a smell of how it looks like,and fix issues at same time,do events(even pre-opening,) and reward with usefull -but no op- items
try premium advert on topsites,create a promo vid and share it and find a good opening date and time,in general try be more creative with every step u making,some small changes here and there..and imo,don't over do it with them custom items.. anyways,still noone says that it will succeed but you have for sure try harder than just advertising it half day before opener...
L2 Rivendel H5
in Private Servers
Posted
to waste ur time
nothing
rename-reopen / or just close