· 8 years ago · Dec 08, 2017, 10:12 PM
1--MySQL dump--
2
3
4CREATE DATABASE IF NOT EXISTS opencp;
5
6SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
7
8
9
10CREATE TABLE IF NOT EXISTS `ps_users` (
11 `id` int(11) NOT NULL AUTO_INCREMENT,
12 `username` varchar(20) NOT NULL,
13 `nickname` varchar(20) NOT NULL,
14 `email` varchar(999) NOT NULL,
15 `password` varchar(999) NOT NULL,
16 `active` int(1) NOT NULL DEFAULT '0',
17 `ubdate` varchar(255) NOT NULL,
18 `items` longblob NOT NULL,
19 `curhead` varchar(10) NOT NULL DEFAULT '0',
20 `curface` varchar(10) NOT NULL DEFAULT '0',
21 `curneck` varchar(10) NOT NULL DEFAULT '0',
22 `curbody` varchar(10) NOT NULL DEFAULT '0',
23 `curhands` varchar(10) NOT NULL DEFAULT '0',
24 `curfeet` varchar(10) NOT NULL DEFAULT '0',
25 `curphoto` varchar(10) NOT NULL DEFAULT '0',
26 `curflag` varchar(10) NOT NULL DEFAULT '0',
27 `colour` varchar(10) NOT NULL DEFAULT '1',
28 `buddies` longtext NOT NULL,
29 `ignore` longtext NOT NULL,
30 `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
31 `lkey` varchar(50) NOT NULL,
32 `coins` int(11) NOT NULL,
33 `ismoderator` int(11) NOT NULL,
34`reputation` varchar(20) NOT NULL, `rank` int(11) NOT NULL DEFAULT '1',
35 `ips` longtext,
36 PRIMARY KEY (`id`)
37) ENGINE=MyISAM DEFAULT CHARSET=latin1;
38
39--Updated file, last one didn't work :$
40<?php
41// For Penguin Lite V0.3 beta
42echo '<head>
43<center><font size="72" color="red">Reputation System </center>
44<title>Penguin lite\'s reputation system</title>
45</head>
46<body>';
47mysql_connect('localhost', 'root', 'password'); //MySQL Connection
48mysql_select_db('database'); // Database
49
50$query = mysql_query("SELECT * FROM users");
51
52while($row=mysql_fetch_assoc($query)) {
53 echo $row['username'];
54 echo $row['rep'];
55 echo '<a href="index.php?username='.$row['username'].'&&add==true">Add</a> / <a href="index.php?username='.$row['username'].'&&remove==true">Remove</a>';
56 echo '<br>';
57}
58
59if ($_GET['add']=='true') {
60 $sql=mysql_query('SELECT * FROM users WHERE username="'.$_GET['username'].'"');
61 $number = $sql['rep'] + 1;
62 mysql_query('UPDATE Persons SET rep = $number WHERE username="'.$_GET['username'].'"');
63 header('Location: index.php');
64}
65
66if ($_GET['remove'])
67{
68 $sql=mysql_query('SELECT * FROM users WHERE username="'.$_GET['username'].'"');
69 $number = $sql['rep'] - 1;
70 mysql_query('UPDATE users SET rep = ' . $number . ' WHERE username="' . $_GET['username'] . '"');
71 header('Location: index.php');
72}
73
74//The only thing left to fix is, um the links
75?>