Vice City: Multiplayer

Server Development => Scripting and Server Management => Topic started by: Mohamed Boubekri on Nov 18, 2017, 02:54 PM

Title: Helppppp In Command /baninfo
Post by: Mohamed Boubekri on Nov 18, 2017, 02:54 PM
Hello Guys, i Have Command /baninfo Its Work Fine But //.

if Me Do /baninfo Say me Info for my self

i want to see info ban for other player. [ plr.name ) xd

else if ( cmd == "baninfo" )
{
local q = QuerySQL( db, "SELECT * FROM Bans WHERE Name='" + text + "' COLLATE NOCASE" );
if (!q) MessagePlayer( "[Error] - The player is not banned", player );
else
{
MessagePlayer( "[#00ffff][INFO][#ffffff] Player Name Found!", player );
MessagePlayer( "[#00ffff][INFO][#ffffff] Player : " + text, player );
MessagePlayer( "[#00ffff][INFO][#ffffff] IP : " + GetSQLColumnData( q, 1 ), player );
MessagePlayer( "[#00ffff][INFO][#ffffff] Banned by : " + GetSQLColumnData( q, 2 ), player );
MessagePlayer( "[#00ffff][INFO][#ffffff] Reason : " + GetSQLColumnData( q, 3 ), player );
}
}
[/]

                                                                              Helppppppppppp :'(


Title: Re: Helppppp In Command /baninfo
Post by: =RK=MarineForce on Nov 18, 2017, 04:11 PM
From Database?
Title: Re: Helppppp In Command /baninfo
Post by: Mohamed Boubekri on Nov 18, 2017, 04:28 PM
Yassssssss
Title: Re: Helppppp In Command /baninfo
Post by: Mohamed Boubekri on Nov 18, 2017, 04:35 PM
Problem Solved By Me.
Just i Added That Line.

local q = QuerySQL( db,  "SELECT * FROM SubBans WHERE Name='" + text + "'" );
Thanks To @=RK=MarineForce Give me Idea !

Topic Locked.