[API]

Before I explain, you are trying to make an IP into a single cell and be able to turn it back into an IP, correct?

[n3wton]

Not really.
Yes the ip address needs to be turned into a singal number but I'm using geocitylite to work out the city locations from the IP adress. http://www.maxmind.com/app/csv thats where it tells you how to get the data from the ip address to an ip number from which you can query the database to atain the city location.

yours
n3wton

[FaTony]

Regular arithmetics won't work here because SourcePawn doesn't have unsigned cells. Use the shifts already and give up your multiplication.

[n3wton]

but how would I use the shifts, because geoipcity doesnt take just the ipaddress without the dots, it takes it with the multiplication.

Yours
N3wton

[Scone]

I don't think his aim here is to pack it into a cell, but rather to be able to use the result of the multiplication as part of the MySQL query, i.e. get a base 10 number out and use it as part of a string.

The solution is simple: perform the multiplication in MySQL. Feed the four segments of the IP address into the query, and multiply each part by whatever you want.

"SELECT 16777216 * 16777216" successfully returns 281474976710656, so I doubt you'll run into any problems with length.

[n3wton]

@Scone
Thats a great idea, but for some unknown reason, its not working, when I manually enter the equation into my own SQlite database it returns the correct value, but when I run the same query via SOurceMod, I still get the negative value

Did you get

"SELECT 16777216 * 16777216" successfully returns 281474976710656

Via source mod? if so how?

Here's my code, that I'm using...

SubIP[0] = "153";
SubIP[1] = "104";
SubIP[2] = "162";
SubIP[3] = "98";
new String:IPseg[256];
Format( IPseg, 256, "SELECT (16777216 * %s) + (65536 * %s) + (256 * %s) + %s", SubIP[0], SubIP[1], SubIP[2], SubIP[3] ); 
new Handle:LocNumberQ = SQL_Query(GeoCityDB, IPseg);
SQL_FetchRow( LocNumberQ );
new String:IPnum[30] = "NULL";
SQL_FetchString( LocNumberQ, 0, IPnum, 30 );
CloseHandle( LocNumberQ );
PrintToChat( client, "[SQlite] Ip Number : %s", IPnum );

But that returns
[SQlite] Ip Number : -1737906334

Yours
N3wton

[FaTony]

Why would initialise a string to "NULL"? That would be a definite memory leak in C++. God bless SourcePawn's simplicity. On the other note, i'm confised, that code should work as you don't touch integers... Check your SQLite settings.

[Scone]

I just tried "SELECT 16777216 * 16777216" in the SQLite console app, and it gave me the correct result. As far as I can see, there's no reason for your code not to work.

[n3wton]

Ok... this is really wierd, I fiqured there was lots going on when I did the query, so I'd right a new plugin that just did 1 query, and still no luck... Infact, if the query is SELECT 16777216 * 16777216 the result is 0...

#pragma semicolon 1

#include <sourcemod>
#include <sdktools>

#define CVAR_FLAGS FCVAR_PLUGIN|FCVAR_SPONLY|FCVAR_NOTIFY
#define VERSION "1.0.0"

new Handle:SQliteDB = INVALID_HANDLE;
new bool:SQliteConnected = false;

public Plugin:myinfo =
{
    name = "SQliteErrorExample",
    author = "n3wton",
    description = "Showing the error of multiplication in SQlite",
    version = VERSION
};

public OnPluginStart()
{
    new String:error[64];
    SQliteDB = SQLite_UseDatabase( "sourcemod-local", error, 64 );
    if( SQliteDB != INVALID_HANDLE )
    {
        SQliteConnected = true;
    }
}

public OnClientPostAdminCheck( client )
{
    if( client != 0 && SQliteConnected )
    {
        if( !IsFakeClient(client) )
        {
            new String:Query[256];
            Format( Query, 256, "SELECT 16777216 * 155" );
            new Handle:TableQuery = SQL_Query( SQliteDB, Query );
            if( TableQuery != INVALID_HANDLE )
            {
                new String:Result[20];
                SQL_FetchRow( TableQuery );
                SQL_FetchString( TableQuery, 0, Result, 20 );
                PrintToChat( client, "[SQlite] Query : %s", Query );
                PrintToChat( client, "[SQlite] Result : %s", Result );
            }
        }
    }
}

Thats the code, I was wondering if it would work with SQL databases rather than SQlite, but the thing is SQL databases would be pointless for what i'm using them for...

Yours
N3wton

[Scone]

That doesn't make sense, SQLite only uses 64 bit integers - you couldn't limit yourself to 32 bit ones even if you wanted to.

Perhaps SourceMod uses an out-of-date/oddly configured version of SQLite? You'd have more luck using MySQL, as the server is totally separate.