1.12.7 i starsze - Diamenty MOD
szymon1051 - 11-10-2011, 18:09
Ze było by naliczane np po 30 dniach 14 %. A fajnie by było jak by w PA można było ustawić za ile dni ma naliczyć i ile procent.
Warmix - 11-10-2011, 18:27
szymon1051, chodzi Ci o to, że jak ktoś ma na swoim koncie 20 diamentów, to jeśli za 2 tygodnie będzie mieć te 20 diamentów o otrzyma do tej liczby 14% i w sumie będzie mieć: 22, 8. Tylko tak, z tym to może być różnie, bo muszą być liczby całkowite... i mogą pojawić się błędy...
KinGDooM - 11-10-2011, 18:43
Warmix, wiem że najpierw się robi w module ale nie umiem tego znaleźć... I nie robie aktualizacji tylko instaluje mod od nowa, wersje v2.3
tartut - 11-10-2011, 19:10
| Warmix napisał/a: | | szymon1051, chodzi Ci o to, że jak ktoś ma na swoim koncie 20 diamentów, to jeśli za 2 tygodnie będzie mieć te 20 diamentów o otrzyma do tej liczby 14% i w sumie będzie mieć: 22, 8. Tylko tak, z tym to może być różnie, bo muszą być liczby całkowite... i mogą pojawić się błędy... |
liczby zmiennoprzecinkowe można zaokrąglić floor() 
obliczanie ilości diamentów w banku liczone by było przez wzór (na matmę trzeba było chodzić  ) a potem co dziennie o północy trzeba obliczać kwotę czyli będzie potrzebny cron, albo przynajmniej psudo-cron 
Warmix, jeżeli nie zamierzasz pisać tej modyfikacji to pisz, bo ja mam chrapkę 
Warmix - 11-10-2011, 19:25
tartut, skoro chcesz, to pisz i tak na razie nie mam czasu...
piotrekziomek12 - 12-10-2011, 15:04
Warmix, Wciąż .. jak klikam już wyślij :
| Kod: | Could not insert data into users table
DEBUG MODE
INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_interests, user_from, user_sig, user_sig_bbcode_uid, user_sig_image, user_avatar, user_avatar_type,user_viewgifts, user_viewemail, user_viewaim, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_attachuserbar, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_gg, user_notify_pm, user_popup_pm, user_timezone, user_lang, user_custom_color, user_custom_rank, user_style, user_gender, allowpm,pokazujdiamenty, wylaczlisteonline, wylaczliste, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_ip, user_ip_login_check, user_active, user_actkey) VALUES (36, 'msmm', 1318428240, '1a1fbaf06112c55ab0151562a89b1c5a', 'manos@poczta.pl', '', '', '', '', '', '', '', '', '', 0,1, 1, 1, '', '', '', 1, 1, 1, , 1, 1, 0, 0, 1, 1, 1, 'polish', '', '', 4, '1', 1,1, 1, 1, 0, 1, '999999', '0', '4fb945cd', 1, 1, '')
Line : 902
File : usercp_register.php |
a przed rejestracją jeszcze jak wejdę zarejestruj się to na górze pojawia się:
| Kod: | Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newspane/public_html/includes/usercp_register.php on line 1477
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newspane/public_html/includes/usercp_register.php on line 1486 |
:
[ Dodano: 12-10-2011, 18:11 ]
Warmix, wiesz już coś ? Jak nie to powiedz mi w SQL który to kod do includes/usercp_register.php to ciekawe jak bym delte zrobił kodu czy by zadziałało.
[ Dodano: 12-10-2011, 20:33 ]
Skasowałem takie 2 linijki z błędem
| Kod: | Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newspane/public_html/includes/usercp_register.php on line 1477
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/newspane/public_html/includes/usercp_register.php on line 1486 |
już go nie ma myślę że coś zgubiłeś na temat includes/usercp_register.php
w innstal_mod.php myślę że jakieś zapytanie czy coś skubnełeś. zaraz sprawdzę co z twoim forum czy też masz taki bład
[ Dodano: 12-10-2011, 20:38 ]
u cb to wg nie można zobaczyć zarejestrować się itp . . licz się z błędami bo u cb też może być to samo co u mnie ( u nas)
Warmix - 12-10-2011, 21:21
piotrekziomek12, rzeczywiście brakuje kilku zapytań SQL, bo takie są prawdopodobnie tym spowodowane...
Spróbuj wykonać po kolei każde zapytanie, które jest kierowane do tabeli phpbb_users.
A ja sprawdzę instrukcję...
[ Dodano: 12-10-2011, 22:51 ]
Wersja 2.4
Zmiany:
- lekka zmiana, ponieważ nie można było wejść w formularz rejestracji
Jeśli instalowałeś wersję v2.3 pobierz plik Diamenty MOD v2.4 i zapoznaj się z plikiem "Aktualizacja z v2.3 do v2.4"
KrYssTeeK - 12-10-2011, 23:28
Nie żeby coś ale przy instalacji sql mam błąd;
| Kod: | Bład: Incorrect table name 'phpbb_diamenty_historia' ( '
SQL : CREATE TABLE `phpbb_diamenty_historia' ( `id` int(255) NOT NULL auto_increment, `user_id` int(255) default NULL, `data` varchar(255) collate utf8_unicode_ci default NULL, `kod` varchar(16) collate utf8_unicode_ci default NULL, `kwota` varchar(255) collate utf8_unicode_ci default NULL, `diamenty` int(255) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `kod` (`kod`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18
Bład: 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 ''phpbb_config' VALUES ('ostrzezenie','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('ostrzezenie','10')
Bład: 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 ''phpbb_config' VALUES ('vip','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('vip','25')
Bład: 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 ''phpbb_config' VALUES ('vip_id','3')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('vip_id','3')
Bład: 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 ''phpbb_config' VALUES ('svip','50')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('svip','50')
Bład: 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 ''phpbb_config' VALUES ('svip_id','5')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('svip_id','5')
Bład: 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 ''phpbb_config' VALUES ('zp','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('zp','25')
Bład: 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 ''phpbb_config' VALUES ('ukryjpoziomy','0')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('ukryjpoziomy','0')
Bład: 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 ''phpbb_config' VALUES ('poziom1','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom1','10')
Bład: 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 ''phpbb_config' VALUES ('poziom2','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom2','10')
Bład: 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 ''phpbb_config' VALUES ('poziom3','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom3','10')
Bład: 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 ''phpbb_config' VALUES ('poziom4','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom4','10')
Bład: 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 ''phpbb_config' VALUES ('poziom5','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom5','25')
Bład: 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 ''phpbb_config' VALUES ('poziom6','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom6','25')
Bład: 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 ''phpbb_config' VALUES ('poziom7','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom7','25')
Bład: 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 ''phpbb_config' VALUES ('poziom8','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom8','25')
Bład: 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 ''phpbb_config' VALUES ('poziom9','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom9','25')
Bład: 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 ''phpbb_config' VALUES ('poziom10','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom10','25')
Bład: 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 ''phpbb_config' VALUES ('poziom11','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom11','25')
Bład: 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 ''phpbb_config' VALUES ('poziom12','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom12','25')
Bład: 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 ''phpbb_config' VALUES ('poziom13','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom13','25')
Bład: 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 ''phpbb_config' VALUES ('poziom14','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom14','25')
Bład: 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 ''phpbb_config' VALUES ('poziom15','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom15','25')
Bład: 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 ''phpbb_config' VALUES ('poziom16','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom16','25')
Bład: 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 ''phpbb_config' VALUES ('poziom17','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom17','25')
Bład: 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 ''phpbb_config' VALUES ('poziom18','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom18','25')
Bład: 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 ''phpbb_config' VALUES ('poziom19','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom19','25')
Bład: 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 ''phpbb_config' VALUES ('poziom20','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom20','25')
Bład: 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 ''phpbb_config' VALUES ('poziom21','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom21','25')
Bład: 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 ''phpbb_config' VALUES ('poziom22','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom22','25')
Bład: 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 ''phpbb_config' VALUES ('poziom23','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom23','25')
Bład: 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 ''phpbb_config' VALUES ('poziom24','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom24','25')
Bład: 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 ''phpbb_config' VALUES ('poziom25','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('poziom25','25')
Bład: 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 ''phpbb_config' VALUES ('flood','5')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('flood','5')
Bład: 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 ''phpbb_config' VALUES ('sig_height','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sig_height','10')
Bład: 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 ''phpbb_config' VALUES ('sig_chars','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sig_chars','10')
Bład: 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 ''phpbb_config' VALUES ('sb_chars','50')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sb_chars','50')
Bład: 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 ''phpbb_config' VALUES ('flood2','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('flood2','10')
Bład: 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 ''phpbb_config' VALUES ('sig_height2','20')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sig_height2','20')
Bład: 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 ''phpbb_config' VALUES ('maxpochwal','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('maxpochwal','10')
Bład: 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 ''phpbb_config' VALUES ('sb_flood','5')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sb_flood','5')
Bład: 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 ''phpbb_config' VALUES ('max_ava','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('max_ava','10')
Bład: 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 ''phpbb_config' VALUES ('wyrozpost','40')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('wyrozpost','40')
Bład: 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 ''phpbb_config' VALUES ('nowynick','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('nowynick','25')
Bład: 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 ''phpbb_config' VALUES ('nowyemail','25')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('nowyemail','25')
Bład: 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 ''phpbb_config' VALUES ('max_pw','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('max_pw','10')
Bład: 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 ''phpbb_config' VALUES ('flood_post','2')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('flood_post','2')
Bład: 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 ''phpbb_config' VALUES ('pokazujdiamenty','1')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('pokazujdiamenty','1')
Bład: 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 ''phpbb_config' VALUES ('flood_pw','5')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('flood_pw','5')
Bład: 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 ''phpbb_config' VALUES ('sig_height3','30')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sig_height3','30')
Bład: 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 ''phpbb_config' VALUES ('sb_chars2','100')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sb_chars2','100')
Bład: 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 ''phpbb_config' VALUES ('max_ava2','20')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('max_ava2','20')
Bład: 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 ''phpbb_config' VALUES ('sig_chars3','200')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sig_chars3','200')
Bład: 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 ''phpbb_config' VALUES ('flood3','50')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('flood3','50')
Bład: 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 ''phpbb_config' VALUES ('sb_flood2','15')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('sb_flood2','15')
Bład: 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 ''phpbb_config' VALUES ('max_pw2','50')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('max_pw2','50')
Bład: 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 ''phpbb_config' VALUES ('flood_post2','24')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('flood_post2','24')
Bład: 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 ''phpbb_config' VALUES ('nowynickzezwol','1')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('nowynickzezwol','1')
Bład: 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 ''phpbb_config' VALUES ('nowyemailzezwol','1')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('nowyemailzezwol','1')
Bład: 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 ''phpbb_config' VALUES ('ildloteria','50')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('ildloteria','50')
Bład: 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 ''phpbb_config' VALUES ('kosztloteria','5')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('kosztloteria','5')
Bład: 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 ''phpbb_config' VALUES ('opisloteria','Zapisując sie, zostajesz dodany do listy u' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('opisloteria','Zapisując sie, zostajesz dodany do listy u?ytkowników, którzy mają szanse na wygranie diamentów.')
Bład: 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 ''phpbb_config' VALUES ('wlaczloteria','0')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('wlaczloteria','0')
Bład: 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 ''phpbb_config' VALUES ('dataloteria','4.10.2011')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('dataloteria','4.10.2011')
Bład: 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 ''phpbb_config' VALUES ('version_diam','2.3')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('version_diam','2.3')
Bład: 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 ''phpbb_config' VALUES ('tresc1','XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('tresc1','XX')
Bład: 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 ''phpbb_config' VALUES ('tresc2','XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('tresc2','XX')
Bład: 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 ''phpbb_config' VALUES ('tresc3','XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('tresc3','XX')
Bład: 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 ''phpbb_config' VALUES ('tresc4','XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('tresc4','XX')
Bład: 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 ''phpbb_config' VALUES ('numer1','XXX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('numer1','XXX')
Bład: 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 ''phpbb_config' VALUES ('numer2','XXX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('numer2','XXX')
Bład: 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 ''phpbb_config' VALUES ('numer3','XXX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('numer3','XXX')
Bład: 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 ''phpbb_config' VALUES ('numer4','XXX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('numer4','XXX')
Bład: 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 ''phpbb_config' VALUES ('koszt1','X')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('koszt1','X')
Bład: 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 ''phpbb_config' VALUES ('koszt2','X')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('koszt2','X')
Bład: 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 ''phpbb_config' VALUES ('koszt3','X')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('koszt3','X')
Bład: 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 ''phpbb_config' VALUES ('koszt4','X')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('koszt4','X')
Bład: 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 ''phpbb_config' VALUES ('vat1','X,XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('vat1','X,XX')
Bład: 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 ''phpbb_config' VALUES ('vat2','X,XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('vat2','X,XX')
Bład: 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 ''phpbb_config' VALUES ('vat3','X,XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('vat3','X,XX')
Bład: 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 ''phpbb_config' VALUES ('vat4','X,XX')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('vat4','X,XX')
Bład: 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 ''phpbb_config' VALUES ('diamenty1','10')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('diamenty1','10')
Bład: 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 ''phpbb_config' VALUES ('diamenty2','30')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('diamenty2','30')
Bład: 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 ''phpbb_config' VALUES ('diamenty3','70')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('diamenty3','70')
Bład: 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 ''phpbb_config' VALUES ('diamenty4','120')' at line 1
SQL : INSERT INTO 'phpbb_config' VALUES ('diamenty4','120')
Bład: 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 ''phpbb_config' SET config_value = CONCAT(config_value, '1') WHERE config_name = ' at line 1
SQL : UPDATE 'phpbb_config' SET config_value = CONCAT(config_value, '1') WHERE config_name = 'promoted_users' |
Po za tym po wejściu w /diamenty.php jest next błąd;
| Kod: | Error while querying database
DEBUG MODE
SQL Error : 1146 Table 'fejsbuuk_crazy.phpbb_diamenty_historia' doesn't exist
SELECT SUM(diamenty) AS `user_id` FROM phpbb_diamenty_historia WHERE user_id='2'
Line : 504
File : diamenty.php |
W temacie;
| Kod: | Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'p.post_wyroznij' in 'field list'
SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_wyroznij, p.post_plusp, p.post_minusp, p.post_parent, p.post_icon, p.post_attachment, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.user_avatar_width, u.user_avatar_height, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, u.user_banedd, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, u.user_diamenty, u.user_poziom, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 67 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15
Line : 874
File : viewtopic.php |
P.S.
Zainstalowałem 2.4 wersję
Jakiś pomysł ocb ? ;>
japi55 - 13-10-2011, 04:49
Masz inny prefiks tabel.
KrYssTeeK - 13-10-2011, 06:32
Na pewno mam "phpbb_" gdyż wcześniej zainstalowałem 3 modyfikacje bez problemu..
Dekke - 13-10-2011, 13:49
| KrYssTeeK napisał/a: | | Na pewno mam "phpbb_" gdyż wcześniej zainstalowałem 3 modyfikacje bez problemu.. |
phpMyAdmin -> Tabela forum i zrób screenshota.
KrYssTeeK - 13-10-2011, 14:01
masz..
http://imageshack.us/f/571/bladuz.png/
Warmix - 13-10-2011, 14:52
KrYssTeeK, spróbuj wykonać ręcznie zapytania...
| Kod: | CREATE TABLE phpbb_diamenty_kody (
`id` int(11) NOT NULL auto_increment,
`user_id` MEDIUMINT(10) DEFAULT '0' NOT NULL,
`data` INT(11) NOT NULL DEFAULT '0',
`kod` varchar(16) default NULL,
`uzyty` INT(1) NOT NULL DEFAULT '0',
`typ` VARCHAR(26) DEFAULT '' NOT NULL,
`diamenty` int(255) default NULL,
PRIMARY KEY (`id`)
);
CREATE TABLE phpbb_diamenty_hostria (
`id` int(255) NOT NULL auto_increment,
`user_id` int(255) default NULL,
`data` varchar(255) collate utf8_unicode_ci default NULL,
`kod` varchar(16) collate utf8_unicode_ci default NULL,
`kwota` varchar(255) collate utf8_unicode_ci default NULL,
`diamenty` int(255) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `kod` (`kod`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=18;
CREATE TABLE phpbb_diamenty_przywileje (
`id` int(11) NOT NULL auto_increment,
`user_id` int(25) NOT NULL,
`data` varchar(255) collate utf8_unicode_ci NOT NULL,
`nazwa` varchar(255) collate utf8_unicode_ci NOT NULL,
`diamenty` int(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12;
CREATE TABLE phpbb_loteria (
`id` int(11) NOT NULL auto_increment,
`id_user` int(25) NOT NULL,
`username` varchar(255) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12;
CREATE TABLE phpbb_loteria_wynik(
`id` int(11) NOT NULL auto_increment,
`user_id` int(25) NOT NULL,
`username` varchar(255) collate utf8_unicode_ci NOT NULL,
`diamenty` int(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=12;
ALTER TABLE phpbb_users ADD `user_diamenty` INT(18) DEFAULT '0';
ALTER TABLE phpbb_users ADD `user_poziom` INT(18) DEFAULT '0';
INSERT INTO phpbb_config VALUES ('ostrzezenie','10');
INSERT INTO phpbb_config VALUES ('vip','25');
INSERT INTO phpbb_config VALUES ('vip_id','3');
INSERT INTO phpbb_config VALUES ('svip','50');
INSERT INTO phpbb_config VALUES ('svip_id','5');
INSERT INTO phpbb_config VALUES ('zp','25');
INSERT INTO phpbb_config VALUES ('ukryjpoziomy','0');
INSERT INTO phpbb_config VALUES ('poziom1','10');
INSERT INTO phpbb_config VALUES ('poziom2','10');
INSERT INTO phpbb_config VALUES ('poziom3','10');
INSERT INTO phpbb_config VALUES ('poziom4','10');
INSERT INTO phpbb_config VALUES ('poziom5','25');
INSERT INTO phpbb_config VALUES ('poziom6','25');
INSERT INTO phpbb_config VALUES ('poziom7','25');
INSERT INTO phpbb_config VALUES ('poziom8','25');
INSERT INTO phpbb_config VALUES ('poziom9','25');
INSERT INTO phpbb_config VALUES ('poziom10','25');
INSERT INTO phpbb_config VALUES ('poziom11','25');
INSERT INTO phpbb_config VALUES ('poziom12','25');
INSERT INTO phpbb_config VALUES ('poziom13','25');
INSERT INTO phpbb_config VALUES ('poziom14','25');
INSERT INTO phpbb_config VALUES ('poziom15','25');
INSERT INTO phpbb_config VALUES ('poziom16','25');
INSERT INTO phpbb_config VALUES ('poziom17','25');
INSERT INTO phpbb_config VALUES ('poziom18','25');
INSERT INTO phpbb_config VALUES ('poziom19','25');
INSERT INTO phpbb_config VALUES ('poziom20','25');
INSERT INTO phpbb_config VALUES ('poziom21','25');
INSERT INTO phpbb_config VALUES ('poziom22','25');
INSERT INTO phpbb_config VALUES ('poziom23','25');
INSERT INTO phpbb_config VALUES ('poziom24','25');
INSERT INTO phpbb_config VALUES ('poziom25','25');
INSERT INTO phpbb_config VALUES ('flood','5');
INSERT INTO phpbb_config VALUES ('sig_height','10');
INSERT INTO phpbb_config VALUES ('sig_chars','10');
INSERT INTO phpbb_config VALUES ('sb_chars','50');
INSERT INTO phpbb_config VALUES ('flood2','10');
INSERT INTO phpbb_config VALUES ('sig_height2','20');
INSERT INTO phpbb_config VALUES ('maxpochwal','10');
INSERT INTO phpbb_config VALUES ('sb_flood','5');
INSERT INTO phpbb_config VALUES ('max_ava','10');
INSERT INTO phpbb_config VALUES ('wyrozpost','40');
INSERT INTO phpbb_config VALUES ('nowynick','25');
INSERT INTO phpbb_config VALUES ('nowyemail','25');
INSERT INTO phpbb_config VALUES ('max_pw','10');
INSERT INTO phpbb_config VALUES ('flood_post','2');
INSERT INTO phpbb_config VALUES ('pokazujdiamenty','1');
INSERT INTO phpbb_config VALUES ('flood_pw','5');
INSERT INTO phpbb_config VALUES ('sig_height3','30');
INSERT INTO phpbb_config VALUES ('sb_chars2','100');
INSERT INTO phpbb_config VALUES ('max_ava2','20');
INSERT INTO phpbb_config VALUES ('sig_chars3','200');
INSERT INTO phpbb_config VALUES ('flood3','50');
INSERT INTO phpbb_config VALUES ('sb_flood2','15');
INSERT INTO phpbb_config VALUES ('max_pw2','50');
INSERT INTO phpbb_config VALUES ('flood_post2','24');
INSERT INTO phpbb_config VALUES ('nowynickzezwol','1');
INSERT INTO phpbb_config VALUES ('nowyemailzezwol','1');
INSERT INTO phpbb_config VALUES ('ildloteria','50');
INSERT INTO phpbb_config VALUES ('kosztloteria','5');
INSERT INTO phpbb_config VALUES ('opisloteria','Zapisuj±c sie, zostajesz dodany do listy u?ytkowników, którzy maj± szanse na wygranie diamentów.');
INSERT INTO phpbb_config VALUES ('wlaczloteria','0');
INSERT INTO phpbb_config VALUES ('dataloteria','4.10.2011');
INSERT INTO phpbb_config VALUES ('version_diam','2.4');
ALTER TABLE phpbb_users ADD `user_flood` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sig_height` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sig_chars` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sb_chars` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `user_flood2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sig_height2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `max_pochwal` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sb_flood` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `max_ava` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `max_pw` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `flood_post` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `pokazujdiamenty` TINYINT(1) NULL DEFAULT 1;
ALTER TABLE phpbb_users ADD `flood_pw` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sig_height3` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sb_chars2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `max_ava2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sig_chars3` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `user_flood3` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `sb_flood2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `ukryjsie` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `max_pw2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `flood_post2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `ukryj_liste` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `wylaczlisteonline` TINYINT(1) NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `ukryj_liste2` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `wylaczliste` TINYINT(1) NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `wyroznieniepostu` INT(8) NOT NULL DEFAULT 0;
ALTER TABLE phpbb_users ADD `post_wyroznij` ENUM('no', 'yes') DEFAULT 'no';
INSERT INTO phpbb_config VALUES ('tresc1','XX');
INSERT INTO phpbb_config VALUES ('tresc2','XX');
INSERT INTO phpbb_config VALUES ('tresc3','XX');
INSERT INTO phpbb_config VALUES ('tresc4','XX');
INSERT INTO phpbb_config VALUES ('numer1','XXX');
INSERT INTO phpbb_config VALUES ('numer2','XXX');
INSERT INTO phpbb_config VALUES ('numer3','XXX');
INSERT INTO phpbb_config VALUES ('numer4','XXX');
INSERT INTO phpbb_config VALUES ('koszt1','X');
INSERT INTO phpbb_config VALUES ('koszt2','X');
INSERT INTO phpbb_config VALUES ('koszt3','X');
INSERT INTO phpbb_config VALUES ('koszt4','X');
INSERT INTO phpbb_config VALUES ('vat1','X,XX');
INSERT INTO phpbb_config VALUES ('vat2','X,XX');
INSERT INTO phpbb_config VALUES ('vat3','X,XX');
INSERT INTO phpbb_config VALUES ('vat4','X,XX');
INSERT INTO phpbb_config VALUES ('diamenty1','10');
INSERT INTO phpbb_config VALUES ('diamenty2','30');
INSERT INTO phpbb_config VALUES ('diamenty3','70');
INSERT INTO phpbb_config VALUES ('diamenty4','120');
UPDATE phpbb_config SET config_value = CONCAT(config_value, '1') WHERE config_name = 'promoted_users'; |
A błędy wynikają z braku wykonania zapytań...
[ Dodano: 13-10-2011, 16:03 ]
Zastanawia mnie tylko ten błąd:
| Kod: | | 'fejsbuuk_crazy.phpbb_diamenty_historia' |
KrYssTeeK - 13-10-2011, 15:24
Po wywaleniu tamtych resztek zapytań które się zrobiły, puściłem te zapytania i oto efekt;
| Kod: | Error while querying database
DEBUG MODE
SQL Error : 1146 Table 'fejsbuuk_crazy.phpbb_diamenty_historia' doesn't exist
SELECT SUM(diamenty) AS `user_id` FROM phpbb_diamenty_historia WHERE user_id='2'
Line : 504
File : diamenty.php |
| Kod: | Could not obtain post/user information.
DEBUG MODE
SQL Error : 1054 Unknown column 'p.post_wyroznij' in 'field list'
SELECT p.post_id, p.post_time, p.enable_sig, p.enable_html, p.enable_smilies, p.post_edit_count, p.post_edit_time, p.post_username, p.post_approve, p.poster_delete, p.post_edit_by, p.post_wyroznij, p.post_plusp, p.post_minusp, p.post_parent, p.post_icon, p.post_attachment, u.user_sig_image, u.user_birthday, u.user_from, u.user_regdate, u.user_gender, u.user_aim, u.user_viewaim, u.user_avatar_width, u.user_avatar_height, u.user_id, u.username, u.user_level, u.user_jr, u.user_allowhtml, u.user_posts, u.user_allowsig, u.user_sig, u.user_sig_bbcode_uid, u.user_allowsmile, u.user_plusp, u.user_minusp, u.user_disallowed_write, u.user_banedd, u.user_avatar_type, u.user_allowavatar, u.user_avatar, u.user_rank, u.user_viewemail, u.user_website, u.user_email, u.can_custom_ranks, u.user_custom_rank, u.user_session_time, u.user_allow_viewonline, u.user_diamenty, u.user_poziom, pt.post_text, pt.bbcode_uid, pt.post_subject , ph.th_post_id FROM phpbb_posts p LEFT JOIN phpbb_posts_text_history ph ON (ph.th_post_id = p.post_id) LEFT JOIN phpbb_posts_text pt ON (pt.post_id = p.post_id) LEFT JOIN phpbb_users u ON (u.user_id = p.poster_id) WHERE p.topic_id = 68 GROUP by p.post_id ORDER BY p.post_order, p.post_time ASC LIMIT 0, 15
Line : 874
File : viewtopic.php |
EDIT@:
Taka mnie myśl naszła, zamiast; | Kod: | | CREATE TABLE phpbb_diamenty_hostria |
nie powinno być | Kod: | | CREATE TABLE phpbb_diamenty_historia |
? bo z tego co widzę to szuka tabelki historia ;>
// z tym miałem rację, działa już
Lecz w viewtopic.php dalej błąd mam ;/
japi55 - 13-10-2011, 16:32
KrYssTeeK, wykonaj resztę zapytań.
|
|
|
