How to Remove Admin from PvP Script ?

01/12/2018 16:15 PlugMan#1

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 ?

01/12/2018 17:23 MC Flip#2

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.

01/12/2018 18:52 SnickQ#3

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

01/12/2018 19:33 [MXD]Takeshi#4

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

01/12/2018 23:15 nephren#5

Quote:

Originally Posted by SnickQ

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

Quote:

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 ?

01/13/2018 15:42 MC Flip#6

Quote:

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.

01/13/2018 17:28 killer2p#7

Code:

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

01/13/2018 23:44 nephren#8

Quote:

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.

01/14/2018 12:04 PlugMan#9

Quote:

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

01/15/2018 13:18 [MXD]Takeshi#10

Quote:

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 :)

01/15/2018 20:37 [ADM]SpyRow#11

Quote:

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