Topic: Bitcoin Camming Site - page 4. (Read 26586 times)
Remember the dot commands are for scripting those commands are for opening a SQLite3 shell, I will look and test later, what OS? So I can create a VM
Still not it:
sqlite3: Error: too many options: ".output"
Use -help for a list of options.
I used the help function and try to fix it myself (the dot-commands are not listed) but was unable to get it working. Here is the help info:
root@cam4btc:/var/www# sqlite3 -help
Usage: sqlite3 [OPTIONS] FILENAME [SQL]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist.
OPTIONS include:
-help show this message
-init filename read/process named file
-echo print commands before execution
-[no]header turn headers on or off
-bail stop after hitting an error
-interactive force interactive I/O
-batch force batch I/O
-column set output mode to 'column'
-csv set output mode to 'csv'
-html set output mode to HTML
-line set output mode to 'line'
-list set output mode to 'list'
-separator 'x' set output field separator (|)
-stats print memory stats before each finalize
-nullvalue 'text' set text string for NULL values
-version show SQLite version
sqlite3: Error: too many options: ".output"
Use -help for a list of options.
I used the help function and try to fix it myself (the dot-commands are not listed) but was unable to get it working. Here is the help info:
root@cam4btc:/var/www# sqlite3 -help
Usage: sqlite3 [OPTIONS] FILENAME [SQL]
FILENAME is the name of an SQLite database. A new database is created
if the file does not previously exist.
OPTIONS include:
-help show this message
-init filename read/process named file
-echo print commands before execution
-[no]header turn headers on or off
-bail stop after hitting an error
-interactive force interactive I/O
-batch force batch I/O
-column set output mode to 'column'
-csv set output mode to 'csv'
-html set output mode to HTML
-line set output mode to 'line'
-list set output mode to 'list'
-separator 'x' set output field separator (|)
-stats print memory stats before each finalize
-nullvalue 'text' set text string for NULL values
-version show SQLite version
sqlite3: Error: too many options: "html"
I needed to change the second line to:
but it ran. it didn't create a "schedule.html" in the directory I ran it though and also not in my root directory. Where can I look for the file? lol
Code:
if [ "$db" = "$1" ]
but it ran. it didn't create a "schedule.html" in the directory I ran it though and also not in my root directory. Where can I look for the file? lol
https://gist.github.com/2984812
this will output it to html that is all i got for now I have to work on it later but for something quick
and it would work like this
this will output it to html that is all i got for now I have to work on it later but for something quick
and it would work like this
Code:
scheduleToHtml.sh -db
Sqlite3 is installed. The format of the db is as follows:
assert(con:execute("Create TABLE IF NOT exists scheduledShows(id INTEGER PRIMARY KEY AUTOINCREMENT, performer varchar(255), showName varchar(255), estimatedDuration INTEGER, startTime INTEGER)"))
With startTime as the number of seconds since 1970 (milliseconds/1000 because otherwise it would choke the SQLite db which wold not return the correct value).
I have no experience with writing and scheduling bash scripts under Linux. Do you (or anyone else here)? Otherwise I'll figure it out. Thanks for the idea anyway
assert(con:execute("Create TABLE IF NOT exists scheduledShows(id INTEGER PRIMARY KEY AUTOINCREMENT, performer varchar(255), showName varchar(255), estimatedDuration INTEGER, startTime INTEGER)"))
With startTime as the number of seconds since 1970 (milliseconds/1000 because otherwise it would choke the SQLite db which wold not return the correct value).
I have no experience with writing and scheduling bash scripts under Linux. Do you (or anyone else here)? Otherwise I'll figure it out. Thanks for the idea anyway
This is the best Idea i can get is install sqlite3 and create a bash script to output it to rss, probably you have to put it on a cron for every hour or so
I would have done this already if it were simple. The Schedule is stored in a very simple SQLite DB and I am working on a server with nothing installed (just a webserver and the rendez-vous server and its dependencies (LUA/SSL/SQLite for LUA)).
So if any of you know of a simple way to extract the data from the SQLite DB dynamically and make it available in HTML/RSS/Plain Text I am all ears and will get on it when I get back. Otherwise I'll need to install something (likely PHP) which is quite heavyweight for the intended purpose.
So if any of you know of a simple way to extract the data from the SQLite DB dynamically and make it available in HTML/RSS/Plain Text I am all ears and will get on it when I get back. Otherwise I'll need to install something (likely PHP) which is quite heavyweight for the intended purpose.
Please provide a URL that shows the schedule using plain old HTML.
If he is going to do that, he might as well make the RSS feed of the schedule they would take the same amount of time using a php RSS library http://simplepie.org/
Please provide a URL that shows the schedule using plain old HTML.
Okay this http://cam4btc.com/Main.apk will work for Android only (IvebeenBit tested it for me, thank you ). There are a lot of limitations (but it does work):
* I cannot throw alerts so I cannot notify the user when something goes wrong
* Scheduling is disabled
* IveBeenBit had trouble fitting everything on his screen (my emulator is fine though)
* IveBeenBit could not use the chat (my emulator is fine though)
* Broadcasting only
Note that this is quickly ported and could contain some bugs. Tomorrow I'll leave for my holiday so other platforms will have to wait a bit
Enjoy, shows out in the field could be really awesome
). There are a lot of limitations (but it does work):* I cannot throw alerts so I cannot notify the user when something goes wrong
* Scheduling is disabled
* IveBeenBit had trouble fitting everything on his screen (my emulator is fine though)
* IveBeenBit could not use the chat (my emulator is fine though)
* Broadcasting only
Note that this is quickly ported and could contain some bugs. Tomorrow I'll leave for my holiday so other platforms will have to wait a bit
Enjoy, shows out in the field could be really awesome
So there is a Dragonfly show soon. Sorry but it's too late for me
http://www.adobe.com/devnet/air/articles/packaging-air-apps-ios.html
we need a self signed IPA, just an air file is no good
we need a self signed IPA, just an air file is no good
Did you click the link? It explain everything there (source is Adobe, all Mobile platforms that are supported are discussed including Android and iOS).
I don't have the time to re-engineer everything on a new platform. I might do that sometime in the future but this
I don't have the time to re-engineer everything on a new platform. I might do that sometime in the future but this
no it is a wate of time to try get it to work on iphone, also why don't you convert the air app to a native apk for android cause for android you can just host your own apk and have people install that way it would be easier
Oh I'm sorry for wasting your time I have never tried to install an air application on a mobile device and reckoned it would be the same as on a pc. On a pc (if you have the air player installed) it is as easy as double clicking the air file and it will automatically install.
BTW: Unzipping the air file is definitely not the right way to go, I have packaged it in an air wrapper for the phone to be able to run it, if you take it appart it won't work at all.
Well I did some Googling and I think I know why it didn't work for you, you need to allow the installation of apps from unknown sources (ME!
) on your phone before it will install it
End users of your app can install the AIR runtime and AIR applications using the normal application and distribution mechanism for their device.
On Android, for example, users can install applications from the Android Market. Or, if they have allowed the installation of apps from unknown sources in the Application settings, users can install an app by clicking a link on a web page, or by copying the application package to their device and opening it. If a user attempts to install an Android app, but doesn’t have the AIR runtime installed yet, then they will be automatically directed to the Market where they can install the runtime.
On iOS, there are two ways to distribute applications to end users. The primary distribution channel is the Apple App Store. You can also use ad hoc distribution to allow a limited number of users to install your application without going though the App Store.
See http://help.adobe.com/en_US/air/build/WSfffb011ac560372f-5d0f4f25128cc9cd0cb-7ff6.html for more information
So the steps to be taken are (for Android):
1) Go to application settings and allow the installation of apps from "unknown" sources
2) Download the Main.air file
3) Open the Main.air file (if you don't have the air run-time it should automatically redirect you, if this doesn't work, download and install it yourself)
FYI: I don't have licenses (which cost money) for any app store so i won't be able to distribute it that way. (App stores are retarded imo anyway)
BTW: Unzipping the air file is definitely not the right way to go, I have packaged it in an air wrapper for the phone to be able to run it, if you take it appart it won't work at all.
Well I did some Googling and I think I know why it didn't work for you, you need to allow the installation of apps from unknown sources (ME!
) on your phone before it will install it Quote
End users of your app can install the AIR runtime and AIR applications using the normal application and distribution mechanism for their device.
On Android, for example, users can install applications from the Android Market. Or, if they have allowed the installation of apps from unknown sources in the Application settings, users can install an app by clicking a link on a web page, or by copying the application package to their device and opening it. If a user attempts to install an Android app, but doesn’t have the AIR runtime installed yet, then they will be automatically directed to the Market where they can install the runtime.
On iOS, there are two ways to distribute applications to end users. The primary distribution channel is the Apple App Store. You can also use ad hoc distribution to allow a limited number of users to install your application without going though the App Store.
See http://help.adobe.com/en_US/air/build/WSfffb011ac560372f-5d0f4f25128cc9cd0cb-7ff6.html for more information
So the steps to be taken are (for Android):
1) Go to application settings and allow the installation of apps from "unknown" sources
2) Download the Main.air file
3) Open the Main.air file (if you don't have the air run-time it should automatically redirect you, if this doesn't work, download and install it yourself)
FYI: I don't have licenses (which cost money) for any app store so i won't be able to distribute it that way. (App stores are retarded imo anyway)
Okay I'll check later. In development mode I tested it on several emulators (iPhone4, iPad, HTC andorid and another Android). And I exported the project to air while enabling the air for Androis, iOS and BB. Let me see what I did wrong.
Did anyone try on Android or BlackBerry?
Did anyone try on Android or BlackBerry?
Installed Air on my droid phone, then went to the URL you gave and still got a bunch of gibberish.
On a lark, I went to the URL on my PC and saw that it was a zip file. For some reason my phone was looking at the URL and displaying the binary file as text.
Anyways, so then I added Winzip to my droid phone, unzipped it on my phone, tried to run the .swf file and got an error saying I didn't have the correct application.
Then I unzipped the file onto my computer, recreated the zip file's directory structure (manually cuz I had to) and copied all the files over. Still could not get the SWF file to run.
This is weird because I have Adobe play and flash both installed on my phone.
I am not all technical and crap when it comes to my phone. I was just trying shit to see if anything would work. After 30 or 40 minutes of screwing with it, I gave up.
Okay I'll check later. In development mode I tested it on several emulators (iPhone4, iPad, HTC andorid and another Android). And I exported the project to air while enabling the air for Androis, iOS and BB. Let me see what I did wrong.
Did anyone try on Android or BlackBerry?
Did anyone try on Android or BlackBerry?
Jump to: