|
You last visited: Today at 14:13
Advertisement
[Release]Datenbank Query
Discussion on [Release]Datenbank Query within the Metin2 PServer Guides & Strategies forum part of the Metin2 Private Server category.
09/24/2011, 14:21
|
#16
|
elite*gold: 121
Join Date: Feb 2008
Posts: 654
Received Thanks: 411
|
Quote:
Originally Posted by Risan
Und wenn man nur bestimmte Monaster sorte will?v
PHP Code:
UPDATE player.mob_proto SET gold_min=gold_min100/*120where locale_name LIKE 'Setaou%' ;
Theoretisch, weiss nicht ob es so stimmt.
Setzt nur setaou Vieher in der Mobproto..
|
UPDATE player.mob_proto SET gold_min = gold_min*100 WHERE level > 1 AND level < 100 OR locale_name LIKE '%a%';
Ist nur ein beispiel, welches die spalte gold_min von den einträgen ändert welches ein lvl zwischen 2 und 99 hat ODER wo ein vorkommen von dem buchstaben "a" gibt.
|
|
|
09/24/2011, 14:21
|
#17
|
elite*gold: 30
Join Date: Jul 2010
Posts: 1,627
Received Thanks: 1,450
|
Quote:
Originally Posted by Endless.
Nicht schlecht,
Wenn du auch ne Query findest womit man Alle Accounts ihre 3 Lager
auf 5 Jahre oder so setzen kannst, wäre ich voll zufrieden.
|
PHP Code:
UPDATE account.account SET safebox_expire='2015-01-01 00:00:00';
|
|
|
09/24/2011, 15:12
|
#18
|
elite*gold: 0
Join Date: Jan 2009
Posts: 2,876
Received Thanks: 982
|
Added in meinen Sammelthread...
Danke
|
|
|
09/24/2011, 15:14
|
#19
|
elite*gold: 0
Join Date: Jan 2011
Posts: 1,484
Received Thanks: 3,151
|
Quote:
Originally Posted by Risan
Und wenn man nur bestimmte Monaster sorte will?v
PHP Code:
UPDATE player.mob_proto SET gold_min=gold_min100/*120where locale_name LIKE 'Setaou%' ;
Theoretisch, weiss nicht ob es so stimmt.
Setzt nur setaou Vieher in der Mobproto..
|
Die ist etwas unübersichtlich... bleib entweder dabei die Querie Befehle groß zu schreiben oder lass es!
PHP Code:
UPDATE player.mob_proto SET gold_min=gold_min*120 WHERE locale_name LIKE 'Setaou%';
|
|
|
07/17/2013, 14:32
|
#20
|
elite*gold: 0
Join Date: Jan 2013
Posts: 1
Received Thanks: 0
|
wie mach ich wieder weniger hab ausversehen zu viel gemacht??
|
|
|
07/17/2013, 14:34
|
#21
|
elite*gold: 0
Join Date: Jan 2013
Posts: 348
Received Thanks: 353
|
Quote:
Originally Posted by AyguenYeah
wie mach ich wieder weniger hab ausversehen zu viel gemacht??
|
Willkommen bei e*PvP ^^
Was meinst du mit weniger machen? Was willst du weniger machen?
Achja und bitte les die Regeln des Forums, du hast einen veralterten Thread gepusht
|
|
|
07/17/2013, 14:35
|
#22
|
elite*gold: 11
Join Date: Nov 2010
Posts: 1,709
Received Thanks: 3,828
|
Unneeded, you can do the same much faster with eventflags.
|
|
|
07/17/2013, 14:42
|
#23
|
elite*gold: 1143
Join Date: Jun 2012
Posts: 800
Received Thanks: 399
|
Quote:
Originally Posted by AyguenYeah
wie mach ich wieder weniger hab ausversehen zu viel gemacht??
|
Ich habe da eine Theorie, DIE IST ABER NICHT GETESTET!
Quote:
SELECT * FROM `mob_proto`;UPDATE player.mob_proto SET gold_min=gold_min*2 , gold_max=gold_max*2
|
der Stern bedeutet auch auf dem Taschenrechner von Windows "mal", also versuch doch mal anstatt nen * ein - (minus) oder ein / (geteilt) ?
Wäre dich "Theoretisch" logisch oder? ^^
|
|
|
07/17/2013, 16:18
|
#24
|
elite*gold: 216
Join Date: Aug 2009
Posts: 1,768
Received Thanks: 1,962
|
PHP Code:
SELECT * FROM `mob_proto`;UPDATE player.mob_proto SET gold_min=gold_min/2 , gold_max=gold_max/2
Zahlen beliebig abänderbar!
|
|
|
07/17/2013, 17:04
|
#25
|
elite*gold: 0
Join Date: Feb 2010
Posts: 7,221
Received Thanks: 6,758
|
Quote:
Originally Posted by Uncorrupted
Unneeded, you can do the same much faster with eventflags.
|
Meanwhile everybody know that, this thread was created over 2 years ago - no creator of pservers knew that at this time.
|
|
|
07/17/2013, 23:17
|
#26
|
elite*gold: 0
Join Date: May 2011
Posts: 5,084
Received Thanks: 3,458
|
#closed
|
|
|
|
|
Similar Threads
|
[Release]MobSpawn Query Maker v1.0
01/28/2013 - CO2 PServer Guides & Releases - 27 Replies
Here is a program that will allow you to make mob spawns and save time.
Credits are included in the program as well as instructions. This was made for LOTF. Screen shot provided below.
Pass: emptyproject
Download: Multiupload.com - upload your files to multiple file hosting sites!
|
[RELEASE] Character(s) Statistics Query
12/23/2012 - Shaiya PServer Guides & Releases - 4 Replies
What this query does:
Calculates a character(s) total statistics and displays them one row per character.
What this query does not account for:
Skills that passively add attack power.
Currently applied buffs and nostrums.
Characters with no items are left out of the results of this query.
Multiple of the same lapis in a single item (like if an item was GM linked with two or more Craft 7s in it, only one would be counted).
Any lapis GM linked to your mount.
Anything I forgot to account...
|
Release : Vsro Databases in Query
09/16/2011 - SRO Private Server - 13 Replies
deleted
|
[Release]FlyingDragon Query
02/28/2011 - EO PServer Guides & Releases - 6 Replies
I made this Query using these files: FlyingDragons
This is my very first query I made so let me know if it works!
(P.S. RedDragon soon to come)
|
[RELEASE] Query Sammlung
10/17/2010 - Metin2 PServer Guides & Strategies - 14 Replies
Hoi,
Dachte mal ich Sammle mal alle Querys die ich schreibe auch sowas wie Items anhand der Log Tabelle wiederherstellen allerdings natürlich erst wenn ich sie schreibe xD Erstmal das einfache Zeug
Log mit Spielernamen auslesen:
SELECT log.*,player.name FROM log.log LEFT JOIN player.player ON player.id = log.who
von GM erstellte Items finden
SELECT log.*,player.name FROM log.log LEFT JOIN player ON player.player = log.who WHERE what ="GM"
|
All times are GMT +2. The time now is 14:13.
|
|