Topics

Hey Guys! What's Going On?
I was just trying to create a new feature & I have one question
Can we Get Country Name from IPtoCountry Like As i Wanted to Implement this

Code Select Expand

function SetLanguage( player )
{
      local Country = IpToCountry( player.IP );
      if ( IpToCountry( player ) == How to Get Country name )
{
  status[ player.ID ].Language = "English";
}
}


Thanks!

Regards, Terror Styles!

[What I wanted to fix?]

Hey Guys What's going on?

I was trying to Implement my Cash System But Faced a bit problem

I have created Two Functions SetCash & GetCash  Also Create Table in Database

Codes:
Function SetCash, GetCash, Cash

Code Select Expand

function GetCash( player )
{
   local v =  GetSQLColumnData( QuerySQL( DB, "SELECT Cash FROM Cash WHERE Name='" + player.Name+"'" ), 0 );
   if ( v ) return v.tointeger();
   else return 0;
}
function Cash( player )
{
local q = QuerySQL( DB, "SELECT * FROM Cash WHERE Name='" + player.Name+ "'" );
status[ player.ID ].Cash = GetSQLColumnData( q, 1 );
status[ player.ID ].Bank = GetSQLColumnData( q, 2 );
}
function SetCash( player, amount )
{
      status[ player.ID ].Cash = amount.tointeger();
      QuerySQL(DB, "UPDATE Cash SET Cash='" +  amount.tointeger() + "' WHERE Name='" + player.Name + "'");   
}

Database Loaded

Code Select Expand

function CreateTables()
{
QuerySQL( DB, "CREATE TABLE IF NOT EXISTS Cash( Name VARCHAR(32),Cash INT(15), Bank INT(15) )" );
}

I have added this on PlayerDeath

Code Select Expand

SetCash( player, GetCash( player ) -1000);

But When I type /kill it Doesn't Decrease my Cash but do in Database







What I wanted to fix?
I wanted Cash to be increase & decrease with real cash provided in Gta Vice City!

Hey What's Going on Guys?

I am trying to Add Clanstats in Anik GUI Registration System Everything Works Fine But
When Player Join It Pop An Error

Screenshot:



Error Lines

onPlayerJoin

Code Select Expand

AccInfo(player);AccInfo Function

Code Select Expand

FreeSQLQuery( Clan );
AccInfo Function

Code Select Expand

function AccInfo(player)
{
 local q = QuerySQL(DB, "SELECT * FROM Accounts WHERE Name = '" + escapeSQLString(player.Name) + "'");
 if (q)
 {
  status[player.ID].Password = GetSQLColumnData(q, 2);
  status[player.ID].Level = GetSQLColumnData(q, 3);
  status[player.ID].UID = GetSQLColumnData(q, 5);
  status[player.ID].IP = GetSQLColumnData(q, 6);
  status[player.ID].AutoLogin = GetSQLColumnData(q, 7);
  status[player.ID].Registered = true;
  if ((player.UID == status[player.ID].UID) || (player.IP == status[player.ID].IP))
  {
   if (status[player.ID].AutoLogin == "true")
   {
    MessagePlayer("[#CCFF66]** Welcome back to the server.", player);
    MessagePlayer("[#CCFF66]** You've been auto logged in, to disable this, type /autologin [ Toggles automatically ]", player);
    status[player.ID].LoggedIn = true;
local Clan = GetSQLColumnData( QuerySQL(DB, "SELECT Clan FROM Accounts WHERE Name = '"+player.Name+"' " ), 0 );

local w = QuerySQL( Clans, "SELECT * FROM ClanMembersRequest WHERE Player LIKE '" + player.Name + "' COLLATE NOCASE" );
if (w)
{
status[ player.ID ].ClanRequest = true;
status[ player.ID ].ClaneTag = GetSQLColumnData( w, 1 );
status[ player.ID ].Clane = GetSQLColumnData( w, 2 );
status[ player.ID ].ClaneState = GetSQLColumnData( w, 3 );
MessagePlayer( "[CLAN-Request] Clan [ " + status[ player.ID ].Clane + " ].Use /acceptclan or /rejectclan.",player);
}
FreeSQLQuery( w );

if ( Clan != "None" )
{
local r = QuerySQL( Clans, "SELECT Tag FROM ClanStats WHERE Clan LIKE '"+Clan+"'" );
if (r)
{
local
Tag = GetSQLColumnData( r, 0 ),
t = QuerySQL( Clans, "SELECT * FROM ClanMembers WHERE Clan LIKE '"+Clan+"'" ),
Owner = GetSQLColumnData( t, 1 ),
Leader1 = GetSQLColumnData( t, 2 ),
Leader2 = GetSQLColumnData( t, 3 ),
Leader3 = GetSQLColumnData( t, 4 ),
Users = GetSQLColumnData( t, 5 );
if ( Owner == player.Name )
{
status[ player.ID ].Clan = Clan;
status[ player.ID ].ClanTag = Tag;
status[ player.ID ].ClanState = "Owner";
}
if ( Leader1 == player.Name )
{
status[ player.ID ].Clan = Clan;
status[ player.ID ].ClanTag = Tag;
status[ player.ID ].ClanState = "Leader1";
}
if ( Leader2 == player.Name )
{
status[ player.ID ].Clan = Clan;
status[ player.ID ].ClanTag = Tag;
status[ player.ID ].ClanState = "Leader2";
}
if ( Leader3 == player.Name )
{
status[ player.ID ].Clan = Clan;
status[ player.ID ].ClanTag = Tag;
status[ player.ID ].ClanState = "Leader3";
}
if ( Users.find( player.Name ) )
{
status[ player.ID ].Clan = Clan;
status[ player.ID ].ClanTag = Tag;
status[ player.ID ].ClanState = "Users";
}
FreeSQLQuery(t);
}
FreeSQLQuery(r);
}

CheckPlayerClan( player );
FreeSQLQuery( Clan ); [b]This Line Pop error[/b]
   }
   else
   {
    MessagePlayer("[#CCFF66]** Welcome back to the server.", player);
    MessagePlayer("[#CCFF66]** Your nick is registered. Please login in order to access services.", player);
   }
  }
  else
  {
   MessagePlayer("[#CCFF66]** Welcome back to the server.", player);
   MessagePlayer("[#CCFF66]** Your nick is registered. Please login in order to access services.", player);
  }
 }
 else
 {
  MessagePlayer("[#CCFF66]** Welcome to the server.", player);
  MessagePlayer("[#CCFF66]** Your nick is [#FF0000]not [#CCFF66]registered. Please register in order to access services.", player);
 }
 FreeSQLQuery(q);
}