falck3

July 17, 2015

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"

July 17, 2015

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

March 22, 2015

Nē, tas pareizi.

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

March 22, 2015

Kāds ir kolonnas tips referālim? Minu, kas teksts, nevis integers :)

ir int(11)

tas slikti?

March 22, 2015

pieliec sortēšanas virzienu.

Paskaidrosi sīkāk?

March 22, 2015


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

March 22, 2015

Kāpēc vispār tāds nesmuks nosacījums - ID pēc 2114?

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

March 21, 2015

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

March 21, 2015

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`

March 21, 2015

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

February 23, 2014

$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

February 23, 2014

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

Uzliku tavu versiju nekas nemainās!

February 23, 2014

Varbūt mana vaina ka nepieminēju ka runa iet par mājaslapu :D

February 23, 2014

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

March 22, 2013

kas ir vim?

March 22, 2013

sveiki!

vai ir iespejams ieelikt 1000 epastus datubaze uzreiz?

man ir saraksts

[email protected]

ka lai dabunu visus sadus? (' [email protected] ');

January 11, 2013

Sveiki PHP!

Man ir viens jautajums!

vai ir iespejams savienot telefona simkarti ar datubazi?

July 20, 2012

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?

May 13, 2012

kas ir ciu saiu?

ok es o nokartoju nx par meginajumu :D

May 13, 2012

kas ir ciu saiu?

citu saitu es domaju!

ja kads atver manu lapu tad paraleli atveras velviena!bet neviens to neredz!

gribu lai ari nedzird ;)

May 13, 2012

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?

May 13, 2012

sveiki!

vai ir iespejams ar kadu kodu paslept skanu majaslapa?

paldies!

February 6, 2012

var kads pateikt ko nozime sis errors?

Parse error: syntax error, unexpected $end in /home/fumeeptc/public_html/members/onlinemem.php on line 30

January 24, 2012

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>

January 24, 2012

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**!

Sign In

falck3

Posts

Joined

Last visited

Content Type

Profiles

Forums

Posts posted by falck3

kas par problēmu mysql

kas par problēmu mysql

palīdziet

palīdziet

palīdziet

palīdziet

palīdziet

palīdziet

palīdziet

palīdziet

Problēma ar Garumzīmēm

Problēma ar Garumzīmēm

Problēma ar Garumzīmēm

Problēma ar Garumzīmēm

ka var izdarit?

ka var izdarit?

vai ir iespejams?

kas ir ar to ip 169.254?

skana we lapa

skana we lapa

skana we lapa

skana we lapa

sveiki visi

vajag lapu kliksku statistiku!

vajag lapu kliksku statistiku!

Browse

Activity