Where is the link ?
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Show posts MenuQuote from: Doom_Kill3R on Jun 25, 2016, 01:45 PMAnswered several times already, pickup ids start from 0 and rowids in database start from 1. If you got some sense you'll know the reason now.Man i know that :| That's not what i'm asking, for. I know the pickup id starts from 0, while rowid starts from 1! so i've to add another pickup in
Quote from: KAKAN on Jun 25, 2016, 01:09 PMK Topic locked.Quote from: Striker on Jun 25, 2016, 12:31 PMhe said, "Read the fucking manual", read it and your problem will be solvedQuote from: . on Jun 25, 2016, 12:21 PMThis is what happens when someone didn't, once in you entire life, tell you: RTFMSir please help.
Quote from: . on Jun 25, 2016, 12:21 PMThis is what happens when someone didn't, once in you entire life, tell you: RTFMSir please help.
local q = QuerySQL( db, "SELECT * FROM Cars WHERE rowid = '" + text.tointeger() + "'" );
if ( GetSQLColumnData( q, 3 ) == player.Name )
{
local b = QuerySQL( db, "SELECT * FROM Model WHERE Model LIKE '" + GetSQLColumnData( q, 2 ) + "'" );
SetCash( player, GetCash( player ) +GetSQLColumnData( b, 1 ).tointeger() / 2 ); local v = FindVehicle( text.tointeger() );
if ( v ) Message( "Player [#897FA4][" + player.Name + "][#FCB000] sold his Vehicle:[#EC0E0E][ " + GetSQLColumnData( q, 2 ) + " ]" ), QuerySQL(db, "DELETE FROM Cars WHERE rowid = '" + text.tointeger() + "' " ),v.Delete();
but then :| /sellcar doesn't work with the ID 22( but how ? The ID :22 Car has been deleted, so the ID:23 and the row id both should become 22 :| ) Why guys ? Any solution?
Quote from: MaTaDeToR on Mar 20, 2016, 04:03 AM...The server is AWESOME!
Quote from: S.L.C on Mar 23, 2016, 09:00 PMI'd like to ask people what features do you think are missing from the official Squirrel plug-in so that I could implement them in the one that I'm working on.Can't we do smoke/cigarette like we use to do in the game when we type a cheat?
Speak your mind here about situations where certain things would've made your life easier and you think would make sense to have in a scripting plug-in.
Keep in mind that your suggestion is open for debate. And if that feature already exists I'll give you an example of it. And if it's planed for later then I'll discuss the way I thought to implement it.
I'll be waiting for your feedback.
NOTE: This plug-in might be obsolete in near future since the devs are working on something else. This is for those that want to stick with Squirrel because that's what they've got used to.
Quote from: S.L.C on Mar 12, 2016, 09:43 AMProbably no. That board requires that a server is at least hosted on a static IP/Hostk Thanks
Quote from: Thijn on Mar 09, 2016, 06:45 AMYes, I meant objectWell, I guess i'm noob myself no? I've created two Tables, with objects IDS, well My English will surely make you confuse, so simply.
Try printing the query, and running it yourself using a sqlite browser:
print("SELECT Chocolate FROM Accessories WHERE ID ='" + object.ID + "'");
Quote from: Thijn on Mar 08, 2016, 04:59 PMWhat returns null?1.Well the query get's simply fail, so whenever any thing that i want to return/get from Database returns null i.e : - ClientMessage("You have found a Chocalate! Containing null Vitamins!",player,255,255,0); also I guess you mean the object ID.
Is the row actually there? Are you sure you got the right pickup ID? Did you try printing the pickup ID and checking your database?
There's plenty of things you could do yourself to debug this..