Registration!

vknok · January 13, 2009

Labvakar kādam nav aizķēries kāds registrācijas scripts ? ?

Mullter^ · January 13, 2009

tepat 2. lapā viens bija.

vknok · January 13, 2009

a tur ir tiaki daļa no skripta tur viņs teica ka pec kkadas pamacibas to veido gribu redzētu kut viņa ir nevari palīdzēt pameklēt ?

Edza15 · January 14, 2009

Rekur ir tīri sakarīga pamācība http://gfx.lv/forums/index.php?showtopic=5473

vknok · January 15, 2009

Nu tā problēma kr4 es to tavu pamadcibu no ownmen pabeidzu tikai radas pproblema kad pieregojos es pec tam nevaru ieiet iekšā why ?

PHPMYADMIN es uztaisiju datubazi sistema ! ? kapec es nevaru ?

Mans index skripts :

<?php
error_reporting(E_ALL);

include("include/config.php");

include("include/functions.php");

// Vajadzīgais kvērijs

if(isset($_SESSION['id']))

{

$id = $_SESSION['id'];

$result = mysql_query("SELECT * FROM lietotaaji WHERE id=$id");

}

// Ja saņem pieprasījumu IELOGOTIES

if(isset($_GET['darbiiba']) and $_GET['darbiiba'] == "login")

{

$epasts = quote_smart($_POST['epasts']);

$parole = quote_smart(md5($_POST['parole']));

$result = mysql_query("SELECT COUNT(*) FROM lietotaaji WHERE epasts=$epasts and parole=$parole");

// Izvelkam lietotāja ID

$get_id = mysql_query("SELECT * FROM lietotaaji WHERE epasts=$epasts and parole=$parole");

$row = mysql_fetch_row($get_id);

$id = $row[0];

// Ja šāds lietotājs pastāv

if(mysql_num_rows($result) == 1)

{

mysql_query("UPDATE lietotaaji SET online='Y' WHERE id=$id");

$_SESSION['id'] = $id;

}

else

{

$nav = "Nepareizs epasts un/vai parole!";

}

}

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

<title>TorrentFile draugi!</title>

<link href="stils.css" rel="stylesheet" type="text/css" />

</head>

<body>

<?php

// Rādam ja nav ielogoies

if(!isset($_SESSION['id']))

{

?>

<div align="center" style="margin-top: 150px;">

<form method="post" action="index.php?darbiiba=login">

<?php

if(isset($nav))

{

echo $nav;

}

?>

<table>

<tr><td>E-pasts:</td><td><input type="text" name="epasts" /></td></tr>

<tr><td>Parole:</td><td><input type="password" name="parole" /></td></tr>

<tr><td></td><td><input type="submit" value="Ielogogties" /></td></tr>

<tr><td></td><td align="right"><a href="register.php">Reģistrēties</a></td></tr>

</table>

</form>

</div>

<?php

}

// Rādam ja ir ielogojies

if(isset($_SESSION['id']))

{

?>

<div id="savelk">

<div id="izveelne">

<ul>

<li><a href="index.php">Sākums</a></li>

<li><a href="index.php?darbiiba=online">Onlainā [<?php echo mysql_result(mysql_query("SELECT COUNT(*) FROM lietotaaji WHERE online='Y' AND id!=$id"),0,'COUNT(*)'); ?>]</a></li>

<li><a href="index.php?darbiiba=profils">Profils</a></li>

<li><a href="index.php?darbiiba=veestules">Vēsutles</a></li>

<li class="iziet"><a href="index.php?darbiiba=logout">Iziet</a></li>

</ul>

</div>

<div id="profila_lauks">

<?php

$row = mysql_fetch_assoc($result);

echo "Sveiks, {$row['vaards']} {$row['uzvaards']}!<br />";

//Profila bilde

$result = mysql_query("SELECT * FROM lietotaaji WHERE id=$id");

$row = mysql_fetch_assoc($result);

$img = getimagesize($row['bilde']);

if($img[0] > 150)

{

echo "<a href='{$row['bilde']}' target='_blank'><img src='{$row['bilde']}' alt='Profila bilde' width='150' /></a>";

}

else

{

echo "<img src='{$row['bilde']}' alt='Profila bilde' />";

}

?>

</div>

<div id="logo">

<a href="index.php"><img src="bildes/sisteema.gif" alt="Sistēma logo" /></a><br />

</div>

<div id="saturs">

<?php

if(isset($_GET['darbiiba']))

{

switch($_GET['darbiiba'])

{

case 'profils':

include("switch/profils.php");

break;

case 'online':

include("switch/online.php");

break;

case 'veestules':

include("switch/veestules_inbox.php");

break;

}

}

else

{

echo 'Čau !';

}

?>

</div>

<div id="apaksha">

<div style="padding-top: 12px">? 2009 Viktors Ganago (vknok) </div>

</div>

</div>

<?php

}

