[Request]Removal of Annoying "Green Book"

[Unrealx420]

Hello, I notice in Vsro they have this green book thing that limits the time you can play with exp. Is there a way to disable this? Sorry if this topic is retarded I just figured maybe somebody else would hate this problem as well.. Or if there is already a guide or info regarding this it would be appreciated to have somebody redirect me to the link. Thanks in advanced.

[Disco Teka]

Relogg and u will have full time green book again.

[Unrealx420]

Originally Posted by Disco Teka

Relogg and u will have full time green book again.

hmm maybe something is setup wrong, I have tried that and the book is not green again. Oh well..

[PortalDark]

Originally Posted by Disco Teka

Relogg and u will have full time green book again.

he means remove
not refill

[Dr.Abdelfattah]

check my last update (last point) in this guide

[eLO21]

better way is add in SQL Server Agent "job" which will reset "AccPlayTime"

UPDATE TB_USER
SET AccPlayTime=('0')
WHERE AccPlayTime>10800

...now you don't must relogg and edit GlobalManger.exe, you need just use any teleport to reset green book

@Edit:
When i find some time, i make guide with images... ^^

[akira_lee]

Originally Posted by eLO21

better way is add in SQL Server Agent "job" which will reset "AccPlayTime"

UPDATE TB_USER
SET AccPlayTime=('0')
WHERE AccPlayTime>10800

...now you don't must relogg and edit GlobalManger.exe, you need just use any teleport to reset green book

@Edit:
When i find some time, i make guide with images... ^^

did you have detail guide?

[eLO21]

Like i said... you don't must edit GameServer.exe or GlobalManger.exe

~Proof:


on first you have green book with 4h 100% exp, when this end you don't must relogg, because green book give you next 18h play with 100% exp... and when this end green book give 4h 100% exp, next 18h 100% exp etc...

~If green book got stuck... all teleports will fix it:


ok, now...

Server.cfg:

Common {
	debug_option_debugger_present{
			DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
			DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
			DEBUG_OPTION_ASSERT_CANCEL_EXIT
	}
	debug_option_stand_alone{			
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}
	netengine_debug_option_debugger_present{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}
	netengine_debug_option_stand_alone{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 
	}

}

GlobalManager {
		Certification "127.0.0.1", 32000 
		LoginFailureTolerance 3
		IBUVFailureTolerance 3
		LoginFailureBlockTimeMin 10
		IBUVFailureBlockTimeMin	10
		AutomatedPunisher "AutomatedPunisher"
		LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times"
		LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times"
		IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times"
		IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times"
}

GatewayServer {
		LastFullVersion_SR_Client 130
		Certification "127.0.0.1", 15880
		IBUVQueueReserveCount 20000
		IBUVQueuePrepareRatio 0.5
		IBUVFailureIPTolerance 0
		IBUVStringSize 6
		IBUVCharacterSet "ABCDEFGHLMNQRTabdehimn2345678"
}

DownloadServer {
        	Certification "127.0.0.1", 15880
}

FarmManager {
		Certification "127.0.0.1", 15880
}

AgentServer {
		Certification "127.0.0.1", 15882
}

MachineManager {
		Certification "127.0.0.1", 15880
}

SR_GameServer {
		Certification "127.0.0.1", 15882

		ExpRatio 10000
        	ExpRatioParty 15000
		DropItemRatio 5000
        	DropGoldAmountCoef 3000	
        	//WINTER_EVENT_2009 EVENT_ON
		//EUBUSINESS_EVENT EVENT_ON
        	//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
		//THANKS_GIVING_EVENT EVENT_ON
		//LIBERATION_EVENT EVENT_ON
		LOCALE LOCALE_VIETNAM
       
         	//#ifdef OPEN_MARKET_SYSTEM
        	SET_FEE_RATE "0,5,5,5"
        	SELL_FEE_RATE "0,10,10,10"
        	//#endif OPEN_MARKET_SYSTEM

		DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "ON"
		ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"


}

