Mangos Vote Reward System (Must Work)

[Tomatsuppen]

Hello MMowned,

I know that there are a few requests already with people looking for a vote reward system for Mangos, but all the requests are either dead or showing incorrect information, so I choosed to make a new request about this.

Me and im sure many other people are still in a desperate need of a working Mangos Voting Reward System.

I have been searching for hours , with no luck in getting what i wanted.

I'm looking for the AVS Voting Reward System (BUT) converted and working for Mangos. (Or anything that has the same options and features)

I did find a few converted uploads of it, but everytime it failed and many other people claimed it as none working and the topics went dead.

I dont have much to give back as a reward for finding a solution for my problem. I can give you rep, you can get a gm account on our server, or maybe give you some money as a thank you gift.

It would really save my day if I could get a converted and working AVS version for Mangos.

Thanks for reading

[The-Eradicator]

Originally Posted by Tomatsuppen

Hello MMowned,

I know that there are a few requests already with people looking for a vote reward system for Mangos, but all the requests are either dead or showing incorrect information, so I choosed to make a new request about this.

Me and im sure many other people are still in a desperate need of a working Mangos Voting Reward System.

I have been searching for hours , with no luck in getting what i wanted.

I'm looking for the AVS Voting Reward System (BUT) converted and working for Mangos. (Or anything that has the same options and features)

I did find a few converted uploads of it, but everytime it failed and many other people claimed it as none working and the topics went dead.

I dont have much to give back as a reward for finding a solution for my problem. I can give you rep, you can get a gm account on our server, or maybe give you some money as a thank you gift.

It would really save my day if I could get a converted and working AVS version for Mangos.

Thanks for reading

Code it yourself, or hire someone. Money is a very good incentive, if you'd like to throw out a number.

[Tomatsuppen]

I have no experience coding what so ever. Well if a person would fix the AVS for me to work on my Mangos community I would give, lets say 25$

I know the coding wouldn't take long since the files a pretty simple to lookup and fix if you know how to code, so yeah 25$ I would give.

[jerrkan]

Okey.
There is 1 AVS for mangos out there i know. Also there is another vote system thats working great. Let me find it and i will update this post.

AVS mangos: [Only registered and activated users can see links. ] (I dont take credits for this)

Other mangos vote system: [Only registered and activated users can see links. ] (No credits for this) Im using this working 100%

[Tomatsuppen]

Jerrkan if it works , you really saved my day dude, I will return when I have tested them Ty man.

[Tomatsuppen]

Hi again Jerrkan,

The one you use is what I have been trying to setup on my server the last days, it communicates fine with the database, but when buying rewards with votingpoints it gives me a error

"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"

I have installed telnet server & client services are running, but it gives me this error all the time.

[Tomatsuppen]

People say that the Mangos AVS voting reward system is a dead project until some person will be fixing the login.php which gives mysql error when trying to claim rewards from voting.

If you could maybe help me out fixing the voting system you already use and says works 100% it would be nice!

+ for you.

[milla247]

Hi Tom, I think I have fixed the AVS program.
Download the Org AVS from the link linked above or [Only registered and activated users can see links. ]

Now download my edited spend.php and replace it or make these fixes:

AFTER THESE LINES:

//send item.
		$Con = mysql_connect($Realminfo['sqlhost'],$Realminfo['sqluser'],$Realminfo['sqlpass']);
		mysql_select_db($Realminfo['chardb']);
		$stack = 1;
		$gold = 0;
		$item = 1;

DELETE ALL LINES BETWEEN ABOVE AND BELOW (not incuding these):

//	if ($result) {
//	      mysql_close();
//          return $mail_id;
//	} else {
//			mysql_close();
//			return 0;
//			}

AND ADD THIS CODE IN BETWEEN THEM:

if ($item == 0) {
        	 $has_items = 0;
    	} else {
        	 $has_items = 1;
    	}

		// create item first...
		$result =  mysql_query("SELECT MAX(`guid`) FROM item_instance");
		$item_instance_id = (mysql_result($result, 0)) + 1;
		$result = mysql_query("INSERT INTO `item_instance` (`guid`, `owner_guid`, `data`) VALUES ($item_instance_id , '{$Character}', '".$item_instance_id." 0 3 {$Rinfo['itemid']} 0 0 {$Character} 0 0 0 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ')");
		
		// Write message
		$result = mysql_query("SELECT MAX(`id`) FROM item_text");
		$item_page_id = (mysql_result($result, 0)) + 1;
		$result = mysql_query("INSERT INTO `item_text` (id, text) VALUES ($item_page_id,'".MAIL_BODY."')");
		
		// Setup Mail entry
		$result = mysql_query("SELECT MAX(`id`) FROM mail");
		$mail_id = (mysql_result($result, 0)) + 1;
	   	$result = mysql_query("INSERT INTO mail (id,messageType,stationery,mailTemplateId,sender,receiver,subject,itemTextId,has_items,expire_time,deliver_time,money,cod,checked) VALUES ($mail_id, 0, 61, 0, '{$Character}', '{$Character}', '".MAIL_SUBJECT."', '$item_page_id', '$has_items', '".(time() + (30*24*3600))."','".(time()+5)."', '$gold', 0, 0)");
 		if ($has_items) {
			$result = mysql_query("INSERT INTO mail_items (mail_id,item_guid,item_template,receiver) VALUES ($mail_id, $item_instance_id, '{$Rinfo['itemid']}', '{$Character}')");
		}

