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 пре 3 година
RepoJS Updated to place the right color. пре 7 година
games Replaced mysql dependency with sqlite пре 3 година
includes Replaced mysql dependency with sqlite пре 3 година
nbproject added zombie game to games folder пре 8 година
php_docker Replaced mysql dependency with sqlite пре 3 година
user Replaced mysql dependency with sqlite пре 3 година
.gitignore added zombie game to games folder пре 8 година
Dockerfile Modified docker file to make it work with infrastructure docker compose пре 4 година
LICENSE Create LICENSE пре 6 година
README.md Replaced mysql dependency with sqlite пре 3 година
about.php Refactored syntax style of project пре 7 година
admin.php Refactored syntax style of project пре 7 година
club_connect.php Replaced mysql dependency with sqlite пре 3 година
docker-compose.yml Replaced mysql dependency with sqlite пре 3 година
games.php Refactored syntax style of project пре 7 година
index.php Refactored syntax style of project пре 7 година
site.conf Created docker compose script to run application locally on port 8080 пре 4 година

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