Uphillyout

Hi there... I have Gracia Final Server, and now I'am need

¤ Interlude Server

¤ Epilogue Server

¤ Freya Server

If you have dis, I'll buy it. Interested only in 95-100% content.

Do you have question? add me in skype - "Uphillyout".

Thx.

hi! could someone tell me where i can find something about this core-mod ?

i cant find anything...

i am sorry if i posted in wrong section...

nope... id ont waiting it... iam waiting for help, maybe someone want to work with me on this

any news?

and how can we apply this to gracia final? with 6 race - kamael. and other

this is not for gracia final... its for C5. open and look "patch.txt"

[offtop]OMG ))) hide and seek)) rofl)))[/offtop]

well... could anyone try to make VIP Event for gracia final ?

can anyone make this for Gracia Final ?

What do you mean ? He don't know how to call the methods in a code , that's why i gave him this link.

omg)) i know))

btw, why you cant just help ?

can anyone help me?

so this NPC is not real to install on server... ?

iam sorry... where?

try this configuration your MYSQL server

[client]

port=3306



[mysql]

default-character-set=latin1



[mysqld]

port=3306

basedir="C:/Program Files/MySQL/MySQL Server 5.1/"

datadir="C:/Program Files/MySQL/MySQL Server 5.1/Data/"

default-character-set=latin1

default-storage-engine=INNODB

sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

max_connections=300

table_cache=3000



query_cache_size=350M

query_cache_type=1

query_cache_limit=512k



#posible que no hacen falta

tmp_table_size=0M

#max_heap_table_size=512M



thread_cache_size=2048

log_slow_queries

memlock



#probar esto, antes 14400

wait_timeout =3600

interactive_timeout=3600





query_prealloc_size=16k



#*** MyISAM Specific options

myisam_max_sort_file_size=100G

myisam_max_extra_sort_file_size=100G

myisam_sort_buffer_size=30M

key_buffer_size=350M

read_buffer_size=64K

read_rnd_buffer_size=256K

sort_buffer_size=256k



#*** INNODB Specific options ***

innodb_data_home_dir="C:/MySQL Datafiles/"

#skip-innodb

innodb_additional_mem_pool_size=6M

innodb_flush_log_at_trx_commit=1

innodb_log_buffer_size=3M

innodb_buffer_pool_size=350M

innodb_log_file_size=50M

innodb_thread_concurrency=8

innodb_lock_wait_timeout =50

innodb_file_per_table

innodb_open_files=2400

Well... is this code have any mistakes? why does not work?

L2PcInstance.java

 
// Character Transformation SQL String Definitions:
private static final String SELECT_CHAR_TRANSFORM = "SELECT transform_id FROM characters WHERE charId=?";
private static final String UPDATE_CHAR_TRANSFORM = "UPDATE characters SET transform_id=? WHERE charId=?";

+	// Character Color System by =)
+	private static final String INSERT_CHAR_COLOR = "INSERT INTO character_color(charId, name_color, title_color) VALUES (?,?,?)";
+	private static final String SELECT_CHAR_COLOR = "SELECT * FROM character_color WHERE charId=?";
+	private static final String UPDATE_CHAR_COLOR = "UPDATE character_color SET name_color=?, title_color=? WHERE charId=?";

=====================================

case L2PcInstance.STORE_PRIVATE_MANUFACTURE:
        		activeChar.sendPacket(new RecipeShopMsg(this));
        		break;
        }
    }

+	/**
+	 * method fo restore colors from database
+	 * and insert if in database if not exists
+	 * @author =)
+	 */
+	public void restoreColor()
+	{
+		Connection con = null;
+		PreparedStatement statement = null;
+		ResultSet rset = null;
+        try
+        {
+            con = L2DatabaseFactory.getInstance().getConnection();
+            statement = con.prepareStatement(SELECT_CHAR_COLOR);
+            statement.setInt(1, getObjectId());
+            rset = statement.executeQuery();
+
+			if (rset.next())
+            {
+               	getAppearance().setNameColor(Integer.decode((new +StringBuilder()).append("0x").append(rset.getString("name_color")).toString()).intValue());
+                getAppearance().setTitleColor(Integer.decode((new +StringBuilder()).append("0x").append(rset.getString("title_color")).toString()).intValue());
+            }
+			else
+			{
+				con = L2DatabaseFactory.getInstance().getConnection();
+           	 	statement = con.prepareStatement(INSERT_CHAR_COLOR);
+            	statement.setInt(1, getObjectId());
+            	statement.setString(2, Integer.toHexString(getAppearance().getNameColor()).toUpperCase());
+            	statement.setString(3, Integer.toHexString(getAppearance().getTitleColor()).toUpperCase());
+            	statement.execute();
+			}
+        }
+        catch (Exception e)
+        {
+            _log.warning("could not restore colors: "+e);
+        }
+        finally
+        {
+            try{ con.close(); statement.close(); rset.close();}
+
+			catch(SQLException e) {}
+        }
+	}
+
+	/**
+	 * Store colors
+	 * @author =)
+	 */
+    private void storeColor()
+    {
+
+       	Connection con = null;
+		PreparedStatement statement = null;
+        try
+        {
+            con = L2DatabaseFactory.getInstance().getConnection();
+            statement = con.prepareStatement(UPDATE_CHAR_COLOR);
+            statement.setString(1, Integer.toHexString(getAppearance().getNameColor()).toUpperCase());
+            statement.setString(2, Integer.toHexString(getAppearance().getTitleColor()).toUpperCase());
+            statement.setInt(3, getObjectId());
+            statement.execute();
+        }
+        catch (Exception e)
+        {
+            _log.warning("could not store colors: "+e);
+			e.printStackTrace();
+        }
+        finally
+        {
+            try
+			{
+				con.close(); statement.close();
+			}
+            catch(SQLException e) {}
+        }
+	}

And MYSQL

-- ----------------------------------------
-- Table structure for `character_color` --
-- ----------------------------------------
DROP TABLE IF EXISTS `character_color`;
CREATE TABLE `character_color` (
  `charId` decimal(11,0) NOT NULL DEFAULT '0',
  `name_color` char(6) NOT NULL DEFAULT 'FFFFFF',
  `title_color` char(6) NOT NULL DEFAULT 'FFFF77',
  PRIMARY KEY (`charId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-------------------------------------------

Can anyone tell me plz, how i can TODO this "mod"...

On server allow only latin, without any special symbols like "$" "#" "=" etc...

I want to spawn NPC. For donation money that NPC will change player's name to "iam^bad^**#@BOY" or other... how wish donator...

i mean like this, but with special symbols... I wanna to have this NPC !! =)) thx