GM Links / Rerolls Questions

[benoli105]

is there a faster way to GM Link / Rerolls threw DB or using a GM panel then this 1 : How to do GM link, enchant and ep4 stats change trought DataBase ( the 1 provided by Julee )


if yes , plz answer me on this thread o.o

[JuuF]

Here i wrote a script for you you can do it by 1 click o,o but you gotta change Craftname, CharID, Bag and Slot ofc

Use PS_GameData
UPDATE dbo.CharItems SET Craftname = '00000000000000000020' WHERE (CharID = '1') AND (Bag = '1') AND (Slot = '5')
SELECT RowID, CharID, ItemID, Type, TypeID, Bag, Craftname
FROM dbo.CharItems Where (CharID = '1') AND (Bag = '1') AND (Slot = '5')

Credits goes to Julee for his/her Screenshot.

[benoli105]

and do you have a script for links ?

and btw , could u tell me where im spose to put the items in inventory / Wh in order to makes it works? ty

[JuuF]

It's for inventory. You can change that line to change item spot

(CharID = '1') AND (Bag = '1') AND (Slot = '5')

Here is GM Link Code:

Use PS_GameData
UPDATE dbo.CharItems SET Gem1 = '0', Gem2 = '0', Gem3 = '0', Gem4 = '0', Gem5 = '0', Gem6 = '0' WHERE (CharID = '1') AND (Bag = '1') AND (Slot = '5')
SELECT RowID, CharID, ItemID, Type, TypeID, Bag, Gem1, Gem2,Gem3, Gem4, Gem5,Gem6
FROM dbo.CharItems Where (CharID = '1') AND (Bag = '1') AND (Slot = '5')

[benoli105]

ok tyvm man !

man ur scripts arnt working at all e.e

[mirazass]

best way is create your PHP based script then you will prevent of mistakes

[JuuF]

Originally Posted by benoli105

man ur scripts arnt working at all e.e

They are working, i tested them and worked perfectly. Can you explain what error do you get?

[benoli105]

well im not getting any error tbh the only thing strange is , i run the script then it show everything is perfect , but when i enter the game the rerolls / link didnt chant o.o,

or maybe its just me but im editing those 2 lines Where (CharID = '1') AND (Bag = '1') AND (Slot = '5')
to Where (CharID = '1') AND (Bag = '1') AND (Slot = '1')
i put the item in the 1st bad 1st slot run the script i get " sucessfull " in the report and the bottom i can see my item with the lapis linked on it but i go into the game and the item is clean , where the prob :/?

[abrasive]

Originally Posted by benoli105

well im not getting any error tbh the only thing strange is , i run the script then it show everything is perfect , but when i enter the game the rerolls / link didnt chant o.o,

or maybe its just me but im editing those 2 lines Where (CharID = '1') AND (Bag = '1') AND (Slot = '5')
to Where (CharID = '1') AND (Bag = '1') AND (Slot = '1')
i put the item in the 1st bad 1st slot run the script i get " sucessfull " in the report and the bottom i can see my item with the lapis linked on it but i go into the game and the item is clean , where the prob :/?

Are you logged into the game when you update the database? You must be logged off during the database update, and log in only after the changes are made.

[benoli105]

maybe thats why , well anyway ill try again

Still not working...

OH GOSH NVM I WAS JUST ENTERING THE WRONG CHAR ID LOOOL // soz for the blabla ikr im kinda fail D:

Your script is my life savior :O!! Thanks !

[lingern1]

Sorry to post on an old thread but, I am trying to give my players max OJ's.... For some reason this script is not working for me. Can anyone make a video on it? If not its okay. Thanks.

[nubness]

The mistake was originally made by JuuF. People need to learn the difference between script and query. Scripts are basically web based, PHP for instance. Queries are what you execute in SQL, SQL standing for Structured Query Language.

You need to execute this query in SQL, this is not what for example Shaiya Haven has, this is something you do manually.

[lingern1]

Originally Posted by nubness

The mistake was originally made by JuuF. People need to learn the difference between script and query. Scripts are basically web based, PHP for instance. Queries are what you execute in SQL, SQL standing for Structured Query Language.

You need to execute this query in SQL, this is not what for example Shaiya Haven has, this is something you do manually.

Okay so what I did was, Open it as a query, enter the correct info, update the server, but still for some reason Im getting no results. Im going to mess around with it a bit more.

[nubness]

USE PS_GameData

DECLARE @CharID int
DECLARE @Str varchar(2)
DECLARE @Dex varchar(2)
DECLARE @Rec varchar(2)
DECLARE @Int varchar(2)
DECLARE @Wis varchar(2)
DECLARE @Luc varchar(2)
DECLARE @HP varchar(2)
DECLARE @MP varchar(2)
DECLARE @SP varchar(2)
DECLARE @Enchant varchar(2)
DECLARE @NewCraftname varchar(20)

SET @CharID = (SELECT CharID FROM Chars WHERE CharName = '')
SET @Str = ''
SET @Dex = ''
SET @Rec = ''
SET @Int = ''
SET @Wis = ''
SET @Luc = ''
SET @HP = ''
SET @MP = ''
SET @SP = ''
SET @Enchant = ''

SET @NewCraftname = @Str + @Dex + @Rec + @Int + @Wis + @Luc + @HP + @MP + @SP  + @Enchant

UPDATE CharItems
SET Craftname = @NewCraftname
WHERE CharID = @CharID AND Bag = 0 AND Slot = 0

All you have to do is fill in the CharName and the stats you need, if you don't need any of those stats just put 00 there, it must have 2 digits.
I hope this makes it more explicit.

[lingern1]

Thanks very much, finally got it down after a while!