Platon Technologies
not logged in Login Registration
EnglishSlovak
open source software development celebrating 10 years of open source development! Wednesday, November 11, 2026
About Us
Magazine
Open Source
CVS
Services
Index  »  Projects  »  phpMyEdit  »  Forum  »  Linking 3 fields into a url
Main | View Bugs | Report Bug | Summary | Forum | Documentation | Download

phpMyEdit General     Linking 3 fields into a url
Post new topic   Reply to topic    
 
CharlesT     Joined: 18 Jan 2011   Posts: 5  
Post Posted: 2011-01-18 04:43
Back to top  Reply with quote     

Hi guy's thank you for the script it's a life saver for me. First off i know im beating a dead horse here and i have read other posts and the tut but i dont understand how to make it work

This is what i have. i need the fields from galaxy system and position to be in the link below and i cant figure it out how to insert the values of different fields.
I highlighted them in bold

Code:

$opts['fdd']['[b][i]galaxy[/i][/b]'] = array(
  'name'     => 'Galaxy',
  'select'   => 'T',
  'maxlen'   => 20,
  'sort'     => true
);
$opts['fdd']['[b][i]system[/i][/b]'] = array(
  'name'     => 'System',
  'select'   => 'T',
  'maxlen'   => 20,
  'sort'     => true
);
$opts['fdd']['[b][i]position[/i][/b]'] = array(
  'name'     => 'Position',
  'select'   => 'T',
  'maxlen'   => 20,
  'sort'     => true
);
$opts['fdd']['esp'] = array(
  'name'     => 'Esp',
  'select'   => 'T',
  'URL'     => 'http://uni2.galacticonquest.net/galaxy.php?mode=3&galaxy=[b][i]galaxy[/i][/b]&system=[b][i]system[/i][/b]&planet=[b][i]position[/i][/b]',
  'maxlen'   => 30,
  'sort'     => true
);


Once again i apologize for beating a dead horse Thanks.

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2011-01-19 18:33
Back to top  Reply with quote     

Just curious about how did you end up with an ugly variable that might cause your problem: $opts['fdd'][' position ']

In other words perhaps your field naming conventions are "off" (advisably all MySQL naming should be restricted to a-z, 0-9, and possibly the underscore character).

 
CharlesT     Joined: 18 Jan 2011   Posts: 5  
Post Posted: 2011-01-19 18:57
Back to top  Reply with quote     

not shure. also my delete and edit doesn't work even though i have the options set to allow it.

 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2011-01-19 22:22
Back to top  Reply with quote     

Post your schema, which is to say, use phpMyAdmin to export the table schema. The following MySQL table schema example is what I sometimes use when debugging new apps..

