Simple website with some JavaScript games.
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 
 
 
 
jrtechs 1eeeec9bc2 Replaced mysql dependency with sqlite 2 years ago
RepoJS Updated to place the right color. 6 years ago
games Replaced mysql dependency with sqlite 2 years ago
includes Replaced mysql dependency with sqlite 2 years ago
nbproject added zombie game to games folder 7 years ago
php_docker Replaced mysql dependency with sqlite 2 years ago
user Replaced mysql dependency with sqlite 2 years ago
.gitignore added zombie game to games folder 7 years ago
Dockerfile Modified docker file to make it work with infrastructure docker compose 3 years ago
LICENSE Create LICENSE 5 years ago
README.md Replaced mysql dependency with sqlite 2 years ago
about.php Refactored syntax style of project 6 years ago
admin.php Refactored syntax style of project 6 years ago
club_connect.php Replaced mysql dependency with sqlite 2 years ago
docker-compose.yml Replaced mysql dependency with sqlite 2 years ago
games.php Refactored syntax style of project 6 years ago
index.php Refactored syntax style of project 6 years ago
site.conf Created docker compose script to run application locally on port 8080 3 years ago

README.md

Club-Panda

A simple website with some JavaScript Games

Preview

Preview site here: https://clubpanda.jrtechs.net

Contributing

How to submit a PR

  1. Fork this repo.
  2. Checkout your fork.
  3. Make changes and commit them to your fork.
  4. Hit the button that says "Submit Pull Request" on your forked repo.

SQL Lite DB Initialization

sqlite3 clubpanda.sqlite

CREATE TABLE scores (
    score_id INTEGER PRIMARY KEY AUTOINCREMENT,
  game INTEGER NOT NULL,
  user_id mediumint(9) NOT NULL,
  score mediumint(9) NOT NULL
);


CREATE TABLE users (
  user_id INTEGER PRIMARY KEY AUTOINCREMENT,
  first_name varchar(20) NOT NULL,
  last_name varchar(40) NOT NULL,
  user_name varchar(60) NOT NULL,
  pass char(40) NOT NULL,
  registration_date datetime NOT NULL,
  admin tinyint(1) NOT NULL
);

select score, users.user_name username from scores  inner join users on users.user_id=scores.user_id where game = '1' order by score desc limit 20

.exit

Notes on php sqlite documentation: https://www.php.net/manual/en/sqlite3.construct.php