SR_ShardManager {
		Certification "127.0.0.1", 15882
		BILLING_SERVER_URL "http://127.0.0.1:8080/"
		CREST_FTP_URL "ftp://crest:[email protected]/"
        	ExtraExpRatio 0.5
        	ChristmasEvent2007 0
		SERVER_EVENT_SYSTEM ON
       		LOCALE LOCALE_VIETNAM

       		FlagEvent 1
       		HourForMeterRateLevelFirst 22
       		HourForMeterRateLevelSecond 23

		BattleArenaRandom 1
		BattleArenaParty 1
		BattleArenaGuild 1
		BattleArenaJob 1
		ArenaMatchOccupy 1
		ArenaMatchFlag 1
		ArenaMatchPoint 1
}

127.0.0.1 change to your IP...

Schedule.cfg:

/////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		13:30:00, 13:31:00
}

Schedule SpecialGoodsSelling1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		14:00:00, 14:20:00	
}

////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:30:00, 16:31:00
}

Schedule SpecialGoodsSelling2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		17:00:00, 17:20:00	
}

////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		19:30:00, 19:31:00
}

Schedule SpecialGoodsSelling3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		20:00:00, 20:20:00	
}

////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:30:00, 22:31:00
}

Schedule SpecialGoodsSelling4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		23:00:00, 23:20:00
}


///////////////////////// 2008-01-22 /////////////////////////////////

/*
Schedule UniqueSpawn_1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		01:00:00, 01:01:00
}

Schedule UniqueSpawn_2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		11:00:00, 11:01:00
}

Schedule UniqueSpawn_3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		15:00:00, 15:01:00
}

Schedule UniqueSpawn_4
{
	DurationBegin	2008-01-21, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		19:00:00, 19:01:00
}
*/

Schedule EUBusinessEventUpdate
{
	DurationBegin	2008-01-21, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		17:00:00, 23:59:59
}

///////////////////////////////////////////////////
Schedule MentorHonorRecordUpdate
{
	DurationBegin	2006-09-27, 00:00:00 	
 	DurationEnd	2020-12-31, 00:00:00
	Daily		1,1			// ¸ĹŔĎ 1ąř
	Once		00:00:00, 00:01:00	// ¸ĹŔĎ ŔÚÁ¤żˇ!!
}

////////////////////////////////////////////////////////////
// SiegeFortress Schedule
Schedule AllowSiegeRequest
{
	// 2ÁÖ °Ł°ÝŔş ˝ĂŔŰŔĎ ±âÁŘŔ¸·Î Ä«żîĆĂŔĚ µÇąÇ·Î, ąÝµĺ˝Ă ĆĐġµÇ´Â łŻÂĄ¸¦ ±âÁŘŔ¸·Î ˝ĂŔŰŔĎŔ» ŔâľĆľß ÇŃ´Ů!!!

	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, { 1, 2, 3, 4, 5, }	// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ żů,Č*,Ľö,¸ń,±ÝżäŔĎżˇ!
	Once		00:00:00, 23:59:59	// AM 00:00:00 ~ PM 11:59:59şĐ ±îÁö¸¸!
}

Schedule SiegeProgressing
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		20:00:00, 21:30:00	// PM 21:00:00 ~ PM 23:00:00 ±îÁö ÁřÇŕ
}

Schedule FortressStatusUpdate
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1			// ¸ĹŔĎ 1ąř
	Once		23:05:00, 23:06:00	// żä»őŔü ÇĎ´Â łŻµµ żä»őŔü Áľ·á ČÄ 10şĐ µÚ°ˇ µÇµµ·Ď ÇŃ´Ů.
}

Schedule AllowSiegeTaxJob
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ŔĎżäŔĎ
	Once		00:00:00, 23:59:59	// ÇĎ·ç ÁľŔĎ
}

Schedule AlertSiegeStartAfter30Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		19:30:00, 19:31:00	// PM 19:30:00 ~ PM 19:31:00 
}

Schedule AlertSiegeFinishAfter30Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:00:00, 21:01:00	// żŔČÄ 2˝Ă 30şĐżˇ!
}

Schedule AlertSiegeFinishAfter20Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:10:00, 21:11:00	// PM 21:40:00
}

Schedule AlertSiegeFinishAfter10Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:20:00,21:21:00	// PM 21:50:00
}

Schedule AlertSiegeFinishAfter1Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:29:00, 21:29:10	// PM 21:59:00
}


////////////////////////////////////////////////////////////
// FlagWorld Schedule
Schedule FlagWorldParticipation1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		00:50:00, 01:01:00
}

Schedule FlagWorldNotice1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		00:55:00, 00:59:00
}

