Okay then use = instead of like [problem solved] wasn't meant to be used for more than a value, why like? cuz I didn't remember any npc code so i used it @ mine while testing cuz i had a npc with smth like ;****; so i used LIKE '%****%', laziness ftw!
problem is... what if there are 2+ NPCs with %****%?
[Release] Useful queries for some people (Part I) 08/31/2013 - SRO PServer Guides & Releases - 14 Replies If you want certain character's mastery's at a certain level.. Input their name here, and set their skill level you desire.
USE
GO
--by Evo
Declare @CharName Varchar (64)
Set @CharName = 'BlackBerry'
[Release] Einige SQL Queries 06/30/2012 - Flyff PServer Guides & Releases - 6 Replies So Release hier mal paar queries die ich aus langeweile mal gemacht hatte.
Feedback und http://www.elitepvpers.com/forum/images/elitepvper s/buttons/post_thanks.gif gern gesehen^^
Items finden (per Item-ID bzw. Unique-ID)
DECLARE @item VARCHAR(32)
SET @item = '21'
---------------------------------
-- AB HIER NICHTS MEHR ÄNDERN! --
[Release]2010/11er Queries 09/18/2011 - Metin2 PServer Guides & Strategies - 4 Replies Moin :)
Da in letzter oft die Frage kommt "Warum funktionieren die Queries von den Reittieren / Korea Metins bei mir nicht?" habe ich fertige & funktionierende Queries gemacht.
Was war der Fehler?
Die Queries wurden auf 2007er Files gemacht & 2007er Files haben 6 Spalten weniger als 2010/11er Files.
Korea Metins
![[Release] 2 small queries](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-2-small-queries_ltr.gif){kind=small}
