How to Remove Admin from PvP Script ?

[PlugMan]

Hello E*PvP

I'm setting up a PvP Script for local server and i see my toon with status 16 in list with normal toons

How to remove Admin's , GM's from PvP Rank script ?

[MC Flip]

The pvp rankings that are released here do not show my GM chars in the ranking page.

I'd recommend to use one of them, or at least as a guideline to use come code from it.

[SnickQ]

Tr in users_master "admin"=true or AdminLevel=255

[[MXD]Takeshi]

add where status = 0
it show just the status "normal", no ban or adm or gm....

[nephren]

Originally Posted by SnickQ

Tr in users_master "admin"=true or AdminLevel=255

Originally Posted by [MXD]Takeshi

add where status = 0
it show just the status "normal", no ban or adm or gm....

Neither SnickQ or MXD-Takeshi makes sense.

Why should he change the Database if it can be simple done in PHP ?

[MC Flip]

Originally Posted by nephren

Neither SnickQ or MXD-Takeshi makes sense.

Why should he change the Database if it can be simple done in PHP ?

I think what Takeshi meant to say is that he should try adding 'WHERE Status = 0' to the query in the pvp ranking script so it will only look for normal accounts and ignore admins and banned accounts.

[killer2p]

select CharName, K1, K2, K3, K4
from PS_GameData.dbo.Chars
inner join PS_UserData.dbo.Users_Master on Users_Master.UserUID = Chars.UserUID
Where Del = 0 and Status = 0 Order By K1 Desc

[nephren]

Originally Posted by MC Flip

I think what Takeshi meant to say is that he should try adding 'WHERE Status = 0' to the query in the pvp ranking script so it will only look for normal accounts and ignore admins and banned accounts.

I see. NVM then, my bad.

[PlugMan]

Originally Posted by MC Flip

The pvp rankings that are released here do not show my GM chars in the ranking page.

I'd recommend to use one of them, or at least as a guideline to use come code from it.

Hi Mr.Flip

i use everything from elitepvp and my rank script is from "abrasive release"

but i changed script to "eQuiNoX." Release and working good now !

Thanks everyone

[[MXD]Takeshi]

Originally Posted by MC Flip

I think what Takeshi meant to say is that he should try adding 'WHERE Status = 0' to the query in the pvp ranking script so it will only look for normal accounts and ignore admins and banned accounts.

Thanks you for explain what i mean, i'm sorry to haven't explain it before

[[ADM]SpyRow]

Originally Posted by PlugMan

Hello E*PvP

I'm setting up a PvP Script for local server and i see my toon with status 16 in list with normal toons

How to remove Admin's , GM's from PvP Rank script ?

Place on userID on PS_User admin 1 admin level 255 and he will be gone