?>

</body>

</html>

Mans config.php scripts kas piesledzas pie datubazes :

<?php
//Pieslēgšanās datubāzei

$db_host = 'localhost';

$db_user = 'root';

$db_password = 'pass';

$db_name = 'sistema';

$connection = @mysql_connect($db_host, $db_user, $db_password) or die(mysql_error());

mysql_select_db($db_name, $connection);

mysql_query("SET NAMES utf8");

?>

Edited January 15, 2009 by vknok

dimka62 · January 17, 2009

A tu SQL kodu iekopeji MYSQL datubaze

vknok · January 17, 2009

ka ?

dimka62 · January 18, 2009

Tur taja sistema23442.rar faila ir sistema.sql.zip nokope ta sql faila kodu ieej phpmyadmin ieej sistema datubaze un tur augsa buus SQL uzspied un iekope to kodu

vknok · January 23, 2009

man rada kļūda #1050 - Table 'lietotaaji' already exists wtf ?

kods !

-- phpMyAdmin SQL Dump
-- version 2.11.6

-- http://www.phpmyadmin.net

--

-- Host: localhost

-- Generation Time: Dec 04, 2008 at 05:39 PM

-- Server version: 5.0.51

-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;

/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;

/*!40101 SET NAMES utf8 */;

--

-- Database: `sistema`

--

-- --------------------------------------------------------

--

-- Table structure for table `lietotaaji`

--

CREATE TABLE `lietotaaji` (

`id` int(11) NOT NULL auto_increment,

`vaards` varchar(255) collate utf8_unicode_ci NOT NULL,

`uzvaards` varchar(255) collate utf8_unicode_ci NOT NULL,

`epasts` varchar(255) collate utf8_unicode_ci NOT NULL,

`parole` varchar(255) collate utf8_unicode_ci NOT NULL,

`bilde` varchar(255) collate utf8_unicode_ci NOT NULL,

`online` varchar(1) collate utf8_unicode_ci NOT NULL default 'N',

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `lietotaaji`

--

-- --------------------------------------------------------

--

-- Table structure for table `veestules`

--

CREATE TABLE `veestules` (

`id` int(11) NOT NULL auto_increment,

`autora_id` int(11) NOT NULL,

`sanjeemeeja_id` int(11) NOT NULL,

`teema` varchar(255) collate utf8_unicode_ci NOT NULL,

`zinja` text collate utf8_unicode_ci NOT NULL,

`laiks` varchar(255) collate utf8_unicode_ci NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--

-- Dumping data for table `veestules`

--

X ID · January 23, 2009

Tik grūti iztulkot? Tāda tabula izvēlētajā datubāzē jau eksistē. Izlem pats vai vecā tabula tev ir vajadzīga, ja nav, tad dzēs ārā, ja ir tad labāk izvēlies citu datubāzi.

Sign In

Registration!

Recommended Posts

vknok

Link to comment

Share on other sites

Mullter^

Link to comment

Share on other sites

vknok

Link to comment

Share on other sites

Edza15

Link to comment

Share on other sites

vknok

Link to comment

Share on other sites

dimka62

Link to comment

Share on other sites

vknok

Link to comment

Share on other sites

dimka62

Link to comment

Share on other sites

vknok

Link to comment

Share on other sites

X ID

Link to comment

Share on other sites

GIGN Forums

Activity