Printable View
Use this Querry..Quote:
Originally Posted by MaskARRA
Quote:
use [master]
go
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
CREATE FUNCTION [dbo].[fn_md5] (@data varchar(255))
RETURNS CHAR(32) AS
BEGIN
return SUBSTRING(master.dbo.fn_varbintohexstr(HashBytes('MD5', @data)), 3, 32)
END
go
GRANT EXECUTE ON [dbo].[fn_md5] TO [public]
go
does someone have the original header?
w/o Muonline season 6, or at least w/o Season 6 on it?
- - - Updated - - -
[Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function dbo.fn_md5 has too many arguments specified. (SQLExecute[8144] at ext\pdo_odbc\odbc_stmt.c:133)Quote:
Originally Posted by KinJaeWom
- - - Updated - - -
does someone fixed the problem with the raking of killers and guild?
- - - Updated - - -
For PK ranking
look into class.ranking.php and corect your query.Code:case 'killers':
$dbDATA = $dB->query_fetch("SELECT TOP ".mconfig('rankings_results')." Name,Class,PKCount FROM Character WHERE Name NOT IN(".rankingsExcludeChars().") ORDER BY PKCount DESC");
$cacheDATA = BuildCacheData($dbDATA);
UpdateCache('rankings_pk.cache',$cacheDATA);
- - - Updated - - -
For guild ranking look into database [dbo].[guild] the column G_Score(by defaul i have NULL) have to be >0 to appear in top, or change the config ../modules/ranking/guilds.php
if($i>=1 && $rdata[2] > 0) TO if($i>=1 && $rdata[2] >= 0)
and you need to alter the procedure createguild from dbo.muonline to insert G_Score - 0 or you will get on top guild w/o guild score (nothing will be there)
If u have the problem with the guild mark try to change in config
$config['gmark_bin2hex_enable'] = false;
- - - Updated - - -
=============
Setup WebEngine's cron to run every 5 minutes (/cron/cron.php)
i cannot add it from adminCP ... or i need to make the bat to run himself(like making a job in windows) every X minutes?
Hi mate, I used your query but still I got that kind of error..Quote:
Originally Posted by KinJaeWom
my memb_pwd is varbinary
should I change this "CREATE FUNCTION [dbo].[fn_md5] (@data varchar(255)) " to "CREATE FUNCTION [dbo].[fn_md5] (@data varbinary(255)) " ?
Please help
Setup WebEngine's cron to run every 5 minutes (/cron/cron.php)
i cannot add it from adminCP ... or i need to make the bat to run himself(like making a job in windows) every X minutes?
===================
does someone have the original header?
@Please help!Quote:
Originally Posted by MaskARRA
Please help :(
Hello
i have the same problem with website offline ....some help plzz
I use :
windows 8.1
xampp-win32-5.6.8-0-VC11-installer
SQLSRV32 drivers for msql 2008 r2 developer
Attachment 152031Attachment 152032
$config['SQL_PDO_DRIVER'] = 1; // 1= dblib (default) || 2= sqlsrv || 3= odbc
if i use 3 its work the web but dont work a lot of things ....please help !
same problem
Fix (my problem): Install new xamp 1.7.1 :)
use 3 odbc, if something doesnt work look for top fix some posts of mine, this page or -1
- - - Updated - - -
i use odbc conn and with somefixes of the code + cron nob works.
took a lot of time to find the cure, but its worth the pain
is this work in SQL 2000?
nope, 2008 works
P0st deleted
did someone fix the "latest paypal donations" from AdminCP?
some ppl donated, they didnt get the "credits" and nothing appeared in the list.
Paypal donation module works perfect, make sure you configure it correctly.Quote:
Originally Posted by FlamingArm