SQL Selecting a Row?
Okay, so, I have this.
Code:
|
Re: SQL Selecting a Row?
Quote:
|
Re: SQL Selecting a Row?
Quote:
|
Re: SQL Selecting a Row?
if you want to delete all rows where a value is for example <= 37.0:
Code:
'DELETE FROM table WHERE x<=37.0'Code:
'DELETE FROM table WHERE entity_id=%d'you could also set a PRIMARY KEY id AUTO INCREMENT and set your entity_id as UNIQUE you see, a lot of possible solutions :wink: |
Re: SQL Selecting a Row?
Quote:
|
Re: SQL Selecting a Row?
You'd have to dispatch a query that read something like:
Code:
DELETE FROM table WHERE originx='%f',originy='%f',originz='%f'; |
Re: SQL Selecting a Row?
Quote:
I only use you, Hawk. But anyways, this method I tried. But the origins are slightly off. I can't try yet, but as Shorty said. I might just do Origin <= # AND Origin >= # |
Re: SQL Selecting a Row?
Oh, you can use the data layer then. Look in ApolloRP_Data.inc. It's a wrapper for a keytable that saves itself to SQL. If you need examples, check out ARP_JailMod (included with it) and ARP_Fero (extra plugin I posted on the site). You shouldn't need access to the database for anything other than insanely long entries.
|
| All times are GMT -4. The time now is 09:18. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.