RF 2.2.3 sql query for archon
i use this sql and my character(Mint) doesnt change to RL..
Quote:
use RF_WORLD_NOVUS
Insert into [dbo].[tbl_patriarch_candidate] (eSerial, Race, Lv, Rank, PvpPoint, ASerial, AName, GSerial, GName, ClassType, State, dtUpScore)
Values ('1', '0', '65', '', '', '14', 'Mint', '-1', '', '0', '2', getdate() )
eSerial = weeks << dunno what to do with it and i keep it 1
race 0 = bel, 1 = cora, 2 = arc << my char is belato so i use 0
lv = Check the base 'character level' << my char lv is 65
rank = No input << i keep it "
pvppoint = No input << i keep it " << but my actual pvp point is 999999 should i change it?
ASerial = Check the base 'Character serial' << my char serial is 14
AName = Check the base 'Character name' << my char name is Mint
GSerial = Check the Guild 'Guild Serial number' << no guild
GName = Check the Guild 'Guild Name' << no guild
ClassType = @xAlastor reply << i keep it 0
State = Cumulative number << i keep it 2
dtUpScore= 'getdate()' fix
help me please sir.. im totally a noob.. please help me step by step..
Re: RF 2.2.3 sql query for archon
have you restarted your zoneserver?
Re: RF 2.2.3 sql query for archon
Quote:
Originally Posted by
dpman
have you restarted your zoneserver?
yeah.. but nothing happen sir..
maybe i fill the wrong value sir?