Ranking error help

[misterbit]

hello all, when it lodges in the city and within the game, it gives me error on ranking, does anyone know how to solve the problem?

[MentaL]

[gozo333]

http://forum.ragezone.com/f611/world...system-795526/

[killburne]

i´d think it is cause you don´t have data in the tables of wrk.
you have to get atum2_db_worldranking and connect with your admin tool.

[julioclitwin]

How can atum2_db_worldranking?

[WARonline]

How can atum2_db_worldranking?

Create it.

[misterbit]

Sorry you please explain how to do it?

[DragonLord]

Just give up.
If you can't perform even the utmost basic functions, you should not be doing any of this.
Come back when you've been to a proper school that taught you English and common sense.

[misterbit]

I just wanted to know which fields are created in the db atum2_db_WorldRanking.
type PvP - level-hungry?

[mKeey]

Copy it from Account.

[WARonline]

You can't copy the tables wrk from atum2_db_account it won't let you to do it.

Only the procedures you only execute in that atum2_db_WorldRanking.

[mKeey]

Learn SQL. Than come back and say again what you can't copy it.

[WARonline]

Dude you have to take them out from atum2_db_account so u can copy them there;)
You make them in scripts and after u delete then execute in atum2_db_WorldRanking.

If you say to copy them tell him the entire process. As i did now.

Otherwise if he want to only copy them it won't work because they already exist.

[misterbit]

atum2_db_worldranking the tables must be created equal to those of atum2_db account?
and must be saved with the same name?
wrk_fame
wrk_level
wrk_pvp

and in this case should be deleted from atum2_db account?

[yokohiro]

use this. (OMG)
ps: don't remove N'
change only YOUR SERVER NAME HERE

ps: do not forget to edit it: td_wrk_selfServerGroupInfo (atum2_db_1)
and it: td_wrk_allServiceInfo, td_wrk_selfServiceInfo (atum2_db_account)

USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_delete_otherAllFameRanking]
        @i_ExcludeServiceUID = 10061

SELECT    'Return Value' = @return_value

GO


USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_delete_otherAllLevelRanking]
        @i_ExcludeServiceUID = 10061

SELECT    'Return Value' = @return_value

GO


USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_delete_otherAllPVPRanking]
        @i_ExcludeServiceUID = 10061

SELECT    'Return Value' = @return_value

GO

USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_delete_selfAllFameRanking]
        @i_ServiceUID = 10061,
        @i_ServGroupID = 10061

SELECT    'Return Value' = @return_value

GO



USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_delete_selfAllLevelRanking]
        @i_ServiceUID = 10061,
        @i_ServGroupID = 10061

SELECT    'Return Value' = @return_value

GO


USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_delete_selfAllPVPRanking]
        @i_ServiceUID = 10061,
        @i_ServGroupID = 10061

SELECT    'Return Value' = @return_value

GO


USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_arrange_selfAllFameRanking]
        @i_ServiceUID = 10061,
        @i_ServGroupID = 10061,
        @i_ServGroupName = N'YOUR SERVER NAME HERE'

SELECT    'Return Value' = @return_value

GO


USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_arrange_selfAllLevelRanking]
        @i_ServiceUID = 10061,
        @i_ServGroupID = 10061,
        @i_ServGroupName = N'YOUR SERVER NAME HERE'

SELECT    'Return Value' = @return_value

GO


USE [atum2_db_1]
GO

DECLARE    @return_value int

EXEC    @return_value = [dbo].[atum_wrk_arrange_selfAllPVPRanking]
        @i_ServiceUID = 10061,
        @i_ServGroupID = 10061,
        @i_ServGroupName = N'YOUR SERVER NAME HERE'

SELECT    'Return Value' = @return_value

GO

[misterbit]

tnx very very good

[simca]

make a db.bak compelete with this.