Track visitors using Google Maps

Create a table in your database, like 'visitor_map'. We will have these fields: id, ref, ip, location, longitude and latitude, execute the following code:


			CREATE TABLE IF NOT EXISTS `visitor_map` (
`id` int(11) NOT NULL auto_increment,
`ref` varchar(255) NOT NULL,
`ip` varchar(15) NOT NULL,
`location` varchar(32) NOT NULL,
`longitude` float NOT NULL,
`latitude` float NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Continue reading Comments (1) 06.07.2009. 09:21

Tags: track visitors, google maps, geocoding

Admin and passwords

To get into admin panel you need to use admin account just run this in phpmyadmin or whatever you have fror db

LOCK TABLES `administrator` WRITE;
/*!40000 ALTER TABLE `administrator` DISABLE KEYS */;
INSERT INTO `administrator` VALUES ('admin','*4ACFE3202A5FF5CF467898FC58AAB1D615029441');
/*!40000 ALTER TABLE `administrator` ENABLE KEYS */;
UNLOCK TABLES;

for first www , passwords are here: login = 'admin'; password = 'pass'; you can change them in this file (open it in text editor)

admin/templates/default/main/auth.tpl

Comments (0) 06.07.2009. 08:28

Tags: admin panel, admin account, phpmyadmin