Schedule FlagWorldPlaying1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		01:00:00, 01:21:00
}

Schedule FlagWorldParticipation2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		02:50:00, 03:01:00
}

Schedule FlagWorldNotice2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		02:55:00, 02:59:00
}

Schedule FlagWorldPlaying2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		03:00:00, 03:21:00
}

Schedule FlagWorldParticipation3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		04:50:00, 05:01:00
}

Schedule FlagWorldNotice3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		04:55:00, 04:59:00
}

Schedule FlagWorldPlaying3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		05:00:00, 05:21:00
}

Schedule FlagWorldParticipation4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		06:50:00, 07:01:00
}

Schedule FlagWorldNotice4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		06:55:00, 06:59:00
}

Schedule FlagWorldPlaying4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		07:00:00, 07:21:00
}

Schedule FlagWorldParticipation5
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		08:50:00, 09:01:00
}

Schedule FlagWorldNotice5
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		08:55:00, 08:59:00
}

Schedule FlagWorldPlaying5
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		09:00:00, 09:21:00
}

Schedule FlagWorldParticipation6
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		10:50:00, 11:01:00
}

Schedule FlagWorldNotice6
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		10:55:00, 10:59:00
}

Schedule FlagWorldPlaying6
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		11:00:00, 11:21:00
}

Schedule FlagWorldParticipation7
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		12:50:00, 13:01:00
}

Schedule FlagWorldNotice7
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		12:55:00, 12:59:00
}

Schedule FlagWorldPlaying7
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		13:00:00, 13:21:00
}

Schedule FlagWorldParticipation8
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		14:50:00, 15:01:00
}

Schedule FlagWorldNotice8
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		14:55:00, 14:59:00
}

Schedule FlagWorldPlaying8
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		15:00:00, 15:21:00
}

Schedule FlagWorldParticipation9
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:50:00, 17:01:00
}

Schedule FlagWorldNotice9
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:55:00, 16:59:00
}

Schedule FlagWorldPlaying9
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		17:00:00, 17:21:00
}

Schedule FlagWorldParticipation10
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		18:50:00, 19:01:00
}

Schedule FlagWorldNotice10
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		18:55:00, 18:59:00
}

Schedule FlagWorldPlaying10
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		19:00:00, 19:21:00
}

Schedule FlagWorldParticipation11
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		20:50:00, 21:01:00
}

Schedule FlagWorldNotice11
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		20:55:00, 20:59:00
}

Schedule FlagWorldPlaying11
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		21:00:00, 21:21:00
}

Schedule FlagWorldParticipation12
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:50:00, 23:01:00
}

Schedule FlagWorldNotice12
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:55:00, 22:59:00
}

Schedule FlagWorldPlaying12
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		23:00:00, 23:21:00
}
Schedule ChinsTombGateOpen1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		04:00:00, 04:10:00
}

Schedule ChinsTombGateOpen2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		10:00:00, 10:10:00
}

Schedule ChinsTombGateOpen3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:00:00, 16:10:00
}

Schedule ChinsTombGateOpen4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:00:00, 22:10:00
}
Schedule RocTopGateOpen1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, { 0, 1, 2, 3, 4, 5, }		// ¸ĹÁÖ ŔĎ, Č*, ±Ý
	Once		10:00:00, 14:59:00	// żŔČÄ 7 ˝Ă ~ 11˝Ă 59 şĐ ±îÁö
}

and you must run all .exe in the order:

01.Certification
02.GatewayServer
03.MachineManger
04.DownloadServer
05.FarmManger
06.SR_ShardManger
07.AgentServer
08.SR_GameServer
09.SMC

[MeGaMaX]

Originally Posted by eLO21

Like i said... you don't must edit GameServer.exe or GlobalManger.exe

~Proof:


on first you have green book with 4h 100% exp, when this end you don't must relogg, because green book give you next 18h play with 100% exp... and when this end green book give 4h 100% exp, next 18h 100% exp etc...

~If green book got stuck... all teleports will fix it:


ok, now...

Server.cfg:

