Archive

Posts Tagged ‘uid’

Website Administration Cms

November 7th, 2011 Comments off

I need someone to design (Drupal, Joomla, other) a CMS to administrate a website that I have. I currently add a bunch of information into a database to update the website. It is somewhat painful at the moment and a simple CMS would help ease the update time for the site.

*** AUTOMATED BIDS, BIDS WHO DO NOT READ WILL NOT BE ACCEPTED

Entry Types:

* Addition of Payment methods into a datatable (Name only, UID auto)
* Addition of Software into a datatable with Name, Launch date (UID auto)
* Addition of Type into a datatable (Name only, UID auto)
* Addition of Type2 into a datatable (Name only, UID auto)

* Addition of Companies into a datatable with 13 fields (UID auto)
– Join Company with software (can be multiple)
– Join Company with payment methods into deposit table
– Join Company with payment methods into withdrawal table

* Addition of bonuses
– Select Company
– Select Type
– Select Type2
– 33 Fields total

It’s pretty easy MySQL stuff… Any good programmer with experience in a CMS can do this. CMS has to be secure.

*** NOTE – IF YOU WANT THIS JOB, PASTE THE FOLLOWING INTO YOUR BID (IF YOU DO NOT, IT WON’T BE CONSIDERED): >>ADMIN_CMS<< ***

Joomla Or Drupal Administrator Project

July 7th, 2011 Comments off

I am looking to have an Administrator (CMS Admin) created for a website of mine. The administrator would allow the entry of data into the database – relatively simple stuff.

—————-
CMS Admin Requirements
—————-

* Registration Required – User’s must sign up for an account into the CMS to allow usage. Without login, only a basic registration screen is available.

* ‘Administrator’ account can access all features and information in the system.

* Drupal or Joomla should be used as tools. Can not be a ‘custom’ interface. Template can be any off the shelf templae, no issues there.

—————-
CMS Feature Set
—————-

_________________
Enter Casino Info
_________________

SUMMARY: Registered users can enter Casino information into the system. This information resides in the following datatables – ‘casino’, ‘software’, ‘casino_software_join’.

* User can enter Casino Information into the Administrator and keep track of the Casinos they have entered. All Casino Entries are editable ONLY to the Registered user who submitted the information and to the ‘Administrator’. The Casino Information is as follows:

— ‘casino’ DataTable –
1. casino_uid – Primary Key, Auto Increment, NOT used by user.
1. Casino Name – Name of the Casino
2. Casino Logo – Logo should be an image, 60×24, uploaded to the server in the proper location {casino-images folder} and the name of the file stored in this field.
3. casino_usaccepted – yes/no selectable. To database bit field, 1=yes, 0=no
4. casino_supportnumber – Text
5. casino_faxnumber – Text
6. casino_contacttext – Text
7. casino_livehelp – URL (text)
8. casino_est – Year established (4-digit year – ex: 2011)
9. casino_address – text

In addition to this information, there will be the following:

Casino Software is in the following datatable: software. This data is:

— ‘software’ DataTable –
1. software_name – Name of the software, required
2. software_golive – Software established date, not required

There should be a selection box that shows the software_name for the user to select. There should be an ‘Add’ button to add that software name to an ajax section on the page. They can ‘add’ as many software selections as they want because casinos can have several softwares used.

There should be the ability underneath to ‘Add A NEW Software’. They can then add a new software by entering ONLY the ‘software_name’. This ‘Add A NEW Software’ would commit the new software to the ‘software’ datatable.

Once the information is completed, it will insert the information into:

1. ‘casino’ DataTable
2. ‘software’ DataTable (only if a NEW Software is added)
3. ‘casino_software_join’ DataTable – This table JOINS the casino_uid with the software_uid. casino_uid’s can have multiple software_uid’s. All must be joined.

_________________
Enter Bonus Info
_________________

SUMMARY: Registered users can enter Bonus information into the system. The information resides in the following datatables – ‘bonus’, ‘bonus_type’, ‘bonus_wd_type’

* User can enter bonus information into the Administrator and keep track of the bonuses they have entered. All Bonus Entries are editable ONLY to the Registered user who submitted the information and to the ‘Administrator’. The Bonus Information is as follows:

