PHP-Fusion Mods - Diskusijų forumas: Negauna pilno prefix'o

Peržiūrėti temą

PHP-Fusion Mods :: PHP-Fusion modifikacijų forumas :: Taisymas

Negauna pilno prefix'o
lolitux	#1 parašyta 2011-12-18 13:38
Naujokas Reputacija: 0 Pranešimai: 3 Įstojo: 2008-08-26	Turiu kod� : GeSHi: PHP openside("Siuntini� kategorijos"); $result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE ".groupaccess('download_cat_access')." ORDER BY download_cat_name"); $rows = dbrows($result); if ($rows != 0) { $counter = 0; $columns = 2; while ($data = dbarray($result)) { if ($counter != 0 && ($counter % $columns == 0)) echo ""; $num = dbcount("(download_cat)", "downloads", "download_cat='".$data['download_cat_id']."'"); echo "<img src='http://eizo0x.xz.lt/images/failas.gif'> <a style='color:#FFF;' href='".BASEDIR."downloads.php?cat_id=".$data['download_cat_id']."'>".$data['download_cat_name']."</a> <span class='small2'>($num)</span>"; echo "" ; $counter++; } echo ""; $result = dbquery("SELECT count(download_id) FROM ".$db_prefix."downloads"); echo "<img src='".THEME."images/bullet.gif'> Siuntini�: [".dbresult($result, 0)."]"; $result = dbquery("SELECT SUM(download_count) FROM ".$db_prefix."downloads"); echo "<img src='".THEME."images/bullet.gif'> Atsisi�sta: [".dbresult($result, 0)."]"; } else { echo "<center>\nŠiai panelei nėra turinio</center>\n"; } closeside(); Parsed in 0.025 seconds, using GeSHi 1.0.8.10 Klaid� gauno toki� : Table 'fusion.downloads' doesn't exist Table 'fusion.downloads' doesn't exist bet pas mane ne fusion.downloads o fusion3iq22_downloads, galit i?taisyt? :D
	PM

Exceptio	#2 parašyta 2011-12-18 13:39
Administratorius Reputacija: 0 Pranešimai: 438 Įstojo: 2008-11-10	Kuri versija pas tave?
	PM

tabux	#3 parašyta 2011-12-18 16:39
S.Administratorius Reputacija: 0 Pranešimai: 1009 Įstojo: 2008-10-16	cia phpfusion v.6 kodas, tu tikriausiai ji dedi i phpfusion 7, phpfusion v.7 dbcount() funkcija jau kitokia sintakse, reikia taip pat nurodyti prefixa, arba naudoti apibrezta konstanta, butu taip: Code openside(\"Siuntini� kategorijos\"); $result = dbquery(\"SELECT * FROM \".$db_prefix.\"download_cats WHERE \".groupaccess('download_cat_access').\" ORDER BY download_cat_name\"); $rows = dbrows($result); if ($rows != 0) { $counter = 0; $columns = 2; while ($data = dbarray($result)) { if ($counter != 0 && ($counter % $columns == 0)) echo \"\"; $num = dbcount(\"(download_cat)\", \".DB_DOWNLOADS.\", \"download_cat='\".$data['download_cat_id'].\"'\"); echo \" \".$data['download_cat_name'].\" ($num)\"; echo \" \" ; $counter++; } echo \" \"; $result = dbquery(\"SELECT count(download_id) FROM \".$db_prefix.\"downloads\"); echo \" Siuntini�: [\".dbresult($result, 0).\"] \"; $result = dbquery(\"SELECT SUM(download_count) FROM \".$db_prefix.\"downloads\"); echo \" Atsisi�sta: [\".dbresult($result, 0).\"] \"; } else { echo \" \nŠiai panelei nėra turinio \n\"; } closeside();
	PM

lolitux	#4 parašyta 2011-12-18 19:10
Naujokas Reputacija: 0 Pranešimai: 3 Įstojo: 2008-08-26	Gaunu ?i� klaid�: 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 download_cat='1'' at line 1
	PM

Wyciokazz	#5 parašyta 2011-12-18 20:00
Administratorius Reputacija: 1 Pranešimai: 2108 Įstojo: 2008-02-27	Code openside(\"Siuntini� kategorijos\"); $result = dbquery(\"SELECT * FROM \".$db_prefix.\"download_cats WHERE \".groupaccess('download_cat_access').\" ORDER BY download_cat_name\"); $rows = dbrows($result); if ($rows != 0) { $counter = 0; $columns = 2; while ($data = dbarray($result)) { if ($counter != 0 && ($counter % $columns == 0)) echo \"\"; $num = dbcount(\"(download_cat)\", DB_DOWNLOADS, \"download_cat='\".$data['download_cat_id'].\"'\"); echo \" \".$data['download_cat_name'].\" ($num)\"; echo \" \" ; $counter++; } echo \" \"; $result = dbquery(\"SELECT count(download_id) FROM \".$db_prefix.\"downloads\"); echo \" Siuntini�: [\".dbresult($result, 0).\"] \"; $result = dbquery(\"SELECT SUM(download_count) FROM \".$db_prefix.\"downloads\"); echo \" Atsisi�sta: [\".dbresult($result, 0).\"] \"; } else { echo \" \nŠiai panelei nėra turinio \n\"; } closeside(); Redagavo Wyciokazz 2011-12-18 20:00 Kam kurti tai kas jau sukurta. Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda. [img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
	PM

lolitux	#6 parašyta 2011-12-18 20:13
Naujokas Reputacija: 0 Pranešimai: 3 Įstojo: 2008-08-26	A�i� :)
	PM

Peršokti į forumą:

tabux	15:34:09
sanper	nepamenu
Zbigniew@	nepamenu
CepelinasX	nepamenu
VV91DD	nepamenu
Minus	nepamenu
priezilviciu	nepamenu
EdvinasG1337	nepamenu
rolandas94	nepamenu
Edis2	nepamenu
klubogerbejas	nepamenu
Miskinis	nepamenu

	Neleista registracija: 38943
	Šiandien: 20