i beleave it should be sumwere along the lines of
Code:
USE [PS_GMTool]
GO
/****** Object: StoredProcedure [dbo].[usp_script name here] Script Date: 02/18/2011 14:08:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO
CREATE PROCEDURE [dbo].[usp_script name here]
@CharID INT
AS
SET NOCOUNT ON
UPDATE PS_GameData.dbo.Chars
SET Level=1, Exp=0
Where CharID= @CharID
that will creat the stored proc how to set the identifying Charid from ingame when its executed i have no idea and i also beleave for the efects to take you must also restart the game (that player only) not totaly shure on the set level=1,exp=0 or if its level=1 and exp=0 im not a sql person i just edit this and that i have no idea how to actyaly wright them as i have never used it tell i started my server but a lil trial and error useing a created toon for that specific purpus of re doing lvls and exp i could make it work asfar as redoing its levels and so on just notshure how to imploment it to recall its levels and soon after items sold or quest completed to recall levels without a game restart for that player