[HELP] LEADERBOARDS not showing reputation

[Krecikv15]

Why my char not show my reputation ????


Screenshots :

[MentaL]

[LukasCCB]

check your api =\

[GetRektBambi]

Do you have your [WZ_DB_GenerateLeaderboards] to update automatically on interval?

If not, first step would be to run that function. Then go ahead and check if your leaderboard updated.

[Krecikv15]

GetRektBambi how to do it ?

[GetRektBambi]

Confirm your leaderboard updated when you ran the function, otherwise next step is useless

[Krecikv15]

I have this Green RUN klick this or what ???




- - - Updated - - -

THIS IS MY CODE look






ALTER PROCEDURE [dbo].[WZ_DB_GenerateLeaderboards]
AS
BEGIN
SET NOCOUNT ON;


-- Leaderboard IDs:
-- SOFTCORE:
-- 00 - XP
-- 01 - TimePlayed
-- 02 - KilledZombies
-- 03 - KilledSurvivors
-- 04 - KilledBandits
-- 05 - Reputation DESC - her2
-- 06 - Reputation ASC - bandits
-- HARDCORE:
-- 50 - XP
-- 51 - TimePlayed
-- 52 - KilledZombies
-- 53 - KilledSurvivors
-- 54 - KilledBandits
-- 55 - Reputation DESC - heroes
-- 56 - Reputation ASC - bandits

-- 00 - XP
truncate table Leaderboard00
insert into Leaderboard00
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 --and d.IsDeveloper=0
order by c.XP desc


-- 01 - TimePlayed
truncate table Leaderboard01
insert into Leaderboard01
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 --and d.IsDeveloper=0
order by c.TimePlayed desc


-- 02 - KilledZombies
truncate table Leaderboard02
insert into Leaderboard02
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 --and d.IsDeveloper=0
order by c.Stat00 desc


-- 03 - KilledSurvivors
truncate table Leaderboard03
insert into Leaderboard03
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 --and d.IsDeveloper=0
order by c.Stat01 desc


-- 04 - KilledBandits
truncate table Leaderboard04
insert into Leaderboard04
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 --and d.IsDeveloper=0
order by c.Stat02 desc


-- 05 - Reputation DESC - heroes
truncate table Leaderboard05
insert into Leaderboard05
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 and c.Reputation>=10 --and d.IsDeveloper=0
order by c.Reputation desc


-- 06 - Reputation ASC - bandits
truncate table Leaderboard06
insert into Leaderboard06
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=0 and c.Reputation<=-5 --and d.IsDeveloper=0
order by c.Reputation asc


-- 50 - XP
truncate table Leaderboard50
insert into Leaderboard50
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 --and d.IsDeveloper=0
order by c.XP desc


-- 51 - TimePlayed
truncate table Leaderboard51
insert into Leaderboard51
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 --and d.IsDeveloper=0
order by c.TimePlayed desc


-- 02 - KilledZombies
truncate table Leaderboard52
insert into Leaderboard52
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 --and d.IsDeveloper=0
order by c.Stat00 desc


-- 03 - KilledSurvivors
truncate table Leaderboard53
insert into Leaderboard53
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 --and d.IsDeveloper=0
order by c.Stat01 desc


-- 04 - KilledBandits
truncate table Leaderboard54
insert into Leaderboard54
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 --and d.IsDeveloper=0
order by c.Stat02 desc


-- 05 - Reputation DESC - heroes
truncate table Leaderboard55
insert into Leaderboard55
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 and c.Reputation>=10 --and d.IsDeveloper=0
order by c.Reputation desc


-- 06 - Reputation ASC - bandits
truncate table Leaderboard56
insert into Leaderboard56
select top(2000)
c.CustomerID, c.CharID, c.Gamertag, c.Alive, c.XP, c.TimePlayed, c.Reputation,
c.Stat00, c.Stat01, c.Stat02, c.Stat03, c.Stat04, c.Stat05, c.GameServerId, c.ClanID
from UsersChars c
join UsersData d on d.CustomerID=c.CustomerID
where d.AccountStatus=100 and c.Hardcore=1 and c.Reputation<=-5 --and d.IsDeveloper=0
order by c.Reputation asc




END

- - - Updated - - -

Thanks man I got <3 solved

- - - Updated - - -

GetRektBambi You are very helpfull Thanks man

[GetRektBambi]

Thanks man I got <3 solved

- - - Updated - - -

GetRektBambi You are very helpfull Thanks man

Glad you got there in the end :)

and No problem

[Oosmar02]

removed ...
sorry