Vice City: Multiplayer

Community Projects => Drake's Free Host => Applications => Topic started by: Diamond on Apr 03, 2016, 12:59 PM

Title: Webhost
Post by: Diamond on Apr 03, 2016, 12:59 PM
User Name: Diamond
Sub-domain: http://www.cf.vcmp.co.uk
Email Address: [email protected]
What are you planning to do with this Webhost?: I would like to host my server sqlite webstats
Forum Software(Optional):
Extra Information(Optional):
Title: Re: Webhost
Post by: Diamond on Apr 09, 2016, 01:38 PM
*BUMP*

I am still alive :P
Title: Re: Webhost
Post by: Drake on Apr 20, 2016, 12:43 AM
Accepted.

:edit: Halted.
Title: Re: Webhost
Post by: . on Apr 20, 2016, 01:02 AM
Quote from: Diamond on Apr 03, 2016, 12:59 PMWhat are you planning to do with this Webhost?: I would like to host my server sqlite webstats

You cannot connect to SQLite database from two applications simultaneously. One of them will fail at some point if the database is locked by the other application. Therefore, quite useless.
Title: Re: Webhost
Post by: Drake on Apr 20, 2016, 01:57 AM
Quote from: . on Apr 20, 2016, 01:02 AM
Quote from: Diamond on Apr 03, 2016, 12:59 PMWhat are you planning to do with this Webhost?: I would like to host my server sqlite webstats

You cannot connect to SQLite database from two applications simultaneously. One of them will fail at some point if the database is locked by the other application. Therefore, quite useless.
And I thought you were talking about MySQL.
As @. said, this isn't possible.
Title: Re: Webhost
Post by: KAKAN on Apr 20, 2016, 03:49 AM
Quote from: . on Apr 20, 2016, 01:02 AM
Quote from: Diamond on Apr 03, 2016, 12:59 PMWhat are you planning to do with this Webhost?: I would like to host my server sqlite webstats

You cannot connect to SQLite database from two applications simultaneously. One of them will fail at some point if the database is locked by the other application. Therefore, quite useless.
I have tried it and it seems to work without problems.
Title: Re: Webhost
Post by: . on Apr 20, 2016, 04:30 AM
Quote from: KAKAN on Apr 20, 2016, 03:49 AMI have tried it and it seems to work without problems.

You just haven't encountered the situation where two simultaneous queries are executed on the same database.
Title: Re: Webhost
Post by: Thijn on Apr 20, 2016, 04:04 PM
Quote from: . on Apr 20, 2016, 04:30 AM
Quote from: KAKAN on Apr 20, 2016, 03:49 AMI have tried it and it seems to work without problems.

You just haven't encountered the situation where two simultaneous queries are executed on the same database.
You can make webstats without any problems, but only if you're only doing select queries.
http://www.sqlite.org/faq.html#q5
Title: Re: Webhost
Post by: Diamond on Apr 23, 2016, 09:03 AM
Quote from: Thijn on Apr 20, 2016, 04:04 PM
Quote from: . on Apr 20, 2016, 04:30 AM
Quote from: KAKAN on Apr 20, 2016, 03:49 AMI have tried it and it seems to work without problems.

You just haven't encountered the situation where two simultaneous queries are executed on the same database.
You can make webstats without any problems, but only if you're only doing select queries.
http://www.sqlite.org/faq.html#q5

Yes, I just want to select queries.
Title: Re: Webhost
Post by: Drake on Apr 23, 2016, 10:21 AM
So, will you be using the SQLite database from the server that I host for you?

If so, I will be creating a folder inside your server files and you can put your files there and it will be up on http://cf.vcmp.co.uk. Confirm it.
Title: Re: Webhost
Post by: KAKAN on Apr 23, 2016, 11:12 AM
Quote from: Drake on Apr 23, 2016, 10:21 AMSo, will you be using the SQLite database from the server that I host for you?

If so, I will be creating a folder inside your server files and you can put your files there and it will be up on http://cf.vcmp.co.uk. Confirm it.
You can access the database from different locations too.
For ex:
There are 2 disks
C and D
In C, the PHP files are there
In D, the server files are there
So, if a PHP file wants to access the server's database, then, the connection( path ) line should be like this:
D:\server\database.db
or simply, a symlink :D
Title: Re: Webhost
Post by: Drake on Apr 23, 2016, 11:31 AM
Quote from: KAKAN on Apr 23, 2016, 11:12 AM
Quote from: Drake on Apr 23, 2016, 10:21 AMSo, will you be using the SQLite database from the server that I host for you?

If so, I will be creating a folder inside your server files and you can put your files there and it will be up on http://cf.vcmp.co.uk. Confirm it.
You can access the database from different locations too.
For ex:
There are 2 disks
C and D
In C, the PHP files are there
In D, the server files are there
So, if a PHP file wants to access the server's database, then, the connection( path ) line should be like this:
D:\server\database.db
or simply, a symlink :D
And I didn't know that? I just don't want to create another FTP Account and give the same to a user who already has the access to one of the FTP Account and there are more reasons too that it won't work in my VPS because you don't know how it is set up.
Title: Re: Webhost
Post by: Diamond on Apr 24, 2016, 03:17 AM
I dont want it anymore.

I left CF clan for which i was doing so.

Thanks.

Closed and Locked.