Printable View
I try to use this with my test server but i cant make it work.cause i use ODBC connection cause when i setup via MSSQL connection my website always getting error's i just want to ask if you could do this to work on ODBC..Exchange Online Hours To Credits.http://forum.ragezone.com/f197/mucor...module-928874/
1min Like a boss
http://oi41.tinypic.com/foztw1.jpg
Download
Download rewrited.php from Sendspace.com - send big files the easy way
let me try it Dude :)..Thank you so much..
can you upload it on mediafire.Cause i dont know whats fuc*king happened i cant download on sendspace..
sometimes happens on sendspace :D
anw take mega (lazy to create acc on media)
https://mega.co.nz/#!F1ARkKLQ!Basqa3...tQfvJR19pyy_Ew
thank you so much :)
bro please check my dll's on this thread if what dll's blocking main.exe to call mu.exe
http://forum.ragezone.com/f193/force...oad-mu-943274/
bro can you include the correct WZ_DISCONNECT_MEMB Queries for this?.included the TH.
I also use OnlineHours on MEMB_STAT,but i facing problem cause its always NULL.I cant set it to Not Allow Nulls, what i need to do?
Or i should i just create TotalOnline on my MEMB_STAT?
When I try to remove the NULLS on OnlineHours at MEMB_STAT and saving it,it shows.
Quote:
'MEMB_STAT' table
- Unable to modify table.
Cannot insert the value NULL into column 'OnlineHours', table 'MuOnline.dbo.Tmp_MEMB_STAT'; column does not allow nulls. INSERT fails.
The statement has been terminated.
about mu.exe - answeredQuote:
Originally Posted by NoLimiT
TH it's column in my db, rewrited.php read from OnlineHours column
i thought you have one if you gave me url to original release.
anw create column in MEMB_STAT
Name = OnlineHours
Data Type = int
default 0
Stored procedure
Code:CREATE PROCEDURE WZ_DISCONNECT_MEMB
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0
Set @find_id = 'NOT'
select @find_id = S.memb___id from MEMB_STAT S INNER JOIN MEMB_INFO I ON S.memb___id = I.memb___id
where I.memb___id = @memb___id
if( @find_id <> 'NOT' )
begin
update MEMB_STAT set ConnectStat = @ConnectStat, DisConnectTM = getdate(), OnlineHours = OnlineHours+(DATEDIFF(hh,ConnectTM,getdate()))
where memb___id = @memb___id
end
end
GO
bro I already have OnlineHours on my MEMB_STAT.My problem is i cant edit the length i use mssql2k5. i think the length must be the problem on my MEMB_STAT cause every time i edit the OnlineHours and enter it.Always back to NULL.
Edit: Its fine now bro.Thank you So much for the effort helping me.. BIG THANKS :P:
Just want to ask final question with this matter bro.how to change the credits per hour?
Np & EnjoyQuote:
Originally Posted by NoLimiT
<? $k = $hours*10; echo($k); ?>Quote:
Originally Posted by NoLimiT
&
$k = $hh * 10 + $cr[0];
10 to different number
Thank you mate,for now i see 1 hour is equivalent of 100 right if i want 1 hr is equivalent of 10 so i just put
<? $k = $hours*1; echo($k); ?>
How's my signature? :tongue: Special Thanks to you.
Hehe just seen sig, cool :)Quote:
Originally Posted by NoLimiT
by default it was 10 credits per 1 hour
so *1 = 1 credit per 1 hour :)
the first it's just visual
second one adding to the credits column.
Thank you very much bro..can you pm me your skype bro?.can i add you on my skype?
I don't use skype to talk, only to video conv's, i do use only my country comunicator & irc channels sorry :PQuote:
Originally Posted by NoLimiT