close× Call Us +49 (1805) 01 29 59

SGI Fusion
Thread Author: turbo-opa
Thread ID: 2442
Thread Info
Es gibt 5 Beiträge zu diesem Thema, und es wurde 1856 mal angesehen.
Wer ist hier? 1 Gäste
 Thema drucken
My sql
turbo-opa
frage gib es ne möglichkeit datenbank tabellen in die my sql zu importieren wenn mann nicht die weboberfläche dafür zur hand hat?
folgendes möchte gerne für einen freund die country fields einbauen. jetzt habe ich zwar alle passwörter die ich brauche aber ich komme nicht an die daten damit ich über den browser in die daten bank komme somit kann ich auch nicht die nötigen tabellen importieren.

es gab bei der v6 mal eine infusion wo ichs direkt über den admin bereichmachen konnte. gibts das teil auch schon für die v7?

danke gruß uwe
radio-4fun.info/hg/banner9.gif
 
SC-Ad-Bot
 
emblinux
Welche Infusion du jetzt meinst weiß ich jetzt nicht, aber man kann die Daten auch anders importieren. Dazu muss man die SQL-Befehle, welche eigentlich in so einer SQL-Backup-Datei vorhanden sind, ein wenig anpassen und in eine Variable packen und diese Variable dann mit der Funktion dbquery in die DB importieren.

Dazu sollte man aber aussreichend PHP und MYSQL Grundkenntnisse haben. Unerfahrene kann ich davon nur abraten.
Das Lernen ist wie ein Meer ohne Ufer. Konfuzius

Alles wird Gut!

KEIN Support per Mail, ICQ oder PN !
www.heiseclan.de/fusion/sig.gif

www.heiseclan.de/geosig.gif
 
turbo-opa
ok also nicht unbedingt was für mich. my sql admin hieß die infusion glaub ich mann konnte aus dem admin bereich über ne infusion direkt auf die db zugreifen.

-- phpMyAdmin SQL Dump
-- version 2.10.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 25, 2008 at 08:52 PM
-- Server version: 5.0.51
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `esac`
--

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

--
-- Table structure for table `fusion_nations`
--

CREATE TABLE `fusion_nations` (
  `nat_id` smallint(5) unsigned NOT NULL auto_increment,
  `nat_name` varchar(150) NOT NULL,
  `nat_pic` varchar(200) NOT NULL,
  PRIMARY KEY  (`nat_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=236 ;

--
-- Dumping data for table `fusion_nations`
--

INSERT INTO `fusion_nations` (`nat_id`, `nat_name`, `nat_pic`) VALUES
(1, 'Sweden', 'images/flags/f-se.gif'),
(2, 'Norway', 'images/flags/f-no.gif'),
(3, 'Finland', 'images/flags/f-fi.gif'),
(4, 'Spain', 'images/flags/f-es.gif'),
(6, 'France', 'images/flags/f-fr.gif'),
(7, 'Argentina', 'images/flags/f-ar.gif'),
(8, 'Uruguay', 'images/flags/f-uy.gif'),
(9, 'Denmark', 'images/flags/f-dk.gif'),
(10, 'Afghanistan', 'images/flags/f-af.gif'),
(11, 'Albania', 'images/flags/f-al.gif'),
(12, 'Algeria', 'images/flags/f-dz.gif'),
(14, 'Andorra', 'images/flags/f-ad.gif'),
(15, 'Australia', 'images/flags/f-au.gif'),
(16, 'Anguilla', 'images/flags/f-ai.gif'),
(17, 'Antigua and Barbuda', 'images/flags/f-ag.gif'),
(19, 'Armenia', 'images/flags/f-am.gif'),
(20, 'Aruba', 'images/flags/f-aw.gif'),
(21, 'Ashmore and Cartier Islands', 'images/flags/f-au.gif'),
(23, 'Austria', 'images/flags/f-at.gif'),
(24, 'Azerbaijan', 'images/flags/f-az.gif'),
(25, 'Bahamas', 'images/flags/f-bs.gif'),
(26, 'Bahrain', 'images/flags/f-bh.gif'),
(27, 'Bangladesh', 'images/flags/f-bd.gif'),
(28, 'Barbados', 'images/flags/f-bb.gif'),
(29, 'Belarus', 'images/flags/f-by.gif'),
(30, 'Belgium', 'images/flags/f-be.gif'),
(31, 'Belize', 'images/flags/f-bz.gif'),
(32, 'Benin', 'images/flags/f-bj.gif'),
(33, 'Bhutan', 'images/flags/f-bt.gif'),
(34, 'Bolivia', 'images/flags/f-bo.gif'),
(35, 'Bosnia and Herzegovina', 'images/flags/f-ba.gif'),
(37, 'Botswana', 'images/flags/f-bw.gif'),
(38, 'Brazil', 'images/flags/f-br.gif'),
(39, 'United Kingdom', 'images/flags/f-uk.gif'),
(40, 'Brunei', 'images/flags/f-bn.gif'),
(41, 'Bulgaria', 'images/flags/f-bg.gif'),
(42, 'Burkina Faso', 'images/flags/f-bf.gif'),
(43, 'Burma (Myanmar)', 'images/flags/f-mm.gif'),
(44, 'Burundi', 'images/flags/f-bi.gif'),
(45, 'Cambodia', 'images/flags/f-kh.gif'),
(46, 'Cameroon', 'images/flags/f-cm.gif'),
(47, 'Canada', 'images/flags/f-ca.gif'),
(48, 'Cape Verde', 'images/flags/f-cv.gif'),
(49, 'Cayman Islands', 'images/flags/f-ky.gif'),
(50, 'Central African Republic', 'images/flags/f-cf.gif'),
(51, 'Chad', 'images/flags/f-td.gif'),
(52, 'Chile', 'images/flags/f-cl.gif'),
(53, 'China', 'images/flags/f-cn.gif'),
(54, 'Christmas Island', 'images/flags/f-cx.gif'),
(56, 'Colombia', 'images/flags/f-co.gif'),
(57, 'Comoros', 'images/flags/f-km.gif'),
(58, 'Congo', 'images/flags/f-cg.gif'),
(60, 'Cook Islands', 'images/flags/f-ck.gif'),
(61, 'Costa Rica', 'images/flags/f-cr.gif'),
(62, 'Cote d'Ivoire', 'images/flags/f-ci.gif'),
(63, 'Croatia', 'images/flags/f-hr.gif'),
(64, 'Cuba', 'images/flags/f-cu.gif'),
(65, 'Cyprus', 'images/flags/f-cy.gif'),
(66, 'Czech Republic', 'images/flags/f-cz.gif'),
(68, 'Djibouti', 'images/flags/f-dj.gif'),
(69, 'Dominica', 'images/flags/f-dm.gif'),
(70, 'Dominican Republic', 'images/flags/f-do.gif'),
(71, 'East Timor', 'images/flags/f-tp.gif'),
(72, 'Ecuador', 'images/flags/f-ec.gif'),
(73, 'Egypt', 'images/flags/f-eg.gif'),
(74, 'El Salvador', 'images/flags/f-sv.gif'),
(75, 'Equatorial Guinea', 'images/flags/f-gq.gif'),
(76, 'Eritrea', 'images/flags/f-er.gif'),
(77, 'Estonia', 'images/flags/f-ee.gif'),
(78, 'Ethiopia', 'images/flags/f-et.gif'),
(79, 'Faroe Islands', 'images/flags/f-fo.gif'),
(80, 'Fiji', 'images/flags/f-fj.gif'),
(81, 'French Guyana', 'images/flags/f-gf.gif'),
(82, 'French Polynesia', 'images/flags/f-pf.gif'),
(83, 'Gabon', 'images/flags/f-ga.gif'),
(84, 'Gambia', 'images/flags/f-gm.gif'),
(85, 'Georgia', 'images/flags/f-ge.gif'),
(86, 'Germany', 'images/flags/f-de.gif'),
(87, 'Ghana', 'images/flags/f-gh.gif'),
(88, 'Greece', 'images/flags/f-gr.gif'),
(89, 'Greenland', 'images/flags/f-gl.gif'),
(90, 'Grenada', 'images/flags/f-gd.gif'),
(91, 'Guadeloupe', 'images/flags/f-gp.gif'),
(92, 'Guam', 'images/flags/f-gu.gif'),
(93, 'Guatemala', 'images/flags/f-gt.gif'),
(95, 'Guinea', 'images/flags/f-gn.gif'),
(96, 'Guinea-Bissau', 'images/flags/f-gw.gif'),
(97, 'Guyana', 'images/flags/f-gy.gif'),
(98, 'Haiti', 'images/flags/f-ht.gif'),
(99, 'Netherlands', 'images/flags/f-nl.gif'),
(100, 'Honduras', 'images/flags/f-hn.gif'),
(101, 'Hungary', 'images/flags/f-hu.gif'),
(102, 'Iceland', 'images/flags/f-is.gif'),
(103, 'India', 'images/flags/f-in.gif'),
(104, 'Indonesia', 'images/flags/f-id.gif'),
(105, 'Iran', 'images/flags/f-ir.gif'),
(106, 'Iraq', 'images/flags/f-iq.gif'),
(107, 'Ireland', 'images/flags/f-ie.gif'),
(109, 'Israel', 'images/flags/f-il.gif'),
(110, 'Italy', 'images/flags/f-it.gif'),
(111, 'Jamaica', 'images/flags/f-jm.gif'),
(112, 'Japan', 'images/flags/f-jp.gif'),
(113, 'Jordan', 'images/flags/f-jo.gif'),
(114, 'Kazakstan', 'images/flags/f-kz.gif'),
(115, 'Kenya', 'images/flags/f-ke.gif'),
(116, 'Kiribati', 'images/flags/f-ki.gif'),
(117, 'Korea, North', 'images/flags/f-kp.gif'),
(118, 'Korea, South', 'images/flags/f-kr.gif'),
(119, 'Kuwait', 'images/flags/f-kw.gif'),
(120, 'Kyrgyzstan', 'images/flags/f-kg.gif'),
(121, 'Laos', 'images/flags/f-la.gif'),
(122, 'Latvia', 'images/flags/f-lv.gif'),
(123, 'Lebanon', 'images/flags/f-lb.gif'),
(124, 'Lesotho', 'images/flags/f-ls.gif'),
(125, 'Liberia', 'images/flags/f-lr.gif'),
(126, 'Libya', 'images/flags/f-ly.gif'),
(127, 'Liechtenstein', 'images/flags/f-li.gif'),
(128, 'Lithuania', 'images/flags/f-lt.gif'),
(129, 'Luxembourg', 'images/flags/f-lu.gif'),
(130, 'Macedonia', 'images/flags/f-mk.gif'),
(131, 'Madagascar', 'images/flags/f-mg.gif'),
(132, 'Malawi', 'images/flags/f-mw.gif'),
(133, 'Malaysia', 'images/flags/f-my.gif'),
(134, 'Maldives', 'images/flags/f-mv.gif'),
(135, 'Mali', 'images/flags/f-ml.gif'),
(136, 'Malta', 'images/flags/f-mt.gif'),
(137, 'Marshall Islands', 'images/flags/f-mh.gif'),
(138, 'Martinique', 'images/flags/f-mq.gif'),
(139, 'Mauritania', 'images/flags/f-mr.gif'),
(140, 'Mauritius', 'images/flags/f-mu.gif'),
(141, 'Mexico', 'images/flags/f-mx.gif'),
(142, 'Micronesia', 'images/flags/f-fm.gif'),
(143, 'Moldova', 'images/flags/f-md.gif'),
(144, 'Monaco', 'images/flags/f-mc.gif'),
(145, 'Mongolia', 'images/flags/f-mn.gif'),
(146, 'Montenegro', 'images/flags/f-me.gif'),
(147, 'Montserrat', 'images/flags/f-ms.gif'),
(148, 'Morocco', 'images/flags/f-ma.gif'),
(149, 'Mozambique', 'images/flags/f-mz.gif'),
(150, 'Namibia', 'images/flags/f-na.gif'),
(151, 'Nauru', 'images/flags/f-nr.gif'),
(152, 'Nepal', 'images/flags/f-np.gif'),
(153, 'Netherlands Antilles', 'images/flags/f-an.gif'),
(154, 'New Caledonia', 'images/flags/f-nc.gif'),
(155, 'New Zealand', 'images/flags/f-nz.gif'),
(156, 'Nicaragua', 'images/flags/f-ni.gif'),
(157, 'Niger', 'images/flags/f-ne.gif'),
(158, 'Nigeria', 'images/flags/f-ng.gif'),
(159, 'Niue', 'images/flags/f-nu.gif'),
(160, 'Norfolk Island', 'images/flags/f-nf.gif'),
(162, 'Northern Mariana Islands', 'images/flags/f-mp.gif'),
(163, 'Oman', 'images/flags/f-om.gif'),
(164, 'Pakistan', 'images/flags/f-pk.gif'),
(165, 'Palau', 'images/flags/f-pw.gif'),
(166, 'Palestine', 'images/flags/f-ps.gif'),
(167, 'Panama', 'images/flags/f-pa.gif'),
(168, 'Papua New Guinea', 'images/flags/f-pg.gif'),
(169, 'Paraguay', 'images/flags/f-py.gif'),
(170, 'Peru', 'images/flags/f-pe.gif'),
(171, 'Philippines', 'images/flags/f-ph.gif'),
(172, 'Poland', 'images/flags/f-pl.gif'),
(173, 'Portugal', 'images/flags/f-pt.gif'),
(174, 'Qatar', 'images/flags/f-qa.gif'),
(175, 'Romania', 'images/flags/f-ro.gif'),
(176, 'Russia', 'images/flags/f-ru.gif'),
(177, 'Saint Kitts and Nevis', 'images/flags/f-kn.gif'),
(178, 'Saint Lucia', 'images/flags/f-lc.gif'),
(179, 'Saint Pierre and Miquelon', 'images/flags/f-pm.gif'),
(180, 'Saint Vincent and the Grenadines', 'images/flags/f-vc.gif'),
(181, 'Samoa', 'images/flags/f-ws.gif'),
(182, 'San Marino', 'images/flags/f-sm.gif'),
(183, 'Sao Tome and Principe', 'images/flags/f-st.gif'),
(184, 'Saudi Arabia', 'images/flags/f-sa.gif'),
(185, 'Senegal', 'images/flags/f-sn.gif'),
(186, 'Serbia', 'images/flags/f-rs.gif'),
(187, 'Seychelles', 'images/flags/f-sc.gif'),
(188, 'Sierra Leone', 'images/flags/f-sl.gif'),
(189, 'Singapore', 'images/flags/f-sg.gif'),
(190, 'Slovakia', 'images/flags/f-sk.gif'),
(191, 'Slovenia', 'images/flags/f-si.gif'),
(192, 'Solomon Islands', 'images/flags/f-sb.gif'),
(193, 'Somalia', 'images/flags/f-so.gif'),
(194, 'South Africa', 'images/flags/f-za.gif'),
(196, 'Sri Lanka', 'images/flags/f-lk.gif'),
(198, 'Sudan', 'images/flags/f-sd.gif'),
(199, 'Suriname', 'images/flags/f-sr.gif'),
(200, 'Swaziland', 'images/flags/f-sz.gif'),
(201, 'Switzerland', 'images/flags/f-ch.gif'),
(202, 'Syria', 'images/flags/f-sy.gif'),
(203, 'Taiwan', 'images/flags/f-tw.gif'),
(204, 'Tajikistan', 'images/flags/f-tj.gif'),
(205, 'Tanzania', 'images/flags/f-tz.gif'),
(206, 'Thailand', 'images/flags/f-th.gif'),
(207, 'Togo', 'images/flags/f-tg.gif'),
(208, 'Tonga', 'images/flags/f-to.gif'),
(209, 'Trinidad and Tobago', 'images/flags/f-tt.gif'),
(210, 'Tunisia', 'images/flags/f-tn.gif'),
(211, 'Turkey', 'images/flags/f-tr.gif'),
(212, 'Turkmenistan', 'images/flags/f-tm.gif'),
(213, 'Turks and Caicos Islands', 'images/flags/f-tc.gif'),
(214, 'Tuvalu', 'images/flags/f-tv.gif'),
(215, 'Uganda', 'images/flags/f-ug.gif'),
(216, 'Ukraine', 'images/flags/f-ua.gif'),
(217, 'United Arab Emirates', 'images/flags/f-ae.gif'),
(218, 'United States', 'images/flags/f-us.gif'),
(220, 'Uzbekistan', 'images/flags/f-uz.gif'),
(221, 'Vanuatu', 'images/flags/f-vu.gif'),
(222, 'Vatican City', 'images/flags/f-va.gif'),
(223, 'Venezuela', 'images/flags/f-ve.gif'),
(224, 'Vietnam', 'images/flags/f-vn.gif'),
(225, 'Yemen', 'images/flags/f-ye.gif'),
(226, 'Yugoslavia', 'images/flags/f-yu.gif'),
(227, 'Zambia', 'images/flags/f-zm.gif'),
(228, 'Zimbabwe', 'images/flags/f-zw.gif'),
(232, 'Ã…land Island', 'images/flags/f-ax.gif'),
(233, 'Angola', 'images/flags/f-ao.gif'),
(235, 'Bouvet Island', 'images/flags/f-bv.gif');
das muß ich übrigens in die datenbank rein bekommen denn er bringt mir folgenden fehler bei aktivierung der profil feldes:
Table 'usr_web984_1.fusion_nations' doesn't existTable 'usr_web984_1.fusion_nations' doesn't exist
Table 'usr_web984_1.fusion_nations' doesn't exist
radio-4fun.info/hg/banner9.gif
 
emblinux
Du kannst mal folgendes in ein neues Panel packen und auf Vorschau gehen, NICHT SPEICHERN. Wenn alles korrekt ist, sollte die Tabelle richtig angelegt werden und die Daten importiert werden.


$sql1 = "CREATE TABLE ".DB_PREFIX."nations (
  nat_id smallint(5) unsigned NOT NULL auto_increment,
  nat_name varchar(150) NOT NULL,
  nat_pic varchar(200) NOT NULL,
  PRIMARY KEY  (nat_id))";

dbquery($sql1);

$sql2 = "INSERT INTO ".DB_PREFIX."nations (nat_id, nat_name, nat_pic) VALUES
(1, 'Sweden', 'images/flags/f-se.gif'),
(2, 'Norway', 'images/flags/f-no.gif'),
(3, 'Finland', 'images/flags/f-fi.gif'),
(4, 'Spain', 'images/flags/f-es.gif'),
(6, 'France', 'images/flags/f-fr.gif'),
(7, 'Argentina', 'images/flags/f-ar.gif'),
(8, 'Uruguay', 'images/flags/f-uy.gif'),
(9, 'Denmark', 'images/flags/f-dk.gif'),
(10, 'Afghanistan', 'images/flags/f-af.gif'),
(11, 'Albania', 'images/flags/f-al.gif'),
(12, 'Algeria', 'images/flags/f-dz.gif'),
(14, 'Andorra', 'images/flags/f-ad.gif'),
(15, 'Australia', 'images/flags/f-au.gif'),
(16, 'Anguilla', 'images/flags/f-ai.gif'),
(17, 'Antigua and Barbuda', 'images/flags/f-ag.gif'),
(19, 'Armenia', 'images/flags/f-am.gif'),
(20, 'Aruba', 'images/flags/f-aw.gif'),
(21, 'Ashmore and Cartier Islands', 'images/flags/f-au.gif'),
(23, 'Austria', 'images/flags/f-at.gif'),
(24, 'Azerbaijan', 'images/flags/f-az.gif'),
(25, 'Bahamas', 'images/flags/f-bs.gif'),
(26, 'Bahrain', 'images/flags/f-bh.gif'),
(27, 'Bangladesh', 'images/flags/f-bd.gif'),
(28, 'Barbados', 'images/flags/f-bb.gif'),
(29, 'Belarus', 'images/flags/f-by.gif'),
(30, 'Belgium', 'images/flags/f-be.gif'),
(31, 'Belize', 'images/flags/f-bz.gif'),
(32, 'Benin', 'images/flags/f-bj.gif'),
(33, 'Bhutan', 'images/flags/f-bt.gif'),
(34, 'Bolivia', 'images/flags/f-bo.gif'),
(35, 'Bosnia and Herzegovina', 'images/flags/f-ba.gif'),
(37, 'Botswana', 'images/flags/f-bw.gif'),
(38, 'Brazil', 'images/flags/f-br.gif'),
(39, 'United Kingdom', 'images/flags/f-uk.gif'),
(40, 'Brunei', 'images/flags/f-bn.gif'),
(41, 'Bulgaria', 'images/flags/f-bg.gif'),
(42, 'Burkina Faso', 'images/flags/f-bf.gif'),
(43, 'Burma (Myanmar)', 'images/flags/f-mm.gif'),
(44, 'Burundi', 'images/flags/f-bi.gif'),
(45, 'Cambodia', 'images/flags/f-kh.gif'),
(46, 'Cameroon', 'images/flags/f-cm.gif'),
(47, 'Canada', 'images/flags/f-ca.gif'),
(48, 'Cape Verde', 'images/flags/f-cv.gif'),
(49, 'Cayman Islands', 'images/flags/f-ky.gif'),
(50, 'Central African Republic', 'images/flags/f-cf.gif'),
(51, 'Chad', 'images/flags/f-td.gif'),
(52, 'Chile', 'images/flags/f-cl.gif'),
(53, 'China', 'images/flags/f-cn.gif'),
(54, 'Christmas Island', 'images/flags/f-cx.gif'),
(56, 'Colombia', 'images/flags/f-co.gif'),
(57, 'Comoros', 'images/flags/f-km.gif'),
(58, 'Congo', 'images/flags/f-cg.gif'),
(60, 'Cook Islands', 'images/flags/f-ck.gif'),
(61, 'Costa Rica', 'images/flags/f-cr.gif'),
(62, 'Cote d'Ivoire', 'images/flags/f-ci.gif'),
(63, 'Croatia', 'images/flags/f-hr.gif'),
(64, 'Cuba', 'images/flags/f-cu.gif'),
(65, 'Cyprus', 'images/flags/f-cy.gif'),
(66, 'Czech Republic', 'images/flags/f-cz.gif'),
(68, 'Djibouti', 'images/flags/f-dj.gif'),
(69, 'Dominica', 'images/flags/f-dm.gif'),
(70, 'Dominican Republic', 'images/flags/f-do.gif'),
(71, 'East Timor', 'images/flags/f-tp.gif'),
(72, 'Ecuador', 'images/flags/f-ec.gif'),
(73, 'Egypt', 'images/flags/f-eg.gif'),
(74, 'El Salvador', 'images/flags/f-sv.gif'),
(75, 'Equatorial Guinea', 'images/flags/f-gq.gif'),
(76, 'Eritrea', 'images/flags/f-er.gif'),
(77, 'Estonia', 'images/flags/f-ee.gif'),
(78, 'Ethiopia', 'images/flags/f-et.gif'),
(79, 'Faroe Islands', 'images/flags/f-fo.gif'),
(80, 'Fiji', 'images/flags/f-fj.gif'),
(81, 'French Guyana', 'images/flags/f-gf.gif'),
(82, 'French Polynesia', 'images/flags/f-pf.gif'),
(83, 'Gabon', 'images/flags/f-ga.gif'),
(84, 'Gambia', 'images/flags/f-gm.gif'),
(85, 'Georgia', 'images/flags/f-ge.gif'),
(86, 'Germany', 'images/flags/f-de.gif'),
(87, 'Ghana', 'images/flags/f-gh.gif'),
(88, 'Greece', 'images/flags/f-gr.gif'),
(89, 'Greenland', 'images/flags/f-gl.gif'),
(90, 'Grenada', 'images/flags/f-gd.gif'),
(91, 'Guadeloupe', 'images/flags/f-gp.gif'),
(92, 'Guam', 'images/flags/f-gu.gif'),
(93, 'Guatemala', 'images/flags/f-gt.gif'),
(95, 'Guinea', 'images/flags/f-gn.gif'),
(96, 'Guinea-Bissau', 'images/flags/f-gw.gif'),
(97, 'Guyana', 'images/flags/f-gy.gif'),
(98, 'Haiti', 'images/flags/f-ht.gif'),
(99, 'Netherlands', 'images/flags/f-nl.gif'),
(100, 'Honduras', 'images/flags/f-hn.gif'),
(101, 'Hungary', 'images/flags/f-hu.gif'),
(102, 'Iceland', 'images/flags/f-is.gif'),
(103, 'India', 'images/flags/f-in.gif'),
(104, 'Indonesia', 'images/flags/f-id.gif'),
(105, 'Iran', 'images/flags/f-ir.gif'),
(106, 'Iraq', 'images/flags/f-iq.gif'),
(107, 'Ireland', 'images/flags/f-ie.gif'),
(109, 'Israel', 'images/flags/f-il.gif'),
(110, 'Italy', 'images/flags/f-it.gif'),
(111, 'Jamaica', 'images/flags/f-jm.gif'),
(112, 'Japan', 'images/flags/f-jp.gif'),
(113, 'Jordan', 'images/flags/f-jo.gif'),
(114, 'Kazakstan', 'images/flags/f-kz.gif'),
(115, 'Kenya', 'images/flags/f-ke.gif'),
(116, 'Kiribati', 'images/flags/f-ki.gif'),
(117, 'Korea, North', 'images/flags/f-kp.gif'),
(118, 'Korea, South', 'images/flags/f-kr.gif'),
(119, 'Kuwait', 'images/flags/f-kw.gif'),
(120, 'Kyrgyzstan', 'images/flags/f-kg.gif'),
(121, 'Laos', 'images/flags/f-la.gif'),
(122, 'Latvia', 'images/flags/f-lv.gif'),
(123, 'Lebanon', 'images/flags/f-lb.gif'),
(124, 'Lesotho', 'images/flags/f-ls.gif'),
(125, 'Liberia', 'images/flags/f-lr.gif'),
(126, 'Libya', 'images/flags/f-ly.gif'),
(127, 'Liechtenstein', 'images/flags/f-li.gif'),
(128, 'Lithuania', 'images/flags/f-lt.gif'),
(129, 'Luxembourg', 'images/flags/f-lu.gif'),
(130, 'Macedonia', 'images/flags/f-mk.gif'),
(131, 'Madagascar', 'images/flags/f-mg.gif'),
(132, 'Malawi', 'images/flags/f-mw.gif'),
(133, 'Malaysia', 'images/flags/f-my.gif'),
(134, 'Maldives', 'images/flags/f-mv.gif'),
(135, 'Mali', 'images/flags/f-ml.gif'),
(136, 'Malta', 'images/flags/f-mt.gif'),
(137, 'Marshall Islands', 'images/flags/f-mh.gif'),
(138, 'Martinique', 'images/flags/f-mq.gif'),
(139, 'Mauritania', 'images/flags/f-mr.gif'),
(140, 'Mauritius', 'images/flags/f-mu.gif'),
(141, 'Mexico', 'images/flags/f-mx.gif'),
(142, 'Micronesia', 'images/flags/f-fm.gif'),
(143, 'Moldova', 'images/flags/f-md.gif'),
(144, 'Monaco', 'images/flags/f-mc.gif'),
(145, 'Mongolia', 'images/flags/f-mn.gif'),
(146, 'Montenegro', 'images/flags/f-me.gif'),
(147, 'Montserrat', 'images/flags/f-ms.gif'),
(148, 'Morocco', 'images/flags/f-ma.gif'),
(149, 'Mozambique', 'images/flags/f-mz.gif'),
(150, 'Namibia', 'images/flags/f-na.gif'),
(151, 'Nauru', 'images/flags/f-nr.gif'),
(152, 'Nepal', 'images/flags/f-np.gif'),
(153, 'Netherlands Antilles', 'images/flags/f-an.gif'),
(154, 'New Caledonia', 'images/flags/f-nc.gif'),
(155, 'New Zealand', 'images/flags/f-nz.gif'),
(156, 'Nicaragua', 'images/flags/f-ni.gif'),
(157, 'Niger', 'images/flags/f-ne.gif'),
(158, 'Nigeria', 'images/flags/f-ng.gif'),
(159, 'Niue', 'images/flags/f-nu.gif'),
(160, 'Norfolk Island', 'images/flags/f-nf.gif'),
(162, 'Northern Mariana Islands', 'images/flags/f-mp.gif'),
(163, 'Oman', 'images/flags/f-om.gif'),
(164, 'Pakistan', 'images/flags/f-pk.gif'),
(165, 'Palau', 'images/flags/f-pw.gif'),
(166, 'Palestine', 'images/flags/f-ps.gif'),
(167, 'Panama', 'images/flags/f-pa.gif'),
(168, 'Papua New Guinea', 'images/flags/f-pg.gif'),
(169, 'Paraguay', 'images/flags/f-py.gif'),
(170, 'Peru', 'images/flags/f-pe.gif'),
(171, 'Philippines', 'images/flags/f-ph.gif'),
(172, 'Poland', 'images/flags/f-pl.gif'),
(173, 'Portugal', 'images/flags/f-pt.gif'),
(174, 'Qatar', 'images/flags/f-qa.gif'),
(175, 'Romania', 'images/flags/f-ro.gif'),
(176, 'Russia', 'images/flags/f-ru.gif'),
(177, 'Saint Kitts and Nevis', 'images/flags/f-kn.gif'),
(178, 'Saint Lucia', 'images/flags/f-lc.gif'),
(179, 'Saint Pierre and Miquelon', 'images/flags/f-pm.gif'),
(180, 'Saint Vincent and the Grenadines', 'images/flags/f-vc.gif'),
(181, 'Samoa', 'images/flags/f-ws.gif'),
(182, 'San Marino', 'images/flags/f-sm.gif'),
(183, 'Sao Tome and Principe', 'images/flags/f-st.gif'),
(184, 'Saudi Arabia', 'images/flags/f-sa.gif'),
(185, 'Senegal', 'images/flags/f-sn.gif'),
(186, 'Serbia', 'images/flags/f-rs.gif'),
(187, 'Seychelles', 'images/flags/f-sc.gif'),
(188, 'Sierra Leone', 'images/flags/f-sl.gif'),
(189, 'Singapore', 'images/flags/f-sg.gif'),
(190, 'Slovakia', 'images/flags/f-sk.gif'),
(191, 'Slovenia', 'images/flags/f-si.gif'),
(192, 'Solomon Islands', 'images/flags/f-sb.gif'),
(193, 'Somalia', 'images/flags/f-so.gif'),
(194, 'South Africa', 'images/flags/f-za.gif'),
(196, 'Sri Lanka', 'images/flags/f-lk.gif'),
(198, 'Sudan', 'images/flags/f-sd.gif'),
(199, 'Suriname', 'images/flags/f-sr.gif'),
(200, 'Swaziland', 'images/flags/f-sz.gif'),
(201, 'Switzerland', 'images/flags/f-ch.gif'),
(202, 'Syria', 'images/flags/f-sy.gif'),
(203, 'Taiwan', 'images/flags/f-tw.gif'),
(204, 'Tajikistan', 'images/flags/f-tj.gif'),
(205, 'Tanzania', 'images/flags/f-tz.gif'),
(206, 'Thailand', 'images/flags/f-th.gif'),
(207, 'Togo', 'images/flags/f-tg.gif'),
(208, 'Tonga', 'images/flags/f-to.gif'),
(209, 'Trinidad and Tobago', 'images/flags/f-tt.gif'),
(210, 'Tunisia', 'images/flags/f-tn.gif'),
(211, 'Turkey', 'images/flags/f-tr.gif'),
(212, 'Turkmenistan', 'images/flags/f-tm.gif'),
(213, 'Turks and Caicos Islands', 'images/flags/f-tc.gif'),
(214, 'Tuvalu', 'images/flags/f-tv.gif'),
(215, 'Uganda', 'images/flags/f-ug.gif'),
(216, 'Ukraine', 'images/flags/f-ua.gif'),
(217, 'United Arab Emirates', 'images/flags/f-ae.gif'),
(218, 'United States', 'images/flags/f-us.gif'),
(220, 'Uzbekistan', 'images/flags/f-uz.gif'),
(221, 'Vanuatu', 'images/flags/f-vu.gif'),
(222, 'Vatican City', 'images/flags/f-va.gif'),
(223, 'Venezuela', 'images/flags/f-ve.gif'),
(224, 'Vietnam', 'images/flags/f-vn.gif'),
(225, 'Yemen', 'images/flags/f-ye.gif'),
(226, 'Yugoslavia', 'images/flags/f-yu.gif'),
(227, 'Zambia', 'images/flags/f-zm.gif'),
(228, 'Zimbabwe', 'images/flags/f-zw.gif'),
(232, 'Ã…land Island', 'images/flags/f-ax.gif'),
(233, 'Angola', 'images/flags/f-ao.gif'),
(235, 'Bouvet Island', 'images/flags/f-bv.gif')";

dbquery($sql2);

Das Lernen ist wie ein Meer ohne Ufer. Konfuzius

Alles wird Gut!

KEIN Support per Mail, ICQ oder PN !
www.heiseclan.de/fusion/sig.gif

www.heiseclan.de/geosig.gif
 
turbo-opa
Danke funktioniert super

ps wäre super wenn das ganze mit erklärung auch noch zum dl profilfelder kontaktdaten zugefügt wird dann habens andere leichter.

gruß uwe
Bearbeitet von turbo-opa am 20.02.2010 00000002 13:32
radio-4fun.info/hg/banner9.gif
 
Springe ins Forum:
Datalus