Menu
What's new
By:
Filters

B??dy w Acc Makerze na stronie

L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Po pierwsze jak naprawi? takie b??dy :

1.
Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'erpegia.auction_system' doesn't exist' in /home/erpegia/www/auctionsystem.php:2 Stack trace: #0 /home/erpegia/www/auctionsystem.php(2): PDO->query('SELECT `auction...') #1 /home/erpegia/www/index.php(100): include('/home/erpegia/w...') #2 {main} thrown in /home/erpegia/www/auctionsystem.php on line 2

2.
Code: 
Warning: include(Map.php): failed to open stream: No such file or directory in /home/erpegia/www/index.php on line 244 Warning: include(): Failed opening 'Map.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /home/erpegia/www/index.php on line 244

To tyle prosz? o pomoc jak naprawi? te 2 b??dy.
 
jeztPolak

jeztPolak

Active User
Joined
Oct 11, 2010
Messages
132
Reaction score
18
Odp: B??dy w Acc Makerze na stronie

Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'erpegia.auction_system' doesn't exist' in /home/erpegia/www/auctionsystem.php:2 Stack trace: #0 /home/erpegia/www/auctionsystem.php(2): PDO->query('SELECT `auction...') #1 /home/erpegia/www/index.php(100): include('/home/erpegia/w...') #2 {main} thrown in /home/erpegia/www/auctionsystem.php on line 2
Je?li chodzi o ten b??d nie posiadasz tabeli w bazie danych o nazwie auction_system, czyli og?lnie nie powinne? mie? zainstalowanego systemu aukcji w grze. Jak to naprawi?? Musisz zainstalowa? odpowiedni system aukcji.​
 
L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Odp: B??dy w Acc Makerze na stronie

Dzi?ki wielkie pierwszy b??d ju? naprawiony, teraz tylko jeszcze pozosta? ten drugi.

Warning: include(Map.php): failed to open stream: No such file or directory in /home/erpegia/www/index.php on line 244 Warning: include(): Failed opening 'Map.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /home/erpegia/www/index.php on line 244
Click to expand...
 
jeztPolak

jeztPolak

Active User
Joined
Oct 11, 2010
Messages
132
Reaction score
18
Odp: B??dy w Acc Makerze na stronie

Wy?lij zawarto?? pliku /index.php, to powiem ci jak naprawi? taki b??d.​
 
L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Odp: B??dy w Acc Makerze na stronie

createObject('Account'); $account_logged->load($_SESSION['account']); if($account_logged->isLoaded() && $account_logged->getPassword() == $_SESSION['password']) { $logged = TRUE; $group_id_of_acc_logged = $account_logged->getPageAccess(); } else { $logged = FALSE; unset($_SESSION['account']); unset($account_logged); } } //login with data from form $login_account = strtoupper($_POST['account_login']); $login_password = trim($_POST['password_login']); if(!$logged && !empty($login_account) && !empty($login_password)) { $login_password = password_ency($login_password); $account_logged = $ots->createObject('Account'); $account_logged->find($login_account); if($account_logged->isLoaded()) { if($login_password == $account_logged->getPassword()) { $_SESSION['account'] = $account_logged->getId(); $_SESSION['password'] = $login_password; $logged = TRUE; $account_logged->setCustomField("page_lastday", time()); $group_id_of_acc_logged = $account_logged->getPageAccess(); } else $logged = FALSE; } } //#### LOAD PAGE ########## //load subtopic page if(empty($_REQUEST['subtopic'])) { $_REQUEST['subtopic'] = "latestnews"; $subtopic = "latestnews"; } switch($_REQUEST['subtopic']) { case "latestnews": $topic = "Latest News"; $subtopic = "latestnews"; include("latestnews.php"); break; case "creatures"; $topic = "Creatures"; $subtopic = "creatures"; include("creatures.php"); break; case "spells"; $topic = "Spells"; $subtopic = "spells"; include("spells.php"); break; case "experiencetable"; $topic = "Experience Table"; $subtopic = "experiencetable"; include("experiencetable.php"); break; case "characters"; $topic = "Characters"; $subtopic = "characters"; include("characters.php"); break; case "auctionsystem"; $topic = "Auctions"; $subtopic = "auctionsystem"; include("auctionsystem.php"); break; case "whoisonline"; $topic = "Who is online?"; $subtopic = "whoisonline"; include("whoisonline.php"); break; case "highscores"; $topic = "Highscores"; $subtopic = "highscores"; include("highscores.php"); break; case "killstatistics"; $topic = "Last Kills"; $subtopic = "killstatistics"; include("killstatistics.php"); break; case "houses"; $topic = "Houses"; $subtopic = "houses"; include("houses.php"); break; case "guilds"; $topic = "Guilds"; $subtopic = "guilds"; include("guilds.php"); break; case "accountmanagement"; $topic = "Account Management"; $subtopic = "accountmanagement"; include("accountmanagement.php"); break; case "createaccount"; $topic = "Create Account"; $subtopic = "createaccount"; include("createaccount.php"); break; case "lostaccount"; $topic = "Lost Account Interface"; $subtopic = "lostaccount"; include("lostaccount.php"); break; case "tibiarules"; $topic = "Server Rules"; $subtopic = "tibiarules"; include("tibiarules.php"); break; case "adminpanel": $topic = "Admin Panel"; $subtopic = "adminpanel"; include("adminpanel.php"); break; case "forum": $topic = "Forum"; $subtopic = "forum"; include("forum.php"); break; case "team"; $subtopic = "team"; $topic = "Gamemasters List"; include("team.php"); break; case "downloads"; $subtopic = "downloads"; $topic = "Downloads"; include("downloads.php"); break; case "serverinfo"; $subtopic = "serverinfo"; $topic = "Server Info"; include("serverinfo.php"); break; case "shopsystem"; $subtopic = "shopsystem"; $topic = "Shop System"; include("shopsystem.php"); break; case "buypoints"; $subtopic = "buypoints"; $topic = "Buy Points"; include("buypoints.php"); break; case "gallery"; $subtopic = "gallery"; $topic = "Gallery"; include("gallery.php"); break; case "namelock"; $subtopic = "namelock"; $topic = "Namelock Manager"; include("namelocks.php"); break; case "archive"; $subtopic = "archive"; $topic = "News Archives"; include("archive.php"); break; case "mail"; $subtopic = "mail"; $topic = "Mass emails sender"; include("mail.php"); break; case "shopadmin"; $subtopic = "shopadmin"; $topic = "Shop Admin"; include("shopadmin.php"); break; case "records"; $subtopic = "records"; $topic = "Players Online Records"; include("records.php"); break; case "paypal"; $subtopic = "paypal"; $topic = "PayPal"; include("paypal.php"); break; case "map"; $subtopic = "map"; $topic = "Map"; include("Map.php"); break; } //generate title of page if(empty($topic)) { $title = $GLOBALS['config']['server']["serverName"]." - OTS"; $main_content .= 'Invalid subtopic. Can\'t load page.'; } else { $title = $GLOBALS['config']['server']["serverName"]." - ".$topic; } //#####LAYOUT##### $layout_header = '"; include($layout_name."/layout.php"); ob_end_flush(); ?>
Click to expand...

