|
You last visited: Today at 06:12
Advertisement
[SERVICE] PHP Coding und Questing
Discussion on [SERVICE] PHP Coding und Questing within the Web Development forum part of the Coders Den category.
10/17/2010, 13:44
|
#16
|
elite*gold: 255 
Join Date: Jan 2010
Posts: 2,067
Received Thanks: 756
|
Quote:
Originally Posted by lolkid2009
Infis Api kann RELOAD nicht RELOAD A ^^
|
das gleich ;D
Reloaded halt dann gleich alles
^^
|
|
|
|
10/17/2010, 13:49
|
#17
|
elite*gold: 0
Join Date: Jul 2009
Posts: 2,471
Received Thanks: 5,622
|
Quote:
Originally Posted by .Zander
das gleich ;D
Reloaded halt dann gleich alles
^^
|
Ne, es lädt nicht alles neu^^
Nur die Proto Tabellen und Banword
Hier die Quest für IceCold
PHP Code:
quest the_spions begin
state start begin
when login with pc.get_level() >= 50 begin
setstate(info)
end
end
state info begin
when letter begin
send_letter("Die Spione: Information")
end
when info or button begin
say_title("Die Spione")
----"12345678901234567890123456789012345678901234567890"|
say("Hallo "..pc.get_name()..",")
say("wie wir erfahren haben, sind 50 Spione in unser")
say("Reich eingedrungen und haben geheime")
say("Informationen gestohlen. Diese Informationen ")
say("dürfen unter keinen Umständen, in die Hände")
say("einer unser Feinde fallen. Der Kaiser hat")
say("dich ausgewählt! Du hast die ehrenvolle")
say("Aufgabe die 50 Spione zu töten.")
say("")
syschat("Du hast den Brief gelesen und packst ihn wieder ein.")
pc.setqf("state", 0)
q.set_counter("Übrige Spione", 0)
setstate(mission)
end
end
state mission begin
when letter begin
send_letter("Die Spione: Mission")
end
when info or button begin
say_title("Die Spione")
say("")
say("Erfülle deinen Auftrag und töte die 50 Spione")
say("")
say_reward("Du musst noch 50 Spieler aus einem Fremden")
say_reward("Reich töten um die Aufgabe abzuschließen.")
end
when kill with npc.is_pc() and npc_is_same_empire() == false begin
local count = pc.getqf("state") + 1
if count <= 50 then
pc.setqf("state", count)
q.set_counter("Übrige Spione", 50 - count)
syschat("Töte noch "..count.." Spione.")
if count == 50 then
syschat("Du hast alle Spione beseitigt und deine Aufgabe erfüllt!")
say_title("Die Spione")
----"12345678901234567890123456789012345678901234567890"|
say("Du hast alle Spione erledigt und unser Reich")
say("gerettet. Der Kaiser hat dir dafür ein etwas")
say("hinterlassen.")
setstate(reward)
end
end
end
end
state reward begin
when info or login or button begin
syschat("Der König hat dir einen Brief hinterlassen.")
syschat("Du öffnest ihn und spürst ein unglaublich gutes")
syschat("Gefühl.")
pc.change_alignment(20000) -- 20.000 Rang Punkte
pc.give_exp_perc(10) -- 10 Prozent Erfahrung
end
end
end
|
|
|
|
|
10/17/2010, 13:52
|
#18
|
elite*gold: 15
Join Date: Feb 2010
Posts: 4,410
Received Thanks: 3,105
|
Och mensch loli das kannste doch nicht machen 
|
|
|
|
|
10/17/2010, 14:08
|
#19
|
elite*gold: 0
Join Date: Jul 2009
Posts: 2,471
Received Thanks: 5,622
|
Für die kostenlosen Sachen wär nen Thanks nice 
|
|
|
|
|
10/17/2010, 14:30
|
#20
|
elite*gold: 100
Join Date: Sep 2009
Posts: 8,143
Received Thanks: 2,763
|
Also Ranking Regi Player Count Char Count Guild Count ItemCount sind kostenlos oder ? , da es ja nur einfache sql abfragen sind 
Wen du nichts dagegen hast poste ich mal die Counter hier in den thread :
Kann ich dir vielleicht ein biscchen arbeit abnehmen
Charakter Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$chars = "SELECT * from player";
$charsquery = mysql_query($chars);
$charszahl = mysql_num_rows($charsquery);
echo "Charaktere : $charanzahl";
Account Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("account");
$accs = "SELECT * from account";
$accsquery = mysql_query($accs);
$accszahl = mysql_num_rows($accsquery);
echo "Account : $accszahl";
Item Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$items = "SELECT * FROM item ";
$itemsquery = mysql_query($items);
$itemanzahl = mysql_num_rows($itemsquery);
echo "Items : $itemanzahl";
Gilden Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$guilds ="SELECT * FROM guild";
$guildsquery = mysql_query($guilds);
$guildanzahl = mysql_num_rows ($guildsquery);
echo "Gilden : $guildanzahl";
Spieler online :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$output = mysql_query("SELECT COUNT(*) as count FROM player WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < last_play;");
$online_count = mysql_fetch_object($output)->count+1;
echo "Spieler Online : $online_count";
Ranking ohne GMs GAs :
PHP Code:
<?php
echo "<center>";
include('inc/config.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
$test = "SELECT * from player";
$testquery = mysql_query($test);
$num2 = mysql_num_rows($testquery);
if($_GET['max']) {
$get = $_GET['max'];
} else {
$get = '0';
$max = $get + 20;
$max2 = $get - 20;
if($get > $num2) {
}
elseif($get >= 20 && $get < $num2) { }
elseif ($num2 <= 20) { echo ""; }
else { }
echo "</center><br>";
?>
<center><table border="0">
<tr>
<th width="150">Platz</th>
<th width="150">Name</th>
<th width="150">Level</th>
<th width="150">Exp</th>
<th width="150">Reich</th>
</tr>
</table></center>
<?php
include('inc/config.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
// Select player etc from db //
$rank = "SELECT * from player WHERE name NOT LIKE '[GA]%' and name NOT LIKE '[GM]%' order by level desc limit 10";
$query = mysql_query($rank);
echo "<center><table border=\"0\">"; // Open table
$i = 0;
while($array = mysql_fetch_array($query)) {
$i = $i + 1;
echo "
<tr>
<th width=\"150\"><font color=\"black\">" . $i . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["name"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["level"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["exp"] . "</font></th>";
$reich = "SELECT empire from player_index where id = " . $array[account_id] . "";
$query2 = mysql_query($reich);
$array2 = mysql_fetch_array($query2);
if($array2["empire"] == 1) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/red.jpg\"></th></tr>";
} elseif($array2["empire"] == 2) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/yellow.jpg\"></th></tr>";
} else {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/blue.jpg\"></th></tr>";
}
}
echo "</table></center><br>"; // close table
}
?>
Ranking by Purusha
|
|
|
|
|
10/17/2010, 14:44
|
#21
|
elite*gold: 0
Join Date: Mar 2009
Posts: 114
Received Thanks: 13
|
Marcel nimmst du bitte meine Scripts da raus, danke.
|
|
|
|
|
10/17/2010, 14:47
|
#22
|
elite*gold: 100
Join Date: Sep 2009
Posts: 8,143
Received Thanks: 2,763
|
Quote:
Originally Posted by Purusha
Marcel nimmst du bitte meine Scripts da raus, danke.
|
Is nur das Regi script, das von dir ist.
|
|
|
|
|
10/17/2010, 14:48
|
#23
|
elite*gold: 0
Join Date: Mar 2009
Posts: 114
Received Thanks: 13
|
Okay, danke.
#geklärt
|
|
|
|
|
10/17/2010, 16:20
|
#24
|
elite*gold: 80
Join Date: Feb 2010
Posts: 4,407
Received Thanks: 2,857
|
Infi's Api bringt mir doch nichts wenn ich sie gefixxt habe. :>
|
|
|
|
|
10/17/2010, 22:57
|
#25
|
elite*gold: 0
Join Date: Jul 2009
Posts: 2,471
Received Thanks: 5,622
|
Quote:
Originally Posted by .0x1338_#
Also Ranking Regi Player Count Char Count Guild Count ItemCount sind kostenlos oder ? , da es ja nur einfache sql abfragen sind
Wen du nichts dagegen hast poste ich mal die Counter hier in den thread :
Kann ich dir vielleicht ein biscchen arbeit abnehmen
Charakter Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$chars = "SELECT * from player";
$charsquery = mysql_query($chars);
$charszahl = mysql_num_rows($charsquery);
echo "Charaktere : $charanzahl";
Account Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("account");
$accs = "SELECT * from account";
$accsquery = mysql_query($accs);
$accszahl = mysql_num_rows($accsquery);
echo "Account : $accszahl";
Item Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$items = "SELECT * FROM item ";
$itemsquery = mysql_query($items);
$itemanzahl = mysql_num_rows($itemsquery);
echo "Items : $itemanzahl";
Gilden Counter :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$guilds ="SELECT * FROM guild";
$guildsquery = mysql_query($guilds);
$guildanzahl = mysql_num_rows ($guildsquery);
echo "Gilden : $guildanzahl";
Spieler online :
PHP Code:
include("config.php");
mysql_connect($dbhost,$dbuser,$dbpass);
mysql_select_db("player");
$output = mysql_query("SELECT COUNT(*) as count FROM player WHERE DATE_SUB(NOW(), INTERVAL 5 MINUTE) < last_play;");
$online_count = mysql_fetch_object($output)->count+1;
echo "Spieler Online : $online_count";
Ranking ohne GMs GAs :
PHP Code:
<?php
echo "<center>";
include('inc/config.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
$test = "SELECT * from player";
$testquery = mysql_query($test);
$num2 = mysql_num_rows($testquery);
if($_GET['max']) {
$get = $_GET['max'];
} else {
$get = '0';
$max = $get + 20;
$max2 = $get - 20;
if($get > $num2) {
}
elseif($get >= 20 && $get < $num2) { }
elseif ($num2 <= 20) { echo ""; }
else { }
echo "</center><br>";
?>
<center><table border="0">
<tr>
<th width="150">Platz</th>
<th width="150">Name</th>
<th width="150">Level</th>
<th width="150">Exp</th>
<th width="150">Reich</th>
</tr>
</table></center>
<?php
include('inc/config.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
// Select player etc from db //
$rank = "SELECT * from player WHERE name NOT LIKE '[GA]%' and name NOT LIKE '[GM]%' order by level desc limit 10";
$query = mysql_query($rank);
echo "<center><table border=\"0\">"; // Open table
$i = 0;
while($array = mysql_fetch_array($query)) {
$i = $i + 1;
echo "
<tr>
<th width=\"150\"><font color=\"black\">" . $i . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["name"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["level"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $array["exp"] . "</font></th>";
$reich = "SELECT empire from player_index where id = " . $array[account_id] . "";
$query2 = mysql_query($reich);
$array2 = mysql_fetch_array($query2);
if($array2["empire"] == 1) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/red.jpg\"></th></tr>";
} elseif($array2["empire"] == 2) {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/yellow.jpg\"></th></tr>";
} else {
echo "<th width=\"150\"><img src=\"http://www.elitepvpers.com/forum/images/blue.jpg\"></th></tr>";
}
}
echo "</table></center><br>"; // close table
}
?>
Ranking by Purusha |
Naja, die Querys die du da hast sind einfach nur langsam. Dadurch lädt die HP langsamer man kann sie viel schneller machen. Außerdem werden viel zu viele Querys ausgeführt ...
@chin Doch^^
Der Fixx sieht ja so aus das du alle IPs außer maximal 3 IPs sperrst du kannst einfach deinen Webserver frei lassen aber trotzdem Infi's API hat kein RELOAD A es lädt nur Proto tabellen und Banword neu.
|
|
|
|
 |
|
Similar Threads
|
Looking for an Questing Buddy :)
06/19/2010 - Dekaron - 0 Replies
Hello i,am coming back to Dekaron after 5-6months or so. If you are just starting or making a new character, and you looking for something to play with and stuff, Add me to xfire or send me a message with your server/character. :)
Xfire: nateww
Thank You & Have a nice day :)
|
Questing about stacking bugs on 3.3.2 :)
03/05/2010 - World of Warcraft - 12 Replies
I found a video in youtube which can stack wrist ,waist ,weapons and all items and get additional spell power. Here is the video YouTube - WoW Private server spell / attack power hack, cheat, stacking 3.3.0a
First I`ve make it gray but i`ve got message such as "this item cannot stack" but on the same time i saw a pally which heal me over 40k and make 20k damage. I cant answer him because he got banned (despite the fact of being lame and get enormous stack) Could pls tell me what kind of items...
|
Questing in NA
06/14/2008 - Cabal Online - 1 Replies
for some reason in mercury for cabal NA
i cant turn in my quest...like it go to the corresponding npc and when i click on the last screen...nothing happens
anyone have any idea y? bug maybe?
i didnt do any of the quest and im lvl 50+ and now im trying to do them to get the port lux map piece
and the very first quest "something about a missing expedition"..and when i try to turn in nothing happens...
|
Questing Vs Botting
06/06/2008 - Cabal Online - 4 Replies
i have a question...since alot of stuff evolves around questing in this game
like getting combo lvl1
and people (like me) like to bot to have more free time
how would we be able to get the required quests done......(not trying to be lazy) but is there a site i can go to or anyone have the important quests that need to be done
like the combo level 1...i cant seem to be able to find combo lvl 2 since i bot and level quickly and have IRL stuff to do
|
Grinding oder Questing???
08/14/2005 - World of Warcraft - 3 Replies
text2schild.php?smilienummer=1&text=Ich weiß dumme Frage aber....' border='0' alt='Ich weiß dumme Frage aber....' />
So ich wollte das mal wissen weil ich beim Questen nicht besonders schnell weiter komme!
Und was ist Grinden überhaupt genau???
Outsh das gibt ärger :hm:
da es ne frage ist, verschiebe ich diesen thread mal ins main
|
All times are GMT +1. The time now is 06:12.
|
|
![[SERVICE] PHP Coding und Questing](https://www.elitepvpers.com/forum/iconimages/web-development/service-php-coding-und-questing_ltr.gif){kind=small}
