[Guide] Implementation level 7 guild

[zaglumilo]

Update guild rank is 1 time every day.
Rasschityvaetsya guild rank based on power points and Reiten below a certain value.
Points rasschityvayutsya power of the sum of the levels and status points all guild members divided by 10,000.
Rtg rasschityvaetsya position of guild rankings on the number of power points, multiplied by 100 and divided by the total number of positions in the ranking.
=======================================================================
What would implement the seven guild level, we need to reduce the power requirements of points, as the server has a limit on the maximum number of characters in a guild, and the required number of points might just simply do not score.

Requirements spelled out in the area in the form of a normal request to the database, and what would need to find them to change their hex editor and carefully corrected.

General view of the requests in the area to update the guild rank:
=======================================================================

update tbl_GuildRank%s set Rate = ( (Rank*100)/(select count(*) from tbl_GuildRank%s) )    ReConnectDataBase Fail. Query : %s
update tbl_GuildRank%s set Grade = 2 where rate <= 95 and GuildPower >= 300    CRFWorldDatabase::Update_GuildRank(char* szDate(%s)) : %s Fail!
update tbl_GuildRank%s set Grade = 3 where rate <= 85 and GuildPower >= 1500    CRFWorldDatabase::Update_GuildRank(char* szDate(%s)) : %s Fail!
update tbl_GuildRank%s set Grade = 4 where rate <= 65 and GuildPower >= 3000    CRFWorldDatabase::Update_GuildRank(char* szDate(%s)) : %s Fail!
update tbl_GuildRank%s set Grade = 5 where rate <= 35 and GuildPower >= 10000    CRFWorldDatabase::Update_GuildRank(char* szDate(%s)) : %s Fail!
update tbl_GuildRank%s set Grade = 6 where rate <= 15 and GuildPower >= 25000    CRFWorldDatabase::Update_GuildRank(char* szDate(%s)) : %s Fail!
update tbl_GuildRank%s set Grade = 7 where rate <= 5 and GuildPower >= 30000

Let us consider the request in part.

set Grade = 2 - Sets the level to be assigned to the guild
where rate <= 95 - The level of the guild will be assigned if it is less than 95 raid
and GuildPower> = 300 level will be assigned to the guild if its power more than 300 points

(C)НейрoН

 

[maxpmes]

How I can calculate the rate of a guild?? Why the lower the rate, the higher the grade?

 

[xAlastor]

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '%'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '%'.Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '%'.
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '%'.

need solution

 

[xAlastor]

why no one reply?