dulais Posted January 12, 2009 Report Share Posted January 12, 2009 Tā tad es gribu uztaisīt tā kad ielogojas parādās kontroles panelis!!Nu piem. nomainīt paroli,bildi paskatīties kas onlainā Varbūt tas jau ir izrunāts, bet es nekā sakarīga neatradu Varbūt ir kāds kods?? Link to comment Share on other sites More sharing options...
Aleksejs Posted January 12, 2009 Report Share Posted January 12, 2009 Skaties http://php.lv/f/index.php?showtopic=2935 tēmas punktā: logini/autorizācijas (arī sesijas) Link to comment Share on other sites More sharing options...
dulais Posted January 12, 2009 Author Report Share Posted January 12, 2009 (edited) Problēma, bet tur nav nekā tāda ko man vajadzētu Edited January 12, 2009 by dulais Link to comment Share on other sites More sharing options...
Aleksejs Posted January 12, 2009 Report Share Posted January 12, 2009 Savādi. Kura tieši daļa Tev nav skaidra? Panelis? Ielogošanās? Parādīšana tikai ja ielogojies? Link to comment Share on other sites More sharing options...
dulais Posted January 12, 2009 Author Report Share Posted January 12, 2009 Man vajag kad ielogojas paradas panelis precizaak kura no temam ta bija?? Link to comment Share on other sites More sharing options...
Aleksejs Posted January 13, 2009 Report Share Posted January 13, 2009 Nu, atceros, ka samērā sen (tas būtu jāpielabo, lai novērstu SQL injekcijas) biju iemetis šajā tēmā: http://php.lv/f/index.php?showtopic=28&hl=fixation Nesenāk biju uzrakstījis šo: http://php.lv/f/index.php?showtopic=11116&hl=hardened Link to comment Share on other sites More sharing options...
dulais Posted January 13, 2009 Author Report Share Posted January 13, 2009 (edited) Bet tagad atkal cita problēma!! Man tas SQL ir šāds -- 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` -- Iznāk tā ka ar loginu nekas neiznāks varētu izmainīt šo SQL lai viņš derētu arī loginam??Bet tik atstāj lai paliek tās vēstules un bildes šīs divas vietas `bilde` varchar(255) collate utf8_unicode_ci NOT NULL, `online` varchar(1) collate utf8_unicode_ci NOT NULL default 'N', Edited January 13, 2009 by dulais Link to comment Share on other sites More sharing options...
Aleksejs Posted January 13, 2009 Report Share Posted January 13, 2009 Kāpēc lai neiznāktu? Attiecīgajās vietās pieliec klāt vajadzīgos laukus (ar PHPmyAdmin tas ir dikti viegli) un skriptu paraugos attiecīgi nomaini nosaukumus izsaucamajai DB, tabulai un laukiem. Link to comment Share on other sites More sharing options...
dulais Posted January 13, 2009 Author Report Share Posted January 13, 2009 Kādus laukus precīzāk uzraksti!! Man nepatīk šīs vietas `vaards` varchar(255) collate utf8_unicode_ci NOT NULL, `uzvaards` varchar(255) collate utf8_unicode_ci NOT NULL, Es gribētu to abu vieta niku un viss Link to comment Share on other sites More sharing options...
NiTrino Posted January 13, 2009 Report Share Posted January 13, 2009 (edited) ALTER TABLE lietotaaji DROP COLUMN vaards; ALTER TABLE lietotaaji DROP COLUMN uzvaards; ALTER TABLE lietotaaji ADD COLUMN nick varchar(50) NOT NULL Edited January 13, 2009 by NiTrino Link to comment Share on other sites More sharing options...
dulais Posted January 13, 2009 Author Report Share Posted January 13, 2009 Lūdzams visu to SQL!! :) Es ļoti maz ko sparotu Link to comment Share on other sites More sharing options...
anonīms Posted January 15, 2009 Report Share Posted January 15, 2009 Tad mācies! Tev tur jau ir sql iedots. Link to comment Share on other sites More sharing options...
aldis Posted January 15, 2009 Report Share Posted January 15, 2009 http://www.google.lv/search?q=php+login+system un nekas nenoder? - pierksti klat vel vardu tutorial, un ej pa solim uz prieksu! :) Link to comment Share on other sites More sharing options...
dulais Posted January 16, 2009 Author Report Share Posted January 16, 2009 Man jau viss ir tikai ar to SQL problēmas Link to comment Share on other sites More sharing options...
anonīms Posted January 16, 2009 Report Share Posted January 16, 2009 Nitriono iedeva tev jau kodu ALTER TABLE lietotaaji DROP COLUMN vaards; ALTER TABLE lietotaaji DROP COLUMN uzvaards; ALTER TABLE lietotaaji ADD COLUMN nick varchar(50) NOT NULL Link to comment Share on other sites More sharing options...
Recommended Posts