SQLite package
Moderator: Forum Moderator
SQLite package
I've been interested in using the SQLite package, but at the point where the guide says to type "sqlite3 <path>", the command prompt returns an invalid database. I tried creating one with sqlite3 alone, with AMXX, copied to C:/ (no folders), copied sqlite3 in the same dir, tried with and without a path, but nothing seems to work.
I've also tried this on two machines, one running WinXP Pro SP2, and another running Win2k3.
Thanks in advance.
I've also tried this on two machines, one running WinXP Pro SP2, and another running Win2k3.
Thanks in advance.
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
What? I didn't get it. please state the exact command line you are using.
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
Windows right? So you have to use Windows style slashes:
Now if you are doing it from scratch, you dont have a "C:\amxx.db" database, and the program will create one when you exit the interactive shell with the command .quit. You cannot read the database to execute SQL statements from itself, the .read command takes as input a text file, with a batch of SQL commands (normally such files have the .sql extension), so make sure of the filename you want to read from with the .read command.
Code: Select all
sqlite3 C:\amxx.db
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
The window in the foreground? It's what it should look like, it's OK. What are you trying to do?
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
OK point me to where you are stuck (feed me the post and start of sentence where you are at), so I can understand the problem.
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
Here is the exact place I'm stuck:
Thanks.
I tried with the Steam folder (although I run a stand alone server, but obviously used the correct path) as well as copying the DB into my C:/ drive root. For some reason sqlite3 just doesn't want to read the arguments I give it, or doesn't like the format. I might also try this on Linux, as I dual boot it (but it won't help at all, my server is Windows and that's ultimately where it's going to be put to use).Lazarus Long wrote: For Microsoft Windows start up the SQLite command-line program by issuing the following command in a Command Prompt (note that you must point to the exact same path where the amx_sql_db is pointing to, replace <steam folder> with the base path where you installed Steam, <steam account> with your Steam login name and <game mod folder> with the game you are running)Code: Select all
sqlite3 "<steam folder>\SteamApps\<steam account>\<game mod folder>\addons\amxmodx\data\amxx.db"
Thanks.
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
Feed me you server path, please (better yet the AMX Mod X path under your server).
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
C:/HLServer/zetaraedon/cstrike/addons/amxmodx/
[ramble]
And no I really don't care that you have my server's username, I don't get why people remove those when they post it. It's like a forum account, a username doesn't do jack if you don't have the password. It's not even a paid account, I made it with the HLDS update tool. [/ramble]
[ramble]
And no I really don't care that you have my server's username, I don't get why people remove those when they post it. It's like a forum account, a username doesn't do jack if you don't have the password. It's not even a paid account, I made it with the HLDS update tool. [/ramble]
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
I second that and the same for the STEAM ID.Hawk552 wrote:[ramble]
And no I really don't care that you have my server's username, I don't get why people remove those when they post it. It's like a forum account, a username doesn't do jack if you don't have the password. It's not even a paid account, I made it with the HLDS update tool. [/ramble]
OK, if you enter:
Code: Select all
sqlite3 "C:\HLServer\zetaraedon\cstrike\addons\amxmodx\data\amxx.db"
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!
It still seems to simply enter the program without reading the parameters. Here is another screenshot, following the exact instructions you gave. (I'm going to stop directly linking to pics, it's probably killing everyone's bandwidth)
- Lazarus Long
- Lead PITA SOB
- Posts: 618
- Joined: Tue Jul 05, 2005 9:24 pm
Humm... something is wrong, we aren't understanding each other. That is what it's supose to do, you then continue to write in the interactive SQL console the commands that follow. You are at point IV.2.3 right?
Lazarus
- Before asking anything: Search!
- Want help with Warcraft 3 FT? Ask it the right way!
- What to download to get Warcraft 3 FT running? Check the list of files!
- Need more help? Check the simple Mini-HOWTO series!