Common {
	debug_option_debugger_present{
			DEBUG_OPTION_ASSERT_SHOW_MESSAGEBOX_OKCANCEL,
			DEBUG_OPTION_ASSERT_ADVANCE_BREAK,
			DEBUG_OPTION_ASSERT_CANCEL_EXIT
	}
	debug_option_stand_alone{			
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}
	netengine_debug_option_debugger_present{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP
	}
	netengine_debug_option_stand_alone{
			DEBUG_OPTION_ASSERT_DONOT_SHOW_MESSAGEBOX,
			DEBUG_OPTION_ASSERT_WRITE_MINIDUMP 
	}

}

GlobalManager {
		Certification "127.0.0.1", 32000 
		LoginFailureTolerance 3
		IBUVFailureTolerance 3
		LoginFailureBlockTimeMin 10
		IBUVFailureBlockTimeMin	10
		AutomatedPunisher "AutomatedPunisher"
		LoginPunishmentGuide "Blocked for 10 minutes due to incorrect password entered 3 times"
		LoginPunishmentDescription "Blocked for 10 minutes due to incorrect password entered 3 times"
		IBUVPunishmentGuide "Blocked for 10 minutes due to incorrect code entered 3 times"
		IBUVPunishmentDescription "Blocked for 10 minutes due to incorrect code entered 3 times"
}

GatewayServer {
		LastFullVersion_SR_Client 130
		Certification "127.0.0.1", 15880
		IBUVQueueReserveCount 20000
		IBUVQueuePrepareRatio 0.5
		IBUVFailureIPTolerance 0
		IBUVStringSize 6
		IBUVCharacterSet "ABCDEFGHLMNQRTabdehimn2345678"
}

DownloadServer {
        	Certification "127.0.0.1", 15880
}

FarmManager {
		Certification "127.0.0.1", 15880
}

AgentServer {
		Certification "127.0.0.1", 15882
}

MachineManager {
		Certification "127.0.0.1", 15880
}

SR_GameServer {
		Certification "127.0.0.1", 15882

		ExpRatio 10000
        	ExpRatioParty 15000
		DropItemRatio 5000
        	DropGoldAmountCoef 3000	
        	//WINTER_EVENT_2009 EVENT_ON
		//EUBUSINESS_EVENT EVENT_ON
        	//GOLDEN_PIG_FEBRUARY_EVENT EVENT_ON
		//THANKS_GIVING_EVENT EVENT_ON
		//LIBERATION_EVENT EVENT_ON
		LOCALE LOCALE_VIETNAM
       
         	//#ifdef OPEN_MARKET_SYSTEM
        	SET_FEE_RATE "0,5,5,5"
        	SELL_FEE_RATE "0,10,10,10"
        	//#endif OPEN_MARKET_SYSTEM

		DO_NOT_SPAWN_MONSTER_OVER_MAX_SERVICE_LEVEL "ON"
		ENTER_LIMIT_CONDITION_GAME_WORLD_ASSIGNED "OFF"


}

SR_ShardManager {
		Certification "127.0.0.1", 15882
		BILLING_SERVER_URL "http://127.0.0.1:8080/"
		CREST_FTP_URL "ftp://crest:[email protected]/"
        	ExtraExpRatio 0.5
        	ChristmasEvent2007 0
		SERVER_EVENT_SYSTEM ON
       		LOCALE LOCALE_VIETNAM

       		FlagEvent 1
       		HourForMeterRateLevelFirst 22
       		HourForMeterRateLevelSecond 23

		BattleArenaRandom 1
		BattleArenaParty 1
		BattleArenaGuild 1
		BattleArenaJob 1
		ArenaMatchOccupy 1
		ArenaMatchFlag 1
		ArenaMatchPoint 1
}

127.0.0.1 change to your IP...

Schedule.cfg:

/////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		13:30:00, 13:31:00
}

Schedule SpecialGoodsSelling1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		14:00:00, 14:20:00	
}

////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:30:00, 16:31:00
}

Schedule SpecialGoodsSelling2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		17:00:00, 17:20:00	
}

////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		19:30:00, 19:31:00
}

Schedule SpecialGoodsSelling3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		20:00:00, 20:20:00	
}

////////////////////////////////////////////////
Schedule InformSpecialGoodsSelling4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:30:00, 22:31:00
}

Schedule SpecialGoodsSelling4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		23:00:00, 23:20:00
}


///////////////////////// 2008-01-22 /////////////////////////////////

