Get a Freelance Job

Hello Programmers

I have a 2 sqlite databases that contains player information based on gameplay. My computer has recently fluked and caused the system time / date to revert to another year.

In the 2 database I have about 40 or more players who have a wrong playing time because of this.

I need you to fix the users time played column in the database, you just need to change the data to be similar to the others.

I will include an example database, but i will need to shut down the ser…

Hello Programmers

I have currently have a sqlite database that contains player information (gamers) I also have a simple php page that will displays the database contents in a nice graphical form. Look here to view it http://www.dylanknisley.com/stats

As you can see from the link we have 3 servers thus 3 databases. They includes the following information : playername, level, class, score, kills, deaths, class, time played. times connected. Now please keep in mind each server contains its o…

Hello Programmers

I have currently have a sqlite database that contains player information (gamers) I would like someone to make the following html / php stats page by using the included database.

Look at this example, I would like it to show the following stats http://hlstats.bob.fi/index.php?mode=players& game=cstrike

My database includes the following information, playername, level, class, score, kills, deaths . I would like for the query / stats page to also include a rank based on …

I have an excel file with sentence punctuation (see attached Excel.jpg), and I need it converted to SQLite with all the punctuation and grammer to stay. I do not want the attached SQLite.jpg… I get that on my own.

My budget is $25 and I need it done by 10/17/2011

Simple CodeIgniter PHP URL shortner project.

We need a URL shortening function created for us using CodeIgnitor and using a SQLite DB.

You can just use a std CodeIgniter 1.7.2 package and we will integrate it into our main project later.

We expect to see a form that takes the following user input:

1. A local URL
2. A keyword

The keyword (only) must be checked against the DB to ensure that it is unique before the form can be submitted.

A short URL is then generated.

For example, if the URL entered was:

‘http://example.com/index.php/main/view/about’

and the keyword was: ‘about’

the short URL would be: ‘http://example.com/about’ and would redirect accordingly.

Note that this MUST be created using Codeignitor 1.7.2 and SQLite (not MySQL) as specified.

This will probably only take you a few hours – maybe a day at the most!

I want the text file content that I’ve attached insert into sqlite. The text file contains 3 “side by side” Koran (Qur’an) translations.

I’ve attached one old sqlite database that I have, which has a single Koran translation in it, just to show you the type of thing that I’m looking for (use the same database structure).

This new Koran database will have ALL 3 TRANSLATIONS from the text file in it. In other words, each “punchline” field will have all 3 translations.

I’ve started this for you, in case this is unclear. See “side_by_side_koran.db”. I’ve inserted the first two records, and the first category, to help get you started.

I need to convert mysql data to sqlite, i also have data in excel or access, i can give sql script file too.
2 databases to be converted

Hello Programmers,

I

First, I just want to say this is the 6th time I have posted this project. For the love of god and all good things on earth, PLEASE PLEASE PLEASE if you don’t understand what I want, then don’t bother bidding. I give ridiculous amounts of description, I give code examples, I give database outlines, I give you databases!! I have no idea how it’s possible that bidders of a project, given all that, can still not bother coding to my specifications. If you are illiterate and cannot read specifications or cannot follow them, then please don’t bother bidding on this project because I am a programmer, I will look over the code, I will see if you lying to me.

The last time I posted this, someone asked me to select them, and I did, and then they didn’t reply for 3 days. I just don’t get it.

If however, you are a programmer who cares about quality and following client specifications, I reward such things. I will be more than happy to pay a bonus for fast service and beautiful code.

It seems very strange to me that people will bid on projects that they do not intend to fulfill. My time is valuable as is yours, so please don’t waste both our times if you don’t intend to complete the project on time and to my specifications.

Hashgallery

I started on it, but do not have time to finish it, and so I have code snippets as well as detailed description of the project.

Basically, a barebones gallery based on the unique concept that the files will be renamed to their SHA1 values and thus, the file will carry with it, the innate knowledge of its own link name.

The folders are virtual folders, living in a sqlite database, with reference pointers to the files themselves.

So a file named “DSC_0001.jpg” might have a SHA1 hash value of 091E01046BCCA9829BCB9DCBC47F583880FF8AE6 and thus renamed to “091E01046BCCA9829BCB9DCBC47F583880FF8AE6.jpg”. This then becomes the permalink to the file. In this way, no matter what happens, to the name of the file, you can always regenerate this hash by hashing the file itself, thus even with a completely meltdown of the server or db, the permalinks will never die.

Because hash values are 0~9, A~F, 16 directories are created:

/0
/1
/2
…
/E
/F

Each file will live in the directory of the first letter of the hash.

So as per the previous example, the file with the name “091E01046BCCA9829BCB9DCBC47F583880FF8AE6.jpg” will live in the /0 directory.

So now the permalink for this image is:

http://www.example.com/hashgallery/091E01046BCCA9829BCB9DCBC47F583880FF8AE6.jpg

HOWEVER, using mod_rewrite on Apache, it will be turned into:

http://www.example.com/hashgallery/0/091E01046BCCA9829BCB9DCBC47F583880FF8AE6.jpg

(Note the extra /0 directory)

