Jump to content
php.lv forumi

falck3

Reģistrētie lietotāji
  • Posts

    59
  • Joined

  • Last visited

Everything posted by falck3

  1. Atradu problēmu ) ENGINE = MYISAM AUTO_INCREMENT =1; jābūt Bija ) TYPE = MYISAM AUTO_INCREMENT =1; Viss dēļ tā ka MySQL 5.1 vairs nelieto "TYPE"
  2. 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
  3. falck3

    palīdziet

    Varbūt zini kā izvilkt no referrals referāļus kas pievienojās pēdējās 30 dienās? ir colona signup signup int(11) No None
  4. falck3

    palīdziet

    ir int(11) tas slikti?
  5. falck3

    palīdziet

    Paskaidrosi sīkāk?
  6. falck3

    palīdziet

    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
  7. falck3

    palīdziet

    jo būs tāds kā pasākums kurā tiks skaitīti tikai id > ka 2114
  8. falck3

    palīdziet

    kā lai order by referrals bet rādītu tam referrals tos id kas ir tie pēc 2114?
  9. falck3

    palīdziet

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

    palīdziet

    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
  11. 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
  12. 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!
  13. Varbūt mana vaina ka nepieminēju ka runa iet par mājaslapu :D
  14. 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
  15. sveiki! vai ir iespejams ieelikt 1000 epastus datubaze uzreiz? man ir saraksts [email protected] [email protected] [email protected] [email protected] [email protected] ka lai dabunu visus sadus? (' [email protected] ');
  16. Sveiki PHP! Man ir viens jautajums! vai ir iespejams savienot telefona simkarti ar datubazi?
  17. man ir problema ka lan nebaltcom mani neredz onlaina!vini saka ka sis 169 norada uz kkadu probleu iekartaa(respektivi datora) !kas si ir par problemu?
  18. ok es o nokartoju nx par meginajumu :D
  19. citu saitu es domaju! ja kads atver manu lapu tad paraleli atveras velviena!bet neviens to neredz! gribu lai ari nedzird ;)
  20. 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?
  21. sveiki! vai ir iespejams ar kadu kodu paslept skanu majaslapa? paldies!
  22. var kads pateikt ko nozime sis errors? Parse error: syntax error, unexpected $end in /home/fumeeptc/public_html/members/onlinemem.php on line 30
  23. 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>
  24. un kas man jamet ieksa tai .txt faila?un ka janorada cels uz vinu?
×
×
  • Create New...