Peonso
Godly Member
- Joined
- Jan 14, 2008
- Messages
- 1,763
- Solutions
- 30
- Reaction score
- 1,556
If someone asks for Znote for OTHire (7.72 server), I converted 1.5 from 24 july, it's here GitHub.
Znote there is a problem with the gallery i used the direct url and the other link but never show the pic
<?php
# Online Players Records for ZnoteAAC
# By cbrm @ otland.net
require_once 'engine/init.php'; include 'layout/overall/header.php';
echo'<h1>Online Players Records</h1>';
$record = mysql_query('SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 20;');
while ($row = mysql_fetch_assoc($record)) {$data[] = $row;}
if (empty($data)) {echo 'This server is not born yet.'; return include 'layout/overall/footer.php';}
?>
<center>
Max amount of online players was of <?php echo $data[0]['record'] ?> players on <?php echo date("M j Y", $data[0]['timestamp']) ?>
</center>
<table>
<tr class="yellow">
<td width="30%">
<span style="font-weight:bold;">Players</span>
</td>
<td width="70%">
<span style="font-weight:bold;">Date</span>
</td>
</tr>
<?php
foreach($data as $record):
echo'<tr><td>'.$record['record'].'</td>';
echo'<td>'.date("M j Y, H:i:s T", $record['timestamp']).'</td></tr>';
endforeach;
echo'</table>'; include 'layout/overall/footer.php'; ?>
<?php You have <?php echo $user_data['premdays']; ?> days remaining premium account.</p> ?>
Hey Znote, gimme a hand. This is not working with 1.5, I got no clue why, I always get the msg "This server is not born yet." from line 9.Code:<?php # Online Players Records for ZnoteAAC # By cbrm @ otland.net require_once 'engine/init.php'; include 'layout/overall/header.php'; echo'<h1>Online Players Records</h1>'; $record = mysql_query('SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 20;'); while ($row = mysql_fetch_assoc($record)) {$data[] = $row;} if (empty($data)) {echo 'This server is not born yet.'; return include 'layout/overall/footer.php';} ?> <center> Max amount of online players was of <?php echo $data[0]['record'] ?> players on <?php echo date("M j Y", $data[0]['timestamp']) ?> </center> <table> <tr class="yellow"> <td width="30%"> <span style="font-weight:bold;">Players</span> </td> <td width="70%"> <span style="font-weight:bold;">Date</span> </td> </tr> <?php foreach($data as $record): echo'<tr><td>'.$record['record'].'</td>'; echo'<td>'.date("M j Y, H:i:s T", $record['timestamp']).'</td></tr>'; endforeach; echo'</table>'; include 'layout/overall/footer.php'; ?>
Also, I tried to change this linefrom myaccount.php, since my servers uses `premend` (unixtime like death date) instead, but $user_data['premend'] returns nothing at all. I tried a lot of different shit and nothing worked.Code:<?php You have <?php echo $user_data['premdays']; ?> days remaining premium account.</p> ?>
$record = mysql_query('SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 20;');
while ($row = mysql_fetch_assoc($record)) {$data[] = $row;}
if (empty($data)) {echo 'This server is not born yet.'; return include 'layout/overall/footer.php';}
$records = mysql_select_multi('SELECT * FROM `server_record` ORDER BY `record` DESC LIMIT 20;');
foreach ($records as $record) $data[] = $record;
if (!$records || empty($data)) {
echo 'This server is not born yet.';
return include 'layout/overall/footer.php';
}
Also, I tried to change this line
from myaccount.php, since my servers uses `premend` (unixtime like death date) instead, but $user_data['premend'] returns nothing at all.Code:<?php You have <?php echo $user_data['premdays']; ?> days remaining premium account.</p> ?>
I tried a lot of different shit and nothing worked.
Your premium account will last till <?php echo date("d/m/Y, H:i:s",$user_data['premend']); ?>.</p>
youre missing a table, re install it correctly..
http://otland.net/threads/mysql-how-to-run-a-query.177833/Which table should I use, I do not have the right table, I've tested several and all give this error
CREATE TABLE IF NOT EXISTS `znote` (
`id` int(10) NOT NULL AUTO_INCREMENT,
`version` varchar(30) NOT NULL COMMENT 'Znote AAC version',
`installed` int(10) NOT NULL,
`cached` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `znote` (`version`, `installed`) VALUES
('$version', '$time');
CREATE TABLE IF NOT EXISTS `znote_accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`ip` int(10) NOT NULL,
`created` int(10) NOT NULL,
`points` int(10) DEFAULT 0,
`cooldown` int(10) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
INSERT INTO `znote_accounts` (`account_id`, `ip`, `created`) VALUES
('1', '0', '$time');
CREATE TABLE IF NOT EXISTS `znote_news` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`text` text NOT NULL,
`date` int(11) NOT NULL,
`pid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(30) NOT NULL,
`desc` text NOT NULL,
`date` int(11) NOT NULL,
`status` int(11) NOT NULL,
`image` varchar(30) NOT NULL,
`account_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_paypal` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`txn_id` varchar(30) NOT NULL,
`email` varchar(255) NOT NULL,
`accid` int(11) NOT NULL,
`price` int(11) NOT NULL,
`points` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_paygol` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`price` int(11) NOT NULL,
`points` int(11) NOT NULL,
`message_id` varchar(255) NOT NULL,
`service_id` varchar(255) NOT NULL,
`shortcode` varchar(255) NOT NULL,
`keyword` varchar(255) NOT NULL,
`message` varchar(255) NOT NULL,
`sender` varchar(255) NOT NULL,
`operator` varchar(255) NOT NULL,
`country` varchar(255) NOT NULL,
`currency` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_players` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` int(11) NOT NULL,
`created` int(11) NOT NULL,
`hide_char` tinyint(4) NOT NULL,
`comment` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `znote_players` (`player_id`, `created`, `hide_char`, `comment`) VALUES
('1', '$time', '0', '. . .');
CREATE TABLE IF NOT EXISTS `znote_player_reports` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`posx` int(6) NOT NULL,
`posy` int(6) NOT NULL,
`posz` int(6) NOT NULL,
`report_description` VARCHAR(255) NOT NULL,
`date` INT(11) NOT NULL,
`status` TINYINT(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_changelog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` VARCHAR(255) NOT NULL,
`time` INT(11) NOT NULL,
`report_id` INT(11) NOT NULL,
`status` TINYINT(3) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_shop` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` int(11) NOT NULL,
`itemid` int(11) DEFAULT NULL,
`count` int(11) NOT NULL DEFAULT '1',
`describtion` varchar(255) NOT NULL,
`points` int(11) NOT NULL DEFAULT '10',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_shop_logs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
`type` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`count` int(11) NOT NULL,
`points` int(11) NOT NULL,
`time` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_shop_orders` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_id` int(11) NOT NULL,
`type` int(11) NOT NULL,
`itemid` int(11) NOT NULL,
`count` int(11) NOT NULL,
`time` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_visitors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` int(11) NOT NULL,
`value` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_visitors_details` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ip` int(11) NOT NULL,
`time` int(11) NOT NULL,
`type` tinyint(4) NOT NULL,
`account_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_forum` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`access` tinyint(4) NOT NULL,
`closed` tinyint(4) NOT NULL,
`hidden` tinyint(4) NOT NULL,
`guild_id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
INSERT INTO `znote_forum` (`name`, `access`, `closed`, `hidden`, `guild_id`) VALUES
('Staff Board', '4', '0', '0', '0'),
('Tutors Board', '2', '0', '0', '0'),
('Discussion', '1', '0', '0', '0'),
('Feedback', '1', '0', '1', '0');
CREATE TABLE IF NOT EXISTS `znote_forum_threads` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`forum_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
`player_name` varchar(50) NOT NULL,
`title` varchar(50) NOT NULL,
`text` text NOT NULL,
`created` int(11) NOT NULL,
`updated` int(11) NOT NULL,
`sticky` tinyint(4) NOT NULL,
`hidden` tinyint(4) NOT NULL,
`closed` tinyint(4) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_forum_posts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`thread_id` int(11) NOT NULL,
`player_id` int(11) NOT NULL,
`player_name` varchar(50) NOT NULL,
`text` text NOT NULL,
`created` int(11) NOT NULL,
`updated` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_deleted_characters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`original_account_id` int(11) NOT NULL,
`character_name` varchar(255) NOT NULL,
`time` datetime NOT NULL,
`done` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `znote_guild_wars` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`limit` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
FOREIGN KEY (`id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 29 inC:\xampp\htdocs\engine\function\users.php on line 1385
I'm getting this when I try to log in with any accounts (even after updating them)
Code:Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 29 inC:\xampp\htdocs\engine\function\users.php on line 1385
echo 'Congratulations! Your account has been created. You may now login to create a character.';
user_account_add_premdays(account_id, 10);
lastaccount = accounts.size;
add_premdays(account[lastaccount], 10);
Any ideas on how to add 10 premium days for new accounts? I couldn't find any default settings in config.php
Any help?
You can do it through the server.
'email' => $_POST['email'],
'premdays' => 10,
'premdays' => time() + (10 * 24 * 3600),