<?php
Class Action {
private $db ;
public function __construct( ) {
include 'db_connect.php' ;
$this -> db = $conn ;
}
function __destruct( ) {
$this -> db -> close ( ) ;
}
function login( ) {
$qry = $this -> db -> query ( "SELECT * FROM users where email = '" . $email . "' and password = '" . md5 ( $password ) . "' " ) ; if ( $qry -> num_rows > 0 ) {
foreach ( $qry -> fetch_array ( ) as $key => $value ) {
$_SESSION [ 'login_' . $key ] = $value ;
}
return 1 ;
} else {
return 3 ;
}
}
function logout( ) {
foreach ( $_SESSION as $key => $value ) {
}
}
function signup( ) {
$data = " firstname = '$firstname ' " ;
$data .= ", lastname = '$lastname ' " ;
$data .= ", middlename = '$middlename ' " ;
$data .= ", contact = '$contact ' " ;
$data .= ", address = '$address ' " ;
$data .= ", email = '$email ' " ;
$data .= ", password = '" . md5 ( $password ) . "' " ; $chk = $this -> db -> query ( "SELECT * FROM users where email = '$email ' " ) -> num_rows ;
if ( $chk > 0 ) {
return 2 ;
}
$save = $this -> db -> query ( "INSERT INTO users set " . $data ) ;
if ( $save ) {
$login = $this -> login ( ) ;
if ( $login == 1 )
return 1 ;
}
}
function save_upload( ) {
for ( $i = 0 ; $i < count ( $img ) ; $i ++ ) { $img [ $i ] = str_replace ( 'data:image/jpeg;base64,' , '' , $img [ $i ] ) ; $data = " file_path = 'img/uploads/" . $fname . "' " ;
$data .= ", user_id = '" . $_SESSION [ 'login_id' ] . "' " ;
$save [ ] = $this -> db -> query ( "INSERT INTO file_uploads set" . $data ) ;
$ids [ ] = $this -> db -> insert_id ;
}
if ( $type == 1 ) {
$data = " user_id = '" . $_SESSION [ 'login_id' ] . "' " ;
$data .= ", content = '$content ' " ;
$data .= ", file_ids = '" . implode ( "," , $ids ) . "' " ; $save = $this -> db -> query ( "INSERT INTO posts set" . $data ) ;
}
return 1 ;
}
}
function save_comment( ) {
$data = " post_id = $post_id " ;
$data .= ", user_id = " . $_SESSION [ 'login_id' ] . " " ;
$data .= ", comment = '$comment ' " ;
$save = $this -> db -> query ( "INSERT INTO comments set " . $data ) ;
if ( $save ) {
$id = $this -> db -> insert_id ;
$data = $this -> db -> query ( "SELECT c.*,concat(u.firstname,' ',u.middlename,' ',u.lastname) as uname FROM comments c inner join users u on u.id = c.user_id where c.id = $id " ) -> fetch_array ( ) ;
foreach ( $data as $k => $v ) {
$c [ $k ] = $v ;
}
$d [ 'comment' ] = $comment ;
}
}
function save_posts( ) {
$data = " user_id = " . $_SESSION [ 'login_id' ] . " " ;
$data .= ", content = '$content ' " ;
$data .= ", file_ids = '$file_id ' " ;
$save = $this -> db -> query ( "INSERT INTO posts set " . $data ) ;
if ( $save ) {
return 1 ;
}
}
}
PD9waHAKc2Vzc2lvbl9zdGFydCgpOwpDbGFzcyBBY3Rpb24gewoJcHJpdmF0ZSAkZGI7CgoJcHVibGljIGZ1bmN0aW9uIF9fY29uc3RydWN0KCkgewoJCW9iX3N0YXJ0KCk7CiAgIAlpbmNsdWRlICdkYl9jb25uZWN0LnBocCc7CiAgICAKICAgICR0aGlzLT5kYiA9ICRjb25uOwoJfQoJZnVuY3Rpb24gX19kZXN0cnVjdCgpIHsKCSAgICAkdGhpcy0+ZGItPmNsb3NlKCk7CgkgICAgb2JfZW5kX2ZsdXNoKCk7Cgl9CgoJZnVuY3Rpb24gbG9naW4oKXsKCQlleHRyYWN0KCRfUE9TVCk7CgkJJHFyeSA9ICR0aGlzLT5kYi0+cXVlcnkoIlNFTEVDVCAqIEZST00gdXNlcnMgd2hlcmUgZW1haWwgPSAnIi4kZW1haWwuIicgYW5kIHBhc3N3b3JkID0gJyIubWQ1KCRwYXNzd29yZCkuIicgIik7CgkJaWYoJHFyeS0+bnVtX3Jvd3MgPiAwKXsKCQkJZm9yZWFjaCAoJHFyeS0+ZmV0Y2hfYXJyYXkoKSBhcyAka2V5ID0+ICR2YWx1ZSkgewoJCQkJaWYoJGtleSAhPSAncGFzc3dvcnMnICYmICFpc19udW1lcmljKCRrZXkpKQoJCQkJCSRfU0VTU0lPTlsnbG9naW5fJy4ka2V5XSA9ICR2YWx1ZTsKCQkJfQoJCQkJcmV0dXJuIDE7CgkJfWVsc2V7CgkJCXJldHVybiAzOwoJCX0KCX0KCWZ1bmN0aW9uIGxvZ291dCgpewoJCXNlc3Npb25fZGVzdHJveSgpOwoJCWZvcmVhY2ggKCRfU0VTU0lPTiBhcyAka2V5ID0+ICR2YWx1ZSkgewoJCQl1bnNldCgkX1NFU1NJT05bJGtleV0pOwoJCX0KCQloZWFkZXIoImxvY2F0aW9uOmxvZ2luLnBocCIpOwoJfQoJZnVuY3Rpb24gc2lnbnVwKCl7CgkJZXh0cmFjdCgkX1BPU1QpOwoJCSRkYXRhID0gIiBmaXJzdG5hbWUgPSAnJGZpcnN0bmFtZScgIjsKCQkkZGF0YSAuPSAiLCBsYXN0bmFtZSA9ICckbGFzdG5hbWUnICI7CgkJJGRhdGEgLj0gIiwgbWlkZGxlbmFtZSA9ICckbWlkZGxlbmFtZScgIjsKCQkkZGF0YSAuPSAiLCBjb250YWN0ID0gJyRjb250YWN0JyAiOwoJCSRkYXRhIC49ICIsIGFkZHJlc3MgPSAnJGFkZHJlc3MnICI7CgkJJGRhdGEgLj0gIiwgZW1haWwgPSAnJGVtYWlsJyAiOwoJCSRkYXRhIC49ICIsIHBhc3N3b3JkID0gJyIubWQ1KCRwYXNzd29yZCkuIicgIjsKCQkkY2hrID0gJHRoaXMtPmRiLT5xdWVyeSgiU0VMRUNUICogRlJPTSB1c2VycyB3aGVyZSBlbWFpbCA9ICckZW1haWwnICIpLT5udW1fcm93czsKCQlpZigkY2hrID4gMCl7CgkJCXJldHVybiAyOwoJCQlleGl0OwoJCX0KCQkJJHNhdmUgPSAkdGhpcy0+ZGItPnF1ZXJ5KCJJTlNFUlQgSU5UTyB1c2VycyBzZXQgIi4kZGF0YSk7CgkJaWYoJHNhdmUpewoJCQkkbG9naW4gPSAkdGhpcy0+bG9naW4oKTsKCQkJaWYoJGxvZ2luID09IDEpCgkJCXJldHVybiAxOwoJCX0KCX0KCglmdW5jdGlvbiBzYXZlX3VwbG9hZCgpewoJCWV4dHJhY3QoJF9QT1NUKTsKCQkkaWRzPSBhcnJheSgpOwoJCWZvcigkaSA9IDAgOyAkaTwgY291bnQoJGltZyk7JGkrKyl7CgkJCSRpbWdbJGldPSBzdHJfcmVwbGFjZSgnZGF0YTppbWFnZS9qcGVnO2Jhc2U2NCwnLCAnJywgJGltZ1skaV0gKTsKCQkJJGltZ1skaV0gPSBiYXNlNjRfZGVjb2RlKCRpbWdbJGldKTsKCQkJJGZuYW1lID0gc3RydG90aW1lKGRhdGUoJ1ktbS1kIEg6aScpKS4iXyIuJGltZ05hbWVbJGldOwoJCQkkdXBsb2FkID0gZmlsZV9wdXRfY29udGVudHMoImFzc2V0cy9pbWcvdXBsb2Fkcy8iLiRmbmFtZSwkaW1nWyRpXSk7CgkJCSRkYXRhID0gIiBmaWxlX3BhdGggPSAnaW1nL3VwbG9hZHMvIi4kZm5hbWUuIicgIjsKCQkJJGRhdGEgLj0gIiwgdXNlcl9pZCA9ICciLiRfU0VTU0lPTlsnbG9naW5faWQnXS4iJyAiOwoJCQkkc2F2ZVtdID0gJHRoaXMtPmRiLT5xdWVyeSgiSU5TRVJUIElOVE8gZmlsZV91cGxvYWRzIHNldCIuJGRhdGEpOwoJCQkkaWRzW10gPSAkdGhpcy0+ZGItPmluc2VydF9pZDsKCQl9CgkJaWYoaXNzZXQoJHNhdmUpKXsKCQkJaWYoJHR5cGUgPT0gMSl7CgkJCQkkZGF0YSA9ICIgdXNlcl9pZCA9ICciLiRfU0VTU0lPTlsnbG9naW5faWQnXS4iJyAiOwoJCQkJJGRhdGEgLj0gIiwgY29udGVudCA9ICckY29udGVudCcgIjsKCQkJCSRkYXRhIC49ICIsIGZpbGVfaWRzID0gJyIuaW1wbG9kZSgiLCIsJGlkcykuIicgIjsKCQkJCSRzYXZlID0gJHRoaXMtPmRiLT5xdWVyeSgiSU5TRVJUIElOVE8gcG9zdHMgc2V0Ii4kZGF0YSk7CgkJCX0KCQkJcmV0dXJuIDE7CgkJfQoJfQoJZnVuY3Rpb24gc2F2ZV9jb21tZW50KCl7CgkJZXh0cmFjdCgkX1BPU1QpOwoKCQkkZGF0YSA9ICIgcG9zdF9pZCA9ICRwb3N0X2lkICI7CgkJJGRhdGEgLj0gIiwgdXNlcl9pZCA9ICIuJF9TRVNTSU9OWydsb2dpbl9pZCddLiIgIjsKCQkkZGF0YSAuPSAiLCBjb21tZW50ID0gJyRjb21tZW50JyAiOwoKCQkkc2F2ZSA9ICR0aGlzLT5kYi0+cXVlcnkoIklOU0VSVCBJTlRPIGNvbW1lbnRzIHNldCAiLiRkYXRhKTsKCQlpZigkc2F2ZSl7CgkJCSRpZCA9ICR0aGlzLT5kYi0+aW5zZXJ0X2lkOwoJCQkkZGF0YSA9ICR0aGlzLT5kYi0+cXVlcnkoIlNFTEVDVCBjLiosY29uY2F0KHUuZmlyc3RuYW1lLCcgJyx1Lm1pZGRsZW5hbWUsJyAnLHUubGFzdG5hbWUpIGFzIHVuYW1lIEZST00gY29tbWVudHMgYyBpbm5lciBqb2luIHVzZXJzIHUgb24gdS5pZCA9IGMudXNlcl9pZCB3aGVyZSBjLmlkID0gJGlkICIpLT5mZXRjaF9hcnJheSgpOwoJCQlmb3JlYWNoKCRkYXRhIGFzICRrPT4kdil7CgkJCQlpZighaXNfbnVtZXJpYygkaykpCgkJCQkkY1ska10gPSAkdjsKCQkJfQoJCQkkZFsndXNlciddID0gdWN3b3JkcygkY1sndW5hbWUnXSk7CgkJCSRkWydjb21tZW50J10gPSAkY29tbWVudDsKCQkJJGRbJ2RhdGUnXSA9IGRhdGUoIk0gZCxZIixzdHJ0b3RpbWUoJGNbJ2RhdGVfY3JlYXRlZCddKSk7CgkJCXJldHVybiBqc29uX2VuY29kZShhcnJheSgic3RhdHVzIj0+MSwiZGF0YSI9PiRkKSk7CgkJfQoJfQoJZnVuY3Rpb24gc2F2ZV9wb3N0cygpewoJCWV4dHJhY3QoJF9QT1NUKTsKCgkJJGRhdGEgPSAiIHVzZXJfaWQgPSAiLiRfU0VTU0lPTlsnbG9naW5faWQnXS4iICI7CgkJJGRhdGEgLj0gIiwgY29udGVudCA9ICckY29udGVudCcgIjsKCQkkZGF0YSAuPSAiLCBmaWxlX2lkcyA9ICckZmlsZV9pZCcgIjsKCgkJJHNhdmUgPSAkdGhpcy0+ZGItPnF1ZXJ5KCJJTlNFUlQgSU5UTyBwb3N0cyBzZXQgIi4kZGF0YSk7CgkJaWYoJHNhdmUpewoJCQlyZXR1cm4gMTsKCQl9Cgl9Cn0=