The reason for doing this is that down the road, it is possible to slice up the HD into 16 parts, or any other types of divisions.

This gallery will be primarily designed for use in conjunction with blogs, so a permalink is important.

References to the files themselves then, will not go through a db, only file maintenance will, this make it so that the db is not a bottleneck.

Unlike gallery2, which died on me when the albums got really big, this gallery will be able to support hundreds of thousands of images. Using a php program called ultratree, a file directory tree is created in php with only 1 db query.

The gallery will allow for bulk .zip file upload, or individual file upload. Folder creation and subfolder creation, folder movement etc.. It will also allow for sorting of images via DHTML like

http://www.dhtmlgoodies.com/index.html?whichScript=floating_gallery

I would like the db interface though to be abstracted to support other db’s in the future.

php code snippets available and included.

More detailed description included in the description file.

I would like the first db used to be sqlite3.
http://www.sqlite.org

As I am a programmer, any and all questions I am able to answer. I am even able to answer code optimizations.

I originally had a skeleton sample running on one of the servers, but the server has been decommissioned but I have taken a screen recording to give a rough idea. I’ve also attached the database that I used, and the sample source code that I used.

Please take a look at the entire attached package. I’ve got a screen mockup, an avi, a detailed description, a visio diagram, a sample db, and sample source code.

There should be a configuration page of minimal items which are configurable such as thumbnail size (using the GD library of php).

The app also allows for ftp’ing to a specified directory and then batch processing.

If you have read this far, and think you will bid on this project, search on freshmeat.net or someone online, send me a copy of some other gallery and pray I won’t find out (like the first guy who bid on this project) then you are sadly mistaken.

Thank you for taking your time and interest in the project.

I can give you a link to where the previous programmer ended.

We’re going to be building an application in FLASH taking only a little over 1000 Q&A from a book (Word) and converting them (copy and paste) to a dynamic flash type of flash application for both web (FLEX) and cd-rom (AIR). Basically almost all the questions are multiple choice, but there are many versions of these MC questions & answers, so be sure to see and study the attachment so that the db template will, in fact, accomodate these various versions of multiple choice and/or matching.

We’re contemplating the following setup:

***FLASH UI (FLEX / AIR)
***MIDDLEWARE: php
***DB: mySQL (online / FLEX version) and SQLite (CD / AIR version)

***AIR goes with SQLite as you know
***FLEX goes with mySQL

Your bid is for the DB part only (ie not the UI or the middleware) for BOTH mySQL and SQLite versions.

We’ll need you to create a DATABASE TEMPLATE that can meet all of the following 10 …

DATABASE REQUIREMENTS / CONSIDERATIONS:

1. We need to be able to copy and paste the various Q/A components (for the columns of data, see p.1 of attached document) from the original Word (or pdf) directly to the table (but remember too that we’ve got SYMBOLS and TABLES (see attached document for what we mean by symbols and TABLES). There’s a lot of SYMBOLS (for example arrows, etc, ie not flash symbols per se), and even TABLES (eg showing different sequences of symbols and one sequence is the correct answer) throughout the book
2. DB should allow for a column for images, for questions that also have an image or images.
3. When we copy and paste the various parts of each question and answer into your template, we want the symbols AND the FORMATTING to be preserved. The symbols are mostly from fonts like monotype sorts, zapfdingbats, webdings, wingdings, etc. We can identify all the fonts for you so that when they paste, the symbols don’t get lost in translation.
4. db MUST work for both Web & CD
5. MUST work with both Windows & Mac OS
6. for a dynamic application
7. Both web and CD db should be secure and encryptable .
8. I understand any type of db can work with Flash (generally) thru middleware like php, asp, cf, etc. Is it true that the final step is that Flash can ONLY read XML?
9. Ideally we’d like to be able to update questions and answers for the application without having to bother the coder every time, so would this change your recommendation as far as a db that can meet these criteria?
10. MUST be compatible with FLEX and AIR for later development of the FLASH UI.

ATTACHED please find a 10 page pdf SAMPLE of question types from the original word file from which we’ll be pasting appropriate portions of the Q/A to the proper columns. Just use the pzwd “flashdb” (no quotes) to view the ATTACHED document.

Your bid is for the DB part only (ie not the UI or the middleware) for BOTH mySQL and SQLite versions.

Along with your bid, remember to INCLUDE 3 things:

a. What do you feel would be the best middleware (between the FLEX & mySQL ….and between the AIR & SQLite, and why? For example, if you feel strongly that asp.NET is superior for this type of flow, please let us know your preferred middleware and why you prefer it over, say, php.
b. Because of auto mat ed bids, please include the word “genuine” in your bid. It will also show that you cared enough to read through the entire job description.
c. What experience do you have involving FLEX, AIR, with databases of mySQL / SQLite ?

Delivery is expected within 7 days of project award (10 days if you also plan to include a MACRO to automatically parse the data from Word into the columns (which macro will pay an extra $100).

If your work is excellent, you’re easy to work with, you’re reliable and can check in daily with your progress, we will gladly consider awarding you the other portions of this project on completion and have many more projects for you.

Thank you.

Parson

SEE ATTACHEMENT