[Tutorial][Release]How to make the ClanRankings showup in game....

[Rotana]

Maybe alot of people already know this, but i had alot of PM's about the ranking and score in game . On how it must be showed up.. SO here is it...

If you follow this easy to use 4 steps, then your clan rankings will be showed in the game..

1> Open the mssql studio management. And expant your db then the stored procedures
2> Search for the procedures

spRegularUpdateClanRanking
spRegularUpdateClanRankIncrease

3> click with right button on it and select "Execute Stored Procedure" then an new window will popup and then select "OK"
4> Do the same for the second procedure..


Please note.. that it will update the clanranking only for clans with:
Some wins [so wins must not be 0 or NULL]
Or the Losses aren't 0 or NULL
And the Clan DeleteFlag must be 0 [[thats default]will be set to 1 if the clan is deleted]

Have fun with it...

UPDATE To make it easier for some ppl
first make an new query and past this in it

DECLARE @RC int
EXECUTE @RC = [dbo].[spRegularUpdateClanRanking] 
EXECUTE @RC = [dbo].[spRegularUpdateClanRankIncrease]

If you dont have this 2 stored procedure then you dont have the right database

[MentaL]

[Joe9099]

u got a screenshot.. not cus i think ur lieing of course but just to take a look and see if its worth it...

[Rotana]

u got a screenshot.. not cus i think ur lieing of course but just to take a look and see if its worth it...

Here is an screenshot..

And is it that hard to try it your selve?? Or you affraid to damage your mouse when you do to much with it?

[willianmorvan]

=] nice rotana

[kekku500]

u mean i "Execute Stored Procedure" spRegularUpdateClanRanking,
spRegularUpdateClanRankIncrease then delete spRegularUpdateClanRanking,
spRegularUpdateClanRankIncrease and Execute spRegularUpdateClanRanking,
spRegularUpdateClanRankIncrease ???

[Rotana]

To make a little bit easier:
Copy and pas this into an new query editor of mssql studio

DECLARE @RC int
EXECUTE @RC = [dbo].[spRegularUpdateClanRanking] 
EXECUTE @RC = [dbo].[spRegularUpdateClanRankIncrease]

and hit execute.

[Joe9099]

Here is an screenshot..

And is it that hard to try it your selve?? Or you affraid to damage your mouse when you do to much with it?

lol very funny.... Well id rather take a look at everything i come across just to se if its worth it. And now with screenie i think u done a great job :smile:

[Rotana]

lol very funny.... Well id rather take a look at everything i come across just to se if its worth it. And now with screenie i think u done a great job :smile:

Just please note that i was the persone that release the latest clan fixes Emblem's and ranking in game....

This week the website with emblem upload will be released.. But a note on that, its only the small/licht version of the page. The full version will be private an only some people i know will have the full version..

[rodanio14]

I dont got the 2 tables

[Hakurah]

I don't have that procs... And I'm with official DB bla bla bla =P

Can you post them here? x)

[thebestkiller]

Nice Release
But...
tried it..
the ranking doesnt showup in-game :S

[-RooK-]

Nice Release
But...
tried it..
the ranking doesnt showup in-game :S

I've tested this on december '05, july, jan 07 br, march 07 br, all works fine

[azncracker99]

Yea... ummm. I cant find the "stored procedures" after i expand the database. Can somebody post a screenshot of where it is in the Mssql? TY!

[sexy fire slash]

wow bumping old threads.

Expand database go to stored procdures

[Psylithium]

Really nice, Thanks.