I got the @CGUID thing to work. This is a Variable, its need to be set at the beginning.
Look in your Database for the highest guid to set this Variable.
For example your highest guid is 5999999 you set "@CGUID" to 6000000...
At the top of the SQL file the variable need to be set for example like this: SET @CGUID := 6000000;
With this line the other lines will be calculated automatically:
@CGUID+1 = 6000001
@CGUID+2 = 6000002
@CGUID+3 = 6000003
[...] But there is a Problem/Bug
The apostrophes need to be removed in each line: Change every line from this:
('@CGUID+0', 88999, 1116 ...
('@CGUID+1', 88999, 1116 ...
('@CGUID+2', 88999, 1116 ... To this (no apostrophes around variable):
(@CGUID+0, 88999, 1116 ...
(@CGUID+1, 88999, 1116 ...
(@CGUID+2, 88999, 1116 ... My Fixed Test-SQL file in attachments
(Some Spawns in south Gorgrond, see my last post)
- Freddy G.
2016_06_12_13_29_06_21742_2016-06-12_12-57-25_176A7C80.pkt.sql