[Tutorial] GM commands for beginners.

[codyx]

The structure of the GM commands is the following one: (main credits to chreadie, hvdaedalus, Tsukasa & X_Sarah_X)

Method:
1 - open authserver and enter cmdon
2 - run this procedure in your database :

USE Pangya_S4_TH
INSERT INTO Pangya_Server_Command (Command, Arg1, Arg2, Arg3, Arg4, Arg5, Target, RegDate, ReserveDate)
VALUES(commandID,Arg1Value,0,0,0,0,20201,NOW,NULL)

Command ID :

• 0 Notice
  Help :

  To use command 0 you need to add a message to Pangya_Notice_List and supply Arg1 with the Idx of the notice you want to play.

  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Notice_List (Message, ReplayCount, RefreshTime)
  VALUES (varchar(250), int,int)

  ------- idx = the unique number of the message you added in the Pangya_Notice_List
  

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (0, idx, 20201)

• 1 Server shutdown
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (1, 1, 20201)

• 2 Server cancel shutdown
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (2, 1, 20201)

• 3 Server service control
  Example :
• 9 Reload Iff file (items/shop/prices etc.)
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (9, 1, 20201)

• 10 Kick player
  Example :
• 11 Update patch version
  Example :
• 12 Change quest flag
  Example :
• 13 Change quest drop rate
  Example :
• 14 Change quest drop flag
  Example :
• 15 Pang event rate
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (15, 400, 20201)

• 16 Pang XP rate
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (16, 400, 20201)

• 17 Server Shutdown
  Example :
• 18 Item drop rate
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (18, 1000, 20201)

• 19 Angel event (Arg1 = 1 on / 0 off) - it is auto ON!
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (19, 1, 20201)

• 20 Rain event (% rain = 10 * Arg1)
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (20, 250, 20201)

• 21 Papel drop ratios (Arg1 = rare item drop rate, Arg2 = Cookie item drop rate)
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Arg2, Target)
  VALUES (20, 250, 250, 20201)

• 22 Map pang event
  Example :
• 23 Change server icon
  Example :
• 24 Jackpot
  Example :
• 25 Scratches drop rate
  Example :
• 28 Gift drops (pop up from holes)
  Example :
• 29 Christmas sock drop rate
  Example :
• 30 New year money ratios
  Example :
• 33 Event gift box
  Example :
• 36 Event set state
  Example :
• 51 Set Gauge time
  Example :
• 52 Set map Gauge
  Example :
• 53 Ghost Service (Arg1 = 1 on / 0 off)
  Example :

  USE Pangya_S4_TH
  INSERT INTO Pangya_Server_Command (Command, Arg1, Target)
  VALUES (53, 1, 20201)

List incomplete but in progress.

Source : http://forum.ragezone.com/f512/gmtool_cmd-727937/
"Nothing" comes from me, it's more a summary of this thread.

 

[Kamikaze1]

Angel event

is auto on

 

[dooku]

black papel command to change rates for the rares is 21 not 20

USE Pangya_S4_TH
INSERT INTO Pangya_Server_Command (Command, Arg1, Arg2, Target)
VALUES (21, 250, 250, 20201)