DECLARE @bIsWhitelist TINYINT
SELECT TOP 1 @bIsWhitelist = bIsWhitelist FROM TWHITELIST
IF(@bIsWhitelist = 1)
BEGIN
SELECT TOP 1 dwUserID FROM TWHITELISTUSER WHERE dwUserID = @dwUserID
IF(@@ROWCOUNT = 0)
BEGIN
/* Not whitelisted */
RETURN 4 /* 4 = Wrong version */
END
END
Am besten ist es, wenn dieser Block unter die Prüfung nach dem Benutzernamen o.Ä. eingefügt wird.
/* Prüfung auf Benutzername */
SELECT TOP 1 @dwUserID = dwUserID, @bCheck = bCheck FROM TACCOUNT WHERE szUserID = @szUserID
IF @@ROWCOUNT = 0
BEGIN
/* Not found user */
RETURN 1
END
/* Whitelist */
DECLARE @bIsWhitelist TINYINT
SELECT TOP 1 @bIsWhitelist = bIsWhitelist FROM TWHITELIST
IF(@bIsWhitelist = 1)
BEGIN
SELECT TOP 1 dwUserID FROM TWHITELISTUSER WHERE dwUserID = @dwUserID
IF(@@ROWCOUNT = 0)
BEGIN
/* Not whitelisted */
RETURN 4 /* 4 = Wrong version */
END
END
SQL-Dateien müssen in der TGLOBAL_GSP ausgeführt werden mit Rechtsklick -> "Execute SQL file". Danach Rechtsklick -> "Refresh" und die Tabellen sind da.
[Selling] [WEB]Minecraft Whitelist System 06/09/2013 - Minecraft Trading - 0 Replies Hello,
I would like to present you updated version of UniveXNet Whitelist System.
This system is written in php and is for whitelisting players on your server. They send registration, which shows up in the system, you can approve it or deny it, also supports sending informative emails, for users, if they are added to whitelist or they are not & reason of your decision.
Stores all information in MySQL, you can look for users overview, send newsletters, ...
Created new design, based on...
[Selling] [WEB] UniveXNet Whitelist System 05/30/2013 - Minecraft Trading - 2 Replies Hello guys,
my name is Martin, and I would like to introduce my whitelist system.
About this system: This system is written in PHP, it works simply. Someone sends a whitelist registration, with their ingame name, age, email and REASON why do they want to play on your server. This registration will appear in this system, where you will just select if you want to approve it, disapprove it, or do nothing with it.
You can browse though all approved registrations, and change your mind, by...
[WEB] UniveXNet Whitelist System 05/29/2013 - Minecraft Mods, Textures, Skins & Maps - 4 Replies Hello guys,
my name is Martin, and I would like to introduce my whitelist system.
About this system: This system is written in PHP, it works simply. Someone sends a whitelist registration, with their ingame name, age, email and REASON why do they want to play on your server. This registration will appear in this system, where you will just select if you want to approve it, disapprove it, or do nothing with it.
You can browse though all approved registrations, and change your mind, by...
MysticCraft 1.5_01[Whitelist][Free Build][RPG][24/7][Level-System] 05/21/2011 - Minecraft Server Advertising - 4 Replies Original Thread von MysticCraft-Minecraft!
Hallo ich wollte euch heute mal meinen Minecraft Server zeigen er ist ein Stabiler RootServer mit VIP-Systemen und es ist ein RPG Server bzw. eon Survival Server wer auf den Server drauf möchte muss sich allerdings hier oder in unserem Forum BEwerben alle Details zum Server findet ihr hier und im Forum danke!
Ein Muster wie die Bewerbung für die Whitelist aussehen soll
Name:
InGameName: