Replace Arhons

[Killerwoody]

Anyone have a guide or can point me to the direction in SQL to make Archon changes?

 

[dpman]

its in tbl_patriarch_candidate

 

[Killerwoody]

ok I got that so do I just put in the new person name and execute lol Very noobish at sql but I understand some of it and thanks dpman

 

[xAlastor]

its in tbl_patriarch_candidate

yeah ryt

0 for rl
1 for consul
2 for strike team
3 for deffense team
4 for support team

5 for 2nd consul
6 for 2nd strike
7 for 2nd deffense team
8. for 2nd support team

 

[Killerwoody]

Thanks guys! So when I put the new player in do I need to make their cpt match or does it matter? Also if the player has no Aserial because he/she didn't run for archon do I just use the next serial open in the list ? Thanks in advance and for all the help

 

[learlove]

use RF_World
Insert into [dbo].[tbl_patriarch_candidate] (eSerial, Race, Lv, Rank, PvpPoint, ASerial, AName, GSerial, GName, ClassType, State, dtUpScore)
Values ('1', '0', '65', '', '', '23', 'test', '-1', '', '0', '2', getdate() )

eSerial = weeks
race 0 = bel, 1 = cora, 2 = arc
lv = Check the base 'character level'
rank = No input
pvppoint = No input
ASerial = Check the base 'Character serial'
AName = Check the base 'Character name'
GSerial = Check the Guild 'Guild Serial number'
GName = Check the Guild 'Guild Name'
ClassType = @xAlastor reply
State = Cumulative number
dtUpScore= 'getdate()' fix