- Joined
- Apr 9, 2012
- Messages
- 2,359
- Reaction score
- 442
this is query to insert a new archon (not changing), make sure to check on the ClassType (red colour) is not exist yet for the race
ok, so i will explain a little what is the column mean, and how to change it, because i'm not creating the update query yet :
Code:
INSERT INTO dbo.tbl_patriarch_candidate (eSerial,Race,Lv,Rank,Grade,PvpPoint,ASerial,AName,GSerial,GName,WinCnt,ClassType,State,Score,Refund,dtUpScore)
select (Select TOP 1 Serial From tbl_patriarch_elect Where ProcType >= 4 Order by Serial DESC) ,r.Race,b.Lv,r.Rank,r.Grade,r.PvpPoint,b.serial,b.Name,-1,'',0,[COLOR=#ff0000]4[/COLOR],3,0,0,GETDATE() from tbl_base as b inner join tbl_general as g on b.serial = g.Serial left join tbl_PvpRankToday as r on b.serial = r.Serial where b.Name='[COLOR=#0000cd]enter the nickname here[/COLOR]'
- eSerial (the latest serial from table tbl_patriarch_elect that have ProcType >= 4)
- Race (bell=0,cora=1,acc=2, from the query, i pick the race from pvpranktoday table)
- Lv (well, you already now what is this, you can check it on base table)
- Rank (i'm not sure about this one, but i take the Rank from pvpranktoday and this might wrong)
- Grade (it's taken from pvpranktoday table, if the account is not exist in it table, the value should be fill with -1)
- PvpPoint (take either from base or pvpranktoday, PvpPoint)
- ASerial (AvatarSerial, you can see the serial in base table)
- AName (AvatarName, you can see the Name in base table, this is character in game name)
- GSerial (GuildSerial, should be taken from general table, but, as far as i see on the database, only Archon has this column filled it, the other are not)
- GName (GuildSerial, should be taken from general table, but, as far as i see on the database, only Archon has this column filled it, the other are not, when the archon doesn't have guild, it should be filled with *, the other (non archon) can be fill with blank, in the query, i fill it with blank '')
- WinCnt (leave it 0, since this is not officially made from game)
- ClassType (will be explained bellow)
- State (1=failed to be archon/council, 2=win the election from the game, 3 choosen by archon, archon and left wing should use 2 and right wing should use 3)
- Score (0)
- Refund (0)
- dtUpScore [fill with GETDATE()]
- archon=0
- left consule=1
- left striker=2
- left defend=3
- left support=4
- righ consule=5
- right striker=6
- right defend=7
- right support=8
- failed on election=255
- TESTED on 2232 server, not sure about 223
- If you were lazy to change the database on by one, simply put 255 on the ClassType current council/archon you want to change, and 1 on the State column,
- and then insert a new character you want to fill the position, if it's exist already, you change the classtype and state, or delete the record and insert a new one
- Even the archon changing in game, but the character still doesn't get the aura and can't use archon armor (i'm still can't figure it out how this work, if you know something about it, let me know :
Last edited: