Скрипт саппорта

Sanasol · 16 августа, 2011

Вопрос задают НПЦу. Отвечает админ через админку на сайте.

1. NPC:

prontera,164,167,5	script	Support service	89,{

mes "Hi, I can answer any question!";
mes "Enter your question and within days you will necessarily answer.";
switch(select("Ask a question","^FF0000Show Answer^000000","Cancel")){
case 1:
next;
mes "Enter your question";
input .@question$;
if(.@question$=="") { mes "You must enter a question"; close; 
} else { 
query_sql("INSERT INTO `questions` (`account_id`, `question`, `read`) VALUES ('"+getcharid(3)+"', '"+.@question$+"', '0')");
next;
mes "Question posted!";
mes "Come back later and select the menu item 'Show Answer '";
close;
}
break;

case 2:
query_sql("select id,question from `questions` where `account_id`='"+getcharid(3)+"' and `read`='1' order by `id` desc", @id, @question$);
if (@id[0] == 0) { next; mes "Your question is not answered or you did not ask the question"; close; } else {
mes "Your questions:";
mes @id[0]+" "+@question$[0];
if (@id[1] != 0){mes @id[1]+" "+@question$[1];}
if (@id[2] != 0){mes @id[2]+" "+@question$[2];}
if (@id[3] != 0){mes @id[3]+" "+@question$[3];}
if (@id[4] != 0){mes @id[4]+" "+@question$[4];}
next;
mes "Enter the question number to which you wish to receive a response.";
input @idq;
query_sql("select question,answer,author from `questions` where `id`='"+@idq+"' and `read`='1'", @question$, @answer$, @auth$);
mes "Question: "+@question$[0]+"";
mes "Answer: "+@answer$[0]+"";
mes "Answered by: "+@auth$[0]+"";
close;
}
break;

case 3:
close;
break;
}
}

2. Table

-- ----------------------------
-- Table structure for `questions`
-- ----------------------------
DROP TABLE IF EXISTS `questions`;
CREATE TABLE `questions` (
  `id` int(5) NOT NULL auto_increment,
  `account_id` int(11) NOT NULL,
  `question` varchar(300) collate utf8_bin NOT NULL,
  `answer` varchar(500) collate utf8_bin NOT NULL,
  `read` int(1) NOT NULL,
  `author` varchar(15) collate utf8_bin NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=220 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

3. Web part

<?
$db = mysql_connect ("localhost","root","vertrigo");
mysql_select_db("ragnarok",$db);
		$id = $_GET['id'];
		if(!isset($id))
		{

		$result = mysql_query("SELECT `account_id`,`question`,`id` FROM `questions` where `read`='0'");
		$myrow = mysql_fetch_array($result);
		mysql_query("SET SESSION CHARACTER SET cp1251");  
		mysql_query("SET NAMES cp1251"); 
		do
		{
		printf ("<div align='center'><p> %s || <a href='index.php?id=%s'>%s</a></p></div>", $myrow['account_id'], $myrow['id'], $myrow['question']);
		}
		while($myrow = mysql_fetch_array($result));

		}
		else
		{

		$id = $_GET['id'];
		$result = mysql_query("SELECT `account_id`,`question` FROM `questions` where `id`='$id'");
		$myrow = mysql_fetch_array($result);
		mysql_query("SET SESSION CHARACTER SET cp1251");  
		mysql_query("SET NAMES cp1251"); 

		?>
		<div align="center">
		<?
		echo "Account ID: ".$myrow['account_id']."<br />";
		echo "Question: ".$myrow['question'];
		?>
		<form action="index.php?do=enter_answer" method="post" target="_top">
		Текст ответа:<br><textarea name="answer" cols="30" rows="10" id="answer"></textarea><br>
		<br>
		<input name="id" type="hidden" value="<? echo $id; ?>">
		Автор:<br><input name="author" type="text" cols="30" value=" "><br>
		<input name="submit" type="submit" value="Reply">
		</form>
		</div>

		<?
		}



			if($_GET['do'] == "enter_answer") 
			{
	$answer = trim($_POST["answer"]);
	$author = trim($_POST["author"]);
	$id = trim($_POST["id"]);

$db = mysql_connect ("localhost","root","vertrigo");
mysql_select_db("ragnarok",$db);

	$result = mysql_query("UPDATE `questions` SET `answer`='$answer', `author`='$author', `read`='1' WHERE `id`='$id'");	
	if($result == 'true')
	{
	echo "<div align='center'>"."<font color='#0066FF'>"."You have successfully answered!"."</font>"."</div>";
	echo '<head>
		<META HTTP-EQUIV="Refresh" CONTENT="3;URL=index.php">
	</head>';
	}
	else
	{
	echo "<div align='center'>"."<font color='#FF0000'>"."FAIL!"."</font>"."</div>";
	echo '<head>
		<META HTTP-EQUIV="Refresh" CONTENT="3;URL=index.php">
	</head>';
	}
		}

		?>

Questions list:

Answer:

ПуфЫстик · 16 августа, 2011

А как в игре выглядит ответ от админа ?

Войти

Скрипт саппорта

Рекомендуемые сообщения

Sanasol

Ссылка на комментарий

Поделиться на другие сайты

ПуфЫстик

Ссылка на комментарий

Поделиться на другие сайты

Сайт

Активность