To jest zawarto?? pliku index.php
 
Veliusek

Veliusek

Active User
Joined
Jul 31, 2008
Messages
124
Reaction score
7
Odp: B??dy w Acc Makerze na stronie

Stw?rz plik Map.php (mo?e by? pusty) w folderze z acc makerem.
 
L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Odp: B??dy w Acc Makerze na stronie

Magic said:
Aby link do tego skryptu by? widzialny w acc makerze musicie doda? jeszcze odpowiedni kod do layout.php, lecz on jest zale?ny od layoutu. Dla layoutu ala rl tibia wygl?da to tak:
PHP: 
<a href='?subtopic=housesauc'>
  <div id='submenu_createaccount' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
    <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
    <div id='ActiveSubmenuItemIcon_createaccount' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
    <div class='SubmenuitemLabel'>Houses Licitation</div>
    <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
  </div>
</a>
Dodajemy to pod tym:
PHP: 
<div id='community_Submenu' class='Submenu'>
<a href='?subtopic=characters'>
  <div id='submenu_characters' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
    <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
    <div id='ActiveSubmenuItemIcon_characters' class='ActiveSubmenuItemIcon' style='background-image:url(<?PHP echo $layout_name; ?>/images/menu/icon-activesubmenu.gif);'></div>
    <div class='SubmenuitemLabel'>Characters</div>
    <div class='RightChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
  </div>
</a>
Nast?pnie otwieramy folder z naszym otsem i przechodzimy do folderu talkactions i podmieniamy zawarto?? pliku leavehouse.lua na t?:
Code: 
function onSay(cid, words, param, channel)
	local house = getHouseFromPos(getCreaturePosition(cid))
	if(not house) then
		doPlayerSendCancel(cid, "You are not inside a house.")
		doSendMagicEffect(getCreaturePosition(cid), CONST_ME_POFF)
		return false
	end
	local owner = getHouseInfo(house).owner
	if(owner ~= getPlayerGUID(cid) and (owner ~= getPlayerGuildId(cid) or getPlayerGuildLevel(cid) ~= GUILDLEVEL_LEADER)) then
		doPlayerSendCancel(cid, "You are not the owner of this house.")
		doSendMagicEffect(getCreaturePosition(cid), CONST_ME_POFF)
		return false
	end
	setHouseOwner(house, 0)
	db.executeQuery("UPDATE houses SET time = 0 WHERE owner = "..owner.."")
	doSendMagicEffect(getCreaturePosition(cid), CONST_ME_MAGIC_BLUE)
	return false
