Discussion on [Release SQL] Change startmap coords and map within the Metin2 PServer Guides & Strategies forum part of the Metin2 Private Server category.
Hello, excuse my english.
I have just done a "Trigger" And "Procedure" for changing the startmap coords and map.
If you want to put the same map for all kingdom you can use this trigger
Code:
DELIMITER $$
DROP TRIGGER IF EXISTS esper $$
CREATE TRIGGER esper
BEFORE INSERT ON player
FOR EACH ROW
BEGIN
set new.x= 172428;
set new.y= 1220252;
set new.map_index= 73;
end $$
DELIMITER ;
changing the coords and map index.
However if you want to put a different map depending of the kingdom you can use the trigger and procedure which are below.
Remember you mustn't put these querys if you have in your sql player data any value of map_index = 0, you must put this update query
Code:
UPDATE player set map_index=1 where map_index=0
after inserting the code above you have to type the following trigger and procedure.
Code:
DELIMITER $$
DROP TRIGGER IF EXISTS espera $$
CREATE TRIGGER espera
AFTER UPDATE ON player_index
FOR EACH ROW
BEGIN
call proceso();
end $$
DELIMITER ;
this only call the procedure "proceso" when a new pj is created.
The procedure is typed below
Code:
delimiter $$
Drop procedure if exists `proceso` $$
CREATE
PROCEDURE `proceso`()
begin
declare reino integer;
declare ids integer;
select account_id into ids from player where player.map_index=0;
select empire into reino from player_index where id=ids;
if reino=1 THEN
UPDATE player set x=1111 where map_index=0;
UPDATE player set y=1111 where map_index=0;
UPDATE player set map_index=1 where map_index=0;
end if;
if reino=2 THEN
UPDATE player set x=2222 where map_index=0;
UPDATE player set y=2222 where map_index=0;
UPDATE player set map_index=2 where map_index=0;
END if;
if reino=3 THEN
UPDATE player set x=3333 where map_index=0;
UPDATE player set y=2222 where map_index=0;
UPDATE player set map_index=3 where map_index=0;
end if;
end $$
delimiter ;
you must set the x coords, y coords and map_index which are in sql data of player.
Wer will ne Wette abschließen ? Ich sage 0,7% der Com verstehen es
Quote:
Originally Posted by .Nagato
Hallo,
Hierfür muss man nichtmal SQL können.
Englisch sollte ausreichen, wobei das auch wieder so eine Sache sein kann. oó
Really nice!
DEU:
Dann gehöre ich wohl zu den ~0.4% der Community, die beides können.
MySQL-Trigger sind zwar eine tolle Sache, aber "native" Anpassung der Startkoordinaten in der Binary wäre mir doch lieber.
Von Triggern in großen, zugriffsstarken Tabellen halte ich nicht so viel, weil das der Performance schaden könnte.
ENG:
MySQL triggers are a nice feature but I would rather "natively" modify the starting coordinates in the game binary.
I don't like the idea of adding triggers to large, access rich tables because this could harm performance.
Really this it's a good system, only uploads map_index=0 where is insert any date, no update, for this reason the speed of DB musn't be delayed (excuse for my english)
ich schätze mal das es auch nicht so schwer sein sollte wie es hier die meisten sagen natürlich haben einige ihre schwierigkeiten , jedoch sollte es keinen daran hindern
[Release] Alte Startmap von iMetin 03/26/2011 - Metin2 PServer Guides & Strategies - 14 Replies Release sie mal, weil ich sie eh nicht mehr brauche.
Viel Spaß damit.
Screens hab ich grad keine da.
Video hab ich da darf ich aber nicht posten, da da die iMetin Homepage UrL zu sehen ist.
iMer
[FRAGE]Startmap!? 02/02/2011 - Metin2 Private Server - 10 Replies Wo stellt man es ein?
Auf welcher map der neu erstellte
Account/Chara als erstet steht?
also ich wills um stellen das nnicht mehr map 1 des jeweiligen reiches
die start map ist sondern
eine neutrale map
kann da wer helfen?^^
Frage: Startmap ändern 12/19/2010 - Metin2 Private Server - 0 Replies Guten Abend Com,
Ich habe eine Frage: Wie kann man die Startmap ändern, sprich man wählt das Rote Reich aus und man landet auf einer anderen Map als im Roten Reich.
Würde mich über Antworten freuen,
Mfg,
°WhiT3°
[Release] SBot Coords Database 10/29/2010 - SRO Coding Corner - 10 Replies Hello forum,
This is my first major project, I got the idea from SBot AC professional but decided to make one for the people that don't want to pay for it. So idea credit goes to theoneofgod :)
SBot Coords Database
http://img202.imageshack.us/img202/5734/previewit .jpg
:
-Grab coords directly off of the selected SBot and puts it in the database along with desired name. Note:
Screen Coords <--> Map Coords using autoit 04/21/2009 - CO2 Programming - 1 Replies Someone might like this.
I provide an example of how to convert screen coords into map coords and visa versa. So that if your using autoit or some other mouse clicking macro tool, then you can get it to accurately get the mouse coordinates to click to move to a map-coordinate location.
This method works by using autoit to look at the current player coordinates (_MemoryRead()), and performing some clicks on the screen to take map coordinate samples for mouse clicks in different locations....
![[Release SQL] Change startmap coords and map](https://www.elitepvpers.com/forum/iconimages/metin2-pserver-guides-strategies/release-sql-change-startmap-coords-map_ltr.gif){kind=small}
[Release SQL] Change startmap coords and map