Or download the spend.php file here:

[Only registered and activated users can see links. ]

[Only registered and activated users can see links. ]

[Only registered and activated users can see links. ]

[Only registered and activated users can see links. ]

EDIT:
I see you mentioned that you were considering paying or rewarding etc, you dont have to, but if you feel a tip is in need then send me a PM =)

Hope this fix works for you

[Tomatsuppen]

Hey Milla247.

Sorry for me being slow replying back, I just came home from vaccation yesterday. Now I have done what you have explained in your upper post, but it still does not work,

I keep getting this error :

"Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\xampp\htdocs\vote\pages\login.php on line 76
Login failed."

Exact same error as in all the other mangos avs I have tried. The login.php does not seem to be coded correct to work with Mangos and I dont know how to fix it. :/

[milla247]

I need to know what ver of PHP is on your server and send me a typical database structure of your realmd accounts table
mine is...

CREATE TABLE /*!32312 IF NOT EXISTS*/ `account` (
  `id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier',
  `username` varchar(32) NOT NULL default '',
  `sha_pass_hash` varchar(40) NOT NULL default '',
  `gmlevel` tinyint(3) unsigned NOT NULL default '0',
  `sessionkey` longtext,
  `v` longtext,
  `s` longtext,
  `email` text,
  `joindate` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `last_ip` varchar(30) NOT NULL default '0.0.0.0',
  `failed_logins` int(11) unsigned NOT NULL default '0',
  `locked` tinyint(3) unsigned NOT NULL default '0',
  `last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
  `online` tinyint(4) NOT NULL default '0',
  `expansion` tinyint(3) unsigned NOT NULL default '0',
  `mutetime` bigint(40) unsigned NOT NULL default '0',
  `locale` tinyint(3) unsigned NOT NULL default '0',
  `reward_points` int(8) unsigned default NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';

[Tomatsuppen]

CREATE TABLE `account` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Identifier',
  `username` varchar(32) NOT NULL DEFAULT '',
  `sha_pass_hash` varchar(40) NOT NULL DEFAULT '',
  `gmlevel` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `sessionkey` longtext,
  `v` longtext,
  `s` longtext,
  `email` text,
  `joindate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_ip` varchar(30) NOT NULL DEFAULT '0.0.0.0',
  `failed_logins` int(11) unsigned NOT NULL DEFAULT '0',
  `locked` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `last_login` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `online` tinyint(4) NOT NULL DEFAULT '0',
  `expansion` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `mutetime` bigint(40) unsigned NOT NULL DEFAULT '0',
  `locale` tinyint(3) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_gmlevel` (`gmlevel`)
) ENGINE=MyISAM AUTO_INCREMENT=417 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Account System';

PHP version I have no clue, we run it using Xampp

[milla247]

This is how to check the version...
create a text file and rename it phpver.php

Open the file with notepad and put in the following and then save it in C:\xampp\htdocs and open with your browser (http://localhost/phpver.php)

<?php
phpinfo();
?>

As a control I am running php ver 5.2.10 with MySQL ver 5.1.37
You can verify your MySQL ver by either connecting to your database or if your using HiediSQL it will say it at the bottom.

I do belive that either you php ver is outdated or mysql is too

[Wast3d]

Somtimes the script send wrong items... And gives errors for me. (MAIL INSERT errors)

Using trinitycore2

Anyone got aolsution for this?

[Tomatsuppen]

Okay Milla247.

Im running :

PHP Version 5.2.9
MYSQL Communty Server 5.1.36

So I guess my issue is that im outdated? Its just weird since I did install the latest xampp & mysql community server avalible.

[BlackGoth]

sry i have any problems with the Mangos_AVS vote Systhem!

My Englisch isn´t verry good...i´m coming from Germany and i hope you can help me =(

I have this Problem.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in

did everybody know whats the problem are?

I need your help.

My Serverversion is Mangos 3.2.2a

Thank you.