RFWorld
Would you like to react to this message? Create an account in a few clicks or log in to continue.

RFWorldLog in

Rising Force World

ANNOUNCEMENT

HOW TO DOWNLOAD THE FILE?

CLICK THE LINK FILE YOU WANT TO DOWNLOAD, THEN CLICK FREE ACCESS, LAST STEP IS FOLLOW THE LINK TILL YOU FIND THE FILE ORIGINAL LINK,

THIS ADS LINK MANDATORY TO KEEP OUR FORUM ALIVE♥️


PLEASE SUPPORT US BY CLICK THE ADS LINK, TURN OFF ADBLOCK ♥️

OR YOU CAN SUPPORT US THROUGH PAYPAL / SAWERIA ♥️

THE FORUM WILL BE SHUT DOWN IN THE END OF THE YEAR

IF WE GOT NO SUPPORT ANYMORE Tears





Ask Archon

power_settings_newLogin to reply
4 posters

descriptionAsk Archon EmptyAsk Archon May 10th 2020, 06:11

more_horiz
ane udah bikin player dan mau ane jadiin archon make Query SQL (command bossme tidak bisa karena ini player bukan GM) tetapi kenapa tidak bisa ya?
udah nyoba make toolz juga ga ngaruh, padahal di tabel tbl_patriarch_candidate sudah muncul dan sudah ane ganti classnya jadi 0 (untuk archon) tetapi in game tidak ada perubahan
apakah ada yg salah dari step saya

descriptionAsk Archon EmptyRe: Ask Archon May 10th 2020, 06:12

more_horiz
Ask Archon Sql10
Ask Archon Sql_210
Ask Archon Rf10

descriptionAsk Archon EmptyRe: Ask Archon May 10th 2020, 10:48

more_horiz
Nunggu hari minggu pak on in dah pas jam 12.00 malam

descriptionAsk Archon EmptyRe: Ask Archon May 10th 2020, 11:03

more_horiz
dimasx wrote:
Nunggu hari minggu pak on in dah pas jam 12.00 malam

jadi berubahnya sama persis kalo kayak kita vote normal ya?
thx gan ane coba lihat nanti

solved terimakasih
(tinggal nunggu hari minggu jam 00.00 otomatis berubah)

Last edited by kenasuka on May 13th 2020, 19:53; edited 1 time in total

descriptionAsk Archon EmptyRe: Ask Archon May 12th 2020, 13:30

more_horiz
Mas kalo boleh minta querry archon nya dong mas.

descriptionAsk Archon EmptyRe: Ask Archon May 13th 2020, 19:49

more_horiz
Robi2106 wrote:
Mas kalo boleh minta querry archon nya dong mas.

Code:

/*******************************************************************
Copyright © 2012 - Heaven Network
Website  : www.heaven-gaming.org
Category : SQL Modules - Changes Council

Database Inject : [RF_World]
Object:  Table [dbo].[tbl_patriarch_candidate] 
Notice : If Player Are Not In Ranking System, He Can't Promoted
********************************************************************/
USE RF_World
DECLARE @eserial int
DECLARE @race    tinyint
DECLARE @lv    tinyint
DECLARE @rank    int
DECLARE @pvppnt    float
DECLARE @aserial    int
DECLARE @aname    varchar(17)
DECLARE @gserial    int
DECLARE @gname    varchar(17)
DECLARE @class    tinyint
DECLARE @status    tinyint

/*    [+]Class Information:
        0 "Archon";
        1 "Left - Consul";
        2 "Left - Strike Team";
        3 "Left - Deffense Team";
        4 "Left - Support Team";
        5 "Right - Consul";
        7 "Right - Deffense Team";
        6 "Right - Strike Team";
        8 "Right - Support Team";

    [+]eSerial Information
        It's Generated Automatically, It's Take Latest Council Period

    [+]Status Information
        1 - For Assign To Next Council Election
        2 - For Assign To Left Council
        3 - For Assign To Right Council
*/

SET @aname    = 'KenAsukaJr' -- Player Nickname which u want grant to Council
SET @class    = 0 -- See Class Information
SET @eserial = (select top 1 eSerial from [RF_World].dbo.tbl_patriarch_candidate order by eSerial desc)
SET @race    = (select race from tbl_PvpRankToday where name=@aname)
SET @lv    = (select lv from tbl_PvpRankToday where name=@aname)
SET @rank    =(select rank from tbl_PvpRankToday where name=@aname)
SET @pvppnt    =(select PvpPoint from tbl_PvpRankToday where name=@aname)
SET @aserial    =(select serial from tbl_PvpRankToday where name=@aname)
SET @gserial    =(select GuildSerial from tbl_PvpRankToday where name=@aname)
SET @gname    =(select GuildName from tbl_PvpRankToday where name=@aname)
SET @status    = 1  -- See Status Information


Insert into [dbo].[tbl_patriarch_candidate] (eSerial, Race, Lv, Rank, PvpPoint, ASerial, AName, GSerial, GName, ClassType, State, dtUpScore)
Values (@eserial, @race, @lv, @rank, @pvppnt, @aserial, @aname, @gserial, @gname, @class, @status, getdate() )

print 'Current Archon Period : ' + CAST(@eserial as varchar)
print 'Nickname : ' + @aname
print 'Race : ' + CAST(@race as varchar)
print 'Level : ' + CAST(@lv as varchar)
print 'Ranking : ' + CAST(@rank as varchar)
print 'PvP Point : ' + CAST(@pvppnt as varchar)
print 'Account : ' + CAST(@aserial as varchar)
print 'Guild Name : ' + @gname
print 'Guild Serial :' + CAST(@gserial as varchar)
print 'Promoted To : ' + CAST(@class as varchar)
print 'Status : ' + CAST(@status as varchar)

nick nya tinggal diganti aja sama nick ente
credit sql tertera

descriptionAsk Archon EmptyRe: Ask Archon June 4th 2020, 17:12

more_horiz
kenasuka wrote:
Ask Archon Sql10
Ask Archon Sql_210
Ask Archon Rf10


gan itu biar ada guild gimana caranya? boleh minta scriptnya? atau tutornya?
thx

descriptionAsk Archon EmptyRe: Ask Archon

more_horiz
privacy_tip Permissions in this forum:
You cannot reply to topics in this forum
power_settings_newLogin to reply