Clanstats in database

[Nihongo^]

hello im using kartoz GetTag( string ) function we can add clans manually in note pad
but is it possible to add them into a database instead adding it on NOTEPAD ?

function GetTag( string )
{
        local
        Tag = FindClan( string ).toupper(),                 // Getting the clan tag & switching it to upper case just to match the table regardless of case.
        // There needed the alliance in big letters
        // Clan Table for defining slots of clan sublevels [ Trainee, Rookie & Scout ]
        Clans = { VU_T = "VU", VU_R = "VU", TLK = "ULK", TLKR = "ULK", MKT = "MK", MKS = "MK", DKR = "DK", DKT = "DK", DKS = "DK" };
       
         if ( Tag in Clans )    // Checking if the tag obtained through findclan( string ) is in Clan Table or not
        {
             return Clans[ Tag ];      // If yes, its time to calling their corresponding slots from the table
        }
        else return FindClan( string );    // if not, then tag will be as it is [ If no slot will be alloted for a clan then script may recognize sublevels as other clans ]
}

[EK.IceFlake]

you need to use arrays
you also need mysql or sqlite
then you need to got a table called 'clans'
you will got it from them, and use this function:
array.push(/*value*/);
to add a value to the array
and then you will use array.find

good luck

[Nihongo^]

can u give example  ?

[EK.IceFlake]

im feeling very lazy now so this code is probably poorly written and might have some errors

Code Select Expand

function onScriptLoad()
{
    clandb <- ConnectSQL("clans.sqli");
    clans <- [];
    local clanq = QuerySQL(clandb, "select * from clans");
    while (GetSQLNextRow(clanq))
    {
        clans.push(GetSQLColumnData(clanq, 0));
    }
}
now you will have a global array called 'clans' you can use it anywhere you want with ex clans.find("EK");
you will need to add the table clans by hand, with the first row being the clan tag
you can also script the server to do that with this query:
create table if not exists clans (tag text)
and you can add additional clan information if you wish

[Nihongo^]

Thanks for reply well its see like this ? ( just example )

[Cool]

Wrong Board next time post in right place.

[Nihongo^]

Wrong Board next time post in right place.

will you please tell me
which board is for server bugs relate and for Discussion

[Thijn]

This one

[EK.IceFlake]

Thanks for reply well its see like this ? ( just example )

as long as that clan tag thing is on first row, yes
also, any value other than the first row is ignored
you need to add, for example, VU and VU_T seperately

[Nihongo^]

what about gettag function where i place it  ?

[Shovon^]

can u give me the script of clan after you figure put the fix??? I also need it

[KAKAN]

can u give me the script of clan after you figure put the fix??? I also need it

another nerd here lol

what about gettag function where i place it  ?

Just edit the function a bit to use the array instead of that table.

[Nihongo^]

can u give me the script of clan after you figure put the fix??? I also need it

another nerd here lol

what about gettag function where i place it  ?

Just edit the function a bit to use the array instead of that table.

KAKAN will you please give little bit example ? i mean a way to use that array on my GetTag function ? i'm confused

[KAKAN]

can u give me the script of clan after you figure put the fix??? I also need it

another nerd here lol

what about gettag function where i place it  ?

Just edit the function a bit to use the array instead of that table.

KAKAN will you please give little bit example ? i mean a way to use that array on my GetTag function ? i'm confused

sure. Take this as an example:-

Code Select Expand

function GetTag( tag ){
//The global array is 'clans'
local clan = clans.find( tag.tolower() ); /*Find the tag.
 Everything must be lowercase in your array.
 Else simply remove the .tolower();
*/
if( tag == null ){
//The clan tag isn't registered here...
return 0;
//Do whatever you want.
}
else return clan; //The clan is registered
//If something unknown happens( which will never will! )
return 0;
}Usage:

Code Select Expand

print( GetTag( "VU" ) )Returns: VU
Example #2:

Code Select Expand

print( GetTag( "SD" ) );Returns: 0

[KAKAN]

well its give error when i put

print( GetTag( "VU" ) )

to check the clans

Remove all the spaces from that function and then add it yourself.