|
You last visited: Today at 09:12
Advertisement
need sql query , help
Discussion on need sql query , help within the Dekaron Private Server forum part of the Dekaron category.
08/11/2010, 22:09
|
#1
|
elite*gold: 0
Join Date: Dec 2008
Posts: 15
Received Thanks: 0
|
need sql query , help
hello epvp ,
well i open this topic , coz i want a sql code .
to set all my players ( dekaron players )
tables :
wPosX , wPoxY , wRetPosX , wRetPosY , wMapIndex , wRetMapIndex
to this postion
wPosX : 415
wPoxY : 133
wRetPosX : 415
wRetPosY : 133
wMapIndex : 7
wRetMapIndex : 7
can some one make that for me ?
i want to write this sql query so all my dekaron players will changed and spawn on this location
|
|
|
08/11/2010, 22:55
|
#2
|
elite*gold: 20
Join Date: Mar 2008
Posts: 964
Received Thanks: 232
|
Well if I remember correctly here is how I would do it. Now im no sql pro. But I did learn some queries as you need to know some basic queries to run a server. But I havent used sql in ages so Im not totally sure lol. Anyway before you try this I suggest you backup your database.
Code:
Update character.dbo.user_character
Set wPosX = '415' and WPosY = '133' and wRetPosX = '415' and wRetPosY ='133' and wMapIndex = '7' and WRetMapIndex = '7'
Where character_name = '%'
and character_name <> '[DEV]KNIGHT'
and character_name <> '[DEV]SEGNALLE'
and character_name <> '[DEV]WARRIOR'
and character_name <> '[DEV]SUMMONER'
and character_name <> '[DEV]HUNTER'
and character_name <> '[DEV]MAGICIAN'
as you can see I used the character name to exclude dev characters as its best not to touch the values in dev characters. But if the query shows an error just take the last 7 lines off.
Again Im not too sure about this query because I might have forgotten some stuff as I havent worked with teh query analyzer in a while. So I suggest you do a full character backup before you try this. As I do not want to be responsible for your data loss.
|
|
|
08/12/2010, 14:05
|
#3
|
elite*gold: 0
Join Date: Jan 2008
Posts: 568
Received Thanks: 176
|
it doesnt matter if u change the coords on the dev chars, new chars get their possitions from the char_mappos table
just make sure u dont move players u've put in jail :P
this sets all characters in parca exept for characters with a [] tag and except characters in map 65 (on my server thats the jail map)
Code:
UPDATE character..user_character
SET wMapIndex = 6, wPosX = 416, wPosY = 333, wRetMapIndex = 6, wRetPosX = 416, wRetPosY = 333
WHERE (wMapIndex <> 65) AND character_name > ']'
|
|
|
08/12/2010, 14:09
|
#4
|
elite*gold: 0
Join Date: Dec 2008
Posts: 15
Received Thanks: 0
|
Quote:
Originally Posted by pieter
it doesnt matter if u change the coords on the dev chars, new chars get their possitions from the char_mappos table
just make sure u dont move players u've put in jail :P
this sets all characters in parca exept for characters with a [] tag and except characters in map 65 (on my server thats the jail map)
Code:
UPDATE character..user_character
SET wMapIndex = 6, wPosX = 416, wPosY = 333, wRetMapIndex = 6, wRetPosX = 416, wRetPosY = 333
WHERE (wMapIndex <> 65) AND character_name > ']'
|
thanks , that's what i meant .
|
|
|
|
Similar Threads
|
[Suche]Query für "Alteklinge, Reichsklinge" &' Stichdolche NUR QUERY!
08/18/2010 - Metin2 Private Server - 1 Replies
Ich weiß ich werd nervig aber ich suche die Query's
für Alteklinge, Reichsklinge &' Strichdolche
Why?
Naya, weil ich in der DB i-wie nur Drachenmaulglocke hab
... not more -.-
Auf jeden Fall Icon's etc. etc. etc. hab ich ich brauche nur die Query's
|
query
05/05/2010 - Metin2 Private Server - 0 Replies
So es gab mal ein ttut wie man query fur navicat usen kan nur ich finde in nicht mehr hat jemand den link?
|
Query?
05/03/2010 - Metin2 Private Server - 24 Replies
Hi Liebe Community ;)
Ich wollte mal neue waffen einfügen ;)
Jemand sagte mir um sie in die DB einzufügen musst du in die Item_Proto gehen und ein query machen...
aber wie geht das? ich muss das da einfügen
INSERT INTO `item_proto` VALUES ('7220', 'Spada Raggio di Luna +0 ', 'Spada Raggio di Luna +0', '1', '0', '0', '2', '32', '1', '16', '', '30000', '100', '7221', '19', '0', '5', '1', '80', '0', '0', '7', '15', '17', '2', '0', '0', '0', '90', '110', '5', '67', '117', '-1', '-1',...
|
A Query
03/02/2010 - 12Sky2 - 6 Replies
Hi,
First off, i'm an addict for 12sky 2. I play both 12sky 2 PH and 12sky 2 aeria. All the hax i find here for aeria server
has been very helpful. Apparently, things are quite the opposite for 12sky2 ph server since we have Xtrap. So hacking is quite
impossible for PH. Lately there has been major issues in PH server like some people using cheats/hacks. Fact is, there are already
people banned in PH server for using hax.
Anyway, been trying to find a way to hack 12sky 2 ph server but...
|
Query Help? xD
01/24/2009 - EO PServer Hosting - 3 Replies
Hey lol Can anyone show me how to make this Query replace the old Legion Admin.. Check out this wordpad please and if you Know how to make these Translations replace the old ones Please email me at [email protected]
|
All times are GMT +2. The time now is 09:12.
|
|