1. bonus_uid – Primary Key, Auto Increment, NOT used by user.
2. casino_uid – User would select one of the casinos they had previously entered into the system, the UID of that casinos would be inserted into this field in the DB
3. bonus_type_uid – User would have a ‘selectable’ dropdown. That dropdown will be filled with the ‘bonus_type_description’ from the ‘bonus_type’ datatable. By selecting the dropdown, this field would be filled in with the ‘bonus_type_uid’ from the ‘bonus_type’ datatable.
4. bonus_wd_type_uid – User would have a ‘selectable’ dropdown. That dropdown will be filled with the ‘bonus_wd_type_description’ from the ‘bonus_wd_type’ datatable. By selecting the dropdown, this field would be filled in with the ‘bonus_wd_type_uid’ from the ‘bonus_wd_type’ datatable.
5. bonus_freemoney – integer
6. bonus_currency – User will enter the Currency type ($,

Editor

November 5th, 2009 Comments off

Main purpose: Creation and editing of configuration files

Output: txt file

Functions: 1. creation of new file
2.edit existing file
3. save delete copy file
4. renumbering of objects

A. Create new file
-default top object is created – name by user input +UID
-auto creation of UID (unique id number)
Function add:
1.select object and add new sub object -name by user input – auto created UID
2. select object and add input value – name by user input – auto created UID – default value – unit Max/Min value – add picture
3. Select object add input quantity- name by user input – auto created UID – default value – unit Max/Min value – add picture
4.select object and add select – name by user input – auto created UID – objects – radio/drop down single/ multi select – add picture
5 select object and add relation – select relation object – auto created UID – matrix value by user force/or optional value(object to object)

Funtion delete
1.delete object and sub-objects
2.delete input/select
3.delete relation

Function edit
1. edit object name
2. edit object input/output
3. Edit relation

B. Edit an existing file
all the functions for creating a new file

C. Save, delete copy file

D. Make a renumbering of objects with the interval of 10

Categories: MySQL, PHP Tags: , , , , , ,

Universal Customizer

October 16th, 2009 Comments off

Web based service for a customizer

Main purpose: Creation and editing of configuration files

Output: txt file

Functions: 1. creation of new file
2.edit existing file
3. save delete copy file
4. renumbering of objects

A. Create new file
-default top object is created – name by user input +UID
-auto creation of UID (unique id number)
Function add:
1.select object and add new sub object -name by user input – auto created UID
2. select object and add input value – name by user input – auto created UID – default value – unit Max/Min value – add picture
3. Select object add input quantiti – name by user input – auto created UID – default value – unit Max/Min value – add picture
4.select object and add select – name by user input – auto created UID – objects – radio/drop down single/ multi select – add picture
5 select object and add relation – select relation object – auto created UID – matrix value by user force/or optional value(object to object)

Funtion delete
1.delete object and sub-objects
2.delete input/select
3.delete relation

Function edit
1. edit object name
2. edit object input/output
3. Edit relation

B. Edit an existing file
all the functions for creating a new file

C. Save, delete copy file

D. Make a renumbering of objects with the interval of 10

Categories: Ajax, Java, Javascript, MySQL, PHP Tags: , , , , , ,

Store And Retrieve Images

July 2nd, 2009 Comments off

This is a simple project for storing and retrieving images from a MySQL Database. The table has the following structure:

Table Name: GAME_IMAGES
Fields:
IMAGE_UID – Primary Key – BigInt
IMAGE_DESCRIPTION – Text
GAMES_UID – BigInt
GAME_IMAGE – BLOB

The image would be stored in the GAME_IMAGE field and will be a full-size image (most likely 800×600, but could be larger).

What is needed:

1. A web page to PUSH the images into the database (including asking for the Image Description and browsing for the image). Test with GAMES_UID = 1. Should be able to upload MULTIPLE IMAGES (each having their own description), delete images from the database, add more images (all based upon the GAMES_UID).

2. A web page which pulls the images out of the database based upon the GAMES_UID=1 *

* Pulling of the images should include SIZING and adding a watermark.

Configuation File: The configuration file would include database settings, SIZING information, and Watermark information like the following:

// Database connection settings
$db['host'] = ”; // MySQL host
$db['user'] = ”; // User’s name
$db['pass'] = ”; // User’s password
$db['name'] = ”; // Database name

$params['sizing_width'] = 800; // Width in Pixels
$params['sizing_height'] = 600; // Height in Pixels

$params['watermark'] = “http://www.mydomain.com/images/watermark.png” // Watermark Image Location

Summary: A web page will allow a user to upload and store multiple images to the database (based upon GAMES_UID=1). Once the images are stored in the database (full sized), another web page can browse the images. The ‘browse’ web page will automatically size and watermark the images based upon the settings in the configuration file.

Bear