/*
Schedule UniqueSpawn_1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		01:00:00, 01:01:00
}

Schedule UniqueSpawn_2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		11:00:00, 11:01:00
}

Schedule UniqueSpawn_3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		15:00:00, 15:01:00
}

Schedule UniqueSpawn_4
{
	DurationBegin	2008-01-21, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		19:00:00, 19:01:00
}
*/

Schedule EUBusinessEventUpdate
{
	DurationBegin	2008-01-21, 00:00:00
	DurationEnd	2008-12-31, 00:00:00
	Daily		1,1
	Once		17:00:00, 23:59:59
}

///////////////////////////////////////////////////
Schedule MentorHonorRecordUpdate
{
	DurationBegin	2006-09-27, 00:00:00 	
 	DurationEnd	2020-12-31, 00:00:00
	Daily		1,1			// ¸ĹŔĎ 1ąř
	Once		00:00:00, 00:01:00	// ¸ĹŔĎ ŔÚÁ¤żˇ!!
}

////////////////////////////////////////////////////////////
// SiegeFortress Schedule
Schedule AllowSiegeRequest
{
	// 2ÁÖ °Ł°ÝŔş ˝ĂŔŰŔĎ ±âÁŘŔ¸·Î Ä«żîĆĂŔĚ µÇąÇ·Î, ąÝµĺ˝Ă ĆĐġµÇ´Â łŻÂĄ¸¦ ±âÁŘŔ¸·Î ˝ĂŔŰŔĎŔ» ŔâľĆľß ÇŃ´Ů!!!

	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, { 1, 2, 3, 4, 5, }	// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ żů,Č*,Ľö,¸ń,±ÝżäŔĎżˇ!
	Once		00:00:00, 23:59:59	// AM 00:00:00 ~ PM 11:59:59şĐ ±îÁö¸¸!
}

Schedule SiegeProgressing
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		20:00:00, 21:30:00	// PM 21:00:00 ~ PM 23:00:00 ±îÁö ÁřÇŕ
}

Schedule FortressStatusUpdate
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1			// ¸ĹŔĎ 1ąř
	Once		23:05:00, 23:06:00	// żä»őŔü ÇĎ´Â łŻµµ żä»őŔü Áľ·á ČÄ 10şĐ µÚ°ˇ µÇµµ·Ď ÇŃ´Ů.
}

Schedule AllowSiegeTaxJob
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ŔĎżäŔĎ
	Once		00:00:00, 23:59:59	// ÇĎ·ç ÁľŔĎ
}

Schedule AlertSiegeStartAfter30Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		19:30:00, 19:31:00	// PM 19:30:00 ~ PM 19:31:00 
}

Schedule AlertSiegeFinishAfter30Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:00:00, 21:01:00	// żŔČÄ 2˝Ă 30şĐżˇ!
}

Schedule AlertSiegeFinishAfter20Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:10:00, 21:11:00	// PM 21:40:00
}

Schedule AlertSiegeFinishAfter10Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:20:00,21:21:00	// PM 21:50:00
}

Schedule AlertSiegeFinishAfter1Min
{
	DurationBegin	2006-12-13, 00:00:00 	// ˝ĂŔŰŔĎŔĚ ¸í˝ĂŔűŔ¸·Î ĆĐġŔĎŔĚľîľß ÇŃ´Ů!!!!! Ŕý´ë ÁÖŔÇ żä¸Á!!!
 	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, {3, }		// 2ÁÖ °Ł°ÝŔ¸·Î ¸ĹÁÖ ĹäżäŔĎ
	Once		21:29:00, 21:29:10	// PM 21:59:00
}


////////////////////////////////////////////////////////////
// FlagWorld Schedule
Schedule FlagWorldParticipation1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		00:50:00, 01:01:00
}

Schedule FlagWorldNotice1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		00:55:00, 00:59:00
}

Schedule FlagWorldPlaying1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		01:00:00, 01:21:00
}

Schedule FlagWorldParticipation2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		02:50:00, 03:01:00
}

Schedule FlagWorldNotice2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		02:55:00, 02:59:00
}

Schedule FlagWorldPlaying2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		03:00:00, 03:21:00
}

Schedule FlagWorldParticipation3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		04:50:00, 05:01:00
}

Schedule FlagWorldNotice3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		04:55:00, 04:59:00
}

Schedule FlagWorldPlaying3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		05:00:00, 05:21:00
}

Schedule FlagWorldParticipation4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		06:50:00, 07:01:00
}