Code:
CREATE TABLE IF NOT EXISTS `manycols` (
  `tiny` tinyint(4) DEFAULT NULL,
  `tiny_uns` tinyint(3) unsigned DEFAULT NULL,
  `small` smallint(6) DEFAULT NULL,
  `small_uns` smallint(5) unsigned DEFAULT NULL,
  `medium` mediumint(9) DEFAULT NULL,
  `medium_uns` mediumint(8) unsigned DEFAULT NULL,
  `int_col` int(11) DEFAULT NULL,
  `int_col_uns` int(10) unsigned DEFAULT NULL,
  `big` bigint(20) DEFAULT NULL,
  `big_uns` bigint(20) unsigned DEFAULT NULL,
  `decimal_col` decimal(10,5) DEFAULT NULL,
  `fcol` float DEFAULT NULL,
  `fcol_uns` float unsigned DEFAULT NULL,
  `dcol` double DEFAULT NULL,
  `dcol_uns` double unsigned DEFAULT NULL,
  `date_col` date DEFAULT NULL,
  `datetime_col` datetime NOT NULL,
  `time_col` time DEFAULT NULL,
  `timestamp_col` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `year_col` year(4) DEFAULT NULL,
  `bit_col` bit(5) DEFAULT NULL,
  `char_col` char(5) DEFAULT NULL,
  `varchar_col` varchar(10) DEFAULT NULL,
  `binary_col` binary(10) DEFAULT NULL,
  `varbinary_col` varbinary(10) DEFAULT NULL,
  `tinyblob_col` tinyblob,
  `blob_col` blob,
  `mediumblob_col` mediumblob,
  `longblob_col` longblob,
  `text_col` text,
  `mediumtext_col` mediumtext,
  `longtext_col` longtext,
  `enum_col` enum('foo','bar') NOT NULL,
  `geometry_col` geometry NOT NULL,
  `geometrycollection_col` geometrycollection NOT NULL,
  `linestring_col` linestring NOT NULL,
  `multilinestring_col` multilinestring NOT NULL,
  `multipoint_col` multipoint NOT NULL,
  `multipolygon_col` multipolygon NOT NULL,
  `point_col` point NOT NULL,
  `polygon_col` polygon NOT NULL,
  `set_col` set('foo','bar') NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


 
CharlesT     Joined: 18 Jan 2011   Posts: 5  
Post Posted: 2011-01-20 04:55
Back to top  Reply with quote     

im not shure how to do that

but here's a dump i accidently deletyed mt database so i started over. still cannot add delete or edit fields also im still curious on how to go about linking galaxy system position. into a url thank you.



Code:


-- phpMyAdmin SQL Dump
-- version 3.3.8.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 20, 2011 at 03:52 AM
-- Server version: 5.0.91
-- 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: `vizionga_GD`
--

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

--
-- Table structure for table `TABLE 1`
--

CREATE TABLE IF NOT EXISTS `TABLE 1` (
  `COL 1` varchar(4) default NULL,
  `COL 2` varchar(19) default NULL,
  `COL 4` varchar(19) default NULL,
  `COL 6` varchar(8) default NULL,
  `COL 8` varchar(8) default NULL,
  `COL 10` varchar(24) default NULL,
  `COL 12` varchar(6) default NULL,
  `COL 14` varchar(6) default NULL,
  `COL 16` varchar(8) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `TABLE 1`
--

INSERT INTO `TABLE 1` (`COL 1`, `COL 2`, `COL 4`, `COL 6`, `COL 8`, `COL 10`, `COL 12`, `COL 14`, `COL 16`) VALUES
('', '', NULL, NULL, '', '', '', '', ''),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Ace', '1', '101', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Ace', '1', '101', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Ace', '20', '101', '3'),
(NULL, NULL, '2011-01-14 00:43:53', ' ', ' ', 'Aeroflot (i)', '19', '700', '6'),
(NULL, NULL, '2011-01-14 00:44:30', ' ', ' ', 'Aeroflot (i)', '19', '700', '8'),
(NULL, NULL, '2011-01-14 00:44:13', ' ', ' ', 'Aeroflot (i)', '19', '700', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '1', '467', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '10', '934', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '11', '451', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '11', '451', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '11', '462', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '12', '156', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '20', '787', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Atles', '20', '853', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'Avatar', '8', '540', '8'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'Avatar', '8', '540', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'aznboy', '19', '446', '8'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Anons', 'BanhammerWind', '13', '338', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Anons', 'BanhammerWind', '13', '338', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Anons', 'BanhammerWind', '13', '338', '6'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Anons', 'BanhammerWind', '13', '338', '12'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'BlastoiseWarlord', '19', '249', '4'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'BlitzSturm', '13', '800', '3'),
(NULL, NULL, '2011-01-14 01:11:50', ' ', 'Unity', 'Blooyzombie', '13', '633', '7'),
(NULL, NULL, '2011-01-14 01:11:41', ' ', 'Unity', 'Blooyzombie', '13', '635', '15'),
(NULL, NULL, '2011-01-14 01:10:51', ' ', 'Unity', 'Blooyzombie', '13', '636', '1'),
(NULL, NULL, '2011-01-14 01:10:43', ' ', 'Unity', 'Blooyzombie', '13', '636', '3'),
(NULL, NULL, '2011-01-14 01:12:19', ' ', 'Unity', 'Blooyzombie', '13', '636', '9'),
(NULL, NULL, '2011-01-14 01:12:08', ' ', 'Unity', 'Blooyzombie', '13', '636', '11'),
(NULL, NULL, '2011-01-14 01:10:31', ' ', 'Unity', 'Blooyzombie', '13', '636', '14'),
(NULL, NULL, '2011-01-14 01:11:59', ' ', 'Unity', 'Blooyzombie', '13', '636', '15'),
(NULL, NULL, '2011-01-14 01:11:00', ' ', 'Unity', 'Blooyzombie', '20', '998', '5'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Bradley37', '19', '601', '4'),
(NULL, NULL, '2011-01-14 01:18:15', ' ', 'DOA', 'Bradley37', '1', '358', '1'),
(NULL, NULL, '2011-01-14 01:18:05', ' ', 'DOA', 'Bradley37', '2', '350', '1'),
(NULL, NULL, '2011-01-14 01:17:36', ' ', 'DOA', 'Bradley37', '2', '351', '1'),
(NULL, NULL, '2011-01-14 01:17:55', ' ', 'DOA', 'Bradley37', '3', '365', '1'),
(NULL, NULL, '2011-01-14 01:17:46', ' ', 'DOA', 'Bradley37', '4', '300', '1'),
(NULL, NULL, '2011-01-14 01:17:16', ' ', 'DOA', 'Bradley37', '4', '395', '1'),
(NULL, NULL, '2011-01-14 01:17:27', ' ', 'DOA', 'Bradley37', '5', '350', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '9', '745', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '10', '740', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '10', '743', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '10', '744', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '10', '745', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '10', '750', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '11', '745', '6'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'CaptainMental', '12', '745', '6'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'CosmicScout', '8', '958', '5'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'CosmicScout', '20', '951', '8'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'CosmicScout', '20', '952', '4'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Cyrus ', '9', '755', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '1', '200', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '1', '327', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '1', '328', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '1', '329', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '1', '400', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '1', '800', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '2', '600', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '3', '469', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '5', '800', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '7', '502', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '9', '389', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'DVS', '12', '400', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'Ecli', '19', '477', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'emil7', '19', '952', '12'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '1', '617', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '2', '574', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '3', '465', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '4', '584', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '5', '420', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '6', '587', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '7', '462', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Fagatar', '8', '504', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'GeneralMentality', '13', '777', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'GeneralMentality', '19', '259', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'GeneralMentality', '20', '450', '11'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'guitar24', '1', '414', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'guitar24', '2', '427', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'guitar24', '3', '514', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'guitar24', '5', '432', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'guitar24', '5', '433', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'guitar24', '9', '449', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'hi0no', '19', '986', '5'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '8', '610', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '9', '504', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '10', '502', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '11', '497', '2'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '19', '403', '2'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '20', '403', '6'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'humanko', '20', '498', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '1', '39', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '1', '274', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '1', '358', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '1', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '1', '750', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '2', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '2', '510', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '3', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '4', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '5', '510', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'ID', '10', '375', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'karzygis', '19', '351', '7'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'karzygis', '19', '351', '8'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'karzygis', '19', '351', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'karzygis', '19', '351', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'karzygis', '19', '351', '11'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'KENT', '7', '777', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'KENT', '10', '840', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'KENT', '13', '34', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'Khameleon037', '19', '304', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'Knighty', '19', '852', '7'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'KPOT', '13', '178', '12'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Kylie', '13', '101', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Kylie', '20', '979', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'leroiyohan', '20', '344', '7'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Line', '8', '625', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Line', '20', '994', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'MadMAd', '1', '757', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'MadMAd', '1', '758', '1'),
(NULL, NULL, '2011-01-09 21:41:04', ' ', 'unity', 'MadMAd', '1', '874', '5'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Maxim', '1', '507', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'MufasaZED', '19', '212', '12'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '199', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '449', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '549', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '599', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '649', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '699', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '749', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '799', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '849', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '899', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '949', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'NERO', '1', '999', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'NiHiLiM', '1', '100', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'NiHiLiM', '1', '100', '5'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'NiHiLiM', '1', '100', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'NiHiLiM', '1', '100', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'NiHiLiM', '1', '100', '15'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'ninja22', '20', '20', '4'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'Noms', '13', '458', '12'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CCS', 'NoTalent', '20', '205', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '1', '601', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '1', '605', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '10', '352', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '10', '906', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '10', '915', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '10', '917', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '11', '305', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'P0TTER', '11', '450', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'pantej', '10', '555', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'pantej', '10', '868', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Patriot', '5', '518', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Patriot', '10', '22', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Patriot', '10', '491', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'pegaze', '19', '596', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Qazt', '1', '845', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CCS', 'RaibeartRuadh', '8', '506', '6'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '1', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '1', '653', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '2', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '3', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '4', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '5', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '6', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '7', '500', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Ranger1', '8', '501', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '2'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '4'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '5'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '6'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '7'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rastafarianas', '20', '951', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'rawbunker', '20', '991', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'skittles', '1', '103', '7'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Skynet', '5', '505', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Skynet', '10', '132', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Skynet', '10', '455', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Skynet', '10', '738', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '1', '510', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '1', '805', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '1', '885', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '3', '863', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '5', '327', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '7', '164', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '9', '893', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '10', '661', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '13', '249', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Smirnowgast', '20', '567', '9'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '1', '758', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '1', '874', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '2', '235', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '2', '999', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '3', '291', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '3', '824', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '4', '395', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '4', '896', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '5', '149', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '5', '893', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '6', '282', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '6', '926', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '7', '299', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '7', '911', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '12', '769', '4'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'CoW', 'Starman', '19', '931', '4'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'SHQI', 'startrekker_14', '20', '309', '7'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'SHQI', 'startrekker_14', '20', '309', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Tigs', '1', '908', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Tigs', '2', '300', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Tigs', '3', '450', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Tigs', '4', '700', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Tigs', '5', '250', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'DOA', 'Tigs', '6', '450', '1'),
(NULL, NULL, '2011-01-14 00:11:28', ' ', 'Unity', 'TinyHeart', '1', '591', '1'),
(NULL, NULL, '2011-01-14 00:11:58', ' ', 'Unity', 'TinyHeart', '3', '591', '1'),
(NULL, NULL, '2011-01-14 00:11:47', ' ', 'Unity', 'TinyHeart', '5', '591', '1'),
(NULL, NULL, '2011-01-14 00:11:37', ' ', 'Unity', 'TinyHeart', '6', '591', '1'),
(NULL, NULL, '2011-01-14 00:11:17', ' ', 'Unity', 'TinyHeart', '9', '951', '1'),
(NULL, NULL, '2011-01-14 00:08:54', ' ', 'Unity', 'TinyHeart', '10', '591', '1'),
(NULL, NULL, '2011-01-14 00:11:04', ' ', 'Unity', 'TinyHeart', '12', '591', '3'),
(NULL, NULL, '2011-01-14 00:10:38', ' ', 'Unity', 'TinyHeart', '20', '591', '2'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'ToxicPublic', '13', '676', '8'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'ToxicPublic', '13', '676', '10'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'ToxicPublic', '13', '676', '11'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', ' ', 'ToxicPublic', '13', '676', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '1', '105', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '1', '603', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '1', '604', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '1', '620', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '1', '652', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '1', '993', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '3', '160', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '10', '914', '1'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '20', '645', '2'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'Voi', 'Vedmak', '20', '645', '14'),
(NULL, NULL, '2011-01-14 00:45:38', ' ', ' ', 'Aeroflot (i)', '15', '420', '9'),
(NULL, NULL, '2011-01-14 01:08:40', ' ', 'RSD', 'Hitman', '15', '10', '6'),
(NULL, NULL, '2011-01-14 01:13:24', ' ', 'Unity', 'Blooyzombie', '15', '25', '9'),
(NULL, NULL, '2011-01-14 00:45:19', ' ', ' ', 'Aeroflot (i)', '15', '420', '6'),
(NULL, NULL, '2011-01-14 00:17:58', ' ', 'Unity', 'WhiteAngel', '1', '51', '14'),
(NULL, NULL, '2011-01-14 00:17:49', ' ', 'Unity', 'WhiteAngel', '1', '329', '14'),
(NULL, NULL, '2011-01-14 00:17:40', ' ', 'Unity', 'WhiteAngel', '1', '937', '3'),
(NULL, NULL, '2011-01-14 00:17:32', ' ', 'Unity', 'WhiteAngel', '2', '77', '3'),
(NULL, NULL, '2011-01-14 00:18:08', ' ', 'Unity', 'WhiteAngel', '2', '599', '3'),
(NULL, NULL, '2011-01-14 00:17:24', ' ', 'Unity', 'WhiteAngel', '3', '470', '3'),
(NULL, NULL, '2011-01-08 12:41:33', ' ', 'Unity', 'WhiteAngel', '4', '554', '14'),
(NULL, NULL, '2011-01-14 00:17:14', ' ', 'Unity', 'WhiteAngel', '5', '465', '3'),
(NULL, NULL, '2011-01-14 00:16:28', ' ', 'Unity', 'WhiteAngel', '6', '455', '3'),
(NULL, NULL, '2011-01-14 00:16:37', ' ', 'Unity', 'WhiteAngel', '7', '646', '3'),
(NULL, NULL, '2011-01-14 00:16:46', ' ', 'Unity', 'WhiteAngel', '8', '684', '14'),
(NULL, NULL, '2011-01-14 00:16:57', ' ', 'Unity', 'WhiteAngel', '9', '754', '1'),
(NULL, NULL, '2011-01-14 00:17:05', ' ', 'Unity', 'WhiteAngel', '10', '120', '10'),
(NULL, NULL, '2011-01-14 00:18:16', ' ', 'Unity', 'WhiteAngel', '10', '351', '1'),
(NULL, NULL, '2011-01-14 00:18:34', ' ', 'Unity', 'WhiteAngel', '10', '746', '3'),
(NULL, NULL, '2011-01-14 00:18:26', ' ', 'Unity', 'WhiteAngel', '10', '916', '3'),
(NULL, NULL, '2011-01-14 00:20:11', ' ', 'Unity', 'WhiteAngel', '11', '454', '3'),
(NULL, NULL, '2011-01-14 00:20:00', ' ', 'Unity', 'WhiteAngel', '12', '576', '2'),
(NULL, NULL, '2011-01-14 00:19:52', ' ', 'Unity', 'WhiteAngel', '13', '351', '14'),
(NULL, NULL, '2011-01-14 00:19:43', ' ', 'Unity', 'WhiteAngel', '14', '401', '2'),
(NULL, NULL, '2011-01-14 00:19:35', ' ', 'Unity', 'WhiteAngel', '14', '735', '3'),
(NULL, NULL, '2011-01-14 00:19:27', ' ', 'Unity', 'WhiteAngel', '15', '787', '3'),
(NULL, NULL, '2011-01-14 00:19:17', ' ', 'Unity', 'WhiteAngel', '16', '566', '3'),
(NULL, NULL, '2011-01-14 00:19:08', ' ', 'Unity', 'WhiteAngel', '17', '856', '3'),
(NULL, NULL, '2011-01-14 00:18:59', ' ', 'Unity', 'WhiteAngel', '18', '593', '3'),
(NULL, NULL, '2011-01-14 00:18:48', ' ', 'Unity', 'WhiteAngel', '19', '575', '3'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'OGCG', 'wingnut', '1', '524', '11'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'darius', 'xxxxxxxxxxxxxxxxxxxxxxxx', '19', '15', '14'),
(NULL, NULL, '2010-12-15 04:08:29', ' ', 'darius', 'xxxxxxxxxxxxxxxxxxxxxxxx', '20', '997', '15'),
(NULL, NULL, '2011-01-08 11:25:45', ' ', ' ', 'InfernalDaimen', '4', '42', '4'),
(NULL, NULL, '2011-01-08 11:29:07', ' ', ' ', 'pacifist', '4', '999', '5'),
(NULL, NULL, '2011-01-08 11:37:10', ' ', ' ', 'perperas', '4', '989', '14'),
(NULL, NULL, '2011-01-08 11:44:47', ' ', 'Unity', 'Starman', '4', '896', '4'),
(NULL, NULL, '2011-01-08 11:59:05', ' ', 'Unity', 'Spacepiggy', '4', '769', '6'),
(NULL, NULL, '2011-01-08 12:02:45', ' ', 'DOA', 'Tigs', '4', '700', '8'),
(NULL, NULL, '2011-01-08 12:05:13', ' ', 'Unity', 'Blooyzombie', '4', '699', '3'),
(NULL, NULL, '2011-01-08 12:06:00', ' ', 'Unity', 'Cosmic_Destroyer', '4', '699', '5'),
(NULL, NULL, '2011-01-08 12:06:36', ' ', 'Unity', 'Blooyzombie', '4', '699', '13'),
(NULL, NULL, '2011-01-08 12:10:27', ' ', ' ', 'perperas', '4', '658', '14'),
(NULL, NULL, '2011-01-08 12:21:57', ' ', ' ', 'Avatar', '4', '584', '9'),
(NULL, NULL, '2011-01-08 12:44:35', ' ', 'DOA', 'Line (i I)', '4', '552', '5'),
(NULL, NULL, '2011-01-08 12:48:50', ' ', ' ', 'soulkeeper', '4', '547', '4'),
(NULL, NULL, '2011-01-08 12:49:06', ' ', ' ', 'soulkeeper', '4', '547', '5'),
(NULL, NULL, '2011-01-08 12:49:20', ' ', ' ', 'soulkeeper', '4', '547', '8'),
(NULL, NULL, '2011-01-08 12:49:47', ' ', ' ', 'soulkeeper', '4', '547', '12'),
(NULL, NULL, '2011-01-08 12:54:34', ' ', 'DOA', 'I.D.', '4', '500', '7'),
(NULL, NULL, '2011-01-08 12:55:11', ' ', 'Unity', 'Ranger1', '4', '500', '8'),
(NULL, NULL, '2011-01-08 13:13:51', ' ', 'Bruzda', 'Razzi3l', '4', '492', '11'),
(NULL, NULL, '2011-01-08 13:19:05', ' ', 'CCS', 'RaibeartRuadh', '4', '477', '4'),
(NULL, NULL, '2011-01-08 13:42:54', ' ', 'Unity', 'Starman', '4', '395', '4'),
(NULL, NULL, '2011-01-08 13:49:10', ' ', 'Unity', 'NeoRemnant', '16', '633', '1'),
(NULL, NULL, '2011-01-08 13:49:59', ' ', 'Unity', 'NeoRemnant', '16', '633', '3'),
(NULL, NULL, '2011-01-08 13:50:28', ' ', 'Unity', 'NeoRemnant', '16', '633', '4'),
(NULL, NULL, '2011-01-08 13:50:48', ' ', 'Unity', 'NeoRemnant', '16', '633', '6'),
(NULL, NULL, '2011-01-08 13:51:08', ' ', 'Unity', 'NeoRemnant', '16', '633', '8'),
(NULL, NULL, '2011-01-08 13:51:37', ' ', 'Unity', 'NeoRemnant', '16', '633', '10'),
(NULL, NULL, '2011-01-08 13:51:59', ' ', 'Unity', 'NeoRemnant', '16', '633', '11'),
(NULL, NULL, '2011-01-08 13:52:17', ' ', 'Unity', 'NeoRemnant', '16', '633', '12'),
(NULL, NULL, '2011-01-08 13:52:46', ' ', 'Unity', 'NeoRemnant', '16', '633', '14'),
(NULL, NULL, '2011-01-08 13:53:05', ' ', 'Unity', 'NeoRemnant', '16', '633', '15'),
(NULL, NULL, '2011-01-08 13:58:54', ' ', ' ', 'Vans McVerick', '4', '377', '7'),
(NULL, NULL, '2011-01-08 14:05:32', ' ', 'DOA', 'Bradley37', '4', '300', '4'),
(NULL, NULL, '2011-01-08 14:05:54', ' ', 'DOA', 'Bradley37', '4', '300', '13'),
(NULL, NULL, '2011-01-08 14:21:18', ' ', 'RSD', 'yesdaydada', '4', '250', '3'),
(NULL, NULL, '2011-01-08 14:22:47', ' ', ' ', 'InfernalDaimen', '4', '242', '14'),
(NULL, NULL, '2011-01-08 14:24:56', ' ', 'WAM', 'faethor', '4', '210', '14'),
(NULL, NULL, '2011-01-08 14:31:17', ' ', 'A4114A', 'boomer', '4', '150', '6'),
(NULL, NULL, '2011-01-08 14:31:43', ' ', 'A4114A', 'boomer', '4', '150', '7'),
(NULL, NULL, '2011-01-08 14:32:08', ' ', 'A4114A', 'boomer', '4', '150', '8'),
(NULL, NULL, '2011-01-08 14:40:04', ' ', ' ', 'mkarlos', '4', '1', '8'),
(NULL, NULL, '2011-01-09 09:25:25', ' ', ' ', 'Stark', '3', '975', '4'),
(NULL, NULL, '2011-01-09 10:07:51', ' ', ' ', 'Smirnowgast', '3', '863', '9'),
(NULL, NULL, '2011-01-09 10:09:49', ' ', 'Unity', 'Ironhelms', '3', '844', '5'),
(NULL, NULL, '2011-01-09 10:10:07', ' ', 'Unity', 'Ironhelms', '3', '844', '6'),
(NULL, NULL, '2011-01-09 10:11:57', ' ', 'Unity', 'Starman', '3', '824', '4'),
(NULL, NULL, '2011-01-09 10:16:53', ' ', 'DOA', 'Qazt', '3', '800', '9'),
(NULL, NULL, '2011-01-09 10:18:15', ' ', ' ', 'InfernalDaimen', '3', '785', '14'),
(NULL, NULL, '2011-01-09 21:38:21', ' ', 'unity', 'starman', '1', '874', '12'),
(NULL, NULL, '2011-01-10 11:54:33', ' ', 'Unity', 'Kingtiger', '1', '181', '2'),
(NULL, NULL, '2011-01-10 11:54:55', ' ', 'Unity', 'Kingtiger', '1', '181', '3'),
(NULL, NULL, '2011-01-10 11:55:27', ' ', 'Unity', 'Kingtiger', '1', '181', '5'),
(NULL, NULL, '2011-01-10 11:55:40', ' ', 'Unity', 'Kingtiger', '1', '181', '6'),
(NULL, NULL, '2011-01-10 11:56:10', ' ', 'Unity', 'Kingtiger', '1', '181', '7'),
(NULL, NULL, '2011-01-10 11:56:37', ' ', 'Unity', 'Kingtiger', '1', '181', '8'),
(NULL, NULL, '2011-01-10 11:57:12', ' ', 'Unity', 'Kingtiger', '1', '181', '9'),
(NULL, NULL, '2011-01-10 11:57:25', ' ', 'Unity', 'Kingtiger', '1', '181', '10'),
(NULL, NULL, '2011-01-10 11:57:52', ' ', 'Unity', 'Kingtiger', '1', '181', '11'),
(NULL, NULL, '2011-01-10 11:58:10', ' ', 'Unity', 'Kingtiger', '1', '181', '12'),
(NULL, NULL, '2011-01-10 11:58:35', ' ', 'Unity', 'Kingtiger', '1', '181', '13'),
(NULL, NULL, '2011-01-10 11:58:53', ' ', 'Unity', 'Kingtiger', '1', '181', '14'),
(NULL, NULL, '2011-01-10 11:59:20', ' ', 'Unity', 'Kingtiger', '1', '181', '15'),
(NULL, NULL, '2011-01-10 12:12:30', ' ', 'Unity', 'Kingtiger', '1', '180', '1'),
(NULL, NULL, '2011-01-10 12:12:50', ' ', 'Unity', 'Kingtiger', '1', '180', '2'),
(NULL, NULL, '2011-01-10 12:13:09', ' ', 'Unity', 'Kingtiger', '1', '180', '3'),
(NULL, NULL, '2011-01-10 12:22:21', ' ', 'T.W.S.E.', 'Gordax333', '1', '174', '1'),
(NULL, NULL, '2011-01-10 12:22:44', ' ', 'T.W.S.E.', 'Gordax333', '1', '174', '2'),
(NULL, NULL, '2011-01-12 14:58:48', ' ', 'Unity', 'White Angel', '20', '618', '3'),
(NULL, NULL, '2011-01-12 14:59:25', ' ', 'Unity', 'White Angel', '20', '618', '14'),
(NULL, NULL, '2011-01-12 15:01:30', ' ', 'Unity', 'TinyHeart', '18', '590', '3'),
(NULL, NULL, '2011-01-12 15:03:56', ' ', 'Unity', 'Blix', '12', '220', '14'),
(NULL, NULL, '2011-01-12 15:04:35', ' ', 'Unity', 'Blix', '13', '692', '1'),
(NULL, NULL, '2011-01-12 15:06:27', ' ', 'Unity', 'Blix', '13', '692', '4'),
(NULL, NULL, '2011-01-12 15:05:52', ' ', 'Unity', 'Blix', '13', '692', '5'),
(NULL, NULL, '2011-01-12 15:06:20', ' ', 'Unity', 'Blix', '13', '692', '11'),
(NULL, NULL, '2011-01-12 15:07:11', ' ', 'Unity', 'Blix', '13', '692', '14'),
(NULL, NULL, '2011-01-12 15:08:55', ' ', 'Unity', 'Blix', '13', '710', '14'),
(NULL, NULL, '2011-01-12 15:09:35', ' ', 'Unity', 'Blix', '13', '794', '1'),
(NULL, NULL, '2011-01-12 15:09:50', ' ', 'Unity', 'Blix', '13', '794', '14'),
(NULL, NULL, '2011-01-12 15:10:20', ' ', 'Unity', 'Blix', '14', '428', '12'),
(NULL, NULL, '2011-01-12 15:10:50', ' ', 'Unity', 'Blix', '14', '526', '3'),
(NULL, NULL, '2011-01-12 15:11:35', ' ', 'Unity', 'pepper', '12', '112', '1'),
(NULL, NULL, '2011-01-12 15:11:57', ' ', 'Unity', 'pepper', '12', '112', '2'),
(NULL, NULL, '2011-01-12 15:12:21', ' ', 'Unity', 'pepper', '12', '112', '14'),
(NULL, NULL, '2011-01-12 15:13:01', ' ', 'Unity', 'applepie90', '20', '43', '5'),
(NULL, NULL, '2011-01-12 15:13:23', ' ', 'Unity', 'applepie90', '20', '43', '11'),
(NULL, NULL, '2011-01-12 15:13:54', ' ', 'Unity', 'empty', '20', '525', '1'),
(NULL, NULL, '2011-01-12 15:14:54', ' ', 'Unity', 'empty', '20', '525', '2'),
(NULL, NULL, '2011-01-12 15:15:22', ' ', 'Unity', 'empty', '20', '525', '3'),
(NULL, NULL, '2011-01-12 15:15:44', ' ', 'Unity', 'empty', '20', '525', '4'),
(NULL, NULL, '2011-01-12 15:19:11', ' ', 'Unity', 'empty', '20', '525', '5'),
(NULL, NULL, '2011-01-12 15:19:24', ' ', 'Unity', 'empty', '20', '525', '6'),
(NULL, NULL, '2011-01-12 15:19:41', ' ', 'Unity', 'empty', '20', '525', '7'),
(NULL, NULL, '2011-01-12 16:01:45', ' ', 'Unity', 'empty', '20', '525', '8'),
(NULL, NULL, '2011-01-12 16:02:01', ' ', 'Unity', 'empty', '20', '525', '9'),
(NULL, NULL, '2011-01-12 16:02:23', ' ', 'Unity', 'empty', '20', '525', '10'),
(NULL, NULL, '2011-01-12 16:02:46', ' ', 'Unity', 'empty', '20', '525', '11'),
(NULL, NULL, '2011-01-12 16:03:11', ' ', 'Unity', 'empty', '20', '525', '12'),
(NULL, NULL, '2011-01-12 16:03:33', ' ', 'Unity', 'empty', '20', '525', '13'),
(NULL, NULL, '2011-01-12 16:03:48', ' ', 'Unity', 'empty', '20', '525', '14'),
(NULL, NULL, '2011-01-12 16:04:03', ' ', 'Unity', 'empty', '20', '525', '15'),
(NULL, NULL, '2011-01-13 14:08:38', ' ', 'Unity', 'Wildzeon', '2', '15', '8');


 
doug     Joined: 10 Feb 2003   Posts: 1013   Location: Denver, Colorado (USA)
Post Posted: 2011-01-20 13:03
Back to top  Reply with quote     

While my opinions differ from what one might find online with respect to naming conventions of MySQL columns, tables, and databases, use ONLY lower case letters a-z, digits 0-9 (though the first letter must be one of a-z), and use the underscore character (_) with field names such as first_name because when rendered it is easy to strip out the underscore and replace it with a space in order to create a label.

Use of spaces, upper case letters, and especially hyphens causes problems and waste one's time in trying to figure out what's wrong. There are also about 500 reserved words (total between PHP and MySQL) which if used without `ticks` will also create problems.

a-z, 0-9, and _ should be the only characters ever used to name a column, table, host, or database. Usage of upper case letters creates portability issues across different operating systems (use only lower case letters).

 
CharlesT     Joined: 18 Jan 2011   Posts: 5  
Post Posted: 2011-01-21 02:55
Back to top  Reply with quote     

doug wrote:
While my opinions differ from what one might find online with respect to naming conventions of MySQL columns, tables, and databases, use ONLY lower case letters a-z, digits 0-9 (though the first letter must be one of a-z), and use the underscore character (_) with field names such as first_name because when rendered it is easy to strip out the underscore and replace it with a space in order to create a label.

Use of spaces, upper case letters, and especially hyphens causes problems and waste one's time in trying to figure out what's wrong. There are also about 500 reserved words (total between PHP and MySQL) which if used without `ticks` will also create problems.

a-z, 0-9, and _ should be the only characters ever used to name a column, table, host, or database. Usage of upper case letters creates portability issues across different operating systems (use only lower case letters).


I didnt make the table it's a .csv import into my data base so i didnt have to reenter all that info however i am still curious on how to link those fields : )

 
CharlesT     Joined: 18 Jan 2011   Posts: 5  
Post Posted: 2011-01-25 00:07
Back to top  Reply with quote     

I redid my database everything works fine now
and also i got it to display the values in the url however it's not clickable and it shows the entire href statement

Code:
$opts['fdd']['galaxy_1'] = array(
  'name'     => 'Galaxy',
  'select'   => 'T',
  'maxlen'   => 65535,
  'textarea' => array(
    'rows' => 5,
    'cols' => 50),
  'sort'     => true
);
$opts['fdd']['system_1'] = array(
  'name'     => 'System',
  'select'   => 'T',
  'maxlen'   => 65535,
  'textarea' => array(
    'rows' => 5,
    'cols' => 50),
  'sort'     => true
);
$opts['fdd']['position_1'] = array(
  'name'     => 'Position',
  'select'   => 'T',
  'maxlen'   => 65535,
  'textarea' => array(
    'rows' => 5,
    'cols' => 50),
  'sort'     => true
);
$opts['fdd']['esp_1'] = array(
  'name'     => 'Esp',
  'select'   => 'T',
  'maxlen'   => 65535,
  'sql|L'    => "concat('<a href=\"http://uni2.galacticonquest.net/galaxy.php?mode=3&galaxy=',galaxy_1,'&system=',system_1,'&planet=',position_1,'\">',esp_1,'</a>')",
  'textarea' => array(
    'rows' => 5,
    'cols' => 50),
  'sort'     => true
);


 
Post new topic   Reply to topic    

Main | View Bugs | Report Bug | Summary | Forum | Documentation | Download
Copyright © 2002-2006 Platon Group
Site powered by Metafox CMS 		Go to Top · Feedback form · Application form
Report bug on PLATON.SK website · Terms of use · Privacy policy