Jump to content
php.lv forumi

falck3

Reģistrētie lietotāji
  • Content Count

    59
  • Joined

  • Last visited

Posts posted by falck3

  1. Te ir sql kas dod man erroru!

    Saprotu ka tas varbūt ir dēļ manas sql versijas?

    ja tā tad kā labot šo sql?

    -- 
    -- Table structure for table `scraffiliateusr`
    -- 
    
    CREATE TABLE `scraffiliateusr` (
      `usrid` bigint(20) NOT NULL auto_increment,
      `usract` int(11) NOT NULL default '0',
      `usrnam` varchar(100) NOT NULL default '',
      `usrpwd` varchar(100) NOT NULL default '',
      `usractkey` varchar(100) NOT NULL default '',
      `usrip` varchar(100) NOT NULL default '',
      `usreml` varchar(100) NOT NULL default '',
      `usrjondtetme` datetime NOT NULL default '0000-00-00 00:00:00',
      `usrinvby` int(11) NOT NULL default '0',
      `usrlstvstdtetme` datetime NOT NULL default '0000-00-00 00:00:00',
      `usrvst` int(11) NOT NULL default '0',
      `usrvsttdy` int(11) NOT NULL default '0',
      `usrprflstvstdtetme` datetime NOT NULL default '0000-00-00 00:00:00',
      `usrprfvst` int(11) NOT NULL default '0',
      `usrprfvsttdy` int(11) NOT NULL default '0',
      `usrinvlstsnddtetme` datetime NOT NULL default '0000-00-00 00:00:00',
      `usrinvsnd` int(11) NOT NULL default '0',
      `usrinvsndtdy` int(11) NOT NULL default '0',
      `usrinvurllstclkdtetme` datetime NOT NULL default '0000-00-00 00:00:00',
      `usrinvurlclk` int(11) NOT NULL default '0',
      `usrinvurlclktdy` int(11) NOT NULL default '0',
      `usrinvsndmax` int(11) NOT NULL default '0',
      `usrpoints` float NOT NULL default '0',
      `usrpointsindirect` float NOT NULL default '0',
      `usr24` varchar(100) NOT NULL default '',
      `usr25` varchar(100) NOT NULL default '',
      `usr26` varchar(100) NOT NULL default '',
      `usr27` varchar(100) NOT NULL default '',
      PRIMARY KEY  (`usrid`)
    ) TYPE=MyISAM AUTO_INCREMENT=1 ;
    
    -- 
    -- Dumping data for table `scraffiliateusr`
    -- 
    
    INSERT INTO `scraffiliateusr` (`usrid`, `usract`, `usrnam`, `usrpwd`, `usractkey`, `usrip`, `usreml`, `usrjondtetme`, `usrinvby`, `usrlstvstdtetme`, `usrvst`, `usrvsttdy`, `usrprflstvstdtetme`, `usrprfvst`, `usrprfvsttdy`, `usrinvlstsnddtetme`, `usrinvsnd`, `usrinvsndtdy`, `usrinvurllstclkdtetme`, `usrinvurlclk`, `usrinvurlclktdy`, `usrinvsndmax`, `usrpoints`, `usrpointsindirect`, `usr24`, `usr25`, `usr26`, `usr27`) VALUES 
    (1001, 1, 'user', 'password', '', '', '', '0000-00-00 00:00:00', 0, '2008-02-24 19:05:46', 10, 11, '2008-02-24 07:40:54', 2, 1, '2008-02-24 19:06:09', 2, 1, '2008-02-24 17:40:27', 2, 1, 5, 20, 9, '', '', '', ''),
    (1002, 1, 'user2', 'password', '', '', '', '0000-00-00 00:00:00', 1001, '0000-00-00 00:00:00', 0, 0, '2008-02-24 19:05:58', 4, 8, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 2, 11, 0, '', '', '', ''),
    (1003, 1, 'user3', 'password', '', '', '', '0000-00-00 00:00:00', 1001, '0000-00-00 00:00:00', 0, 0, '2008-02-24 07:22:42', 1, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''),
    (1004, 1, 'user4', 'password', '', '', '', '0000-00-00 00:00:00', 1001, '0000-00-00 00:00:00', 0, 0, '2008-02-24 07:28:29', 1, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 3, 0, 0, '', '', '', ''),
    (1005, 1, 'user5', 'password', '', '', '', '0000-00-00 00:00:00', 1002, '0000-00-00 00:00:00', 0, 0, '2008-02-24 07:29:26', 1, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 4, 10, 0, '', '', '', ''),
    (1006, 1, 'user6', 'password', '', '', '', '0000-00-00 00:00:00', 1003, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''),
    (1007, 1, 'user7', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 1, 0, 0, '', '', '', ''),
    (1008, 1, 'user8', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, 0, '', '', '', ''),
    (1009, 1, 'user9', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 3, 0, 0, '', '', '', ''),
    (1010, 1, 'user10', 'password', '', '', '', '0000-00-00 00:00:00', 1004, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''),
    (1011, 1, 'user11', 'password', '', '', '', '0000-00-00 00:00:00', 1005, '0000-00-00 00:00:00', 0, 0, '2008-02-20 12:38:26', 0, 1, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 4, 10, 0, '', '', '', ''),
    (1012, 1, 'user12', 'password', '', '', '', '0000-00-00 00:00:00', 1005, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 5, 0, 0, '', '', '', ''),
    (1013, 1, 'user13', 'password', '', '', '', '0000-00-00 00:00:00', 1008, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 4, 0, 0, '', '', '', ''),
    (1014, 1, 'user14', 'password', '', '', '', '0000-00-00 00:00:00', 1009, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 3, 0, 0, '', '', '', ''),
    (1015, 1, 'user15', 'password', '', '', '', '0000-00-00 00:00:00', 1014, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', 0, 0, 2, 0, 0, '', '', '', '');
    
    
    
    
    
    
    
    
    
    
    
    
    
    -- --------------------------------------------------------
    
    --
    -- Table structure for table `scraffiliateurlclk`
    --
    
    CREATE TABLE IF NOT EXISTS `scraffiliateurlclk` (
      `urlclkid` bigint(20) NOT NULL auto_increment,
      `urlclkusrid` bigint(20) NOT NULL,
      `urlclkipaddress` varchar(50) NOT NULL,
      `urlclktmestmp` varchar(50) NOT NULL default '0',
      `urlclk4` varchar(50) NOT NULL,
      PRIMARY KEY  (`urlclkid`)
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
    
    --
    -- Dumping data for table `scraffiliateurlclk`
    --
    
    

    ERRORS:

     

    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM AUTO_INCREMENT=1' at line 35

  2. 
    Username	Referrals
    Admin	        2
    f1stptcupdate	9
    AIS01	        1
    elena075	12
    InternsLink	1
    viking88hp	7
    kelly998888	99 

    Ir tā man vaig lai tabulā "Referrals" (tas cipars ir kopējais skaits) skaitu veidotu no useriem kuru id ir lielāks kā 2114

     

     

  3.  

    Nenotestēju, bet WHERE būtu jāliek pirms ORDER BY. Visticamāk, ka šādi strādā:

     

    SELECT * FROM members
    WHERE `id`>2114
    ORDER BY `referrals` 

     

    Pamēģināju arī tā! Jā nau errors bet nekārto pēc `referrals` 

  4. Lietoju šo

     

    SELECT * FROM members
    ORDER BY `referrals` 
    WHERE `id`>2114
     
    Ir errors :
     
    #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id`>2114 LIMIT 0, 30' at line 3
     
     
     
    Doma parādīt sarakstu ar MEMBERS kuru `referrals` kuru `id` ir lielāks kā 2114
     
    bez ORDER BY `referrals` viss ir ok bet tā nesanāk
     
    ko daru nepareizi??
     
    Paldies
  5. $lang['txt'][$k] = utf8_encode($v);

    WTF? Kā tu tos datus glabā datubāzē, ka tev šitādi brīnumi jādara?

    Ne datubāzē bet .php

     

    $lang['txt']['lastpost'] = 'Last Post';

    $lang['txt']['newtopic'] = 'New Topic';

    $lang['txt']['back2topic'] = 'Back to Topic';

    $lang['txt']['topic'] = 'Topic';

    $lang['txt']['moveto'] = 'Move to';

    $lang['txt']['topictitle'] = 'Topic Title';

     

     

    Ja vairākas valodas tad $lang['txt']['topictitle' tūlkos pēc valodas

  6. Ir gan tava vaina.

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

    foreach($lang['txt'] as $k => $v){

        $lang['txt'][$k] = utf8_encode($v);

    }

     

     

    un xml faila ir

     

    <?xml version="1.0" encoding="UTF-8"?>

     

    home failā bija

     

    <meta charset="utf-8">

     

    Uzliku tavu versiju nekas nemainās!

  7. Sveiki

     

    man ir viena problēma un liekas ka pat ar mātes googles palīdzību man nesanāk to atrisināt

     

    Problēma ir :

     

    Man mājaslapā

     

    "Lietotāji Onlainā" rādās kā "Lietotâji Onlainâ"

     

    Kur varētu būt problēma?

     

    Paldies

  8. sveiki!

     

     

    vai ir iespejams ieelikt 1000 epastus datubaze uzreiz?

     

     

       man ir saraksts  

     

                                                                                                                                                                                                                                                          
    epasts@epasts.com

    epasts@epasts.com

    epasts@epasts.com

    epasts@epasts.com

    epasts@epasts.com

     

    ka lai dabunu visus sadus? ('  epasts@epasts.com   ');

  9. No kurienes nāk tā skaņa? :D Man parasti mājaslapas bez iemesla neskan...

     

     

    nu teoretiski atveru ciu saiu sava lapa caur iframe kodu

    tai lapa dazreiz ir video kas skan!

    doma ir paslep skanu ja iespejams!

    nezini nau tada koda?

  10. es atradu sitadu!

     

    bet kkas riktigi nestrada :(

     

    <pre class="alt2" dir="ltr" style=" margin: 0px; padding: 6px; border: 1px inset; width: 750px; height: 434px; text-align: left; overflow: auto"><HTML> <HEAD> <TITLE> Clicker Counter Thingamajig </TITLE></head><body><script type="text/javascript">var clicks = 0;function linkClick(){ document.getElementById('clicked').value = ++clicks;}document.write('<a href="#" onclick="linkClick()">Click Me!</a>');</script>You have clicked the link <input id="clicked" size="3" onfocus="this.blur();" value="0" > times. </BODY></HTML></pre>

  11. un kas man jamet ieksa tai .txt faila?un ka janorada cels uz vinu?

     

     

    Google Analytics.

     

    Ja pats gribi no nulles taisīt, datubāzi gan tev vajadzēs (protams, ar to jau uzreiz nevajag saprast SQL datubāzi). Tev to skaitu reāli kaut kur ir jāpieglabā. Vari izlēdzēties ar failu sistēmu, attiecīgi, - glabā to visu, piemēram, .txt failā uz paša servera. Uzsveru, ka tā var tikai **izlīdzēties**!

×
×
  • Create New...