Schedule FlagWorldNotice4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		06:55:00, 06:59:00
}

Schedule FlagWorldPlaying4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		07:00:00, 07:21:00
}

Schedule FlagWorldParticipation5
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		08:50:00, 09:01:00
}

Schedule FlagWorldNotice5
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		08:55:00, 08:59:00
}

Schedule FlagWorldPlaying5
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		09:00:00, 09:21:00
}

Schedule FlagWorldParticipation6
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		10:50:00, 11:01:00
}

Schedule FlagWorldNotice6
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		10:55:00, 10:59:00
}

Schedule FlagWorldPlaying6
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		11:00:00, 11:21:00
}

Schedule FlagWorldParticipation7
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		12:50:00, 13:01:00
}

Schedule FlagWorldNotice7
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		12:55:00, 12:59:00
}

Schedule FlagWorldPlaying7
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		13:00:00, 13:21:00
}

Schedule FlagWorldParticipation8
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		14:50:00, 15:01:00
}

Schedule FlagWorldNotice8
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		14:55:00, 14:59:00
}

Schedule FlagWorldPlaying8
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		15:00:00, 15:21:00
}

Schedule FlagWorldParticipation9
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:50:00, 17:01:00
}

Schedule FlagWorldNotice9
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:55:00, 16:59:00
}

Schedule FlagWorldPlaying9
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		17:00:00, 17:21:00
}

Schedule FlagWorldParticipation10
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		18:50:00, 19:01:00
}

Schedule FlagWorldNotice10
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		18:55:00, 18:59:00
}

Schedule FlagWorldPlaying10
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		19:00:00, 19:21:00
}

Schedule FlagWorldParticipation11
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		20:50:00, 21:01:00
}

Schedule FlagWorldNotice11
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		20:55:00, 20:59:00
}

Schedule FlagWorldPlaying11
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		21:00:00, 21:21:00
}

Schedule FlagWorldParticipation12
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:50:00, 23:01:00
}

Schedule FlagWorldNotice12
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:55:00, 22:59:00
}

Schedule FlagWorldPlaying12
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		23:00:00, 23:21:00
}
Schedule ChinsTombGateOpen1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		04:00:00, 04:10:00
}

Schedule ChinsTombGateOpen2
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		10:00:00, 10:10:00
}

Schedule ChinsTombGateOpen3
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		16:00:00, 16:10:00
}

Schedule ChinsTombGateOpen4
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Daily		1,1
	Once		22:00:00, 22:10:00
}
Schedule RocTopGateOpen1
{
	DurationBegin	2006-01-01, 00:00:00
	DurationEnd	2030-12-31, 00:00:00
	Weekly		1, { 0, 1, 2, 3, 4, 5, }		// ¸ĹÁÖ ŔĎ, Č*, ±Ý
	Once		10:00:00, 14:59:00	// żŔČÄ 7 ˝Ă ~ 11˝Ă 59 şĐ ±îÁö
}

and you must run all .exe in the order:

01.Certification
02.GatewayServer
03.MachineManger
04.DownloadServer
05.FarmManger
06.SR_ShardManger
07.AgentServer
08.SR_GameServer
09.SMC

can you write what is the diffrent in this 2 files cuz i no see any diffrent

[LastThief]

Originally Posted by eLO21

better way is add in SQL Server Agent "job" which will reset "AccPlayTime"

UPDATE TB_USER
SET AccPlayTime=('0')
WHERE AccPlayTime>10800

...now you don't must relogg and edit GlobalManger.exe, you need just use any teleport to reset green book

@Edit:
When i find some time, i make guide with images... ^^

small application in vb.net will do the job i will make it in friday

[lesderid]

Originally Posted by LastThief

small application in vb.net will do the job i will make it in friday

You don't need an app for this, a stored procedure would suffice.

[LastThief]

Originally Posted by lesderid

You don't need an app for this, a stored procedure would suffice.

well some ppl don't know **** about sql so app will fix their problems

[ahmed4ever2u]

Originally Posted by LastThief

well some ppl don't know **** about sql so app will fix their problems

and you care about pple problems ?!

[LastThief]

Originally Posted by ahmed4ever2u

and you care about pple problems ?!

why shouldn't i ?

[NightCore#]

Could somebody tell me how to add a Stored Procedure ? :S