end
Nast?pnie tworzymy nowy plik w tym samym folderze o nazwie housesauc.lua i uzupe?niamy go tym:
Code: 
function onSay(cid, words, param, channel)
local query_moneys = db.getResult("SELECT moneys FROM players WHERE id = "..getPlayerGUID(cid).." LIMIT 1")
local moneys = query_moneys:getDataInt("moneys")
if (param == "") then
      doPlayerPopupFYI(cid, "Uzycie:\n!house deposit, ilosc (wplaca dana ilosc na konto)\n!house withdraw (wyciaga pieniadze z konta)\n\nStan konta: "..moneys.." gold coins")
return TRUE
end
local param = string.explode(param, ",")
	if (param[1] == "deposit") then
		if (doPlayerRemoveMoney(cid, param[2])) then
			db.executeQuery("UPDATE players SET moneys = moneys + "..param[2].." WHERE id = "..getPlayerGUID(cid).." LIMIT 1")
			doPlayerSendTextMessage(cid, 20, "Dodales "..param[2].." gold coins do swojego konta.")
		else
			doPlayerSendTextMessage(cid, 20, "Masz zbyt malo pieniedzy.")
		end
	elseif (param[1] == "withdraw") then
		local query_houses = db.getResult("SELECT owner FROM houses WHERE id = (SELECT house_id FROM house_auctions WHERE player_id = "..getPlayerGUID(cid).." ORDER BY time DESC LIMIT 1) and time > 0")
		if query_houses:getID() == -1 then
			if (moneys > 0) then
				if (doPlayerAddMoney(cid, moneys)) then
					doPlayerSendTextMessage(cid, 20, "Wyciagnales "..moneys.." gold coins ze swojego konta.")
					db.executeQuery("UPDATE players SET moneys = 0 WHERE id = "..getPlayerGUID(cid).."")
					query_moneys:free()
				end
			else
				doPlayerSendTextMessage(cid, 20, "Nie masz srodkow na koncie.")
			end
		else
			doPlayerSendTextMessage(cid, 20, "Jestes w trakcie licytacji domku, nie mozesz wyplacic pieniedzy")
		end
	end
return TRUE
end
Do talkactions.xml dodajemy:
Code: 
<talkaction words="!house" hide="yes" event="script" value="housesauc.lua"/>
To ju? koniec! Mo?esz si? cieszy? nowym systemem
You do not have permission to view link please Log in or Register
You do not have permission to view link please Log in or Register
Click to expand...
Te pierwsze dwa kody m?g?by mi kto? umie?ci? dobrze w moim layout.php ??
Tutaj znajduje si? kod layout.php
You do not have permission to view link please Log in or Register
 
Last edited:
Veliusek

Veliusek

Active User
Joined
Jul 31, 2008
Messages
124
Reaction score
7
Odp: B??dy w Acc Makerze na stronie

To najpierw zapodaj tre?? tego layout.php xD
Znajdziesz go w themes/nazwatwojegotheme/
 
L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Odp: B??dy w Acc Makerze na stronie

Veliusek said:
To najpierw zapodaj tre?? tego layout.php xD
Znajdziesz go w themes/nazwatwojegotheme/
Click to expand...

Popatrz nad sw?j post tre?? jest w :

Code: 
Te pierwsze dwa kody m?g?by mi kto? umie?ci? dobrze w moim layout.php ??
Tutaj znajduje si? kod layout.php
http://wklej.org/id/406019/
 
Veliusek

Veliusek

Active User
Joined
Jul 31, 2008
Messages
124
Reaction score
7
Odp: B??dy w Acc Makerze na stronie

Faktycznie nie zauwa?y?em;d
Swoj? drog? dziwne;d
Ostatnio edytowane przez Licen : Dzisiaj o 19:14.
Click to expand...
Prosz? bardzo.
You do not have permission to view link please Log in or Register
 
L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Odp: B??dy w Acc Makerze na stronie

Dzi?ki wielkie, zrobi?em all wed?ug tego poradnika http://tibia.net.pl/php/371917-licytacja-domkow.html i mi si? nie wy?wietla na stronie ;/ wiesz o co mo?e chodzi??

O co chodzi z tym b??dem ??

Code: 
Deprecated: Function ereg() is deprecated in /home/erpegia/www/buypoints.php on line 108 Deprecated: Function ereg() is deprecated in /home/erpegia/www/buypoints.php on line 108 Deprecated: Function ereg() is deprecated in /home/erpegia/www/buypoints.php on line 108 Deprecated: Function ereg() is deprecated in /home/erpegia/www/buypoints.php on line 108
 
Last edited:
Veliusek

Veliusek

Active User
Joined
Jul 31, 2008
Messages
124
Reaction score
7
Odp: B??dy w Acc Makerze na stronie

Zbyt stara wersja php. Musisz mie? php5.
 
L

Licen

Active User
Joined
May 17, 2008
Messages
69
Reaction score
3
Age
43
Odp: B??dy w Acc Makerze na stronie

Jak za stara ?? Je?li sms shop dzia?a? dobrze wcze?niej ;/
 
You must log in or register to reply here.
Top