[Release] Query To Un-ban Account [Database] 08/04/2012 - SRO PServer Guides & Releases - 6 Replies --By Leandro ( nukertube ) --
USE
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @CharName VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @CharName = 'CharNameHere'---
---------------------------------
need query for database 12/26/2011 - Metin2 Private Server - 2 Replies I need query to update item@player
I want to change one vnum of all the items in player@table to another..
example: change vnum 19 to 16
Need help to make a sql query 07/06/2011 - Shaiya Private Server - 0 Replies i'm adding mobs and i use shtool.
the new mobs comes in both a sdata and csv file.
but anyway i need to add mobId 3005+ in the MobItems and insted of adding 3005 - 3100 manualy there has to be a way for sql to make that for you?
trying :
/*
[Help] Database query 06/26/2009 - CO2 Private Server - 8 Replies So, I'm currently trying to add the +12 npc to my TQ binaries server, and I keep getting an issue with the query when I try to run it.
INSERT INTO cq_npc VALUES(0453, 0, 0, "MoonGoddess", 0002, 4053, -1, 5000, 0047, 0074, 1400,
0,0,0,0,0,0,0, 0,0,0,0, "", 0, 00, 00, 0000, 01, 0000 );
1136 - Column count doesn't match value count at row 1
that is the error I am receiving so if anyone knows how to fix it please respond.
Also I'm using navicat 8.0.20 lite to edit it.
